From a 500-row sample across 17 columns.
binshape_areamappluto_bbl+13binmappluto_bbldoitt_id+11binmappluto_bbldoitt_id+12| the_geom | bin | doitt_id | shape_area | base_bbl | objectid | construction_year | demolition_year | geom_source | last_edited_date | last_status_type | shape_length |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-73.813401912796,40.782791074511],[-73.813504946732,40.782799085765],[-73.813490789364,40.782904384057],[-73.813458691401,40.782901883796],[-73.813454712077,40.782931548006],[-73.813403768998,40.782927595448],[-73.813415566643,40.78283973343],[-73.813395573543,40.782838188706],[-73.813401912796,40.782791074511]]]]} | 4106391 | 0 | 185.16796875 | 4046860009 | 4023 | 1925 | 2004 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
name | text | — | 93% | NO NAMETerminal 38 Washington Place |
bin | integer | — | 0% | 400000030000005000000 |
doitt_id | integer | — | 0% | 03758401273156 |
shape_area | float | — | 0% |
GET /api/datasets/ipkp-snf6 GET /api/datasets/ipkp-snf6/quality GET /api/datasets/ipkp-snf6/related GET /api/columns?dataset=ipkp-snf6
the_geombinthe_geomshape_areathe_geomshape_areathe_geom| Photogrammetric |
| 2004-08-16T00:00:00.000Z |
| Demolition |
| 62.950159437834515 |
| {"type":"MultiPolygon","coordinates":[[[[-73.9471949217,40.752091154897],[-73.947245589005,40.752039471865],[-73.947250622551,40.752042361645],[-73.947259288928,40.752032590193],[-73.947265228278,40.752035636838],[-73.947361000779,40.751927650794],[-73.947392765684,40.751943942347],[-73.94743122324,40.751900579848],[-73.947571588422,40.751742314403],[-73.947662338142,40.751788860622],[-73.947844287135,40.751882182922],[-73.947491687933,40.752243368112],[-73.947460970933,40.752227613663],[-73.9471949217,40.752091154897]]]]} | 4005284 | 618591 | 2466.46875 | 4004590005 | 1243 | 2008 | 2007 | Photogrammetric | 2009-04-30T00:00:00.000Z | Demolition | 214.3426066890475 |
| {"type":"MultiPolygon","coordinates":[[[[-73.900418889555,40.866052114257],[-73.900600120833,40.866127703069],[-73.900542008687,40.866208004047],[-73.900360766427,40.866132404157],[-73.900418889555,40.866052114257]]]]} | 2086821 | 846184 | 310.453125 | 2032040029 | 5824 | 0 | 2004 | Photogrammetric | 2007-09-04T00:00:00.000Z | Demolition | 73.029586146809265 |
| {"type":"MultiPolygon","coordinates":[[[[-74.147675233225,40.538845183061],[-74.147696360057,40.538860186502],[-74.147705122707,40.538852997534],[-74.147736522862,40.538875280729],[-74.147665099943,40.538933837204],[-74.147676746195,40.538942106082],[-74.147610763906,40.538996195198],[-74.147546605045,40.538950639598],[-74.147675233225,40.538845183061]]]]} | 5068309 | 435925 | 194.5546875 | 5053070130 | 8490 | 2009 | 2005 | Photogrammetric | 2007-09-12T00:00:00.000Z | Demolition | 64.547683797375072 |
| {"type":"MultiPolygon","coordinates":[[[[-73.955802770994,40.734835583053],[-73.95581273158,40.734903953218],[-73.955757180874,40.73490980292],[-73.955727362082,40.734746042155],[-73.955785362885,40.734739932656],[-73.955802770994,40.734835583053]]]]} | 3336692 | 846143 | 156.9140625 | 3025040034 | 7618 | 2005 | 2004 | Other (Manual) | 2007-09-20T00:00:00.000Z | Demolition | 61.338389846100981 |
| {"type":"MultiPolygon","coordinates":[[[[-73.922882098457,40.693220256127],[-73.922932666864,40.693248124716],[-73.922846138089,40.693339080578],[-73.922795569649,40.693311211952],[-73.922882098457,40.693220256127]]]]} | 3075590 | 0 | 114.5859375 | 3033040010 | 4066 | 1996 | 2004 | Other (Manual) | 2004-08-16T00:00:00.000Z | Demolition | 46.849260818752413 |
| {"type":"MultiPolygon","coordinates":[[[[-73.895229740662,40.733073209475],[-73.895230413273,40.733081449847],[-73.895280279216,40.73307916216],[-73.89528463157,40.73313375384],[-73.895234328945,40.733136068578],[-73.895233168265,40.733121550504],[-73.895072441595,40.733128979696],[-73.895068588327,40.733080643764],[-73.895229740662,40.733073209475]]]]} | 4057383 | 129673 | 172.63671875 | 4024780037 | 6944 | 2005 | 2005 | Photogrammetric | 2007-09-07T00:00:00.000Z | Demolition | 65.566958900904666 |
| {"type":"MultiPolygon","coordinates":[[[[-74.108199216725,40.577014544953],[-74.108159077903,40.576986766201],[-74.108166384581,40.576980626738],[-74.108163048314,40.576978317381],[-74.108209228656,40.576939522034],[-74.108210968595,40.576938060159],[-74.108231503349,40.57695227332],[-74.108258207005,40.57697075364],[-74.108209764566,40.57701144917],[-74.108206002142,40.577008845835],[-74.108199216725,40.577014544953]]]]} | 5140056 | 884251 | 63.97265625 | 5036100035 | 2269 | 2008 | 2004 | Photogrammetric | 2009-07-10T00:00:00.000Z | Demolition | 32.562332748668616 |
| {"type":"MultiPolygon","coordinates":[[[[-73.974912389072,40.605311556571],[-73.97492156098,40.605370947736],[-73.974850320445,40.605377335781],[-73.974841152204,40.605317936377],[-73.974912389072,40.605311556571]]]]} | 3177054 | 0 | 70.0234375 | 3066550054 | 8421 | 2002 | 2002 | Other (Manual) | 2005-01-31T00:00:00.000Z | Demolition | 33.507565617257406 |
| {"type":"MultiPolygon","coordinates":[[[[-73.892005385983,40.701692927329],[-73.891920667273,40.701809176583],[-73.891857124008,40.701782127593],[-73.89194372793,40.701664323871],[-73.891964811685,40.701673294352],[-73.891978389501,40.701669354629],[-73.891999401042,40.701678379931],[-73.892005385983,40.701692927329]]]]} | 4089244 | 846155 | 164.6640625 | 4036750060 | 4306 | 0 | 2004 | Photogrammetric | 2007-09-18T00:00:00.000Z | Demolition | 56.652936017398481 |
Showing 12 of 13 columns. All of them are listed below.
131.1796875132.9726562545.0390625base_bbl | text | — | 0% | 416350040040000000004163400050 |
objectid | integer | — | 0% | 163361005148498 |
construction_year | integer | — | 3% | 019201930 |
demolition_year | integer | — | 6% | 200620072005 |
feature_code | categorical | — | 59% | 210051105100of 10 |
geom_source | categorical | — | 4% | PhotogrammetricOther (Manual)Placeholderof 3 |
ground_elevation | integer | — | 60% | 867 |
height_roof | integer | — | 39% | 101213 |
last_edited_date | datetime | — | 0% | 2007-09-11T00:00:00.000Z2005-01-31T00:00:00.000Z2004-08-16T00:00:00.000Z |
last_status_type | categorical | — | 0% | DemolitionAlterationConstructedof 12 |
mappluto_bbl | text | — | 66% | 416350040041634000504142600001 |
shape_length | float | — | 0% | 51.1992150949008572.43791876622728452.388040965893147 |