{ "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": "Stormwater inlets typically found along the side or roads or in drainage swales.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "PW_Stormwater_Inlet", "relatedTableId": 110, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{C4E7759A-3604-4BE4-B158-B29DF86C7D7A}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041498000 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1962729.1202333868, "ymin": 778266.1159036458, "xmax": 1981020.0475622267, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "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": "2e7cb548fbd3f4932243b197e6b2d8ac", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEAUlEQVRIic2WXWhbZRjH/ydJl2XN6dq0Jj2n1NZtnLD1A+FEh7uwncNd+FEVL6QteKFsbDJcM8ELb8QLvdsXeCEqgsNar9cx0AuzIk6sOQM3HfakimXtOUvWZu3elBm29JXnzUmXNEkzZxH/8JJwcvL+zvO8z/N/jgf/oTz/P9gxrmEFKiRo4FBXr3MwuGDiDgx8KFn/DvYm1+GGLkD5zYWCLZBT82CQIINDhwc6otyChAs4IZn/HHaUDzmRoGvTVaVr09Vwu2dOa6jninSbAQHgL18LW1xpsg3/fuPHRIAeZghHuYnT0pf3D3NAra7r8jP13/R11s3odHlqqh4J5gZjAXFbOMxkVZ2Xn80mtC65w/iMvXpOPGCUH8RJ6ePaMAdE0fT7vusPuVNaPN6AeHwrLMtbcmssFoAs38XevWlEIjP6W42n1dFbr4xdX2lVEeXP46Q0Xh1GZ+RERKBcckkbjSkiompizIOzZ4PiYQ4duqYcVr469u7cyHviLI/wksIphVExcIBSRxHVAhXLsrwYHVUwPGzjNfnMcyKlbgwCOF4Oc8qb0kdnRKlbD+QP+rBtXxt6B7cj1BPA5bFpXB77HfH4skjpnpBpXkxqJo5wtRDdPZhT3lR19ElpWQ/04qdPCkhBvYM7xLoxuROY+hxtmFUBzUQdqLjWwJwyp/KmiNYWQ7GeGOkuARXroccfhhXzYlfPH33B3FNGagFK4bd7MMcZNruy/i2dCrbva0M1UQTrqaWvC+7EJXT3QPt2Aqwc5siLrMx9skjTg4pvkXHfTZ28ksbkOz9V3ezpDx6rCczCy1b9swxGFyXISysNdlvTvDL+0XTVjUI9Teum0jNrgvlaMrNzsOCqBCP35tBv5pqsTnVGIWeghq2kH079UhU2P/Erti7YqGvv9S/OIQPALofRmPBAP7+8f+KNxk90siByhkrKpG7ji4GvEeoOYM9IN+qDvtU+2/3Ib0AEuNbwqJn6GQx3YZTDqPGi3CJf+/NOh0GNWckPi8+VFkGoDeh7OEwNfQvL7b0sbncYkGBVtyuaRxxDZDVkquR1ZEG1LCvpgAYGboixE/O8cM6chg0XLhTfVwqjwUfzSIJG7v1645kDw8O2TNZFDl/pDFU1i0hkSUSUa1bwvfzSxKQB2sNYO0jL/02DL8oPUjrfT799gkyVUkqbUUppFaAUDcFI6eZd9nn+8rh5CTY4TJwqHS+VYSQafDSPOHRKKZmqvu1mf6j5iqKq9mof5ZpVpOHLpFojFp2RSB1FVAFUHZYHjot55MYguffFJExgN7Qdea9bXESmkcMvAAlx3tRTD/gOQspX0nExJvLurZiFXudgqQVhBPbGvF2VQmtutjGwDdLf0YTIgGyaYfEAAAAASUVORK5CYII=", "contentType": "image/png", "width": 20, "height": 20, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "FACILITYID", "type": "esriFieldTypeString", "alias": "Inlet ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERTELEV" }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "OFFICEDATE", "type": "esriFieldTypeDate", "alias": "OFFICEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OFFICEDATE" }, { "name": "PWID", "type": "esriFieldTypeDouble", "alias": "PWID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PWID" }, { "name": "DEVICEID", "type": "esriFieldTypeDouble", "alias": "DEVICEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEVICEID" }, { "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": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Rim", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rim" }, { "name": "INVINELEV2", "type": "esriFieldTypeDouble", "alias": "Invert in Elevation 2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV2" }, { "name": "INVINELEV3", "type": "esriFieldTypeDouble", "alias": "Invert In Elevation 3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV3" }, { "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": "InletLabel", "type": "esriFieldTypeInteger", "alias": "Inlet Label", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InletLabel" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_99", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G175FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S48_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Inlets", "description": "", "prototype": { "attributes": { "InletLabel": null, "FACILITYID": null, "INSTALLDATE": null, "INLETTYPE": null, "INVERTELEV": null, "OWNEDBY": 1, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "OFFICEDATE": null, "PWID": null, "DEVICEID": null, "INVINELEV": null, "INVOUTELEV": null, "DESCRIPTION": null, "InletStandard": null, "Rim": null, "INVINELEV2": null, "INVINELEV3": null, "InletStructure": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "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": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "PW_Stormwater_Outlet", "relatedTableId": 120, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{9B26FC04-B298-4CF0-9BBF-DF7E235BD038}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041474000 }, "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": false }, "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": 3048.0060960121928, "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": "24d492c1fc563295b6743b1a91f75b6e", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADuElEQVRIic1WT0gUcRh9Gwu1uaaJqbtFB/8kke7BxqIgo0Q6lFIQ2lLdQr1Ynb15qEMdqluJxyTaQ4ZZFGJWZBGtHlQiLbcQdzfNtHJFEXXifTu/dXZd/1VEHyy7Mzvze/Pe733vGyv+YVn/OzD9LkoB7IYFx+R7oYIAHgCot5Sj84/AdA8qAfmYAczlMP6v1D3ohI46S4WArw1M98hNZILgtBMfQrnoD+UiNJuIidnEMNKGgHwOprbDbp0g82bdgxZLuSixOjAFxIWfjx5C13dNzvvHU7Flz3boGxMx3DOGuQQHgt+c8n9BshdHM5p52THdA6+lHNqKYAqIbF6MHhI2Xu8mzOQUYNf5A5gyrktyASEAn1r6MNv6GNA0UeDUtkZhqXtwy1KOqiXBjD0SRgR61u9Ce3sK+voSAAzBttOPzOKtket9bX401XQBSIPXm4TqaqDhczUuZl+FsY9RxollRjCRjowUkD3NJiAJaTZ03/mIyZFpZB52Ij0/BS53tpwLBNajsdGB06eBh1/KlKRUybkITNmbUnAPKB2BuGDJpUL4ngZwu+xJ5KleXe+R75LLhTjjPiL/8XreR0m5h44NAYfuwW7FzsxM7E3Xsd4PZgCYx/4Leei+MyBPH69aa98KoGI4uC4fGjpk/+hUQ62qaLBww4p8s9t2oLSpAq9v9EakW65aa9+i+s1xTI5MofhaEeYe+SIONffoImY0x7zNLif2CavlgVSxFY43FMnvuZRwS5jXjQWTYsOyj1T52kSKFSs0opoCUfevKRsp42oqPS8l6jjROmHOz0VgPOngpg4N9QOusCQud9aqpfS1hfvQOtSvzMEKxANjT1TyIurNZLhX04UzzUeQVbwVA23+JUFKLhdiuHdMjHLySg5c00HYkyPM4jZ1PcEYqnSSRBDSxJHceC4UjyEtz4dpOvdCjmdedoCpaDhRrRsNxsbjmGCuyYUaGztJGLFhTzQUiaRkMNwzDnu6TVKExQehG3NzJ6FpP1VDC6ul40pHHccEo4ZNyaxjBPX1ADf33jcAswH3wh4pRgQqK/sqIEZUhdczVRQYBx/nEcOY6c1QZdYxgpgM5hBm8fjA2VRs/vFOGBGI9yn5YgfpIutz8HEeUU6mN0OVkjKCmAxsWNVHdF1JTtjZpnnGaokdL3HBDECN84iG4QJcSAW0Sgb2EZnQdaY9CjOKA7QkmAFYxXnElmB6czGTw+JV52+/gxiAdJKTY8L04qOyjvqRTudfebuKAY0rzVrqn76k/gImJa+tkWFApAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 20, "height": 20, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "Outfall ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "AVGDISCH", "type": "esriFieldTypeString", "alias": "Average Discharge", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AVGDISCH" }, { "name": "DISCHID", "type": "esriFieldTypeString", "alias": "Outfall Label", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DISCHID" }, { "name": "DISCHRGTYP", "type": "esriFieldTypeString", "alias": "Outfall 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": "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": "PERMITID", "type": "esriFieldTypeString", "alias": "Permit Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PERMITID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROTATION" }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Pipe Diameter", "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeDiameter", "description": "", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1-1/4\"", "code": 1.25 }, { "name": "1-1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "OFFICEDATE", "type": "esriFieldTypeDate", "alias": "OFFICEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OFFICEDATE" }, { "name": "PWID", "type": "esriFieldTypeDouble", "alias": "PWID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PWID" }, { "name": "DEVICEID", "type": "esriFieldTypeDouble", "alias": "DEVICEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEVICEID" }, { "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": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "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": "OutfallStructure", "type": "esriFieldTypeString", "alias": "Outfall 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": "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "UUID_96", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G172FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S45_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Outlets", "description": "", "prototype": { "attributes": { "EnergyDissipator": null, "FACILITYID": null, "AVGDISCH": null, "DISCHID": null, "DISCHRGTYP": null, "PEAKDISCH": null, "PERMIT": null, "PERMITID": null, "INSTALLDATE": null, "LOCDESC": null, "ROTATION": null, "DIAMETER": null, "OWNEDBY": 1, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "OFFICEDATE": null, "PWID": null, "DEVICEID": null, "INVINELEV": null, "INVOUTELEV": null, "DESCRIPTION": null, "Priority": null, "StreamOrigin": null, "OutfallStructure": null, "SCMType": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "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": "Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "PW_Stormwater_JunctionManhole", "relatedTableId": 130, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{C49E0161-72AB-4918-B17A-493F004CE5BA}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041518000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1962938.8553782254, "ymin": 779028.3479749709, "xmax": 1980435.4768809676, "ymax": 802797.7171028107, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "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": "9d8e167e7a92f5a02df2a3495d721916", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB2ElEQVQ4jX2TsY7iMBCGRyiCF4AiiB6olxZFPMBFgo4XyNJS0FDEsQs6RMulp4XirqegzdZAj0IBXR6A02dhlNu9vZGsWLb/f/6Z+ePJfyJJkubzm3/3xvt8YIx5E5GIVRSFO+OTsuI4/viWQGud5HmusiyT8/ksjoDo9XpREAQ/tNapUir5QqC1Tq7Xq9psNtJqtWQ8HsvxeJRGoyGdTkd2u50sl0t/MpkoY4wfx/H7i8AY80ZmwGQdDocyGo1ksVhYcvb3+90Srtdrmc1mkTHGluM9BUTIJjNgB7zdbhaYpqldq9XKfvf7vYRh+JPKPEdAzcgmGwFJFEVSr9ftHnC/37cqIAnD0E7IY1TIZnHJYzJDBAFxOp1ku93K4XCwd0RRFD5YrzwFGkYgu9vtvs5pogNyR9RqNalUKj4K8uec7UMyk2k6ndrHlIDk+Xxu79hfLhepVqvXchNT5swlKgC7hqEEMKVBSCntdhvMr7IPUkySZZkPGAAN43F5jBA2m01MJY/H4/eLII7jDxyGSZgzpqFxgFxWygI8GAzE932tlPpLgWBPHIZJmLPLTlAzsoMgcOCvVn4qecdhmIQ5Myq6TcOoGdku8z8JXDk4jD1zZlSf/8By/AGQpyFh4x+OWQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "FACILITYID", "type": "esriFieldTypeString", "alias": "Junction ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HIGHELEV" }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERTELEV" }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert Elevation 2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT" }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIMELEV" }, { "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": "WALLMAT", "type": "esriFieldTypeString", "alias": "Manhole 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": "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": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Manhole Pavement Cut Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CUTDEPTH" }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "domain": { "type": "codedValue", "name": "PW.YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LINED" }, { "name": "GPSDATE", "type": "esriFieldTypeDate", "alias": "GPS Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "GPSDATE" }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "PWID", "type": "esriFieldTypeDouble", "alias": "PWID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PWID" }, { "name": "DEVICEID", "type": "esriFieldTypeDouble", "alias": "DEVICEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEVICEID" }, { "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": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "PWLabel", "type": "esriFieldTypeInteger", "alias": "PW Label", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PWLabel" }, { "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": "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_102", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G178FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S51_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": { "JunctionType": null, "FACILITYID": null, "INSTALLDATE": null, "HIGHELEV": null, "INVERTELEV": null, "INVERT": null, "RIMELEV": null, "CVTYPE": null, "WALLMAT": null, "MHTYPE": null, "LOCDESC": null, "CUTDEPTH": null, "LINED": null, "GPSDATE": null, "OWNEDBY": 1, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "PWID": null, "DEVICEID": null, "INVINELEV": null, "INVOUTELEV": null, "DESCRIPTION": null, "Standard": null, "PWLabel": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 40, "name": "Clean Outs", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041492000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1962977.5652745515, "ymin": 785854.2601761371, "xmax": 1978805.945691213, "ymax": 792066.4131061435, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "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": "b023a19499b1e59e83b613d4ca631538", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABeElEQVQ4ja2UsU6DUBSG/6GDcTDppBAHJQ6mdbsdfAAXDbjhrMsl8QUcC4uTL0AX3ZroJjyAmw5l7GITmmgKg4ODmrBpDqQFLhdr1T9huZz78f/nXG4D/6jGD+tUANGfYeY63L1V8ItH+KM3GL+Fsf012Gfb0FkT4Br0kwEGV2Mc1rmsg3G7DbfbKi9edsA2ljGxh7AA9ObBUjenW9B1Rf6VbgvQFbjmPfj4A506GDvehHu+A6Ys1fidFjaB8ADs6AHRzXMKjIoww2W45RoW0vUuFGcljz2F6QYNXyIrAIJXgN6LPSRRO+xhenRmzhwvAhed9cLsIRGQ4nOhhtYBeEVY1H9CwDUwSeFMcYKKaB+VFmG4e0EQJ+Xm2+3cGTVdnHCcpPt82TQrUQn8aQJ+nMHEKXtRHlGESaOS6s5cvxBRhKVRKZF8qzRi8N0f4PTC6lRlCrLhlH4pEZZGNdT57kbviIsRZTCybqledgjnqHJzyG6NUlMX0ReOuX4etv5ZGQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "Cleanout ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "ACCESSDIAM", "type": "esriFieldTypeDouble", "alias": "Access Diameter", "domain": { "type": "range", "name": "PW.Stormwater.AccessDiameter", "description": "", "range": [ 0, 72 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 24, "modelName": "ACCESSDIAM" }, { "name": "ACCESSMAT", "type": "esriFieldTypeString", "alias": "Access Material", "domain": { "type": "codedValue", "name": "PW.Stormwater.PipeMaterial", "description": "", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Brick", "code": "BR" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Earthen", "code": "EAR" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Does Not Exist", "code": "DoesNotExist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ACCESSMAT" }, { "name": "ACCESSTYPE", "type": "esriFieldTypeString", "alias": "Access Type", "domain": { "type": "codedValue", "name": "PW.Stormwater.AccessType", "description": "", "codedValues": [ { "name": "Door", "code": "Door" }, { "name": "Grate", "code": "Grate" }, { "name": "Cover", "code": "Cover" }, { "name": "Hand", "code": "Hand" }, { "name": "Lid", "code": "Lid" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Cover", "modelName": "ACCESSTYPE" }, { "name": "INTDEPTH", "type": "esriFieldTypeDouble", "alias": "Interior Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INTDEPTH" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "DEVICETYPE", "type": "esriFieldTypeString", "alias": "Cleanout Type", "domain": { "type": "codedValue", "name": "PW.Stormwater.CleanoutTypes", "description": "", "codedValues": [ { "name": "Cleanout", "code": "Cleanout" }, { "name": "Flushing Structure", "code": "Flushing Structure" }, { "name": "Lamp Hole", "code": "Lamp Hole" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": "Cleanout", "modelName": "DEVICETYPE" }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROTATION" }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.EditBy", "description": "List of editors for stormwater field data", "codedValues": [ { "name": "Randy Dodd", "code": "Dodd" }, { "name": "Emily Cochran", "code": "Cochran" }, { "name": "Evan Crane", "code": "Crane" }, { "name": "Heather Holley", "code": "Holley" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "UUID_98", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S47_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Clean Outs", "description": "", "prototype": { "attributes": { "LASTEDITOR": null, "FACILITYID": null, "ACCESSDIAM": 24, "ACCESSMAT": null, "ACCESSTYPE": "Cover", "INTDEPTH": null, "INSTALLDATE": null, "DEVICETYPE": "Cleanout", "ROTATION": null, "OWNEDBY": 1, "MAINTBY": 1, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 50, "name": "Pipes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 19000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "PW_Stormwater_Pipe", "relatedTableId": 140, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{9227718D-9547-43A8-9CE6-E5C7EC65226B}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041459000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1962729.1202333868, "ymin": 775648.00007689, "xmax": 1980984.4121347964, "ymax": 807172.1624221504, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "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": [ 0, 230, 169, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "FACILITYID", "type": "esriFieldTypeString", "alias": "Pipe ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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": "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": "LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "LINEDYEAR" }, { "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": "FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "FROMMH" }, { "name": "TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "TOMH" }, { "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": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUMFLOW" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNELEV" }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPELEV" }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SLOPE" }, { "name": "OFFICEDATE", "type": "esriFieldTypeDate", "alias": "OFFICEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OFFICEDATE" }, { "name": "LINEID", "type": "esriFieldTypeDouble", "alias": "LINEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINEID" }, { "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": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "As-Built Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length" }, { "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": "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "OPRI_Class", "type": "esriFieldTypeSmallInteger", "alias": "OPRI Class", "domain": { "type": "codedValue", "name": "PW_Stormwater_OPRI_Class", "description": "NASSCO overall rating index", "codedValues": [ { "name": "1 - very good condition", "code": 1 }, { "name": "2 - good condition", "code": 2 }, { "name": "3 - monitor / schedule rehab", "code": 3 }, { "name": "4 - poor, plan rehab", "code": 4 }, { "name": "5 - critical, high priority", "code": 5 }, { "name": "0 - no issue", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPRI_Class" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_94", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G170FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S43_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Pipes", "description": "", "prototype": { "attributes": { "InspectionDate": null, "FACILITYID": null, "INSTALLDATE": null, "MATERIAL": null, "DIAMETER": null, "MAINSHAPE": null, "LINEDYEAR": null, "LINERTYPE": null, "FROMMH": null, "TOMH": null, "OWNEDBY": 1, "MAINTBY": 1, "SUMFLOW": null, "LASTUPDATE": null, "LASTEDITOR": null, "DOWNELEV": null, "UPELEV": null, "SLOPE": null, "OFFICEDATE": null, "LINEID": null, "INVINELEV": null, "INVOUTELEV": null, "COMMENT": null, "OPRI_Class": null, "Length": null, "PipedStream": null, "PipeLiner": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "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": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "PW_Stormwater_OpenChannel", "relatedTableId": 150, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{A0401F67-72FD-4110-AEC7-565B89FBDBA3}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041467000 }, "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": false }, "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": 3048.0060960121928, "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": [ 0, 169, 230, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "Channel ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "OWNEDBY" }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "PW.AssetOwner", "description": "Carrboro-State-Private-Other", "codedValues": [ { "name": "Carrboro", "code": 1 }, { "name": "State", "code": 2 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MAINTBY" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LINEID", "type": "esriFieldTypeDouble", "alias": "LINEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINEID" }, { "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": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "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": "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": "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "UUID_95", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G171FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S44_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": { "ChannelShape": null, "FACILITYID": null, "INSTALLDATE": null, "TOPWIDTH": null, "BOTWIDTH": null, "DEPTH": null, "LEFTSLOPE": null, "RIGHTSLOPE": null, "UPTOP": null, "DWNTOP": null, "OWNEDBY": 1, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "LINEID": null, "INVINELEV": null, "INVOUTELEV": null, "COMMENT": null, "ChannelLiner": null, "StreamChannel": "No", "DrainageType": "Ditch" } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 70, "name": "Culverts", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 5, "name": "PW_Stormwater_Culvert", "relatedTableId": 160, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{24F5E9F2-04D2-43B7-88FD-E4EA24CCF313}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041452000 }, "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": false }, "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": 3048.0060960121928, "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": [ 205, 137, 102, 255 ], "width": 2.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "Culvert ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "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": "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": "Culvert 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": "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": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUMFLOW" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNELEV" }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPELEV" }, { "name": "OFFICEDATE", "type": "esriFieldTypeDate", "alias": "OFFICEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OFFICEDATE" }, { "name": "LINEID", "type": "esriFieldTypeDouble", "alias": "LINEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINEID" }, { "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": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "AsBuiltLength", "type": "esriFieldTypeDouble", "alias": "As-Built Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AsBuiltLength" }, { "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "UUID_93", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G169FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S42_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culverts", "description": "", "prototype": { "attributes": { "AsBuiltLength": null, "FACILITYID": null, "INSTALLDATE": null, "MATERIAL": null, "DIAMETER": null, "MAINSHAPE": null, "OWNEDBY": 1, "MAINTBY": 1, "SUMFLOW": null, "LASTUPDATE": null, "LASTEDITOR": null, "DOWNELEV": null, "UPELEV": null, "OFFICEDATE": null, "LINEID": null, "INVINELEV": null, "INVOUTELEV": null, "COMMENT": null, "PipedStream": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 80, "name": "Curb and Gutter", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 19000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "PW_Stormwater_CurbGutter", "relatedTableId": 170, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{D8171A98-CD20-42CC-802C-7D7D8DAB03F3}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041483000 }, "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": false }, "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": 3048.0060960121928, "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": [ 197, 0, 255, 255 ], "width": 2 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StreetID", "type": "esriFieldTypeSmallInteger", "alias": "StreetID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StreetID" }, { "name": "DirPrefix", "type": "esriFieldTypeString", "alias": "DirPrefix", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DirPrefix" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "Name" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Type" }, { "name": "DirSuffix", "type": "esriFieldTypeString", "alias": "DirSuffix", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "DirSuffix" }, { "name": "FullName", "type": "esriFieldTypeString", "alias": "FullName", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "FullName" }, { "name": "LeftFrom", "type": "esriFieldTypeSmallInteger", "alias": "LeftFrom", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LeftFrom" }, { "name": "LeftTo", "type": "esriFieldTypeSmallInteger", "alias": "LeftTo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LeftTo" }, { "name": "RightFrom", "type": "esriFieldTypeSmallInteger", "alias": "RightFrom", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RightFrom" }, { "name": "RightTo", "type": "esriFieldTypeSmallInteger", "alias": "RightTo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RightTo" }, { "name": "LeftZip", "type": "esriFieldTypeString", "alias": "LeftZip", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "LeftZip" }, { "name": "RightZip", "type": "esriFieldTypeString", "alias": "RightZip", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RightZip" }, { "name": "LeftMailCity", "type": "esriFieldTypeString", "alias": "LeftMailCity", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LeftMailCity" }, { "name": "RightMailCity", "type": "esriFieldTypeString", "alias": "RightMailCity", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RightMailCity" }, { "name": "Jurisdiction_R", "type": "esriFieldTypeString", "alias": "Jurisdiction_R", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Jurisdiction_R" }, { "name": "Jurisdiction_L", "type": "esriFieldTypeString", "alias": "Jurisdiction_L", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Jurisdiction_L" }, { "name": "SegmentID", "type": "esriFieldTypeInteger", "alias": "SegmentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SegmentID" }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maint", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Maint" }, { "name": "Surface", "type": "esriFieldTypeString", "alias": "Surface", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "Surface" }, { "name": "RightSpeed", "type": "esriFieldTypeSmallInteger", "alias": "RightSpeed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RightSpeed" }, { "name": "LeftSpeed", "type": "esriFieldTypeSmallInteger", "alias": "LeftSpeed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LeftSpeed" }, { "name": "Direction", "type": "esriFieldTypeSmallInteger", "alias": "Direction", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Direction" }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Class", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Class" }, { "name": "Curb", "type": "esriFieldTypeString", "alias": "Curb", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Curb" }, { "name": "Width", "type": "esriFieldTypeSmallInteger", "alias": "Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Width" }, { "name": "Miles", "type": "esriFieldTypeDouble", "alias": "Miles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Miles" }, { "name": "Cross1", "type": "esriFieldTypeString", "alias": "Cross1", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "Cross1" }, { "name": "Cross12", "type": "esriFieldTypeString", "alias": "Cross12", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "Cross12" }, { "name": "Cross2", "type": "esriFieldTypeString", "alias": "Cross2", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "Cross2" }, { "name": "Cross22", "type": "esriFieldTypeString", "alias": "Cross22", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "Cross22" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 54, "defaultValue": null, "modelName": "Comments" }, { "name": "Symbology", "type": "esriFieldTypeString", "alias": "Symbology", "domain": null, "editable": true, "nullable": true, "length": 18, "defaultValue": null, "modelName": "Symbology" }, { "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": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "TransportationImpact", "type": "esriFieldTypeString", "alias": "TransportationImpact", "domain": { "type": "codedValue", "name": "PW.Stormwater.TransportationImpact", "description": "", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "High", "code": "High" }, { "name": "Lowest", "code": "Lowest" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Highest", "code": "Highest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TransportationImpact" }, { "name": "CensusPriority", "type": "esriFieldTypeSmallInteger", "alias": "Census Block Priority", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CensusPriority" }, { "name": "GutterOutfall", "type": "esriFieldTypeString", "alias": "GutterOutfall", "domain": { "type": "codedValue", "name": "PW.Stormwater.GutterOutfall", "description": "", "codedValues": [ { "name": "Pipe", "code": "Pipe" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Gutter", "code": "Gutter" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "GutterOutfall" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_97", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G173FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S46_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": { "GutterOutfall": null, "StreetID": null, "DirPrefix": null, "Name": null, "Type": null, "DirSuffix": null, "FullName": null, "LeftFrom": null, "LeftTo": null, "RightFrom": null, "RightTo": null, "LeftZip": null, "RightZip": null, "LeftMailCity": null, "RightMailCity": null, "Jurisdiction_R": null, "Jurisdiction_L": null, "SegmentID": null, "Maint": null, "Surface": null, "RightSpeed": null, "LeftSpeed": null, "Direction": null, "Class": null, "Curb": null, "Width": null, "Miles": null, "Cross1": null, "Cross12": null, "Cross2": null, "Cross22": null, "Comments": null, "Symbology": null, "FACILITYID": null, "GutterType": null, "INVINELEV": null, "INVOUTELEV": null, "OWNEDBY": null, "MAINTBY": null, "COMMENT": null, "LASTUPDATE": null, "LASTEDITOR": null, "TransportationImpact": null, "CensusPriority": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 90, "name": "SCMs", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 14999, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "PW_Stormwater_SCM", "relatedTableId": 180, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{4BC00B7C-2A52-4F36-86A0-94719D236755}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041505000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1961975.5000214726, "ymin": 771949.749927476, "xmax": 1980047.3733264655, "ymax": 807016.4908174723, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "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": "esriSFSSolid", "color": [ 190, 255, 232, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 230, 169, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "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": "Side 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": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": { "type": "codedValue", "name": "PW.Stormwater.FeatureStatus", "description": "", "codedValues": [ { "name": "Present Not Functioning", "code": "Not Functioning" }, { "name": "Disconnected", "code": "Disconnected" }, { "name": "Category Change (Different Feature Type)", "code": "Category Change" }, { "name": "Does Not Exist", "code": "Does Not Exist" }, { "name": "Clarify Status with Inspector", "code": "Clarify Status" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "BMPID", "type": "esriFieldTypeString", "alias": "BMPID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BMPID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "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": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENT" }, { "name": "AreaSF", "type": "esriFieldTypeDouble", "alias": "Area Sq Ft", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AreaSF" }, { "name": "MediaElev", "type": "esriFieldTypeDouble", "alias": "SCM 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": "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": "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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "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()" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "UUID_100", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S49_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCMs", "description": "", "prototype": { "attributes": { "Permitted": null, "FACILITYID": null, "INSTALLDATE": null, "LOCDESC": null, "LENGTH": null, "WIDTH": null, "DEPTH": null, "SIDESLOPE": null, "VOLUME": null, "BEDMATERIAL": null, "BNKMATERIAL": null, "INVERTELEV": null, "OUTFLWELEV": null, "OWNEDBY": 1, "MAINTBY": 1, "LASTUPDATE": null, "LASTEDITOR": null, "BMPID": null, "TownRegulated": null, "DetentionType": null, "COMMENT": null, "AreaSF": null, "MediaElev": null, "WeirElev": null, "Condition": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 100, "name": "Virtual Drainage to Stream", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 15000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777046258000 }, "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": false }, "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": 3048.0060960121928, "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": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LASTEDITOR", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "OFFICEDATE", "type": "esriFieldTypeDate", "alias": "OFFICEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OFFICEDATE" }, { "name": "LINEID", "type": "esriFieldTypeDouble", "alias": "LINEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINEID" }, { "name": "INVINELEV", "type": "esriFieldTypeDouble", "alias": "INVINELEV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVINELEV" }, { "name": "INVOUTELEV", "type": "esriFieldTypeDouble", "alias": "INVOUTELEV", "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "indexes": [ { "name": "UUID_104", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S52_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": { "LASTUPDATE": null, "OFFICEDATE": null, "LINEID": null, "INVINELEV": null, "INVOUTELEV": null, "COMMENT": null, "LASTEDITOR": null, "FacilityID": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 110, "name": "Inlet Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "swInlet", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{C4E7759A-3604-4BE4-B158-B29DF86C7D7A}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041409000 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_85", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G160RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G160FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Inlet Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 120, "name": "Outlet Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "swDischargePoint", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{9B26FC04-B298-4CF0-9BBF-DF7E235BD038}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041425000 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_88", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G163RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G163FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Outlet Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 130, "name": "Junction/Manhole Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "swManhole", "relatedTableId": 30, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{C49E0161-72AB-4918-B17A-493F004CE5BA}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041397000 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_83", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G158RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G158FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Junction/Manhole Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 140, "name": "Pipe Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "swGravityMain", "relatedTableId": 50, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{9227718D-9547-43A8-9CE6-E5C7EC65226B}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041431000 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_89", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G164RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G164FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Pipe Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 150, "name": "Ditch Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "swOpenDrain", "relatedTableId": 60, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{A0401F67-72FD-4110-AEC7-565B89FBDBA3}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041437000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_90", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G165RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G165FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Ditch Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 160, "name": "Culvert Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 5, "name": "swCulvert", "relatedTableId": 70, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{24F5E9F2-04D2-43B7-88FD-E4EA24CCF313}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041403000 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_84", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G159RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G159FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Culvert Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 170, "name": "Curb and Gutter Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "swCurbGutter", "relatedTableId": 80, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{D8171A98-CD20-42CC-802C-7D7D8DAB03F3}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041414000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_86", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G161RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G161FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Curb and Gutter Inspections", "description": "", "prototype": { "attributes": { "RelateID": 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, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 180, "name": "SCM Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "swDetention", "relatedTableId": 90, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{4BC00B7C-2A52-4F36-86A0-94719D236755}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1777041419000 }, "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": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "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" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_87", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G162RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G162FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCM Inspections", "description": "", "prototype": { "attributes": { "RelateID": null, "FacilityID": null, "ReviewFlag": null, "InspDate": null, "Notes": null, "InspYear": null, "InspBy": null, "Inspector": null, "InspType": null, "InspRef": null, "Condition": null, "MaintRequired": null, "NextAction": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdf53e5f3fd1452088fc140870ba4d4a" } ] }