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

About this Dataset

Regional Transit Areas

Locations of the rural transit agencies in Iowa.
Organization: State of Iowa
Last updated: 2024-04-12T12:50:13.788281
Tags: assets, inventory, mobility-managers, transit

Tables

Table 1

@usgov.state_of_iowa_regional_transit_areas_data.table_1

432.52 kB
16 rows
35 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "system_id" BIGINT,
  "system_name" VARCHAR,
  "manager" VARCHAR,
  "entity_name" VARCHAR,
  "address_1" VARCHAR  -- Address (1),
  "address_2" VARCHAR  -- Address (2),
  "city_name" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "phone" VARCHAR,
  "fax" VARCHAR,
  "route_phone" VARCHAR,
  "email" VARCHAR,
  "service_area" VARCHAR,
  "original_structure" VARCHAR,
  "highlights" VARCHAR,
  "hours" VARCHAR,
  "fares" VARCHAR,
  "system_code" BIGINT,
  "service_type" VARCHAR,
  "transit_region" BIGINT,
  "transit_service_url" VARCHAR,
  "dot_administrator" VARCHAR,
  "transit_geometry_id" BIGINT,
  "entity_id" BIGINT,
  "common_name" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "area_acres_state_plane" DOUBLE  -- Area (Acres - State Plane),
  "permiter_meter_state_plane" DOUBLE  -- Permiter (Meter - State Plane),
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);