{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 43,
 "name": "Water Hydrant Info",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "FHNUM",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "FID_ATTR",
   "type": "esriFieldTypeInteger",
   "alias": "FID_ATTR",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "FID_ATTR"
  },
  {
   "name": "FHNUM",
   "type": "esriFieldTypeString",
   "alias": "FH NUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "FHNUM"
  },
  {
   "name": "Maintenance_Strategy",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Strategy",
   "domain": {
    "type": "codedValue",
    "name": "BUO_Maintenance_Strategy",
    "description": "Maintenance strategies defined by the Bureau of Utility Operations",
    "codedValues": [
     {
      "name": "Run To Failure",
      "code": "Run To Failure"
     },
     {
      "name": "Preventative Maintenance",
      "code": "Preventative Maintenance"
     },
     {
      "name": "Predictive Maintenance",
      "code": "Predictive Maintenance"
     },
     {
      "name": "Risk",
      "code": "Risk"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "BUO_Maintenance_Strategy"
  },
  {
   "name": "Install_Year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Install Year",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Install_Year"
  },
  {
   "name": "WarrantyStartDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Start Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "WarrantyStartDate"
  },
  {
   "name": "WarrantyEndDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty End Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "WarrantyEndDate"
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "domain": {
    "type": "codedValue",
    "name": "BUO_MFG_Valve",
    "description": "Valve manufacturers as specified by the Bureau of Utility Operations",
    "codedValues": [
     {
      "name": "A.R.I. USA Inc.",
      "code": "A.R.I USA Inc."
     },
     {
      "name": "ABZ Manufacturing",
      "code": "ABZ Manufacturing"
     },
     {
      "name": "Acrison, Inc.",
      "code": "Acrison, Inc."
     },
     {
      "name": "American",
      "code": "American"
     },
     {
      "name": "Ames",
      "code": "Ames"
     },
     {
      "name": "Anniston",
      "code": "Anniston"
     },
     {
      "name": "APCO Valves",
      "code": "APCO Valves"
     },
     {
      "name": "Apollo Valves",
      "code": "Apollo Valves"
     },
     {
      "name": "Avk Valves",
      "code": "Avk Valves"
     },
     {
      "name": "Beeco",
      "code": "Beeco"
     },
     {
      "name": "Bermad Valve",
      "code": "Bermad Valve"
     },
     {
      "name": "BIF",
      "code": "BIF"
     },
     {
      "name": "Bray Control And Valves",
      "code": "Bray Controls And Valves"
     },
     {
      "name": "Cameron",
      "code": "Cameron"
     },
     {
      "name": "Centerline",
      "code": "Centerline"
     },
     {
      "name": "Cla-Val",
      "code": "Cla-Val"
     },
     {
      "name": "CLB Valve",
      "code": "CLB Valve"
     },
     {
      "name": "Clow Valve Company",
      "code": "Clow Valve Company"
     },
     {
      "name": "Crane Valves",
      "code": "Crane Valves"
     },
     {
      "name": "Crispin Valve Manufacturing",
      "code": "Crispin Valve Manufacturing"
     },
     {
      "name": "Danfoss Valves",
      "code": "Danfoss Valves"
     },
     {
      "name": "Davis Valve",
      "code": "Davis Valve"
     },
     {
      "name": "Dezurik Valve Company",
      "code": "Dezurik Valve Company"
     },
     {
      "name": "DK TMI Co. , Ltd Valves",
      "code": "DK TMI Co. , Ltd Valves"
     },
     {
      "name": "Dresser Rand Group Inc.",
      "code": "Dresser Rand Group Inc."
     },
     {
      "name": "E.I.M. Controls",
      "code": "E.I.M. Controls"
     },
     {
      "name": "Eddy Iowa",
      "code": "Eddy Iowa"
     },
     {
      "name": "Febco",
      "code": "Febco"
     },
     {
      "name": "Flowline, Inc",
      "code": "Flowline, Inc"
     },
     {
      "name": "Flowserve",
      "code": "Flowserve"
     },
     {
      "name": "FNW Piping Products",
      "code": "FNW Piping Products"
     },
     {
      "name": "G.A. Industries",
      "code": "G.A. Industries"
     },
     {
      "name": "Hayward Gordon",
      "code": "Hayward Gordon"
     },
     {
      "name": "Hayward Plastics",
      "code": "Hayward Plastics"
     },
     {
      "name": "Henry Pratt Valve Co.",
      "code": "Henry Pratt Valve Co."
     },
     {
      "name": "Homestead Valves Co",
      "code": "Homestead Valve Co"
     },
     {
      "name": "Hydro Gate Valves",
      "code": "Hydro Gate Valves"
     },
     {
      "name": "Indelac Controls",
      "code": "Indelac Controls"
     },
     {
      "name": "Kennedy Fire Hydrants And Valves",
      "code": "Kennedy Fire Hydrants And Valves"
     },
     {
      "name": "Keystone Valve",
      "code": "Keystone Valve"
     },
     {
      "name": "Kinetrol Usa Inc",
      "code": "Kinetrol Usa Inc"
     },
     {
      "name": "Limitorque",
      "code": "Limitorque"
     },
     {
      "name": "M and H Valve",
      "code": "M and H Valve"
     },
     {
      "name": "Meyer Products",
      "code": "Meyer Products"
     },
     {
      "name": "Milliken Valve Company",
      "code": "Milliken Valve Company"
     },
     {
      "name": "Mueller Co.",
      "code": "Mueller Co."
     },
     {
      "name": "Nibco",
      "code": "Nibco"
     },
     {
      "name": "Orbinox Valve Solutions",
      "code": "Orbinox Valve Solutions"
     },
     {
      "name": "Pepco Valves",
      "code": "Pepco Valves"
     },
     {
      "name": "Plasti-fab, Inc.",
      "code": "Plasti-fab, Inc."
     },
     {
      "name": "Powell",
      "code": "Powell"
     },
     {
      "name": "Red Valve Company",
      "code": "Red Valve Company"
     },
     {
      "name": "Rodney Hunt - Fontaine Inc.",
      "code": "Rodney Hunt - Fontaine Inc."
     },
     {
      "name": "Ross Valve",
      "code": "Ross Valve"
     },
     {
      "name": "Rotork Actuators And Valves",
      "code": "Rotork Actuators And Valves"
     },
     {
      "name": "RW Gate Company",
      "code": "RW Gate Company"
     },
     {
      "name": "Saehan Valve Ind. Co , Ltd.",
      "code": "Saehan Valve Ind. Co , Ltd."
     },
     {
      "name": "Shick Tube-yeyor Corporation",
      "code": "Shick Tube-yeyor Corporation"
     },
     {
      "name": "Singer Heaters",
      "code": "Singer Heaters"
     },
     {
      "name": "Smith And Loveless",
      "code": "Smith And Loveless"
     },
     {
      "name": "SST Enviro Corp",
      "code": "SST Enviro Corp"
     },
     {
      "name": "Techno Check Valves - Cameron Valve",
      "code": "Techno Check Valves - Cameron Valve"
     },
     {
      "name": "Terminal City Iron Works Valves",
      "code": "Terminal City Iron Works Valves"
     },
     {
      "name": "Tideflex Technologies",
      "code": "Tideflex Technologies"
     },
     {
      "name": "Titan Flow Control, Inc.",
      "code": "Titan Flow Control, Inc."
     },
     {
      "name": "U.S. Manufacturing Inc.",
      "code": "U.S. Manufacturing Inc."
     },
     {
      "name": "Valmatic Valves",
      "code": "Valmatic Valves"
     },
     {
      "name": "Vortex Valves",
      "code": "Vortex Valves"
     },
     {
      "name": "Waterman Industries",
      "code": "Waterman Industries"
     },
     {
      "name": "Watts",
      "code": "Watts"
     },
     {
      "name": "Whipps",
      "code": "Whipps"
     },
     {
      "name": "Wilkins",
      "code": "Wilkins"
     },
     {
      "name": "Zurn Wilkins Engineered Water Solutions",
      "code": "Zurn Wilkins Engineered Water Solutions"
     },
     {
      "name": "H-TEC",
      "code": "H-TEC"
     },
     {
      "name": "Wood Matthew Fire Hydrant",
      "code": "Wood Matthew Fire Hydrant"
     },
     {
      "name": "Woods Matthews/Kennedy FH with Lead jnts",
      "code": "Woods Matthews/Kennedy FH with Lead jnts"
     },
     {
      "name": "Gaysco Valves",
      "code": "Gaysco Valves"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Manufacturer"
  },
  {
   "name": "Model_No",
   "type": "esriFieldTypeString",
   "alias": "Model No",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "Model"
  },
  {
   "name": "Serial_No",
   "type": "esriFieldTypeString",
   "alias": "Serial No",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "Serial"
  },
  {
   "name": "Access_Notes",
   "type": "esriFieldTypeString",
   "alias": "Access Notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Access_Notes"
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Notes"
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "domain": {
    "type": "codedValue",
    "name": "BUO_Status",
    "description": "Asset status as defined by the Bureau of Utilitity Operations",
    "codedValues": [
     {
      "name": "Proposed",
      "code": "Proposed"
     },
     {
      "name": "Active",
      "code": "Active"
     },
     {
      "name": "Inactive",
      "code": "Inactive"
     },
     {
      "name": "Abandoned",
      "code": "Abandoned"
     },
     {
      "name": "Removed",
      "code": "Removed"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "Status"
  },
  {
   "name": "Last_Paint_Dt",
   "type": "esriFieldTypeDate",
   "alias": "Last Paint Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Last_Paint_Dt"
  },
  {
   "name": "Recommendation",
   "type": "esriFieldTypeString",
   "alias": "Recommendation",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "Recommendation"
  }
 ],
 "indexes": [
  {
   "name": "R73_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Water Hydrant Info",
   "description": "",
   "prototype": {
    "attributes": {
     "Last_Paint_Dt": null,
     "Recommendation": null,
     "FID_ATTR": null,
     "FHNUM": null,
     "Maintenance_Strategy": null,
     "Install_Year": null,
     "WarrantyStartDate": null,
     "WarrantyEndDate": null,
     "Manufacturer": null,
     "Model_No": null,
     "Serial_No": null,
     "Access_Notes": null,
     "Notes": null,
     "Status": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 1000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 1000,
 "maxRecordCountFactor": 1
}