About this Dataset

MPO Boundaries

This dataset provides the Metropolitan Planning Organization (MPO) boundaries for the State of Iowa including contact information, location details and more. A MPO is a federally mandated and federally funded organization designated to carry out the metropolitan transportation planning process.
Organization: State of Iowa
Last updated: 2024-04-12T12:46:35.369139
Tags: iowa, metro, metropolitan, metropolitan-planning-organization, mpo, planning, reference

Tables

Table 1

@usgov.state_of_iowa_mpo_boundaries_data.table_1

276.7 kB
9 rows
40 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "mpo_name" VARCHAR,
  "mpo_abbreviation" VARCHAR,
  "mpo_street_address" VARCHAR,
  "mpo_po_box" VARCHAR,
  "mpo_city" VARCHAR,
  "mpo_state" VARCHAR,
  "mpo_zip_code" BIGINT,
  "mpo_email" VARCHAR,
  "mpo_url" VARCHAR,
  "mpo_district_transportation_planner" VARCHAR,
  "district_trans_planner_street_address" VARCHAR  -- District Trans. Planner Street Address,
  "district_trans_po_box" VARCHAR  -- District Trans. PO Box,
  "district_trans_city" VARCHAR  -- District Trans. City,
  "district_trans_planner_zip_code" BIGINT  -- District Trans. Planner Zip Code,
  "district_trans_planner_email" VARCHAR  -- District Trans. Planner Email,
  "effective_start_date" VARCHAR,
  "mpo_number" BIGINT,
  "dot_district" DOUBLE,
  "mpo_fax" DOUBLE,
  "mpo_phone" BIGINT,
  "district_trans_planner_phone" BIGINT,
  "district_trans_planner_fax" BIGINT,
  "mpo_census_year" VARCHAR,
  "mpo_district_transportation_planner_alternate" VARCHAR,
  "district_trans_planner_email_alternate" VARCHAR,
  "created_by" VARCHAR,
  "date_created_utc" VARCHAR  -- Date Created (UTC),
  "edited_by" VARCHAR,
  "date_edited_utc" VARCHAR  -- Date Edited (UTC),
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_updated_utc_offset" VARCHAR,
  "date_created_utc_offset" VARCHAR,
  "date_edited_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
);