{ "currentVersion": 10.91, "id": 2, "name": "gisqbywater.DBO.valvereltable", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CREW_ONE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "VALVEID", "type": "esriFieldTypeSmallInteger", "alias": "VALVEID", "domain": null }, { "name": "CREW_ONE", "type": "esriFieldTypeString", "alias": "CREW_ONE", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 1", "description": "Crew Member 1", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREW_TWO", "type": "esriFieldTypeString", "alias": "CREW_TWO", "length": 50, "domain": { "type": "codedValue", "name": "Crew Member 2", "description": "Crew Member 2", "codedValues": [ { "name": "Tyson Converse", "code": "Tyson Converse" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Tom Matteson", "code": "Tom Matteson" }, { "name": "Joe Quintal", "code": "Joe Quintal" }, { "name": "Gary Schlierloh", "code": "Gary Schlierloh" }, { "name": "Devin Stockman", "code": "Devin Stockman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VBOX_LOC", "type": "esriFieldTypeString", "alias": "VBOX_LOC", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Location", "description": "Valve Box Location", "codedValues": [ { "name": "Intersection", "code": "Intersection" }, { "name": "Edge of Paved Road", "code": "Edge of Paved Road" }, { "name": "Driveway", "code": "Driveway" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "ROW", "code": "ROW" }, { "name": "Near Hydrant", "code": "Near Hydrant" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VBOXL_CMNT", "type": "esriFieldTypeString", "alias": "VBOX_CMNT", "length": 150, "domain": null }, { "name": "VBOX_SUR", "type": "esriFieldTypeString", "alias": "VBOX_SUR", "length": 50, "domain": { "type": "codedValue", "name": "Valve Box Surface", "description": "Valve Box Surface", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Dirt/Grass", "code": "Dirt/Grass" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Wet Area", "code": "Wet Area" }, { "name": "Other (add Comment)", "code": "Other (add Comment)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VBOXS_CMNT", "type": "esriFieldTypeString", "alias": "VBOXS_CMNT", "length": 150, "domain": null }, { "name": "REP_BOX", "type": "esriFieldTypeString", "alias": "REP_BOX", "length": 50, "domain": { "type": "codedValue", "name": "Repair Box/Cap", "description": "Repair Box/Cap", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPBX_CMNT", "type": "esriFieldTypeString", "alias": "REPBX_CMNT", "length": 150, "domain": null }, { "name": "VAC", "type": "esriFieldTypeString", "alias": "VAC", "length": 50, "domain": { "type": "codedValue", "name": "Vacuum", "description": "Vacuum", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VAC_CMNT", "type": "esriFieldTypeString", "alias": "VAC_CMNT", "length": 150, "domain": null }, { "name": "NUT_ACC", "type": "esriFieldTypeString", "alias": "NUT_ACC", "length": 50, "domain": { "type": "codedValue", "name": "Nut Accessible", "description": "Nut Accessible", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUTA_CMNT", "type": "esriFieldTypeString", "alias": "NUTA_CMNT", "length": 150, "domain": null }, { "name": "VAL_OP", "type": "esriFieldTypeString", "alias": "VAL_OP", "length": 50, "domain": { "type": "codedValue", "name": "Valve Operational", "description": "Valve Operational", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALOP_CMNT", "type": "esriFieldTypeString", "alias": "VALOP_CMNT", "length": 150, "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 } ], "indexes": [ { "name": "R8_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13_VALVEID", "fields": "VALVEID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "gisqbywater.DBO.testvalves", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "VALVEID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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": "d55d87d449a84bf18cdf84b1fa7af1ab" }