From a 500-row sample across 17 columns.
the_geomnamebin+11bin:@computed_region_f5dn_yrer:@computed_region_sbqj_enih+2the_geombin:@computed_region_f5dn_yrer+3the_geomMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | bin | doitt_id | base_bbl | objectid | construction_year | feature_code | geom_source | ground_elevation | height_roof | last_edited_date | last_status_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.67117, -73.94670 | 3032417 | 672968 | 3012560076 | 1026585 | 1910 | 2100 | Photogrammetric | 97 | 25.87 | 2020-01-28T17:16:14.000Z | Constructed |
| 40.74197, -73.82184 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry column used for mapping | 0% | {'coordinates': [-73.848…{'coordinates': [-73.936…{'coordinates': [-73.946… |
name | text | Building name (limited to commonly known names). This field has not been actively maintained since the original creation of this dataset. | 100% | Adler Place Town HousesCooper Place Town HousesBroun Place Town Houses |
bin | integer | Building Identification Number. A number assigned by City Planning and used by Dept. of Buildings to reference information pertaining to an individual building. The first digit is a borough code (1 = Manhattan, 2 = The Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island). The remaining 6 digits are unique for buildings within that borough. In some cases where these 6 digits are all zeros (e.g. 1000000, 2000000, etc.) the BIN is unassigned or unknown. | 0% |
GET /api/datasets/u9wf-3gbt GET /api/datasets/u9wf-3gbt/quality GET /api/datasets/u9wf-3gbt/related GET /api/columns?dataset=u9wf-3gbt
the_geom| 4140548 |
| 328604 |
| 4064170022 |
| 807856 |
| 1940 |
| 2100 |
| Photogrammetric |
| 46 |
| 27.03 |
| 2017-08-22T19:31:41.000Z |
| Constructed |
| 40.79000, -73.81532 | 4481285 | 909628 | 4045040044 | 395837 | 1935 | 5110 | Photogrammetric | 79 | 12.42 | 2017-08-17T16:19:27.000Z | Constructed |
| 40.63184, -74.12109 | 5156295 | 499359 | 5002210040 | 617587 | 1920 | 5110 | Photogrammetric | 50 | 11.44 | 2017-08-17T16:43:04.000Z | Constructed |
| 40.73928, -73.72058 | 4174700 | 151224 | 4085710041 | 647287 | 1955 | 2100 | Photogrammetric | 104 | 23.086432 | 2017-08-22T17:41:54.000Z | Constructed |
| 40.66986, -73.73949 | 4528398 | 959316 | 4131750004 | 314366 | 1925 | 5110 | Photogrammetric | 22 | 11.72780452 | 2017-08-17T16:31:15.000Z | Constructed |
| 40.58866, -74.18964 | 5041858 | 298781 | 5026430007 | 656115 | 1901 | 2100 | Photogrammetric | 24 | 29.97 | 2017-08-22T17:29:42.000Z | Constructed |
| 40.60586, -73.74684 | 4516775 | 878406 | 4155160012 | 507264 | 1920 | 5110 | Photogrammetric | 28 | 12.0526642 | 2017-08-17T16:23:51.000Z | Constructed |
| 40.64195, -73.94048 | 3424240 | 1187983 | 3049550053 | 598040 | 1920 | 5110 | Photogrammetric | 35 | 10.18 | 2017-08-17T16:35:27.000Z | Constructed |
| 40.59500, -73.99115 | 3186124 | 152684 | 3068780012 | 847929 | 1930 | 2100 | Photogrammetric | 9 | 26.25 | 2017-08-22T15:27:42.000Z | Constructed |
Showing 12 of 17 columns. All of them are listed below.
400000030000005000000doitt_id | integer | Consistent unique identifier assigned by OTI (formerly DOITT). | 0% | 765228895878639712 |
base_bbl | text | Borough, block, and lot number for the tax lot that the footprint is physically located within. | 0% | 416350040041635003004163400050 |
objectid | integer | — | 0% | 527545799817932 |
construction_year | integer | — | 1% | 192019301925 |
feature_code | categorical | — | 0% | 210051105100of 11 |
geom_source | categorical | — | 0% | PhotogrammetricOther (Manual)Otherof 3 |
ground_elevation | integer | — | 0% | 103028 |
height_roof | integer | — | 0% | 302827 |
last_edited_date | datetime | — | 0% | 2009-02-14T00:00:00.000Z2015-01-01T00:00:00.000Z2012-01-01T00:00:00.000Z |
last_status_type | categorical | — | 0% | ConstructedAlterationMarked for Constructionof 12 |
mappluto_bbl | text | — | 0% | 416350040041635003004163400050 |