{ "currentVersion": 10.22, "id": 1, "name": "QBYTESTHYDRELCLASS.DBO.testreltable", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Manname", "typeIdField": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "Manufacturer", "codedValues": [ { "name": "Eddy", "code": "Eddy" }, { "name": "Ludlow", "code": "Ludlow" }, { "name": "Mueller Sup", "code": "Mueller Sup" }, { "name": "Mueller Cen", "code": "Mueller Cen" }, { "name": "Mueller Imp", "code": "Mueller Imp" }, { "name": "Mueller 107", "code": "Mueller 107" }, { "name": "Mueller Stan", "code": "Mueller Stan" }, { "name": "Other", "code": "Other" } ] } }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": { "type": "range", "name": "Year", "range": [ 1800, 2100 ] } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Staked", "type": "esriFieldTypeString", "alias": "Staked", "length": 50, "domain": { "type": "codedValue", "name": "Staked", "codedValues": [ { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Wood", "code": "Wood" }, { "name": "Removed", "code": "Removed" } ] } }, { "name": "Plowed", "type": "esriFieldTypeString", "alias": "Plowed", "length": 50, "domain": { "type": "codedValue", "name": "Plowed", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Frozen", "type": "esriFieldTypeString", "alias": "Frozen", "length": 50, "domain": { "type": "codedValue", "name": "Frozen", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": { "type": "codedValue", "name": "Inspector", "codedValues": [ { "name": "Vance Plant", "code": "Vance Plant" }, { "name": "Gary Schierloh", "code": "Gary Schierloh" }, { "name": "Steve Burch", "code": "Steve Burch" }, { "name": "Joey Quintal", "code": "Joey Quintal" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Greg Moon", "code": "Greg Moon" } ] } }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 36, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": { "type": "codedValue", "name": "Inspector", "codedValues": [ { "name": "Vance Plant", "code": "Vance Plant" }, { "name": "Gary Schierloh", "code": "Gary Schierloh" }, { "name": "Steve Burch", "code": "Steve Burch" }, { "name": "Joey Quintal", "code": "Joey Quintal" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Greg Moon", "code": "Greg Moon" } ] } }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 36, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": { "type": "codedValue", "name": "Inspector", "codedValues": [ { "name": "Vance Plant", "code": "Vance Plant" }, { "name": "Gary Schierloh", "code": "Gary Schierloh" }, { "name": "Steve Burch", "code": "Steve Burch" }, { "name": "Joey Quintal", "code": "Joey Quintal" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Greg Moon", "code": "Greg Moon" } ] } }, { "name": "Pressure_Tested", "type": "esriFieldTypeString", "alias": "Pressure_Tested", "length": 50, "domain": { "type": "codedValue", "name": "Pressure Tested", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Oil_Level", "type": "esriFieldTypeString", "alias": "Oil_Level", "length": 50, "domain": { "type": "codedValue", "name": "Oil Level ", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Check_Grease", "type": "esriFieldTypeString", "alias": "Check_Grease", "length": 50, "domain": { "type": "codedValue", "name": "Check Grease", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Threads_Serviced", "type": "esriFieldTypeString", "alias": "Threads_Serviced", "length": 50, "domain": { "type": "codedValue", "name": "Threads Serviced", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Packing_Tightened", "type": "esriFieldTypeString", "alias": "Packing_Tightened", "length": 50, "domain": { "type": "codedValue", "name": "Packing Tightened", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Branch_Valve", "type": "esriFieldTypeString", "alias": "Branch_Valve", "length": 50, "domain": { "type": "codedValue", "name": "Brach Valve Op", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Hydrant_Num_OK", "type": "esriFieldTypeString", "alias": "Hydrant_Num_OK", "length": 50, "domain": { "type": "codedValue", "name": "Hydrant Number OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Location_Noted", "type": "esriFieldTypeString", "alias": "Location_Noted", "length": 50, "domain": { "type": "codedValue", "name": "Location Noted", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Straight_to_Road", "type": "esriFieldTypeString", "alias": "Straight_to_Road", "length": 50, "domain": { "type": "codedValue", "name": "Straight to Road", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "PSI", "type": "esriFieldTypeSmallInteger", "alias": "PSI", "domain": { "type": "range", "name": "PSI", "range": [ 10, 1000 ] } }, { "name": "Steamer_Thread", "type": "esriFieldTypeString", "alias": "Steamer_Thread", "length": 50, "domain": { "type": "codedValue", "name": "Steamer Thread", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Hydrant_Work", "type": "esriFieldTypeString", "alias": "Hydrant_Work", "length": 50, "domain": { "type": "codedValue", "name": "Hydrant Work", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Branch_Valve_Loc", "type": "esriFieldTypeString", "alias": "Branch_Valve_Loc", "length": 50, "domain": { "type": "codedValue", "name": "Branch Valve Loc", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Low", "code": "Low" }, { "name": "Straight", "code": "Straight" } ] } }, { "name": "Highway_Yellow_Cap", "type": "esriFieldTypeString", "alias": "Highway_Yellow_Cap", "length": 50, "domain": { "type": "codedValue", "name": "Highway Yellow", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Plugged_Drip", "type": "esriFieldTypeString", "alias": "Plugged_Drip", "length": 50, "domain": { "type": "codedValue", "name": "Plugged Drip", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Caps_Pentagon", "type": "esriFieldTypeString", "alias": "Caps_Pentagon", "length": 50, "domain": { "type": "codedValue", "name": "Caps Pentagon", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Leading_OK", "type": "esriFieldTypeString", "alias": "Leading_OK", "length": 50, "domain": { "type": "codedValue", "name": "Leading OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Hydrant_Needs", "type": "esriFieldTypeString", "alias": "Hydrant_Needs", "length": 150, "domain": null }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 150, "domain": null }, { "name": "Height_OK", "type": "esriFieldTypeString", "alias": "Height_OK", "length": 50, "domain": { "type": "codedValue", "name": "Height OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Vert_OK", "type": "esriFieldTypeString", "alias": "Vert_OK", "length": 50, "domain": { "type": "codedValue", "name": "Vertical OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Paint_OK", "type": "esriFieldTypeString", "alias": "Paint_OK", "length": 50, "domain": { "type": "codedValue", "name": "Paint OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Caps_OK", "type": "esriFieldTypeString", "alias": "Caps_OK", "length": 50, "domain": { "type": "codedValue", "name": "Caps OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Nozzles_OK", "type": "esriFieldTypeString", "alias": "Nozzles_OK", "length": 50, "domain": { "type": "codedValue", "name": "Nozzles OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Opnut_OK", "type": "esriFieldTypeString", "alias": "Opnut_OK", "length": 50, "domain": { "type": "codedValue", "name": "Op Nut OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Barrels_OK", "type": "esriFieldTypeString", "alias": "Barrels_OK", "length": 50, "domain": { "type": "codedValue", "name": "Barrels OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Mainvalve_OK", "type": "esriFieldTypeString", "alias": "Mainvalve_OK", "length": 50, "domain": { "type": "codedValue", "name": "Main Valve OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Drainvalve_OK", "type": "esriFieldTypeString", "alias": "Drainvalve_OK", "length": 50, "domain": { "type": "codedValue", "name": "Drain Valve OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Branchvalve_OK", "type": "esriFieldTypeString", "alias": "Branchvalve_OK", "length": 50, "domain": { "type": "codedValue", "name": "Branch Valve OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Orings_OK", "type": "esriFieldTypeString", "alias": "Orings_OK", "length": 50, "domain": { "type": "codedValue", "name": "O Rings OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Packing_OK", "type": "esriFieldTypeString", "alias": "Packing_OK", "length": 50, "domain": { "type": "codedValue", "name": "Packing OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Reflecpaint_OK", "type": "esriFieldTypeString", "alias": "Reflecpaint_OK", "length": 50, "domain": { "type": "codedValue", "name": "Reflect Paint OK", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Pumped_OK", "type": "esriFieldTypeString", "alias": "Pumped_OK", "length": 50, "domain": { "type": "codedValue", "name": "Pumped", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ] } }, { "name": "Inspector_Hrs", "type": "esriFieldTypeInteger", "alias": "Inspector_Hrs", "domain": { "type": "range", "name": "Inspector Hrs", "range": [ 0, 10 ] } }, { "name": "Inspector_OT", "type": "esriFieldTypeInteger", "alias": "Inspector_OT", "domain": null }, { "name": "Equip", "type": "esriFieldTypeString", "alias": "Equip", "length": 50, "domain": { "type": "codedValue", "name": "Equipment", "codedValues": [ { "name": "02-3", "code": "02-3" } ] } }, { "name": "Inspector_Add", "type": "esriFieldTypeString", "alias": "Inspector_Add", "length": 50, "domain": { "type": "codedValue", "name": "Inspector", "codedValues": [ { "name": "Vance Plant", "code": "Vance Plant" }, { "name": "Gary Schierloh", "code": "Gary Schierloh" }, { "name": "Steve Burch", "code": "Steve Burch" }, { "name": "Joey Quintal", "code": "Joey Quintal" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Greg Moon", "code": "Greg Moon" } ] } }, { "name": "inspadd_Hrs", "type": "esriFieldTypeInteger", "alias": "inspadd_Hrs", "domain": { "type": "range", "name": "Inspector Hrs", "range": [ 0, 10 ] } }, { "name": "Inspadd_OT", "type": "esriFieldTypeInteger", "alias": "Inspadd_OT", "domain": { "type": "range", "name": "Inspector Hrs", "range": [ 0, 10 ] } }, { "name": "Inspector_Add2", "type": "esriFieldTypeString", "alias": "Inspector_Add2", "length": 50, "domain": { "type": "codedValue", "name": "Inspector", "codedValues": [ { "name": "Vance Plant", "code": "Vance Plant" }, { "name": "Gary Schierloh", "code": "Gary Schierloh" }, { "name": "Steve Burch", "code": "Steve Burch" }, { "name": "Joey Quintal", "code": "Joey Quintal" }, { "name": "Paul Finch", "code": "Paul Finch" }, { "name": "Greg Moon", "code": "Greg Moon" } ] } }, { "name": "Inspadd2_Hrs", "type": "esriFieldTypeInteger", "alias": "Inspadd2_Hrs", "domain": { "type": "range", "name": "Inspector Hrs", "range": [ 0, 10 ] } }, { "name": "Inspadd2_OT", "type": "esriFieldTypeInteger", "alias": "Inspadd2_OT", "domain": { "type": "range", "name": "Inspector Hrs", "range": [ 0, 10 ] } }, { "name": "Equip_Hrs", "type": "esriFieldTypeInteger", "alias": "Equip_Hrs", "domain": { "type": "range", "name": "Inspector Hrs", "range": [ 0, 10 ] } }, { "name": "Descrip", "type": "esriFieldTypeString", "alias": "Descrip", "length": 150, "domain": null }, { "name": "Descrip_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip_Mk", "type": "esriFieldTypeString", "alias": "Descrip_Mk", "length": 50, "domain": null }, { "name": "Descrip_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip_Ptnum", "length": 50, "domain": null }, { "name": "Descrip2", "type": "esriFieldTypeString", "alias": "Descrip2", "length": 150, "domain": null }, { "name": "Descrip2_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip2_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip2_Mk", "type": "esriFieldTypeString", "alias": "Descrip2_Mk", "length": 50, "domain": null }, { "name": "Descrip2_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip2_Ptnum", "length": 50, "domain": null }, { "name": "Descrip3", "type": "esriFieldTypeString", "alias": "Descrip3", "length": 150, "domain": null }, { "name": "Descrip3_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip3_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip3_Mk", "type": "esriFieldTypeString", "alias": "Descrip3_Mk", "length": 50, "domain": null }, { "name": "Descrip3_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip3_Ptnum", "length": 50, "domain": null }, { "name": "Descrip4", "type": "esriFieldTypeString", "alias": "Descrip4", "length": 150, "domain": null }, { "name": "Descrip4_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip4_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip4_Mk", "type": "esriFieldTypeString", "alias": "Descrip4_Mk", "length": 50, "domain": null }, { "name": "Descrip4_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip4_Ptnum", "length": 50, "domain": null }, { "name": "Descrip5", "type": "esriFieldTypeString", "alias": "Descrip5", "length": 150, "domain": null }, { "name": "Descrip5_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip5_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip5_Mk", "type": "esriFieldTypeString", "alias": "Descrip5_Mk", "length": 50, "domain": null }, { "name": "Descrip5_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip5_Ptnum", "length": 50, "domain": null }, { "name": "Descrip6", "type": "esriFieldTypeString", "alias": "Descrip6", "length": 150, "domain": null }, { "name": "Descrip6_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip6_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip6_Mk", "type": "esriFieldTypeString", "alias": "Descrip6_Mk", "length": 50, "domain": null }, { "name": "Descrip6_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip6_Ptnum", "length": 50, "domain": null }, { "name": "Descrip7", "type": "esriFieldTypeString", "alias": "Descrip7", "length": 150, "domain": null }, { "name": "Descrip7_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip7_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip7_Mk", "type": "esriFieldTypeString", "alias": "Descrip7_Mk", "length": 50, "domain": null }, { "name": "Descrip7_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip7_Ptnum", "length": 50, "domain": null }, { "name": "Descrip8", "type": "esriFieldTypeString", "alias": "Descrip8", "length": 150, "domain": null }, { "name": "Descrip8_Qt", "type": "esriFieldTypeInteger", "alias": "Descrip8_Qt", "domain": { "type": "range", "name": "Descrip Qty", "range": [ 1, 100 ] } }, { "name": "Descrip8_Mk", "type": "esriFieldTypeString", "alias": "Descrip8_Mk", "length": 50, "domain": null }, { "name": "Descrip8_Ptnum", "type": "esriFieldTypeString", "alias": "Descrip8_Ptnum", "length": 50, "domain": null }, { "name": "Insp_Hrs", "type": "esriFieldTypeSingle", "alias": "Insp_Hrs", "domain": null }, { "name": "Insp_Hrs2", "type": "esriFieldTypeSingle", "alias": "Insp_Hrs2", "domain": null }, { "name": "Insp_Hrs3", "type": "esriFieldTypeSingle", "alias": "Insp_Hrs3", "domain": null }, { "name": "Insp_OT", "type": "esriFieldTypeSingle", "alias": "Insp_OT", "domain": null }, { "name": "Insp_OT2", "type": "esriFieldTypeSingle", "alias": "Insp_OT2", "domain": null }, { "name": "Insp_OT3", "type": "esriFieldTypeSingle", "alias": "Insp_OT3", "domain": null }, { "name": "Eq_Hrs", "type": "esriFieldTypeSingle", "alias": "Eq_Hrs", "domain": null }, { "name": "Mancode", "type": "esriFieldTypeSmallInteger", "alias": "Mancode", "domain": { "type": "codedValue", "name": "Mancode", "codedValues": [ { "name": "Eddy Clow", "code": 1 }, { "name": "Mueller", "code": 2 }, { "name": "Ludlow", "code": 3 }, { "name": "Kennedy", "code": 4 } ] } }, { "name": "Manname", "type": "esriFieldTypeString", "alias": "Manname", "length": 50, "domain": { "type": "codedValue", "name": "Manname", "codedValues": [ { "name": "Eddy/Clow", "code": "Eddy/Clow" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Ludlow", "code": "Ludlow" }, { "name": "Kennedy", "code": "Kennedy" } ] } }, { "name": "Manmodel", "type": "esriFieldTypeString", "alias": "Manmodel", "length": 50, "domain": { "type": "codedValue", "name": "Manmodel", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Centurion", "code": "Centurion" }, { "name": "Super Centurion", "code": "Super Centurion" }, { "name": "107", "code": "107" } ] } }, { "name": "HydrantNumber", "type": "esriFieldTypeString", "alias": "HydrantNumber", "length": 50, "domain": null }, { "name": "Leak_Tested", "type": "esriFieldTypeString", "alias": "Leak_Tested", "length": 50, "domain": { "type": "codedValue", "name": "Leak Tested", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" }, { "name": "Needs Work", "code": "Needs Work" } ] } } ], "relationships": [ { "id": 0, "name": "testrelateclassto", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "HydrantNumber", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true }