From a 500-row sample across 23 columns.
longitudelatitudeborough+2longitudelatitudecommunity_board+1longitudelatitudecommunity_board+1longitudelatitudecommunity_board+1Mappable — coordinate pair `latitude` / `x_coord`.
Open on the map →| id | reservation_date | franchisee | status | pole_type | borough | x_coord | y_coord | latitude | longitude | zone | on_street |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 29696 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1000101.4570000 | 209373.7690000 | 40.7413450 | -73.9427970 | B | 49th Avenue |
| 29695 | 2026-09-04T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
id | integer | ID number associated with pole | 0% | 16096541410093 |
reservation_date | datetime | The date that pole was reserved by franchisee | 0% | 2018-08-02T00:00:00.0002017-12-29T00:00:00.0002016-09-09T00:00:00.000 |
franchisee | categorical | Franchisee name e.g. Mobilitie, Crown Castle, etc. | 0% | Crown Castle NGExtenet IICrown Castle Solutionsof 12 |
status | categorical | Status of pole reservation e.g. “Proposed” (franchisee has submitted an application but has not yet received City approval), “Approved” (pole reservation has been approved by the City), “Installed” (franchisee has completed construction). |
GET /api/datasets/tbgj-tdd6 GET /api/datasets/tbgj-tdd6/quality GET /api/datasets/tbgj-tdd6/related GET /api/columns?dataset=tbgj-tdd6
boroughcommunity_boardstatus| NY SMSA |
| Proposed |
| UTILITY |
| Queens |
| 1001328.8000000 |
| 218660.2000000 |
| 40.7668316 |
| -73.9383443 |
| B |
| Vernon Boulevard |
| 29694 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1039091.8500000 | 207083.5300000 | 40.7349030 | -73.8021117 | B | 67th Avenue |
| 29693 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1039307.5800000 | 220991.5800000 | 40.7730757 | -73.8012194 | B | 163rd Street |
| 29692 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1052791.3500000 | 215514.7000000 | 40.7579488 | -73.7525935 | B | Horatio Parkway |
| 29691 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1036482.9000000 | 207873.0000000 | 40.7370857 | -73.8115196 | B | 157th Street |
| 29690 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1053454.6000000 | 184712.6000000 | 40.6733996 | -73.7505161 | B | 138th Avenue |
| 29689 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1034524.7000000 | 229488.2500000 | 40.7964252 | -73.8184240 | B | 149th Place |
| 29688 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1035872.0900000 | 229092.1490000 | 40.7953303 | -73.8135607 | B | 7th Avenue |
| 29687 | 2026-09-04T00:00:00.000 | NY SMSA | Proposed | UTILITY | Queens | 1032035.0000000 | 218698.0000000 | 40.7668227 | -73.8274927 | B | 34th Avenue |
Showing 12 of 17 columns. All of them are listed below.
| 0% |
InstalledApprovedProposedof 3 |
installation_date | datetime | The date that the equipment installation was completed | 49% | 2009-02-18T00:00:00.0002018-12-26T00:00:00.0002016-05-11T00:00:00.000 |
pole_type | categorical | City-owned light pole or privately-owned wooden utility pole | 0% | CITYUTILITYof 2 |
borough | categorical | Borough - Manhattan, Bronx, Brooklyn, Queens, and Staten Island | 0% | ManhattanBronxQueensof 5 |
x_coord | integer | The x coordinate is a given number of pixels along the horizontal axis based on the World Geodetic System (WGS1984) standard. This Property Level Information x coordinate is approximated to the location based on the address range. | 0% | 989226.0000000989655.0000000987985.0000000 |
y_coord | integer | The y coordinate is a given number of pixels along the vertical axis based on the World Geodetic System (WGS1984) standard. This Property Level Information y coordinate is approximated to the location based on the address range. | 0% | 216258.0000000209707.0000000198343.0000000 |
latitude | coordinate | Points that fall North or South of the Equator, expressed in degrees. | 0% | 40.718940040.752741540.8722598 |
longitude | coordinate | Points that fall East or West of the Prime Meridian, expressed in degrees. | 0% | -74.0045970-73.9825413-73.8814074 |
zone | categorical | A, B, and C ("Zone A” means the portion of the Borough of Manhattan which includes 96th Street (inclusive of the northernmost boundary of the north side sidewalk of 96th Street) and all parts of said Borough that lie south of 96th Street. “Zone B” means all portions of the City not within Zone A or Zone C. “Zone C” means Community Districts 1, 2, 4, 5, and 7 in the Borough of the Bronx and Community Districts 13 and 16 in the Borough of Brooklyn.”) | 0% | BACof 3 |
on_street | text | On Street - Various names, i.e. “Barnes Ave”, “E 219 ST”, etc. | 0% | Broadway5th Ave3rd Ave |
cross_street_1 | text | Cross street 1 - Various names, i.e. “Barnes Ave”, “E 219 ST”, etc. | 0% | Broadway5th Ave6th Ave |
cross_street_2 | text | Cross street 2- Various names, i.e. “Barnes Ave”, “E 219 ST”, etc. | 0% | Dead EndBroadway6th Ave |
park_advisory | text | The pole is located within a Department of Parks and Recreation (“Parks”) property. | 93% | Central ParkGREENSTREETRiverside Park |
historic_advisory | text | The pole is located in or near a historic district under the jurisdiction of the Landmarks Preservation Commission (LPC). | 92% | Greenwich Village Histor…Upper East Side Historic…Brooklyn Heights Histori… |
scenic_landmark_advisory | categorical | The pole is located adjacent to a scenic landmark under the jurisdiction of the Landmarks Preservation Commission (LPC). | 98% | Central ParkRiverside Park and River…Prospect Parkof 10 |
bid_advisory | text | The pole is within a Business Improvement District (BID). | 87% | Downtown Alliance BIDTimes Square BIDFlatiron/23rd Street Par… |
school_advisory | text | The pole is located within 20 feet of a school. | 98% | BERLITZ SCHOOL 51 STPS X37 MULTIPLE INTELL S…GEORGE WESTINGHOUSE CARE… |
zipcode | text | Five (5) digit postal code assigned by the United States Postal Service. | 0% | 112011031410312 |
community_board | text | Appointed advisory groups 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% | 501105503 |
council_district | text | Council District is the lawmaking body of the City of New York. There are 51 districts throughout NYC's five boroughs. | 0% | 431 |