Retaining Wall Inventory
ODOT's inventory of retaining walls.
- Published by
- ODOT Office of Geotechnical Engineering
- Source
- Ohio Department of Transportation TIMS
- Original data
- tims.dot.state.oh.us
- On the map
- Lines
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: 83 fields.
| Field | Description |
|---|---|
NLFID | Unique Identifier of the route asset is located on |
CRS | County, Route and County Milepost asset is located on |
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 True Log Begin Number |
CTL_END_NBR | County True Log End Number |
STL_BEGIN_NBR | State True Log Begin Number |
STL_END_NBR | State True Log End Number |
LATITUDE_DD_BEGIN | Latitude of wall start point |
LATITUDE_DD_END | Latitude of wall end point |
LONGITUDE_DD_BEGIN | Longitude of wall start point |
LONGITUDE_DD_END | Longitude of wall end point |
PERP_DATE PERP_date | Date of LRS asset is located against |
STATUS | Status of Wall (A = active) |
INSTALLATION_DATE INSTALLATION_date | Date the wall was installed |
LET_PLANS_URL | Plan Sheets |
PID | Project ID of the project the wall was built |
MAINTAIN_RESPONSIBLE | Agency responsible for maintenance of the Wall |
RETAINING_WALL_FILENUM | Unique Identifier of Retaining Wall |
SECTION_ID | Unique Identifier of section that makes up a retaining wall |
ABOVE_BELOW_ROAD | Is the retaining wall above or below the roadway? |
LOCATION_DESCRIPTION | Text Description of the Wall Location (for example: Middle wall in the 3 tiered retaining wall system) |
ACCESS_CONSTRAINTS | Description of physical constraints limiting access to the retaining wall (For example: Traffic, Steep slope) |
ADJACENT_FEATURE_ABOVE | Text field to describe what is above the retaining wall (For example: Road, Creek, Sidewalk) |
ADJACENT_FEATURE_BELOW | Text field to describe what is below the retaining wall (For example: Road, Creek, Sidewalk) |
PROJECT_NAME | Name of Original Project Construction |
STATE_PROJECT_NUMBER | State Project Number |
WALL_NAME | If Present, the name of the wall as it is referred to in plans |
WALL_TYPE | Construction Method for the Wall |
WALL_SUPPLIER | Who supplied the wall |
WALL_FUNCTION | Purpose and use of the Wall |
WALL_FACE_MATERIAL | Material that is used as the wall facing |
MAX_EXPOSED_WALL_HT | Maximum height of wall exposed above ground. |
WALL_SECTION_LENGTH | Length of wall measured in feet. |
WALL_FACE_SLOPE | Is the exposed face vertical or sloped? |
UPSLOPE_ANGLE | Is the backfill behind the wall flat or sloped? |
DOWNSLOPE_ANGLE | Is the backfill in front of the wall flat or sloped? |
FOUNDATION_TYPE | Type of foundation |
FOUNDATION_DEPTH | Depth of foundation |
WALL_EMBEDMENT_DEPTH | Depth of Subsurface Wall Features |
MAX_TOTAL_WALL_HEIGHT | Exposed wall weight + wall embedment depth. |
WALL_HEIGHT_ABOVE_SOIL | The stick up height of the wall above the retained backfill. |
BRIDGE_CULVERT_ASSOC | Field to determine if wall is associated with a bridge or culvert |
BRIDGE_CULVERT_REF | Text field to input CFN and/or SFN |
WALL_DRAINAGE | Indicator if wall drainage exists |
DRAINAGE_DESCRIPTION | Description if WALL_DRAINAGE is 'Y' |
INVENTORY_COMMENTS | Text field for general comments about Retaining Wall |
NEXT_INSPECTION_DUE | This field is used to display when the next inspection is due |
DEFORMATION_PRESENT | Is the wall bulging, leaning, etc? |
DAMAGE_PRESENT | Does the wall have significant visible damage? |
DRAINAGE_OUTLETS_OPER | Are there drainage outlets visible? If so, can water be seen coming from them? |
DRAINAGE_CHANNELS_OPER | Are there drainage channels visible? If so, are they capturing water? |
OVERALL_WALL_CONDITION | Condition of the wall |
CONDITION_DESCRIPTION | Comments about the wall |
REC_ENGINEER_INSP | Indicator if inspector believes the wall needs inspected by an engineer |
MAINT_REPAIR_MOD | Inspector records comments about any type of changes made to the wall |
INSPECTOR | The name or initials of the person who inspected the wall |
INSPECTION_date | Date Wall is inspected |
NEEDS_MAINTENANCE | Indicator if inspector believes the wall needs maintenance |
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 |
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 images attached to inspection record |
Image_Attach_Insp | Link to images attached to inspection record |