Open Streets Locations by US Government | Demographics and Population Studies

About this Dataset

Open Streets Locations

New York City's Open Streets program transforms streets into public spaces open to all. These public spaces allows a variety of activities including education and cultural programming as well as building communities. For more information please visit: https://www.nyc.gov/html/dot/html/pedestrians/openstreets.shtml
Please note: there may be a delay in updates to the Open Data files.
Organization: City of New York
Last updated: 2020-11-10T17:05:36.667601
Tags: bike, cycling, distancing, open, social, street, walk

Tables

Table 1

@usgov.city_of_new_york_open_streets_locations.table_1

68.27 KB
391 rows
29 columns


CREATE TABLE table_1 (
  "object_id" BIGINT,
  "organization_name" VARCHAR,
  "approved_on_street" VARCHAR,
  "borough_name" VARCHAR,
  "approved_from_street" VARCHAR,
  "approved_to_street" VARCHAR,
  "apprdayswe" VARCHAR,
  "status_type" VARCHAR,
  "approved_monday_open" VARCHAR,
  "approved_monday_close" VARCHAR,
  "approved_tuesday_open" VARCHAR,
  "approved_tuesday_close" VARCHAR,
  "approved_wednesday_open" VARCHAR,
  "approved_wednesday_close" VARCHAR,
  "approved_thursday_open" VARCHAR,
  "approved_thursday_close" VARCHAR,
  "approved_friday_open" VARCHAR,
  "approved_friday_close" VARCHAR,
  "approved_saturday_open" VARCHAR,
  "approved_saturday_close" VARCHAR,
  "approved_sunday_open" VARCHAR,
  "approved_sunday_close" VARCHAR,
  "apprstartd" TIMESTAMP,
  "apprenddat" TIMESTAMP,
  "shape_stle" DOUBLE,
  "segmentidt" BIGINT,
  "segmentidf" BIGINT,
  "lionversion" VARCHAR,
  "the_geom" VARCHAR
);