From a 5-row sample across 5 columns.
shape_lengborocodeshape_area+2shape_lengshape_areathe_geomshape_lengshape_areathe_geomshape_lengshape_areathe_geomHas borough codes (`borocode`) — joinable, but needs boundary shapes to draw.
| borocode | boroname | shape_area | shape_leng | the_geom |
|---|---|---|---|---|
| 5 | Staten Island | 1623618358.46 | 325912.288988 | NaN, NaN |
| 3 | Brooklyn | 1934462607.75 | 726953.04509 | NaN, NaN |
| 4 | Queens | 3041419716.32 | 887902.903727 | NaN, NaN |
| 1 | Manhattan | 636631537.285 | 359537.906171 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borocode | categorical | Borough code. | 0% | 512of 5 |
boroname | categorical | Name of borough. | 0% | QueensBrooklynManhattanof 5 |
shape_area | categorical | Area of feature in internal units squared. | 0% | 636631537.2851623618358.463041419716.32of 5 |
shape_leng | categorical | Length of feature in internal units. | 0% | 887902.903727726953.04509 |
GET /api/datasets/gthc-hcne GET /api/datasets/gthc-hcne/quality GET /api/datasets/gthc-hcne/related GET /api/columns?dataset=gthc-hcne
shape_lengshape_areathe_geomshape_lengshape_areathe_geomshape_lengshape_areathe_geomshape_lengborocodeshape_area+2| NaN, NaN |
| 2 | Bronx | 1187199168.58 | 463146.326689 | NaN, NaN |
463146.326689the_geom | unknown | — | — | — |