{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "WCElements", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "WCElementsInsp", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GISID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": 471592.4925, "ymin": 5556887.4345, "xmax": 539001.1785, "ymax": 5608105.583875, "spatialReference": { "wkid": 26913, "latestWkid": 26913, "xyTolerance": 0.002093132257591652, "zTolerance": 2, "mTolerance": 2, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26913, "latestWkid": 26913, "xyTolerance": 0.002, "zTolerance": 0.002, "mTolerance": 0.002, "falseX": -5120900, "falseY": -9998100, "xyUnits": 8000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "GISID", "uniqueValueInfos": [], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 0, 112, 6, 255 ], "toColor": [ 241, 252, 30, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 252, 30, 255 ], "toColor": [ 250, 58, 10, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "UPDATE_USER", "typeIdField": "GISID", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GISID", "type": "esriFieldTypeInteger", "alias": "GISID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISID" }, { "name": "UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "UPDATE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UPDATE_DATE" }, { "name": "UPDATE_USER", "type": "esriFieldTypeString", "alias": "UPDATE_USER", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UPDATE_USER" }, { "name": "ACCT_ID", "type": "esriFieldTypeInteger", "alias": "ACCT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCT_ID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.LEN" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "GDB_83328_GISID", "fields": "GISID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R347203_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A4263_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "WValve", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "WValveInsp", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GISID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 472577.45, "ymin": 484768.32399999903, "xmax": 5593502.626, "ymax": 5603815.82025, "spatialReference": { "wkid": 26913, "latestWkid": 26913, "xyTolerance": 0.002093132257591652, "zTolerance": 2, "mTolerance": 2, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26913, "latestWkid": 26913, "xyTolerance": 0.002, "zTolerance": 0.002, "mTolerance": 0.002, "falseX": -5120900, "falseY": -9998100, "xyUnits": 8000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Subtype", "uniqueValueInfos": [], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 0, 112, 6, 255 ], "toColor": [ 241, 252, 30, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 252, 30, 255 ], "toColor": [ 250, 58, 10, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "SUBTYPENAME", "typeIdField": "SUBTYPE", "subtypeField": "Subtype", "defaultSubtypeCode": 4, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SUBTYPE", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null, "editable": true, "nullable": true, "defaultValue": 4, "modelName": "Subtype" }, { "name": "SYMBOLANGLE", "type": "esriFieldTypeDouble", "alias": "SymbolAngle", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "SymbolAngle" }, { "name": "DIAMETER", "type": "esriFieldTypeInteger", "alias": "DIAMETER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "INSTALLATIONDATE", "type": "esriFieldTypeString", "alias": "INSTALLATIONDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLATIONDATE" }, { "name": "INSTALLEDBY", "type": "esriFieldTypeString", "alias": "InstalledBy", "domain": { "type": "codedValue", "name": "Installers", "description": "", "codedValues": [ { "name": "ASL Paving", "code": "ASL Paving" }, { "name": "Bills Trenching", "code": "Bills Trenching" }, { "name": "Boyd Excavating", "code": "Boyd Excavating" }, { "name": "Bruces Landscaping", "code": "Bruces Landscaping" }, { "name": "Builders Dev. Ltd.", "code": "Builders Dev. Ltd." }, { "name": "Carys Trenching", "code": "Carys Trenching" }, { "name": "Comfort Mechanical", "code": "Comfort Mechanical" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Dun-Rite Plumbing & Heating", "code": "Dun-Rite Plumbing & Heating" }, { "name": "Edco Plumbing & Heating", "code": "Edco Plumbing & Heating" }, { "name": "Eds Backhoe Service", "code": "Eds Backhoe Service" }, { "name": "Erican Construction", "code": "Erican Construction" }, { "name": "G & B Sewer Water & Excavating Ltd.", "code": "G & B Sewer Water & Excavating Ltd." }, { "name": "G & E Plumbing & Heating", "code": "G & E Plumbing & Heating" }, { "name": "MacKenzie Plumbing & Heating", "code": "MacKenzie Plumbing & Heating" }, { "name": "Marathon Mechanical (1993)", "code": "Marathon Mechanical (1993)" }, { "name": "Marquardt Mechanical Ltd.", "code": "Marquardt Mechanical Ltd." }, { "name": "NIS Contractors", "code": "NIS Contractors" }, { "name": "Northwest Excavation", "code": "Northwest Excavation" }, { "name": "Red River Construction", "code": "Red River Construction" }, { "name": "Regent Realty", "code": "Regent Realty" }, { "name": "Richardsons Plumbing & Heating Ltd.", "code": "Richardsons Plumbing & Heating Ltd." }, { "name": "Sherwood Land Development", "code": "Sherwood Land Development" }, { "name": "Strong, Lamb & Nelson Ltd.", "code": "Strong, Lamb & Nelson Ltd." }, { "name": "Tu-Way Trenching", "code": "Tu-Way Trenching" }, { "name": "Underwood McLellan", "code": "Underwood McLellan" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "Wappel Construction", "code": "Wappel Construction" }, { "name": "Wardrop", "code": "Wardrop" }, { "name": "Wascana Mechanical", "code": "Wascana Mechanical" }, { "name": "Welldone Plumbing & Heating Ltd.", "code": "Welldone Plumbing & Heating Ltd." }, { "name": "XL Mechanical", "code": "XL Mechanical" }, { "name": "Canadian Bobcat", "code": "Canadian Bobcat" }, { "name": "CLC Building Solutions Inc", "code": "CLC Building Solutions Inc" }, { "name": "KMS Construction Ltd", "code": "KMS Construction Ltd" }, { "name": "Jordan Excavating", "code": "Jordan Excavating" }, { "name": "Operation Dirt", "code": "Operation Dirt" }, { "name": "Vic's Excavating Ltd", "code": "Vic's Excavating Ltd" }, { "name": "Zaryski Construction Ltd", "code": "Zaryski Construction Ltd" }, { "name": "Barbour Excavating", "code": "Barbour Excavating" }, { "name": "Degelman Developments", "code": "Degelman Developments" }, { "name": "CBS Contracting", "code": "CBS Contracting" }, { "name": "Queen City Excavating", "code": "Queen City Excavating" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "UNKNOWN", "modelName": "InstalledBy" }, { "name": "DISTANCEEW", "type": "esriFieldTypeString", "alias": "DISTANCEEW", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DISTANCEEW" }, { "name": "DISTANCENS", "type": "esriFieldTypeString", "alias": "DISTANCENS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DISTANCENS" }, { "name": "MAINTAINEDBY", "type": "esriFieldTypeString", "alias": "MaintainedBy", "domain": { "type": "codedValue", "name": "MaintainedBy", "description": "", "codedValues": [ { "name": "City", "code": "C" }, { "name": "Private", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "C", "modelName": "MaintainedBy" }, { "name": "VALVEBOX", "type": "esriFieldTypeString", "alias": "ValveBox", "domain": { "type": "codedValue", "name": "YesNo__1", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ValveBox" }, { "name": "VALVECHAMBER", "type": "esriFieldTypeString", "alias": "ValveChamber", "domain": { "type": "codedValue", "name": "YesNo__1", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ValveChamber" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "DETAILDRAWING", "type": "esriFieldTypeString", "alias": "DETAILDRAWING", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "DETAILDRAWING" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "SAC_ANODE", "type": "esriFieldTypeString", "alias": "SAC_ANODE", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "SAC_ANODE" }, { "name": "SUBTYPENAME", "type": "esriFieldTypeString", "alias": "SUBTYPENAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUBTYPENAME" }, { "name": "SURVEY_DATE", "type": "esriFieldTypeDate", "alias": "SURVEY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SURVEY_DATE" }, { "name": "GISID", "type": "esriFieldTypeInteger", "alias": "GISID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISID" }, { "name": "UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "UPDATE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UPDATE_DATE" }, { "name": "UPDATE_USER", "type": "esriFieldTypeString", "alias": "UPDATE_USER", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UPDATE_USER" }, { "name": "FLANGED", "type": "esriFieldTypeString", "alias": "FLANGED", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "FLANGED" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LOCATION" }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT" }, { "name": "PROJECTSTATUS", "type": "esriFieldTypeString", "alias": "PROJECTSTATUS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PROJECTSTATUS" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "WValveStatus", "description": "Water Main Valve Status", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "PERMANENTLY OPEN", "code": "PERMANENTLY OPEN" }, { "name": "PERMANENTLY CLOSED", "code": "PERMANENTLY CLOSED" }, { "name": "NORMALLY CLOSED", "code": "NORMALLY CLOSED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "ACTIVE", "modelName": "STATUS" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "GDB_3978_GISID", "fields": "GISID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1905_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1905", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1905", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "A1762_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [], "subtypes": [ { "code": 4, "name": "Check", "defaultValues": { "SUBTYPE": 4, "SYMBOLANGLE": 0, "DIAMETER": 0, "INSTALLATIONDATE": null, "INSTALLEDBY": "UNKNOWN", "DISTANCEEW": null, "DISTANCENS": null, "MAINTAINEDBY": "C", "VALVEBOX": null, "VALVECHAMBER": null, "COMMENTS": null, "DETAILDRAWING": null, "ENABLED": 1, "SAC_ANODE": "N", "SUBTYPENAME": null, "SURVEY_DATE": null, "GISID": null, "UPDATE_DATE": null, "UPDATE_USER": null, "FLANGED": "N", "LOCATION": null, "PROJECT": null, "PROJECTSTATUS": null, "GLOBALID": null, "STATUS": "ACTIVE" }, "domains": { "DIAMETER": { "type": "codedValue", "name": "WValveDiameter", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "40", "code": 40 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "name": "135", "code": 135 }, { "name": "150", "code": 150 }, { "name": "200", "code": 200 }, { "name": "250", "code": 250 }, { "name": "300", "code": 300 }, { "name": "350", "code": 350 }, { "name": "400", "code": 400 }, { "name": "450", "code": 450 }, { "name": "500", "code": 500 }, { "name": "600", "code": 600 }, { "name": "750", "code": 750 }, { "name": "900", "code": 900 }, { "name": "1050", "code": 1050 }, { "name": "1200", "code": 1200 }, { "name": "1500", "code": 1500 }, { "name": "1800", "code": 1800 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "INSTALLEDBY": {"type": "inherited"}, "MAINTAINEDBY": {"type": "inherited"}, "VALVEBOX": {"type": "inherited"}, "VALVECHAMBER": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "SAC_ANODE": {"type": "inherited"}, "FLANGED": {"type": "inherited"}, "LOCATION": { "type": "codedValue", "name": "WValveLocation", "description": "Water Main Valve Locations", "codedValues": [ { "name": "AS SHOWN", "code": "AS SHOWN" }, { "name": "HYDRANT LEAD", "code": "HYDRANT LEAD" }, { "name": "PROPERTY LINE", "code": "PROPERTY LINE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PROJECTSTATUS": { "type": "codedValue", "name": "IRProjectStatus", "description": "IR Status of Project Data delivered", "codedValues": [ { "name": "AS-BUILT", "code": "AS-BUILT" }, { "name": "DESIGN", "code": "DESIGN" }, { "name": "PARTIAL AS-BUILT", "code": "PARTIAL AS-BUILT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "STATUS": {"type": "inherited"} } }, { "code": 5, "name": "Flushout", "defaultValues": { "SUBTYPE": 5, "SYMBOLANGLE": 0, "DIAMETER": 0, "INSTALLATIONDATE": null, "INSTALLEDBY": "UNKNOWN", "DISTANCEEW": null, "DISTANCENS": null, "MAINTAINEDBY": "C", "VALVEBOX": null, "VALVECHAMBER": null, "COMMENTS": null, "DETAILDRAWING": null, "ENABLED": 1, "SAC_ANODE": "N", "SUBTYPENAME": null, "SURVEY_DATE": null, "GISID": null, "UPDATE_DATE": null, "UPDATE_USER": null, "FLANGED": "N", "LOCATION": null, "PROJECT": null, "PROJECTSTATUS": null, "GLOBALID": null, "STATUS": "ACTIVE" }, "domains": { "DIAMETER": { "type": "codedValue", "name": "WFlushoutDiameter", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "25", "code": 25 }, { "name": "50", "code": 50 }, { "name": "100", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "INSTALLEDBY": {"type": "inherited"}, "MAINTAINEDBY": {"type": "inherited"}, "VALVEBOX": {"type": "inherited"}, "VALVECHAMBER": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "SAC_ANODE": {"type": "inherited"}, "FLANGED": {"type": "inherited"}, "LOCATION": { "type": "codedValue", "name": "WValveLocation", "description": "Water Main Valve Locations", "codedValues": [ { "name": "AS SHOWN", "code": "AS SHOWN" }, { "name": "HYDRANT LEAD", "code": "HYDRANT LEAD" }, { "name": "PROPERTY LINE", "code": "PROPERTY LINE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PROJECTSTATUS": { "type": "codedValue", "name": "IRProjectStatus", "description": "IR Status of Project Data delivered", "codedValues": [ { "name": "AS-BUILT", "code": "AS-BUILT" }, { "name": "DESIGN", "code": "DESIGN" }, { "name": "PARTIAL AS-BUILT", "code": "PARTIAL AS-BUILT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "STATUS": {"type": "inherited"} } }, { "code": 3, "name": "Butterfly", "defaultValues": { "SUBTYPE": 3, "SYMBOLANGLE": 0, "DIAMETER": 0, "INSTALLATIONDATE": null, "INSTALLEDBY": "UNKNOWN", "DISTANCEEW": null, "DISTANCENS": null, "MAINTAINEDBY": "C", "VALVEBOX": null, "VALVECHAMBER": null, "COMMENTS": null, "DETAILDRAWING": null, "ENABLED": 1, "SAC_ANODE": "N", "SUBTYPENAME": null, "SURVEY_DATE": null, "GISID": null, "UPDATE_DATE": null, "UPDATE_USER": null, "FLANGED": "N", "LOCATION": null, "PROJECT": null, "PROJECTSTATUS": null, "GLOBALID": null, "STATUS": "ACTIVE" }, "domains": { "DIAMETER": { "type": "codedValue", "name": "WValveDiameter", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "40", "code": 40 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "name": "135", "code": 135 }, { "name": "150", "code": 150 }, { "name": "200", "code": 200 }, { "name": "250", "code": 250 }, { "name": "300", "code": 300 }, { "name": "350", "code": 350 }, { "name": "400", "code": 400 }, { "name": "450", "code": 450 }, { "name": "500", "code": 500 }, { "name": "600", "code": 600 }, { "name": "750", "code": 750 }, { "name": "900", "code": 900 }, { "name": "1050", "code": 1050 }, { "name": "1200", "code": 1200 }, { "name": "1500", "code": 1500 }, { "name": "1800", "code": 1800 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "INSTALLEDBY": {"type": "inherited"}, "MAINTAINEDBY": {"type": "inherited"}, "VALVEBOX": {"type": "inherited"}, "VALVECHAMBER": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "SAC_ANODE": {"type": "inherited"}, "FLANGED": {"type": "inherited"}, "LOCATION": { "type": "codedValue", "name": "WValveLocation", "description": "Water Main Valve Locations", "codedValues": [ { "name": "AS SHOWN", "code": "AS SHOWN" }, { "name": "HYDRANT LEAD", "code": "HYDRANT LEAD" }, { "name": "PROPERTY LINE", "code": "PROPERTY LINE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PROJECTSTATUS": { "type": "codedValue", "name": "IRProjectStatus", "description": "IR Status of Project Data delivered", "codedValues": [ { "name": "AS-BUILT", "code": "AS-BUILT" }, { "name": "DESIGN", "code": "DESIGN" }, { "name": "PARTIAL AS-BUILT", "code": "PARTIAL AS-BUILT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "STATUS": {"type": "inherited"} } }, { "code": 2, "name": "Blowoff", "defaultValues": { "SUBTYPE": 2, "SYMBOLANGLE": 0, "DIAMETER": 0, "INSTALLATIONDATE": null, "INSTALLEDBY": "UNKNOWN", "DISTANCEEW": null, "DISTANCENS": null, "MAINTAINEDBY": "C", "VALVEBOX": null, "VALVECHAMBER": null, "COMMENTS": null, "DETAILDRAWING": null, "ENABLED": 1, "SAC_ANODE": "N", "SUBTYPENAME": null, "SURVEY_DATE": null, "GISID": null, "UPDATE_DATE": null, "UPDATE_USER": null, "FLANGED": "N", "LOCATION": null, "PROJECT": null, "PROJECTSTATUS": null, "GLOBALID": null, "STATUS": "ACTIVE" }, "domains": { "DIAMETER": { "type": "codedValue", "name": "WValveDiameter", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "40", "code": 40 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "name": "135", "code": 135 }, { "name": "150", "code": 150 }, { "name": "200", "code": 200 }, { "name": "250", "code": 250 }, { "name": "300", "code": 300 }, { "name": "350", "code": 350 }, { "name": "400", "code": 400 }, { "name": "450", "code": 450 }, { "name": "500", "code": 500 }, { "name": "600", "code": 600 }, { "name": "750", "code": 750 }, { "name": "900", "code": 900 }, { "name": "1050", "code": 1050 }, { "name": "1200", "code": 1200 }, { "name": "1500", "code": 1500 }, { "name": "1800", "code": 1800 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "INSTALLEDBY": {"type": "inherited"}, "MAINTAINEDBY": {"type": "inherited"}, "VALVEBOX": {"type": "inherited"}, "VALVECHAMBER": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "SAC_ANODE": {"type": "inherited"}, "FLANGED": {"type": "inherited"}, "LOCATION": { "type": "codedValue", "name": "WValveLocation", "description": "Water Main Valve Locations", "codedValues": [ { "name": "AS SHOWN", "code": "AS SHOWN" }, { "name": "HYDRANT LEAD", "code": "HYDRANT LEAD" }, { "name": "PROPERTY LINE", "code": "PROPERTY LINE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PROJECTSTATUS": { "type": "codedValue", "name": "IRProjectStatus", "description": "IR Status of Project Data delivered", "codedValues": [ { "name": "AS-BUILT", "code": "AS-BUILT" }, { "name": "DESIGN", "code": "DESIGN" }, { "name": "PARTIAL AS-BUILT", "code": "PARTIAL AS-BUILT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "STATUS": {"type": "inherited"} } }, { "code": 1, "name": "Ball", "defaultValues": { "SUBTYPE": 1, "SYMBOLANGLE": 0, "DIAMETER": 0, "INSTALLATIONDATE": null, "INSTALLEDBY": "UNKNOWN", "DISTANCEEW": null, "DISTANCENS": null, "MAINTAINEDBY": "C", "VALVEBOX": null, "VALVECHAMBER": null, "COMMENTS": null, "DETAILDRAWING": null, "ENABLED": 1, "SAC_ANODE": "N", "SUBTYPENAME": null, "SURVEY_DATE": null, "GISID": null, "UPDATE_DATE": null, "UPDATE_USER": null, "FLANGED": "N", "LOCATION": null, "PROJECT": null, "PROJECTSTATUS": null, "GLOBALID": null, "STATUS": "ACTIVE" }, "domains": { "DIAMETER": { "type": "codedValue", "name": "WValveDiameter", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "40", "code": 40 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "name": "135", "code": 135 }, { "name": "150", "code": 150 }, { "name": "200", "code": 200 }, { "name": "250", "code": 250 }, { "name": "300", "code": 300 }, { "name": "350", "code": 350 }, { "name": "400", "code": 400 }, { "name": "450", "code": 450 }, { "name": "500", "code": 500 }, { "name": "600", "code": 600 }, { "name": "750", "code": 750 }, { "name": "900", "code": 900 }, { "name": "1050", "code": 1050 }, { "name": "1200", "code": 1200 }, { "name": "1500", "code": 1500 }, { "name": "1800", "code": 1800 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "INSTALLEDBY": {"type": "inherited"}, "MAINTAINEDBY": {"type": "inherited"}, "VALVEBOX": {"type": "inherited"}, "VALVECHAMBER": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "SAC_ANODE": {"type": "inherited"}, "FLANGED": {"type": "inherited"}, "LOCATION": { "type": "codedValue", "name": "WValveLocation", "description": "Water Main Valve Locations", "codedValues": [ { "name": "AS SHOWN", "code": "AS SHOWN" }, { "name": "HYDRANT LEAD", "code": "HYDRANT LEAD" }, { "name": "PROPERTY LINE", "code": "PROPERTY LINE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PROJECTSTATUS": { "type": "codedValue", "name": "IRProjectStatus", "description": "IR Status of Project Data delivered", "codedValues": [ { "name": "AS-BUILT", "code": "AS-BUILT" }, { "name": "DESIGN", "code": "DESIGN" }, { "name": "PARTIAL AS-BUILT", "code": "PARTIAL AS-BUILT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "STATUS": {"type": "inherited"} } }, { "code": 6, "name": "Gate", "defaultValues": { "SUBTYPE": 6, "SYMBOLANGLE": 0, "DIAMETER": 0, "INSTALLATIONDATE": null, "INSTALLEDBY": "UNKNOWN", "DISTANCEEW": null, "DISTANCENS": null, "MAINTAINEDBY": "C", "VALVEBOX": null, "VALVECHAMBER": null, "COMMENTS": null, "DETAILDRAWING": null, "ENABLED": 1, "SAC_ANODE": "N", "SUBTYPENAME": null, "SURVEY_DATE": null, "GISID": null, "UPDATE_DATE": null, "UPDATE_USER": null, "FLANGED": "N", "LOCATION": null, "PROJECT": null, "PROJECTSTATUS": null, "GLOBALID": null, "STATUS": "ACTIVE" }, "domains": { "DIAMETER": { "type": "codedValue", "name": "WValveDiameter", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "40", "code": 40 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "name": "135", "code": 135 }, { "name": "150", "code": 150 }, { "name": "200", "code": 200 }, { "name": "250", "code": 250 }, { "name": "300", "code": 300 }, { "name": "350", "code": 350 }, { "name": "400", "code": 400 }, { "name": "450", "code": 450 }, { "name": "500", "code": 500 }, { "name": "600", "code": 600 }, { "name": "750", "code": 750 }, { "name": "900", "code": 900 }, { "name": "1050", "code": 1050 }, { "name": "1200", "code": 1200 }, { "name": "1500", "code": 1500 }, { "name": "1800", "code": 1800 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "INSTALLEDBY": {"type": "inherited"}, "MAINTAINEDBY": {"type": "inherited"}, "VALVEBOX": {"type": "inherited"}, "VALVECHAMBER": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "SAC_ANODE": {"type": "inherited"}, "FLANGED": {"type": "inherited"}, "LOCATION": { "type": "codedValue", "name": "WValveLocation", "description": "Water Main Valve Locations", "codedValues": [ { "name": "AS SHOWN", "code": "AS SHOWN" }, { "name": "HYDRANT LEAD", "code": "HYDRANT LEAD" }, { "name": "PROPERTY LINE", "code": "PROPERTY LINE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PROJECTSTATUS": { "type": "codedValue", "name": "IRProjectStatus", "description": "IR Status of Project Data delivered", "codedValues": [ { "name": "AS-BUILT", "code": "AS-BUILT" }, { "name": "DESIGN", "code": "DESIGN" }, { "name": "PARTIAL AS-BUILT", "code": "PARTIAL AS-BUILT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "STATUS": {"type": "inherited"} } } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "WCElementsInsp", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "WCElements", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GISID_", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SERVICETYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RECEIVEDDATE", "type": "esriFieldTypeDate", "alias": "RECEIVEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RECEIVEDDATE" }, { "name": "TIMEARRIVED", "type": "esriFieldTypeDate", "alias": "TIMEARRIVED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TIMEARRIVED" }, { "name": "TIMECOMPLETED", "type": "esriFieldTypeDate", "alias": "TIMECOMPLETED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TIMECOMPLETED" }, { "name": "SERVICEREQUEST", "type": "esriFieldTypeInteger", "alias": "SERVICEREQUEST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVICEREQUEST" }, { "name": "WORKORDER", "type": "esriFieldTypeDouble", "alias": "WORKORDER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDER" }, { "name": "WORKORDERTASK", "type": "esriFieldTypeDouble", "alias": "WORKORDERTASK", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDERTASK" }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "SERVICETYPE", "domain": { "type": "codedValue", "name": "WaterCurbInspSERV", "description": "WaterCurbInspSERV", "codedValues": [ { "name": "Pre-Flushing", "code": "Pre-Flushing" }, { "name": "Flushing Program", "code": "Flushing Program" }, { "name": "Pre-Construction", "code": "Pre-Construction" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Preventative Maintenance", "code": "Preventative Maintenance" }, { "name": "Post-Construction", "code": "Post-Construction" }, { "name": "Watermain Relining", "code": "Watermain Relining" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICETYPE" }, { "name": "PIPEMATERIALCITY", "type": "esriFieldTypeString", "alias": "PIPEMATERIALCITY", "domain": { "type": "codedValue", "name": "WaterCFPIPEMATERIALCITY", "description": "WaterCFPIPEMATERIALCITY", "codedValues": [ { "name": "Copper", "code": "Copper" }, { "name": "Lead", "code": "Lead" }, { "name": "Poly B", "code": "Poly B" }, { "name": "Poly E", "code": "Poly E" }, { "name": "Camaloid", "code": "Camaloid" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPEMATERIALCITY" }, { "name": "PIPEMATERIALPRIVATE", "type": "esriFieldTypeString", "alias": "PIPEMATERIALPRIVATE", "domain": { "type": "codedValue", "name": "WaterCFPIPEMATERIALCITY", "description": "WaterCFPIPEMATERIALCITY", "codedValues": [ { "name": "Copper", "code": "Copper" }, { "name": "Lead", "code": "Lead" }, { "name": "Poly B", "code": "Poly B" }, { "name": "Poly E", "code": "Poly E" }, { "name": "Camaloid", "code": "Camaloid" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPEMATERIALPRIVATE" }, { "name": "CBOCONDITION", "type": "esriFieldTypeString", "alias": "CBOCONDITION", "domain": { "type": "codedValue", "name": "WaterCurbInspBO", "description": "WaterCurbInspBO", "codedValues": [ { "name": "Operable", "code": "Operable" }, { "name": "Cannot Locate", "code": "Cannot Locate" }, { "name": "Stuck Lid", "code": "Stuck Lid" }, { "name": "Full/Debris", "code": "Full/Debris" }, { "name": "Misaligned Box", "code": "Misaligned Box" }, { "name": "Bent Rod", "code": "Bent Rod" }, { "name": "Too High", "code": "Too High" }, { "name": "Too Low", "code": "Too Low" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CBOCONDITION" }, { "name": "CSCONDITION", "type": "esriFieldTypeString", "alias": "CSCONDITION", "domain": { "type": "codedValue", "name": "WaterCurbInspSTOP", "description": "WaterCurbInspSTOP", "codedValues": [ { "name": "Non-Operable", "code": "Non-Operable" }, { "name": "Corroded", "code": "Corroded" }, { "name": "No Check pin", "code": "No Check pin" }, { "name": "Passing", "code": "Passing" }, { "name": "Pass", "code": "Pass" }, { "name": "Drain Hole", "code": "Drain Hole" }, { "name": "Packing Gland", "code": "Packing Gland" }, { "name": "Tee Head off", "code": "Tee Head off" }, { "name": "Frozen", "code": "Frozen" }, { "name": "Leak", "code": "Leak" }, { "name": "Other", "code": "Other" }, { "name": "Operable", "code": "Operable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CSCONDITION" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "ACTION", "domain": { "type": "codedValue", "name": "WaterCurbInspACTION", "description": "WaterCurbInspACTION", "codedValues": [ { "name": "Replaced Curb Box and Rod", "code": "Replaced Curb Box and Rod" }, { "name": "Flushed", "code": "Flushed" }, { "name": "Raised", "code": "Raised" }, { "name": "Lower", "code": "Lower" }, { "name": "Steamed", "code": "Steamed" }, { "name": "Thawed", "code": "Thawed" }, { "name": "No Action", "code": "No Action" }, { "name": "Hydrovac Failed", "code": "Hydrovac Failed" }, { "name": "Located and Operated", "code": "Located and Operated" }, { "name": "Pulled Rod", "code": "Pulled Rod" }, { "name": "Hydrovac Successful", "code": "Hydrovac Successful" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Inspected", "code": "Inspected" }, { "name": "Turned on", "code": "Turned on" }, { "name": "Turned off", "code": "Turned off" }, { "name": "Seized", "code": "Seized" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ACTION" }, { "name": "BOXRODQTY", "type": "esriFieldTypeInteger", "alias": "BOXRODQTY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BOXRODQTY" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "SERVICEDBY", "type": "esriFieldTypeString", "alias": "SERVICEDBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICEDBY" }, { "name": "VEHICLEUNIT", "type": "esriFieldTypeInteger", "alias": "VEHICLEUNIT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VEHICLEUNIT" }, { "name": "DATEREFFERED", "type": "esriFieldTypeDate", "alias": "DATEREFFERED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEREFFERED" }, { "name": "PLANSMADEBY", "type": "esriFieldTypeString", "alias": "PLANSMADEBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PLANSMADEBY" }, { "name": "GISID_", "type": "esriFieldTypeInteger", "alias": "GISID_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISID_" }, { "name": "MAITENANCE", "type": "esriFieldTypeString", "alias": "MAITENANCE", "domain": { "type": "codedValue", "name": "WaterCurbInspMAINTE", "description": "WaterCurbInspMAINTE", "codedValues": [ { "name": "Replaced Curb Box and Rod", "code": "Replaced Curb Box and Rod" }, { "name": "Flushed", "code": "Flushed" }, { "name": "Raised", "code": "Raised" }, { "name": "Lower", "code": "Lower" }, { "name": "Steamed", "code": "Steamed" }, { "name": "Thawed", "code": "Thawed" }, { "name": "No Action", "code": "No Action" }, { "name": "Hydrovacced Failed", "code": "Hydrovacced Failed" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAITENANCE" }, { "name": "POSITIONLEFT", "type": "esriFieldTypeString", "alias": "POSITIONLEFT", "domain": { "type": "codedValue", "name": "WaterCurbInspPOSITIONLEF", "description": "WaterCurbInspPOSITIONLEF", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" }, { "name": "Partially Open", "code": "Partially Open" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "POSITIONLEFT" } ], "indexes": [ { "name": "GDB_126844_GISID", "fields": "GISID_", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1244438_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WCElementsInsp", "description": "", "prototype": { "attributes": { "MAITENANCE": null, "POSITIONLEFT": null, "RECEIVEDDATE": null, "TIMEARRIVED": null, "TIMECOMPLETED": null, "SERVICEREQUEST": null, "WORKORDER": null, "WORKORDERTASK": null, "SERVICETYPE": null, "PIPEMATERIALCITY": null, "PIPEMATERIALPRIVATE": null, "CBOCONDITION": null, "CSCONDITION": null, "ACTION": null, "BOXRODQTY": null, "COMMENTS": null, "SERVICEDBY": null, "VEHICLEUNIT": null, "DATEREFFERED": null, "PLANSMADEBY": null, "GISID_": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "WValveInsp", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "WValve", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GISID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "COMMENTS", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TIMEARRIVED", "type": "esriFieldTypeDate", "alias": "DATE ARRIVED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SERVICETYPE" }, { "name": "TIMECOMPLETED", "type": "esriFieldTypeDate", "alias": "DATE COMPLETED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CLEANOUT" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "GISID", "type": "esriFieldTypeInteger", "alias": "JUMP_GISID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUMP_GISID" }, { "name": "SERVICEREQUEST", "type": "esriFieldTypeInteger", "alias": "SERVICE REQUEST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceRequest" }, { "name": "WORKORDER", "type": "esriFieldTypeInteger", "alias": "WORK ORDER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrder" }, { "name": "TASK_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "TASK NUMBER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrderTask" }, { "name": "VEHICLEUNIT", "type": "esriFieldTypeInteger", "alias": "VEHICLE UNIT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VehicleUnit" }, { "name": "VBCONDITION", "type": "esriFieldTypeString", "alias": "VB CONDITION", "domain": { "type": "codedValue", "name": "WaterVInspVBCONDITION", "description": "WaterVInspVBCONDITION", "codedValues": [ { "name": "Damaged Rod", "code": "Damaged Rod" }, { "name": "Off Center", "code": "Off Center" }, { "name": "Damage Box", "code": "Damage Box" }, { "name": "Paved Over", "code": "Paved Over" }, { "name": "Valve Box too high", "code": "Valve Box too high" }, { "name": "Valve Box too low", "code": "Valve Box too low" }, { "name": "Damaged Extension", "code": "Damaged Extension" }, { "name": "Full/Debris", "code": "Full/Debris" }, { "name": "Obsolete Valve Box", "code": "Obsolete Valve Box" }, { "name": "Locate Valve Box", "code": "Locate Valve Box" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VBCondition" }, { "name": "VCONDITION_1", "type": "esriFieldTypeString", "alias": "V CONDITION", "domain": { "type": "codedValue", "name": "WaterVInspVBC", "description": "WaterVInspVBC", "codedValues": [ { "name": "Operable", "code": "Operable" }, { "name": "Non-Operable", "code": "Non-Operable" }, { "name": "Defective", "code": "Defective" }, { "name": "Works Hard", "code": "Works Hard" }, { "name": "Passing Broken Spindle", "code": "Passing Broken Spindle" }, { "name": "Operating Nut Off", "code": "Operating Nut Off" }, { "name": "Corroded Body Bolt", "code": "Corroded Body Bolt" }, { "name": "Packing Gland", "code": "Packing Gland" }, { "name": "Leadite Joins", "code": "Leadite Joins" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VCONDITION_1" }, { "name": "POSITIONLEFT", "type": "esriFieldTypeString", "alias": "POSITION LEFT", "domain": { "type": "codedValue", "name": "WaterValvePosLeft", "description": "WaterValvePositLeft", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" }, { "name": "Partially Open", "code": "Partially Open" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "POSITIONLEFT" }, { "name": "MAINTENANCE", "type": "esriFieldTypeString", "alias": "MAINTENANCE", "domain": { "type": "codedValue", "name": "WaterVInspMAINTENANCE", "description": "WaterVInspMAINTENANCE", "codedValues": [ { "name": "Flushed", "code": "Flushed" }, { "name": "Lowered", "code": "Lowered" }, { "name": "Raised", "code": "Raised" }, { "name": "Exercised", "code": "Exercised" }, { "name": "Steamed", "code": "Steamed" }, { "name": "Thawed", "code": "Thawed" }, { "name": "No Action", "code": "No Action" }, { "name": "Hydrovacced Failed", "code": "Hydrovacced Failed" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINTANENCE" }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "SERVICETYPE", "domain": { "type": "codedValue", "name": "WaterVInspSERVICETYPE", "description": "WaterVInspSERVICETYPE", "codedValues": [ { "name": "Pre-Flushing", "code": "Pre-Flushing" }, { "name": "Flushing Program", "code": "Flushing Program" }, { "name": "Pre-Construction", "code": "Pre-Construction" }, { "name": "Post-Construction", "code": "Post-Construction" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Watermain Relining", "code": "Watermain Relining" }, { "name": "Preventative Maintenance", "code": "Preventative Maintenance" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERVICETYPE" }, { "name": "TURNS", "type": "esriFieldTypeSmallInteger", "alias": "TURNS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TURNS" } ], "indexes": [ { "name": "GDB_126842_GISID", "fields": "GISID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1244435_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WValveInsp", "description": "", "prototype": { "attributes": { "SERVICETYPE": null, "TURNS": null, "TIMEARRIVED": null, "TIMECOMPLETED": null, "COMMENTS": null, "GISID": null, "SERVICEREQUEST": null, "WORKORDER": null, "TASK_NUMBER": null, "VEHICLEUNIT": null, "VBCONDITION": null, "VCONDITION_1": null, "POSITIONLEFT": null, "MAINTENANCE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }