From a 500-row sample across 39 columns.
:@computed_region_yeji_bk3q:@computed_region_sbqj_enihgeometry+8:@computed_region_yeji_bk3q:@computed_region_sbqj_enihnta+28:@computed_region_yeji_bk3q:@computed_region_sbqj_enihnta+28Mappable — Socrata point column `location`.
Open on the map →| objectid | buildingnumber | streetname | pssite | width | length | crossstreet1 | crossstreet2 | communityboard | sanitationzone | zipcode | citycouncil |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 118422 | 81-37 | MAIN STREET | Street | 24.0 | 48.0 | GRAND CENTRAL PARKWAY SR NORTH | BEND | 408.0 | 4083E | 11435.0 | 24.0 |
| 120022 | 199 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
objectid | integer | Unique identifier for each inspection | 0% | 108599581087978010852643 |
boroughcode | categorical | Borough planting space is in | 0% | QueensBrooklynBronxof 5 |
buildingnumber | text | Building number of the Planting Space address | 20% | *115 |
streetname | text | Street name of the Planting Space address | 20% | BROADWAYOCEAN PARKWAY5 AVENUE |
GET /api/datasets/82zj-84is GET /api/datasets/82zj-84is/quality GET /api/datasets/82zj-84is/related GET /api/columns?dataset=82zj-84is
:@computed_region_yeji_bk3q:@computed_region_sbqj_enihgeometry+8:@computed_region_yeji_bk3q:@computed_region_sbqj_enihbin+7ntacensus_tractbin+4:@computed_region_yeji_bk3q:@computed_region_sbqj_enihnta+10:@computed_region_yeji_bk3q:@computed_region_sbqj_enihbin+7| BEACH 96 STREET |
| Street |
| — |
| — |
| ROCKAWAY BEACH BOULEVARD |
| WOODROW COTTAGES |
| 414.0 |
| 4142C |
| 11693.0 |
| 32.0 |
| 120823 | 2188 | LIGHT STREET | Street | — | — | LIGHT STREET | CONNER STREET | 212.0 | 2125E | 10466.0 | 12.0 |
| 120825 | 629 | RICHMOND ROAD | Street | — | — | PIERCE STREET | LONGVIEW ROAD | 501.0 | 5011D | 10304.0 | 49.0 |
| 121622 | 194 | WOODVALE AVENUE | Street | 10.0 | — | FINLAY AVENUE | EXCELSIOR AVENUE | 503.0 | 5037D | 10309.0 | 51.0 |
| 121623 | 84-002 | 106 AVENUE | Street | — | — | 86 STREET | 84 STREET | 410.0 | 4101D | 11417.0 | 32.0 |
| 121624 | 402 | EAST 74 STREET | Street | — | — | YORK AVENUE | 1 AVENUE | 108.0 | 1082B | 10021.0 | 5.0 |
| 121625 | 85-002 | 91 AVENUE | Street | — | — | 86 STREET | 85 STREET | 409.0 | 4092D | 11421.0 | 32.0 |
| 121627 | 211 | WHEELER AVENUE | Street | — | — | BEND | SOUTH GANNON AVENUE | 502.0 | 5023C | 10314.0 | 49.0 |
| 121628 | 230 | KINGSTON AVENUE | Street | — | — | ST JOHNS PLACE | STERLING PLACE | 308.0 | 3082B | 11213.0 | 35.0 |
Showing 12 of 35 columns. All of them are listed below.
pssite |
| categorical |
| Indicates if planting space is in a park or on the street |
| 0% |
StreetParkof 2 |
plantingspaceonstreet | text | Street that Planting Space is on, may not be the same as address if property is a corner lot | 71% | 1F1f2F |
width | coordinate | Width of planting space | 100% | 60.072.05.0 |
length | coordinate | Length of planting space | 100% | 72.0120.096.0 |
parkname | text | Name of park planting space is in | 80% | PROSPECT PARK WESTFlushing Meadows Corona …Riverside Park |
parkzone | text | Name of park planting space is in | 95% | X003-ZN01X003-ZN02R065-ZN08 |
crossstreet1 | text | First cross street | 19% | BENDDEAD ENDBROADWAY |
crossstreet2 | text | Second cross street | 19% | BENDDEAD END5 AVENUE |
communityboard | integer | New York City community board | 0% | 503.0413.0407.0 |
sanitationzone | text | DSNY sanitation zone | 3% | QEBKS2031A |
zipcode | coordinate | Zipcode | 7% | 10312.010314.011215.0 |
citycouncil | integer | New York City council district | 7% | 51.050.019.0 |
statesenate | integer | New York State senate district | 7% | 24.011.015.0 |
stateassembly | integer | New York State assembly district | 7% | 62.026.064.0 |
congressional | categorical | U.S. congressional district | 7% | 11.06.05.0of 15 |
physicalid | text | PhysicalID of CSCL line segment that the planting space address is associated with | 29% | 003882400789700086291 |
psstatus | categorical | Indicates if planting space is populated, empty, or retired | 0% | PopulatedEmptyRetiredof 5 |
geometry | text | Geometry for planting space in well known text | 0% | POINT(-73.98628456355274…POINT(-73.72843244026265…POINT(-73.91413396036916… |
globalid | text | Unique identifier for each inspection | 0% | 8F0E9667-8C2A-4415-9BE1-…2CA04486-A826-45CC-9A14-…D2A4CBA6-655F-4824-9BB9-… |
createddate | datetime | Date of record creation | 0% | 2016-11-02T16:56:042018-11-07T11:11:112018-04-11T11:11:11 |
updateddate | datetime | Date record was updated last | 34% | 2017-06-14T11:11:112020-05-26T15:00:002019-02-20T16:20:53 |
jurisdiction | categorical | Indicates if planting space is under DPR or other jurisdiction | 85% | DPRGreen ThumbPrivateof 12 |
overheadutilities | coordinate | Indicates if there are overhead utility wires (1) or not (0) | 97% | 1.00.0of 2 |
treeguard | categorical | This is a new field and is barely populated | 98% | NoneHelpfulHarmfulof 3 |
latitude | float | — | 56% | 40.87501340.83861340.612318 |
longitude | float | — | 56% | -73.828362-73.856525-73.93572899999999 |
census_tract | float | — | 56% | 892.011571.01884 |
bin | integer | — | 57% | 400000030000002000000 |
bbl | integer | — | 57% | 100972000110097800014124950002 |
nta | text | — | 54% | /BaysideMurray Hill-Broadway Flu… |
location | coordinate | — | 0% | {'coordinates': [-74.095…{'coordinates': [-73.914…{'coordinates': [-73.986… |