Truck Parking Locations - Alternative Service Location

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id p594-nfrt
Name Truck Parking Locations - Alternative Service Location
Attribution Iowa DOT, HDR Engineering
Category Transportation & Utilities
Tags asset, classification, rest, area, truck, parking, iowa dot, iowa department of transportation
Created 2016-08-19T20:15:41Z
Publication Date 2016-08-19T20:18:26Z

Description

Iowa Department of Transportation statewide rest area data. This layer displays alternative service locations with truck parking.

Columns

| Included | Schema Type    | Field Name                | Name                      | Data Type | Render Type |
| ======== | ============== | ========================= | ========================= | ========= | =========== |
| No       | time           | :updated_at               | updated_at                | meta_data | meta_data   |
| Yes      | series tag     | objectid                  | OBJECTID                  | text      | number      |
| Yes      | series tag     | facility_id               | Facility_ID               | text      | text        |
| Yes      | series tag     | place                     | Place                     | text      | text        |
| Yes      | series tag     | category                  | Category                  | text      | text        |
| Yes      | series tag     | interstate_number         | Interstate_Number         | text      | text        |
| Yes      | series tag     | exit_number               | Exit_Number               | text      | text        |
| Yes      | series tag     | area_type                 | Area_Type                 | text      | text        |
| No       |                | address                   | Address                   | text      | text        |
| Yes      | series tag     | city                      | City                      | text      | text        |
| Yes      | series tag     | state                     | State                     | text      | text        |
| Yes      | series tag     | zip_code                  | Zip_Code                  | text      | number      |
| Yes      | series tag     | phone_number              | Phone_Number              | text      | text        |
| Yes      | series tag     | surveyed                  | Surveyed                  | text      | text        |
| Yes      | series tag     | hours_24                  | Hours_24                  | text      | text        |
| Yes      | series tag     | hours_operate             | Hours_Operate             | text      | text        |
| Yes      | series tag     | accessible                | Accessible                | text      | text        |
| Yes      | series tag     | cars_truck                | Cars_Truck                | text      | text        |
| Yes      | series tag     | truck_parking             | Truck_Parking             | text      | text        |
| Yes      | series tag     | free_prkng                | Free_Prkng                | text      | text        |
| Yes      | series tag     | car_spaces                | Car_Spaces                | text      | text        |
| Yes      | series tag     | truck_spaces              | Truck_Spaces              | text      | text        |
| Yes      | numeric metric | handi_spaces              | Handi_Spaces              | number    | text        |
| Yes      | series tag     | busy_day_truck            | Busy_Day_Truck            | text      | text        |
| Yes      | series tag     | busy_time_truck           | Busy_Time_Truck           | text      | text        |
| Yes      | series tag     | busy_season_truck         | Busy_Season_Truck         | text      | text        |
| Yes      | series tag     | busy_day_car              | Busy_Day_Car              | text      | text        |
| Yes      | series tag     | busy_time_car             | Busy_Time_Car             | text      | text        |
| Yes      | series tag     | busy_season_car           | Busy_Season_Car           | text      | text        |
| Yes      | series tag     | car_holiday_wknd          | Car_Holiday_Wknd          | text      | text        |
| Yes      | series tag     | hr_prkng_24               | Hr_Prkng_24               | text      | text        |
| Yes      | series tag     | parking_hours             | Parking_Hours             | text      | text        |
| Yes      | series tag     | car_trk_pernight          | Car_Trk_PerNight          | text      | text        |
| Yes      | series tag     | trck_full                 | Trck_Full                 | text      | text        |
| Yes      | series tag     | restrooms                 | Restrooms                 | text      | text        |
| Yes      | series tag     | family_restroom           | Family_Restroom           | text      | text        |
| Yes      | series tag     | telephone                 | Telephone                 | text      | text        |
| Yes      | series tag     | tdd                       | TDD                       | text      | text        |
| Yes      | series tag     | wi_fi                     | Wi_Fi                     | text      | text        |
| Yes      | series tag     | wi_fi_free                | Wi_Fi_Free                | text      | text        |
| Yes      | series tag     | wi_fi_price               | Wi_Fi_Price               | text      | text        |
| Yes      | series tag     | travel_info               | Travel_Info               | text      | text        |
| Yes      | series tag     | rv_dump                   | RV_Dump                   | text      | text        |
| Yes      | series tag     | elect_veh_charge          | Elect_Veh_Charge          | text      | text        |
| Yes      | series tag     | elect_free                | Elect_Free                | text      | text        |
| Yes      | series tag     | picnic                    | Picnic                    | text      | text        |
| Yes      | series tag     | pet_exercise              | Pet_Exercise              | text      | text        |
| Yes      | series tag     | food_purchase             | Food_Purchase             | text      | text        |
| Yes      | series tag     | dot_tech_partner          | DOT_Tech_Partner          | text      | text        |
| Yes      | series tag     | other_services            | Other_Services            | text      | text        |
| Yes      | series tag     | name_request              | Name_Request              | text      | text        |
| Yes      | series tag     | email_request             | Email_Request             | text      | text        |
| Yes      | series tag     | future_question           | Future_Question           | text      | text        |
| Yes      | series tag     | location_facility_id      | Location_Facility_ID      | text      | text        |
| Yes      | numeric metric | approx_number_truck_space | Approx_Number_Truck_Space | number    | number      |
| Yes      | numeric metric | truck_percent_utili       | Truck_Percent_Utili       | number    | number      |
| Yes      | series tag     | truck_perc_group          | Truck_Perc_Group          | text      | text        |
| Yes      | series tag     | aslsummshort              | ASLSummShort              | text      | text        |

