{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Storm Drain Structures", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "New data is entered by DPIE, legacy data has been updated through field verification from DPW&T and DoE.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Downstream Conveyance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{F527ABA8-E776-41FE-96DB-062815A40BF8}" }, { "id": 1, "name": "SDS_Cleaning", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{45CECFD0-D9C8-420E-B808-21E21433B93A}" }, { "id": 2, "name": "Upstream Conveyance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{45DA3540-6913-4CC5-B67C-D241E45B6FBF}" }, { "id": 3, "name": "OutfallDrainageArea", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "MDE_GDB_ID", "composite": false, "catalogID": "{6BF330AA-A244-44B6-B110-E52202ECECFE}" }, { "id": 4, "name": "SDS_Condition", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{4907AB96-09D7-4537-879E-51E4587F7428}" }, { "id": 5, "name": "ESMGDB.PGCSW.SDS_Repairs", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{79F98C92-8A9B-4DE3-A66A-16BCD9024AB6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "modelName": "GP_865594853", "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1291853.671886161, "ymin": 321120.1198234856, "xmax": 1407237.2760922462, "ymax": 664849.3053952307, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "STR_TYPE", "defaultSymbol": { "type": "esriPMS", "url": "85cd2a6e0fc37694f8998e3b4902ec9b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAMCAYAAABSgIzaAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABQUlEQVQokWNhwA0MGBgYPjAwMDzAJsmCRUxATUQr2VreteDrry+cu29v6nv/43UbIY0KmqL6tfGGOZGeaiGcfOwCDEaSc2oWnp+ifP31xWKoCzA0Oriq+E0osGzU1xIDuRICwnVTOHXFTZLq9uUYn316tICBgeEAXKOOuGGyqYxdQ5JRgYwMnwKG27XEDBjmBW7Rbz1Ysmbv3a11b7+9mAbW+Pzzc3Y35QCsmmAA5OxAzRjhC8+Pc7799gJi49tvL7btv7/trYWsgzADHrD//ra3t95c24vsxwdXX517++nnB2GQydjAp58fGC69OH2FgYHhArJGhtdfn8+69upCj4WsA1aN115dYHj3/dVmGB+u8daba2v3399Wicu5yM5E0Qhz7onHB7BqRHYmukaGow/3ut94fdULm8a3314cQxYAAECChhq4SFkiAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "Structure Type", "classes": [ { "label": "Culvert", "description": "Culvert", "symbol": { "type": "esriPMS", "url": "15116de951b09d62f7473a08820456b3", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCElEQVQokZ2SsW3DMBBFX+ENoiZaIAMoXVagPIQNWBsoZZRWG0iFdzDkFVSytweIKu+Q4BM8gRYUGPAD1BB8urt/3PAkm5WzQ/xEDnhgAHr+EQugeaNwexoyXnkh54p3LZW7MelnW2Bais2exu34Sn9MhuPEDy1VcaLvgDIVD6q0lFJqOi54d8Wrcj+Las8YOasCNyZaBj5w4fyTjh3vd2KYyTBJ1JSM/LLExFxBGCaJLDmPd/JU9EpPQQi1V1MGSbMZY9hKWM8sDopc6QnNNK60p9njTmex154UeVoh5ci3KsoMDyHd41Z7UuRKz2ZSe6oUpcoup6ISKbWnGLkF8fDJGbpwd2mNP5SSWdtUFLlsAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "CV" ] ] }, { "label": "Endsection", "description": "Endsection", "symbol": { "type": "esriPMS", "url": "93dd20ecb45391f6cfad1bf7a38c382a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQokZXPIYsCQRjG8X/YoE2wGgZBk8FiGcskEdOCYHJhRNnkJVEwC9sMJpNgsLtdhE1XNmgwr4efwCZcOkbcQ9SVuwdeGF748cxrkRwBnG/zFCtJSYl3uSB2O+R/oHIcaqkU2U4HDSz/AkWlwqheJysErFaMt1sC4OstLBToui7KIJN+n2IUMTge+XgHRaOB7vVIxwvbhiDAns2Y3rdaj21ak3v8hdbk1msmpxPOK6hMW7n8fLTZtds0PY8FXO/9hRkpcV+1xRkOSW82jMLwDubzyGqVmnnv90kUWi1UGKJM6xVGEZ++z9z3k1GcUonvwwF+AOEpQR7YRJSQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "ES" ] ] }, { "label": "Endwall", "description": "Endwall", "symbol": { "type": "esriPMS", "url": "93dd20ecb45391f6cfad1bf7a38c382a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQokZXPIYsCQRjG8X/YoE2wGgZBk8FiGcskEdOCYHJhRNnkJVEwC9sMJpNgsLtdhE1XNmgwr4efwCZcOkbcQ9SVuwdeGF748cxrkRwBnG/zFCtJSYl3uSB2O+R/oHIcaqkU2U4HDSz/AkWlwqheJysErFaMt1sC4OstLBToui7KIJN+n2IUMTge+XgHRaOB7vVIxwvbhiDAns2Y3rdaj21ak3v8hdbk1msmpxPOK6hMW7n8fLTZtds0PY8FXO/9hRkpcV+1xRkOSW82jMLwDubzyGqVmnnv90kUWi1UGKJM6xVGEZ++z9z3k1GcUonvwwF+AOEpQR7YRJSQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "EW" ] ] }, { "label": "Headwall", "description": "Headwall", "symbol": { "type": "esriPMS", "url": "d892737de46ad058f48d67a5b260ef42", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAMCAYAAAC9QufkAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABUElEQVQokWNhQAMcQqJJrGxs2ujiv3/9uvrj3et5yGIsaGo89CNS+lTcAvjRNd/bt+Xn8UnNzxgYGHZg06wiqKDSpROWxC8gr4Kul0FAXoX9xqblXe8f3DnFwMDwDkUzr4R0pmFivi42jWDvCAgxgOSP9tUn/fz4rgdZs4q8rVuMYVwOAz5gGJfDcH/vltz7h3ZuYGBguMMCs1U/OkOMgQhglFQg9+bWlczPL54Ww5394wPYG0QBJnYOKbizP794Ov3cvAkhCvYecvg0/fjwjuH6hqWPPj682w/XDHL/s4unJ9/YtKxbwy8Kp+Zn50/8fHr68CwGBgZQiCNC++fHd/NOTmtPk9A3U8UW4h8e3mE4Mbnp+senD1fCxJDj+d2bm1caTs/snqYbnoyRSO7s2vDx+fmTc0FMbJpBYNmtnes57u/fipE8WTg4QZqmIwsCAC/rfZS0hkMWAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "HW" ] ] }, { "label": "Inlet", "description": "Inlet", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 230, 0, 0, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "IN" ] ] }, { "label": "Manhole", "description": "Manhole", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 85, 255, 0, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "MH" ] ] }, { "label": "Other", "description": "Other", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 169, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "values": [ [ "OTH" ] ] }, { "label": "Projecting Pipe", "description": "Projecting Pipe", "symbol": { "type": "esriPMS", "url": "93dd20ecb45391f6cfad1bf7a38c382a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQokZXPIYsCQRjG8X/YoE2wGgZBk8FiGcskEdOCYHJhRNnkJVEwC9sMJpNgsLtdhE1XNmgwr4efwCZcOkbcQ9SVuwdeGF748cxrkRwBnG/zFCtJSYl3uSB2O+R/oHIcaqkU2U4HDSz/AkWlwqheJysErFaMt1sC4OstLBToui7KIJN+n2IUMTge+XgHRaOB7vVIxwvbhiDAns2Y3rdaj21ak3v8hdbk1msmpxPOK6hMW7n8fLTZtds0PY8FXO/9hRkpcV+1xRkOSW82jMLwDubzyGqVmnnv90kUWi1UGKJM6xVGEZ++z9z3k1GcUonvwwF+AOEpQR7YRJSQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "PP" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "15116de951b09d62f7473a08820456b3", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCElEQVQokZ2SsW3DMBBFX+ENoiZaIAMoXVagPIQNWBsoZZRWG0iFdzDkFVSytweIKu+Q4BM8gRYUGPAD1BB8urt/3PAkm5WzQ/xEDnhgAHr+EQugeaNwexoyXnkh54p3LZW7MelnW2Bais2exu34Sn9MhuPEDy1VcaLvgDIVD6q0lFJqOi54d8Wrcj+Las8YOasCNyZaBj5w4fyTjh3vd2KYyTBJ1JSM/LLExFxBGCaJLDmPd/JU9EpPQQi1V1MGSbMZY9hKWM8sDopc6QnNNK60p9njTmex154UeVoh5ci3KsoMDyHd41Z7UuRKz2ZSe6oUpcoup6ISKbWnGLkF8fDJGbpwd2mNP5SSWdtUFLlsAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "CV", "label": "Culvert" }, { "symbol": { "type": "esriPMS", "url": "93dd20ecb45391f6cfad1bf7a38c382a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQokZXPIYsCQRjG8X/YoE2wGgZBk8FiGcskEdOCYHJhRNnkJVEwC9sMJpNgsLtdhE1XNmgwr4efwCZcOkbcQ9SVuwdeGF748cxrkRwBnG/zFCtJSYl3uSB2O+R/oHIcaqkU2U4HDSz/AkWlwqheJysErFaMt1sC4OstLBToui7KIJN+n2IUMTge+XgHRaOB7vVIxwvbhiDAns2Y3rdaj21ak3v8hdbk1msmpxPOK6hMW7n8fLTZtds0PY8FXO/9hRkpcV+1xRkOSW82jMLwDubzyGqVmnnv90kUWi1UGKJM6xVGEZ++z9z3k1GcUonvwwF+AOEpQR7YRJSQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "ES", "label": "Endsection" }, { "symbol": { "type": "esriPMS", "url": "93dd20ecb45391f6cfad1bf7a38c382a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQokZXPIYsCQRjG8X/YoE2wGgZBk8FiGcskEdOCYHJhRNnkJVEwC9sMJpNgsLtdhE1XNmgwr4efwCZcOkbcQ9SVuwdeGF748cxrkRwBnG/zFCtJSYl3uSB2O+R/oHIcaqkU2U4HDSz/AkWlwqheJysErFaMt1sC4OstLBToui7KIJN+n2IUMTge+XgHRaOB7vVIxwvbhiDAns2Y3rdaj21ak3v8hdbk1msmpxPOK6hMW7n8fLTZtds0PY8FXO/9hRkpcV+1xRkOSW82jMLwDubzyGqVmnnv90kUWi1UGKJM6xVGEZ++z9z3k1GcUonvwwF+AOEpQR7YRJSQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "EW", "label": "Endwall" }, { "symbol": { "type": "esriPMS", "url": "d892737de46ad058f48d67a5b260ef42", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAMCAYAAAC9QufkAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABUElEQVQokWNhQAMcQqJJrGxs2ujiv3/9uvrj3et5yGIsaGo89CNS+lTcAvjRNd/bt+Xn8UnNzxgYGHZg06wiqKDSpROWxC8gr4Kul0FAXoX9xqblXe8f3DnFwMDwDkUzr4R0pmFivi42jWDvCAgxgOSP9tUn/fz4rgdZs4q8rVuMYVwOAz5gGJfDcH/vltz7h3ZuYGBguMMCs1U/OkOMgQhglFQg9+bWlczPL54Ww5394wPYG0QBJnYOKbizP794Ov3cvAkhCvYecvg0/fjwjuH6hqWPPj682w/XDHL/s4unJ9/YtKxbwy8Kp+Zn50/8fHr68CwGBgZQiCNC++fHd/NOTmtPk9A3U8UW4h8e3mE4Mbnp+senD1fCxJDj+d2bm1caTs/snqYbnoyRSO7s2vDx+fmTc0FMbJpBYNmtnes57u/fipE8WTg4QZqmIwsCAC/rfZS0hkMWAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "HW", "label": "Headwall" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 230, 0, 0, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "IN", "label": "Inlet" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 85, 255, 0, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "MH", "label": "Manhole" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 169, 255 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } }, "value": "OTH", "label": "Other" }, { "symbol": { "type": "esriPMS", "url": "93dd20ecb45391f6cfad1bf7a38c382a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAALCAYAAABPhbxiAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9klEQVQokZXPIYsCQRjG8X/YoE2wGgZBk8FiGcskEdOCYHJhRNnkJVEwC9sMJpNgsLtdhE1XNmgwr4efwCZcOkbcQ9SVuwdeGF748cxrkRwBnG/zFCtJSYl3uSB2O+R/oHIcaqkU2U4HDSz/AkWlwqheJysErFaMt1sC4OstLBToui7KIJN+n2IUMTge+XgHRaOB7vVIxwvbhiDAns2Y3rdaj21ak3v8hdbk1msmpxPOK6hMW7n8fLTZtds0PY8FXO/9hRkpcV+1xRkOSW82jMLwDubzyGqVmnnv90kUWi1UGKJM6xVGEZ++z9z3k1GcUonvwwF+AOEpQR7YRJSQAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "PP", "label": "Projecting Pipe" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 76, 148, 68, 255 ], "toColor": [ 76, 148, 68, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 161, 48, 159, 255 ], "toColor": [ 161, 48, 159, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 176, 60, 37, 255 ], "toColor": [ 176, 60, 37, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 52, 133, 173, 255 ], "toColor": [ 52, 133, 173, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 32, 56, 138, 255 ], "toColor": [ 32, 56, 138, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 153, 72, 98, 255 ], "toColor": [ 153, 72, 98, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 176, 148, 46, 255 ], "toColor": [ 176, 148, 46, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 35, 168, 146, 255 ], "toColor": [ 35, 168, 146, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 133, 81, 50, 255 ], "toColor": [ 133, 81, 50, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 100, 50, 173, 255 ], "toColor": [ 100, 50, 173, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 123, 171, 41, 255 ], "toColor": [ 123, 171, 41, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 115, 79, 158, 255 ], "toColor": [ 115, 79, 158, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 153, 73, 137, 255 ], "toColor": [ 153, 73, 137, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": {"expression": "DomainName($feature, 'STR_TYPE')"}, "labelPlacement": "esriServerPointLabelPlacementAboveLeft", "deconflictionStrategy": "dynamic", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 190, 255 ], "haloSize": 0.75, "font": { "family": "Arial", "size": 8, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "str_num", "typeIdField": "STR_TYPE", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "str_num", "type": "esriFieldTypeString", "alias": "Structure Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "str_num" }, { "name": "STR_TYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "domain": { "type": "codedValue", "name": "dStormDrain_StructureType", "description": "Storm Drain Structure Type", "codedValues": [ { "name": "Bend", "code": "B" }, { "name": "Culvert", "code": "CV" }, { "name": "Ditch Intersection", "code": "DI" }, { "name": "Emergency Spillway", "code": "EM" }, { "name": "Endsection", "code": "ES" }, { "name": "Endwall", "code": "EW" }, { "name": "Headwall", "code": "HW" }, { "name": "Inlet", "code": "IN" }, { "name": "Junction Box", "code": "JB" }, { "name": "Manhole", "code": "MH" }, { "name": "Other", "code": "OTH" }, { "name": "Pipe Connection", "code": "PC" }, { "name": "Pipe Direction", "code": "PD" }, { "name": "Projecting Pipe", "code": "PP" }, { "name": "Pump Station", "code": "PS" }, { "name": "SWM Structure", "code": "SWM" }, { "name": "Wye Connection", "code": "WC" }, { "name": "Culvert Headwall", "code": "CHW" }, { "name": "Culvert Endwall", "code": "CEW" }, { "name": "Riser Structure", "code": "RS" }, { "name": "Pond Outfall", "code": "PO" }, { "name": "Pond Headwall", "code": "PH" }, { "name": "Pond Endwall", "code": "PE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "STR_TYPE" }, { "name": "status", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "status" }, { "name": "MS4_Report", "type": "esriFieldTypeString", "alias": "MS4 Report", "domain": { "type": "codedValue", "name": "dMS4Report", "description": "Part of NPDES or not", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MS4_Report" }, { "name": "MDE_GDB_ID", "type": "esriFieldTypeString", "alias": "MDE_GDB_ID", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "MDE_GDB_ID" }, { "name": "MajOutfall", "type": "esriFieldTypeString", "alias": "MS4 Major Outfall", "domain": { "type": "codedValue", "name": "dSDI_MajOutfallType", "description": "Types of MS4 Major Outfalls", "codedValues": [ { "name": "Industrial Outfall 12\" or greater", "code": "12" }, { "name": "Outfall 36\" or greater", "code": "36" }, { "name": "Outfall with Drainage Area reater than 50 acres", "code": "50" }, { "name": "36\u201d or Greater-Multiple Pipes", "code": "36MP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "MajOutfall" }, { "name": "top_of_grade", "type": "esriFieldTypeDouble", "alias": "TOP_OF_GRADE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "top_of_grade" }, { "name": "measured_depth", "type": "esriFieldTypeDouble", "alias": "MEASURED_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "measured_depth" }, { "name": "GenCom", "type": "esriFieldTypeString", "alias": "General Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GenCom" }, { "name": "StruOwner", "type": "esriFieldTypeString", "alias": "Structure Owner", "domain": { "type": "codedValue", "name": "dSDIOwner", "description": "", "codedValues": [ { "name": "County", "code": "C" }, { "name": "SHA", "code": "S" }, { "name": "Municipality", "code": "M" }, { "name": "Private", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "StruOwner" }, { "name": "sd_number", "type": "esriFieldTypeString", "alias": "SD Number", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "sd_number" }, { "name": "pipe_in_quantity", "type": "esriFieldTypeDouble", "alias": "PIPE_IN_QUANTITY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pipe_in_quantity" }, { "name": "pipe_out_quantity", "type": "esriFieldTypeDouble", "alias": "PIPE_OUT_QUANTITY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pipe_out_quantity" }, { "name": "out_year", "type": "esriFieldTypeString", "alias": "Year Constructed", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "out_year" }, { "name": "permit_num", "type": "esriFieldTypeString", "alias": "PERMIT_NUM", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "permit_num" }, { "name": "bottom_elevation", "type": "esriFieldTypeDouble", "alias": "Structure Bottom Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bottom_elevation" }, { "name": "asbuiltdate", "type": "esriFieldTypeDate", "alias": "As Built Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "asbuiltdate" }, { "name": "approvaldate", "type": "esriFieldTypeDate", "alias": "Approval Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "approvaldate" }, { "name": "Muni", "type": "esriFieldTypeString", "alias": "Municipality", "domain": { "type": "codedValue", "name": "dMuni", "description": "Municipalities", "codedValues": [ { "name": "EAGLE HARBOR", "code": "73" }, { "name": "GREENBELT", "code": "74" }, { "name": "BERWYN HEIGHTS", "code": "75" }, { "name": "BLADENSBURG", "code": "76" }, { "name": "BOWIE", "code": "77" }, { "name": "BRENTWOOD", "code": "78" }, { "name": "CAPITOL HEIGHTS", "code": "79" }, { "name": "CHEVERLY", "code": "80" }, { "name": "COLLEGE PARK", "code": "81" }, { "name": "COLMAR MANOR", "code": "82" }, { "name": "COTTAGE CITY", "code": "83" }, { "name": "DISTRICT HEIGHTS", "code": "84" }, { "name": "EDMONSTON", "code": "85" }, { "name": "FAIRMOUNT HEIGHTS", "code": "86" }, { "name": "GLENARDEN", "code": "87" }, { "name": "HYATTSVILLE", "code": "88" }, { "name": "LANDOVER HILLS", "code": "89" }, { "name": "LAUREL", "code": "90" }, { "name": "MOUNT RAINIER", "code": "91" }, { "name": "NORTH BRENTWOOD", "code": "92" }, { "name": "RIVERDALE PARK", "code": "93" }, { "name": "SEAT PLEASANT", "code": "94" }, { "name": "UNIVERSITY PARK", "code": "96" }, { "name": "UPPER MARLBORO", "code": "97" }, { "name": "MORNINGSIDE", "code": "98" }, { "name": "FOREST HEIGHTS", "code": "99" }, { "name": "NEW CARROLLTON", "code": "72" }, { "name": "NONE", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Muni" }, { "name": "WATERSHED8DGT", "type": "esriFieldTypeString", "alias": "8 Digit Watershed", "domain": { "type": "codedValue", "name": "dMD8digit", "description": "Maryland 8 digit hydrologic unit code", "codedValues": [ { "name": "Anacostia River", "code": "02140205" }, { "name": "Mattawoman Creek", "code": "02140111" }, { "name": "Oxon Creek", "code": "02140204" }, { "name": "Patuxent River lower", "code": "02131101" }, { "name": "Patuxent River middle", "code": "02131102" }, { "name": "Patuxent River upper", "code": "02131104" }, { "name": "Piscataway Creek", "code": "02140203" }, { "name": "Potomac River M tidal", "code": "02140102" }, { "name": "Potomac River U tidal", "code": "02140201" }, { "name": "Rocky Gorge Dam", "code": "02131107" }, { "name": "Western Branch", "code": "02131103" }, { "name": "Zekiah Swamp", "code": "02140108" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WATERSHED8DGT" }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "Longitude (X)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_X" }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "Latitude (Y)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_Y" }, { "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "EdCom", "type": "esriFieldTypeString", "alias": "Editor Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EdCom" }, { "name": "FieldVer", "type": "esriFieldTypeString", "alias": "Field Verified", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FieldVer" }, { "name": "FieldVerDate", "type": "esriFieldTypeDate", "alias": "Field Verification Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FieldVerDate" }, { "name": "Structure_AGE", "type": "esriFieldTypeString", "alias": "Age of Structure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Structure_AGE" }, { "name": "ST_RepairAs", "type": "esriFieldTypeString", "alias": "Repair Assessment Indicator", "domain": { "type": "codedValue", "name": "dOSDM_RepairRec", "description": "Repair Recommendations", "codedValues": [ { "name": "Significant Repairs Recommended", "code": "Significant" }, { "name": "No Repairs Recommended", "code": "NA" }, { "name": "Moderate Repairs Recommended", "code": "Moderate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_RepairAs" }, { "name": "ST_RepairDate", "type": "esriFieldTypeDate", "alias": "Repair Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ST_RepairDate" }, { "name": "ST_Repair_Issue", "type": "esriFieldTypeString", "alias": "Repair Issue", "domain": { "type": "codedValue", "name": "dOSDMStructRepairIssue", "description": "OSDM Structure Repair Issues", "codedValues": [ { "name": "Total Rebuild", "code": "TR" }, { "name": "Brick Work - Parging", "code": "BWP" }, { "name": "Reset Top Slab", "code": "Reset" }, { "name": "Pipe Connection", "code": "PC" }, { "name": "Crushed Top Slab", "code": "CTS" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_Repair_Issue" }, { "name": "ST_RepairNotes", "type": "esriFieldTypeString", "alias": "Repair Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_RepairNotes" }, { "name": "ST_RepairResp", "type": "esriFieldTypeString", "alias": "Repair Responsibility", "domain": { "type": "codedValue", "name": "dOSDM_MaintResp", "description": "Maintenance Responsibility", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3" }, { "name": "Clean Water Partnership", "code": "CWP" }, { "name": "In-House", "code": "IN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_RepairResp" }, { "name": "InletCleaned", "type": "esriFieldTypeString", "alias": "Inlet Cleaned", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InletCleaned" }, { "name": "Date_Last_Cleaned", "type": "esriFieldTypeDate", "alias": "Last Date Cleaned", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Last_Cleaned" }, { "name": "ST_Blockage", "type": "esriFieldTypeString", "alias": "Blockage Extent", "domain": { "type": "codedValue", "name": "dOSDM_Blockage", "description": "Blockage Description", "codedValues": [ { "name": "0% - 25% None to Little Blockage", "code": "Low Blockage" }, { "name": "26% to 75% Blockage", "code": "Moderate Blockage" }, { "name": "Greater than 76% Blockage", "code": "High Blockage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_Blockage" }, { "name": "Assess_Date", "type": "esriFieldTypeDate", "alias": "Assessment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Assess_Date" }, { "name": "SR_NOa", "type": "esriFieldTypeString", "alias": "Service Request Number", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "SR_NOa" }, { "name": "ST_RepairStatus", "type": "esriFieldTypeString", "alias": "Repair Progress Status", "domain": { "type": "codedValue", "name": "dMaintStatus", "description": "Maintenance Status", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "TD" }, { "name": "In-Progress", "code": "IP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_RepairStatus" }, { "name": "ST_Assesment_Com", "type": "esriFieldTypeString", "alias": "Assesment Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_Assesment_Com" }, { "name": "Struct_GlobalID_on_add", "type": "esriFieldTypeGUID", "alias": "GlobalID_On_Add", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Struct_GlobalID_on_add" }, { "name": "STsafety_score", "type": "esriFieldTypeString", "alias": "Safety Score", "domain": { "type": "codedValue", "name": "dOSDMSafety_Score", "description": "OSDM Safety score related to structure", "codedValues": [ { "name": "No Safety Hazard Observed", "code": "No Safety Hazard Observed" }, { "name": "Low Risk Safety Hazard Observed", "code": "Low Risk Safety Hazard Observed" }, { "name": "Moderate Risk Safety Hazard Observed", "code": "Moderate Risk Safety Hazard Observed" }, { "name": "Significant/High Risk Safety Hazard Observed", "code": "Significant/High Risk Safety Hazard Observed" }, { "name": "Severe/Immediate Risk Safety Hazard Observed", "code": "Severe/Immediate Risk Safety Hazard Observed" }, { "name": "Could not evaluate", "code": "Could not evaluate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "STsafety_score" }, { "name": "MDE_GDB_ID_OutfallDA", "type": "esriFieldTypeString", "alias": "MDE GDB ID of Outfall DA", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MDE_GDB_ID_OutfallDA" }, { "name": "Inlet_Type", "type": "esriFieldTypeString", "alias": "Inlet Type", "domain": { "type": "codedValue", "name": "dOSDM_InletType", "description": "Indicates the type and size of of Inlet", "codedValues": [ { "name": "A1- Grate Inlet at Curb", "code": "A1" }, { "name": "A2- Grate Inlet at Curb", "code": "A2" }, { "name": "A3- Grate Inlet at Curb", "code": "A3" }, { "name": "A4- Grate Inlet at Curb", "code": "A4" }, { "name": "A5- Grate Inlet at Curb", "code": "A5" }, { "name": "B- Grate Inlet at Curb", "code": "B" }, { "name": "C- Grate Inlet at Curb", "code": "C" }, { "name": "D1- Curb opening Inlets", "code": "D1" }, { "name": "D2- Curb opening Inlets", "code": "D2" }, { "name": "D3- Curb opening Inlets", "code": "D3" }, { "name": "D4- Curb opening Inlets", "code": "D4" }, { "name": "D5- Curb opening Inlets", "code": "D5" }, { "name": "E1- Combination (Grate + Curb)", "code": "E1" }, { "name": "E2- Combination (Grate + Curb)", "code": "E2" }, { "name": "E3- Combination (Grate + Curb)", "code": "E3" }, { "name": "E4- Combination (Grate + Curb)", "code": "E4" }, { "name": "E5- Combination (Grate + Curb)", "code": "E5" }, { "name": "F-Combination (Grate + Curb)", "code": "F" }, { "name": "G- Combination (Grate + Curb)", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inlet_Type" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R496_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_496", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3022_MDE_GDB", "fields": "MDE_GDB_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S228_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "CV", "name": "Culvert", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "CV", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "CV", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "ES", "name": "Endsection", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "ES", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "ES", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "EW", "name": "Endwall", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "EW", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "EW", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "HW", "name": "Headwall", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "HW", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "HW", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "IN", "name": "Inlet", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "IN", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "IN", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "MH", "name": "Manhole", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "MH", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "MH", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "OTH", "name": "Other", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "OTH", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "OTH", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": "PP", "name": "Projecting Pipe", "domains": { "STR_TYPE": {"type": "inherited"}, "MS4_Report": {"type": "inherited"}, "MajOutfall": {"type": "inherited"}, "StruOwner": {"type": "inherited"}, "Muni": {"type": "inherited"}, "WATERSHED8DGT": {"type": "inherited"}, "ST_RepairAs": {"type": "inherited"}, "ST_Repair_Issue": {"type": "inherited"}, "ST_RepairResp": {"type": "inherited"}, "InletCleaned": {"type": "inherited"}, "ST_Blockage": {"type": "inherited"}, "ST_RepairStatus": {"type": "inherited"}, "STsafety_score": {"type": "inherited"}, "Inlet_Type": {"type": "inherited"} }, "templates": [ { "name": "PP", "description": "", "prototype": { "attributes": { "MDE_GDB_ID_OutfallDA": null, "STsafety_score": null, "str_num": null, "STR_TYPE": "PP", "status": null, "MS4_Report": null, "MDE_GDB_ID": null, "MajOutfall": null, "top_of_grade": null, "measured_depth": null, "GenCom": null, "StruOwner": null, "sd_number": null, "pipe_in_quantity": null, "pipe_out_quantity": null, "out_year": null, "permit_num": null, "bottom_elevation": null, "asbuiltdate": null, "approvaldate": null, "Muni": null, "WATERSHED8DGT": null, "POINT_X": null, "POINT_Y": null, "Struct_GlobalID_on_add": null, "ST_Assesment_Com": null, "ST_RepairStatus": null, "SR_NOa": null, "Inlet_Type": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Structure_AGE": null, "ST_RepairAs": null, "ST_RepairDate": null, "ST_Repair_Issue": null, "ST_RepairNotes": null, "ST_RepairResp": null, "InletCleaned": null, "Date_Last_Cleaned": null, "ST_Blockage": null, "Assess_Date": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Storm Drain Conveyance", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "New data is entered by DPIE, legacy data has been updated through field verification from DPW&T and DoE.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "SDC_Repairs", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{22777A1F-01AF-4D80-8E63-FFB75D7772B5}" }, { "id": 7, "name": "SDC_Cleaning", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{95E59396-4EAA-4B48-8D98-1787D59255D4}" }, { "id": 8, "name": "SDC_Condition", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{EE48D515-785A-423A-B3BE-CBCA6CAFFD83}" }, { "id": 2, "name": "Downstream Structure", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "dnstrm_globalid", "composite": false, "catalogID": "{45DA3540-6913-4CC5-B67C-D241E45B6FBF}" }, { "id": 0, "name": "Upstream Structure", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "upstrm_globalid", "composite": false, "catalogID": "{F527ABA8-E776-41FE-96DB-062815A40BF8}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1291535.5740971565, "ymin": 320428.3137923926, "xmax": 1403740.8460772485, "ymax": 583427.1283448935, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ConveyanceType", "uniqueValueGroups": [ { "heading": "Type Of Storm Drain Conveyance", "classes": [ { "label": "Culvert", "description": "Culvert", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "values": [ [ "C" ] ] }, { "label": "Ditch", "description": "Ditch", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "values": [ [ "D" ] ] }, { "label": "Hydraulic Connector", "description": "Hydraulic Connector", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "values": [ [ "HC" ] ] }, { "label": "Open Channel", "description": "Open Channel", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "values": [ [ "OC" ] ] }, { "label": "Pipe", "description": "Pipe", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 2 }, "values": [ [ "P" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "value": "C", "label": "Culvert" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "value": "D", "label": "Ditch" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 2 }, "value": "HC", "label": "Hydraulic Connector" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "value": "OC", "label": "Open Channel" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 255 ], "width": 2 }, "value": "P", "label": "Pipe" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 209, 252, 204, 255 ], "toColor": [ 209, 252, 204, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 179, 252, 255 ], "toColor": [ 238, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 219, 252, 255 ], "toColor": [ 182, 219, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 207, 199, 255 ], "toColor": [ 252, 207, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 228, 179, 255 ], "toColor": [ 252, 228, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 189, 252, 255 ], "toColor": [ 187, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 250, 255 ], "toColor": [ 179, 252, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 216, 255 ], "toColor": [ 252, 179, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 236, 215, 252, 255 ], "toColor": [ 236, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 252, 179, 255 ], "toColor": [ 252, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 183, 252, 179, 255 ], "toColor": [ 183, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 230, 212, 255 ], "toColor": [ 252, 230, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 241, 252, 255 ], "toColor": [ 212, 241, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "dpw_channel_name", "typeIdField": "ConveyanceType", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ConveyanceType", "type": "esriFieldTypeString", "alias": "Type Of Storm Drain Conveyance", "domain": { "type": "codedValue", "name": "dStormDrain_ConveyanceType", "description": "Storm Drain Conveyance Type", "codedValues": [ { "name": "Culvert", "code": "C" }, { "name": "Ditch", "code": "D" }, { "name": "Hydraulic Connector", "code": "HC" }, { "name": "Open Channel", "code": "OC" }, { "name": "Pipe", "code": "P" }, { "name": "Pipe-Culvert", "code": "PC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "ConveyanceType" }, { "name": "TYPE_MATL", "type": "esriFieldTypeString", "alias": "Conveyance Material", "domain": { "type": "codedValue", "name": "dStormDrain_ConveyanceMaterial", "description": "Conveyance Material Type", "codedValues": [ { "name": "Asphalt Coated Corrugated Metal Pipe", "code": "ACCMP" }, { "name": "Aluminum Spiral Rib Pipe", "code": "ASRP" }, { "name": "Bituminous Coated Corrugated Metal Pipe", "code": "BCCMP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Concrete", "code": "CONC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Polyvinyl Chloride (PVC) Pipe", "code": "PVC" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Structural Plate Pipe", "code": "SPP" }, { "name": "Stream", "code": "STR" }, { "name": "Terracotta Pipe", "code": "TCP" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VC" }, { "name": "Vegetated Channel", "code": "VEG" }, { "name": "Perforated PVC", "code": "PPVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "TYPE_MATL" }, { "name": "DIM_OUTFALL", "type": "esriFieldTypeDouble", "alias": "Outfall dimensions (square inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIM_OUTFALL" }, { "name": "HT_OUTFALL", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HT_OUTFALL" }, { "name": "WT_OUTFALL", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WT_OUTFALL" }, { "name": "MDE_GDB_ID", "type": "esriFieldTypeString", "alias": "MDE GDB ID of Outfall", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MDE_GDB_ID" }, { "name": "ConveyStatus", "type": "esriFieldTypeString", "alias": "Conveyance Status in Field", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "ConveyStatus" }, { "name": "ConveyOwner", "type": "esriFieldTypeString", "alias": "Conveyance Owner", "domain": { "type": "codedValue", "name": "dSDIOwner", "description": "", "codedValues": [ { "name": "County", "code": "C" }, { "name": "SHA", "code": "S" }, { "name": "Municipality", "code": "M" }, { "name": "Private", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ConveyOwner" }, { "name": "invert_in_elevation", "type": "esriFieldTypeDouble", "alias": "Invert In Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invert_in_elevation" }, { "name": "invert_out_elevation", "type": "esriFieldTypeDouble", "alias": "Invert Out Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invert_out_elevation" }, { "name": "plan_length", "type": "esriFieldTypeDouble", "alias": "Conveyance Length on Plan in Feet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "plan_length" }, { "name": "upstrm_globalid", "type": "esriFieldTypeGUID", "alias": "OSDM Upstream Structure Global ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "upstrm_globalid" }, { "name": "dnstrm_globalid", "type": "esriFieldTypeGUID", "alias": "OSDM Downstream Structure Global ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "dnstrm_globalid" }, { "name": "sd_number", "type": "esriFieldTypeString", "alias": "SD Number", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "sd_number" }, { "name": "GenCom", "type": "esriFieldTypeString", "alias": "General Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GenCom" }, { "name": "invert_in_measurement", "type": "esriFieldTypeDouble", "alias": "Invert In Measurement", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invert_in_measurement" }, { "name": "invert_out_measurement", "type": "esriFieldTypeDouble", "alias": "Invert Out Measurement", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "invert_out_measurement" }, { "name": "top_width", "type": "esriFieldTypeDouble", "alias": "Channel Top Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "top_width" }, { "name": "bottom_width", "type": "esriFieldTypeDouble", "alias": "Channel Bottom Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bottom_width" }, { "name": "depth", "type": "esriFieldTypeDouble", "alias": "Channel Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "depth" }, { "name": "dpw_channel_id", "type": "esriFieldTypeString", "alias": "DPWT Channel ID", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "dpw_channel_id" }, { "name": "dpw_channel_name", "type": "esriFieldTypeString", "alias": "DPWT Channel Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "dpw_channel_name" }, { "name": "x_area", "type": "esriFieldTypeDouble", "alias": "Area of Channel", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "x_area" }, { "name": "ConveyShape", "type": "esriFieldTypeString", "alias": "Conveyance Shape", "domain": { "type": "codedValue", "name": "dStormDrain_Conveyance_Shape", "description": "Pipe, Channel, and Ditch Shapes", "codedValues": [ { "name": "V-Ditch", "code": "VD" }, { "name": "Parabolic Ditch", "code": "PD" }, { "name": "Trapezoidal Ditch", "code": "TD" }, { "name": "Other", "code": "O" }, { "name": "Flat Bottom", "code": "FB" }, { "name": "Unknown", "code": "U" }, { "name": "Circular/Symmetrical Pipe", "code": "CSP" }, { "name": "Elliptical Pipe", "code": "EP" }, { "name": "Arch/Asymetric Pipe", "code": "AAP" }, { "name": "Rectangular Concrete Box Pipe", "code": "RCBP" }, { "name": "Metal Box Pipe", "code": "MBP" }, { "name": "Asphalt Coated Pipe", "code": "ACP" }, { "name": "Sectional Plate", "code": "SP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "ConveyShape" }, { "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": "GeomLengthFt", "type": "esriFieldTypeDouble", "alias": "Geometric Length In Feet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GeomLengthFt" }, { "name": "EdCom", "type": "esriFieldTypeString", "alias": "Editor Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EdCom" }, { "name": "FieldVer", "type": "esriFieldTypeString", "alias": "Field Verified", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "FieldVer" }, { "name": "FieldVerDate", "type": "esriFieldTypeDate", "alias": "Field Verification Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FieldVerDate" }, { "name": "Slope", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Slope" }, { "name": "Conveyance_AGE", "type": "esriFieldTypeString", "alias": "Age of Conveyance", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conveyance_AGE" }, { "name": "Conv_RepairResp", "type": "esriFieldTypeString", "alias": "Repair Responsibility", "domain": { "type": "codedValue", "name": "dOSDM_MaintResp", "description": "Maintenance Responsibility", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3" }, { "name": "Clean Water Partnership", "code": "CWP" }, { "name": "In-House", "code": "IN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_RepairResp" }, { "name": "Conv_RepairStatus", "type": "esriFieldTypeString", "alias": "Repair Progress Status", "domain": { "type": "codedValue", "name": "dMaintStatus", "description": "Maintenance Status", "codedValues": [ { "name": "Complete", "code": "C" }, { "name": "To-Do", "code": "TD" }, { "name": "In-Progress", "code": "IP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_RepairStatus" }, { "name": "Conv_RepairDate", "type": "esriFieldTypeDate", "alias": "Repair Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Conv_RepairDate" }, { "name": "Conv_Repair_Issue", "type": "esriFieldTypeString", "alias": "Repair Issue", "domain": { "type": "codedValue", "name": "dOSDMConvRepairIssue", "description": "OSDM Conveyance Repair Issues", "codedValues": [ { "name": "Reset", "code": "Reset" }, { "name": "Replace", "code": "Replace" }, { "name": "Replace - Upgrade", "code": "RU" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_Repair_Issue" }, { "name": "Conv_RepairNotes", "type": "esriFieldTypeString", "alias": "Repair Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_RepairNotes" }, { "name": "PIPE_Cleaned", "type": "esriFieldTypeString", "alias": "Pipe Cleaned", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPE_Cleaned" }, { "name": "PipeDateLastCleaned", "type": "esriFieldTypeDate", "alias": "Last Date Cleaned", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PipeDateLastCleaned" }, { "name": "ConvRepairAs", "type": "esriFieldTypeString", "alias": "Repair Assesment Indicator", "domain": { "type": "codedValue", "name": "dOSDM_RepairRec", "description": "Repair Recommendations", "codedValues": [ { "name": "Significant Repairs Recommended", "code": "Significant" }, { "name": "No Repairs Recommended", "code": "NA" }, { "name": "Moderate Repairs Recommended", "code": "Moderate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ConvRepairAs" }, { "name": "Conv_Blockage", "type": "esriFieldTypeString", "alias": "Blockage Extent", "domain": { "type": "codedValue", "name": "dOSDM_Blockage", "description": "Blockage Description", "codedValues": [ { "name": "0% - 25% None to Little Blockage", "code": "Low Blockage" }, { "name": "26% to 75% Blockage", "code": "Moderate Blockage" }, { "name": "Greater than 76% Blockage", "code": "High Blockage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_Blockage" }, { "name": "Asses_Date2", "type": "esriFieldTypeDate", "alias": "Assesment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Asses_Date2" }, { "name": "SR_NOb", "type": "esriFieldTypeString", "alias": "Service Request Number", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "SR_NOb" }, { "name": "Material_PipeReplace", "type": "esriFieldTypeString", "alias": "Material of Replaced Pipe", "domain": { "type": "codedValue", "name": "dStormDrain_ConveyanceMaterial", "description": "Conveyance Material Type", "codedValues": [ { "name": "Asphalt Coated Corrugated Metal Pipe", "code": "ACCMP" }, { "name": "Aluminum Spiral Rib Pipe", "code": "ASRP" }, { "name": "Bituminous Coated Corrugated Metal Pipe", "code": "BCCMP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Concrete", "code": "CONC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Polyvinyl Chloride (PVC) Pipe", "code": "PVC" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Structural Plate Pipe", "code": "SPP" }, { "name": "Stream", "code": "STR" }, { "name": "Terracotta Pipe", "code": "TCP" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VC" }, { "name": "Vegetated Channel", "code": "VEG" }, { "name": "Perforated PVC", "code": "PPVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Material_PipeReplace" }, { "name": "Length_PipeReplace", "type": "esriFieldTypeDouble", "alias": "Length of Replaced Pipe (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_PipeReplace" }, { "name": "VideoPipeInsp", "type": "esriFieldTypeString", "alias": "Video Pipe Inspection", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VideoPipeInsp" }, { "name": "VideoPipeInspDate", "type": "esriFieldTypeDate", "alias": "Video Pipe Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "VideoPipeInspDate" }, { "name": "Conv_Assess_Com", "type": "esriFieldTypeString", "alias": "Assesment Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_Assess_Com" }, { "name": "Length_Pipe_Insp", "type": "esriFieldTypeDouble", "alias": "Length of Pipe Inspected (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_Pipe_Insp" }, { "name": "Length_Pipe_Cleaned", "type": "esriFieldTypeDouble", "alias": "Length of Pipe Cleaned (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_Pipe_Cleaned" }, { "name": "Conv_GlobalID_on_add", "type": "esriFieldTypeGUID", "alias": "GlobalID_On_Add", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Conv_GlobalID_on_add" }, { "name": "Convsafety_score", "type": "esriFieldTypeString", "alias": "Safety Score", "domain": { "type": "codedValue", "name": "dOSDMSafety_Score", "description": "OSDM Safety score related to structure", "codedValues": [ { "name": "No Safety Hazard Observed", "code": "No Safety Hazard Observed" }, { "name": "Low Risk Safety Hazard Observed", "code": "Low Risk Safety Hazard Observed" }, { "name": "Moderate Risk Safety Hazard Observed", "code": "Moderate Risk Safety Hazard Observed" }, { "name": "Significant/High Risk Safety Hazard Observed", "code": "Significant/High Risk Safety Hazard Observed" }, { "name": "Severe/Immediate Risk Safety Hazard Observed", "code": "Severe/Immediate Risk Safety Hazard Observed" }, { "name": "Could not evaluate", "code": "Could not evaluate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "Convsafety_score" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R482_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_482", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3408_dnstrm_", "fields": "dnstrm_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3408_upstrm_", "fields": "upstrm_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S220_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "C", "name": "Culvert", "domains": { "ConveyanceType": {"type": "inherited"}, "TYPE_MATL": {"type": "inherited"}, "ConveyOwner": {"type": "inherited"}, "ConveyShape": {"type": "inherited"}, "Conv_RepairResp": {"type": "inherited"}, "Conv_RepairStatus": {"type": "inherited"}, "Conv_Repair_Issue": {"type": "inherited"}, "PIPE_Cleaned": {"type": "inherited"}, "ConvRepairAs": {"type": "inherited"}, "Conv_Blockage": {"type": "inherited"}, "Material_PipeReplace": {"type": "inherited"}, "VideoPipeInsp": {"type": "inherited"}, "Convsafety_score": {"type": "inherited"} }, "templates": [ { "name": "C", "description": "", "prototype": { "attributes": { "Convsafety_score": null, "Conv_GlobalID_on_add": null, "ConveyanceType": "C", "TYPE_MATL": null, "DIM_OUTFALL": null, "HT_OUTFALL": null, "WT_OUTFALL": null, "MDE_GDB_ID": null, "ConveyStatus": null, "ConveyOwner": null, "invert_in_elevation": null, "invert_out_elevation": null, "plan_length": null, "upstrm_globalid": null, "dnstrm_globalid": null, "sd_number": null, "GenCom": null, "invert_in_measurement": null, "invert_out_measurement": null, "top_width": null, "bottom_width": null, "depth": null, "dpw_channel_id": null, "dpw_channel_name": null, "x_area": null, "ConveyShape": null, "Length_Pipe_Cleaned": null, "Length_Pipe_Insp": null, "Conv_Assess_Com": null, "VideoPipeInspDate": null, "VideoPipeInsp": null, "GeomLengthFt": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Slope": null, "Conveyance_AGE": null, "Conv_RepairResp": null, "Conv_RepairStatus": null, "Conv_RepairDate": null, "Conv_Repair_Issue": null, "Conv_RepairNotes": null, "PIPE_Cleaned": null, "PipeDateLastCleaned": null, "ConvRepairAs": null, "Conv_Blockage": null, "Asses_Date2": null, "SR_NOb": null, "Material_PipeReplace": null, "Length_PipeReplace": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "D", "name": "Ditch", "domains": { "ConveyanceType": {"type": "inherited"}, "TYPE_MATL": {"type": "inherited"}, "ConveyOwner": {"type": "inherited"}, "ConveyShape": {"type": "inherited"}, "Conv_RepairResp": {"type": "inherited"}, "Conv_RepairStatus": {"type": "inherited"}, "Conv_Repair_Issue": {"type": "inherited"}, "PIPE_Cleaned": {"type": "inherited"}, "ConvRepairAs": {"type": "inherited"}, "Conv_Blockage": {"type": "inherited"}, "Material_PipeReplace": {"type": "inherited"}, "VideoPipeInsp": {"type": "inherited"}, "Convsafety_score": {"type": "inherited"} }, "templates": [ { "name": "D", "description": "", "prototype": { "attributes": { "Convsafety_score": null, "Conv_GlobalID_on_add": null, "ConveyanceType": "D", "TYPE_MATL": null, "DIM_OUTFALL": null, "HT_OUTFALL": null, "WT_OUTFALL": null, "MDE_GDB_ID": null, "ConveyStatus": null, "ConveyOwner": null, "invert_in_elevation": null, "invert_out_elevation": null, "plan_length": null, "upstrm_globalid": null, "dnstrm_globalid": null, "sd_number": null, "GenCom": null, "invert_in_measurement": null, "invert_out_measurement": null, "top_width": null, "bottom_width": null, "depth": null, "dpw_channel_id": null, "dpw_channel_name": null, "x_area": null, "ConveyShape": null, "Length_Pipe_Cleaned": null, "Length_Pipe_Insp": null, "Conv_Assess_Com": null, "VideoPipeInspDate": null, "VideoPipeInsp": null, "GeomLengthFt": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Slope": null, "Conveyance_AGE": null, "Conv_RepairResp": null, "Conv_RepairStatus": null, "Conv_RepairDate": null, "Conv_Repair_Issue": null, "Conv_RepairNotes": null, "PIPE_Cleaned": null, "PipeDateLastCleaned": null, "ConvRepairAs": null, "Conv_Blockage": null, "Asses_Date2": null, "SR_NOb": null, "Material_PipeReplace": null, "Length_PipeReplace": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "HC", "name": "Hydraulic Connector", "domains": { "ConveyanceType": {"type": "inherited"}, "TYPE_MATL": {"type": "inherited"}, "ConveyOwner": {"type": "inherited"}, "ConveyShape": {"type": "inherited"}, "Conv_RepairResp": {"type": "inherited"}, "Conv_RepairStatus": {"type": "inherited"}, "Conv_Repair_Issue": {"type": "inherited"}, "PIPE_Cleaned": {"type": "inherited"}, "ConvRepairAs": {"type": "inherited"}, "Conv_Blockage": {"type": "inherited"}, "Material_PipeReplace": {"type": "inherited"}, "VideoPipeInsp": {"type": "inherited"}, "Convsafety_score": {"type": "inherited"} }, "templates": [ { "name": "HC", "description": "", "prototype": { "attributes": { "Convsafety_score": null, "Conv_GlobalID_on_add": null, "ConveyanceType": "HC", "TYPE_MATL": null, "DIM_OUTFALL": null, "HT_OUTFALL": null, "WT_OUTFALL": null, "MDE_GDB_ID": null, "ConveyStatus": null, "ConveyOwner": null, "invert_in_elevation": null, "invert_out_elevation": null, "plan_length": null, "upstrm_globalid": null, "dnstrm_globalid": null, "sd_number": null, "GenCom": null, "invert_in_measurement": null, "invert_out_measurement": null, "top_width": null, "bottom_width": null, "depth": null, "dpw_channel_id": null, "dpw_channel_name": null, "x_area": null, "ConveyShape": null, "Length_Pipe_Cleaned": null, "Length_Pipe_Insp": null, "Conv_Assess_Com": null, "VideoPipeInspDate": null, "VideoPipeInsp": null, "GeomLengthFt": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Slope": null, "Conveyance_AGE": null, "Conv_RepairResp": null, "Conv_RepairStatus": null, "Conv_RepairDate": null, "Conv_Repair_Issue": null, "Conv_RepairNotes": null, "PIPE_Cleaned": null, "PipeDateLastCleaned": null, "ConvRepairAs": null, "Conv_Blockage": null, "Asses_Date2": null, "SR_NOb": null, "Material_PipeReplace": null, "Length_PipeReplace": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "OC", "name": "Open Channel", "domains": { "ConveyanceType": {"type": "inherited"}, "TYPE_MATL": {"type": "inherited"}, "ConveyOwner": {"type": "inherited"}, "ConveyShape": {"type": "inherited"}, "Conv_RepairResp": {"type": "inherited"}, "Conv_RepairStatus": {"type": "inherited"}, "Conv_Repair_Issue": {"type": "inherited"}, "PIPE_Cleaned": {"type": "inherited"}, "ConvRepairAs": {"type": "inherited"}, "Conv_Blockage": {"type": "inherited"}, "Material_PipeReplace": {"type": "inherited"}, "VideoPipeInsp": {"type": "inherited"}, "Convsafety_score": {"type": "inherited"} }, "templates": [ { "name": "OC", "description": "", "prototype": { "attributes": { "Convsafety_score": null, "Conv_GlobalID_on_add": null, "ConveyanceType": "OC", "TYPE_MATL": null, "DIM_OUTFALL": null, "HT_OUTFALL": null, "WT_OUTFALL": null, "MDE_GDB_ID": null, "ConveyStatus": null, "ConveyOwner": null, "invert_in_elevation": null, "invert_out_elevation": null, "plan_length": null, "upstrm_globalid": null, "dnstrm_globalid": null, "sd_number": null, "GenCom": null, "invert_in_measurement": null, "invert_out_measurement": null, "top_width": null, "bottom_width": null, "depth": null, "dpw_channel_id": null, "dpw_channel_name": null, "x_area": null, "ConveyShape": null, "Length_Pipe_Cleaned": null, "Length_Pipe_Insp": null, "Conv_Assess_Com": null, "VideoPipeInspDate": null, "VideoPipeInsp": null, "GeomLengthFt": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Slope": null, "Conveyance_AGE": null, "Conv_RepairResp": null, "Conv_RepairStatus": null, "Conv_RepairDate": null, "Conv_Repair_Issue": null, "Conv_RepairNotes": null, "PIPE_Cleaned": null, "PipeDateLastCleaned": null, "ConvRepairAs": null, "Conv_Blockage": null, "Asses_Date2": null, "SR_NOb": null, "Material_PipeReplace": null, "Length_PipeReplace": null } }, "drawingTool": "esriFeatureEditToolLine" } ] }, { "id": "P", "name": "Pipe", "domains": { "ConveyanceType": {"type": "inherited"}, "TYPE_MATL": {"type": "inherited"}, "ConveyOwner": {"type": "inherited"}, "ConveyShape": {"type": "inherited"}, "Conv_RepairResp": {"type": "inherited"}, "Conv_RepairStatus": {"type": "inherited"}, "Conv_Repair_Issue": {"type": "inherited"}, "PIPE_Cleaned": {"type": "inherited"}, "ConvRepairAs": {"type": "inherited"}, "Conv_Blockage": {"type": "inherited"}, "Material_PipeReplace": {"type": "inherited"}, "VideoPipeInsp": {"type": "inherited"}, "Convsafety_score": {"type": "inherited"} }, "templates": [ { "name": "P", "description": "", "prototype": { "attributes": { "Convsafety_score": null, "Conv_GlobalID_on_add": null, "ConveyanceType": "P", "TYPE_MATL": null, "DIM_OUTFALL": null, "HT_OUTFALL": null, "WT_OUTFALL": null, "MDE_GDB_ID": null, "ConveyStatus": null, "ConveyOwner": null, "invert_in_elevation": null, "invert_out_elevation": null, "plan_length": null, "upstrm_globalid": null, "dnstrm_globalid": null, "sd_number": null, "GenCom": null, "invert_in_measurement": null, "invert_out_measurement": null, "top_width": null, "bottom_width": null, "depth": null, "dpw_channel_id": null, "dpw_channel_name": null, "x_area": null, "ConveyShape": null, "Length_Pipe_Cleaned": null, "Length_Pipe_Insp": null, "Conv_Assess_Com": null, "VideoPipeInspDate": null, "VideoPipeInsp": null, "GeomLengthFt": null, "EdCom": null, "FieldVer": null, "FieldVerDate": null, "Slope": null, "Conveyance_AGE": null, "Conv_RepairResp": null, "Conv_RepairStatus": null, "Conv_RepairDate": null, "Conv_Repair_Issue": null, "Conv_RepairNotes": null, "PIPE_Cleaned": null, "PipeDateLastCleaned": null, "ConvRepairAs": null, "Conv_Blockage": null, "Asses_Date2": null, "SR_NOb": null, "Material_PipeReplace": null, "Length_PipeReplace": null } }, "drawingTool": "esriFeatureEditToolLine" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Outfall Drainage Area", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "Records from storm drains built since 2013 should have drainage areas from as built plans, else earlier records were digitized from contours and existing pipe network.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "StormDrainStructures", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "MDE_GDB_ID_Outfall", "composite": false, "catalogID": "{6BF330AA-A244-44B6-B110-E52202ECECFE}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "modelName": "GP_248342601", "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 1296874.3665691614, "ymin": 321070.525762558, "xmax": 1401796.0235233307, "ymax": 530272.9702177346, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.00328083333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 169, 28, 28, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "MDE_GDB_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MDE_GDB_ID", "type": "esriFieldTypeString", "alias": "MDE_GDB_ID", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "MDE_GDB_ID" }, { "name": "MDE_GDB_ID_Outfall", "type": "esriFieldTypeString", "alias": "MDE GDB ID of Outfall", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "MDE_GDB_ID_Outfall" }, { "name": "OUTFALL_DRAIN_AREA", "type": "esriFieldTypeDouble", "alias": "Drainage area (acres) to outfall", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUTFALL_DRAIN_AREA" }, { "name": "SD_Number", "type": "esriFieldTypeString", "alias": "SD Number", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "SD_Number" }, { "name": "GEN_COMMENTS", "type": "esriFieldTypeString", "alias": "General comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GEN_COMMENTS" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created by", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Date created", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last edited by", "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R502_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_502", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S233_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Outfall Drainage Area", "description": "", "prototype": { "attributes": { "SD_Number": null, "GEN_COMMENTS": null, "MDE_GDB_ID": null, "MDE_GDB_ID_Outfall": null, "OUTFALL_DRAIN_AREA": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "SDC_Cleaning", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 7, "name": "StormDrainConveyance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "rel_globalid", "composite": false, "catalogID": "{95E59396-4EAA-4B48-8D98-1787D59255D4}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "conv_pipe_cleaned", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "rel_globalid", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "rel_globalid" }, { "name": "conv_pipe_cleaned", "type": "esriFieldTypeString", "alias": "Pipe Cleaned", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "inlet_cleaned" }, { "name": "conv_date_cleaned", "type": "esriFieldTypeDate", "alias": "Date Cleaned", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_last_cleaned" }, { "name": "Conv_comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "C_meets_criteria_yn", "type": "esriFieldTypeString", "alias": "Meets Criteria", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "meets_criteria_yn" }, { "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": "Length_Pipe_Cleaned", "type": "esriFieldTypeDouble", "alias": "Length of Pipe Cleaned (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_Pipe_Cleaned" } ], "indexes": [ { "name": "R771_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5848_rel_glo", "fields": "rel_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_771", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDC_Cleaning", "description": "", "prototype": { "attributes": { "C_meets_criteria_yn": null, "Length_Pipe_Cleaned": null, "rel_globalid": null, "conv_pipe_cleaned": null, "conv_date_cleaned": null, "Conv_comments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "SDC_Condition", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 8, "name": "StormDrainConveyance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "rel_globalid", "composite": false, "catalogID": "{EE48D515-785A-423A-B3BE-CBCA6CAFFD83}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "safety_score2", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "safety_score2", "type": "esriFieldTypeString", "alias": "Safety Score", "domain": { "type": "codedValue", "name": "dOSDMSafety_Score", "description": "OSDM Safety score related to structure", "codedValues": [ { "name": "No Safety Hazard Observed", "code": "No Safety Hazard Observed" }, { "name": "Low Risk Safety Hazard Observed", "code": "Low Risk Safety Hazard Observed" }, { "name": "Moderate Risk Safety Hazard Observed", "code": "Moderate Risk Safety Hazard Observed" }, { "name": "Significant/High Risk Safety Hazard Observed", "code": "Significant/High Risk Safety Hazard Observed" }, { "name": "Severe/Immediate Risk Safety Hazard Observed", "code": "Severe/Immediate Risk Safety Hazard Observed" }, { "name": "Could not evaluate", "code": "Could not evaluate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SAFETY_SCORE" }, { "name": "blockage2", "type": "esriFieldTypeString", "alias": "Blockage Extent", "domain": { "type": "codedValue", "name": "dOSDM_Blockage", "description": "Blockage Description", "codedValues": [ { "name": "0% - 25% None to Little Blockage", "code": "Low Blockage" }, { "name": "26% to 75% Blockage", "code": "Moderate Blockage" }, { "name": "Greater than 76% Blockage", "code": "High Blockage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "BLOCKAGE" }, { "name": "ConvRepairEval2", "type": "esriFieldTypeString", "alias": "Repair Assessment Indicator", "domain": { "type": "codedValue", "name": "dOSDM_RepairRec", "description": "Repair Recommendations", "codedValues": [ { "name": "Significant Repairs Recommended", "code": "Significant" }, { "name": "No Repairs Recommended", "code": "NA" }, { "name": "Moderate Repairs Recommended", "code": "Moderate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "CONDITION" }, { "name": "assess_comments2", "type": "esriFieldTypeString", "alias": "Assesment Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSESS_COMMENTS" }, { "name": "assess_date2", "type": "esriFieldTypeDate", "alias": "Assement Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ASSESS_DATE" }, { "name": "rel_globalid", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "VideoPipeInsp", "type": "esriFieldTypeString", "alias": "Video Pipe Inspection", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VideoPipeInsp" }, { "name": "VideoPipeInspDate", "type": "esriFieldTypeDate", "alias": "Video Pipe Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "VideoPipeInspDate" }, { "name": "Length_Pipe_Insp", "type": "esriFieldTypeDouble", "alias": "Length of Pipe Inspected (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_Pipe_Insp" } ], "indexes": [ { "name": "R772_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5849_rel_glo", "fields": "rel_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_772", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDC_Condition", "description": "", "prototype": { "attributes": { "VideoPipeInspDate": null, "VideoPipeInsp": null, "safety_score2": null, "blockage2": null, "ConvRepairEval2": null, "assess_comments2": null, "assess_date2": null, "rel_globalid": null, "Length_Pipe_Insp": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "SDC_Repairs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "StormDrainConveyance", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "REL_GUID", "composite": false, "catalogID": "{22777A1F-01AF-4D80-8E63-FFB75D7772B5}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "created_user", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "REL_GUID", "type": "esriFieldTypeGUID", "alias": "REL_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_GUID" }, { "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": "Conv_RepairResp3", "type": "esriFieldTypeString", "alias": "Repair Responsibility", "domain": { "type": "codedValue", "name": "dOSDM_MaintResp", "description": "Maintenance Responsibility", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3" }, { "name": "Clean Water Partnership", "code": "CWP" }, { "name": "In-House", "code": "IN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_RepairResp3" }, { "name": "Conv_RepairDate3", "type": "esriFieldTypeDate", "alias": "Repair Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Conv_RepairDate3" }, { "name": "Conv_Repair_Issue3", "type": "esriFieldTypeString", "alias": "Repair Issue", "domain": { "type": "codedValue", "name": "dOSDMConvRepairIssue", "description": "OSDM Conveyance Repair Issues", "codedValues": [ { "name": "Reset", "code": "Reset" }, { "name": "Replace", "code": "Replace" }, { "name": "Replace - Upgrade", "code": "RU" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_Repair_Issue3" }, { "name": "Conv_RepairNotes3", "type": "esriFieldTypeString", "alias": "Repair Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Conv_RepairNotes3" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "SR_NOb3", "type": "esriFieldTypeString", "alias": "Service Request Number", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "SR_NOb3" }, { "name": "Material_PipeReplace", "type": "esriFieldTypeString", "alias": "Material of Replaced Pipe", "domain": { "type": "codedValue", "name": "dStormDrain_ConveyanceMaterial", "description": "Conveyance Material Type", "codedValues": [ { "name": "Asphalt Coated Corrugated Metal Pipe", "code": "ACCMP" }, { "name": "Aluminum Spiral Rib Pipe", "code": "ASRP" }, { "name": "Bituminous Coated Corrugated Metal Pipe", "code": "BCCMP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Concrete", "code": "CONC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Other", "code": "OTH" }, { "name": "Polyvinyl Chloride (PVC) Pipe", "code": "PVC" }, { "name": "Reinforced Concrete Pipe", "code": "RCP" }, { "name": "Structural Plate Pipe", "code": "SPP" }, { "name": "Stream", "code": "STR" }, { "name": "Terracotta Pipe", "code": "TCP" }, { "name": "Unknown", "code": "UNK" }, { "name": "Vitrified Clay", "code": "VC" }, { "name": "Vegetated Channel", "code": "VEG" }, { "name": "Perforated PVC", "code": "PPVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Material_PipeReplace" }, { "name": "Length_PipeReplace", "type": "esriFieldTypeDouble", "alias": "Length of Replaced Pipe (FT)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Length_PipeReplace" } ], "indexes": [ { "name": "R773_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5850_REL_GUI", "fields": "REL_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_773", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDC_Repairs", "description": "", "prototype": { "attributes": { "Material_PipeReplace": null, "SR_NOb3": null, "REL_GUID": null, "Length_PipeReplace": null, "Conv_RepairNotes3": null, "Conv_Repair_Issue3": null, "Conv_RepairDate3": null, "Conv_RepairResp3": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "SDS_Cleaning", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "StormDrainStructures", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "rel_globalid", "composite": false, "catalogID": "{45CECFD0-D9C8-420E-B808-21E21433B93A}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "inlet_cleaned", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "rel_globalid", "type": "esriFieldTypeGUID", "alias": "KCI Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "rel_globalid" }, { "name": "inlet_cleaned", "type": "esriFieldTypeString", "alias": "Inlet Cleaned", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "inlet_cleaned" }, { "name": "st_date_cleaned", "type": "esriFieldTypeDate", "alias": "Date Cleaned", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_last_cleaned" }, { "name": "st_comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "meets_criteria_yn", "type": "esriFieldTypeString", "alias": "Meets Criteria", "domain": { "type": "codedValue", "name": "d_Boolean", "description": "Boolean (Yes/No/NA", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "meets_criteria_yn" }, { "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": "R774_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5851_rel_glo", "fields": "rel_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_774", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDS_Cleaning", "description": "", "prototype": { "attributes": { "meets_criteria_yn": null, "st_comments": null, "rel_globalid": null, "inlet_cleaned": null, "st_date_cleaned": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "SDS_Condition", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "StormDrainStructures", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "rel_globalid", "composite": false, "catalogID": "{4907AB96-09D7-4537-879E-51E4587F7428}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "safety_score", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "safety_score", "type": "esriFieldTypeString", "alias": "Safety Score", "domain": { "type": "codedValue", "name": "dOSDMSafety_Score", "description": "OSDM Safety score related to structure", "codedValues": [ { "name": "No Safety Hazard Observed", "code": "No Safety Hazard Observed" }, { "name": "Low Risk Safety Hazard Observed", "code": "Low Risk Safety Hazard Observed" }, { "name": "Moderate Risk Safety Hazard Observed", "code": "Moderate Risk Safety Hazard Observed" }, { "name": "Significant/High Risk Safety Hazard Observed", "code": "Significant/High Risk Safety Hazard Observed" }, { "name": "Severe/Immediate Risk Safety Hazard Observed", "code": "Severe/Immediate Risk Safety Hazard Observed" }, { "name": "Could not evaluate", "code": "Could not evaluate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SAFETY_SCORE" }, { "name": "blockage", "type": "esriFieldTypeString", "alias": "Blockage Extent", "domain": { "type": "codedValue", "name": "dOSDM_Blockage", "description": "Blockage Description", "codedValues": [ { "name": "0% - 25% None to Little Blockage", "code": "Low Blockage" }, { "name": "26% to 75% Blockage", "code": "Moderate Blockage" }, { "name": "Greater than 76% Blockage", "code": "High Blockage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "BLOCKAGE" }, { "name": "RepairEval", "type": "esriFieldTypeString", "alias": "Repair Assessment Indicator", "domain": { "type": "codedValue", "name": "dOSDM_RepairRec", "description": "Repair Recommendations", "codedValues": [ { "name": "Significant Repairs Recommended", "code": "Significant" }, { "name": "No Repairs Recommended", "code": "NA" }, { "name": "Moderate Repairs Recommended", "code": "Moderate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "CONDITION" }, { "name": "assess_comments", "type": "esriFieldTypeString", "alias": "Assesment Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSESS_COMMENTS" }, { "name": "assess_date", "type": "esriFieldTypeDate", "alias": "Assessment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ASSESS_DATE" }, { "name": "rel_globalid", "type": "esriFieldTypeGUID", "alias": "KCI Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_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": "top_stable", "type": "esriFieldTypeString", "alias": "Top is Stable", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "top_stable_" }, { "name": "LAB_GUID", "type": "esriFieldTypeGUID", "alias": "Lab Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "LAB_GUID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R775_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5852_rel_glo", "fields": "rel_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_775", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDS_Condition", "description": "", "prototype": { "attributes": { "LAB_GUID": null, "top_stable": null, "safety_score": null, "blockage": null, "RepairEval": null, "assess_comments": null, "assess_date": null, "rel_globalid": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "SDS_Repairs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 5, "name": "ESMGDB.PGCSW.StormDrainStructures", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "REL_GUID", "composite": false, "catalogID": "{79F98C92-8A9B-4DE3-A66A-16BCD9024AB6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ST_RepairDate3", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ST_RepairDate3", "type": "esriFieldTypeDate", "alias": "Repair Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ST_RepairDate3" }, { "name": "ST_Repair_Issue3", "type": "esriFieldTypeString", "alias": "Repair Issue", "domain": { "type": "codedValue", "name": "dOSDMStructRepairIssue", "description": "OSDM Structure Repair Issues", "codedValues": [ { "name": "Total Rebuild", "code": "TR" }, { "name": "Brick Work - Parging", "code": "BWP" }, { "name": "Reset Top Slab", "code": "Reset" }, { "name": "Pipe Connection", "code": "PC" }, { "name": "Crushed Top Slab", "code": "CTS" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_Repair_Issue3" }, { "name": "ST_RepairNotes3", "type": "esriFieldTypeString", "alias": "Repair Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_RepairNotes3" }, { "name": "ST_RepairResp3", "type": "esriFieldTypeString", "alias": "Repair Responsibility", "domain": { "type": "codedValue", "name": "dOSDM_MaintResp", "description": "Maintenance Responsibility", "codedValues": [ { "name": "Contractor 1", "code": "C1" }, { "name": "Contractor 2", "code": "C2" }, { "name": "Contractor 3", "code": "C3" }, { "name": "Clean Water Partnership", "code": "CWP" }, { "name": "In-House", "code": "IN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ST_RepairResp3" }, { "name": "REL_GUID", "type": "esriFieldTypeGUID", "alias": "REL_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "REL_GUID" }, { "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "SR3", "type": "esriFieldTypeString", "alias": "Service Request Number", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "SR3" } ], "indexes": [ { "name": "R776_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_776", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5853_REL_GUI", "fields": "REL_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SDS_Repairs", "description": "", "prototype": { "attributes": { "SR3": null, "REL_GUID": null, "ST_RepairDate3": null, "ST_Repair_Issue3": null, "ST_RepairNotes3": null, "ST_RepairResp3": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }