This document summarizes the data collected for use in the KY Statewide Truck Parking Study. It includes an initial summary and overview of the available data. Use the layer button in the maps below to turn layers on/off and to change the background basemap.

Parking_Facilities

Received via email on 2021-01-29

  • 371 facilities total
    • Note that the “facilities” also include interchanges
    • The dataset was collected by KYTC ADDs
  • 158 facilities with spaces > 0; We should treat this as the starting point for “Truck Parking Facilities” in KY.
  • Key attributes include: marked spaces, additional spaces, ownership, route type and yes/no for multiple amenities.
  • Assume all spaces refer to truck spaces, but need to confirm

The map displays parking facility locations (black) dots and total number of spaces (red).

## # A tibble: 1 x 1
##       n
##   <int>
## 1   371
## Rows: 371
## Columns: 28
## $ OBJECTID   <dbl> 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, ...
## $ RT_NE_UNIQ <chr> "024-EB-9004  -000", "056-I -0064  -000", "056-I -0265  ...
## $ BEGIN_MP   <dbl> 7.915, 8.065, 13.540, 9.347, 82.030, 12.232, 4.713, 17.9...
## $ EXIT_NUMBE <chr> "8", "8", "14", "9", "82", "12", "5", "18", "27", "11", ...
## $ ROUTE      <chr> "EB", "I-64", "I-265", "EB", "I-275", "I-264", "I-471", ...
## $ COUNTY     <chr> "CHRISTIAN", "JEFFERSON", "JEFFERSON", "CHRISTIAN", "KEN...
## $ OWNR       <chr> "PUBLIC", "PUBLIC", "PUBLIC", "PUBLIC", "PUBLIC", "PRIVA...
## $ NAME       <chr> "NO TRUCK PARKING", "URBAN AREA - LIMITED SERVICES - NO ...
## $ RTE_TYPE   <chr> "PARKWAY", "INTERSTATE", "INTERSTATE", "PARKWAY", "INTER...
## $ TYPE       <chr> "GEN_SVC_EXT", "URBAN_NO_SVC", "URBAN_NO_SVC", "GEN_SVC_...
## $ MARKED_SPA <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3,...
## $ ADD_SPACES <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0...
## $ TOT_SPACES <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3...
## $ HANDICAP   <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ DIESEL_FUE <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 1, 0, 0, 0, 0, 0,...
## $ LODGING    <chr> "NO", "NO", "NO", "NO", "NO", "YES", "NO", "NO", "YES", ...
## $ HOSPITAL   <chr> "NO", "NO", "NO", "YES", "YES", "YES", "NO", "NO", "NO",...
## $ VENDING    <chr> "YES", "NO", "NO", "NO", "NO", "YES", "NO", "NO", "YES",...
## $ RESTAURANT <chr> "NO", "NO", "NO", "NO", "NO", "YES", "NO", "NO", "YES", ...
## $ PAYPHONE   <chr> "YES", "NO", "NO", "NO", "NO", "YES", "NO", "NO", "NO", ...
## $ RESTROOMS  <chr> "YES", "NO", "NO", "YES", "NO", "YES", "NO", "NO", "YES"...
## $ TRUCK_PARK <chr> "NO", "NO", "NO", "NO", "NO", "NO", "NO", "NO", "YES", "...
## $ SERVICES   <chr> "YES", "NO", "NO", "YES", "NO", "YES", "NO", "NO", "YES"...
## $ Status     <chr> "Services But No Parking", "No parking and No Services",...
## $ COMMENTS   <chr> NA, "NO TRUCK SERVICES", "NO TRUCK SERVICES", NA, "NO TR...
## $ ADD_       <chr> "PENNYRILE", "KIPDA", "KIPDA", "PENNYRILE", "NORTHERN KE...
## $ LOC_ERROR  <chr> "NO ERROR", "NO ERROR", "NO ERROR", "NO ERROR", "NO ERRO...
## $ geometry   <POINT [m]> POINT (1347242 1058114), POINT (1504324 1212414), ...
## Legend for symbol sizes not available in view mode.

Welcome_Centers

