{ "currentVersion": 10.91, "id": 15, "name": "f_Valves", "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": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 25, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 30, "domain": { "type": "codedValue", "name": "FVType", "description": "Valve Type for Facilities Valves", "codedValues": [ { "name": "Ball", "code": "Ball" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Gate", "code": "Gate" }, { "name": "Mud", "code": "Mud" }, { "name": "Pinch", "code": "Pinch" }, { "name": "Plug", "code": "Plug" }, { "name": "Slide", "code": "Slide" }, { "name": "Telescopic", "code": "Telescopic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVEMATERIAL", "type": "esriFieldTypeString", "alias": "VALVEMATERIAL", "length": 35, "domain": { "type": "codedValue", "name": "FVMaterial", "description": "Valve Material for Facilities Valves", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Brass", "code": "Brass" }, { "name": "Ductile", "code": "Ductile" }, { "name": "Plastic, PVC", "code": "Plastic, PVC" }, { "name": "SS, 304", "code": "SS, 304" }, { "name": "SS, 316", "code": "SS, 316" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVESERVICE", "type": "esriFieldTypeString", "alias": "Valve Service", "length": 35, "domain": { "type": "codedValue", "name": "FVService", "description": "Valve Service for Facilities Valves", "codedValues": [ { "name": "Air", "code": "Air" }, { "name": "Chemical", "code": "Chemical" }, { "name": "Effluent", "code": "Effluent" }, { "name": "Mixed Liquor", "code": "Mixed Liquor" }, { "name": "Non-Pot H2O", "code": "Non-Pot H2O" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Sludge", "code": "Sludge" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "JOINTTYPE", "type": "esriFieldTypeString", "alias": "Joint Type", "length": 50, "domain": { "type": "codedValue", "name": "FVJointType", "description": "Joint Type for Facilities Valves", "codedValues": [ { "name": "Bell & Spigot", "code": "Bell & Spigot" }, { "name": "Flange", "code": "Flange" }, { "name": "Groove & Clamp", "code": "Groove & Clamp" }, { "name": "Mech. Joint", "code": "Mech. Joint" }, { "name": "National Pipe Thread", "code": "National Pipe Thread" }, { "name": "Socket Weld", "code": "Socket Weld" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPERATORTYPE", "type": "esriFieldTypeString", "alias": "Operator Type", "length": 50, "domain": { "type": "codedValue", "name": "FVOperatorType", "description": "Operator Type for Facilities Valves", "codedValues": [ { "name": "Extended Nut", "code": "Extended Nut" }, { "name": "Floor Stand", "code": "Floor Stand" }, { "name": "Gear OP W/Ext. Bonnet & HW", "code": "Gear OP W/Ext. Bonnet & HW" }, { "name": "Gear W/Chain", "code": "Gear W/Chain" }, { "name": "Gear W/Hand Crank", "code": "Gear W/Hand Crank" }, { "name": "Gear w/Handwheel", "code": "Gear w/Handwheel" }, { "name": "Quarter Turn Nut", "code": "Quarter Turn Nut" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPERATORSTYLE", "type": "esriFieldTypeString", "alias": "Operator Style", "length": 35, "domain": { "type": "codedValue", "name": "FVOperatorStyle", "description": "Operator Style of Facilities Valves", "codedValues": [ { "name": "Indicating", "code": "Indicating" }, { "name": "Locking Lever", "code": "Locking Lever" }, { "name": "Nmotor", "code": "Nmotor" }, { "name": "Non-Indicating", "code": "Non-Indicating" }, { "name": "Non-Rising Stem", "code": "Non-Rising Stem" }, { "name": "Rising Stem", "code": "Rising Stem" }, { "name": "Spring", "code": "Spring" }, { "name": "Weighted Arm", "code": "Weighted Arm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "R1078_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9748_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "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" }