How do I get off this email group? I requested to be removed to no avail. .someone out there please take me Off!!! <div>-------- Original message --------</div><div>From: PAUL LICHTERMAN <ltsradio@yahoo.com> </div><div>Date:10/09/2016 5:16 PM (GMT-06:00) </div><div>To: Florida Repeater Council Discussion <frc-info@lists.keekles.org>,mccrpt@tampabay.rr.com,Florida Repeater Council Discussion <frc-info@lists.keekles.org> </div><div>Subject: Re: [FRC] What is this lists' purpose </div><div> </div>Hello everyone, Please keep the name calling to a minimum. Thank you in in advance Gerald P. Lichterman KE4ISY Ltsradio@yahoo.com Sent from Yahoo Mail on Android On Sun, 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