Received via email on 2021-01-29

  • 8 welcome centers
  • Key attributes include similar information to parking facility list

The map displays welcome center locations (black) dots and total number of marked spaces (red).

## Rows: 8
## Columns: 22
## $ OBJECTID   <dbl> 1, 2, 3, 4, 5, 6, 7, 8
## $ COUNTY_NAM <chr> "Boone", "Bullitt", "Carter", "Christian", "McCracken", ...
## $ BEGIN_MP   <dbl> 176.800, 113.300, 173.300, 92.500, 6.865, 1.700, 28.600,...
## $ END_MP     <dbl> 176.800, 113.300, 173.300, 92.500, 6.865, 1.700, 28.600,...
## $ AGENCY     <chr> "Tourism", "Tourism", "Tourism", "Tourism", "Tourism", "...
## $ STREET_ADD <chr> "Boone County (Florence) Welcome Center southbound", "Bu...
## $ ROUTE      <chr> "I-75", "I-65", "I-64", "I-24", "I-24", "I-75", "I-64", ...
## $ EXIT_MP    <dbl> 177, 113, 173, 96, 7, 2, 29, 0
## $ FAC_TYPE   <chr> "WELCOME CENTER", "WELCOME CENTER", "WELCOME CENTER", "W...
## $ MARKED_SPA <int> 67, 28, 12, 38, 18, 40, 23, 32
## $ ADD_SPACE  <dbl> 0, 0, 0, 0, 0, 0, 0, 0
## $ HANDICAP   <dbl> 0, 0, 1, 2, 0, 0, 0, 1
## $ LODGING    <chr> "NO", "NO", "NO", "NO", "NO", "NO", "NO", "NO"
## $ HOSPITAL   <chr> "NO", "NO", "NO", "NO", "NO", "NO", "NO", "NO"
## $ VENDING    <chr> "YES", "YES", "YES", "YES", "YES", "YES", "YES", "YES"
## $ RESTAURANT <chr> "NO", "NO", "NO", "NO", "NO", "NO", "NO", "NO"
## $ PAYPHONE   <chr> "YES", "YES", "YES", "YES", "YES", "YES", "YES", "YES"
## $ RESTROOMS  <chr> "YES", "YES", "YES", "YES", "YES", "YES", "YES", "YES"
## $ COMMENTS   <chr> NA, NA, NA, NA, NA, NA, NA, NA
## $ DIESEL_FUE <dbl> 0, 0, 0, 0, 0, 0, 0, 0
## $ DIR        <chr> "SB", "SB", "WB", "WB", "EB", "NB", "EB", "NB"
## $ geometry   <POINT [m]> POINT (1596778 1289747), POINT (1505230 1179022), ...
## Legend for symbol sizes not available in view mode.

Trucker Path Facility Locations

Received via email on 2021-04-23

## Rows: 358
## Columns: 29
## $ title                 <chr> "Parking/RestArea", "Paid Parking", "Dirts Ya...
## $ highway               <chr> NA, NA, NA, NA, NA, "Western Kentucky Parkway...
## $ exit                  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N...
## $ location              <chr> "[-84.64853734917195, 38.86554038857241]", "[...
## $ wifi                  <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ overnightParking      <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FAL...
## $ scales                <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ tireCare              <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ rvDumpStations        <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ laundry               <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ gym                   <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ petFriendly           <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FAL...
## $ faxScanService        <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, FALSE, FAL...
## $ transfloExpress       <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ pool                  <lgl> FALSE, FALSE, FALSE, FALSE, FALSE, NA, FALSE,...
## $ address               <chr> "12504 McCoys Fork Rd", "490 Pendleton Rd", "...
## $ phone                 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N...
## $ state                 <chr> "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY...
## $ country               <chr> "US", "US", "US", "US", "US", "US", "US", "US...
## $ zip                   <dbl> 41094, 40055, 40218, 42055, 41056, 42320, 420...
## $ city                  <chr> "Walton", "Pendleton", "Louisville", "Kuttawa...
## $ fax                   <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N...
## $ opisId                <dbl> NA, NA, NA, NA, NA, 64003, NA, NA, NA, NA, NA...
## $ bulkDefCount          <dbl> NA, NA, NA, NA, NA, 8, NA, NA, NA, NA, NA, NA...
## $ atmCount              <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA...
## $ showerCount           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N...
## $ bulkDieselCount       <dbl> NA, NA, NA, NA, NA, 8, NA, NA, NA, NA, NA, NA...
## $ truckParkingSpotCount <dbl> NA, NA, NA, NA, NA, 30, NA, NA, NA, NA, NA, N...
## $ geometry              <POINT> POINT (-84.64854 38.86554), POINT (-85.2978...
## Warning: Currect projection of shape TruckerPath unknown. Long-lat (WGS84) is
## assumed.
## Legend for symbol sizes not available in view mode.

