{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "HydrantID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "HydrantID", "type": "esriFieldTypeString", "alias": "Hydrant ID", "length": 50, "domain": null }, { "name": "TagID", "type": "esriFieldTypeString", "alias": "Tag ID", "length": 50, "domain": null }, { "name": "OverallCondition_Structure_", "type": "esriFieldTypeString", "alias": "Overall Condition - Structure\n", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OverallCondition_Operation", "type": "esriFieldTypeString", "alias": "Overall Condition - Operation", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ClearBrush", "type": "esriFieldTypeString", "alias": "Clear of Brush or Other Obstructions", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BrushAction", "type": "esriFieldTypeString", "alias": "Clear of Brush - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Flange_6", "type": "esriFieldTypeString", "alias": "Traffic flange does not exceed 6_ above ground level", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlangeAction", "type": "esriFieldTypeString", "alias": "Flange - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BreakAway", "type": "esriFieldTypeString", "alias": "Condition of break-away device", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BreakAwayAction", "type": "esriFieldTypeString", "alias": "Break-away device - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ListenLeakage", "type": "esriFieldTypeString", "alias": "Listen device check for main valve leakage", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ListenLeakageAction", "type": "esriFieldTypeString", "alias": "Listen device - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BarrelFreeWet", "type": "esriFieldTypeString", "alias": "Hydrant barrel free of water and/or ice", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BarrelFreeWetAction", "type": "esriFieldTypeString", "alias": "Hydrant barrel - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Caps", "type": "esriFieldTypeString", "alias": "All caps in place", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CapsAction", "type": "esriFieldTypeString", "alias": "All caps in place - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LubricationAction", "type": "esriFieldTypeString", "alias": "Lubrication - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UpperBarrelLeaks", "type": "esriFieldTypeString", "alias": "Listening device check for upper barrel leaks", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UpperBarrelLeaksAction", "type": "esriFieldTypeString", "alias": "Upper barrel leaks - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructuralLeaks", "type": "esriFieldTypeString", "alias": "Structural Leaks", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructuralLeaksAction", "type": "esriFieldTypeString", "alias": "Structural leaks - Corrective Action Taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StaticPSI", "type": "esriFieldTypeDouble", "alias": "Record static hydrant pressure (psi)", "domain": null }, { "name": "FlushOperation", "type": "esriFieldTypeString", "alias": "Flush operation", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IsoValveOp", "type": "esriFieldTypeString", "alias": "Isolation Valve Operational", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IsoValveOpAction", "type": "esriFieldTypeString", "alias": "Iso Valve - corrective action taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BarrelDrainage", "type": "esriFieldTypeString", "alias": "Hydrant barrel drainage", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BarrelDrainageAction", "type": "esriFieldTypeString", "alias": "Hydrant Barrel - Corrective action taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CapThreads", "type": "esriFieldTypeString", "alias": "Cap threads and lubrication", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CapThreadsAction", "type": "esriFieldTypeString", "alias": "Cap threads - corrective action taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HyTagged", "type": "esriFieldTypeString", "alias": "Hydrant Tagged", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HyTaggedAction", "type": "esriFieldTypeString", "alias": "Hydrant tagged - Corrective action taken?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WO_Req", "type": "esriFieldTypeString", "alias": "Work Order Required", "length": 50, "domain": { "type": "codedValue", "name": "WorkOrderReq", "description": "Work Order Required", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Immediate Action", "code": "Immediate Action" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "length": 100, "domain": null }, { "name": "DeadEndMainHydrant", "type": "esriFieldTypeString", "alias": "Hydrant on Dead End Main", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lubrication", "type": "esriFieldTypeString", "alias": "Lubrication", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass or Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" }, { "name": "Not Inspected", "code": "Not Inspected" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 500, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 50, "domain": null }, { "name": "Creator_Date", "type": "esriFieldTypeDate", "alias": "Creator_Date", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "Editor_Date", "type": "esriFieldTypeDate", "alias": "Editor_Date", "length": 8, "domain": null }, { "name": "WOID", "type": "esriFieldTypeString", "alias": "WOID", "length": 50, "domain": null }, { "name": "Exercised", "type": "esriFieldTypeString", "alias": "Exercised", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Flagged", "type": "esriFieldTypeString", "alias": "Flagged", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected", "type": "esriFieldTypeString", "alias": "Inspected", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Painted", "type": "esriFieldTypeString", "alias": "Painted", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Raised", "type": "esriFieldTypeString", "alias": "Raised", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Repaired", "type": "esriFieldTypeString", "alias": "Repaired", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Tagged", "type": "esriFieldTypeString", "alias": "Tagged", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Winterized", "type": "esriFieldTypeString", "alias": "Winterized", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Greased", "type": "esriFieldTypeString", "alias": "Greased", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QAQCComments", "type": "esriFieldTypeString", "alias": "QAQCComments", "length": 500, "domain": null }, { "name": "QAQC_By", "type": "esriFieldTypeString", "alias": "QAQC_By", "length": 50, "domain": null }, { "name": "QAQC_Date", "type": "esriFieldTypeDate", "alias": "QAQC_Date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R12_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_16_HydrantID", "fields": "HydrantID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_12", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_16_TagID", "fields": "TagID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Hydrants", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "TagID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{80A89186-D20A-4D81-A2CD-8AA9B558B8A3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }