From a 500-row sample across 12 columns.
boroughnumberthe_geom+1shape_areathe_geomshape_lenshape_areathe_geom+1shape_areathe_geomobjectidHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| number | image | objectid | the_geom | curr_round | curr_user | curr_stat | curr_err | borough | shape_area | shape_len | boro |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 930142 | 930142 | 101 | {"type":"MultiPolygon","coordinates":[[[[-74.1952332903716,40.55763936063564],[-74.19525334439554,40.56450136161628],[-74.1862555221778,40.564516304542394],[-74.18623639229386,40.557654302035864],[-74.1952332903716,40.55763936063564]]]]} | 1 | dlitvak | 1 | 0 | 5 | 6250000.01164 | 10000.0000093 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
number | integer | — | 0% | 9351455022055185 |
image | text | — | 0% | 035175045220030190 |
objectid | integer | — | 0% | 10705681360 |
the_geom | unknown | — | — | — |
curr_round | categorical | — | 0% | 1 |
GET /api/datasets/yjgu-spfb GET /api/datasets/yjgu-spfb/quality GET /api/datasets/yjgu-spfb/related GET /api/columns?dataset=yjgu-spfb
shape_areathe_geomshape_areathe_geomboroughborough| 5 |
| 937142 | 937142 | 160 | {"type":"MultiPolygon","coordinates":[[[[-74.16824258454074,40.557682070495936],[-74.16825986614106,40.56454407583839],[-74.1592620327018,40.56455690420746],[-74.15924567524495,40.55769489755501],[-74.16824258454074,40.557682070495936]]]]} | 1 | yfriedman | 1 | 0 | 5 | 6250000.01164 | 10000.0000093 | 5 |
| 22222 | 022222 | 1268 | {"type":"MultiPolygon","coordinates":[[[[-73.86189301081052,40.77730458737624],[-73.86187877789385,40.78416641679866],[-73.85285126346764,40.78415524364668],[-73.85286642663522,40.77729341536386],[-73.86189301081052,40.77730458737624]]]]} | 1 | kweingart | 1 | 0 | 4 | 6250000.01164 | 10000.0000093 | 4 |
| 970185 | 970185 | 389 | {"type":"MultiPolygon","coordinates":[[[[-74.05137225375147,40.674447508870486],[-74.05137753986696,40.681309442473726],[-74.04236393785894,40.68131311409446],[-74.04235957913166,40.674451180116485],[-74.05137225375147,40.674447508870486]]]]} | 1 | rcohen | 1 | 0 | 5 | 6250000.01164 | 10000.0000093 | 5 |
| 960155 | 960155 | 311 | {"type":"MultiPolygon","coordinates":[[[[-74.08731513567992,40.59208217252334],[-74.08732410917123,40.59894416554631],[-74.07832162871782,40.59895065353636],[-74.07831358032713,40.59208865985097],[-74.08731513567992,40.59208217252334]]]]} | 1 | dlitvak | 1 | 0 | 5 | 6250000.01164 | 10000.0000093 | 5 |
| 987210 | 987210 | 587 | {"type":"MultiPolygon","coordinates":[[[[-73.98827145202522,40.74307745694792],[-73.98827024393468,40.74993932950878],[-73.97924735618231,40.7499380572656],[-73.97924949357306,40.743076184834536],[-73.98827145202522,40.74307745694792]]]]} | 1 | rcohen | 1 | 0 | 1 | 6249999.37164 | 9999.99949731 | 1 |
| 962152 | 962152 | 323 | {"type":"MultiPolygon","coordinates":[[[[-74.07830553359038,40.585226661666084],[-74.07831358032713,40.59208865985097],[-74.06931202332039,40.592094442034835],[-74.06930490149469,40.585232443259564],[-74.07830553359038,40.585226661666084]]]]} | 1 | rcohen | 1 | 0 | 5 | 6250000.01164 | 10000.0000093 | 5 |
| 137 | 000137 | 767 | {"type":"MultiPolygon","coordinates":[[[[-73.94333092245995,40.54406726708207],[-73.94332510268883,40.55092929150248],[-73.9343290903063,40.55092449945721],[-73.93433583384964,40.544062475526175],[-73.94333092245995,40.54406726708207]]]]} | 1 | dlitvak | 1 | 0 | 4 | 6250000.01164 | 10000.0000093 | 4 |
| 32187 | 032187 | 1451 | {"type":"MultiPolygon","coordinates":[[[[-73.82603766046574,40.68118940882986],[-73.82601975824464,40.688051324408725],[-73.81700526350247,40.68803734260669],[-73.8170240932919,40.681175428454665],[-73.82603766046574,40.68118940882986]]]]} | 1 | kweingart | 1 | 0 | 4 | 6250000.01164 | 10000.0000093 | 4 |
| 37160 | 037160 | 1532 | {"type":"MultiPolygon","coordinates":[[[[-73.80822759286397,40.60567934325811],[-73.8082078801596,40.61254131404056],[-73.79920358609681,40.61252593721692],[-73.79922422427073,40.60566396800431],[-73.80822759286397,40.60567934325811]]]]} | 1 | kweingart | 1 | 0 | 4 | 6250000.01164 | 10000.0000093 | 4 |
23curr_user | categorical | — | 0% | rsklardlitvakrcohenof 5 |
curr_stat | categorical | — | 0% | 12of 2 |
curr_err | categorical | — | 0% | 012of 8 |
borough | categorical | — | 0% | 453of 6 |
shape_area | categorical | — | 0% | 6250000.011646249999.37164of 2 |
shape_len | categorical | — | 0% | 10000.00000939999.99949731of 2 |
boro | categorical | — | 0% | 453of 5 |