{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "Oil and Grit Separators", "type": "Feature Layer", "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>", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "Town of Ajax Engineering Department, Town of Ajax GIS Section", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": false, "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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILTYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILTYID", "type": "esriFieldTypeInteger", "alias": "FACILTYID", "domain": null }, { "name": "LABEL", "type": "esriFieldTypeString", "alias": "LABEL", "length": 6, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 100, "domain": null }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "INF_REV_AREA", "length": 10, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "length": 8, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 255, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "length": 30, "domain": null }, { "name": "ASSET_ID_NUM", "type": "esriFieldTypeString", "alias": "ASSET_ID_NUM", "length": 50, "domain": null }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "STRUCT_TYPE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 100, "domain": null }, { "name": "INV_1", "type": "esriFieldTypeString", "alias": "INV_1", "length": 50, "domain": null }, { "name": "INV_2", "type": "esriFieldTypeString", "alias": "INV_2", "length": 50, "domain": null }, { "name": "INV_3", "type": "esriFieldTypeString", "alias": "INV_OTHER", "length": 50, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "OWNER", "length": 50, "domain": null }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "length": 8, "domain": null }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "length": 8, "domain": null }, { "name": "REPAIR_DATE", "type": "esriFieldTypeDate", "alias": "REPAIR_DATE", "length": 8, "domain": null }, { "name": "WORK_PERF", "type": "esriFieldTypeString", "alias": "WORK_PERF", "length": 255, "domain": null }, { "name": "C_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "C_ASSESS_DATE", "length": 8, "domain": null }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "length": 10, "domain": null }, { "name": "REM_LIFE", "type": "esriFieldTypeString", "alias": "REM_LIFE", "length": 10, "domain": null }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "length": 50, "domain": null }, { "name": "ASSUMED", "type": "esriFieldTypeString", "alias": "ASSUMEDD", "length": 50, "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "LATITUDE_", "type": "esriFieldTypeDouble", "alias": "Latitude_", "domain": null }, { "name": "LONGITUDE_", "type": "esriFieldTypeDouble", "alias": "Longitude_", "domain": null }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location ID #", "length": 255, "domain": null }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "length": 255, "domain": null }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "MUNICIPAL_ADDRESS", "type": "esriFieldTypeString", "alias": "Municipal Address", "length": 255, "domain": null }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 255, "domain": null }, { "name": "L1_ASSETCLASS", "type": "esriFieldTypeString", "alias": "Level 1: Asset Class", "length": 255, "domain": null }, { "name": "L2_ASSETCATEGORY", "type": "esriFieldTypeString", "alias": "Level 2: Asset Category", "length": 255, "domain": null }, { "name": "L3_ASSETTYPE", "type": "esriFieldTypeString", "alias": "Level 3: Asset Type", "length": 255, "domain": null }, { "name": "L4_SPECIFICGROUPEDASSETS", "type": "esriFieldTypeString", "alias": "Level 4: Specific Grouped Assets", "length": 255, "domain": null }, { "name": "TCACATEGORY", "type": "esriFieldTypeString", "alias": "TCA Category", "length": 255, "domain": null }, { "name": "AGE_", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null }, { "name": "YEARINSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null }, { "name": "ASSUMED_", "type": "esriFieldTypeString", "alias": "Assumed_", "length": 255, "domain": null }, { "name": "COMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Commissioned Date", "length": 8, "domain": null }, { "name": "DECOMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "length": 8, "domain": null }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "YEARRENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Year Renewed", "domain": null }, { "name": "LASTRENEWALACTIVITY", "type": "esriFieldTypeString", "alias": "Last Renewal Activity", "length": 255, "domain": null }, { "name": "REPLACEMENTUNITCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Unit Cost", "domain": null }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "PHYSICALCONDITION", "type": "esriFieldTypeString", "alias": "Physical Condition", "length": 255, "domain": null }, { "name": "FUNCTIONALCONDITION", "type": "esriFieldTypeString", "alias": "Functional Condition", "length": 255, "domain": null }, { "name": "DEMANDCONDITION", "type": "esriFieldTypeString", "alias": "Demand Condition", "length": 255, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R642_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A566_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1708712613000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Manhole", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MPLAN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 100, "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "MPLAN", "type": "esriFieldTypeString", "alias": "MPLAN", "length": 25, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "*LOCATION AGE*", "length": 255, "domain": null }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "*AGE*", "length": 10, "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "DEPTH_M", "type": "esriFieldTypeDouble", "alias": "Depth (m)", "domain": null }, { "name": "RIM_ELEV_M", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "DIAMETER_M", "type": "esriFieldTypeDouble", "alias": "Diameter (m)", "domain": null }, { "name": "INVERT_N", "type": "esriFieldTypeDouble", "alias": "N Invert", "domain": null }, { "name": "INVERT_NE", "type": "esriFieldTypeDouble", "alias": "NE Invert", "domain": null }, { "name": "INVERT_E", "type": "esriFieldTypeDouble", "alias": "E Invert", "domain": null }, { "name": "INVERT_SE", "type": "esriFieldTypeDouble", "alias": "SE Invert", "domain": null }, { "name": "INVERT_S", "type": "esriFieldTypeDouble", "alias": "S Invert", "domain": null }, { "name": "INVERT_SW", "type": "esriFieldTypeDouble", "alias": "SW Invert", "domain": null }, { "name": "INVERT_W", "type": "esriFieldTypeDouble", "alias": "W Invert", "domain": null }, { "name": "INVERT_NW", "type": "esriFieldTypeDouble", "alias": "NW Invert", "domain": null }, { "name": "DROP_STRUCT", "type": "esriFieldTypeString", "alias": "Drop Structure", "length": 255, "domain": { "type": "codedValue", "name": "YN", "description": "", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DROP_STRUCT_DIR", "type": "esriFieldTypeString", "alias": "Drop Structure Direction", "length": 255, "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" } }, { "name": "DROP_STRUCT_SIZE", "type": "esriFieldTypeDouble", "alias": "Drop Structure Pipe Size", "domain": null }, { "name": "SAFETY_PLATFORM", "type": "esriFieldTypeString", "alias": "Safety Platform", "length": 255, "domain": { "type": "codedValue", "name": "YN", "description": "", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "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" } }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "Ownership", "length": 255, "domain": null }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "length": 255, "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" } }, { "name": "COND_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assess Date", "length": 8, "domain": null }, { "name": "PHYSICAL_COND", "type": "esriFieldTypeString", "alias": "Physical Condition", "length": 255, "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" } }, { "name": "FUNCTIONAL_COND", "type": "esriFieldTypeString", "alias": "Functional Condition", "length": 255, "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" } }, { "name": "DEMAND_COND", "type": "esriFieldTypeString", "alias": "Demand Condition", "length": 255, "domain": null }, { "name": "REPLACEMENT_COST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "ROAD_CLASS", "type": "esriFieldTypeString", "alias": "Road Classification", "length": 255, "domain": null }, { "name": "LOT_PARK_NAME", "type": "esriFieldTypeString", "alias": "Parking Lot/Park Name", "length": 255, "domain": null }, { "name": "MANHOLE_OPSD", "type": "esriFieldTypeString", "alias": "Manhole OPSD", "length": 255, "domain": null }, { "name": "LID_OPSD", "type": "esriFieldTypeString", "alias": "Lid OPSD", "length": 255, "domain": null }, { "name": "TERM_STRUCT_ID", "type": "esriFieldTypeString", "alias": "Terminal Structure Asset ID", "length": 255, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "length": 50, "domain": null }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "length": 50, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "length": 255, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Inspection", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "ASSETID_CW", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9A624C4-9811-4A2B-8186-B36D5E42EA9A}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1713805692000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "Catchbasin", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STRUCT_TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "CityWorks ID", "length": 255, "domain": null }, { "name": "MPLAN", "type": "esriFieldTypeString", "alias": "MPlan", "length": 255, "domain": null }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "*AGE*", "length": 10, "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeInteger", "alias": "*TYPE*", "domain": null }, { "name": "STRUCT_TYPEX", "type": "esriFieldTypeString", "alias": "*TYPE_TEXT*", "length": 50, "domain": null }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "SUBDRAIN", "type": "esriFieldTypeString", "alias": "Subdrain", "length": 1, "domain": { "type": "codedValue", "name": "YN", "description": "", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "Ownership", "length": 50, "domain": null }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "*INF_REV_AREA*", "length": 10, "domain": null }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "length": 255, "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" } }, { "name": "COND_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assess Date", "length": 8, "domain": null }, { "name": "PHYSICAL_COND", "type": "esriFieldTypeString", "alias": "Physical Condition", "length": 255, "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" } }, { "name": "FUNCTIONAL_COND", "type": "esriFieldTypeString", "alias": "Functional Condition", "length": 255, "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" } }, { "name": "DEMAND_COND", "type": "esriFieldTypeString", "alias": "Demand Condition", "length": 255, "domain": null }, { "name": "REPLACEMENT_COST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LAST_CLEAN_DATE", "type": "esriFieldTypeDate", "alias": "Last Cleanout Date", "length": 8, "domain": null }, { "name": "ROAD_CLASS", "type": "esriFieldTypeString", "alias": "Road Classification", "length": 255, "domain": null }, { "name": "LOT_PARK_NAME", "type": "esriFieldTypeString", "alias": "Parking Lot/Park Name", "length": 255, "domain": null }, { "name": "GRATE_OPSD", "type": "esriFieldTypeString", "alias": "Grate OPSD", "length": 255, "domain": null }, { "name": "CATCHBASIN_OPSD", "type": "esriFieldTypeString", "alias": "Catchbasin OPSD", "length": 255, "domain": null }, { "name": "BIKE_ROUTE", "type": "esriFieldTypeString", "alias": "Bike Route", "length": 255, "domain": null }, { "name": "TERM_STRUCT_ID", "type": "esriFieldTypeString", "alias": "Terminal Structure Asset ID", "length": 255, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "length": 50, "domain": null }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "length": 50, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 255, "domain": { "type": "codedValue", "name": "Catchbasin_Status", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Removed", "code": "Removed" }, { "name": "Discrepancy", "code": "Discrepancy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "length": 255, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Inspections", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "ASSETID_CW", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5973219A-C443-4843-B1A4-4290EEC60DFA}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1713805627000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "Storm Gravity Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 7 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LOCATION_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 100, "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "CityWorks ID", "length": 255, "domain": null }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "Barcode", "length": 20, "domain": null }, { "name": "MPLAN", "type": "esriFieldTypeString", "alias": "MPlan", "length": 255, "domain": null }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "length": 255, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 255, "domain": null }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "length": 10, "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "LENGTH_M", "type": "esriFieldTypeDouble", "alias": "Length (m)", "domain": null }, { "name": "DIAMETER_MM", "type": "esriFieldTypeDouble", "alias": "Diameter (mm)", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "FUNCTION", "type": "esriFieldTypeString", "alias": "Function", "length": 255, "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" } }, { "name": "DOWNSTREAM_INV", "type": "esriFieldTypeDouble", "alias": "Downstream Invert", "domain": null }, { "name": "UPSTREAM_INV", "type": "esriFieldTypeDouble", "alias": "Upstream Invert", "domain": null }, { "name": "GR_PERCENT", "type": "esriFieldTypeDouble", "alias": "Grade %", "domain": null }, { "name": "SECTIONAL_SHAPE", "type": "esriFieldTypeString", "alias": "Sectional Shape", "length": 255, "domain": null }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "Ownership", "length": 255, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "length": 255, "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" } }, { "name": "COND_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assess Date", "length": 8, "domain": null }, { "name": "PHYSICAL_COND", "type": "esriFieldTypeString", "alias": "Physical Condition", "length": 255, "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" } }, { "name": "DEMAND_COND", "type": "esriFieldTypeString", "alias": "Demand Condition", "length": 255, "domain": null }, { "name": "FUNCTIONAL_COND", "type": "esriFieldTypeString", "alias": "Functional Condition", "length": 255, "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" } }, { "name": "REPLACEMENT_COST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "DRAIN_AREA", "type": "esriFieldTypeDouble", "alias": "Drainage Area (ha)", "domain": null }, { "name": "DRAIN_COEFF", "type": "esriFieldTypeDouble", "alias": "Drainage Coefficient", "domain": null }, { "name": "DOWNSTREAM_ID", "type": "esriFieldTypeString", "alias": "Downstream Asset ID", "length": 255, "domain": null }, { "name": "UPSTREAM_ID", "type": "esriFieldTypeString", "alias": "Upstream Asset ID", "length": 255, "domain": null }, { "name": "ROUGH_SCALE", "type": "esriFieldTypeDouble", "alias": "Manning's Roughness Scale", "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 50, "domain": null }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "length": 50, "domain": null }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "length": 50, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "length": 8, "domain": null }, { "name": "SHAPE.LEN", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null }, { "name": "WIDTH_MM", "type": "esriFieldTypeDouble", "alias": "WIDTH_MM", "domain": null }, { "name": "HEIGHT_MM", "type": "esriFieldTypeDouble", "alias": "HEIGHT_MM", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Inspections", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "ASSETID_CW", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{55565EE7-7A41-48D0-9FBA-9F9D99669D54}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.LEN", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1752144806000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "Manhole Inspections Latest", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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, 213, 192, 255 ], "toColor": [ 252, 213, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 192, 252, 255 ], "toColor": [ 182, 192, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 185, 255 ], "toColor": [ 184, 252, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 250, 252, 255 ], "toColor": [ 182, 250, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 216, 255 ], "toColor": [ 252, 179, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 252, 224, 255 ], "toColor": [ 212, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 228, 252, 255 ], "toColor": [ 202, 228, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 239, 215, 252, 255 ], "toColor": [ 239, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 249, 182, 252, 255 ], "toColor": [ 249, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 232, 252, 199, 255 ], "toColor": [ 232, 252, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 223, 255 ], "toColor": [ 252, 215, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 231, 184, 255 ], "toColor": [ 252, 231, 184, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID_CW", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "length": 8, "domain": null }, { "name": "INSPECTION_YEAR", "type": "esriFieldTypeDouble", "alias": "INSPECTION_YEAR", "domain": null }, { "name": "INSPECTION_MONTH", "type": "esriFieldTypeDouble", "alias": "INSPECTION_MONTH", "domain": null }, { "name": "INSPECTION_YEAR_MONTH", "type": "esriFieldTypeString", "alias": "INSPECTION_YEAR_MONTH", "length": 49, "domain": null }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "Catchbasin Inspections Latest", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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, 213, 192, 255 ], "toColor": [ 252, 213, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 192, 252, 255 ], "toColor": [ 182, 192, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 185, 255 ], "toColor": [ 184, 252, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 250, 252, 255 ], "toColor": [ 182, 250, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 216, 255 ], "toColor": [ 252, 179, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 252, 224, 255 ], "toColor": [ 212, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 228, 252, 255 ], "toColor": [ 202, 228, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 239, 215, 252, 255 ], "toColor": [ 239, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 249, 182, 252, 255 ], "toColor": [ 249, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 232, 252, 199, 255 ], "toColor": [ 232, 252, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 223, 255 ], "toColor": [ 252, 215, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 231, 184, 255 ], "toColor": [ 252, 231, 184, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID_CW", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "length": 8, "domain": null }, { "name": "INSPECTION_YEAR", "type": "esriFieldTypeDouble", "alias": "INSPECTION_YEAR", "domain": null }, { "name": "INSPECTION_MONTH", "type": "esriFieldTypeDouble", "alias": "INSPECTION_MONTH", "domain": null }, { "name": "INSPECTION_YEAR_MONTH", "type": "esriFieldTypeString", "alias": "INSPECTION_YEAR_MONTH", "length": 49, "domain": null }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "Gravity Main Inspections Latest", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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, 213, 192, 255 ], "toColor": [ 252, 213, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 192, 252, 255 ], "toColor": [ 182, 192, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 185, 255 ], "toColor": [ 184, 252, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 250, 252, 255 ], "toColor": [ 182, 250, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 216, 255 ], "toColor": [ 252, 179, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 250, 179, 255 ], "toColor": [ 252, 250, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 252, 224, 255 ], "toColor": [ 212, 252, 224, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 228, 252, 255 ], "toColor": [ 202, 228, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 239, 215, 252, 255 ], "toColor": [ 239, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 249, 182, 252, 255 ], "toColor": [ 249, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 232, 252, 199, 255 ], "toColor": [ 232, 252, 199, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 223, 255 ], "toColor": [ 252, 215, 223, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 231, 184, 255 ], "toColor": [ 252, 231, 184, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSETID_CW", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "length": 8, "domain": null }, { "name": "INSPECTION_YEAR", "type": "esriFieldTypeDouble", "alias": "INSPECTION_YEAR", "domain": null }, { "name": "INSPECTION_MONTH", "type": "esriFieldTypeDouble", "alias": "INSPECTION_MONTH", "domain": null }, { "name": "INSPECTION_YEAR_MONTH", "type": "esriFieldTypeString", "alias": "INSPECTION_YEAR_MONTH", "length": 49, "domain": null }, { "name": "STPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STPIPERATINGSINDEX", "domain": null }, { "name": "OMPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMPIPERATINGSINDEX", "domain": null }, { "name": "OVERALLPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLPIPERATINGSINDEX", "domain": null }, { "name": "SHAPE.LEN", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.LEN", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "Headwall", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "INF_REV_AREA", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "INF_REV_AREA", "length": 10, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "length": 8, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 255, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "length": 30, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 100, "domain": null }, { "name": "ASSET_ID_NUM", "type": "esriFieldTypeString", "alias": "ASSET_ID_NUM", "length": 50, "domain": null }, { "name": "STRUCT_TYPE", "type": "esriFieldTypeString", "alias": "STRUCT_TYPE", "length": 50, "domain": null }, { "name": "STD_DWG", "type": "esriFieldTypeString", "alias": "STD_DWG", "length": 50, "domain": null }, { "name": "INV_1", "type": "esriFieldTypeString", "alias": "INV_1", "length": 50, "domain": null }, { "name": "INV_2", "type": "esriFieldTypeString", "alias": "INV_2", "length": 50, "domain": null }, { "name": "INV_OTHER", "type": "esriFieldTypeString", "alias": "INV_OTHER", "length": 50, "domain": null }, { "name": "SPILLWAY_TYPE", "type": "esriFieldTypeString", "alias": "SPILLWAY_TYPE", "length": 50, "domain": null }, { "name": "FENCE_TYPE", "type": "esriFieldTypeString", "alias": "FENCE_TYPE", "length": 50, "domain": null }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "length": 8, "domain": null }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "length": 8, "domain": null }, { "name": "REPAIR_DATE", "type": "esriFieldTypeDate", "alias": "REPAIR_DATE", "length": 8, "domain": null }, { "name": "WORK_PERF", "type": "esriFieldTypeString", "alias": "WORK_PERF", "length": 255, "domain": null }, { "name": "C_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "C_ASSESS_DATE", "length": 8, "domain": null }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "length": 10, "domain": null }, { "name": "REM_LIFE", "type": "esriFieldTypeString", "alias": "REM_LIFE", "length": 15, "domain": null }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "length": 50, "domain": null }, { "name": "ASSUMED", "type": "esriFieldTypeString", "alias": "ASSUMED", "length": 50, "domain": null }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "length": 50, "domain": null }, { "name": "CREATEDATE", "type": "esriFieldTypeDate", "alias": "CREATEDATE", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "length": 50, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "length": 8, "domain": null }, { "name": "SHAPE.AREA", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null }, { "name": "SHAPE.LEN", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "LATITUDE_", "type": "esriFieldTypeDouble", "alias": "Latitude_", "domain": null }, { "name": "LONGITUDE_", "type": "esriFieldTypeDouble", "alias": "Longitude_", "domain": null }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location ID #", "length": 255, "domain": null }, { "name": "INFRASTRUCTURE_AREA_", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "length": 255, "domain": null }, { "name": "LOCATION_DESCRIPTION_", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "MUNICIPAL_ADDRESS", "type": "esriFieldTypeString", "alias": "Municipal Address", "length": 255, "domain": null }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 255, "domain": null }, { "name": "L1_ASSETCLASS", "type": "esriFieldTypeString", "alias": "Level 1: Asset Class", "length": 255, "domain": null }, { "name": "L2_ASSETCATEGORY", "type": "esriFieldTypeString", "alias": "Level 2: Asset Category", "length": 255, "domain": null }, { "name": "L3_ASSETTYPE", "type": "esriFieldTypeString", "alias": "Level 3: Asset Type", "length": 255, "domain": null }, { "name": "L4_SPECIFICGROUPEDASSETS", "type": "esriFieldTypeString", "alias": "Level 4: Specific Grouped Assets", "length": 255, "domain": null }, { "name": "TCACATEGORY", "type": "esriFieldTypeString", "alias": "TCA Category", "length": 255, "domain": null }, { "name": "AGE_", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null }, { "name": "YEARINSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null }, { "name": "ASSUMED_", "type": "esriFieldTypeString", "alias": "Assumed_", "length": 255, "domain": null }, { "name": "COMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Commissioned Date", "length": 8, "domain": null }, { "name": "DECOMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "length": 8, "domain": null }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "YEARRENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Year Renewed", "domain": null }, { "name": "LASTRENEWALACTIVITY", "type": "esriFieldTypeString", "alias": "Last Renewal Activity", "length": 255, "domain": null }, { "name": "REPLACEMENTUNITCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Unit Cost", "domain": null }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "PHYSICALCONDITION", "type": "esriFieldTypeString", "alias": "Physical Condition", "length": 255, "domain": null }, { "name": "FUNCTIONALCONDITION", "type": "esriFieldTypeString", "alias": "Functional Condition", "length": 255, "domain": null }, { "name": "DEMANDCONDITION", "type": "esriFieldTypeString", "alias": "Demand Condition", "length": 255, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "HEADWALL_TYPE", "type": "esriFieldTypeString", "alias": "Headwall Type", "length": 255, "domain": null }, { "name": "HEADWALL_STYLE", "type": "esriFieldTypeString", "alias": "Headwall Style", "length": 255, "domain": null }, { "name": "HEADWALL_MATERIAL", "type": "esriFieldTypeString", "alias": "Headwall Material", "length": 255, "domain": null }, { "name": "TOP_WALL_GUARDING", "type": "esriFieldTypeString", "alias": "Top of Wall Guarding", "length": 255, "domain": null }, { "name": "HEADWALL_STANDARD_NUMBER", "type": "esriFieldTypeString", "alias": "Headwall Standard Number", "length": 255, "domain": null }, { "name": "OUTFALL_GRATES", "type": "esriFieldTypeString", "alias": "Outfall Grates", "length": 255, "domain": null }, { "name": "GRATE_ORIENTATION", "type": "esriFieldTypeString", "alias": "Grate Orientation", "length": 255, "domain": null }, { "name": "GRATE_FASTENING", "type": "esriFieldTypeString", "alias": "Grate Fastening", "length": 255, "domain": null }, { "name": "GRATE_STANDARD_NUMBER", "type": "esriFieldTypeString", "alias": "Grate Standard Number", "length": 255, "domain": null }, { "name": "SPILLWAY_TREATMENT", "type": "esriFieldTypeString", "alias": "Spillway Treatment", "length": 255, "domain": null }, { "name": "SPILLWAY_OUTLET", "type": "esriFieldTypeString", "alias": "Spillway Outlet", "length": 255, "domain": null }, { "name": "NUM_OUTLET_PIPES", "type": "esriFieldTypeSmallInteger", "alias": "Number of Outlet Pipes", "domain": null }, { "name": "PIPE_1_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Pipe 1 Diameter", "domain": null }, { "name": "PIPE_1_INVERT", "type": "esriFieldTypeString", "alias": "Pipe 1 Invert", "length": 255, "domain": null }, { "name": "WATER_SOURCE_1", "type": "esriFieldTypeString", "alias": "Water Source 1", "length": 255, "domain": null }, { "name": "WATER_SOURCE_1_QUALITY", "type": "esriFieldTypeString", "alias": "Water Source 1 Quality", "length": 255, "domain": null }, { "name": "PIPE_2_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Pipe 1 Diameter", "domain": null }, { "name": "PIPE_2_INVERT", "type": "esriFieldTypeString", "alias": "Pipe 1 Invert", "length": 255, "domain": null }, { "name": "WATER_SOURCE_2", "type": "esriFieldTypeString", "alias": "Water Source 1", "length": 255, "domain": null }, { "name": "WATER_SOURCE_2_QUALITY", "type": "esriFieldTypeString", "alias": "Water Source 1 Quality", "length": 255, "domain": null }, { "name": "CONDITION_RATING", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": null }, { "name": "CONDITION_ASSESSOR", "type": "esriFieldTypeString", "alias": "Condition Assessor", "length": 255, "domain": null }, { "name": "CONDITION_ASSESSMENT_DATE", "type": "esriFieldTypeDate", "alias": "Condition Assessment Date", "length": 8, "domain": null }, { "name": "LIFECYCLE_ACTIVITY2_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY3", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 3", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY3_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY4", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 4", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY4_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY1_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY2_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY3_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY4_UNITCOST", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY_COST_10YR", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost to 2031", "domain": null }, { "name": "LIFECYCLE_ACTIVITY_COST_50YR", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost to 2071", "domain": null }, { "name": "LIFECYCLE_ACTIVITY1", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 1", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY1_FREQ", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY2", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 2", "length": 255, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.AREA", "shapeLengthFieldName": "SHAPE.LEN", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1710254585000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 8, "name": "Storm Ponds", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "POND_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "AJAX_POND", "type": "esriFieldTypeString", "alias": "AJAX_POND", "length": 10, "domain": null }, { "name": "POND_NUM", "type": "esriFieldTypeString", "alias": "POND_NUM", "length": 10, "domain": null }, { "name": "POND_NAME", "type": "esriFieldTypeString", "alias": "POND_NAME", "length": 100, "domain": null }, { "name": "DRAW_APPRO", "type": "esriFieldTypeString", "alias": "DRAW_APPRO", "length": 6, "domain": null }, { "name": "ASSU_BYLAW", "type": "esriFieldTypeString", "alias": "ASSU_BYLAW", "length": 10, "domain": null }, { "name": "ASSU_DATE", "type": "esriFieldTypeDate", "alias": "ASSU_DATE", "length": 8, "domain": null }, { "name": "CAP_YEAR", "type": "esriFieldTypeString", "alias": "CAP_YEAR", "length": 6, "domain": null }, { "name": "LAND_USE", "type": "esriFieldTypeString", "alias": "LAND_USE", "length": 15, "domain": null }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "OWNERSHIP", "length": 50, "domain": null }, { "name": "ISSUES", "type": "esriFieldTypeString", "alias": "ISSUES", "length": 100, "domain": null }, { "name": "PRV_TWN", "type": "esriFieldTypeString", "alias": "PRV_TWN", "length": 5, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 100, "domain": null }, { "name": "INF_REV_AREA", "type": "esriFieldTypeString", "alias": "INF_REV_AREA", "length": 10, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "length": 8, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 255, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LEGACYID", "length": 30, "domain": null }, { "name": "ASSET_ID_NUM", "type": "esriFieldTypeString", "alias": "ASSET_ID_NUM", "length": 50, "domain": null }, { "name": "POND_TYPE", "type": "esriFieldTypeString", "alias": "POND_TYPE", "length": 50, "domain": null }, { "name": "TRCAPOND_NUM", "type": "esriFieldTypeString", "alias": "TRCAPOND_NUM", "length": 50, "domain": null }, { "name": "MOE_COA", "type": "esriFieldTypeString", "alias": "MOE_COA", "length": 50, "domain": null }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "length": 8, "domain": null }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "length": 8, "domain": null }, { "name": "REPAIR_DATE", "type": "esriFieldTypeDate", "alias": "REPAIR_DATE", "length": 8, "domain": null }, { "name": "WORK_PERF", "type": "esriFieldTypeString", "alias": "WORK_PERF", "length": 255, "domain": null }, { "name": "REHAB_DATE", "type": "esriFieldTypeDate", "alias": "REHAB_DATE", "length": 8, "domain": null }, { "name": "C_ASSESS_DATE", "type": "esriFieldTypeDate", "alias": "C_ASSESS_DATE", "length": 8, "domain": null }, { "name": "AGE", "type": "esriFieldTypeString", "alias": "AGE", "length": 10, "domain": null }, { "name": "REM_LIFE", "type": "esriFieldTypeString", "alias": "REM_LIFE", "length": 10, "domain": null }, { "name": "REP_VALUE", "type": "esriFieldTypeString", "alias": "REP_VALUE", "length": 10, "domain": null }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "length": 50, "domain": null }, { "name": "ASSUMED", "type": "esriFieldTypeString", "alias": "ASSUMED", "length": 50, "domain": null }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "CREATEDBY", "length": 50, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "length": 50, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EDITDATE", "length": 8, "domain": null }, { "name": "ASSETID_CW", "type": "esriFieldTypeString", "alias": "ASSETID_CW", "length": 255, "domain": null }, { "name": "SHAPE.AREA", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null }, { "name": "SHAPE.LEN", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null }, { "name": "LATITUDE_", "type": "esriFieldTypeDouble", "alias": "Latitude_", "domain": null }, { "name": "LONGITUDE_", "type": "esriFieldTypeDouble", "alias": "Longitude_", "domain": null }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "Location ID #", "length": 255, "domain": null }, { "name": "INFRASTRUCTURE_AREA", "type": "esriFieldTypeString", "alias": "Infrastructure Area", "length": 255, "domain": null }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "MUNICIPAL_ADDRESS", "type": "esriFieldTypeString", "alias": "Municipal Address", "length": 255, "domain": null }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 255, "domain": null }, { "name": "L1_ASSETCLASS", "type": "esriFieldTypeString", "alias": "Level 1: Asset Class", "length": 255, "domain": null }, { "name": "L2_ASSETCATEGORY", "type": "esriFieldTypeString", "alias": "Level 2: Asset Category", "length": 255, "domain": null }, { "name": "L3_ASSETTYPE", "type": "esriFieldTypeString", "alias": "Level 3: Asset Type", "length": 255, "domain": null }, { "name": "L4_SPECIFICGROUPEDASSETS", "type": "esriFieldTypeString", "alias": "Level 4: Specific Grouped Assets", "length": 255, "domain": null }, { "name": "TCACATEGORY", "type": "esriFieldTypeString", "alias": "TCA Category", "length": 255, "domain": null }, { "name": "AGE_", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null }, { "name": "YEARINSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null }, { "name": "ASSUMED_", "type": "esriFieldTypeString", "alias": "Assumed_", "length": 255, "domain": null }, { "name": "COMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Commissioned Date", "length": 8, "domain": null }, { "name": "DECOMMISSIONEDDATE", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "length": 8, "domain": null }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "YEARRENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Year Renewed", "domain": null }, { "name": "LASTRENEWALACTIVITY", "type": "esriFieldTypeString", "alias": "Last Renewal Activity", "length": 255, "domain": null }, { "name": "REPLACEMENTUNITCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Unit Cost", "domain": null }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "PHYSICALCONDITION", "type": "esriFieldTypeString", "alias": "Physical Condition", "length": 255, "domain": null }, { "name": "FUNCTIONALCONDITION", "type": "esriFieldTypeString", "alias": "Functional Condition", "length": 255, "domain": null }, { "name": "DEMANDCONDITION", "type": "esriFieldTypeString", "alias": "Demand Condition", "length": 255, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "FUNCTION", "type": "esriFieldTypeString", "alias": "Function", "length": 255, "domain": null }, { "name": "PERMANENT_POOL_VOLUME", "type": "esriFieldTypeString", "alias": "Permanent Pool Volume", "length": 255, "domain": null }, { "name": "FLUCTUATING_STORAGE_VOLUME", "type": "esriFieldTypeString", "alias": "Flunctuating Storage Volume", "length": 255, "domain": null }, { "name": "MAX_STORAGE_VOLUME", "type": "esriFieldTypeDouble", "alias": "Max Storage Volume", "domain": null }, { "name": "OVERFLOW_WEIR_ELEVATION1", "type": "esriFieldTypeDouble", "alias": "Overflow Weir Elevation", "domain": null }, { "name": "NUMBER_OF_INLETS1", "type": "esriFieldTypeSmallInteger", "alias": "Number of Inlets", "domain": null }, { "name": "OUTFALL_TYPE1", "type": "esriFieldTypeString", "alias": "Outfall Type", "length": 255, "domain": null }, { "name": "CREEK_NAME1", "type": "esriFieldTypeString", "alias": "Creek Name", "length": 255, "domain": null }, { "name": "HEADWALL_ASSET_ID1", "type": "esriFieldTypeString", "alias": "Headwall Asset ID", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY11", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 1", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY1_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY21", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 2", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY2_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY31", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 3", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY3_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY41", "type": "esriFieldTypeString", "alias": "Lifecycle Activity 4", "length": 255, "domain": null }, { "name": "LIFECYCLE_ACTIVITY4_FREQ1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Frequency", "domain": null }, { "name": "LIFECYCLE_ACTIVITY1_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 1 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY2_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 2 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY3_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 3 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY4_UNITCOST1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity 4 Unit Cost", "domain": null }, { "name": "LIFECYCLE_ACTIVITY_COST_10YR1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost 10 Years", "domain": null }, { "name": "LIFECYCLE_ACTIVITY_COST_50YR1", "type": "esriFieldTypeDouble", "alias": "Lifecycle Activity Cost 50 Years", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.AREA", "shapeLengthFieldName": "SHAPE.LEN", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1708712794000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "Storm_Gravity_Main_Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "PIPE_SEGMENT_REFERENCE", "type": "esriFieldTypeString", "alias": "Pipe_Segment_Reference", "length": 255, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "length": 1, "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" } }, { "name": "PRECLEANING", "type": "esriFieldTypeString", "alias": "PreCleaning", "length": 1, "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" } }, { "name": "FLOW_CONTROL", "type": "esriFieldTypeString", "alias": "Flow_Control", "length": 1, "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" } }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "length": 1, "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" } }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "Direction", "length": 1, "domain": { "type": "codedValue", "name": "swDirection_1", "description": "", "codedValues": [ { "name": "Upstream", "code": "U" }, { "name": "Downstream", "code": "D" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore1", "domain": null }, { "name": "STGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore2", "domain": null }, { "name": "STGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore3", "domain": null }, { "name": "STGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore4", "domain": null }, { "name": "STGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "STGradeScore5", "domain": null }, { "name": "OMGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore1", "domain": null }, { "name": "OMGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore2", "domain": null }, { "name": "OMGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore3", "domain": null }, { "name": "OMGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore4", "domain": null }, { "name": "OMGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "OMGradeScore5", "domain": null }, { "name": "STPIPERATING", "type": "esriFieldTypeSmallInteger", "alias": "STPipeRating", "domain": null }, { "name": "OMPIPERATING", "type": "esriFieldTypeSmallInteger", "alias": "OMPipeRating", "domain": null }, { "name": "OVERALLPIPERATING", "type": "esriFieldTypeSmallInteger", "alias": "OverallPipeRating", "domain": null }, { "name": "STQUICKRATING", "type": "esriFieldTypeString", "alias": "STQuickRating", "length": 10, "domain": null }, { "name": "OMQUICKRATING", "type": "esriFieldTypeString", "alias": "OMQuickRating", "length": 10, "domain": null }, { "name": "PACPQUICKRATING", "type": "esriFieldTypeString", "alias": "PACPQuickRating", "length": 10, "domain": null }, { "name": "STPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STPipeRatingsIndex", "domain": null }, { "name": "OMPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMPipeRatingsIndex", "domain": null }, { "name": "OVERALLPIPERATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OverallPipeRatingsIndex", "domain": null }, { "name": "LOFPACP", "type": "esriFieldTypeDouble", "alias": "LoFPACP", "domain": null }, { "name": "MEDIA_LABEL", "type": "esriFieldTypeString", "alias": "Media_Label", "length": 255, "domain": null }, { "name": "INSPECTION_STATUS", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 10, "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" } }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "length": 20, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Conditions", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "INSPECTIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{98B91C9D-9844-4439-A084-2E2EA480172A}" }, { "id": 2, "name": "Gravity Main", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "PIPE_SEGMENT_REFERENCE", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{55565EE7-7A41-48D0-9FBA-9F9D99669D54}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "name": "Storm_Gravity_Main_Inspections_Conditions", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "DISTANCE", "type": "esriFieldTypeDouble", "alias": "Distance", "domain": null }, { "name": "COUNTER", "type": "esriFieldTypeSmallInteger", "alias": "Counter", "domain": null }, { "name": "PACP_CODE", "type": "esriFieldTypeString", "alias": "PACP_Code", "length": 5, "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" } }, { "name": "VALUE_1ST_DIMENSION", "type": "esriFieldTypeSmallInteger", "alias": "Value_1st_Dimension", "domain": null }, { "name": "VALUE_PERCENT", "type": "esriFieldTypeSmallInteger", "alias": "Value_Percent", "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 100, "domain": null }, { "name": "VCR_TIME", "type": "esriFieldTypeSmallInteger", "alias": "VCR_Time", "domain": null }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "length": 20, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Inspection", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "INSPECTIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{98B91C9D-9844-4439-A084-2E2EA480172A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "Storm_Manhole_Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECTIONID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "length": 255, "domain": null }, { "name": "MANHOLE_NUMBER", "type": "esriFieldTypeString", "alias": "Manhole_Number", "length": 10, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "length": 255, "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" } }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "length": 1, "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" } }, { "name": "INSPECTIONLEVEL", "type": "esriFieldTypeString", "alias": "InspectionLevel", "length": 1, "domain": null }, { "name": "INSPECTIONSTATUS", "type": "esriFieldTypeString", "alias": "InspectionStatus", "length": 2, "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" } }, { "name": "COVER_FRAME_FIT", "type": "esriFieldTypeString", "alias": "Cover_Frame_Fit", "length": 1, "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" } }, { "name": "COVER_CONDITION_BOLTSMISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_BoltsMissing", "length": 5, "domain": null }, { "name": "COVER_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Cover_Condition_Broken", "length": 5, "domain": null }, { "name": "COVER_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Corroded", "length": 5, "domain": null }, { "name": "COVER_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Cracked", "length": 5, "domain": null }, { "name": "COVER_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_Missing", "length": 5, "domain": null }, { "name": "COVER_CONDITION_RESTRAINT_DEFE", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Defect", "length": 5, "domain": null }, { "name": "COVER_CONDITION_RESTRAINT_MISS", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Missin", "length": 5, "domain": null }, { "name": "COVER_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Cover_Condition_Sound", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Cracked", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Corroded", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_INSERTFELL", "type": "esriFieldTypeString", "alias": "Insert_Condition_InsertFell", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "Insert_Condition_Leaking", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_POORLYFITTING", "type": "esriFieldTypeString", "alias": "Insert_Condition_PoorlyFitting", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Insert_Condition_Sound", "length": 5, "domain": null }, { "name": "RING_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Ring_Condition_Broken", "length": 5, "domain": null }, { "name": "RING_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CORRODED", "length": 5, "domain": null }, { "name": "RING_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CRACKED", "length": 5, "domain": null }, { "name": "RING_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "RING_CONDITION_LEAKING", "length": 5, "domain": null }, { "name": "RING_CONDITION_POORINSTALL", "type": "esriFieldTypeString", "alias": "RING_CONDITION_POORINSTALL", "length": 5, "domain": null }, { "name": "RING_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "RING_CONDITION_SOUND", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_BROKEN", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_COATED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_COATED", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CORRODED", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CRACKED", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_MISSING", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_SOUND", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_CRACKED", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_LOOSE", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_LOOSE", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_MISSING", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_OFFSET", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_OFFSET", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_SOUND", "length": 5, "domain": null }, { "name": "CHIMNEY_CONDITION", "type": "esriFieldTypeString", "alias": "CHIMNEY_CONDITION", "length": 1, "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" } }, { "name": "CONE_CONDITION", "type": "esriFieldTypeString", "alias": "CONE_CONDITION", "length": 1, "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" } }, { "name": "WALL_CONDITION", "type": "esriFieldTypeString", "alias": "WALL_CONDITION", "length": 1, "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" } }, { "name": "BENCH_CONDITION", "type": "esriFieldTypeString", "alias": "BENCH_CONDITION", "length": 1, "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" } }, { "name": "CHANNEL_CONDITION", "type": "esriFieldTypeString", "alias": "CHANNEL_CONDITION", "length": 1, "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" } }, { "name": "STGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE1", "domain": null }, { "name": "STGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE2", "domain": null }, { "name": "STGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE3", "domain": null }, { "name": "STGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE4", "domain": null }, { "name": "STGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE5", "domain": null }, { "name": "OMGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE1", "domain": null }, { "name": "OMGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE2", "domain": null }, { "name": "OMGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE3", "domain": null }, { "name": "OMGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE4", "domain": null }, { "name": "OMGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE5", "domain": null }, { "name": "STMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "STMHRATING", "domain": null }, { "name": "OMMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OMMHRATING", "domain": null }, { "name": "OVERALLMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OVERALLMHRATING", "domain": null }, { "name": "STQUICKRATING", "type": "esriFieldTypeString", "alias": "STQUICKRATING", "length": 10, "domain": null }, { "name": "OMQUICKRATING", "type": "esriFieldTypeString", "alias": "OMQUICKRATING", "length": 10, "domain": null }, { "name": "MACPQUICKRATING", "type": "esriFieldTypeString", "alias": "MACPQUICKRATING", "length": 10, "domain": null }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null }, { "name": "LOFMACP", "type": "esriFieldTypeDouble", "alias": "LOFMACP", "domain": null }, { "name": "MEDIA_LABEL", "type": "esriFieldTypeString", "alias": "MEDIA_LABEL", "length": 255, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Manhole", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "MANHOLE_NUMBER", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9A624C4-9811-4A2B-8186-B36D5E42EA9A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 12, "name": "Storm_Catchbasin_Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECTIONID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSPECTIONID", "type": "esriFieldTypeString", "alias": "InspectionID", "length": 255, "domain": null }, { "name": "MANHOLE_NUMBER", "type": "esriFieldTypeString", "alias": "Manhole_Number", "length": 10, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather", "length": 255, "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" } }, { "name": "PURPOSE", "type": "esriFieldTypeString", "alias": "Purpose", "length": 1, "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" } }, { "name": "INSPECTIONLEVEL", "type": "esriFieldTypeString", "alias": "InspectionLevel", "length": 1, "domain": null }, { "name": "INSPECTIONSTATUS", "type": "esriFieldTypeString", "alias": "InspectionStatus", "length": 2, "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" } }, { "name": "COVER_FRAME_FIT", "type": "esriFieldTypeString", "alias": "Cover_Frame_Fit", "length": 1, "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" } }, { "name": "COVER_CONDITION_BOLTSMISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_BoltsMissing", "length": 5, "domain": null }, { "name": "COVER_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Cover_Condition_Broken", "length": 5, "domain": null }, { "name": "COVER_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Corroded", "length": 5, "domain": null }, { "name": "COVER_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Cover_Condition_Cracked", "length": 5, "domain": null }, { "name": "COVER_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "Cover_Condition_Missing", "length": 5, "domain": null }, { "name": "COVER_CONDITION_RESTRAINT_DEFE", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Defect", "length": 5, "domain": null }, { "name": "COVER_CONDITION_RESTRAINT_MISS", "type": "esriFieldTypeString", "alias": "Cover_Condition_Restraint_Missin", "length": 5, "domain": null }, { "name": "COVER_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Cover_Condition_Sound", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Cracked", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "Insert_Condition_Corroded", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_INSERTFELL", "type": "esriFieldTypeString", "alias": "Insert_Condition_InsertFell", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "Insert_Condition_Leaking", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_POORLYFITTING", "type": "esriFieldTypeString", "alias": "Insert_Condition_PoorlyFitting", "length": 5, "domain": null }, { "name": "INSERT_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "Insert_Condition_Sound", "length": 5, "domain": null }, { "name": "RING_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "Ring_Condition_Broken", "length": 5, "domain": null }, { "name": "RING_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CORRODED", "length": 5, "domain": null }, { "name": "RING_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "RING_CONDITION_CRACKED", "length": 5, "domain": null }, { "name": "RING_CONDITION_LEAKING", "type": "esriFieldTypeString", "alias": "RING_CONDITION_LEAKING", "length": 5, "domain": null }, { "name": "RING_CONDITION_POORINSTALL", "type": "esriFieldTypeString", "alias": "RING_CONDITION_POORINSTALL", "length": 5, "domain": null }, { "name": "RING_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "RING_CONDITION_SOUND", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_BROKEN", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_BROKEN", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_COATED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_COATED", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_CORRODED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CORRODED", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_CRACKED", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_MISSING", "length": 5, "domain": null }, { "name": "FRAME_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "FRAME_CONDITION_SOUND", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_CRACKED", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_CRACKED", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_LOOSE", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_LOOSE", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_MISSING", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_MISSING", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_OFFSET", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_OFFSET", "length": 5, "domain": null }, { "name": "SEAL_CONDITION_SOUND", "type": "esriFieldTypeString", "alias": "SEAL_CONDITION_SOUND", "length": 5, "domain": null }, { "name": "CHIMNEY_CONDITION", "type": "esriFieldTypeString", "alias": "CHIMNEY_CONDITION", "length": 1, "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" } }, { "name": "CONE_CONDITION", "type": "esriFieldTypeString", "alias": "CONE_CONDITION", "length": 1, "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" } }, { "name": "WALL_CONDITION", "type": "esriFieldTypeString", "alias": "WALL_CONDITION", "length": 1, "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" } }, { "name": "BENCH_CONDITION", "type": "esriFieldTypeString", "alias": "BENCH_CONDITION", "length": 1, "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" } }, { "name": "CHANNEL_CONDITION", "type": "esriFieldTypeString", "alias": "CHANNEL_CONDITION", "length": 1, "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" } }, { "name": "STGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE1", "domain": null }, { "name": "STGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE2", "domain": null }, { "name": "STGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE3", "domain": null }, { "name": "STGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE4", "domain": null }, { "name": "STGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "STGRADESCORE5", "domain": null }, { "name": "OMGRADESCORE1", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE1", "domain": null }, { "name": "OMGRADESCORE2", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE2", "domain": null }, { "name": "OMGRADESCORE3", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE3", "domain": null }, { "name": "OMGRADESCORE4", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE4", "domain": null }, { "name": "OMGRADESCORE5", "type": "esriFieldTypeSmallInteger", "alias": "OMGRADESCORE5", "domain": null }, { "name": "STMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "STMHRATING", "domain": null }, { "name": "OMMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OMMHRATING", "domain": null }, { "name": "OVERALLMHRATING", "type": "esriFieldTypeSmallInteger", "alias": "OVERALLMHRATING", "domain": null }, { "name": "STQUICKRATING", "type": "esriFieldTypeString", "alias": "STQUICKRATING", "length": 10, "domain": null }, { "name": "OMQUICKRATING", "type": "esriFieldTypeString", "alias": "OMQUICKRATING", "length": 10, "domain": null }, { "name": "MACPQUICKRATING", "type": "esriFieldTypeString", "alias": "MACPQUICKRATING", "length": 10, "domain": null }, { "name": "STMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "STMHRATINGSINDEX", "domain": null }, { "name": "OMMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OMMHRATINGSINDEX", "domain": null }, { "name": "OVERALLMHRATINGSINDEX", "type": "esriFieldTypeDouble", "alias": "OVERALLMHRATINGSINDEX", "domain": null }, { "name": "LOFMACP", "type": "esriFieldTypeDouble", "alias": "LOFMACP", "domain": null }, { "name": "MEDIA_LABEL", "type": "esriFieldTypeString", "alias": "MEDIA_LABEL", "length": 255, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Catchbasin", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "MANHOLE_NUMBER", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5973219A-C443-4843-B1A4-4290EEC60DFA}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }