{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Bidd_2012.DBO.Add_a_Catch_Basin", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102684, "latestWkid": 26848, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -15495200, "falseY": -48378500, "xyUnits": 3048.0060960121928, "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": "esriSMS", "style": "esriSMSCircle", "color": [ 142, 75, 59, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7847171.884034498, "ymin": 5379272.8987727715, "xmax": -7830490.143446859, "ymax": 5388167.737866308, "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": "AncillaryRole", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": null }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "length": 200, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "In-Place - Not Active", "code": "In-Place" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "WaterType", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterType", "description": "", "codedValues": [ { "name": "Combined", "code": "Combined" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 120, "domain": null }, { "name": "Rim", "type": "esriFieldTypeDouble", "alias": "Rim", "domain": null }, { "name": "Invert", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "AccessMaterial", "type": "esriFieldTypeString", "alias": "AccessMaterial", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainJunctionMaterial", "description": "", "codedValues": [ { "name": "Steel", "code": "Steel" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Poly Vinyl Chloride", "code": "PVC" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Clay", "code": "Cl" }, { "name": "Wood", "code": "Wo" }, { "name": "Unknown", "code": "Unk" }, { "name": "Other", "code": "Oth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AccesType", "type": "esriFieldTypeString", "alias": "AccesType", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainAccessType", "description": "", "codedValues": [ { "name": "Door", "code": "Door" }, { "name": "Grate", "code": "Grate" }, { "name": "Hand", "code": "Hand" }, { "name": "Lid", "code": "Lid" }, { "name": "Manhole Cover", "code": "Cover" }, { "name": "Other", "code": "Oth" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "length": 25, "domain": null }, { "name": "FIELDNOTE1", "type": "esriFieldTypeString", "alias": "FIELDNOTE1", "length": 25, "domain": null }, { "name": "Label_ID", "type": "esriFieldTypeString", "alias": "Label_ID", "length": 7, "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 }, { "name": "Protected_GUID", "type": "esriFieldTypeGUID", "alias": "Protected_GUID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R891_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_891", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_891", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5420_Facilit", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S775_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.Structure_Inspection_Data", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5830DCED-708C-4406-ABAE-345D4C40B862}" }, { "id": 1, "name": "DBO.CB_Storm_Water_Inspection_Data", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2EF0CAA9-3DCE-4DF5-AA2C-30162BB507E4}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": 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, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "ss Outfalls", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102684, "latestWkid": 26848, "xyTolerance": 0.002, "zTolerance": 0.002, "mTolerance": 0.002, "falseX": -15495200, "falseY": -48378500, "xyUnits": 4000, "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": "esriSMS", "style": "esriSMSCircle", "color": [ 101, 57, 147, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7852390.284057508, "ymin": 5379716.465867603, "xmax": -7831159.259115937, "ymax": 5388416.305669612, "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": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "AncillaryRole", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "length": 200, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "In-Place - Not Active", "code": "In-Place" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "WaterType", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterType", "description": "", "codedValues": [ { "name": "Combined", "code": "Combined" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 120, "domain": null }, { "name": "OutfallID", "type": "esriFieldTypeString", "alias": "OutfallID", "length": 20, "domain": null }, { "name": "Diameter", "type": "esriFieldTypeInteger", "alias": "Diameter", "domain": { "type": "codedValue", "name": "ssDomainMainDistributionDiameter", "description": "", "codedValues": [ { "name": "1 inch", "code": 1 }, { "name": "2 inch", "code": 2 }, { "name": "4 inch", "code": 4 }, { "name": "6 inch", "code": 6 }, { "name": "8 inch", "code": 8 }, { "name": "10 inch", "code": 10 }, { "name": "12 inch", "code": 12 }, { "name": "14 inch", "code": 14 }, { "name": "15 inch", "code": 15 }, { "name": "16 inch", "code": 16 }, { "name": "18 inch", "code": 18 }, { "name": "20 inch", "code": 20 }, { "name": "24 inch", "code": 24 }, { "name": "27 inch", "code": 27 }, { "name": "30 inch", "code": 30 }, { "name": "36 inch", "code": 36 }, { "name": "42 inch", "code": 42 }, { "name": "48 inch", "code": 48 }, { "name": "54 inch", "code": 54 }, { "name": "60 inch", "code": 60 }, { "name": "72 inch", "code": 72 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "21 inch", "code": 21 }, { "name": "22 inch", "code": 22 }, { "name": "3 inch", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Invert", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "Label_ID", "type": "esriFieldTypeSmallInteger", "alias": "Label_ID", "domain": null }, { "name": "Orig_Data_Set", "type": "esriFieldTypeString", "alias": "Orig_Data_Set", "length": 50, "domain": null }, { "name": "ReceivingWaters", "type": "esriFieldTypeString", "alias": "ReceivingWaters", "length": 50, "domain": { "type": "codedValue", "name": "cvd_Recieving_Waters", "description": "", "codedValues": [ { "name": "Atlantic Ocean", "code": "Atlantic Ocean" }, { "name": "Biddeford Pool", "code": "Biddeford Pool" }, { "name": "Bush Brook", "code": "Bush Brook" }, { "name": "Dungeon Brook", "code": "Dungeon Brook" }, { "name": "Etherington Pond (Peter Pond)", "code": "Etherington Pond" }, { "name": "Lily Pond", "code": "Lily Pond" }, { "name": "Little River", "code": "Little River" }, { "name": "Maddox Pond (Lords Pond)", "code": "Maddox Pond" }, { "name": "Moors Brook", "code": "Moors Brook" }, { "name": "Richardson Brook", "code": "Richardson Brook" }, { "name": "Saco River", "code": "Saco River" }, { "name": "Snake Brook", "code": "Snake Brook" }, { "name": "Swan Pond Brook", "code": "Swan Pond Brook" }, { "name": "Thacher Brook", "code": "Thacher Brook" }, { "name": "West Brook", "code": "West Brook" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Label_ID_txt", "type": "esriFieldTypeString", "alias": "Label_ID_txt", "length": 4, "domain": null }, { "name": "PipeMaterial", "type": "esriFieldTypeString", "alias": "PipeMaterial", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterLineMaterial", "description": "", "codedValues": [ { "name": "Poly Vinyl Chloride", "code": "PVC" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Polyethylene", "code": "Poly" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Vitreous Clay", "code": "VC" }, { "name": "Brick", "code": "Br" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Wood", "code": "Wo" }, { "name": "Other", "code": "Oth" }, { "name": "Unknown", "code": "Unk" }, { "name": "Swale", "code": "SW" }, { "name": "Ditch", "code": "Dit" }, { "name": "Lined", "code": "Lined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Sign_Dsgntn", "type": "esriFieldTypeString", "alias": "Sign_Dsgntn", "length": 10, "domain": null }, { "name": "Northing", "type": "esriFieldTypeDouble", "alias": "Northing", "domain": null }, { "name": "Easting", "type": "esriFieldTypeDouble", "alias": "Easting", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "GRID", "type": "esriFieldTypeString", "alias": "GRID", "length": 10, "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 }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Protected_GUID", "type": "esriFieldTypeGUID", "alias": "Protected_GUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Inspect_Status", "type": "esriFieldTypeString", "alias": "Inspect_Status", "length": 25, "domain": { "type": "codedValue", "name": "outfallinspect", "description": "", "codedValues": [ { "name": "Needs Inspection", "code": "needInsp" }, { "name": "Do Not Inspect", "code": "DoNotInspect" }, { "name": "Inspection Complete", "code": "InspComplete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LastInspDate", "type": "esriFieldTypeDate", "alias": "LastInspDate", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R141_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_141", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_141", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_562_Facility", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S130_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620295429000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "ss Manholes", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102684, "latestWkid": 26848, "xyTolerance": 0.002, "zTolerance": 0.002, "mTolerance": 0.002, "falseX": -15495200, "falseY": -48378500, "xyUnits": 4000, "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": "esriSMS", "style": "esriSMSCircle", "color": [ 140, 118, 64, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7885620.759484913, "ymin": 5379472.896034224, "xmax": -7831164.870737822, "ymax": 5405859.206012066, "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": "AncillaryRole", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "length": 200, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "In-Place - Not Active", "code": "In-Place" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "WaterType", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterType", "description": "", "codedValues": [ { "name": "Combined", "code": "Combined" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 120, "domain": null }, { "name": "Rim", "type": "esriFieldTypeDouble", "alias": "Rim", "domain": null }, { "name": "Invert", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "WallMaterial", "type": "esriFieldTypeString", "alias": "WallMaterial", "length": 25, "domain": null }, { "name": "Sump", "type": "esriFieldTypeSmallInteger", "alias": "Sump", "domain": { "type": "codedValue", "name": "ssDomainBoolean", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Label_ID", "type": "esriFieldTypeSmallInteger", "alias": "Label_ID", "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "length": 25, "domain": null }, { "name": "FIELDNOTE1", "type": "esriFieldTypeString", "alias": "FIELDNOTE1", "length": 25, "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 }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Protected_GUID", "type": "esriFieldTypeGUID", "alias": "Protected_GUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "General_Cond", "type": "esriFieldTypeSmallInteger", "alias": "General Condition", "domain": null }, { "name": "Latest_Inspect_Date", "type": "esriFieldTypeDate", "alias": "Latest Inspection Date", "length": 8, "domain": null }, { "name": "Latest_Inspection_Notes", "type": "esriFieldTypeString", "alias": "Latest Inspection Notes", "length": 1024, "domain": null }, { "name": "Latest_Inspect_Stucture_Cond", "type": "esriFieldTypeString", "alias": "Latest Inspection Structural Condition", "length": 255, "domain": { "type": "codedValue", "name": "Uninspected_Good_Fair_Poor", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Uninspected", "code": "Uninspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comb_Sep", "type": "esriFieldTypeString", "alias": "Combined or Separated", "length": 255, "domain": { "type": "codedValue", "name": "Comb_Sep", "description": "", "codedValues": [ { "name": "Separated", "code": "Separated" }, { "name": "Combined", "code": "Combined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Owwnership", "type": "esriFieldTypeString", "alias": "Owwnership", "length": 255, "domain": { "type": "codedValue", "name": "Ownership", "description": "", "codedValues": [ { "name": "Public", "code": "Public" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Field_Ver", "type": "esriFieldTypeString", "alias": "Field Verified", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspect_Stat", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 255, "domain": { "type": "codedValue", "name": "Inspect_Stat", "description": "", "codedValues": [ { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "No Follow Up Needed", "code": "No Follow Up Needed" }, { "name": "Needs Cleaning", "code": "Needs Cleaning" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Struct_Cond", "type": "esriFieldTypeString", "alias": "Structure Condition", "length": 255, "domain": { "type": "codedValue", "name": "GFP", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Srce_I_I", "type": "esriFieldTypeString", "alias": "Source of I and I", "length": 255, "domain": { "type": "codedValue", "name": "Src_of_I_I", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lst_Edit_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "Lst_Insp_Date", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R140_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_140", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_140", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_561_Facility", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S129_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Structure_Inspection_Data", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7F4ABE4D-3C3C-4769-90EA-0E78747EF534}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620295429000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "ss Catch Basins", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102684, "latestWkid": 26848, "xyTolerance": 0.002, "zTolerance": 0.002, "mTolerance": 0.002, "falseX": -15495200, "falseY": -48378500, "xyUnits": 4000, "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": "esriSMS", "style": "esriSMSCircle", "color": [ 60, 160, 38, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7849840.815049856, "ymin": 5376320.640880453, "xmax": -7830483.960634499, "ymax": 5388229.97498545, "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": "AncillaryRole", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Source", "code": 1 }, { "name": "Sink", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "LocationDescription", "type": "esriFieldTypeString", "alias": "LocationDescription", "length": 200, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "In-Place - Not Active", "code": "In-Place" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "WaterType", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterType", "description": "", "codedValues": [ { "name": "Combined", "code": "Combined" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Rim", "type": "esriFieldTypeDouble", "alias": "Rim", "domain": null }, { "name": "Invert", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "AccessMaterial", "type": "esriFieldTypeString", "alias": "AccessMaterial", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainJunctionMaterial", "description": "", "codedValues": [ { "name": "Steel", "code": "Steel" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Poly Vinyl Chloride", "code": "PVC" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Clay", "code": "Cl" }, { "name": "Wood", "code": "Wo" }, { "name": "Unknown", "code": "Unk" }, { "name": "Other", "code": "Oth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AccesType", "type": "esriFieldTypeString", "alias": "AccesType", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainAccessType", "description": "", "codedValues": [ { "name": "Door", "code": "Door" }, { "name": "Grate", "code": "Grate" }, { "name": "Hand", "code": "Hand" }, { "name": "Lid", "code": "Lid" }, { "name": "Manhole Cover", "code": "Cover" }, { "name": "Other", "code": "Oth" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Label_ID", "type": "esriFieldTypeSmallInteger", "alias": "Label_ID", "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "length": 25, "domain": null }, { "name": "FIELDNOTE1", "type": "esriFieldTypeString", "alias": "FIELDNOTE1", "length": 25, "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 }, { "name": "Combined_Contributer", "type": "esriFieldTypeSmallInteger", "alias": "Combined_Contributer", "domain": { "type": "codedValue", "name": "ssDomainBoolean", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "empties_into_cso", "type": "esriFieldTypeString", "alias": "empties_into_cso", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Protected_GUID", "type": "esriFieldTypeGUID", "alias": "Protected_GUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "General_Cond", "type": "esriFieldTypeSmallInteger", "alias": "General_Cond", "domain": null }, { "name": "sw_cb_insp_status", "type": "esriFieldTypeSmallInteger", "alias": "CB Inspection Status", "domain": { "type": "codedValue", "name": "cb_Insp_status", "description": "", "codedValues": [ { "name": "2021 Not inspected", "code": 1 }, { "name": "2022 Not inspected", "code": 2 }, { "name": "Inspected - Follow up needed", "code": 4 }, { "name": "Cleaned - reinspect in 1 year", "code": 5 }, { "name": "Cleaned - reinspect in 2 years", "code": 6 }, { "name": "Inspected - No follow up needed, inspect in two years", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CleanYear", "type": "esriFieldTypeInteger", "alias": "Year for Next Cleaning", "domain": null }, { "name": "Latest_Inspect_Date", "type": "esriFieldTypeDate", "alias": "Latest Inspection Date", "length": 8, "domain": null }, { "name": "Latest_Inspection_Notes", "type": "esriFieldTypeString", "alias": "Latest Inspection Notes", "length": 1024, "domain": null }, { "name": "Latest_Inspect_Stucture_Cond", "type": "esriFieldTypeString", "alias": "Latest Inspection Structural Condition", "length": 255, "domain": { "type": "codedValue", "name": "Uninspected_Good_Fair_Poor", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Uninspected", "code": "Uninspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 1024, "domain": null }, { "name": "Comb_Sep", "type": "esriFieldTypeString", "alias": "Comb_Sep", "length": 25, "domain": { "type": "codedValue", "name": "Comb_Sep", "description": "", "codedValues": [ { "name": "Separated", "code": "Separated" }, { "name": "Combined", "code": "Combined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Owwnership", "type": "esriFieldTypeString", "alias": "Owwnership", "length": 25, "domain": { "type": "codedValue", "name": "Ownership", "description": "", "codedValues": [ { "name": "Public", "code": "Public" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Field_Ver", "type": "esriFieldTypeString", "alias": "Field_Ver", "length": 5, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspect_Stat", "type": "esriFieldTypeString", "alias": "Inspect_Stat", "length": 50, "domain": { "type": "codedValue", "name": "Inspect_Stat", "description": "", "codedValues": [ { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "No Follow Up Needed", "code": "No Follow Up Needed" }, { "name": "Needs Cleaning", "code": "Needs Cleaning" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Struct_Cond", "type": "esriFieldTypeString", "alias": "Struct_Cond", "length": 10, "domain": { "type": "codedValue", "name": "GFP", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Srce_I_I", "type": "esriFieldTypeString", "alias": "Srce_I_I", "length": 10, "domain": { "type": "codedValue", "name": "Src_of_I_I", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lst_Edit_date", "type": "esriFieldTypeDate", "alias": "Lst_Edit_date", "length": 8, "domain": null }, { "name": "Clean_Date", "type": "esriFieldTypeDate", "alias": "Clean_Date", "length": 8, "domain": null }, { "name": "Clean_By", "type": "esriFieldTypeString", "alias": "Clean_By", "length": 50, "domain": null }, { "name": "Lst_Insp_Date", "type": "esriFieldTypeDate", "alias": "Lst_Insp_Date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R139_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_139", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_139", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_560_Facility", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S128_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Structure_Inspection_Data", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9E58DAD7-068C-474A-AAFE-33F783EBD5FB}" }, { "id": 3, "name": "CB_Storm_Water_Inspection_Data", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF01311F-0FA0-4297-BC53-A23EF0F7D115}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620295429000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "ss Gravity Mains", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102684, "latestWkid": 26848, "xyTolerance": 0.002, "zTolerance": 0.002, "mTolerance": 0.002, "falseX": -15495200, "falseY": -48378500, "xyUnits": 4000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Subtype", "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 130, 130, 130, 255 ], "width": 1 }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "Subtype", "classes": [ { "label": "Collector", "description": "Collector", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 184, 184, 255 ], "width": 1 }, "values": [ [ "1" ] ] }, { "label": "Culvert", "description": "Culvert", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 215, 215, 255 ], "width": 1 }, "values": [ [ "2" ] ] }, { "label": "OpenChannel", "description": "OpenChannel", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 197, 197, 255 ], "width": 1 }, "values": [ [ "3" ] ] }, { "label": "Outfall", "description": "Outfall", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 192, 192, 255 ], "width": 1 }, "values": [ [ "4" ] ] }, { "label": "Overflow", "description": "Overflow", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 207, 207, 255 ], "width": 1 }, "values": [ [ "5" ] ] }, { "label": "Interceptor", "description": "Interceptor", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 179, 179, 255 ], "width": 1 }, "values": [ [ "6" ] ] }, { "label": "Underdrain", "description": "Underdrain", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 204, 204, 255 ], "width": 1 }, "values": [ [ "7" ] ] }, { "label": "Footing Drain", "description": "Footing Drain", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 194, 194, 255 ], "width": 1 }, "values": [ [ "8" ] ] }, { "label": "Lateral", "description": "Lateral", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 212, 212, 255 ], "width": 1 }, "values": [ [ "9" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 184, 184, 255 ], "width": 1 }, "value": "1", "label": "Collector" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 215, 215, 255 ], "width": 1 }, "value": "2", "label": "Culvert" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 197, 197, 255 ], "width": 1 }, "value": "3", "label": "OpenChannel" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 192, 192, 255 ], "width": 1 }, "value": "4", "label": "Outfall" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 207, 207, 255 ], "width": 1 }, "value": "5", "label": "Overflow" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 179, 179, 255 ], "width": 1 }, "value": "6", "label": "Interceptor" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 204, 204, 255 ], "width": 1 }, "value": "7", "label": "Underdrain" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 194, 194, 255 ], "width": 1 }, "value": "8", "label": "Footing Drain" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 252, 212, 212, 255 ], "width": 1 }, "value": "9", "label": "Lateral" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 202, 202, 255 ], "toColor": [ 252, 202, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 179, 255 ], "toColor": [ 252, 179, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 215, 255 ], "toColor": [ 252, 215, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 189, 189, 255 ], "toColor": [ 252, 189, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 187, 187, 255 ], "toColor": [ 252, 187, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 207, 207, 255 ], "toColor": [ 252, 207, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 194, 194, 255 ], "toColor": [ 252, 194, 194, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 197, 197, 255 ], "toColor": [ 252, 197, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 210, 210, 255 ], "toColor": [ 250, 210, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 202, 202, 255 ], "toColor": [ 250, 202, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 197, 197, 255 ], "toColor": [ 250, 197, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 180, 180, 255 ], "toColor": [ 250, 180, 180, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 210, 255 ], "toColor": [ 252, 210, 210, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -7885882.982542798, "ymin": 5378383.376993705, "xmax": -7831156.815673824, "ymax": 5406032.971089155, "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": "Enabled", "typeIdField": "Subtype", "subtypeFieldName": "Subtype", "subtypeField": "Subtype", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "In-Place - Not Active", "code": "In-Place" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "WaterType", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterType", "description": "", "codedValues": [ { "name": "Combined", "code": "Combined" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "domain": { "type": "codedValue", "name": "ssDomainWaterLineMaterial", "description": "", "codedValues": [ { "name": "Poly Vinyl Chloride", "code": "PVC" }, { "name": "Asbestos Concrete", "code": "AC" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Polyethylene", "code": "Poly" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Vitreous Clay", "code": "VC" }, { "name": "Brick", "code": "Br" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Wood", "code": "Wo" }, { "name": "Other", "code": "Oth" }, { "name": "Unknown", "code": "Unk" }, { "name": "Swale", "code": "SW" }, { "name": "Ditch", "code": "Dit" }, { "name": "Lined", "code": "Lined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "length": 80, "domain": null }, { "name": "PlanNum", "type": "esriFieldTypeString", "alias": "PlanNum", "length": 10, "domain": null }, { "name": "UpstreamInvert", "type": "esriFieldTypeDouble", "alias": "UpstreamInvert", "domain": null }, { "name": "DownstreamInvert", "type": "esriFieldTypeDouble", "alias": "DownstreamInvert", "domain": null }, { "name": "Slope", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "NominalDiameter", "type": "esriFieldTypeInteger", "alias": "NominalDiameter", "domain": { "type": "codedValue", "name": "ssDomainMainDistributionDiameter", "description": "", "codedValues": [ { "name": "1 inch", "code": 1 }, { "name": "2 inch", "code": 2 }, { "name": "4 inch", "code": 4 }, { "name": "6 inch", "code": 6 }, { "name": "8 inch", "code": 8 }, { "name": "10 inch", "code": 10 }, { "name": "12 inch", "code": 12 }, { "name": "14 inch", "code": 14 }, { "name": "15 inch", "code": 15 }, { "name": "16 inch", "code": 16 }, { "name": "18 inch", "code": 18 }, { "name": "20 inch", "code": 20 }, { "name": "24 inch", "code": 24 }, { "name": "27 inch", "code": 27 }, { "name": "30 inch", "code": 30 }, { "name": "36 inch", "code": 36 }, { "name": "42 inch", "code": 42 }, { "name": "48 inch", "code": 48 }, { "name": "54 inch", "code": 54 }, { "name": "60 inch", "code": 60 }, { "name": "72 inch", "code": 72 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "21 inch", "code": 21 }, { "name": "22 inch", "code": 22 }, { "name": "3 inch", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Measurement1", "type": "esriFieldTypeInteger", "alias": "Measurement1", "domain": { "type": "codedValue", "name": "ssDomainMainDistributionDiameter", "description": "", "codedValues": [ { "name": "1 inch", "code": 1 }, { "name": "2 inch", "code": 2 }, { "name": "4 inch", "code": 4 }, { "name": "6 inch", "code": 6 }, { "name": "8 inch", "code": 8 }, { "name": "10 inch", "code": 10 }, { "name": "12 inch", "code": 12 }, { "name": "14 inch", "code": 14 }, { "name": "15 inch", "code": 15 }, { "name": "16 inch", "code": 16 }, { "name": "18 inch", "code": 18 }, { "name": "20 inch", "code": 20 }, { "name": "24 inch", "code": 24 }, { "name": "27 inch", "code": 27 }, { "name": "30 inch", "code": 30 }, { "name": "36 inch", "code": 36 }, { "name": "42 inch", "code": 42 }, { "name": "48 inch", "code": 48 }, { "name": "54 inch", "code": 54 }, { "name": "60 inch", "code": 60 }, { "name": "72 inch", "code": 72 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "21 inch", "code": 21 }, { "name": "22 inch", "code": 22 }, { "name": "3 inch", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Measurement2", "type": "esriFieldTypeInteger", "alias": "Measurement2", "domain": { "type": "codedValue", "name": "ssDomainMainDistributionDiameter", "description": "", "codedValues": [ { "name": "1 inch", "code": 1 }, { "name": "2 inch", "code": 2 }, { "name": "4 inch", "code": 4 }, { "name": "6 inch", "code": 6 }, { "name": "8 inch", "code": 8 }, { "name": "10 inch", "code": 10 }, { "name": "12 inch", "code": 12 }, { "name": "14 inch", "code": 14 }, { "name": "15 inch", "code": 15 }, { "name": "16 inch", "code": 16 }, { "name": "18 inch", "code": 18 }, { "name": "20 inch", "code": 20 }, { "name": "24 inch", "code": 24 }, { "name": "27 inch", "code": 27 }, { "name": "30 inch", "code": 30 }, { "name": "36 inch", "code": 36 }, { "name": "42 inch", "code": 42 }, { "name": "48 inch", "code": 48 }, { "name": "54 inch", "code": 54 }, { "name": "60 inch", "code": 60 }, { "name": "72 inch", "code": 72 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "21 inch", "code": 21 }, { "name": "22 inch", "code": 22 }, { "name": "3 inch", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FromJct", "type": "esriFieldTypeString", "alias": "FromJct", "length": 50, "domain": null }, { "name": "ToJct", "type": "esriFieldTypeString", "alias": "ToJct", "length": 50, "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 }, { "name": "Nominal_Length", "type": "esriFieldTypeDouble", "alias": "Map Length", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Protected_GUID", "type": "esriFieldTypeGUID", "alias": "Protected_GUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Year_Scanned", "type": "esriFieldTypeSmallInteger", "alias": "Year Scanned", "domain": { "type": "range", "name": "SCN_Years_Range", "description": "", "range": [ 2010, 2030 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Scan_Status", "type": "esriFieldTypeString", "alias": "Scan Status", "length": 35, "domain": { "type": "codedValue", "name": "SCN_Scan_Status", "description": "", "codedValues": [ { "name": "Not Scanned", "code": "Not Scanned" }, { "name": "Scanned \u2013 No follow up needed", "code": "Scanned \u2013 No follow up needed" }, { "name": "Scanned \u2013 Follow up needed", "code": "Scanned \u2013 Follow up needed" }, { "name": "Could not scan", "code": "Could not scan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Latest_Inspect_Date", "type": "esriFieldTypeDate", "alias": "Latest Inspection Date", "length": 8, "domain": null }, { "name": "Latest_Inspection_Notes", "type": "esriFieldTypeString", "alias": "Latest Inspection Notes", "length": 1024, "domain": null }, { "name": "Latest_Inspect_Stucture_Cond", "type": "esriFieldTypeString", "alias": "Latest Inspection Structural Condition", "length": 255, "domain": { "type": "codedValue", "name": "Uninspected_Good_Fair_Poor", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Uninspected", "code": "Uninspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "Owwnership", "type": "esriFieldTypeString", "alias": "Owwnership", "length": 255, "domain": { "type": "codedValue", "name": "Ownership", "description": "", "codedValues": [ { "name": "Public", "code": "Public" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Field_Ver", "type": "esriFieldTypeString", "alias": "Field Verified", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspect_Stat", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 255, "domain": { "type": "codedValue", "name": "Inspect_Stat", "description": "", "codedValues": [ { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "No Follow Up Needed", "code": "No Follow Up Needed" }, { "name": "Needs Cleaning", "code": "Needs Cleaning" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Struct_Cond", "type": "esriFieldTypeString", "alias": "Structure Condition", "length": 255, "domain": { "type": "codedValue", "name": "GFP", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Srce_I_I", "type": "esriFieldTypeString", "alias": "Source of I and I", "length": 255, "domain": { "type": "codedValue", "name": "Src_of_I_I", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lst_Edit_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "Clean_Date", "type": "esriFieldTypeDate", "alias": "Cleaning Date", "length": 8, "domain": null }, { "name": "Clean_By", "type": "esriFieldTypeString", "alias": "Cleaned By", "length": 255, "domain": null }, { "name": "Lst_Insp_Date", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "Last_Scan_Date", "type": "esriFieldTypeDate", "alias": "Last_Scan_Date", "length": 8, "domain": null }, { "name": "Intruding_laterals", "type": "esriFieldTypeString", "alias": "Intruding_laterals", "length": 25, "domain": { "type": "codedValue", "name": "Src_of_I_I", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Root_Issues", "type": "esriFieldTypeString", "alias": "Root_Issues", "length": 25, "domain": { "type": "codedValue", "name": "Src_of_I_I", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleaning_Notes", "type": "esriFieldTypeString", "alias": "Cleaning_Notes", "length": 2000, "domain": null }, { "name": "Scan_Results", "type": "esriFieldTypeString", "alias": "Scan_Results", "length": 25, "domain": { "type": "codedValue", "name": "Scan_Result", "description": "", "codedValues": [ { "name": "Not Scanned", "code": "Not Scanned" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Could Not Scan", "code": "Could Not Scan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 2000, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R146_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_146", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_146", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_567_Protecte", "fields": "Protected_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_567_Facility", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S135_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 6, "name": "Interceptor" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 1, "name": "Collector" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 2, "name": "Culvert" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 3, "name": "OpenChannel" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 5, "name": "Overflow" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 4, "name": "Outfall" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 7, "name": "Underdrain" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 8, "name": "Footing Drain" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "id": 9, "name": "Lateral" } ], "subtypes": [ { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": 6, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 6, "name": "Interceptor" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": 1, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 1, "name": "Collector" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": 2, "FacilityID": null, "Status": "Active", "WaterType": "Storm", "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 2, "name": "Culvert" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": 3, "FacilityID": null, "Status": "Active", "WaterType": "Storm", "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 3, "name": "OpenChannel" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": 5, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 5, "name": "Overflow" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": 4, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 4, "name": "Outfall" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": null, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 7, "name": "Underdrain" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": null, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 8, "name": "Footing Drain" }, { "domains": { "Enabled": {"type": "inherited"}, "Status": {"type": "inherited"}, "WaterType": {"type": "inherited"}, "Material": {"type": "inherited"}, "NominalDiameter": {"type": "inherited"}, "Measurement1": {"type": "inherited"}, "Measurement2": {"type": "inherited"} }, "defaultValues": { "Enabled": 1, "Subtype": null, "FacilityID": null, "Status": "Active", "WaterType": null, "Material": null, "InstallDate": null, "Street": null, "PlanNum": null, "UpstreamInvert": null, "DownstreamInvert": null, "Slope": null, "NominalDiameter": null, "Measurement1": null, "Measurement2": null, "FromJct": null, "ToJct": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Nominal_Length": null, "Protected_GUID": null, "GlobalID": null, "Year_Scanned": null, "Scan_Status": null, "Latest_Inspect_Date": null, "Latest_Inspection_Notes": null, "Latest_Inspect_Stucture_Cond": null, "Owwnership": null, "Field_Ver": null, "Inspect_Stat": null, "Struct_Cond": null, "Srce_I_I": null, "Lst_Edit_date": null, "Clean_Date": null, "Clean_By": null, "Lst_Insp_Date": null, "Last_Scan_Date": null, "Intruding_laterals": null, "Root_Issues": null, "Cleaning_Notes": null, "Scan_Results": null, "Comment": null }, "code": 9, "name": "Lateral" } ], "relationships": [ { "id": 5, "name": "Sewer_Inspections_Scan_Data", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A759275-9F60-4F68-AD18-7EBD80B526A8}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620295429000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "CB Storm Water Inspection Data", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityID", "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": "Date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Structure Condition", "length": 25, "domain": { "type": "codedValue", "name": "swCondition", "description": "Storm Water Inspection Structure Condition", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Needs Attention", "code": "Needs Attention" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Flow", "type": "esriFieldTypeString", "alias": "Flow Amount", "length": 25, "domain": { "type": "codedValue", "name": "swFlow", "description": "Storm Water Inspection Structure Flow", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Trickle", "code": "Trickle" }, { "name": "Steady", "code": "Steady" }, { "name": "More than ¼ Full", "code": "More than ¼ Full" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Excessive_Sediment", "type": "esriFieldTypeSmallInteger", "alias": "Excessive Sediment", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pollution", "type": "esriFieldTypeSmallInteger", "alias": "Pollution", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Oil_Sheen", "type": "esriFieldTypeSmallInteger", "alias": "Oil Sheen", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discoloration", "type": "esriFieldTypeSmallInteger", "alias": "Discoloration", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Foam_Soap", "type": "esriFieldTypeSmallInteger", "alias": "Foam or Soap", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AlgaGrowth", "type": "esriFieldTypeSmallInteger", "alias": "Algal Growth", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sewage", "type": "esriFieldTypeSmallInteger", "alias": "Sewage", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Odor", "type": "esriFieldTypeSmallInteger", "alias": "Odor", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Yard_Waste", "type": "esriFieldTypeSmallInteger", "alias": "Yard Waste", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pet_Waste", "type": "esriFieldTypeSmallInteger", "alias": "Pet Waste", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cig_Butts", "type": "esriFieldTypeSmallInteger", "alias": "Cigarette Butts", "domain": { "type": "codedValue", "name": "CB_insp_cig_butts", "description": "Ciggarette count in CB 0 = None, 1 = 1-10 Butts, 2 = Over 10 Butts", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Less than 10 Butts", "code": -1 }, { "name": "10 or More Butts", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Accessible", "type": "esriFieldTypeString", "alias": "Accessable", "length": 25, "domain": { "type": "codedValue", "name": "swAccessible", "description": "Storm Water Inspection Structure accessability", "codedValues": [ { "name": "Accessible", "code": "Accessible" }, { "name": "Paved Over", "code": "Paved Over" }, { "name": "Unopenable", "code": "Unopenable" }, { "name": "Buried", "code": "Buried" }, { "name": "Not Found", "code": "Not Found" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleaned", "type": "esriFieldTypeSmallInteger", "alias": "Cleaned", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Clean_Date", "type": "esriFieldTypeDate", "alias": "Date Cleaned", "length": 8, "domain": null }, { "name": "Follow_Up", "type": "esriFieldTypeSmallInteger", "alias": "Follow Up", "domain": { "type": "codedValue", "name": "CB_insp_rev_YN", "description": "Stored values are reversed Yes = -1 and No = 0", "codedValues": [ { "name": "Yes", "code": -1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1024, "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 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CleanedBy", "type": "esriFieldTypeString", "alias": "Cleaned By", "length": 25, "domain": null }, { "name": "Sediment_Depth", "type": "esriFieldTypeSmallInteger", "alias": "Sediment Depth", "domain": { "type": "range", "name": "Range_0-48", "description": "", "range": [ 0, 48 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sw_cb_insp_status", "type": "esriFieldTypeSmallInteger", "alias": "CB Inspection Status", "domain": { "type": "codedValue", "name": "cb_Insp_status", "description": "", "codedValues": [ { "name": "2021 Not inspected", "code": 1 }, { "name": "2022 Not inspected", "code": 2 }, { "name": "Inspected - Follow up needed", "code": 4 }, { "name": "Cleaned - reinspect in 1 year", "code": 5 }, { "name": "Cleaned - reinspect in 2 years", "code": 6 }, { "name": "Inspected - No follow up needed, inspect in two years", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CleanYear", "type": "esriFieldTypeInteger", "alias": "Year for Next Cleaning", "domain": null } ], "indexes": [ { "name": "R855_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_855", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_855", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4795_Facilit", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "ssCatchBasin", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF01311F-0FA0-4297-BC53-A23EF0F7D115}" }, { "id": 1, "name": "DBO.Add_a_Catch_Basin", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2EF0CAA9-3DCE-4DF5-AA2C-30162BB507E4}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1621869367000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "CB Storm Water Inspection Data ATACHMENTS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R856_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_856", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4796_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_856", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1621869371000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Outfall Dry Weather Inspection Data", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspecctName", "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": "DateTime", "type": "esriFieldTypeDate", "alias": "Enter today's date and time", "length": 8, "domain": null }, { "name": "InspecctName", "type": "esriFieldTypeString", "alias": "Inspector(s)", "length": 255, "domain": null }, { "name": "SkyCond", "type": "esriFieldTypeString", "alias": "What are the current sky conditions?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_SkyCond", "description": "", "codedValues": [ { "name": "Clear (<30% Cloud)", "code": "Clear" }, { "name": "Partly Sunny (30-70% Cloud)", "code": "PartlySunny" }, { "name": "Mostly Cloudy (>70% Cloud)", "code": "MostlyCloudy" }, { "name": "Overcast (100% Cloud)", "code": "Overcast" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurrTemp", "type": "esriFieldTypeInteger", "alias": "What is the current temperature (F)", "domain": null }, { "name": "WindyCalm", "type": "esriFieldTypeString", "alias": "Is it windy or calm?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_WindyCalm", "description": "", "codedValues": [ { "name": "Calm", "code": "calm" }, { "name": "Windy", "code": "windy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WindSpeed", "type": "esriFieldTypeInteger", "alias": "Wind Speed (MPH)", "domain": null }, { "name": "WindDir", "type": "esriFieldTypeString", "alias": "Wind Direction", "length": 255, "domain": { "type": "codedValue", "name": "cvd_WindDir", "description": "", "codedValues": [ { "name": "North", "code": "n" }, { "name": "Northeast", "code": "ne" }, { "name": "East", "code": "e" }, { "name": "Southeast", "code": "se" }, { "name": "South", "code": "s" }, { "name": "Southwest", "code": "sw" }, { "name": "West", "code": "w" }, { "name": "Northwest", "code": "nw" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RainYN", "type": "esriFieldTypeString", "alias": "Has it rain in last 3 days?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_RainYN", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RainAmt", "type": "esriFieldTypeDouble", "alias": "If yes, how much rain? (Inches 0.00)", "domain": null }, { "name": "PipeFlow", "type": "esriFieldTypeString", "alias": "Describe the current pipe flow", "length": 255, "domain": { "type": "codedValue", "name": "cvd_PipeFlow", "description": "", "codedValues": [ { "name": "None", "code": "none" }, { "name": "Trickle", "code": "trickle" }, { "name": "Steady", "code": "steady" }, { "name": "¼ pipe flow or more", "code": "quarterpipeplus" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SeepageFlow", "type": "esriFieldTypeString", "alias": "Describe the seepage flow", "length": 255, "domain": { "type": "codedValue", "name": "cvd_SeepageFlow", "description": "", "codedValues": [ { "name": "None", "code": "none" }, { "name": "Trickle", "code": "trickle" }, { "name": "Steady", "code": "steady" }, { "name": "¼ pipe flow or more", "code": "quarterpipeplus" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ColorFlow", "type": "esriFieldTypeString", "alias": "What is the color? (if flow is present)", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ColorFlow", "description": "", "codedValues": [ { "name": "Clear", "code": "clear" }, { "name": "White", "code": "white" }, { "name": "Grey", "code": "grey" }, { "name": "Black", "code": "black" }, { "name": "Orange", "code": "orange" }, { "name": "Light Brown", "code": "ltbrown" }, { "name": "Brown", "code": "brown" }, { "name": "Dark Brown", "code": "dkbrown" }, { "name": "Yellow", "code": "yellow" }, { "name": "Red", "code": "red" }, { "name": "Red Brown", "code": "redbrown" }, { "name": "Green", "code": "green" }, { "name": "Blue", "code": "blue" }, { "name": "Purple", "code": "purple" }, { "name": "Other (specify)", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "othercolor", "type": "esriFieldTypeString", "alias": "Specify other color", "length": 255, "domain": null }, { "name": "OutfallID", "type": "esriFieldTypeString", "alias": "Outfall ID", "length": 255, "domain": null }, { "name": "signDesg", "type": "esriFieldTypeString", "alias": "Sign Designation", "length": 255, "domain": null }, { "name": "outfallLocation", "type": "esriFieldTypeString", "alias": "Outfall Location", "length": 255, "domain": null }, { "name": "receivingwaters", "type": "esriFieldTypeString", "alias": "Receiving Waters", "length": 255, "domain": null }, { "name": "pipesize", "type": "esriFieldTypeInteger", "alias": "Pipe Size", "domain": null }, { "name": "pipetype", "type": "esriFieldTypeString", "alias": "Pipe Type", "length": 255, "domain": null }, { "name": "DebrisObs", "type": "esriFieldTypeString", "alias": "If there is obvious debris or pollution, score all that are applicable in the questions below", "length": 255, "domain": null }, { "name": "DebNone", "type": "esriFieldTypeString", "alias": "DebNone", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dn", "type": "esriFieldTypeString", "alias": "dn", "length": 255, "domain": null }, { "name": "DebFoam", "type": "esriFieldTypeString", "alias": "Is foam present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_foam", "description": "", "codedValues": [ { "name": "0 - There is no foam present", "code": "0 - There is no foam present" }, { "name": "3 - There is foam present", "code": "3 - There is foam present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dfm", "type": "esriFieldTypeString", "alias": "dfm", "length": 255, "domain": null }, { "name": "DebFloat", "type": "esriFieldTypeString", "alias": "Is floating green scum present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_scum", "description": "", "codedValues": [ { "name": "0 - There is no floating green scum present", "code": "0 - There is no floating green scum present" }, { "name": "3 - There is floating green scum present", "code": "3 - There is floating green scum present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dfl", "type": "esriFieldTypeString", "alias": "dfl", "length": 255, "domain": null }, { "name": "DebOil", "type": "esriFieldTypeString", "alias": "Is there is oil or a film present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_oil_film", "description": "", "codedValues": [ { "name": "0 - There is no oil or film present", "code": "0 - There is no oil or film present" }, { "name": "9 - There is oil or film present", "code": "9 - There is oil or film present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "doil", "type": "esriFieldTypeString", "alias": "doil", "length": 255, "domain": null }, { "name": "DebVeg", "type": "esriFieldTypeString", "alias": "Is a vegitative mat present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_veg_mat", "description": "", "codedValues": [ { "name": "0 - There is no vegitative mat present", "code": "0 - There is no vegitative mat present" }, { "name": "9 - There is a vegitative mat present", "code": "9 - There is a vegitative mat present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dv", "type": "esriFieldTypeString", "alias": "dv", "length": 255, "domain": null }, { "name": "DebSew", "type": "esriFieldTypeString", "alias": "Is there sewage or septic present", "length": 255, "domain": { "type": "codedValue", "name": "cvd_sew_sep", "description": "", "codedValues": [ { "name": "0 - There is no sewage or septic present", "code": "0 - There is no sewage or septic present" }, { "name": "10 - There is sewage or septic present", "code": "10 - There is sewage or septic present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ds", "type": "esriFieldTypeString", "alias": "ds", "length": 255, "domain": null }, { "name": "DebrisScore", "type": "esriFieldTypeInteger", "alias": "Debris Score - add the last five values", "domain": null }, { "name": "Odor", "type": "esriFieldTypeString", "alias": "Odor Score - Select one", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Odor", "description": "", "codedValues": [ { "name": "0 - None / Natural", "code": "0 - None / Natural" }, { "name": "5 - Musty", "code": "5 - Musty" }, { "name": "10 - Sewage / Septic", "code": "10 - Sewage / Septic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OdorScore", "type": "esriFieldTypeInteger", "alias": "Odor Score - Select one", "domain": null }, { "name": "Clarity", "type": "esriFieldTypeString", "alias": "Clarity Score - Select one", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Clarity", "description": "", "codedValues": [ { "name": "0 - Clear", "code": "0 - Clear" }, { "name": "5 - Cloudy", "code": "5 - Cloudy" }, { "name": "10 - Opaque", "code": "10 - Opaque" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ClarityScore", "type": "esriFieldTypeInteger", "alias": "Clarity Score", "domain": null }, { "name": "TotalScore", "type": "esriFieldTypeInteger", "alias": "Total Score - add the debris, odor and clarity scores", "domain": null }, { "name": "SedimentLevel", "type": "esriFieldTypeString", "alias": "What Best describes the sediment level?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_SedimentLevel", "description": "", "codedValues": [ { "name": "Open", "code": "open" }, { "name": "¼ Full", "code": "quarter" }, { "name": "½ Full", "code": "half" }, { "name": "¾ Full", "code": "3quarter" }, { "name": "Plugged", "code": "plugged" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureCond", "type": "esriFieldTypeString", "alias": "How would you describe the structure's condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_StructureCond", "description": "", "codedValues": [ { "name": "Excellent", "code": "excellent" }, { "name": "Good", "code": "good" }, { "name": "Fair", "code": "fair" }, { "name": "Poor", "code": "poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TrashLitter", "type": "esriFieldTypeString", "alias": "Is there trash or litter present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_TrashLitter", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "YardWaste", "type": "esriFieldTypeString", "alias": "Is yard waste present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_YardWaste", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GenComments", "type": "esriFieldTypeString", "alias": "Comments?", "length": 255, "domain": null }, { "name": "PotSourceActions", "type": "esriFieldTypeString", "alias": "Have you located any potential sources and describe any actions you have taken?", "length": 255, "domain": null }, { "name": "followup", "type": "esriFieldTypeString", "alias": "Is follow-up reguired?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_followup", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sig", "type": "esriFieldTypeString", "alias": "Initial", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "latlong", "type": "esriFieldTypeString", "alias": "Latitude and Longitude (Decimal Degrees)", "length": 255, "domain": null }, { "name": "New_outfall", "type": "esriFieldTypeString", "alias": "Outfall Details", "length": 255, "domain": null }, { "name": "new_old", "type": "esriFieldTypeString", "alias": "new_old", "length": 255, "domain": null }, { "name": "OutfallID_New", "type": "esriFieldTypeString", "alias": "Outfall ID", "length": 255, "domain": null }, { "name": "latty", "type": "esriFieldTypeString", "alias": "latty", "length": 255, "domain": null }, { "name": "longy", "type": "esriFieldTypeString", "alias": "longy", "length": 255, "domain": null }, { "name": "latlong_new", "type": "esriFieldTypeString", "alias": "Latitude and Longitude", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null } ], "indexes": [ { "name": "R878_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_878", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_878", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4855_Facilit", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1621869164000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Outfall Dry Weather Inspection Data ATTACHMENTS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R879_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_879", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4856_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_879", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1621869168000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Sewer Inspections Scan Data", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Inspection_Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 255, "domain": null }, { "name": "Scan_Score", "type": "esriFieldTypeSmallInteger", "alias": "Scan Score", "domain": { "type": "range", "name": "ScanScale", "description": "0-10 Rating for Pipe Scanning", "range": [ 0, 10 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "FromJct", "type": "esriFieldTypeString", "alias": "FromJCT", "length": 50, "domain": null }, { "name": "ToJct", "type": "esriFieldTypeString", "alias": "ToJct", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Scan_Condition", "type": "esriFieldTypeString", "alias": "Scan Condition", "length": 10, "domain": { "type": "codedValue", "name": "Uninspected_Good_Fair_Poor", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Uninspected", "code": "Uninspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Needs_Cleaning", "type": "esriFieldTypeSmallInteger", "alias": "Needs Cleaning", "domain": { "type": "codedValue", "name": "Yes_No_Short", "description": "Yes/no stored as 0 or -1", "codedValues": [ { "name": "Yes", "code": 0 }, { "name": "No", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cleaning_Date", "type": "esriFieldTypeDate", "alias": "Cleaning Date", "length": 8, "domain": null }, { "name": "Cleaned_By", "type": "esriFieldTypeString", "alias": "Cleaned_By", "length": 30, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1024, "domain": null }, { "name": "cln_insp", "type": "esriFieldTypeString", "alias": "Inspected/Cleaned", "length": 15, "domain": { "type": "codedValue", "name": "CleanInspect", "description": "Did you clean or inspect", "codedValues": [ { "name": "Cleaned", "code": "Cleaned" }, { "name": "Inspected", "code": "Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R795_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2731_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_795", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_795", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2731_Facilit", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "ssGravityMain", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A759275-9F60-4F68-AD18-7EBD80B526A8}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620295429000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Sewer Inspections Scan Data ATTACHMENTS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R852_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_852", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_4792_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_852", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620545311000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Structure Inspection Data", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "USER_", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "USER_", "type": "esriFieldTypeString", "alias": "User", "length": 50, "domain": null }, { "name": "STUCTURE_ID", "type": "esriFieldTypeString", "alias": "Structure ID", "length": 25, "domain": null }, { "name": "PHYSICAL_LOCATION", "type": "esriFieldTypeString", "alias": "Physical Location", "length": 50, "domain": null }, { "name": "COVER_TYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 50, "domain": null }, { "name": "COVER_CONDITION", "type": "esriFieldTypeInteger", "alias": "Cover Condition", "domain": null }, { "name": "FRAME_HEIGHT", "type": "esriFieldTypeInteger", "alias": "Frame Height", "domain": null }, { "name": "FRAME_SHAPE", "type": "esriFieldTypeString", "alias": "Frame Shape", "length": 50, "domain": null }, { "name": "FRAME_CONDITION", "type": "esriFieldTypeInteger", "alias": "Frame Condition", "domain": null }, { "name": "RISER_RINGS", "type": "esriFieldTypeInteger", "alias": "# of Concrete Riser Rings", "domain": null }, { "name": "BRICK_RISERS", "type": "esriFieldTypeInteger", "alias": "# of Brick Risers", "domain": null }, { "name": "CONE_MATERIAL", "type": "esriFieldTypeString", "alias": "Cone Material", "length": 50, "domain": null }, { "name": "CONE_CONDITION", "type": "esriFieldTypeInteger", "alias": "Cone Condition", "domain": null }, { "name": "STUCTURE_DIAMETER", "type": "esriFieldTypeInteger", "alias": "Structure Diameter", "domain": null }, { "name": "BARREL_MATERIAL", "type": "esriFieldTypeString", "alias": "Barrel Material", "length": 50, "domain": null }, { "name": "BARREL_CONDITION", "type": "esriFieldTypeInteger", "alias": "Barrel Condition", "domain": null }, { "name": "BASE_MATERIAL", "type": "esriFieldTypeString", "alias": "Base Material", "length": 50, "domain": null }, { "name": "BASE_CONDITION", "type": "esriFieldTypeInteger", "alias": "Base Condition", "domain": null }, { "name": "INVERT_MATERIAL", "type": "esriFieldTypeString", "alias": "Invert Material", "length": 50, "domain": null }, { "name": "INVERT_CONDITION", "type": "esriFieldTypeInteger", "alias": "Invert Condition", "domain": null }, { "name": "DEPTH_INVERT", "type": "esriFieldTypeDouble", "alias": "Invert Depth", "domain": null }, { "name": "INLET_NUMBER", "type": "esriFieldTypeInteger", "alias": "Number Inlets", "domain": null }, { "name": "INLET_1_SIZE", "type": "esriFieldTypeDouble", "alias": "Inlet 1 Size", "domain": null }, { "name": "INLET_1_MATERIAL", "type": "esriFieldTypeString", "alias": "Inlet 1 Material", "length": 50, "domain": null }, { "name": "INLET_2_SIZE", "type": "esriFieldTypeDouble", "alias": "Inlet 2 Size", "domain": null }, { "name": "INLET_2_MATERIAL", "type": "esriFieldTypeString", "alias": "Inlet 2 Material", "length": 50, "domain": null }, { "name": "INLET_3_SIZE", "type": "esriFieldTypeDouble", "alias": "Inlet 3 Size", "domain": null }, { "name": "INLET_3_MATERIAL", "type": "esriFieldTypeString", "alias": "Inlet 3 Material", "length": 50, "domain": null }, { "name": "INLET_4_SIZE", "type": "esriFieldTypeDouble", "alias": "Inlet 4 Size", "domain": null }, { "name": "INLET_4_MATERIAL", "type": "esriFieldTypeString", "alias": "Inlet 4 Material", "length": 50, "domain": null }, { "name": "OUTLET_SIZE", "type": "esriFieldTypeDouble", "alias": "Outlet Size", "domain": null }, { "name": "OUTLET_MATERIAL", "type": "esriFieldTypeString", "alias": "Outlet Material", "length": 50, "domain": null }, { "name": "FLOW_DIRECTION", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 50, "domain": null }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active?", "length": 50, "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "INLET_1_Depth", "type": "esriFieldTypeDouble", "alias": "Inlet 1 Depth", "domain": null }, { "name": "INLET_2_Depth", "type": "esriFieldTypeDouble", "alias": "Inlet 2 Depth", "domain": null }, { "name": "INLET_3_Depth", "type": "esriFieldTypeDouble", "alias": "Inlet 3 Depth", "domain": null }, { "name": "INLET_4_Depth", "type": "esriFieldTypeDouble", "alias": "Inlet 4 Depth", "domain": null }, { "name": "Outlet_Depth", "type": "esriFieldTypeDouble", "alias": "Outlet Depth", "domain": null }, { "name": "Complete", "type": "esriFieldTypeString", "alias": "Complete", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 50, "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": 50, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "General_Cond", "type": "esriFieldTypeInteger", "alias": "General Condition", "domain": null }, { "name": "MH_Type", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "Out_2_size", "type": "esriFieldTypeDouble", "alias": "Outlet 2 Size", "domain": null }, { "name": "Out_2_Mat", "type": "esriFieldTypeString", "alias": "Outlet 2 Material", "length": 50, "domain": null }, { "name": "Out_2_deptth", "type": "esriFieldTypeDouble", "alias": "Outlet 2 Depth", "domain": null }, { "name": "Out_2_Overflow", "type": "esriFieldTypeString", "alias": "Outlet 2 Overflow", "length": 50, "domain": null }, { "name": "In_1_drop", "type": "esriFieldTypeString", "alias": "Inlet 1 Drop", "length": 50, "domain": null }, { "name": "in_2_drop", "type": "esriFieldTypeString", "alias": "Inlet 2 Drop", "length": 50, "domain": null }, { "name": "in_3_drop", "type": "esriFieldTypeString", "alias": "Inlet 3 Drop", "length": 50, "domain": null }, { "name": "in_4_drop", "type": "esriFieldTypeString", "alias": "Inlet 4 Drop", "length": 50, "domain": null }, { "name": "Sump", "type": "esriFieldTypeString", "alias": "Sump", "length": 50, "domain": null }, { "name": "WaterType", "type": "esriFieldTypeString", "alias": "Water Type", "length": 50, "domain": null }, { "name": "in_5_Size", "type": "esriFieldTypeDouble", "alias": "Inlet 5 Size", "domain": null }, { "name": "In_5_Depth", "type": "esriFieldTypeDouble", "alias": "Inlet 5 Depth", "domain": null }, { "name": "In_5_Drop", "type": "esriFieldTypeString", "alias": "Inlet 5 Drop", "length": 50, "domain": null }, { "name": "in_6_size", "type": "esriFieldTypeDouble", "alias": "Inlet 6 Size", "domain": null }, { "name": "In_6_mat", "type": "esriFieldTypeString", "alias": "Inlet 6 Material", "length": 50, "domain": null }, { "name": "In_6_depth", "type": "esriFieldTypeDouble", "alias": "Inlet 6 Depth", "domain": null }, { "name": "In_6_drop", "type": "esriFieldTypeString", "alias": "Inlet 6 Drop", "length": 50, "domain": null }, { "name": "in_7_size", "type": "esriFieldTypeDouble", "alias": "Inlet 7 Size", "domain": null }, { "name": "in_7_mat", "type": "esriFieldTypeString", "alias": "Inlet 7 Material", "length": 50, "domain": null }, { "name": "In_7_depth", "type": "esriFieldTypeDouble", "alias": "Inlet 7 Depth", "domain": null }, { "name": "In_7_drop", "type": "esriFieldTypeString", "alias": "Inlet 7 Drop", "length": 50, "domain": null }, { "name": "in_5_mat", "type": "esriFieldTypeString", "alias": "Inlet 5 Material", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "facility_ID", "type": "esriFieldTypeString", "alias": "facility_ID", "length": 25, "domain": null }, { "name": "OverallCondition", "type": "esriFieldTypeString", "alias": "OverallCondition", "length": 10, "domain": null } ], "indexes": [ { "name": "R864_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_864", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_864", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4802_STUCTUR", "fields": "STUCTURE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_4802_facilit", "fields": "facility_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "ssManhole", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "STUCTURE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7F4ABE4D-3C3C-4769-90EA-0E78747EF534}" }, { "id": 4, "name": "ssCatchBasin", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "STUCTURE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9E58DAD7-068C-474A-AAFE-33F783EBD5FB}" }, { "id": 0, "name": "DBO.Add_a_Catch_Basin", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "facility_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5830DCED-708C-4406-ABAE-345D4C40B862}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Structure Inspection Data ATTACHMENTS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R865_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_865", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4803_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_865", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" } ] }