Baselight

Abandoned Rail Lines

State of Iowa

@usgov.state_of_iowa_abandoned_rail_lines_data

Loading...
Loading...

About this Dataset

Abandoned Rail Lines

This layer depicts abandoned rail lines in Iowa.
Organization: State of Iowa
Last updated: 2024-04-12T12:53:16.613823
Tags: asset-inventory, freight, inventory, rail, rail-lines

Tables

Table 1

@usgov.state_of_iowa_abandoned_rail_lines_data.table_1
  • 4.29 MB
  • 3299 rows
  • 67 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.