Highway Lighting Inventory
Lighting installed along Ohio's highways, inventoried by ODOT.
- Published by
- ODOT Office of Roadway Engineering
- Source
- Ohio Department of Transportation TIMS
- Original data
- tims.dot.state.oh.us
- Terms of use
- Public information, no warranty (ODOT)
- On the map
- Points
Ask State Planner a question about this data in plain language, and get the answer as a written explanation and a map.
Sign up to askFields
What each record holds, as the publisher describes it: 112 fields.
| Field | Description |
|---|---|
NLFID | Network Linear Feature Identifier |
CRS | County-Route-Section. County CD, Route Number, CTL Begin Number (ALL-30-10.432) |
ODOT_DISTRICT | ODOT District Number |
COUNTY | Full County Name |
COUNTY_CD | Three Character County Code |
ROUTE_TYPE | IR, US, SR, CR, TR, MR, etc |
ROUTE_NBR | 5 Digit Route Number |
ROUTE_SUFFIX | A, B, C, D, I, F, T etc. |
CTL_BEGIN_NBR | County log point of highway lighting |
STL_BEGIN_NBR | State log point of highway lighting |
LATITUDE_DD_BEGIN | Latitude of highway light |
LONGITUDE_DD_BEGIN | Longitude of highway light |
PERP_DATE | Date of Linear Referencing System(LRS) highway light is located against |
STATUS | status of highway light |
INSTALLATION_DATE | Date highway light was installed |
PID | PID under which the highway light was installed |
END_CONSTRUCTION_DATE | end of construction date in Ellis |
HL_FILE_NUM | Unique number assigned to lighting pole |
DATE_RELAMPED | Date of the last time the luminaires were replaced |
CLUSTERID | This field will be used if districts want to group lights together |
OWNER_AGENCY | Agency responsible for inspecting light |
POLE_ID | Identifier on each lighting support |
LIGHTING_TYPE | Type of highway lighting support |
DECORATIVE | Indicator if the highway light support is decorative |
FOUNDATION_BOLT | Number of bolts on the tower foundation |
SUPPORT_BASE_TYPE | Type of base on highway light support |
SUPPORT_BASE_STYLE | Style of base on highway light support |
FOUNDATION_DEPTH_FT | Depth of foundation of the highway light support |
POLE_HEIGHT_FT | Height of support |
MOUNTING_HEIGHT_FT | Height of luminaire on support from ground |
NUM_BRACKET_ARMS | Number of bracket arms on support |
BRACKET_ARM_LENGTH1_FT | Length of bracket on support in feet |
BRACKET_ARM_LENGTH2_FT | Length of bracket on support in feet |
BRACKET_ARM_LENGTH3_FT | Length of bracket on support in feet |
MAINT_PLATFORM | Indicator if the highway lighting support has a maintenance platform |
VARMINT_SCREENING | Indicator if the highway lighting support has a varmint screen |
PAINTED_COATED | Indicator if the highway lighting support is painted or coated |
MEDIAN_WALL_MOUNT | Indicator if the highway lighting support is mounted on a median wall |
BRIDGE_MOUNT | Indicator if the highway lighting support is mounted on a bridge |
STRUCTURE_MOUNT | Indicator if the highway lighting structure is mounted on a support that is not a bridge |
SUPPORT_COMMENTS | Catch all comment field for highway lighting support |
LUMINAIRE_TYPE | Type of Luminaire |
NUM_LUMINAIRES | Number of luminaires on support |
HPS_WATTAGE | Wattage of HPS luminaire |
LED_WATTAGE | Wattage of LED luminaire |
LUMENS | Amount of lumens luminaire gives off |
GLARE_SHIELD | Indicator if highway light has a glare shield |
IES_DISTRIBUTION | Distrubution of light |
LUMINAIRE_BRAND | Brand of luminaire |
LUMINAIRE_MODEL_NUM | Model number of luminaire |
VOLTAGE | Voltage of the luminaire |
BULB_IS_OUT | Indicator if the bulb is out |
SIGNAL_POLE_MOUNTED | Indicator if the luminaire is mounted on a signal pole |
WOOD_POLE_MOUNTED | Indicator if the luminaire is mounted on a wood pole |
UTILITY_POLE_MOUNTED | Indicator if the luminaire is mounted on a utility pole |
SIGN_SUPPORT_MOUNTED | Indicator if the luminaire is mounted on a sign support |
AIRPORT_OBSTRUCT_LIGHT | Indicator if there is an airport obstruction light present |
LUMINAIRE_COMMENTS | Catch all comment field for highway lighting luminaire |
CCPS_CONFIGURATION | How the Control Center/Power Service is mounted |
CONTROL_CENTER_ID | Control Center ID for Control Center/Power Service |
CIRCUIT_ID | Circuit ID for the Control Center/Power Service |
POWER_SERV_FILE_NUMBER | Power Service File Number from ITS Inventory |
POWER_COMPANY | Power Complany that is supplying power to the Control Center/Power Service |
ACCOUNT_NUMBER | Account Number of the Control Center/Power Service |
METER_NUMBER | Meter Number of the Control Center/Power Service |
CC_KVA | cc kVa of the Control Center/Power Service |
PREMETER_DISCONNECT | Indicator if the Control Center/Power service is a pre-meter unfused disconnect |
CT_CABINET | Indicator if the Control Center/Power service is a CT cabinet |
CCPS_COMMENTS | Catch all comment field for highway lighting Control Center/Power Service |
LATEST_INSPECTION_DATE | Inspection Date from most recent inspection |
INSPECTION_DUE_YEARS | Years until the next inspection is due (Calendar Year) |
RELAMP_DUE_YEARS | Years until the next relamp is due (Calendar Year) |
invNEED_FURTHER_INSPECT | Indicator if further inspection is needed, associated with the inventory record |
invMAINTENANCE_NEEDED | Indicator if maintenance is needed, associated with the inventory record |
LATEST_MAINTENANCE_DATE | Latest maintenance date |
FOUNDATION_CRACK_SPALL | Indicator if there is cracking or spalling on the foundation |
FOUNDATION_BURIED_EROS | Indicator if there is foundation is buried or eroded |
BOLT_NUT_CORROSION | Indicator of Corrosion on Anchor Bolts/Nuts |
BOLT_NUT_LOOSE | Indicator if Anchor Bolts/Nuts are loose |
BOLT_NUT_WASHER_MISS | Indicator if Anchor Bolts/Nuts are missing washers |
POLE_POSITION | Indicator if the pole is down |
POLE_DAMAGE | Type of damage on pole |
BRACKET_ARM_DAMAGE | Type of damage on bracket arm |
ANCHOR_BOLT_DAMAGE | Type of damage on anchor bolt |
TRANSFORM_BASE_DAMAGE | Indicator if there is any Transofrmer base damage |
LUMINAIRE_DAMAGE | Indicator if there is any luminaire damage |
inspNEED_FURTHER_INSPECT | Indicator if further inspection is needed, associated with the inspection record |
INSPECTION_COMMENTS | Catch all for comments about inspection |
INSPECTION_DATE | Date the inspection occurred |
inspMAINTENANCE_NEEDED | Indicator if maintenance is needed, associated with the inspection record |
MAINTENANCE_COMPLETED_DATE | Maintenance completed date |
Image_Attach_Inv | Link to view inventory attachments |
Image_Attach_Insp | Link to view inspection attachments |
JURISDICTION | Type of jurisdiction to which the section of the route belongs. (C) County. (F) Federal. (M) Municipal. (P) Private. (S) State. (T) Township. (X) Unknown. |
DIVIDED_HWY | Indicates whether a roadway section is part of a divided highway |
URBAN_AREA_CODE | U.S. Census Urban Area Code associated with the section of roadway |
BASE_TYPE | Base type on the right side of the roadway. (F) Crack and Seat. (H) Rubblize and Roll. (I) Aggregate Base 304 or Traffic Compacted. (K) Water Bound Macadam. (L) Bituminous Concrete Mix or Penetration Macadam. (N) Plain Concrete. (P) Reinforced Concrete. (R) Brick – Flexible. (T) Brick – Rigid. |
FUNCTIONAL_CLASS | Definition of roadway classes for the FHWA approved Functional Class system. This is based upon assignment of roads into systems according to the character of service they provide in relation to the total road network. (01) Interstate. (02)Other Freeway and Expressway. (03) Principal Arterial. (04) Minor Arterial. (05) Major Collector. (06) Minor Collector. (7) Local. |
HPMS_SAMPLE_ID | Identifier associated with the Highway Performance Management System (HPMS) sample sections. HPMS is a system used by FHWA to collect roadway data from each state to facilitate consistent reporting on the condition and performance of the nation's highways. |
LANES | Number of lanes in both directions carrying through traffic |
MAINTENANCE_AUTHORITY | Entity who maintains roadway section. (1) State Highway Agency. (2) County Highway Agency. (3) Town or Township Highway Agency. (4) City or Municipal Highway Agency. (11) State Park, Forest, or Reservation Agency. (12) Local Park, Forest, or Reservation Agency. (21) Other State Agency. (25) Other Local Agency. (26) Private (other than Railroad). (27) Railroad. (31) State Toll Authority. (32) Local Toll Authority. (40) Other Public Instrumentality (e.g., Airport, School, University). (50) Indian Tribe Nation. (60) Other Federal Agency. (62) Bureau of Indian Affairs. (63) Bureau of Fish and Wildlife. (64) U.S. Forest Service. (66) National Park Service. (67) Tennessee Valley Authority. (68) Bureau of Land Management. (69) Bureau of Reclamation. (70) Corps of Engineers. (72) Air Force. (73) Navy/Marines. (74) Army. (80) Other. |
NHS | Code indicating the type of NHS Route. (N) National Highway System (regular). (H) Congressional Corridor. (S) Strahnet. (C) Strahnet Connector. (2) Major Airport. (3) Major Port Facility. (4) Major Amtrak Facility. (5) Major Rail/Truck Terminal. (6) Major intercity Bus Terminal. (7) Major Public Transit Terminal. (8) Major Pipeline Terminal. (9) Major Ferry Terminal. |
PRIORITY_SYSTEM | Priority System code associated with the section of the roadway. (G) General. (P) Priority System. (U) Urban. |
SURFACE_TYPE | Surface type on the right side of the roadway. (B) Brick. (D) Reinforced Concrete. (E) Plain Concrete. (G) Dense Graded Asphaltic Concrete. (I) Seal Coat on Penetration Macadam or Water bound Macadam. (K) Open Graded Bituminous. (L) Surface Seal with cover. (S) Wood. (T) Steel Plate. (Z) Right of Way Only. |
SURFACE_WIDTH | Surface width on the right side of the roadway |
ESAL_TOTAL | Measure of total damage to road in speed zone. ESAL stands for Equivalent Single Axel Load which is a concept developed from data collected at the American Association of State Highway Officials (AASHO) Road Test to establish a damage relationship for com |
AADT_PASSENGER | Annual Average Daily Traffic for passenger type vehicles |
AADT_TOTAL | Total Annual Average Daily Traffic |
AADT_BC_TRUCK | Annual Average Daily Traffic for type BC trucks. (B=Buses C= Commercial Trucks) |
PAVE_TYPE | Type of Pavement |
PCR_YEAR | Year in which conditions of pavements on road were last collected and processed by the pavement engineering group |
ROADWAY_WIDTH_NBR | The entire width of the roadway, including all driving lanes and shoulders. This number could include some gravel shoulders. Does not include medians |