About this Dataset

Park And Ride System

This dataset provides information on Iowa's Park and Ride System including existing state-owned park and ride facilities and ideal candidates for future expansion of the system. The inventory and identification of ideal candidates for future expantion is part of the Iowa Park and Ride System Plan. The primary objective of the plan is to provide a location-specific, priority-based park and ride system that allows for coordinated planning and implementation of park and ride facilities. As part of coordinating the statewide rideshare program, the dataset may also include other existing park and ride facilities not owned by the state or identified in the plan.
Organization: State of Iowa
Last updated: 2024-04-12T12:49:39.931565
Tags: asset-inventory, assets, inventory, park-and-ride, ridesharing, statewide

Tables

Table 1

@usgov.state_of_iowa_park_and_ride_system_data.table_1

40.89 kB
50 rows
46 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "district" BIGINT,
  "mpo_number" BIGINT,
  "rpa_number" BIGINT,
  "area_sqft" DOUBLE  -- Area (SqFt),
  "location" VARCHAR,
  "lot_sign" VARCHAR,
  "gas" VARCHAR,
  "fixed_route_transit" VARCHAR,
  "intercity" VARCHAR,
  "bus_stop" VARCHAR,
  "bike_rack" VARCHAR,
  "notes" VARCHAR,
  "city_number" BIGINT,
  "status" BIGINT,
  "jurisdiction" BIGINT,
  "transit_id" BIGINT,
  "property_contact" VARCHAR,
  "surface_type" BIGINT,
  "access_road" VARCHAR,
  "estimated_spaces" BIGINT,
  "bus_shelter" VARCHAR,
  "trash_recycling" VARCHAR,
  "lease" BIGINT,
  "park_and_ride_id" BIGINT,
  "deed_holder" VARCHAR,
  "restrictions" VARCHAR,
  "lighting" BIGINT,
  "estimated_usage" BIGINT,
  "transit_website" VARCHAR,
  "express_bus" VARCHAR,
  "photograph" VARCHAR,
  "handicap_access" DOUBLE,
  "county_number" BIGINT,
  "transit_provider_common_name" VARCHAR,
  "transit_provider_official_name" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "globalid" VARCHAR,
  "add_date_utc" VARCHAR  -- Add Date (UTC),
  "add_by" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date_utc" VARCHAR  -- Modified Date (UTC)
);