Name: RPA Boundaries
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

RPA Boundaries

This dataset provides the Regional Planning Association (RPA) boundaries for the State of Iowa including contact information, location details and more.
Organization: State of Iowa
Last updated: 2024-04-12T12:51:54.818853
Tags: iowa, metropolitan, planning, reference, regional-planning-association, rpa

Tables

Table 1

@usgov.state_of_iowa_rpa_boundaries_data.table_1

454.34 kB
18 rows
38 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "rpa_name" VARCHAR,
  "rpa_street_address" VARCHAR,
  "rpa_po_box" VARCHAR,
  "rpa_city" VARCHAR,
  "rpa_state" VARCHAR,
  "rpa_zip_code" BIGINT,
  "rpa_email" VARCHAR,
  "rpa_url" VARCHAR,
  "rpa_district_transportation_planner" VARCHAR,
  "district_transp_planner_street_address" VARCHAR  -- District Transp. Planner Street Address,
  "district_transp_planner_po_box" VARCHAR  -- District Transp. Planner PO Box,
  "district_transp_planner_city" VARCHAR  -- District Transp. Planner City,
  "district_transp_planner_zip_code" BIGINT  -- District Transp. Planner Zip Code,
  "district_transp_planner_email" VARCHAR  -- District Transp. Planner Email,
  "dot_district" BIGINT,
  "rpa_abbreviation" VARCHAR,
  "rpa_number" BIGINT,
  "rpa_phone" DOUBLE,
  "rpa_fax" DOUBLE,
  "district_trans_planner_phone" DOUBLE,
  "district_trans_planner_fax" DOUBLE,
  "effective_start_date" VARCHAR,
  "rpa_census_year" BIGINT,
  "created_by" VARCHAR,
  "date_record_created_utc" VARCHAR  -- Date Record Created (UTC),
  "edited_by" VARCHAR,
  "date_record_last_edited_utc" VARCHAR  -- Date Record Last Edited (UTC),
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_service_updated_utc_offset" VARCHAR,
  "date_record_last_updated_utc_offset" VARCHAR,
  "date_record_created_utc_offset" VARCHAR,
  "area_acre_state_plane" DOUBLE  -- Area (Acre - State Plane),
  "perimeter_meter_state_plane" DOUBLE  -- Perimeter (Meter - State Plane),
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);