NYC Wi-Fi Hotspot Locations

Contract version 20260907135534-4d303bfcde99

Detected: 2026-09-07T13:55:34+00:00
Source updated: Fri, 20 Sep 2024 02:21:00 GMT
Rows: 3319

Source Files For 20260907135534-4d303bfcde99

NYC_Wi-Fi_Hotspot_Locations.csv: source

Open Data Contract YAML

dataset_id: nyc-wifi-hotspot-locations
title: NYC Wi-Fi Hotspot Locations
description: NYC Wi-Fi Hotspot Locations discovered from data.cityofnewyork.us.
source_name: data.cityofnewyork.us
source_url: https://data.cityofnewyork.us/api/views/yjub-udmw/rows.csv?accessType=DOWNLOAD
update_frequency: monthly
next_scan_at: '2026-09-08T13:55:35.226377+00:00'
license:
  name: NYC Open Data terms of use
  url: https://opendata.cityofnewyork.us/overview/#termsofuse
tags:
- data.cityofnewyork.us
geography:
- United States
- New York City
revisions:
- revision_id: 20260907135534-4d303bfcde99
  detected_at: '2026-09-07T13:55:34+00:00'
  source_updated_at: Fri, 20 Sep 2024 02:21:00 GMT
  context: NYC_Wi-Fi_Hotspot_Locations.csv detected from rows.csv.
  assets:
  - asset_id: asset-9fe55d64eba26b22
    name: NYC_Wi-Fi_Hotspot_Locations.csv
    source_url: https://data.cityofnewyork.us/api/views/yjub-udmw/rows.csv?accessType=DOWNLOAD
    media_type: text/csv; charset=utf-8
    content_hash: 9fe55d64eba26b22d9178d11735305632c125af9f9bb1db8f760786a3ae56de0
    size_bytes: 1083204
    parent_archive_id: null
  row_count: 3319
  headers:
  - OBJECTID
  - Borough
  - Type
  - Provider
  - Name
  - Location
  - Latitude
  - Longitude
  - X
  - Y
  - Location_T
  - Remarks
  - City
  - SSID
  - SourceID
  - Activated
  - BoroCode
  - Borough Name
  - Neighborhood Tabulation Area Code (NTACODE)
  - Neighborhood Tabulation Area (NTA)
  - Council Distrcit
  - Postcode
  - BoroCD
  - Census Tract
  - BCTCB2010
  - BIN
  - BBL
  - DOITT_ID
  - Location (Lat, Long)
  sample_rows:
  - OBJECTID: '10604'
    Borough: '4'
    Type: Limited Free
    Provider: SPECTRUM
    Name: Baisley Pond Park
    Location: Park Perimeter
    Latitude: '40.6748599999'
    Longitude: '-73.7841200005'
    X: '1044131.89696'
    Y: '185219.892077'
    Location_T: Outdoor TWC Aerial
    Remarks: 3 free 10 min sessions
    City: Queens
    SSID: GuestWiFi
    SourceID: '0'
    Activated: 09/09/9999
    BoroCode: '4'
    Borough Name: Queens
    Neighborhood Tabulation Area Code (NTACODE): QN02
    Neighborhood Tabulation Area (NTA): Springfield Gardens North
    Council Distrcit: '28'
    Postcode: '11434'
    BoroCD: '412'
    Census Tract: '294'
    BCTCB2010: '294'
    BIN: '0'
    BBL: '0'
    DOITT_ID: '1408'
    Location (Lat, Long): (40.6748599999, -73.7841200005)
  - OBJECTID: '10555'
    Borough: '4'
    Type: Limited Free
    Provider: SPECTRUM
    Name: Kissena Park
    Location: Park Perimeter
    Latitude: '40.7475599996'
    Longitude: '-73.8181499997'
    X: '1034637.51076'
    Y: '211685.217755'
    Location_T: Outdoor TWC Aerial
    Remarks: 3 free 10 min sessions
    City: Queens
    SSID: GuestWiFi
    SourceID: '0'
    Activated: 09/09/9999
    BoroCode: '4'
    Borough Name: Queens
    Neighborhood Tabulation Area Code (NTACODE): QN22
    Neighborhood Tabulation Area (NTA): Flushing
    Council Distrcit: '20'
    Postcode: '11355'
    BoroCD: '407'
    Census Tract: '845'
    BCTCB2010: '845'
    BIN: '0'
    BBL: '0'
    DOITT_ID: '1359'
    Location (Lat, Long): (40.7475599996, -73.8181499997)
  - OBJECTID: '12370'
    Borough: '3'
    Type: Free
    Provider: Transit Wireless
    Name: Grand St (L)
    Location: Grand St (L)
    Latitude: '40.7119259997'
    Longitude: '-73.9406699994'
    X: '1000698.12752'
    Y: '198655.90884'
    Location_T: Subway Station
    Remarks: SN 123
    City: Brooklyn
    SSID: TransitWirelessWiFi
    SourceID: ''
    Activated: 09/09/9999
    BoroCode: '3'
    Borough Name: Brooklyn
    Neighborhood Tabulation Area Code (NTACODE): BK90
    Neighborhood Tabulation Area (NTA): East Williamsburg
    Council Distrcit: '34'
    Postcode: '11206'
    BoroCD: '301'
    Census Tract: '495'
    BCTCB2010: '495'
    BIN: '0'
    BBL: '0'
    DOITT_ID: '1699'
    Location (Lat, Long): (40.7119259997, -73.9406699994)
  - OBJECTID: '9893'
    Borough: '3'
    Type: Free
    Provider: Downtown Brooklyn
    Name: ''
    Location: 125 Court St.
    Latitude: '40.6899850001'
    Longitude: '-73.9919950004'
    X: '986469.966349'
    Y: '190656.680416'
    Location_T: Outdoor
    Remarks: ''
    City: Brooklyn
    SSID: Downtown Brooklyn WiFi
    SourceID: ''
    Activated: 09/09/9999
    BoroCode: '3'
    Borough Name: Brooklyn
    Neighborhood Tabulation Area Code (NTACODE): BK09
    Neighborhood Tabulation Area (NTA): Brooklyn Heights-Cobble Hill
    Council Distrcit: '33'
    Postcode: '11201'
    BoroCD: '302'
    Census Tract: '9'
    BCTCB2010: '9'
    BIN: '3388736'
    BBL: '3002777501'
    DOITT_ID: '298'
    Location (Lat, Long): (40.6899850001, -73.9919950004)
  - OBJECTID: '10169'
    Borough: '1'
    Type: Free
    Provider: Transit Wireless
    Name: Lexington Av-63 St (F)
    Location: Lexington Av-63 St (F)
    Latitude: '40.7646300002'
    Longitude: '-73.9661150001'
    X: '993636.552081'
    Y: '217853.888161'
    Location_T: Subway Station
    Remarks: SN 223
    City: New York
    SSID: TransitWirelessWiFi
    SourceID: ''
    Activated: 09/09/9999
    BoroCode: '1'
    Borough Name: Manhattan
    Neighborhood Tabulation Area Code (NTACODE): MN40
    Neighborhood Tabulation Area (NTA): Upper East Side-Carnegie Hill
    Council Distrcit: '4'
    Postcode: '10065'
    BoroCD: '108'
    Census Tract: '120'
    BCTCB2010: '120'
    BIN: '0'
    BBL: '0'
    DOITT_ID: '599'
    Location (Lat, Long): (40.7646300002, -73.9661150001)
  parser_errors: []
  logical_asset_id: null
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: null

