Abandoned Rail Lines
State of Iowa
@usgov.state_of_iowa_abandoned_rail_lines_data
State of Iowa
@usgov.state_of_iowa_abandoned_rail_lines_data
CREATE TABLE table_1 (
"the_geom" VARCHAR,
"objectid" BIGINT,
"year_built" DOUBLE,
"owner" VARCHAR,
"owner_abbreviation" VARCHAR,
"primary_operator" VARCHAR,
"primary_operator_desc" VARCHAR,
"aar_code" DOUBLE,
"div_code" DOUBLE,
"subdiv_code" DOUBLE,
"branch_code" DOUBLE,
"within_corporation_limit" VARCHAR,
"aar_code_description" VARCHAR,
"trackage" VARCHAR,
"trackage_2" VARCHAR,
"haulage" VARCHAR,
"track_type" VARCHAR,
"state" VARCHAR,
"aerial_imagery" VARCHAR,
"previous_operator_1" VARCHAR,
"previous_owner_1" VARCHAR,
"previous_owner_2" VARCHAR,
"previous_owner_3" VARCHAR,
"previous_owner_4" VARCHAR,
"previous_owner_5" VARCHAR,
"previous_owner_6" VARCHAR,
"previous_owner_7" VARCHAR,
"previous_owner_8" VARCHAR,
"previous_owner_9" VARCHAR,
"previous_owner_10" VARCHAR,
"previous_owner_11" VARCHAR,
"previous_owner_12" VARCHAR,
"previous_owner_13" VARCHAR,
"previous_owner_14" VARCHAR,
"previous_owner_15" VARCHAR,
"number_of_main_lines" DOUBLE,
"date_digitized_utc" VARCHAR,
"tonnage_trackage" VARCHAR,
"tonnage" DOUBLE,
"ton_track_name" VARCHAR,
"total_tonnage" DOUBLE,
"freight_speed" DOUBLE,
"rr_class" DOUBLE,
"passenger_study" VARCHAR,
"active_passenger" VARCHAR,
"proposed_future_passenger" VARCHAR,
"future_passenger" VARCHAR,
"fra_crossing" VARCHAR,
"tier_1_study" VARCHAR,
"city_number" DOUBLE,
"abandoned_plan_category" DOUBLE,
"previous_tonnage" DOUBLE,
"previous_total_tonnage" DOUBLE,
"previous_tonnage_trackage" VARCHAR,
"previous_ton_track_name" VARCHAR,
"date_last_modified_utc" VARCHAR,
"abandoned" VARCHAR,
"rail_id" DOUBLE,
"year_abandoned" DOUBLE,
"rest_service_last_updated_utc" VARCHAR,
"rest_utc_offset" VARCHAR,
"county_name" VARCHAR,
"length_mile_state_plane" DOUBLE,
"year_built_date" VARCHAR,
"county_number" BIGINT,
"globalid" VARCHAR,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.