Local Road Pavement Condition by County

What follows is the transcript of this chat as State Planner generated it. It is here to show how the answer above was arrived at: every query State Planner ran, what each one returned, and where the data came from.

transcript.md

↑ Contents

State Planner chat · https://stateplanner.com

State: Ohio (OH)
Started: November 1, 2026, 7:12 PM UTC
Runtime: 49 sec
Status: completed

Prompt

Which Ohio Counties Have the Worst Local Road Pavement?

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

Response

Local road pavement condition by county (ODOT PCR, local system)

I used ODOT's PCR (Local) table (oh_pcr_local). It holds the Pavement Condition Rating, a 0–100 score where lower means more distress, for about 12,000 miles of county, municipal and township roads in all 88 counties. I ranked counties two ways:

Average PCR weighted by mileage, so long segments count more than short ones.
Share of rated miles below PCR 55. On ODOT's scale that is "poor" or worse.

Statewide, the mileage-weighted average is 82.1, and 4.7% of rated miles are below 55.

Local Road Pavement Condition by County

Counties with the lowest average local-road PCR

County	Rated miles	Avg PCR	% of miles PCR < 55
Vinton	38	70.4	0.0
Noble	12	70.4	40.0
Belmont	116	73.2	19.1
Harrison	46	73.9	16.1
Pike	38	74.8	7.0
Cuyahoga	795	75.3	10.9
Knox	33	75.6	18.3
Ross	110	75.7	11.8
Hamilton	628	75.8	7.8
Licking	215	76.0	7.5
Sandusky	88	76.1	6.5
Lawrence	98	76.2	12.7

Counties with at least 50 rated miles, by share below PCR 55: Belmont 19.1%, Jackson 13.5%, Lawrence 12.7%, Summit 12.0%, Ross 11.8%, Lucas 11.5%, Cuyahoga 10.9%, Hamilton 7.8%.

What stands out

Belmont is low on both measures, with enough mileage (116 mi) to be a reliable reading. Nearby Harrison and Noble also score low, but they have few rated miles.
Among the large urban counties, Cuyahoga (75.3) and Hamilton (75.8) have the lowest averages. Together they have about 1,400 rated miles. Lucas and Summit have average scores near the middle, but more than 11% of their miles are below 55.
Some rankings rest on very few miles. Noble has 12 rated miles, Knox 33, and Vinton and Pike 38 each. One or two segments can move these counties a lot. Vinton's low average comes from many middling scores rather than any segment below 55.

Map legend

County fill: mileage-weighted average PCR.
- Dark red: under 75
- Orange: 75–77.9
- Light pink: 78–80.9
- Light blue: 81–83.9
- Dark blue: 84 and above
Dark purple lines: the 959 local segments rated below 55.
Click a county for its rated miles, share below 55 and rating dates. Click a segment for its route, city or township, PCR, roughness (IRI) and rating date.

Caveats

Not every local road is rated. The table covers about 12,000 miles, mostly federal-aid-eligible routes (functional classes 2–7) rather than every residential street. How much is rated varies widely by county, and so does how reliable each county's figure is.
Ratings range from October 2020 to February 2026, so counties are not all measured at the same time. A county rated early may have repaved since.
The threshold and weighting are my choices. Lengths come from county log points, and "below 55" is my cut-off. Using below 65 instead, Noble, Harrison, Belmont and Ross have the highest shares (34–53%).

I can also compare counties by road owner (county, city or township roads), rank cities or townships, or show the state-highway PCR beside these.

Exploratory Queries

Query 1 — Understand year coverage, rated mileage and counties in local PCR data.

   SELECT pcr_year,
          count(*) n,
          count(DISTINCT county_cd) counties,
          round(sum(ctl_end - ctl_begin)::numeric) miles,
          round(avg(pcr_nbr), 1) avg_pcr,
          count(*) FILTER (
              WHERE pcr_nbr IS NULL
          ) nulls
     FROM oh_pcr_local
 GROUP BY 1
 ORDER BY 1

pcr_year	n	counties	miles	avg_pcr	nulls
2026	16316	88	12011	80.9	0

data/turn-1-query-1.csv

Query 2 — Check jurisdiction, route type and direction mix of rated local segments.

   SELECT jurisdiction,
          route_type,
          direction_cd,
          count(*) n,
          round(sum(ctl_end - ctl_begin)::numeric) miles,
          round(avg(pcr_nbr), 1) avg_pcr
     FROM oh_pcr_local
 GROUP BY 1,
          2,
          3
 ORDER BY n DESC
    LIMIT 20

