Nobody stole anything. And this list isn't a place for personal attacks, as has already been made clear. If you don't want to constructively help, it would probably be best for you to unsubscribe so you're not bothered. Sent from an iPhone 6
On Oct 9, 2016, at 4:59 PM, "mccrpt@tampabay.rr.com" <mccrpt@tampabay.rr.com> wrote:
You got this for a clown stole the FRC's email list. And now this same clown wants to control repeater coordination in Florida. But he is a IT clown and we in real engineering know IT pukes are not very well educated.
73, ron, n9ee/r a know code Extra
Ron Wright, N9EE/R BSEE Micro Computer Concepts 352-683-4476 mccrpt@tampabay.rr.com
From: FRC-Info <frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com> Sent: Saturday, October 8, 2016 5:35 AM To: Florida Repeater Council Discussion Subject: [FRC] What is this lists' purpose
Maybe I missed it because I was concentrating on saving my family from Matthew, but how did I get on this list again, and what is it's purpose?
I've got one repeater that I am the trustee and coordinator for. The FRC has always been respectful and helpful, and while maybe not always the quickest, I found that they would follow through with what the said they would do. Besides that, a few of their board members have had some major health issues, so I treated them with the respect and patience we as amateur radio operators are known for. 73 de KK4YEL
-----
The problem with the world is that the intelligent people are full of doubts, while the stupid ones are full of confidence.
On Oct 8, 2016, at 11:08, Bryan Fields <Bryan@bryanfields.net> wrote:
On 10/7/16 11:30 PM, Jon Pearl - W4ABC wrote: I've got Mysql loaded in my shack computer to manage my logbook and you're right... a relational database beats the heck out of hunting and picking through a static .pdf file, any day. There are a lot of old entries in this file that could be culled but as you say, if this database was the product of real-time information, it would speed up the search process for amateurs hunting pairs.
I did just this with FCC data looking for commercial pairs. This selects frequencies at base stations between 464 and 465 from a central point, and orders them by furthest to nearest.
A query such as this could be run via a web interface after clicking "here" on a map and ranking all frequencies in use in furthest to near from that point. ie, you click on a point and it tells you the frequencies in use there sorted by distance.
SELECT f.frequency_assigned,f.call_sign, f.location_number,f.unique_system_identifier, l.dec_lat, l.dec_long, (ROUND( 3956 * acos( cos( radians(lat) ) * cos( radians(l.dec_lat) ) * cos( radians(l.dec_long) - radians(lon)) + sin(radians(lon)) * sin( radians(l.dec_lat))) )) AS distance FROM `FREQUENCY` f right join LOCATION l on l.location_number = f.location_number and l.unique_system_identifier = f.`unique_system_identifier` WHERE f.frequency_assigned >=464 and f.frequency_assigned <=465 and l.dec_lat is not null AND f.frequency_assigned NOT in (SELECT distinct f.frequency_assigned FROM `FREQUENCY` f right join LOCATION l on l.location_number = f.location_number and l.unique_system_identifier = f.`unique_system_identifier` WHERE f.frequency_assigned >=464 and f.frequency_assigned <=465 and l.dec_lat is not null AND ROUND( 3956 * acos( cos( radians(lat) ) * cos( radians(l.dec_lat) ) * cos( radians(l.dec_long) - radians(lon)) + sin(radians(lat)) * sin( radians(l.dec_lat))) ) < 15 ORDER BY `f`.`frequency_assigned` ASC) ORDER BY `f`.`frequency_assigned`, `distance` DESC
-- Bryan Fields
727-409-1194 - Voice http://bryanfields.net Bryan Fields.net bryanfields.net Welcome to Bryan Fields.net. Are you looking for Microwave Path engineering? - Allow me to assist your company with your RF design needs. Having trouble with Alcatel ...
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info