RPA Boundaries
State of Iowa
@usgov.state_of_iowa_rpa_boundaries_data
State of Iowa
@usgov.state_of_iowa_rpa_boundaries_data
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_po_box" VARCHAR,
"district_transp_planner_city" VARCHAR,
"district_transp_planner_zip_code" BIGINT,
"district_transp_planner_email" VARCHAR,
"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,
"edited_by" VARCHAR,
"date_record_last_edited_utc" VARCHAR,
"rest_service_last_updated_utc" VARCHAR,
"rest_service_updated_utc_offset" VARCHAR,
"date_record_last_updated_utc_offset" VARCHAR,
"date_record_created_utc_offset" VARCHAR,
"area_acre_state_plane" DOUBLE,
"perimeter_meter_state_plane" DOUBLE,
"globalid" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.