MnGCA

Bus&Betty · Posted: Wed Nov 14, 2007 9:52 am Post subject: GSAK and DeLorme

We are using the User Data 2 field in GSAK for our counties. It's working great.

Does anyone know if we can:
1. Create another User Data x field.
2. Use [?] to automatically correlate the cache location to the number from the DeLorme Atlas.
3. Populate the User Data x field with the DeLorme Atlas number.

So, in other words, for a cache in Blaine, I'd like a User Data x field that reads 41, along with my User Data 2 field that reads Anoka.

Thanks,
Patty

merkman · Past MnGCA Board Joined: 03 Jun 2006 Posts: 2032

I am not sure.
I can check on that.

If you don't get two fields it may be possible to append the data to one field like this.

Anoka - 41
or
41 - Anoka

That is just a thought

I would require GSAK macro programming though.

merkman · Past MnGCA Board Joined: 03 Jun 2006 Posts: 2032

The first thing you would need are the shape files for the Delorme pages.
I don't know much about shape files but I don't see them at http://www.gpsbabel.org/download.html

One way that I can think of doing it (it is pretty ugly) is

1) Run the county macro as it is.
2) Make a copy of xcsv.dir in the shape files directory
3) Change the shape files from counties to Delorme files (if you can find them)
4) Run the county macro (it should populate User2 with Delorme page#)
5) Make a copy of xcsv.dir in the shape files directory
6) Open the 2 xcsv.dir and update the data in the User2 field on one of the files so it is in the Anoka - 41 or 41 - Anoka format. (This can be done in excel with a vlookup and a concatination)
7) Modify the macro to pause just before GoSub Name=ProcessSingleXCSVFile
8) Replace the xcsv.dir in the shape files directory with the one you modified.
9) Resume the macro.
10) That should fill in User2 with what you modified it with.

This is total untested but you could test it out by pausing the macro to just before GoSub Name=ProcessSingleXCSVFile then modify the xcsv.dir file in excel. Overwrite the existing xcsv.dir file and resume the macro and see what User2 gets filled in with.

Of course there is probably some one here who knows a better way.

Bus&Betty · Posted: Wed Nov 14, 2007 2:14 pm Post subject:

Bob's got an idea brewing Idea

If anything comes of it, we'll post it here.

RubberToes · Posted: Wed Nov 14, 2007 4:45 pm Post subject:

A little more than a year ago, I made this post in which I made available text files that describe each of Minnesota's counties for GSAK's polygon filter.

I also have text files for the DeLorme pages. I'd be happy to post them if you're interested.

merkman · Past MnGCA Board Joined: 03 Jun 2006 Posts: 2032

I have been waiting for your post Laughing

I am interested in the delorme pages text file

RubberToes · Posted: Wed Nov 14, 2007 8:14 pm Post subject:

Sorry for the delay. I got involved with cooking dinner and lost track of the important stuff.

A link to the file is on the bottom of my Minnesota Counties page.

Let me know how this works for you.

Pear Head · Posted: Wed Nov 14, 2007 8:23 pm Post subject:

I have access to the GSAK macro that Oklahoma uses for their Delorme Challenge. If someone wants it to look at let me know via PM or email and I'll email it to you.
_________________
Hmm...

Bus&Betty

Thank you RubberToes for the DeLorme shape files! They saved Betty and I many hours of data translation and entry. I had to modify a few of the shape files, but they seem to be working fine.

I used County.gsk as a starting point for the new DeLorme.gsx macro. The setup is the same, you just use a different directory to keep the "county" and "page" shape files seperate.

The DeLorme.gsk macro places the results in two places. It populates the "User Data" field with results like "Pg 42". The macro also prepends the "User Data 2" field (currently used by County.gsk to hold the county data) with results like this: "41-Anoka". 41 is the DeLorme page number and Anoka is the County name. If there is no County information in "User Data 2", then it will be populated the same as "User Data". For the latter (User Data 2) to be populated correctly with both County and DeLorme page number, run thte county.gsx macro first and then run the DeLorme.gsx macro.

I only have shape files for Minnesota. However, the macro does support the possibility of adding additional states by simply creating the state directory containing the appropriate shape files.

merkman · Past MnGCA Board Joined: 03 Jun 2006 Posts: 2032

So lets see it!!!

RubberToes · Posted: Thu Nov 15, 2007 11:56 am Post subject:

Cool. Glad I was able to help you out. I'd love to see a copy of your DeLorme macro even though I probably don't need it at this point. I only have a few DeLorme pages left to do and I already have filters set up for all pages.

What I do when getting ready for a trip is run a macro that chains together as many of these filters as I need, and that pretty quickly gets me all the caches that will be in play for that trip. Then I run one more macro to output to the GPS, Cachemate, and Mapsource and I'm out the door.

Bus&Betty · Posted: Thu Nov 15, 2007 12:24 pm Post subject:

I've received several offers to host the files.

Thanks everyone.

Happy Cachin' Smile

Pear Head · Posted: Thu Nov 15, 2007 6:46 pm Post subject:

Jonas

Bus&Betty · Posted: Fri Nov 16, 2007 8:32 am Post subject:

I've submitted the first change request to Bob Confused

I would like the DeLorme number after the county name, not before. That way, the User Data 2 field sorts by county name, not DeLorme number.

I've also found a page number discrepancy between the User Data and User Data 2 fields for 24, 25, and 26. The User Data 2 field is correct, the User Data field is not. Bob will look at this too.

Patty

Yes Dear. Cool

--Bus