Name: Amtrak Rail Lines
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Amtrak Rail Lines

The Rail Network is a comprehensive database of the nation's railway system at the 1:100,000 scale or better. The data set covers the State of Maryland.
Organization: State of Maryland
Last updated: 2025-07-26T21:22:10.616441

Tables

Table 1

@usgov.state_of_maryland_amtrak_rail_lines_2658b.table_1

65.69 kB
116 rows
34 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "gis_object_id" BIGINT,
  "fra_arc_id" BIGINT,
  "length_of_segment_in_miles" DOUBLE,
  "state_railroad_abbreviation" VARCHAR,
  "state_fips_code" BIGINT,
  "county_fips_code" BIGINT,
  "state_and_county_fips_code" BIGINT,
  "fra_regional_boundaries" BIGINT,
  "first_railroad_owner" VARCHAR,
  "second_railroad_owner" VARCHAR,
  "third_railroad_owner" VARCHAR,
  "first_railroad_with_trackage_rights" VARCHAR,
  "second_railroad_with_trackage_rights" VARCHAR,
  "third_railroad_with_trackage_rights" VARCHAR,
  "fourth_railroad_with_trackage_rights" VARCHAR,
  "fifth_railroad_with_trackage_rights" VARCHAR,
  "sixth_railroad_with_trackage_rights" VARCHAR,
  "seventh_railroad_with_trackage_rights" VARCHAR,
  "eighth_railroad_with_trackage_rights" VARCHAR,
  "ninth_railroad_with_trackage_rights" VARCHAR,
  "type_of_military_interest_flag" VARCHAR,
  "type_of_signaling_system" VARCHAR,
  "number_of_tracks" BIGINT,
  "subdivision" VARCHAR,
  "fra_node_number" BIGINT,
  "fra_node_number2" BIGINT,
  "part_of_network" VARCHAR,
  "passenger_operations" VARCHAR,
  "name_of_yard" VARCHAR,
  "intermodal_type" VARCHAR,
  "shape_length_alt" DOUBLE,
  "density_category_2010" BIGINT,
  "shape_stlength" DOUBLE
);