{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "Inlets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "96361d6e774115bd4e34c74a10230d8b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAQZJREFUOI2tzrFqhDAABuC/JmQpgrgUFDdxloBP0VcQn0F8hEJ36eQzdO7mdLhVgkNXxyCSglsXQenSa3t3aoPXf0qC/+dP8U+hx0MYhi97AELIqxDigf56uN8DTdN0uggAbNuei6J41wGyLHuSUj4e7ycQpRSe593leb6JBEEA13XfpJQ/3fOP5nlGXddYw5RSKMvy4v0CAgDGGBzH2VylBQ3DgKZpFgumaepDjDFYlnX9or7vUVXVYoFzrg/5vo8kSRYLXdfpQ3uyCLVtiziOFwvjOCKKor8hxhgOh8Pm3w3DQJqm65BSyuCcf2wqXyGEPG8uIoTc6kDn+YaEEDd7gNVFe/MJIzhGIzRhWe0AAAAASUVORK5CYII=", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1962729.1202333868, "ymin": 778266.1159036458, "xmax": 1981020.0475622267, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 1, "name": "Outlets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "31b0f25bcd067ec018b00493e95221d4", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAjhJREFUOI2tkz9IG2EYxn8X75LDUwJpHNoOQhoupUIJGKQ4JUMrxKFLhpLFwT9TioGiHW5SqoJIHQSl4BAoHASKGGjp4NJCpnrFyVKKCi1dYiUJRw6ahiQdTGLOxBZKn+l7vj+/733ej0/kP0lsG7++tOYEbgAKIAE/gTxwBtTa9n0AFlsgl8sVzWazb5s+nU7fWVtbu9lO9ng8vo2NjY+qqp4CHBwcyDMzMyO2ihRFIRQKRZs+GAxiWRZbW1stkK7rwtjYWKjpJUk6Bj5fjtZSsVhkff05IyN3mZh4gyz3Ylmwt/eeXC5HPB5HFO1H251QKBQAmJ19zPR0hIGBHuC0ER0mJyMYxhm7u7vEYjEMw3ADgg1kWRaJRIJAQCUaVRsQu0qlE4aHB9nefke1WmVqasoLeDui6brOeRNfdEvcuPArkcg9IpFWO6/ZQOVyGYChIT+y7LwSBCDLlXbb21ERwNHREZVKFUnqjNaUaZrt9pcN5HK58Pv9hMNBTk6+EwgMXgkyjE/Mz8+zuroKYNpAiqKws7NDX59AMjnJ3Nwj+vt7OyCHh98oFissL6/gdrtNTdNyl6PVVVUVAJLJJywtrRCP38fnu47TKWGaFvv7XyiVPCwsLCKKIuPj4z80TSt37RHA6OhDNjdvo2lPSaWetebT6ZfEYnEcDkfHGRuoVrv4i8fHp6RSGdtmXX9FOPwAr9d7HqFe7wTl83mhp+fqlwLIZDJkMjb4Lbr8NeGPlL+oa4/+Rb8Bjc6uoPMA3HYAAAAASUVORK5CYII=", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1961990.14238064, "ymin": 771963.4293620586, "xmax": 1980980.757286474, "ymax": 807006.2296831459, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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" } ], "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": "PERMIT", "type": "esriFieldTypeString", "alias": "Permitted?", "length": 30, "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": 15, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 2, "name": "Junctions/Manholes", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 7999, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "3ea75cb0c896ec1e2eb8af34b0e86082", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAABM5JREFUSIm1ln1M1HUcx1/3xP04Tg+PUzl5THE3PIMzYpenFEU2CBY5Hub8R02xzTkrc9OWOYo2Z1Y+0OMKSptMoczFCDPJTezytMsLArvE8aByJx4PB8fh4R31B3lIQFqtz5/f3+f7fv32ef8+n89Pyv8c0ntNNBqNmjiNL7qp7ZbY7/dft9vtDmDkPwHKN2r1Azenv9N0XWq0dvpDLzslCIIEgNw0gy9Gw5nznfJii8Vy5p8CxB8+m1B95GdVllIWEBUYhtjwsIvTdiWt3bA2rYf27jB5bbMyw+/3ZxQuM3x7dVCxwmw299wVsDMb5Ui4/uIBmxC9Y5mL9EQncqkPgOZOHd3eUPRRDvRRkJkEv3Ro2Xli9uMzQrwNJpMp3Ww2t/wdQIRaf+FosxCdOT/Ao3onIWLflCUUA0mxDlYZw0Tba1VRaoW3Li0tzVBfX987KaB0vf6DT61CQmmei6rzSkpPJLDpiSZk4ikZnLmUQHGtireecrPnlDK6f8BbDiyfAFhhMqlPt3jXvrDUw+J57eij5Lx8LJH36/RsWLeR/hkpXG2pwTXQhmtmERrXZsyXItnypYr3Cl08EN/ONCFOvL5S87TRaFx62/ggYJHOu7WyQSLJXnQDgOmCj9dzO9hal8GLFRfp77eQlZVFQmIyxV/UER+xic9rvqM0f1QcwBDXTtKsGcMNXWwAxgP6h1ietzBAeOjYh6DS7SAnYh6tra0UFRUhCAIAOTk5VFVVUXizh9S5ZWOeiCBvkUfW/I0qC5AAgSCgwy3R5iW7x9V3ODaTQ/uKKSsrC4oDyGQyCgoKeP7USfqG1ONeKl4zKPKjCtfpdJF2u/1aEOB0o6huVHKhwxBM9prfwWAwoFAoJpgrk8l45LEMXjlyjoiw2OB5/9CtUXOl0tnAGEAqCQRiwhHrtZ5gsic+nhZHL1PF0EAf+kjQTBu70z0o53QHCIIwDHd4oFbiXqD1aPJTx/okMH8Oa/c14nA40Gq148TdbjfHv66hPL+F0JCxXrG1x/3+0TlBJJVKneMAYWIs51rl2QWpYyKSljVkLtlFSUkJ27ZtIzZ2tBRdXV3s21XCwvAu5CHjG/F8m/IGMGCxWFzjAFan5BOQZF/rUxMVPmqa+VIMe49+xktrnmTv7l0Mj0CIGHoc7axObuPjJhkVZh0rTXbEwNAtOYetsulARbD0QYDVemx5uuFKxQ/amC1ZPZy9HMfmoypK812kziwhdyYcqNfxW5eU8sImxMCCOXKeO5KIRKxjxUN2qn+K73b7JUqPx7NnAgAItPaxrrNROC4R6UWVDQL7812kzm0PJoTIQCaVcXtyzJrmY0/BRTYdTuRKr95f2ShEAK/Z7faOyQDYbLYTRqNha0WD8MbKpJs8eIf4VBGp8vHM4l7v9uMaRSAQqLbZbK/e+XzCuLZYbLsNBkOgskF40zOs969a4pDFRUwY8wB0D6o5dFbrOGgVtEClzWZbzV+23KQLx2azvZ2SknLhZIuw/6tf71t4f2TsUPq8oRG7U6q46oaD3+v6zK2hgR87JZo/NTZardZ3J9OacmVardZTQLLJZMpqdPpyG51KI6AFZM0uZRfQLJVKa9RqdWVtbe3AVDp3W/ojZrO5Bqi5S96Ucc9/Ff82/gDcvNLDJedZKgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": [ { "labelPlacement": "esriServerPointLabelPlacementAboveRight", "where": null, "labelExpression": "[FacilityID]", "useCodedValues": true, "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" } }, "minScale": 1800, "maxScale": 0 } ] }, "defaultVisibility": true, "extent": { "xmin": 1962938.8553782254, "ymin": 779028.3479749709, "xmax": 1980435.4768809676, "ymax": 802797.7171028107, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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" } ], "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": 13, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 3, "name": "Clean Outs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "ee79d3a688dc068af52cf09cabd8a1de", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAiRJREFUOI2tk11Ik1EYx3/atre9G9tySrNkzrGPQoOhoYl0uZuIoFhF3SxZH9BF6kV0tYiy7OOmuwgihMqLUCgKugjqzjHEkGiL1agM0j73Ucs8a84upLV3c8yi/915zvP/nef8D0fFf5SqWkMvWC0OTg/F6QdS/ww76yDQauSU10qTWy+1hzP0XYmLx38Lky64ubnDxrYNBmQAv1Nscr1nxPxTujE4LU4Ai1Vhx+vw2K3SyP5msdGgUe51W7C0GES/bjVbRmP4JuFjRdg5hxRsN4tjXquor60wskVGPdDG1kYt4fgHBgZnuVMKM1x0c9dnEz0tBtQVOH8yqAW/E1vIxLBGx9jJOIeBBRXA5Vbp0SGX6JCXSTCbh685qNNA6bTdDRgbtfQaJXJ9EY6oAOrV4mk2T4dc0jwzBwdD8CABwWYIbgZ1CTElqLHouVe4pklmKJLG39OgPPzhuyUQwJlp2OOCNpMSFv/Op71h7hdg28d5ebuLN4C9uHGNpDSWvm4uD0lB9Pe6kJIQhDJZ7Poig3cdXPPAkyTsXA/WkhxeZ0AN18tgulWcj6bZ11l0Va0KAk4IsLyi3/jSO8WtMtiuSZ6NdfG2E2wVvAotAp/T0nMQC2UwgIxg4kcOm7bq94fZOcjmdKMgCjWFTZa5FEvj85ipqQaLJEkcjSWuFtcUsN3jTAx7mEnNs7Ya7FVaegFiviIM4MAUTdVASxJllRWks3L9Arwwnhpm5BEzAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1962977.5652745515, "ymin": 785854.2601761371, "xmax": 1978805.945691213, "ymax": 792066.4131061435, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 4, "name": "Pipes", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 19000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3.5 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": [ { "labelPlacement": "esriServerLinePlacementAboveAlong", "where": "\"DIAMETER\" NOT IN ( NULL, -99.98999786, -99)", "labelExpression": "[DIAMETER] CONCAT \"\"\"-\" CONCAT [MATERIAL]", "useCodedValues": false, "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" } }, "minScale": 3000, "maxScale": 0 } ] }, "defaultVisibility": true, "extent": { "xmin": 1962729.1202333868, "ymin": 775648.00007689, "xmax": 1980984.4121347964, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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": 16, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 5, "name": "Culverts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 112, 0, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1966967.4063762128, "ymin": 779662.1344370544, "xmax": 1979676.1667198092, "ymax": 807077.7820334733, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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": 4, "name": "PW_Stormwater_Culvert", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 6, "name": "Curb and Gutter", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 15000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 137, 137, 68, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1968033.7903982997, "ymin": 778735.3177211434, "xmax": 1981057.1419762224, "ymax": 807161.193612054, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FullName", "type": "esriFieldTypeString", "alias": "Street Name", "length": 36, "domain": null }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Street Maintenance", "length": 12, "domain": null }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Street Class", "length": 10, "domain": null }, { "name": "Width", "type": "esriFieldTypeSmallInteger", "alias": "Street Width", "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" } ], "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": "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": "G4542FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S197_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "PW_Stormwater_CurbGutter", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 7, "name": "Open Channels", "type": "Feature Layer", "description": "Storm water open drains.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 14999, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 215, 215, 158, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1966912.298546806, "ymin": 782846.9738678932, "xmax": 1980358.9274933934, "ymax": 807133.8832992315, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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": 6, "name": "PW_Stormwater_OpenChannel", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 8, "name": "SCMs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 14999, "maxScale": 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 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1961975.5000214726, "ymin": 771949.749927476, "xmax": 1980047.3733264655, "ymax": 807016.4908174723, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "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" } ], "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" } ], "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" } ], "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": 17, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 9, "name": "Virtual Drainage to Stream", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 15000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 150, 0, 255 ], "width": 0.5 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1967914.8441138864, "ymin": 771963.4293620586, "xmax": 1981020.0475622267, "ymax": 806810.0079627335, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "LASTEDITOR", "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": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.81, "id": 10, "name": "CulvertInspections", "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": 4, "name": "swCulvert", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 11, "name": "CurbGutterInspections", "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": 5, "name": "swCurbGutter", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 12, "name": "InletInspections", "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": 0, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 13, "name": "JunctionManholeInspections", "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": 2, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 14, "name": "OpenChannelInspections", "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": 6, "name": "swOpenDrain", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 15, "name": "OutletInspections", "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": 1, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 16, "name": "PipeInspections", "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": 4, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 17, "name": "SCMInspections", "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": 8, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null } ] }