About this Dataset

Street Seats - 2014-2019

Street Seats is a citywide program where partners apply to transform underused streets into vibrant, social public spaces between the months of March through December (the Season). Street Seats are installed in the roadbed along the curb line to create an attractive setting for eating, reading, working, meeting a friend or taking a rest.

For additional information on Street Seats, please visit the DOT website: https://www1.nyc.gov/html/dot/html/pedestrians/streetseats.shtml
For current data, please search for Street Seats (current year)

This data was collected to track information regarding each locations and the partners that manage each StreetSeat. The data is collected via Excel and tracked throughout the Season. Each record represents one Street Seat location. This data can be used to geolocate all of the Street Seats within 2018 Season. The data gets updated throughout the Season to include more details.
Organization: City of New York
Last updated: 2020-11-10T17:02:26.881357
Tags: seats, street

Tables

Table 1

@usgov.city_of_new_york_street_seats.table_1

23 kB
24 rows
27 columns

CREATE TABLE table_1 (
  "f1" BIGINT,
  "borough" VARCHAR,
  "ifo_business" VARCHAR,
  "applicant" VARCHAR,
  "year" BIGINT,
  "location" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR,
  "site_visit" TIMESTAMP,
  "structure" VARCHAR,
  "structur_1" VARCHAR,
  "structur_2" VARCHAR,
  "establishment" VARCHAR,
  "parking_regulation" VARCHAR,
  "application" VARCHAR,
  "community_board_cb" DOUBLE  -- Community Board (CB),
  "n_2019_installation" TIMESTAMP  -- 2019 Installation,
  "n_2019_removal" VARCHAR  -- 2019 Removal,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "postcode" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "localtion1" VARCHAR
);