{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "Oil and Grit Separators", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "

Imported from CAD drawing from Ajax Engineering<\/SPAN><\/P>

To demonstrate locations of Storm Septor Locations, private and publicly owned<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "Town of Ajax Engineering Department, Town of Ajax GIS Section", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1708712613000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -8802713.70894749, "ymin": 5437978.856720108, "xmax": -8793387.095142877, "ymax": 5450581.169786552, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "a6fb22cbfa75235394c80bc237a0b35c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAsAAAASCAYAAACNdSR1AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA4UlEQVQokZWS2xGCMBBFz4dNSBuxDGiDlEEsg5Rh2pA2oA3nbgiDURi9H2E2c/bug1z4Q5eD+waYf4F7YATuQDiD3QpKAxD3FWo46EgJus5iJXbfYAe0fQ9tC/rGSLveTzUcmiZDFgSDi/ttDwsxVycf4HrNCSGYs1pJG+wcDBppJ8Xqf5rMfYObZeFMtpEC+3nmoR5Lz5LiyUaznW9w0sTe4wos6G6IbSLV2/DA03sYx+w659+RUypYDjHGPOy6Np3mWsPFpZc7oJFzygGswkrQEm2OM1jS+3h7QGdwqfChFzomSBCp9CSxAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 8, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FACILTYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILTYID", "type": "esriFieldTypeInteger", "alias": "FACILTYID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FACILTYID" }, { "name": "LABEL", "type": "esriFieldTypeString", "alias": "LABEL", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "LABEL" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "INF_REV_AREA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INF_REV_AREA" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LEGACYID" }, { "name": "ASSET_ID_NUM", "type": "esriFieldTypeString", "alias": "ASSET_ID_NUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ASSET_ID_NUM" }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "STRUCT_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRUCT_TYPE" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "MODEL" }, { "name": "INV_1", "type": "esriFieldTypeString", "alias": "INV_1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INV_1" }, { "name": "INV_2", "type": "esriFieldTypeString", "alias": "INV_2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INV_2" }, { "name": "INV_3", "type": "esriFieldTypeString", "alias": "INV_OTHER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INV_3" }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OWNER" }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MAINT_DATE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "REPAIR_DATE", "type": "esriFieldTypeDate", "alias": "REPAIR_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPAIR_DATE" }, { "name": "WORK_PERF", "type": "esriFieldTypeString", "alias": "WORK_PERF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WORK_PERF" }, { "name": "C_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "C_ASSESS_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "C_ASSESS_DATE" }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AGE" }, { "name": "REM_LIFE", "type": "esriFieldTypeString", "alias": "REM_LIFE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "REM_LIFE" }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BARCODE" }, { "name": "ASSUMED", "type": "esriFieldTypeString", "alias": "ASSUMEDD", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "Not Assumed", "modelName": "ASSUMED" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "LATITUDE_", "type": "esriFieldTypeDouble", "alias": "Latitude_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LATITUDE_" }, { "name": "LONGITUDE_", "type": "esriFieldTypeDouble", "alias": "Longitude_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONGITUDE_" }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location ID #", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATIONID" }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INFRASTRUCTURE_AREA" }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION" }, { "name": "MUNICIPAL_ADDRESS", "type": "esriFieldTypeString", "alias": "Municipal Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MUNICIPAL_ADDRESS" }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LEGAL_DESCRIPTION" }, { "name": "L1_ASSETCLASS", "type": "esriFieldTypeString", "alias": "Level 1: Asset Class", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L1_ASSETCLASS" }, { "name": "L2_ASSETCATEGORY", "type": "esriFieldTypeString", "alias": "Level 2: Asset Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L2_ASSETCATEGORY" }, { "name": "L3_ASSETTYPE", "type": "esriFieldTypeString", "alias": "Level 3: Asset Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L3_ASSETTYPE" }, { "name": "L4_SPECIFICGROUPEDASSETS", "type": "esriFieldTypeString", "alias": "Level 4: Specific Grouped Assets", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L4_SPECIFICGROUPEDASSETS" }, { "name": "TCACATEGORY", "type": "esriFieldTypeString", "alias": "TCA Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TCACATEGORY" }, { "name": "AGE_", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AGE_" }, { "name": "YEARINSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEARINSTALLED" }, { "name": "ASSUMED_", "type": "esriFieldTypeString", "alias": "Assumed_", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSUMED_" }, { "name": "COMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Commissioned Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMMISSIONEDDATE" }, { "name": "DECOMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DECOMMISSIONEDDATE" }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTINSPECTIONDATE" }, { "name": "YEARRENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Year Renewed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEARRENEWED" }, { "name": "LASTRENEWALACTIVITY", "type": "esriFieldTypeString", "alias": "Last Renewal Activity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LASTRENEWALACTIVITY" }, { "name": "REPLACEMENTUNITCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTUNITCOST" }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTCOST" }, { "name": "PHYSICALCONDITION", "type": "esriFieldTypeString", "alias": "Physical Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PHYSICALCONDITION" }, { "name": "FUNCTIONALCONDITION", "type": "esriFieldTypeString", "alias": "Functional Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTIONALCONDITION" }, { "name": "DEMANDCONDITION", "type": "esriFieldTypeString", "alias": "Demand Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEMANDCONDITION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATED_USER" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LAST_EDITED_USER" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R642_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A566_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Oil and Grit Separators", "description": "", "prototype": { "attributes": { "STATUS": null, "FACILTYID": null, "LABEL": null, "FACILITYID": null, "INF_REV_AREA": null, "WARRANTYDATE": null, "INSTALLDATE": null, "LOCATION": null, "LEGACYID": null, "ASSET_ID_NUM": null, "STRUCT_TYPE": null, "MODEL": null, "INV_1": null, "INV_2": null, "INV_3": null, "OWNER": null, "MAINT_DATE": null, "INSP_DATE": null, "REPAIR_DATE": null, "WORK_PERF": null, "C_ASSESS_DATE": null, "AGE": null, "REM_LIFE": null, "BARCODE": null, "ASSUMED": "Not Assumed", "ASSETID_CW": null, "LATITUDE_": null, "LONGITUDE_": null, "LOCATIONID": null, "INFRASTRUCTURE_AREA": null, "LOCATION_DESCRIPTION": null, "MUNICIPAL_ADDRESS": null, "LEGAL_DESCRIPTION": null, "L1_ASSETCLASS": null, "L2_ASSETCATEGORY": null, "L3_ASSETTYPE": null, "L4_SPECIFICGROUPEDASSETS": null, "TCACATEGORY": null, "AGE_": null, "YEARINSTALLED": null, "ASSUMED_": null, "COMMISSIONEDDATE": null, "DECOMMISSIONEDDATE": null, "LASTINSPECTIONDATE": null, "YEARRENEWED": null, "LASTRENEWALACTIVITY": null, "REPLACEMENTUNITCOST": null, "REPLACEMENTCOST": null, "PHYSICALCONDITION": null, "FUNCTIONALCONDITION": null, "DEMANDCONDITION": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Manhole", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 24000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATEDATE", "creatorField": "CREATEDBY", "editDateField": "EDITDATE", "editorField": "EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Inspection", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID_CW", "composite": false, "catalogID": "{F9A624C4-9811-4A2B-8186-B36D5E42EA9A}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1713805692000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -8803269.224753687, "ymin": 5433949.497696825, "xmax": -8787726.292289272, "ymax": 5453070.445877461, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 2.56000000238419E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120899.99999281, "falseY": -9998099.99996649, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 170, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "MPLAN", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "MPLAN", "type": "esriFieldTypeString", "alias": "MPLAN", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MPLAN" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "*LOCATION AGE*", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "*AGE*", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AGE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "DEPTH_M", "type": "esriFieldTypeDouble", "alias": "Depth (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH_M" }, { "name": "RIM_ELEV_M", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIM_ELEV_M" }, { "name": "DIAMETER_M", "type": "esriFieldTypeDouble", "alias": "Diameter (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER_M" }, { "name": "INVERT_N", "type": "esriFieldTypeDouble", "alias": "N Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_N" }, { "name": "INVERT_NE", "type": "esriFieldTypeDouble", "alias": "NE Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_NE" }, { "name": "INVERT_E", "type": "esriFieldTypeDouble", "alias": "E Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_E" }, { "name": "INVERT_SE", "type": "esriFieldTypeDouble", "alias": "SE Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_SE" }, { "name": "INVERT_S", "type": "esriFieldTypeDouble", "alias": "S Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_S" }, { "name": "INVERT_SW", "type": "esriFieldTypeDouble", "alias": "SW Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_SW" }, { "name": "INVERT_W", "type": "esriFieldTypeDouble", "alias": "W Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_W" }, { "name": "INVERT_NW", "type": "esriFieldTypeDouble", "alias": "NW Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INVERT_NW" }, { "name": "DROP_STRUCT", "type": "esriFieldTypeString", "alias": "Drop Structure", "domain": { "type": "codedValue", "name": "YN", "description": "", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "N", "modelName": "DROP_STRUCT" }, { "name": "DROP_STRUCT_DIR", "type": "esriFieldTypeString", "alias": "Drop Structure Direction", "domain": { "type": "codedValue", "name": "Direction", "description": "", "codedValues": [ { "name": "East", "code": "East" }, { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Northwest", "code": "Northwest" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "North/South", "code": "North/South" }, { "name": "East/West", "code": "East/West" }, { "name": "Northeast/Southwest", "code": "Northeast/Southwest" }, { "name": "Northwest/Southeast", "code": "Northwest/Southeast" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DROP_STRUCT_DIR" }, { "name": "DROP_STRUCT_SIZE", "type": "esriFieldTypeDouble", "alias": "Drop Structure Pipe Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DROP_STRUCT_SIZE" }, { "name": "SAFETY_PLATFORM", "type": "esriFieldTypeString", "alias": "Safety Platform", "domain": { "type": "codedValue", "name": "YN", "description": "", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "N", "modelName": "SAFETY_PLATFORM" }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "domain": { "type": "codedValue", "name": "swManholeType", "description": "", "codedValues": [ { "name": "MH", "code": "MH" }, { "name": "CBMH", "code": "CBMH" }, { "name": "Diversion MH", "code": "Diversion MH" }, { "name": "RLCBMH", "code": "RLCBMH" }, { "name": "Control MH", "code": "Control MH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "MH", "modelName": "STRUCT_TYPE" }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "Ownership", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "Unassumed", "modelName": "OWNERSHIP" }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "domain": { "type": "codedValue", "name": "swInfrArea", "description": "", "codedValues": [ { "name": "PS1", "code": "PS1" }, { "name": "PS2", "code": "PS2" }, { "name": "PS3", "code": "PS3" }, { "name": "PS4", "code": "PS4" }, { "name": "PS5", "code": "PS5" }, { "name": "PS6", "code": "PS6" }, { "name": "PN1", "code": "PN1" }, { "name": "PN2", "code": "PN2" }, { "name": "PN3", "code": "PN3" }, { "name": "PN4", "code": "PN4" }, { "name": "PN5", "code": "PN5" }, { "name": "PN6", "code": "PN6" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INFRASTRUCTURE_AREA" }, { "name": "COND_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assess Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COND_ASSESS_DATE" }, { "name": "PHYSICAL_COND", "type": "esriFieldTypeString", "alias": "Physical Condition", "domain": { "type": "codedValue", "name": "swCondition", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PHYSICAL_COND" }, { "name": "FUNCTIONAL_COND", "type": "esriFieldTypeString", "alias": "Functional Condition", "domain": { "type": "codedValue", "name": "swCondition", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTIONAL_COND" }, { "name": "DEMAND_COND", "type": "esriFieldTypeString", "alias": "Demand Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEMAND_COND" }, { "name": "REPLACEMENT_COST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENT_COST" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "ROAD_CLASS", "type": "esriFieldTypeString", "alias": "Road Classification", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ROAD_CLASS" }, { "name": "LOT_PARK_NAME", "type": "esriFieldTypeString", "alias": "Parking Lot/Park Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOT_PARK_NAME" }, { "name": "MANHOLE_OPSD", "type": "esriFieldTypeString", "alias": "Manhole OPSD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANHOLE_OPSD" }, { "name": "LID_OPSD", "type": "esriFieldTypeString", "alias": "Lid OPSD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LID_OPSD" }, { "name": "TERM_STRUCT_ID", "type": "esriFieldTypeString", "alias": "Terminal Structure Asset ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TERM_STRUCT_ID" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDITOR" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITDATE" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_NAME" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R453780_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_453780", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_453780", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A2363_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Manhole", "description": "", "prototype": { "attributes": { "LOCATION_NAME": null, "TERM_STRUCT_ID": null, "FACILITYID": null, "NOTES": null, "MPLAN": null, "LOCATION": null, "AGE": null, "INSTALL_DATE": null, "DEPTH_M": null, "RIM_ELEV_M": null, "DIAMETER_M": null, "INVERT_N": null, "INVERT_NE": null, "INVERT_E": null, "INVERT_SE": null, "INVERT_S": null, "INVERT_SW": null, "INVERT_W": null, "INVERT_NW": null, "DROP_STRUCT": "N", "DROP_STRUCT_DIR": null, "DROP_STRUCT_SIZE": null, "SAFETY_PLATFORM": "N", "STRUCT_TYPE": "MH", "OWNERSHIP": "Unassumed", "INFRASTRUCTURE_AREA": null, "COND_ASSESS_DATE": null, "PHYSICAL_COND": null, "FUNCTIONAL_COND": null, "DEMAND_COND": null, "REPLACEMENT_COST": null, "WARRANTY_DATE": null, "ROAD_CLASS": null, "LOT_PARK_NAME": null, "MANHOLE_OPSD": null, "LID_OPSD": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "Catchbasin", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 24000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATEDATE", "creatorField": "CREATEDBY", "editDateField": "EDITDATE", "editorField": "EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "Inspections", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID_CW", "composite": false, "catalogID": "{5973219A-C443-4843-B1A4-4290EEC60DFA}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1713805627000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -1.0210211985654611E7, "ymin": 4728184.897921926, "xmax": -8787079.905081777, "ymax": 5455577.381541425, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 2.56000000238419E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120899.99999281, "falseY": -9998099.99996649, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "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 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "STRUCT_TYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "CityWorks ID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "MPLAN", "type": "esriFieldTypeString", "alias": "MPlan", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MPLAN" }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "*AGE*", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AGE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "TYPE", "type": "esriFieldTypeInteger", "alias": "*TYPE*", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TYPE" }, { "name": "STRUCT_TYPEX", "type": "esriFieldTypeString", "alias": "*TYPE_TEXT*", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRUCT_TYPEX" }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRUCT_TYPE" }, { "name": "SUBDRAIN", "type": "esriFieldTypeString", "alias": "Subdrain", "domain": { "type": "codedValue", "name": "YN", "description": "", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "SUBDRAIN" }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "Ownership", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "Unassumed", "modelName": "OWNERSHIP" }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "*INF_REV_AREA*", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INF_REV_AREA" }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "domain": { "type": "codedValue", "name": "swInfrArea", "description": "", "codedValues": [ { "name": "PS1", "code": "PS1" }, { "name": "PS2", "code": "PS2" }, { "name": "PS3", "code": "PS3" }, { "name": "PS4", "code": "PS4" }, { "name": "PS5", "code": "PS5" }, { "name": "PS6", "code": "PS6" }, { "name": "PN1", "code": "PN1" }, { "name": "PN2", "code": "PN2" }, { "name": "PN3", "code": "PN3" }, { "name": "PN4", "code": "PN4" }, { "name": "PN5", "code": "PN5" }, { "name": "PN6", "code": "PN6" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INFRASTRUCTURE_AREA" }, { "name": "COND_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assess Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COND_ASSESS_DATE" }, { "name": "PHYSICAL_COND", "type": "esriFieldTypeString", "alias": "Physical Condition", "domain": { "type": "codedValue", "name": "swCondition", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PHYSICAL_COND" }, { "name": "FUNCTIONAL_COND", "type": "esriFieldTypeString", "alias": "Functional Condition", "domain": { "type": "codedValue", "name": "swCondition", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTIONAL_COND" }, { "name": "DEMAND_COND", "type": "esriFieldTypeString", "alias": "Demand Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEMAND_COND" }, { "name": "REPLACEMENT_COST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENT_COST" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "LAST_CLEAN_DATE", "type": "esriFieldTypeDate", "alias": "Last Cleanout Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_CLEAN_DATE" }, { "name": "ROAD_CLASS", "type": "esriFieldTypeString", "alias": "Road Classification", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ROAD_CLASS" }, { "name": "LOT_PARK_NAME", "type": "esriFieldTypeString", "alias": "Parking Lot/Park Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOT_PARK_NAME" }, { "name": "GRATE_OPSD", "type": "esriFieldTypeString", "alias": "Grate OPSD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GRATE_OPSD" }, { "name": "CATCHBASIN_OPSD", "type": "esriFieldTypeString", "alias": "Catchbasin OPSD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CATCHBASIN_OPSD" }, { "name": "BIKE_ROUTE", "type": "esriFieldTypeString", "alias": "Bike Route", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BIKE_ROUTE" }, { "name": "TERM_STRUCT_ID", "type": "esriFieldTypeString", "alias": "Terminal Structure Asset ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TERM_STRUCT_ID" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDITOR" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITDATE" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "Catchbasin_Status", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Removed", "code": "Removed" }, { "name": "Discrepancy", "code": "Discrepancy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_NAME" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R453779_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_453779", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_453779", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A2362_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Catchbasin", "description": "", "prototype": { "attributes": { "STATUS": null, "LOCATION_NAME": null, "FACILITYID": null, "NOTES": null, "MPLAN": null, "AGE": null, "INSTALL_DATE": null, "TYPE": null, "STRUCT_TYPEX": null, "STRUCT_TYPE": null, "SUBDRAIN": "N", "OWNERSHIP": "Unassumed", "INF_REV_AREA": null, "INFRASTRUCTURE_AREA": null, "COND_ASSESS_DATE": null, "PHYSICAL_COND": null, "FUNCTIONAL_COND": null, "DEMAND_COND": null, "REPLACEMENT_COST": null, "WARRANTY_DATE": null, "LAST_CLEAN_DATE": null, "ROAD_CLASS": null, "LOT_PARK_NAME": null, "GRATE_OPSD": null, "CATCHBASIN_OPSD": null, "BIKE_ROUTE": null, "TERM_STRUCT_ID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "Storm Gravity Main", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATEDATE", "creatorField": "CREATEDBY", "editDateField": "EDITDATE", "editorField": "EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "Inspections", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ASSETID_CW", "composite": false, "catalogID": "{55565EE7-7A41-48D0-9FBA-9F9D99669D54}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1752144806000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -1.0210242896853844E7, "ymin": 4728184.897912551, "xmax": -8790573.869547423, "ymax": 5455821.985550973, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 7 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "LOCATION_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "CityWorks ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "Barcode", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "BARCODE" }, { "name": "MPLAN", "type": "esriFieldTypeString", "alias": "MPlan", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MPLAN" }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_NAME" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AGE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "LENGTH_M", "type": "esriFieldTypeDouble", "alias": "Length (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH_M" }, { "name": "DIAMETER_MM", "type": "esriFieldTypeDouble", "alias": "Diameter (mm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER_MM" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "FUNCTION", "type": "esriFieldTypeString", "alias": "Function", "domain": { "type": "codedValue", "name": "swFunctions", "description": "", "codedValues": [ { "name": "Main", "code": "Main" }, { "name": "CB Lead", "code": "CB Lead" }, { "name": "Service Connection", "code": "Service Connection" }, { "name": "Rear Lot CB", "code": "Rear Lot CB" }, { "name": "Culvert", "code": "Culvert" }, { "name": "Open Culvert", "code": "Open Culvert" }, { "name": "FDC", "code": "FDC" }, { "name": "GDC", "code": "GDC" }, { "name": "RDC", "code": "RDC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTION" }, { "name": "DOWNSTREAM_INV", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWNSTREAM_INV" }, { "name": "UPSTREAM_INV", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPSTREAM_INV" }, { "name": "GR_PERCENT", "type": "esriFieldTypeDouble", "alias": "Grade %", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GR_PERCENT" }, { "name": "SECTIONAL_SHAPE", "type": "esriFieldTypeString", "alias": "Sectional Shape", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "Circular", "modelName": "SECTIONAL_SHAPE" }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "Ownership", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "Assumed", "modelName": "OWNERSHIP" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "domain": { "type": "codedValue", "name": "swInfrArea", "description": "", "codedValues": [ { "name": "PS1", "code": "PS1" }, { "name": "PS2", "code": "PS2" }, { "name": "PS3", "code": "PS3" }, { "name": "PS4", "code": "PS4" }, { "name": "PS5", "code": "PS5" }, { "name": "PS6", "code": "PS6" }, { "name": "PN1", "code": "PN1" }, { "name": "PN2", "code": "PN2" }, { "name": "PN3", "code": "PN3" }, { "name": "PN4", "code": "PN4" }, { "name": "PN5", "code": "PN5" }, { "name": "PN6", "code": "PN6" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INFRASTRUCTURE_AREA" }, { "name": "COND_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assess Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COND_ASSESS_DATE" }, { "name": "PHYSICAL_COND", "type": "esriFieldTypeString", "alias": "Physical Condition", "domain": { "type": "codedValue", "name": "swCondition", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PHYSICAL_COND" }, { "name": "DEMAND_COND", "type": "esriFieldTypeString", "alias": "Demand Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEMAND_COND" }, { "name": "FUNCTIONAL_COND", "type": "esriFieldTypeString", "alias": "Functional Condition", "domain": { "type": "codedValue", "name": "swCondition", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTIONAL_COND" }, { "name": "REPLACEMENT_COST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENT_COST" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "DRAIN_AREA", "type": "esriFieldTypeDouble", "alias": "Drainage Area (ha)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DRAIN_AREA" }, { "name": "DRAIN_COEFF", "type": "esriFieldTypeDouble", "alias": "Drainage Coefficient", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DRAIN_COEFF" }, { "name": "DOWNSTREAM_ID", "type": "esriFieldTypeString", "alias": "Downstream Asset ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DOWNSTREAM_ID" }, { "name": "UPSTREAM_ID", "type": "esriFieldTypeString", "alias": "Upstream Asset ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UPSTREAM_ID" }, { "name": "ROUGH_SCALE", "type": "esriFieldTypeDouble", "alias": "Manning's Roughness Scale", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROUGH_SCALE" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NOTES" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDITOR" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITDATE" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.LEN" }, { "name": "WIDTH_MM", "type": "esriFieldTypeDouble", "alias": "WIDTH_MM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WIDTH_MM" }, { "name": "HEIGHT_MM", "type": "esriFieldTypeDouble", "alias": "HEIGHT_MM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HEIGHT_MM" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "GDB_195794_ASSET", "fields": "ASSETID_CW", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R454174_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_454174", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_454174", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A2669_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Storm Gravity Main", "description": "", "prototype": { "attributes": { "WIDTH_MM": null, "NOTES": null, "HEIGHT_MM": null, "FACILITYID": null, "ASSETID_CW": null, "BARCODE": null, "MPLAN": null, "LOCATION_NAME": null, "LOCATION": null, "AGE": null, "INSTALL_DATE": null, "LENGTH_M": null, "DIAMETER_MM": null, "MATERIAL": null, "FUNCTION": null, "DOWNSTREAM_INV": null, "UPSTREAM_INV": null, "GR_PERCENT": null, "SECTIONAL_SHAPE": "Circular", "OWNERSHIP": "Assumed", "STATUS": null, "INFRASTRUCTURE_AREA": null, "COND_ASSESS_DATE": null, "PHYSICAL_COND": null, "DEMAND_COND": null, "FUNCTIONAL_COND": null, "REPLACEMENT_COST": null, "WARRANTY_DATE": null, "DRAIN_AREA": null, "DRAIN_COEFF": null, "DOWNSTREAM_ID": null, "UPSTREAM_ID": null, "ROUGH_SCALE": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "Manhole Inspections Latest", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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": true, "supportsQuantizationEditMode": true, "supportsCalculate": false, "supportsASyncCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -8801406.730323598, "ymin": 5437351.773248895, "xmax": -8791818.1705527, "ymax": 5450240.330690377, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120899.99999281, "falseY": -9998099.99996649, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var yr = $feature.INSPECTION_DATE;\nvar yrx = '';\nIF(YEAR(yr)==YEAR(NOW())) yrx='This Year'\nELSE yrx='Previous Year'\nreturn yrx", "valueExpressionTitle": "Custom", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 } }, "defaultLabel": "Previous Year", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 169, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 } }, "value": "This Year", "label": "This Year" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 222, 210, 255 ], "toColor": [ 252, 222, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 184, 255 ], "toColor": [ 182, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 190, 252, 255 ], "toColor": [ 184, 190, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 241, 252, 255 ], "toColor": [ 184, 241, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 229, 255 ], "toColor": [ 252, 182, 229, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 252, 224, 255 ], "toColor": [ 204, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 220, 252, 255 ], "toColor": [ 215, 220, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 180, 255 ], "toColor": [ 252, 179, 180, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 217, 179, 252, 255 ], "toColor": [ 217, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 248, 212, 255 ], "toColor": [ 252, 248, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 238, 255 ], "toColor": [ 252, 210, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 222, 252, 179, 255 ], "toColor": [ 222, 252, 179, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "", "globalIdField": "", "displayField": "ASSETID_CW", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "INSPECTION_YEAR", "type": "esriFieldTypeDouble", "alias": "INSPECTION_YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSPECTION_YEAR" }, { "name": "INSPECTION_MONTH", "type": "esriFieldTypeDouble", "alias": "INSPECTION_MONTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSPECTION_MONTH" }, { "name": "INSPECTION_YEAR_MONTH", "type": "esriFieldTypeString", "alias": "INSPECTION_YEAR_MONTH", "domain": null, "editable": true, "nullable": true, "length": 49, "defaultValue": null, "modelName": "INSPECTION_YEAR_MONTH" }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STMHRATINGSINDEX" }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMMHRATINGSINDEX" }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLMHRATINGSINDEX" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Manhole Inspections Latest", "description": "", "prototype": { "attributes": { "OMMHRATINGSINDEX": null, "OVERALLMHRATINGSINDEX": null, "ASSETID_CW": null, "INSPECTION_DATE": null, "INSPECTION_YEAR": null, "INSPECTION_MONTH": null, "INSPECTION_YEAR_MONTH": null, "STMHRATINGSINDEX": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "Catchbasin Inspections Latest", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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": true, "supportsQuantizationEditMode": true, "supportsCalculate": false, "supportsASyncCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -8801911.382962355, "ymin": 5437260.116667068, "xmax": -8791800.92971877, "ymax": 5450198.998245325, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120899.99999281, "falseY": -9998099.99996649, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var yr = $feature.INSPECTION_DATE;\nvar yrx = '';\nIF(YEAR(yr)==YEAR(NOW())) yrx='This Year'\nELSE yrx='Previous Year'\nreturn yrx", "valueExpressionTitle": "Custom", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 } }, "defaultLabel": "Previous Year", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 169, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 } }, "value": "This Year", "label": "This Year" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 222, 210, 255 ], "toColor": [ 252, 222, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 184, 255 ], "toColor": [ 182, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 190, 252, 255 ], "toColor": [ 184, 190, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 241, 252, 255 ], "toColor": [ 184, 241, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 229, 255 ], "toColor": [ 252, 182, 229, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 252, 224, 255 ], "toColor": [ 204, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 220, 252, 255 ], "toColor": [ 215, 220, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 180, 255 ], "toColor": [ 252, 179, 180, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 217, 179, 252, 255 ], "toColor": [ 217, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 248, 212, 255 ], "toColor": [ 252, 248, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 238, 255 ], "toColor": [ 252, 210, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 222, 252, 179, 255 ], "toColor": [ 222, 252, 179, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "", "globalIdField": "", "displayField": "ASSETID_CW", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "INSPECTION_YEAR", "type": "esriFieldTypeDouble", "alias": "INSPECTION_YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSPECTION_YEAR" }, { "name": "INSPECTION_MONTH", "type": "esriFieldTypeDouble", "alias": "INSPECTION_MONTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSPECTION_MONTH" }, { "name": "INSPECTION_YEAR_MONTH", "type": "esriFieldTypeString", "alias": "INSPECTION_YEAR_MONTH", "domain": null, "editable": true, "nullable": true, "length": 49, "defaultValue": null, "modelName": "INSPECTION_YEAR_MONTH" }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STMHRATINGSINDEX" }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMMHRATINGSINDEX" }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLMHRATINGSINDEX" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Catchbasin Inspections Latest", "description": "", "prototype": { "attributes": { "OMMHRATINGSINDEX": null, "OVERALLMHRATINGSINDEX": null, "ASSETID_CW": null, "INSPECTION_DATE": null, "INSPECTION_YEAR": null, "INSPECTION_MONTH": null, "INSPECTION_YEAR_MONTH": null, "STMHRATINGSINDEX": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "Gravity Main Inspections Latest", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -8801504.068994382, "ymin": 5437002.6254292065, "xmax": -8791908.570229433, "ymax": 5446884.06955893, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0, "zTolerance": 0, "mTolerance": 0, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var yr = $feature.INSPECTION_DATE;\nvar yrx = '';\nIF(YEAR(yr)==YEAR(NOW())) yrx='This Year'\nELSE yrx='Previous Year'\nreturn yrx", "valueExpressionTitle": "Custom", "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 156, 156, 156, 255 ], "width": 6 }, "defaultLabel": "Previous Year", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 169, 255 ], "width": 7 }, "value": "This Year", "label": "This Year" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 222, 210, 255 ], "toColor": [ 252, 222, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 184, 255 ], "toColor": [ 182, 252, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 190, 252, 255 ], "toColor": [ 184, 190, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 241, 252, 255 ], "toColor": [ 184, 241, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 229, 255 ], "toColor": [ 252, 182, 229, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 204, 252, 224, 255 ], "toColor": [ 204, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 220, 252, 255 ], "toColor": [ 215, 220, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 180, 255 ], "toColor": [ 252, 179, 180, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 217, 179, 252, 255 ], "toColor": [ 217, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 248, 212, 255 ], "toColor": [ 252, 248, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 238, 255 ], "toColor": [ 252, 210, 238, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 222, 252, 179, 255 ], "toColor": [ 222, 252, 179, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ASSETID_CW", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "INSPECTION_YEAR", "type": "esriFieldTypeDouble", "alias": "INSPECTION_YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSPECTION_YEAR" }, { "name": "INSPECTION_MONTH", "type": "esriFieldTypeDouble", "alias": "INSPECTION_MONTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSPECTION_MONTH" }, { "name": "INSPECTION_YEAR_MONTH", "type": "esriFieldTypeString", "alias": "INSPECTION_YEAR_MONTH", "domain": null, "editable": true, "nullable": true, "length": 49, "defaultValue": null, "modelName": "INSPECTION_YEAR_MONTH" }, { "name": "STPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STPIPERATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STPIPERATINGSINDEX" }, { "name": "OMPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMPIPERATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMPIPERATINGSINDEX" }, { "name": "OVERALLPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLPIPERATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLPIPERATINGSINDEX" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.LEN" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Gravity Main Inspections Latest", "description": "", "prototype": { "attributes": { "OVERALLPIPERATINGSINDEX": null, "OMPIPERATINGSINDEX": null, "ASSETID_CW": null, "INSPECTION_DATE": null, "INSPECTION_YEAR": null, "INSPECTION_MONTH": null, "INSPECTION_YEAR_MONTH": null, "STPIPERATINGSINDEX": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "Headwall", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATEDATE", "creatorField": "CREATEDBY", "editDateField": "EDITDATE", "editorField": "EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1710254585000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -8802853.092032185, "ymin": 5436998.757613873, "xmax": -8791926.85702825, "ymax": 5452807.261125368, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 2.56000000238419E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120899.99999281, "falseY": -9998099.99996649, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 230, 152, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "INF_REV_AREA", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "INF_REV_AREA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INF_REV_AREA" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LEGACYID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "ASSET_ID_NUM", "type": "esriFieldTypeString", "alias": "ASSET_ID_NUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ASSET_ID_NUM" }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "STRUCT_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRUCT_TYPE" }, { "name": "STD_DWG", "type": "esriFieldTypeString", "alias": "STD_DWG", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STD_DWG" }, { "name": "INV_1", "type": "esriFieldTypeString", "alias": "INV_1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INV_1" }, { "name": "INV_2", "type": "esriFieldTypeString", "alias": "INV_2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INV_2" }, { "name": "INV_OTHER", "type": "esriFieldTypeString", "alias": "INV_OTHER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INV_OTHER" }, { "name": "SPILLWAY_TYPE", "type": "esriFieldTypeString", "alias": "SPILLWAY_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SPILLWAY_TYPE" }, { "name": "FENCE_TYPE", "type": "esriFieldTypeString", "alias": "FENCE_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FENCE_TYPE" }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MAINT_DATE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "REPAIR_DATE", "type": "esriFieldTypeDate", "alias": "REPAIR_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPAIR_DATE" }, { "name": "WORK_PERF", "type": "esriFieldTypeString", "alias": "WORK_PERF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WORK_PERF" }, { "name": "C_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "C_ASSESS_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "C_ASSESS_DATE" }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AGE" }, { "name": "REM_LIFE", "type": "esriFieldTypeString", "alias": "REM_LIFE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "REM_LIFE" }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BARCODE" }, { "name": "ASSUMED", "type": "esriFieldTypeString", "alias": "ASSUMED", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "Not Assumed", "modelName": "ASSUMED" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDITOR" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITDATE" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.AREA" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.LEN" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "LATITUDE_", "type": "esriFieldTypeDouble", "alias": "Latitude_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LATITUDE_" }, { "name": "LONGITUDE_", "type": "esriFieldTypeDouble", "alias": "Longitude_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONGITUDE_" }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location ID #", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATIONID" }, { "name": "INFRASTRUCTURE_AREA_", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INFRASTRUCTURE_AREA_" }, { "name": "LOCATION_DESCRIPTION_", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION_" }, { "name": "MUNICIPAL_ADDRESS", "type": "esriFieldTypeString", "alias": "Municipal Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MUNICIPAL_ADDRESS" }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LEGAL_DESCRIPTION" }, { "name": "L1_ASSETCLASS", "type": "esriFieldTypeString", "alias": "Level 1: Asset Class", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L1_ASSETCLASS" }, { "name": "L2_ASSETCATEGORY", "type": "esriFieldTypeString", "alias": "Level 2: Asset Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L2_ASSETCATEGORY" }, { "name": "L3_ASSETTYPE", "type": "esriFieldTypeString", "alias": "Level 3: Asset Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L3_ASSETTYPE" }, { "name": "L4_SPECIFICGROUPEDASSETS", "type": "esriFieldTypeString", "alias": "Level 4: Specific Grouped Assets", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L4_SPECIFICGROUPEDASSETS" }, { "name": "TCACATEGORY", "type": "esriFieldTypeString", "alias": "TCA Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TCACATEGORY" }, { "name": "AGE_", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AGE_" }, { "name": "YEARINSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEARINSTALLED" }, { "name": "ASSUMED_", "type": "esriFieldTypeString", "alias": "Assumed_", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSUMED_" }, { "name": "COMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Commissioned Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMMISSIONEDDATE" }, { "name": "DECOMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DECOMMISSIONEDDATE" }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTINSPECTIONDATE" }, { "name": "YEARRENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Year Renewed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEARRENEWED" }, { "name": "LASTRENEWALACTIVITY", "type": "esriFieldTypeString", "alias": "Last Renewal Activity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LASTRENEWALACTIVITY" }, { "name": "REPLACEMENTUNITCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTUNITCOST" }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTCOST" }, { "name": "PHYSICALCONDITION", "type": "esriFieldTypeString", "alias": "Physical Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PHYSICALCONDITION" }, { "name": "FUNCTIONALCONDITION", "type": "esriFieldTypeString", "alias": "Functional Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTIONALCONDITION" }, { "name": "DEMANDCONDITION", "type": "esriFieldTypeString", "alias": "Demand Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEMANDCONDITION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "HEADWALL_TYPE", "type": "esriFieldTypeString", "alias": "Headwall Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HEADWALL_TYPE" }, { "name": "HEADWALL_STYLE", "type": "esriFieldTypeString", "alias": "Headwall Style", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HEADWALL_STYLE" }, { "name": "HEADWALL_MATERIAL", "type": "esriFieldTypeString", "alias": "Headwall Material", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HEADWALL_MATERIAL" }, { "name": "TOP_WALL_GUARDING", "type": "esriFieldTypeString", "alias": "Top of Wall Guarding", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TOP_WALL_GUARDING" }, { "name": "HEADWALL_STANDARD_NUMBER", "type": "esriFieldTypeString", "alias": "Headwall Standard Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HEADWALL_STANDARD_NUMBER" }, { "name": "OUTFALL_GRATES", "type": "esriFieldTypeString", "alias": "Outfall Grates", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OUTFALL_GRATES" }, { "name": "GRATE_ORIENTATION", "type": "esriFieldTypeString", "alias": "Grate Orientation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GRATE_ORIENTATION" }, { "name": "GRATE_FASTENING", "type": "esriFieldTypeString", "alias": "Grate Fastening", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GRATE_FASTENING" }, { "name": "GRATE_STANDARD_NUMBER", "type": "esriFieldTypeString", "alias": "Grate Standard Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GRATE_STANDARD_NUMBER" }, { "name": "SPILLWAY_TREATMENT", "type": "esriFieldTypeString", "alias": "Spillway Treatment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SPILLWAY_TREATMENT" }, { "name": "SPILLWAY_OUTLET", "type": "esriFieldTypeString", "alias": "Spillway Outlet", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SPILLWAY_OUTLET" }, { "name": "NUM_OUTLET_PIPES", "type": "esriFieldTypeSmallInteger", "alias": "Number of Outlet Pipes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUM_OUTLET_PIPES" }, { "name": "PIPE_1_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Pipe 1 Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PIPE_1_DIAMETER" }, { "name": "PIPE_1_INVERT", "type": "esriFieldTypeString", "alias": "Pipe 1 Invert", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPE_1_INVERT" }, { "name": "WATER_SOURCE_1", "type": "esriFieldTypeString", "alias": "Water Source 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WATER_SOURCE_1" }, { "name": "WATER_SOURCE_1_QUALITY", "type": "esriFieldTypeString", "alias": "Water Source 1 Quality", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WATER_SOURCE_1_QUALITY" }, { "name": "PIPE_2_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Pipe 1 Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PIPE_2_DIAMETER" }, { "name": "PIPE_2_INVERT", "type": "esriFieldTypeString", "alias": "Pipe 1 Invert", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPE_2_INVERT" }, { "name": "WATER_SOURCE_2", "type": "esriFieldTypeString", "alias": "Water Source 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WATER_SOURCE_2" }, { "name": "WATER_SOURCE_2_QUALITY", "type": "esriFieldTypeString", "alias": "Water Source 1 Quality", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WATER_SOURCE_2_QUALITY" }, { "name": "CONDITION_RATING", "type": "esriFieldTypeString", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONDITION_RATING" }, { "name": "CONDITION_ASSESSOR", "type": "esriFieldTypeString", "alias": "Condition Assessor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONDITION_ASSESSOR" }, { "name": "CONDITION_ASSESSMENT_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assessment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CONDITION_ASSESSMENT_DATE" }, { "name": "LIFECYCLE_ACTIVITY2_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY2_FREQ" }, { "name": "LIFECYCLE_ACTIVITY3", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY3" }, { "name": "LIFECYCLE_ACTIVITY3_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY3_FREQ" }, { "name": "LIFECYCLE_ACTIVITY4", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 4", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY4" }, { "name": "LIFECYCLE_ACTIVITY4_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY4_FREQ" }, { "name": "LIFECYCLE_ACTIVITY1_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY1_UNITCOST" }, { "name": "LIFECYCLE_ACTIVITY2_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY2_UNITCOST" }, { "name": "LIFECYCLE_ACTIVITY3_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY3_UNITCOST" }, { "name": "LIFECYCLE_ACTIVITY4_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY4_UNITCOST" }, { "name": "LIFECYCLE_ACTIVITY_COST_10YR", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost to 2031", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY_COST_10YR" }, { "name": "LIFECYCLE_ACTIVITY_COST_50YR", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost to 2071", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY_COST_50YR" }, { "name": "LIFECYCLE_ACTIVITY1", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY1" }, { "name": "LIFECYCLE_ACTIVITY1_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY1_FREQ" }, { "name": "LIFECYCLE_ACTIVITY2", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY2" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R453772_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_453772", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_453772", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A2356_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Headwall", "description": "", "prototype": { "attributes": { "LIFECYCLE_ACTIVITY2": null, "INF_REV_AREA": null, "WARRANTYDATE": null, "INSTALLDATE": null, "LOCATION": null, "LEGACYID": null, "FACILITYID": null, "ASSET_ID_NUM": null, "STRUCT_TYPE": null, "STD_DWG": null, "INV_1": null, "INV_2": null, "INV_OTHER": null, "SPILLWAY_TYPE": null, "FENCE_TYPE": null, "MAINT_DATE": null, "INSP_DATE": null, "REPAIR_DATE": null, "WORK_PERF": null, "C_ASSESS_DATE": null, "AGE": null, "REM_LIFE": null, "BARCODE": null, "ASSUMED": "Not Assumed", "LIFECYCLE_ACTIVITY_COST_50YR": null, "LIFECYCLE_ACTIVITY_COST_10YR": null, "LIFECYCLE_ACTIVITY4_UNITCOST": null, "LIFECYCLE_ACTIVITY3_UNITCOST": null, "LIFECYCLE_ACTIVITY1_FREQ": null, "LIFECYCLE_ACTIVITY1": null, "LIFECYCLE_ACTIVITY2_UNITCOST": null, "LATITUDE_": null, "LONGITUDE_": null, "LOCATIONID": null, "INFRASTRUCTURE_AREA_": null, "LOCATION_DESCRIPTION_": null, "MUNICIPAL_ADDRESS": null, "LEGAL_DESCRIPTION": null, "L1_ASSETCLASS": null, "L2_ASSETCATEGORY": null, "L3_ASSETTYPE": null, "L4_SPECIFICGROUPEDASSETS": null, "TCACATEGORY": null, "AGE_": null, "YEARINSTALLED": null, "ASSUMED_": null, "COMMISSIONEDDATE": null, "DECOMMISSIONEDDATE": null, "LASTINSPECTIONDATE": null, "YEARRENEWED": null, "LASTRENEWALACTIVITY": null, "REPLACEMENTUNITCOST": null, "REPLACEMENTCOST": null, "PHYSICALCONDITION": null, "FUNCTIONALCONDITION": null, "DEMANDCONDITION": null, "STATUS": null, "HEADWALL_TYPE": null, "HEADWALL_STYLE": null, "HEADWALL_MATERIAL": null, "TOP_WALL_GUARDING": null, "HEADWALL_STANDARD_NUMBER": null, "OUTFALL_GRATES": null, "GRATE_ORIENTATION": null, "GRATE_FASTENING": null, "GRATE_STANDARD_NUMBER": null, "SPILLWAY_TREATMENT": null, "SPILLWAY_OUTLET": null, "NUM_OUTLET_PIPES": null, "PIPE_1_DIAMETER": null, "PIPE_1_INVERT": null, "WATER_SOURCE_1": null, "WATER_SOURCE_1_QUALITY": null, "PIPE_2_DIAMETER": null, "PIPE_2_INVERT": null, "WATER_SOURCE_2": null, "WATER_SOURCE_2_QUALITY": null, "CONDITION_RATING": null, "CONDITION_ASSESSOR": null, "CONDITION_ASSESSMENT_DATE": null, "LIFECYCLE_ACTIVITY2_FREQ": null, "LIFECYCLE_ACTIVITY3": null, "LIFECYCLE_ACTIVITY3_FREQ": null, "LIFECYCLE_ACTIVITY4": null, "LIFECYCLE_ACTIVITY4_FREQ": null, "LIFECYCLE_ACTIVITY1_UNITCOST": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 8, "name": "Storm Ponds", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATED_DATE", "creatorField": "CREATEDBY", "editDateField": "EDITDATE", "editorField": "EDITOR" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1708712794000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": -8802534.687825015, "ymin": 5437623.2841469105, "xmax": -8791913.219298799, "ymax": 5451970.804609729, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 190, 232, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "POND_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ID" }, { "name": "AJAX_POND", "type": "esriFieldTypeString", "alias": "AJAX_POND", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AJAX_POND" }, { "name": "POND_NUM", "type": "esriFieldTypeString", "alias": "POND_NUM", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "POND_NUM" }, { "name": "POND_NAME", "type": "esriFieldTypeString", "alias": "POND_NAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "POND_NAME" }, { "name": "DRAW_APPRO", "type": "esriFieldTypeString", "alias": "DRAW_APPRO", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "DRAW_APPRO" }, { "name": "ASSU_BYLAW", "type": "esriFieldTypeString", "alias": "ASSU_BYLAW", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ASSU_BYLAW" }, { "name": "ASSU_DATE", "type": "esriFieldTypeDate", "alias": "ASSU_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ASSU_DATE" }, { "name": "CAP_YEAR", "type": "esriFieldTypeString", "alias": "CAP_YEAR", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "CAP_YEAR" }, { "name": "LAND_USE", "type": "esriFieldTypeString", "alias": "LAND_USE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "LAND_USE" }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "OWNERSHIP", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OWNERSHIP" }, { "name": "ISSUES", "type": "esriFieldTypeString", "alias": "ISSUES", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ISSUES" }, { "name": "PRV_TWN", "type": "esriFieldTypeString", "alias": "PRV_TWN", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PRV_TWN" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "INF_REV_AREA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INF_REV_AREA" }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTYDATE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LEGACYID" }, { "name": "ASSET_ID_NUM", "type": "esriFieldTypeString", "alias": "ASSET_ID_NUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ASSET_ID_NUM" }, { "name": "POND_TYPE", "type": "esriFieldTypeString", "alias": "POND_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "POND_TYPE" }, { "name": "TRCAPOND_NUM", "type": "esriFieldTypeString", "alias": "TRCAPOND_NUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TRCAPOND_NUM" }, { "name": "MOE_COA", "type": "esriFieldTypeString", "alias": "MOE_COA", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MOE_COA" }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MAINT_DATE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "REPAIR_DATE", "type": "esriFieldTypeDate", "alias": "REPAIR_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPAIR_DATE" }, { "name": "WORK_PERF", "type": "esriFieldTypeString", "alias": "WORK_PERF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WORK_PERF" }, { "name": "REHAB_DATE", "type": "esriFieldTypeDate", "alias": "REHAB_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REHAB_DATE" }, { "name": "C_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "C_ASSESS_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "C_ASSESS_DATE" }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AGE" }, { "name": "REM_LIFE", "type": "esriFieldTypeString", "alias": "REM_LIFE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "REM_LIFE" }, { "name": "REP_VALUE", "type": "esriFieldTypeString", "alias": "REP_VALUE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "REP_VALUE" }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BARCODE" }, { "name": "ASSUMED", "type": "esriFieldTypeString", "alias": "ASSUMED", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": "Not Assumed", "modelName": "ASSUMED" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDITOR" }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITDATE" }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETID_CW" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.AREA" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.LEN" }, { "name": "LATITUDE_", "type": "esriFieldTypeDouble", "alias": "Latitude_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LATITUDE_" }, { "name": "LONGITUDE_", "type": "esriFieldTypeDouble", "alias": "Longitude_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONGITUDE_" }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location ID #", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATIONID" }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INFRASTRUCTURE_AREA" }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION" }, { "name": "MUNICIPAL_ADDRESS", "type": "esriFieldTypeString", "alias": "Municipal Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MUNICIPAL_ADDRESS" }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LEGAL_DESCRIPTION" }, { "name": "L1_ASSETCLASS", "type": "esriFieldTypeString", "alias": "Level 1: Asset Class", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L1_ASSETCLASS" }, { "name": "L2_ASSETCATEGORY", "type": "esriFieldTypeString", "alias": "Level 2: Asset Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L2_ASSETCATEGORY" }, { "name": "L3_ASSETTYPE", "type": "esriFieldTypeString", "alias": "Level 3: Asset Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L3_ASSETTYPE" }, { "name": "L4_SPECIFICGROUPEDASSETS", "type": "esriFieldTypeString", "alias": "Level 4: Specific Grouped Assets", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "L4_SPECIFICGROUPEDASSETS" }, { "name": "TCACATEGORY", "type": "esriFieldTypeString", "alias": "TCA Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TCACATEGORY" }, { "name": "AGE_", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AGE_" }, { "name": "YEARINSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEARINSTALLED" }, { "name": "ASSUMED_", "type": "esriFieldTypeString", "alias": "Assumed_", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSUMED_" }, { "name": "COMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Commissioned Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMMISSIONEDDATE" }, { "name": "DECOMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DECOMMISSIONEDDATE" }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTINSPECTIONDATE" }, { "name": "YEARRENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Year Renewed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEARRENEWED" }, { "name": "LASTRENEWALACTIVITY", "type": "esriFieldTypeString", "alias": "Last Renewal Activity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LASTRENEWALACTIVITY" }, { "name": "REPLACEMENTUNITCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTUNITCOST" }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REPLACEMENTCOST" }, { "name": "PHYSICALCONDITION", "type": "esriFieldTypeString", "alias": "Physical Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PHYSICALCONDITION" }, { "name": "FUNCTIONALCONDITION", "type": "esriFieldTypeString", "alias": "Functional Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTIONALCONDITION" }, { "name": "DEMANDCONDITION", "type": "esriFieldTypeString", "alias": "Demand Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEMANDCONDITION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "FUNCTION", "type": "esriFieldTypeString", "alias": "Function", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNCTION" }, { "name": "PERMANENT_POOL_VOLUME", "type": "esriFieldTypeString", "alias": "Permanent Pool Volume", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERMANENT_POOL_VOLUME" }, { "name": "FLUCTUATING_STORAGE_VOLUME", "type": "esriFieldTypeString", "alias": "Flunctuating Storage Volume", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FLUCTUATING_STORAGE_VOLUME" }, { "name": "MAX_STORAGE_VOLUME", "type": "esriFieldTypeDouble", "alias": "Max Storage Volume", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_STORAGE_VOLUME" }, { "name": "OVERFLOW_WEIR_ELEVATION1", "type": "esriFieldTypeDouble", "alias": "Overflow Weir Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERFLOW_WEIR_ELEVATION1" }, { "name": "NUMBER_OF_INLETS1", "type": "esriFieldTypeSmallInteger", "alias": "Number of Inlets", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMBER_OF_INLETS1" }, { "name": "OUTFALL_TYPE1", "type": "esriFieldTypeString", "alias": "Outfall Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OUTFALL_TYPE1" }, { "name": "CREEK_NAME1", "type": "esriFieldTypeString", "alias": "Creek Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREEK_NAME1" }, { "name": "HEADWALL_ASSET_ID1", "type": "esriFieldTypeString", "alias": "Headwall Asset ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "HEADWALL_ASSET_ID1" }, { "name": "LIFECYCLE_ACTIVITY11", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY11" }, { "name": "LIFECYCLE_ACTIVITY1_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY1_FREQ1" }, { "name": "LIFECYCLE_ACTIVITY21", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY21" }, { "name": "LIFECYCLE_ACTIVITY2_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY2_FREQ1" }, { "name": "LIFECYCLE_ACTIVITY31", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY31" }, { "name": "LIFECYCLE_ACTIVITY3_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY3_FREQ1" }, { "name": "LIFECYCLE_ACTIVITY41", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 4", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY41" }, { "name": "LIFECYCLE_ACTIVITY4_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Frequency", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY4_FREQ1" }, { "name": "LIFECYCLE_ACTIVITY1_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY1_UNITCOST1" }, { "name": "LIFECYCLE_ACTIVITY2_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY2_UNITCOST1" }, { "name": "LIFECYCLE_ACTIVITY3_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY3_UNITCOST1" }, { "name": "LIFECYCLE_ACTIVITY4_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY4_UNITCOST1" }, { "name": "LIFECYCLE_ACTIVITY_COST_10YR1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost 10 Years", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY_COST_10YR1" }, { "name": "LIFECYCLE_ACTIVITY_COST_50YR1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost 50 Years", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFECYCLE_ACTIVITY_COST_50YR1" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R753_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_753", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_753", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A662_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Storm Water Management Ponds", "description": "", "prototype": { "attributes": { "LIFECYCLE_ACTIVITY_COST_50YR1": null, "ID": null, "AJAX_POND": null, "POND_NUM": null, "POND_NAME": null, "DRAW_APPRO": null, "ASSU_BYLAW": null, "ASSU_DATE": null, "CAP_YEAR": null, "LAND_USE": null, "OWNERSHIP": null, "ISSUES": null, "PRV_TWN": null, "NOTES": null, "FACILITYID": null, "INF_REV_AREA": null, "WARRANTYDATE": null, "INSTALLDATE": null, "LOCATION": null, "LEGACYID": null, "ASSET_ID_NUM": null, "POND_TYPE": null, "TRCAPOND_NUM": null, "MOE_COA": null, "MAINT_DATE": null, "INSP_DATE": null, "REPAIR_DATE": null, "WORK_PERF": null, "REHAB_DATE": null, "C_ASSESS_DATE": null, "AGE": null, "REM_LIFE": null, "REP_VALUE": null, "BARCODE": null, "ASSUMED": "Not Assumed", "LIFECYCLE_ACTIVITY3_UNITCOST1": null, "LIFECYCLE_ACTIVITY2_UNITCOST1": null, "LIFECYCLE_ACTIVITY1_UNITCOST1": null, "LIFECYCLE_ACTIVITY4_FREQ1": null, "LIFECYCLE_ACTIVITY41": null, "LIFECYCLE_ACTIVITY_COST_10YR1": null, "LIFECYCLE_ACTIVITY4_UNITCOST1": null, "LATITUDE_": null, "LONGITUDE_": null, "LOCATIONID": null, "INFRASTRUCTURE_AREA": null, "LOCATION_DESCRIPTION": null, "MUNICIPAL_ADDRESS": null, "LEGAL_DESCRIPTION": null, "L1_ASSETCLASS": null, "L2_ASSETCATEGORY": null, "L3_ASSETTYPE": null, "L4_SPECIFICGROUPEDASSETS": null, "TCACATEGORY": null, "AGE_": null, "YEARINSTALLED": null, "ASSUMED_": null, "COMMISSIONEDDATE": null, "DECOMMISSIONEDDATE": null, "LASTINSPECTIONDATE": null, "YEARRENEWED": null, "LASTRENEWALACTIVITY": null, "REPLACEMENTUNITCOST": null, "REPLACEMENTCOST": null, "PHYSICALCONDITION": null, "FUNCTIONALCONDITION": null, "DEMANDCONDITION": null, "STATUS": null, "FUNCTION": null, "PERMANENT_POOL_VOLUME": null, "FLUCTUATING_STORAGE_VOLUME": null, "MAX_STORAGE_VOLUME": null, "OVERFLOW_WEIR_ELEVATION1": null, "NUMBER_OF_INLETS1": null, "OUTFALL_TYPE1": null, "CREEK_NAME1": null, "HEADWALL_ASSET_ID1": null, "LIFECYCLE_ACTIVITY11": null, "LIFECYCLE_ACTIVITY1_FREQ1": null, "LIFECYCLE_ACTIVITY21": null, "LIFECYCLE_ACTIVITY2_FREQ1": null, "LIFECYCLE_ACTIVITY31": null, "LIFECYCLE_ACTIVITY3_FREQ1": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "Storm_Gravity_Main_Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATED_DATE", "creatorField": "CREATED_USER", "editDateField": "LAST_EDITED_DATE", "editorField": "LAST_EDITED_USER" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "Conditions", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "INSPECTIONID", "composite": false, "catalogID": "{98B91C9D-9844-4439-A084-2E2EA480172A}" }, { "id": 2, "name": "Gravity Main", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PIPE_SEGMENT_REFERENCE", "composite": false, "catalogID": "{55565EE7-7A41-48D0-9FBA-9F9D99669D54}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "PIPE_SEGMENT_REFERENCE", "type": "esriFieldTypeString", "alias": "Pipe_Segment_Reference", "domain": null, "editable": true, "nullable": false, "length": 255, "defaultValue": null, "modelName": "PIPE_SEGMENT_REFERENCE" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "domain": { "type": "codedValue", "name": "swWeather", "description": "", "codedValues": [ { "name": "Dry - No Precipitation During Survey", "code": "1" }, { "name": "Heavy Rain", "code": "2" }, { "name": "Light Rain", "code": "3" }, { "name": "Snow", "code": "4" }, { "name": "Dry Weather/Wet Ground", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "WEATHER" }, { "name": "PRECLEANING", "type": "esriFieldTypeString", "alias": "PreCleaning", "domain": { "type": "codedValue", "name": "swPreCleaning", "description": "", "codedValues": [ { "name": "Heavy Cleaning", "code": "H" }, { "name": "Light Cleaning", "code": "L" }, { "name": "No Pre-Cleaning", "code": "N" }, { "name": "Not Known", "code": "X" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PRECLEANING" }, { "name": "FLOW_CONTROL", "type": "esriFieldTypeString", "alias": "Flow_Control", "domain": { "type": "codedValue", "name": "swFlowControl", "description": "", "codedValues": [ { "name": "Bypassed", "code": "B" }, { "name": "De-watered Using Jetter", "code": "D" }, { "name": "Lift Station", "code": "L" }, { "name": "Not Controlled", "code": "N" }, { "name": "Plugged", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "FLOW_CONTROL" }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "domain": { "type": "codedValue", "name": "swPurpose", "description": "", "codedValues": [ { "name": "Maintenance Related", "code": "A" }, { "name": "Infiltration/Inflow Investigation", "code": "B" }, { "name": "Post Rehabilitation Survey", "code": "C" }, { "name": "Pre-Rehabilitation Survey", "code": "D" }, { "name": "Pre-Acceptance New Sewers", "code": "E" }, { "name": "Routine Assessment", "code": "F" }, { "name": "Capital Improvement Program Assessment", "code": "G" }, { "name": "Resurvey For Any Reason", "code": "H" }, { "name": "Sewer System Evaluation Survey (SSES)", "code": "I" }, { "name": "Pre-Existing Video", "code": "R" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PURPOSE" }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "Direction", "domain": { "type": "codedValue", "name": "swDirection_1", "description": "", "codedValues": [ { "name": "Upstream", "code": "U" }, { "name": "Downstream", "code": "D" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DIRECTION" }, { "name": "STGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE1" }, { "name": "STGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE2" }, { "name": "STGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE3" }, { "name": "STGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE4" }, { "name": "STGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE5" }, { "name": "OMGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE1" }, { "name": "OMGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE2" }, { "name": "OMGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE3" }, { "name": "OMGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE4" }, { "name": "OMGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE5" }, { "name": "STPIPERATING", "type": "esriFieldTypeSmallInteger", "alias": "STPipeRating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STPIPERATING" }, { "name": "OMPIPERATING", "type": "esriFieldTypeSmallInteger", "alias": "OMPipeRating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMPIPERATING" }, { "name": "OVERALLPIPERATING", "type": "esriFieldTypeSmallInteger", "alias": "OverallPipeRating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLPIPERATING" }, { "name": "STQUICKRATING", "type": "esriFieldTypeString", "alias": "STQuickRating", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "STQUICKRATING" }, { "name": "OMQUICKRATING", "type": "esriFieldTypeString", "alias": "OMQuickRating", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "OMQUICKRATING" }, { "name": "PACPQUICKRATING", "type": "esriFieldTypeString", "alias": "PACPQuickRating", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "PACPQUICKRATING" }, { "name": "STPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STPipeRatingsIndex", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STPIPERATINGSINDEX" }, { "name": "OMPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMPipeRatingsIndex", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMPIPERATINGSINDEX" }, { "name": "OVERALLPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OverallPipeRatingsIndex", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLPIPERATINGSINDEX" }, { "name": "LOFPACP", "type": "esriFieldTypeDouble", "alias": "LoFPACP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOFPACP" }, { "name": "MEDIA_LABEL", "type": "esriFieldTypeString", "alias": "Media_Label", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MEDIA_LABEL" }, { "name": "INSPECTION_STATUS", "type": "esriFieldTypeString", "alias": "Inspection Status", "domain": { "type": "codedValue", "name": "swInspectionStatus", "description": "", "codedValues": [ { "name": "Buried or Marked", "code": "BM" }, { "name": "Descent Inspection", "code": "DI" }, { "name": "No Access", "code": "NA" }, { "name": "Not Found", "code": "NF" }, { "name": "Traffic", "code": "NI" }, { "name": "Not Opened", "code": "NO" }, { "name": "Remote Inspection", "code": "RI" }, { "name": "Surcharged/Debris", "code": "SD" }, { "name": "Surface Inspection", "code": "SI" }, { "name": "Complete Inspection", "code": "CI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INSPECTION_STATUS" }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "INSPECTIONID" }, { "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": "GDB_196113_INSPE", "fields": "INSPECTIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_196113_PIPE_", "fields": "PIPE_SEGMENT_REFERENCE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R454176_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_454176", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_454176", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Storm_Gravity_Main_Inspections", "description": "", "prototype": { "attributes": { "INSPECTION_STATUS": null, "INSPECTIONID": " ", "MEDIA_LABEL": null, "PIPE_SEGMENT_REFERENCE": " ", "INSPECTION_DATE": null, "WEATHER": null, "PRECLEANING": null, "FLOW_CONTROL": null, "PURPOSE": null, "DIRECTION": null, "STGRADESCORE1": null, "STGRADESCORE2": null, "STGRADESCORE3": null, "STGRADESCORE4": null, "STGRADESCORE5": null, "OMGRADESCORE1": null, "OMGRADESCORE2": null, "OMGRADESCORE3": null, "OMGRADESCORE4": null, "OMGRADESCORE5": null, "STPIPERATING": null, "OMPIPERATING": null, "OVERALLPIPERATING": null, "STQUICKRATING": " ", "OMQUICKRATING": " ", "PACPQUICKRATING": " ", "STPIPERATINGSINDEX": null, "OMPIPERATINGSINDEX": null, "OVERALLPIPERATINGSINDEX": null, "LOFPACP": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 20000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "name": "Storm_Gravity_Main_Inspections_Conditions", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATED_DATE", "creatorField": "CREATED_USER", "editDateField": "LAST_EDITED_DATE", "editorField": "LAST_EDITED_USER" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "Inspection", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "INSPECTIONID", "composite": false, "catalogID": "{98B91C9D-9844-4439-A084-2E2EA480172A}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "DISTANCE", "type": "esriFieldTypeDouble", "alias": "Distance", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISTANCE" }, { "name": "COUNTER", "type": "esriFieldTypeSmallInteger", "alias": "Counter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COUNTER" }, { "name": "PACP_CODE", "type": "esriFieldTypeString", "alias": "PACP_Code", "domain": { "type": "codedValue", "name": "swPACPConditions", "description": "", "codedValues": [ { "name": "Access Point Catch Basin", "code": "ACB" }, { "name": "Access Point Cleanout House", "code": "ACOH" }, { "name": "Access Point Cleanout Mainline", "code": "ACOM" }, { "name": "Access Point Cleanout Propertyline", "code": "ACOP" }, { "name": "Access Point Discharge Point", "code": "ADP" }, { "name": "Access Point End of Pipe", "code": "AEP" }, { "name": "Access Point Junction Box", "code": "AJB" }, { "name": "Access Point Meter", "code": "AM" }, { "name": "Access Point Manhole", "code": "AMH" }, { "name": "Access Point Special Chamber", "code": "AOC" }, { "name": "Access Point Tee Connection", "code": "ATC" }, { "name": "Access Point Wastewater Access Device", "code": "AWA" }, { "name": "Access Point Wet Well", "code": "AWW" }, { "name": "Access Point Other", "code": "AZ" }, { "name": "Broken", "code": "B" }, { "name": "Broken Soil Visible", "code": "BSV" }, { "name": "Broken Void Visible", "code": "BVV" }, { "name": "Crack Circumferential", "code": "CC" }, { "name": "Crack Longitudinal Hinge, 2", "code": "CH2" }, { "name": "Crack Longitudinal Hinge, 3", "code": "CH3" }, { "name": "Crack Longitudinal Hinge, 4", "code": "CH4" }, { "name": "Crack Longitudinal", "code": "CL" }, { "name": "Crack Multiple", "code": "CM" }, { "name": "Crack Spiral", "code": "CS" }, { "name": "Deposits Attached Encrustation", "code": "DAE" }, { "name": "Deposits Attached Grease", "code": "DAGS" }, { "name": "Deposits Attached Ragging", "code": "DAR" }, { "name": "Deposits Attached Other", "code": "DAZ" }, { "name": "Displaced Brick", "code": "DB" }, { "name": "Deformed Flexible Bulging Inverse Curvature", "code": "DFBI" }, { "name": "Deformed Flexible Bulging Round", "code": "DFBR" }, { "name": "Deformed Flexible Creasing", "code": "DFC" }, { "name": "Deformed Flexible Elliptical", "code": "DFE" }, { "name": "Brickwork Dropped Invert", "code": "DI" }, { "name": "Deposits Ingress Fine", "code": "DNF" }, { "name": "Deposits Ingress Gravel", "code": "DNGV" }, { "name": "Deposits Ingress Other", "code": "DNZ" }, { "name": "Deformed Rigid", "code": "DR" }, { "name": "Deposits Settled Hard/Compacted", "code": "DSC" }, { "name": "Deposits Settled Fine", "code": "DSF" }, { "name": "Deposits Settled Gravel", "code": "DSGV" }, { "name": "Deposits Settled Other", "code": "DSZ" }, { "name": "Deformed Brick Bulging Inverse Curvature", "code": "DTBI" }, { "name": "Deformed Brick Bulging Round", "code": "DTBR" }, { "name": "Fracture Circumferential", "code": "FC" }, { "name": "Fracture Longitudinal Hinge, 2", "code": "FH2" }, { "name": "Fracture Longitudinal Hinge, 3", "code": "FH3" }, { "name": "Fracture Longitudinal Hinge, 4", "code": "FH4" }, { "name": "Fracture Longitudinal", "code": "FL" }, { "name": "Fracture Multiple", "code": "FM" }, { "name": "Fracture Spiral", "code": "FS" }, { "name": "Grout at a Location", "code": "GRT" }, { "name": "Grout Test Fail Joint", "code": "GTFJ" }, { "name": "Grout Test Fail Lateral", "code": "GTFL" }, { "name": "Grout Test Pass Joint", "code": "GTPJ" }, { "name": "Grout Test Pass Lateral", "code": "GTPL" }, { "name": "Grout Test Unable to Test Joint", "code": "GTUJ" }, { "name": "Grout Test Unable to Test Lateral", "code": "GTUL" }, { "name": "Hole", "code": "H" }, { "name": "Hole Soil Visible", "code": "HSV" }, { "name": "Hole Void Visible", "code": "HVV" }, { "name": "Infiltration Dripper", "code": "ID" }, { "name": "Infiltration Dripper Barrel", "code": "IDB" }, { "name": "Infiltration Dripper Connection", "code": "IDC" }, { "name": "Infiltration Dripper Joint", "code": "IDJ" }, { "name": "Infiltration Dripper Lateral", "code": "IDL" }, { "name": "Infiltration Gusher", "code": "IG" }, { "name": "Infiltration Gusher Barrel", "code": "IGB" }, { "name": "Infiltration Gusher Connection", "code": "IGC" }, { "name": "Infiltration Gusher Joint", "code": "IGJ" }, { "name": "Infiltration Gusher Lateral", "code": "IGL" }, { "name": "Infiltration Runner", "code": "IR" }, { "name": "Infiltration Runner Barrel", "code": "IRB" }, { "name": "Infiltration Runner Connection", "code": "IRC" }, { "name": "Infiltration Runner Joint", "code": "IRJ" }, { "name": "Infiltration Runner Lateral", "code": "IRL" }, { "name": "Infiltration Stain", "code": "IS" }, { "name": "Infiltration Stain Barrel", "code": "ISB" }, { "name": "Infiltration Stain Connection", "code": "ISC" }, { "name": "Intruding Sealing Material Grout", "code": "ISGT" }, { "name": "Infiltration Stain Joint", "code": "ISJ" }, { "name": "Infiltration Stain Lateral", "code": "ISL" }, { "name": "Intruding Sealing Material Sealing Ring", "code": "ISSR" }, { "name": "Intruding Sealing Material Sealing Ring Broken", "code": "ISSRB" }, { "name": "Intruding Sealing Material Sealing Ring Hanging", "code": "ISSRH" }, { "name": "Intruding Sealing Material Sealing Ring Loose/Poorly Fitting", "code": "ISSRL" }, { "name": "Intruding Sealing Material Other", "code": "ISZ" }, { "name": "Infiltration Weeper", "code": "IW" }, { "name": "Infiltration Weeper Barrel", "code": "IWB" }, { "name": "Infiltration Weeper Connection", "code": "IWC" }, { "name": "Infiltration Weeper Joint", "code": "IWJ" }, { "name": "Infiltration Weeper Lateral", "code": "IWL" }, { "name": "Joint Angular Large", "code": "JAL" }, { "name": "Joint Angular Medium", "code": "JAM" }, { "name": "Joint Angular Small", "code": "JAS" }, { "name": "Joint Offset Large", "code": "JOL" }, { "name": "Joint Offset Large Defective", "code": "JOLD" }, { "name": "Joint Offset Medium", "code": "JOM" }, { "name": "Joint Offset Medium Defective", "code": "JOMD" }, { "name": "Joint Offset Small", "code": "JOS" }, { "name": "Joint Offset Small Defective", "code": "JOSD" }, { "name": "Joint Separated Large", "code": "JSL" }, { "name": "Joint Separated Medium", "code": "JSM" }, { "name": "Joint Separated Small", "code": "JSS" }, { "name": "Line Down", "code": "LD" }, { "name": "Lining Feature Abandoned Connection", "code": "LFAC" }, { "name": "Lining Feature Annular Space", "code": "LFAS" }, { "name": "Lining Feature Blistered", "code": "LFB" }, { "name": "Lining Feature Service Cut Shifted", "code": "LFCS" }, { "name": "Lining Feature Detached", "code": "LFD" }, { "name": "Lining Feature Discoloration", "code": "LFDC" }, { "name": "Lining Feature Defective End", "code": "LFDE" }, { "name": "Lining Feature Delaminating", "code": "LFDL" }, { "name": "Lining Feature Overcut Service", "code": "LFOC" }, { "name": "Lining Feature Resin Slug", "code": "LFRS" }, { "name": "Lining Feature Undercut Service", "code": "LFUC" }, { "name": "Lining Feature Wrinkled", "code": "LFW" }, { "name": "Lining Feature Other", "code": "LFZ" }, { "name": "Line Left", "code": "LL" }, { "name": "Line Left Down", "code": "LLD" }, { "name": "Line Left Up", "code": "LLU" }, { "name": "Line Right", "code": "LR" }, { "name": "Line Right Down", "code": "LRD" }, { "name": "Line Right Up", "code": "LRU" }, { "name": "Line Up", "code": "LU" }, { "name": "Missing Brick", "code": "MB" }, { "name": "Miscellaneous Camera Underwater", "code": "MCU" }, { "name": "Miscellaneous General Observation", "code": "MGO" }, { "name": "Miscellaneous General Photo", "code": "MGP" }, { "name": "Miscellaneous Pipe Joint Length Change", "code": "MJL" }, { "name": "Miscellaneous Lining Change", "code": "MLC" }, { "name": "Miscellaneous Material Change", "code": "MMC" }, { "name": "Missing Mortar Large", "code": "MML" }, { "name": "Missing Mortar Medium", "code": "MMM" }, { "name": "Missing Mortar Small", "code": "MMS" }, { "name": "Miscellaneous Abandoned Survey", "code": "MSA" }, { "name": "Miscellaneous Shape/Size Change", "code": "MSC" }, { "name": "Miscellaneous Water Level", "code": "MWL" }, { "name": "Miscellaneous Water Level Sag", "code": "MWLS" }, { "name": "Miscellaneous Water Mark", "code": "MWM" }, { "name": "Miscellaneous Dye Test Not Visible", "code": "MYN" }, { "name": "Miscellaneous Dye Test Visible", "code": "MYV" }, { "name": "Obstruction Brick or Masonry", "code": "OBB" }, { "name": "Obstruction Thru Connection", "code": "OBC" }, { "name": "Obstruction Intruding Through Wall", "code": "OBI" }, { "name": "Obstruction Wedged In The Joint", "code": "OBJ" }, { "name": "Obstruction Pipe Material in Invert", "code": "OBM" }, { "name": "Obstruction Construction Debris", "code": "OBN" }, { "name": "Obstruction External Pipe or Cable", "code": "OBP" }, { "name": "Obstruction Rocks", "code": "OBR" }, { "name": "Obstruction Built Into Structure", "code": "OBS" }, { "name": "Obstruction Other", "code": "OBZ" }, { "name": "Roots Ball Barrel", "code": "RBB" }, { "name": "Roots Ball Connection", "code": "RBC" }, { "name": "Roots Ball Joint", "code": "RBJ" }, { "name": "Roots Ball Lateral", "code": "RBL" }, { "name": "Roots Fine Barrel", "code": "RFB" }, { "name": "Roots Fine Connection", "code": "RFC" }, { "name": "Roots Fine Joint", "code": "RFJ" }, { "name": "Roots Fine Lateral", "code": "RFL" }, { "name": "Roots Medium Barrel", "code": "RMB" }, { "name": "Roots Medium Connection", "code": "RMC" }, { "name": "Roots Medium Joint", "code": "RMJ" }, { "name": "Roots Medium Lateral", "code": "RML" }, { "name": "Point Repair Liner", "code": "RPL" }, { "name": "Point Repair Liner Defective", "code": "RPLD" }, { "name": "Point Repair Patch", "code": "RPP" }, { "name": "Point Repair Patch Patch Defective", "code": "RPPD" }, { "name": "Point Repair Replacement", "code": "RPR" }, { "name": "Point Repair Replacement Defective", "code": "RPRD" }, { "name": "Point Repair Other", "code": "RPZ" }, { "name": "Point Repair Other Defective", "code": "RPZD" }, { "name": "Roots Tap Barrel", "code": "RTB" }, { "name": "Roots Tap Connection", "code": "RTC" }, { "name": "Roots Tap Joint", "code": "RTJ" }, { "name": "Roots Tap Lateral", "code": "RTL" }, { "name": "Surface Damage Aggregate Missing", "code": "SAM" }, { "name": "Surface Damage Aggregate Projecting", "code": "SAP" }, { "name": "Surface Damage Aggregate Visible", "code": "SAV" }, { "name": "Surface Damage Corrosion", "code": "SCP" }, { "name": "Surface Damage Missing Wall", "code": "SMW" }, { "name": "Surface Damage Reinforcement Corroded", "code": "SRC" }, { "name": "Surface Damage Roughness Increased", "code": "SRI" }, { "name": "Surface Damage Reinforcement Projecting", "code": "SRP" }, { "name": "Surface Damage Reinforcement Visible", "code": "SRV" }, { "name": "Surface Spalling of Damage Coating", "code": "SSC" }, { "name": "Surface Damage Surface Spalling", "code": "SSS" }, { "name": "Surface Damage Other", "code": "SZ" }, { "name": "Tap Break-in/Hammer", "code": "TB" }, { "name": "Tap Break-in Activity", "code": "TBA" }, { "name": "Tap Break-in Abandoned", "code": "TBB" }, { "name": "Tap Break-in Capped", "code": "TBC" }, { "name": "Tap Break-in/Hammer Defective", "code": "TBD" }, { "name": "Tap Break-in Intruding", "code": "TBI" }, { "name": "Tap Factory", "code": "TF" }, { "name": "Tap Factory Activity", "code": "TFA" }, { "name": "Tap Factory Abandoned", "code": "TFB" }, { "name": "Tap Factory Capped", "code": "TFC" }, { "name": "Tap Factory Defective", "code": "TFD" }, { "name": "Tap Factory Intruding", "code": "TFI" }, { "name": "Tap Rehabilitated", "code": "TR" }, { "name": "Tap Rehabilitated Activity", "code": "TRA" }, { "name": "Tap Rehabilitated Abandoned", "code": "TRB" }, { "name": "Tap Rehabilitated Capped", "code": "TRC" }, { "name": "Tap Rehabilitated Defective", "code": "TRD" }, { "name": "Tap Rehabilitated Intruding", "code": "TRI" }, { "name": "Tap Saddle", "code": "TS" }, { "name": "Tap Saddle Activity", "code": "TSA" }, { "name": "Tap Saddle Abandoned", "code": "TSB" }, { "name": "Tap Saddle Capped", "code": "TSC" }, { "name": "Tap Saddle Defective", "code": "TSD" }, { "name": "Tap Saddle Intruding", "code": "TSI" }, { "name": "Vermin Cockroach", "code": "VC" }, { "name": "Vermin Rat", "code": "VR" }, { "name": "Vermin Other", "code": "VZ" }, { "name": "Weld Feature Circumferential", "code": "WFC" }, { "name": "Weld Feature Longitudinal", "code": "WFL" }, { "name": "Weld Feature Multiple", "code": "WFM" }, { "name": "Weld Feature Spiral", "code": "WFS" }, { "name": "Weld Feature Other", "code": "WFZ" }, { "name": "Collapse", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PACP_CODE" }, { "name": "VALUE_1ST_DIMENSION", "type": "esriFieldTypeSmallInteger", "alias": "Value_1st_Dimension", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALUE_1ST_DIMENSION" }, { "name": "VALUE_PERCENT", "type": "esriFieldTypeSmallInteger", "alias": "Value_Percent", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALUE_PERCENT" }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "REMARKS" }, { "name": "VCR_TIME", "type": "esriFieldTypeSmallInteger", "alias": "VCR_Time", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VCR_TIME" }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "INSPECTIONID" }, { "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": "GDB_196114_INSPE", "fields": "INSPECTIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R454177_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_454177", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_454177", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Storm_Gravity_Main_Inspections_Conditions", "description": "", "prototype": { "attributes": { "VCR_TIME": null, "INSPECTIONID": null, "REMARKS": null, "DISTANCE": null, "COUNTER": null, "PACP_CODE": null, "VALUE_1ST_DIMENSION": null, "VALUE_PERCENT": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 20000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "Storm_Manhole_Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Manhole", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "MANHOLE_NUMBER", "composite": false, "catalogID": "{F9A624C4-9811-4A2B-8186-B36D5E42EA9A}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "INSPECTIONID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INSPECTIONID" }, { "name": "MANHOLE_NUMBER", "type": "esriFieldTypeString", "alias": "Manhole_Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MANHOLE_NUMBER" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "domain": { "type": "codedValue", "name": "swWeather", "description": "", "codedValues": [ { "name": "Dry - No Precipitation During Survey", "code": "1" }, { "name": "Heavy Rain", "code": "2" }, { "name": "Light Rain", "code": "3" }, { "name": "Snow", "code": "4" }, { "name": "Dry Weather/Wet Ground", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WEATHER" }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "domain": { "type": "codedValue", "name": "swPurpose", "description": "", "codedValues": [ { "name": "Maintenance Related", "code": "A" }, { "name": "Infiltration/Inflow Investigation", "code": "B" }, { "name": "Post Rehabilitation Survey", "code": "C" }, { "name": "Pre-Rehabilitation Survey", "code": "D" }, { "name": "Pre-Acceptance New Sewers", "code": "E" }, { "name": "Routine Assessment", "code": "F" }, { "name": "Capital Improvement Program Assessment", "code": "G" }, { "name": "Resurvey For Any Reason", "code": "H" }, { "name": "Sewer System Evaluation Survey (SSES)", "code": "I" }, { "name": "Pre-Existing Video", "code": "R" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PURPOSE" }, { "name": "INSPECTIONLEVEL", "type": "esriFieldTypeString", "alias": "InspectionLevel", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "INSPECTIONLEVEL" }, { "name": "INSPECTIONSTATUS", "type": "esriFieldTypeString", "alias": "InspectionStatus", "domain": { "type": "codedValue", "name": "swInspectionStatus", "description": "", "codedValues": [ { "name": "Buried or Marked", "code": "BM" }, { "name": "Descent Inspection", "code": "DI" }, { "name": "No Access", "code": "NA" }, { "name": "Not Found", "code": "NF" }, { "name": "Traffic", "code": "NI" }, { "name": "Not Opened", "code": "NO" }, { "name": "Remote Inspection", "code": "RI" }, { "name": "Surcharged/Debris", "code": "SD" }, { "name": "Surface Inspection", "code": "SI" }, { "name": "Complete Inspection", "code": "CI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "INSPECTIONSTATUS" }, { "name": "COVER_FRAME_FIT", "type": "esriFieldTypeString", "alias": "Cover_Frame_Fit", "domain": { "type": "codedValue", "name": "swCoverFrameFit", "description": "Description", "codedValues": [ { "name": "Good", "code": "G" }, { "name": "Oversized", "code": "O" }, { "name": "Rocks/Wobbles", "code": "R" }, { "name": "Undersized", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "COVER_FRAME_FIT" }, { "name": "COVER_CONDITION_BOLTSMISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_BoltsMissing", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_BOLTSMISSING" }, { "name": "COVER_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Cover_Condition_Broken", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_BROKEN" }, { "name": "COVER_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Corroded", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_CORRODED" }, { "name": "COVER_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Cracked", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_CRACKED" }, { "name": "COVER_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_Missing", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_MISSING" }, { "name": "COVER_CONDITION_RESTRAINT_DEFE", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Defect", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_RESTRAINT_DEFE" }, { "name": "COVER_CONDITION_RESTRAINT_MISS", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Missin", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_RESTRAINT_MISS" }, { "name": "COVER_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Cover_Condition_Sound", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_SOUND" }, { "name": "INSERT_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Cracked", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_CRACKED" }, { "name": "INSERT_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Corroded", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_CORRODED" }, { "name": "INSERT_CONDITION_INSERTFELL", "type": "esriFieldTypeString", "alias": "Insert_Condition_InsertFell", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_INSERTFELL" }, { "name": "INSERT_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "Insert_Condition_Leaking", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_LEAKING" }, { "name": "INSERT_CONDITION_POORLYFITTING", "type": "esriFieldTypeString", "alias": "Insert_Condition_PoorlyFitting", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_POORLYFITTING" }, { "name": "INSERT_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Insert_Condition_Sound", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_SOUND" }, { "name": "RING_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Ring_Condition_Broken", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_BROKEN" }, { "name": "RING_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CORRODED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_CORRODED" }, { "name": "RING_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CRACKED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_CRACKED" }, { "name": "RING_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "RING_CONDITION_LEAKING", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_LEAKING" }, { "name": "RING_CONDITION_POORINSTALL", "type": "esriFieldTypeString", "alias": "RING_CONDITION_POORINSTALL", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_POORINSTALL" }, { "name": "RING_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "RING_CONDITION_SOUND", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_SOUND" }, { "name": "FRAME_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_BROKEN", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_BROKEN" }, { "name": "FRAME_CONDITION_COATED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_COATED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_COATED" }, { "name": "FRAME_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CORRODED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_CORRODED" }, { "name": "FRAME_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CRACKED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_CRACKED" }, { "name": "FRAME_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_MISSING", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_MISSING" }, { "name": "FRAME_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_SOUND", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_SOUND" }, { "name": "SEAL_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_CRACKED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_CRACKED" }, { "name": "SEAL_CONDITION_LOOSE", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_LOOSE", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_LOOSE" }, { "name": "SEAL_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_MISSING", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_MISSING" }, { "name": "SEAL_CONDITION_OFFSET", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_OFFSET", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_OFFSET" }, { "name": "SEAL_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_SOUND", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_SOUND" }, { "name": "CHIMNEY_CONDITION", "type": "esriFieldTypeString", "alias": "CHIMNEY_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CHIMNEY_CONDITION" }, { "name": "CONE_CONDITION", "type": "esriFieldTypeString", "alias": "CONE_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CONE_CONDITION" }, { "name": "WALL_CONDITION", "type": "esriFieldTypeString", "alias": "WALL_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "WALL_CONDITION" }, { "name": "BENCH_CONDITION", "type": "esriFieldTypeString", "alias": "BENCH_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BENCH_CONDITION" }, { "name": "CHANNEL_CONDITION", "type": "esriFieldTypeString", "alias": "CHANNEL_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CHANNEL_CONDITION" }, { "name": "STGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE1" }, { "name": "STGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE2" }, { "name": "STGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE3" }, { "name": "STGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE4" }, { "name": "STGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE5" }, { "name": "OMGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE1" }, { "name": "OMGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE2" }, { "name": "OMGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE3" }, { "name": "OMGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE4" }, { "name": "OMGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE5" }, { "name": "STMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "STMHRATING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STMHRATING" }, { "name": "OMMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OMMHRATING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMMHRATING" }, { "name": "OVERALLMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OVERALLMHRATING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLMHRATING" }, { "name": "STQUICKRATING", "type": "esriFieldTypeString", "alias": "STQUICKRATING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "STQUICKRATING" }, { "name": "OMQUICKRATING", "type": "esriFieldTypeString", "alias": "OMQUICKRATING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "OMQUICKRATING" }, { "name": "MACPQUICKRATING", "type": "esriFieldTypeString", "alias": "MACPQUICKRATING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MACPQUICKRATING" }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STMHRATINGSINDEX" }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMMHRATINGSINDEX" }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLMHRATINGSINDEX" }, { "name": "LOFMACP", "type": "esriFieldTypeDouble", "alias": "LOFMACP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOFMACP" }, { "name": "MEDIA_LABEL", "type": "esriFieldTypeString", "alias": "MEDIA_LABEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MEDIA_LABEL" } ], "indexes": [ { "name": "GDB_164929_MANHO", "fields": "MANHOLE_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R453857_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Storm_Manhole_Inspections", "description": "", "prototype": { "attributes": { "LOFMACP": null, "MEDIA_LABEL": null, "INSPECTIONID": null, "MANHOLE_NUMBER": null, "INSPECTION_DATE": null, "WEATHER": null, "PURPOSE": null, "INSPECTIONLEVEL": null, "INSPECTIONSTATUS": null, "COVER_FRAME_FIT": null, "COVER_CONDITION_BOLTSMISSING": null, "COVER_CONDITION_BROKEN": null, "COVER_CONDITION_CORRODED": null, "COVER_CONDITION_CRACKED": null, "COVER_CONDITION_MISSING": null, "COVER_CONDITION_RESTRAINT_DEFE": null, "COVER_CONDITION_RESTRAINT_MISS": null, "COVER_CONDITION_SOUND": null, "INSERT_CONDITION_CRACKED": null, "INSERT_CONDITION_CORRODED": null, "INSERT_CONDITION_INSERTFELL": null, "INSERT_CONDITION_LEAKING": null, "INSERT_CONDITION_POORLYFITTING": null, "INSERT_CONDITION_SOUND": null, "RING_CONDITION_BROKEN": null, "RING_CONDITION_CORRODED": null, "RING_CONDITION_CRACKED": null, "RING_CONDITION_LEAKING": null, "RING_CONDITION_POORINSTALL": null, "RING_CONDITION_SOUND": null, "FRAME_CONDITION_BROKEN": null, "FRAME_CONDITION_COATED": null, "FRAME_CONDITION_CORRODED": null, "FRAME_CONDITION_CRACKED": null, "FRAME_CONDITION_MISSING": null, "FRAME_CONDITION_SOUND": null, "SEAL_CONDITION_CRACKED": null, "SEAL_CONDITION_LOOSE": null, "SEAL_CONDITION_MISSING": null, "SEAL_CONDITION_OFFSET": null, "SEAL_CONDITION_SOUND": null, "CHIMNEY_CONDITION": null, "CONE_CONDITION": null, "WALL_CONDITION": null, "BENCH_CONDITION": null, "CHANNEL_CONDITION": null, "STGRADESCORE1": null, "STGRADESCORE2": null, "STGRADESCORE3": null, "STGRADESCORE4": null, "STGRADESCORE5": null, "OMGRADESCORE1": null, "OMGRADESCORE2": null, "OMGRADESCORE3": null, "OMGRADESCORE4": null, "OMGRADESCORE5": null, "STMHRATING": null, "OMMHRATING": null, "OVERALLMHRATING": null, "STQUICKRATING": null, "OMQUICKRATING": null, "MACPQUICKRATING": null, "STMHRATINGSINDEX": null, "OMMHRATINGSINDEX": null, "OVERALLMHRATINGSINDEX": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 20000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 12, "name": "Storm_Catchbasin_Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Catchbasin", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "MANHOLE_NUMBER", "composite": false, "catalogID": "{5973219A-C443-4843-B1A4-4290EEC60DFA}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "INSPECTIONID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INSPECTIONID" }, { "name": "MANHOLE_NUMBER", "type": "esriFieldTypeString", "alias": "Manhole_Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MANHOLE_NUMBER" }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSPECTION_DATE" }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "domain": { "type": "codedValue", "name": "swWeather", "description": "", "codedValues": [ { "name": "Dry - No Precipitation During Survey", "code": "1" }, { "name": "Heavy Rain", "code": "2" }, { "name": "Light Rain", "code": "3" }, { "name": "Snow", "code": "4" }, { "name": "Dry Weather/Wet Ground", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WEATHER" }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "domain": { "type": "codedValue", "name": "swPurpose", "description": "", "codedValues": [ { "name": "Maintenance Related", "code": "A" }, { "name": "Infiltration/Inflow Investigation", "code": "B" }, { "name": "Post Rehabilitation Survey", "code": "C" }, { "name": "Pre-Rehabilitation Survey", "code": "D" }, { "name": "Pre-Acceptance New Sewers", "code": "E" }, { "name": "Routine Assessment", "code": "F" }, { "name": "Capital Improvement Program Assessment", "code": "G" }, { "name": "Resurvey For Any Reason", "code": "H" }, { "name": "Sewer System Evaluation Survey (SSES)", "code": "I" }, { "name": "Pre-Existing Video", "code": "R" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PURPOSE" }, { "name": "INSPECTIONLEVEL", "type": "esriFieldTypeString", "alias": "InspectionLevel", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "INSPECTIONLEVEL" }, { "name": "INSPECTIONSTATUS", "type": "esriFieldTypeString", "alias": "InspectionStatus", "domain": { "type": "codedValue", "name": "swInspectionStatus", "description": "", "codedValues": [ { "name": "Buried or Marked", "code": "BM" }, { "name": "Descent Inspection", "code": "DI" }, { "name": "No Access", "code": "NA" }, { "name": "Not Found", "code": "NF" }, { "name": "Traffic", "code": "NI" }, { "name": "Not Opened", "code": "NO" }, { "name": "Remote Inspection", "code": "RI" }, { "name": "Surcharged/Debris", "code": "SD" }, { "name": "Surface Inspection", "code": "SI" }, { "name": "Complete Inspection", "code": "CI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "INSPECTIONSTATUS" }, { "name": "COVER_FRAME_FIT", "type": "esriFieldTypeString", "alias": "Cover_Frame_Fit", "domain": { "type": "codedValue", "name": "swCoverFrameFit", "description": "Description", "codedValues": [ { "name": "Good", "code": "G" }, { "name": "Oversized", "code": "O" }, { "name": "Rocks/Wobbles", "code": "R" }, { "name": "Undersized", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "COVER_FRAME_FIT" }, { "name": "COVER_CONDITION_BOLTSMISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_BoltsMissing", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_BOLTSMISSING" }, { "name": "COVER_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Cover_Condition_Broken", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_BROKEN" }, { "name": "COVER_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Corroded", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_CORRODED" }, { "name": "COVER_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Cracked", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_CRACKED" }, { "name": "COVER_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_Missing", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_MISSING" }, { "name": "COVER_CONDITION_RESTRAINT_DEFE", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Defect", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_RESTRAINT_DEFE" }, { "name": "COVER_CONDITION_RESTRAINT_MISS", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Missin", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_RESTRAINT_MISS" }, { "name": "COVER_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Cover_Condition_Sound", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "COVER_CONDITION_SOUND" }, { "name": "INSERT_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Cracked", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_CRACKED" }, { "name": "INSERT_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Corroded", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_CORRODED" }, { "name": "INSERT_CONDITION_INSERTFELL", "type": "esriFieldTypeString", "alias": "Insert_Condition_InsertFell", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_INSERTFELL" }, { "name": "INSERT_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "Insert_Condition_Leaking", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_LEAKING" }, { "name": "INSERT_CONDITION_POORLYFITTING", "type": "esriFieldTypeString", "alias": "Insert_Condition_PoorlyFitting", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_POORLYFITTING" }, { "name": "INSERT_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Insert_Condition_Sound", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "INSERT_CONDITION_SOUND" }, { "name": "RING_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Ring_Condition_Broken", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_BROKEN" }, { "name": "RING_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CORRODED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_CORRODED" }, { "name": "RING_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CRACKED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_CRACKED" }, { "name": "RING_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "RING_CONDITION_LEAKING", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_LEAKING" }, { "name": "RING_CONDITION_POORINSTALL", "type": "esriFieldTypeString", "alias": "RING_CONDITION_POORINSTALL", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_POORINSTALL" }, { "name": "RING_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "RING_CONDITION_SOUND", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "RING_CONDITION_SOUND" }, { "name": "FRAME_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_BROKEN", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_BROKEN" }, { "name": "FRAME_CONDITION_COATED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_COATED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_COATED" }, { "name": "FRAME_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CORRODED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_CORRODED" }, { "name": "FRAME_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CRACKED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_CRACKED" }, { "name": "FRAME_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_MISSING", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_MISSING" }, { "name": "FRAME_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_SOUND", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "FRAME_CONDITION_SOUND" }, { "name": "SEAL_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_CRACKED", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_CRACKED" }, { "name": "SEAL_CONDITION_LOOSE", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_LOOSE", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_LOOSE" }, { "name": "SEAL_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_MISSING", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_MISSING" }, { "name": "SEAL_CONDITION_OFFSET", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_OFFSET", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_OFFSET" }, { "name": "SEAL_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_SOUND", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SEAL_CONDITION_SOUND" }, { "name": "CHIMNEY_CONDITION", "type": "esriFieldTypeString", "alias": "CHIMNEY_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CHIMNEY_CONDITION" }, { "name": "CONE_CONDITION", "type": "esriFieldTypeString", "alias": "CONE_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CONE_CONDITION" }, { "name": "WALL_CONDITION", "type": "esriFieldTypeString", "alias": "WALL_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "WALL_CONDITION" }, { "name": "BENCH_CONDITION", "type": "esriFieldTypeString", "alias": "BENCH_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BENCH_CONDITION" }, { "name": "CHANNEL_CONDITION", "type": "esriFieldTypeString", "alias": "CHANNEL_CONDITION", "domain": { "type": "codedValue", "name": "swCondition_2", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "Defective", "code": "D" }, { "name": "Sound", "code": "S" }, { "name": "Not Known", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CHANNEL_CONDITION" }, { "name": "STGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE1" }, { "name": "STGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE2" }, { "name": "STGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE3" }, { "name": "STGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE4" }, { "name": "STGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STGRADESCORE5" }, { "name": "OMGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE1" }, { "name": "OMGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE2" }, { "name": "OMGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE3" }, { "name": "OMGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE4" }, { "name": "OMGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMGRADESCORE5" }, { "name": "STMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "STMHRATING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STMHRATING" }, { "name": "OMMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OMMHRATING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMMHRATING" }, { "name": "OVERALLMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OVERALLMHRATING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLMHRATING" }, { "name": "STQUICKRATING", "type": "esriFieldTypeString", "alias": "STQUICKRATING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "STQUICKRATING" }, { "name": "OMQUICKRATING", "type": "esriFieldTypeString", "alias": "OMQUICKRATING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "OMQUICKRATING" }, { "name": "MACPQUICKRATING", "type": "esriFieldTypeString", "alias": "MACPQUICKRATING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MACPQUICKRATING" }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STMHRATINGSINDEX" }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OMMHRATINGSINDEX" }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALLMHRATINGSINDEX" }, { "name": "LOFMACP", "type": "esriFieldTypeDouble", "alias": "LOFMACP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOFMACP" }, { "name": "MEDIA_LABEL", "type": "esriFieldTypeString", "alias": "MEDIA_LABEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MEDIA_LABEL" } ], "indexes": [ { "name": "GDB_164615_MANHO", "fields": "MANHOLE_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R453856_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Storm_Catchbasin_Inspections", "description": "", "prototype": { "attributes": { "LOFMACP": null, "MEDIA_LABEL": null, "INSPECTIONID": null, "MANHOLE_NUMBER": null, "INSPECTION_DATE": null, "WEATHER": null, "PURPOSE": null, "INSPECTIONLEVEL": null, "INSPECTIONSTATUS": null, "COVER_FRAME_FIT": null, "COVER_CONDITION_BOLTSMISSING": null, "COVER_CONDITION_BROKEN": null, "COVER_CONDITION_CORRODED": null, "COVER_CONDITION_CRACKED": null, "COVER_CONDITION_MISSING": null, "COVER_CONDITION_RESTRAINT_DEFE": null, "COVER_CONDITION_RESTRAINT_MISS": null, "COVER_CONDITION_SOUND": null, "INSERT_CONDITION_CRACKED": null, "INSERT_CONDITION_CORRODED": null, "INSERT_CONDITION_INSERTFELL": null, "INSERT_CONDITION_LEAKING": null, "INSERT_CONDITION_POORLYFITTING": null, "INSERT_CONDITION_SOUND": null, "RING_CONDITION_BROKEN": null, "RING_CONDITION_CORRODED": null, "RING_CONDITION_CRACKED": null, "RING_CONDITION_LEAKING": null, "RING_CONDITION_POORINSTALL": null, "RING_CONDITION_SOUND": null, "FRAME_CONDITION_BROKEN": null, "FRAME_CONDITION_COATED": null, "FRAME_CONDITION_CORRODED": null, "FRAME_CONDITION_CRACKED": null, "FRAME_CONDITION_MISSING": null, "FRAME_CONDITION_SOUND": null, "SEAL_CONDITION_CRACKED": null, "SEAL_CONDITION_LOOSE": null, "SEAL_CONDITION_MISSING": null, "SEAL_CONDITION_OFFSET": null, "SEAL_CONDITION_SOUND": null, "CHIMNEY_CONDITION": null, "CONE_CONDITION": null, "WALL_CONDITION": null, "BENCH_CONDITION": null, "CHANNEL_CONDITION": null, "STGRADESCORE1": null, "STGRADESCORE2": null, "STGRADESCORE3": null, "STGRADESCORE4": null, "STGRADESCORE5": null, "OMGRADESCORE1": null, "OMGRADESCORE2": null, "OMGRADESCORE3": null, "OMGRADESCORE4": null, "OMGRADESCORE5": null, "STMHRATING": null, "OMMHRATING": null, "OVERALLMHRATING": null, "STQUICKRATING": null, "OMQUICKRATING": null, "MACPQUICKRATING": null, "STMHRATINGSINDEX": null, "OMMHRATINGSINDEX": null, "OVERALLMHRATINGSINDEX": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 20000, "maxRecordCountFactor": 1 } ] }