About this Dataset

Street Seats (2021-)

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.

This data tracks active Street Seats program sites. The data contains the location of the street seats as well as the managing partners. The data is collected via Excel and tracked throughout the season. Each record represents one Street Seat location. For more information on the Street Seat program, please visit the DOT website: https://www1.nyc.gov/html/dot/html/pedestrians/streetseats.shtml
Organization: City of New York
Last updated: 2021-12-11T16:06:44.584887
Tags: community, rest, seating, street

Tables

Table 1

@usgov.city_of_new_york_street_seats_2021.table_1

25.49 kB
45 rows
29 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "borocode" BIGINT,
  "borocd" BIGINT,
  "assemdist" BIGINT,
  "stsendist" BIGINT,
  "congdist" BIGINT,
  "location" VARCHAR,
  "address" VARCHAR,
  "borough" VARCHAR,
  "postcode" DOUBLE,
  "on_street" VARCHAR,
  "to_street" VARCHAR,
  "from_street" VARCHAR,
  "type" VARCHAR,
  "partner" VARCHAR,
  "status" VARCHAR,
  "xcoordin" BIGINT,
  "ycoordin" BIGINT,
  "femafldz" VARCHAR,
  "femafldt" VARCHAR,
  "hrcevac" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" BIGINT,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta_2020" VARCHAR  -- NTA (2020)
);