Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Andreas Wiatowski 
Thanks Eric!

I was actually able to speak directly with an AT today that was provided by 
Industry Canada.  I will keep the information you provided for reference.

They seemed very willing to help solve our issue…especially since they have 
just started deploying.

Cheers,
__
Andreas Wiatowski | CEO
Silo Wireless Inc.
Email  andr...@silowireless.com
19 Sage Court
Brantford, Ontario N3R 7T4 (CANADA)
Tel +1.519.449.5656  Extension-600|Fax +1.519.449.5536 |Toll Free 
+1.866.727.4138

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Eric Kuhnke
Sent: Thursday, August 4, 2016 12:31 PM
To: af@afmug.com
Subject: Re: [AFMUG] Cellular Antenna & Frequency database - FCC

If you really want to do something like this, here's a copy and paste from my 
notes file. Warning that the fcc_all.db is going to be huge so it's strongly 
recommended to only pull out one or two states of sites at a time.

0. data source is http://reboot.fcc.gov/license-view





a. CSV and pipe delimited text files are linked on right side, along with data 
dictionary and data sample





b. the CSV actual comma delimited text file is rather useless, because of the 
number of entity names and description fields that also contain commas. 
therefore we want to use the pipe delimited file.





c. consult the data dictionary DOC file for a detailed description of all 
columns, this is provided on the license-view FCC ULS page. local copy here. 
[[File:Fcc-license-view-data-dictionary.doc|thumbnail]]





1. download fcc-license-view-data-pipe-delimited-format.zip , this file should 
be about 1.1GB zipped





2. unzip fcc-license-view-data-pipe-delimited-format.zip , the unzipped TXT 
file should be about 11GB





3. you should now have the file fcc_lic_vw_pipe.txt which is delimited using 
pipes





3b. use "pragma table_info(table_name); to see contents of table





4. create empty database with table fccinfo by doing the following:



a. sqliteman



b. create new file as fcc_all.db



c. create table fccdata



d. create 84 columns matching columns in header of fcc_lic_vw_pipe.txt file



example of columns to create for FCC ULS:



sqlite> .fullschema

