{ "currentVersion": 10.91, "id": 12, "name": "f_HVAC", "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": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "STRUCTURETYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": { "type": "codedValue", "name": "FacilityProcessType", "description": "Facility Process Types", "codedValues": [ { "name": "Activated Sludge", "code": "Activated Sludge" }, { "name": "BD-2000", "code": "BD-2000" }, { "name": "Brine Pump", "code": "Brine Pump" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Citric Acid", "code": "Citric Acid" }, { "name": "Cooling", "code": "Cooling" }, { "name": "Effluent", "code": "Effluent" }, { "name": "Flouride", "code": "Flouride" }, { "name": "Heating", "code": "Heating" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Hypochlorite", "code": "Hypochlorite" }, { "name": "Non Potable", "code": "Non Potable" }, { "name": "Phosphate", "code": "Phosphate" }, { "name": "Phosphate ", "code": "Phosphate " }, { "name": "Polyphosphate", "code": "Polyphosphate" }, { "name": "Potable Water", "code": "Potable Water" }, { "name": "Primary Sludge", "code": "Primary Sludge" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Return Activated Sludge", "code": "Return Activated Sludge" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Thickened Waste Activated Sludge", "code": "Thickened Waste Activated Sludge" }, { "name": "Wash Water", "code": "Wash Water" }, { "name": "Waste Activated Sludge", "code": "Waste Activated Sludge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 25, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SERIAL", "type": "esriFieldTypeString", "alias": "Serial", "length": 50, "domain": null }, { "name": "INSTALLYEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 10, "domain": null }, { "name": "FACILITYNAMES", "type": "esriFieldTypeString", "alias": "Facility Names", "length": 50, "domain": null }, { "name": "USEFULLIFE", "type": "esriFieldTypeSmallInteger", "alias": "Useful Life", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1082_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9752_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }