maemo.org - Talk - View Single Post - Importing List of POIs into Maemo Mapper 2.3

	abby_normal	2008-01-28 , 22:48
	Posts: 48 \| Thanked: 4 times \| Joined on Jan 2008	#1

First of all, let me just say that this is a truly awesome program. Kudos to gnuite and the others contributing to the project.

I will be traveling to NZ next month, and have been working on obtaining offline content. Downloading maps has been working fine, so I've now turned to POIs. There is an impressive collection (40,000+) available from Zenbu (www.zenbu.co.nz), and I managed to convert the native format (.CSV file) to .GPX using a program called GPSBabel, and then imported the waypoints into Mapper. The import took quite a while!

My question is whether anyone has advice or suggestions as to how I can best map the information in the Zenbu file to Mapper. The Zenbu information does not have "categories" as such, it has "tags" that do not easily map to categories. Here are the first 3 lines of the .csv file, which shows the available fields:

Code:

zid,name,tags,website,physical_address,phone,opening_hours,longitude,latitude,gisprecision,correctly_placed,created_at,updated_at,updated_by
1000105,The Don,"japanese donburi restaurant, takeaway, licensed","","Upstairs in Queens Arcade, 47 High Street, Auckland",09 379 2834,"Mon Fri 11am-9pm, Sat 5-9pm",174.766374,-36.848021,number,true,2006-07-06 14:29:32,2006-10-06 09:37:22,zenbu
1000112,Burger King - Swanson Street,"burgers, fast food",http://www.burgerking.co.nz,"115 Queen Street, Auckland Central",09 309 8579,"",174.765937,-36.846247,manual,true,2006-07-06 15:12:51,2007-03-15 10:41:15.252002,zenbu

What's too bad is that most of this information gets lost in the shuffle. When GPSBabel turns this into .GPX, it just takes the information in the "name" field and puts it into <name>, <cmt>, and <desc> tags, like so:

Code:

<wpt lat="-36.848021000" lon="174.766374000">
<time>2006-10-06T00:00:00Z</time>
  <name>The Don</name>
  <cmt>The Don</cmt>
  <desc>The Don</desc>
</wpt>

I messed around with changing the headings in the first line of the .CSV file, but that did not help. I imagine that with some tweaking, either GPSBabel or some other program could assign the tags more intelligently, and mabe even concatenate fields in some reasonable manner (e.g. put address, phone, hours, and website into the <desc> tag separated by line breaks). Any suggestions on a good program or technique for doing this?

The folks at the New Zealand Open GPS Maps Project (gwprojects.orcon.net.nz/gps/) have figured out a way to get all of this information into useful waypoints for Garmin units--including icons appropriate to the type of waypoint, inclusion of addresses & phone numbers, etc. Is there any reasonable prospect of doing something similar with Mapper?

Quote & Reply |