From a 500-row sample across 23 columns.
longitudelatitudecensus_tract+6longitudecommunity_boardlatitude+7longitudecommunity_boardlatitude+6longitudecommunity_boardlatitudeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| number | street | borough | block | lot | primary | x | y | geocode_status | construction_status | assignment_type | created_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 529A | WEST 29 STREET | Manhattan | 701 | 7501 | false | 983502.0 | 213247.0 | Successfully geocoded | Application | New/Permanent | 2015-11-04T00:00:00.000 |
| 477Rear | HUDSON STREET |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
number | text | — | 0% | 200130 |
street | text | — | 0% | BROADWAYMADISON AVENUE3 AVENUE |
borough | text | — | 0% | Manhattanof 1 |
block | integer | — | 0% | 1611711051 |
lot | integer | — | 0% |
GET /api/datasets/qy7q-cb9e GET /api/datasets/qy7q-cb9e/quality GET /api/datasets/qy7q-cb9e/related GET /api/columns?dataset=qy7q-cb9e
longitudecommunity_boardlatitude+7longitudecommunity_boardlatitude+6longitudecommunity_boardlatitude+6| Manhattan |
| 605 |
| 38 |
| false |
| 982429.0 |
| 205993.0 |
| Successfully geocoded |
| Application |
| Verification |
| 2016-03-30T00:00:00.000 |
| 238 1/2 | EAST 83 STREET | Manhattan | 1528 | 31 | false | 997007.761596679 | 222041.072021484 | Successfully geocoded | Completed | Tentative | 2015-02-27T00:00:00.000 |
| 188A | COLUMBUS AVENUE | Manhattan | 1140 | 32 | false | 989662.0 | 221684.0 | Successfully geocoded | Application | New/Permanent | 2017-09-14T00:00:00.000 |
| 110A | MADISON AVENUE | Manhattan | 859 | 7503 | false | 988414.0 | 210705.0 | Successfully geocoded | Application | New/Permanent | 2017-08-07T00:00:00.000 |
| 544 | WEST 39 STREET | Manhattan | 710 | 58 | true | 984470.375793457 | 215611.999206542 | Successfully geocoded | Completed | — | 2011-02-28T00:00:00.000 |
| 44 | MERCER STREET | Manhattan | 474 | 7507 | true | 983951.782592773 | 202152.740600585 | Successfully geocoded | Completed | — | 2011-02-28T00:00:00.000 |
| 581 | HUDSON STREET | Manhattan | 634 | 60 | true | 982571.382629394 | 207558.622436523 | Successfully geocoded | Completed | — | 2010-12-16T00:00:00.000 |
| 450 | WEST 33 STREET | Manhattan | 729 | 9001 | true | 984587.0 | 213816.0 | Successfully geocoded | Application | New/Permanent | 2010-12-20T00:00:00.000 |
| 446 | WEST 33 STREET | Manhattan | 729 | 9001 | false | 984748.0 | 213726.0 | Successfully geocoded | Application | New/Permanent | 2010-12-20T00:00:00.000 |
Showing 12 of 22 columns. All of them are listed below.
175017502bin | integer | — | 42% | 108279210858671059689 |
saf_type | categorical | — | 98% | Vanity addressAddressable place nameof 2 |
primary | categorical | — | 0% | falsetrue of 3 |
x | integer | — | 0% | 0.0996704.0989633.0 |
y | integer | — | 0% | 0.0208628.0202047.0 |
geocode_status | categorical | — | 0% | Successfully geocodedOutside of existing stre…Street name not recogniz…of 3 |
construction_status | categorical | — | 0% | CompletedApplicationUnder constructionof 3 |
assignment_type | categorical | — | 6% | New/PermanentTentativeVerificationof 5 |
created_date | datetime | — | 0% | 2017-06-09T00:00:00.0002012-07-12T00:00:00.0002010-12-20T00:00:00.000 |
last_modified_date | datetime | — | 0% | 2017-05-16T00:00:00.0002017-06-09T00:00:00.0002016-12-16T00:00:00.000 |
postcode | text | — | 2% | 100271001110001 |
latitude | float | — | 2% | 40.71735640.72124840.726785 |
longitude | float | — | 2% | -73.981254-73.982176-74.014163 |
community_board | categorical | — | 2% | 452of 13 |
council_district | categorical | — | 2% | 314of 10 |
census_tract | integer | — | 2% | 9911537 |
bbl | integer | — | 3% | 101051750210148000101007510001 |
nta | text | — | 2% | Hudson Yards-Chelsea-Fla…Midtown-Midtown South …SoHo-TriBeCa-Civic Cente… |