Time Field

Value = updated_at
Format & Zone = seconds

Series Fields

Excluded Fields = address

Data Commands

series e:p594-nfrt d:2016-08-19T20:15:41.000Z t:truck_perc_group=75-99% t:surveyed=No t:state=Iowa t:interstate_number="35 & 80" t:truck_spaces=40 t:facility_id="I-35 & 80 Exit-136, ID-4" t:food_purchase=Yes t:restrooms="Yes - Unknown" t:city="Des Moines" t:area_type="Urban Area" t:exit_number=136 t:truck_parking=Yes t:category="Gasoline Stations with Convenience Stores" t:location_facility_id="I-35 & 80 Exit-136, ID-4" t:accessible=Yes t:hours_24=Yes t:aslsummshort=RR_Not24hr t:travel_info=Unknown t:place="QUIKTRIP CORP" t:objectid=4 t:cars_truck=Yes m:approx_number_truck_space=40 m:truck_percent_utili=75

series e:p594-nfrt d:2016-08-19T20:15:41.000Z t:dot_tech_partner=N/A t:phone_number=5152761509 t:rv_dump=Yes t:hr_prkng_24=Yes t:parking_hours=N/A t:food_purchase=Yes t:car_trk_pernight=N/A t:city="Des Moines" t:exit_number=126 t:wi_fi=No t:car_holiday_wknd=No t:busy_season_car=Summer t:location_facility_id="I-35 & 80 Exit-126, ID-1" t:hours_operate=NA t:free_prkng=Yes t:pet_exercise=No t:place="PILOT TRAVEL CENTERS LLC" t:car_spaces=40 t:wi_fi_free="Not Free" t:busy_day_truck=Weekends t:elect_veh_charge=No t:wi_fi_price="$4.79 day" t:busy_season_truck=Winter t:elect_free=N/A t:category="Other Gasoline Stations" t:trck_full=Yes-Weekends t:hours_24=Yes t:travel_info=No t:objectid=14 t:cars_truck=Both t:picnic=No t:zip_code=50322 t:state=Iowa t:interstate_number="35 & 80" t:truck_spaces=75 t:facility_id="I-35 & 80 Exit-126, ID-1" t:restrooms="Yes - 24 Hours" t:area_type="Urban Area" t:busy_day_car=Wednesdays t:accessible=Yes t:aslsummshort=24hr_RR_TP t:other_services="Restaurant/Food Service" t:truck_perc_group=75-99% t:busy_time_truck="Fri nights" t:surveyed=Yes t:family_restroom=No t:email_request=No t:tdd=Yes t:truck_parking=Yes t:busy_time_car=Noon t:name_request="Charles Sang" t:telephone=Yes m:approx_number_truck_space=75 m:handi_spaces=12 m:truck_percent_utili=85

