Proximity Search Sorted by Distance doesn't work.

  • KE4IAJ
  • KE4IAJ's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
15 Jun 2016 15:13 #51 by KE4IAJ
When I do a proximity search sorted by "Location, Sort by distance when results appear.", it doesn't sort by distance.

If I click on "Mi" it sorts by distance but export to CHIRP is not sorted by distance.

Please advise.
The following user(s) said Thank You: AD0JA

Please Log in or Create an account to join the conversation.

  • AD0JA
  • AD0JA's Avatar
  • Offline
  • Moderator
  • Moderator
  • MO and IL Admin
More
25 Jul 2016 03:36 #90 by AD0JA
I am having the EXACT same issue. Not sure if it's something we're not doing right or the site.

Garrett, could you provide some insight on this?

73 de AD0JA
the voice of Wright City, MO
Kenwood, Motorola, M/ACOM - Harris commercial radio enthusiast

Please Log in or Create an account to join the conversation.

  • K0LDB
  • K0LDB's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Caught the Fusion Bug
More
05 Aug 2016 04:17 #106 by K0LDB
Gentlemen, I have tested the proximity search several times and have had no issues with it, I believe if you click on the top on "Miles" it will sort miles , near to far and the opposite if you click it again. the same with frequency sort just click up top on the frequency word itself

I hope this helps
Dave

Please Log in or Create an account to join the conversation.

  • AD0JA
  • AD0JA's Avatar
  • Offline
  • Moderator
  • Moderator
  • MO and IL Admin
More
08 Aug 2016 02:23 #121 by AD0JA
N8DJR,
It will sort the displayed list by miles,
HOWEVER,
It will not export them to CHIRP in that order. Not matter what I do, it displays them in a mixed up order in CHIRP.

73 de AD0JA
the voice of Wright City, MO
Kenwood, Motorola, M/ACOM - Harris commercial radio enthusiast

Please Log in or Create an account to join the conversation.

  • KE4IAJ
  • KE4IAJ's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
08 Aug 2016 02:54 #123 by KE4IAJ
AD0JA is correct. It's also what I stated in the OP. We can't export sorted by distance.
The following user(s) said Thank You: AD0JA

Please Log in or Create an account to join the conversation.

More
31 Aug 2016 21:36 #149 by KD6KPC
Sorry for the delay on responding.

You can sort by distance by clicking on the header, but you cannot export it directly from the database that way. That's because the query searches for repeaters within an area, but the query cannot do the math. The math is done after the query spits out the result (JavaScript).

This is also why it does not export to CHIRP already sorted by distance. When you click the export button, is re-running the query and spitting out the CHIRP results. Again, the database query is unable to calculate the distance.

I've bene looking for a server side solution and it looks like what I would have to do is query the database, spit the results into a temporary table, including the distance math, and then displaying the results out of the temporary table in the order requested.

This would also have to occur with the export function.

One of our admins has suggested this before. It's a lot of coding, but I think the simmer of requests is coming closer to a boil and it may be time to get on this. This would be classified as a convenience function, so it's not the highest priority. Maybe something I can get done by the end of the year.

Repeaterbook.com
Site Owner

Please Log in or Create an account to join the conversation.

More
16 Feb 2019 21:20 #474 by W8GMF
Well it isn't really a convenience issue. It makes the data base practically useless for the current crop of transceivers with dozens of memories.

Garry W8GMF

Please Log in or Create an account to join the conversation.

More
16 Feb 2019 22:09 #475 by KD6KPC
I've tried to make this work, I will try again.

The database itself is not capable of sorting the repeaters from the location specified. The distance from the location is calculated as the data is extracted from the database. Javascript, which is client-side (running on your computer, not the server) does the sorting when you click the headers. When you transfer the data to the export, the database is re-queried. Again, because the database has no ability to conduct sorting based on distance, the distance cannot be calculated and then sorted for CHIRP.

The only solution I have seen for this is taking the results, Re-uploading them to a temporary table in the order you desire, and then spitting them back out into the CHIRP export. I have not yet been able to figure out how to do that, but am working on it. It's a big job with a lot of overhead for the web site. I completely understand the need, though.

Garrett

Repeaterbook.com
Site Owner

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum