{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "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": 110, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{3730D1E1-9235-48BF-BF9A-13793B16B960}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -121841900, "ymin": -93659000, "xmax": 1981020.0475622267, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "dbebcda6c95f8a6b86f70ee43787aa8b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABKElEQVQ4jbXUPWqEQBQH8CdMI7EQFqwUi5RKIIiFlaTzBqlELxE9g+QS1jmBpXZBgwh2QhDtVgTTiASUDRYLu/ixOmz+lczj/eaNIyK4c9C/gbIscwDwioMQBOGHYfh1BZ5Op0cAeMcc7A0ArsFzKIo6qqp63KL4vj+0bft8uTYBOY77NQzjyfO8VUySJCjL8iNN03VwTFEUEAQBaJo2i8VxvP+WeZ4H0zQXG7uu2wfmeQ6u68LSCRiG2QeSJAksy87WqqpaagOsCWmaBkEQ9oGKooDjOLO1caPd7xA3aKmQpinYtr14KaqqbgdFUQTLslYnGT+rKIpug1mWPei6/gkb0jSNfBMchuFQ1/UBMIPOD33fJwihF0znewImSfIz/kBwJ5uA98ofR8NkMJdKObYAAAAASUVORK5CYII=", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": 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": "Inlet ID", "domain": null, "editable": false, "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "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": "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": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1302_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4984_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1159_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Inlets", "description": "", "prototype": { "attributes": { "Rim": null, "OWNEDBY": 1, "MAINTBY": 1, "INVOUTELEV": null, "InletLabel": null, "INLETTYPE": null, "DESCRIPTION": null, "InletStructure": null, "InletStandard": null, "INVERTELEV": null, "INVINELEV": null, "INVINELEV2": null, "INVINELEV3": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 20, "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": 120, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{F5AFB1BC-12DD-40C4-BDCD-A7A496592EB2}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1961990.14238064, "ymin": 771963.4293620586, "xmax": 1980980.757286474, "ymax": 807006.2296831459, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "197b7d9a36f025f8eb7b56b38d813444", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACkUlEQVQ4jbWUzUsbURTFzyQzyQRrm5SQGj/aRUDjpipIV1lMQGmpcaEQQhdVcFFxJyIWFJHWdSD4B0gIqZBF2i6kVAkSbUEXLpJN0EgDjUGqRe0oTmYkzpQZk6DJExe1ZzP3zLvv93j3Xh6NOxb9P4FNAHwV6zoAjwFYAOgBHALIArioyIsD2KwEOmw22zufzyeqRpIkKhKJ3Od5XgWVxbKs4vV6ebPZLKt+aWmJSqfTIAHhcDgu5ubmHpb84OAg3G43zs/PyzmhUIjyer3mkh8aGjooAquufE17e3uYnp5CW5sTnZ1O0LQeqdQuZmffw263w+Vy3VpDiKJIqd9UKgWP5yUmJvrAcU+vbdja+oWBgdeIRj+io6MD+/v7zI3ATCbDjo+PY3n5K0ZGXlTBVDmddfD7hzE8/AZ9ff2IxWIPis2rAtInJye03++H3W6Dx/PspmqgtfURTCYGk5OTKMKekIB1iqJoQXNzIyhKu/2NamlpwtraesnaSMBCKRBFCbdJELTpKumCBDzQ6/UKwzBUOp3D2ZmImhoWJMmygvX1JGpra3F6eqrtJQFli8VSCAaDzMbGdwQCnzA19YoIXFj4hvr6RkSjn8FxXIHn+V0SUB1ssaenh+nu7gbHuTAzE8LoaD8slnvauiBImJ+PYXMzi8XFL7Barejt7T0Oh8MKEajTXXbfYDBgZWUNgYAfXV1v0dBg0wY7k8lhbGwMq6sfYDQatVyGYcqwKuBVsSwLg8EEQchjZ+dn+f/R0XEZRhJ91SQSCWN7ezuvxoVCgcrlciadTkfLslyeoWAwKMfjcYFlWa2z2Wz2sh4EYCKfzz9PJpOkQxsAmAD8liTpcHt7uzLnBwn4p/iu/ZPu/MX+C4j23oWil4ElAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": 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": "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "AVGDISCH", "type": "esriFieldTypeString", "alias": "Average Discharge", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AVGDISCH" }, { "name": "PEAKDISCH", "type": "esriFieldTypeString", "alias": "Peak Discharge", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PEAKDISCH" }, { "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": "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": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R1299_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4981_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1156_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "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, "AVGDISCH": null, "PEAKDISCH": null, "PERMIT": null, "INSTALLDATE": null, "MAINTBY": 1, "Priority": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 30, "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": 130, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{59CEDF68-8AD4-4B77-8616-869D89A87CF2}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1962938.8553782254, "ymin": 779028.3479749709, "xmax": 1980435.4768809676, "ymax": 802798.03731215, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "e75e1fab052753e666eceaa7ca448d07", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEzUlEQVRIie2WfUxTVxjGn3Nb+0FbvgqhIDqME6V3oh1fmdMJRdRhcJoBjqHZxpa5GWa3afzDYMziZJqZwIxsiSyLARwubMShwyibomMgMFagVo0KiAKtgiKUFrjtvXdpp5UaOxlblv2xJzk5uc897/nlvCfvmyPEvyjh/7CEhARfh8OxhBASLhTy/ixL3QbQabPZGoxGI/OPpDE+Pj5WSNh8B8dqCSECp+dwEAC867+fXGxfkzK/xjTss7GxsbFnSrDExEShxWLZx3Hc5mB/hn95YT/13KwhtPbIsbfmKRx7px2mIRHOXfOfVmUITiW8vTs7VZ13uPriJ38JRtO0yGodOS6gkJy7tIe8GnuLCKg/TnKhT+aaZSIWmhkjrvHW8yYUnplBHW0Lyl+/Sq0u++HihknDpFLplwCfDIAK9WPwAORNMhGLML9xEAJcvuWz/vXVUVcOVV3a9URYXFxcJs/zG7Ytu4GRcSHyjs2CkOKQOOeeV1hJowpf/Dwd25dfh75HgZpLAR+lajUl1af13V5hGRkZgq6urny1ymZN1/S78jXuINheNRufrr0GLmARTpnkALpQYtIhc2EvTv14FgfOhWPbsm6sWTAA7dxBnL3qTwJ9xksBvOAV1tHRsYiiqNkbF/e6vY2L+8CwFD74LhLh4RJkZWUgPVsJg8GAdXv0sFjCsTX5JtI1/a71vhIWL0UPoLIteJHz7ieWhQeMoqiV0wQ8Ex8xLJroB4XORnT00ygqKoJYLHZ5Wq0WKSkpyM3NxbIVq4CBr9zrl865h69/DRHQM7HCaMQxb3c2SylnRkYZKnCiWdEkQf7erW7QA6nVaqSlpaHSMIxXAlwl6FKo77hr9hezMYB3WJB5SByo3a/xMClqEJGRkXicoqKisGPHDhyEZ4xTPEHYxO9HYUNKmd2iS+pRTDT3naVhNpsRFuYR65LJZIJ2SSwS/Srcnp0l2HUiAhxHbnuF8Tzfa2Mo8qL6jseG7cNSFBcXY+fOnR7+3bt3UV5ejs90akTZHsZcvS11zYOjAoNXGCHkzKhdoLva74M5wTa3H8hewMHjdzA2NoacnBwolUq0t7ejoKAA1hEL7J1lgOrhPr90+jsbAd87JDvxZyerIYQMHTof6tid1qF0emXNKhTXh0KX1AOr9Aq2fKiDydyPBc/Mg25tMM7XGfDekZk4kDmG+WFWVworW4MQomAMVT+1DHuFtbS02GJiYvbUXA74OCtGhrZeOfbXOuvoBjKfdaa/EiFMEHabI1CgLYdCwiJpOeDgIrC5IhJF666gvtMPZosYYgH/9hPblUKhKLRarenvfjOPHrMTyRY36PFy9sO8ldfBcgSbjkRi1E4hWGYvq65ta3wirLa2dkyj0azmeUGDVMSFqFU2z+J6jCgCqFVWVBuVCPBxNNkQ8Maku75er++Li4tLGGWo7988PDd2edQgkxVzS0KHWj3WOdtYfacvSptUaO+Vw1fi+Lbvjj3baKx1TBrmVHNzs5mm6SVSqXRTzeXAvFOXAiU+Is4uE7EUAMFrpWrWPCyi7CwhkmlcN8/z75+uaz065WfB/SZaSNP052KxOMnGUFrrOJlOCHxvDooHeJ7vIgQn6xp+a3a/E6YKewR68v6YsoR/J/g/Dfsdy3ziVC2sHvUAAAAASUVORK5CYII=", "contentType": "image/png", "width": 20, "height": 20, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[FacilityID]", "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 1800, "name": "Default", "priority": 8, "symbol": { "type": "esriTS", "color": [ 52, 52, 52, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 235, 175, 255 ], "haloSize": 1.75, "font": { "family": "Calibri", "size": 9, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": 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": "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "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": "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": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1303_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4985_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1160_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Junctions/Manholes", "description": "", "prototype": { "attributes": { "LINED": null, "OWNEDBY": 1, "MAINTBY": 1, "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 } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 40, "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": 140, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{3FC276C4-C39B-4CD9-93CB-973DB4D6ADE8}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 9.85014171898365, "ymin": 12.491311639547348, "xmax": 1980984.4121347964, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 3.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[DIAMETER] CONCAT \"\"\"-\" CONCAT [MATERIAL]", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "straight", "deconflictionStrategy": "dynamic", "allowOverrun": false, "repeatLabel": false, "removeDuplicates": "all", "removeDuplicatesDistance": 0, "lineConnection": "minimizeLabels", "lineOrientation": "direction", "allowOverlapOfFeatureInterior": "exclude", "stackLabel": false, "where": "\"DIAMETER\" NOT IN ( NULL, -99.98999786, -99)", "useCodedValues": false, "maxScale": 0, "minScale": 3000, "name": "Default", "priority": 9, "symbol": { "type": "esriTS", "color": [ 168, 112, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 244, 186, 255 ], "haloSize": 1, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "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": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()" }, { "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": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1301_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4983_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1158_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Pipes", "description": "", "prototype": { "attributes": { "COMMENT": null, "OWNEDBY": 1, "MAINTBY": 1, "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 } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 50, "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": 150, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{AB341C5C-D8D8-4B9A-908F-4C9EE4F35D26}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1966967.4063762128, "ymin": 779662.1344370544, "xmax": 1979676.1667198092, "ymax": 807077.7820334733, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 112, 0, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "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": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R1297_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4979_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1154_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culverts", "description": "", "prototype": { "attributes": { "COMMENT": null, "OWNEDBY": 1, "MAINTBY": 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 } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 60, "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": 5, "name": "PW_Stormwater_OpenChannel", "relatedTableId": 160, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{907B5576-DE4E-478B-92BD-B387FD2B3F74}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1966912.298546806, "ymin": 782846.9738678932, "xmax": 1980358.9274933934, "ymax": 807133.8832992315, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 215, 215, 158, 255 ], "width": 3 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": 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": "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "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": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R1305_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4987_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1162_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Open Channels", "description": "", "prototype": { "attributes": { "FACILITYID": null, "COMMENT": null, "DrainageType": "Ditch", "OWNEDBY": 1, "ChannelLiner": null, "StreamChannel": "No", "TOPWIDTH": null, "BOTWIDTH": null, "DEPTH": null, "LEFTSLOPE": null, "RIGHTSLOPE": null, "UPTOP": null, "DWNTOP": null, "INVINELEV": null, "INVOUTELEV": null, "MAINTBY": 1, "ChannelShape": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 70, "name": "Curb and Gutter", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 14999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "PW_Stormwater_CurbGutter", "relatedTableId": 170, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{24D21900-7C21-49EE-BEB3-FB85BC40BFB3}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1968033.7903982997, "ymin": 778735.3177211434, "xmax": 1981057.1419762224, "ymax": 807161.193612054, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "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": "OBJECTID" }, { "name": "FullName", "type": "esriFieldTypeString", "alias": "Street", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "FullName" }, { "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "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": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()" }, { "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": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1948_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_21210_FACILI", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1748_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Curb and Gutter", "description": "", "prototype": { "attributes": { "CensusPriority": null, "GutterOutfall": null, "FullName": null, "FACILITYID": null, "GutterType": null, "INVINELEV": null, "INVOUTELEV": null, "OWNEDBY": null, "MAINTBY": null, "COMMENT": null, "TransportationImpact": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 80, "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": 180, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{C238210C-6186-4925-899E-BF8EDB36B3CD}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": -121841900, "ymin": -93659000, "xmax": 1980047.3733264655, "ymax": 807026.9999828041, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSBackwardDiagonal", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "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": "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": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "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": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R1298_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1155_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCMs", "description": "", "prototype": { "attributes": { "OUTFLWELEV": null, "OWNEDBY": 1, "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, "MAINTBY": 1, "Permitted": null, "WeirElev": null, "Condition": null, "AreaSF": null, "MediaElev": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 90, "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, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1967914.8441138864, "ymin": 771963.4293620586, "xmax": 1981020.0475622267, "ymax": 806810.0079627335, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3.6365718124241434E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 150, 0, 255 ], "width": 0.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "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": "Drainline ID", "domain": null, "editable": false, "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": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "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": false, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "R1307_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1164_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Virtual Drainage to Stream", "description": "", "prototype": { "attributes": { "INVOUTELEV": null, "INVINELEV": null, "COMMENT": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 110, "name": "Inlet Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "swInlet", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{3730D1E1-9235-48BF-BF9A-13793B16B960}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1937_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1937", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21195_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21195_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1937", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Inlet Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 120, "name": "Outlet Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "swDischargePoint", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{F5AFB1BC-12DD-40C4-BDCD-A7A496592EB2}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1941_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1941", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21201_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21201_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1941", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Outlet Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 130, "name": "Junction/Manhole Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "swManhole", "relatedTableId": 30, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{59CEDF68-8AD4-4B77-8616-869D89A87CF2}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1938_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1938", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21198_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21198_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1938", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Junction/Manhole Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 140, "name": "Pipe Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "swGravityMain", "relatedTableId": 40, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{3FC276C4-C39B-4CD9-93CB-973DB4D6ADE8}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1947_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1947", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21207_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21207_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1947", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Pipe Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 150, "name": "Culvert Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "swCulvert", "relatedTableId": 50, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{AB341C5C-D8D8-4B9A-908F-4C9EE4F35D26}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1946_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1946", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21206_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21206_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1946", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 160, "name": "Ditch Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 5, "name": "swOpenDrain", "relatedTableId": 60, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{907B5576-DE4E-478B-92BD-B387FD2B3F74}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1939_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1939", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21199_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21199_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1939", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Ditch Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 170, "name": "Curb and Gutter Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "swCurbGutter", "relatedTableId": 70, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{24D21900-7C21-49EE-BEB3-FB85BC40BFB3}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1940_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1940", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21200_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21200_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1940", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Curb and Gutter Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 180, "name": "SCM Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "swDetention", "relatedTableId": 80, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{C238210C-6186-4925-899E-BF8EDB36B3CD}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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": "R1949_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_21221_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1949", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_21221_Relate", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1949", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCM Inspections", "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": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "28220e385eb049f29be196c38cfaf346" } ] }