series e:p594-nfrt d:2016-08-19T20:15:41.000Z t:dot_tech_partner=No t:phone_number=5152767437 t:rv_dump=No t:hr_prkng_24=No t:parking_hours="Only trucks--any time" t:food_purchase=Yes t:car_trk_pernight=200 t:city=Clive t:exit_number=125 t:wi_fi=No t:car_holiday_wknd=No t:busy_season_car=Summer t:location_facility_id="I-35 & 80 Exit-125, ID-2" t:hours_operate=NA t:free_prkng=Yes t:pet_exercise=Yes t:place="Love's Travel Stop" t:car_spaces=130 t:wi_fi_free="Not Free" t:busy_day_truck=Tuesday-Wednesday t:elect_veh_charge=No t:wi_fi_price="AT&T provides it--not sure" t:busy_season_truck=Summer t:elect_free=N/A t:category="Gas Station/Conveinece" t:trck_full="Yes--3 nights/week" t:hours_24=Yes t:travel_info=No t:objectid=17 t:cars_truck=Both t:picnic=No t:zip_code=50325 t:state=Iowa t:interstate_number="35 & 80" t:truck_spaces=250 t:facility_id="I-35 & 80 Exit-125, ID-2" t:restrooms="Yes - 24 Hours" t:area_type="Urban Area" t:busy_day_car=Varies t:accessible=Yes t:aslsummshort=24hr_RR_TP t:other_services=No t:truck_perc_group=75-99% t:busy_time_truck=Varies t:surveyed=Yes t:family_restroom=Yes t:email_request=store411@love.com t:tdd=Yes t:truck_parking=Yes t:busy_time_car=Day t:name_request="? Long" t:telephone=Yes m:approx_number_truck_space=250 m:handi_spaces=6 m:truck_percent_utili=90

Meta Commands

metric m:handi_spaces p:integer l:Handi_Spaces d:"Handicap Parking Spaces" t:dataTypeName=number

metric m:approx_number_truck_space p:integer l:Approx_Number_Truck_Space d:"Appoximate Number of Truck Spaces" t:dataTypeName=number

metric m:truck_percent_utili p:integer l:Truck_Percent_Utili d:"Truck Utilization Percent" t:dataTypeName=number

entity e:p594-nfrt l:"Truck Parking Locations - Alternative Service Location" t:attribution="Iowa DOT, HDR Engineering" t:url=https://data.iowa.gov/api/views/p594-nfrt

property e:p594-nfrt t:meta.view v:id=p594-nfrt v:category="Transportation & Utilities" v:averageRating=0 v:name="Truck Parking Locations - Alternative Service Location" v:attribution="Iowa DOT, HDR Engineering"

property e:p594-nfrt t:meta.view.owner v:id=2cmj-63jw v:profileImageUrlMedium=/api/users/2cmj-63jw/profile_images/THUMB v:profileImageUrlLarge=/api/users/2cmj-63jw/profile_images/LARGE v:screenName="Iowa Department of Transportation" v:profileImageUrlSmall=/api/users/2cmj-63jw/profile_images/TINY v:displayName="Iowa Department of Transportation"

property e:p594-nfrt t:meta.view.tableauthor v:id=2cmj-63jw v:profileImageUrlMedium=/api/users/2cmj-63jw/profile_images/THUMB v:profileImageUrlLarge=/api/users/2cmj-63jw/profile_images/LARGE v:screenName="Iowa Department of Transportation" v:profileImageUrlSmall=/api/users/2cmj-63jw/profile_images/TINY v:roleName=administrator v:displayName="Iowa Department of Transportation"

Top Records

