Convert SQL to Geodata for Australia

Hi I have a SQL file that contains the postcode, suburb name, lat and long for Australia. Just wondering how would I go about creating a geodata file from this and use it on my psp with Australia's maps.

hey kaitoudark,

thats some interesting information which you have there. would be useful to compile into geodata for Australia,

I'd probably recommend that you private message (pm) deniska on this request as he should be able to give you information on possibility doing this.

Im from australia too and would find this information helpful to get mapthis working with gps guidance and not just gps mapping :)

Cheers.

Well I tried PMing deniska.....unfortunately deniska's inbox is full and does not accept any PMs.
:(

any way of passing that information to me so i could have a look ?

There's a few Aussie users on here, and I'd love to have this also, it'd be a huge help.

PM me ur email if you want the SQL file and have a crack at it yourself.

It should be reasonably easy for you to get the data into a CSV (Excel database connection, move about some columns, etc.) after that I've added importing custom geodata into GMDL, see: http://en.wikibooks.org/wiki/Map_This!?#Custom and redownload http://www.in7ane.com/psp/gmdl0.4.17a.zip

Thanks in7ane, I'll give it a try and see how it goes.

hey everyone:)

im new to all this stuff.

Im about to purchuse a gps for my psp and i live in Australia, would it work, asuming from riceboi post it does? what are you guys talking about? something wrong with gps service in australia?

At the moment all we can do is surf around lots of tiles (pictures). There is no data stored in them apart where they sit in comparison to other tiles.

Adding geodata means that Mapthis can determine which tiles are in which suburb, and tell you how to get there (at the moment you can only do this on you PC and them transfer the info).

Eventually full geodata (street numbers, street names) should be available, at which time we can search for a street and number and Mapthis can figure out how to get there. Our friends in other countries already have this.