Cool It! NYC 2020 - Spray Showers

tzuk-eq2funcategorised12 columns

This dataset represents amenities activated as a part of Cool It! NYC, a Citywide plan to increase the amount of cooling features available to the public during heat emergencies, particularly in neighborhoods that face the dangers of high heat. This is part of the Cool It! NYC 2020 Data Collection, which includes the following amenities: Drinking Fountains: Indicates whether a drinking fountain is activated, not yet activated, broken, or under construction. Spray Showers: Indicates whether a spray shower installed before July 2020 is activated, not yet activated, broken, or under construction. At this time, spray showers are mapped to the middle of parks. Cooling Sites: To measure neighborhoods that are the most at risk during extreme heat, NYC Health and Columbia University developed the New York City Heat Vulnerability Index, or HVI. Parks used this data to direct new cooling elements to neighborhoods with HVIs of 4 and 5. Data Dictionary: https://docs.google.com/spreadsheets/d/1GpXHX9p0e520LcAf3gstOKTQm64wxkdDUiACjhMwd9Q/edit?usp=sharing

View on NYC Open Data

Quality

B81.3 / 100

From a 500-row sample across 12 columns.

completeness100/ 25% weight

consistency92/ 20% weight

accuracy100/ 20% weight

timeliness0/ 15% weight

usability90/ 20% weight

· No obvious temporal column — limits time-series joins
· Has geographic keys — joinable to other NYC datasets

Related datasets

Cool It! NYC 2020 - Drinking Fountains0.63
joins onboroughysystem+5
Functional Parkland0.26
joins onboroughgispropnumpropertyname
2015 Street Tree Census - Blockface Data0.23
NYC Parks Public Events – Upcoming 14 Days0.21
Parks Permit Areas0.21
joins onboroughsystemgispropnum+3

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

status	borough	gispropnum	omppropid	subpropertyname	propertyname	feature	system	featuretype	district	x	y
Activated	B	B001	B001	American Playground	American Playground	Play Equipment	B001-SPRAY01	Sprinkler	B-01	995942.28193132	204739.17641795
Under Construction	B

Columns

12 queryable · 12 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`status`	categorical	Indicates whether a spray shower is activated, not yet activated, broken, or under construction	0%	`ActivatedUnder ConstructionBroken`of 4
`borough`	categorical	Borough in which the spray shower is located	0%	`BQM`of 5
`gispropnum`	text	Unique identification number for the property the spray shower is within	2%	`M010M071Q015`
`omppropid`	text	Unique identification number for a property or portion of a property. In some cases – a standalone, smaller park for example – this number will be equivalent to the GIS Property Number. In other cases – a zone, playground or other site within a larger park – an additional designation of letters and/or numbers will be added.

Query this from your own app

GET /api/datasets/tzuk-eq2f
GET /api/datasets/tzuk-eq2f/quality
GET /api/datasets/tzuk-eq2f/related
GET /api/columns?dataset=tzuk-eq2f