MTA Subway Stations

State of New York

@usgov.state_of_new_york_mta_subway_stations

Table List

1 table(45.01 KB)

Table 1

@usgov.state_of_new_york_mta_subway_stations.table_1

45.01 KB
496 rows
19 columns

gtfs_stop_id GTFS Stop ID	station_id Station ID	complex_id Complex ID	division Division	line Line	stop_name Stop Name	borough Borough	cbd CBD	daytime_routes Daytime Routes	structure Structure	gtfs_latitude GTFS Latitude	gtfs_longitude GTFS Longitude	north_direction_label North Direction Label	south_direction_label South Direction Label	ada ADA	ada_northbound ADA Northbound	ada_southbound ADA Southbound	georeference Georeference
127	317	611	IRT	Broadway - 7Av	Times Sq-42 St	M	true	1 2 3	Subway	40.75529	-73.987495	Uptown	Downtown	1	1	1	POINT (-73.987495 40.75529)
S17	515	515	SIR	Staten Island	Annadale	SI		SIR	Open Cut	40.54046	-74.178217	Ferry	South Shore				POINT (-74.178217 40.54046)
S01	139	627	BMT	Franklin Shuttle	Franklin Av	Bk		S	Elevated	40.680596	-73.955827	Last Stop	Prospect Park	1	1	1	POINT (-73.955827 40.680596)
254	349	349	IRT	Eastern Pky	Junius St	Bk		3	Elevated	40.663515	-73.902447	Manhattan	New Lots				POINT (-73.902447 40.663515)
M01	108	108	BMT	Myrtle Av	Middle Village-Metropolitan Av	Q		M	Elevated	40.711396	-73.889601	Inbound	Last Stop	1	1	1	POINT (-73.889601 40.711396)
726	471	471	IRT	Flushing	34 St-Hudson Yards	M	true	7	Subway	40.755882	-74.00191	Last Stop	Queens	1	1	1	POINT (-74.00191 40.755882)
713	457	457	IRT	Flushing	52 St	Q		7	Elevated	40.744149	-73.912549	Outbound	Manhattan				POINT (-73.912549 40.744149)
615	373	373	IRT	Pelham	E 149 St	Bx		6	Subway	40.812118	-73.904098	Northbound	Manhattan	1	1	1	POINT (-73.904098 40.812118)
M11	97	97	BMT	Jamaica	Myrtle Av	Bk		M J Z	Elevated	40.697207	-73.935657	Outbound	Manhattan				POINT (-73.935657 40.697207)
F16	234	234	IND	6th Av - Culver	East Broadway	M	true	F	Subway	40.713715	-73.990173	Uptown	Brooklyn				POINT (-73.990173 40.713715)


CREATE TABLE table_1 (
  "gtfs_stop_id" VARCHAR,
  "station_id" BIGINT,
  "complex_id" BIGINT,
  "division" VARCHAR,
  "line" VARCHAR,
  "stop_name" VARCHAR,
  "borough" VARCHAR,
  "cbd" BOOLEAN,
  "daytime_routes" VARCHAR,
  "structure" VARCHAR,
  "gtfs_latitude" DOUBLE,
  "gtfs_longitude" DOUBLE,
  "north_direction_label" VARCHAR,
  "south_direction_label" VARCHAR,
  "ada" BIGINT,
  "ada_northbound" BIGINT,
  "ada_southbound" BIGINT,
  "ada_notes" VARCHAR,
  "georeference" VARCHAR
);