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

About this Dataset

Historical Rail Lines

Historical rail lines in Iowa. Using the Data_Year field one could view various year historical data for each rail line segment.
Organization: State of Iowa
Last updated: 2024-04-12T12:48:35.961365
Tags: asset-inventory, freight, inventory, rail, rail-lines

Tables

Table 1

@usgov.state_of_iowa_historical_rail_lines_data.table_1

44.87 MB
88,315 rows
72 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" VARCHAR,
  "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),
  "county_number" DOUBLE,
  "number_of_main_lines" DOUBLE,
  "date_digitized_utc" VARCHAR  -- Date Digitized (UTC),
  "tonnage_trackage" DOUBLE,
  "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" DOUBLE,
  "previous_ton_track_name" VARCHAR,
  "date_last_modified_utc" VARCHAR  -- Date Last Modified (UTC),
  "abandoned" VARCHAR  -- Abandoned?,
  "data_year" BIGINT,
  "roadmaster_url" VARCHAR,
  "roadmaster_number" DOUBLE,
  "rail_id" DOUBLE,
  "year_abandoned" DOUBLE,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "length_mile" DOUBLE,
  "year_built_date" VARCHAR,
  "year_abandond_date" VARCHAR,
  "county_name" VARCHAR,
  "city_name" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);