Convert SQL to Geodata for Australia

**kaitoudark** · June 20th, 2007, 05:10

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.

**riceboi** · June 20th, 2007, 09:57

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.

**kaitoudark** · June 20th, 2007, 11:15

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

**riceboi** · June 21st, 2007, 08:50

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

**Leake** · June 21st, 2007, 21:58

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

**kaitoudark** · June 24th, 2007, 00:43

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

**in7ane** · July 3rd, 2007, 12:39

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

**kaitoudark** · July 4th, 2007, 02:52

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

**a_haouchar** · July 4th, 2007, 08:46

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?

**hes21** · July 4th, 2007, 12:53

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.