jurisdiction	route_type	direction_cd	n	miles	avg_pcr
C	CR	UP	8156	7903	83.0
M	MR	UP	6469	3052	78.0
T	TR	UP	1317	786	82.8
M	MR	DOWN	200	137	79.5
C	CR	DOWN	161	128	82.8
T	TR	DOWN	13	6	88.0

data/turn-1-query-2.csv

Query 3 — Rank counties by mileage-weighted local-road PCR and share of miles rated below 55.

     WITH s AS (
             SELECT county_cd,
                    greatest(ctl_end - ctl_begin, 0) mi,
                    pcr_nbr
               FROM oh_pcr_local
          )
   SELECT c.county,
          s.county_cd,
          round(sum(mi)::numeric, 0) miles,
          count(*) segs,
          round((sum(mi * pcr_nbr) / nullif(sum(mi), 0))::numeric, 1) wpcr,
          round(
          (
          100 * sum(mi) FILTER (
              WHERE pcr_nbr < 55
          ) / sum(mi)
          )::numeric,
          1
          ) pct_lt55,
          round(
          (
          100 * sum(mi) FILTER (
              WHERE pcr_nbr < 65
          ) / sum(mi)
          )::numeric,
          1
          ) pct_lt65
     FROM s
     JOIN oh_county c USING (county_cd)
 GROUP BY 1,
          2
 ORDER BY wpcr
    LIMIT 20

county	county_cd	miles	segs	wpcr	pct_lt55	pct_lt65
VINTON	VIN	38	19	70.4		6.6
NOBLE	NOB	12	8	70.4	40.0	53.2
BELMONT	BEL	116	158	73.2	19.1	34.4
HARRISON	HAS	46	23	73.9	16.1	39.4
PIKE	PIK	38	33	74.8	7.0	17.8
CUYAHOGA	CUY	795	1202	75.3	10.9	25.7
KNOX	KNO	33	41	75.6	18.3	26.0
ROSS	ROS	110	107	75.7	11.8	33.2
HAMILTON	HAM	628	1198	75.8	7.8	25.4
LICKING	LIC	215	286	76.0	7.5	21.7
SANDUSKY	SAN	88	125	76.1	6.5	24.9
LAWRENCE	LAW	98	95	76.2	12.7	17.9
FRANKLIN	FRA	998	1570	78.0	5.5	19.2
JEFFERSON	JEF	111	164	78.2	7.3	21.0
LUCAS	LUC	447	728	78.9	11.5	21.9
PAULDING	PAU	41	28	79.4	6.7	11.9
JACKSON	JAC	74	92	80.1	13.5	14.6
LAKE	LAK	159	212	80.3	6.0	22.1
FULTON	FUL	117	103	80.6	2.4	11.1
BUTLER	BUT	273	418	80.6	5.2	18.3

data/turn-1-query-3.csv

Query 4 — Check rating dates, functional classes and statewide totals for context.

   SELECT min(rated_date)::date mind,
          max(rated_date)::date maxd,
          round(
          (
          sum(greatest(ctl_end - ctl_begin, 0) * pcr_nbr) / sum(greatest(ctl_end - ctl_begin, 0))
          )::numeric,
          1
          ) wpcr,
          round(
          (
          100 * sum(greatest(ctl_end - ctl_begin, 0)) FILTER (
              WHERE pcr_nbr < 55
          ) / sum(greatest(ctl_end - ctl_begin, 0))
          )::numeric,
          1
          ) pct55,
          string_agg(DISTINCT functional_class, ',') fcs,
          min(pcr_nbr),
          max(pcr_nbr)
     FROM oh_pcr_local

mind	maxd	wpcr	pct55	fcs	min	max
2020-10-14T00:00:00.000Z	2026-02-19T00:00:00.000Z	82.1	4.7	2,3,4,5,6,7	0	100

data/turn-1-query-4.csv

Query 5 — Rank counties with at least 50 rated miles by share of miles below PCR 55.

     WITH s AS (
             SELECT county_cd,
                    greatest(ctl_end - ctl_begin, 0) mi,
                    pcr_nbr
               FROM oh_pcr_local
          )
   SELECT c.county,
          round(sum(mi)::numeric) miles,
          round((sum(mi * pcr_nbr) / sum(mi))::numeric, 1) wpcr,
          round(
          (
          100 * coalesce(
          sum(mi) FILTER (
              WHERE pcr_nbr < 55
          ),
          0
          ) / sum(mi)
          )::numeric,
          1
          ) p55
     FROM s
     JOIN oh_county c USING (county_cd)
 GROUP BY 1
   HAVING sum(mi) >= 50
 ORDER BY p55 DESC
    LIMIT 10

