{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Culvert", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 103470, "latestWkid": 103470, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17646100, "falseY": -48340000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 51, 51, 255 ], "width": 7 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 701328.9182577468, "ymin": 427951.767050989, "xmax": 821968.2357056625, "ymax": 555795.4214681536, "spatialReference": { "wkid": 103470, "latestWkid": 103470, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17646100, "falseY": -48340000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CULV_NB_DRVD", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CULV_NB_DRVD", "type": "esriFieldTypeString", "alias": "Culvert Number", "length": 254, "domain": null }, { "name": "CULV_INAC_FL", "type": "esriFieldTypeString", "alias": "Pipe Status", "length": 1, "domain": null }, { "name": "CULV_INAC_RSN", "type": "esriFieldTypeString", "alias": "Inactive Reason", "length": 254, "domain": null }, { "name": "RD_TY", "type": "esriFieldTypeString", "alias": "Road Type", "length": 254, "domain": null }, { "name": "RD_NM", "type": "esriFieldTypeString", "alias": "Road Name", "length": 254, "domain": { "type": "codedValue", "name": "CLV_RD_NAME", "description": "CLV_RD_NAME", "codedValues": [ { "name": "COUNTY RD A", "code": "COUNTY RD A" }, { "name": "COUNTY RD AH", "code": "COUNTY RD AH" }, { "name": "COUNTY RD B", "code": "COUNTY RD B" }, { "name": "COUNTY RD BB", "code": "COUNTY RD BB" }, { "name": "COUNTY RD C", "code": "COUNTY RD C" }, { "name": "COUNTY RD CB", "code": "COUNTY RD CB" }, { "name": "COUNTY RD D", "code": "COUNTY RD D" }, { "name": "COUNTY RD E", "code": "COUNTY RD E" }, { "name": "COUNTY RD F", "code": "COUNTY RD F" }, { "name": "COUNTY RD FF", "code": "COUNTY RD FF" }, { "name": "COUNTY RD G", "code": "COUNTY RD G" }, { "name": "COUNTY RD GG", "code": "COUNTY RD GG" }, { "name": "COUNTY RD H", "code": "COUNTY RD H" }, { "name": "COUNTY RD HH", "code": "COUNTY RD HH" }, { "name": "COUNTY RD I", "code": "COUNTY RD I" }, { "name": "COUNTY RD II", "code": "COUNTY RD II" }, { "name": "COUNTY RD JJ", "code": "COUNTY RD JJ" }, { "name": "COUNTY RD K", "code": "COUNTY RD K" }, { "name": "COUNTY RD M", "code": "COUNTY RD M" }, { "name": "COUNTY RD MM", "code": "COUNTY RD MM" }, { "name": "COUNTY RD N", "code": "COUNTY RD N" }, { "name": "COUNTY RD O", "code": "COUNTY RD O" }, { "name": "COUNTY RD PP", "code": "COUNTY RD PP" }, { "name": "COUNTY RD R", "code": "COUNTY RD R" }, { "name": "COUNTY RD RP", "code": "COUNTY RD RP" }, { "name": "COUNTY RD S", "code": "COUNTY RD S" }, { "name": "COUNTY RD T", "code": "COUNTY RD T" }, { "name": "COUNTY RD V", "code": "COUNTY RD V" }, { "name": "COUNTY RD W", "code": "COUNTY RD W" }, { "name": "COUNTY RD X", "code": "COUNTY RD X" }, { "name": "COUNTY RD XX", "code": "COUNTY RD XX" }, { "name": "COUNTY RD Y", "code": "COUNTY RD Y" }, { "name": "COUNTY RD Z", "code": "COUNTY RD Z" }, { "name": "INTERSTATE 41", "code": "INTERSTATE 41" }, { "name": "STATE RD 110", "code": "STATE RD 110" }, { "name": "STATE RD 116", "code": "STATE RD 116" }, { "name": "STATE RD 21", "code": "STATE RD 21" }, { "name": "STATE RD 26", "code": "STATE RD 26" }, { "name": "STATE RD 44", "code": "STATE RD 44" }, { "name": "STATE RD 441", "code": "STATE RD 441" }, { "name": "STATE RD 49", "code": "STATE RD 49" }, { "name": "STATE RD 76", "code": "STATE RD 76" }, { "name": "STATE RD 91", "code": "STATE RD 91" }, { "name": "STATE RD 96", "code": "STATE RD 96" }, { "name": "US HWY 10", "code": "US HWY 10" }, { "name": "US HWY 45", "code": "US HWY 45" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULV_OWN", "type": "esriFieldTypeString", "alias": "Owner Name", "length": 254, "domain": { "type": "codedValue", "name": "CLV_OWNER", "description": "Culvert Owner", "codedValues": [ { "name": "State of Wisconsin", "code": "State of Wisconsin\nState of Wisconsin" }, { "name": "Winnebago County", "code": "Winnebago County" }, { "name": "City of Appleton", "code": "City of Appleton" }, { "name": "City of Menasha", "code": "City of Menasha\nCity of Menasha" }, { "name": "City of Neenah", "code": "City of Neenah" }, { "name": "City of Omro", "code": "City of Omro" }, { "name": "City of Oshkosh", "code": "City of Oshkosh" }, { "name": "Village of Fox Crossing", "code": "Village of Fox Crossing" }, { "name": "Village of Winneconne", "code": "Village of Winneconne" }, { "name": "Town of Algoma", "code": "Town of Algoma" }, { "name": "Town of Black Wolf", "code": "Town of Black Wolf" }, { "name": "Town of Clayton", "code": "Town of Clayton" }, { "name": "Town of Menasha", "code": "Town of Menasha" }, { "name": "Town of Neenah", "code": "Town of Neenah" }, { "name": "Town of Nekimi", "code": "Town of Nekimi" }, { "name": "Town of Nepeuskun", "code": "Town of Nepeuskun" }, { "name": "Town of Omro", "code": "Town of Omro" }, { "name": "Town of Oshkosh", "code": "Town of Oshkosh" }, { "name": "Town of Poygan", "code": "Town of Poygan" }, { "name": "Town of Rushford", "code": "Town of Rushford" }, { "name": "Town of Utica", "code": "Town of Utica" }, { "name": "Town of Vinland", "code": "Town of Vinland" }, { "name": "Town of Winchester", "code": "Town of Winchester" }, { "name": "Town of Winneconne", "code": "Town of Winneconne" }, { "name": "Town of Wolf River", "code": "Town of Wolf River" }, { "name": "Private", "code": "Private" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PREV_ROAD", "type": "esriFieldTypeString", "alias": "Previous Road", "length": 254, "domain": null }, { "name": "LAT_Y", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "LNGT_X", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "PIPE_FUNC", "type": "esriFieldTypeString", "alias": "Pipe Function", "length": 254, "domain": null }, { "name": "FTR_OVER", "type": "esriFieldTypeString", "alias": "Feature Over", "length": 254, "domain": null }, { "name": "CL_ZONE_HZ", "type": "esriFieldTypeString", "alias": "Traversable Hazard", "length": 254, "domain": null }, { "name": "BMGRD", "type": "esriFieldTypeString", "alias": "Barrier System", "length": 254, "domain": null }, { "name": "INSL_YR", "type": "esriFieldTypeString", "alias": "Installation Year", "length": 4, "domain": null }, { "name": "PIPE_MATL", "type": "esriFieldTypeString", "alias": "Pipe Material", "length": 254, "domain": { "type": "codedValue", "name": "CLV_PIPE_MATL", "description": "Pipe Material", "codedValues": [ { "name": "Corrugated Aluminum", "code": "Corrugated Aluminum" }, { "name": "Corrugated poly-ETHY-lene", "code": "Corrugated Polyethylene" }, { "name": "Corrugated Steel", "code": "Corrugated Steel" }, { "name": "Corrugated Steel Aluminum Coated", "code": "Corrugated Steel Aluminum Coated" }, { "name": "Corrugated Steel Polymer Coated", "code": "Corrugated Steel Polymer Coated" }, { "name": "Reinforced Concrete", "code": "Reinforced Concrete" }, { "name": "Steel Casing", "code": "Steel Casing" }, { "name": "Structural Plate", "code": "Structural Plate" }, { "name": "Corrugated poly-PROPY-lene", "code": "Corrugated Polypropylene" }, { "name": "Tile", "code": "Tile" }, { "name": "Iron", "code": "Iron" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Stone", "code": "Stone" }, { "name": "HDPE Liner", "code": "HDPE Liner" }, { "name": "Aluminum Box", "code": "Aluminum Box" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_LING", "type": "esriFieldTypeString", "alias": "Pipe Lining", "length": 254, "domain": null }, { "name": "PIPE_SHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "length": 254, "domain": { "type": "codedValue", "name": "CLV_PIPE_SHAPE", "description": "Pipe Shape", "codedValues": [ { "name": "Arched pipe (width x height)", "code": "Arch" }, { "name": "Box culvert", "code": "Box" }, { "name": "Horizontal Elliptical pipe (height x width)", "code": "Horizontal Elliptical" }, { "name": "Other pipe - See Comments", "code": "Other" }, { "name": "Round pipe", "code": "Round" }, { "name": "Slotted vane drain pipe", "code": "Vane Drains" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_HT", "type": "esriFieldTypeSmallInteger", "alias": "Pipe Height", "domain": { "type": "range", "name": "CLV_PIPE_HT_RNG", "description": "Culvert Pipe Height Range", "range": [ 1, 200 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_WD", "type": "esriFieldTypeSmallInteger", "alias": "Pipe Width", "domain": { "type": "range", "name": "CLV_PIPE_WD_RNG", "description": "Culvert Pipe Width Range", "range": [ 1, 200 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_LN", "type": "esriFieldTypeSmallInteger", "alias": "Pipe Length", "domain": { "type": "range", "name": "CLV_PIPE_LN_RNG", "description": "Culvert Pipe Length Range", "range": [ 1, 2000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FILL_HT", "type": "esriFieldTypeSmallInteger", "alias": "Fill Height", "domain": null }, { "name": "TIED_JNTS", "type": "esriFieldTypeString", "alias": "Tied Joints", "length": 254, "domain": null }, { "name": "UPST_EXTN_TY", "type": "esriFieldTypeString", "alias": "Upstream Extension Type", "length": 254, "domain": null }, { "name": "DNST_EXTN_TY", "type": "esriFieldTypeString", "alias": "Downstream Extension Type", "length": 254, "domain": null }, { "name": "UPST_END_TRMT", "type": "esriFieldTypeString", "alias": "Upstream End Treatment", "length": 254, "domain": { "type": "codedValue", "name": "CLV_LT_END_TRMT", "description": "Left End Treatment", "codedValues": [ { "name": "Cast in Place Endwall", "code": "Cast in Place Endwall" }, { "name": "Field Stone Endwall", "code": "Field Stone Endwall" }, { "name": "Inlet", "code": "Inlet" }, { "name": "Masonry Endwall", "code": "Masonry Endwall" }, { "name": "No end treatment", "code": "None" }, { "name": "Other end treatment", "code": "Other" }, { "name": "Precast Endwall", "code": "Precast Endwall" }, { "name": "Steel Endwall", "code": "Steel Endwall" }, { "name": "Water Controlled Structure", "code": "Water Controlled Structure" }, { "name": "Wood Endwall", "code": "Wood Endwall" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DNST_END_TRMT", "type": "esriFieldTypeString", "alias": "Downstream End Treatment", "length": 254, "domain": { "type": "codedValue", "name": "CLV_RT_END_TRMT", "description": "Right End Treatment", "codedValues": [ { "name": "Cast in Place Endwall", "code": "Cast in Place Endwall" }, { "name": "Field Stone Endwall", "code": "Field Stone Endwall" }, { "name": "Inlet", "code": "Inlet" }, { "name": "Masonry Endwall", "code": "Masonry Endwall" }, { "name": "No end treatment", "code": "None" }, { "name": "Other end treatment", "code": "Other" }, { "name": "Precast Endwall", "code": "Precast Endwall" }, { "name": "Steel Endwall", "code": "Steel Endwall" }, { "name": "Water Controlled Structure", "code": "Water Controlled Structure" }, { "name": "Wood Endwall", "code": "Wood Endwall" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BTM_FTR", "type": "esriFieldTypeString", "alias": "Special Design Bottom Feature", "length": 254, "domain": null }, { "name": "WTLDS", "type": "esriFieldTypeString", "alias": "Wetlands", "length": 254, "domain": null }, { "name": "TROUT_STRM", "type": "esriFieldTypeString", "alias": "Trout Stream", "length": 254, "domain": null }, { "name": "NVGL_STRM", "type": "esriFieldTypeString", "alias": "Navigable Stream", "length": 254, "domain": null }, { "name": "ACDTY_SOIL", "type": "esriFieldTypeString", "alias": "Acidic Soil", "length": 254, "domain": null }, { "name": "PRJ", "type": "esriFieldTypeString", "alias": "Project", "length": 255, "domain": null }, { "name": "HST", "type": "esriFieldTypeString", "alias": "History", "length": 255, "domain": null }, { "name": "LOC_SCR", "type": "esriFieldTypeString", "alias": "Location Source", "length": 255, "domain": { "type": "codedValue", "name": "CLV_LOC_SCR", "description": "Culvert Location Source", "codedValues": [ { "name": "Aerial Photo", "code": "Aerial Photo" }, { "name": "Aerial Photo/Field Measurement", "code": "Aerial Photo/Field Measurement" }, { "name": "GPS", "code": "GPS" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CULV_SPEC_SCR", "type": "esriFieldTypeString", "alias": "Culvert Specification Source", "length": 255, "domain": { "type": "codedValue", "name": "CULV_SPEC_SCR", "description": "Culvert Specification Source", "codedValues": [ { "name": "Field Assessment", "code": "Field Assessment" }, { "name": "Design Specs", "code": "Design Specs" }, { "name": "Other", "code": "Other" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CM", "type": "esriFieldTypeString", "alias": "Inventory Comments", "length": 254, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "DOT_CULV_NB", "type": "esriFieldTypeString", "alias": "Dot Culvert Number", "length": 254, "domain": null }, { "name": "CULV_STATUS", "type": "esriFieldTypeString", "alias": "Culvert Status", "length": 50, "domain": null }, { "name": "REVIEW_NEEDED", "type": "esriFieldTypeString", "alias": "Review Needed", "length": 50, "domain": null }, { "name": "REVIEW_NOTES", "type": "esriFieldTypeString", "alias": "Review Notes", "length": 254, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1381_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1381", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1381", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1185_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LocalGovernment.GISADMIN.swCulvertMaint", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 1, "name": "LocalGovernment.GISADMIN.swCulvertInsp", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "79a51e9ed06e41eb8695f9fc7da7b7d3" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "LocalGovernment.GISADMIN.swCulvertInsp", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPD_BY", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSPD_BY", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 254, "domain": null }, { "name": "INSPD_NM", "type": "esriFieldTypeString", "alias": "Inspector Name", "length": 254, "domain": null }, { "name": "INSPD_DT", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "length": 2, "domain": null }, { "name": "INSPL", "type": "esriFieldTypeString", "alias": "Inspectable", "length": 1, "domain": null }, { "name": "ENTR_RSTC", "type": "esriFieldTypeString", "alias": "Entry Restrictions", "length": 254, "domain": null }, { "name": "MRKR_POST_RTG", "type": "esriFieldTypeString", "alias": "Marker Posts", "length": 254, "domain": null }, { "name": "RDWY_RTG", "type": "esriFieldTypeString", "alias": "Roadway Rating", "length": 254, "domain": null }, { "name": "EMBKT_RTG", "type": "esriFieldTypeString", "alias": "Embankment Rating", "length": 254, "domain": null }, { "name": "SCUR_RTG", "type": "esriFieldTypeString", "alias": "Scour Rating", "length": 254, "domain": null }, { "name": "VALN_RTG", "type": "esriFieldTypeString", "alias": "Vertical Alignment", "length": 254, "domain": null }, { "name": "DRNG_ALNM_RTG", "type": "esriFieldTypeString", "alias": "Drainage Alignment Rating", "length": 254, "domain": null }, { "name": "WATR_LVL_RTG", "type": "esriFieldTypeString", "alias": "Water Level", "length": 254, "domain": null }, { "name": "LEFT_END_TRMT_RTG", "type": "esriFieldTypeString", "alias": "Left End Treatment Rating", "length": 254, "domain": null }, { "name": "RGHT_END_TRMT_RTG", "type": "esriFieldTypeString", "alias": "Right End Treatment Rating", "length": 254, "domain": null }, { "name": "PIPE_FLOW_RTG", "type": "esriFieldTypeString", "alias": "Pipe Flow Rating", "length": 254, "domain": null }, { "name": "CRRSN_RTG", "type": "esriFieldTypeString", "alias": "Corrosion Rating", "length": 254, "domain": null }, { "name": "CRKG_RTG", "type": "esriFieldTypeString", "alias": "Cracking Rating", "length": 254, "domain": null }, { "name": "PIPE_CNNC_RTG", "type": "esriFieldTypeString", "alias": "Pipe Connection Rating", "length": 254, "domain": null }, { "name": "DSTN_RTG", "type": "esriFieldTypeString", "alias": "Distortion Rating", "length": 254, "domain": null }, { "name": "PIPE_ALNM_RTG", "type": "esriFieldTypeString", "alias": "Pipe Alignment Rating", "length": 254, "domain": null }, { "name": "JNT_SPRTN_RTG", "type": "esriFieldTypeString", "alias": "Joint Separation Rating", "length": 254, "domain": null }, { "name": "DLMN_SPLNG_RTG", "type": "esriFieldTypeString", "alias": "Delaminating and Spalling Rating", "length": 254, "domain": null }, { "name": "EXPSD_RFCMT_RTG", "type": "esriFieldTypeString", "alias": "Exposed Reinforcement Rating", "length": 254, "domain": null }, { "name": "ABR_WEAR_RTG", "type": "esriFieldTypeString", "alias": "Abrasion and Wear Rating", "length": 254, "domain": null }, { "name": "SALT_RUST_SAN_RTG", "type": "esriFieldTypeString", "alias": "Salt and Rust Stain Rating", "length": 254, "domain": null }, { "name": "CRTC_FDNG_FL", "type": "esriFieldTypeString", "alias": "Critical Finding", "length": 1, "domain": null }, { "name": "CM", "type": "esriFieldTypeString", "alias": "Inspection Comments", "length": 254, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "INSP_BY", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1382_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_93110_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1382", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1382", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "LocalGovernment.GISADMIN.swCulvert", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "79a51e9ed06e41eb8695f9fc7da7b7d3" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "LocalGovernment.GISADMIN.swCulvertMaint", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MNTC_ACTN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MNTC_ACTN", "type": "esriFieldTypeString", "alias": "Maintenance Action", "length": 254, "domain": null }, { "name": "ASGT_DT", "type": "esriFieldTypeDate", "alias": "Date of Assignment", "length": 8, "domain": null }, { "name": "ASGD_TO", "type": "esriFieldTypeString", "alias": "Assigned To", "length": 254, "domain": null }, { "name": "DT_TB_CMPL", "type": "esriFieldTypeDate", "alias": "Date to be Completed", "length": 8, "domain": null }, { "name": "DT_CMPL", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CM", "type": "esriFieldTypeString", "alias": "Maintenance Comments", "length": 254, "domain": null }, { "name": "FNDG_TY", "type": "esriFieldTypeString", "alias": "Funding Type", "length": 254, "domain": null }, { "name": "PROJECT_ID", "type": "esriFieldTypeString", "alias": "Project ID", "length": 8, "domain": null }, { "name": "EST_COST", "type": "esriFieldTypeDouble", "alias": "Estimated Cost (Budget)", "domain": null }, { "name": "FINAL_COST", "type": "esriFieldTypeDouble", "alias": "Final Cost", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_DATE", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "CMPLT_BY", "type": "esriFieldTypeString", "alias": "Completed By", "length": 255, "domain": null }, { "name": "WORK_ORDER", "type": "esriFieldTypeString", "alias": "Work Order Number", "length": 30, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1384_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_93112_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1384", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1384", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LocalGovernment.GISADMIN.swCulvert", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "79a51e9ed06e41eb8695f9fc7da7b7d3" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "LocalGovernment.GISADMIN.swCulvertInsp__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R1386_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1386", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_93778_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1386", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "79a51e9ed06e41eb8695f9fc7da7b7d3" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "LocalGovernment.GISADMIN.swCulvertMaint__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R1387_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1387", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_93780_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1387", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "79a51e9ed06e41eb8695f9fc7da7b7d3" } ] }