About this Dataset

Parks Syringe Disposal Kiosks

• One line of data represents single syringe collection kiosk location, its capacity, how it is mounted, and when it was installed.
• Data is collected via an ArcGIS Online web application.
• Data is updated as necessary as kiosks are installed, moved, or removed. However, there is a delay between these actions happening and when the data is updated to reflect them.
• The installation date is known to be incomplete. Minor shifts in kiosk locations do not typically entail the creation of a new record, rather the point is simply moved.

This is part of the NYC Parks Syringe Litter Data Collection: https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Syringe+Litter&q=

You can find the complete data dictionary at https://docs.google.com/spreadsheets/d/1VSUqd1peSc-4D2XnBZNiLdxa0Jg4z62D/edit?usp=sharing&ouid=100172030647057411202&rtpof=true&sd=true
Organization: City of New York
Last updated: 2020-11-10T17:04:51.442504
Tags: parks, syringe-disposal, syringes

Tables

Table 1

@usgov.city_of_new_york_parks_syringe_disposal_kiosks.table_1

16.69 kB
57 rows
17 columns

CREATE TABLE table_1 (
  "kioskid" BIGINT,
  "borough" VARCHAR,
  "parkdistrict" VARCHAR,
  "gispropnum" VARCHAR,
  "omppropid" VARCHAR,
  "propertyname" VARCHAR,
  "subpropertyname" VARCHAR,
  "location" VARCHAR,
  "kiosktype" VARCHAR,
  "submodel" VARCHAR,
  "containersize" VARCHAR,
  "status" VARCHAR,
  "installationdate" TIMESTAMP,
  "remove_date" VARCHAR,
  "removal_reason" VARCHAR,
  "status_change_date" VARCHAR,
  "point" VARCHAR
);