ODOT-Maintained Bridges by HUC-12 Subwatershed

transcript.md

↑ Contents

State Planner chat · https://stateplanner.com

State: Ohio (OH)
Started: November 4, 2026, 3:16 PM UTC
Runtime: 1 min 53 sec
Status: completed

Prompt

Ohio HUC-12 Watersheds: Which Subwatersheds Have the Most State Bridges?

Model: Anthropic: Claude Opus 5.5 (anthropic/claude-opus-5.5, via openrouter)

Response

ODOT-maintained bridges by HUC-12 subwatershed

I took "state bridges" to mean bridges whose major maintenance falls to the state (ODOT bridge inventory code maint_resp_cd = '01'). That's 14,317 structures. Each bridge point is placed in the one NRCS HUC-12 subwatershed it falls in, and 14,311 of them landed in one. The other 6 sit just outside the subwatershed outlines.

ODOT-Maintained Bridges by HUC-12 Subwatershed

How to read the map: each of Ohio's 1,554 subwatersheds is shaded by how many state bridges it holds:

dark red: 50 or more
red: 20–49
orange: 10–19
tan: 1–9
pale grey: none

Click a subwatershed to see its name, HUC-12 code, bridge count, area and bridges per 100 km².

Top 20 subwatersheds by number of ODOT-maintained bridges

Rank	Subwatershed (HUC-12)	Bridges	Area (km²)	Per 100 km²
1	Kian Run–Scioto River (050600012302)	122	76.4	159.7
2	City of Cleveland–Cuyahoga River (041100020605)	96	61.0	157.4
3	Mason Run–Big Walnut Cr. (050600011505)	87	92.3	94.3
4	Town of Oakwood–Great Miami River (050800020105)	82	68.6	119.6
5	Town of Twinsburg–Tinkers Creek (041100020504)	78	143.7	54.3
6	City of Akron–Little Cuyahoga River (041100020304)	73	84.4	86.5
7	Bliss Run–Alum Creek (050600011602)	69	137.1	50.3
8	Cahoon Creek–Frontal Lake Erie (041100010204)	68	96.8	70.3
9	Griswold Creek–Chagrin River (041100030402)	68	198.0	34.3
10	Big Creek (041100020603)	64	96.7	66.2
11	Portage Lakes–Tuscarawas River (050400010105)	63	95.4	66.0
12	Little Squaw Creek–Mahoning River (050301030705)	60	67.7	88.7
13	Mouth Olentangy River (050600011103)	58	82.9	70.0
14	Congress Run–Mill Creek (050902030104)	57	77.6	73.5
15	West Branch Nimishillen Creek (050400010503)	54	120.9	44.7
16	Rocky River (041100010203)	53	65.6	80.8
17	Poplar Creek–Great Miami River (050800012005)	53	141.0	37.6
18	Dry Run–Scioto River (050600011205)	52	63.8	81.5
19	Headwaters West Fork Duck Creek (050302010901)	51	193.4	26.4
20	Town of Newport–Ohio River (050902030201)	51	43.6	117.1

What the map shows

The subwatersheds with the most state bridges are where interstates and freeway interchanges are densest. They include the Scioto and Olentangy through central Columbus and the Cuyahoga and Big Creek in Cleveland. Others are the Great Miami near Dayton, the Little Cuyahoga in Akron, Mill Creek in Cincinnati, the Mahoning in Youngstown and Nimishillen Creek in Canton. Kian Run–Scioto River has the most, with 122 bridges, about 160 per 100 km².
Statewide, a subwatershed has 7 state bridges at the median and 9.2 on average. Only 23 have 50 or more. 960 have 1–9, and 79 have none.
Headwaters West Fork Duck Creek (rank 19) is the one largely rural subwatershed in the top 20. It has a high count but a low density (26 per 100 km²).
Town of Newport–Ohio River crosses into Kentucky. Its count includes only bridges in ODOT's inventory.

Notes and caveats

Counts come from ODOT's TIMS Bridge Inventory, which ODOT updates daily. It includes structures shorter than the 20-foot NBI minimum, so totals are higher than an NBI-only count would be.
A bridge is counted where its inventory point sits. That point is not necessarily the stream it crosses, so some bridges counted here are over roads or railroads, not water.
Other ways to define it: by route type, counting bridges carrying a state-system route (rte_on_brg_cd = '10', about 13,000), or limiting to bridges over waterways only (type_serv2_cd 5–9). Either can be rerun the same way.

Exploratory Queries

Query 1 — See how bridge maintenance responsibility is coded to define "state bridges".

   SELECT maint_resp_cd,
          count(*) n,
          count(*) FILTER (
              WHERE retire_reason_cd IS NOT NULL
          ) retired,
          count(*) FILTER (
              WHERE rte_on_brg_cd = '10'
          ) state_rte
     FROM oh_bridge_inventory
 GROUP BY 1
 ORDER BY 2 DESC
    LIMIT 12

maint_resp_cd	n	retired	state_rte
02	25798	25798	6
01	14317	14317	12903
04	2996	2996	22
27	832	832	4
31	531	531	38
	258	258	3
26	236	236	36
11	187	187	3
12	139	139	1
25	61	61	4
03	27	27	1
21	11	11	0

data/turn-1-query-1.csv

Query 2 — Count ODOT-maintained bridges in each HUC-12 subwatershed and rank them.

     WITH b AS (
             SELECT DISTINCT ON (b.objectid) b.objectid,
                    h.huc12
               FROM oh_bridge_inventory b
               JOIN oh_nrcs_huc_12 h ON ST_Intersects(h.geom, b.geom)
              WHERE b.maint_resp_cd = '01'
           ORDER BY b.objectid,
                    h.huc12
          )
   SELECT h.huc12,
          h.name,
          h.states,
          round(h.areasqkm::numeric, 1) km2,
          count(b.*) n,
          round((count(b.*) * 100.0 / h.areasqkm)::numeric, 1) per100km2,
          (
             SELECT count(*)
               FROM b
          ) total_assigned,
          (
             SELECT count(*)
               FROM oh_bridge_inventory
              WHERE maint_resp_cd = '01'
          ) total
     FROM oh_nrcs_huc_12 h
LEFT JOIN b ON b.huc12 = h.huc12
 GROUP BY h.huc12,
          h.name,
          h.states,
          h.areasqkm
 ORDER BY n DESC
    LIMIT 20

huc12	name	states	km2	n	per100km2	total_assigned	total
050600012302	Kian Run-Scioto River	OH	76.4	122	159.7	14311	14317
041100020605	City of Cleveland-Cuyahoga River	OH	61.0	96	157.4	14311	14317
050600011505	Mason Run-Big Walnut Cr.	OH	92.3	87	94.3	14311	14317
050800020105	Town of Oakwood-Great Miami River	OH	68.6	82	119.6	14311	14317
041100020504	Town of Twinsburg-Tinkers Creek	OH	143.7	78	54.3	14311	14317
041100020304	City of Akron-Little Cuyahoga River	OH	84.4	73	86.5	14311	14317
050600011602	Bliss Run-Alum Creek	OH	137.1	69	50.3	14311	14317
041100010204	Cahoon Creek-Frontal Lake Erie	OH	96.8	68	70.3	14311	14317
041100030402	Griswold Creek-Chagrin River	OH	198.0	68	34.3	14311	14317
041100020603	Big Creek	OH	96.7	64	66.2	14311	14317
050400010105	Portage Lakes-Tuscarawas River	OH	95.4	63	66.0	14311	14317
050301030705	Little Squaw Creek-Mahoning River	OH	67.7	60	88.7	14311	14317
050600011103	Mouth Olentangy River	OH	82.9	58	70.0	14311	14317
050902030104	Congress Run-Mill Creek	OH	77.6	57	73.5	14311	14317
050400010503	West Branch Nimishillen Creek	OH	120.9	54	44.7	14311	14317
041100010203	Rocky River	OH	65.6	53	80.8	14311	14317
050800012005	Poplar Creek-Great Miami River	OH	141.0	53	37.6	14311	14317
050600011205	Dry Run-Scioto River	OH	63.8	52	81.5	14311	14317
050302010901	Headwaters West Fork Duck Creek	OH	193.4	51	26.4	14311	14317
050902030201	Town of Newport-Ohio River	KY,OH	43.6	51	117.1	14311	14317

data/turn-1-query-2.csv

