{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 42,
 "name": "Sewer Valve Info",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NAME_NUMBER",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "NAME_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "NAME NUMBER",
   "length": 30,
   "domain": null
  },
  {
   "name": "FFID",
   "type": "esriFieldTypeInteger",
   "alias": "FFID",
   "domain": null
  },
  {
   "name": "Maintenance_Strategy",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Strategy",
   "length": 30,
   "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"
   }
  },
  {
   "name": "Install_Year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Install Year",
   "domain": null
  },
  {
   "name": "WarrantyStartDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Start Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "WarrantyEndDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty End Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "length": 50,
   "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"
   }
  },
  {
   "name": "Model_No",
   "type": "esriFieldTypeString",
   "alias": "Model No",
   "length": 30,
   "domain": null
  },
  {
   "name": "Serial_No",
   "type": "esriFieldTypeString",
   "alias": "Serial No",
   "length": 30,
   "domain": null
  },
  {
   "name": "Bury_Condition",
   "type": "esriFieldTypeString",
   "alias": "Bury_Condition",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "BUO_Bury_Condition",
    "description": "Bury Condition",
    "codedValues": [
     {
      "name": "Vault",
      "code": "Vault"
     },
     {
      "name": "Direct Bury",
      "code": "Direct Bury"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Operator_Type",
   "type": "esriFieldTypeString",
   "alias": "Operator Type",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "BUO_Operator_Type",
    "description": "Valve operation type",
    "codedValues": [
     {
      "name": "Wheel",
      "code": "Wheel"
     },
     {
      "name": "Key",
      "code": "Key"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ARV_Odor_Control_System",
   "type": "esriFieldTypeString",
   "alias": "ARV Odor Control System",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "Yes/No",
    "description": "Three character Yes/No values",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Open_Direction",
   "type": "esriFieldTypeString",
   "alias": "Open Direction",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "BUO_Rotation",
    "description": "Rotation values specified by the Bureau of Utility Operations",
    "codedValues": [
     {
      "name": "CW",
      "code": "CW"
     },
     {
      "name": "CCW",
      "code": "CCW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Turns_To_Close",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Turns To Close",
   "domain": null
  },
  {
   "name": "Current_Position",
   "type": "esriFieldTypeString",
   "alias": "Current Position",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "BUO_Current_Position",
    "description": "State of Valve",
    "codedValues": [
     {
      "name": "Open",
      "code": "Open"
     },
     {
      "name": "Closed",
      "code": "Closed"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Current_Position_Date",
   "type": "esriFieldTypeDate",
   "alias": "Current Position Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ARV_Priority",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ARV Priority",
   "domain": null
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 255,
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 20,
   "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"
   }
  },
  {
   "name": "Valve_ID",
   "type": "esriFieldTypeString",
   "alias": "Valve ID",
   "length": 25,
   "domain": null
  },
  {
   "name": "Vault_Material",
   "type": "esriFieldTypeString",
   "alias": "Vault Material",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "BUO_Wall_Type",
    "description": "Wall types defined by the Bureau of Utility Operations",
    "codedValues": [
     {
      "name": "Brick",
      "code": "Brick"
     },
     {
      "name": "Block",
      "code": "Block"
     },
     {
      "name": "Precast",
      "code": "Precast"
     },
     {
      "name": "Poured",
      "code": "Poured"
     },
     {
      "name": "Plastic",
      "code": "Plastic"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Vault_Shape",
   "type": "esriFieldTypeString",
   "alias": "Vault Shape",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "BUOVaultShape",
    "description": "Sewer Vault Shape",
    "codedValues": [
     {
      "name": "Circular",
      "code": "Circular"
     },
     {
      "name": "Rectangular",
      "code": "Rectangular"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Valve_Type",
   "type": "esriFieldTypeString",
   "alias": "Valve Type",
   "length": 40,
   "domain": {
    "type": "codedValue",
    "name": "BUO_ARVType",
    "description": "Type of Sewer Air Release Valve",
    "codedValues": [
     {
      "name": "Air Release",
      "code": "Air Release"
     },
     {
      "name": "Combination",
      "code": "Combination"
     },
     {
      "name": "Vacuum",
      "code": "Vacuum"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Tap_Type",
   "type": "esriFieldTypeString",
   "alias": "Tap Type",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "BUOTapType",
    "description": "Type of Sewer Valve Tap",
    "codedValues": [
     {
      "name": "Flange",
      "code": "Flange"
     },
     {
      "name": "Saddle",
      "code": "Saddle"
     },
     {
      "name": "Tap",
      "code": "Tap"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Valve_Position",
   "type": "esriFieldTypeString",
   "alias": "Valve Position",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "BUO_Current_Position",
    "description": "State of Valve",
    "codedValues": [
     {
      "name": "Open",
      "code": "Open"
     },
     {
      "name": "Closed",
      "code": "Closed"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Valve_Location",
   "type": "esriFieldTypeString",
   "alias": "Valve Location",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "BUO_ARVLocation",
    "description": "Location of ARV in Vault",
    "codedValues": [
     {
      "name": "Top",
      "code": "Top"
     },
     {
      "name": "Side",
      "code": "Side"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Nipple_Material",
   "type": "esriFieldTypeString",
   "alias": "Nipple Material",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "BUO_ARVPipeMaterial",
    "description": "ARV Pipe Material",
    "codedValues": [
     {
      "name": "Cast Iron",
      "code": "Cast Iron"
     },
     {
      "name": "Galvanized",
      "code": "Galvanized"
     },
     {
      "name": "Stainless",
      "code": "Stainless"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Max_Pressure",
   "type": "esriFieldTypeDouble",
   "alias": "Max Pressure",
   "domain": null
  },
  {
   "name": "Min_Pressure",
   "type": "esriFieldTypeDouble",
   "alias": "Min Pressure",
   "domain": null
  },
  {
   "name": "Valve_Size",
   "type": "esriFieldTypeDouble",
   "alias": "Valve Size",
   "domain": null
  },
  {
   "name": "Tap_Size",
   "type": "esriFieldTypeDouble",
   "alias": "Tap Size",
   "domain": null
  },
  {
   "name": "Vault_Length",
   "type": "esriFieldTypeDouble",
   "alias": "Vault Length",
   "domain": null
  },
  {
   "name": "Vault_Width",
   "type": "esriFieldTypeDouble",
   "alias": "Vault Width",
   "domain": null
  },
  {
   "name": "Vault_Floor_to_Ceiling",
   "type": "esriFieldTypeDouble",
   "alias": "Vault Floor to Ceiling",
   "domain": null
  },
  {
   "name": "Side_Wall_to_Valve",
   "type": "esriFieldTypeDouble",
   "alias": "Side Wall to Valve",
   "domain": null
  },
  {
   "name": "Front_Wall_to_Valve",
   "type": "esriFieldTypeDouble",
   "alias": "Front Wall to Valve",
   "domain": null
  },
  {
   "name": "Main_to_Ceiling",
   "type": "esriFieldTypeDouble",
   "alias": "Main to Ceiling",
   "domain": null
  },
  {
   "name": "PS_Area",
   "type": "esriFieldTypeString",
   "alias": "PS Area",
   "length": 25,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R72_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "Utilities.SDELOADER.Sewer_ValvePROD",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "NAME_NUMBER",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "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": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}