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

About this Dataset

Parking 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:49:42.531688
Tags: asset-inventory, assets, inventory

Tables

Table 1

@usgov.state_of_iowa_parking_areas_data.table_1

33.48 kB
14 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" DOUBLE,
  "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" BIGINT
);