Name: Rest Areas
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Rest Areas

Point feature class file providing the location, description, and contact information of the Iowa Department of Transportation's Rest and Parking Facilities as well as Weigh Areas. (2015)
Organization: State of Iowa
Last updated: 2024-04-12T12:52:41.013255
Tags: asset-inventory, assets, inventory

Tables

Table 1

@usgov.state_of_iowa_rest_areas_data.table_1

37.05 kB
33 rows
45 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "inventory_id" VARCHAR,
  "address" VARCHAR,
  "nearest_city" VARCHAR,
  "cost_center" BIGINT,
  "year_built" BIGINT,
  "areq_sqft" BIGINT  -- Areq (SQFT),
  "building_type" VARCHAR,
  "county_number" BIGINT,
  "rest_area_name" VARCHAR,
  "route" VARCHAR,
  "milepost" BIGINT,
  "ada_facilities" VARCHAR  -- ADA Facilities?,
  "family_restroom" VARCHAR  -- Family Restroom?,
  "public_phone" VARCHAR  -- Public Phone?,
  "weather" VARCHAR,
  "rv_dump" VARCHAR  -- RV Dump?,
  "vending" VARCHAR  -- Vending?,
  "wifi" VARCHAR,
  "travel_direction" VARCHAR,
  "facility_type" VARCHAR,
  "number_of_car_parking" BIGINT,
  "number_of_ada_parking" BIGINT,
  "number_of_truck_parking" BIGINT,
  "trailer_parking" VARCHAR  -- Trailer Parking?,
  "restrooms" VARCHAR  -- Restrooms?,
  "picnic" VARCHAR,
  "pet_area" VARCHAR  -- Pet Area?,
  "remarks" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "globalid" VARCHAR,
  "route_id" VARCHAR,
  "record_created_by" VARCHAR,
  "record_created_on_utc" VARCHAR  -- Record Created On (UTC),
  "record_edited_by" VARCHAR,
  "record_last_updated_utc" VARCHAR  -- Record Last Updated (UTC),
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "date_record_created_utc_offset" VARCHAR,
  "date_record_last_updated_utc_offset" VARCHAR,
  "date_record_last_verified_utc_offset" VARCHAR,
  "oversize_overweight_parking" BIGINT,
  "change_station" DOUBLE
);