Query 3 — Summarize the distribution of state bridge counts across subwatersheds for the map classes.

     WITH b AS (
             SELECT DISTINCT ON (b.objectid) b.objectid,
                    h.huc12
               FROM oh_bridge_inventory b
               JOIN oh_nrcs_huc_12 h ON ST_Intersects(h.geom, b.geom)
              WHERE b.maint_resp_cd = '01'
           ORDER BY b.objectid,
                    h.huc12
          ),
          c AS (
             SELECT h.huc12,
                    count(b.objectid) n
               FROM oh_nrcs_huc_12 h
          LEFT JOIN b USING (huc12)
           GROUP BY h.huc12
          )
   SELECT count(*) hucs,
          count(*) FILTER (
              WHERE n = 0
          ) zero,
          percentile_cont(0.5) WITHIN GROUP (
           ORDER BY n
          ) med,
          avg(n)::numeric(6, 1) mean,
          count(*) FILTER (
              WHERE n >= 50
          ) ge50,
          count(*) FILTER (
              WHERE n BETWEEN 20 AND 49
          ) b20_49,
          count(*) FILTER (
              WHERE n BETWEEN 10 AND 19
          ) b10_19,
          count(*) FILTER (
              WHERE n BETWEEN 1 AND 9
          ) b1_9
     FROM c

hucs	zero	med	mean	ge50	b20_49	b10_19	b1_9
1554	79	7	9.2	23	122	370	960

data/turn-1-query-3.csv

Map Layer Queries

