{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 5, "name": "Sewer Cube Launch", "type": "Feature Layer", "parentLayer": { "id": 4, "name": "Sewer Pump Stations" }, "defaultVisibility": false, "minScale": 5000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "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" }, "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" }, "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 }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PlanName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Owner" }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Maint" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "OrigPlan" }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PlanName" }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RefPlan" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Source" }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SpatialConf" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewCubeLaunch", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "Location": null, "Address": null, "Owner": null, "Maint": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "OrigPlan": null, "PlanName": null, "RefPlan": null, "Source": null, "SpatialConf": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 6, "name": "Sewer Pump Station - Public", "type": "Feature Layer", "parentLayer": { "id": 4, "name": "Sewer Pump Stations" }, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "PS have meters", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{FB2F51D1-4902-49BD-A6F7-1DCD7DD8D19F}" }, { "id": 3, "name": "PS have valves", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{F4B4617E-21E5-4DF4-9BBF-352913CC4F15}" }, { "id": 4, "name": "PS have drywells", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{AA899048-DA68-4613-BEB2-88282B069E24}" }, { "id": 2, "name": "PS have drywells", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{BB1E4521-FE19-418D-9E9F-CB2A88C2E664}" }, { "id": 0, "name": "PS have pumps", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{620C8A4C-8301-4418-9507-CF9EEDAA7BF0}" }, { "id": 5, "name": "PS are at sites", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SiteID", "composite": false, "catalogID": "{70757CAD-7D69-4AB3-B964-4922CE095ACE}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "modelName": "GP_935926095", "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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" }, "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" }, "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 }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SiteID" }, { "name": "SvcPoleID", "type": "esriFieldTypeString", "alias": "Service Pole ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SvcPoleID" }, { "name": "SvcPoleAddr", "type": "esriFieldTypeString", "alias": "Service Pole Address", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "SvcPoleAddr" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SvcPhase" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Owner" }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Maint" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "OrigPlan" }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PlanName" }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RefPlan" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Source" }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SpatialConf" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewPumpStations", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "Name": null, "SiteID": null, "SvcPoleID": null, "SvcPoleAddr": null, "SvcPhase": null, "Location": null, "Address": null, "Owner": null, "Maint": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "OrigPlan": null, "PlanName": null, "RefPlan": null, "Source": null, "SpatialConf": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 7, "name": "Sewer Site", "type": "Feature Layer", "parentLayer": { "id": 4, "name": "Sewer Pump Stations" }, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 5, "name": "Sites have PS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{70757CAD-7D69-4AB3-B964-4922CE095ACE}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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" }, "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" }, "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 }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "SiteType", "type": "esriFieldTypeString", "alias": "Site Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SiteType" }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ParcelNumber" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "required": true, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "required": true, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewSites", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "Name": null, "SiteType": null, "ParcelNumber": null, "LifecycleStatus": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "Storm Outfall", "type": "Feature Layer", "parentLayer": { "id": 3, "name": "Storm Pump Stations" }, "defaultVisibility": false, "minScale": 4000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "Outfalls are at PS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PumpStationID", "composite": false, "catalogID": "{120BA5DA-724D-4937-9F07-227BF1C353CA}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "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" }, "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" }, "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 }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PlanName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "FeatureType", "type": "esriFieldTypeString", "alias": "Feature Type", "domain": { "type": "codedValue", "name": "stmIOType", "description": "", "codedValues": [ { "name": "Input", "code": "Input" }, { "name": "Output", "code": "Output" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FeatureType" }, { "name": "PumpStationID", "type": "esriFieldTypeString", "alias": "Pump Station ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "PumpStationID" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Material" }, { "name": "EndAccessory", "type": "esriFieldTypeString", "alias": "End Accessory", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EndAccessory" }, { "name": "Outfall", "type": "esriFieldTypeString", "alias": "Outfall", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Outfall" }, { "name": "DischargeType", "type": "esriFieldTypeString", "alias": "Discharge Type", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "DischargeType" }, { "name": "InvertElev", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InvertElev" }, { "name": "OutputBMP", "type": "esriFieldTypeString", "alias": "Output BMP", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "OutputBMP" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Owner" }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Maint" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "OrigPlan" }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PlanName" }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RefPlan" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Source" }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SpatialConf" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmOpenPipeEnds", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "FeatureType": null, "PumpStationID": null, "Material": null, "EndAccessory": null, "Outfall": null, "DischargeType": null, "InvertElev": null, "OutputBMP": null, "Location": null, "Address": null, "Owner": null, "Maint": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "OrigPlan": null, "PlanName": null, "RefPlan": null, "Source": null, "SpatialConf": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Storm Pump Station - Public", "type": "Feature Layer", "parentLayer": { "id": 3, "name": "Storm Pump Stations" }, "defaultVisibility": true, "minScale": 100000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "PS have pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{D4F009CF-FD1D-4F19-96E2-0A217ECB7073}" }, { "id": 8, "name": "PS have valves", "relatedTableId": 22, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{C5D81642-0E56-4060-BC42-193B18C44680}" }, { "id": 6, "name": "PS have outfalls", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{120BA5DA-724D-4937-9F07-227BF1C353CA}" }, { "id": 9, "name": "PS have drywells", "relatedTableId": 21, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{9A84339D-A8AD-4F39-858E-BF766030816E}" }, { "id": 10, "name": "PS have meters", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{F8A026DF-40C6-4F3F-9A04-C019969FCEBF}" }, { "id": 11, "name": "PS are at sites", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SiteID", "composite": false, "catalogID": "{D3E13ADC-00BC-49BA-935A-29E86E514B09}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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" }, "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" }, "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": [ 252, 197, 243, 255 ], "toColor": [ 252, 197, 243, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 200, 252, 189, 255 ], "toColor": [ 200, 252, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 214, 184, 255 ], "toColor": [ 252, 214, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 234, 252, 255 ], "toColor": [ 197, 234, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 182, 252, 255 ], "toColor": [ 184, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 252, 231, 255 ], "toColor": [ 202, 252, 231, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 245, 179, 255 ], "toColor": [ 252, 245, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 182, 185, 255 ], "toColor": [ 252, 182, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 207, 210, 252, 255 ], "toColor": [ 207, 210, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 216, 255 ], "toColor": [ 252, 215, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 233, 252, 210, 255 ], "toColor": [ 233, 252, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 223, 184, 252, 255 ], "toColor": [ 223, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 194, 220, 255 ], "toColor": [ 252, 194, 220, 255 ] } ] } } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "Owner", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SiteID" }, { "name": "SvcPoleID", "type": "esriFieldTypeString", "alias": "Service Pole ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SvcPoleID" }, { "name": "SvcPoleAddr", "type": "esriFieldTypeString", "alias": "Service Pole Address", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "SvcPoleAddr" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SvcPhase" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owned By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Owner" }, { "name": "Maint", "type": "esriFieldTypeString", "alias": "Maintained By", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Maint" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "OrigPlan", "type": "esriFieldTypeString", "alias": "Original Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "OrigPlan" }, { "name": "PlanName", "type": "esriFieldTypeString", "alias": "Plan Name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PlanName" }, { "name": "RefPlan", "type": "esriFieldTypeString", "alias": "Reference Plan", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RefPlan" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Source" }, { "name": "SpatialConf", "type": "esriFieldTypeSmallInteger", "alias": "Spatial Confidence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SpatialConf" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "Kent PW", "name": "Kent", "domains": { "SvcPhase": {"type": "inherited"}, "Owner": {"type": "inherited"}, "Maint": {"type": "inherited"}, "LifecycleStatus": {"type": "inherited"} }, "templates": [ { "name": "Kent PW", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetNotes": null, "AssetID": null, "LegacyID": null, "Name": null, "SiteID": null, "SvcPoleID": null, "SvcPoleAddr": null, "SvcPhase": null, "Location": null, "Address": null, "Owner": "Kent PW", "Maint": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "OrigPlan": null, "PlanName": null, "RefPlan": null, "Source": null, "SpatialConf": null, "DocLink": null } }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Storm Site", "type": "Feature Layer", "parentLayer": { "id": 3, "name": "Storm Pump Stations" }, "defaultVisibility": true, "minScale": 100000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 11, "name": "Sites have PS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{D3E13ADC-00BC-49BA-935A-29E86E514B09}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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" }, "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" }, "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 }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "SiteType", "type": "esriFieldTypeString", "alias": "Site Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SiteType" }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ParcelNumber" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "required": true, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "required": true, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmSites", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "Name": null, "SiteType": null, "ParcelNumber": null, "LifecycleStatus": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 8, "name": "sewDrywells", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "Drywells are in PS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{AA899048-DA68-4613-BEB2-88282B069E24}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewDrywells", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 9, "name": "sewFlowMeters", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "Meters are at PS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{FB2F51D1-4902-49BD-A6F7-1DCD7DD8D19F}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Size", "type": "esriFieldTypeSmallInteger", "alias": "Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Size" }, { "name": "FlowRange", "type": "esriFieldTypeSmallInteger", "alias": "Flow Range", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FlowRange" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewFlowMeters", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "Size": null, "FlowRange": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 10, "name": "sewImpellers", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 12, "name": "Impellers are on pumps", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{4A611769-2901-47FC-912E-4C0199DF3C2E}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "GPM", "type": "esriFieldTypeInteger", "alias": "Gallons per Minute", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GPM" }, { "name": "PumpingHead", "type": "esriFieldTypeSmallInteger", "alias": "Pumping Head", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PumpingHead" }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Diameter" }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPM" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Size" }, { "name": "Stage", "type": "esriFieldTypeSmallInteger", "alias": "Stage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Stage" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Type" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewImpellers", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "GPM": null, "PumpingHead": null, "Diameter": null, "RPM": null, "Size": null, "Stage": null, "Type": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 11, "name": "sewMotorControls", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 13, "name": "Motor control is on pumps", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{E82DA780-3012-4CCB-9822-4218D5E9DEDF}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewMotorControls", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 12, "name": "sewMotors", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 14, "name": "Motors are on pumps", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{CCE2D124-300C-4902-8E5D-689C3A4DB9A0}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Frame", "type": "esriFieldTypeDouble", "alias": "Frame", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frame" }, { "name": "HP", "type": "esriFieldTypeInteger", "alias": "Horsepower", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HP" }, { "name": "InsulationClass", "type": "esriFieldTypeString", "alias": "Insulation Class", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "InsulationClass" }, { "name": "MAT", "type": "esriFieldTypeSmallInteger", "alias": "Maximum Ambient Temperature", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAT" }, { "name": "NEMA", "type": "esriFieldTypeString", "alias": "NEMA Design", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "NEMA" }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPM" }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Volts" }, { "name": "TotalHours", "type": "esriFieldTypeDouble", "alias": "Total Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalHours" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewMotors", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Frame": null, "HP": null, "InsulationClass": null, "MAT": null, "NEMA": null, "Phase": null, "RPM": null, "Volts": null, "TotalHours": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 13, "name": "sewPumpAssemblies", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 13, "name": "Pumps have motor control", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{E82DA780-3012-4CCB-9822-4218D5E9DEDF}" }, { "id": 12, "name": "Pumps have impellers", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{4A611769-2901-47FC-912E-4C0199DF3C2E}" }, { "id": 15, "name": "Pumps have valves", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{9D2C3B89-22BF-426A-BFDE-5A2B850304A1}" }, { "id": 14, "name": "Pumps have motors", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{CCE2D124-300C-4902-8E5D-689C3A4DB9A0}" }, { "id": 0, "name": "Pumps are at PS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{620C8A4C-8301-4418-9507-CF9EEDAA7BF0}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "PumpType", "type": "esriFieldTypeString", "alias": "Pump Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PumpType" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewPumpAssemblies", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "PumpType": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 14, "name": "sewSiteValves", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "Valves are at PS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{F4B4617E-21E5-4DF4-9BBF-352913CC4F15}" }, { "id": 15, "name": "Valves are at pumps", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{9D2C3B89-22BF-426A-BFDE-5A2B850304A1}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ValveType", "type": "esriFieldTypeString", "alias": "Valve Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ValveType" }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Size" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewSiteValves", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ValveType": null, "Size": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 15, "name": "sewWetwells", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "Drywells are in PS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{BB1E4521-FE19-418D-9E9F-CB2A88C2E664}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sewWetwells", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 16, "name": "stmEngines", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 16, "name": "Engines serve pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{2AA7C8EF-D837-40D7-AE47-604ACCE7F743}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "HP", "type": "esriFieldTypeInteger", "alias": "Horesepower", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HP" }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Volts" }, { "name": "HeaterSize", "type": "esriFieldTypeString", "alias": "Heater Size", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "HeaterSize" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmEngines", "description": "", "prototype": { "attributes": { "Volts": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null, "OtherNotes": null, "HeaterSize": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "HP": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 17, "name": "stmFlowMeters", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 10, "name": "Meters are at PS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{F8A026DF-40C6-4F3F-9A04-C019969FCEBF}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Size", "type": "esriFieldTypeSmallInteger", "alias": "Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Size" }, { "name": "FlowRange", "type": "esriFieldTypeSmallInteger", "alias": "Flow Range", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FlowRange" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmFlowMeters", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "Size": null, "FlowRange": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 18, "name": "stmImpellers", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 17, "name": "Impellers are on pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{C1262283-D323-410E-90D8-D1B09F3CD709}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "GPM", "type": "esriFieldTypeInteger", "alias": "Gallons per Minute", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GPM" }, { "name": "PumpingHead", "type": "esriFieldTypeSmallInteger", "alias": "Pumping Head", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PumpingHead" }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Diameter" }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPM" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Size" }, { "name": "Stage", "type": "esriFieldTypeSmallInteger", "alias": "Stage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Stage" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Type" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmImpellers", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "GPM": null, "PumpingHead": null, "Diameter": null, "RPM": null, "Size": null, "Stage": null, "Type": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 19, "name": "stmMotorControls", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 18, "name": "Motor control is on pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{1C00FDF0-9454-4658-8384-E04EDAE02464}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmMotorControls", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 20, "name": "stmMotors", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 19, "name": "Motors are on pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{2981DAB2-1D32-45ED-9EC5-509F17FEA23C}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Frame", "type": "esriFieldTypeDouble", "alias": "Frame", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Frame" }, { "name": "HP", "type": "esriFieldTypeInteger", "alias": "Horsepower", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HP" }, { "name": "InsulationClass", "type": "esriFieldTypeString", "alias": "Insulation Class", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "InsulationClass" }, { "name": "MAT", "type": "esriFieldTypeSmallInteger", "alias": "Maximum Ambient Temperature", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAT" }, { "name": "NEMA", "type": "esriFieldTypeString", "alias": "NEMA Design", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "NEMA" }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPM" }, { "name": "Volts", "type": "esriFieldTypeString", "alias": "Volts", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Volts" }, { "name": "TotalHours", "type": "esriFieldTypeDouble", "alias": "Total Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalHours" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmMotors", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Frame": null, "HP": null, "InsulationClass": null, "MAT": null, "NEMA": null, "Phase": null, "RPM": null, "Volts": null, "TotalHours": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 21, "name": "stmPSDrywells", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 9, "name": "Drywells are in PS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{9A84339D-A8AD-4F39-858E-BF766030816E}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmPSDrywells", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 22, "name": "stmSiteValves", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 8, "name": "Valves are at PS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{C5D81642-0E56-4060-BC42-193B18C44680}" }, { "id": 20, "name": "Valves are at pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{38487BFD-1F3A-444D-BCBB-407C4069A76F}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ValveType", "type": "esriFieldTypeString", "alias": "Valve Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ValveType" }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Size" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmSiteValves", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "ValveType": null, "Size": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 23, "name": "stmPumpAssemblies", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 20, "name": "Pumps have valves", "relatedTableId": 22, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{38487BFD-1F3A-444D-BCBB-407C4069A76F}" }, { "id": 19, "name": "Pumps have motors", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{2981DAB2-1D32-45ED-9EC5-509F17FEA23C}" }, { "id": 16, "name": "Pumps have engines", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{2AA7C8EF-D837-40D7-AE47-604ACCE7F743}" }, { "id": 17, "name": "Pumps have impellers", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{C1262283-D323-410E-90D8-D1B09F3CD709}" }, { "id": 18, "name": "Pumps have motor control", "relatedTableId": 19, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{1C00FDF0-9454-4658-8384-E04EDAE02464}" }, { "id": 21, "name": "Pumps have transmissions", "relatedTableId": 24, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{6B7BF435-741C-445A-BDF8-FE00F55219FD}" }, { "id": 7, "name": "Pumps are at PS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{D4F009CF-FD1D-4F19-96E2-0A217ECB7073}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "PumpType", "type": "esriFieldTypeString", "alias": "Pump Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PumpType" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmPumpAssemblies", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "LegacyID": null, "PumpType": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 24, "name": "stmTransmissions", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 21, "name": "Transmissions are on pumps", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{6B7BF435-741C-445A-BDF8-FE00F55219FD}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "DocLink", "type": "esriFieldTypeString", "alias": "Document Link", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DocLink" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stmTransmissions", "description": "", "prototype": { "attributes": { "last_edited_user": null, "AssetID": null, "LegacyID": null, "ParentID": null, "Name": null, "Location": null, "Address": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "DocLink": null, "AssetNotes": null, "OtherNotes": null, "last_edited_date": null, "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ce7f50fe383141dbb7555672edd51c3e" } ] }