From a 500-row sample across 17 columns.
:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+2boroughsystemgispropnum+3:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+2:@computed_region_92fq_4b7qboroughMappable — Socrata point column `the_geom`.
Open on the map →| system | fountainty | position | painted | gispropnum | propertyna | parentid | borough | fountainco | department | decription | featuresta |
|---|---|---|---|---|---|---|---|---|---|---|---|
| M076-DF0014 | D | In Playground | NO | M076 | St. Vartan Park | M076 | M | 1 | M-06 | D-St. Vartan Park | Active |
| R011-DF0108 | B |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
system | text | Unique identifier for the record. | 0% | X255-DF0207Q099-DF0262M037-DF0925 |
fountainty | text | Type of drinking fountain. | 0% | ACE |
position | text | Description of immediate surroundings around the drinking fountain | 6% | Out in OpenIndoorIn Playground |
painted | categorical | Indicates whether or not the drinking fountain is painted. | 25% | NOYESof 2 |
GET /api/datasets/qnv7-p7a2 GET /api/datasets/qnv7-p7a2/quality GET /api/datasets/qnv7-p7a2/related GET /api/columns?dataset=qnv7-p7a2
:@computed_region_sbqj_enih:@computed_region_92fq_4b7qborough:@computed_region_sbqj_enih+3:@computed_region_92fq_4b7qborough:@computed_region_sbqj_enih+2the_geom:@computed_region_92fq_4b7qborough:@computed_region_sbqj_enih+2| In Shade |
| — |
| R011 |
| Hero Park |
| R011 |
| R |
| 1 |
| R-01 |
| B-Hero Park |
| Active |
| Q094-DF0496 | H | Under Tree | YES | Q094 | Tudor Park | Q094-01 | Q | 1 | Q-10 | H-Tudor Park-Addabbo Playground | Active |
| M120B-DF0615 | A | Under Tree, In Playground | YES | M120B | Playground of the Americas | M120B | M | 1 | M-02 | A-Playground of the Americas | Active |
| B109-DF1073 | Indoor Drinking Fountain | Indoor | — | B109 | Bill Brown Playground | B109-BLG1168 | B | 1 | B-15 | Indoor Drinking Fountain-Bill Brown Playground-Comfort Station | Active |
| B021-DF0734 | A | Under Tree, Just Outside Playground | YES | B021 | Commodore Barry Park | B021 | B | 1 | B-02 | A-Commodore Barry Park | Active |
| B169-DF0539 | E | Out in Open | NO | B169 | Coney Island Beach & Boardwalk | B169-ZN01A | B | 1 | B-13 | E-Coney Island Beach & Boardwalk-Coney Island Beach Zone 1a | Active |
| M223-DF0494 | C | Near Ballfield | YES | M223 | Jacob H. Schiff Playground | M223 | M | 1 | M-09 | C-Jacob H. Schiff Playground | Active |
| Q126-DF0678 | F High Low | In Playground | NO | Q126 | Francis Lewis Park | Q126-01 | Q | 2 | Q-07 | F High Low-Francis Lewis Park-Francis Lewis Playground | Active |
| B352-DF0394 | E | Under Tree, In Shade, In Playground | YES | B352 | Curtis Playground | B352 | B | 1 | B-18 | E-Curtis Playground | Active |
Showing 12 of 17 columns. All of them are listed below.
gispropnum| text |
| Unique identification number for each park property, identified by borough/county (B = Brooklyn; M = Manhattan; Q = Queens; R = Richmond (Staten Island); X = Bronx), and followed by a number |
| 0% |
M010Q099B073 |
propertyna | text | Name of GISPropNum that Drinking Fountain is within. | 0% | Central ParkFlushing Meadows Corona …Prospect Park |
parentid | 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. | 0% | Q099-ZN01B251-ZN01Q021-ZN03 |
borough | categorical | Borough that the drinking fountain is within. | 0% | BQMof 5 |
fountainco | categorical | The number of fountains as part of the drinking fountain. | 0% | 123of 3 |
department | text | Parks District that the drinking fountain is within. | 0% | M-13M-03Q-15 |
decription | text | Description of the drinking fountain. | 0% | E-Manhattan Beach Park-M…A-Franklin D. Roosevelt …A-Flushing Meadows Coron… |
featuresta | text | The current status of the feature. | 0% | Activeof 1 |
the_geom | coordinate | Geometry | 0% | {'coordinates': [-73.965…{'coordinates': [-73.949…{'coordinates': [-73.870… |