{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "SWM Accounts / Water Meters", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 2.0E-4, "zTolerance": 2, "mTolerance": 2, "falseX": -5120899.99997529, "falseY": -9998099.99997139, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 197, 255, 255 ], "size": 3, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 530635.00202471, "ymin": 4809510.99812861, "xmax": 542410.388424709, "ymax": 4819811.00162861, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME_1", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OUTGOING_METER_NO", "type": "esriFieldTypeString", "alias": "OUTGOING_METER_NO", "length": 20, "domain": null }, { "name": "OUTGOING_METER_READ", "type": "esriFieldTypeInteger", "alias": "OUTGOING_METER_READ", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ACCOUNT_NO", "type": "esriFieldTypeString", "alias": "ACCOUNT_NO", "length": 7, "domain": null }, { "name": "ACCOUNT_6", "type": "esriFieldTypeString", "alias": "ACCOUNT_6", "length": 6, "domain": null }, { "name": "ACCOUNT_NO_7", "type": "esriFieldTypeString", "alias": "ACCOUNT_NO_7", "length": 7, "domain": null }, { "name": "ACCOUNT_STATUS", "type": "esriFieldTypeString", "alias": "ACCOUNT_STATUS", "length": 10, "domain": null }, { "name": "METER_ID", "type": "esriFieldTypeString", "alias": "METER_ID", "length": 20, "domain": null }, { "name": "CIVIC_ADDR", "type": "esriFieldTypeString", "alias": "CIVIC_ADDR", "length": 75, "domain": null }, { "name": "VAIL_ID", "type": "esriFieldTypeInteger", "alias": "VAIL_ID", "domain": null }, { "name": "PARCEL_ID", "type": "esriFieldTypeInteger", "alias": "PARCEL_ID", "domain": null }, { "name": "ASMT_ID", "type": "esriFieldTypeInteger", "alias": "ASMT_ID", "domain": null }, { "name": "ARN", "type": "esriFieldTypeString", "alias": "ARN", "length": 15, "domain": null }, { "name": "NAME_1", "type": "esriFieldTypeString", "alias": "NAME_1", "length": 254, "domain": null }, { "name": "NAME_2", "type": "esriFieldTypeString", "alias": "NAME_2", "length": 60, "domain": null }, { "name": "MAILING1", "type": "esriFieldTypeString", "alias": "MAILING1", "length": 254, "domain": null }, { "name": "STORMPROPERTYTYPE", "type": "esriFieldTypeString", "alias": "STORMPROPERTYTYPE", "length": 25, "domain": { "type": "codedValue", "name": "SW_UTILITY_TYPE", "description": "Type of sw account", "codedValues": [ { "name": "Residential", "code": "Residential" }, { "name": "Multi-Res", "code": "Multi-Res" }, { "name": "Industrial", "code": "Industrial" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Institutional", "code": "Institutional" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STORMWATER_FEE", "type": "esriFieldTypeDouble", "alias": "STORMWATER_FEE", "domain": null }, { "name": "SWMFEE_TIER", "type": "esriFieldTypeString", "alias": "SWMFEE_TIER", "length": 30, "domain": null }, { "name": "BILLING_AREA", "type": "esriFieldTypeDouble", "alias": "BILLING_AREA", "domain": null }, { "name": "BILLINGAREA_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "BillingArea_Flag", "domain": null }, { "name": "BILLINGAREA_COMMENTS", "type": "esriFieldTypeString", "alias": "BILLINGAREA_COMMENTS", "length": 100, "domain": null }, { "name": "OWNER_ACRES", "type": "esriFieldTypeDouble", "alias": "OWNER_ACRES", "domain": null }, { "name": "ASMT_AC", "type": "esriFieldTypeDouble", "alias": "ASMT_AC", "domain": null }, { "name": "SECTION_NO", "type": "esriFieldTypeString", "alias": "SECTION_NO", "length": 254, "domain": null }, { "name": "SUB_SECTION_NO", "type": "esriFieldTypeString", "alias": "SUB_SECTION_NO", "length": 10, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "length": 50, "domain": null }, { "name": "STREET_NO", "type": "esriFieldTypeString", "alias": "STREET_NO", "length": 254, "domain": null }, { "name": "UPPER_STREET_NO", "type": "esriFieldTypeString", "alias": "UPPER_STREET_NO", "length": 10, "domain": null }, { "name": "STREET_NAME_CODE", "type": "esriFieldTypeString", "alias": "STREET_NAME_CODE", "length": 10, "domain": null }, { "name": "STREET_UNIT", "type": "esriFieldTypeString", "alias": "STREET_UNIT", "length": 10, "domain": null }, { "name": "STREET_QUAL", "type": "esriFieldTypeString", "alias": "STREET_QUAL", "length": 20, "domain": null }, { "name": "OCCUPANCY_DATE", "type": "esriFieldTypeDate", "alias": "OCCUPANCY_DATE", "length": 8, "domain": null }, { "name": "TERMINATION_DATE", "type": "esriFieldTypeDate", "alias": "TERMINATION_DATE", "length": 8, "domain": null }, { "name": "OWNER_TENANT", "type": "esriFieldTypeString", "alias": "OWNER_TENANT", "length": 10, "domain": null }, { "name": "PROPERTYCO", "type": "esriFieldTypeSmallInteger", "alias": "PROPERTYCO", "domain": null }, { "name": "CODE", "type": "esriFieldTypeString", "alias": "CODE", "length": 200, "domain": null }, { "name": "MPAC_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "MPAC_FLAG", "domain": null }, { "name": "MPAC_COMMENTS", "type": "esriFieldTypeString", "alias": "MPAC_COMMENTS", "length": 50, "domain": null }, { "name": "NO_METER", "type": "esriFieldTypeSmallInteger", "alias": "NO_METER", "domain": null }, { "name": "NO_METER_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "No_Meter_Flag", "domain": null }, { "name": "NO_METER_COMMENTS", "type": "esriFieldTypeString", "alias": "NO_METER_COMMENTS", "length": 50, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 100, "domain": null }, { "name": "CHARGE_CODE_MONTHLY", "type": "esriFieldTypeSmallInteger", "alias": "CHARGE_CODE_MONTHLY", "domain": null }, { "name": "CHARGE_CODE_BIMONTHLY", "type": "esriFieldTypeSmallInteger", "alias": "CHARGE_CODE_BIMONTHLY", "domain": null }, { "name": "BILLING_DESCRIPTION", "type": "esriFieldTypeString", "alias": "BILLING_DESCRIPTION", "length": 50, "domain": null }, { "name": "TIER_LINK", "type": "esriFieldTypeString", "alias": "TIER_LINK", "length": 50, "domain": null }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null }, { "name": "BILLING_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "BILLING_FLAG", "domain": { "type": "codedValue", "name": "SW_BILLING_FLAG", "description": "stormwater billing status", "codedValues": [ { "name": "Normal Billing", "code": 0 }, { "name": "Account not billed", "code": 1 }, { "name": "Recalculate charge code", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREDIT_PCTG", "type": "esriFieldTypeSingle", "alias": "CREDIT_PCTG", "domain": null }, { "name": "APPLICATION_STATUS", "type": "esriFieldTypeString", "alias": "APPLICATION_STATUS", "length": 40, "domain": null }, { "name": "REVIEW_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "REVIEW_FLAG", "domain": { "type": "codedValue", "name": "SW_REVIEW", "description": "stormwater review required?", "codedValues": [ { "name": "No review required", "code": 0 }, { "name": "Application needs review", "code": 1 }, { "name": "Review complete", "code": 2 }, { "name": "Credit adjusted", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REVIEWED_DATE", "type": "esriFieldTypeDate", "alias": "REVIEWED_DATE", "length": 8, "domain": null }, { "name": "APPLICATION_ID", "type": "esriFieldTypeInteger", "alias": "APPLICATION_ID", "domain": null }, { "name": "INSPECTION_FLAG", "type": "esriFieldTypeString", "alias": "INSPECTION_FLAG", "length": 24, "domain": { "type": "codedValue", "name": "SW_INSPECTION_FLAG", "description": "stormwater inspection status", "codedValues": [ { "name": "Inspection needed", "code": "Inspection needed" }, { "name": "Inspection not needed", "code": "Inspection not needed" }, { "name": "Inspection completed", "code": "Inspection completed" }, { "name": "Credit needs adjusting", "code": "Credit needs adjusting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "length": 8, "domain": null }, { "name": "INSPECTION_NOTES", "type": "esriFieldTypeString", "alias": "INSPECTION_NOTES", "length": 256, "domain": null }, { "name": "NRMR_TOTAL_QUANTITY", "type": "esriFieldTypeDouble", "alias": "NRMR_TOTAL_QUANTITY", "domain": null }, { "name": "NRMR_TOTAL_QUALITY", "type": "esriFieldTypeDouble", "alias": "NRMR_TOTAL_QUALITY", "domain": null }, { "name": "NRMR_TOTAL_ED", "type": "esriFieldTypeDouble", "alias": "NRMR_TOTAL_ED", "domain": null }, { "name": "CREDIT_STATUS", "type": "esriFieldTypeString", "alias": "CREDIT_STATUS", "length": 30, "domain": null }, { "name": "APPLICATION_TYPE", "type": "esriFieldTypeString", "alias": "APPLICATION_TYPE", "length": 50, "domain": null }, { "name": "APPLICATION_ENTRY_DATE", "type": "esriFieldTypeDate", "alias": "APPLICATION_ENTRY_DATE", "length": 8, "domain": null }, { "name": "CREDIT_VOLUME", "type": "esriFieldTypeSmallInteger", "alias": "CREDIT_VOLUME", "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "CREATE_DATE", "length": 8, "domain": null }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "CREATE_USER", "length": 16, "domain": null }, { "name": "UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "UPDATE_DATE", "length": 8, "domain": null }, { "name": "UPDATE_USER", "type": "esriFieldTypeString", "alias": "UPDATE_USER", "length": 16, "domain": null }, { "name": "LASTACTIVITY", "type": "esriFieldTypeString", "alias": "LASTACTIVITY", "length": 50, "domain": { "type": "codedValue", "name": "dmnLastActivity_SWS", "description": "Activity drop down for SW&S", "codedValues": [ { "name": "Inspection", "code": "INSP" }, { "name": "Update", "code": "UPDT" }, { "name": "Repair / Replacement", "code": "RPR" }, { "name": "Installation", "code": "INST" }, { "name": "Abandon / Remove", "code": "ABAN" }, { "name": "Flushing", "code": "FLUSH" }, { "name": "Cleaning", "code": "CLEN" }, { "name": "Lateral Flushing", "code": "LATFL" }, { "name": "Contractor Cleaning", "code": "CC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATESTAMP", "type": "esriFieldTypeDate", "alias": "DATESTAMP", "length": 8, "domain": null }, { "name": "LINKEDDOCUMENTS", "type": "esriFieldTypeString", "alias": "LINKEDDOCUMENTS", "length": 1000, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "I1223ACCOUNT_NO", "fields": "ACCOUNT_NO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1223VAIL_ID", "fields": "VAIL_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R861_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A783_IX1", "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, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Addresses", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "vcsWkid": 115702, "latestVcsWkid": 115702, "xyTolerance": 2.0E-4, "zTolerance": 7.4976715938E-5, "mTolerance": 7.4976715938E-5, "falseX": -5120899.99997529, "falseY": -9998099.99997139, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "NAD_1983", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 159, 173, 255 ], "size": 1, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[LOCNUM]", "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "removeDuplicates": "none", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 5000, "name": "Default", "priority": 8, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 6, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 530635.00202471, "ymin": 4809321.61212861, "xmax": 542411.09002471, "ymax": 4819900.33172861, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ROLLNUM15", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "VAIL_ID", "type": "esriFieldTypeDouble", "alias": "VAIL_ID", "domain": null }, { "name": "ROLLNUM15", "type": "esriFieldTypeString", "alias": "ROLLNUM15", "length": 15, "domain": null }, { "name": "ROLLNUM19", "type": "esriFieldTypeString", "alias": "ROLLNUM19", "length": 19, "domain": null }, { "name": "CIVIC_ADDR", "type": "esriFieldTypeString", "alias": "CIVIC_ADDR", "length": 80, "domain": null }, { "name": "LOCNUM", "type": "esriFieldTypeDouble", "alias": "LOCNUM", "domain": null }, { "name": "STREETQUAL", "type": "esriFieldTypeString", "alias": "STREETQUAL", "length": 13, "domain": null }, { "name": "STREET_NM", "type": "esriFieldTypeString", "alias": "STREET_NM", "length": 30, "domain": null }, { "name": "STREET_UNI", "type": "esriFieldTypeString", "alias": "STREET_UNI", "length": 13, "domain": null }, { "name": "ROLLNO", "type": "esriFieldTypeString", "alias": "ROLLNO", "length": 16, "domain": null }, { "name": "OWNER1", "type": "esriFieldTypeString", "alias": "OWNER1", "length": 38, "domain": null }, { "name": "OWNER2", "type": "esriFieldTypeString", "alias": "OWNER2", "length": 37, "domain": null }, { "name": "OWNER3", "type": "esriFieldTypeString", "alias": "OWNER3", "length": 34, "domain": null }, { "name": "MAIL1", "type": "esriFieldTypeString", "alias": "MAIL1", "length": 37, "domain": null }, { "name": "MAIL2", "type": "esriFieldTypeString", "alias": "MAIL2", "length": 36, "domain": null }, { "name": "MAIL3", "type": "esriFieldTypeString", "alias": "MAIL3", "length": 36, "domain": null }, { "name": "MAIL4", "type": "esriFieldTypeString", "alias": "MAIL4", "length": 30, "domain": null }, { "name": "MAIL5", "type": "esriFieldTypeString", "alias": "MAIL5", "length": 11, "domain": null }, { "name": "LEG1", "type": "esriFieldTypeString", "alias": "LEG1", "length": 35, "domain": null }, { "name": "LEG2", "type": "esriFieldTypeString", "alias": "LEG2", "length": 35, "domain": null }, { "name": "LEG3", "type": "esriFieldTypeString", "alias": "LEG3", "length": 34, "domain": null }, { "name": "LEG4", "type": "esriFieldTypeString", "alias": "LEG4", "length": 35, "domain": null }, { "name": "LEG5", "type": "esriFieldTypeString", "alias": "LEG5", "length": 33, "domain": null }, { "name": "CODE", "type": "esriFieldTypeString", "alias": "CODE", "length": 200, "domain": null }, { "name": "DATEENTERE", "type": "esriFieldTypeDate", "alias": "DATEENTERE", "length": 8, "domain": null }, { "name": "ROADSEG", "type": "esriFieldTypeDouble", "alias": "ROADSEG", "domain": null }, { "name": "RDSIDE", "type": "esriFieldTypeString", "alias": "RDSIDE", "length": 10, "domain": null }, { "name": "STREETNO", "type": "esriFieldTypeDouble", "alias": "STREETNO", "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 15, "domain": { "type": "codedValue", "name": "ADDRESS_STATUS", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Expired", "code": "Expired" }, { "name": "To Be Retired", "code": "To Be Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PARCEL_ID", "type": "esriFieldTypeDouble", "alias": "PARCEL_ID", "domain": null }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null }, { "name": "MULTIUNIT", "type": "esriFieldTypeString", "alias": "MULTIUNIT", "length": 16, "domain": null }, { "name": "LODGEHOUSE", "type": "esriFieldTypeString", "alias": "LODGEHOUSE", "length": 16, "domain": null }, { "name": "MUNICNUM", "type": "esriFieldTypeString", "alias": "MUNICNUM", "length": 10, "domain": null }, { "name": "PROPERTYCO", "type": "esriFieldTypeDouble", "alias": "PROPERTYCO", "domain": null }, { "name": "WARD", "type": "esriFieldTypeInteger", "alias": "WARD", "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 40, "domain": null }, { "name": "POSTAL_CODE", "type": "esriFieldTypeString", "alias": "POSTAL_CODE", "length": 7, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "CREATE_DATE", "length": 8, "domain": null }, { "name": "UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "UPDATE_DATE", "length": 8, "domain": null }, { "name": "MXADDRESSCODE", "type": "esriFieldTypeString", "alias": "MXADDRESSCODE", "length": 12, "domain": null }, { "name": "MXSITEID", "type": "esriFieldTypeString", "alias": "MXSITEID", "length": 8, "domain": null }, { "name": "PLUSSERVICEADDRESSID", "type": "esriFieldTypeDouble", "alias": "PLUSSERVICEADDRESSID", "domain": null }, { "name": "ROWSTAMP", "type": "esriFieldTypeString", "alias": "ROWSTAMP", "length": 40, "domain": null }, { "name": "ASMT_ID", "type": "esriFieldTypeInteger", "alias": "ASMT_ID", "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 30, "domain": null }, { "name": "DATASOURCE", "type": "esriFieldTypeString", "alias": "DATASOURCE", "length": 30, "domain": { "type": "codedValue", "name": "ADDRESS_SOURCE", "description": "Data source for address points", "codedValues": [ { "name": "BYLAW", "code": "BYLAW" }, { "name": "GIS FIELD CHECK", "code": "GIS FIELD CHECK" }, { "name": "MPAC", "code": "MPAC" }, { "name": "PARKS", "code": "PARKS" }, { "name": "PWS", "code": "PWS" }, { "name": "VAILTECH WATER", "code": "VAILTECH WATER" }, { "name": "BUILDING STANDARDS", "code": "BUILDING STANDARDS" }, { "name": "STREETVIEW", "code": "STREETVIEW" }, { "name": "VAILTECH TAX", "code": "VAILTECH TAX" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SOURCETYPE", "type": "esriFieldTypeString", "alias": "SOURCETYPE", "length": 25, "domain": null }, { "name": "OUTSIDECITY", "type": "esriFieldTypeString", "alias": "OUTSIDECITY", "length": 1, "domain": { "type": "codedValue", "name": "boolean_text_single", "description": "Codes Y and N for YES and NO", "codedValues": [ { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "CREATE_USER", "length": 16, "domain": null }, { "name": "UPDATE_USER", "type": "esriFieldTypeString", "alias": "UPDATE_USER", "length": 16, "domain": null }, { "name": "BIA", "type": "esriFieldTypeString", "alias": "BIA", "length": 1, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 100, "domain": null }, { "name": "UPPER_NUMBER", "type": "esriFieldTypeString", "alias": "UPPER_NUMBER", "length": 10, "domain": null }, { "name": "BYLAW_ENF_AREA", "type": "esriFieldTypeString", "alias": "BYLAW_ENF_AREA", "length": 1, "domain": null }, { "name": "BYLAW_STAFF", "type": "esriFieldTypeString", "alias": "BYLAW_STAFF", "length": 30, "domain": null }, { "name": "BILLABLE", "type": "esriFieldTypeString", "alias": "BILLABLE", "length": 1, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "BYLAW_SNOW_ICE_AREA", "type": "esriFieldTypeString", "alias": "BYLAW_SNOW_ICE_AREA", "length": 1, "domain": null }, { "name": "BYLAW_SNOW_ICE_STAFF", "type": "esriFieldTypeString", "alias": "BYLAW_SNOW_ICE_STAFF", "length": 30, "domain": null }, { "name": "BUILDING_AREA", "type": "esriFieldTypeString", "alias": "BUILDING_AREA", "length": 10, "domain": null }, { "name": "BUILDING_STAFF", "type": "esriFieldTypeString", "alias": "BUILDING_STAFF", "length": 30, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "I56CIVIC_ADDR", "fields": "CIVIC_ADDR", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I56PARCEL_ID", "fields": "PARCEL_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I56ROLLNUM15", "fields": "ROLLNUM15", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I56VAIL_ID", "fields": "VAIL_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R28_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A10_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Sampling Locations", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26917, "latestWkid": 26917, "vcsWkid": 115702, "latestVcsWkid": 115702, "xyTolerance": 2.0E-4, "zTolerance": 7.4976715938E-5, "mTolerance": 7.4976715938E-5, "falseX": -5120899.99997529, "falseY": -9998099.99997139, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "NAD_1983", "heightUnit": "meter" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 10000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "1f5f096dc1df4803de0335a503ccb773", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABKUlEQVQoka3Sy0oCYRjG8f8cVGhkKGpoCLEDEilEiwiCFGtjVFfQFUT7gigCCQrsDrqFgpaGmyBbtqiN00Y0gmBsQCIombTDIqyRmWkhvcuH7wfPy/fKdDnyf8PRAZXZhk39xeYSeP0ThkGbmuBobpxkQEbbP4WQTGuoj8OqxY4fFKbjHK9lmBcFqNS+Q7uFXLXYHhtEqtTYcsHJKJurSVKi4N39oc4GsNeu/QOj/aR7FSSfnbGbSDGdlbLJSQcMBgj7ofYoQXRX1ecGj5+AT1MAmm+cu6D8TrZokEknUL1QTOfeMCm5YMGgtBTiQLhlNxVHcaJhjaeITrps/mYd/3h2TW55hsJdkZwoMpKI0KOp5BcM1rMWH863rsvJX3EDLDqzC4/qXd/qF9alSCef5fjjAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 531870.79472471, "ymin": 4809683.55082861, "xmax": 542331.95332471, "ymax": 4819577.82722861, "spatialReference": { "wkid": 26917, "latestWkid": 26917, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "COMPUTERNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "CIVIC_ADD", "type": "esriFieldTypeString", "alias": "CIVIC_ADD", "length": 50, "domain": null }, { "name": "LOC_DESCRI", "type": "esriFieldTypeString", "alias": "LOC_DESCRI", "length": 50, "domain": null }, { "name": "TAP_LOC", "type": "esriFieldTypeString", "alias": "TAP_LOC", "length": 50, "domain": null }, { "name": "SAMP_FREQ", "type": "esriFieldTypeString", "alias": "SAMP_FREQ", "length": 20, "domain": null }, { "name": "ROUTE", "type": "esriFieldTypeString", "alias": "ROUTE", "length": 20, "domain": null }, { "name": "TEST_TYPE", "type": "esriFieldTypeString", "alias": "TEST_TYPE", "length": 50, "domain": null }, { "name": "CODE", "type": "esriFieldTypeString", "alias": "CODE", "length": 10, "domain": null }, { "name": "LASTACTIVITY", "type": "esriFieldTypeString", "alias": "LASTACTIVITY", "length": 8, "domain": { "type": "codedValue", "name": "dmnChlorineMonitoring", "description": "", "codedValues": [ { "name": "Chlorine Monitoring", "code": "INSP" }, { "name": "Monochloramine / FA", "code": "MCFA" }, { "name": "ATP Sampling", "code": "ATP" }, { "name": "Regional Sampling", "code": "REGIONAL" }, { "name": "Dead End Flushing", "code": "FLSH" }, { "name": "Data for Ref Only", "code": "SUPPLY" }, { "name": "Autoflusher", "code": "AUTOFLSH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPUTERNAME", "type": "esriFieldTypeString", "alias": "COMPUTERNAME", "length": 30, "domain": null }, { "name": "DATESTAMP", "type": "esriFieldTypeDate", "alias": "DATESTAMP", "length": 8, "domain": null }, { "name": "ACTIVITYID", "type": "esriFieldTypeString", "alias": "ACTIVITYID", "length": 20, "domain": null }, { "name": "OPTIME", "type": "esriFieldTypeString", "alias": "OPTIME", "length": 505, "domain": null }, { "name": "OPERATEDBY", "type": "esriFieldTypeString", "alias": "OPERATEDBY", "length": 30, "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": "SAMPLED_BY", "type": "esriFieldTypeString", "alias": "SAMPLED_BY", "length": 50, "domain": { "type": "codedValue", "name": "dmnSamplingOperators", "description": "List of water sampling operators", "codedValues": [ { "name": "Andy Turner", "code": "Andy Turner" }, { "name": "Dave Herzing", "code": "Dave Herzing" }, { "name": "Jaclyn Varga", "code": "Jaclyn Varga" }, { "name": "Jamar Grant", "code": "Jamar Grant" }, { "name": "Jeff Schultz", "code": "Jeff Schultz" }, { "name": "Jim Helm", "code": "Jim Helm" }, { "name": "John Plomske", "code": "John Plomske" }, { "name": "Katie Turner", "code": "Katie Turner" }, { "name": "Matt Kutchcoski", "code": "Matt Kutchcoski" }, { "name": "Miriam Elsworthy", "code": "Miriam Elsworthy" }, { "name": "Natasha Glauser", "code": "Natasha Glauser" }, { "name": "Nathan Schaefer", "code": "Nathan Schaefer" }, { "name": "Paola Mendez", "code": "Paola Mendez" }, { "name": "Scott Donelle", "code": "Scott Donelle" }, { "name": "Shawn Mitchell", "code": "Shawn Mitchell" }, { "name": "Steve House", "code": "Steve House" }, { "name": "Shawn Clapham", "code": "Shawn Clapham" }, { "name": "Dan Lang", "code": "Dan Lang" }, { "name": "Stephen Bairos", "code": "Stephen Bairos" }, { "name": "Shane Vanamburg", "code": "Shane Vanamburg" }, { "name": "David Albanese", "code": "David Albanese" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAMPLE_TIME", "type": "esriFieldTypeSingle", "alias": "SAMPLE_TIME", "domain": null }, { "name": "CONDUCTIVITY", "type": "esriFieldTypeSingle", "alias": "CONDUCTIVITY", "domain": null }, { "name": "PH", "type": "esriFieldTypeSingle", "alias": "PH", "domain": null }, { "name": "TEMPERATURE", "type": "esriFieldTypeSingle", "alias": "TEMPERATURE", "domain": null }, { "name": "WAIT_TIME", "type": "esriFieldTypeSingle", "alias": "WAIT_TIME", "domain": null }, { "name": "ULTRACHECK_RLU", "type": "esriFieldTypeInteger", "alias": "ULTRACHECK_RLU", "domain": null }, { "name": "ATP_RLU", "type": "esriFieldTypeSmallInteger", "alias": "ATP_RLU", "domain": null }, { "name": "VOLUME_FILTERED", "type": "esriFieldTypeSmallInteger", "alias": "VOLUME_FILTERED", "domain": null }, { "name": "ANALYZED_BY", "type": "esriFieldTypeString", "alias": "ANALYZED_BY", "length": 50, "domain": { "type": "codedValue", "name": "dmnSamplingOperators", "description": "List of water sampling operators", "codedValues": [ { "name": "Andy Turner", "code": "Andy Turner" }, { "name": "Dave Herzing", "code": "Dave Herzing" }, { "name": "Jaclyn Varga", "code": "Jaclyn Varga" }, { "name": "Jamar Grant", "code": "Jamar Grant" }, { "name": "Jeff Schultz", "code": "Jeff Schultz" }, { "name": "Jim Helm", "code": "Jim Helm" }, { "name": "John Plomske", "code": "John Plomske" }, { "name": "Katie Turner", "code": "Katie Turner" }, { "name": "Matt Kutchcoski", "code": "Matt Kutchcoski" }, { "name": "Miriam Elsworthy", "code": "Miriam Elsworthy" }, { "name": "Natasha Glauser", "code": "Natasha Glauser" }, { "name": "Nathan Schaefer", "code": "Nathan Schaefer" }, { "name": "Paola Mendez", "code": "Paola Mendez" }, { "name": "Scott Donelle", "code": "Scott Donelle" }, { "name": "Shawn Mitchell", "code": "Shawn Mitchell" }, { "name": "Steve House", "code": "Steve House" }, { "name": "Shawn Clapham", "code": "Shawn Clapham" }, { "name": "Dan Lang", "code": "Dan Lang" }, { "name": "Stephen Bairos", "code": "Stephen Bairos" }, { "name": "Shane Vanamburg", "code": "Shane Vanamburg" }, { "name": "David Albanese", "code": "David Albanese" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "CATP", "type": "esriFieldTypeDouble", "alias": "CATP", "domain": null }, { "name": "CELL_COUNT", "type": "esriFieldTypeDouble", "alias": "CELL_COUNT", "domain": null }, { "name": "HT_PLATE_CNT", "type": "esriFieldTypeSmallInteger", "alias": "HT_PLATE_CNT", "domain": null }, { "name": "PA_ECOLI", "type": "esriFieldTypeString", "alias": "PA_ECOLI", "length": 20, "domain": null }, { "name": "PA_TC", "type": "esriFieldTypeString", "alias": "PA_TC", "length": 20, "domain": null }, { "name": "PRESENCE_ABSENCE", "type": "esriFieldTypeString", "alias": "PRESENCE_ABSENCE", "length": 20, "domain": null }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "CREATE_USER", "length": 16, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "CREATE_DATE", "length": 8, "domain": null }, { "name": "UPDATE_USER", "type": "esriFieldTypeString", "alias": "UPDATE_USER", "length": 16, "domain": null }, { "name": "UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "UPDATE_DATE", "length": 8, "domain": null }, { "name": "ZONE", "type": "esriFieldTypeString", "alias": "ZONE", "length": 20, "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeInteger", "alias": "ASSET_ID", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1049_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A872_IX1", "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, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Valve Inspections", "type": "Feature Layer", "description": "
Defn was:<\/SPAN><\/P> (<\/SPAN><\/SPAN>LASTACTIVITY<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'EXE'<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>Or<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>LASTACTIVITY<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'FVI'<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>And<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>DATESTAMP<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>TO_DATE<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>'2023-01-01 00:00:00'<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'YYYY-MM-DD HH24:MI:SS'<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>And<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>VALVE_FUNCTION<\/SPAN><\/SPAN> <\/SPAN><\/SPAN><><\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'Hydrant Valve'<\/SPAN><\/SPAN><\/P><\/DIV>",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
76,
230,
0,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": null
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 531867.46262471,
"ymin": 4809245.72102861,
"xmax": 542343.77762471,
"ymax": 4819866.24292861,
"spatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "ENTNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "FLUSHING_ZONE",
"type": "esriFieldTypeString",
"alias": "FLUSHING_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_MANAGER",
"type": "esriFieldTypeString",
"alias": "ASSET_MANAGER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_MANAGER",
"description": "City groups responsible for managing / budgeting for assets",
"codedValues": [
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facilities",
"code": "Facilities"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Storm",
"code": "Storm"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Active Transportation",
"code": "Active Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "LIFECYCLESTATUS",
"type": "esriFieldTypeString",
"alias": "LifecycleStatus",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainLifecycleStatus",
"description": "",
"codedValues": [
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Active",
"code": "Active"
},
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Never Built",
"code": "Never Built"
},
{
"name": "Split Archived",
"code": "Split Archived"
},
{
"name": "Temp",
"code": "Temp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "INSTALLDATE",
"type": "esriFieldTypeDate",
"alias": "INSTALLDATE",
"length": 8,
"domain": null
},
{
"name": "VALVE_FUNCTION",
"type": "esriFieldTypeString",
"alias": "VALVE_FUNCTION",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wValve_Function",
"description": "Function/Purpose of a water valve",
"codedValues": [
{
"name": "Control Valve",
"code": "Control Valve"
},
{
"name": "Flushing Valve",
"code": "Flushing Valve"
},
{
"name": "Hydrant Valve",
"code": "Hydrant Valve"
},
{
"name": "Main Valve",
"code": "Main Valve"
},
{
"name": "Service Valve",
"code": "Service Valve"
},
{
"name": "Bypass Valve",
"code": "Bypass Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_TYPE",
"type": "esriFieldTypeString",
"alias": "VALVE_TYPE",
"length": 30,
"domain": {
"type": "codedValue",
"name": "wValve_Type",
"description": "Type of a water valve",
"codedValues": [
{
"name": "Butterfly Valve",
"code": "Butterfly Valve"
},
{
"name": "Curb Stop",
"code": "Curb Stop"
},
{
"name": "Gate Valve",
"code": "Gate Valve"
},
{
"name": "Valve in Chamber",
"code": "Valve in Chamber"
},
{
"name": "Air Release Valve",
"code": "Air Release Valve"
},
{
"name": "Pressure Release Valve",
"code": "Pressure Release Valve"
},
{
"name": "Air & Vacuum Release Valve",
"code": "Air & Vacuum Release Valve"
},
{
"name": "Vacuum Release Valve",
"code": "Vacuum Release Valve"
},
{
"name": "Drain Valve",
"code": "Drain Valve"
},
{
"name": "Check Valve",
"code": "Check Valve"
},
{
"name": "Motorized Control Valve",
"code": "Motorized Control Valve"
},
{
"name": "Tapping Valve",
"code": "Tapping Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ASSET_ID",
"type": "esriFieldTypeInteger",
"alias": "ASSET_ID",
"domain": null
},
{
"name": "ENTNAME",
"type": "esriFieldTypeString",
"alias": "ENTNAME",
"length": 50,
"domain": null
},
{
"name": "SEGMENT_ID",
"type": "esriFieldTypeInteger",
"alias": "SEGMENT_ID",
"domain": null
},
{
"name": "VAIL_ID",
"type": "esriFieldTypeInteger",
"alias": "VAIL_ID",
"domain": null
},
{
"name": "CIVIC_ADDRESS",
"type": "esriFieldTypeString",
"alias": "CIVIC_ADDRESS",
"length": 80,
"domain": null
},
{
"name": "OWNER",
"type": "esriFieldTypeString",
"alias": "OWNER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "pws_asset_owner",
"description": "Owner of an asset ",
"codedValues": [
{
"name": "City of Waterloo",
"code": "City of Waterloo"
},
{
"name": "City of Kitchener",
"code": "City of Kitchener"
},
{
"name": "Region of Waterloo",
"code": "Region of Waterloo"
},
{
"name": "Shared with Region",
"code": "Shared with Region"
},
{
"name": "Private",
"code": "Private"
},
{
"name": "Township of Wilmot",
"code": "Township of Wilmot"
},
{
"name": "Township of Woolwich",
"code": "Township of Woolwich"
},
{
"name": "University of Waterloo",
"code": "University of Waterloo"
},
{
"name": "Region - Servicing Kitchener",
"code": "Region - Servicing Kitchener"
},
{
"name": "Grand River Conservation Authority",
"code": "GRCA"
},
{
"name": "Waterloo Region District School Board",
"code": "WRDSB"
},
{
"name": "Waterloo Catholic District School Board",
"code": "WCDSB"
},
{
"name": "City of Waterloo Property",
"code": "City of Waterloo Property"
},
{
"name": "Shared with Kitchener",
"code": "Shared with Kitchener"
},
{
"name": "Shared with Woolwich Twp",
"code": "Shared with Woolwich Twp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VALVE_MAKE",
"type": "esriFieldTypeString",
"alias": "VALVE_MAKE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainHydrantManufacturer",
"description": "",
"codedValues": [
{
"name": "AMERD",
"code": "AMERD"
},
{
"name": "COREY",
"code": "COREY"
},
{
"name": "CLOW",
"code": "CLOW"
},
{
"name": "DRESSER",
"code": "DRESSER"
},
{
"name": "KENNEDY",
"code": "KENNEDY"
},
{
"name": "MH",
"code": "MH"
},
{
"name": "MHD",
"code": "MHD"
},
{
"name": "MULLER",
"code": "MULLER"
},
{
"name": "UNK",
"code": "UNK"
},
{
"name": "USPIPE",
"code": "USPIPE"
},
{
"name": "WOOD",
"code": "WOOD"
},
{
"name": "CENTURY",
"code": "CENTURY"
},
{
"name": "BRIGADIER",
"code": "BRIGADIER"
},
{
"name": "CAN VALVE",
"code": "CAN VALVE"
},
{
"name": "CANRON",
"code": "CANRON"
},
{
"name": "CONCORD",
"code": "CONCORD"
},
{
"name": "DARLING",
"code": "DARLING"
},
{
"name": "McAVITY",
"code": "McAVITY"
},
{
"name": "SENTINEL",
"code": "SENTINEL"
},
{
"name": "DARLING B50B",
"code": "DARLING B50B"
},
{
"name": "CONCORD DAIGLE",
"code": "CONCORD DAIGLE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASBUILTNUMBER",
"type": "esriFieldTypeString",
"alias": "ASBUILTNUMBER",
"length": 50,
"domain": null
},
{
"name": "POSITION_ACCURACY",
"type": "esriFieldTypeString",
"alias": "POSITION_ACCURACY",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmnInfraPosition",
"description": "Describes positional accuracy/source of infrastructure assets",
"codedValues": [
{
"name": "Digitized +/- 2m",
"code": "Digitized +/- 2m"
},
{
"name": "Total Station +/- 0.5m",
"code": "Total Station +/- 0.5m"
},
{
"name": "AutoCAD Drawings +/- 1m",
"code": "AutoCAD Drawings +/- 1m"
},
{
"name": "Site Plan +/- 2m",
"code": "Site Plan +/- 2m"
},
{
"name": "Schematic +/- 2m",
"code": "Schematic +/- 2m"
},
{
"name": "Eng Dwg/As Built +/- 2m",
"code": "Eng Dwg/As Built +/- 2m"
},
{
"name": "GPS +/- 0.5m",
"code": "GPS +/- 0.5m"
},
{
"name": "Inferred for Inframap",
"code": "Inferred for Inframap"
},
{
"name": "Estimated/Unknown",
"code": "Estimated/Unknown"
},
{
"name": "Aerial Photo +/- 0.5m",
"code": "Aerial Photo +/- 0.5m"
},
{
"name": "Field Notes",
"code": "Field Notes"
},
{
"name": "CCTV +/- 1m",
"code": "CCTV +/- 1m"
},
{
"name": "Extended from City-owned service for Lead Project",
"code": "Extended from City-owned service for Lead Project"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DIAMETER",
"type": "esriFieldTypeSmallInteger",
"alias": "DIAMETER",
"domain": {
"type": "codedValue",
"name": "wMainDiameter",
"description": "Water Distribution Main Diameter",
"codedValues": [
{
"name": "25",
"code": 25
},
{
"name": "50",
"code": 50
},
{
"name": "100",
"code": 100
},
{
"name": "150",
"code": 150
},
{
"name": "200",
"code": 200
},
{
"name": "250",
"code": 250
},
{
"name": "300",
"code": 300
},
{
"name": "400",
"code": 400
},
{
"name": "450",
"code": 450
},
{
"name": "600",
"code": 600
},
{
"name": "750",
"code": 750
},
{
"name": "350",
"code": 350
},
{
"name": "500",
"code": 500
},
{
"name": "38",
"code": 38
},
{
"name": "19",
"code": 19
},
{
"name": "900",
"code": 900
},
{
"name": "1200",
"code": 1200
},
{
"name": "999",
"code": 999
},
{
"name": "15",
"code": 15
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "LOCATIONDESCRIPTION",
"type": "esriFieldTypeString",
"alias": "LOCATIONDESCRIPTION",
"length": 200,
"domain": null
},
{
"name": "ASSUMPTIONSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSUMPTIONSTATUS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "InfrastructureAssumptionStatus",
"description": "",
"codedValues": [
{
"name": "Assumed by City of Waterloo",
"code": "Assumed by City of Waterloo"
},
{
"name": "NA",
"code": "NA"
},
{
"name": "On Maintenance",
"code": "On Maintenance"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STARTOFMAINTDATE",
"type": "esriFieldTypeDate",
"alias": "STARTOFMAINTDATE",
"length": 8,
"domain": null
},
{
"name": "FINALACCEPTANCEDATE",
"type": "esriFieldTypeDate",
"alias": "FINALACCEPTANCEDATE",
"length": 8,
"domain": null
},
{
"name": "REMOVED_DATE",
"type": "esriFieldTypeDate",
"alias": "REMOVED_DATE",
"length": 8,
"domain": null
},
{
"name": "OPENSTATUS",
"type": "esriFieldTypeString",
"alias": "OPENSTATUS",
"length": 6,
"domain": {
"type": "codedValue",
"name": "wValve_OpenStatus",
"description": "current status of a water valve (not necessarily = normal status)",
"codedValues": [
{
"name": "Open",
"code": "Open"
},
{
"name": "Closed",
"code": "Closed"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ROTATION",
"type": "esriFieldTypeDouble",
"alias": "ROTATION",
"domain": null
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"length": 50,
"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": "SURFACE_ELEVATION",
"type": "esriFieldTypeDouble",
"alias": "SURFACE_ELEVATION",
"domain": null
},
{
"name": "CREATE_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATE_DATE",
"length": 8,
"domain": null
},
{
"name": "CREATE_USER",
"type": "esriFieldTypeString",
"alias": "CREATE_USER",
"length": 16,
"domain": null
},
{
"name": "UPDATE_DATE",
"type": "esriFieldTypeDate",
"alias": "UPDATE_DATE",
"length": 8,
"domain": null
},
{
"name": "UPDATE_USER",
"type": "esriFieldTypeString",
"alias": "UPDATE_USER",
"length": 16,
"domain": null
},
{
"name": "ACTIVITYID",
"type": "esriFieldTypeString",
"alias": "ACTIVITYID",
"length": 20,
"domain": null
},
{
"name": "LASTACTIVITY",
"type": "esriFieldTypeString",
"alias": "LASTACTIVITY",
"length": 4,
"domain": {
"type": "codedValue",
"name": "dmnValveActivity",
"description": "",
"codedValues": [
{
"name": "Installation",
"code": "INST"
},
{
"name": "Update Info",
"code": "UPDT"
},
{
"name": "Exercise Valve",
"code": "EXE"
},
{
"name": "Line Shutdown",
"code": "CLS"
},
{
"name": "Line Reopen",
"code": "OPN"
},
{
"name": "Remove/Abandon",
"code": "ABAN"
},
{
"name": "Pressure Valve Pumping",
"code": "PRV"
},
{
"name": "Repair",
"code": "RPR"
},
{
"name": "Valve Inspection",
"code": "FVI"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DATESTAMP",
"type": "esriFieldTypeDate",
"alias": "DATESTAMP",
"length": 8,
"domain": null
},
{
"name": "OPTIME",
"type": "esriFieldTypeString",
"alias": "OPTIME",
"length": 5,
"domain": null
},
{
"name": "COMPUTERNAME",
"type": "esriFieldTypeString",
"alias": "COMPUTERNAME",
"length": 30,
"domain": null
},
{
"name": "OPERATEDBY",
"type": "esriFieldTypeString",
"alias": "OPERATEDBY",
"length": 30,
"domain": null
},
{
"name": "OPERATIONALSTATUS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALSTATUS",
"length": 10,
"domain": {
"type": "codedValue",
"name": "dmnOperationalStatus",
"description": "",
"codedValues": [
{
"name": "OK",
"code": "OK"
},
{
"name": "Needs Repair",
"code": "NRPR"
},
{
"name": "Inoperable",
"code": "INOP"
},
{
"name": "Unable to Locate",
"code": "UTL"
},
{
"name": "No Access",
"code": "NOAC"
},
{
"name": "Out of Service",
"code": "OOS"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "TURNTOOPERATE",
"type": "esriFieldTypeDouble",
"alias": "TURNTOOPERATE",
"domain": null
},
{
"name": "DEPTH",
"type": "esriFieldTypeDouble",
"alias": "DEPTH",
"domain": null
},
{
"name": "GPSX",
"type": "esriFieldTypeDouble",
"alias": "GPSX",
"domain": null
},
{
"name": "GPSY",
"type": "esriFieldTypeDouble",
"alias": "GPSY",
"domain": null
},
{
"name": "LINKEDDOCUMENTS",
"type": "esriFieldTypeString",
"alias": "LINKEDDOCUMENTS",
"length": 500,
"domain": null
},
{
"name": "OPERATIONALCOMMENTS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALCOMMENTS",
"length": 200,
"domain": null
},
{
"name": "CLOCKWISETOCLOSE",
"type": "esriFieldTypeString",
"alias": "CLOCKWISETOCLOSE",
"length": 4,
"domain": null
},
{
"name": "UPDATEGPS",
"type": "esriFieldTypeString",
"alias": "UPDATEGPS",
"length": 4,
"domain": null
},
{
"name": "MANUALTURN",
"type": "esriFieldTypeString",
"alias": "MANUALTURN",
"length": 1,
"domain": {
"type": "codedValue",
"name": "boolean_text_single",
"description": "Codes Y and N for YES and NO",
"codedValues": [
{
"name": "Y",
"code": "Y"
},
{
"name": "N",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"length": 80,
"domain": null
},
{
"name": "HIGHTORQUE",
"type": "esriFieldTypeSmallInteger",
"alias": "HIGHTORQUE",
"domain": null
},
{
"name": "TORQUEDATA",
"type": "esriFieldTypeString",
"alias": "TORQUEDATA",
"length": 1073741822,
"domain": null
},
{
"name": "GLAND_LEAK",
"type": "esriFieldTypeString",
"alias": "GLAND_LEAK",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnGlandLeak",
"description": "water system valves",
"codedValues": [
{
"name": "No gland leak",
"code": "No gland leak"
},
{
"name": "Steady",
"code": "Steady"
},
{
"name": "Stops when jammed",
"code": "Stops when jammed"
},
{
"name": "Not inspected",
"code": "Not inspected"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OPERATING_NUT",
"type": "esriFieldTypeString",
"alias": "OPERATING_NUT",
"length": 16,
"domain": {
"type": "codedValue",
"name": "dmnOperatingNut",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Broken Off",
"code": "Broken Off"
},
{
"name": "Rounded",
"code": "Rounded"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Broken, spins",
"code": "Broken, spins"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_BROKEN",
"type": "esriFieldTypeString",
"alias": "VALVE_BROKEN",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnValveBroken",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Valve Broken Open",
"code": "Valve Broken Open"
},
{
"name": "Valve Broken Closed",
"code": "Valve Broken Closed"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Seized",
"code": "Seized"
},
{
"name": "Stiff",
"code": "Stiff"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_BOX",
"type": "esriFieldTypeString",
"alias": "VALVE_BOX",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnValveBox",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Valve Box Broken",
"code": "Valve Box Broken"
},
{
"name": "Valve Box Shifted",
"code": "Valve Box Shifted"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Valve Box is raised",
"code": "Raised Valve Box"
},
{
"name": "Mud/Water/Debris",
"code": "Mud and Debris"
},
{
"name": "New Lid Needed",
"code": "New Lid Needed"
},
{
"name": "Valve Box is low",
"code": "Lowered Valve Box"
},
{
"name": "Screw Top Broken",
"code": "Screw Top Broken"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_TURNS",
"type": "esriFieldTypeString",
"alias": "VALVE_TURNS",
"length": 12,
"domain": {
"type": "codedValue",
"name": "dmnValveTurns",
"description": "water system valves",
"codedValues": [
{
"name": "Normal",
"code": "Normal"
},
{
"name": "Above Normal",
"code": "Above Normal"
},
{
"name": "Below Normal",
"code": "Below Normal"
},
{
"name": "Undetermined",
"code": "Undetermined"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_PRIORITY",
"type": "esriFieldTypeString",
"alias": "VALVE_PRIORITY",
"length": 12,
"domain": {
"type": "codedValue",
"name": "dmnValvePriority",
"description": "water system valves",
"codedValues": [
{
"name": "Low",
"code": "Low"
},
{
"name": "Medium",
"code": "Medium"
},
{
"name": "High",
"code": "High"
},
{
"name": "Very High",
"code": "Very High"
},
{
"name": "Top Priority",
"code": "Top Priority"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_ACTION",
"type": "esriFieldTypeString",
"alias": "VALVE_ACTION",
"length": 30,
"domain": null
},
{
"name": "PRESSURE_ZONE",
"type": "esriFieldTypeString",
"alias": "PRESSURE_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_CLASS",
"type": "esriFieldTypeString",
"alias": "ASSET_CLASS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_CLASS",
"description": "Classes of Assets for AM",
"codedValues": [
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facility",
"code": "Facility"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Lakes",
"code": "Lakes"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Roads",
"code": "Roads"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Stormwater",
"code": "Stormwater"
},
{
"name": "Natural",
"code": "Natural"
},
{
"name": "Ponds",
"code": "Ponds"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Land / Property",
"code": "Land / Property"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VFA_CAMPUS_ID",
"type": "esriFieldTypeString",
"alias": "VFA_CAMPUS_ID",
"length": 20,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R846_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A778_IX1",
"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,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": false
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.81,
"cimVersion": "2.6.0",
"id": 4,
"name": "Hydrant Inspections",
"type": "Feature Layer",
"description": " Defn was:<\/SPAN><\/P> (<\/SPAN><\/SPAN>LASTACTIVITY<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'INSP'<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>Or<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>LASTACTIVITY<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'FIRE'<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>And<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>DATESTAMP<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>TO_DATE<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>'2023-01-01 00:00:00'<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN> <\/SPAN><\/SPAN>'YYYY-MM-DD HH24:MI:SS'<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN><\/P><\/DIV>",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
197,
0,
255,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": null
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": [
{
"labelExpression": "[DATESTAMP]",
"labelPlacement": "esriServerPointLabelPlacementAboveRight",
"deconflictionStrategy": "dynamic",
"removeDuplicates": "none",
"stackLabel": false,
"useCodedValues": true,
"maxScale": 0,
"minScale": 1000,
"name": "Default",
"priority": 5,
"symbol": {
"type": "esriTS",
"color": [
168,
0,
132,
255
],
"backgroundColor": null,
"borderLineColor": null,
"borderLineSize": null,
"verticalAlignment": "bottom",
"horizontalAlignment": "center",
"rightToLeft": false,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"kerning": true,
"haloColor": [
255,
255,
255,
255
],
"haloSize": 2,
"font": {
"family": "Arial",
"size": 7,
"style": "normal",
"weight": "bold",
"decoration": "none"
}
}
}
]
},
"defaultVisibility": true,
"extent": {
"xmin": 531870.79472471,
"ymin": 4809092.57982861,
"xmax": 542331.95332471,
"ymax": 4819833.37282861,
"spatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "ENTNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "FLUSHING_ZONE",
"type": "esriFieldTypeString",
"alias": "FLUSHING_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_MANAGER",
"type": "esriFieldTypeString",
"alias": "ASSET_MANAGER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_MANAGER",
"description": "City groups responsible for managing / budgeting for assets",
"codedValues": [
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facilities",
"code": "Facilities"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Storm",
"code": "Storm"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Active Transportation",
"code": "Active Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "LIFECYCLESTATUS",
"type": "esriFieldTypeString",
"alias": "LIFECYCLESTATUS",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainLifecycleStatus",
"description": "",
"codedValues": [
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Active",
"code": "Active"
},
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Never Built",
"code": "Never Built"
},
{
"name": "Split Archived",
"code": "Split Archived"
},
{
"name": "Temp",
"code": "Temp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASSET_ID",
"type": "esriFieldTypeInteger",
"alias": "ASSET_ID",
"domain": null
},
{
"name": "HYDRANT_ID",
"type": "esriFieldTypeDouble",
"alias": "HYDRANT_ID",
"domain": null
},
{
"name": "ENTNAME",
"type": "esriFieldTypeString",
"alias": "ENTNAME",
"length": 20,
"domain": null
},
{
"name": "SEGMENT_ID",
"type": "esriFieldTypeInteger",
"alias": "SEGMENT_ID",
"domain": null
},
{
"name": "VAIL_ID",
"type": "esriFieldTypeInteger",
"alias": "VAIL_ID",
"domain": null
},
{
"name": "CIVIC_ADDRESS",
"type": "esriFieldTypeString",
"alias": "CIVIC_ADDRESS",
"length": 80,
"domain": null
},
{
"name": "OWNER",
"type": "esriFieldTypeString",
"alias": "OWNER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "pws_asset_owner",
"description": "Owner of an asset ",
"codedValues": [
{
"name": "City of Waterloo",
"code": "City of Waterloo"
},
{
"name": "City of Kitchener",
"code": "City of Kitchener"
},
{
"name": "Region of Waterloo",
"code": "Region of Waterloo"
},
{
"name": "Shared with Region",
"code": "Shared with Region"
},
{
"name": "Private",
"code": "Private"
},
{
"name": "Township of Wilmot",
"code": "Township of Wilmot"
},
{
"name": "Township of Woolwich",
"code": "Township of Woolwich"
},
{
"name": "University of Waterloo",
"code": "University of Waterloo"
},
{
"name": "Region - Servicing Kitchener",
"code": "Region - Servicing Kitchener"
},
{
"name": "Grand River Conservation Authority",
"code": "GRCA"
},
{
"name": "Waterloo Region District School Board",
"code": "WRDSB"
},
{
"name": "Waterloo Catholic District School Board",
"code": "WCDSB"
},
{
"name": "City of Waterloo Property",
"code": "City of Waterloo Property"
},
{
"name": "Shared with Kitchener",
"code": "Shared with Kitchener"
},
{
"name": "Shared with Woolwich Twp",
"code": "Shared with Woolwich Twp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASBUILTNUMBER",
"type": "esriFieldTypeString",
"alias": "ASBUILTNUMBER",
"length": 50,
"domain": null
},
{
"name": "POSITION_ACCURACY",
"type": "esriFieldTypeString",
"alias": "POSITION_ACCURACY",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmnInfraPosition",
"description": "Describes positional accuracy/source of infrastructure assets",
"codedValues": [
{
"name": "Digitized +/- 2m",
"code": "Digitized +/- 2m"
},
{
"name": "Total Station +/- 0.5m",
"code": "Total Station +/- 0.5m"
},
{
"name": "AutoCAD Drawings +/- 1m",
"code": "AutoCAD Drawings +/- 1m"
},
{
"name": "Site Plan +/- 2m",
"code": "Site Plan +/- 2m"
},
{
"name": "Schematic +/- 2m",
"code": "Schematic +/- 2m"
},
{
"name": "Eng Dwg/As Built +/- 2m",
"code": "Eng Dwg/As Built +/- 2m"
},
{
"name": "GPS +/- 0.5m",
"code": "GPS +/- 0.5m"
},
{
"name": "Inferred for Inframap",
"code": "Inferred for Inframap"
},
{
"name": "Estimated/Unknown",
"code": "Estimated/Unknown"
},
{
"name": "Aerial Photo +/- 0.5m",
"code": "Aerial Photo +/- 0.5m"
},
{
"name": "Field Notes",
"code": "Field Notes"
},
{
"name": "CCTV +/- 1m",
"code": "CCTV +/- 1m"
},
{
"name": "Extended from City-owned service for Lead Project",
"code": "Extended from City-owned service for Lead Project"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "MAIN_DIAMETER",
"type": "esriFieldTypeSmallInteger",
"alias": "MAIN_DIAMETER",
"domain": {
"type": "codedValue",
"name": "wMainDiameter",
"description": "Water Distribution Main Diameter",
"codedValues": [
{
"name": "25",
"code": 25
},
{
"name": "50",
"code": 50
},
{
"name": "100",
"code": 100
},
{
"name": "150",
"code": 150
},
{
"name": "200",
"code": 200
},
{
"name": "250",
"code": 250
},
{
"name": "300",
"code": 300
},
{
"name": "400",
"code": 400
},
{
"name": "450",
"code": 450
},
{
"name": "600",
"code": 600
},
{
"name": "750",
"code": 750
},
{
"name": "350",
"code": 350
},
{
"name": "500",
"code": 500
},
{
"name": "38",
"code": 38
},
{
"name": "19",
"code": 19
},
{
"name": "900",
"code": 900
},
{
"name": "1200",
"code": 1200
},
{
"name": "999",
"code": 999
},
{
"name": "15",
"code": 15
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "HYDRANT_MAKE",
"type": "esriFieldTypeString",
"alias": "HYDRANT_MAKE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainHydrantManufacturer",
"description": "",
"codedValues": [
{
"name": "AMERD",
"code": "AMERD"
},
{
"name": "COREY",
"code": "COREY"
},
{
"name": "CLOW",
"code": "CLOW"
},
{
"name": "DRESSER",
"code": "DRESSER"
},
{
"name": "KENNEDY",
"code": "KENNEDY"
},
{
"name": "MH",
"code": "MH"
},
{
"name": "MHD",
"code": "MHD"
},
{
"name": "MULLER",
"code": "MULLER"
},
{
"name": "UNK",
"code": "UNK"
},
{
"name": "USPIPE",
"code": "USPIPE"
},
{
"name": "WOOD",
"code": "WOOD"
},
{
"name": "CENTURY",
"code": "CENTURY"
},
{
"name": "BRIGADIER",
"code": "BRIGADIER"
},
{
"name": "CAN VALVE",
"code": "CAN VALVE"
},
{
"name": "CANRON",
"code": "CANRON"
},
{
"name": "CONCORD",
"code": "CONCORD"
},
{
"name": "DARLING",
"code": "DARLING"
},
{
"name": "McAVITY",
"code": "McAVITY"
},
{
"name": "SENTINEL",
"code": "SENTINEL"
},
{
"name": "DARLING B50B",
"code": "DARLING B50B"
},
{
"name": "CONCORD DAIGLE",
"code": "CONCORD DAIGLE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "DISTANCE_HYD_TO_VALVE",
"type": "esriFieldTypeSingle",
"alias": "DISTANCE_HYD_TO_VALVE",
"domain": null
},
{
"name": "NUMBER_OF_OUTLETS",
"type": "esriFieldTypeSmallInteger",
"alias": "NUMBER_OF_OUTLETS",
"domain": null
},
{
"name": "STORTZ_CONNECTION",
"type": "esriFieldTypeString",
"alias": "STORTZ_CONNECTION",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wHydrant_YNU",
"description": "Yes No Unknown",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
},
{
"name": "Unknown",
"code": "U"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DRAINHOLES_CAPPED",
"type": "esriFieldTypeString",
"alias": "DRAINHOLES_CAPPED",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wHydrant_YNU",
"description": "Yes No Unknown",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
},
{
"name": "Unknown",
"code": "U"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "BARREL_TYPE",
"type": "esriFieldTypeString",
"alias": "BARREL_TYPE",
"length": 20,
"domain": null
},
{
"name": "ATLAS_TILE",
"type": "esriFieldTypeString",
"alias": "ATLAS_TILE",
"length": 10,
"domain": null
},
{
"name": "PRESSURE_ZONE",
"type": "esriFieldTypeString",
"alias": "PRESSURE_ZONE",
"length": 20,
"domain": null
},
{
"name": "COLOUR_CODE",
"type": "esriFieldTypeString",
"alias": "COLOUR_CODE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnHydrantColour",
"description": "Colour (=flow rate) painted on hydrants",
"codedValues": [
{
"name": "Blue",
"code": "Blue"
},
{
"name": "Green",
"code": "Green"
},
{
"name": "Orange",
"code": "Orange"
},
{
"name": "Red",
"code": "Red"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "LOCATION_DESCRIPTION",
"length": 80,
"domain": null
},
{
"name": "ASSUMPTIONSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSUMPTIONSTATUS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "InfrastructureAssumptionStatus",
"description": "",
"codedValues": [
{
"name": "Assumed by City of Waterloo",
"code": "Assumed by City of Waterloo"
},
{
"name": "NA",
"code": "NA"
},
{
"name": "On Maintenance",
"code": "On Maintenance"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STARTOFMAINTDATE",
"type": "esriFieldTypeDate",
"alias": "STARTOFMAINTDATE",
"length": 8,
"domain": null
},
{
"name": "FINALACCEPTANCEDATE",
"type": "esriFieldTypeDate",
"alias": "FINALACCEPTANCEDATE",
"length": 8,
"domain": null
},
{
"name": "REMOVED_DATE",
"type": "esriFieldTypeDate",
"alias": "REMOVED_DATE",
"length": 8,
"domain": null
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"length": 200,
"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": "CREATE_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATE_DATE",
"length": 8,
"domain": null
},
{
"name": "CREATE_USER",
"type": "esriFieldTypeString",
"alias": "CREATE_USER",
"length": 16,
"domain": null
},
{
"name": "UPDATE_DATE",
"type": "esriFieldTypeDate",
"alias": "UPDATE_DATE",
"length": 8,
"domain": null
},
{
"name": "UPDATE_USER",
"type": "esriFieldTypeString",
"alias": "UPDATE_USER",
"length": 16,
"domain": null
},
{
"name": "ACTIVITYID",
"type": "esriFieldTypeString",
"alias": "ACTIVITYID",
"length": 20,
"domain": null
},
{
"name": "LASTACTIVITY",
"type": "esriFieldTypeString",
"alias": "LASTACTIVITY",
"length": 4,
"domain": {
"type": "codedValue",
"name": "dmnHydrantActivity",
"description": "Activity performed on hydrant",
"codedValues": [
{
"name": "Installation",
"code": "INST"
},
{
"name": "Update Info",
"code": "UPDT"
},
{
"name": "Inspection",
"code": "INSP"
},
{
"name": "Fire Flow Test",
"code": "FIRE"
},
{
"name": "Paint Hydrant",
"code": "PNT"
},
{
"name": "Unidirectional Flush",
"code": "FLSH"
},
{
"name": "Repair/Replacement",
"code": "RPR"
},
{
"name": "Remove/Abandon",
"code": "ABAN"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DATESTAMP",
"type": "esriFieldTypeDate",
"alias": "DATESTAMP",
"length": 8,
"domain": null
},
{
"name": "OPTIME",
"type": "esriFieldTypeString",
"alias": "OPTIME",
"length": 5,
"domain": null
},
{
"name": "COMPUTERNAME",
"type": "esriFieldTypeString",
"alias": "COMPUTERNAME",
"length": 30,
"domain": null
},
{
"name": "OPERATEDBY",
"type": "esriFieldTypeString",
"alias": "OPERATEDBY",
"length": 30,
"domain": null
},
{
"name": "OPERATIONALSTATUS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALSTATUS",
"length": 5,
"domain": {
"type": "codedValue",
"name": "dmnOperationalStatus",
"description": "",
"codedValues": [
{
"name": "OK",
"code": "OK"
},
{
"name": "Needs Repair",
"code": "NRPR"
},
{
"name": "Inoperable",
"code": "INOP"
},
{
"name": "Unable to Locate",
"code": "UTL"
},
{
"name": "No Access",
"code": "NOAC"
},
{
"name": "Out of Service",
"code": "OOS"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STATICPSI",
"type": "esriFieldTypeSmallInteger",
"alias": "STATICPSI",
"domain": null
},
{
"name": "RESIDPSI",
"type": "esriFieldTypeSmallInteger",
"alias": "RESIDPSI",
"domain": null
},
{
"name": "PITOT",
"type": "esriFieldTypeSmallInteger",
"alias": "PITOT",
"domain": null
},
{
"name": "FLOWMINS",
"type": "esriFieldTypeString",
"alias": "FLOWMINS",
"length": 7,
"domain": null
},
{
"name": "OPERATIONCOMMENTS",
"type": "esriFieldTypeString",
"alias": "OPERATIONCOMMENTS",
"length": 200,
"domain": {
"type": "codedValue",
"name": "dmnHydrantOPComments",
"description": "Operator comments",
"codedValues": [
{
"name": "Branch valve needs service",
"code": "BranchValveNS"
},
{
"name": "Broken Barrel",
"code": "Broken Barrel"
},
{
"name": "Broken Stem",
"code": "Broken Stem"
},
{
"name": "Head Gasket",
"code": "Head Gasket"
},
{
"name": "Caps need service",
"code": "HydrantCNS"
},
{
"name": "Valve and seat need service",
"code": "HydrantVSNS"
},
{
"name": "Packing needs service",
"code": "PackingNS"
},
{
"name": "Seat Gasket",
"code": "Seat Gasket"
},
{
"name": "Valve Ball",
"code": "Valve Ball"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ISOVALVE",
"type": "esriFieldTypeString",
"alias": "ISOVALVE",
"length": 4,
"domain": null
},
{
"name": "HYDRANTREPAIRS",
"type": "esriFieldTypeString",
"alias": "HYDRANTREPAIRS",
"length": 50,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "PITOT2",
"type": "esriFieldTypeSmallInteger",
"alias": "PITOT2",
"domain": null
},
{
"name": "LINKEDDOCUMENTS",
"type": "esriFieldTypeString",
"alias": "LINKEDDOCUMENTS",
"length": 500,
"domain": null
},
{
"name": "RESIDUAL_HYDRANT",
"type": "esriFieldTypeString",
"alias": "RESIDUAL_HYDRANT",
"length": 20,
"domain": null
},
{
"name": "REPAIRS_NEEDED",
"type": "esriFieldTypeString",
"alias": "REPAIRS_NEEDED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmn_Major_Minor",
"description": "Codes of Major and Minor",
"codedValues": [
{
"name": "Major",
"code": "Major"
},
{
"name": "Minor",
"code": "Minor"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "INSTALLDATE",
"type": "esriFieldTypeDate",
"alias": "INSTALLDATE",
"length": 8,
"domain": null
},
{
"name": "HYDRANT_DRAINAGE",
"type": "esriFieldTypeString",
"alias": "HYDRANT_DRAINAGE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "HYDRANT_OPERATION_NUT",
"type": "esriFieldTypeString",
"alias": "HYDRANT_OPERATION_NUT",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnHydrant_Operation_Nut",
"description": "",
"codedValues": [
{
"name": "needs service",
"code": "needs service"
},
{
"name": "good condition",
"code": "good condition"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "HYDRANT_PAINTING",
"type": "esriFieldTypeString",
"alias": "HYDRANT_PAINTING",
"length": 3,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASSET_CLASS",
"type": "esriFieldTypeString",
"alias": "ASSET_CLASS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_CLASS",
"description": "Classes of Assets for AM",
"codedValues": [
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facility",
"code": "Facility"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Lakes",
"code": "Lakes"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Roads",
"code": "Roads"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Stormwater",
"code": "Stormwater"
},
{
"name": "Natural",
"code": "Natural"
},
{
"name": "Ponds",
"code": "Ponds"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Land / Property",
"code": "Land / Property"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VFA_CAMPUS_ID",
"type": "esriFieldTypeString",
"alias": "VFA_CAMPUS_ID",
"length": 20,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R842_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A774_IX1",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": true,
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": true,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": false
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.81,
"cimVersion": "2.6.0",
"id": 5,
"name": "Hydrants",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 10000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriPMS",
"url": "a2e419bf6c41ccea91fa3c83b3038ac9",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAAAcAAAAHCAYAAADEUlfTAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAgUlEQVQImX3OsQpBcQBG8d/wH1htyuCWQTYWXVZlNFlsBnkNqxfwEB5BqbuIVeoaWNQts7oDm8mNxZm+OvV1gj+Ez6hTmtBcc77yKuSY8pJtRDxlN2OQ8AwwpBMRQ4P+iHbCPkDGMSOt0bqRXjgVtwvyKr0K3TuHFflP0JwHNt+1b2iyG1DCVRiAAAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 5,
"height": 5,
"angle": 0,
"xoffset": 0,
"yoffset": 0
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 531870.79472471,
"ymin": 4809092.57982861,
"xmax": 542331.95332471,
"ymax": 4819833.37282861,
"spatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "ENTNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "FLUSHING_ZONE",
"type": "esriFieldTypeString",
"alias": "FLUSHING_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_MANAGER",
"type": "esriFieldTypeString",
"alias": "ASSET_MANAGER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_MANAGER",
"description": "City groups responsible for managing / budgeting for assets",
"codedValues": [
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facilities",
"code": "Facilities"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Storm",
"code": "Storm"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Active Transportation",
"code": "Active Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "LIFECYCLESTATUS",
"type": "esriFieldTypeString",
"alias": "LIFECYCLESTATUS",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainLifecycleStatus",
"description": "",
"codedValues": [
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Active",
"code": "Active"
},
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Never Built",
"code": "Never Built"
},
{
"name": "Split Archived",
"code": "Split Archived"
},
{
"name": "Temp",
"code": "Temp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASSET_ID",
"type": "esriFieldTypeInteger",
"alias": "ASSET_ID",
"domain": null
},
{
"name": "HYDRANT_ID",
"type": "esriFieldTypeDouble",
"alias": "HYDRANT_ID",
"domain": null
},
{
"name": "ENTNAME",
"type": "esriFieldTypeString",
"alias": "ENTNAME",
"length": 20,
"domain": null
},
{
"name": "SEGMENT_ID",
"type": "esriFieldTypeInteger",
"alias": "SEGMENT_ID",
"domain": null
},
{
"name": "VAIL_ID",
"type": "esriFieldTypeInteger",
"alias": "VAIL_ID",
"domain": null
},
{
"name": "CIVIC_ADDRESS",
"type": "esriFieldTypeString",
"alias": "CIVIC_ADDRESS",
"length": 80,
"domain": null
},
{
"name": "OWNER",
"type": "esriFieldTypeString",
"alias": "OWNER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "pws_asset_owner",
"description": "Owner of an asset ",
"codedValues": [
{
"name": "City of Waterloo",
"code": "City of Waterloo"
},
{
"name": "City of Kitchener",
"code": "City of Kitchener"
},
{
"name": "Region of Waterloo",
"code": "Region of Waterloo"
},
{
"name": "Shared with Region",
"code": "Shared with Region"
},
{
"name": "Private",
"code": "Private"
},
{
"name": "Township of Wilmot",
"code": "Township of Wilmot"
},
{
"name": "Township of Woolwich",
"code": "Township of Woolwich"
},
{
"name": "University of Waterloo",
"code": "University of Waterloo"
},
{
"name": "Region - Servicing Kitchener",
"code": "Region - Servicing Kitchener"
},
{
"name": "Grand River Conservation Authority",
"code": "GRCA"
},
{
"name": "Waterloo Region District School Board",
"code": "WRDSB"
},
{
"name": "Waterloo Catholic District School Board",
"code": "WCDSB"
},
{
"name": "City of Waterloo Property",
"code": "City of Waterloo Property"
},
{
"name": "Shared with Kitchener",
"code": "Shared with Kitchener"
},
{
"name": "Shared with Woolwich Twp",
"code": "Shared with Woolwich Twp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASBUILTNUMBER",
"type": "esriFieldTypeString",
"alias": "ASBUILTNUMBER",
"length": 50,
"domain": null
},
{
"name": "POSITION_ACCURACY",
"type": "esriFieldTypeString",
"alias": "POSITION_ACCURACY",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmnInfraPosition",
"description": "Describes positional accuracy/source of infrastructure assets",
"codedValues": [
{
"name": "Digitized +/- 2m",
"code": "Digitized +/- 2m"
},
{
"name": "Total Station +/- 0.5m",
"code": "Total Station +/- 0.5m"
},
{
"name": "AutoCAD Drawings +/- 1m",
"code": "AutoCAD Drawings +/- 1m"
},
{
"name": "Site Plan +/- 2m",
"code": "Site Plan +/- 2m"
},
{
"name": "Schematic +/- 2m",
"code": "Schematic +/- 2m"
},
{
"name": "Eng Dwg/As Built +/- 2m",
"code": "Eng Dwg/As Built +/- 2m"
},
{
"name": "GPS +/- 0.5m",
"code": "GPS +/- 0.5m"
},
{
"name": "Inferred for Inframap",
"code": "Inferred for Inframap"
},
{
"name": "Estimated/Unknown",
"code": "Estimated/Unknown"
},
{
"name": "Aerial Photo +/- 0.5m",
"code": "Aerial Photo +/- 0.5m"
},
{
"name": "Field Notes",
"code": "Field Notes"
},
{
"name": "CCTV +/- 1m",
"code": "CCTV +/- 1m"
},
{
"name": "Extended from City-owned service for Lead Project",
"code": "Extended from City-owned service for Lead Project"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "MAIN_DIAMETER",
"type": "esriFieldTypeSmallInteger",
"alias": "MAIN_DIAMETER",
"domain": {
"type": "codedValue",
"name": "wMainDiameter",
"description": "Water Distribution Main Diameter",
"codedValues": [
{
"name": "25",
"code": 25
},
{
"name": "50",
"code": 50
},
{
"name": "100",
"code": 100
},
{
"name": "150",
"code": 150
},
{
"name": "200",
"code": 200
},
{
"name": "250",
"code": 250
},
{
"name": "300",
"code": 300
},
{
"name": "400",
"code": 400
},
{
"name": "450",
"code": 450
},
{
"name": "600",
"code": 600
},
{
"name": "750",
"code": 750
},
{
"name": "350",
"code": 350
},
{
"name": "500",
"code": 500
},
{
"name": "38",
"code": 38
},
{
"name": "19",
"code": 19
},
{
"name": "900",
"code": 900
},
{
"name": "1200",
"code": 1200
},
{
"name": "999",
"code": 999
},
{
"name": "15",
"code": 15
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "HYDRANT_MAKE",
"type": "esriFieldTypeString",
"alias": "HYDRANT_MAKE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainHydrantManufacturer",
"description": "",
"codedValues": [
{
"name": "AMERD",
"code": "AMERD"
},
{
"name": "COREY",
"code": "COREY"
},
{
"name": "CLOW",
"code": "CLOW"
},
{
"name": "DRESSER",
"code": "DRESSER"
},
{
"name": "KENNEDY",
"code": "KENNEDY"
},
{
"name": "MH",
"code": "MH"
},
{
"name": "MHD",
"code": "MHD"
},
{
"name": "MULLER",
"code": "MULLER"
},
{
"name": "UNK",
"code": "UNK"
},
{
"name": "USPIPE",
"code": "USPIPE"
},
{
"name": "WOOD",
"code": "WOOD"
},
{
"name": "CENTURY",
"code": "CENTURY"
},
{
"name": "BRIGADIER",
"code": "BRIGADIER"
},
{
"name": "CAN VALVE",
"code": "CAN VALVE"
},
{
"name": "CANRON",
"code": "CANRON"
},
{
"name": "CONCORD",
"code": "CONCORD"
},
{
"name": "DARLING",
"code": "DARLING"
},
{
"name": "McAVITY",
"code": "McAVITY"
},
{
"name": "SENTINEL",
"code": "SENTINEL"
},
{
"name": "DARLING B50B",
"code": "DARLING B50B"
},
{
"name": "CONCORD DAIGLE",
"code": "CONCORD DAIGLE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "DISTANCE_HYD_TO_VALVE",
"type": "esriFieldTypeSingle",
"alias": "DISTANCE_HYD_TO_VALVE",
"domain": null
},
{
"name": "NUMBER_OF_OUTLETS",
"type": "esriFieldTypeSmallInteger",
"alias": "NUMBER_OF_OUTLETS",
"domain": null
},
{
"name": "STORTZ_CONNECTION",
"type": "esriFieldTypeString",
"alias": "STORTZ_CONNECTION",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wHydrant_YNU",
"description": "Yes No Unknown",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
},
{
"name": "Unknown",
"code": "U"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DRAINHOLES_CAPPED",
"type": "esriFieldTypeString",
"alias": "DRAINHOLES_CAPPED",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wHydrant_YNU",
"description": "Yes No Unknown",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
},
{
"name": "Unknown",
"code": "U"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "BARREL_TYPE",
"type": "esriFieldTypeString",
"alias": "BARREL_TYPE",
"length": 20,
"domain": null
},
{
"name": "ATLAS_TILE",
"type": "esriFieldTypeString",
"alias": "ATLAS_TILE",
"length": 10,
"domain": null
},
{
"name": "PRESSURE_ZONE",
"type": "esriFieldTypeString",
"alias": "PRESSURE_ZONE",
"length": 20,
"domain": null
},
{
"name": "COLOUR_CODE",
"type": "esriFieldTypeString",
"alias": "COLOUR_CODE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnHydrantColour",
"description": "Colour (=flow rate) painted on hydrants",
"codedValues": [
{
"name": "Blue",
"code": "Blue"
},
{
"name": "Green",
"code": "Green"
},
{
"name": "Orange",
"code": "Orange"
},
{
"name": "Red",
"code": "Red"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "LOCATION_DESCRIPTION",
"length": 80,
"domain": null
},
{
"name": "ASSUMPTIONSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSUMPTIONSTATUS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "InfrastructureAssumptionStatus",
"description": "",
"codedValues": [
{
"name": "Assumed by City of Waterloo",
"code": "Assumed by City of Waterloo"
},
{
"name": "NA",
"code": "NA"
},
{
"name": "On Maintenance",
"code": "On Maintenance"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STARTOFMAINTDATE",
"type": "esriFieldTypeDate",
"alias": "STARTOFMAINTDATE",
"length": 8,
"domain": null
},
{
"name": "FINALACCEPTANCEDATE",
"type": "esriFieldTypeDate",
"alias": "FINALACCEPTANCEDATE",
"length": 8,
"domain": null
},
{
"name": "REMOVED_DATE",
"type": "esriFieldTypeDate",
"alias": "REMOVED_DATE",
"length": 8,
"domain": null
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"length": 200,
"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": "CREATE_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATE_DATE",
"length": 8,
"domain": null
},
{
"name": "CREATE_USER",
"type": "esriFieldTypeString",
"alias": "CREATE_USER",
"length": 16,
"domain": null
},
{
"name": "UPDATE_DATE",
"type": "esriFieldTypeDate",
"alias": "UPDATE_DATE",
"length": 8,
"domain": null
},
{
"name": "UPDATE_USER",
"type": "esriFieldTypeString",
"alias": "UPDATE_USER",
"length": 16,
"domain": null
},
{
"name": "ACTIVITYID",
"type": "esriFieldTypeString",
"alias": "ACTIVITYID",
"length": 20,
"domain": null
},
{
"name": "LASTACTIVITY",
"type": "esriFieldTypeString",
"alias": "LASTACTIVITY",
"length": 4,
"domain": {
"type": "codedValue",
"name": "dmnHydrantActivity",
"description": "Activity performed on hydrant",
"codedValues": [
{
"name": "Installation",
"code": "INST"
},
{
"name": "Update Info",
"code": "UPDT"
},
{
"name": "Inspection",
"code": "INSP"
},
{
"name": "Fire Flow Test",
"code": "FIRE"
},
{
"name": "Paint Hydrant",
"code": "PNT"
},
{
"name": "Unidirectional Flush",
"code": "FLSH"
},
{
"name": "Repair/Replacement",
"code": "RPR"
},
{
"name": "Remove/Abandon",
"code": "ABAN"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DATESTAMP",
"type": "esriFieldTypeDate",
"alias": "DATESTAMP",
"length": 8,
"domain": null
},
{
"name": "OPTIME",
"type": "esriFieldTypeString",
"alias": "OPTIME",
"length": 5,
"domain": null
},
{
"name": "COMPUTERNAME",
"type": "esriFieldTypeString",
"alias": "COMPUTERNAME",
"length": 30,
"domain": null
},
{
"name": "OPERATEDBY",
"type": "esriFieldTypeString",
"alias": "OPERATEDBY",
"length": 30,
"domain": null
},
{
"name": "OPERATIONALSTATUS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALSTATUS",
"length": 5,
"domain": {
"type": "codedValue",
"name": "dmnOperationalStatus",
"description": "",
"codedValues": [
{
"name": "OK",
"code": "OK"
},
{
"name": "Needs Repair",
"code": "NRPR"
},
{
"name": "Inoperable",
"code": "INOP"
},
{
"name": "Unable to Locate",
"code": "UTL"
},
{
"name": "No Access",
"code": "NOAC"
},
{
"name": "Out of Service",
"code": "OOS"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STATICPSI",
"type": "esriFieldTypeSmallInteger",
"alias": "STATICPSI",
"domain": null
},
{
"name": "RESIDPSI",
"type": "esriFieldTypeSmallInteger",
"alias": "RESIDPSI",
"domain": null
},
{
"name": "PITOT",
"type": "esriFieldTypeSmallInteger",
"alias": "PITOT",
"domain": null
},
{
"name": "FLOWMINS",
"type": "esriFieldTypeString",
"alias": "FLOWMINS",
"length": 7,
"domain": null
},
{
"name": "OPERATIONCOMMENTS",
"type": "esriFieldTypeString",
"alias": "OPERATIONCOMMENTS",
"length": 200,
"domain": {
"type": "codedValue",
"name": "dmnHydrantOPComments",
"description": "Operator comments",
"codedValues": [
{
"name": "Branch valve needs service",
"code": "BranchValveNS"
},
{
"name": "Broken Barrel",
"code": "Broken Barrel"
},
{
"name": "Broken Stem",
"code": "Broken Stem"
},
{
"name": "Head Gasket",
"code": "Head Gasket"
},
{
"name": "Caps need service",
"code": "HydrantCNS"
},
{
"name": "Valve and seat need service",
"code": "HydrantVSNS"
},
{
"name": "Packing needs service",
"code": "PackingNS"
},
{
"name": "Seat Gasket",
"code": "Seat Gasket"
},
{
"name": "Valve Ball",
"code": "Valve Ball"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ISOVALVE",
"type": "esriFieldTypeString",
"alias": "ISOVALVE",
"length": 4,
"domain": null
},
{
"name": "HYDRANTREPAIRS",
"type": "esriFieldTypeString",
"alias": "HYDRANTREPAIRS",
"length": 50,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "PITOT2",
"type": "esriFieldTypeSmallInteger",
"alias": "PITOT2",
"domain": null
},
{
"name": "LINKEDDOCUMENTS",
"type": "esriFieldTypeString",
"alias": "LINKEDDOCUMENTS",
"length": 500,
"domain": null
},
{
"name": "RESIDUAL_HYDRANT",
"type": "esriFieldTypeString",
"alias": "RESIDUAL_HYDRANT",
"length": 20,
"domain": null
},
{
"name": "REPAIRS_NEEDED",
"type": "esriFieldTypeString",
"alias": "REPAIRS_NEEDED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmn_Major_Minor",
"description": "Codes of Major and Minor",
"codedValues": [
{
"name": "Major",
"code": "Major"
},
{
"name": "Minor",
"code": "Minor"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "INSTALLDATE",
"type": "esriFieldTypeDate",
"alias": "INSTALLDATE",
"length": 8,
"domain": null
},
{
"name": "HYDRANT_DRAINAGE",
"type": "esriFieldTypeString",
"alias": "HYDRANT_DRAINAGE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "HYDRANT_OPERATION_NUT",
"type": "esriFieldTypeString",
"alias": "HYDRANT_OPERATION_NUT",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnHydrant_Operation_Nut",
"description": "",
"codedValues": [
{
"name": "needs service",
"code": "needs service"
},
{
"name": "good condition",
"code": "good condition"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "HYDRANT_PAINTING",
"type": "esriFieldTypeString",
"alias": "HYDRANT_PAINTING",
"length": 3,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASSET_CLASS",
"type": "esriFieldTypeString",
"alias": "ASSET_CLASS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_CLASS",
"description": "Classes of Assets for AM",
"codedValues": [
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facility",
"code": "Facility"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Lakes",
"code": "Lakes"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Roads",
"code": "Roads"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Stormwater",
"code": "Stormwater"
},
{
"name": "Natural",
"code": "Natural"
},
{
"name": "Ponds",
"code": "Ponds"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Land / Property",
"code": "Land / Property"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VFA_CAMPUS_ID",
"type": "esriFieldTypeString",
"alias": "VFA_CAMPUS_ID",
"length": 20,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R842_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A774_IX1",
"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,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": false
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.81,
"cimVersion": "2.6.0",
"id": 6,
"name": "System Valves",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 10000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriPMS",
"url": "45e40c2ef5a230bf14138d80c2c2248f",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAuklEQVQoka3RIW5CURAF0CO+Bo1BNKlFAUHg0W0VZQHQJbABElYAJGyh1NY2VDRsowLBBkCB6Pvh5eVBSMPYmZPcmyn8c4p7wCr2OFy4rWGbg2/o4iWD2/hAB78pnOIB7wluBfRaohQeMcQiwo0IfV3qmOJPPGKQohws8RJrbPCTucnCZojaCxHTzlnYdO60DhHnWOE5xsUVVMYeYRZ2TyWOYR19fCcpjv5+PEYFuxSuMn1jPLnW8eY5AdE6Ldrv5zP2AAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 10,
"height": 10,
"angle": 0,
"xoffset": 0,
"yoffset": 0
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 531867.46262471,
"ymin": 4809245.72102861,
"xmax": 542343.77762471,
"ymax": 4819866.24292861,
"spatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "ENTNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "FLUSHING_ZONE",
"type": "esriFieldTypeString",
"alias": "FLUSHING_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_MANAGER",
"type": "esriFieldTypeString",
"alias": "ASSET_MANAGER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_MANAGER",
"description": "City groups responsible for managing / budgeting for assets",
"codedValues": [
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facilities",
"code": "Facilities"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Storm",
"code": "Storm"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Active Transportation",
"code": "Active Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "LIFECYCLESTATUS",
"type": "esriFieldTypeString",
"alias": "LifecycleStatus",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainLifecycleStatus",
"description": "",
"codedValues": [
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Active",
"code": "Active"
},
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Never Built",
"code": "Never Built"
},
{
"name": "Split Archived",
"code": "Split Archived"
},
{
"name": "Temp",
"code": "Temp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "INSTALLDATE",
"type": "esriFieldTypeDate",
"alias": "INSTALLDATE",
"length": 8,
"domain": null
},
{
"name": "VALVE_FUNCTION",
"type": "esriFieldTypeString",
"alias": "VALVE_FUNCTION",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wValve_Function",
"description": "Function/Purpose of a water valve",
"codedValues": [
{
"name": "Control Valve",
"code": "Control Valve"
},
{
"name": "Flushing Valve",
"code": "Flushing Valve"
},
{
"name": "Hydrant Valve",
"code": "Hydrant Valve"
},
{
"name": "Main Valve",
"code": "Main Valve"
},
{
"name": "Service Valve",
"code": "Service Valve"
},
{
"name": "Bypass Valve",
"code": "Bypass Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_TYPE",
"type": "esriFieldTypeString",
"alias": "VALVE_TYPE",
"length": 30,
"domain": {
"type": "codedValue",
"name": "wValve_Type",
"description": "Type of a water valve",
"codedValues": [
{
"name": "Butterfly Valve",
"code": "Butterfly Valve"
},
{
"name": "Curb Stop",
"code": "Curb Stop"
},
{
"name": "Gate Valve",
"code": "Gate Valve"
},
{
"name": "Valve in Chamber",
"code": "Valve in Chamber"
},
{
"name": "Air Release Valve",
"code": "Air Release Valve"
},
{
"name": "Pressure Release Valve",
"code": "Pressure Release Valve"
},
{
"name": "Air & Vacuum Release Valve",
"code": "Air & Vacuum Release Valve"
},
{
"name": "Vacuum Release Valve",
"code": "Vacuum Release Valve"
},
{
"name": "Drain Valve",
"code": "Drain Valve"
},
{
"name": "Check Valve",
"code": "Check Valve"
},
{
"name": "Motorized Control Valve",
"code": "Motorized Control Valve"
},
{
"name": "Tapping Valve",
"code": "Tapping Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ASSET_ID",
"type": "esriFieldTypeInteger",
"alias": "ASSET_ID",
"domain": null
},
{
"name": "ENTNAME",
"type": "esriFieldTypeString",
"alias": "ENTNAME",
"length": 50,
"domain": null
},
{
"name": "SEGMENT_ID",
"type": "esriFieldTypeInteger",
"alias": "SEGMENT_ID",
"domain": null
},
{
"name": "VAIL_ID",
"type": "esriFieldTypeInteger",
"alias": "VAIL_ID",
"domain": null
},
{
"name": "CIVIC_ADDRESS",
"type": "esriFieldTypeString",
"alias": "CIVIC_ADDRESS",
"length": 80,
"domain": null
},
{
"name": "OWNER",
"type": "esriFieldTypeString",
"alias": "OWNER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "pws_asset_owner",
"description": "Owner of an asset ",
"codedValues": [
{
"name": "City of Waterloo",
"code": "City of Waterloo"
},
{
"name": "City of Kitchener",
"code": "City of Kitchener"
},
{
"name": "Region of Waterloo",
"code": "Region of Waterloo"
},
{
"name": "Shared with Region",
"code": "Shared with Region"
},
{
"name": "Private",
"code": "Private"
},
{
"name": "Township of Wilmot",
"code": "Township of Wilmot"
},
{
"name": "Township of Woolwich",
"code": "Township of Woolwich"
},
{
"name": "University of Waterloo",
"code": "University of Waterloo"
},
{
"name": "Region - Servicing Kitchener",
"code": "Region - Servicing Kitchener"
},
{
"name": "Grand River Conservation Authority",
"code": "GRCA"
},
{
"name": "Waterloo Region District School Board",
"code": "WRDSB"
},
{
"name": "Waterloo Catholic District School Board",
"code": "WCDSB"
},
{
"name": "City of Waterloo Property",
"code": "City of Waterloo Property"
},
{
"name": "Shared with Kitchener",
"code": "Shared with Kitchener"
},
{
"name": "Shared with Woolwich Twp",
"code": "Shared with Woolwich Twp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VALVE_MAKE",
"type": "esriFieldTypeString",
"alias": "VALVE_MAKE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainHydrantManufacturer",
"description": "",
"codedValues": [
{
"name": "AMERD",
"code": "AMERD"
},
{
"name": "COREY",
"code": "COREY"
},
{
"name": "CLOW",
"code": "CLOW"
},
{
"name": "DRESSER",
"code": "DRESSER"
},
{
"name": "KENNEDY",
"code": "KENNEDY"
},
{
"name": "MH",
"code": "MH"
},
{
"name": "MHD",
"code": "MHD"
},
{
"name": "MULLER",
"code": "MULLER"
},
{
"name": "UNK",
"code": "UNK"
},
{
"name": "USPIPE",
"code": "USPIPE"
},
{
"name": "WOOD",
"code": "WOOD"
},
{
"name": "CENTURY",
"code": "CENTURY"
},
{
"name": "BRIGADIER",
"code": "BRIGADIER"
},
{
"name": "CAN VALVE",
"code": "CAN VALVE"
},
{
"name": "CANRON",
"code": "CANRON"
},
{
"name": "CONCORD",
"code": "CONCORD"
},
{
"name": "DARLING",
"code": "DARLING"
},
{
"name": "McAVITY",
"code": "McAVITY"
},
{
"name": "SENTINEL",
"code": "SENTINEL"
},
{
"name": "DARLING B50B",
"code": "DARLING B50B"
},
{
"name": "CONCORD DAIGLE",
"code": "CONCORD DAIGLE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASBUILTNUMBER",
"type": "esriFieldTypeString",
"alias": "ASBUILTNUMBER",
"length": 50,
"domain": null
},
{
"name": "POSITION_ACCURACY",
"type": "esriFieldTypeString",
"alias": "POSITION_ACCURACY",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmnInfraPosition",
"description": "Describes positional accuracy/source of infrastructure assets",
"codedValues": [
{
"name": "Digitized +/- 2m",
"code": "Digitized +/- 2m"
},
{
"name": "Total Station +/- 0.5m",
"code": "Total Station +/- 0.5m"
},
{
"name": "AutoCAD Drawings +/- 1m",
"code": "AutoCAD Drawings +/- 1m"
},
{
"name": "Site Plan +/- 2m",
"code": "Site Plan +/- 2m"
},
{
"name": "Schematic +/- 2m",
"code": "Schematic +/- 2m"
},
{
"name": "Eng Dwg/As Built +/- 2m",
"code": "Eng Dwg/As Built +/- 2m"
},
{
"name": "GPS +/- 0.5m",
"code": "GPS +/- 0.5m"
},
{
"name": "Inferred for Inframap",
"code": "Inferred for Inframap"
},
{
"name": "Estimated/Unknown",
"code": "Estimated/Unknown"
},
{
"name": "Aerial Photo +/- 0.5m",
"code": "Aerial Photo +/- 0.5m"
},
{
"name": "Field Notes",
"code": "Field Notes"
},
{
"name": "CCTV +/- 1m",
"code": "CCTV +/- 1m"
},
{
"name": "Extended from City-owned service for Lead Project",
"code": "Extended from City-owned service for Lead Project"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DIAMETER",
"type": "esriFieldTypeSmallInteger",
"alias": "DIAMETER",
"domain": {
"type": "codedValue",
"name": "wMainDiameter",
"description": "Water Distribution Main Diameter",
"codedValues": [
{
"name": "25",
"code": 25
},
{
"name": "50",
"code": 50
},
{
"name": "100",
"code": 100
},
{
"name": "150",
"code": 150
},
{
"name": "200",
"code": 200
},
{
"name": "250",
"code": 250
},
{
"name": "300",
"code": 300
},
{
"name": "400",
"code": 400
},
{
"name": "450",
"code": 450
},
{
"name": "600",
"code": 600
},
{
"name": "750",
"code": 750
},
{
"name": "350",
"code": 350
},
{
"name": "500",
"code": 500
},
{
"name": "38",
"code": 38
},
{
"name": "19",
"code": 19
},
{
"name": "900",
"code": 900
},
{
"name": "1200",
"code": 1200
},
{
"name": "999",
"code": 999
},
{
"name": "15",
"code": 15
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "LOCATIONDESCRIPTION",
"type": "esriFieldTypeString",
"alias": "LOCATIONDESCRIPTION",
"length": 200,
"domain": null
},
{
"name": "ASSUMPTIONSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSUMPTIONSTATUS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "InfrastructureAssumptionStatus",
"description": "",
"codedValues": [
{
"name": "Assumed by City of Waterloo",
"code": "Assumed by City of Waterloo"
},
{
"name": "NA",
"code": "NA"
},
{
"name": "On Maintenance",
"code": "On Maintenance"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STARTOFMAINTDATE",
"type": "esriFieldTypeDate",
"alias": "STARTOFMAINTDATE",
"length": 8,
"domain": null
},
{
"name": "FINALACCEPTANCEDATE",
"type": "esriFieldTypeDate",
"alias": "FINALACCEPTANCEDATE",
"length": 8,
"domain": null
},
{
"name": "REMOVED_DATE",
"type": "esriFieldTypeDate",
"alias": "REMOVED_DATE",
"length": 8,
"domain": null
},
{
"name": "OPENSTATUS",
"type": "esriFieldTypeString",
"alias": "OPENSTATUS",
"length": 6,
"domain": {
"type": "codedValue",
"name": "wValve_OpenStatus",
"description": "current status of a water valve (not necessarily = normal status)",
"codedValues": [
{
"name": "Open",
"code": "Open"
},
{
"name": "Closed",
"code": "Closed"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ROTATION",
"type": "esriFieldTypeDouble",
"alias": "ROTATION",
"domain": null
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"length": 50,
"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": "SURFACE_ELEVATION",
"type": "esriFieldTypeDouble",
"alias": "SURFACE_ELEVATION",
"domain": null
},
{
"name": "CREATE_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATE_DATE",
"length": 8,
"domain": null
},
{
"name": "CREATE_USER",
"type": "esriFieldTypeString",
"alias": "CREATE_USER",
"length": 16,
"domain": null
},
{
"name": "UPDATE_DATE",
"type": "esriFieldTypeDate",
"alias": "UPDATE_DATE",
"length": 8,
"domain": null
},
{
"name": "UPDATE_USER",
"type": "esriFieldTypeString",
"alias": "UPDATE_USER",
"length": 16,
"domain": null
},
{
"name": "ACTIVITYID",
"type": "esriFieldTypeString",
"alias": "ACTIVITYID",
"length": 20,
"domain": null
},
{
"name": "LASTACTIVITY",
"type": "esriFieldTypeString",
"alias": "LASTACTIVITY",
"length": 4,
"domain": {
"type": "codedValue",
"name": "dmnValveActivity",
"description": "",
"codedValues": [
{
"name": "Installation",
"code": "INST"
},
{
"name": "Update Info",
"code": "UPDT"
},
{
"name": "Exercise Valve",
"code": "EXE"
},
{
"name": "Line Shutdown",
"code": "CLS"
},
{
"name": "Line Reopen",
"code": "OPN"
},
{
"name": "Remove/Abandon",
"code": "ABAN"
},
{
"name": "Pressure Valve Pumping",
"code": "PRV"
},
{
"name": "Repair",
"code": "RPR"
},
{
"name": "Valve Inspection",
"code": "FVI"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DATESTAMP",
"type": "esriFieldTypeDate",
"alias": "DATESTAMP",
"length": 8,
"domain": null
},
{
"name": "OPTIME",
"type": "esriFieldTypeString",
"alias": "OPTIME",
"length": 5,
"domain": null
},
{
"name": "COMPUTERNAME",
"type": "esriFieldTypeString",
"alias": "COMPUTERNAME",
"length": 30,
"domain": null
},
{
"name": "OPERATEDBY",
"type": "esriFieldTypeString",
"alias": "OPERATEDBY",
"length": 30,
"domain": null
},
{
"name": "OPERATIONALSTATUS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALSTATUS",
"length": 10,
"domain": {
"type": "codedValue",
"name": "dmnOperationalStatus",
"description": "",
"codedValues": [
{
"name": "OK",
"code": "OK"
},
{
"name": "Needs Repair",
"code": "NRPR"
},
{
"name": "Inoperable",
"code": "INOP"
},
{
"name": "Unable to Locate",
"code": "UTL"
},
{
"name": "No Access",
"code": "NOAC"
},
{
"name": "Out of Service",
"code": "OOS"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "TURNTOOPERATE",
"type": "esriFieldTypeDouble",
"alias": "TURNTOOPERATE",
"domain": null
},
{
"name": "DEPTH",
"type": "esriFieldTypeDouble",
"alias": "DEPTH",
"domain": null
},
{
"name": "GPSX",
"type": "esriFieldTypeDouble",
"alias": "GPSX",
"domain": null
},
{
"name": "GPSY",
"type": "esriFieldTypeDouble",
"alias": "GPSY",
"domain": null
},
{
"name": "LINKEDDOCUMENTS",
"type": "esriFieldTypeString",
"alias": "LINKEDDOCUMENTS",
"length": 500,
"domain": null
},
{
"name": "OPERATIONALCOMMENTS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALCOMMENTS",
"length": 200,
"domain": null
},
{
"name": "CLOCKWISETOCLOSE",
"type": "esriFieldTypeString",
"alias": "CLOCKWISETOCLOSE",
"length": 4,
"domain": null
},
{
"name": "UPDATEGPS",
"type": "esriFieldTypeString",
"alias": "UPDATEGPS",
"length": 4,
"domain": null
},
{
"name": "MANUALTURN",
"type": "esriFieldTypeString",
"alias": "MANUALTURN",
"length": 1,
"domain": {
"type": "codedValue",
"name": "boolean_text_single",
"description": "Codes Y and N for YES and NO",
"codedValues": [
{
"name": "Y",
"code": "Y"
},
{
"name": "N",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"length": 80,
"domain": null
},
{
"name": "HIGHTORQUE",
"type": "esriFieldTypeSmallInteger",
"alias": "HIGHTORQUE",
"domain": null
},
{
"name": "TORQUEDATA",
"type": "esriFieldTypeString",
"alias": "TORQUEDATA",
"length": 1073741822,
"domain": null
},
{
"name": "GLAND_LEAK",
"type": "esriFieldTypeString",
"alias": "GLAND_LEAK",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnGlandLeak",
"description": "water system valves",
"codedValues": [
{
"name": "No gland leak",
"code": "No gland leak"
},
{
"name": "Steady",
"code": "Steady"
},
{
"name": "Stops when jammed",
"code": "Stops when jammed"
},
{
"name": "Not inspected",
"code": "Not inspected"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OPERATING_NUT",
"type": "esriFieldTypeString",
"alias": "OPERATING_NUT",
"length": 16,
"domain": {
"type": "codedValue",
"name": "dmnOperatingNut",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Broken Off",
"code": "Broken Off"
},
{
"name": "Rounded",
"code": "Rounded"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Broken, spins",
"code": "Broken, spins"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_BROKEN",
"type": "esriFieldTypeString",
"alias": "VALVE_BROKEN",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnValveBroken",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Valve Broken Open",
"code": "Valve Broken Open"
},
{
"name": "Valve Broken Closed",
"code": "Valve Broken Closed"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Seized",
"code": "Seized"
},
{
"name": "Stiff",
"code": "Stiff"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_BOX",
"type": "esriFieldTypeString",
"alias": "VALVE_BOX",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnValveBox",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Valve Box Broken",
"code": "Valve Box Broken"
},
{
"name": "Valve Box Shifted",
"code": "Valve Box Shifted"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Valve Box is raised",
"code": "Raised Valve Box"
},
{
"name": "Mud/Water/Debris",
"code": "Mud and Debris"
},
{
"name": "New Lid Needed",
"code": "New Lid Needed"
},
{
"name": "Valve Box is low",
"code": "Lowered Valve Box"
},
{
"name": "Screw Top Broken",
"code": "Screw Top Broken"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_TURNS",
"type": "esriFieldTypeString",
"alias": "VALVE_TURNS",
"length": 12,
"domain": {
"type": "codedValue",
"name": "dmnValveTurns",
"description": "water system valves",
"codedValues": [
{
"name": "Normal",
"code": "Normal"
},
{
"name": "Above Normal",
"code": "Above Normal"
},
{
"name": "Below Normal",
"code": "Below Normal"
},
{
"name": "Undetermined",
"code": "Undetermined"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_PRIORITY",
"type": "esriFieldTypeString",
"alias": "VALVE_PRIORITY",
"length": 12,
"domain": {
"type": "codedValue",
"name": "dmnValvePriority",
"description": "water system valves",
"codedValues": [
{
"name": "Low",
"code": "Low"
},
{
"name": "Medium",
"code": "Medium"
},
{
"name": "High",
"code": "High"
},
{
"name": "Very High",
"code": "Very High"
},
{
"name": "Top Priority",
"code": "Top Priority"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_ACTION",
"type": "esriFieldTypeString",
"alias": "VALVE_ACTION",
"length": 30,
"domain": null
},
{
"name": "PRESSURE_ZONE",
"type": "esriFieldTypeString",
"alias": "PRESSURE_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_CLASS",
"type": "esriFieldTypeString",
"alias": "ASSET_CLASS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_CLASS",
"description": "Classes of Assets for AM",
"codedValues": [
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facility",
"code": "Facility"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Lakes",
"code": "Lakes"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Roads",
"code": "Roads"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Stormwater",
"code": "Stormwater"
},
{
"name": "Natural",
"code": "Natural"
},
{
"name": "Ponds",
"code": "Ponds"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Land / Property",
"code": "Land / Property"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VFA_CAMPUS_ID",
"type": "esriFieldTypeString",
"alias": "VFA_CAMPUS_ID",
"length": 20,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R846_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A778_IX1",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "SDE_USER.wValveActivity",
"relatedTableId": 17,
"role": "esriRelRoleOrigin",
"keyField": "ASSET_ID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"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,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": false
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.81,
"cimVersion": "2.6.0",
"id": 7,
"name": "Curb Stop Valve",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 5000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
0,
197,
255,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": null
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 531867.46262471,
"ymin": 4809245.72102861,
"xmax": 542343.77762471,
"ymax": 4819866.24292861,
"spatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "ENTNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "FLUSHING_ZONE",
"type": "esriFieldTypeString",
"alias": "FLUSHING_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_MANAGER",
"type": "esriFieldTypeString",
"alias": "ASSET_MANAGER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_MANAGER",
"description": "City groups responsible for managing / budgeting for assets",
"codedValues": [
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facilities",
"code": "Facilities"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Storm",
"code": "Storm"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Active Transportation",
"code": "Active Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "LIFECYCLESTATUS",
"type": "esriFieldTypeString",
"alias": "LifecycleStatus",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainLifecycleStatus",
"description": "",
"codedValues": [
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Active",
"code": "Active"
},
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Never Built",
"code": "Never Built"
},
{
"name": "Split Archived",
"code": "Split Archived"
},
{
"name": "Temp",
"code": "Temp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "INSTALLDATE",
"type": "esriFieldTypeDate",
"alias": "INSTALLDATE",
"length": 8,
"domain": null
},
{
"name": "VALVE_FUNCTION",
"type": "esriFieldTypeString",
"alias": "VALVE_FUNCTION",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wValve_Function",
"description": "Function/Purpose of a water valve",
"codedValues": [
{
"name": "Control Valve",
"code": "Control Valve"
},
{
"name": "Flushing Valve",
"code": "Flushing Valve"
},
{
"name": "Hydrant Valve",
"code": "Hydrant Valve"
},
{
"name": "Main Valve",
"code": "Main Valve"
},
{
"name": "Service Valve",
"code": "Service Valve"
},
{
"name": "Bypass Valve",
"code": "Bypass Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_TYPE",
"type": "esriFieldTypeString",
"alias": "VALVE_TYPE",
"length": 30,
"domain": {
"type": "codedValue",
"name": "wValve_Type",
"description": "Type of a water valve",
"codedValues": [
{
"name": "Butterfly Valve",
"code": "Butterfly Valve"
},
{
"name": "Curb Stop",
"code": "Curb Stop"
},
{
"name": "Gate Valve",
"code": "Gate Valve"
},
{
"name": "Valve in Chamber",
"code": "Valve in Chamber"
},
{
"name": "Air Release Valve",
"code": "Air Release Valve"
},
{
"name": "Pressure Release Valve",
"code": "Pressure Release Valve"
},
{
"name": "Air & Vacuum Release Valve",
"code": "Air & Vacuum Release Valve"
},
{
"name": "Vacuum Release Valve",
"code": "Vacuum Release Valve"
},
{
"name": "Drain Valve",
"code": "Drain Valve"
},
{
"name": "Check Valve",
"code": "Check Valve"
},
{
"name": "Motorized Control Valve",
"code": "Motorized Control Valve"
},
{
"name": "Tapping Valve",
"code": "Tapping Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ASSET_ID",
"type": "esriFieldTypeInteger",
"alias": "ASSET_ID",
"domain": null
},
{
"name": "ENTNAME",
"type": "esriFieldTypeString",
"alias": "ENTNAME",
"length": 50,
"domain": null
},
{
"name": "SEGMENT_ID",
"type": "esriFieldTypeInteger",
"alias": "SEGMENT_ID",
"domain": null
},
{
"name": "VAIL_ID",
"type": "esriFieldTypeInteger",
"alias": "VAIL_ID",
"domain": null
},
{
"name": "CIVIC_ADDRESS",
"type": "esriFieldTypeString",
"alias": "CIVIC_ADDRESS",
"length": 80,
"domain": null
},
{
"name": "OWNER",
"type": "esriFieldTypeString",
"alias": "OWNER",
"length": 30,
"domain": {
"type": "codedValue",
"name": "pws_asset_owner",
"description": "Owner of an asset ",
"codedValues": [
{
"name": "City of Waterloo",
"code": "City of Waterloo"
},
{
"name": "City of Kitchener",
"code": "City of Kitchener"
},
{
"name": "Region of Waterloo",
"code": "Region of Waterloo"
},
{
"name": "Shared with Region",
"code": "Shared with Region"
},
{
"name": "Private",
"code": "Private"
},
{
"name": "Township of Wilmot",
"code": "Township of Wilmot"
},
{
"name": "Township of Woolwich",
"code": "Township of Woolwich"
},
{
"name": "University of Waterloo",
"code": "University of Waterloo"
},
{
"name": "Region - Servicing Kitchener",
"code": "Region - Servicing Kitchener"
},
{
"name": "Grand River Conservation Authority",
"code": "GRCA"
},
{
"name": "Waterloo Region District School Board",
"code": "WRDSB"
},
{
"name": "Waterloo Catholic District School Board",
"code": "WCDSB"
},
{
"name": "City of Waterloo Property",
"code": "City of Waterloo Property"
},
{
"name": "Shared with Kitchener",
"code": "Shared with Kitchener"
},
{
"name": "Shared with Woolwich Twp",
"code": "Shared with Woolwich Twp"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VALVE_MAKE",
"type": "esriFieldTypeString",
"alias": "VALVE_MAKE",
"length": 20,
"domain": {
"type": "codedValue",
"name": "wDomainHydrantManufacturer",
"description": "",
"codedValues": [
{
"name": "AMERD",
"code": "AMERD"
},
{
"name": "COREY",
"code": "COREY"
},
{
"name": "CLOW",
"code": "CLOW"
},
{
"name": "DRESSER",
"code": "DRESSER"
},
{
"name": "KENNEDY",
"code": "KENNEDY"
},
{
"name": "MH",
"code": "MH"
},
{
"name": "MHD",
"code": "MHD"
},
{
"name": "MULLER",
"code": "MULLER"
},
{
"name": "UNK",
"code": "UNK"
},
{
"name": "USPIPE",
"code": "USPIPE"
},
{
"name": "WOOD",
"code": "WOOD"
},
{
"name": "CENTURY",
"code": "CENTURY"
},
{
"name": "BRIGADIER",
"code": "BRIGADIER"
},
{
"name": "CAN VALVE",
"code": "CAN VALVE"
},
{
"name": "CANRON",
"code": "CANRON"
},
{
"name": "CONCORD",
"code": "CONCORD"
},
{
"name": "DARLING",
"code": "DARLING"
},
{
"name": "McAVITY",
"code": "McAVITY"
},
{
"name": "SENTINEL",
"code": "SENTINEL"
},
{
"name": "DARLING B50B",
"code": "DARLING B50B"
},
{
"name": "CONCORD DAIGLE",
"code": "CONCORD DAIGLE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ASBUILTNUMBER",
"type": "esriFieldTypeString",
"alias": "ASBUILTNUMBER",
"length": 50,
"domain": null
},
{
"name": "POSITION_ACCURACY",
"type": "esriFieldTypeString",
"alias": "POSITION_ACCURACY",
"length": 50,
"domain": {
"type": "codedValue",
"name": "dmnInfraPosition",
"description": "Describes positional accuracy/source of infrastructure assets",
"codedValues": [
{
"name": "Digitized +/- 2m",
"code": "Digitized +/- 2m"
},
{
"name": "Total Station +/- 0.5m",
"code": "Total Station +/- 0.5m"
},
{
"name": "AutoCAD Drawings +/- 1m",
"code": "AutoCAD Drawings +/- 1m"
},
{
"name": "Site Plan +/- 2m",
"code": "Site Plan +/- 2m"
},
{
"name": "Schematic +/- 2m",
"code": "Schematic +/- 2m"
},
{
"name": "Eng Dwg/As Built +/- 2m",
"code": "Eng Dwg/As Built +/- 2m"
},
{
"name": "GPS +/- 0.5m",
"code": "GPS +/- 0.5m"
},
{
"name": "Inferred for Inframap",
"code": "Inferred for Inframap"
},
{
"name": "Estimated/Unknown",
"code": "Estimated/Unknown"
},
{
"name": "Aerial Photo +/- 0.5m",
"code": "Aerial Photo +/- 0.5m"
},
{
"name": "Field Notes",
"code": "Field Notes"
},
{
"name": "CCTV +/- 1m",
"code": "CCTV +/- 1m"
},
{
"name": "Extended from City-owned service for Lead Project",
"code": "Extended from City-owned service for Lead Project"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DIAMETER",
"type": "esriFieldTypeSmallInteger",
"alias": "DIAMETER",
"domain": {
"type": "codedValue",
"name": "wMainDiameter",
"description": "Water Distribution Main Diameter",
"codedValues": [
{
"name": "25",
"code": 25
},
{
"name": "50",
"code": 50
},
{
"name": "100",
"code": 100
},
{
"name": "150",
"code": 150
},
{
"name": "200",
"code": 200
},
{
"name": "250",
"code": 250
},
{
"name": "300",
"code": 300
},
{
"name": "400",
"code": 400
},
{
"name": "450",
"code": 450
},
{
"name": "600",
"code": 600
},
{
"name": "750",
"code": 750
},
{
"name": "350",
"code": 350
},
{
"name": "500",
"code": 500
},
{
"name": "38",
"code": 38
},
{
"name": "19",
"code": 19
},
{
"name": "900",
"code": 900
},
{
"name": "1200",
"code": 1200
},
{
"name": "999",
"code": 999
},
{
"name": "15",
"code": 15
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "LOCATIONDESCRIPTION",
"type": "esriFieldTypeString",
"alias": "LOCATIONDESCRIPTION",
"length": 200,
"domain": null
},
{
"name": "ASSUMPTIONSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSUMPTIONSTATUS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "InfrastructureAssumptionStatus",
"description": "",
"codedValues": [
{
"name": "Assumed by City of Waterloo",
"code": "Assumed by City of Waterloo"
},
{
"name": "NA",
"code": "NA"
},
{
"name": "On Maintenance",
"code": "On Maintenance"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STARTOFMAINTDATE",
"type": "esriFieldTypeDate",
"alias": "STARTOFMAINTDATE",
"length": 8,
"domain": null
},
{
"name": "FINALACCEPTANCEDATE",
"type": "esriFieldTypeDate",
"alias": "FINALACCEPTANCEDATE",
"length": 8,
"domain": null
},
{
"name": "REMOVED_DATE",
"type": "esriFieldTypeDate",
"alias": "REMOVED_DATE",
"length": 8,
"domain": null
},
{
"name": "OPENSTATUS",
"type": "esriFieldTypeString",
"alias": "OPENSTATUS",
"length": 6,
"domain": {
"type": "codedValue",
"name": "wValve_OpenStatus",
"description": "current status of a water valve (not necessarily = normal status)",
"codedValues": [
{
"name": "Open",
"code": "Open"
},
{
"name": "Closed",
"code": "Closed"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ROTATION",
"type": "esriFieldTypeDouble",
"alias": "ROTATION",
"domain": null
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"length": 50,
"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": "SURFACE_ELEVATION",
"type": "esriFieldTypeDouble",
"alias": "SURFACE_ELEVATION",
"domain": null
},
{
"name": "CREATE_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATE_DATE",
"length": 8,
"domain": null
},
{
"name": "CREATE_USER",
"type": "esriFieldTypeString",
"alias": "CREATE_USER",
"length": 16,
"domain": null
},
{
"name": "UPDATE_DATE",
"type": "esriFieldTypeDate",
"alias": "UPDATE_DATE",
"length": 8,
"domain": null
},
{
"name": "UPDATE_USER",
"type": "esriFieldTypeString",
"alias": "UPDATE_USER",
"length": 16,
"domain": null
},
{
"name": "ACTIVITYID",
"type": "esriFieldTypeString",
"alias": "ACTIVITYID",
"length": 20,
"domain": null
},
{
"name": "LASTACTIVITY",
"type": "esriFieldTypeString",
"alias": "LASTACTIVITY",
"length": 4,
"domain": {
"type": "codedValue",
"name": "dmnValveActivity",
"description": "",
"codedValues": [
{
"name": "Installation",
"code": "INST"
},
{
"name": "Update Info",
"code": "UPDT"
},
{
"name": "Exercise Valve",
"code": "EXE"
},
{
"name": "Line Shutdown",
"code": "CLS"
},
{
"name": "Line Reopen",
"code": "OPN"
},
{
"name": "Remove/Abandon",
"code": "ABAN"
},
{
"name": "Pressure Valve Pumping",
"code": "PRV"
},
{
"name": "Repair",
"code": "RPR"
},
{
"name": "Valve Inspection",
"code": "FVI"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DATESTAMP",
"type": "esriFieldTypeDate",
"alias": "DATESTAMP",
"length": 8,
"domain": null
},
{
"name": "OPTIME",
"type": "esriFieldTypeString",
"alias": "OPTIME",
"length": 5,
"domain": null
},
{
"name": "COMPUTERNAME",
"type": "esriFieldTypeString",
"alias": "COMPUTERNAME",
"length": 30,
"domain": null
},
{
"name": "OPERATEDBY",
"type": "esriFieldTypeString",
"alias": "OPERATEDBY",
"length": 30,
"domain": null
},
{
"name": "OPERATIONALSTATUS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALSTATUS",
"length": 10,
"domain": {
"type": "codedValue",
"name": "dmnOperationalStatus",
"description": "",
"codedValues": [
{
"name": "OK",
"code": "OK"
},
{
"name": "Needs Repair",
"code": "NRPR"
},
{
"name": "Inoperable",
"code": "INOP"
},
{
"name": "Unable to Locate",
"code": "UTL"
},
{
"name": "No Access",
"code": "NOAC"
},
{
"name": "Out of Service",
"code": "OOS"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "TURNTOOPERATE",
"type": "esriFieldTypeDouble",
"alias": "TURNTOOPERATE",
"domain": null
},
{
"name": "DEPTH",
"type": "esriFieldTypeDouble",
"alias": "DEPTH",
"domain": null
},
{
"name": "GPSX",
"type": "esriFieldTypeDouble",
"alias": "GPSX",
"domain": null
},
{
"name": "GPSY",
"type": "esriFieldTypeDouble",
"alias": "GPSY",
"domain": null
},
{
"name": "LINKEDDOCUMENTS",
"type": "esriFieldTypeString",
"alias": "LINKEDDOCUMENTS",
"length": 500,
"domain": null
},
{
"name": "OPERATIONALCOMMENTS",
"type": "esriFieldTypeString",
"alias": "OPERATIONALCOMMENTS",
"length": 200,
"domain": null
},
{
"name": "CLOCKWISETOCLOSE",
"type": "esriFieldTypeString",
"alias": "CLOCKWISETOCLOSE",
"length": 4,
"domain": null
},
{
"name": "UPDATEGPS",
"type": "esriFieldTypeString",
"alias": "UPDATEGPS",
"length": 4,
"domain": null
},
{
"name": "MANUALTURN",
"type": "esriFieldTypeString",
"alias": "MANUALTURN",
"length": 1,
"domain": {
"type": "codedValue",
"name": "boolean_text_single",
"description": "Codes Y and N for YES and NO",
"codedValues": [
{
"name": "Y",
"code": "Y"
},
{
"name": "N",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"length": 80,
"domain": null
},
{
"name": "HIGHTORQUE",
"type": "esriFieldTypeSmallInteger",
"alias": "HIGHTORQUE",
"domain": null
},
{
"name": "TORQUEDATA",
"type": "esriFieldTypeString",
"alias": "TORQUEDATA",
"length": 1073741822,
"domain": null
},
{
"name": "GLAND_LEAK",
"type": "esriFieldTypeString",
"alias": "GLAND_LEAK",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnGlandLeak",
"description": "water system valves",
"codedValues": [
{
"name": "No gland leak",
"code": "No gland leak"
},
{
"name": "Steady",
"code": "Steady"
},
{
"name": "Stops when jammed",
"code": "Stops when jammed"
},
{
"name": "Not inspected",
"code": "Not inspected"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OPERATING_NUT",
"type": "esriFieldTypeString",
"alias": "OPERATING_NUT",
"length": 16,
"domain": {
"type": "codedValue",
"name": "dmnOperatingNut",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Broken Off",
"code": "Broken Off"
},
{
"name": "Rounded",
"code": "Rounded"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Broken, spins",
"code": "Broken, spins"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_BROKEN",
"type": "esriFieldTypeString",
"alias": "VALVE_BROKEN",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnValveBroken",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Valve Broken Open",
"code": "Valve Broken Open"
},
{
"name": "Valve Broken Closed",
"code": "Valve Broken Closed"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Seized",
"code": "Seized"
},
{
"name": "Stiff",
"code": "Stiff"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_BOX",
"type": "esriFieldTypeString",
"alias": "VALVE_BOX",
"length": 20,
"domain": {
"type": "codedValue",
"name": "dmnValveBox",
"description": "water system valves",
"codedValues": [
{
"name": "Good Condition",
"code": "Good Condition"
},
{
"name": "Valve Box Broken",
"code": "Valve Box Broken"
},
{
"name": "Valve Box Shifted",
"code": "Valve Box Shifted"
},
{
"name": "Not inspected",
"code": "Not inspected"
},
{
"name": "Valve Box is raised",
"code": "Raised Valve Box"
},
{
"name": "Mud/Water/Debris",
"code": "Mud and Debris"
},
{
"name": "New Lid Needed",
"code": "New Lid Needed"
},
{
"name": "Valve Box is low",
"code": "Lowered Valve Box"
},
{
"name": "Screw Top Broken",
"code": "Screw Top Broken"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_TURNS",
"type": "esriFieldTypeString",
"alias": "VALVE_TURNS",
"length": 12,
"domain": {
"type": "codedValue",
"name": "dmnValveTurns",
"description": "water system valves",
"codedValues": [
{
"name": "Normal",
"code": "Normal"
},
{
"name": "Above Normal",
"code": "Above Normal"
},
{
"name": "Below Normal",
"code": "Below Normal"
},
{
"name": "Undetermined",
"code": "Undetermined"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_PRIORITY",
"type": "esriFieldTypeString",
"alias": "VALVE_PRIORITY",
"length": 12,
"domain": {
"type": "codedValue",
"name": "dmnValvePriority",
"description": "water system valves",
"codedValues": [
{
"name": "Low",
"code": "Low"
},
{
"name": "Medium",
"code": "Medium"
},
{
"name": "High",
"code": "High"
},
{
"name": "Very High",
"code": "Very High"
},
{
"name": "Top Priority",
"code": "Top Priority"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "VALVE_ACTION",
"type": "esriFieldTypeString",
"alias": "VALVE_ACTION",
"length": 30,
"domain": null
},
{
"name": "PRESSURE_ZONE",
"type": "esriFieldTypeString",
"alias": "PRESSURE_ZONE",
"length": 20,
"domain": null
},
{
"name": "ASSET_CLASS",
"type": "esriFieldTypeString",
"alias": "ASSET_CLASS",
"length": 30,
"domain": {
"type": "codedValue",
"name": "ASSET_CLASS",
"description": "Classes of Assets for AM",
"codedValues": [
{
"name": "Bridges",
"code": "Bridges"
},
{
"name": "BIA",
"code": "BIA"
},
{
"name": "Cemeteries",
"code": "Cemeteries"
},
{
"name": "Facility",
"code": "Facility"
},
{
"name": "Fire",
"code": "Fire"
},
{
"name": "Fleet",
"code": "Fleet"
},
{
"name": "Forestry",
"code": "Forestry"
},
{
"name": "IT",
"code": "IT"
},
{
"name": "Lakes",
"code": "Lakes"
},
{
"name": "Library",
"code": "Library"
},
{
"name": "Parking",
"code": "Parking"
},
{
"name": "Parks",
"code": "Parks"
},
{
"name": "Roads",
"code": "Roads"
},
{
"name": "Sanitary",
"code": "Sanitary"
},
{
"name": "Stormwater",
"code": "Stormwater"
},
{
"name": "Natural",
"code": "Natural"
},
{
"name": "Ponds",
"code": "Ponds"
},
{
"name": "Transportation",
"code": "Transportation"
},
{
"name": "Water Distribution",
"code": "Water Distribution"
},
{
"name": "Land / Property",
"code": "Land / Property"
},
{
"name": "Public Art",
"code": "Public Art"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "VFA_CAMPUS_ID",
"type": "esriFieldTypeString",
"alias": "VFA_CAMPUS_ID",
"length": 20,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R846_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A778_IX1",
"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,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": false
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.81,
"cimVersion": "2.6.0",
"id": 8,
"name": "Roads",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPolyline",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
45,
0,
128,
255
],
"width": 1
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": [
{
"labelExpression": "[STREET_NAME]",
"labelPlacement": "esriServerLinePlacementAboveAlong",
"textLayout": "straight",
"allowOverrun": false,
"repeatLabel": false,
"deconflictionStrategy": "dynamic",
"removeDuplicates": "all",
"removeDuplicatesDistance": 0,
"lineConnection": "minimizeLabels",
"stackLabel": false,
"useCodedValues": true,
"maxScale": 0,
"minScale": 0,
"name": "Default",
"priority": 3,
"symbol": {
"type": "esriTS",
"color": [
0,
0,
0,
255
],
"backgroundColor": null,
"borderLineColor": null,
"borderLineSize": null,
"verticalAlignment": "bottom",
"horizontalAlignment": "center",
"rightToLeft": false,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"kerning": true,
"haloColor": null,
"haloSize": null,
"font": {
"family": "Arial",
"size": 7,
"style": "normal",
"weight": "normal",
"decoration": "none"
}
}
}
]
},
"defaultVisibility": true,
"extent": {
"xmin": 530238.830324709,
"ymin": 4808863.36972861,
"xmax": 542328.68362471,
"ymax": 4819865.83702861,
"spatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "STREET_NAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "SCHOOL_ZONE",
"type": "esriFieldTypeString",
"alias": "SCHOOL_ZONE",
"length": 10,
"domain": {
"type": "codedValue",
"name": "YES_NO",
"description": "Generic Yes No",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "SEGMENT_ID",
"type": "esriFieldTypeInteger",
"alias": "SEGMENT_ID",
"domain": null
},
{
"name": "SEQUENCE",
"type": "esriFieldTypeDouble",
"alias": "SEQUENCE",
"domain": null
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "STREET_NAME",
"length": 50,
"domain": null
},
{
"name": "STREET_NAME_ID",
"type": "esriFieldTypeInteger",
"alias": "STREET_NAME_ID",
"domain": null
},
{
"name": "FROM_LEFT",
"type": "esriFieldTypeSmallInteger",
"alias": "FROM_LEFT",
"domain": null
},
{
"name": "TO_LEFT",
"type": "esriFieldTypeSmallInteger",
"alias": "TO_LEFT",
"domain": null
},
{
"name": "FROM_RIGHT",
"type": "esriFieldTypeSmallInteger",
"alias": "FROM_RIGHT",
"domain": null
},
{
"name": "TO_RIGHT",
"type": "esriFieldTypeSmallInteger",
"alias": "TO_RIGHT",
"domain": null
},
{
"name": "LOW__",
"type": "esriFieldTypeSmallInteger",
"alias": "_LOW",
"domain": null
},
{
"name": "HIGH__",
"type": "esriFieldTypeSmallInteger",
"alias": "_HIGH",
"domain": null
},
{
"name": "RANGE__",
"type": "esriFieldTypeString",
"alias": "_RANGE",
"length": 15,
"domain": null
},
{
"name": "LEFT_PARITY",
"type": "esriFieldTypeString",
"alias": "LEFT_PARITY",
"length": 1,
"domain": null
},
{
"name": "RIGHT_PARITY",
"type": "esriFieldTypeString",
"alias": "RIGHT_PARITY",
"length": 1,
"domain": null
},
{
"name": "LEFT_MUNICIPALITY",
"type": "esriFieldTypeString",
"alias": "LEFT_MUNICIPALITY",
"length": 30,
"domain": null
},
{
"name": "RIGHT_MUNICIPALITY",
"type": "esriFieldTypeString",
"alias": "RIGHT_MUNICIPALITY",
"length": 30,
"domain": null
},
{
"name": "CRISYS_STREET_NAMES",
"type": "esriFieldTypeString",
"alias": "_ALT_STREET_NAMES",
"length": 50,
"domain": null
},
{
"name": "FROM_STREET",
"type": "esriFieldTypeString",
"alias": "FROM_STREET",
"length": 50,
"domain": null
},
{
"name": "FROM_STREET_ID",
"type": "esriFieldTypeInteger",
"alias": "FROM_STREET_ID",
"domain": null
},
{
"name": "TO_STREET",
"type": "esriFieldTypeString",
"alias": "TO_STREET",
"length": 50,
"domain": null
},
{
"name": "TO_STREET_ID",
"type": "esriFieldTypeInteger",
"alias": "TO_STREET_ID",
"domain": null
},
{
"name": "LIFECYCLE_STATUS",
"type": "esriFieldTypeString",
"alias": "LIFECYCLE_STATUS",
"length": 20,
"domain": {
"type": "codedValue",
"name": "LIFECYCLE_STATUS",
"description": "",
"codedValues": [
{
"name": "Active",
"code": "Active"
},
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "Abandoned",
"code": "Abandoned"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Never Built",
"code": "Never Built"
},
{
"name": "Temp",
"code": "Temp"
},
{
"name": "Missing",
"code": "Missing"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "STATUS_PHYSICAL",
"type": "esriFieldTypeString",
"alias": "STATUS_PHYSICAL",
"length": 20,
"domain": null
},
{
"name": "STATUS_PLANNING",
"type": "esriFieldTypeString",
"alias": "STATUS_PLANNING",
"length": 20,
"domain": null
},
{
"name": "STREET_TYPE",
"type": "esriFieldTypeString",
"alias": "STREET_TYPE",
"length": 12,
"domain": null
},
{
"name": "STREET_CLASS",
"type": "esriFieldTypeString",
"alias": "STREET_CLASS",
"length": 20,
"domain": null
},
{
"name": "CARTO_CLASS",
"type": "esriFieldTypeString",
"alias": "CARTO_CLASS",
"length": 30,
"domain": null
},
{
"name": "OWNED_BY",
"type": "esriFieldTypeString",
"alias": "OWNED_BY",
"length": 30,
"domain": null
},
{
"name": "MANAGED_BY",
"type": "esriFieldTypeString",
"alias": "MANAGED_BY",
"length": 30,
"domain": null
},
{
"name": "MAIN_ROAD",
"type": "esriFieldTypeString",
"alias": "MAIN_ROAD",
"length": 1,
"domain": null
},
{
"name": "FLOW_DIRECTION",
"type": "esriFieldTypeString",
"alias": "FLOW_DIRECTION",
"length": 6,
"domain": null
},
{
"name": "SURFACE_TYPE",
"type": "esriFieldTypeString",
"alias": "SURFACE_TYPE",
"length": 10,
"domain": null
},
{
"name": "NUMBER_LANES",
"type": "esriFieldTypeSmallInteger",
"alias": "NUMBER_LANES",
"domain": null
},
{
"name": "ROAD_WIDTH",
"type": "esriFieldTypeDouble",
"alias": "ROAD_WIDTH",
"domain": null
},
{
"name": "SPEED_ZONE",
"type": "esriFieldTypeSmallInteger",
"alias": "SPEED_ZONE",
"domain": null
},
{
"name": "REGIONAL_ROAD_NUMBER",
"type": "esriFieldTypeSmallInteger",
"alias": "REGIONAL_ROAD_NUMBER",
"domain": null
},
{
"name": "PUBLIC_ACCESS",
"type": "esriFieldTypeString",
"alias": "PUBLIC_ACCESS",
"length": 60,
"domain": null
},
{
"name": "STREET_INDEX",
"type": "esriFieldTypeString",
"alias": "STREET_INDEX",
"length": 5,
"domain": null
},
{
"name": "RUNCARD_ID",
"type": "esriFieldTypeSmallInteger",
"alias": "RUNCARD_ID",
"domain": null
},
{
"name": "FIRE_ROUTE",
"type": "esriFieldTypeString",
"alias": "FIRE_ROUTE",
"length": 10,
"domain": {
"type": "codedValue",
"name": "FIRE_ROUTE",
"description": "Fire Route priority values",
"codedValues": [
{
"name": "Primary",
"code": "Primary"
},
{
"name": "Secondary",
"code": "Secondary"
},
{
"name": "NA",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DEMAND_ZONE",
"type": "esriFieldTypeSmallInteger",
"alias": "DEMAND_ZONE",
"domain": null
},
{
"name": "TANKER_RQR",
"type": "esriFieldTypeString",
"alias": "TANKER_RQR",
"length": 1,
"domain": null
},
{
"name": "FIRST",
"type": "esriFieldTypeSmallInteger",
"alias": "FIRST",
"domain": null
},
{
"name": "SECOND",
"type": "esriFieldTypeSmallInteger",
"alias": "SECOND",
"domain": null
},
{
"name": "THIRD",
"type": "esriFieldTypeSmallInteger",
"alias": "THIRD",
"domain": null
},
{
"name": "FOURTH",
"type": "esriFieldTypeSmallInteger",
"alias": "FOURTH",
"domain": null
},
{
"name": "RP_CLASS",
"type": "esriFieldTypeSmallInteger",
"alias": "RP_CLASS",
"domain": null
},
{
"name": "RP_ROUTE_CODE",
"type": "esriFieldTypeSmallInteger",
"alias": "RP_ROUTE_CODE",
"domain": null
},
{
"name": "CUL_DE_SAC",
"type": "esriFieldTypeString",
"alias": "CUL_DE_SAC",
"length": 1,
"domain": null
},
{
"name": "CUL_DE_SAC_ISLAND",
"type": "esriFieldTypeString",
"alias": "CUL_DE_SAC_ISLAND",
"length": 1,
"domain": null
},
{
"name": "CUL_DE_SAC_GRASS_CODE",
"type": "esriFieldTypeString",
"alias": "CUL_DE_SAC_GRASS_CODE",
"length": 6,
"domain": null
},
{
"name": "NOTES",
"type": "esriFieldTypeString",
"alias": "NOTES",
"length": 50,
"domain": null
},
{
"name": "CREATE_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATE_DATE",
"length": 8,
"domain": null
},
{
"name": "CREATE_USER",
"type": "esriFieldTypeString",
"alias": "CREATE_USER",
"length": 16,
"domain": null
},
{
"name": "UPDATE_DATE",
"type": "esriFieldTypeDate",
"alias": "UPDATE_DATE",
"length": 8,
"domain": null
},
{
"name": "UPDATE_USER",
"type": "esriFieldTypeString",
"alias": "UPDATE_USER",
"length": 16,
"domain": null
},
{
"name": "ROW_ID",
"type": "esriFieldTypeString",
"alias": "ROW_ID",
"length": 20,
"domain": null
},
{
"name": "MXLOCATION",
"type": "esriFieldTypeString",
"alias": "MXLOCATION",
"length": 12,
"domain": null
},
{
"name": "MXSITEID",
"type": "esriFieldTypeString",
"alias": "MXSITEID",
"length": 8,
"domain": null
},
{
"name": "MXCREATIONSTATE",
"type": "esriFieldTypeSmallInteger",
"alias": "MXCREATIONSTATE",
"domain": null
},
{
"name": "ROWSTAMP",
"type": "esriFieldTypeString",
"alias": "ROWSTAMP",
"length": 40,
"domain": null
},
{
"name": "GLOBAL_ID",
"type": "esriFieldTypeGUID",
"alias": "GLOBAL_ID",
"length": 38,
"domain": null
},
{
"name": "MEDIAN",
"type": "esriFieldTypeString",
"alias": "MEDIAN",
"length": 3,
"domain": {
"type": "codedValue",
"name": "boolean_text",
"description": "Mixed case version of Yes and No codes",
"codedValues": [
{
"name": "Yes",
"code": "Yes"
},
{
"name": "No",
"code": "No"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "AADT",
"type": "esriFieldTypeInteger",
"alias": "AADT",
"domain": null
},
{
"name": "AADT_DATE",
"type": "esriFieldTypeDate",
"alias": "AADT_DATE",
"length": 8,
"domain": null
},
{
"name": "AADT_SOURCE",
"type": "esriFieldTypeString",
"alias": "AADT_SOURCE",
"length": 4,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
},
{
"name": "SHAPE.LEN",
"type": "esriFieldTypeDouble",
"alias": "SHAPE.LEN",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "I63SEGMENT_ID",
"fields": "SEGMENT_ID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "R35_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A17_IX1",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": true,
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": true,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true
},
"supportsDatumTransformation": true,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": false
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.81,
"cimVersion": "2.6.0",
"id": 9,
"name": "Water Mains",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPolyline",
"sourceSpatialReference": {
"wkid": 26917,
"latestWkid": 26917,
"vcsWkid": 115702,
"latestVcsWkid": 115702,
"xyTolerance": 2.0E-4,
"zTolerance": 7.4976715938E-5,
"mTolerance": 7.4976715938E-5,
"falseX": -5120899.99997529,
"falseY": -9998099.99997139,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"sourceHeightModelInfo": {
"heightModel": "ellipsoidal",
"vertCRS": "NAD_1983",
"heightUnit": "meter"
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 10000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "uniqueValue",
"field1": "DIAMETER",
"defaultSymbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
0,
0,
0,
255
],
"width": 2
},
"defaultLabel": "