Revision dbt Source YAML

Open raw YAML

version: 2
sources:
- name: nyc_wifi_hotspot_locations
  description: NYC Wi-Fi Hotspot Locations discovered from data.cityofnewyork.us.
  meta:
    opendataodc:
      dataset_id: nyc-wifi-hotspot-locations
      revision_id: 20260907135534-4d303bfcde99
      detected_at: '2026-09-07T13:55:34+00:00'
      source_url: https://data.cityofnewyork.us/api/views/yjub-udmw/rows.csv?accessType=DOWNLOAD
  tables:
  - name: nyc_wi_fi_hotspot_locations_csv
    description: Source asset NYC_Wi-Fi_Hotspot_Locations.csv.
    meta:
      opendataodc:
        source_url: https://data.cityofnewyork.us/api/views/yjub-udmw/rows.csv?accessType=DOWNLOAD
        content_hash: 9fe55d64eba26b22d9178d11735305632c125af9f9bb1db8f760786a3ae56de0
        row_count: 3319
        parser_errors: []
    columns:
    - name: OBJECTID
    - name: Borough
    - name: Type
    - name: Provider
    - name: Name
    - name: Location
    - name: Latitude
    - name: Longitude
    - name: X
    - name: Y
    - name: Location_T
    - name: Remarks
    - name: City
    - name: SSID
    - name: SourceID
    - name: Activated
    - name: BoroCode
    - name: Borough Name
    - name: Neighborhood Tabulation Area Code (NTACODE)
    - name: Neighborhood Tabulation Area (NTA)
    - name: Council Distrcit
    - name: Postcode
    - name: BoroCD
    - name: Census Tract
    - name: BCTCB2010
    - name: BIN
    - name: BBL
    - name: DOITT_ID
    - name: Location (Lat, Long)

