From a 500-row sample across 21 columns.
air_lot_flagreuc_flagsub_lot_flag+13Has borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| the_geom | objectid | boro | block | lot | bbl | bill_bbl_flag | nycmap_bldg_flag | value_reflected_out_flag | shape_area | shape_length | conversion_exception_flag |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-73.983492767884,40.720456671083],[-73.983559206711,40.720326840549],[-73.983764030243,40.720389549555],[-73.983833537667,40.720410830211],[-73.983903855938,40.720432358977],[-73.983903463251,40.720433126225],[-73.983837531326,40.720561966278],[-73.983492767884,40.720456671083]]]]} | 8716 | 1 | 350 | 71 | 1003500071 | 0 | 1 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
objectid | integer | — | 0% | 527545799817932 |
boro | categorical | — | 0% | 435of 5 |
block | integer | — | 0% | 292574054452 |
lot | integer | — | 0% | 1 |
GET /api/datasets/nst5-iqiu GET /api/datasets/nst5-iqiu/quality GET /api/datasets/nst5-iqiu/related GET /api/columns?dataset=nst5-iqiu
| 845.51171875 |
| 123.62762417971882 |
| — |
| {"type":"MultiPolygon","coordinates":[[[[-74.102199643275,40.609555872365],[-74.102191114988,40.609501362391],[-74.102184718955,40.6094604807],[-74.102183073216,40.609449959885],[-74.102653375132,40.609410212475],[-74.10264880248,40.609430303028],[-74.102641933868,40.60945027899],[-74.102634472374,40.609466636739],[-74.102628753666,40.609477131978],[-74.102623427723,40.609485824521],[-74.102618865984,40.609492630421],[-74.102615211632,40.609497728027],[-74.10260900971,40.609505772087],[-74.102598942888,40.609517500172],[-74.102579786025,40.609536412016],[-74.102563676103,40.609549750385],[-74.102554844137,40.609556279025],[-74.102546981315,40.609561686748],[-74.102539492856,40.609566514434],[-74.102531952365,40.609571082882],[-74.102527010192,40.609573926773],[-74.102518929163,40.609578336196],[-74.102513354548,40.609581214378],[-74.102501973473,40.609586695502],[-74.102223236786,40.609706668546],[-74.102199643275,40.609555872365]]]]} | 767038 | 5 | 837 | 385 | 5008370385 | 0 | 0 | 0 | 1324.53515625 | 158.19149840591558 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-74.006814652215,40.738705390068],[-74.006815803928,40.738639749219],[-74.006816925334,40.738575868526],[-74.006556343628,40.738575565358],[-74.006559402675,40.738401311242],[-74.00689374971,40.738401699949],[-74.006892700017,40.738461531933],[-74.006888418561,40.738705476321],[-74.006814652215,40.738705390068]]]]} | 8542 | 1 | 642 | 57 | 1006420057 | 0 | 1 | 0 | 1109.14453125 | 163.70742786778456 | — |
| {"type":"MultiPolygon","coordinates":[[[[-73.735691273166,40.76938334614],[-73.735768558142,40.769252309632],[-73.735850524017,40.769113336051],[-73.735870126248,40.769080101057],[-73.736044968987,40.769145573376],[-73.736181301153,40.76897103159],[-73.736301837575,40.769021515159],[-73.736151672184,40.769211223875],[-73.736112195408,40.769261096579],[-73.73607406172,40.769309271213],[-73.736036788105,40.769356360092],[-73.736014655944,40.769384320094],[-73.73596202894,40.769450804338],[-73.735929886968,40.769436223625],[-73.735916525005,40.769430764275],[-73.735916412427,40.769430719749],[-73.735900858539,40.769424713624],[-73.735887156456,40.769419723568],[-73.735862417119,40.769411764778],[-73.735834616619,40.769404078622],[-73.735804531118,40.769397177007],[-73.735769231648,40.769390857873],[-73.735736113472,40.769386601111],[-73.735691273166,40.76938334614]]]]} | 644631 | 4 | 8227 | 42 | 4082270042 | 0 | 0 | 0 | 1993.5078125 | 221.32938766458579 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.970871537663,40.752514802388],[-73.971048572481,40.752271743726],[-73.971129753967,40.752305870288],[-73.970952719355,40.752548927668],[-73.970871537663,40.752514802388]]]]} | 9129 | 1 | 1319 | 30 | 1013190030 | 0 | 1 | 0 | 421.60546875 | 102.25718548683945 | — |
| {"type":"MultiPolygon","coordinates":[[[[-73.983150019085,40.683476115651],[-73.983316495708,40.683228212012],[-73.983383691491,40.683254354429],[-73.983217212051,40.683502263961],[-73.983150019085,40.683476115651]]]]} | 163153 | 3 | 388 | 50 | 3003880050 | 0 | 1 | 0 | 343.34375 | 98.492251722258828 | — |
| {"type":"MultiPolygon","coordinates":[[[[-73.986485017017,40.733414469053],[-73.986631410647,40.733213840967],[-73.986947207207,40.733347360276],[-73.986801240033,40.733548168688],[-73.986485017017,40.733414469053]]]]} | 10863 | 1 | 896 | 1 | 1008960001 | 0 | 0 | 0 | 1356.69921875 | 147.92520899167471 | — |
| {"type":"MultiPolygon","coordinates":[[[[-73.926317862029,40.745375205598],[-73.926398487328,40.744969765276],[-73.926763005542,40.745009744088],[-73.926682381721,40.745415184486],[-73.926317862029,40.745375205598]]]]} | 424304 | 4 | 219 | 18 | 4002190018 | 0 | 1 | 0 | 2470.06640625 | 202.49196638367303 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.933177573512,40.852512576123],[-73.933282449911,40.852368962222],[-73.933581559814,40.852497061744],[-73.933472503823,40.852646362814],[-73.933177573512,40.852512576123]]]]} | 11730 | 1 | 2167 | 75 | 1021670075 | 0 | 1 | 0 | 942.140625 | 125.79571978695078 | — |
| {"type":"MultiPolygon","coordinates":[[[[-74.003110917129,40.736329046457],[-74.003212722569,40.73631442418],[-74.003290241852,40.736586804825],[-74.003250616574,40.736592571954],[-74.003188489599,40.736601607049],[-74.003110917129,40.736329046457]]]]} | 13351 | 1 | 614 | 42 | 1006140042 | 0 | 1 | 0 | 472.1953125 | 104.96846038824205 | — |
Showing 12 of 15 columns. All of them are listed below.
2015bbl | text | — | 0% | 507055000120999989004076210001 |
condo_flag | text | — | 99% | Cof 1 |
reuc_flag | text | — | 99% | Rof 1 |
air_lot_flag | text | — | 100% | Aof 1 |
sub_lot_flag | text | — | 100% | Sof 1 |
easement_flag | text | — | 96% | Eof 1 |
lot_note | text | — | 100% | Add Lot faces for Block …Lot was not in COGISNo dimension has been ca… |
effective_tax_year | text | — | 95% | 2007-20082008-20092006-2007 |
bill_bbl_flag | categorical | — | 1% | 01of 2 |
nycmap_bldg_flag | categorical | — | 1% | 012of 3 |
conversion_exception_flag | categorical | — | 31% | 019of 4 |
value_reflected_out_flag | categorical | — | 2% | 012of 7 |
created_user | text | — | 96% | LTPMARVGL |
created_date | datetime | — | 92% | 1999-11-30T00:00:00.000Z1899-12-30T00:00:00.000Z2005-11-30T00:00:00.000Z |
last_edited_user | text | — | 7% | sjJDLTP |
last_edited_date | datetime | — | 91% | 2007-11-30T00:00:00.000Z2000-11-30T00:00:00.000Z2008-11-30T00:00:00.000Z |
shape_area | float | — | 0% | 323.4453125485.36328125323.44140625 |
shape_length | float | — | 0% | 97.01497417488784100.0749933773281102.63705535033543 |