CREATE TABLE fccdata (

"license_id" INTEGER,

"source_system" TEXT,

"callsign" TEXT,

"facility_id" INTEGER,

"frn" INTEGER,

"lic_name" TEXT,

"common_name" TEXT,

"radio_service_code" TEXT,

"radio_service_desc" TEXT,

"rollup_category_code" TEXT,

"rollup_category_desc" TEXT,

"grant_date" TEXT,

"expired_date" TEXT,

"cancellation_date" TEXT,

"last_action_date" TEXT,

"lic_status_code" TEXT,

"lic_status_desc" TEXT,

"rollup_status_code" TEXT,

"rollup_status_desc" TEXT,

"entity_type_code" TEXT,

"entity_type_desc" TEXT,

"rollup_entity_code" TEXT,

"rollup_entity_desc" TEXT,

"lic_address" TEXT,

"lic_city" TEXT,

"lic_state" TEXT,

"lic_zip_code" INTEGER,

"lic_attention_line" TEXT,

"contact_company" TEXT,

"contact_name" TEXT,

"contact_title" TEXT,

"contact_address1" TEXT,

"contact_address2" TEXT,

"contact_city" TEXT,

"contact_state" TEXT,

"contact_zip" INTEGER,

"contact_country" TEXT,

"contact_phone" TEXT,

"contact_fax" TEXT,

"contact_email" TEXT,

"market_code" TEXT,

"market_desc" TEXT,

"channel_block" TEXT,

"loc_type_code" TEXT,

"loc_type_desc" TEXT,

"loc_city" TEXT,

"loc_county_code" TEXT,

"loc_county_name" TEXT,

"loc_state" TEXT,

"loc_radius_op" TEXT,

"loc_seq_id" TEXT,

"loc_lat_deg" INTEGER,

"loc_lat_min" INTEGER,

"loc_lat_sec" INTEGER,

"loc_lat_dir" TEXT,

"loc_long_deg" INTEGER,

"loc_long_min" INTEGER,

"loc_long_sec" INTEGER,

"loc_long_dir" TEXT,

"hgt_structure" INTEGER,

"asr_num" INTEGER,

"antenna_id" TEXT,

"ant_seq_id" TEXT,

"ant_make" TEXT,

"ant_model" TEXT,

"ant_type_code" TEXT,

"ant_type_desc" TEXT,

"azimuth" INTEGER,

"beamwidth" INTEGER,

"polarization_code" TEXT,

"frequency_id" TEXT,

"freq_seq_id" TEXT,

"freq_class_station_code" TEXT,

"freq_class_station_desc" TEXT,

Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Eric Kuhnke 
If you really want to do something like this, here's a copy and paste from
my notes file. Warning that the fcc_all.db is going to be huge so it's
strongly recommended to only pull out one or two states of sites at a time.

0. data source is http://reboot.fcc.gov/license-view


a. CSV and pipe delimited text files are linked on right side, along
with data dictionary and data sample


b. the CSV actual comma delimited text file is rather useless, because
of the number of entity names and description fields that also contain
commas. therefore we want to use the pipe delimited file.


c. consult the data dictionary DOC file for a detailed description of
all columns, this is provided on the license-view FCC ULS page. local
copy here. [[File:Fcc-license-view-data-dictionary.doc|thumbnail]]


1. download fcc-license-view-data-pipe-delimited-format.zip , this
file should be about 1.1GB zipped


2. unzip fcc-license-view-data-pipe-delimited-format.zip , the
unzipped TXT file should be about 11GB


3. you should now have the file fcc_lic_vw_pipe.txt which is delimited
using pipes


3b. use "pragma table_info(table_name); to see contents of table


4. create empty database with table fccinfo by doing the following:

a. sqliteman

b. create new file as fcc_all.db

c. create table fccdata

d. create 84 columns matching columns in header of fcc_lic_vw_pipe.txt file

example of columns to create for FCC ULS:

sqlite> .fullschema
CREATE TABLE fccdata (
"license_id" INTEGER,
"source_system" TEXT,
"callsign" TEXT,
"facility_id" INTEGER,
"frn" INTEGER,
"lic_name" TEXT,
"common_name" TEXT,
"radio_service_code" TEXT,
"radio_service_desc" TEXT,
"rollup_category_code" TEXT,
"rollup_category_desc" TEXT,
"grant_date" TEXT,
"expired_date" TEXT,
"cancellation_date" TEXT,
"last_action_date" TEXT,
"lic_status_code" TEXT,
"lic_status_desc" TEXT,
"rollup_status_code" TEXT,
"rollup_status_desc" TEXT,
"entity_type_code" TEXT,
"entity_type_desc" TEXT,
"rollup_entity_code" TEXT,
"rollup_entity_desc" TEXT,
"lic_address" TEXT,
"lic_city" TEXT,
"lic_state" TEXT,
"lic_zip_code" INTEGER,
"lic_attention_line" TEXT,
"contact_company" TEXT,
"contact_name" TEXT,
"contact_title" TEXT,
"contact_address1" TEXT,
"contact_address2" TEXT,
"contact_city" TEXT,
"contact_state" TEXT,
"contact_zip" INTEGER,
"contact_country" TEXT,
"contact_phone" TEXT,
"contact_fax" TEXT,
"contact_email" TEXT,
"market_code" TEXT,
"market_desc" TEXT,
"channel_block" TEXT,
"loc_type_code" TEXT,
"loc_type_desc" TEXT,
"loc_city" TEXT,
"loc_county_code" TEXT,
"loc_county_name" TEXT,
"loc_state" TEXT,
"loc_radius_op" TEXT,
"loc_seq_id" TEXT,
"loc_lat_deg" INTEGER,
"loc_lat_min" INTEGER,
"loc_lat_sec" INTEGER,
"loc_lat_dir" TEXT,
"loc_long_deg" INTEGER,
"loc_long_min" INTEGER,
"loc_long_sec" INTEGER,
"loc_long_dir" TEXT,
"hgt_structure" INTEGER,
"asr_num" INTEGER,
"antenna_id" TEXT,
"ant_seq_id" TEXT,
"ant_make" TEXT,
"ant_model" TEXT,
"ant_type_code" TEXT,
"ant_type_desc" TEXT,
"azimuth" INTEGER,
"beamwidth" INTEGER,
"polarization_code" TEXT,
"frequency_id" TEXT,
"freq_seq_id" TEXT,
"freq_class_station_code" TEXT,
"freq_class_station_desc" TEXT,
"power_erp" TEXT,
"power_output" TEXT,
"frequency_assigned" INTEGER,
"frequency_upper_band" INTEGER,
"unit_of_measure" TEXT,
"tolerance" INTEGER,
"emission_id" TEXT,
"emission_seq_id" TEXT,
"emission_code" TEXT,
"ground_elevation" INTEGER
);

e. save empty template database as fcc_template.db

f. keep fcc_template.db with all rows empty to use as a template for
future imports, do not modify further



4b. if necessary, use sqliteman to edit the columns for the
fcc_template.db fccdata table, ensuring that numeric-only columns are
described as INTEGER



5a. copy the fcc_template.db file with empty 84 columns to new file fcc_all.db


5b. sqlite3 fcc_all.db

a. .headers on
b. .mode csv
c. .separator |
d. .show
e. .import fcc_lic_vw_pipe.txt fccdata
f. this will take CPU usage to 100% on one core and take a rather long
time! the finished fcc_all.db file will be approximately 15GB in size
or larger.
g. .quit

or you can do the above on one line for non-interactive import:

sqlite3 -header -csv -separator '|' fcc_all.db '.import
fcc_lic_vw_pipe.txt fccdata'



On Thu, Aug 4, 2016 at 4:47 AM, Andreas Wiatowski 
wrote:

> Does anyone know if there is an antenna/frequency database that I can
> search for cellular frequencies and tower locations used…including antenna
> down tilt and azimuth?
>
> I tried looking around the FCC databases but could not find one that gives
> me that kind of information.
>
> Any help is appreciated.
>
> Cheers,
>
> Andreas Wiatowski, CEO
> Silo Wireless Inc.
>

Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Eric Kuhnke 
The entire FCC Part 101 database and the FCC ULS database are available to
the public as pipe delimited CSV files inside a big .zip file. It's close
to 24GB in size.

I have a cron job that retrieves a complete copy of both and parses them
into an SQL database for local use with a client's internal systems.

There is no column in the ULS database for antenna downtilt. That would be
in the cellular companies' internal documentation. You can certainly
discover locations and tower sites, though of course everything that is too
short to require FAA clearance and an ASR registration won't be in the
database.




On Thu, Aug 4, 2016 at 4:47 AM, Andreas Wiatowski 
wrote:

> Does anyone know if there is an antenna/frequency database that I can
> search for cellular frequencies and tower locations used…including antenna
> down tilt and azimuth?
>
> I tried looking around the FCC databases but could not find one that gives
> me that kind of information.
>
> Any help is appreciated.
>
> Cheers,
>
> Andreas Wiatowski, CEO
> Silo Wireless Inc.
> 519-449-5656 x-600
>
>

Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Cameron Crum 
Not to that detail. Towers would be registered if they have a carrier on
them, but if they don't own the tower, it would be hit and miss and the FCC
does not require RF info to be submitted other than proof of coverage to
get/keep you license. They (used to) accept Carey curves for such proof. So
I wouldn't count on anything you find on that front to be very accurate.

On Thu, Aug 4, 2016 at 8:23 AM, Jaime Solorza 
wrote:

> There are some websites that tell you by zip code where towers are and
> carriers.   They even show FCC filings... I think it is called
> cellfinder.   Been a while since I used it.   Wilson and other booster
> folks have links to helpful sites.   I have two apps on phone that help me
> with some searches..  Signal Finder and LTE Discovery... First one finds
> towers on map and second gives me strength with frequencies used.   I just
> installed Mobile Signal and it is signal strength meter.   Lastly.. There
> is an add on to Google Earth that shows rural tower sites.   Good luck
>
> On Aug 4, 2016 5:47 AM, "Andreas Wiatowski" 
> wrote:
>
> Does anyone know if there is an antenna/frequency database that I can
> search for cellular frequencies and tower locations used…including antenna
> down tilt and azimuth?
>
> I tried looking around the FCC databases but could not find one that gives
> me that kind of information.
>
> Any help is appreciated.
>
> Cheers,
>
> Andreas Wiatowski, CEO
> Silo Wireless Inc.
> 519-449-5656 x-600
>
>
>

Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Adam Moffett 
Right, they'll have a license to use a channel in a geographic area.  
Exactly where the antenna is and where it's pointed is up to them as 
long as the signal stays within their contour.


or that's my understanding as I sit here in my cellular armchair.


There isn't going to be that in FCC land.



-
Mike Hammett
Intelligent Computing Solutions <http://www.ics-il.com/>
<https://www.facebook.com/ICSIL><https://plus.google.com/+IntelligentComputingSolutionsDeKalb><https://www.linkedin.com/company/intelligent-computing-solutions><https://twitter.com/ICSIL>
Midwest Internet Exchange <http://www.midwest-ix.com/>
<https://www.facebook.com/mdwestix><https://www.linkedin.com/company/midwest-internet-exchange><https://twitter.com/mdwestix>
The Brothers WISP <http://www.thebrotherswisp.com/>
<https://www.facebook.com/thebrotherswisp>


<https://www.youtube.com/channel/UCXSdfxQv7SpoRQYNyLwntZg>

*From: *"Andreas Wiatowski" <andr...@silowireless.com>
*To: *af@afmug.com
*Sent: *Thursday, August 4, 2016 6:47:36 AM
*Subject: *[AFMUG] Cellular Antenna & Frequency database - FCC

Does anyone know if there is an antenna/frequency database that I can 
search for cellular frequencies and tower locations used…including 
antenna down tilt and azimuth?


I tried looking around the FCC databases but could not find one that 
gives me that kind of information.


Any help is appreciated.

Cheers,

Andreas Wiatowski, CEO
Silo Wireless Inc.
519-449-5656 x-600

Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Jaime Solorza 
There are some websites that tell you by zip code where towers are and
carriers.   They even show FCC filings... I think it is called
cellfinder.   Been a while since I used it.   Wilson and other booster
folks have links to helpful sites.   I have two apps on phone that help me
with some searches..  Signal Finder and LTE Discovery... First one finds
towers on map and second gives me strength with frequencies used.   I just
installed Mobile Signal and it is signal strength meter.   Lastly.. There
is an add on to Google Earth that shows rural tower sites.   Good luck

On Aug 4, 2016 5:47 AM, "Andreas Wiatowski" 
wrote:

Does anyone know if there is an antenna/frequency database that I can
search for cellular frequencies and tower locations used…including antenna
down tilt and azimuth?

I tried looking around the FCC databases but could not find one that gives
me that kind of information.

Any help is appreciated.

Cheers,

Andreas Wiatowski, CEO
Silo Wireless Inc.
519-449-5656 x-600

Re: [AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Mike Hammett 
There isn't going to be that in FCC land. 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -

From: "Andreas Wiatowski" <andr...@silowireless.com> 
To: af@afmug.com 
Sent: Thursday, August 4, 2016 6:47:36 AM 
Subject: [AFMUG] Cellular Antenna & Frequency database - FCC 




Does anyone know if there is an antenna/frequency database that I can search 
for cellular frequencies and tower locations used…including antenna down tilt 
and azimuth? 


I tried looking around the FCC databases but could not find one that gives me 
that kind of information. 


Any help is appreciated. 




Cheers, 


Andreas Wiatowski, CEO 
Silo Wireless Inc. 
519-449-5656 x-600

[AFMUG] Cellular Antenna & Frequency database - FCC

2016-08-04 Thread Andreas Wiatowski 
Does anyone know if there is an antenna/frequency database that I can search 
for cellular frequencies and tower locations used…including antenna down tilt 
and azimuth?

I tried looking around the FCC databases but could not find one that gives me 
that kind of information.

Any help is appreciated.

Cheers,

Andreas Wiatowski, CEO
Silo Wireless Inc.
519-449-5656 x-600