Re: Time to update list of contributors

[Bruce Momjian <bruce(at)momjian(dot)us>]

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. +