county	miles	wpcr	p55
BELMONT	116	73.2	19.1
JACKSON	74	80.1	13.5
LAWRENCE	98	76.2	12.7
SUMMIT	490	81.5	12.0
ROSS	110	75.7	11.8
LUCAS	447	78.9	11.5
CUYAHOGA	795	75.3	10.9
HAMILTON	628	75.8	7.8
LICKING	215	76.0	7.5
JEFFERSON	111	78.2	7.3

data/turn-1-query-5.csv

Map Layer Queries

Average local-road PCR (mileage-weighted) — colored by "bin": Avg PCR under 75 (#b2182b), 75 – 77.9 (#ef8a62), 78 – 80.9 (#fddbc7), 81 – 83.9 (#92c5de), 84 and above (#2166ac)

     WITH s AS (
             SELECT county_cd,
                    greatest(ctl_end - ctl_begin, 0) mi,
                    pcr_nbr,
                    rated_date
               FROM oh_pcr_local
          ),
          a AS (
             SELECT county_cd,
                    sum(mi) miles,
                    count(*) segs,
                    sum(mi * pcr_nbr) / nullif(sum(mi), 0) wpcr,
                    100 * coalesce(
                    sum(mi) FILTER (
                        WHERE pcr_nbr < 55
                    ),
                    0
                    ) / nullif(sum(mi), 0) p55,
                    min(rated_date)::date d0,
                    max(rated_date)::date d1
               FROM s
           GROUP BY 1
          )
   SELECT c.geom,
          initcap(c.county) AS "County",
          round(a.wpcr::numeric, 1) AS "Avg PCR(mile-weighted)",
          round(a.p55::numeric, 1) AS "% of rated miles PCR < 55",
          round(a.miles::numeric) AS "Rated miles",
          a.segs AS "Rated segments",
          a.d0 || ' to ' || a.d1 AS "Rating dates",
          CASE
                    WHEN a.wpcr < 75 THEN 'a'
                    WHEN a.wpcr < 78 THEN 'b'
                    WHEN a.wpcr < 81 THEN 'c'
                    WHEN a.wpcr < 84 THEN 'd'
                    ELSE 'e'
          END AS bin
     FROM oh_county c
     JOIN a USING (county_cd)

Picture: maps/turn-1-local-pcr-county.png

Local segments rated PCR under 55

   SELECT geom,
          county_cd AS "County code",
          route_type || ' ' || route_nbr || coalesce(route_suffix, '') AS "Route",
          coalesce(city_name, township_name) AS "City / township",
          pcr_nbr AS "PCR",
          avg_iri AS "Avg IRI",
          rated_date::date AS "Rated",
          round((ctl_end - ctl_begin)::numeric, 2) AS "Miles"
     FROM oh_pcr_local
    WHERE pcr_nbr < 55

Picture: maps/turn-1-local-pcr-county.png

Used Data Sets

oh_county — last synced 2026-09-27 · 88 rows
oh_pcr_local — last synced 2026-11-01 · 16,316 rows

data/turn-1-query-1.csv

↑ Contents

pcr_year	n	counties	miles	avg_pcr	nulls
2026	16316	88	12011	80.9	0

1 row.

data/turn-1-query-2.csv

↑ Contents

jurisdiction	route_type	direction_cd	n	miles	avg_pcr
C	CR	UP	8156	7903	83.0
M	MR	UP	6469	3052	78.0
T	TR	UP	1317	786	82.8
M	MR	DOWN	200	137	79.5
C	CR	DOWN	161	128	82.8
T	TR	DOWN	13	6	88.0

6 rows.

data/turn-1-query-3.csv

↑ Contents

county	county_cd	miles	segs	wpcr	pct_lt55	pct_lt65
VINTON	VIN	38	19	70.4		6.6
NOBLE	NOB	12	8	70.4	40.0	53.2
BELMONT	BEL	116	158	73.2	19.1	34.4
HARRISON	HAS	46	23	73.9	16.1	39.4
PIKE	PIK	38	33	74.8	7.0	17.8
CUYAHOGA	CUY	795	1202	75.3	10.9	25.7
KNOX	KNO	33	41	75.6	18.3	26.0
ROSS	ROS	110	107	75.7	11.8	33.2
HAMILTON	HAM	628	1198	75.8	7.8	25.4
LICKING	LIC	215	286	76.0	7.5	21.7
SANDUSKY	SAN	88	125	76.1	6.5	24.9
LAWRENCE	LAW	98	95	76.2	12.7	17.9
FRANKLIN	FRA	998	1570	78.0	5.5	19.2
JEFFERSON	JEF	111	164	78.2	7.3	21.0
LUCAS	LUC	447	728	78.9	11.5	21.9
PAULDING	PAU	41	28	79.4	6.7	11.9
JACKSON	JAC	74	92	80.1	13.5	14.6
LAKE	LAK	159	212	80.3	6.0	22.1
FULTON	FUL	117	103	80.6	2.4	11.1
BUTLER	BUT	273	418	80.6	5.2	18.3

20 rows.

data/turn-1-query-4.csv

↑ Contents

mind	maxd	wpcr	pct55	fcs	min	max
2020-10-14T00:00:00.000Z	2026-02-19T00:00:00.000Z	82.1	4.7	2,3,4,5,6,7	0	100

1 row.

data/turn-1-query-5.csv

↑ Contents

county	miles	wpcr	p55
BELMONT	116	73.2	19.1
JACKSON	74	80.1	13.5
LAWRENCE	98	76.2	12.7
SUMMIT	490	81.5	12.0
ROSS	110	75.7	11.8
LUCAS	447	78.9	11.5
CUYAHOGA	795	75.3	10.9
HAMILTON	628	75.8	7.8
LICKING	215	76.0	7.5
JEFFERSON	111	78.2	7.3

10 rows.

maps/turn-1-local-pcr-county.png

↑ Contents

provenance/oh_county.md

↑ Contents

Provenance: `oh_county`

This file describes how the rows in PostgreSQL table oh_county 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_county
Family: TIMS
Display name: County
Source URL: https://tims.dot.state.oh.us/ags/rest/services/Boundaries/County/MapServer/0
Geometry (source / stored): esriGeometryPolygon / geometry(MultiPolygon, 4326)
Update cycle: As Needed
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
COUNTY_CD	`county_cd`	esriFieldTypeString	The 3-letter code of the county within Ohio (88 counties total) [ODOT]
COUNTY	`county`	esriFieldTypeString	County name [ODOT]
COUNTY_SEAT	`county_seat`	esriFieldTypeString	City that serves as the County seat [ODOT]
ODOT_DISTRICT	`odot_district`	esriFieldTypeSmallInteger	From 1-12 plus Central Office – the counties are grouped into districts in Ohio for ease of maintenance and funding [ODOT]
FIPS_COUNTY_CD	`fips_county_cd`	esriFieldTypeString	FIPS County Code (Federal Information Processing Standard) [ODOT]
POP_2020	`pop_2020`	esriFieldTypeInteger
POP_2010	`pop_2010`	esriFieldTypeInteger	County population in 2010
POP_2000	`pop_2000`	esriFieldTypeInteger	County population in 2000
POP_1990	`pop_1990`	esriFieldTypeInteger	County population in 1990
STATE_PLANE_ZONE	`state_plane_zone`	esriFieldTypeString	State plane zone in which the county falls, N - North or S - South
ELEVATION_MAXIMUM	`elevation_maximum`	esriFieldTypeSmallInteger	Maximum elevation within the County boundaries
ELEVATION_MINIMUM	`elevation_minimum`	esriFieldTypeSmallInteger	Minimum elevation within the County boundaries
LAT_NORTH_DD	`lat_north_dd`	esriFieldTypeDouble
LAT_SOUTH_DD	`lat_south_dd`	esriFieldTypeDouble
LONG_EAST_DD	`long_east_dd`	esriFieldTypeDouble
LONG_WEST_DD	`long_west_dd`	esriFieldTypeDouble
AREA_SQMI	`area_sqmi`	esriFieldTypeDouble
AREA_ID	`area_id`	esriFieldTypeInteger
(feature geometry)	`geom`	`ST_Multi(ST_SetSRID(ST_GeomFromGeoJSON(…), 4326))`	Feature geometry, WGS84

Geometry

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

provenance/oh_pcr_local.md

↑ Contents

Provenance: `oh_pcr_local`

This file describes how the rows in PostgreSQL table oh_pcr_local 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_pcr_local
Family: TIMS
Display name: PCR (Local)
Source URL: https://tims.dot.state.oh.us/ags/rest/services/Roadway_Information/PCR_Local/MapServer/0
Geometry (source / stored): esriGeometryPolyline / geometry(MultiLineString, 4326)
Update cycle: Fortnightly
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.

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

Field → column mapping

Source field	Column	Esri type	Description
OBJECTID	`objectid`	esriFieldTypeOID
PCR_HISTORY_ID	`pcr_history_id`	esriFieldTypeString	PCR History ID
PCR_YEAR	`pcr_year`	esriFieldTypeInteger	Year in which conditions of pavements on road in speed zone were last collected and processed by the pavement engineering group
PERP_YEAR	`perp_year`	esriFieldTypeInteger	Calendar year in which a RI event occurs (like new constructions, abandoning of roads, annexations, increase in speed limit, and so on) on a roadway and is recorded in ODOT’s RI database
RATED_DATE	`rated_date`	esriFieldTypeDate	Date the roadway was rated
ODOT_DISTRICT	`odot_district`	esriFieldTypeString	From 1-12 plus Central Office – the counties are grouped into districts in Ohio for ease of maintenance and funding
COUNTY_CD	`county_cd`	esriFieldTypeString	The 3-letter code of the county within Ohio (88 counties total)
NLFID	`nlfid`	esriFieldTypeString	Primary key field that allows ODOT’s graphic roadway network geometric segments to be linked to business data attributes
JURISDICTION	`jurisdiction`	esriFieldTypeString	One-letter code indicating the primary legal authority of the speed zone - one component of the NLFID
ROUTE_TYPE	`route_type`	esriFieldTypeString	Two letter code indicating the basic transportation grouping or system that the speed zone belongs to- third component of the NLFID
ROUTE_NBR	`route_nbr`	esriFieldTypeString	Route number associated with the section of the route
ROUTE_SUFFIX	`route_suffix`	esriFieldTypeString	Single letter used with the route number in local and municipal systems to guarantee uniqueness
DIRECTION_CD	`direction_cd`	esriFieldTypeString	Direction Code
CTL_BEGIN	`ctl_begin`	esriFieldTypeDouble	Logpoint County Begin Number – the location within the county where the route begins
CTL_END	`ctl_end`	esriFieldTypeDouble	Logpoint County End Number – the location within the county where the route ends
DIVIDED_HWY	`divided_hwy`	esriFieldTypeString	Indicates whether a roadway section is part of a divided highway
FUNCTIONAL_CLASS	`functional_class`	esriFieldTypeString	The organization of roadways into a hierarchy based on the character of service provided. Typical classifications include arterial, local, and collector roadways.
URBAN_AREA_CODE	`urban_area_code`	esriFieldTypeString	U.S. Census Urban Area Code associated with the section of roadway
AREA_TYPE	`area_type`	esriFieldTypeString	When URBAN_AREA_CODE = '99999' then area type is 'RURAL'; When URBAN_AREA_CODE is less than '99999' then area type is 'URBAN'
HPMS_SAMPLE_ID	`hpms_sample_id`	esriFieldTypeString	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; For code descriptions, please refer to the Roadway Information Manual
ACCESS_CONTROL	`access_control`	esriFieldTypeString	Degree of access control for a given section of the road
NHS	`nhs`	esriFieldTypeString	Indicates if the record 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`	esriFieldTypeString	Priority System code associated with the section of the roadway; G-General, P-Priority System, U-Urban
BASE_TYPE	`base_type`	esriFieldTypeString	Code indicating type of base material on roadway segment associated with record, please reference Roadway Information manual
SURFACE_TYPE	`surface_type`	esriFieldTypeString	Roadway top layer, i.e., Brick (B), Concrete (D), Bituminouse Concrete Road (G), Bitumminous Cold Mix Road (K), Chipseal or Micro (L), Gravel (M), Right-of-way Only (X)
PAVE_TYPE	`pave_type`	esriFieldTypeString	Pavement type as used in the Pavement Condition Rating Process i.e. Composite, Flexible
SURFACE_WIDTH	`surface_width`	esriFieldTypeInteger	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
ROADWAY_WIDTH_NBR	`roadway_width_nbr`	esriFieldTypeInteger	The entire width of the roadway, including all driving lanes and shoulders. This number could include some gravel shoulders. Does not include medians
PCR_NBR	`pcr_nbr`	esriFieldTypeInteger	Pavement Condition Rating Number on a scale of 0 to 100 with 100 being new pavement not open to traffic
TOT_PCR_DEDUCT_NBR	`tot_pcr_deduct_nbr`	esriFieldTypeDouble	The sum of the individul distress deducts calculated from the Pavement Condition Rating
TOT_STRUCT_DEDUCT_NBR	`tot_struct_deduct_nbr`	esriFieldTypeDouble	The sum of the individual distresses that are structural in nature from the Pavement Condition Rating Calculation
TOT_CRACK_DEDUCT_NBR	`tot_crack_deduct_nbr`	esriFieldTypeDouble	The sum of the individual crack distress deducts calculated from the Pavement Conditon Rating Calculation
TOT_RUT_DEDUCT_NBR	`tot_rut_deduct_nbr`	esriFieldTypeDouble	The sum of the rut distress deduct calculated from the Pavement Condtion Rating Calculation
BASE_FAILURE	`base_failure`	esriFieldTypeString	Any deviation of the pavement surface from its original shape (other than described for rutting ). This deformation may take the form of bumps, dips, lipping or stepping at cracks, all of which give rise to pitch, roll and jarring drop in a moving vehicle
BASE_FAILURE_VALUE	`base_failure_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
BLEEDING	`bleeding`	esriFieldTypeString	Flushing of excess asphalt binder on the surface of the pavement
BLEEDING_VALUE	`bleeding_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
BLOCK_TRANS_CRK	`block_trans_crk`	esriFieldTypeString	Cracking that is formed by interconcected transversed and longitudinal cracking
BLOCK_TRANS_CRK_VALUE	`block_trans_crk_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
BRICK_DETERIORATION	`brick_deterioration`	esriFieldTypeString	The breaking up, disintegration¸ or loss of bricks
BRICK_DETER_VALUE	`brick_deter_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
CORNER_BREAK	`corner_break`	esriFieldTypeString	A crack in jointed concrete pavement that intersects transverse joints or cracks and a longitudinal edge diagonally. To be considered a corner break, the leg size of the triangular break must be greater than 12 inches.
CORNER_BREAK_VALUE	`corner_break_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
CORRUGATION	`corrugation`	esriFieldTypeString	Corrugations refers to the ride quality of various brick pavers. Pavers with very narrow and tight joints and a level surface may have a very smooth ride and minor traffic noise. Pavers with some settlement, open joints, and a rough, uneven surface can produce a very rough ride and significant traffic noise.
CORRUGATION_VALUE	`corrugation_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
CROWN	`crown`	esriFieldTypeString	The crown of the road refers to the center of the road being higher than the shoulders.
CROWN_VALUE	`crown_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
CRACK_SEAL_DEFICIENCY	`crack_seal_deficiency`	esriFieldTypeString	Crack seal deficiency is crack seal which is no longer effective in preventing intrusion of water or cracks which have never been sealed.
CRACK_SEAL_DEF_VALUE	`crack_seal_def_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
DISCOLORATION	`discoloration`	esriFieldTypeString	The fading of the initial brick color.
DISCOLORATION_VALUE	`discoloration_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
DRAINAGE	`drainage`	esriFieldTypeString	A system such as roadside ditches, culverts, etc., used to remove surface water on the roadway
DRAINAGE_VALUE	`drainage_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
DUST	`dust`	esriFieldTypeString	Soil and other fines that become airborne under the action traffic over a gravel surface
DUST_VALUE	`dust_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
EDGE_CRACKING	`edge_cracking`	esriFieldTypeString	Edge cracks are longitudinal or crescent shaped cracks found within 1 foot
EDGE_CRACKING_VALUE	`edge_cracking_value`	esriFieldTypeSingle	(0.3 m) of the pavement edge line
FAULTING	`faulting`	esriFieldTypeString	The difference in elevation between abutting slabs at transverse joints or cracks in concrete pavements
FAULTING_VALUE	`faulting_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
GRAVEL_LAYER	`gravel_layer`	esriFieldTypeString	Combination of stone, sand, and other material used as the top surface of a roadway
GRAVEL_LAYER_VALUE	`gravel_layer_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
JOINT_REF_CRK	`joint_ref_crk`	esriFieldTypeString	A transverse crack in the asphalt surface of a compsite pavement that is a result of the underlying joint formed by two abutting concrete slabs
JOINT_REF_CRK_VALUE	`joint_ref_crk_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
JOINT_SLT_DMG	`joint_slt_dmg`	esriFieldTypeString	A measure of the effectiveness of the material placed on the joint formed by two abutting concrete slabs to prevent water and other material from seeping between the slabs.
JOINT_SLT_DMG_VALUE	`joint_slt_dmg_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
JOINT_EROSION	`joint_erosion`	esriFieldTypeString	A wearing away of the area and widening of the spacing between brick pavers. This additional spacing allows water and other materials to seep between the pavers.
JOINT_EROSION_VALUE	`joint_erosion_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
JOINT_SPALLING	`joint_spalling`	esriFieldTypeString	The break up or disintegration of the concrete at longitudinal or transverse pavement joints.
JOINT_SPALLING_VALUE	`joint_spalling_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
LONGITUDINAL_JOINT_CRACKING	`longitudinal_joint_cracking`	esriFieldTypeString	Cracks formed parallel to the centerline of the roadway, and are the result of paving joints, widening joints which have reflected up through the layers of overlay, or the result of gear box segregation.
LONG_JOINT_CRK_VALUE	`long_joint_crk_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
LONG_JOINT_SPAL	`long_joint_spal`	esriFieldTypeString	The break up or disintegration of the concrete at longitudinal pavement joints.
LONG_JOINT_SPAL_VALUE	`long_joint_spal_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
LONGITUDINAL_CRACKING	`longitudinal_cracking`	esriFieldTypeString	A crack or break approximately parallel to the pavement centerline.
LONG_CRACKING_VALUE	`long_cracking_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
LOOSE_AGGREGATE	`loose_aggregate`	esriFieldTypeString	A movement of soil and other materials to form ridges in center of lanes of a gravel surface. The movement is usually caused by heavy dust action, erosion, etc.
LOOSE_AGGREGATE_VALUE	`loose_aggregate_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
MAP_CRACKING	`map_cracking`	esriFieldTypeString	Interconnected cracks that form a series of large polygon blocks which look, overall, like a map. The cracking appears to combine transverse and longitudinal cracks to form this map.
MAP_CRACKING_VALUE	`map_cracking_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
INTER_TRANS_CRK	`inter_trans_crk`	esriFieldTypeString	A transverse crack in the asphalt surface of a compsite pavement that is a reflection of a mid-panel or mid-slab transverse crack in the underlying concrete slab
INTER_TRANS_CRK_VALUE	`inter_trans_crk_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
PATCHING	`patching`	esriFieldTypeString	Patching is either the placing of asphalt concrete on the surface of the existing pavement
PATCHING_VALUE	`patching_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
POPOUT	`popout`	esriFieldTypeString	Cone shaped holes in the pavement surface with aggregates at the bottom and are unrelated to joint or crack spalling.
POPOUT_VALUE	`popout_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
POTHOLE	`pothole`	esriFieldTypeString	Bowl-shaped voids or depressions in the pavement surface.
POTHOLE_VALUE	`pothole_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
PRESSURE_DAMAGE	`pressure_damage`	esriFieldTypeString	a bump or hump in the pavement surface at a transverse joint or crack. The upheaval is a result of thermal expansion in the underlying concrete base creating compressive forces.
PRESSURE_DAMAGE_VALUE	`pressure_damage_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
PUMPING	`pumping`	esriFieldTypeString	The ejection of fine soil particles through pavement cracks, joints, or along pavement edges.
PUMPING_VALUE	`pumping_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
PUNCHOUT	`punchout`	esriFieldTypeString	A cracked rectangular area usually along the outside pavement edge. A punchout requires formation of longitudinal crack (usually within the outer wheel track) which connects transverse cracks of the composite pavement. The rectangular punchout area thus is defined by 2 transverse cracks, the longitudinal crack, and the outside pavement edge.
PUNCHOUT_VALUE	`punchout_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
RANDOM_CRACKING	`random_cracking`	esriFieldTypeString	Cracks that do not clearly fit into one of the more-defined categories such as block and transvers, edge, longitudinal, transverse, edge, etc. For example, cracks which meander across or along the pavement would be classified as random cracks.
RANDOM_CRACKING_VALUE	`random_cracking_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
RAVELING	`raveling`	esriFieldTypeString	Disintegration of the pavement from the surface downward due to the loss of aggregate particles.
RAVELING_VALUE	`raveling_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
RUTTING	`rutting`	esriFieldTypeString	Vertical deformations in the pavement surface along the wheel tracks.
RUTTING_VALUE	`rutting_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
SURF_DIS_OR_DEBOND	`surf_dis_or_debond`	esriFieldTypeString	The removal of the asphaltic surface layer from the underlying layer.
SURF_DIS_DEBOND_VALUE	`surf_dis_debond_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
SETTLEMENT	`settlement`	esriFieldTypeString	A dip in the longitudinal profile of the pavement surface.
SETTLEMENT_VALUE	`settlement_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
SHATTERED_SLAB	`shattered_slab`	esriFieldTypeString	The breakup of the underlying rigid pavement made evident by surface reflection cracking and/or distortion.
SHATTERED_SLAB_VALUE	`shattered_slab_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
SPALLING	`spalling`	esriFieldTypeString	The cracking, breaking, chipping, or fraying of the concrete surface
SPALLING_VALUE	`spalling_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
SURFACE_DETERIORATION	`surface_deterioration`	esriFieldTypeString	Disintegration or loss of concrete from the surface of the pavement. Includes scaling and abrasion.
SURFACE_DETER_VALUE	`surface_deter_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
TRANSVERSE_CRK	`transverse_crk`	esriFieldTypeString	A crack or break at approximately right angles to the pavement centerline.
TRANSVERSE_CRK_VALUE	`transverse_crk_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
TRANS_CRK_PL_CONC	`trans_crk_pl_conc`	esriFieldTypeString	A crack or break at approximately right angles to the pavement centerline in plain concrete pavements.
TRANS_CRK_PL_CONC_VALUE	`trans_crk_pl_conc_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
TRANS_CRK_RF_CONC	`trans_crk_rf_conc`	esriFieldTypeString	A crack or break at approximately right angles to the pavement centerline in reinforced concrete pavements.
TRANS_CRK_RF_CONC_VALUE	`trans_crk_rf_conc_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
THERMAL_CRACKING	`thermal_cracking`	esriFieldTypeString	A series of evenly spaced cracks that are oriented perpendicular to the centerline of the roadway. Thermal cracks should be present from edge of pavement to edge of pavement. Distress applies to flexible pavements.
THERMAL_CRACKING_VALUE	`thermal_cracking_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
TRANS_CRK_UJ_BASE	`trans_crk_uj_base`	esriFieldTypeString	A crack or break at approximately right angles to the pavement centerline in a composite pavement that has an unjointed base.
TRANS_CK_UJ_BASE_VALUE	`trans_ck_uj_base_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
WASHBOARD	`washboard`	esriFieldTypeString	A series of closely-spaced ridges or humps perpendicular to travel direction on a gravel pavement. Ridges are caused by traffic dislodging aggregate.
WASHBOARD_VALUE	`washboard_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
WHEEL_TRACK_CRK	`wheel_track_crk`	esriFieldTypeString	Cracks located within or near the wheel paths. For evaluation purposes, each wheel path shall be considered 3 feet (1 m) in width.
WHEEL_TRACK_CRK_VALUE	`wheel_track_crk_value`	esriFieldTypeSingle	Value of the deduct associated with the Distress
AADT_PASSENGER	`aadt_passenger`	esriFieldTypeInteger	Measure of the Average Annual Daily Traffic passengers (Does not include trucks)
AADT_TOTAL	`aadt_total`	esriFieldTypeInteger	Measure of the Average Annual Daily Traffic in total (Includes cars and trucks)
AADT_BC_TRUCK	`aadt_bc_truck`	esriFieldTypeInteger	Avearage Annual Truck Traffic (Includes all trucks single units and combination units)
ESAL	`esal`	esriFieldTypeDouble	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
AVG_IRI	`avg_iri`	esriFieldTypeInteger	International Roughness Index (IRI) average, aggregated per PCR section. IRI is measured as vertical inches traveled over a linear mile.
LEFT_MUNI_NAME	`left_muni_name`	esriFieldTypeString	Municipality located to the left of the roadway segment while traveling in the cardinal direction
CITY_NAME	`city_name`	esriFieldTypeString	Name of the City within Ohio
LEFT_TWP_NAME	`left_twp_name`	esriFieldTypeString	Township Name
TOWNSHIP_NAME	`township_name`	esriFieldTypeString	Township located to the left of the roadway segment while traveling in the cardinal direction
(feature geometry)	`geom`	`ST_Multi(ST_SetSRID(ST_GeomFromGeoJSON(…), 4326))`	Feature geometry, WGS84

Geometry

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

Local Road Pavement Condition by County