From a 500-row sample across 21 columns.
location_idcouncil_districtcommunity_boardbin+6Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| physical_address_id | location_id | address_1 | city | borough | state_province | postcode | street_number | street_name | latitude | longitude | community_board |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 40 WORTH STREET | NEW YORK | Manhattan | NY | 10013 | 40 | WORTH STREET | 40.71736223432259 | -74.00689733252743 | 101 |
| 2 | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
physical_address_id | integer | Each physical address must have a unique identifier. | 0% | 477347432591 |
location_id | integer | The identifier of the location for which this is the address. | 0% | 10432333293 |
address_1 | text | The first line(s) of the address, including office, building number and street. | 0% | NO ADDRESS56 BAY STREET999 JAMAICA AVENUE |
address_2 | text | (Deprecated) A second (additional) line of address information. (This field is deprecated: we recommend including all address information before 'city' as a comma separated list in address_1. There is no guarantee that systems will read this line of address information.) | 94% |
GET /api/datasets/922w-z7da GET /api/datasets/922w-z7da/quality GET /api/datasets/922w-z7da/related GET /api/columns?dataset=922w-z7da
physical_address_idcouncil_districtcommunity_boardbin+5| 36 RICHMOND TERRACE |
| STATEN ISLAND |
| Staten Island |
| NY |
| 10301 |
| 36 |
| RICHMOND TERRACE |
| 40.64381010324276 |
| -74.07637799273142 |
| 501 |
| 3 | 3 | 8900 SUTPHIN BOULEVARD | JAMAICA | Queens | NY | 11435 | 8900 | SUTPHIN BOULEVARD | 40.70370206272797 | -73.8087462903471 | 412 |
| 4 | 4 | 1 WEST 125 STREET | NEW YORK | Manhattan | NY | 10027 | 1 | WEST 125 STREET | 40.8065220414661 | -73.94249339477317 | 110 |
| 5 | 5 | 1118 GRAND CONCOURSE | BRONX | Bronx | NY | 10456 | 1118 | GRAND CONCOURSE | 40.83223189762735 | -73.91965477267921 | 204 |
| 6 | 6 | 349 EAST 149 STREET | BRONX | Bronx | NY | 10451 | 349 | EAST 149 STREET | 40.81666956272471 | -73.91995897030567 | 201 |
| 7 | 7 | 105 COURT STREET | BROOKLYN | Brooklyn | NY | 11201 | 105 | COURT STREET | 40.69079282675378 | -73.99182530224263 | 302 |
| 8 | 8 | 1360 FULTON STREET | BROOKLYN | Brooklyn | NY | 11216 | 1360 | FULTON STREET | 40.68018559555126 | -73.94593010588461 | 303 |
| 9 | 9 | 3049 BRIGHTON 6TH STREET | BROOKLYN | Brooklyn | NY | 11235 | 3049 | BRIGHTON 6TH STREET | 40.57843437842163 | -73.9617511906496 | 313 |
| 10 | 10 | 126-02 82 AVENUE | KEW GARDENS | Queens | NY | 11415 | 126-02 | 82 AVENUE | 40.71373155961331 | -73.82612226577379 | 409 |
Showing 12 of 17 columns. All of them are listed below.
2ND FLOOR3RD FLOOR4TH FLOOR |
city | text | The city in which the address is located. | 0% | BROOKLYNNEW YORKBRONX |
borough | categorical | The borough in which the address is located. | 0% | BrooklynManhattanBronxof 13 |
state_province | categorical | The state or province in which the address is located. | 0% | NYNJDCof 4 |
postcode | text | The postal code for the address. | 4% | 112261137210457 |
site_catchment | text | The service area if no address available. | 96% | BRONXMANHATTANBROOKLYN |
site_intersection_street_1 | text | The first street of an intersection if services are provided at an intersection. | 95% | ROOSEVELT AVENUEFULTON STREETFLATBUSH AVENUE |
site_intersection_street_2 | text | The second street of an intersection if services are provided at an intersection. | 95% | BROADWAYNOSTRAND AVENUEST NICHOLAS AVENUE |
street_number | text | The street number of the address. | 9% | 15025 |
street_name | text | The street name of the address. | 9% | BROADWAYFLATBUSH AVENUEROOSEVELT AVENUE |
latitude | float | Y coordinate of location expressed in decimal degrees in WGS84 datum. | 7% | 40.7468162274538940.640623851909540.80863835539116 |
longitude | float | X coordinate of location expressed in decimal degrees in WGS84 datum. | 7% | -73.99365540195873-74.07570414224186-73.86832784227522 |
community_board | integer | The community district for the location. | 7% | 112305314 |
council_district | integer | The city council district for the location. | 7% | 17810 |
census_tract | integer | The census tract for the site location. | 7% | 44601269263 |
bin | integer | The building identification number for the location. | 12% | 300000010150602005939 |
bbl | integer | The borough-block-lot where the site is located. | 12% | 100803750220332700012027390015 |
nta | text | The Neighborhood Tabulation Area for the site location. | 11% | MN36BK42BK82 |