Jason’s Law

Downloaded on 2021-02-01

The map displays welcome 2015 locations (black) and 2019 locations (red).

2015 Data (Public and Private)

## Rows: 276
## Columns: 25
## $ Type       <chr> "Private", "Private", "Private", "Private", "Private", "...
## $ St         <chr> "IN", "IN", "IN", "KY", "KY", "KY", "KY", "KY", "KY", "K...
## $ Rest_Area  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ Rte        <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ MP         <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ Mun        <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ Co         <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ Lat        <dbl> 37.93019, 38.15920, 39.04081, 36.76375, 37.84278, 36.877...
## $ Long       <dbl> -87.90262, -87.68263, -85.10128, -83.71157, -84.32954, -...
## $ Total_Spac <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ Truck_Spac <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ Hours      <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ Limit      <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ Comment    <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ Rest_Stop  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ STATEFP    <chr> "21", "21", "21", "21", "21", "21", "21", "21", "21", "2...
## $ STATENS    <chr> "01779786", "01779786", "01779786", "01779786", "0177978...
## $ AFFGEOID   <chr> "0400000US21", "0400000US21", "0400000US21", "0400000US2...
## $ GEOID      <chr> "21", "21", "21", "21", "21", "21", "21", "21", "21", "2...
## $ STUSPS     <chr> "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY", "K...
## $ NAME       <chr> "Kentucky", "Kentucky", "Kentucky", "Kentucky", "Kentuck...
## $ LSAD       <chr> "00", "00", "00", "00", "00", "00", "00", "00", "00", "0...
## $ ALAND      <dbl> 102282218059, 102282218059, 102282218059, 102282218059, ...
## $ AWATER     <dbl> 2372611005, 2372611005, 2372611005, 2372611005, 23726110...
## $ geometry   <POINT [m]> POINT (1310785 1179405), POINT (1330646 1204394), ...

2019 Data (Public Only)

## Rows: 67
## Columns: 20
## $ State.numb <dbl> 11, 11, 11, 11, 12, 12, 12, 12, 15, 15, 15, 15, 15, 15, ...
## $ NHS.Rest.S <chr> "Fort Massac", "Skeeter Mountain WB", "Trail of Tears NB...
## $ Highway.Ro <chr> "I-24", "I-64WB", "I-57", "I-57", "I-64E", "I-65N", "I-6...
## $ Mile.Post  <chr> "1", "130", "32", "32", "7", "22", "22", "151", "1", "2"...
## $ Municipali <chr> "Metropolis", "Calvin", "Anna", "Anna", "Griffin", "Unde...
## $ County     <chr> "NA", "NA", "NA", "NA", "Posey", "Clark", "Clark", "Ripl...
## $ State      <chr> "IL", "IL", "IL", "IL", "IN", "IN", "IN", "IN", "KY", "K...
## $ Latitude   <dbl> 37.15925, 38.23206, 37.46576, 37.46939, 38.19443, 38.584...
## $ Longitude  <dbl> -88.68010, -87.98890, -89.13356, -89.13320, -87.86003, -...
## $ Number.of  <dbl> 18, 21, 20, 20, 16, 64, 64, 40, 3, 20, 43, 29, 50, 50, 5...
## $ STATEFP    <chr> "21", "21", "21", "21", "21", "21", "21", "21", "21", "2...
## $ STATENS    <chr> "01779786", "01779786", "01779786", "01779786", "0177978...
## $ AFFGEOID   <chr> "0400000US21", "0400000US21", "0400000US21", "0400000US2...
## $ GEOID      <chr> "21", "21", "21", "21", "21", "21", "21", "21", "21", "2...
## $ STUSPS     <chr> "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY", "K...
## $ NAME       <chr> "Kentucky", "Kentucky", "Kentucky", "Kentucky", "Kentuck...
## $ LSAD       <chr> "00", "00", "00", "00", "00", "00", "00", "00", "00", "0...
## $ ALAND      <dbl> 102282218059, 102282218059, 102282218059, 102282218059, ...
## $ AWATER     <dbl> 2372611005, 2372611005, 2372611005, 2372611005, 23726110...
## $ geometry   <POINT [m]> POINT (1239779 1095750), POINT (1304007 1213078), ...

