Freelancer Needed to Build Full Cell Tower Database for Brooklyn, NY (Excel + Web Scraping)
Budget: $30 – $250 USD
I need an experienced researcher / data-scraper to create a **complete Excel database of all cell towers and cellular antenna sites in Brooklyn, NY** (all ZIP codes).
You will collect data from ** tower databases, plus tower-map and crowd-sourced sites**,opencellid.org or https://www.cellmapper.net/map and compile it in a clean, well-structured Excel file or google sheet.
**Deliverables (Excel):**
* One master table with, for each site where possible:
* Address and/or coordinates
* Licensee / owner
* Carrier(s) served (Verizon, AT&T, T-Mobile, etc.)
* Technology (LTE, 5G, 4G, small cell, rooftop, macro tower, etc.)
* Structure type (tower, monopole, rooftop, utility pole, DAS, etc.)
* Height (if available)
* Status / notes
* **Source website + URL for each record**
* A short summary tab explaining **methods and data sources used.**
**Data sources (can be used to research/scrape, respecting each site’s terms):**
* **CellTowerMaps** – city/ZIP tower counts and detailed tower lists ([CellTowerMaps][1])
* **AntennaSearch** – tower and antenna locations, ownership, technical details ([AntennaSearch][2])
* **FCC Antenna Structure Registration (ASR) database** & **FCC database search tools** – official registered structures ([FCC Wireless Reports][3])
* **FCCInfo / Tower Finder (recnet TowerFind)** – pulls from FCC ASR and other tower vendors ([FCCinfo][4])
* **OpenCelliD** (API / bulk datasets) – open global cell tower database ([OpenCelliD][5])
* **CellMapper** – crowd-sourced tower and coverage map, per carrier and band ([CellMapper][6])
* **City-Data “FCC Registered Antenna Towers in Brooklyn, NY” page** – additional FCC-based listings ([City-Data][7])
**Requirements:**
* Strong web research + data cleaning skills
* Experience with **web scraping / APIs** (where allowed) and Excel
* Careful with **de-duplication** and **data validation** across multiple sources
* Must deliver a **clean, documented, ready-to-use Excel file**
[1]: https://www.celltowermaps.com/cell-towers/near/city-state/brooklyn/ny?utm_source=chatgpt.com "Cell Towers Near Me in Brooklyn, NY 11226 - 794 Locations"
[2]: https://www.antennasearch.com/?utm_source=chatgpt.com "AntennaSearch - Search for Cell Towers & Antennas"
[3]: https://wireless2.fcc.gov/UlsApp/AsrSearch/asrAdvancedSearch.jsp?utm_source=chatgpt.com "ASR Advanced Registration Search - FCC"
[4]: https://www.fccinfo.com/CMDProASRLookup.php?order=7%7CA%7CN&sKilometers=15&sLatitude=34-13-55.0&sLongitude=118-04-18.0&tabSearchType=ASR+W&utm_source=chatgpt.com "Antenna Structure Registration Search Results"
[5]: https://www.opencellid.org/?utm_source=chatgpt.com "OpenCelliD - Largest Open Database of Cell Towers ..."
[6]: https://www.cellmapper.net/map?utm_source=chatgpt.com "Cellular Tower and Signal Map"
[7]: https://www.city-data.com/towers/cell-Brooklyn-New-York.html?utm_source=chatgpt.com "FCC Registered Cell Phone Towers in Brooklyn, NY"
You will collect data from ** tower databases, plus tower-map and crowd-sourced sites**,opencellid.org or https://www.cellmapper.net/map and compile it in a clean, well-structured Excel file or google sheet.
**Deliverables (Excel):**
* One master table with, for each site where possible:
* Address and/or coordinates
* Licensee / owner
* Carrier(s) served (Verizon, AT&T, T-Mobile, etc.)
* Technology (LTE, 5G, 4G, small cell, rooftop, macro tower, etc.)
* Structure type (tower, monopole, rooftop, utility pole, DAS, etc.)
* Height (if available)
* Status / notes
* **Source website + URL for each record**
* A short summary tab explaining **methods and data sources used.**
**Data sources (can be used to research/scrape, respecting each site’s terms):**
* **CellTowerMaps** – city/ZIP tower counts and detailed tower lists ([CellTowerMaps][1])
* **AntennaSearch** – tower and antenna locations, ownership, technical details ([AntennaSearch][2])
* **FCC Antenna Structure Registration (ASR) database** & **FCC database search tools** – official registered structures ([FCC Wireless Reports][3])
* **FCCInfo / Tower Finder (recnet TowerFind)** – pulls from FCC ASR and other tower vendors ([FCCinfo][4])
* **OpenCelliD** (API / bulk datasets) – open global cell tower database ([OpenCelliD][5])
* **CellMapper** – crowd-sourced tower and coverage map, per carrier and band ([CellMapper][6])
* **City-Data “FCC Registered Antenna Towers in Brooklyn, NY” page** – additional FCC-based listings ([City-Data][7])
**Requirements:**
* Strong web research + data cleaning skills
* Experience with **web scraping / APIs** (where allowed) and Excel
* Careful with **de-duplication** and **data validation** across multiple sources
* Must deliver a **clean, documented, ready-to-use Excel file**
[1]: https://www.celltowermaps.com/cell-towers/near/city-state/brooklyn/ny?utm_source=chatgpt.com "Cell Towers Near Me in Brooklyn, NY 11226 - 794 Locations"
[2]: https://www.antennasearch.com/?utm_source=chatgpt.com "AntennaSearch - Search for Cell Towers & Antennas"
[3]: https://wireless2.fcc.gov/UlsApp/AsrSearch/asrAdvancedSearch.jsp?utm_source=chatgpt.com "ASR Advanced Registration Search - FCC"
[4]: https://www.fccinfo.com/CMDProASRLookup.php?order=7%7CA%7CN&sKilometers=15&sLatitude=34-13-55.0&sLongitude=118-04-18.0&tabSearchType=ASR+W&utm_source=chatgpt.com "Antenna Structure Registration Search Results"
[5]: https://www.opencellid.org/?utm_source=chatgpt.com "OpenCelliD - Largest Open Database of Cell Towers ..."
[6]: https://www.cellmapper.net/map?utm_source=chatgpt.com "Cellular Tower and Signal Map"
[7]: https://www.city-data.com/towers/cell-Brooklyn-New-York.html?utm_source=chatgpt.com "FCC Registered Cell Phone Towers in Brooklyn, NY"