{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 27, "name": "SYSTEM", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SYSTEMID", "type": "esriFieldTypeString", "alias": "SystemID", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 20, "domain": { "type": "codedValue", "name": "DomSystem", "description": "System", "codedValues": [ { "name": "ARCHITECTURAL", "code": "ARCHITECTURAL" }, { "name": "CIVIL", "code": "CIVIL" }, { "name": "ELECTRICAL", "code": "ELECTRICAL" }, { "name": "FIRE", "code": "FIRE" }, { "name": "FLEET", "code": "FLEET" }, { "name": "HVAC", "code": "HVAC" }, { "name": "I&C", "code": "I&C" }, { "name": "IRRIGATION", "code": "IRRIGATION" }, { "name": "IT", "code": "IT" }, { "name": "MECHANICAL", "code": "MECHANICAL" }, { "name": "PLUMBING", "code": "PLUMBING" }, { "name": "SAFETY", "code": "SAFETY" }, { "name": "SECURITY", "code": "SECURITY" }, { "name": "STRUCTURAL", "code": "STRUCTURAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SITEID", "type": "esriFieldTypeString", "alias": "SiteID", "length": 50, "domain": { "type": "codedValue", "name": "DomSiteID", "description": "SiteID", "codedValues": [ { "name": "GRIP", "code": "GRIP" }, { "name": "ADMN", "code": "ADMN" }, { "name": "ANNX", "code": "ANNX" }, { "name": "RWGD", "code": "RWGD" }, { "name": "LJVL", "code": "LJVL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 100, "domain": { "type": "codedValue", "name": "DomLocation", "description": "Location", "codedValues": [ { "name": "ADMIN & LEARNING CENTER", "code": "ADMIN & LEARNING CENTER" }, { "name": "CHEMICAL FACILITIES", "code": "CHEMICAL FACILITIES" }, { "name": "CONTROL BUILDING", "code": "CONTROL BUILDING" }, { "name": "EFFLUENT FACILITIES", "code": "EFFLUENT FACILITIES" }, { "name": "ELECTRICAL FACILITIES", "code": "ELECTRICAL FACILITIES" }, { "name": "GROUNDS", "code": "GROUNDS" }, { "name": "INFLUENT FACILITIES", "code": "INFLUENT FACILITIES" }, { "name": "INJECTION WELL 3", "code": "INJECTION WELL 3" }, { "name": "INTAKE PUMP STATION", "code": "INTAKE PUMP STATION" }, { "name": "INTAKE STRUCTURE", "code": "INTAKE STRUCTURE" }, { "name": "MAIN BUILDING", "code": "MAIN BUILDING" }, { "name": "MF", "code": "MF" }, { "name": "PROCESS BUILDING", "code": "PROCESS BUILDING" }, { "name": "RO", "code": "RO" }, { "name": "SITE GENERAL", "code": "SITE GENERAL" }, { "name": "STABILIZATION & POST-TREATMENT", "code": "STABILIZATION & POST-TREATMENT" }, { "name": "STORAGE BUILDING", "code": "STORAGE BUILDING" }, { "name": "UV", "code": "UV" }, { "name": "WAREHOUSE HYDRO", "code": "WAREHOUSE HYDRO" }, { "name": "WAREHOUSE OPS", "code": "WAREHOUSE OPS" }, { "name": "WAREHOUSE WRD", "code": "WAREHOUSE WRD" }, { "name": "CITY YARD WELL", "code": "CITY YARD WELL" }, { "name": "DELTHORNE PARK WELL", "code": "DELTHORNE PARK WELL" }, { "name": "MADRONA WELL", "code": "MADRONA WELL" }, { "name": "RAW WATER SYSTEM", "code": "RAW WATER SYSTEM" }, { "name": "CIP SYSTEM", "code": "CIP SYSTEM" }, { "name": "AUTO STRAINERS", "code": "AUTO STRAINERS" }, { "name": "BATHROOMS", "code": "BATHROOMS" }, { "name": "BIORETENTION BASIN A", "code": "BIORETENTION BASIN A" }, { "name": "BIORETENTION BASIN B", "code": "BIORETENTION BASIN B" }, { "name": "BIORETENTION BASIN C", "code": "BIORETENTION BASIN C" }, { "name": "BIORETENTION BASIN D", "code": "BIORETENTION BASIN D" }, { "name": "BIORETENTION BASIN E", "code": "BIORETENTION BASIN E" }, { "name": "BREAK ROOM", "code": "BREAK ROOM" }, { "name": "INJECTION WELL 1A", "code": "INJECTION WELL 1A" }, { "name": "LOCKER ROOMS", "code": "LOCKER ROOMS" }, { "name": "OFF-SPEC VAULT", "code": "OFF-SPEC VAULT" }, { "name": "PARKING CANOPY - EAST OF PROCESS BUILDING", "code": "PARKING CANOPY - EAST OF PROCESS BUILDING" }, { "name": "PARKING LOT", "code": "PARKING LOT" }, { "name": "SRW-1A VAULT", "code": "SRW-1A VAULT" }, { "name": "SRW-2 VAULT", "code": "SRW-2 VAULT" }, { "name": "STORMWATER DRAINAGE CHANNEL", "code": "STORMWATER DRAINAGE CHANNEL" }, { "name": "STORMWATER INFILTRATION SYSTEM", "code": "STORMWATER INFILTRATION SYSTEM" }, { "name": "TRASH ENCLOSURE", "code": "TRASH ENCLOSURE" }, { "name": "UF", "code": "UF" }, { "name": "WATER FEATURE VAULT", "code": "WATER FEATURE VAULT" }, { "name": "WATER FEATURES", "code": "WATER FEATURES" }, { "name": "EQUALIZATION BASIN", "code": "EQUALIZATION BASIN" }, { "name": "SRW-3 VAULT", "code": "SRW-3 VAULT" }, { "name": "DECARBONATOR TANK", "code": "DECARBONATOR TANK" }, { "name": "CONTROL ROOM", "code": "CONTROL ROOM" }, { "name": "SERVER ROOM", "code": "SERVER ROOM" }, { "name": "INJECTION WELL 2", "code": "INJECTION WELL 2" }, { "name": "STORAGE ROOM", "code": "STORAGE ROOM" }, { "name": "LABORATORY", "code": "LABORATORY" }, { "name": "WATER TASTING ROOM", "code": "WATER TASTING ROOM" }, { "name": "PARKING CANOPY - EAST OF CHEM STORAGE AREA", "code": "PARKING CANOPY - EAST OF CHEM STORAGE AREA" }, { "name": "Sodium Hydroxide", "code": "Sodium Hydroxide" }, { "name": "Electrical Room 1", "code": "Electrical Room 1" }, { "name": "Decarbonation", "code": "Decarbonation" }, { "name": "Calcium Chloride", "code": "Calcium Chloride" }, { "name": "Primary MF", "code": "Primary MF" }, { "name": "Recovery MF", "code": "Recovery MF" }, { "name": "Injection Well", "code": "Injection Well" }, { "name": "Autostrainers", "code": "Autostrainers" }, { "name": "Influent Diversion Structure", "code": "Influent Diversion Structure" }, { "name": "MF Filtrate Tank", "code": "MF Filtrate Tank" }, { "name": "Control Room", "code": "Control Room" }, { "name": "UV Treatment", "code": "UV Treatment" }, { "name": "RO CIP", "code": "RO CIP" }, { "name": "Product Water Pumps and Storage", "code": "Product Water Pumps and Storage" }, { "name": "RO Flush System", "code": "RO Flush System" }, { "name": "Primary RO", "code": "Primary RO" }, { "name": "TSRO", "code": "TSRO" }, { "name": "RO Perm & Conc Sampling", "code": "RO Perm & Conc Sampling" }, { "name": "Backwash Waste/Recover Feed", "code": "Backwash Waste/Recover Feed" }, { "name": "Electrical Room 2", "code": "Electrical Room 2" }, { "name": "CIT", "code": "CIT" }, { "name": "Mechanical/HVAC", "code": "Mechanical/HVAC" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Sodium Bisulfite", "code": "Sodium Bisulfite" }, { "name": "RO Common/Influent", "code": "RO Common/Influent" }, { "name": "MF Neutralization", "code": "MF Neutralization" }, { "name": "MF CIP", "code": "MF CIP" }, { "name": "Sulfuric Acid", "code": "Sulfuric Acid" }, { "name": "Treshold Inhibitor", "code": "Treshold Inhibitor" }, { "name": "Aq. Ammonia", "code": "Aq. Ammonia" }, { "name": "Brine Disposal", "code": "Brine Disposal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Updated", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R61_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G73SITEID", "fields": "SITEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G73SYSTEMID", "fields": "SYSTEMID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_61", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_61", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "ACTUATOR_VALVE", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D5471A24-8812-4170-A386-A1442CFB801F}" }, { "id": 15, "name": "AIR_COMPRESSOR", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{78A45B04-063C-4E88-83E8-9754673881E3}" }, { "id": 200, "name": "AIR_HANDLING_UNIT", "relatedTableId": 42, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FC875FF9-F171-4A70-BCE6-C052656F51EE}" }, { "id": 199, "name": "AIR_RECEIVER", "relatedTableId": 43, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7BB28952-3A27-4AFF-A72A-C8C505E1B852}" }, { "id": 25, "name": "ANALYZER", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{38C72071-6E92-4AEA-9691-7A37FF070CA6}" }, { "id": 184, "name": "AUTOMATIC_STRAINER", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{474E54DF-1EAC-40EC-8A16-BBB6CB70500F}" }, { "id": 28, "name": "BLOWER", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BA883C7D-B81C-4CB2-A749-70A436C006D4}" }, { "id": 33, "name": "CARTRIDGE_FILTER", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A080F3BB-2046-49BF-BC4F-9246A1A0A0BC}" }, { "id": 42, "name": "CONTROL_PANEL", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3215E9A8-6ACE-4340-BCEC-817602F94966}" }, { "id": 47, "name": "DIFF_PRESSURE_TRANSMITTER", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{01C85946-CA9C-4764-B122-26AC67BD2C50}" }, { "id": 174, "name": "DISTRIBUTION_PANEL", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6BE9D0-F60A-4884-8AE9-BA3097B696D4}" }, { "id": 192, "name": "ELECTRIC_VEHICLE_CHARGE_STATION", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B8427905-31AB-486B-8581-7508E1EB84D3}" }, { "id": 181, "name": "EMERGENCY_SHOWER_AND_EYE_WASH", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F113286-12A0-470E-9F2A-02E31DB44ACE}" }, { "id": 185, "name": "EXHAUST_FAN", "relatedTableId": 50, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{17AD4841-D971-4DD3-ABFD-FC7FF90C5246}" }, { "id": 57, "name": "FLOW_METER", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{01AF3EAD-8C7F-478D-A8FB-A186FB09C1A6}" }, { "id": 187, "name": "FORK_LIFT_RECHARGER", "relatedTableId": 44, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{29B4D8A5-AF73-487C-AFFF-2EA83B208859}" }, { "id": 175, "name": "GENERATOR", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2E009FE2-963C-483E-9B4A-2CC3587070E4}" }, { "id": 64, "name": "HEATER", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{89991948-7874-487F-8039-A78F32C632E2}" }, { "id": 69, "name": "LEVEL_TRANSMITTER", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{49B4CF3B-917C-48F0-A09C-DC5542343557}" }, { "id": 183, "name": "MICROFILTRATION_SKID_RACK", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F78C76D9-ECFC-481B-A853-027F4141D2CD}" }, { "id": 71, "name": "MIXER_AGITATOR", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DE60F939-3855-4C31-BE52-5532C1CC70BA}" }, { "id": 77, "name": "MOTOR", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9CF9A59A-648D-42A5-B2DD-C6C57BE1005F}" }, { "id": 83, "name": "MOTOR_CONTROL_CENTER", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F16F042F-DC37-41D4-942D-E68878D8AD0A}" }, { "id": 85, "name": "PIPES_AND_FITTINGS", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C1156379-E524-4B86-AF85-0BD83DA5B053}" }, { "id": 179, "name": "POWER_DISTRIBUTION_CENTER", "relatedTableId": 46, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3D9AB74F-E15D-44B4-9110-12B795A3A8E8}" }, { "id": 89, "name": "PRESSURE_TRANSMITTER", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{188043FD-CF76-4328-9915-CDD76435EEF2}" }, { "id": 107, "name": "PUMP", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{183C4209-B0A7-4AAA-9BB3-9C29CEC5A7D4}" }, { "id": 115, "name": "RO_VESSEL", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9D2491F4-C036-4A74-A7C1-4DE63A1B74DC}" }, { "id": 194, "name": "SOLAR_PANEL", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C0BBC298-606C-4771-9EF6-13A911F2961F}" }, { "id": 186, "name": "STRAINER", "relatedTableId": 34, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DC4922E4-13A3-4CCA-8140-A81266276025}" }, { "id": 119, "name": "SWITCHBOARD", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FF6F97C1-74C2-4C8C-9998-FC9A7A286602}" }, { "id": 197, "name": "SWITCHES_PROCESS", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E79A4103-0F73-43CC-92FD-3EC7FCB4202C}" }, { "id": 127, "name": "TANK", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2BDF9A98-5684-4A1B-A0DC-D0E9C5A10967}" }, { "id": 132, "name": "TEMPERATURE_TRANSMITTER", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ED4FA5ED-9368-4C9D-95E7-5F2A8DF82CC9}" }, { "id": 176, "name": "TRANSFORMER", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FDAACDCB-E0C8-437C-9F87-A96C67A86FAB}" }, { "id": 191, "name": "ULTRAFILTRATION_SKID", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1098B781-9002-43E1-BE6E-1F096EE1793B}" }, { "id": 195, "name": "UV_LAMP", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3C62650B-0D9D-45A9-A39F-C457E5014BB2}" }, { "id": 193, "name": "UV_REACTOR", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FAFC21C6-209A-430F-8538-82F198D1CC49}" }, { "id": 178, "name": "UV_SENSOR", "relatedTableId": 39, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D713E93-2301-4289-966A-DAFFD035CB8B}" }, { "id": 182, "name": "UV_SLEEVE", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1E9ED5DA-F6BE-48F9-99BA-17BFA4F0CADE}" }, { "id": 135, "name": "VALVE", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B7C7AE01-1EEE-4718-BC94-F28922C90623}" }, { "id": 140, "name": "VARIABLE_FREQUENCY_DRIVE", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8B0CD5BC-208A-4954-8C29-D1D89E6D2B91}" }, { "id": 198, "name": "WELL_CASING", "relatedTableId": 67, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{20D263CD-B562-41DB-AF16-0A552723A84D}" }, { "id": 180, "name": "WELL_PUMP_MOTOR_ASSEMBLY", "relatedTableId": 68, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{87940F0B-7949-4843-846F-CEC67EAD95D8}" }, { "id": 188, "name": "FLOW_SWITCH", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3492090C-9084-4808-BBF6-1A5AEA5FFB89}" }, { "id": 189, "name": "LEVEL_SWITCH", "relatedTableId": 55, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EBC5B8B1-934B-40C7-979F-3CB74F4BFA03}" }, { "id": 177, "name": "PRESSURE_SWITCH", "relatedTableId": 58, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{94F9BA4C-F8CB-4B55-B384-4855934E9BFB}" }, { "id": 190, "name": "TEMPERATURE_SWITCH", "relatedTableId": 61, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{97AF351D-2E29-45DF-AE0D-5526CA45F442}" }, { "id": 196, "name": "UNINTERRUPTIBLE_POWER_SUPPLY", "relatedTableId": 63, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D8065056-B58B-420E-9466-1CF97A383D82}" }, { "id": 173, "name": "WELL", "relatedTableId": 66, "role": "esriRelRoleOrigin", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F5AF22A8-044F-48AE-9EC6-EB5444A30180}" }, { "id": 2, "name": "WRD_SITE", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "SITEID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{59391450-D121-4326-9A68-B3B076BBF446}" }, { "id": 148, "name": "WRD_CMMS_GIS_DEV.DBO.SUB_PROCESS", "relatedTableId": 26, "role": "esriRelRoleDestination", "keyField": "SYSTEMID", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "catalogID": "{55E13D54-6C94-48C1-BC67-A2DBFEEEDC18}", "relationshipTableId": 31, "keyFieldInRelationshipTable": "SYSTEMID" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "6c98ed6080204623a4903c5123106f4e" }