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 _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
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<http://bryanfields.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
Hello everyone, Please keep the name calling to a minimum.Thank you in in advance Gerald P. LichtermanKE4ISY 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/RBSEEMicro Computer Concepts352-683-4476mccrpt@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.netbryanfields.netWelcome 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
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
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in. My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand. With very little respect Steve N4IRS On 10/09/2016 04:59 PM, 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 <http://bryanfields.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
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
lol ! You need an IT type if you've progressed past Mastr II conversions ! Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, 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
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
Prefer Master III personally :) On Oct 9, 2016 7:41 PM, "David Krauss" <nx4y@verizon.net> wrote:
lol ! You need an IT type if you've progressed past Mastr II conversions !
Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, 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> <frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com> <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> <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 <http://bryanfields.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 listFRC-Info@lists.keekles.orghttp://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
_______________________________________________ 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
I like Tait. ;) On 10/09/2016 07:46 PM, Frank Echanique wrote:
Prefer Master III personally :)
On Oct 9, 2016 7:41 PM, "David Krauss" <nx4y@verizon.net <mailto:nx4y@verizon.net>> wrote:
lol ! You need an IT type if you've progressed past Mastr II conversions !
Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com <mailto:szingman@msgstor.com>> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, mccrpt@tampabay.rr.com <mailto: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 <tel:352-683-4476> mccrpt@tampabay.rr.com <mailto:mccrpt@tampabay.rr.com>
------------------------------------------------------------------------ *From:* FRC-Info <frc-info-bounces@lists.keekles.org> <mailto:frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com> <mailto: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> <mailto: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 <tel:727-409-1194> - Voice > http://bryanfields.net Bryan Fields.net <http://bryanfields.net/> bryanfields.net <http://bryanfields.net> Welcome to Bryan Fields.net <http://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 <mailto:FRC-Info@lists.keekles.org> > http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info <http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info> _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org <mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info <http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info>
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org <mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info <http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info>
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org <mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info <http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info>
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org <mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info <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
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
I had a bunch of 900MHz Tait stuff, gotta look for it again, got a EPROM burner to write the ham Roms but never got around to it, my main site said no to 900MHz on their roof :( On Oct 9, 2016 7:47 PM, "Steve Zingman" <szingman@msgstor.com> wrote:
I like Tait. ;)
On 10/09/2016 07:46 PM, Frank Echanique wrote:
Prefer Master III personally :) On Oct 9, 2016 7:41 PM, "David Krauss" <nx4y@verizon.net> wrote:
lol ! You need an IT type if you've progressed past Mastr II conversions !
Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, 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> <frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com> <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> <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 <http://bryanfields.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 listFRC-Info@lists.keekles.orghttp://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-b in/mailman/listinfo/frc-info
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-b in/mailman/listinfo/frc-info
_______________________________________________ FRC-Info mailing listFRC-Info@lists.keekles.orghttp://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
Quantar. there is no substitute. Sent from an iPhone 6
On Oct 9, 2016, at 7:47 PM, Steve Zingman <szingman@msgstor.com> wrote:
I like Tait. ;)
On 10/09/2016 07:46 PM, Frank Echanique wrote: Prefer Master III personally :)
On Oct 9, 2016 7:41 PM, "David Krauss" <nx4y@verizon.net> wrote: lol ! You need an IT type if you've progressed past Mastr II conversions !
Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, 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
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ 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 -- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
I'm not a big moto guy but I'll admit Quantars are sexy... I wish P25 had taken off more in ham On Oct 9, 2016 10:11 PM, "David Krauss" <nx4y@verizon.net> wrote:
Quantar. there is no substitute.
Sent from an iPhone 6
On Oct 9, 2016, at 7:47 PM, Steve Zingman <szingman@msgstor.com> wrote:
I like Tait. ;)
On 10/09/2016 07:46 PM, Frank Echanique wrote:
Prefer Master III personally :) On Oct 9, 2016 7:41 PM, "David Krauss" <nx4y@verizon.net> wrote:
lol ! You need an IT type if you've progressed past Mastr II conversions !
Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, 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> <frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com> <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> <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 <http://bryanfields.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 listFRC-Info@lists.keekles.orghttp://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-b in/mailman/listinfo/frc-info
_______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org http://lists.keekles.org/cgi-b in/mailman/listinfo/frc-info
_______________________________________________ FRC-Info mailing listFRC-Info@lists.keekles.orghttp://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic
_______________________________________________ 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
Quantras are no more than a Micor with a synthizer. Look at the MSF5000 spurious emission spec...walks all over a Qutantra. 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 David Krauss <nx4y@verizon.net> Sent: Sunday, October 9, 2016 3:11 PM To: Florida Repeater Council Discussion Subject: Re: [FRC] What is this lists' purpose Quantar. there is no substitute. Sent from an iPhone 6 On Oct 9, 2016, at 7:47 PM, Steve Zingman <szingman@msgstor.com<mailto:szingman@msgstor.com>> wrote: I like Tait. ;) On 10/09/2016 07:46 PM, Frank Echanique wrote: Prefer Master III personally :) On Oct 9, 2016 7:41 PM, "David Krauss" <nx4y@verizon.net<mailto:nx4y@verizon.net>> wrote: lol ! You need an IT type if you've progressed past Mastr II conversions ! Sent from an iPhone 6 On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com<mailto:szingman@msgstor.com>> wrote: Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in. My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand. With very little respect Steve N4IRS On 10/09/2016 04:59 PM, mccrpt@tampabay.rr.com<mailto: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<tel:352-683-4476> mccrpt@tampabay.rr.com<mailto:mccrpt@tampabay.rr.com> ________________________________ From: FRC-Info <frc-info-bounces@lists.keekles.org><mailto:frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com><mailto: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><mailto: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<tel:727-409-1194> - Voice http://bryanfields.net Bryan Fields.net<http://bryanfields.net/> bryanfields.net<http://bryanfields.net> Welcome to Bryan Fields.net<http://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<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info -- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info -- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
You got to be kidding me..ITs are check this box and solve little...they are not even considered computer programmers. Repeaters are about hardware. 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 David Krauss <nx4y@verizon.net> Sent: Sunday, October 9, 2016 12:41 PM To: Florida Repeater Council Discussion Subject: Re: [FRC] What is this lists' purpose lol ! You need an IT type if you've progressed past Mastr II conversions ! Sent from an iPhone 6 On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com<mailto:szingman@msgstor.com>> wrote: Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in. My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand. With very little respect Steve N4IRS On 10/09/2016 04:59 PM, mccrpt@tampabay.rr.com<mailto: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<mailto:mccrpt@tampabay.rr.com> ________________________________ From: FRC-Info <frc-info-bounces@lists.keekles.org><mailto:frc-info-bounces@lists.keekles.org> on behalf of Kevin Zari <kk4yel@gmail.com><mailto: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><mailto: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<http://bryanfields.net/> bryanfields.net<http://bryanfields.net> Welcome to Bryan Fields.net<http://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<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info -- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ FRC-Info mailing list FRC-Info@lists.keekles.org<mailto:FRC-Info@lists.keekles.org> http://lists.keekles.org/cgi-bin/mailman/listinfo/frc-info
plenty of p25 around florida now. at least parts. linked too. I'm just gonna say , Ron, you have issues. and no idea what you're talking about. and somehow feel the need to put BSEE on every signature. and while i admit guilt in this tangent, it's time to revert this list to discussing how to reform the frc. Sent from an iPhone 6
On Oct 9, 2016, at 11:27 PM, "mccrpt@tampabay.rr.com" <mccrpt@tampabay.rr.com> wrote:
You got to be kidding me..ITs are check this box and solve little...they are not even considered computer programmers.
Repeaters are about hardware.
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 David Krauss <nx4y@verizon.net> Sent: Sunday, October 9, 2016 12:41 PM To: Florida Repeater Council Discussion Subject: Re: [FRC] What is this lists' purpose
lol ! You need an IT type if you've progressed past Mastr II conversions !
Sent from an iPhone 6
On Oct 9, 2016, at 6:42 PM, Steve Zingman <szingman@msgstor.com> wrote:
Wow, I would expect no less from a No class "Extra", all bluster no substance. Sounds like jealousy of the "IT pukes" who get things done done. I guess that's where the BS comes in.
My offer to help you understand how to unsubscribe. I know it's hard for a engineer to understand.
With very little respect Steve N4IRS
On 10/09/2016 04:59 PM, 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
-- "Anything is possible if you don't know what you are talking about." 1st Law of Logic _______________________________________________ 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
participants (6)
-
David Krauss -
Frank Echanique -
Kevin Zari -
mccrpt＠tampabay.rr.com -
PAUL LICHTERMAN -
Steve Zingman