Robert Treat wrote:
> On Wednesday 28 November 2007 16:09, Magnus Hagander wrote:
> > Josh Berkus wrote:
> > > Magnus,
> > >
> > >> We could probably do that fairly easily by just using the google maps
> > >> API.
> > >>
> > >> We used to have a dev map, but it was individually updated. Might be
> > >> easier to do now that there are services out there to do it for us..
> > >
> > > Yeah. Too bad we don't have access to some kind of GIS database or
> > > something which we could use to generate a map. ;-)
> >
> > Well, we have a GIS database, but we don't have the mapping data :-P
>
> Well, it is easy to do it via google maps API. I did this once before on my
> old dev installed, which I'm pretty sure was trashed, but could be redone.
> You need to store everyones lat/lon, and then generate an xml file with the
> proper info, but it's not to tricky. Granted using a service based on
> PostGIS would be cooler, but I've not yet seen one as simple to use as
> google's stuff.
I have a map of my Postgres trips using Google:
http://momjian.us/main/trips.html
Robert is right you just have a javascript file with longitude/latutude
and city name. Here is the javascript I use:
http://momjian.us/main/js/google_map_api.js
I downloaded a location longitude/latutudes from:
http://www.maxmind.com/download/worldcities/
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +