{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "name": "Inlets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "dbebcda6c95f8a6b86f70ee43787aa8b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABKElEQVQ4jbXUPWqEQBQH8CdMI7EQFqwUi5RKIIiFlaTzBqlELxE9g+QS1jmBpXZBgwh2QhDtVgTTiASUDRYLu/ixOmz+lczj/eaNIyK4c9C/gbIscwDwioMQBOGHYfh1BZ5Op0cAeMcc7A0ArsFzKIo6qqp63KL4vj+0bft8uTYBOY77NQzjyfO8VUySJCjL8iNN03VwTFEUEAQBaJo2i8VxvP+WeZ4H0zQXG7uu2wfmeQ6u68LSCRiG2QeSJAksy87WqqpaagOsCWmaBkEQ9oGKooDjOLO1caPd7xA3aKmQpinYtr14KaqqbgdFUQTLslYnGT+rKIpug1mWPei6/gkb0jSNfBMchuFQ1/UBMIPOD33fJwihF0znewImSfIz/kBwJ5uA98ofR8NkMJdKObYAAAAASUVORK5CYII=", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1962729.1202333868, "ymin": 778266.1159036458, "xmax": 1981020.0475622267, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Inlet ID", "length": 20, "domain": null }, { "name": "InletLabel", "type": "esriFieldTypeInteger", "alias": "Inlet Label", "domain": null }, { "name": "INLETTYPE", "type": "esriFieldTypeString", "alias": "Inlet Type", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.InletType", "description": "", "codedValues": [ { "name": "Catch Basin", "code": "Catchbasin" }, { "name": "Combination Inlet", "code": "Combination Inlet" }, { "name": "Curb Inlet", "code": "Curb Inlet" }, { "name": "Grate Inlet", "code": "Grate Inlet" }, { "name": "Inlet", "code": "Inlet" }, { "name": "Open Throat Catch Basin", "code": "Open Throat Catch Basin" }, { "name": "Riser", "code": "Riser" }, { "name": "Yard Inlet", "code": "Yard Inlet" }, { "name": "Drop Inlet", "code": "Drop Inlet" }, { "name": "Grated Drop Inlet", "code": "Grated Drop Inlet" }, { "name": "Traffic-Bearing Grated Drop Inlet", "code": "Traffic-Bearing Grated Drop Inlet" }, { "name": "Curb Diversion Device", "code": "Curb Diversion Device" }, { "name": "Flow Splitter", "code": "Flow Splitter" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "2GI", "code": "2GI" }, { "name": "Pipe", "code": "Pipe" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "InletStructure", "type": "esriFieldTypeString", "alias": "Inlet Structure", "length": 30, "domain": { "type": "codedValue", "name": "PW.Stormwater.InletStructure", "description": "", "codedValues": [ { "name": "Headwall", "code": "Headwall" }, { "name": "Wingwall", "code": "Wingwall" }, { "name": "Bare End", "code": "Bare End" }, { "name": "Flared End Section", "code": "Flared End Section" }, { "name": "Catch Basin Hood and Grate", "code": "CB Hood and Grate" }, { "name": "Drop Inlet Grate", "code": "Drop Inlet Grate" }, { "name": "Wide Slot Flat Grate", "code": "Wide Slot Flat Grate" }, { "name": "Wide Slot Sag Grate", "code": "Wide Slot Sag Grate" }, { "name": "Narrow Slot Flat Grate", "code": "Narrow Slot Flat Grate" }, { "name": "Narrow Slot Sag Grate", "code": "Narrow Slot Sag Grate" }, { "name": "Angled Vane Grate", "code": "Angled Vane Grate" }, { "name": "Steel Grate and Frame", "code": "Steel Grate and Frame" }, { "name": "Manhole Frame and Cover", "code": "Manhole Frame and Cover" }, { "name": "Cast Iron Grate", "code": "Cast Iron Grate" }, { "name": "Endwall", "code": "Endwall" }, { "name": "Riser", "code": "Riser" }, { "name": "Standpipe", "code": "Standpipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InletStandard", "type": "esriFieldTypeString", "alias": "Inlet Standard", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.Standards", "description": "", "codedValues": [ { "name": "JB - NCDOT 840.31 and 840.32", "code": "JB" }, { "name": "Traffic bearing JB - NCDOT 840.34", "code": "JB Traffic" }, { "name": "Manhole - Carrboro Standard 11", "code": "Manhole Carrboro" }, { "name": "Manhole frame and cover - NCDOT 840.54", "code": "Manhole Frame" }, { "name": "CB - NCDOT 840.01 and 840.02", "code": "CB NCDOT" }, { "name": "CB - Carrboro Standard 10", "code": "CB Carrboro" }, { "name": "CB grate - NCDOT 840.03", "code": "CB Grate" }, { "name": "OTCB - NCDOT 840.04 and 840.05", "code": "OTCB" }, { "name": "DI - NCDOT 840.14 and 840.15", "code": "DI NCDOT" }, { "name": "DI Type A - NCDOT 840.17 and 840.26", "code": "DI Type A" }, { "name": "DI Type B - NCDOT 840.18 and 840.27", "code": "DI Type B" }, { "name": "DI Type D - NCDOT 840.19 and 840.28", "code": "DI Type D" }, { "name": "Traffic bearing DI cast iron grate - NCDOT 840.35", "code": "DI Traffic Iron" }, { "name": "Traffic bearing DI steel grate - NCDOT 840.37", "code": "DI Traffic Steel" }, { "name": "YI - Carrboro Standard 12", "code": "YI Carrboro" }, { "name": "DI grate - NCDOT 840.16", "code": "DI Grate" }, { "name": "Wide slot flat grate - NCDOT 840.20", "code": "Wide Flat Grate" }, { "name": "Wide slot sag grate - NCDOT 840.22", "code": "Wide Sag Grate" }, { "name": "Narrow slot sag grate - NCDOT 840.24", "code": "Narrow Sag Grate" }, { "name": "Narrow slot flat grate - NCDOT 840.29", "code": "Narrow Flat Grate" }, { "name": "Angled vane grate - NCDOT 840.33", "code": "Angled Grate" }, { "name": "Steel grate and frame - NCDOT 840.37", "code": "Steel Grate" }, { "name": "NCDOT Standard", "code": "NCDOT" }, { "name": "Carrboro Standard", "code": "Carrboro" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null }, { "name": "INVINELEV2", "type": "esriFieldTypeDouble", "alias": "Invert In 2", "domain": null }, { "name": "INVINELEV3", "type": "esriFieldTypeDouble", "alias": "Invert In 3", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null }, { "name": "Rim", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R336_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4536FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S191_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PW_Stormwater_Inlet", "relatedTableId": 110, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{12B6E139-76B0-461D-9656-2DEB95B98238}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 20, "name": "Outlets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "197b7d9a36f025f8eb7b56b38d813444", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACkUlEQVQ4jbWUzUsbURTFzyQzyQRrm5SQGj/aRUDjpipIV1lMQGmpcaEQQhdVcFFxJyIWFJHWdSD4B0gIqZBF2i6kVAkSbUEXLpJN0EgDjUGqRe0oTmYkzpQZk6DJExe1ZzP3zLvv93j3Xh6NOxb9P4FNAHwV6zoAjwFYAOgBHALIArioyIsD2KwEOmw22zufzyeqRpIkKhKJ3Od5XgWVxbKs4vV6ebPZLKt+aWmJSqfTIAHhcDgu5ubmHpb84OAg3G43zs/PyzmhUIjyer3mkh8aGjooAquufE17e3uYnp5CW5sTnZ1O0LQeqdQuZmffw263w+Vy3VpDiKJIqd9UKgWP5yUmJvrAcU+vbdja+oWBgdeIRj+io6MD+/v7zI3ATCbDjo+PY3n5K0ZGXlTBVDmddfD7hzE8/AZ9ff2IxWIPis2rAtInJye03++H3W6Dx/PspmqgtfURTCYGk5OTKMKekIB1iqJoQXNzIyhKu/2NamlpwtraesnaSMBCKRBFCbdJELTpKumCBDzQ6/UKwzBUOp3D2ZmImhoWJMmygvX1JGpra3F6eqrtJQFli8VSCAaDzMbGdwQCnzA19YoIXFj4hvr6RkSjn8FxXIHn+V0SUB1ssaenh+nu7gbHuTAzE8LoaD8slnvauiBImJ+PYXMzi8XFL7Barejt7T0Oh8MKEajTXXbfYDBgZWUNgYAfXV1v0dBg0wY7k8lhbGwMq6sfYDQatVyGYcqwKuBVsSwLg8EEQchjZ+dn+f/R0XEZRhJ91SQSCWN7ezuvxoVCgcrlciadTkfLslyeoWAwKMfjcYFlWa2z2Wz2sh4EYCKfzz9PJpOkQxsAmAD8liTpcHt7uzLnBwn4p/iu/ZPu/MX+C4j23oWil4ElAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1961990.14238064, "ymin": 771963.4293620586, "xmax": 1980980.757286474, "ymax": 807006.2296831459, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Outlet ID", "length": 20, "domain": null }, { "name": "DISCHID", "type": "esriFieldTypeString", "alias": "PW Outlet Identifier", "length": 20, "domain": null }, { "name": "DISCHRGTYP", "type": "esriFieldTypeString", "alias": "Outlet Type", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.OutfallType", "description": "", "codedValues": [ { "name": "Stormwater Outfall", "code": "Stormwater Outfall" }, { "name": "Discharge to Stream", "code": "Discharge to Stream" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OutfallStructure", "type": "esriFieldTypeString", "alias": "Outlet Structure", "length": 25, "domain": { "type": "codedValue", "name": "PW.Stormwater.OutfallStructure", "description": "", "codedValues": [ { "name": "Endwall", "code": "Endwall" }, { "name": "Wingwall", "code": "Wingwall" }, { "name": "Headwall", "code": "Headwall" }, { "name": "Preformed Scour Hole", "code": "Preformed Scour Hole" }, { "name": "Level Spreader", "code": "Level Spreader" }, { "name": "Energy Dissipator", "code": "Energy Dissipator" }, { "name": "Bare End", "code": "Bare End" }, { "name": "Flared End", "code": "Flared End" }, { "name": "Overflow", "code": "Overflow" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Riprap", "code": "Riprap" }, { "name": "SCM Forebay", "code": "SCM Forebay" }, { "name": "Spillway", "code": "Spillway" }, { "name": "Standpipe", "code": "Standpipe" }, { "name": "Riser", "code": "Riser" }, { "name": "Outlet", "code": "Standard Outlet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SCMType", "type": "esriFieldTypeString", "alias": "SCM If Applicable", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.SCMType", "description": "", "codedValues": [ { "name": "Armor Fill Slope", "code": "Armor fill slope" }, { "name": "Bioretention Area", "code": "Bioretention area" }, { "name": "Drained Farm Pond", "code": "Drained farm pond" }, { "name": "Farm Pond", "code": "Farm pond" }, { "name": "Rainwater Harvesting", "code": "Rainwater harvesting" }, { "name": "Stream Restoration", "code": "Stream restoration" }, { "name": "Underground Detention", "code": "Underground detention" }, { "name": "Wet Detention", "code": "Wet detention" }, { "name": "Bay Filter", "code": "Bay filter" }, { "name": "Filterra", "code": "Filterra" }, { "name": "Green Roof", "code": "Green roof" }, { "name": "Permeable Pavement", "code": "Permeable pavement" }, { "name": "Regenerative Stormwater Conveyance", "code": "Regenerative stormwater conveyance" }, { "name": "Sand Filter", "code": "Sand filter" }, { "name": "Storm Filter", "code": "Storm filter" }, { "name": "Dry Pond", "code": "Dry Pond" }, { "name": "Wet Pond", "code": "Wet Pond" }, { "name": "Stormwater Wetland", "code": "Stormwater Wetland" }, { "name": "Infiltration System", "code": "Infiltration System" }, { "name": "Disconnected Impervious Surface", "code": "Disconnected Impervious Surface" }, { "name": "Treatment Swale", "code": "Treatment Swale" }, { "name": "Silva Cell", "code": "Silva Cell" }, { "name": "Stormceptor", "code": "Stormceptor" }, { "name": "Level Spreader-Filter Strip", "code": "Level Spreader-Filter Strip" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StreamOrigin", "type": "esriFieldTypeString", "alias": "Stream Origin?", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location", "length": 200, "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeDiameter", "description": "", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1-1/4\"", "code": 1.25 }, { "name": "1-1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Illicit Discharge Priority", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.IllicitDischargePriority", "description": "", "codedValues": [ { "name": "Priority Outfall", "code": "Priority" }, { "name": "Major Outfall", "code": "Major" }, { "name": "Major Combined Outfall", "code": "Major Combined" }, { "name": "No Priority", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EnergyDissipator", "type": "esriFieldTypeString", "alias": "EnergyDissipator", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.EnergyDissipator", "description": "", "codedValues": [ { "name": "Class A Rip Rap", "code": "RipRapA" }, { "name": "Class B Rip Rap", "code": "RipRapB" }, { "name": "Class I Rip Rap", "code": "RipRapI" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R334_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4534FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S189_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PW_Stormwater_Outlet", "relatedTableId": 120, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{801FD4BB-246F-4FA6-A9B9-F47465EE2FC0}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 30, "name": "Junctions/Manholes", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "e75e1fab052753e666eceaa7ca448d07", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEzUlEQVRIie2WfUxTVxjGn3Nb+0FbvgqhIDqME6V3oh1fmdMJRdRhcJoBjqHZxpa5GWa3afzDYMziZJqZwIxsiSyLARwubMShwyibomMgMFagVo0KiAKtgiKUFrjtvXdpp5UaOxlblv2xJzk5uc897/nlvCfvmyPEvyjh/7CEhARfh8OxhBASLhTy/ixL3QbQabPZGoxGI/OPpDE+Pj5WSNh8B8dqCSECp+dwEAC867+fXGxfkzK/xjTss7GxsbFnSrDExEShxWLZx3Hc5mB/hn95YT/13KwhtPbIsbfmKRx7px2mIRHOXfOfVmUITiW8vTs7VZ13uPriJ38JRtO0yGodOS6gkJy7tIe8GnuLCKg/TnKhT+aaZSIWmhkjrvHW8yYUnplBHW0Lyl+/Sq0u++HihknDpFLplwCfDIAK9WPwAORNMhGLML9xEAJcvuWz/vXVUVcOVV3a9URYXFxcJs/zG7Ytu4GRcSHyjs2CkOKQOOeeV1hJowpf/Dwd25dfh75HgZpLAR+lajUl1af13V5hGRkZgq6urny1ymZN1/S78jXuINheNRufrr0GLmARTpnkALpQYtIhc2EvTv14FgfOhWPbsm6sWTAA7dxBnL3qTwJ9xksBvOAV1tHRsYiiqNkbF/e6vY2L+8CwFD74LhLh4RJkZWUgPVsJg8GAdXv0sFjCsTX5JtI1/a71vhIWL0UPoLIteJHz7ieWhQeMoqiV0wQ8Ex8xLJroB4XORnT00ygqKoJYLHZ5Wq0WKSkpyM3NxbIVq4CBr9zrl865h69/DRHQM7HCaMQxb3c2SylnRkYZKnCiWdEkQf7erW7QA6nVaqSlpaHSMIxXAlwl6FKo77hr9hezMYB3WJB5SByo3a/xMClqEJGRkXicoqKisGPHDhyEZ4xTPEHYxO9HYUNKmd2iS+pRTDT3naVhNpsRFuYR65LJZIJ2SSwS/Srcnp0l2HUiAhxHbnuF8Tzfa2Mo8qL6jseG7cNSFBcXY+fOnR7+3bt3UV5ejs90akTZHsZcvS11zYOjAoNXGCHkzKhdoLva74M5wTa3H8hewMHjdzA2NoacnBwolUq0t7ejoKAA1hEL7J1lgOrhPr90+jsbAd87JDvxZyerIYQMHTof6tid1qF0emXNKhTXh0KX1AOr9Aq2fKiDydyPBc/Mg25tMM7XGfDekZk4kDmG+WFWVworW4MQomAMVT+1DHuFtbS02GJiYvbUXA74OCtGhrZeOfbXOuvoBjKfdaa/EiFMEHabI1CgLYdCwiJpOeDgIrC5IhJF666gvtMPZosYYgH/9hPblUKhKLRarenvfjOPHrMTyRY36PFy9sO8ldfBcgSbjkRi1E4hWGYvq65ta3wirLa2dkyj0azmeUGDVMSFqFU2z+J6jCgCqFVWVBuVCPBxNNkQ8Maku75er++Li4tLGGWo7988PDd2edQgkxVzS0KHWj3WOdtYfacvSptUaO+Vw1fi+Lbvjj3baKx1TBrmVHNzs5mm6SVSqXRTzeXAvFOXAiU+Is4uE7EUAMFrpWrWPCyi7CwhkmlcN8/z75+uaz065WfB/SZaSNP052KxOMnGUFrrOJlOCHxvDooHeJ7vIgQn6xp+a3a/E6YKewR68v6YsoR/J/g/Dfsdy3ziVC2sHvUAAAAASUVORK5CYII=", "contentType": "image/png", "width": 20, "height": 20, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[FacilityID]", "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 1800, "name": "Default", "priority": 8, "symbol": { "type": "esriTS", "color": [ 52, 52, 52, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 235, 175, 255 ], "haloSize": 1.75, "font": { "family": "Calibri", "size": 9, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 1962938.8553782254, "ymin": 779028.3479749709, "xmax": 1980435.4768809676, "ymax": 802797.7171028107, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Junction ID", "length": 20, "domain": null }, { "name": "PWLabel", "type": "esriFieldTypeInteger", "alias": "PW Label", "domain": null }, { "name": "JunctionType", "type": "esriFieldTypeString", "alias": "Junction Type", "length": 25, "domain": { "type": "codedValue", "name": "PW.Stormwater.JunctionType", "description": "", "codedValues": [ { "name": "Junction", "code": "Junction" }, { "name": "Junction Box with Manhole", "code": "Junction Box w/ Manhole" }, { "name": "Virtual Junction", "code": "Virtual Junction" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Junction Chamber", "code": "Chamber" }, { "name": "Blind Junction Box", "code": "Blind Junction Box" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Standard", "type": "esriFieldTypeString", "alias": "Standard", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.Standards", "description": "", "codedValues": [ { "name": "JB - NCDOT 840.31 and 840.32", "code": "JB" }, { "name": "Traffic bearing JB - NCDOT 840.34", "code": "JB Traffic" }, { "name": "Manhole - Carrboro Standard 11", "code": "Manhole Carrboro" }, { "name": "Manhole frame and cover - NCDOT 840.54", "code": "Manhole Frame" }, { "name": "CB - NCDOT 840.01 and 840.02", "code": "CB NCDOT" }, { "name": "CB - Carrboro Standard 10", "code": "CB Carrboro" }, { "name": "CB grate - NCDOT 840.03", "code": "CB Grate" }, { "name": "OTCB - NCDOT 840.04 and 840.05", "code": "OTCB" }, { "name": "DI - NCDOT 840.14 and 840.15", "code": "DI NCDOT" }, { "name": "DI Type A - NCDOT 840.17 and 840.26", "code": "DI Type A" }, { "name": "DI Type B - NCDOT 840.18 and 840.27", "code": "DI Type B" }, { "name": "DI Type D - NCDOT 840.19 and 840.28", "code": "DI Type D" }, { "name": "Traffic bearing DI cast iron grate - NCDOT 840.35", "code": "DI Traffic Iron" }, { "name": "Traffic bearing DI steel grate - NCDOT 840.37", "code": "DI Traffic Steel" }, { "name": "YI - Carrboro Standard 12", "code": "YI Carrboro" }, { "name": "DI grate - NCDOT 840.16", "code": "DI Grate" }, { "name": "Wide slot flat grate - NCDOT 840.20", "code": "Wide Flat Grate" }, { "name": "Wide slot sag grate - NCDOT 840.22", "code": "Wide Sag Grate" }, { "name": "Narrow slot sag grate - NCDOT 840.24", "code": "Narrow Sag Grate" }, { "name": "Narrow slot flat grate - NCDOT 840.29", "code": "Narrow Flat Grate" }, { "name": "Angled vane grate - NCDOT 840.33", "code": "Angled Grate" }, { "name": "Steel grate and frame - NCDOT 840.37", "code": "Steel Grate" }, { "name": "NCDOT Standard", "code": "NCDOT" }, { "name": "Carrboro Standard", "code": "Carrboro" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.ManholeType", "description": "", "codedValues": [ { "name": "Access", "code": "Access" }, { "name": "Inside Drop", "code": "Inside Drop" }, { "name": "PTO", "code": "PTO" }, { "name": "Up Side BWG", "code": "Up Side BWG" }, { "name": "Down Side BWG", "code": "Down Side BWG" }, { "name": "Up Side SG", "code": "Up Side SG" }, { "name": "Down Side SG", "code": "Down side SG" }, { "name": "Control", "code": "Control" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "No Manhole", "code": "No Manhole" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Manhole Cover Type", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.ManholeCoverType", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Pavement Cut Depth", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location", "length": 200, "domain": null }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert 1", "domain": null }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert 2", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 25, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GPSDATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "length": 8, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R337_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4537FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S192_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PW_Stormwater_JunctionManhole", "relatedTableId": 130, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7090191F-A16B-4481-B4CE-2EA4A0804D25}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 40, "name": "Clean Outs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "d988820c2168476774f20dde7060f2dc", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAWCAYAAAArdgcFAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACJ0lEQVQ4jd3VXUhTYRzH8e/w+L4k18vIcNI8Jc1d1OYuuiqhi4QoigjBgtFFIV5IEHST9AJBIlhdpJUS6yYDwaioC0OpxQgbQb5HTrM4rs21ufWmW3OLJZRbW2e9QfS7/D/n+TzP//A85wj8xQj/P36qHNPTAE0ZAtWdk7j+GF4vcjoY4fBFA7nHRxg0a6m3THDtt/CzG1g6EOBepZqKnUULtZaNLL80gSWoYVfHK/YC0Z/Gj+nZ3u/n6slyVJq8+LFDWjJNhewJR3EU51PV/IznaeO1pViyoaatAkFQJF/cUAjtRrRHB3lSJ9JwwcG5H+JnjGgGPPTsXo24VY1sCjKh1YCy1UHz/hJ2lCrZdmKYUFLc5uROuwlxZfb30LswvPwA6wsgI6GbWhHFWjeVLeNcBsxJcUFB7/sw+kS8zwdVD2EmBCYV3N8CeRnxz0izRAIhrqR8LdMhGrskDh4pI2dx/fzYAhyL3Qe3nFBdHI8/8CD1erCmxG1vcK5bggPQL66rEzpZFbc0zM2Da44h2dPiD2FzzqIvyv1Wa9B9aZt+P+wrgc0r4uf0uIkGPtEmi3vDNN6Ywlwn8nW/qizo3ETK3HUhPfJyWxa3unlRls84oCONxK7n5EdGgXlZPJbpIH3eELplWfL4Yx94glxPNpYUn4nQdHOKmgNrkOW7JCS7j460cetrRnOiDA2/RSmH232MxQ5M2jhAtwtjd1pf7dT5N/5Ev5LPaC6wMNSj5asAAAAASUVORK5CYII=", "contentType": "image/png", "width": 17, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1962977.5652745515, "ymin": 785854.2601761371, "xmax": 1978805.945691213, "ymax": 792066.4131061435, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Cleanout ID", "length": 20, "domain": null }, { "name": "DEVICETYPE", "type": "esriFieldTypeString", "alias": "Cleanout Type", "length": 30, "domain": { "type": "codedValue", "name": "PW.Stormwater.CleanoutTypes", "description": "", "codedValues": [ { "name": "Cleanout", "code": "Cleanout" }, { "name": "Flushing Structure", "code": "Flushing Structure" }, { "name": "Lamp Hole", "code": "Lamp Hole" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSTYPE", "type": "esriFieldTypeString", "alias": "Access Type", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.AccessType", "description": "", "codedValues": [ { "name": "Door", "code": "Door" }, { "name": "Grate", "code": "Grate" }, { "name": "Cover", "code": "Cover" }, { "name": "Hand", "code": "Hand" }, { "name": "Lid", "code": "Lid" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSDIAM", "type": "esriFieldTypeDouble", "alias": "Access Diameter", "domain": { "type": "range", "name": "PW.Stormwater.AccessDiameter", "description": "", "range": [ 0, 72 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSMAT", "type": "esriFieldTypeString", "alias": "Access Material", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "INTDEPTH", "type": "esriFieldTypeDouble", "alias": "Interior Depth", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.EditBy", "description": "List of editors for stormwater field data", "codedValues": [ { "name": "Randy Dodd", "code": "Dodd" }, { "name": "Emily Cochran", "code": "Cochran" }, { "name": "Evan Crane", "code": "Crane" }, { "name": "Heather Holley", "code": "Holley" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R331_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S186_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 50, "name": "Pipes", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 19000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[DIAMETER] CONCAT \"\"\"-\" CONCAT [MATERIAL]", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "straight", "deconflictionStrategy": "dynamic", "allowOverrun": false, "repeatLabel": false, "removeDuplicates": "all", "removeDuplicatesDistance": 0, "lineConnection": "minimizeLabels", "lineOrientation": "direction", "allowOverlapOfFeatureInterior": "exclude", "stackLabel": false, "where": "\"DIAMETER\" NOT IN ( NULL, -99.98999786, -99)", "useCodedValues": false, "maxScale": 0, "minScale": 3000, "name": "Default", "priority": 9, "symbol": { "type": "esriTS", "color": [ 168, 112, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 244, 186, 255 ], "haloSize": 1, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 1962729.1202333868, "ymin": 775648.00007689, "xmax": 1980984.4121347964, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Pipe ID", "length": 20, "domain": null }, { "name": "PipedStream", "type": "esriFieldTypeString", "alias": "Piped Stream?", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeDiameter", "description": "", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1-1/4\"", "code": 1.25 }, { "name": "1-1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeShape", "description": "", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Horseshoe", "code": "Horseshoe" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Arch", "code": "Arch" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PipeLiner", "type": "esriFieldTypeString", "alias": "Pipe Liner?", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.LiningMethod", "description": "", "codedValues": [ { "name": "Cured in Place", "code": "Cured in Place" }, { "name": "Fold and Form or Deform/Reform", "code": "Fold and Form" }, { "name": "Segmented Panel", "code": "Segmanted Panel" }, { "name": "Segmented Pipe", "code": "Segmented Pipe" }, { "name": "Spiral Wound", "code": "Spiral Wound" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "length": 4, "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "As-Built Length", "domain": null }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null }, { "name": "FROMMH", "type": "esriFieldTypeString", "alias": "From Junction", "length": 11, "domain": null }, { "name": "TOMH", "type": "esriFieldTypeString", "alias": "To Junction", "length": 11, "domain": null }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 250, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "R335_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4535FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S190_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "PW_Stormwater_Pipe", "relatedTableId": 140, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A0259227-DC1C-474C-B6EE-15F5689C9BCF}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 60, "name": "Open Channels", "type": "Feature Layer", "description": "Storm water open drains.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 14999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 215, 215, 158, 255 ], "width": 3 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1966912.298546806, "ymin": 782846.9738678932, "xmax": 1980358.9274933934, "ymax": 807133.8832992315, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Open Channel ID", "length": 20, "domain": null }, { "name": "DrainageType", "type": "esriFieldTypeString", "alias": "Channel Type", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.ChannelType", "description": "OpenDrain type", "codedValues": [ { "name": "Swale", "code": "Swale" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Riprap Channel", "code": "Riprap Channel" }, { "name": "Open Channel w/ Check Dams", "code": "Check Dams" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Shoulder", "code": "Shoulder" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StreamChannel", "type": "esriFieldTypeString", "alias": "Stream Channel?", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TOPWIDTH", "type": "esriFieldTypeDouble", "alias": "Top Width", "domain": null }, { "name": "BOTWIDTH", "type": "esriFieldTypeDouble", "alias": "Bottom Width", "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "LEFTSLOPE", "type": "esriFieldTypeDouble", "alias": "Left Slope", "domain": null }, { "name": "RIGHTSLOPE", "type": "esriFieldTypeDouble", "alias": "Right Slope", "domain": null }, { "name": "UPTOP", "type": "esriFieldTypeDouble", "alias": "Upstream Top", "domain": null }, { "name": "DWNTOP", "type": "esriFieldTypeDouble", "alias": "Downstream Top", "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 250, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "ChannelShape", "type": "esriFieldTypeString", "alias": "ChannelShape", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.ChannelShape", "description": "", "codedValues": [ { "name": "Triangular", "code": "Triangle" }, { "name": "Trapezoid", "code": "Trapezoid" }, { "name": "Parabolic", "code": "Parabola" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChannelLiner", "type": "esriFieldTypeString", "alias": "Channel Material", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.ChannelMaterial", "description": "", "codedValues": [ { "name": "Paved", "code": "Paved" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Vegetation", "code": "Vegetation" }, { "name": "RipRap", "code": "RipRap" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R339_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4539FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S194_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "PW_Stormwater_OpenChannel", "relatedTableId": 150, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{939DDD93-2726-4207-9A01-98A5A08DF0C5}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 70, "name": "Culverts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 112, 0, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1966967.4063762128, "ymin": 779662.1344370544, "xmax": 1979676.1667198092, "ymax": 807077.7820334733, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Culvert ID", "length": 20, "domain": null }, { "name": "PipedStream", "type": "esriFieldTypeString", "alias": "Piped Stream?", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AsBuiltLength", "type": "esriFieldTypeDouble", "alias": "As-Built Length", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeDiameter", "description": "", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1-1/4\"", "code": 1.25 }, { "name": "1-1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeShape", "description": "", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Horseshoe", "code": "Horseshoe" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Arch", "code": "Arch" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINEID", "type": "esriFieldTypeDouble", "alias": "Pipe Material", "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 250, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "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": "R332_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4532FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S187_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "PW_Stormwater_Culvert", "relatedTableId": 160, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{753B6CC2-17C9-46B6-99C0-DF614E83F88F}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 80, "name": "Curb and Gutter", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 19000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1968033.7903982997, "ymin": 778735.3177211434, "xmax": 1981057.1419762224, "ymax": 807161.193612054, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FullName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StreetID", "type": "esriFieldTypeSmallInteger", "alias": "StreetID", "domain": null }, { "name": "DirPrefix", "type": "esriFieldTypeString", "alias": "DirPrefix", "length": 1, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 32, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 4, "domain": null }, { "name": "DirSuffix", "type": "esriFieldTypeString", "alias": "DirSuffix", "length": 4, "domain": null }, { "name": "FullName", "type": "esriFieldTypeString", "alias": "FullName", "length": 36, "domain": null }, { "name": "LeftFrom", "type": "esriFieldTypeSmallInteger", "alias": "LeftFrom", "domain": null }, { "name": "LeftTo", "type": "esriFieldTypeSmallInteger", "alias": "LeftTo", "domain": null }, { "name": "RightFrom", "type": "esriFieldTypeSmallInteger", "alias": "RightFrom", "domain": null }, { "name": "RightTo", "type": "esriFieldTypeSmallInteger", "alias": "RightTo", "domain": null }, { "name": "LeftZip", "type": "esriFieldTypeString", "alias": "LeftZip", "length": 5, "domain": null }, { "name": "RightZip", "type": "esriFieldTypeString", "alias": "RightZip", "length": 5, "domain": null }, { "name": "LeftMailCity", "type": "esriFieldTypeString", "alias": "LeftMailCity", "length": 12, "domain": null }, { "name": "RightMailCity", "type": "esriFieldTypeString", "alias": "RightMailCity", "length": 12, "domain": null }, { "name": "Jurisdiction_R", "type": "esriFieldTypeString", "alias": "Jurisdiction_R", "length": 2, "domain": null }, { "name": "Jurisdiction_L", "type": "esriFieldTypeString", "alias": "Jurisdiction_L", "length": 2, "domain": null }, { "name": "SegmentID", "type": "esriFieldTypeInteger", "alias": "SegmentID", "domain": null }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maint", "length": 12, "domain": null }, { "name": "Surface", "type": "esriFieldTypeString", "alias": "Surface", "length": 7, "domain": null }, { "name": "RightSpeed", "type": "esriFieldTypeSmallInteger", "alias": "RightSpeed", "domain": null }, { "name": "LeftSpeed", "type": "esriFieldTypeSmallInteger", "alias": "LeftSpeed", "domain": null }, { "name": "Direction", "type": "esriFieldTypeSmallInteger", "alias": "Direction", "domain": null }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Class", "length": 10, "domain": null }, { "name": "Curb", "type": "esriFieldTypeString", "alias": "Curb", "length": 3, "domain": null }, { "name": "Width", "type": "esriFieldTypeSmallInteger", "alias": "Width", "domain": null }, { "name": "Miles", "type": "esriFieldTypeDouble", "alias": "Miles", "domain": null }, { "name": "Cross1", "type": "esriFieldTypeString", "alias": "Cross1", "length": 36, "domain": null }, { "name": "Cross12", "type": "esriFieldTypeString", "alias": "Cross12", "length": 36, "domain": null }, { "name": "Cross2", "type": "esriFieldTypeString", "alias": "Cross2", "length": 36, "domain": null }, { "name": "Cross22", "type": "esriFieldTypeString", "alias": "Cross22", "length": 36, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 54, "domain": null }, { "name": "Symbology", "type": "esriFieldTypeString", "alias": "Symbology", "length": 18, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "GutterType", "type": "esriFieldTypeString", "alias": "Gutter Type", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.GutterType", "description": "", "codedValues": [ { "name": "Curb", "code": "Curb" }, { "name": "Island", "code": "Island" }, { "name": "Shoulder Berm", "code": "Shoulder" }, { "name": "Expressway", "code": "Expressway" }, { "name": "Flume", "code": "Flume" }, { "name": "Other", "code": "Other" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "In Elevation", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Out Elevation", "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 250, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TransportationImpact", "type": "esriFieldTypeString", "alias": "TransportationImpact", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.TransportationImpact", "description": "", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "High", "code": "High" }, { "name": "Lowest", "code": "Lowest" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Highest", "code": "Highest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CensusPriority", "type": "esriFieldTypeSmallInteger", "alias": "Census Block Priority", "domain": null }, { "name": "GutterOutfall", "type": "esriFieldTypeString", "alias": "GutterOutfall", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.GutterOutfall", "description": "", "codedValues": [ { "name": "Pipe", "code": "Pipe" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Gutter", "code": "Gutter" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "R342_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_342", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4542FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_342", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S197_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "PW_Stormwater_CurbGutter", "relatedTableId": 170, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{25567DD9-A984-441C-A971-7FF2E3A04C80}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 90, "name": "SCMs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 14999, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1961975.5000214726, "ymin": 771949.749927476, "xmax": 1980047.3733264655, "ymax": 807016.4908174723, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "SCM ID", "length": 20, "domain": null }, { "name": "DetentionType", "type": "esriFieldTypeString", "alias": "SCM Type", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.SCMType", "description": "", "codedValues": [ { "name": "Armor Fill Slope", "code": "Armor fill slope" }, { "name": "Bioretention Area", "code": "Bioretention area" }, { "name": "Drained Farm Pond", "code": "Drained farm pond" }, { "name": "Farm Pond", "code": "Farm pond" }, { "name": "Rainwater Harvesting", "code": "Rainwater harvesting" }, { "name": "Stream Restoration", "code": "Stream restoration" }, { "name": "Underground Detention", "code": "Underground detention" }, { "name": "Wet Detention", "code": "Wet detention" }, { "name": "Bay Filter", "code": "Bay filter" }, { "name": "Filterra", "code": "Filterra" }, { "name": "Green Roof", "code": "Green roof" }, { "name": "Permeable Pavement", "code": "Permeable pavement" }, { "name": "Regenerative Stormwater Conveyance", "code": "Regenerative stormwater conveyance" }, { "name": "Sand Filter", "code": "Sand filter" }, { "name": "Storm Filter", "code": "Storm filter" }, { "name": "Dry Pond", "code": "Dry Pond" }, { "name": "Wet Pond", "code": "Wet Pond" }, { "name": "Stormwater Wetland", "code": "Stormwater Wetland" }, { "name": "Infiltration System", "code": "Infiltration System" }, { "name": "Disconnected Impervious Surface", "code": "Disconnected Impervious Surface" }, { "name": "Treatment Swale", "code": "Treatment Swale" }, { "name": "Silva Cell", "code": "Silva Cell" }, { "name": "Stormceptor", "code": "Stormceptor" }, { "name": "Level Spreader-Filter Strip", "code": "Level Spreader-Filter Strip" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location", "length": 200, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "SIDESLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "VOLUME", "type": "esriFieldTypeDouble", "alias": "Volume", "domain": null }, { "name": "BEDMATERIAL", "type": "esriFieldTypeString", "alias": "Bed Material", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BNKMATERIAL", "type": "esriFieldTypeString", "alias": "Bank Material", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert In Elevation", "domain": null }, { "name": "OUTFLWELEV", "type": "esriFieldTypeDouble", "alias": "Outflow Elevation", "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Failing", "code": "Failing" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AreaSF", "type": "esriFieldTypeDouble", "alias": "Area Sq Ft", "domain": null }, { "name": "MediaElev", "type": "esriFieldTypeDouble", "alias": "Media Elevation", "domain": null }, { "name": "WeirElev", "type": "esriFieldTypeDouble", "alias": "Weir Elevation", "domain": null }, { "name": "Permitted", "type": "esriFieldTypeString", "alias": "Permitted?", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes & No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TownRegulated", "type": "esriFieldTypeString", "alias": "Town Regulated?", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R333_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S188_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "PW_Stormwater_SCM", "relatedTableId": 180, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{89CD0A84-CA4C-40F0-B234-2A31561DF559}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 100, "name": "Virtual Drainage to Stream", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 15000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 150, 0, 255 ], "width": 0.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1967914.8441138864, "ymin": 771963.4293620586, "xmax": 1981020.0475622267, "ymax": 806810.0079627335, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Drainline ID", "length": 20, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In Elevation", "domain": null }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out Elevation", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R340_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S195_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3943fb5575f94d0a8d46b2fd82dda518" } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 110, "name": "Inlet Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspTypeCamera", "type": "esriFieldTypeString", "alias": "InspTypeCamera", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.CameraInspectType", "description": "", "codedValues": [ { "name": "CCTV", "code": "CCTV" }, { "name": "Pole", "code": "Pole" }, { "name": "Visual", "code": "Visual" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectRef", "description": "", "codedValues": [ { "name": "AASHTO", "code": "AASHTO" }, { "name": "NCDOT MCAP", "code": "NCDOT" }, { "name": "NASSCO PACP", "code": "NASSCO PACP" }, { "name": "NASSCO MACP", "code": "NASSCO MACP" }, { "name": "Other/None", "code": "Other/None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Blocked50Pct", "type": "esriFieldTypeString", "alias": "Blocked50PctOrMore", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ErosionThreshold", "type": "esriFieldTypeString", "alias": "ErosionGT6inWithin1ftOfInlet", "length": 3, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.InletRatingDescription", "description": "", "codedValues": [ { "name": "No Damage, Like New", "code": 1 }, { "name": "Minimal Damage, Small Chips and Some Weathering", "code": 2 }, { "name": "Some Damage (e.g., Concrete Mortar and Cracking)", "code": 3 }, { "name": "Loss of Concrete, Large Cracking", "code": 4 }, { "name": "Significant Structural Damage", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R324_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_324", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4523RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4523FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_324", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "swInlet", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{12B6E139-76B0-461D-9656-2DEB95B98238}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 120, "name": "Outlet Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "ScourDepthFt", "type": "esriFieldTypeDouble", "alias": "ScourDepthFt", "domain": null }, { "name": "ScourLengthFt", "type": "esriFieldTypeDouble", "alias": "ScoutLengthFt", "domain": null }, { "name": "ScourWidthFt", "type": "esriFieldTypeDouble", "alias": "ScourWidthFt", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectRef", "description": "", "codedValues": [ { "name": "AASHTO", "code": "AASHTO" }, { "name": "NCDOT MCAP", "code": "NCDOT" }, { "name": "NASSCO PACP", "code": "NASSCO PACP" }, { "name": "NASSCO MACP", "code": "NASSCO MACP" }, { "name": "Other/None", "code": "Other/None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Dissipator", "type": "esriFieldTypeString", "alias": "EnergyDissipator", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.EnergyDissipator", "description": "", "codedValues": [ { "name": "Class A Rip Rap", "code": "RipRapA" }, { "name": "Class B Rip Rap", "code": "RipRapB" }, { "name": "Class I Rip Rap", "code": "RipRapI" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.OutfallRatingDescription", "description": "", "codedValues": [ { "name": "No Scour", "code": 1 }, { "name": "Minimal Scour (0-6\" Depth)", "code": 2 }, { "name": "Some Scour (6-12\" Depth)", "code": 3 }, { "name": "Scour Hole (12-18\" Depth)", "code": 4 }, { "name": "Scour Hole > 18\" Depth", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R327_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_327", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4526RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4526FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_327", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "swDischargePoint", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{801FD4BB-246F-4FA6-A9B9-F47465EE2FC0}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 130, "name": "Junction/Manhole Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectDate", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "InspectYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectRef", "description": "", "codedValues": [ { "name": "AASHTO", "code": "AASHTO" }, { "name": "NCDOT MCAP", "code": "NCDOT" }, { "name": "NASSCO PACP", "code": "NASSCO PACP" }, { "name": "NASSCO MACP", "code": "NASSCO MACP" }, { "name": "Other/None", "code": "Other/None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "ConditionStructure", "type": "esriFieldTypeString", "alias": "StructuralCondition", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionStructure", "description": "", "codedValues": [ { "name": "Crack", "code": "Crack" }, { "name": "Hole", "code": "Hole" }, { "name": "Deformed", "code": "Deformed" }, { "name": "Collapsed", "code": "Collapsed" }, { "name": "Joint", "code": "Joint" }, { "name": "Other", "code": "Other" }, { "name": "No Damage", "code": "NoDamage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Defects", "type": "esriFieldTypeString", "alias": "ConditionDefects", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionDefects", "description": "", "codedValues": [ { "name": "Deposits", "code": "Deposits" }, { "name": "Roots", "code": "Roots" }, { "name": "Obstruction", "code": "Obstruction" }, { "name": "Vermin", "code": "Vermin" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R325_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_325", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4524RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4524FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_325", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "swManhole", "relatedTableId": 30, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7090191F-A16B-4481-B4CE-2EA4A0804D25}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 140, "name": "Pipe Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspDate", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectRef", "description": "", "codedValues": [ { "name": "AASHTO", "code": "AASHTO" }, { "name": "NCDOT MCAP", "code": "NCDOT" }, { "name": "NASSCO PACP", "code": "NASSCO PACP" }, { "name": "NASSCO MACP", "code": "NASSCO MACP" }, { "name": "Other/None", "code": "Other/None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureCondition", "type": "esriFieldTypeString", "alias": "StructuralCondition", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionStructure", "description": "", "codedValues": [ { "name": "Crack", "code": "Crack" }, { "name": "Hole", "code": "Hole" }, { "name": "Deformed", "code": "Deformed" }, { "name": "Collapsed", "code": "Collapsed" }, { "name": "Joint", "code": "Joint" }, { "name": "Other", "code": "Other" }, { "name": "No Damage", "code": "NoDamage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Defects", "type": "esriFieldTypeString", "alias": "Defects", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionDefects", "description": "", "codedValues": [ { "name": "Deposits", "code": "Deposits" }, { "name": "Roots", "code": "Roots" }, { "name": "Obstruction", "code": "Obstruction" }, { "name": "Vermin", "code": "Vermin" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeRatingDescription", "description": "placeholder", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R328_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_328", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4527RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4527FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_328", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "swGravityMain", "relatedTableId": 50, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A0259227-DC1C-474C-B6EE-15F5689C9BCF}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 150, "name": "Ditch Inpsections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspRefDitch", "description": "", "codedValues": [ { "name": "AASHTO", "code": "AASHTO" }, { "name": "NCDOT MCAP", "code": "NCDOT" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BlockedGT50Pct_Ft", "type": "esriFieldTypeInteger", "alias": "Length(Ft)BlockedGT50Pct", "domain": null }, { "name": "LengthErodedGT1Ft", "type": "esriFieldTypeInteger", "alias": "Length(Ft)ErodedGT1Ft", "domain": null }, { "name": "DrivePipes", "type": "esriFieldTypeSmallInteger", "alias": "NumberDrivePipes", "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.DitchRatingDescriptiono", "description": "", "codedValues": [ { "name": "No Blockage or Erosion", "code": 1 }, { "name": "Minimal Blockage or 0-6\" Erosion", "code": 2 }, { "name": "> 25% Blocked or 6-12\" Erosion", "code": 3 }, { "name": "> 50% Blocked or 12-18\" Erosion", "code": 4 }, { "name": "100% Blocked or > 18\" Erosion", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R326_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_326", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4525RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4525FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_326", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "swOpenDrain", "relatedTableId": 60, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{939DDD93-2726-4207-9A01-98A5A08DF0C5}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 160, "name": "Culvert Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "PW.Stormwater.InspectRef", "length": 15, "domain": null }, { "name": "ApproachRoad", "type": "esriFieldTypeSmallInteger", "alias": "ApproachRoadwayCondition", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Embankment", "type": "esriFieldTypeSmallInteger", "alias": "EmbankmentCondition", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Channel", "type": "esriFieldTypeSmallInteger", "alias": "ChannelCondition", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EndTreatment", "type": "esriFieldTypeSmallInteger", "alias": "EndTreatmentCondition", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Footing", "type": "esriFieldTypeSmallInteger", "alias": "ConcreteSlabFootingCondition", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Barrel", "type": "esriFieldTypeSmallInteger", "alias": "BarrelAlignmentCondition", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AquaticOrganism", "type": "esriFieldTypeSmallInteger", "alias": "AquaticOrganismPassage", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CulvertRating", "type": "esriFieldTypeSmallInteger", "alias": "CulvertRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.CulvertRatingDescription", "description": "", "codedValues": [ { "name": "1 or fewer indicators fair and no indicators poor or failing", "code": 1 }, { "name": "3 or fewer indicators fair and no indicators poor or failing", "code": 2 }, { "name": "4 or fewer indicators fair amd 1 or fewer indicators poor, no indicators failing", "code": 3 }, { "name": "3 or fewer indicators poor and 1 or fewer indicators failing", "code": 4 }, { "name": "4 or more indicators poor and 2 or more indicators failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R322_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_322", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4521RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4521FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_322", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "swCulvert", "relatedTableId": 70, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{753B6CC2-17C9-46B6-99C0-DF614E83F88F}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 170, "name": "Curb and Gutter Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "ObstructedFt", "type": "esriFieldTypeInteger", "alias": "LengthObstructedFt", "domain": null }, { "name": "DamagedFt", "type": "esriFieldTypeInteger", "alias": "LengthDamagedFt", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "PW.Stormwater.InspectBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 15, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectRef", "description": "", "codedValues": [ { "name": "AASHTO", "code": "AASHTO" }, { "name": "NCDOT MCAP", "code": "NCDOT" }, { "name": "NASSCO PACP", "code": "NASSCO PACP" }, { "name": "NASSCO MACP", "code": "NASSCO MACP" }, { "name": "Other/None", "code": "Other/None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.InletRatingDescription", "description": "", "codedValues": [ { "name": "No Damage, Like New", "code": 1 }, { "name": "Minimal Damage, Small Chips and Some Weathering", "code": 2 }, { "name": "Some Damage (e.g., Concrete Mortar and Cracking)", "code": 3 }, { "name": "Loss of Concrete, Large Cracking", "code": 4 }, { "name": "Significant Structural Damage", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R323_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_323", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4522RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4522FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_323", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "swCurbGutter", "relatedTableId": 80, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{25567DD9-A984-441C-A971-7FF2E3A04C80}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 180, "name": "SCM Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "ReviewFlag", "type": "esriFieldTypeSmallInteger", "alias": "ReviewFlag", "domain": { "type": "codedValue", "name": "PW.BooleanDomain", "description": "", "codedValues": [ { "name": "True", "code": 1 }, { "name": "False", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "length": 4, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectYear", "description": "", "codedValues": [ { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "length": 20, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectBy", "description": "", "codedValues": [ { "name": "TOC Staff", "code": "TOC" }, { "name": "Sungate", "code": "Sungate" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "length": 3, "domain": { "type": "codedValue", "name": "PW.Stormwater.Inspector", "description": "", "codedValues": [ { "name": "Randy Dodd", "code": "RD" }, { "name": "Heather Holley", "code": "HH" }, { "name": "Deborah Shoffner", "code": "DS" }, { "name": "Max Randall", "code": "MR" }, { "name": "Mike Thompson", "code": "MT" }, { "name": "Brian Elam (Sungate)", "code": "BE" }, { "name": "Randy Howard (Sungate)", "code": "RH" }, { "name": "Josh Dalton (Sungate)", "code": "JD" }, { "name": "ME (Sungate)", "code": "ME" }, { "name": "Other", "code": "OTH" }, { "name": "Will Dedmon (Sungate)", "code": "WD" }, { "name": "Brock Austin (Sungate)", "code": "BA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspectType", "description": "", "codedValues": [ { "name": "Initial", "code": "Initial" }, { "name": "Routine", "code": "Routine" }, { "name": "Special", "code": "Special" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "length": 5, "domain": { "type": "codedValue", "name": "PW.Stormwater.InspRefSCM", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "ConditionRating", "domain": { "type": "codedValue", "name": "PW.Stormwater.ConditionRating", "description": "", "codedValues": [ { "name": "Very Good", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Failing", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintRequired", "type": "esriFieldTypeSmallInteger", "alias": "MaintenancePriority", "domain": { "type": "codedValue", "name": "PW.Stormwater.MaintenancePriority", "description": "", "codedValues": [ { "name": "None Required", "code": 1 }, { "name": "Maintenance Required for Debris", "code": 2 }, { "name": "Both Maintenance and Repair Required", "code": 4 }, { "name": "Repair Immediately", "code": 5 }, { "name": "Repair Required", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "length": 10, "domain": { "type": "codedValue", "name": "PW.Stormwater.NextAction", "description": "", "codedValues": [ { "name": "Inspect", "code": "Inspect" }, { "name": "Reinspect", "code": "Reinspect" }, { "name": "Clean", "code": "Clean" }, { "name": "Repair", "code": "Repair" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Retrofit", "code": "Retrofit" }, { "name": "Other", "code": "Other" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R329_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_329", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4528RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4528FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_329", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "swDetention", "relatedTableId": 90, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{89CD0A84-CA4C-40F0-B234-2A31561DF559}" } ], "capabilities": "Query,Map,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": "3943fb5575f94d0a8d46b2fd82dda518" } ] }