Sample Rows

OBJECTID	Borough	Type	Provider	Name	Location	Latitude	Longitude	X	Y	Location_T	Remarks	City	SSID	SourceID	Activated	BoroCode	Borough Name	Neighborhood Tabulation Area Code (NTACODE)	Neighborhood Tabulation Area (NTA)	Council Distrcit	Postcode	BoroCD	Census Tract	BCTCB2010	BIN	BBL	DOITT_ID	Location (Lat, Long)
10604	4	Limited Free	SPECTRUM	Baisley Pond Park	Park Perimeter	40.6748599999	-73.7841200005	1044131.89696	185219.892077	Outdoor TWC Aerial	3 free 10 min sessions	Queens	GuestWiFi	0	09/09/9999	4	Queens	QN02	Springfield Gardens North	28	11434	412	294	294	0	0	1408	(40.6748599999, -73.7841200005)
10555	4	Limited Free	SPECTRUM	Kissena Park	Park Perimeter	40.7475599996	-73.8181499997	1034637.51076	211685.217755	Outdoor TWC Aerial	3 free 10 min sessions	Queens	GuestWiFi	0	09/09/9999	4	Queens	QN22	Flushing	20	11355	407	845	845	0	0	1359	(40.7475599996, -73.8181499997)
12370	3	Free	Transit Wireless	Grand St (L)	Grand St (L)	40.7119259997	-73.9406699994	1000698.12752	198655.90884	Subway Station	SN 123	Brooklyn	TransitWirelessWiFi		09/09/9999	3	Brooklyn	BK90	East Williamsburg	34	11206	301	495	495	0	0	1699	(40.7119259997, -73.9406699994)
9893	3	Free	Downtown Brooklyn		125 Court St.	40.6899850001	-73.9919950004	986469.966349	190656.680416	Outdoor		Brooklyn	Downtown Brooklyn WiFi		09/09/9999	3	Brooklyn	BK09	Brooklyn Heights-Cobble Hill	33	11201	302	9	9	3388736	3002777501	298	(40.6899850001, -73.9919950004)
10169	1	Free	Transit Wireless	Lexington Av-63 St (F)	Lexington Av-63 St (F)	40.7646300002	-73.9661150001	993636.552081	217853.888161	Subway Station	SN 223	New York	TransitWirelessWiFi		09/09/9999	1	Manhattan	MN40	Upper East Side-Carnegie Hill	4	10065	108	120	120	0	0	599	(40.7646300002, -73.9661150001)