{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 4, "name": "Sewer Pump Stations", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 5, "name": "Sewer Cube Launch" }, { "id": 6, "name": "Sewer Pump Station - Public" }, { "id": 7, "name": "Sewer Site" } ], "minScale": 0, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": -1.1710392661120817E8, "ymin": -9.953920807262498E7, "xmax": 1.203847599445415E8, "ymax": 1.0171247821732044E8, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 5, "name": "Sewer Cube Launch", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": { "id": 4, "name": "Sewer Pump Stations" }, "subLayers": [], "minScale": 5000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "85590f6e0b9022803985f3200f5ae067", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACsUlEQVRIieWVS0hUURjHf+c6GqKGPSbyUUKIBkaIV5qBEGpA2qirCLMgaqGrNhW2iKLITRREhIT22jVDK3VcVJugEJ3FhPkolTFTU8fSnDFTR525ca8zo/OqSQqC/rvvO9/9fuf8z7nn6PjL0v0/AIuBagTVWiCwV7ZT80cATw3IPsFVoCyYVJAtRmQlgYrjbYxvGOBv3gDIapyQnILPs4Di86mhLLyMWQzUVNpo/G2Aaom/uaa0nHzyq84zPz7EYMsDPDNfVgcEDRYj5ZUdlMcFCLdESBL6IhPFtfWk7crTavRFh+m8ewG3oyvwWZnZwDg6isMt04U394JVQIYab0rXs7u0ksKzt5ASk4J1Ow+UYqp/ia3uNJO2F3iXFhGCDLyMPTFSUdWBNSpAnXmgeXpeIQWnLpFtOhrVwqTNWym50UTv4zqGrA/57hzW8hK0aMZFAygKshCwJV+m5GYzyfqskKbTvTZtValZe/z+CwrOXCY1O5eu+ovMfx7V0uaDZAasCgEIoSUzludczE+OhgB6H12n5/4VJF0ipnuv2LbPGBxbmBpn8auTX2+ywK6e8bmxQZy25yFNpnvaV21cWWa6tyNkzDXwRsv71bp+o0MAko9Gn/9vdQ10hrD3nqzF/aGH5O2Z5Bw5Ecwvuaf5Nty/ZjPYY67gmA27xagVyLMjfbgcXaTn7tfGdhQdorxpJMKCT6+bNXBACcraCYq0aJ1Nsx/7cHY8CwJiaeptG94lTyC0q5P8KWC9TTN9IbUR8i17cA92B2MFWsNrIgDqDMwGJtQfZ3b4Pf2W2+iSU6IC5kYduIfexbQnKkCVkLCiUO1ydNN55xxxKsKemABF4prw+u/+eKVEv1GjAtRzbD5IllihLPjIxNaEDxqrbJH2xAQEIKDNKuZdH4/+nTd5o/oBC1T9hzn2IegAAAAASUVORK5CYII=", "contentType": "image/png", "width": 18, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PlanName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "length": 20, "domain": { "type": "codedValue", "name": "sewOwnerMaint", "description": "", "codedValues": [ { "name": "Kent", "code": "Kent" }, { "name": "Private", "code": "Private" }, { "name": "Metro", "code": "Metro" }, { "name": "Soos Creek", "code": "Soos Creek" }, { "name": "Seattle", "code": "Seattle" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 20, "domain": { "type": "codedValue", "name": "sewOwnerMaint", "description": "", "codedValues": [ { "name": "Kent", "code": "Kent" }, { "name": "Private", "code": "Private" }, { "name": "Metro", "code": "Metro" }, { "name": "Soos Creek", "code": "Soos Creek" }, { "name": "Seattle", "code": "Seattle" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "length": 12, "domain": null }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "length": 150, "domain": null }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "length": 12, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 20, "domain": null }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R23_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_23", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_23", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S13_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 6, "name": "Sewer Pump Station - Public", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": { "id": 4, "name": "Sewer Pump Stations" }, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "8ff1e89d4b5e08f67c4aa41c401ac5b8", "imageData": "iVBORw0KGgoAAAANSUhEUgAAACAAAAAUCAYAAADskT9PAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC6klEQVRIicWWXUiTURjH/0df92HanM5slqSuj+lUghleaEFEF9YmkVdJGJpodiFhhSwq7aIkguhWjUC6iSCoZiQkUVlmmFqpRZZWRs7RNDXn/NpOnMOWOmdz9EYPHHjOeQ/n/+N5/+95XgH/OQRfi5RSPQCjyFpmQki7XwBKaRWASofNginboGjqSq2+klJ6jhBStSwAdYs3n8zB4FMzxAzNvmKkV9QwCDUhpGQJAKW0eKG4NEKF0LUbQAj5a/FJ61f03a7leXpFTTGltIEQYvaugJFtYuJylRp7bvZCkIdBjHDOTKExL4VDxGYaEZtlqGSe8AZQe5KwuM2LxO/n6eB02H/PQ8IUiEnfhdQj5xEslWOsvwedV47B1tUC1+wMVqnjseVAOTbuL+X7gyUyKDQpmPjWB4eXrwRfxN5lnxz6gjmHHeFxmyCNiIat+zlGP77hILrCs2g+YYDd8hnrtudAolDhU8M1tF86CkWiDtFbd3hO9VkdIZBSxmfnI7ngNB6V7Ya1rQk/3nfAOTuNSesAfy6NjIEmpwhRugzmKkgVKr9nCoEADLU1YWrEykvNYnV8Ei9vgqEQ/Xevov9OHR+ScCV3fcLeAnEBvnc+5iNICOHlTso38fVtpjo+H3hwA5bWRsyMj+Dd9YvsXSKttFo8gKR8E7R5xxESHgESFMzXRj+8xtv6C5izjyOz+hZIsIAn5dmwvnyI4Z4Xfs8UAgEQZKGQKKIWrclUalha7nGTPjPlQpWWyb8KFvMGDBCAulwrhpIp1yDjTD06Lpfx8rMRFCJFYk4Rkg+dWnCm0y+AJVKrd5f1Fcb6uqDQpPJ57sOJP0Ks35nLBzOoa3YassgYDuGJnwO9GO5u5blbw+ILoEqp1RuYe9mN1XgwDWJHbJaRNSWW1i4BIIS0U0pr2V3N5p67W+RmxFLWEc0+PUAIKaGU8oahO1wldjv2iC/fjjEPUStXqfVylTpWNIKV/pC4IdjGJZv/RfwCn5MQ1ic9LSQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 24, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1279687.6823384762, "ymin": 132652.4930228144, "xmax": 1314869.8219477981, "ymax": 158572.9382290542, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "length": 12, "domain": null }, { "name": "SvcPoleID", "type": "esriFieldTypeString", "alias": "Service Pole ID", "length": 12, "domain": null }, { "name": "SvcPoleAddr", "type": "esriFieldTypeString", "alias": "Service Pole Address", "length": 120, "domain": null }, { "name": "SvcPhase", "type": "esriFieldTypeInteger", "alias": "Service Phase", "domain": { "type": "codedValue", "name": "PWSvcPhase", "description": "", "codedValues": [ { "name": "220 V", "code": 220 }, { "name": "440 V", "code": 440 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "length": 20, "domain": { "type": "codedValue", "name": "sewOwnerMaint", "description": "", "codedValues": [ { "name": "Kent", "code": "Kent" }, { "name": "Private", "code": "Private" }, { "name": "Metro", "code": "Metro" }, { "name": "Soos Creek", "code": "Soos Creek" }, { "name": "Seattle", "code": "Seattle" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 20, "domain": { "type": "codedValue", "name": "sewOwnerMaint", "description": "", "codedValues": [ { "name": "Kent", "code": "Kent" }, { "name": "Private", "code": "Private" }, { "name": "Metro", "code": "Metro" }, { "name": "Soos Creek", "code": "Soos Creek" }, { "name": "Seattle", "code": "Seattle" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "length": 12, "domain": null }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "length": 150, "domain": null }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "length": 12, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 20, "domain": null }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R26_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_152_SiteID", "fields": "SiteID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_152_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_26", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_26", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S16_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PS have meters", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FB2F51D1-4902-49BD-A6F7-1DCD7DD8D19F}" }, { "id": 3, "name": "PS have valves", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F4B4617E-21E5-4DF4-9BBF-352913CC4F15}" }, { "id": 4, "name": "PS have drywells", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AA899048-DA68-4613-BEB2-88282B069E24}" }, { "id": 2, "name": "PS have drywells", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BB1E4521-FE19-418D-9E9F-CB2A88C2E664}" }, { "id": 0, "name": "PS have pumps", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{620C8A4C-8301-4418-9507-CF9EEDAA7BF0}" }, { "id": 5, "name": "PS are at sites", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "SiteID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{70757CAD-7D69-4AB3-B964-4922CE095ACE}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 7, "name": "Sewer Site", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": { "id": 4, "name": "Sewer Pump Stations" }, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 168, 56, 0, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 38, 0, 127 ], "width": 0.4 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1279670.6200366318, "ymin": 132105.56006155908, "xmax": 1315264.7440582216, "ymax": 158726.36804030836, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "SiteType", "type": "esriFieldTypeString", "alias": "Site Type", "length": 20, "domain": { "type": "codedValue", "name": "sewSiteType", "description": "", "codedValues": [ { "name": "Pump Station", "code": "Pump Station" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Vactor Site", "code": "Vactor Site" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "length": 10, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R25_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_151_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_25", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_25", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S15_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Sites have PS", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{70757CAD-7D69-4AB3-B964-4922CE095ACE}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "Storm Pump Stations", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 2, "name": "Storm Outfall" }, { "id": 1, "name": "Storm Pump Station - Public" }, { "id": 0, "name": "Storm Site" } ], "minScale": 0, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 1273377.1729778945, "ymin": 116408.71907997131, "xmax": 1378763.83392331, "ymax": 165758.01703472435, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "Storm Outfall", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": { "id": 3, "name": "Storm Pump Stations" }, "subLayers": [], "minScale": 4000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "a6d3273e7fc6c91ad799cffc8ad553d2", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACCElEQVQ4jWNhoBJgoZtB////lwLRjIyMz8g26P///2ln7rybKcDNBmL7MTIybibaoP///xt//PZ7Nj8X62kGBobnpkW7GbxNpBi21Nka//v3P+3bz78m3BzMPoyMjGfxGnTq9rtF/i2HtSamGhmG2cg+R1jAUJ8y+RTDnedfGLbW2W1hYGCQxGvQj59/rzAwMGhF9x5nYGKEKP7P8J8hbepphnl77jO4GkgwMDIynMPrNVCYMDAwXN/V6PDarf6AaGTPcbD4rvMvGP78/c/gbiTBsKHKhoGDjfn0////fZHDjAU5dpYceDhzz4UXYL6yBA/Di/c/wGyQIYyMDAygQM+YdgYkVF8cqAHSIw2LTRQXnbj5lmHhvgdY4oQBFEYMKw8/gvMj7OQYdOX5Mb0GMvnx228hZUGapryczOXpU88wrD76GK6QiZGRYVaOCUOgpcyLL9//LhThY3+AnLZQXCQrzLX237//CaCABRkCCpOd516AbX7z6RfYWwLcbBLBVjKCjIyMFXhjbcXhR9Zzdt1jcDOEBCxnyBoGOVFuhuWlVq9caveLJU48yWCjJWqON9ZAINJOzvXVhx9rUtyUroFih4GBoR4kri3HN311uZXmh6+/DcQF2GsJGgRNsYoFkJj0jXaQZzBUEgRJPbPVFmvAjAYcBqEZuhkUxVA2+ZmWGAOINohYAADLysQYTXpNvgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 1274040.341927141, "ymin": 123333.16553288698, "xmax": 1349589.31714122, "ymax": 164484.75252088904, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PlanName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "FeatureType", "type": "esriFieldTypeString", "alias": "Feature Type", "length": 10, "domain": { "type": "codedValue", "name": "stmIOType", "description": "", "codedValues": [ { "name": "Input", "code": "Input" }, { "name": "Output", "code": "Output" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PumpStationID", "type": "esriFieldTypeString", "alias": "Pump Station ID", "length": 12, "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "stmPipeMaterial", "description": "", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Corrugated Metal Pipe", "code": "CMP" }, { "name": "Cast Iron", "code": "CI" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Concrete", "code": "CONC" }, { "name": "Reinforced Concrete", "code": "RCONC" }, { "name": "Steel", "code": "STL" }, { "name": "Polyethylene", "code": "PEP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Corrugated Polyethylene", "code": "CPEP" }, { "name": "Clay", "code": "CLAY" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EndAccessory", "type": "esriFieldTypeString", "alias": "End Accessory", "length": 20, "domain": { "type": "codedValue", "name": "stmPipeEndAccessory", "description": "", "codedValues": [ { "name": "Bar Screen", "code": "Bar Screen" }, { "name": "Flap Gate", "code": "Flap Gate" }, { "name": "Rubber Check Valve", "code": "Rubber Check Valve" }, { "name": "Open End", "code": "Open End" }, { "name": "None", "code": "None" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall", "type": "esriFieldTypeString", "alias": "Outfall", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DischargeType", "type": "esriFieldTypeString", "alias": "Discharge Type", "length": 10, "domain": { "type": "codedValue", "name": "stmDischargeType", "description": "", "codedValues": [ { "name": "Full", "code": "Full" }, { "name": "Partial", "code": "Partial" }, { "name": "None", "code": "None" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InvertElev", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "OutputBMP", "type": "esriFieldTypeString", "alias": "Output BMP", "length": 25, "domain": { "type": "codedValue", "name": "stmOutputBMP", "description": "", "codedValues": [ { "name": "Splash Block", "code": "Splash Block" }, { "name": "Rock Pad", "code": "Rock Pad" }, { "name": "Dispersion Trench", "code": "Dispersion Trench" }, { "name": "Sheet Flow", "code": "Sheet Flow" }, { "name": "NGRA", "code": "NGRA" }, { "name": "Infiltration Trench", "code": "Infiltration Trench" }, { "name": "Infiltration Depression", "code": "Infiltration Depression" }, { "name": "Level Spreader", "code": "Level Spreader" }, { "name": "None", "code": "None" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "length": 20, "domain": { "type": "codedValue", "name": "stmOwnerMaint", "description": "", "codedValues": [ { "name": "Kent PW", "code": "Kent PW" }, { "name": "Kent Parks", "code": "Kent Parks" }, { "name": "Kent Facilities", "code": "Kent Facilities" }, { "name": "Private", "code": "Private" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "Seatac", "code": "Seatac" }, { "name": "Des Moines", "code": "Des Moines" }, { "name": "Federal Way", "code": "Federal Way" }, { "name": "Auburn", "code": "Auburn" }, { "name": "Covington", "code": "Covington" }, { "name": "Renton", "code": "Renton" }, { "name": "Tukwila", "code": "Tukwila" }, { "name": "King County", "code": "King County" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 20, "domain": { "type": "codedValue", "name": "stmOwnerMaint", "description": "", "codedValues": [ { "name": "Kent PW", "code": "Kent PW" }, { "name": "Kent Parks", "code": "Kent Parks" }, { "name": "Kent Facilities", "code": "Kent Facilities" }, { "name": "Private", "code": "Private" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "Seatac", "code": "Seatac" }, { "name": "Des Moines", "code": "Des Moines" }, { "name": "Federal Way", "code": "Federal Way" }, { "name": "Auburn", "code": "Auburn" }, { "name": "Covington", "code": "Covington" }, { "name": "Renton", "code": "Renton" }, { "name": "Tukwila", "code": "Tukwila" }, { "name": "King County", "code": "King County" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "length": 12, "domain": null }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "length": 150, "domain": null }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "length": 12, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 20, "domain": null }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R44_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_170_PumpStat", "fields": "PumpStationID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_44", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_44", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S34_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Outfalls are at PS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PumpStationID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{120BA5DA-724D-4937-9F07-227BF1C353CA}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Storm Pump Station - Public", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": { "id": 3, "name": "Storm Pump Stations" }, "subLayers": [], "minScale": 100000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Owner", "uniqueValueGroups": [ { "heading": "", "classes": [ { "label": "Kent", "description": "Kent", "symbol": { "type": "esriPMS", "url": "9de379037e573dc3b8cd95ef9c27d241", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAB8AAAAYCAYAAAACqyaBAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACgUlEQVRIie2VW0hUQRiAv7O7ru6ubt7WS1LqS1hWKNZTmj5kFzOiHowSguihhyB6KIIuRmBEFD4Jhd1A6MWikiyQkCQoSStKU0vxlrrYupmXVTdzd+JMhQWuF85iBX0wnDNzmPMx///PjIE/iOG/XJJ1Iwir+RB4ExGKgv/wIpR6KnZd/nXw97BbTXsR4jwoZK60ERtm0mz90D/Gs3dOUATklr2iIq92ernArD62rllMRUEG/iL1cCWv2wcBj/z/jAUXFhyAPwm1GP/Bar9S2c7ZW01TE3QKCdEWTuatIGtVFEJAYVkj1x510OMcI8RkICPZRvGBNJbazNrkQ2MTdDlGUWs/OyWGhs4hqt58pK51gO7r27hT00PBzbeEhxg5ujNJ9u/X2hl1e6gqzNIm/4lOUag8k8nTZifpx6oYHvtKW5+LVrtLfjcZ9axOCGVTagz1nYOEhwQyGwbmiFcIjpfW86SxX/aDjHoSo4PJz4qn+EErvZ/G2XOxRn5btzySC/tS/CcXAs7dbpbvcREmivanEmoJkO39pRxKKttkuF+2DcjobCyopuNqLpHWQO1yvU6hr3S7XHFw0NQ0Nd9qmLekxVJXlC3rYcOpalzuSZq6h1mfbNMuV5luFeMTHsqf9/K4wYFjyP3jMAGrOUDWwEwY0Mjp3cm02keoqLPLKKgsiwuh5OBamRJN8iM7kmTzhZqCeyfSZQQcg27MgQZsi2avdL+ecOpWi4+yzGuOYbrBFvuI3Mdq3rQyMDIhb7Y5yIVXvU5rWwaIyL/r80KYD59dE3i84ntHp/P6lnu85ej1m4Elkx6hOIe/4CcEiCaE5YVv+cP8LiCHBcKwUKK/Tv4NvDjgINAQte4AAAAASUVORK5CYII=", "contentType": "image/png", "width": 23, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Kent PW" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "9de379037e573dc3b8cd95ef9c27d241", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAB8AAAAYCAYAAAACqyaBAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACgUlEQVRIie2VW0hUQRiAv7O7ru6ubt7WS1LqS1hWKNZTmj5kFzOiHowSguihhyB6KIIuRmBEFD4Jhd1A6MWikiyQkCQoSStKU0vxlrrYupmXVTdzd+JMhQWuF85iBX0wnDNzmPMx///PjIE/iOG/XJJ1Iwir+RB4ExGKgv/wIpR6KnZd/nXw97BbTXsR4jwoZK60ERtm0mz90D/Gs3dOUATklr2iIq92ernArD62rllMRUEG/iL1cCWv2wcBj/z/jAUXFhyAPwm1GP/Bar9S2c7ZW01TE3QKCdEWTuatIGtVFEJAYVkj1x510OMcI8RkICPZRvGBNJbazNrkQ2MTdDlGUWs/OyWGhs4hqt58pK51gO7r27hT00PBzbeEhxg5ujNJ9u/X2hl1e6gqzNIm/4lOUag8k8nTZifpx6oYHvtKW5+LVrtLfjcZ9axOCGVTagz1nYOEhwQyGwbmiFcIjpfW86SxX/aDjHoSo4PJz4qn+EErvZ/G2XOxRn5btzySC/tS/CcXAs7dbpbvcREmivanEmoJkO39pRxKKttkuF+2DcjobCyopuNqLpHWQO1yvU6hr3S7XHFw0NQ0Nd9qmLekxVJXlC3rYcOpalzuSZq6h1mfbNMuV5luFeMTHsqf9/K4wYFjyP3jMAGrOUDWwEwY0Mjp3cm02keoqLPLKKgsiwuh5OBamRJN8iM7kmTzhZqCeyfSZQQcg27MgQZsi2avdL+ecOpWi4+yzGuOYbrBFvuI3Mdq3rQyMDIhb7Y5yIVXvU5rWwaIyL/r80KYD59dE3i84ntHp/P6lnu85ej1m4Elkx6hOIe/4CcEiCaE5YVv+cP8LiCHBcKwUKK/Tv4NvDjgINAQte4AAAAASUVORK5CYII=", "contentType": "image/png", "width": 23, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Kent PW", "label": "Kent" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 224, 252, 182, 255 ], "toColor": [ 224, 252, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 252, 255 ], "toColor": [ 252, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 232, 252, 255 ], "toColor": [ 197, 232, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 194, 179, 255 ], "toColor": [ 252, 194, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 182, 252, 255 ], "toColor": [ 179, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 252, 226, 255 ], "toColor": [ 189, 252, 226, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 233, 187, 255 ], "toColor": [ 252, 233, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 242, 255 ], "toColor": [ 252, 215, 242, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 228, 197, 252, 255 ], "toColor": [ 228, 197, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 225, 212, 255 ], "toColor": [ 252, 225, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 189, 255 ], "toColor": [ 179, 252, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 210, 255 ], "toColor": [ 252, 179, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 214, 252, 255 ], "toColor": [ 212, 214, 252, 255 ] } ] } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1279785.4377203882, "ymin": 135108.8129133135, "xmax": 1301233.8305190504, "ymax": 163447.8684398085, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "length": 12, "domain": null }, { "name": "SvcPoleID", "type": "esriFieldTypeString", "alias": "Service Pole ID", "length": 12, "domain": null }, { "name": "SvcPoleAddr", "type": "esriFieldTypeString", "alias": "Service Pole Address", "length": 120, "domain": null }, { "name": "SvcPhase", "type": "esriFieldTypeInteger", "alias": "Service Phase", "domain": { "type": "codedValue", "name": "PWSvcPhase", "description": "", "codedValues": [ { "name": "220 V", "code": 220 }, { "name": "440 V", "code": 440 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "length": 20, "domain": { "type": "codedValue", "name": "stmOwnerMaint", "description": "", "codedValues": [ { "name": "Kent PW", "code": "Kent PW" }, { "name": "Kent Parks", "code": "Kent Parks" }, { "name": "Kent Facilities", "code": "Kent Facilities" }, { "name": "Private", "code": "Private" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "Seatac", "code": "Seatac" }, { "name": "Des Moines", "code": "Des Moines" }, { "name": "Federal Way", "code": "Federal Way" }, { "name": "Auburn", "code": "Auburn" }, { "name": "Covington", "code": "Covington" }, { "name": "Renton", "code": "Renton" }, { "name": "Tukwila", "code": "Tukwila" }, { "name": "King County", "code": "King County" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 20, "domain": { "type": "codedValue", "name": "stmOwnerMaint", "description": "", "codedValues": [ { "name": "Kent PW", "code": "Kent PW" }, { "name": "Kent Parks", "code": "Kent Parks" }, { "name": "Kent Facilities", "code": "Kent Facilities" }, { "name": "Private", "code": "Private" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "Seatac", "code": "Seatac" }, { "name": "Des Moines", "code": "Des Moines" }, { "name": "Federal Way", "code": "Federal Way" }, { "name": "Auburn", "code": "Auburn" }, { "name": "Covington", "code": "Covington" }, { "name": "Renton", "code": "Renton" }, { "name": "Tukwila", "code": "Tukwila" }, { "name": "King County", "code": "King County" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "length": 12, "domain": null }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "length": 150, "domain": null }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "length": 12, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 20, "domain": null }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R45_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_171_SiteID", "fields": "SiteID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_171_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_45", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_45", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S35_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "PS have pumps", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D4F009CF-FD1D-4F19-96E2-0A217ECB7073}" }, { "id": 8, "name": "PS have valves", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C5D81642-0E56-4060-BC42-193B18C44680}" }, { "id": 6, "name": "PS have outfalls", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{120BA5DA-724D-4937-9F07-227BF1C353CA}" }, { "id": 9, "name": "PS have drywells", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9A84339D-A8AD-4F39-858E-BF766030816E}" }, { "id": 10, "name": "PS have meters", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F8A026DF-40C6-4F3F-9A04-C019969FCEBF}" }, { "id": 11, "name": "PS are at sites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SiteID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D3E13ADC-00BC-49BA-935A-29E86E514B09}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Storm Site", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "copyrightText": "", "parentLayer": { "id": 3, "name": "Storm Pump Stations" }, "subLayers": [], "minScale": 100000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 115, 178, 255, 127 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 77, 168, 127 ], "width": 1 } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1273377.1729778945, "ymin": 116408.71907997131, "xmax": 1378763.83392331, "ymax": 165758.01703472435, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2897875299722709E8, "falseY": -1.0960220391086604E8, "xyUnits": 3.447890593683597E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "SiteType", "type": "esriFieldTypeString", "alias": "Site Type", "length": 20, "domain": { "type": "codedValue", "name": "stmSiteType", "description": "", "codedValues": [ { "name": "Pump Station", "code": "Pump Station" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Vactor Site", "code": "Vactor Site" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "length": 10, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R31_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_157_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_31", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_31", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S21_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "Sites have PS", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D3E13ADC-00BC-49BA-935A-29E86E514B09}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "2692327e58f64a72b914232af1beeeae" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 8, "name": "sewDrywells", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R100_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_226_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_100", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_100", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Drywells are in PS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AA899048-DA68-4613-BEB2-88282B069E24}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 9, "name": "sewFlowMeters", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Size", "type": "esriFieldTypeSmallInteger", "alias": "Size", "domain": null }, { "name": "FlowRange", "type": "esriFieldTypeSmallInteger", "alias": "Flow Range", "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R102_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_228_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_102", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_102", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Meters are at PS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FB2F51D1-4902-49BD-A6F7-1DCD7DD8D19F}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 10, "name": "sewImpellers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "GPM", "type": "esriFieldTypeInteger", "alias": "Gallons per Minute", "domain": null }, { "name": "PumpingHead", "type": "esriFieldTypeSmallInteger", "alias": "Pumping Head", "domain": null }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 25, "domain": null }, { "name": "Stage", "type": "esriFieldTypeSmallInteger", "alias": "Stage", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 10, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R105_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_231_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_105", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_105", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "Impellers are on pumps", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4A611769-2901-47FC-912E-4C0199DF3C2E}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 11, "name": "sewMotorControls", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R106_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_232_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_106", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_106", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "Motor control is on pumps", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E82DA780-3012-4CCB-9822-4218D5E9DEDF}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 12, "name": "sewMotors", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Frame", "type": "esriFieldTypeDouble", "alias": "Frame", "domain": null }, { "name": "HP", "type": "esriFieldTypeInteger", "alias": "Horsepower", "domain": null }, { "name": "InsulationClass", "type": "esriFieldTypeString", "alias": "Insulation Class", "length": 5, "domain": null }, { "name": "MAT", "type": "esriFieldTypeSmallInteger", "alias": "Maximum Ambient Temperature", "domain": null }, { "name": "NEMA", "type": "esriFieldTypeString", "alias": "NEMA Design", "length": 5, "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "length": 12, "domain": null }, { "name": "TotalHours", "type": "esriFieldTypeDouble", "alias": "Total Hours", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R104_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_230_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_104", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_104", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "Motors are on pumps", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CCE2D124-300C-4902-8E5D-689C3A4DB9A0}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 13, "name": "sewPumpAssemblies", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "PumpType", "type": "esriFieldTypeString", "alias": "Pump Type", "length": 20, "domain": { "type": "codedValue", "name": "sewPumpType", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Angle Drive", "code": "Angle Drive" }, { "name": "Axial (Line Shaft)", "code": "Axial (Line Shaft)" }, { "name": "Compressor", "code": "Compressor" }, { "name": "Dri-Prime (Electric)", "code": "Dri-Prime (Electric)" }, { "name": "Dri-Prime (Diesel)", "code": "Dri-Prime (Diesel)" }, { "name": "Flooded Suction", "code": "Flooded Suction" }, { "name": "Sump", "code": "Sump" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R99_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_225_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_225_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_99", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_99", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "Pumps have motor control", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E82DA780-3012-4CCB-9822-4218D5E9DEDF}" }, { "id": 12, "name": "Pumps have impellers", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4A611769-2901-47FC-912E-4C0199DF3C2E}" }, { "id": 15, "name": "Pumps have valves", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9D2C3B89-22BF-426A-BFDE-5A2B850304A1}" }, { "id": 14, "name": "Pumps have motors", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CCE2D124-300C-4902-8E5D-689C3A4DB9A0}" }, { "id": 0, "name": "Pumps are at PS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{620C8A4C-8301-4418-9507-CF9EEDAA7BF0}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 14, "name": "sewSiteValves", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ValveType", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 20, "domain": { "type": "codedValue", "name": "sewSiteValveType", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Auma", "code": "Auma" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Gate", "code": "Gate" }, { "name": "Knife", "code": "Knife" }, { "name": "Plug", "code": "Plug" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R103_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_229_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_103", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_103", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Valves are at PS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F4B4617E-21E5-4DF4-9BBF-352913CC4F15}" }, { "id": 15, "name": "Valves are at pumps", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9D2C3B89-22BF-426A-BFDE-5A2B850304A1}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 15, "name": "sewWetwells", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R101_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_227_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_101", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_101", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Drywells are in PS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BB1E4521-FE19-418D-9E9F-CB2A88C2E664}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 16, "name": "stmEngines", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "HP", "type": "esriFieldTypeInteger", "alias": "Horesepower", "domain": null }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "length": 12, "domain": null }, { "name": "HeaterSize", "type": "esriFieldTypeString", "alias": "Heater Size", "length": 12, "domain": null } ], "indexes": [ { "name": "R150_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_150", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_1370_ParentI", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_150", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "Engines serve pumps", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2AA7C8EF-D837-40D7-AE47-604ACCE7F743}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 17, "name": "stmFlowMeters", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "Size", "type": "esriFieldTypeSmallInteger", "alias": "Size", "domain": null }, { "name": "FlowRange", "type": "esriFieldTypeSmallInteger", "alias": "Flow Range", "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R109_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_235_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_109", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_109", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "Meters are at PS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F8A026DF-40C6-4F3F-9A04-C019969FCEBF}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 18, "name": "stmImpellers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "GPM", "type": "esriFieldTypeInteger", "alias": "Gallons per Minute", "domain": null }, { "name": "PumpingHead", "type": "esriFieldTypeSmallInteger", "alias": "Pumping Head", "domain": null }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 25, "domain": null }, { "name": "Stage", "type": "esriFieldTypeSmallInteger", "alias": "Stage", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 10, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R112_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_238_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_112", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_112", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "Impellers are on pumps", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C1262283-D323-410E-90D8-D1B09F3CD709}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 19, "name": "stmMotorControls", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R113_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_239_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_113", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_113", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "Motor control is on pumps", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1C00FDF0-9454-4658-8384-E04EDAE02464}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 20, "name": "stmMotors", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Frame", "type": "esriFieldTypeDouble", "alias": "Frame", "domain": null }, { "name": "HP", "type": "esriFieldTypeInteger", "alias": "Horsepower", "domain": null }, { "name": "InsulationClass", "type": "esriFieldTypeString", "alias": "Insulation Class", "length": 5, "domain": null }, { "name": "MAT", "type": "esriFieldTypeSmallInteger", "alias": "Maximum Ambient Temperature", "domain": null }, { "name": "NEMA", "type": "esriFieldTypeString", "alias": "NEMA Design", "length": 5, "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "length": 12, "domain": null }, { "name": "TotalHours", "type": "esriFieldTypeDouble", "alias": "Total Hours", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R111_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_237_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_111", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_111", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "Motors are on pumps", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2981DAB2-1D32-45ED-9EC5-509F17FEA23C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 21, "name": "stmPSDrywells", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R108_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_234_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_108", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_108", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "Drywells are in PS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9A84339D-A8AD-4F39-858E-BF766030816E}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 22, "name": "stmSiteValves", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ValveType", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 20, "domain": { "type": "codedValue", "name": "stmSiteValveType", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Auma", "code": "Auma" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Gate", "code": "Gate" }, { "name": "Knife", "code": "Knife" }, { "name": "Plug", "code": "Plug" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R110_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_236_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_110", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_110", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Valves are at PS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C5D81642-0E56-4060-BC42-193B18C44680}" }, { "id": 20, "name": "Valves are at pumps", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{38487BFD-1F3A-444D-BCBB-407C4069A76F}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 23, "name": "stmPumpAssemblies", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "PumpType", "type": "esriFieldTypeString", "alias": "Pump Type", "length": 20, "domain": { "type": "codedValue", "name": "stmPumpType", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Angle Drive", "code": "Angle Drive" }, { "name": "Axial (Line Shaft)", "code": "Axial (Line Shaft)" }, { "name": "Compressor", "code": "Compressor" }, { "name": "Dri-Prime (Electric)", "code": "Dri-Prime (Electric)" }, { "name": "Dri-Prime (Diesel)", "code": "Dri-Prime (Diesel)" }, { "name": "Flooded Suction", "code": "Flooded Suction" }, { "name": "Sump", "code": "Sump" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R107_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_233_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_233_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_107", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_107", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 20, "name": "Pumps have valves", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{38487BFD-1F3A-444D-BCBB-407C4069A76F}" }, { "id": 19, "name": "Pumps have motors", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2981DAB2-1D32-45ED-9EC5-509F17FEA23C}" }, { "id": 16, "name": "Pumps have engines", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2AA7C8EF-D837-40D7-AE47-604ACCE7F743}" }, { "id": 17, "name": "Pumps have impellers", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C1262283-D323-410E-90D8-D1B09F3CD709}" }, { "id": 18, "name": "Pumps have motor control", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1C00FDF0-9454-4658-8384-E04EDAE02464}" }, { "id": 21, "name": "Pumps have transmissions", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6B7BF435-741C-445A-BDF8-FE00F55219FD}" }, { "id": 7, "name": "Pumps are at PS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D4F009CF-FD1D-4F19-96E2-0A217ECB7073}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 24, "name": "stmTransmissions", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "length": 255, "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R151_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_151", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_1371_ParentI", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_151", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "Transmissions are on pumps", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6B7BF435-741C-445A-BDF8-FE00F55219FD}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2692327e58f64a72b914232af1beeeae" } ] }