Work with geocoded FCC License Data locally
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
README.md
load.py
sample-fcc.csv

README.md

What is Spectrum Wrangler?

Spectrum Wrangler will download the most recent version of the FCC License View database, parse it into a PostGIS table, clean up the geo columns so they can be used to query on, and produce a spatial index on them.

About the FCC License View database

In the United States the Federal Communication Commission is resposible for regulating the use of the radio waves. The FCC issues licenses for radio transmitters that exceed certain power levels or which operate on certain frequencies. The License View database harmonizes the schema of the various parts of the [Universal Licensing System] (http://wireless.fcc.gov/uls/index.htm?job=transaction&page=weekly) (ULS) but with less detail than the individual ULS databases provide. Approximately 200,000 new licenses are granted each year and the historical sample size of active/inactive licenses is approximately 18M.

How to use

  • Configure the user dbname server & port in the load.py script to work with your PostGIS setup
  • Ensure that you have read/write privlidges to workingdir specified in load.py
  • Run python load.py

Requirements

Examples

Example raw data extract can be found in `sample-fcc.csv'

Query to test whether PostGIS extension successfully configured

SELECT round(dms2dd('43° 0''50.60"S'),9) as latitude, round(dms2dd('147°12''18.20"E'),9) as longitude;

latitude longitude -43.014055556 147.205055556

Ranged queries

Query to search within 1000m of 40.7253319,-74.0076834 and export results

COPY ( SELECT * FROM fcclicenses WHERE ST_DWithin(geom::geography, ST_GeogFromText('POINT(-74.0076834 40.7253319)'), 1000, false) ) To '/tmp/trump-antennas.csv' With CSV HEADER DELIMITER ',';