Sorting tables

Hello,

I mentioned this in the database discussion thread. I’d like to be able to sort some of the tables shown on the SOTA website by clicking on the column headings.

In particular, for the summits list table (http://www.sotawatch.org/summits.php) I’d like to click on number of points, so I can see which are the closest peaks with the highest points.

This website (sorttable: Make all your tables sortable) talks about how to do this in javascript, which would require someone who is probably quite busy to do even more work…

…but in the meantime, near the bottom of that page you will see the heading “Can I sort tables on a page I didn’t write?”. Below there is a javascript link you can add to your bookmark toolbar, which makes any table on a webpage sortable.

So, I can go the summit list, then click on the javascript link on my bookmark toolbar, and suddenly the table is sortable. I can then click on the column headings and sort on anything. Nice.

73,

Andrew

In reply to HL5ZBA:

I’ve read up how to embedded sorting into ASP.NET views and will be trialing a few ideas along with implementing the SWL logging/displays for the database. SWL logging will be the next major feature to get support and with a following wind, I’d like to see that done for the end of November.

I’ve always look on Javascript as the work of Sauron and tend to avoid it whenever I can!

Andy

In reply to HL5ZBA:

This would be very useful. It would also be useful to be able to identify all the summits within, say, 25 km or 50 km of a particular geographical location. I often travel to a distant part of the UK and am left wondering which are the nearest SOTA summits to that location, with a view to doing a quick activation. At present, I have not found any way to do this.

73,
Walt (G3NYY)

In reply to G3NYY:

Go to the SOTA mapping site, select the range option from the top, enter the location and distance, see the summits within range drawn on the map.

Andy
MM0FMF

In reply to G3NYY:

I’m sure this is already known, but for what it’s worth: if you can find out the approximate latitude and longitude of the place you are going to visit from a map, an encyclopedia or another source, you can use these data as input in the “Summit Search” and obtain a list of the nearby summits in order of distance. I’ve done this when I moved to Hannover. Print the list, carry it together with your map, and you are (almost) set. Just don’t forget the radio and the aerial! I left the aerial at home once, and all I could do from the hill I was visiting was having lunch and watching the animals in the forest …

Of course it would be nice if this list could be sorted by other criteria, but if your computer can deal with spreadsheets, you could copy the output into one of these and use the sort function …

73, Jan-Martin

In reply to G3NYY:

" I often travel to a distant part of the UK and am left wondering which are the nearest SOTA summits to that location"

I use google earth with Martyn M1MAJ`s kmz file overlay for exactly that same reason Walt.

If you use street view, you can also research potential parking spots.

In reply to G3NYY:

Walt,

I use adventure radio map (www.qwj.de) which shows all the UK summits when you click on G. Also will show Humps (separate button). Then you can just scroll around and see what you might visit by adjusting your journey as well as the ones in your destination area.

73,
Rod

In reply to G1INK:

The ‘most excellent’ Rucksack Radio Tool app does this job for me, and I don’t need to prepare anything in advance…which is nice.

In reply to MM0FMF:

Go to the SOTA mapping site,

What is the SOTA mapping site?

73,
Walt (G3NYY)

In reply to G3NYY:

There’s a link on just about every page on this web site.

Home | Spots | Alerts | Summits | Reflector | Website | Database | Video | Photos | Recent Info | Shop | Mapping

^^^^^^^^
This one!

Andy
MM0FMF

In reply to G1INK and others:

Thanks to all for the very useful suggestions. I had not heard of any of these solutions before, so I’ll check them out.

73,
Walt (G3NYY)

In reply to MM0FMF:

There’s a link on just about every page on this web site.

Home | Spots | Alerts | Summits | Reflector | Website | Database |
Video | Photos | Recent Info | Shop | Mapping

^^^^^^^^
This one!

Thanks! For some reason, I never knew it existed!! On my display, the word “Mapping” appears on a line by itself.
:slight_smile:

That does exactly what I wanted.

73,
Walt (G3NYY)

In reply to HL5ZBA:

I’d like to be able to sort some of the tables shown on the SOTA website
by clicking on the column headings.

In addition to http://sotamaps.wsstvc.org/ , you might be interested in looking at the sortable lists on http://www.on6zq.be/w/index.php/SOTA/SOTA too.

73 de ON6ZQ
Christophe