NYC Subway Entrance And Exit
Entrance & Exit locations of the NYC subway
@kaggle.thedevastator_nyc_subway_entrance_and_exit
Loading...
Loading...
Loading...
Loading...
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 |
Subway | The subway line that corresponds to the station | categorical
Name | The full name of the station | categorical
Entrance_Location | The address of the entrance/exit | categorical
Entry_Longitude | Longitude location of the entrance/exit | continuous
Entry_Latitude | Latitude location of the entrance/exit | continuous
Corridor | The subway line (s) that this Station is on, separated by a comma | categorical
DIVISION | The division of the subway line (s) | categorical
Line | The subway line that corresponds to the station | categorical
ControlArea | Whether this Station is in a Control Area | categorical
SCP | Subunit Channel Position, can be used to match this with a Subunit Channel (Data in control area file) | categorical
Unit | The unit at which this Station is located | categorical
STATION | The station for this channel, one of the entries above | categorical
LINENAME | The subway lines that are in the station complex, separated by a comma | categorical
DIVISION | The division of the subway line | 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
- 122.18 kB
- 1,868 rows
- 32 columns
Loading...
Loading...
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
);