Bus Pad Tracking
City of New York
@usgov.city_of_new_york_bus_pad_tracking
City of New York
@usgov.city_of_new_york_bus_pad_tracking
CREATE TABLE table_1 (
"date_received" VARCHAR,
"borough" VARCHAR,
"community_board" DOUBLE,
"on_street" VARCHAR,
"cross_street_1" VARCHAR,
"cross_street_2" VARCHAR,
"address" VARCHAR,
"block" VARCHAR,
"lot" VARCHAR,
"existing_bus_pad_or_no_bus_pad" VARCHAR,
"if_existing_length_of_bus_pad_feet" VARCHAR,
"bus_pad_roadway_condition_rating_high_medium_low" VARCHAR,
"vehicular_traffic_high_medium_low" VARCHAR,
"pedestrian_traffic_high_medium_low" VARCHAR,
"curb_type" VARCHAR,
"curb_reveal_inches" VARCHAR,
"sidewalk_type" VARCHAR,
"landmark_area_yes_no" VARCHAR,
"ta_structure_yes_no" VARCHAR,
"vault_yes_no" VARCHAR,
"repaired_y_n" VARCHAR,
"contract" VARCHAR,
"construction_date" VARCHAR,
"linear_ft_constructed" DOUBLE,
"postcode" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"council_district" DOUBLE,
"census_tract_2020" DOUBLE,
"bin" DOUBLE,
"bbl" DOUBLE,
"nta_2020" VARCHAR
);
Anyone who has the link will be able to view this.