KYTC Traffic Count Data

Downloaded from website on 2021-03-24: https://transportation.ky.gov/Planning/Pages/Centerlines.aspx

Line shapefile with ~20,000 roadway segment containing ADT data. Truck ADT is stored as two separate values: ADTSINGLE for single unit trucks and ADTCOMBO for combination unit trucks. This study will use the ADTCOMBO to reflect the type of truck most often used for long-haul truck parking.

## Rows: 19,920
## Columns: 45
## $ RT_UNIQUE  <chr> "030-AU-9005  -000", "030-AU-9005  -211", "030-AU-9005  ...
## $ BEGIN_MP   <dbl> 15.883, 0.000, 0.000, 0.000, 0.000, 0.000, 5.333, 10.141...
## $ END_MP     <dbl> 23.441, 0.377, 0.449, 0.464, 0.371, 5.333, 10.141, 15.88...
## $ D_BEGIN_MP <chr> "015.883", "000.000", "000.000", "000.000", "000.000", "...
## $ D_END_MP   <chr> "023.441", "000.377", "000.449", "000.464", "000.371", "...
## $ MILES      <dbl> 7.558, 0.377, 0.449, 0.464, 0.371, 5.333, 4.808, 5.742, ...
## $ GOV_LEVEL  <chr> "01", "01", "01", "01", "01", "01", "01", "01", "01", "0...
## $ D_GOV_LEVE <chr> "State Maintained Roads", "State Maintained Roads", "Sta...
## $ RT_DESCR   <chr> "AUDUBON PKWY", "AUDUBON PKWY RAMP to US 60", "AUDUBON P...
## $ DISTRICT   <dbl> 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 7, 7, 7,...
## $ D_DISTRICT <chr> "Madisonville", "Madisonville", "Madisonville", "Madison...
## $ CNTY_NAME  <chr> "Daviess", "Daviess", "Daviess", "Daviess", "Daviess", "...
## $ COUNTY     <dbl> 30, 30, 30, 30, 30, 51, 51, 51, 51, 51, 51, 51, 51, 51, ...
## $ RT_PREFIX  <chr> "AU", "AU", "AU", "AU", "AU", "AU", "AU", "AU", "AU", "A...
## $ D_RT_PREFI <chr> "Audubon Parkway", "Audubon Parkway", "Audubon Parkway",...
## $ RT_NUMBER  <dbl> 9005, 9005, 9005, 9005, 9005, 9005, 9005, 9005, 9005, 90...
## $ RT_SUFFIX  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ D_RT_SUFFI <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ RT_SECTION <dbl> 0, 211, 231, 232, 241, 0, 0, 0, 121, 131, 141, 142, 211,...
## $ D_RT_SECTI <chr> "Mainline", "Ramp", "Ramp", "Ramp", "Ramp", "Mainline", ...
## $ START_DATE <date> 2020-06-06, 2020-05-03, 2020-05-03, 2020-05-03, 2019-05...
## $ MODIFY_DT  <date> 2020-06-06, 2020-05-03, 2020-05-03, 2020-05-03, 2019-05...
## $ EXTRACT_DT <date> 2021-03-20, 2021-03-20, 2021-03-20, 2021-03-20, 2021-03...
## $ ADTSTATN   <chr> "030822", "030E46", "030E47", "030E51", "030E50", "05115...
## $ ADTSTYPE   <chr> "2", "5", "5", "5", "5", "2", "3", "2", "5", "5", "5", "...
## $ D_ADTSTYPE <chr> "Full Coverage", "Ramp or Rest Area", "Ramp or Rest Area...
## $ BEGDESC    <chr> "HENDERSON COUNTY LINE", NA, NA, NA, NA, "EDWARD T BREAT...
## $ ENDDESC    <chr> "US 60B BRIDGE", NA, NA, NA, NA, "KY 1078 UNDERPASS", "T...
## $ LASTCNT    <dbl> 9601, 3411, 966, 3891, 838, 9676, 8694, 9930, 1440, 3595...
## $ LASTCNTYR  <dbl> 2019, 2017, 2017, 2017, 2017, 2019, 2019, 2019, 2019, 20...
## $ ADTPRIOR   <dbl> 9601, 3256, 920, 3875, 754, 9676, 8694, 9930, 1440, 3595...
## $ ADTSRCE    <chr> "A", "C", "C", "C", "C", "A", "A", "A", "A", "A", "A", "...
## $ D_ADTSRCE  <chr> "Actual Count", "Computed Estimate", "Computed Estimate"...
## $ ADTSINGLE  <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1004,...
## $ ADTCOMBO   <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1838,...
## $ PCSINGOP   <dbl> 5.665, 0.000, 0.000, 0.000, 0.000, 10.431, 10.431, 10.43...
## $ PCCOMBOP   <dbl> 15.105, 0.000, 0.000, 0.000, 0.000, 11.762, 11.762, 11.7...
## $ PCSINGPK   <dbl> 0.434, 0.000, 0.000, 0.000, 0.000, 0.988, 0.988, 0.988, ...
## $ PCCOMBPK   <dbl> 0.802, 0.000, 0.000, 0.000, 0.000, 0.570, 0.570, 0.570, ...
## $ GROWTH_FAC <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ K_FACTOR   <dbl> 9.3, 8.8, 7.7, 8.4, 8.5, 8.6, 8.7, 9.2, 10.1, 10.4, 11.8...
## $ D_FACTOR   <dbl> 56, 56, 56, 56, 56, 56, 58, 51, 0, 56, 56, 0, 100, 100, ...
## $ AXLE_FACTO <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ GEOLOC_STL <dbl> 40127.094, 1992.355, 2371.839, 2450.327, 1957.427, 28452...
## $ geometry   <LINESTRING [US_survey_foot]> LINESTRING M (4474077 38026..., ...

