NYC Subway Entrance And Exit by Kaggle | Transportation and Logistics

About this Dataset

NYC Subway Entrance And Exit

NYC Subway Entrance And Exit Locations

Entrance & Exit locations of the NYC subway

Data Manual

The dataset is an observation of all the entrances and exits in the NYC subway system. They are all classified according to the name of the subway stations and their corresponding names.
We do not include data on the subway stations that do not have at least one entrance or exit. We can observe how the GPS location of the entrances and exits might or might not correspond to the subway station name.

Variable	Description	Type of Variable
`Station`	name of the station	categorical
`ComplexID`	An ID provided by the MTA identifying the Station-Complex and corresponds to Station	categorical
`Entrance_Type`	Type of entrance, describes the type of staircase or ramp	categorical
`Entry`	Whether this is an entrance or an exit	categorical
`Exit_Only`	Whether this is a turnstile entrance/exit, or an intermediate entrance/exit, for example for a transfer	categorical
`Longitude`	Longitude location of the entrance or exit	continuous
`Latitude`	Latitude location of the entrance or exit	continuous
`ObjectID`	Unique identifier	categorical

Cleaning steps

We cleaned our datasets by selecting only the stations with at least one entrance or exit. We also created a new column with the name of the station in order to be able to merge it with the turnstile dataset.

Tables

Nyc Transit Subway Entrance And Exit Data

@kaggle.thedevastator_nyc_subway_entrance_and_exit.nyc_transit_subway_entrance_and_exit_data

119.31 KB
1868 rows
32 columns


CREATE TABLE nyc_transit_subway_entrance_and_exit_data (
  "division" VARCHAR,
  "line" VARCHAR,
  "station_name" VARCHAR,
  "station_latitude" DOUBLE,
  "station_longitude" DOUBLE,
  "route1" VARCHAR,
  "route2" VARCHAR,
  "route3" VARCHAR,
  "route4" VARCHAR,
  "route5" VARCHAR,
  "route6" VARCHAR,
  "route7" VARCHAR,
  "route8" DOUBLE,
  "route9" DOUBLE,
  "route10" DOUBLE,
  "route11" DOUBLE,
  "entrance_type" VARCHAR,
  "entry" VARCHAR,
  "exit_only" VARCHAR,
  "vending" VARCHAR,
  "staffing" VARCHAR,
  "staff_hours" VARCHAR,
  "ada" BOOLEAN,
  "ada_notes" VARCHAR,
  "free_crossover" BOOLEAN,
  "north_south_street" VARCHAR,
  "east_west_street" VARCHAR,
  "corner" VARCHAR,
  "entrance_latitude" DOUBLE,
  "entrance_longitude" DOUBLE,
  "station_location" VARCHAR,
  "entrance_location" VARCHAR
);