From a 15-row sample across 32 columns.
postcode:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+11:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+8bin:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+8Mappable — Socrata point column `location2`.
Open on the map →| site_id | planned_kiosk_type | installation_status_ | borough | council_district | cb | final_submission_a_ | gf_permit_appl_id | street_address | cross_street_1 | cross_street_2 | ixn_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| bk-16-158880 | Link1.0 | Installed | Brooklyn | 42 | 316 | 2022-01-28T00:00:00.000 | 90176 | 12 NEWPORT STREET | NEWPORT STREET | EAST 98TH STREET | W |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
site_id | categorical | The unique ID for each LinkNYC kiosk site in the format: Borough-Community Board-Payphone ID (e.g., mn-03-123265) | 0% | qu-12-157688mn-12-gf0873mn-12-GF0874of 15 |
planned_kiosk_type | categorical | Indicates style of kiosk (LINK1.0, LINK5G, and LINK5G_NoAd) or public pay phone. | 0% | Link5G_NonAdLink5G_AdLink1.0of 3 |
installation_status_ | categorical | Indicates the current status, including planning for utility connections, DOT permitting, and construction. | 0% | Ready for PreCxInstalledPreCxof 4 |
ppt_id | text | An 6-digit ID generated by the database - a unique number for each LINK and Pay Public Telephone (PPT) |
GET /api/datasets/xp25-gxux GET /api/datasets/xp25-gxux/quality GET /api/datasets/xp25-gxux/related GET /api/columns?dataset=xp25-gxux
bin:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+6binlongitudecensus_tract+4binlongitudecensus_tract+4| mn-12-gf0873 |
| Link5G_NonAd |
| PreCx |
| Manhattan |
| 10 |
| 112 |
| 2022-08-09T00:00:00.000 |
| 90245 |
| 689 FT WASHINGTON AVENUE |
| CABRINI BOULEVARD |
| FORT WASINGTON AVENUE |
| N |
| qu-12-gf44833 | Link5G_NonAd | Ready for Installation | Queens | 28 | 412 | 2022-08-09T00:00:00.000 | 90357 | 134-02 GUY R BREWER BLVD | GUY R BREWER BOULEVARD | 161ST STREET | S |
| qu-12-157688 | Link5G_Ad | Installed | Queens | 27 | 412 | 2021-10-08T00:00:00.000 | 90068 | 182-46 HILLSIDE AVENUE | HILLSIDE AVENUE | 89TH AVENUE | W |
| mn-01-gf0971 | Link5G_Ad | Ready for PreCx | Manhattan | 1 | 101 | 2024-07-25T00:00:00.000 | — | 77 WATER STREET | GOUVERNEUR LANE | OLD SLIP | — |
| mn-12-GF0874 | Link5G_NonAd | Ready for PreCx | Manhattan | 10 | 112 | 2024-03-01T00:00:00.000 | — | 701 FORT WASHINGTON AVENUE | WEST 190TH STREET | CABRINI BOULEVARD | MIDBLOCK |
| qu-10-gf44897 | Link5G_NonAd | Ready for PreCx | Queens | 28 | 410 | 2024-02-22T00:00:00.000 | — | 130-02 115TH AVENUE | 130TH STREET | 131ST STREET | SE |
| qu-12-157212 | Link5G_Ad | Installed | Queens | 27 | 412 | 2021-10-08T00:00:00.000 | 90079 | 175-06 HILLSIDE AVENUE | 175TH STREET | Hillside Ave | E |
| mn-01-gf0973 | Link5G_Ad | Ready for PreCx | Manhattan | 1 | 101 | 2024-07-25T00:00:00.000 | — | 39 SOUTH STREET | OLD SLIP | BROAD STREET | NW |
| bk-16-158935 | Link1.0 | Installed | Brooklyn | 42 | 316 | 2022-01-28T00:00:00.000 | 90175 | 9829 DITMAS AVENUE | BRISTOL STREET | CHESTER STREET | N |
Showing 12 of 31 columns. All of them are listed below.
| 93% |
119917of 1 |
legacy_id | text | The ID number for the LinkNYC kiosk | 100% | — |
borough | categorical | The New York City borough where the hotspots are located. | 0% | ManhattanQueensBrooklynof 3 |
council_district | categorical | Council District is the lawmaking body of the City of New York. There are 51 districts throughout NYC's five boroughs. | 0% | 10127of 8 |
cb | categorical | Community Board: An appointed advisory group from a variety of districts throughout NYC's five boroughs. They deal with issues such as zoning, land usage, and any other matter related to the quality of life of their residents. | 0% | 112101316of 7 |
final_submission_a_ | datetime | Submission Date from vendor for review. | 0% | 2024-07-25T00:00:00.0002022-08-09T00:00:00.0002021-10-08T00:00:00.000of 8 |
gf_permit_appl_id | categorical | The new site permit application number. | 53% | 901769007990245of 7 |
gf_doitt_submitted_to_cb_a | datetime | Information Submitted to Community Board on this date | 13% | 2025-05-27T00:00:00.0002025-05-05T00:00:00.0002024-12-12T00:00:00.000of 7 |
gf_cb_comment_period_ends_a | datetime | Community Board Comment Period Ends on this date | 13% | 2025-08-05T00:00:00.0002025-07-26T00:00:00.0002021-12-27T00:00:00.000of 7 |
street_address | categorical | The name of the street that a site is located on. | 0% | 689 FT WASHINGTON AVENUE1412 EASTERN PARKWAY12 NEWPORT STREETof 15 |
cross_street_1 | categorical | One of the closest streets to a potential LinkNYC site. | 0% | WEST 190TH STREETEAST 86TH STREET130TH STREETof 15 |
cross_street_2 | categorical | One of the closest streets to a potential LinkNYC site. | 0% | 89TH AVENUE54th AveOLD SLIPof 15 |
ixn_code | categorical | The direction the Kiosk is facing. | 13% | NEWof 9 |
postcode | categorical | Five (5) digit postal code assigned by the United States Postal Service. | 0% | 100401000411101of 13 |
zoningnumb | categorical | The type of zoning a kiosk is located in, displayed by its first letter followed by its zone. | 0% | R7-2C2-4C6-9of 10 |
longitude | categorical | Points that fall East or West of the Prime Meridian, expressed in degrees. | 0% | -73.9588655-73.9214-73.7877of 15 |
latitude | categorical | Points that fall North or South of the Equator, expressed in degrees. | 0% | 40.704230240.7136340.7157307of 15 |
greenfield_in_bid_location | categorical | Is the LinkNYC Kiosk located in a Business Improvement District (BID)? | 20% | NoYesof 2 |
bid | categorical | Is the LinkNYC Kiosk located in a Business Improvement District (BID)? | 80% | Downtown Alliance BIDMadison AVE BIDof 2 |
historic_district | text | Is the LinkNYC Kiosk located in a historic district? | 60% | 0of 1 |
historic_district_name | text | Name of historic district determined by the Landmarks Preservation Commission (LPC). | 100% | — |
neighborhood_tabulation_area_nta | categorical | Neighborhood identifiers to differentiate NYC's five boroughs | 0% | Washington Heights NorthFinancial District-Batte…Brownsvilleof 9 |
bin | categorical | Every real estate property has an assigned 7-digit number issued by the Department of City Planning. | 13% | 108751810468421000863of 13 |
bbl | categorical | Every real estate property is identified by a set of 3 numbers for taxes, zoning, construction, and other purposes. | 7% | 400015000140983400101021790600of 14 |
census_tract | categorical | Census Tract (CT) - Permanent statistical subdivisions to provide a stable set of geographic units for the presentation of statistical data | 0% | MH-2731000900QU-470of 14 |
location2 | coordinate | — | 0% | {'coordinates': [-74.007…{'coordinates': [-73.778…{'coordinates': [-73.935…of 15 |