{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 69, "name": "MasterMeter_Vaults", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 172, "name": "Electrical_Equipment_MMC1", "relatedTableId": 50, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{D8004AF9-27AA-463B-9C64-10533A4FD58B}" }, { "id": 182, "name": "Electrical_Equipment_Pump_Control", "relatedTableId": 55, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{A882EFE6-3E2E-4B34-A2FC-5E2D83AAD7EB}" }, { "id": 192, "name": "Electrical_Equipment_Transformer", "relatedTableId": 60, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{03107D0C-C551-49E1-98B4-67FC2BFE89DF}" }, { "id": 175, "name": "Electrical_Equipment_MMC2", "relatedTableId": 51, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{7E418F7C-479A-4620-BFD5-7A60D7181F6E}" }, { "id": 186, "name": "Electrical_Equipment_Secondary_Panel", "relatedTableId": 57, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{1D986C78-A22B-4812-9181-208630E0821E}" }, { "id": 190, "name": "Electrical_Equipment_Transfer_Switch", "relatedTableId": 59, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{24B88D3F-8C13-4FAD-8DE8-347E7985C803}" }, { "id": 195, "name": "Electrical_Equipment_MMC4", "relatedTableId": 95, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{70EEC443-7CB1-4BAD-96AA-C1D73C29ED48}" }, { "id": 185, "name": "Electrical_Equipment_RTU", "relatedTableId": 56, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{D67251AC-7C92-471D-B6B2-93B0CBA53B7B}" }, { "id": 177, "name": "Electrical_Equipment_MMC3", "relatedTableId": 52, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{F84704DD-85BD-4726-BAEC-9EB551E3A47A}" }, { "id": 170, "name": "Electrical_Equipment_MainDisconnect", "relatedTableId": 49, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{39A759F5-75A5-4DD6-B718-4EBB11F6E560}" }, { "id": 196, "name": "Electrical_Equipment_MMC5", "relatedTableId": 96, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{092BA98D-108C-418D-8A41-788B4A966566}" }, { "id": 179, "name": "Electrical_Equipment_MMC6", "relatedTableId": 53, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{91D61BFB-3D59-4AC4-916D-054E3EF3D3FE}" }, { "id": 169, "name": "Electrical_Equipment_Communication_Pole", "relatedTableId": 48, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{1E2C75DB-C649-4C60-A585-2B342F038153}" }, { "id": 189, "name": "Electrical_Equipment_Service", "relatedTableId": 58, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{9C917986-081A-40AB-94A2-D5D00B3803B1}" }, { "id": 181, "name": "Electrical_Equipment_Primary_Power_Panel", "relatedTableId": 54, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Vault_ID", "composite": false, "catalogID": "{A5D9B61C-1EF7-4604-AFE7-F9A4955CC971}" }, { "id": 101, "name": "Master_Meter", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Master_Meter_ID", "composite": false, "catalogID": "{E5460FA2-1FE7-4469-8FB1-E0680D77433B}" } ], "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": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SITE_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SITE_NAME", "type": "esriFieldTypeString", "alias": "SITE NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE_NAME" }, { "name": "SIZE_", "type": "esriFieldTypeString", "alias": "SIZE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIZE_" }, { "name": "Serial_Number", "type": "esriFieldTypeString", "alias": "Serial_Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Serial_Number" }, { "name": "Master_Meter_ID", "type": "esriFieldTypeString", "alias": "Master_Meter_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Master_Meter_ID" }, { "name": "Vault_ID", "type": "esriFieldTypeString", "alias": "Vault_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Vault_ID" }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Manufacture" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status_1", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "Condition_Rating", "type": "esriFieldTypeString", "alias": "Condition_Rating", "domain": { "type": "codedValue", "name": "Condition_Rating", "description": "", "codedValues": [ { "name": "0-UNKNOWN", "code": "0-UNKNOWN" }, { "name": "1-NEW OR EXCELLENT CONDITION", "code": "1-NEW OR EXCELLENT CONDITION" }, { "name": "2-MINOR DEFECTS ONLY", "code": "2-MINOR DEFECTS ONLY" }, { "name": "3-MODERATE DETERIORATION", "code": "3-MODERATE DETERIORATION" }, { "name": "4-SIGNIFICANT DETERIORATION", "code": "4-SIGNIFICANT DETERIORATION" }, { "name": "5-VIRTUALLY UNSERVICEABLE", "code": "5-VIRTUALLY UNSERVICEABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Condition_Rating" } ], "indexes": [ { "name": "R406_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G761Vault_ID", "fields": "Vault_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G761Master_Meter", "fields": "Master_Meter_ID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MasterMeter_Vaults", "description": "", "prototype": { "attributes": { "Status": null, "Condition_Rating": null, "SITE_NAME": null, "SIZE_": null, "Serial_Number": null, "Master_Meter_ID": null, "Vault_ID": null, "Manufacture": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }