About this Dataset

Open Storefronts Applications (Historical)

Program had ended.
The Open Storefronts program assists existing ground-floor storefront businesses who want to use outdoor areas on a temporary bases due to the COVID-19 crisis. Note: Geospatial data is based on the application address, geocoding error may be the result from an incorrect address submission.

For real time business application updates, please visit NYC Open Storefront dashboard: http://nycopenstorefronts.info/
Organization: City of New York
Last updated: 2021-08-07T16:51:03.218049
Tags: business, open, storefront, street

Tables

Table 1

@usgov.city_of_new_york_open_storefronts_applications.table_1

154.7 kB
941 rows
29 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "seatingcho" VARCHAR,
  "retailname" VARCHAR,
  "bizname" VARCHAR,
  "bizdba" VARCHAR,
  "biz_desc" VARCHAR,
  "other_bizd" VARCHAR,
  "bizstreetn" VARCHAR,
  "suitenum" VARCHAR,
  "bizboro" VARCHAR,
  "bizzip" DOUBLE,
  "bizaddress" VARCHAR,
  "sidewalkdi" BIGINT,
  "sidewalk_1" BIGINT,
  "sidewalkar" DOUBLE,
  "openstreet" BIGINT,
  "openstre_1" BIGINT,
  "openstre_2" DOUBLE,
  "qualify_si" VARCHAR,
  "qualify_op" VARCHAR,
  "landmarkdi" VARCHAR,
  "landmark_1" VARCHAR,
  "healthcomp" VARCHAR,
  "submission" TIMESTAMP,
  "creationda" TIMESTAMP,
  "long" DOUBLE,
  "lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);