{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Hydrant Maintenance Table", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DATE_INSPECTED", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DATE_INSPECTED", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition?", "length": 20, "domain": { "type": "codedValue", "name": "msCONDITION", "description": "Condition Rating Scale", "codedValues": [ { "name": "1-Poor", "code": "1-Poor" }, { "name": "2-Fair", "code": "2-Fair" }, { "name": "3-Average", "code": "3-Average" }, { "name": "4-Good", "code": "4-Good" }, { "name": "5-Excellent", "code": "5-Excellent" }, { "name": "Non Operational", "code": "Non Operational" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STATIC_PSI", "type": "esriFieldTypeDouble", "alias": "Static PSI", "domain": null }, { "name": "PAINTED", "type": "esriFieldTypeString", "alias": "Painted?", "length": 10, "domain": { "type": "codedValue", "name": "Boolean_Field", "description": "Boolean", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "H_GUID", "type": "esriFieldTypeGUID", "alias": "H_GUID", "length": 38, "domain": null }, { "name": "EMPLOYEE", "type": "esriFieldTypeString", "alias": "Employee", "length": 255, "domain": { "type": "codedValue", "name": "adFIELD_EMPLOYEE", "description": "Field Employee", "codedValues": [ { "name": "Devin S", "code": "Devin S" }, { "name": "Mark D", "code": "Mark D" }, { "name": "Ronald K", "code": "Ronald K" }, { "name": "Lloyd W", "code": "Lloyd W" }, { "name": "Dustin M", "code": "Dustin M" }, { "name": "Jordan W", "code": "Jordan W" }, { "name": "Jason M", "code": "Jason M" }, { "name": "Alec L", "code": "Alec L" }, { "name": "David F", "code": "David F" }, { "name": "Mike C", "code": "Mike C" }, { "name": "Ron L", "code": "Ron L" }, { "name": "Manny O", "code": "Manny O" }, { "name": "Brad S", "code": "Brad S" }, { "name": "Lonnie C", "code": "Lonnie C" }, { "name": "Collen V", "code": "Collen V" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": { "type": "codedValue", "name": "waHYDRANT_MANUFACTURER", "description": "Hydrant Manufacturer", "codedValues": [ { "name": "M&H", "code": "M&H" }, { "name": "Iowa", "code": "Iowa" }, { "name": "Clow", "code": "Clow" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Waterous", "code": "Waterous" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model or Model #", "length": 75, "domain": null }, { "name": "HYDRANT_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null }, { "name": "FLOW_PRESSURE", "type": "esriFieldTypeSingle", "alias": "Flow Pressure", "domain": null }, { "name": "GPM", "type": "esriFieldTypeSingle", "alias": "GPM", "domain": null }, { "name": "NOZZLE_COEFFICIENT", "type": "esriFieldTypeString", "alias": "Nozzle Coefficient", "length": 255, "domain": { "type": "codedValue", "name": "waNOZZLE_COEFFICIENT", "description": "Nozzle Coefficient", "codedValues": [ { "name": "COEF 0.90", "code": "COEF 0.90" }, { "name": "COEF 0.80", "code": "COEF 0.80" }, { "name": "COEF 0.70", "code": "COEF 0.70" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TS_DUST_CAP_WEATHER_SHIELD", "type": "esriFieldTypeString", "alias": "Dust Cap / Weather Shield", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TS_OPERATING_NUT_STEM", "type": "esriFieldTypeString", "alias": "Operating Nut Stem", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TS_OIL_PORT_GREASE_FITTING", "type": "esriFieldTypeString", "alias": "Oil Port / Grease Fitting", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TS_BONNET_BOLTS_NUTS", "type": "esriFieldTypeString", "alias": "Bonnet Bolts / Nuts", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TS_GASKETS_ORING_SEALS", "type": "esriFieldTypeString", "alias": "Gaskets / O-Ring Seals", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_HOSE_CAPS", "type": "esriFieldTypeString", "alias": "2 1/2in Hose Caps", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_HOSE_NOZZLES", "type": "esriFieldTypeString", "alias": "2 1/2in Hose Nozzles", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_PUMPER_STEAMER_CAP", "type": "esriFieldTypeString", "alias": "Pumper Steamer Cap", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_PUMPER_STEAMER_NOZZLE", "type": "esriFieldTypeString", "alias": "Pumper Steamer Nozzle", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_SAFETY_PARTS_STEM", "type": "esriFieldTypeString", "alias": "Safety Flange Parts / Internal Stem Coupling", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_FLANGE_GASKET_ORING", "type": "esriFieldTypeString", "alias": "Flange Gasket / O-Ring Seals", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MID_FLANGE_BOLTS_NUTS", "type": "esriFieldTypeString", "alias": "Flange Bolts / Nuts", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUB_MAIN_OPERATION_VALVE", "type": "esriFieldTypeString", "alias": "Main Operation Valve", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUB_WATER_DRAINAGE", "type": "esriFieldTypeString", "alias": "Water Drainage", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUB_LOWER_STEM", "type": "esriFieldTypeString", "alias": "Lower Stem", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUB_STANDPIPE_SHOE_ASSEMBLY", "type": "esriFieldTypeString", "alias": "Standpipe / Shoe Assembly", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_LUBE_CAP_NOZZLE_OPNUT", "type": "esriFieldTypeString", "alias": "Lubrication (Caps, Nozzles, Operating Nut)", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_HYDRANT_OPENED_CLOSED", "type": "esriFieldTypeString", "alias": "Hydrant Opened and Closed Completely", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_WATER_CONDITION", "type": "esriFieldTypeString", "alias": "Water Condition", "length": 75, "domain": { "type": "codedValue", "name": "msMAINTENANCE_CHECKS", "description": "Maintenance Checks", "codedValues": [ { "name": "CHECKED AND OK AT THIS TIME", "code": "CHECKED AND OK AT THIS TIME" }, { "name": "MAY REQUIRE FUTURE ATTENTION", "code": "MAY REQUIRE FUTURE ATTENTION" }, { "name": "REQUIRES IMMEDIATE ATTENTION", "code": "REQUIRES IMMEDIATE ATTENTION" }, { "name": "CRITICAL FAILURE CRITERIA (OUT OF SERVICE)", "code": "CRITICAL FAILURE CRITERIA" }, { "name": "SERVICED", "code": "SERVICED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEN_CONDITION_OF_PAINT", "type": "esriFieldTypeString", "alias": "Condition of Paint", "length": 75, "domain": { "type": "codedValue", "name": "msCONDITION", "description": "Condition Rating Scale", "codedValues": [ { "name": "1-Poor", "code": "1-Poor" }, { "name": "2-Fair", "code": "2-Fair" }, { "name": "3-Average", "code": "3-Average" }, { "name": "4-Good", "code": "4-Good" }, { "name": "5-Excellent", "code": "5-Excellent" }, { "name": "Non Operational", "code": "Non Operational" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GALLONS_PER_MINUTE", "type": "esriFieldTypeString", "alias": "Gallons Per Minute", "length": 75, "domain": { "type": "codedValue", "name": "msGALLONS_PER_MINUTE", "description": "Gallons Per Minute Check Range", "codedValues": [ { "name": "NO FLOW", "code": "NO FLOW" }, { "name": "<500 GPM", "code": "< 500 GPM" }, { "name": "500 - 999 GPM", "code": "500 - 999 GPM" }, { "name": "1,000 - 1,499 GPM", "code": "1,000 - 1,499 GPM" }, { "name": "> 1,500 GPM", "code": "> 1,500 GPM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HYDRANT_VALVE_TURNS", "type": "esriFieldTypeSingle", "alias": "Number of Hydrant Valve Turns", "domain": null }, { "name": "CON_VALVE_PAD", "type": "esriFieldTypeString", "alias": "Concrete Valve Pad?", "length": 75, "domain": { "type": "codedValue", "name": "Boolean_Field", "description": "Boolean", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HYDRANT_GRADE", "type": "esriFieldTypeString", "alias": "Is Hydrant to Grade?", "length": 75, "domain": { "type": "codedValue", "name": "Boolean_Field", "description": "Boolean", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRADE_CON_COMMENT", "type": "esriFieldTypeString", "alias": "Grade Condition Comment", "length": 255, "domain": null }, { "name": "PAINT_DATE", "type": "esriFieldTypeDate", "alias": "Date Painted", "length": 8, "domain": null }, { "name": "VALVE_STACK", "type": "esriFieldTypeString", "alias": "VALVE_STACK", "length": 75, "domain": { "type": "codedValue", "name": "waVALVE_STACK_GRADE", "description": "Valve Stack Grade", "codedValues": [ { "name": "Yes, It is to grade", "code": "Yes, It is to grade" }, { "name": "No, It is below grade", "code": "No, It is below grade" }, { "name": "No, It is above grade", "code": "No, It is above grade" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OIL_ADDED", "type": "esriFieldTypeString", "alias": "OIL_ADDED", "length": 255, "domain": { "type": "codedValue", "name": "msYESNONA", "description": "Yes,No,N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REF_ROADMARKERS", "type": "esriFieldTypeString", "alias": "REF_ROADMARKERS", "length": 255, "domain": { "type": "codedValue", "name": "msYESNONA", "description": "Yes,No,N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R60_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_92_H_GUID", "fields": "H_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Backward_Hydrant", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "H_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{66B66D40-E5D8-4A40-A926-91D5F8B7C113}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1dde647417c441b58f4f48884a53d12b" }