Filtering out only roadway segments with ADTCOMBO > 10 results about 5,000 segments and the map below.

## Rows: 4,820
## Columns: 45
## $ RT_UNIQUE  <chr> "002-KY-0252  -000", "005-KY-0252  -000", "006-KY-0036  ...
## $ BEGIN_MP   <dbl> 4.061, 0.000, 0.890, 0.000, 7.407, 0.000, 5.739, 4.635, ...
## $ END_MP     <dbl> 4.978, 4.612, 6.970, 1.176, 14.478, 1.108, 7.415, 8.768,...
## $ D_BEGIN_MP <chr> "004.061", "000.000", "000.890", "000.000", "007.407", "...
## $ D_END_MP   <chr> "004.978", "004.612", "006.970", "001.176", "014.478", "...
## $ MILES      <dbl> 0.917, 4.612, 6.080, 1.176, 7.071, 1.108, 1.676, 4.133, ...
## $ GOV_LEVEL  <chr> "01", "01", "01", "01", "01", "01", "01", "01", "01", "0...
## $ D_GOV_LEVE <chr> "State Maintained Roads", "State Maintained Roads", "Sta...
## $ RT_DESCR   <chr> "BARREN RIVER DAM RD", "FINNEY RD", "KY-36", "KY-72", "K...
## $ DISTRICT   <dbl> 3, 3, 9, 11, 11, 7, 10, 10, 2, 6, 9, 7, 11, 3, 3, 9, 10,...
## $ D_DISTRICT <chr> "Bowling Green", "Bowling Green", "Flemingsburg", "Manch...
## $ CNTY_NAME  <chr> "Allen", "Barren", "Bath", "Bell", "Bell", "Bourbon", "B...
## $ COUNTY     <dbl> 2, 5, 6, 7, 7, 9, 13, 13, 17, 21, 22, 25, 26, 31, 31, 32...
## $ RT_PREFIX  <chr> "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY", "KY", "K...
## $ D_RT_PREFI <chr> "Kentucky Route", "Kentucky Route", "Kentucky Route", "K...
## $ RT_NUMBER  <dbl> 252, 252, 36, 72, 190, 1940, 28, 52, 293, 55, 59, 15, 66...
## $ RT_SUFFIX  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ D_RT_SUFFI <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
## $ RT_SECTION <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ D_RT_SECTI <chr> "Mainline", "Mainline", "Mainline", "Mainline", "Mainlin...
## $ START_DATE <date> 2020-05-03, 2020-05-03, 2020-05-03, 2020-05-03, 2020-05...
## $ MODIFY_DT  <date> 2020-05-03, 2020-05-03, 2020-05-03, 2020-05-03, 2020-05...
## $ EXTRACT_DT <date> 2021-03-20, 2021-03-20, 2021-03-20, 2021-03-20, 2021-03...
## $ ADTSTATN   <chr> "005505", "005505", "006750", "007004", "007751", "009A5...
## $ ADTSTYPE   <chr> "0", "3", "3", "3", "3", "3", "2", "2", "2", "2", "3", "...
## $ D_ADTSTYPE <chr> "In Adjacent County", "Classification", "Classification"...
## $ BEGDESC    <chr> "KY 1533", "ALLEN COUNTY LINE", "KY 11", "US 119", "KY 3...
## $ ENDDESC    <chr> "BARREN COUNTY LINE", "SETTLES ROAD/KY 255", "KY 1325", ...
## $ LASTCNT    <dbl> 612, 612, 737, 1292, 700, 768, 925, 1685, 1485, 478, 134...
## $ LASTCNTYR  <dbl> 2017, 2017, 2015, 2018, 2018, 2017, 2015, 2017, 2017, 20...
## $ ADTPRIOR   <dbl> 682, 682, 842, 1530, 761, 743, 981, 1853, 1557, 478, 136...
## $ ADTSRCE    <chr> "C", "C", "C", "C", "C", "C", "C", "C", "C", "A", "C", "...
## $ D_ADTSRCE  <chr> "Computed Estimate", "Computed Estimate", "Computed Esti...
## $ ADTSINGLE  <dbl> 34, 34, 48, 56, 45, 9, 158, 95, 21, 32, 37, 77, 17, 38, ...
## $ ADTCOMBO   <dbl> 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, 11, ...
## $ PCSINGOP   <dbl> 5.533, 5.533, 6.132, 4.335, 6.395, 1.235, 5.321, 1.738, ...
## $ PCCOMBOP   <dbl> 1.780, 1.780, 1.098, 0.815, 1.565, 0.880, 0.643, 1.300, ...
## $ PCSINGPK   <dbl> 0.935, 0.935, 0.783, 1.569, 0.495, 0.127, 0.827, 0.478, ...
## $ PCCOMBPK   <dbl> 0.523, 0.523, 0.237, 0.205, 0.069, 0.127, 0.115, 0.037, ...
## $ GROWTH_FAC <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ K_FACTOR   <dbl> 10.4, 10.4, 9.8, 10.0, 9.7, 11.1, 9.4, 9.2, 10.0, 11.3, ...
## $ D_FACTOR   <dbl> 57, 57, 56, 64, 56, 55, 57, 56, 56, 55, 56, 58, 56, 58, ...
## $ AXLE_FACTO <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,...
## $ GEOLOC_STL <dbl> 4617.589, 24626.331, 32092.594, 6201.469, 37284.065, 570...
## $ geometry   <LINESTRING [US_survey_foot]> LINESTRING M (4810895 34815..., ...

end