Name: Abandoned Rail Lines
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

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.5 MB
3,299 rows
67 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "year_built" DOUBLE,
  "owner" VARCHAR,
  "owner_abbreviation" VARCHAR,
  "primary_operator" VARCHAR,
  "primary_operator_desc" VARCHAR  -- Primary Operator Desc.,
  "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  -- Trackage (2),
  "haulage" VARCHAR,
  "track_type" VARCHAR,
  "state" VARCHAR,
  "aerial_imagery" VARCHAR,
  "previous_operator_1" VARCHAR  -- Previous Operator (1),
  "previous_owner_1" VARCHAR  -- Previous Owner (1),
  "previous_owner_2" VARCHAR  -- Previous Owner (2),
  "previous_owner_3" VARCHAR  -- Previous Owner (3),
  "previous_owner_4" VARCHAR  -- Previous Owner (4),
  "previous_owner_5" VARCHAR  -- Previous Owner (5),
  "previous_owner_6" VARCHAR  -- Previous Owner (6),
  "previous_owner_7" VARCHAR  -- Previous Owner (7),
  "previous_owner_8" VARCHAR  -- Previous Owner (8),
  "previous_owner_9" VARCHAR  -- Previous Owner (9),
  "previous_owner_10" VARCHAR  -- Previous Owner (10),
  "previous_owner_11" VARCHAR  -- Previous Owner (11),
  "previous_owner_12" VARCHAR  -- Previous Owner (12),
  "previous_owner_13" VARCHAR  -- Previous Owner (13),
  "previous_owner_14" VARCHAR  -- Previous Owner (14),
  "previous_owner_15" VARCHAR  -- Previous Owner (15),
  "number_of_main_lines" DOUBLE,
  "date_digitized_utc" VARCHAR  -- Date Digitized (UTC),
  "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  -- Date Last Modified (UTC),
  "abandoned" VARCHAR  -- Abandoned?,
  "rail_id" DOUBLE,
  "year_abandoned" DOUBLE,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "county_name" VARCHAR,
  "length_mile_state_plane" DOUBLE  -- Length (Mile - State Plane),
  "year_built_date" VARCHAR,
  "county_number" BIGINT,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);