{ "currentVersion": 10.91, "id": 113, "name": "faHVAC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "ENABLED", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FEATURESTATUS", "type": "esriFieldTypeString", "alias": "FEATURESTATUS", "length": 20, "domain": { "type": "codedValue", "name": "FeatureStatus", "description": "Feature status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Not In Use", "code": "Not In Use" }, { "name": "Capped", "code": "Capped" }, { "name": "Warehouse", "code": "Warehouse" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Exigent", "code": "Exigent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FEATURETYPE", "type": "esriFieldTypeString", "alias": "FEATURETYPE", "length": 30, "domain": { "type": "codedValue", "name": "faHVACType", "description": "Type of HVAC component", "codedValues": [ { "name": "Air Handler", "code": "Air Handler" }, { "name": "Boiler", "code": "Boiler" }, { "name": "Chiller", "code": "Chiller" }, { "name": "Circulation Pump", "code": "Circulation Pump" }, { "name": "Condenser", "code": "Condenser" }, { "name": "Cooling Tower", "code": "Cooling Tower" }, { "name": "Exhaust Fan", "code": "Exhaust Fan" }, { "name": "Fan Coil Unit", "code": "Fan Coil Unit" }, { "name": "Furnace (Electric)", "code": "Furnace (Electric)" }, { "name": "Furnace (Gas)", "code": "Furnace (Gas)" }, { "name": "Heat Pump", "code": "Heat Pump" }, { "name": "Heater (Electric)", "code": "Heater (Electric)" }, { "name": "Heater (Gas)", "code": "Heater (Gas)" }, { "name": "Heater (Radiant)", "code": "Heater (Radiant)" }, { "name": "Hot Water Heater", "code": "Hot Water Heater" }, { "name": "Mini Splits", "code": "Mini Splits" }, { "name": "Pump (Other)", "code": "Pump (Other)" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EQDESCRIPTION", "type": "esriFieldTypeString", "alias": "EQDESCRIPTION", "length": 100, "domain": null }, { "name": "AREA_WING", "type": "esriFieldTypeString", "alias": "AREA_WING", "length": 30, "domain": { "type": "codedValue", "name": "faAreaWing", "description": "Area or wing of building", "codedValues": [ { "name": "CC- Admin", "code": "CC- Admin" }, { "name": "CC- Gym", "code": "CC- Gym" }, { "name": "CC- Lower Floor", "code": "CC- Lower Floor" }, { "name": "CC- Other", "code": "CC- Other" }, { "name": "CC- Outside", "code": "CC- Outside" }, { "name": "CC- Roof", "code": "CC- Roof" }, { "name": "CC- Slater", "code": "CC- Slater" }, { "name": "CC- Upper Floor", "code": "CC- Upper Floor" }, { "name": "CCX- Annex Bldg", "code": "CCX- Annex Bldg" }, { "name": "CCX- Outside", "code": "CCX- Outside" }, { "name": "CH- City Manager", "code": "CH- City Manager" }, { "name": "CH- Council Chambers", "code": "CH- Council Chambers" }, { "name": "CH- Court", "code": "CH- Court" }, { "name": "CH- DSG", "code": "CH- DSG" }, { "name": "CH- EOC", "code": "CH- EOC" }, { "name": "CH- Evidence Room", "code": "CH- Evidence Room" }, { "name": "CH- Exercise-Locker Rooms", "code": "CH- Exercise-Locker Rooms" }, { "name": "CH- Finance", "code": "CH- Finance" }, { "name": "CH- Front Lobby", "code": "CH- Front Lobby" }, { "name": "CH- Other", "code": "CH- Other" }, { "name": "CH- Outside", "code": "CH- Outside" }, { "name": "CH- PD Locker Rooms", "code": "CH- PD Locker Rooms" }, { "name": "CH- PD Storage", "code": "CH- PD Storage" }, { "name": "CH- Police", "code": "CH- Police" }, { "name": "FS91- Admin Area", "code": "FS91- Admin Area" }, { "name": "FS91- Apparatus Bay", "code": "FS91- Apparatus Bay" }, { "name": "FS91- Living Area", "code": "FS91- Living Area" }, { "name": "FS91- Lobby", "code": "FS91- Lobby" }, { "name": "FS91- Other", "code": "FS91- Other" }, { "name": "FS91- Outside", "code": "FS91- Outside" }, { "name": "FS91- Roof", "code": "FS91- Roof" }, { "name": "FS92- Admin Area", "code": "FS92- Admin Area" }, { "name": "FS92- Apparatus Bay", "code": "FS92- Apparatus Bay" }, { "name": "FS92- Living Area", "code": "FS92- Living Area" }, { "name": "FS92- Lobby", "code": "FS92- Lobby" }, { "name": "FS92- Other", "code": "FS92- Other" }, { "name": "FS92- Outside", "code": "FS92- Outside" }, { "name": "FS92- Roof", "code": "FS92- Roof" }, { "name": "LBA- Lower Floor", "code": "LBA- Lower Floor" }, { "name": "LBA- Main Floor", "code": "LBA- Main Floor" }, { "name": "LBA- Other", "code": "LBA- Other" }, { "name": "LBA- Outside", "code": "LBA- Outside" }, { "name": "LBA- Upper Floor", "code": "LBA- Upper Floor" }, { "name": "LBC- Caretaker", "code": "LBC- Caretaker" }, { "name": "PW- Lower Floor", "code": "PW- Lower Floor" }, { "name": "PW- Mechanic Shop", "code": "PW- Mechanic Shop" }, { "name": "PW- Other", "code": "PW- Other" }, { "name": "PW- Roof", "code": "PW- Roof" }, { "name": "PW- Upper Floor", "code": "PW- Upper Floor" }, { "name": "PW- Warehouse", "code": "PW- Warehouse" }, { "name": "TS- Lower Floor", "code": "TS- Lower Floor" }, { "name": "TS- Other", "code": "TS- Other" }, { "name": "TS- Roof", "code": "TS- Roof" }, { "name": "TS- Upper Floor", "code": "TS- Upper Floor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOOR", "type": "esriFieldTypeString", "alias": "FLOOR", "length": 20, "domain": { "type": "codedValue", "name": "faFloorDescription", "description": "Main Upper Lower etc", "codedValues": [ { "name": "Main Floor", "code": "Main Floor" }, { "name": "Lower Floor", "code": "Lower Floor" }, { "name": "Upper Floor", "code": "Upper Floor" }, { "name": "Outside", "code": "Outside" }, { "name": "Other", "code": "Other" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "length": 25, "domain": null }, { "name": "MODELNO", "type": "esriFieldTypeString", "alias": "MODELNO", "length": 50, "domain": null }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "length": 50, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "PARENTASSET", "type": "esriFieldTypeString", "alias": "PARENTASSET", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 130, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 255, "domain": null }, { "name": "OWNERSHIP", "type": "esriFieldTypeString", "alias": "OWNERSHIP", "length": 30, "domain": { "type": "codedValue", "name": "Ownership", "description": "Asset ownership", "codedValues": [ { "name": "Mercer Island", "code": "Mercer Island" }, { "name": "Mercer Island (by Easement)", "code": "Mercer Island (by Easement)" }, { "name": "Private", "code": "Private" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "SPU", "code": "SPU" }, { "name": "PSE", "code": "PSE" }, { "name": "King County", "code": "King County" }, { "name": "MI School District", "code": "MI School District" }, { "name": "Shorewood", "code": "Shorewood" }, { "name": "Sound Transit", "code": "Sound Transit" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FILTERS", "type": "esriFieldTypeString", "alias": "FILTERS", "length": 50, "domain": null }, { "name": "BELTS", "type": "esriFieldTypeString", "alias": "BELTS", "length": 20, "domain": null }, { "name": "TONNAGE", "type": "esriFieldTypeDouble", "alias": "TONNAGE", "domain": null }, { "name": "MANUFACTUREDATE", "type": "esriFieldTypeDate", "alias": "MANUFACTUREDATE", "length": 8, "domain": null }, { "name": "CONTRACTORID", "type": "esriFieldTypeString", "alias": "CONTRACTORID", "length": 30, "domain": null }, { "name": "CONTRACTORID2", "type": "esriFieldTypeString", "alias": "CONTRACTORID2", "length": 30, "domain": null }, { "name": "CONTRACTORTYPE", "type": "esriFieldTypeString", "alias": "CONTRACTORTYPE", "length": 30, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "CONDITION", "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "CONDITIONDATE", "length": 8, "domain": null }, { "name": "LIFEEXPECTANCY", "type": "esriFieldTypeSmallInteger", "alias": "LIFEEXPECTANCY", "domain": null }, { "name": "REMAININGLIFE", "type": "esriFieldTypeSmallInteger", "alias": "REMAININGLIFE", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "SYMBOLROTATION", "type": "esriFieldTypeDouble", "alias": "SYMBOLROTATION", "domain": null }, { "name": "UPDATESOURCE", "type": "esriFieldTypeString", "alias": "UPDATESOURCE", "length": 255, "domain": null }, { "name": "UPDATEBY", "type": "esriFieldTypeString", "alias": "UPDATEBY", "length": 20, "domain": null }, { "name": "UPDATEDATE", "type": "esriFieldTypeDate", "alias": "UPDATEDATE", "length": 8, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "indexes": [ { "name": "R741_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S581_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 15000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }