From a 500-row sample across 34 columns.
Mappable — Socrata point column `location_lat_long`.
Open on the map →| objectid | borough | type | provider | name | location | latitude | longitude | x | y | location_t | remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10604 | 4 | Limited Free | SPECTRUM | Baisley Pond Park | Park Perimeter | 40.67485999990 | -73.78412000050 | 1044131.89696000000 | 185219.89207700000 | Outdoor TWC Aerial | 3 free 10 min sessions |
| 10555 | 4 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
objectid | integer | Identification number automatically generated by map software ArcMap. | 0% | 101011026912616 |
borough | categorical | Borough of New York City. MN = Manhattan BX = Bronx BK = Brooklyn QU = Queens SI = Staten Island | 0% | 134of 5 |
type | categorical | Type of WiFi provided by franchise. | 0% | FreeLimited FreePartner Siteof 3 |
provider | categorical | Franchise who is providing the Wifi connection. | 0% |
GET /api/datasets/yjub-udmw GET /api/datasets/yjub-udmw/quality GET /api/datasets/yjub-udmw/related GET /api/columns?dataset=yjub-udmw
binnamelatitude+4:@computed_region_92fq_4b7qbin:@computed_region_yeji_bk3q+7latitudezipcity+1binlatitudebbl+2binlatitudebbl+1| Limited Free |
| SPECTRUM |
| Kissena Park |
| Park Perimeter |
| 40.74755999960 |
| -73.81814999970 |
| 1034637.51076000000 |
| 211685.21775500000 |
| Outdoor TWC Aerial |
| 3 free 10 min sessions |
| 12370 | 3 | Free | Transit Wireless | Grand St (L) | Grand St (L) | 40.71192599970 | -73.94066999940 | 1000698.12752000000 | 198655.90884000000 | Subway Station | SN 123 |
| 9893 | 3 | Free | Downtown Brooklyn | — | 125 Court St. | 40.68998500010 | -73.99199500040 | 986469.96634900000 | 190656.68041600000 | Outdoor | — |
| 10169 | 1 | Free | Transit Wireless | Lexington Av-63 St (F) | Lexington Av-63 St (F) | 40.76463000020 | -73.96611500010 | 993636.55208100000 | 217853.88816100000 | Subway Station | SN 223 |
| 10880 | 4 | Limited Free | SPECTRUM | Kissena Park | Park Perimeter | 40.74243000030 | -73.81151000030 | 1036481.35944000000 | 209820.08861200000 | Outdoor TWC Aerial | 3 free 10 min sessions |
| 10953 | 1 | Free | Harlem | — | Pole 94 - LenWS1N133 | 40.81294400000 | -73.94169299960 | 1000390.02217000000 | 235459.89330300000 | Outdoor | — |
| 11018 | 3 | Free | BPL | Clinton Hill - Brooklyn Public Library | 380 WASHINGTON AVENUE | 40.68737909410 | -73.96603066600 | 993670.82793100000 | 189708.99792800000 | Library | — |
| 12375 | 4 | Free | Transit Wireless | Halsey St (L) | Halsey St (L) | 40.69560200010 | -73.90408400040 | 1010847.41694000000 | 192717.57885400000 | Subway Station | SN 129 |
| 12607 | 3 | Free | Transit Wireless | Broadway Junction (A,C,J,L,Z) | Broadway Junction (A,C,J,L,Z) | 40.67833400020 | -73.90531600010 | 1010512.58493000000 | 186425.97529500000 | Subway Station | SN 184 |
Showing 12 of 34 columns. All of them are listed below.
LinkNYC - CitybridgeSPECTRUMTransit Wirelessof 17 |
name | text | The name of the location where the WiFi is located. | 7% | 0Governors IslandCrotona Park |
location | text | A brief description of where the WiFi point is. | 0% | Park PerimeterAlong Boardwalk and Beac…300 Jay Street |
latitude | float | Latitude: Points that fall North or South of the Equator, expressed in degrees. | 0% | 40.6871910000040.8126809996040.71024999990 |
longitude | float | Longitude: Points that fall East or West of the Prime Meridian, expressed in degrees. | 0% | -73.76955899960-73.99797999990-73.93935699960 |
x | float | X-Coordinate: A horizontal value where a point is located. | 0% | 1048159.07427000000984810.021178000001001036.71904000000 |
y | float | Y-Coordinate: A vertical value where a point is located. | 0% | 189722.70557800000235364.51193200000198039.72765800000 |
location_t | categorical | The type of location that a WiFi hotspot is present in. | 0% | Outdoor KioskOutdoorSubway Stationof 16 |
remarks | text | Comments describing a specific hotspot or location. | 17% | Tablet Internet -phone ,…3 free 10 min sessionsFree - up to 5 mbs |
city | text | The city in which a hotspot is located. | 0% | New YorkBrooklynQueens |
ssid | categorical | The name of the WiFi seen on people's devices. | 0% | LinkNYC Free Wi-FiGuestWiFiTransitWirelessWiFiof 16 |
sourceid | text | A LinkNYC Kiosk's unique identification number. | 32% | 0Governors Island TrustNYC HOUSING AUTHORITY |
activated | datetime | The approximated date that this Wi-Fi site went active | 0% | 9999-09-09T00:00:00.0002016-07-19T00:00:00.0002016-07-21T00:00:00.000 |
borocode | categorical | The New York City borough where the hotspots are located. | 0% | 134of 5 |
boroname | categorical | The New York City borough where the hotspots are located. | 0% | ManhattanBrooklynQueensof 5 |
ntacode | text | Four (4) digit code assigned to neighborhoods to differentiate NYC's five boroughs. | 0% | MN17MN13MN12 |
ntaname | text | Neighborhood identifiers to differentiate NYC's five boroughs. | 0% | Midtown-Midtown SouthHudson Yards-Chelsea-Fla…Upper West Side |
coundist | integer | NYC City Council District number | 0% | 3.000000000004.000000000009.00000000000 |
zip | integer | United States Postal Service Zip Code (5-digits). | 0% | 112011001110025 |
borocd | integer | New York City Borough plus Community Board Numbers. | 0% | 105.00000000000106.00000000000107.00000000000 |
ct2010 | integer | 2010 U.S. Census data based on location. | 0% | 37.0000000000063.0000000000011.00000000000 |
bctcb2010 | integer | Combined value of Borough CD and Census 2010. | 0% | 37.0000000000063.0000000000011.00000000000 |
bin | integer | Building Identification Number. | 0% | 0.000000000004268835.000000000004433386.00000000000 |
bbl | integer | Borough Block Lot. | 0% | 0.000000000001000010010.000000000004124060180.00000000000 |
doitt_id | integer | Identification number automatically generated by GIS Developer map sites. | 0% | 474338084428 |
location_lat_long | coordinate | Combination of the lat and long values | — | — |