| :updated_at | objectid | facility_id              | place                            | category                                  | interstate_number | exit_number | area_type  | address                                     | city            | state | zip_code | phone_number | surveyed | hours_24 | hours_operate | accessible | cars_truck | truck_parking | free_prkng | car_spaces | truck_spaces                                                    | handi_spaces | busy_day_truck    | busy_time_truck | busy_season_truck | busy_day_car    | busy_time_car | busy_season_car | car_holiday_wknd | hr_prkng_24      | parking_hours         | car_trk_pernight    | trck_full          | restrooms      | family_restroom | telephone | tdd | wi_fi | wi_fi_free | wi_fi_price                | travel_info | rv_dump | elect_veh_charge | elect_free | picnic | pet_exercise | food_purchase | dot_tech_partner      | other_services                                            | name_request  | email_request     | future_question | location_facility_id     | approx_number_truck_space | truck_percent_utili | truck_perc_group | aslsummshort  | 
| =========== | ======== | ======================== | ================================ | ========================================= | ================= | =========== | ========== | =========================================== | =============== | ===== | ======== | ============ | ======== | ======== | ============= | ========== | ========== | ============= | ========== | ========== | =============================================================== | ============ | ================= | =============== | ================= | =============== | ============= | =============== | ================ | ================ | ===================== | =================== | ================== | ============== | =============== | ========= | === | ===== | ========== | ========================== | =========== | ======= | ================ | ========== | ====== | ============ | ============= | ===================== | ========================================================= | ============= | ================= | =============== | ======================== | ========================= | =================== | ================ | ============= | 
| 0           | 4        | I-35 & 80 Exit-136, ID-4 | QUIKTRIP CORP                    | Gasoline Stations with Convenience Stores | 35 & 80           | 136         | Urban Area | 4801 N.E. 14TH ST, Des Moines, IA           | Des Moines      | Iowa  |          |              | No       | Yes      |               | Yes        | Yes        | Yes           |            |            | 40                                                              |              |                   |                 |                   |                 |               |                 |                  |                  |                       |                     |                    | Yes - Unknown  |                 |           |     |       |            |                            | Unknown     |         |                  |            |        |              | Yes           |                       |                                                           |               |                   |                 | I-35 & 80 Exit-136, ID-4 | 40                        | 75                  | 75-99%           | RR_Not24hr    | 
| 0           | 14       | I-35 & 80 Exit-126, ID-1 | PILOT TRAVEL CENTERS LLC         | Other Gasoline Stations                   | 35 & 80           | 126         | Urban Area | 11957 Douglas Avenue, Des Moines, IA, 50322 | Des Moines      | Iowa  | 50322    | 5152761509   | Yes      | Yes      | NA            | Yes        | Both       | Yes           | Yes        | 40         | 75                                                              | 12           | Weekends          | Fri nights      | Winter            | Wednesdays      | Noon          | Summer          | No               | Yes              | N/A                   | N/A                 | Yes-Weekends       | Yes - 24 Hours | No              | Yes       | Yes | No    | Not Free   | $4.79 day                  | No          | Yes     | No               | N/A        | No     | No           | Yes           | N/A                   | Restaurant/Food Service                                   | Charles Sang  | No                |                 | I-35 & 80 Exit-126, ID-1 | 75                        | 85                  | 75-99%           | 24hr_RR_TP    | 
| 0           | 17       | I-35 & 80 Exit-125, ID-2 | Love's Travel Stop               | Gas Station/Conveinece                    | 35 & 80           | 125         | Urban Area | 11820 Hickman Road, Clive, IA 50325         | Clive           | Iowa  | 50325    | 5152767437   | Yes      | Yes      | NA            | Yes        | Both       | Yes           | Yes        | 130        | 250                                                             | 6            | Tuesday-Wednesday | Varies          | Summer            | Varies          | Day           | Summer          | No               | No               | Only trucks--any time | 200                 | Yes--3 nights/week | Yes - 24 Hours | Yes             | Yes       | Yes | No    | Not Free   | AT&T provides it--not sure | No          | No      | No               | N/A        | No     | Yes          | Yes           | No                    | No                                                        | ? Long        | store411@love.com |                 | I-35 & 80 Exit-125, ID-2 | 250                       | 90                  | 75-99%           | 24hr_RR_TP    | 
| 0           | 21       | I-29 & 80 Exit-3, ID-1   | TRAVEL CENTERS OF AMERICA        | Other Gasoline Stations                   | 29 & 80           | 3           | Urban Area | 3210 S. 7th St                              | Council Bluffs  | Iowa  | 51501    | 712-366-2217 | No       |          |               |            |            | Yes           |            |            |                                                                 |              |                   |                 |                   |                 |               |                 |                  |                  |                       |                     |                    | Yes - Unknown  |                 |           |     |       |            |                            | Unknown     |         |                  |            |        |              | Yes           |                       |                                                           |               |                   |                 | I-29 & 80 Exit-3, ID-1   | 95                        | 80                  | 75-99%           | RR_Not24hr    | 
| 0           | 29       | I-29 & 80 Exit-1B, ID-3  | PILOT TRAVEL CENTERS LLC         | Other Gasoline Stations                   | 29 & 80           | 1B          | Urban Area | 2647 S. 24th St                             | Council Bluffs  | Iowa  | 51501    | 712-322-0088 | Yes      | Yes      |               | Yes        | Both       | Yes           | Yes        | 40         | 70                                                              | 10           | Weds-Sun          | 9am-1pm         | Summer            | Sunday          | 11/01/2012    | Summer          | Yes              | Yes [more below] |                       | 70 trucks, 5 cars   | Yes, often         | Yes - 24 Hours | Yes             | Yes       | No  | Yes   | Not Free   | $2.99/day                  | Yes         | No      | No               | N/A        |        | No           | Yes           | No/Corporate question |                                                           | Jason Brown   | No                | Yes             | I-29 & 80 Exit-1B, ID-3  | 70                        | 90                  | 75-99%           | 24hr_RR_TP_TI | 
| 0           | 30       | I-29 & 80 Exit-1B, ID-4  | SAPP BROS TRUCK STOPS            | Other Gasoline Stations                   | 29 & 80           | 1B          | Urban Area | 2608 S. 24th St                             | Council Bluffs  | Iowa  | 51501    | 712-322-3000 | Yes      | Yes      |               | Yes        | Both       | Yes           | Yes        | 55         | 110                                                             | 8            | Friday            | Afternoon       | Winter            | Thursday        | 3pm-8pm       | Summer          | Yes              | Yes [more below] |                       | 75 trucks, 20 cars  | No                 | Yes - 24 Hours | No              | Yes       | No  | Yes   | Free       |                            | Yes         | No      | No               | N/A        |        | Yes          | Yes           | No/Corporate question | D.A.T load board, laundry, showers, fax, ATM, restaurants | Susan West    | No                | Yes             | I-29 & 80 Exit-1B, ID-4  | 110                       | 85                  | 75-99%           | 24hr_RR_TP_TI | 
| 0           | 37       | I-380 Exit-68, ID-1      | FLYING J TRAVEL PLAZA            | Gasoline Stations with Convenience Stores | 380               | 68          | Rural Area | 445 Evansdale Dr                            | Elk Run Heights | Iowa  | 50707    | 319-291-7714 | No       |          |               |            |            | Yes           |            |            |                                                                 |              |                   |                 |                   |                 |               |                 |                  |                  |                       |                     |                    | Yes - Unknown  |                 |           |     |       |            |                            | Unknown     |         |                  |            |        |              | Yes           |                       |                                                           |               |                   |                 | I-380 Exit-68, ID-1      | 105                       | 75                  | 75-99%           | RR_Not24hr    | 
| 0           | 38       | I-380 Exit-68, ID-2      | ROAD RANGER                      | Gasoline Stations with Convenience Stores | 380               | 68          | Urban Area | 100 Plaza Dr                                | Elk Run Heights | Iowa  | 50707    | 815-315-0271 | Yes      | Yes      |               | Yes        | Both       | Yes           | Yes        | 20         | 200                                                             | 4            | Tues-Thurs        | after 5pm       | Summer            | Friday          | after 2pm     | Summer          | Yes              | Yes [more below] |                       | 10 cars, 100 trucks | Yes, often         | Yes - 24 Hours | Yes             | No        |     | Yes   | Not Free   | $4.99/day                  | No          | No      | No               | N/A        |        | No           | Yes           | No/Corporate question | Restaurants                                               | Brenda Hanson | No                | Yes             | I-380 Exit-68, ID-2      | 200                       | 85                  | 75-99%           | 24hr_RR_TP    | 
| 0           | 42       | I-380 Exit-35, ID-1      | CENTER POINT TRAVEL PLAZA        | Gasoline Stations with Convenience Stores | 380               | 35          | Urban Area | 696 Grain Lane                              | Center Point    | Iowa  | 52213    | 319-849-2700 | Yes      | Yes      |               | Yes        | Both       | Yes           | Yes        | 90         | 100                                                             | 6            | Weekdays          | 9-11am          | Summer            | Friday-Saturday | 5-6pm         | Summer          | No               | Yes [more below] |                       | 120 trucks, 50 car  | Yes, often         | Yes - 24 Hours | No              | Yes       | No  | Yes   | Free       |                            | Yes         | Yes     | No               | N/A        |        | Yes          | Yes           | No/Corporate question | Scale, fax, showers and laundry, restaurants              | Brian Maloney | No                | Yes             | I-380 Exit-35, ID-1      | 100                       | 70                  | 0-74%            | 24hr_RR_TP_TI | 
| 0           | 64       | I-380 Exit-13, ID-2      | JUST DIESEL/CASEYS GENERAL STORE | Gasoline Stations with Convenience Stores | 380               | 13          | Urban Area | 9001 6th St SW                              | Cedar Rapids    | Iowa  | 52404    | 319-841-9244 | Yes      | Yes      |               | Yes        | Both       | Yes           | Yes        | 30         | 55 (currently expanding to 95, which should be done in October) | 2            | Wednesday         | Noon            | Summer            | Friday          | Noon          | Summer          | Yes              | Yes [more below] |                       | 55 trucks, 5 cars   | Yes, not often     | Yes - 24 Hours | No              | Yes       | No  | Yes   | Free       |                            | Yes         | No      | No               | N/A        |        | No           | Yes           | No/Corporate question | Showers and laundry                                       | Kevin Temple  | No                | Yes             |                          |                           |                     |                  | 24hr_RR_TP_TI |