{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 28, "name": "FLOOR", "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": "FLOORID", "type": "esriFieldTypeString", "alias": "FloorID", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 20, "domain": { "type": "codedValue", "name": "DomFloorName", "description": "Floor name", "codedValues": [ { "name": "FIRST FLOOR", "code": "FIRST FLOOR" }, { "name": "SECOND FLOOR", "code": "SECOND FLOOR" }, { "name": "THIRD FLOOR", "code": "THIRD FLOOR" }, { "name": "ROOF", "code": "ROOF" }, { "name": "BASEMENT", "code": "BASEMENT" }, { "name": "GROUND", "code": "GROUND" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATIONID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 50, "domain": { "type": "codedValue", "name": "DomLocationID", "description": "LocationID", "codedValues": [ { "name": "GRIP - ADMIN & LEARNING CENTER", "code": "GRIP_9000_ADMIN_&_LEARNING_CENTER" }, { "name": "GRIP - PROCESS BUILDING", "code": "GRIP_9000_PROCESS_BUILDING" }, { "name": "ADMN - SITE GENERAL", "code": "ADMN - SITE GENERAL" }, { "name": "ANNX - SITE GENERAL", "code": "ANNX_SITE_GENERAL" }, { "name": "LJVL - RO", "code": "LJVL_RO" }, { "name": "LJVL - UV", "code": "LJVL_UV" }, { "name": "LJVL - MF", "code": "LJVL_MF" }, { "name": "LJVL - CHEMICAL FACILITIES", "code": "LJVL_CHEMICAL_FACILITIES" }, { "name": "LJVL - CONTROL BUILDING", "code": "LJVL_CONTROL_BUILDING" }, { "name": "LJVL - STORAGE BUILDING", "code": "LJVL_STORAGE_BUILDING" }, { "name": "LJVL - EFFLUENT FACILITIES", "code": "LJVL_EFFLUENT_FACILITIES" }, { "name": "LJVL - STABILIZATION & POST-TREATMENT", "code": "LJVL_STABILIZATION_&_POSTTREATMENT" }, { "name": "LJVL - INFLUENT FACILITIES", "code": "LJVL_INFLUENT_FACILITIES" }, { "name": "LJVL - ELECTRICAL FACILITIES", "code": "LJVL_ELECTRICAL_FAC" }, { "name": "LJVL - SITE GENERAL", "code": "LJVL_SITE_GENERAL" }, { "name": "RGWD - CIP SYSTEM", "code": "RGWD - CIP SYSTEM" }, { "name": "RWGD - RO", "code": "RWGD - RO" }, { "name": "RWGD - MADRONA WELL", "code": "RWGD - MADRONA WELL" }, { "name": "RWGD - CITY YARD WELL", "code": "RWGD - CITY YARD WELL" }, { "name": "RWGD - CHEMICAL FACILITIES", "code": "RWGD - CHEMICAL FACILITIES" }, { "name": "RWGD - EFFLUENT FACILITIES", "code": "RWGD - EFFLUENT FACILITIES" }, { "name": "RWGD - RAW WATER SYSTEM", "code": "RWGD - RAW WATER SYSTEM" }, { "name": "RWGD - CONTROL BUILDING", "code": "RWGD - CONTROL BUILDING" }, { "name": "RWGD - ELECTRICAL FACILITIES", "code": "RWGD - ELECTRICAL FACILITIES" }, { "name": "RWGD - DELTHORNE PARK WELL", "code": "RWGD - DELTHORNE PARK WELL" }, { "name": "RWGD - SITE GENERAL", "code": "RWGD - SITE GENERAL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTUPDATED", "type": "esriFieldTypeDate", "alias": "Last Updated", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R35_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G47FLOORID", "fields": "FLOORID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G47LOCATIONID", "fields": "LOCATIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_35", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_35", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "ACTUATOR_VALVE", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5772533A-3D0F-4C76-A821-AE8A9FBE0B46}" }, { "id": 14, "name": "AIR_COMPRESSOR", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BAA639EA-A29F-4BAD-9399-027C777C4277}" }, { "id": 227, "name": "AIR_HANDLING_UNIT", "relatedTableId": 42, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{206223DC-45F1-4A77-A4CA-4D4D443C45B8}" }, { "id": 215, "name": "AIR_RECEIVER", "relatedTableId": 43, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C97665F6-00E4-4D94-9822-62425FD961A3}" }, { "id": 20, "name": "ANALYZER", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EBCB5362-9788-46EB-8563-328F706924AC}" }, { "id": 202, "name": "AUTOMATIC_STRAINER", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D61A2B9E-4958-4D42-A9CC-A8628AF507E2}" }, { "id": 30, "name": "BLOWER", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{642FF1FC-A91D-4F79-B4DE-E0BE9F6102E9}" }, { "id": 32, "name": "CARTRIDGE_FILTER", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AD210C3A-E2F2-4270-85D8-C5260A999B20}" }, { "id": 38, "name": "CONTROL_PANEL", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0A3804FB-EE68-410A-BE30-E042AF56D191}" }, { "id": 48, "name": "DIFF_PRESSURE_TRANSMITTER", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A2B5011-857A-40FF-8B89-CEA9CCEE1DD2}" }, { "id": 223, "name": "DISTRIBUTION_PANEL", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9128E5D0-2AD8-4F89-9FF9-87DE16F47AE0}" }, { "id": 201, "name": "ELECTRIC_VEHICLE_CHARGE_STATION", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{686F08A1-746D-4490-81E4-799F65C65127}" }, { "id": 208, "name": "EMERGENCY_SHOWER_AND_EYE_WASH", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FD42AFF9-5D43-4705-8747-31A82CD22958}" }, { "id": 226, "name": "EXHAUST_FAN", "relatedTableId": 50, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4399D325-5448-456C-B871-0AF95F22FA1D}" }, { "id": 58, "name": "FLOW_METER", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{75E43CCB-D0C2-4526-8A4A-EBEB160C77D1}" }, { "id": 230, "name": "FORK_LIFT_RECHARGER", "relatedTableId": 44, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AECBA33E-EA6A-4335-9862-77D5F4BA9B70}" }, { "id": 224, "name": "GENERATOR", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{72F708FD-ADEF-44FB-8CF4-40B873EF8B6B}" }, { "id": 63, "name": "HEATER", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1C6CC0A0-59E6-4517-88BB-7C4AEFC32B8F}" }, { "id": 68, "name": "LEVEL_TRANSMITTER", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DCDA5A30-4383-4F79-AED9-C0E171BED546}" }, { "id": 221, "name": "MICROFILTRATION_SKID_RACK", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F92D1E0A-61D0-4488-9832-FBB9DECFF465}" }, { "id": 72, "name": "MIXER_AGITATOR", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C3EB5A98-1D40-4BA1-AB28-B867AE05269E}" }, { "id": 79, "name": "MOTOR", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7EDA17DD-FA41-4D9B-A3EF-D8923E480753}" }, { "id": 84, "name": "MOTOR_CONTROL_CENTER", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F2730694-239B-417F-BFEC-E8D05C91A331}" }, { "id": 86, "name": "PIPES_AND_FITTINGS", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3459CB57-6CCC-4CD5-A664-1C526294C61A}" }, { "id": 205, "name": "POWER_DISTRIBUTION_CENTER", "relatedTableId": 46, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8F1B225D-8EC5-4956-BC44-17FE31614422}" }, { "id": 93, "name": "PRESSURE_TRANSMITTER", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D6027DD2-348D-4CCD-9273-5550D918E034}" }, { "id": 104, "name": "PUMP", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7C77EE0A-36F9-4900-8E4D-7E8875C36DB8}" }, { "id": 116, "name": "RO_VESSEL", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9196049C-90C0-46E7-B95E-FAB9F2A57CBA}" }, { "id": 225, "name": "ROOM", "relatedTableId": 41, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{71F9FFD3-4310-47F5-8B10-EF6090961498}" }, { "id": 222, "name": "SOLAR_PANEL", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{39CE6000-D70C-425E-8630-F3EF3C813860}" }, { "id": 216, "name": "STRAINER", "relatedTableId": 34, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1969B092-76FB-41D0-841E-08001F331EA9}" }, { "id": 121, "name": "SWITCHBOARD", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D6074E86-0BE5-4364-8959-20B6108DA127}" }, { "id": 212, "name": "SWITCHES_PROCESS", "relatedTableId": 35, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{39715C2C-2938-49C4-B1BF-D0B67B441EC3}" }, { "id": 129, "name": "TANK", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6DF92F53-8212-4EC9-A360-29AD3BB0BEC2}" }, { "id": 131, "name": "TEMPERATURE_TRANSMITTER", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{19EBBDEE-32C9-4D0A-8B12-6809912EFC99}" }, { "id": 219, "name": "TRANSFORMER", "relatedTableId": 36, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{52A32937-792C-49FE-956B-32DCB9FE42D9}" }, { "id": 210, "name": "ULTRAFILTRATION_SKID", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D53EE618-8709-4C72-B5E3-F8189DE07FBD}" }, { "id": 232, "name": "UV_LAMP", "relatedTableId": 37, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C2A804DA-7AF4-49D2-8F72-FF637003745F}" }, { "id": 220, "name": "UV_REACTOR", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0D645D79-7F1E-4D57-8275-F2D44BF15925}" }, { "id": 207, "name": "UV_SENSOR", "relatedTableId": 39, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EE4E3A85-4B00-4E17-8E1F-3D2715477601}" }, { "id": 218, "name": "UV_SLEEVE", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1166D7E-FE55-4092-9731-E2E78B38C3B3}" }, { "id": 134, "name": "VALVE", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7C0FF602-D12C-459F-A5E6-33F3F88F981C}" }, { "id": 142, "name": "VARIABLE_FREQUENCY_DRIVE", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{185862BE-B4AB-4517-AD59-6D10A50E6ED7}" }, { "id": 209, "name": "WELL_CASING", "relatedTableId": 67, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D806AAEA-C77C-40C8-891D-47B978D2C4B9}" }, { "id": 206, "name": "WELL_PUMP_MOTOR_ASSEMBLY", "relatedTableId": 68, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{47788896-A8D9-4E95-ACB4-943205552F2E}" }, { "id": 217, "name": "FLOW_SWITCH", "relatedTableId": 52, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D4336979-7A87-4B40-93F0-5ADE245335EB}" }, { "id": 204, "name": "LEVEL_SWITCH", "relatedTableId": 55, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B67CE26C-7EE9-4739-B5C6-437EA5040D9D}" }, { "id": 211, "name": "PRESSURE_SWITCH", "relatedTableId": 58, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DA9277A8-AB81-41B0-8BDE-D3D97E40F101}" }, { "id": 214, "name": "TEMPERATURE_SWITCH", "relatedTableId": 61, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3697E60C-4C3C-4FC0-8989-CEAA61F3186C}" }, { "id": 229, "name": "WELL", "relatedTableId": 66, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8685390B-3D2B-4749-B4F7-2EADBC82398A}" }, { "id": 231, "name": "UNINTERRUPTIBLE_POWER_SUPPLY", "relatedTableId": 63, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DAF28B12-9779-45AF-A0C7-501413F6D108}" }, { "id": 203, "name": "AIR_CONDITIONING_UNIT", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{420BF45D-BD0C-4337-8F08-F1204768BD15}" }, { "id": 213, "name": "AIR_CONDITIONING_UNIT", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{558D556D-9440-4BC2-994D-438561A6282F}" }, { "id": 228, "name": "AIR_CONDITIONING_UNIT", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "FLOORID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6DCE3760-EB2B-42FD-9AE1-15593D7672DF}" }, { "id": 0, "name": "WRD_LOCATION", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "LOCATIONID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{298CBC74-47DB-4875-A0F1-3EF796751713}" } ], "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" }