{ "currentVersion": 10.91, "id": 13, "name": "f_Instrumentation", "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": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 25, "domain": null }, { "name": "METERTYPE", "type": "esriFieldTypeString", "alias": "Meter Type", "length": 20, "domain": { "type": "codedValue", "name": "MeterType", "description": "Type of instrument Meter", "codedValues": [ { "name": "Doppler", "code": "Doppler" }, { "name": "Magmeter", "code": "Magmeter" }, { "name": "Ultrasonic", "code": "Ultrasonic" }, { "name": "ABB", "code": "ABB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "length": 25, "domain": { "type": "codedValue", "name": "InsturmentMake", "description": "Make type of facility instrumentation", "codedValues": [ { "name": "Endress-Hauser", "code": "Endress-Hauser" }, { "name": "ISCO", "code": "ISCO" }, { "name": "Krohne", "code": "Krohne" }, { "name": "Polysonics", "code": "Polysonics" }, { "name": "Rosemount", "code": "Rosemount" }, { "name": "Siemens", "code": "Siemens" }, { "name": "WaterMaster", "code": "WaterMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 25, "domain": { "type": "codedValue", "name": "InstrumentModel", "description": "Type of Model for instruments", "codedValues": [ { "name": "3010", "code": "3010" }, { "name": "8732C", "code": "8732C" }, { "name": "DDF4008", "code": "DDF4008" }, { "name": "Milltronics", "code": "Milltronics" }, { "name": "PROMAG53", "code": "PROMAG53" }, { "name": "PROMAGW", "code": "PROMAGW" }, { "name": "SC100AS/MP", "code": "SC100AS/MP" }, { "name": "SX40", "code": "SX40" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SERIALNUM", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 25, "domain": null }, { "name": "RANGE", "type": "esriFieldTypeString", "alias": "Range", "length": 25, "domain": null }, { "name": "ANUALCALIBREQ", "type": "esriFieldTypeString", "alias": "Annual Calibration Required", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "Size", "length": 5, "domain": { "type": "codedValue", "name": "piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "0.75", "code": 0.75 }, { "name": "1", "code": 1 }, { "name": "1.25", "code": 1.25 }, { "name": "1.5", "code": 1.5 }, { "name": "2", "code": 2 }, { "name": "2.5", "code": 2.5 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "6", "code": 6 }, { "name": "8", "code": 8 }, { "name": "10", "code": 10 }, { "name": "12", "code": 12 }, { "name": "14", "code": 14 }, { "name": "15", "code": 15 }, { "name": "16", "code": 16 }, { "name": "17", "code": 17 }, { "name": "18", "code": 18 }, { "name": "20", "code": 20 }, { "name": "21", "code": 21 }, { "name": "24", "code": 24 }, { "name": "27", "code": 27 }, { "name": "30", "code": 30 }, { "name": "36", "code": 36 }, { "name": "40", "code": 40 }, { "name": "42", "code": 42 }, { "name": "48", "code": 48 }, { "name": "54", "code": 54 }, { "name": "60", "code": 60 }, { "name": "66", "code": 66 }, { "name": "72", "code": 72 }, { "name": "75", "code": 75 }, { "name": "84", "code": 84 }, { "name": "96", "code": 96 }, { "name": "108", "code": 108 }, { "name": "120", "code": 120 }, { "name": "144", "code": 144 }, { "name": "168", "code": 168 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GPM", "type": "esriFieldTypeSmallInteger", "alias": "Gallons Per Min", "domain": null }, { "name": "FACILITYNAMES", "type": "esriFieldTypeString", "alias": "Facility Names", "length": 50, "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": "R1083_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9753_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "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" }