{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "Inlets", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 7999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PW_Stormwater_Inlet", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1962729.1202333868, "ymin": 778266.1159036458, "xmax": 1981020.0475622267, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Inlet ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "InletLabel", "type": "esriFieldTypeInteger", "alias": "Inlet Label", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InletLabel" }, { "name": "INLETTYPE", "type": "esriFieldTypeString", "alias": "Inlet Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INLETTYPE" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "InletStructure", "type": "esriFieldTypeString", "alias": "Inlet Structure", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "InletStructure" }, { "name": "InletStandard", "type": "esriFieldTypeString", "alias": "Inlet Standard", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InletStandard" }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERTELEV" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVINELEV2", "type": "esriFieldTypeDouble", "alias": "Invert In 2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV2" }, { "name": "INVINELEV3", "type": "esriFieldTypeDouble", "alias": "Invert In 3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV3" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "Rim", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rim" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Inlets", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "OWNEDBY": 1, "LASTUPDATE": null, "FACILITYID": null, "InletLabel": null, "INLETTYPE": null, "DESCRIPTION": null, "InletStructure": null, "InletStandard": null, "INVERTELEV": null, "INVINELEV": null, "INVINELEV2": null, "INVINELEV3": null, "INVOUTELEV": null, "Rim": null, "MAINTBY": 1, "LASTEDITOR": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 1, "name": "Outlets", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 7999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "PW_Stormwater_Outlet", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1961990.14238064, "ymin": 771963.4293620586, "xmax": 1980980.757286474, "ymax": 807006.2296831459, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Outlet ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "DISCHID", "type": "esriFieldTypeString", "alias": "PW Outlet Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DISCHID" }, { "name": "DISCHRGTYP", "type": "esriFieldTypeString", "alias": "Outlet Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DISCHRGTYP" }, { "name": "OutfallStructure", "type": "esriFieldTypeString", "alias": "Outlet Structure", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "OutfallStructure" }, { "name": "SCMType", "type": "esriFieldTypeString", "alias": "SCM If Applicable", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCMType" }, { "name": "StreamOrigin", "type": "esriFieldTypeString", "alias": "Stream Origin?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "StreamOrigin" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "PERMIT", "type": "esriFieldTypeString", "alias": "Permitted?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PERMIT" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Illicit Discharge Priority", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Priority" }, { "name": "EnergyDissipator", "type": "esriFieldTypeString", "alias": "EnergyDissipator", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EnergyDissipator" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Outlets", "description": "", "prototype": { "attributes": { "DIAMETER": null, "OWNEDBY": 1, "EnergyDissipator": null, "FACILITYID": null, "DISCHID": null, "DISCHRGTYP": null, "OutfallStructure": null, "SCMType": null, "StreamOrigin": null, "DESCRIPTION": null, "LOCDESC": null, "INVINELEV": null, "INVOUTELEV": null, "PERMIT": null, "INSTALLDATE": null, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "Priority": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 2, "name": "Junctions/Manholes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 7999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "PW_Stormwater_JunctionManhole", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1962938.8553782254, "ymin": 779028.3479749709, "xmax": 1980435.4768809676, "ymax": 802797.7171028107, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "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 } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Junction ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "PWLabel", "type": "esriFieldTypeInteger", "alias": "PW Label", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PWLabel" }, { "name": "JunctionType", "type": "esriFieldTypeString", "alias": "Junction Type", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "JunctionType" }, { "name": "Standard", "type": "esriFieldTypeString", "alias": "Standard", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Standard" }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MHTYPE" }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Manhole Cover Type", "domain": { "type": "codedValue", "name": "PW.Stormwater.ManholeCoverType", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CVTYPE" }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Pavement Cut Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CUTDEPTH" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HIGHELEV" }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIMELEV" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERTELEV" }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert 2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "WALLMAT" }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LINED" }, { "name": "GPSDATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "GPSDATE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Junctions/Manholes", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "OWNEDBY": 1, "LASTEDITOR": null, "FACILITYID": null, "PWLabel": null, "JunctionType": null, "Standard": null, "MHTYPE": null, "CVTYPE": null, "CUTDEPTH": null, "DESCRIPTION": null, "LOCDESC": null, "HIGHELEV": null, "RIMELEV": null, "INVINELEV": null, "INVERTELEV": null, "INVERT": null, "INVOUTELEV": null, "WALLMAT": null, "LINED": null, "GPSDATE": null, "MAINTBY": 1, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 3, "name": "Clean Outs", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1962977.5652745515, "ymin": 785854.2601761371, "xmax": 1978805.945691213, "ymax": 792066.4131061435, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Cleanout ID", "domain": null, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "DEVICETYPE", "type": "esriFieldTypeString", "alias": "Cleanout Type", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": "Cleanout", "modelName": "DEVICETYPE" }, { "name": "ACCESSTYPE", "type": "esriFieldTypeString", "alias": "Access Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Cover", "modelName": "ACCESSTYPE" }, { "name": "ACCESSDIAM", "type": "esriFieldTypeDouble", "alias": "Access Diameter", "domain": { "type": "range", "name": "PW.Stormwater.AccessDiameter", "description": "", "range": [ 0, 72 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 24, "modelName": "ACCESSDIAM" }, { "name": "ACCESSMAT", "type": "esriFieldTypeString", "alias": "Access Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ACCESSMAT" }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROTATION" }, { "name": "INTDEPTH", "type": "esriFieldTypeDouble", "alias": "Interior Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INTDEPTH" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R331_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S186_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Clean Outs", "description": "", "prototype": { "attributes": { "ACCESSTYPE": "Cover", "DEVICETYPE": "Cleanout", "MAINTBY": 1, "INSTALLDATE": null, "OWNEDBY": 1, "INTDEPTH": null, "ACCESSDIAM": 24, "ACCESSMAT": null, "ROTATION": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 4, "name": "Pipes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 19000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "PW_Stormwater_Pipe", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1962729.1202333868, "ymin": 775648.00007689, "xmax": 1980984.4121347964, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "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 } ] }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Pipe ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "PipedStream", "type": "esriFieldTypeString", "alias": "Piped Stream?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PipedStream" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINSHAPE" }, { "name": "PipeLiner", "type": "esriFieldTypeString", "alias": "Pipe Liner?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PipeLiner" }, { "name": "LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LINERTYPE" }, { "name": "LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "LINEDYEAR" }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "As-Built Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length" }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SLOPE" }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPELEV" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "FROMMH", "type": "esriFieldTypeString", "alias": "From Junction", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "FROMMH" }, { "name": "TOMH", "type": "esriFieldTypeString", "alias": "To Junction", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "TOMH" }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUMFLOW" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Pipes", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "OWNEDBY": 1, "LASTEDITOR": null, "FACILITYID": null, "PipedStream": null, "DIAMETER": null, "MATERIAL": null, "MAINSHAPE": null, "PipeLiner": null, "LINERTYPE": null, "LINEDYEAR": null, "Length": null, "SLOPE": null, "UPELEV": null, "INVINELEV": null, "DOWNELEV": null, "INVOUTELEV": null, "FROMMH": null, "TOMH": null, "SUMFLOW": null, "COMMENT": null, "MAINTBY": 1, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 5, "name": "Culverts", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "PW_Stormwater_Culvert", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1966967.4063762128, "ymin": 779662.1344370544, "xmax": 1979676.1667198092, "ymax": 807077.7820334733, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 112, 0, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Culvert ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "PipedStream", "type": "esriFieldTypeString", "alias": "Piped Stream?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PipedStream" }, { "name": "AsBuiltLength", "type": "esriFieldTypeDouble", "alias": "As-Built Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AsBuiltLength" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Pipe Shape", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINSHAPE" }, { "name": "LINEID", "type": "esriFieldTypeDouble", "alias": "Pipe Material", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINEID" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPELEV" }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNELEV" }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUMFLOW" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Culverts", "description": "", "prototype": { "attributes": { "INSTALLDATE": null, "OWNEDBY": 1, "FACILITYID": null, "PipedStream": null, "AsBuiltLength": null, "DIAMETER": null, "MAINSHAPE": null, "LINEID": null, "INVINELEV": null, "INVOUTELEV": null, "MATERIAL": null, "UPELEV": null, "DOWNELEV": null, "SUMFLOW": null, "COMMENT": null, "MAINTBY": 1, "LASTEDITOR": null, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 6, "name": "Curb and Gutter", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 15000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 5, "name": "PW_Stormwater_CurbGutter", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1968033.7903982997, "ymin": 778735.3177211434, "xmax": 1981057.1419762224, "ymax": 807161.193612054, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 137, 137, 68, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FullName", "type": "esriFieldTypeString", "alias": "Street Name", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "FullName" }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Street Maintenance", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Maint" }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Street Class", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Class" }, { "name": "Width", "type": "esriFieldTypeSmallInteger", "alias": "Street Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Width" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "GutterType", "type": "esriFieldTypeString", "alias": "Gutter Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "GutterType" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "In Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Out Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAINTBY" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "TransportationImpact", "type": "esriFieldTypeString", "alias": "TransportationImpact", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TransportationImpact" }, { "name": "CensusPriority", "type": "esriFieldTypeSmallInteger", "alias": "Census Block Priority", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CensusPriority" }, { "name": "GutterOutfall", "type": "esriFieldTypeString", "alias": "GutterOutfall", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "GutterOutfall" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Curb and Gutter", "description": "", "prototype": { "attributes": { "GutterOutfall": null, "FullName": null, "Maint": null, "Class": null, "Width": null, "FACILITYID": null, "GutterType": null, "INVINELEV": null, "INVOUTELEV": null, "OWNEDBY": null, "MAINTBY": null, "COMMENT": null, "LASTUPDATE": null, "LASTEDITOR": null, "TransportationImpact": null, "CensusPriority": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 7, "name": "Open Channels", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 14999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "Storm water open drains.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "PW_Stormwater_OpenChannel", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1966912.298546806, "ymin": 782846.9738678932, "xmax": 1980358.9274933934, "ymax": 807133.8832992315, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 215, 215, 158, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Open Channel ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "DrainageType", "type": "esriFieldTypeString", "alias": "Channel Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Ditch", "modelName": "DrainageType" }, { "name": "StreamChannel", "type": "esriFieldTypeString", "alias": "Stream Channel?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "No", "modelName": "StreamChannel" }, { "name": "TOPWIDTH", "type": "esriFieldTypeDouble", "alias": "Top Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOPWIDTH" }, { "name": "BOTWIDTH", "type": "esriFieldTypeDouble", "alias": "Bottom Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BOTWIDTH" }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH" }, { "name": "LEFTSLOPE", "type": "esriFieldTypeDouble", "alias": "Left Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LEFTSLOPE" }, { "name": "RIGHTSLOPE", "type": "esriFieldTypeDouble", "alias": "Right Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIGHTSLOPE" }, { "name": "UPTOP", "type": "esriFieldTypeDouble", "alias": "Upstream Top", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPTOP" }, { "name": "DWNTOP", "type": "esriFieldTypeDouble", "alias": "Downstream Top", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DWNTOP" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "ChannelShape", "type": "esriFieldTypeString", "alias": "ChannelShape", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ChannelShape" }, { "name": "ChannelLiner", "type": "esriFieldTypeString", "alias": "Channel Material", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ChannelLiner" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Open Channels", "description": "", "prototype": { "attributes": { "COMMENT": null, "OWNEDBY": 1, "DrainageType": "Ditch", "FACILITYID": null, "ChannelLiner": null, "StreamChannel": "No", "TOPWIDTH": null, "BOTWIDTH": null, "DEPTH": null, "LEFTSLOPE": null, "RIGHTSLOPE": null, "UPTOP": null, "DWNTOP": null, "INVINELEV": null, "INVOUTELEV": null, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "INSTALLDATE": null, "ChannelShape": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 8, "name": "SCMs", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 14999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "PW_Stormwater_SCM", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1961975.5000214726, "ymin": 771949.749927476, "xmax": 1980047.3733264655, "ymax": 807016.4908174723, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "SCM ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "DetentionType", "type": "esriFieldTypeString", "alias": "SCM Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DetentionType" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH" }, { "name": "WIDTH", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WIDTH" }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH" }, { "name": "SIDESLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SIDESLOPE" }, { "name": "VOLUME", "type": "esriFieldTypeDouble", "alias": "Volume", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VOLUME" }, { "name": "BEDMATERIAL", "type": "esriFieldTypeString", "alias": "Bed Material", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BEDMATERIAL" }, { "name": "BNKMATERIAL", "type": "esriFieldTypeString", "alias": "Bank Material", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BNKMATERIAL" }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert In Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERTELEV" }, { "name": "OUTFLWELEV", "type": "esriFieldTypeDouble", "alias": "Outflow Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTFLWELEV" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Condition" }, { "name": "AreaSF", "type": "esriFieldTypeDouble", "alias": "Area Sq Ft", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AreaSF" }, { "name": "MediaElev", "type": "esriFieldTypeDouble", "alias": "Media Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MediaElev" }, { "name": "WeirElev", "type": "esriFieldTypeDouble", "alias": "Weir Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WeirElev" }, { "name": "Permitted", "type": "esriFieldTypeString", "alias": "Permitted?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes & No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Permitted" }, { "name": "TownRegulated", "type": "esriFieldTypeString", "alias": "Town Regulated?", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "TownRegulated" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R333_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S188_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SCMs", "description": "", "prototype": { "attributes": { "LASTEDITOR": null, "Permitted": null, "TownRegulated": null, "FACILITYID": null, "DetentionType": null, "COMMENT": null, "LOCDESC": null, "LENGTH": null, "WIDTH": null, "DEPTH": null, "SIDESLOPE": null, "VOLUME": null, "BEDMATERIAL": null, "BNKMATERIAL": null, "INVERTELEV": null, "OUTFLWELEV": null, "LASTUPDATE": null, "OWNEDBY": 1, "INSTALLDATE": null, "Condition": null, "AreaSF": null, "MediaElev": null, "WeirElev": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 9, "name": "Virtual Drainage to Stream", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 15000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 1967914.8441138864, "ymin": 771963.4293620586, "xmax": 1981020.0475622267, "ymax": 806810.0079627335, "spatialReference": { "wkid": 102719, "latestWkid": 2264 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 150, 0, 255 ], "width": 0.5 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LASTEDITOR", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Drainline ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "Invert In Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Out Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVOUTELEV" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R340_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S195_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Virtual Drainage to Stream", "description": "", "prototype": { "attributes": { "LASTEDITOR": null, "FacilityID": null, "COMMENT": null, "INVINELEV": null, "INVOUTELEV": null, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.81, "id": 10, "name": "CulvertInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "swCulvert", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "PW.Stormwater.InspectRef", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ApproachRoad" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Embankment" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Channel" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EndTreatment" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Footing" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Barrel" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AquaticOrganism" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CulvertRating" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "CulvertInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "ApproachRoad": null, "Embankment": null, "Channel": null, "EndTreatment": null, "Footing": null, "Barrel": null, "AquaticOrganism": null, "CulvertRating": null, "MaintRequired": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 11, "name": "CurbGutterInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 5, "name": "swCurbGutter", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "ObstructedFt", "type": "esriFieldTypeInteger", "alias": "LengthObstructedFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ObstructedFt" }, { "name": "DamagedFt", "type": "esriFieldTypeInteger", "alias": "LengthDamagedFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DamagedFt" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "PW.Stormwater.InspectBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "CurbGutterInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "ObstructedFt": null, "DamagedFt": null, "Notes": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "Condition": null, "MaintRequired": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 12, "name": "InletInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "swInlet", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspectType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspectType" }, { "name": "InspTypeCamera", "type": "esriFieldTypeString", "alias": "InspTypeCamera", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspTypeCamera" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "name": "Blocked50Pct", "type": "esriFieldTypeString", "alias": "Blocked50PctOrMore", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Blocked50Pct" }, { "name": "ErosionThreshold", "type": "esriFieldTypeString", "alias": "ErosionGT6inWithin1ftOfInlet", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ErosionThreshold" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "InletInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspYear": null, "InspDate": null, "InspBy": null, "Inspector": null, "InspectType": null, "InspTypeCamera": null, "InspRef": null, "Blocked50Pct": null, "ErosionThreshold": null, "Condition": null, "MaintRequired": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 13, "name": "JunctionManholeInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "swManhole", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspectDate", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectDate" }, { "name": "InspectYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspectYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "ConditionStructure", "type": "esriFieldTypeString", "alias": "StructuralCondition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ConditionStructure" }, { "name": "Defects", "type": "esriFieldTypeString", "alias": "ConditionDefects", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Defects" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "JunctionManholeInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspectDate": null, "InspectYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "Condition": null, "MaintRequired": null, "Notes": null, "ConditionStructure": null, "Defects": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 14, "name": "OpenChannelInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "swOpenDrain", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "name": "BlockedGT50Pct_Ft", "type": "esriFieldTypeInteger", "alias": "Length(Ft)BlockedGT50Pct", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BlockedGT50Pct_Ft" }, { "name": "LengthErodedGT1Ft", "type": "esriFieldTypeInteger", "alias": "Length(Ft)ErodedGT1Ft", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LengthErodedGT1Ft" }, { "name": "DrivePipes", "type": "esriFieldTypeSmallInteger", "alias": "NumberDrivePipes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DrivePipes" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "OpenChannelInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "BlockedGT50Pct_Ft": null, "LengthErodedGT1Ft": null, "DrivePipes": null, "Condition": null, "MaintRequired": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 15, "name": "OutletInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "swDischargePoint", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "ScourDepthFt", "type": "esriFieldTypeDouble", "alias": "ScourDepthFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ScourDepthFt" }, { "name": "ScourLengthFt", "type": "esriFieldTypeDouble", "alias": "ScoutLengthFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ScourLengthFt" }, { "name": "ScourWidthFt", "type": "esriFieldTypeDouble", "alias": "ScourWidthFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ScourWidthFt" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "name": "Dissipator", "type": "esriFieldTypeString", "alias": "EnergyDissipator", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Dissipator" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "OutletInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "ScourDepthFt": null, "ScourLengthFt": null, "ScourWidthFt": null, "Notes": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "Dissipator": null, "Condition": null, "MaintRequired": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 16, "name": "PipeInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "swGravityMain", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "InspRef" }, { "name": "StructureCondition", "type": "esriFieldTypeString", "alias": "StructuralCondition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "StructureCondition" }, { "name": "Defects", "type": "esriFieldTypeString", "alias": "Defects", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Defects" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "PipeInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "Notes": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "StructureCondition": null, "Defects": null, "Condition": null, "MaintRequired": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "id": 17, "name": "SCMInspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "swDetention", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReviewFlag" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "InspYear", "type": "esriFieldTypeString", "alias": "InspectionYear", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "InspYear" }, { "name": "InspBy", "type": "esriFieldTypeString", "alias": "InspectedBy", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "InspBy" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "LeadInspector", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Inspector" }, { "name": "InspType", "type": "esriFieldTypeString", "alias": "InspectionType", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspType" }, { "name": "InspRef", "type": "esriFieldTypeString", "alias": "InspectionReference", "domain": { "type": "codedValue", "name": "PW.Stormwater.InspRefSCM", "description": "", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "InspRef" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaintRequired" }, { "name": "NextAction", "type": "esriFieldTypeString", "alias": "DoNext", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NextAction" }, { "name": "RelateID", "type": "esriFieldTypeGUID", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RelateID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SCMInspections", "description": "", "prototype": { "attributes": { "RelateID": null, "NextAction": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "Notes": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "Condition": null, "MaintRequired": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }