From a 500-row sample across 23 columns.
:@computed_region_yeji_bk3qcommunityboard:@computed_region_f5dn_yrer+14communityboardobjectidgispropnum+4locationobjectidgispropnum+3communityboardMappable — Socrata point column `point`.
Open on the map →| communityboard | councildistrict | manufacturer | objectid | precinct | zipcode | point | :@computed_region_efsh_h5xi | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q | :@computed_region_92fq_4b7q | :@computed_region_sbqj_enih |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 502 | 50 | Mitt Mutt | 30403 | 122 | 10306 | 40.57646, -74.09527 | 10693 | 30 | 1 | 14 | 76 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | — | 3% | XBQof 5 |
communityboard | integer | — | 0% | 207501414 |
councildistrict | integer | — | 0% | 111415 |
dispenserunitlocation | categorical | — | 2% | Park PerimeterNear EntrancePark Interiorof 4 |
gispropnum | text |
GET /api/datasets/5npv-j6gn GET /api/datasets/5npv-j6gn/quality GET /api/datasets/5npv-j6gn/related GET /api/columns?dataset=5npv-j6gn
subpropertynamepropertynamecommunityboardpropertynamegispropnum+5:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer:@computed_region_92fq_4b7q+2borough:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer:@computed_region_92fq_4b7q+3| 502 |
| 50 |
| Mitt Mutt |
| 25203 |
| 122 |
| 10306 |
| 40.57625, -74.09749 |
| 10693 |
| 30 |
| 1 |
| 14 |
| 76 |
| 502 | 50 | Mitt Mutt | 2405 | 121 | 10314 | 40.60456, -74.15906 | 10700 | 30 | 1 | 14 | 75 |
| 355 | 39 | Mitt Mutt | 1203 | 78 | 11215 | 40.66540, -73.97585 | — | 13 | 2 | 27 | 50 |
| 595 | 50 | Mitt Mutt | 2404 | 122 | 10305 | 40.57862, -74.07690 | 10692 | 31 | 1 | 14 | 76 |
| 355 | 39 | Mitt Mutt | 1603 | 78 | 11215 | 40.66541, -73.97585 | — | 13 | 2 | 27 | 50 |
| 502 | 50 | Mitt Mutt | 2805 | 121 | 10314 | 40.60676, -74.15549 | 10700 | 30 | 1 | 14 | 75 |
| 595 | 50 | Mitt Mutt | 2403 | 122 | 10305 | 40.58989, -74.06537 | 10692 | 31 | 1 | 14 | 76 |
| 315 | 48 | Mitt Mutt | 2003 | 61 | 11235 | 40.58112, -73.94404 | 13826 | 32 | 2 | 15 | 36 |
| 302 | 35 | Mitt Mutt | 2803 | 88 | 11205 | 40.69257, -73.96161 | 17212 | 68 | 2 | 48 | 55 |
Showing 12 of 23 columns. All of them are listed below.
| — |
| 3% |
X033Q162GroupB073 |
installationdate | datetime | — | 40% | 2018-04-23T04:00:00.0002018-03-12T04:00:00.0002018-03-27T04:00:00.000 |
location | text | — | 35% | Near sidewalknear path5 ft from street interse… |
manufacturer | categorical | — | 0% | Mitt MuttMutt MittZero Waste USAof 4 |
mountingsurface | categorical | — | 2% | Unpaved SurfacePaved SurfaceWrought Iron Fenceof 6 |
objectid | integer | — | 0% | 1800760503633 |
omppropid | text | — | 68% | X033-ZN03X047-ZN01X002-ZN02 |
parkdistrict | text | — | 5% | R-01X-07X-05 |
precinct | integer | — | 0% | 5212046 |
propertyname | text | — | 3% | Mosholu ParkwayRockaway Beach and Board…Prospect Park |
restockedby | categorical | — | 20% | ParksPartner Groupof 2 |
subpropertyname | text | — | 68% | Mosholu Parkway Zone 3Bronx Park Zone 2Franz Sigel Park Zone 1 |
zipcode | integer | — | 0% | 104671045710468 |
point | coordinate | — | 0% | {'coordinates': [-73.844…{'coordinates': [-73.910…{'coordinates': [-73.922… |