Underdrain Outlet Inventory

Outlets where ODOT's roadway underdrains discharge — the pipe ends that let water out of the drainage layer beneath the pavement.

Published by: ODOT Office of Hydraulic 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.

From the publisher

ODOT's inventory of underdrain outlets. Update frequency: Daily. For more information, visit: www.dot.state.oh.us/Divisions/Engineering/Pavement

Fields

What each record holds, as the publisher describes it: 52 fields.

Field	Description
NLFID	Primary key field that allows ODOT’s graphic roadway network geometric segments to be linked to business data attributes
CRS	Concatenation of County Code + Route Number + CTL_Begin, created for use by field crew
ODOT_DISTRICT	From 1-12 plus Central Office – the counties are grouped into districts in Ohio for ease of maintenance and funding
COUNTY	County in which the underdrain is located
COUNTY_CD	Code of the county in which the underdrain is located
ROUTE_TYPE	Two letter code indicating the basic transportation grouping or system that the route belongs to - third component of the NLFID
ROUTE_NBR	Route number associated with section of route
ROUTE_SUFFIX	Single letter used with the route number in local and municipal systems to guarantee uniqueness
CTL_BEGIN_NBR	Logpoint County Begin Number – the location within the county where the route begins
STL_BEGIN_NBR	Beginning State Log Point of section of route
LATITUDE_DD_BEGIN	Code in decimal degrees to six decimal places, indicating the latitude coordinate of the location of the underdrain
LONGITUDE_DD_BEGIN	Code in decimal degrees to six decimal places, indicating the longitude coordinate of the location of the underdrain
PERP_DATE	Road inventory perpetuation date
STATUS	Code indication status of the underdrain outlet: A - Active, R - Retired
INSTALLATION_DATE	Date the underdrain outlet was installed
END_CONSTRUCTION_DATE	Underdrain outlet end construction date
UFN	Underdrain File Number
MAINTAIN_RESPONSIBLE	CMM Inventory Item 10 - Agency type who is responsible for the underdrain maintenance/replacement; S - State Department of Transportation, C - County Agency, M - City, T - Township, V - Village, N - ODNR, O - Other
PID	Project ID (PID) from Ellis
OUTLET_LOCATION	Underdrain Outlet Location
OUTLET_PIPE_TREATMENT	Underdrain Outlet Treatment
OUTLET_PIPE_MATERIAL	Underdrain Outlet Pipe Material
INVENTORY_COMMENTS	A comments section is provided for any comments pertaining to inventory of the underdrain
NUMBER_OF_OUTLETS	The number of outlets at the inventory location
OUTLET_CONDITION	Underdrain Outlet Condition
MARKER_CONDITION	Condition of the underdrain outlet marker or Unmarked
ANIMAL_GUARD	Status of animal guard: 'Damaged', 'Missing', or 'Present'
MAINTENANCE	Maintenance Needed' or 'None Required'
INSPECTION_COMMENTS	Comments pertaining to the inspection
INSPECTION_DATE	Date the inspection was completed
JURISDICTION	One-letter code indicating the primary legal authority of the speed zone- one component of the NLFID
DIVIDED_HWY	Indicates whether a roadway section is part of a divided highway
ACCESS_CONTROL	Degree of access control for a given section of the road
URBAN_AREA_CODE	U.S. Census Urban Area Code associated with the section of roadway
BASE_TYPE	Code indicating type of base material on roadway segment associated with the underdrain, please reference Roadway Infromation manual
FUNCTIONAL_CLASS	The organization of roadways into a hierarchy based on the character of service provided. Typical classifications include arterial, local, and collector roadways.
HPMS_SAMPLE_ID	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; For code descriptions, please refer to the Roadway Information Manual
NHS	Indicates if the School Zone is included in the National Highway System, a federally designated network of roads, most of which already exist, that are eligible for priority federal aid funding; includes the Interstate system and major State highways
PRIORITY_SYSTEM	Priority System code associated with the section of the roadway
SURFACE_TYPE	Type of road surface
SURFACE_WIDTH	The surface width on the right side of the roadway traveling in the cardinal direction. This number indicates only the width of the driving lanes right of the centerline
ESAL_TOTAL	Measure of total damage to road in speed zone. ESAL stands for Equivalend 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	Average Annual Daily Passenger Vehicle Traffic (Does not include trucks)
AADT_TOTAL	Average number of vehicles that pass over point on a daily basis (Includes cars and trucks)
AADT_BC_TRUCK	Average Annual Truck Traffic (Includes all trucks single units and combination units)
PAVE_TYPE	Type of Pavement
PCR_YEAR	Year in which conditions of pavements on road in speed zone 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
Image_Attach_Inv	Link to photos taken at time of inventory
Image_Attach_Insp	Link to photos taken at time of inspection

More from Ohio Department of Transportation TIMS

Every Ohio data set