Sign Inventory
ODOT's inventory of roadway signs.
- Published by
- ODOT Office of Highway Maintenance
- Source
- Ohio Department of Transportation TIMS
- Original data
- tims.dot.state.oh.us
- 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: 104 fields.
| Field | Description |
|---|---|
STATUS signInv_STATUS | The status of a sign |
INSTALLATION_DATE signInv_INSTALLATION_DATE | When the sign was installed on the support |
signInv_PID | Project ID of sign installation |
signInv_END_CONSTRUCTION_DATE | End construction date of PID related to Sign |
signInv_LET_PLANS_URL | URL to project plans for PID reltated to Sign |
signInv_MAINTAIN_RESPONSIBLE | Maintenance responsibility code of Sign |
SIGN_FILE_NUMBER | Unique Sign Identifier |
OLD_SIGN_FILE_ID | Unique Sign Identifier from legacy file |
SIGN_OWNER | The owner of a sign |
SIGN_CATEGORY | Category of sign from SDMM Manual |
SIGN_CODE | MUTCD code of the sign |
SIGN_TEXT | Addition text on the sign |
MOUNT_POSITION | Is the sign on the end frame/end pole or overhead on the span/cantilever |
TRAVEL_DIRECTION | Direction of Travel that the sign is meant for |
BLANK_MATERIAL | Blank Material of sign |
SIGN_WIDTH_INCHES | Width of Sign |
SIGN_HEIGHT_INCHES | Height of Sign |
SIGN_AREA_SQFT | Calculate this value from "Width" and "Height" |
SIGN_BEACON | Sign Beacon Present on Sign |
EXTERNAL_LIGHTING | External Lighting Present on sign |
INTERNAL_LIGHTING | Internal Lighting Present on sign |
BLANKOUT | Blank-Out Present on sign |
LED_ENHANCED | LED-Enhanced Present sign |
VARIABLE_MESSAGE | Variable Message Present Message Variable |
HINGED | Field indicating if sign is hinged |
EMS_EIMS_NUMBER | EMS Number from EIMS |
SIGN_REFLECT_MEASURE | Measurement of Sign Reflectivity |
SIGN_REFLECT_MEASUR_DT | Date of Sign Reflectivity Measurement |
FREEWAY_SIGN | Sign is on a freeway (NLFID is Access Control 1) |
SIGN_INV_COMMENTS | Free Text Comment about sign |
NLFID | Calculated as described in NLFID Description Document. |
CRS | Concatenate Conty_CD+Route_NBR+CTL_Begin_NBR (ALL-30-10.4) |
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. |
STREET_NAME | Street name. Ex: E Main St |
CTL_BEGIN_NBR | County True Log Begin Number |
STL_BEGIN_NBR | State True Log Begin Number |
LATITUDE_DD_BEGIN | Latitude of Support |
LONGITUDE_DD_BEGIN | Longitude of Support - value must be negative |
PERP_DATE | Date of current LRS |
SupInvStatus supInv_STATUS | Status of Support - Proposed, Active, Inactive, Retired |
SupInvInstallation_Date supInv_INSTALLATION_DATE | Date Support was installed |
supInv_PID | Project ID of the support installation |
supInv_END_CONSTRUCTION_DATE | End construction date of PID related to Support |
supInv_LET_PLANS_URL | URL to project plans for PID related to Support |
supInv_MAINTAIN_RESPONSIBLE | Maintenance responsibility code of Support |
INTERSECTION_ID | ID of intersection related to sign |
CROSS_ROUTE_LEG_ID | Cross Route ID related to the instersection where the sign is located |
SUPPORT_FILE_NUMBER | Unique Identifier of Support |
OLD_SUPPORT_ID | Unique Identifier of support in legacy system |
SUPPORT_OWNER | Owner of the support |
LOCATION_DESCRIPTION | Location description for Sign Support |
PROJECT_NAME | Project name for sign support |
PROJECT_NUMBER | project number of support |
ROUTE_DESIGNATION | Type of route support is on. Used to help identify NLFID. |
SUPPORT_CATEGORY | Category of Sign Support |
SUPPORT_STYLE | Generic Style of support |
SUPPORT_TYPE | Type of support |
DESIGN_NUMBER | Design number according to SCD drawing |
SUPPORT_SIZE | Ground Mounted Signs |
NUM_OF_SUPPORTS | Number of supports that touch the ground |
NUM_OF_SIGNS | Number of signs that the support has |
BRIDGE_MOUNTED | Yes/No if support in mounted to/on a bridge |
MEDIAN_WALL_PLATES | Yes/No if support has a median wall plate |
BREAKAWAY_MECHANISM | Yes/No if support has a breakaway mechanism |
FLANGE_TYPE | Flange type of support |
REFLECTOR_STRIP | Yes/No if support has a reflective strip |
OVERHEAD_SPAN_LENGTH | Length of the Overhead span of support |
ATTACHMENTS | Attatchments |
ATTACHMENT_COMMENTS | Attachments Comments |
PAINTED | Painted Status |
SIGN_SUPPORT_REPLACE | Sign Support replacement |
REPLACEMENT_DATE | Date of Replacement |
REPLACEMENT_PID | Project ID of Replacement |
ACCESS_CONTROL | The degree of access control for a given section of the road |
PATH_WEB_VIEWER | Link to the Path Web Viewer |
MAINTAIN_RECOMMEND | Maintenance Recommended |
INSPECTION_DUE | Date the next inspection is due |
SUPPORT_INV_COMMENTS | Free text comment field about the inventory |
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 |
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_SupInv Image_Attach_supInv | Sign Support Inventory image attachments |
Image_Attach_supInv Image_Attach_supInsp |