Re: Time to update list of contributors

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +