{ "currentVersion": 10.61, "id": 33, "name": "MAINVALVES", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATLAS_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WATRNDEID", "type": "esriFieldTypeDouble", "alias": "WATRNDEID", "domain": null }, { "name": "ATLAS_ID", "type": "esriFieldTypeString", "alias": "ATLAS ID", "length": 8, "domain": null }, { "name": "VALVETYPE", "type": "esriFieldTypeSmallInteger", "alias": "VALVE TYPE", "domain": { "type": "codedValue", "name": "VALVE TYPE", "description": "WATER VALVE TYPE", "codedValues": [ { "name": "BUTTERFLY", "code": 1 }, { "name": "GATE", "code": 2 }, { "name": "RESILIENT WEDGE", "code": 3 }, { "name": "ROUNDWAY", "code": 4 }, { "name": "UNKNOWN", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSTYPE", "type": "esriFieldTypeSmallInteger", "alias": "ACCESS TYPE", "domain": { "type": "codedValue", "name": "ACCESS TYPE", "description": "VALVE ACCESS TYPE", "codedValues": [ { "name": "AUXILLARY VALVE BOX", "code": 1 }, { "name": "BLOCK VAULT", "code": 2 }, { "name": "BOX", "code": 3 }, { "name": "BUFFALO BOX", "code": 4 }, { "name": "CONCRETE VAULT", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VLTFRMTYPE", "type": "esriFieldTypeSmallInteger", "alias": "FRAME TYPE", "domain": { "type": "codedValue", "name": "FRAMETYPE", "description": "UTILITY STRUCTURE FRAME TYPES", "codedValues": [ { "name": "BEEHIVE - SHORT", "code": 1 }, { "name": "BEEHIVE - TALL", "code": 2 }, { "name": "CURB BOX", "code": 3 }, { "name": "CIRCULAR", "code": 4 }, { "name": "RECTANGULAR", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VLTFRMHGT", "type": "esriFieldTypeSmallInteger", "alias": "FRAME HEIGHT", "domain": { "type": "codedValue", "name": "FRAMEHEIGHT", "description": "UTILITY STRUCTURE FRAME HEIGHTS", "codedValues": [ { "name": "LOW BOY", "code": 1 }, { "name": "4 INCH", "code": 2 }, { "name": "5 INCH", "code": 3 }, { "name": "6 INCH", "code": 4 }, { "name": "7 INCH", "code": 5 }, { "name": "8 INCH", "code": 6 }, { "name": "9 INCH", "code": 7 }, { "name": "NONE", "code": 8 }, { "name": "10 INCH", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VLTLIDTYPE", "type": "esriFieldTypeSmallInteger", "alias": "LID TYPE", "domain": { "type": "codedValue", "name": "VALVE LID TYPE", "description": "WATER VALVE LID TYPE", "codedValues": [ { "name": "CLOSED WITH OPEN PICKHOLE", "code": 1 }, { "name": "CLOSED WITH CLOSED PICKHOLE", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MNVALVEDIAM", "type": "esriFieldTypeSmallInteger", "alias": "MAINVALVE DIAMETER", "domain": { "type": "codedValue", "name": "DIAMETERS", "description": "MEASURED DIAMETERS FOR UTILITIES", "codedValues": [ { "name": "5/8\"", "code": 1 }, { "name": "3/4\"", "code": 2 }, { "name": "1\"", "code": 3 }, { "name": "1 1/2\"", "code": 4 }, { "name": "2\"", "code": 5 }, { "name": "3\"", "code": 6 }, { "name": "4\"", "code": 7 }, { "name": "6\"", "code": 8 }, { "name": "8\"", "code": 9 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 11 }, { "name": "14\"", "code": 12 }, { "name": "16\"", "code": 13 }, { "name": "20\"", "code": 14 }, { "name": "24\"", "code": 15 }, { "name": "30\"", "code": 16 }, { "name": "36\"", "code": 17 }, { "name": "UNKNOWN", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R919_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_919", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3266WATRNDEID", "fields": "WATRNDEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_919", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Water Mainvalve Features", "relatedTableId": 24, "role": "esriRelRoleDestination", "keyField": "WATRNDEID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 } }