My Finds GPX - Any chance I can get county/elevation/number of Favourite points?

[+InQbuS]

Hi there,

I've never been Project GC premium member but used the freebies every now and then, especially the 81 grids per cache type. Since they have recently restricted that function to premium members only, I started looking at building my own solutions, mainly with Excel and VBA.

 

My basis for the excel solution is the 'My Finds' GPX file. Now I know that there's some info missing, such as County, Elevation or number of Favourite Points for the cache.

 

For County and Elevation of a single cache for example I know I can use data like what I get from https://nominatim.openstreetmap.org/reverse?lat=51&lon=7&format=json but what I'm more after is something where I can process a bulk request to receive more than one record at a time.

 

Is there something like that available somewhere?

 

Also, would I be able to get something similar to the 'My Finds' GPX data for my earned Souvenirs or my Trackable Logs?

 

Many thanks in advance

Daniel aka InQbuS

 

[+arisoft]

I guess that there are challenge caches that already have checkers for 81 grids per cache type.

[+HHL]

3 hours ago, InQbuS said:

Is there something like that available somewhere?

Use GSAK instead of Project-GC.

[+InQbuS]

15 hours ago, arisoft said:

I guess that there are challenge caches that already have checkers for 81 grids per cache type.

 

Thanks, but my Excel/VBA solution does cater for this already. What I'm after is the following:

• Is there a way to bulk request data like county or elevation for given coordinates? I.e. not just for a single cache but for many at the same time?
• Similarly, is it possible to somehow include the current favourite points for a cache in the GPX data?
• Is there any kind of raw data that I could download for my souvenirs/trackables, similar to the "My Finds" GPX file?

 

14 hours ago, HHL said:

Use GSAK instead of Project-GC.

 

Thanks for your response, but I don't really understand in how far GSAK would help me get the required data. Isn't it based on the same GPX data that it also just gets from geocaching.com?

 

Thanks

Daniel

[+Mausebiber]

In GSAK you have all the date fields you need.  If you "refresh" standard .gpx, GSAK will get all required information.

 

Here are the standard data fields in GSAK:

 

 

 

 

No additional work required.  Just import your "all found" .gpx and select the data fields you want to be displayed.

 

 

 

Edited July 5, 2024 by Mausebiber

[+Mausebiber]

Sample:

 

 

[+InQbuS]

21 minutes ago, Mausebiber said:

No additional work required.  Just import your "all found" .gpx and select the data fields you want to be displayed.

 

Many thanks, I wasn't aware of this.

However, I imported my finds in GSAK now, added the elevation and county columns, refreshed the cache data (full, not light) via the geocaching.com access menu but it still doesn't show. For elevation I reckon I need to use the Elevation update (it's processing currently), but not sure how I get updates for the county (not country) column?!

 

Thanks

Daniel

[+InQbuS]

Quick Update to the elevation bit:

I have developed a routine now to bulk request elevation for coordinates from api.open-elevation.com, which works fine so that is one of the items ticked off  .. the elevation seems to be a little different from what Project-GC or Geonames calculate for most of the caches but as long as it's not too far off that's fine.

 

Getting county/favourite points and having raw data for my souvenirs or trackable logs that I could upload into my tool are still open though.

[+HHL]

11 minutes ago, InQbuS said:

I have developed a routine now to bulk request elevation for coordinates from api.open-elevation.com,

No need to do so. GSAK updates Country, State, County and Elevation by itself. Just use the "right" load settings.

 

Read the help file (the bottom down button in the load window) before using. ;-)

In the help window ⇒ hover the box "Elevation" and it will bring you to more help on this issue.

https://gsak.net/help/hs5255.htm

 

Hans

 

Edited July 5, 2024 by HHL

[+Hügh]

5 hours ago, InQbuS said:

Excel/VBA solution

...

the elevation seems to be a little different from what Project-GC

 

If you don't mind some manual copy-pasting and =VLOOKUP, you can get Project-GC's elevations with https://project-gc.com/Challenges/89905. 89906 will list FPs and 89907 will list counties.

 

5 hours ago, InQbuS said:

api.open-elevation.com

 

Irrelevant, but Project-GC uses www.gpxz.io for its data.

 

5 hours ago, InQbuS said:

raw data for my souvenirs or trackable logs

 

A Project-GC challenge checker can't give trackable logs, but I could set one up to dump souvenir data if you wish.

[+InQbuS]

On 7/5/2024 at 9:27 PM, Hügh said:

If you don't mind some manual copy-pasting and =VLOOKUP, you can get Project-GC's elevations with https://project-gc.com/Challenges/89905. 89906 will list FPs and 89907 will list counties.

 

Brilliant, thanks a lot, this is VERY helpful  - I added this as input to my solution now and it works perfectly fine. Any idea if there's also a checker for Region? I know it's available on the GPX but for some countries it doesn't even give me a region (it's "none"), even though Project GC gives me one.

 

On 7/5/2024 at 9:27 PM, Hügh said:

A Project-GC challenge checker can't give trackable logs, but I could set one up to dump souvenir data if you wish.

 

If it's not too much effort that would be ace. What data would it give me? Could it also give type of souvenir (e.g. region, country, event etc.?)

Just wondering, is there any other infor on trackable basis that could be made available through Project GC?

 

Again - thanks a lot, your input helped me really, really much, and with the information from those checkers I could basically create an automated process to check for most of the challenges where I intend to qualify at some point!

Edited July 7, 2024 by InQbuS

[+Hügh]

8 hours ago, InQbuS said:

Brilliant, thanks a lot, this is VERY helpful  - I added this as input to my solution now and it works perfectly fine. Any idea if there's also a checker for Region? I know it's available on the GPX but for some countries it doesn't even give me a region (it's "none"), even though Project GC gives me one.

 

Sure, 89974 will list regions.

 

8 hours ago, InQbuS said:

If it's not too much effort that would be ace. What data would it give me? Could it also give type of souvenir (e.g. region, country, event etc.?)

 

Try 89975.

 

Columns are: souvenir_id (PGC's internal ID), title, image_path, thumbnail_path, date_discovered, pgc_assigned_group (region, specific-day, etc...) I can change the output sorting if you wish, let me know which column to do that on.

 

8 hours ago, InQbuS said:

Just wondering, is there any other infor on trackable basis that could be made available through Project GC?

 

The only TB-related info available via PGC is the total number of TBs a user has moved/discovered. To my knowledge they are not currently storing anything else.

[+InQbuS]

4 hours ago, Hügh said:

Sure, 89974 will list regions.

Great, thanks. That will help close a couple more gaps!

 

4 hours ago, Hügh said:

Try 89975. Columns are: souvenir_id (PGC's internal ID), title, image_path, thumbnail_path, date_discovered, pgc_assigned_group (region, specific-day, etc...) I can change the output sorting if you wish, let me know which column to do that on.

Brilliant, this works perfectly fine for me, maybe if you could do the sorting by date then that would be even better. But don't worry if not, I can easily work with what you have provided.

 

4 hours ago, Hügh said:

The only TB-related info available via PGC is the total number of TBs a user has moved/discovered. To my knowledge they are not currently storing anything else.

No need for that, thanks. I think if I need any of the TB data in my doc then I'll just copy paste from what GC Little Helper summarises in the GC.com statistics page.

 

A BIG upvote for your help with this, that is really appreciated