About this Dataset

Parks Signs

One row of data represents a physical Sign (its location and attributes) that was surveyed or installed by NYC Parks. Data is collected and udpated on an ongoing basis per updates to signage policies, seasonal upgrades, and one-off requests. Some limitations to the data: missing photos of installed signs, occasional shifting of Points (geometry) surveyed by GIS and that NOT ALL SIGNS THAT HAVE BEEN INSTALLED ARE CURRENTLY CAPTURED IN THIS DATASET.
Organization: City of New York
Last updated: 2020-11-10T17:03:26.255914
Tags: parks, sign

Tables

Table 1

@usgov.city_of_new_york_parks_signs.table_1

713.14 kB
11,942 rows
24 columns

CREATE TABLE table_1 (
  "amenitytype" VARCHAR,
  "borough" VARCHAR,
  "communityboard" BIGINT,
  "councildistrict" BIGINT,
  "gispropnum" VARCHAR,
  "hours" VARCHAR,
  "languagecode" VARCHAR,
  "mountingsurface" VARCHAR,
  "nametext" VARCHAR,
  "omppropid" VARCHAR,
  "parkdistrict" VARCHAR,
  "precinct" DOUBLE,
  "propertylocation" VARCHAR,
  "propertyname" VARCHAR,
  "secondlanguage" VARCHAR,
  "signcode" VARCHAR,
  "signcodewithlanguage" VARCHAR,
  "signstatus" VARCHAR,
  "signtype" VARCHAR,
  "subpropertyname" VARCHAR,
  "system" DOUBLE,
  "thirdlanguage" VARCHAR,
  "zipcode" DOUBLE,
  "point" VARCHAR
);