Subwatersheds by ODOT-maintained bridge count — colored by "cls": 50–122 bridges (23) (#7f0000), 20–49 bridges (122) (#d7301f), 10–19 bridges (370) (#fc8d59), 1–9 bridges (960) (#fdd49e), None (79) (#f7f7f7)

     WITH b AS (
             SELECT DISTINCT ON (b.objectid) b.objectid,
                    h.huc12
               FROM oh_bridge_inventory b
               JOIN oh_nrcs_huc_12 h ON ST_Intersects(h.geom, b.geom)
              WHERE b.maint_resp_cd = '01'
           ORDER BY b.objectid,
                    h.huc12
          ),
          c AS (
             SELECT huc12,
                    count(*) n
               FROM b
           GROUP BY huc12
          )
   SELECT h.geom,
          h.name AS "Subwatershed",
          h.huc12 AS "HUC-12",
          COALESCE(c.n, 0) AS "State bridges",
          round(h.areasqkm::numeric, 1) AS "Area(km²)",
          round((COALESCE(c.n, 0) * 100.0 / h.areasqkm)::numeric, 1) AS "Bridges per 100 km²",
          CASE
                    WHEN COALESCE(c.n, 0) >= 50 THEN '50+'
                    WHEN c.n >= 20 THEN '20-49'
                    WHEN c.n >= 10 THEN '10-19'
                    WHEN c.n >= 1 THEN '1-9'
                    ELSE '0'
          END AS cls
     FROM oh_nrcs_huc_12 h
LEFT JOIN c USING (huc12)

Picture: maps/turn-1-state-bridges-huc12.png

Used Data Sets

oh_bridge_inventory — last synced 2026-11-04 · 45,400 rows
oh_nrcs_huc_12 — last synced 2026-09-27 · 1,554 rows

provenance/oh_bridge_inventory.md

↑ Contents

Provenance: `oh_bridge_inventory`

This file describes how the rows in PostgreSQL table oh_bridge_inventory were obtained from an external source: where they were fetched and how fields were renamed and typed. Field meanings are in the mapping table below.

Identity

Table: oh_bridge_inventory
Family: TIMS
Display name: Bridge Inventory
Source URL: https://tims.dot.state.oh.us/ags/rest/services/Assets/Bridge_Inventory/MapServer/0
Geometry (source / stored): esriGeometryPoint / geometry(Point, 4326)
Update cycle: Daily
OID column: objectid

Pipeline (TIMS family)

Ohio DOT TIMS publishes this layer on the TIMS data page. The catalog behind that page is GET https://tims.dot.state.oh.us/tims/api/glossary. Each entry names a MapServer layer URL.

Data is fetched as GeoJSON from that layer's REST query endpoint (where=1=1, outFields=*, outSR=4326, f=geojson), paginated with resultOffset / resultRecordCount. GeoJSON was chosen over the portal's CSV/SHP/GDB/KMZ exports because it keeps full attribute names, keeps geometry, and loads into PostGIS via ST_GeomFromGeoJSON.

Esri field names become lowercase snake_case PostgreSQL columns (non [a-z0-9_] → _). Dates stored as Esri epoch-milliseconds become timestamptz. Geometry is ST_SetSRID(ST_GeomFromGeoJSON(…), 4326), wrapped in ST_Multi when the table's stored type is Multi*. Esri shape-area / shape-length system fields are dropped.

The same MapServer query is used whenever the table is refreshed.

Field → column mapping

Source field	Column	Esri type	Description
OBJECTID	`objectid`	esriFieldTypeOID
SFN	`sfn`	esriFieldTypeString	The Structure File Number is unique for each bridge within the state.
STR_LOC_CARRIED	`str_loc_carried`	esriFieldTypeString	The facility being carried by the structure. In all situations this item describes the use "on" the structure.
RTE_ON_BRG_CD	`rte_on_brg_cd`	esriFieldTypeString	10- State (ODOT, Toll free). 11- ODNR. 12- State (Other, Toll free.) 20- Federal. 30- Toll Rd (State). 31- Toll Rd (Private). 40- County. 41- Municipal. 42- Township. 43- Park District. 44- Conservancy District. 99- Non highway. 00- Other
NLFID	`nlfid`	esriFieldTypeString
CTL_BEGIN_NBR	`ctl_begin_nbr`	esriFieldTypeDouble
COUNTY_CD	`county_cd`	esriFieldTypeString	Counties shall be identified using the Federal Information Processing Standards (FIPS) codes given in the current version of the Census of Population and Housing – Geographic Identification Code Scheme.
DISTRICT	`district`	esriFieldTypeString	The highway agency district in which the bridge is located shall be represented by a two 2 digit code. ( 01 - 12)
INVENT_SPCL_DSGT	`invent_spcl_dsgt`	esriFieldTypeString	Special designation
FIPS_CD	`fips_cd`	esriFieldTypeString	Cities, towns, townships, villages, and other census-designated places identified using the FIPS codes given in the current version of the Census of Population and Housing - Geographic Identification Code Scheme.
INVENT_ON_UND_CD	`invent_on_und_cd`	esriFieldTypeString	1 - Route carried "ON" the structure. 2 - Single route goes "UNDER" the sturcture. A-Z - Multiple routes go "UNDER" the structure. 99 - Miscoded data.
INVENT_HWY_SYS_CD	`invent_hwy_sys_cd`	esriFieldTypeString	1 - Interstate highway. 2 - U.S. numbered highway. 3 - State highway. 4 - County highway. 5 - City street. 6 - Federal lands road. 7 - State lands road. 8 - Other.
INVENT_HWY_DSGT_CD	`invent_hwy_dsgt_cd`	esriFieldTypeString	1 - Interstate highway. 2 - U.S. numbered highway. 3 - State highway. 4 - County highway. 5 - City street. 6 - Federal lands road. 7 - State lands road. 8 - Other.
INVENT_DIR_SFX_CD	`invent_dir_sfx_cd`	esriFieldTypeString	0 - N/A. 1 - North. 2 - East. 3 - South. 4 - West.
INVENT_FEAT	`invent_feat`	esriFieldTypeString	Description of the features intersected by the structure.
STR_LOC	`str_loc`	esriFieldTypeString	A narrative description of the bridge location.
LATITUDE_DD	`latitude_dd`	esriFieldTypeDouble	Latitude coordinate on the centerline of the route on the bridge at the end of the rear approach slab or start of the bridge limits traveling in the cardinal direction.
LONGITUDE_DD	`longitude_dd`	esriFieldTypeDouble	Longitude coordinate on the centerline of the route on the bridge at the end of the rear approach slab or start of the bridge limits traveling in the cardinal direction.
BRDR_BRG_STATE	`brdr_brg_state`	esriFieldTypeString	185- Indiana. 214- Kentucky. 265- Michigan. 423- Pennsylvania. 543- West Virginia.
BRDR_BRG_PCT_RESP	`brdr_brg_pct_resp`	esriFieldTypeString	Percentage of total deck area of the existing bridge that the neighboring State is responsible for funding.
BRDR_BRG_SFN	`brdr_brg_sfn`	esriFieldTypeString	The neighboring State’s National Bridge Inventory structure number.
MAIN_STR_MTL_CD	`main_str_mtl_cd`	esriFieldTypeString	Kind of material: 1- Concrete. 2- Concrete contiunuous. 3- Steel. 4- Steel continuous. 5- Prestressed concrete. 6- Prestressed concrete continuous. 7- Wood. 8- Masonry. 9- Aluminum, wrought iron, or cast iron. 0- Other
MAIN_STR_TYPE_CD	`main_str_type_cd`	esriFieldTypeString	01-Slab. 02-Stringer/multi-beam or girder. 03-Girder and floor beam. 04-Tee beam. 05-Box beam multiple. 06-Box beam single. 07-Frame. 08-Orthotropic. 09-Truss deck. 10-Truss thru. 11-Arch deck. 12-Arch thru. See Bridge Inventory Guide for full list.
APPRH_STR_MTL_CD	`apprh_str_mtl_cd`	esriFieldTypeString	Kind of material: 1- Concrete. 2- Concrete contiunuous. 3- Steel. 4- Steel continuous. 5- Prestressed concrete. 6- Prestressed concrete continuous. 7- Wood. 8- Masonry. 9- Aluminum, wrought iron, or cast iron. 0- Other
APPRH_STR_TYPE_CD	`apprh_str_type_cd`	esriFieldTypeString	01-Slab. 02-Stringer/multi-beam or girder. 03-Girder and floor beam. 04-Tee beam. 05-Box beam multiple. 06-Box beam single. 07-Frame. 08-Orthotropic. 09-Truss deck. 10-Truss thru. 11-Arch deck. 12-Arch thru. See Bridge Inventory Guide for full list.
MAIN_SPANS	`main_spans`	esriFieldTypeInteger	The number of spans in the main or major unit.
APPRH_SPANS	`apprh_spans`	esriFieldTypeInteger	Number of spans in the approach spans to the major bridge, or the number of spans of material different from that of the major bridge.
DECK_CD	`deck_cd`	esriFieldTypeString	1- Concrete Cast-in-Place. 2- Concrete Precast Panels. 3- Open Grating. 4- Closed Grating. 5- Steel plate (includes orthotropic). 6- Corrugated steel. 7- Aluminum. 8- Wood or Timber. 9- Other. N- Not applicable
DECK_PROT_EXTL_CD	`deck_prot_extl_cd`	esriFieldTypeString	1- Built-up. 2- Preformed Fabric. 3- Epoxy. 8- Unknown. 9- Other. 0- None. N- Not Applicable.
DECK_PROT_INT_CD	`deck_prot_int_cd`	esriFieldTypeString	1- Epoxy Coated Reinforcing. 2- Galvanized Reinforcing. 3- Other Coated Reinforcing. 4- Cathodic Protection. 6- Polymer Impregnated. 7- Internally Sealed. 8- Unknown. 9- Other. 0- None. N- Not Applicable
WEAR_SURF_DT	`wear_surf_dt`	esriFieldTypeDate	The month, day and year of the most recent wearing surface application (i.e. concrete overlays, bituminous, etc.)
WEARING_SURF_CD	`wearing_surf_cd`	esriFieldTypeString	1 Monolithic Concrete. 2 Integral Concrete. 3 Latex Concrete. 4 Low Slump Concrete. 5 Epoxy Overlay. 6 Bituminous. 7 Wood. 8 Gravel. 0 Other. N- Not Applicable. A- SDC Overlay. B Chip and Seal Overlay. C Micro-silica Modified Concrete Overlay
WEARING_SURF_THCK	`wearing_surf_thck`	esriFieldTypeSingle	Whether the wearing surface is a separate wearing surface material or monolithic concrete, code the total thickness rounded to the nearest inch.
PAINT_DT	`paint_dt`	esriFieldTypeDate	The most recent date the Protective Coating System was applied to the bridge.
YR_BUILT	`yr_built`	esriFieldTypeDate	The day, month and year the bridge was completed. If unknown, code 07/01/1900.
MAJ_RECON_DT	`maj_recon_dt`	esriFieldTypeDate	The date in month, day and year of the most recent major reconstruction (rehabilitation) of the structure.
TYPE_SERV1_CD	`type_serv1_cd`	esriFieldTypeString	1- Highway. 2- Railroad. 3- Pedestrian/bicycle. 4- Highway/railroad. 5- Highway/pedestrian. 6- Overpass, or second level of a multilevel interchange. 7- Third level. 8- Fourth level. 9- Building or plaza. 0- Other
TYPE_SERV2_CD	`type_serv2_cd`	esriFieldTypeString	1- Highway. 2- Railroad. 3- Pedestrian/bicycle. 4- Highway/railroad. 5- Waterway. 6- Highway/waterway. 7- Railroad/waterway. 8- Highway/waterway/railroad. 9- Relief for waterway. 0- Other
LANES_ON	`lanes_on`	esriFieldTypeInteger	Number of lanes being carried by the structure.
LANES_UND	`lanes_und`	esriFieldTypeInteger	Number of lanes being crossed over by the structure.
INVENT_RTE_ADT	`invent_rte_adt`	esriFieldTypeInteger	Average daily traffic volume for the inventory route identified in Item 5.
BYPASS_LEN	`bypass_len`	esriFieldTypeString	The actual length to the nearest kilometer of the detour length. It is the total additional travel for a vehicle which would result from closing of the bridge.
NBIS_LEN_SW	`nbis_len_sw`	esriFieldTypeString	Yes/No. Does this structure meet or exceed the minimum length specified to be designed as a bridge for National Bridge Inspection Standards purposes.
INVENT_NHS_CD	`invent_nhs_cd`	esriFieldTypeString	0- route is NOT on the National Highway System (NHS). 1- route IS on the NHS.
FUNC_CLAS_CD	`func_clas_cd`	esriFieldTypeString	RURAL: 01-Principal Arterial (P.A.) Interstate, 02- P.A. Other, 06-Minor Arterial, 07-Major Collector, 08-Minor Collector, 09-Local. URBAN: 11- P.A. Interstate, 12- P.A. Freeway, 14- P.A. Other, 17-Collector, 19-Local.
DFNS_HWY_DSGT_SW	`dfns_hwy_dsgt_sw`	esriFieldTypeString	0- Not a STRAHNET route. 1- Interstate STRAHNET route. 2- Non-interstate STRAHNET route. 3- STRAHNET connector route.
PARALLEL_STR_CD	`parallel_str_cd`	esriFieldTypeString	R- The right structure of parallel bridges carrying the roadway in the direction of the inventory. L- The left structure of parallel bridges. This structure carries traffic in the opposite direction. N- No parallel structure exists.
DIR_TRAFFIC_CD	`dir_traffic_cd`	esriFieldTypeString	0- Highway traffic not carried. 1- one-way traffic. 2- two-way traffic. 3- One lane bridge for two-way traffic.
TEMP_STR_SW	`temp_str_sw`	esriFieldTypeString	T- Temporary structure or conditions exist.
DSGT_NATL_NETW_SW	`dsgt_natl_netw_sw`	esriFieldTypeString	0- Route is not part of the national network for trucks. 1- Route is part of the national network for trucks.
TOLL_CD	`toll_cd`	esriFieldTypeString	1- Toll bridge. 2 - On toll road. 3 - On free road. 4 - On Interstate toll segment under Secretarial Agreement. 5 - Toll bridge is a segment under Secretarial Agreement.
ROUTINE_RESP_CD	`routine_resp_cd`	esriFieldTypeString	01- State Highway Agency (ODOT). 02- County Highway Agency. 03- Town or Township Highway Agency. 04- City or Municipal Highway Agency. 11- State Park, Forest or Reservation Agency (ODNR). See Bridge Inventory Guide for full list.
ROUTINE_RESP_CD_2	`routine_resp_cd_2`	esriFieldTypeString	01- State Highway Agency (ODOT). 02- County Highway Agency. 03- Town or Township Highway Agency. 04- City or Municipal Highway Agency. 11- State Park, Forest or Reservation Agency (ODNR). See Bridge Inventory Guide for full list.
MAINT_RESP_CD	`maint_resp_cd`	esriFieldTypeString	Agency legally responsible for the major maintenance of the bridge. 01-State. 02-County. 03-Township. 04-Municipal. 31-Turnpike. See Bridge Inventory Guide for full list.
MAINT_RESP_CD_2	`maint_resp_cd_2`	esriFieldTypeString	01- State Highway Agency (ODOT). 02- County Highway Agency. 03- Town or Township Highway Agency. 04- City or Municipal Highway Agency. 11- State Park, Forest or Reservation Agency (ODNR). See Bridge Inventory Guide for full list.
INSP_RESP_CD	`insp_resp_cd`	esriFieldTypeString	01- State Highway Agency (ODOT). 02- County Highway Agency. 03- Town or Township Highway Agency. 04- City or Municipal Highway Agency. 11- State Park, Forest or Reservation Agency (ODNR). See Bridge Inventory Guide for full list.
INSP_RESP_CD_2	`insp_resp_cd_2`	esriFieldTypeString	01- State Highway Agency (ODOT). 02- County Highway Agency. 03- Town or Township Highway Agency. 04- City or Municipal Highway Agency. 11- State Park, Forest or Reservation Agency (ODNR). See Bridge Inventory Guide for full list.
HIST_SGN_CD	`hist_sgn_cd`	esriFieldTypeString	1- Bridge is on the National Register of Historic Places (NRHP). 2- Bridge is eligible for the NRHP. 3- Bridge is on a state or local historic register. 4- Historical significance is not determinable. 5- Bridge is not eligible for the NRHP.
NAV_CONTROL_SW	`nav_control_sw`	esriFieldTypeString	N- Not applicable, no waterway. 0- No navigation control on waterway (permit not required). 1- Navigation control on waterway (bridge permit required).
NAV_VRT_CLR	`nav_vrt_clr`	esriFieldTypeSingle	Clearance that is allowable for navigation purposes, recorded to the nearest foot.
NAV_HORIZ_CLR	`nav_horiz_clr`	esriFieldTypeDouble	Measurement, to the nearest foot, shown on a navigation permit. May be less than the structure allows.
SUBS_FENDERS	`subs_fenders`	esriFieldTypeString	Pier protection features (fenders, dolphins, etc). 1- Not required. 2- In place and functioning. 3- In place, deteriorated condition. 4- In place, design reevaluation suggested. 5- None present but reevaluation suggested
MIN_NAV_VRT_CLR	`min_nav_vrt_clr`	esriFieldTypeSingle	Minimum vertical clearance, rounded to the nearest foot, imposed at the site as measured above a datum that is specified on a navigation permit issued by a control agency. Only for vertical lift bridges in the dropped or closed position.
INSP_DT	`insp_dt`	esriFieldTypeDate	Routine inspection date
DSGT_INSP_FREQ	`dsgt_insp_freq`	esriFieldTypeInteger	Designated frequency of routine inspections.
FRAC_CRIT_INSP_SW	`frac_crit_insp_sw`	esriFieldTypeString	Yes/No. Is fracture critical inspection required.
FRACCRIT_INSP_FREQ	`fraccrit_insp_freq`	esriFieldTypeInteger	Fracture critical inspection frequency.
FRAC_CRIT_INSP_DT	`frac_crit_insp_dt`	esriFieldTypeDate	Fracture critical inspection date.
DIVE_INSP_SW	`dive_insp_sw`	esriFieldTypeString	Yes/No. Is underwater inspection required.
DIVE_INSP_FREQ	`dive_insp_freq`	esriFieldTypeInteger	Underwater inspection frequency.
DIVE_INSP_DT	`dive_insp_dt`	esriFieldTypeDate	Underwater inspection date.
SPCL_INSP_SW	`spcl_insp_sw`	esriFieldTypeString	Yes/No. Is special inspection required.
SPCL_INSP_FREQ	`spcl_insp_freq`	esriFieldTypeInteger	Special inspection frequency.
SPCL_INSP_DT	`spcl_insp_dt`	esriFieldTypeDate	Special inspection date.
SNOOPER_INSP_SW	`snooper_insp_sw`	esriFieldTypeString	Y/N Is snooper inspection required.
DECK_SUMMARY	`deck_summary`	esriFieldTypeString	9-Excellent. 8-Very Good. 7-Good. 6-Satisfactory. 5-Fair. 4-Poor. 3-Serious. 2-Critical.
DECK_WEAR_SURF	`deck_wear_surf`	esriFieldTypeString	Deck wearing surface inspection. See Bridge Inspection Manual.
DECK_EXPN_JOINTS	`deck_expn_joints`	esriFieldTypeString	Deck expansion joint inspection. See Bridge Inspection Manual.
SUPS_SUMMARY	`sups_summary`	esriFieldTypeString	9-Excellent. 8-Very Good. 7-Good. 6-Satisfactory. 5-Fair. 4-Poor. 3-Serious. 2-Critical.
PAINT	`paint`	esriFieldTypeString	Protective coating system inspection. See Bridge Inspection Manual.
SUBS_SUMMARY	`subs_summary`	esriFieldTypeString	9-Excellent. 8-Very Good. 7-Good. 6-Satisfactory. 5-Fair. 4-Poor. 3-Serious. 2-Critical.
CHAN_SUMMARY	`chan_summary`	esriFieldTypeString	9-Excellent. 8-Very Good. 7-Good. 6-Satisfactory. 5-Fair. 4-Poor. 3-Serious. 2-Critical.
SUBS_SCOUR	`subs_scour`	esriFieldTypeString	Scour inspection. See Bridge Inspection Manual.
CULVERT_SUMMARY	`culvert_summary`	esriFieldTypeString	9-Excellent. 8-Very Good. 7-Good. 6-Satisfactory. 5-Fair. 4-Poor. 3-Serious. 2-Critical.
GEN_APPRAISAL	`gen_appraisal`	esriFieldTypeString	The lowest of the Superstructure, Substructure or Supplemental Summary. See Bridge Inspection Manual.
DESIGN_LOAD_CD	`design_load_cd`	esriFieldTypeString	0-Unknown. 1- H 10. 2- H 15. 3- HS 15. 4- H 20. 5- HS 20. 6- HS 20-44 + Mod. 7- Pedestrian. 8- Railroad. 9- HS 25 or greater. A- HL 93. B- Greater than HL93. C-Other.
RAT_OPR_LOAD_FACT	`rat_opr_load_fact`	esriFieldTypeString	This capacity rating, referred to as the operating rating, will result in the absolute maximum permissible load level to which the structure may be subjected for the vehicle type used in the rating.
RAT_INV_LOAD_CD	`rat_inv_load_cd`	esriFieldTypeString	Load rating method used to determine the Inventory Rating (66). See Bridge Inventory Guide for code descriptions.
RAT_INV_LOAD_FACT	`rat_inv_load_fact`	esriFieldTypeString	This capacity rating, referred to as the inventory rating, will result in a load level which can safely utilize an existing structure for an indefinite period of time.
GEN_OPR_STATUS	`gen_opr_status`	esriFieldTypeString	A- Open. B- Open, posting recommended. D- Open, temporary shoring, etc. E- Open, temporary structure in place. G- New structure not yet open. K- Closed. P- Posted for load. R- Posted for other restriction.
BRG_POSTING	`brg_posting`	esriFieldTypeString	4 or less- Posting required. 5- No posting required.
CALC_STR_EVAL	`calc_str_eval`	esriFieldTypeString	N- Not applicable. 9- Superior to desirable criteria. 8- Equal to desirable criteria. 7- Better than minimum criteria. 6- Equal to minimum criteria. 5-Somewhat better than minimum adequacy. See Bridge Inventory Guide for full list.
CALC_DECK_GEOM	`calc_deck_geom`	esriFieldTypeString	N- Not applicable. 9- Superior to desirable criteria. 8- Equal to desirable criteria. 7- Better than minimum criteria. 6- Equal to minimum criteria. 5-Somewhat better than minimum adequacy. See Bridge Inventory Guide for full list.
CALC_UNDC	`calc_undc`	esriFieldTypeString	N- Not applicable. 9- Superior to desirable criteria. 8- Equal to desirable criteria. 7- Better than minimum criteria. 6- Equal to minimum criteria. 5-Somewhat better than minimum adequacy. See Bridge Inventory Guide for full list.
WW_ADEQUACY_CD	`ww_adequacy_cd`	esriFieldTypeString	N- Bridge not over a waterway. 9- Deck and approaches above flood level elevations. 8- Deck above approaches; slight chance of overtopping approaches. See Bridge Inventory Guide for full list.
APPRH_ALGN_CD	`apprh_algn_cd`	esriFieldTypeString	N- Not applicable. 9- Superior to desirable criteria. 8- Equal to desirable criteria. 7- Better than minimum criteria. 6- Equal to minimum criteria. 5-Somewhat better than minimum adequacy. See Bridge Inventory Guide for full list.
SURVEY_RAILING	`survey_railing`	esriFieldTypeString	0 - Inspected feature does not meet current acceptable standards or a safety feature is required and none is provided. 1 - Inspected feature meets current acceptable standards (ODOT). N - Not applicable or a safety feature is not required.
SURVEY_TRANSITION	`survey_transition`	esriFieldTypeString	0 - Inspected feature does not meet current acceptable standards or a safety feature is required and none is provided. 1 - Inspected feature meets current acceptable standards (ODOT). N - Not applicable or a safety feature is not required.
SURVEY_GUARDRAIL	`survey_guardrail`	esriFieldTypeString	0 - Inspected feature does not meet current acceptable standards or a safety feature is required and none is provided. 1 - Inspected feature meets current acceptable standards (ODOT). N - Not applicable or a safety feature is not required.
SURVEY_RAIL_ENDS	`survey_rail_ends`	esriFieldTypeString	0 - Inspected feature does not meet current acceptable standards or a safety feature is required and none is provided. 1 - Inspected feature meets current acceptable standards (ODOT). N - Not applicable or a safety feature is not required.
SCOUR_CRIT_CD	`scour_crit_cd`	esriFieldTypeString	9- Bridge foundations on dry land well above flood water elevations. 8- foundations determined to be stable for the assessed or calculated scour conditions; calculated scour is above top of footing. See Bridge Inventory Guide for full list.
MAX_SPAN_LEN	`max_span_len`	esriFieldTypeDouble	Length of the maximum (longest) span.
OVRL_STR_LEN	`ovrl_str_len`	esriFieldTypeDouble	Total length of the structure measured along the centerline of the roadway.
SIDW_WD_L	`sidw_wd_l`	esriFieldTypeSingle	Width of the left curb or sidewalk. Left/right determined on the basis of the route's cardinal direction.
SIDW_WD_R	`sidw_wd_r`	esriFieldTypeSingle	Width of the right curb or sidewalk. Left/right determined on the basis of the route's cardinal direction.
BRG_RDW_WD	`brg_rdw_wd`	esriFieldTypeDouble	The most restrictive minimum distance between curbs or rails on the structure roadway.
DECK_WD	`deck_wd`	esriFieldTypeDouble	The out-to-out structure width.
APPRH_RDW_WD	`apprh_rdw_wd`	esriFieldTypeInteger	Number to the nearest foot which represents the normal width of the roadway approaching the structure.
MEDIAN_CD	`median_cd`	esriFieldTypeString	0- No median. 1- Open median. 2- Closed median (no barrier). 3- Closed median with non-mountable barriers.
SKEW_DEG	`skew_deg`	esriFieldTypeInteger	Angle produced when the longitudinal members of a bridge are not perpendicular to the substructure; the skew angle is the acute angle between the alignment of the bridge and a line perpendicular to the centerline of the substructure units
FLARED_SW	`flared_sw`	esriFieldTypeString	Whether or not the width of the structure varies. 0- No flare. 1- Yes, flared.
MIN_HORIZ_CLR_C	`min_horiz_clr_c`	esriFieldTypeSingle	Largest available horizontal clearance for the movement of wide loads.
MINVRT_UNDCLR_C	`minvrt_undclr_c`	esriFieldTypeSingle	Minimum Vertical Under Clearance
IMPR_TYP_WORK_CD	`impr_typ_work_cd`	esriFieldTypeString	31- Replacement, substandard capacity. 32- Replacement, relocation of road. 33- Widening without deck rehab. 34- Widening with deck rehab. 35- Rehabilitation, general deterioration. 36- Deck rehabilitation. 37- Deck replacement. 38- Other
IMPR_TYP_MEANS_CD	`impr_typ_means_cd`	esriFieldTypeString	1- By contract. 2- By owner's forces.
IMPR_LNG	`impr_lng`	esriFieldTypeDouble	Length of the bridge portion to be improved.
IMPR_BRG_COST	`impr_brg_cost`	esriFieldTypeInteger	Estimated cost of proposed bridge improvements, only bridge construction costs included. Code represents value in thousands of dollars. 7- $7,000. 56- $56,000. 7451- $7,451,000.
IMPR_RDW_COST	`impr_rdw_cost`	esriFieldTypeInteger	Estimated cost of proposed bridge construction, excluding roadway, right of way, detour demolition, preliminary engineering, etc. Code represents value in thousands of dollars. 7- $7,000. 56- $56,000. 7451- $7,451,000.
IMPR_TOT_PROJ_COST	`impr_tot_proj_cost`	esriFieldTypeInteger	Total project cost, including incidental costs not included in Items 94 and 95. Code represents value in thousands of dollars. 7- $7,000. 56- $56,000. 7451- $7,451,000.
IMPR_COST_EST_YR	`impr_cost_est_yr`	esriFieldTypeInteger	The year that the costs of work estimated in Item #94 – Bridge Improvements Cost, Item #95 – Roadway Improvement Cost, and Item 96 – Total Project Cost were based upon.
FUTURE_ADT	`future_adt`	esriFieldTypeInteger	The forecasted average daily traffic (ADT) for the inventory route identified in NBI Item #5
FUTURE_ADT_YR	`future_adt_yr`	esriFieldTypeInteger	The year represented by the future ADT in Item #114.
DEDICATED_NME	`dedicated_nme`	esriFieldTypeString	The official name (if applicable) of the bridge.
INVENT_PREF_RTE	`invent_pref_rte`	esriFieldTypeString	P- Inventory route is the preferred route in an overlap area. NP-Non preferred route.
MAJOR_BRG_SW	`major_brg_sw`	esriFieldTypeString	Y/N Does structure meet Major Bridge criteria. See Bridge Inventory Guide for criteria.
INVENT_COUNTY	`invent_county`	esriFieldTypeString	County in which the bridge is located
SEISMIC_SUSCEPT_CD	`seismic_suscept_cd`	esriFieldTypeString	1 Unreinforced masonry. 2 Simple span approaches to large truss bridges. 3 Prestressed I. 4 Non-redundant steel pier caps. 5 Multiple column type piers. 6 Centerline of bearing 4” or less to face of abutment. 7 Seated hinges. N Not applicable
GASB_34_SW	`gasb_34_sw`	esriFieldTypeString	Y/N GASB Bridge - All State System Bridges excluding Major Bridge, ODNR, Turnpike, and Non-Highway bridges not maintained by ODOT.
APERTURE_FABR_SW	`aperture_fabr_sw`	esriFieldTypeString	Y/N If the Fabrication Aperture Cards are available for the bridge.
APERTURE_ORIG_SW	`aperture_orig_sw`	esriFieldTypeString	Y/N If the Original Aperture Cards are available for the bridge.
APERTURE_REP_SW	`aperture_rep_sw`	esriFieldTypeString	Y/N If the Repair Aperture Cards are available for the bridge.
ORIG_PROJ_NBR	`orig_proj_nbr`	esriFieldTypeString	The number of the Ohio Project which the structure was originally constructed.
STD_DRW_NBR	`std_drw_nbr`	esriFieldTypeString	The Standard Drawing Number for the bridge superstructure.
MICROFILM_NBR	`microfilm_nbr`	esriFieldTypeString	Any Microfilm Reel Numbers that contain information about the bridge.
REMARKS	`remarks`	esriFieldTypeString	Remarks coded by the ODOT CO.
UTL_ELECTRIC_SW	`utl_electric_sw`	esriFieldTypeString	Y/N Is electric line present.
UTL_GAS_SW	`utl_gas_sw`	esriFieldTypeString	Y/N Is gas line present.
UTL_SEWER_SW	`utl_sewer_sw`	esriFieldTypeString	Y/N Is sewer line present.
NBIS_BRIDGE_LENGTH	`nbis_bridge_length`	esriFieldTypeDouble	Measurement along the centerline of the roadway between under copings of abutments or spring lines of arches, or extreme ends of openings for multiple boxes.
RTE_UND_BRG_CD	`rte_und_brg_cd`	esriFieldTypeString	10- State (ODOT, Toll free). 11- ODNR. 12- State (Other, Toll free.) 20- Federal. 30- Toll Rd (State). 31- Toll Rd (Private). 40- County. 41- Municipal. 42- Township. 43- Park District. 44- Conservancy District. 99- Non highway. 00- Other
LOAD_RAT_PCT	`load_rat_pct`	esriFieldTypeInteger	For bridges carrying highways, the percent of Ohio Legal Roads to the nearest 5%. 065- 65%. 125- 125%
LOAD_RAT_YR	`load_rat_yr`	esriFieldTypeInteger	The date when the structure was last load rated. If the bridge is closed, the year closed.
RATING_SOFT_CD	`rating_soft_cd`	esriFieldTypeString	1- BARS. 2- BRASS. 3- AASHTO BrR (VIRTIS). 4- Testing 5 Finite Element (FE) Program. 6- In House Program/Spreadsheet. 7- Combination. 8- Other program. 9- Manual Calculations. 0- Assigned rating (no calculations were done)
CATWALKS_SW	`catwalks_sw`	esriFieldTypeString	Y/N Is Inspection Access System present on bridge.
RETIRE_REASON_CD	`retire_reason_cd`	esriFieldTypeString	1- Replaced(>= 50% Suff Rating). 2- Replaced(< 50% Suff Rating). 3- Abandoned(not on public route). 4- Collapsed, not replaced. 5- Closed, not replaced. 7- Collapsed and replaced. 0- Other.
REC_ADD_DT	`rec_add_dt`	esriFieldTypeDate	The date when a proposed SFN is made active first time.
MPO_CD	`mpo_cd`	esriFieldTypeString	01- AMATS. 02- BHJTS. 03- Bel-O-Mar. 04- Eastgate. 05- KYOVA. 06- LCATS. 07- MORPC. 08- NOACA. 09- OKI. 10- SCATS. 11- MVRPC. 12- LACRPC. 13- RCRPC. 14- CCSTCC. 15- TMACOG. 16- WWWIPC. 17- ERPC. NN- None. UU- Unknown
TEMP_SUBDECKING_SW	`temp_subdecking_sw`	esriFieldTypeString	Y/N Does temporary sub decking exist.
APPRH_SLAB_SW	`apprh_slab_sw`	esriFieldTypeString	1- Reinforced concrete. 2- Prestressed concrete. 3- None. 4- Unknown.
MEDIAN_TYP1_CD	`median_typ1_cd`	esriFieldTypeString	1- Level median. 2- Raised median. N- None or not present.
MEDIAN_TYP2_CD	`median_typ2_cd`	esriFieldTypeString	1- Steel barrier. 2- Concrete barrier. 3- 32” Deflector (New Jersey). 4- 42” Deflector (New Jersey). 5- 50” Deflector (New Jersey). 6- 32” Deflector (General Motors). 7- 36” Deflector (New Jersey). N- non barrier. 0- Other
MEDIAN_TYP3_CD	`median_typ3_cd`	esriFieldTypeString	1- Open joint. 2- Filled joint. N- No joint.
RAILING_TYP_CD	`railing_typ_cd`	esriFieldTypeString	1- Reinforced Concrete Parapet. 2- Reinforced Concrete and Steel. 3- Reinforced Concrete Safety Curb and Parapet with Aluminum Railing. 4- Reinforced Concrete Post and Steel Panel. See Bridge Inventory Guide for full list.
COMPOSITE_STR_CD	`composite_str_cd`	esriFieldTypeString	N- Non-composite Construction. Y- Composite Construction. X- Not Applicable. U- Unknown
ELAS_STRP_TROU2_SW	`elas_strp_trou2_sw`	esriFieldTypeString	Y/N An elastomeric trough installed as part of the expansion joint system retrofit.
ELAS_STRP_TROU3_SW	`elas_strp_trou3_sw`	esriFieldTypeString	Y/N Is an expansion joint with trough present.
FENCING_SW	`fencing_sw`	esriFieldTypeString	Y/N Is a fence present on the bridge.
GLARE_SCREEN_SW	`glare_screen_sw`	esriFieldTypeString	Y/N Is a glare screen present on the bridge.
NOISE_BARRIER_SW	`noise_barrier_sw`	esriFieldTypeString	Y/N Is a noise barrier present on the bridge.
DECK_AREA	`deck_area`	esriFieldTypeInteger	The Deck Area is a product of the Bridge Deck Width (NBI #52) and Structure Length (NBI #49). In case of culverts, the deck area is product of the Approach Roadway width (NBI #32).
CURB_SIDW_MTL_L	`curb_sidw_mtl_l`	esriFieldTypeString	1- Concrete. 2- Steel. 3- Timber. N- None. 0- Other
CURB_SIDW_MTL_R	`curb_sidw_mtl_r`	esriFieldTypeString	1- Safety Curb (2’ or less width). 2- Sidewalk (greater than 2’ in width). 3- Felloe Guards. 4- Open Grid. 5- Filled Grid. 6- Check Plate. N- None or N/A (RR, Pedestrian, etc). 0- Other
CURB_SIDW_TYP_L	`curb_sidw_typ_l`	esriFieldTypeString	1- Concrete. 2- Steel. 3- Timber. N- None. 0- Other
CURB_SIDW_TYP_R	`curb_sidw_typ_r`	esriFieldTypeString	1- Safety Curb (2’ or less width). 2- Sidewalk (greater than 2’ in width). 3- Felloe Guards. 4- Open Grid. 5- Filled Grid. 6- Check Plate. N- None or N/A (RR, Pedestrian, etc). 0- Other
HINGE_CD	`hinge_cd`	esriFieldTypeString	1- Pins & Hangers. 2- Pins, Pin Plates. 3- Seated Hinges (Rollers, Plates, Pot Bearings). 4- Other (includes Strut). N- Not Applicable (structures with no hinges)
DECK_DRN_CD	`deck_drn_cd`	esriFieldTypeString	1- Over the side (without drip strip). 2- Opening thru curbs or wheel guards. 3- Scuppers and downspouts. 4- Inlets with drain pipes. 5- Drainage trough under open joints. 6- Over the side. N- None. 0- Other (Natural off the bridge ends)
DECK_CONC_TYP_CD	`deck_conc_typ_cd`	esriFieldTypeString	1- Class C. 2- Class S Superstructure. 3- Class S Superstructure using shrinkage compensating cement. 4- Class S Superstructure with Type 2 cement. 5- High Performance Concrete Superstructure, Type 3. See Bridge Inventory Guide for full list.
EXPN_JOINT1_CD	`expn_joint1_cd`	esriFieldTypeString	1 Metal Finger. 2 Sliding Metal Plate Angle. 3 Compression Seal. 4 Poured. 5 Open (Armored). 6 Open (Unarmored). 7 Steel Reinforced Elastomeric. 8 Elastomeric Strip Seal. N None. 0 Other. A Modular. B Polymer modified expansion device
EXPN_JOINT2_CD	`expn_joint2_cd`	esriFieldTypeString	1 Metal Finger. 2 Sliding Metal Plate Angle. 3 Compression Seal. 4 Poured. 5 Open (Armored). 6 Open (Unarmored). 7 Steel Reinforced Elastomeric. 8 Elastomeric Strip Seal. N None. 0 Other. A Modular. B Polymer modified expansion device
EXPN_JOINT3_CD	`expn_joint3_cd`	esriFieldTypeString	1 Metal Finger. 2 Sliding Metal Plate Angle. 3 Compression Seal. 4 Poured. 5 Open (Armored). 6 Open (Unarmored). 7 Steel Reinforced Elastomeric. 8 Elastomeric Strip Seal. N None. 0 Other. A Modular. B Polymer modified expansion device
HORIZ_CRV_RADIUS	`horiz_crv_radius`	esriFieldTypeString	Blank- structure is primarily on a tangent. 9999- Spiral. 0000-non tangent, unkown curvature. 1830- 18 degrees 30 minutes.
BEARING_DEVICE1_CD	`bearing_device1_cd`	esriFieldTypeString	1- Rollers. 2- Rockers & Bolsters. 3- Sliding, Bronze. 4- Elastomeric, Plain. 5- Pot. 6- Spherical. 7- Disc. 8- Fixed Arch-Rib. N- None. 0- Other. A- Sliding, Other. B- Fixed. C- Elastomeric, laminated. D- Integral & semi-integral abutment bearings
BEARING_DEVICE2_CD	`bearing_device2_cd`	esriFieldTypeString	1- Rollers. 2- Rockers & Bolsters. 3- Sliding, Bronze. 4- Elastomeric, Plain. 5- Pot. 6- Spherical. 7- Disc. 8- Fixed Arch-Rib. N- None. 0- Other. A- Sliding, Other. B- Fixed. C- Elastomeric, laminated. D- Integral & semi-integral abutment bearings
FRAMING_TYP_CD	`framing_typ_cd`	esriFieldTypeString	1- Curved Beams/Girders Framing. 2- Dog-legged or Kinked Framing. 3- Flared Beams/Girders Framing. 4- Straight Beams/Girders Framing. 0- Other Framing. N- None or Not Applicable
HAUNCH_GIRD_SW	`haunch_gird_sw`	esriFieldTypeString	Y/N Does bridge contain a haunched girder.
LONG_MEMB_TYP_CD	`long_memb_typ_cd`	esriFieldTypeString	1- two girder. 2- three girder. 3- four(+) girder. 4- two trusses, welded. 5- two trusses, riveted. 6- three(+) trusses, welded. 7- three(+) trusses, riveted. A- two(+) steel arches, welded. See Bridge Inventory Guide for full list.
MAIN_MEM_CD	`main_mem_cd`	esriFieldTypeString	1- Rolled steel. 2- Riveted built-up steel. 3- Welded built-up steel. 4- Concrete tee beam. 5- Concrete girder. 6- Prestressed concrete box beam. 7- Prestressed concrete I beam. 8- Timber. See Bridge Inventory Guide for full list.
STR_STEEL_PROT_CD	`str_steel_prot_cd`	esriFieldTypeString	1- Red lead. 2- Unpainted weathered steel. 3- Paint system A. 4- Paint system B. 5- Paint system OZEU. 6- Galvanized. 7- Metalized (Alum/Zinc). A- EEU. B- Epoxy, urethane sealers. C- Non epoxy sealers See Bridge Inventory Guide for full list
PRED_STR_STEEL_TYP	`pred_str_steel_typ`	esriFieldTypeString	1- A588 (Weathering Steel). 2- A572. 3- A441. 4- A440. 0- Other. A- Wrought Iron. B- Hybrid (A572 or A588 flanges with A36 webs). C- Hybrid (A709 grade 70W flanges with 50W webs). D- A709 Grade 50 . See Bridge Inventory Guide for full list
PAINT_SURFACE_AREA	`paint_surface_area`	esriFieldTypeInteger	Protective coating system surface area
STR_STEEL_PAINT_CD	`str_steel_paint_cd`	esriFieldTypeString	Where the prime coat of paint was applied to structural steel. 1- Shop. 2- Field. 3- Combination. U- Unknown. N- None.
POST_TENSION_SW	`post_tension_sw`	esriFieldTypeString	Y/N Is bridge Post Tensioned.
ABUT_FWD_TYP_CD	`abut_fwd_typ_cd`	esriFieldTypeString	1- Gravity. 2- Cantilever. 3- Solid Wall. 4- Cellular or “U”. 5- Stub Gravity. 6- Stub-Capped Pile. 7- Integral. 8- Pedestal. B- Capped Pile Bent. C- Cap & Column. D- Semi-Integral. See Bridge Inventory Guide for full list
ABUT_FWD_MATL_CD	`abut_fwd_matl_cd`	esriFieldTypeString	1- Stone. 2- Concrete. 3- Concrete and Stone. 4- Timber. 5- Steel. 6- Steel and Timber. 7- Steel and Concrete. N- None. 0- Other
ABUT_FWD_CD	`abut_fwd_cd`	esriFieldTypeString	1- Steel H Piles (Other size). 2- Cast in place reinforced concrete piles (Other diameter). 3- Drilled shafts. 4-Spread footing. 5- Timber piles. 6-Rock. 7- Steel H Piles (HP 10 x 42). See Bridge Inventory Guide for full list
ABUT_REAR_TYP_CD	`abut_rear_typ_cd`	esriFieldTypeString	1- Gravity. 2- Cantilever. 3- Solid Wall. 4- Cellular or “U”. 5- Stub Gravity. 6- Stub-Capped Pile. 7- Integral. 8- Pedestal. B- Capped Pile Bent. C- Cap & Column. D- Semi-Integral. See Bridge Inventory Guide for full list
ABUT_REAR_MATL_CD	`abut_rear_matl_cd`	esriFieldTypeString	1- Stone. 2- Concrete. 3- Concrete and Stone. 4- Timber. 5- Steel. 6- Steel and Timber. 7- Steel and Concrete. N- None. 0- Other
ABUT_REAR_CD	`abut_rear_cd`	esriFieldTypeString	1- Steel H Piles (Other size). 2- Cast in place reinforced concrete piles (Other diameter). 3- Drilled shafts. 4-Spread footing. 5- Timber piles. 6-Rock. 7- Steel H Piles (HP 10 x 42). See Bridge Inventory Guide for full list
PRED_PIER_TYP_CD	`pred_pier_typ_cd`	esriFieldTypeString	1- Gravity. 2- Cantilever (Tee) Open Panel. 3- Cantilever (Tee) Solid Panel. 4- Open Column. 5- Capped Column. 6- Straddle Bent Column. 8- Capped Pile. 0- Other. A- Solid Wall. B- Tower. N- None
PRED_PIER_MATL_CD	`pred_pier_matl_cd`	esriFieldTypeString	1- Stone. 2- Concrete. 3- Concrete and Stone. 4- Timber. 5- Steel. 6- Steel and Timber. 7- Steel and Concrete. N- None. 0- Other
PIER_PRED_CD	`pier_pred_cd`	esriFieldTypeString	1- Steel H Piles (Other size). 2- Cast in place reinforced concrete piles (Other diameter). 3- Drilled shafts. 4-Spread footing. 5- Timber piles. 6-Rock. 7- Steel H Piles (HP 10 x 42). See Bridge Inventory Guide for full list
PIER_1_TYP_CD	`pier_1_typ_cd`	esriFieldTypeString	1- Gravity. 2- Cantilever (Tee) Open Panel. 3- Cantilever (Tee) Solid Panel. 4- Open Column. 5- Capped Column. 6- Straddle Bent Column. 8- Capped Pile. 0- Other. A- Solid Wall. B- Tower. N- None
PIER_1_MATL_CD	`pier_1_matl_cd`	esriFieldTypeString	1- Stone. 2- Concrete. 3- Concrete and Stone. 4- Timber. 5- Steel. 6- Steel and Timber. 7- Steel and Concrete. N- None. 0- Other
PIER_OTH1_CD	`pier_oth1_cd`	esriFieldTypeString	1- Steel H Piles (Other size). 2- Cast in place reinforced concrete piles (Other diameter). 3- Drilled shafts. 4-Spread footing. 5- Timber piles. 6-Rock. 7- Steel H Piles (HP 10 x 42). See Bridge Inventory Guide for full list
SLOPE_PROT_TYP_CD	`slope_prot_typ_cd`	esriFieldTypeString	1- Concrete (cast-in-place). 2- Stone (No. 1 Aggregate). 3- Rip Rap (dumped rock or rock channel protection). 4- Gabions (wire mesh baskets filled with stone). 5- Fabric bags filled with concrete. 0- Other. See Bridge Inventory Guide for full list
CULVERT_TYP_CD	`culvert_typ_cd`	esriFieldTypeString	1- Slab Top. 2- 4 Sided Box (Concrete Cast-In-Place). 3- 3 Sided Frame (Concrete Cast-In-Place). 4- Pipe-Circular. 5- Pipe-Arch (also includes stone). 6- Pipe-Elliptical. 7- Arch (Multi-Plate). See Bridge Inventory Guide for full list
CULVERT_LEN	`culvert_len`	esriFieldTypeDouble	The out/out length of culvert type bridges
CULVERT_FILL_DEPTH	`culvert_fill_depth`	esriFieldTypeSingle	The depth of fill over a culvert in feet.
SCENIC_WATERWAY_SW	`scenic_waterway_sw`	esriFieldTypeString	Y/N Is the waterway classified as a scenic river.
CHAN_PROT_TYPE_CD	`chan_prot_type_cd`	esriFieldTypeString	1- Concrete. 2- Stone. 3- Sheet Piling. 4- Piling. 5- Rip Rap. 6- Gabions. 7- Fabric bags filled with concrete or sand. N- None. 0- Other. X- Not Applicable. A- Precast concrete (panels). B- Earthen Dikes. U- Unknown
STREAM_VELOCITY	`stream_velocity`	esriFieldTypeString	The hundred-year velocity of the stream under the bridge.
HIST_TYP_CD	`hist_typ_cd`	esriFieldTypeString	Historical bridge type code
HIST_BUILDER_CD	`hist_builder_cd`	esriFieldTypeString	Historical bridge builder code. See Bridge Inventory Guide for code descriptions.
SUFF_RATING	`suff_rating`	esriFieldTypeString	Unofficial sufficiency rating
DEFIC_FUNC_RATING	`defic_func_rating`	esriFieldTypeString	Status
MAIN_STR_DESCR_CD	`main_str_descr_cd`	esriFieldTypeString	1- Pony truss. 2- Through girder. 3- Filled arch. N- Not applicable
APPRH_STR_DESCR_CD	`apprh_str_descr_cd`	esriFieldTypeString	1- Pony truss. 2- Through girder. 3- Filled arch. N- Not applicable
HIST_BUILD_YR	`hist_build_yr`	esriFieldTypeString	Historical bridge year built
ROUTE_TYPE	`route_type`	esriFieldTypeString	Two letter code indicating the basic transportation grouping or system that the route belongs to - third component of the NLFID. IR, US, SR, CR, TR, MR, etc
ROUTE_NBR	`route_nbr`	esriFieldTypeString	Transportation route identification number. Each State system route number is unique within the entire state. Local Roadways are unique within a given county. Right justified, left filled with zero. Fourth component of the NLFID.
ROUTE_SUFFIX	`route_suffix`	esriFieldTypeString	Single letter extension code used with the route number in local and municipal systems to guarantee uniqueness; Fifth component of the NLFID.
ROUTINE_INSP_DUE	`routine_insp_due`	esriFieldTypeDate	Routine inspection due date
FRAC_CRIT_INSP_DUE	`frac_crit_insp_due`	esriFieldTypeDate	Fracture critical inspection due date
DIVE_INSP_DUE	`dive_insp_due`	esriFieldTypeDate	Dive inspection due date
SPCL_INSP_DUE	`spcl_insp_due`	esriFieldTypeDate	Special inspection due date
BIA_REPORT	`bia_report`	esriFieldTypeString	Link to Bridge Inventory and Appraisal Report pdf document
STATE_ROUTE_BR_PHOTOS	`state_route_br_photos`	esriFieldTypeString	Link to bridge photos
JURISDICTION	`jurisdiction`	esriFieldTypeString	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	`divided_hwy`	esriFieldTypeString	Indicates whether a roadway section is part of a divided highway
ACCESS_CONTROL	`access_control`	esriFieldTypeString	Degree of access control for a given section of the road. (1) Full Access Control - Preference given to through traffic movements by providing interchanges with selected public roads, and by prohibiting crossing at-grade and direct driveway connections (i.e., limited access to the facility). (2) Partial Access Control - Preference given to through traffic movement. In addition to interchanges, there may be some crossings at-grade with public roads, but, direct private driveway connections have been minimized through the use of frontage roads or other local access restrictions. Control of curb cuts is not access control. (3) No Access Control - No degree of access control exists (i.e., full access to the facility is permitted).
URBAN_AREA_CODE	`urban_area_code`	esriFieldTypeString	U.S. Census Urban Area Code associated with the section of roadway
BASE_TYPE	`base_type`	esriFieldTypeString	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	`functional_class`	esriFieldTypeString	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	`hpms_sample_id`	esriFieldTypeString	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	`lanes`	esriFieldTypeInteger	Number of lanes in both directions carrying through traffic
MAINTENANCE_AUTHORITY	`maintenance_authority`	esriFieldTypeString	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	`nhs`	esriFieldTypeString	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`	esriFieldTypeString	Priority System code associated with the section of the roadway. (G) General. (P) Priority System. (U) Urban.
SURFACE_TYPE	`surface_type`	esriFieldTypeString	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`	esriFieldTypeInteger	Surface width on the right side of the roadway
ESAL_TOTAL	`esal_total`	esriFieldTypeInteger	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
PAVE_TYPE	`pave_type`	esriFieldTypeString	Type of Pavement
PCR_YEAR	`pcr_year`	esriFieldTypeInteger	Year in which conditions of pavements on road were last collected and processed by the pavement engineering group
ROADWAY_WIDTH_NBR	`roadway_width_nbr`	esriFieldTypeSmallInteger	The entire width of the roadway, including all driving lanes and shoulders. This number could include some gravel shoulders. Does not include medians
(feature geometry)	`geom`	`ST_SetSRID(ST_GeomFromGeoJSON(…), 4326)`	Feature geometry, WGS84

Geometry

SRID 4326 (WGS84). GIST index on geom.
Empty / null geometries stored as SQL NULL.

Source field	Column	Esri type	Description
OBJECTID	`objectid`	esriFieldTypeOID
TNMID	`tnmid`	esriFieldTypeString	TNM ID
MetaSourceID	`metasourceid`	esriFieldTypeString	Meta Source ID
SourceDataDesc	`sourcedatadesc`	esriFieldTypeString	Source Data Description
SourceOriginator	`sourceoriginator`	esriFieldTypeString	Source Originator
SourceFeatureID	`sourcefeatureid`	esriFieldTypeString	Source Feature ID
LoadDate	`loaddate`	esriFieldTypeDate	Load Date
GNIS_ID	`gnis_id`	esriFieldTypeInteger	Unique identifier assigned by GNIS
AreaAcres	`areaacres`	esriFieldTypeDouble	Area of Hydrologic Unit measured in acres
AreaSqKm	`areasqkm`	esriFieldTypeDouble	Area of Hydrologic Unit measure in square kilometeres
States	`states`	esriFieldTypeString	States Hydrological Unit covers
HUC12	`huc12`	esriFieldTypeString	Twelve Digit Hydrologic Unit Code – Subwatershed level breakdown of the Watershed Boundary Dataset
Name	`name`	esriFieldTypeString	Name of Hydrological Unit
HUType	`hutype`	esriFieldTypeString	Hydrologic Unit type – Geomorphic and other considerations used to develop the hydrologic unit
HUMod	`humod`	esriFieldTypeString	A collection of two-character, uppercase abbreviation(s) for either (1) the type of modification to natural overland flow that alters the location of a Watershed boundary or (2) the special conditions GF-ground-water flow, GL-glacier, IF-ice field, OF-overbank flow, KA-karst, NC-noncontributing area, and IT-interbasin transfer
ToHUC	`tohuc`	esriFieldTypeString	To HUC
NonContributingAcres	`noncontributingacres`	esriFieldTypeDouble	Area (in acres) that does not flow toward the outlet of a hydrologic unit.
NonContributingSqKm	`noncontributingsqkm`	esriFieldTypeDouble	Area (in square kilometers) that does not flow toward the outlet of a hydrologic unit.
(feature geometry)	`geom`	`ST_Multi(ST_SetSRID(ST_GeomFromGeoJSON(…), 4326))`	Feature geometry, WGS84

ODOT-Maintained Bridges by HUC-12 Subwatershed

Layers

Data sets used

Ask your own question about Ohio

Transcript

transcript.md

State Planner chat · https://stateplanner.com

Prompt

Response

Exploratory Queries

Query 1 — See how bridge maintenance responsibility is coded to define "state bridges".

Query 2 — Count ODOT-maintained bridges in each HUC-12 subwatershed and rank them.

Query 3 — Summarize the distribution of state bridge counts across subwatersheds for the map classes.

Map Layer Queries

Subwatersheds by ODOT-maintained bridge count — colored by "cls": 50–122 bridges (23) (#7f0000), 20–49 bridges (122) (#d7301f), 10–19 bridges (370) (#fc8d59), 1–9 bridges (960) (#fdd49e), None (79) (#f7f7f7)

Used Data Sets

data/turn-1-query-1.csv

data/turn-1-query-2.csv

data/turn-1-query-3.csv

maps/turn-1-state-bridges-huc12.png

provenance/oh_bridge_inventory.md

Provenance: `oh_bridge_inventory`

Identity

Pipeline (TIMS family)

Field → column mapping

Geometry

provenance/oh_nrcs_huc_12.md

Provenance: `oh_nrcs_huc_12`

Identity

Pipeline (TIMS family)

Field → column mapping

Geometry

ODOT-Maintained Bridges by HUC-12 Subwatershed

Layers

Data sets used

Ask your own question about Ohio

Transcript

State Planner chat · https://stateplanner.com

Prompt

Response

Exploratory Queries

Query 1 — See how bridge maintenance responsibility is coded to define "state bridges".

Query 2 — Count ODOT-maintained bridges in each HUC-12 subwatershed and rank them.

Query 3 — Summarize the distribution of state bridge counts across subwatersheds for the map classes.

Map Layer Queries

Subwatersheds by ODOT-maintained bridge count — colored by "cls": 50–122 bridges (23) (#7f0000), 20–49 bridges (122) (#d7301f), 10–19 bridges (370) (#fc8d59), 1–9 bridges (960) (#fdd49e), None (79) (#f7f7f7)

Used Data Sets

Provenance: oh_bridge_inventory

Identity

Pipeline (TIMS family)

Field → column mapping

Geometry

Provenance: oh_nrcs_huc_12

Identity

Pipeline (TIMS family)

Field → column mapping

Geometry

Provenance: `oh_bridge_inventory`

Provenance: `oh_nrcs_huc_12`