From a 500-row sample across 25 columns.
gispropnumboroughzipcode+4gispropnumboroughsystem+8gispropnumboroughzipcode+4zipcodeHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| system | df_activated | fountaintype | fountaincount | painted | filter_installed | position | outdoor | gispropnum | propertyname | omppropid | parkdistrict |
|---|---|---|---|---|---|---|---|---|---|---|---|
| B001-DF0207 | Activated | A | 1 | true | false | Under Tree, In Playground | true | B001 | American Playground | B001 | B-01 |
| B002-DF0731 | Broken |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
system | text | The internal unique GIS identifier of the drinking fountain. | 1% | X255-DF0207Q099-DF0262R005-DF0197 |
df_activated | categorical | Indicates whether a drinking fountain is activated during the Cool IT! NYC 2020 program (between approximately July to October 2020) | 0% | ActivatedUnderConstructionBrokenof 4 |
fountaintype | text | Indicates the unique type of a drinking fountain per Parks specifications | 0% | ACE |
fountaincount | categorical | The count of drinking fountain fixtures | 1% |
GET /api/datasets/wxhr-qbhz GET /api/datasets/wxhr-qbhz/quality GET /api/datasets/wxhr-qbhz/related GET /api/columns?dataset=wxhr-qbhz
gispropnumboroughzipcode+1boroughgispropnumboroughzipcode+5| E |
| 1 |
| true |
| false |
| Out in Open |
| true |
| B002 |
| Amersfort Park |
| B002 |
| B-18 |
| B002-DF0732 | Broken | E | 1 | true | false | Under Tree, Out in Open | true | B002 | Amersfort Park | B002 | B-18 |
| B007-DF0754 | UnderConstruction | CS Metal | 1 | false | false | In Shade | true | B007 | Bensonhurst Park | B007 | B-11 |
| B007-DF0756 | UnderConstruction | A | 1 | true | true | Out in Open, In Playground | true | B007 | Bensonhurst Park | B007-01 | B-11 |
| B007-DF0757 | UnderConstruction | A | 1 | true | true | Near Ballfield, Out in Open | true | B007 | Bensonhurst Park | B007 | B-11 |
| B007-DF0765 | Broken | A | 1 | true | false | Out in Open | true | B007 | Bensonhurst Park | B007 | B-11 |
| B007-DF0766 | UnderConstruction | A | 1 | true | true | Near Ballfield, Out in Open | true | B007 | Bensonhurst Park | B007 | B-11 |
| B007-DF0767 | Broken | A | 1 | true | false | Out in Open | true | B007 | Bensonhurst Park | B007 | B-11 |
| B008-DF0018 | Activated | F High Low | 2 | true | false | Just Outside Playground | true | B008 | Betsy Head Park | B008-03 | B-16 |
Showing 12 of 25 columns. All of them are listed below.
123painted | boolean | Indicates whether a drinking fountain is painted | 26% | FalseTrueof 2 |
filter_installed | boolean | Indicates whether a filter has been installed on a drinking fountain | 1% | FalseTrueof 2 |
position | text | Indicates specific location details within a Parks property | 7% | Out in OpenIndoorIn Playground |
outdoor | boolean | Indicates whether a drinking fountain is outdoors | 0% | TrueFalseof 2 |
gispropnum | text | Unique identification number for the property the drinking fountain is within | 1% | M010Q099B073 |
propertyname | text | Name of the property the drinking fountain is within | 1% | Central ParkFlushing Meadows Corona …Prospect Park |
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. | 1% | Q099M104M105 |
subpropertyname | text | The name of the subproperty (Zone or Playground) that the drinking fountain falls within | 59% | The BandshellManhattan Beach Zone 1Midland Beach Zone 5 |
parkdistrict | text | Name of the Parks district the drinking fountain is within | 0% | M-13M-03Q-15 |
borough | categorical | Borough in which the drinking fountain is located | 0% | BQMof 6 |
ampsid | integer | Unique ID assigned for use within Parks asset management system | 1% | 100040119100038826100043362 |
ampsclass | text | Unique ID assigned to identify asset as a drinking fountain within Parks asset management system | 0% | DRINKFTNof 1 |
ampsstatus | categorical | Unique status code that identifies drinking fountain status within Parks asset management system | 1% | IDof 2 |
ampsparentid | text | Unique Parks asset management system location ID that identifies Parks property, subproperty, or structure within which a drinking fountain is located | 1% | B251-ZN01R046-ZN05Q021-ZN03 |
ampsname | text | Unique Parks asset management system location name that identifies Parks property, subproperty, or structure within which a drinking fountain is located | 1% | E-Manhattan Beach Park-M…A-Franklin D. Roosevelt …A-Cunningham Park-Cunnin… |
communityboard | integer | Name of the Community Board the drinking fountain is within | 1% | 164103111 |
councildistrict | integer | Name of the NYC City Council District the drinking fountain is within | 1% | 6821 |
precinct | integer | Name of the NYC NYPD precinct the drinking fountain is within | 1% | 22110109 |
zipcode | integer | Name of the zip code the drinking fountain is within | 1% | 831136810002 |
x | float | Longitude | 0% | 993709.030938714998129.275050968992198.543474137 |
y | float | Latitude | 0% | 224835.78725472201625.673241972247940.631792977 |