{
 "currentVersion": 10.81,
 "id": 217,
 "name": "tp_CraneHoist",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SITE_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "FACILITYID",
   "type": "esriFieldTypeString",
   "alias": "Facility ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "LEGACY_ID",
   "type": "esriFieldTypeString",
   "alias": "Legacy ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "CITY_ASSET_ID",
   "type": "esriFieldTypeString",
   "alias": "City Asset ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "Location Description",
   "length": 255,
   "domain": null
  },
  {
   "name": "PROJECT_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Project Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "length": 50,
   "domain": null
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "Model",
   "length": 50,
   "domain": null
  },
  {
   "name": "SERIAL_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Serial Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "PURCHASE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Purchase Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "INITIAL_COST",
   "type": "esriFieldTypeInteger",
   "alias": "Initial Cost",
   "domain": null
  },
  {
   "name": "INSTALLATION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Installation Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "WARRANTYDATE",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "REPLACEMENT_COST",
   "type": "esriFieldTypeInteger",
   "alias": "Replacement Cost",
   "domain": null
  },
  {
   "name": "REMAINING_VALUE",
   "type": "esriFieldTypeInteger",
   "alias": "Remaining Value",
   "domain": null
  },
  {
   "name": "OWNED_BY",
   "type": "esriFieldTypeString",
   "alias": "Owned By",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "tp_Owned_Maint_By",
    "description": "Owned/Maintained By",
    "codedValues": [
     {
      "name": "MyCodeName",
      "code": "MyCodedValue"
     },
     {
      "name": "HARRF Operations",
      "code": "HARRF_OPS"
     },
     {
      "name": "HARRF Plant Systems Technician",
      "code": "HARRF_PST"
     },
     {
      "name": "HARRF Control Systems Technician",
      "code": "HARRF_CST"
     },
     {
      "name": "HARRF Control Systems Analyst",
      "code": "HARRF_CSA"
     },
     {
      "name": "Laboratory Technician",
      "code": "LAB"
     },
     {
      "name": "WTP Operations",
      "code": "WTP_OPS"
     },
     {
      "name": "WTP Plant Systems Technician",
      "code": "WTP_PST"
     },
     {
      "name": "WTP Control Systems Technician",
      "code": "WTP_CST"
     },
     {
      "name": "WTP Control Systems Analyst",
      "code": "WTP_CSA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "MAINTAINED_BY",
   "type": "esriFieldTypeString",
   "alias": "Maintained By",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "tp_Owned_Maint_By",
    "description": "Owned/Maintained By",
    "codedValues": [
     {
      "name": "MyCodeName",
      "code": "MyCodedValue"
     },
     {
      "name": "HARRF Operations",
      "code": "HARRF_OPS"
     },
     {
      "name": "HARRF Plant Systems Technician",
      "code": "HARRF_PST"
     },
     {
      "name": "HARRF Control Systems Technician",
      "code": "HARRF_CST"
     },
     {
      "name": "HARRF Control Systems Analyst",
      "code": "HARRF_CSA"
     },
     {
      "name": "Laboratory Technician",
      "code": "LAB"
     },
     {
      "name": "WTP Operations",
      "code": "WTP_OPS"
     },
     {
      "name": "WTP Plant Systems Technician",
      "code": "WTP_PST"
     },
     {
      "name": "WTP Control Systems Technician",
      "code": "WTP_CST"
     },
     {
      "name": "WTP Control Systems Analyst",
      "code": "WTP_CSA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "LIFECYCLE_STATUS",
   "type": "esriFieldTypeString",
   "alias": "Lifecycle Status",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "tp_Lifecycle_Status",
    "description": "Lifecycle Status",
    "codedValues": [
     {
      "name": "Installed",
      "code": "INSTALLED"
     },
     {
      "name": "Uninstalled",
      "code": "UNINSTALLED"
     },
     {
      "name": "Abandoned-In-Place",
      "code": "ABANDONEDINPLACE"
     },
     {
      "name": "Salvaged",
      "code": "SALVAGED"
     },
     {
      "name": "Disposed/Removed",
      "code": "DISPOSEDREMOVED"
     },
     {
      "name": "Planned/On Order",
      "code": "PLANNEDONORDER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CRITICAL",
   "type": "esriFieldTypeString",
   "alias": "Critical?",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tp_glblBoolean",
    "description": "Global Boolean",
    "codedValues": [
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Not Applicable",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CONDITION",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Condition",
   "domain": null
  },
  {
   "name": "CONDITIONDATE",
   "type": "esriFieldTypeDate",
   "alias": "Condition Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "YR_EXPECTED_END_PHYSICAL_LIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Expected End of Physical Life",
   "domain": null
  },
  {
   "name": "TYPICAL_YRS_FULLY_DEPRECIATE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Typical Years to Fully Depreciate",
   "domain": null
  },
  {
   "name": "DEPRECIATION_DETAILS",
   "type": "esriFieldTypeString",
   "alias": "Depreciation Details",
   "length": 50,
   "domain": null
  },
  {
   "name": "CONSEQUENCE_OF_FAILURE",
   "type": "esriFieldTypeDouble",
   "alias": "Consequence of Failure (COF)",
   "domain": null
  },
  {
   "name": "PROBABILITY_OF_FAILURE",
   "type": "esriFieldTypeDouble",
   "alias": "Probability of Failure (POF)",
   "domain": null
  },
  {
   "name": "BUSINESS_RISK_EXPOSURE",
   "type": "esriFieldTypeDouble",
   "alias": "Business Risk Exposure (BRE)",
   "domain": null
  },
  {
   "name": "DATE_CALCULATED",
   "type": "esriFieldTypeDate",
   "alias": "COF, POF, and BRE Calculation",
   "length": 8,
   "domain": null
  },
  {
   "name": "MAINTENANCE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Maintenance Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "MAINTENANCE_COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "IMAGE_URL",
   "type": "esriFieldTypeString",
   "alias": "Image URL",
   "length": 255,
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "SITE_NAME",
   "type": "esriFieldTypeString",
   "alias": "Site Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "PROCESS_NAME",
   "type": "esriFieldTypeString",
   "alias": "System Name",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "tp_Process_Name",
    "description": "Process Name",
    "codedValues": [
     {
      "name": "Preliminary Treatment",
      "code": "PRETREAT"
     },
     {
      "name": "Primary Treatment",
      "code": "PRIMTREAT"
     },
     {
      "name": "Secondary Treatment",
      "code": "SECTREAT"
     },
     {
      "name": "Tertiary Treatment",
      "code": "TERTREAT"
     },
     {
      "name": "Reclaimed Water Storage and Pumping",
      "code": "RCWSTOREPUMP"
     },
     {
      "name": "Solids Handling",
      "code": "SOLIDSHANDLING"
     },
     {
      "name": "Raw Water Supply",
      "code": "RAWSUPPLY"
     },
     {
      "name": "Chemical",
      "code": "CHEMICAL"
     },
     {
      "name": "Microfiltration",
      "code": "MICROFILTRATION"
     },
     {
      "name": "Reverse Osmosis",
      "code": "REVERSEOSMOSIS"
     },
     {
      "name": "Odor Control",
      "code": "ODORCNTRL"
     },
     {
      "name": "Stormwater Bypass",
      "code": "SWBYPASS"
     },
     {
      "name": "Facility Support",
      "code": "FACILITYSUPPORT"
     },
     {
      "name": "Electrical",
      "code": "ELECTRICAL"
     },
     {
      "name": "Life Safety",
      "code": "LIFESAFETY"
     },
     {
      "name": "Recycled Water",
      "code": "RECYCLEWATER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "SUBPROCESS_NAME",
   "type": "esriFieldTypeString",
   "alias": "Subsystem Name",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "tp_Subprocess_Name",
    "description": "Subprocess Name",
    "codedValues": [
     {
      "name": "Screening",
      "code": "SCREENING"
     },
     {
      "name": "Pumping",
      "code": "PUMPING"
     },
     {
      "name": "Grit Removal",
      "code": "GRITREMOVAL"
     },
     {
      "name": "Scum Collection",
      "code": "SCUMCOLLECT"
     },
     {
      "name": "Clarification",
      "code": "CLARIFICATION"
     },
     {
      "name": "Air Supply",
      "code": "AIRSUPPLY"
     },
     {
      "name": "Difffusion",
      "code": "DIFFUSION"
     },
     {
      "name": "Return Activated Sludge",
      "code": "RETACTSLUDGE"
     },
     {
      "name": "Waste Activated Sludge",
      "code": "WASTEACTSLUDGE"
     },
     {
      "name": "Effluent",
      "code": "EFFLUENT"
     },
     {
      "name": "Secondary Effluent",
      "code": "SECEFFLUENT"
     },
     {
      "name": "Agricultural Water",
      "code": "AGWATER"
     },
     {
      "name": "Storage",
      "code": "STORAGE"
     },
     {
      "name": "Filtration",
      "code": "FILTRATION"
     },
     {
      "name": "Disinfection",
      "code": "DISINFECTION"
     },
     {
      "name": "Chlorination",
      "code": "CHLORINATION"
     },
     {
      "name": "Neutralization",
      "code": "NEUTRALIZATION"
     },
     {
      "name": "Primary Digestion",
      "code": "PRIMDIGESTION"
     },
     {
      "name": "Secondary Digestion",
      "code": "SECDIGESTION"
     },
     {
      "name": "Sludge Thickening",
      "code": "SLUDGETHICK"
     },
     {
      "name": "Dewatering",
      "code": "DEWATER"
     },
     {
      "name": "Piping",
      "code": "PIPING"
     },
     {
      "name": "Coagulation",
      "code": "COAGULATION"
     },
     {
      "name": "Flocculation",
      "code": "FLOCCULATION"
     },
     {
      "name": "Feed",
      "code": "FEED"
     },
     {
      "name": "Clean In Place (CIP)",
      "code": "CIP"
     },
     {
      "name": "Backwash",
      "code": "BACKWASH"
     },
     {
      "name": "Reverse Osmosis",
      "code": "REVOSMOSIS"
     },
     {
      "name": "Odor Collection",
      "code": "ODORCOLLECT"
     },
     {
      "name": "Nutrient Feed System",
      "code": "NUTFEEDSYS"
     },
     {
      "name": "Air Scrubbing",
      "code": "AIRSCRUBBING"
     },
     {
      "name": "Pressure Reduction",
      "code": "PRESSREDUCTION"
     },
     {
      "name": "Security Access Control",
      "code": "SECACCESSCNTRL"
     },
     {
      "name": "HVAC",
      "code": "HVAC"
     },
     {
      "name": "Plumbing",
      "code": "PLUMBING"
     },
     {
      "name": "Building Electrical",
      "code": "BLDGELECTRICAL"
     },
     {
      "name": "Building Structural Maintenance",
      "code": "BLDGSTRUCTMAINT"
     },
     {
      "name": "Generation",
      "code": "GENERATION"
     },
     {
      "name": "Transfer",
      "code": "TRANSFER"
     },
     {
      "name": "Distribution",
      "code": "DISTRIBUTION"
     },
     {
      "name": "Grounding/Lightning Protection",
      "code": "GRNDLIGHTPROTECT"
     },
     {
      "name": "Fire Suppression",
      "code": "FIRESUPPRESS"
     },
     {
      "name": "Personal Protection",
      "code": "PERSONALPROTECT"
     },
     {
      "name": "Fire Alarm",
      "code": "FIREALARM"
     },
     {
      "name": "Recycle Water Chlorination",
      "code": "DECHLORINATION"
     },
     {
      "name": "Brine",
      "code": "BRINE"
     },
     {
      "name": "Sodium Hypochlorite",
      "code": "SODIUM_HYPOCHLORITE"
     },
     {
      "name": "Ferric",
      "code": "FERRIC"
     },
     {
      "name": "Coagulant",
      "code": "COAGULANT"
     },
     {
      "name": "Polymer",
      "code": "POLYMER"
     },
     {
      "name": "Supervisory Control and Data Acquisition",
      "code": "SCADA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CRANE_HOIST_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Crane/Hoist Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "tp_Crane_Hoist_Type",
    "description": "Crane Hoist Type",
    "codedValues": [
     {
      "name": "Gantry",
      "code": "GANTRY"
     },
     {
      "name": "Overhead Bridge",
      "code": "OVERHEADBRIDGE"
     },
     {
      "name": "Jib",
      "code": "JIB"
     },
     {
      "name": "Monorail",
      "code": "MONORAIL"
     },
     {
      "name": "Manual Lift",
      "code": "MANUALLIFT"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "CAPACITY",
   "type": "esriFieldTypeDouble",
   "alias": "Capacity (Tons)",
   "domain": null
  },
  {
   "name": "VOLTAGE",
   "type": "esriFieldTypeString",
   "alias": "Voltage (Volts)",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "tp_Voltage",
    "description": "Voltage",
    "codedValues": [
     {
      "name": "12 (DC)",
      "code": "12DC"
     },
     {
      "name": "24 (DC)",
      "code": "24DC"
     },
     {
      "name": "24 VDC (Loop Powered)",
      "code": "24VDCLOOPEDWRD"
     },
     {
      "name": "110/120 (AC)",
      "code": "110120AC"
     },
     {
      "name": "208 (AC)",
      "code": "208AC"
     },
     {
      "name": "240 (DC)",
      "code": "240DC"
     },
     {
      "name": "460/480 (AC)",
      "code": "460480AC"
     },
     {
      "name": "4160 (AC)",
      "code": "4160AC"
     },
     {
      "name": "12.47K (AC)",
      "code": "1247KAC"
     },
     {
      "name": "2400 (AC)",
      "code": "2400AC"
     },
     {
      "name": "120/240 (AC)",
      "code": "120240AC"
     },
     {
      "name": "115/230 (AC)",
      "code": "115230AC"
     },
     {
      "name": "90 (AC)",
      "code": "90AC"
     },
     {
      "name": "220 (AC)",
      "code": "220AC"
     },
     {
      "name": "4000 (AC)",
      "code": "4000AC"
     },
     {
      "name": "2.3kV (AC)",
      "code": "23kVAC"
     },
     {
      "name": "240 (AC)",
      "code": "240AC"
     },
     {
      "name": "12/24 (AC)",
      "code": "1224AC"
     },
     {
      "name": "4.76 kV",
      "code": "476kV"
     },
     {
      "name": "15 kV",
      "code": "15kV"
     },
     {
      "name": "11000 V",
      "code": "11000V"
     },
     {
      "name": "240/480 V",
      "code": "240480V"
     },
     {
      "name": "230/460 V",
      "code": "230460V"
     },
     {
      "name": "208/120 V",
      "code": "208120V"
     },
     {
      "name": "4760 V",
      "code": "4760V"
     },
     {
      "name": "11500 V",
      "code": "11500V"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     },
     {
      "name": "Not Applicable",
      "code": "NA"
     },
     {
      "name": "700 (DC)",
      "code": "700DC"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "POINT_OF_INTEREST_ID",
   "type": "esriFieldTypeString",
   "alias": "Position ID (Relate)",
   "length": 50,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "LASTEDITOR",
   "type": "esriFieldTypeString",
   "alias": "LASTEDITOR",
   "length": 50,
   "domain": null
  },
  {
   "name": "LASTUPDATE",
   "type": "esriFieldTypeDate",
   "alias": "LASTUPDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ASSETSTATUS",
   "type": "esriFieldTypeString",
   "alias": "ASSETSTATUS",
   "length": 1,
   "domain": {
    "type": "codedValue",
    "name": "AssetStatus",
    "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).",
    "codedValues": [
     {
      "name": "Current",
      "code": "C"
     },
     {
      "name": "Retired",
      "code": "R"
     },
     {
      "name": "Abandoned",
      "code": "A"
     },
     {
      "name": "Geometric Network Only",
      "code": "G"
     },
     {
      "name": "Proposed",
      "code": "P"
     },
     {
      "name": "Needs Review",
      "code": "N"
     },
     {
      "name": "to Delete",
      "code": "D"
     },
     {
      "name": "Transposed",
      "code": "T"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R730_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_730",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G2932POINT_OF_IN",
   "fields": "POINT_OF_INTEREST_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 11,
   "name": "tp_PointsOfInterest",
   "relatedTableId": 127,
   "role": "esriRelRoleDestination",
   "keyField": "POINT_OF_INTEREST_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null,
 "serviceItemId": "551ed99598bc4645bc48894460c82fc3"
}