From a 500-row sample across 15 columns.
feature_codenamebase_bbl+11binthe_geombinMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | bin | doitt_id | base_bbl | objectid | construction_year | demolition_year | geom_source | last_edited_date | last_status_type | feature_code | ground_elevation |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.75166, -73.86041 | 4044563 | 0 | 4017750020 | 2150 | 0 | 2003 | Photogrammetric | 2004-12-30T00:00:00.000Z | Demolition | — | — |
| 40.72355, -73.97983 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | — | 0% | {'coordinates': [-74.002…{'coordinates': [-74.002…{'coordinates': [-73.932… |
name | text | — | 91% | NO NAMEScandinavian House Found…8 Washington Place |
bin | integer | — | 0% | 400000030000005000000 |
doitt_id | integer | — | 0% | 0559819 |
GET /api/datasets/9xsq-wn7d GET /api/datasets/9xsq-wn7d/quality GET /api/datasets/9xsq-wn7d/related GET /api/columns?dataset=9xsq-wn7d
the_geomthe_geom| 1004656 |
| 97862 |
| 1003870133 |
| 35052 |
| 1920 |
| 2018 |
| Photogrammetric |
| 2020-05-26T14:40:15.000Z |
| Demolition |
| 2100 |
| 10 |
| 40.74058, -73.85889 | 4047647 | 604777 | 4019390026 | 36377 | 1925 | 2016 | Photogrammetric | 2020-10-16T18:08:33.000Z | Demolition | 2100 | 17 |
| 40.78734, -73.82532 | 4101197 | 477034 | 4044370008 | 35841 | 1930 | 2018 | Photogrammetric | 2019-07-05T19:32:09.000Z | Demolition | 2100 | 51 |
| 40.86354, -73.88271 | 2000000 | 973989 | 2032720001 | 15927 | 1897 | 2011 | Other (Manual) | 2011-09-23T00:00:00.000Z | Demolition | — | — |
| 40.72912, -73.86378 | 4462154 | 0 | 4030810139 | 28929 | 0 | 2005 | Other (Manual) | 2005-06-24T00:00:00.000Z | Demolition | — | — |
| 40.63262, -74.10944 | 5004236 | 0 | 5001540056 | 22653 | 1925 | 2002 | Photogrammetric | 2005-01-07T00:00:00.000Z | Demolition | — | — |
| 40.59470, -74.07263 | 5048148 | 0 | 5032750017 | 22191 | 2002 | 2002 | Photogrammetric | 2005-02-04T00:00:00.000Z | Demolition | — | — |
| 40.75179, -73.81558 | 4435602 | 541147 | 4052110040 | 33329 | 1915 | 2017 | Photogrammetric | 2018-09-13T16:37:33.000Z | Demolition | 5110 | 47 |
| 40.78120, -73.81076 | 4106849 | 287230 | 4047060017 | 26234 | 1920 | 2011 | Other (Manual) | 2011-05-25T00:00:00.000Z | Demolition | — | — |
Showing 12 of 14 columns. All of them are listed below.
462307base_bbl | text | — | 0% | 416350040040000000004163400050 |
objectid | integer | — | 0% | 133813950028089 |
construction_year | integer | — | 2% | 019201930 |
demolition_year | integer | — | 4% | 200620072005 |
feature_code | categorical | — | 75% | 210051105100of 8 |
geom_source | categorical | — | 5% | PhotogrammetricOther (Manual)Placeholderof 3 |
ground_elevation | integer | — | 75% | 687 |
height_roof | integer | — | 49% | 131211 |
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 9 |
mappluto_bbl | text | — | 83% | 416350040041634000503057390001 |