Re: Time to update list of contributors

From: Bruce Momjian
Subject: Re: Time to update list of contributors
Date: ,
Msg-id: 200711291653.lATGrAC02675@momjian.us
(view: Whole thread, Raw)
In response to: Re: Time to update list of contributors  (Robert Treat)
List: pgsql-www

Tree view

Time to update list of contributors  (Josh Berkus, )
 Re: Time to update list of contributors  ("Joshua D. Drake", )
 Re: [HACKERS] Time to update list of contributors  (Kris Jurka, )
  Re: [HACKERS] Time to update list of contributors  (Magnus Hagander, )
   Re: [HACKERS] Time to update list of contributors  (Kris Jurka, )
    Re: [HACKERS] Time to update list of contributors  (Magnus Hagander, )
 Re: [HACKERS] Time to update list of contributors  (Tom Lane, )
 Re: [HACKERS] Time to update list of contributors  ("Jaime Casanova", )
 Re: [HACKERS] Time to update list of contributors  (Devrim GÜNDÜZ, )
  Re: [HACKERS] Time to update list of contributors  (Magnus Hagander, )
   Re: [HACKERS] Time to update list of contributors  (NikhilS, )
 Re: [HACKERS] Time to update list of contributors  ("Pavan Deolasee", )
 Re: Time to update list of contributors  (Gregory Stark, )
  Re: Time to update list of contributors  (Gregory Stark, )
   Re: Time to update list of contributors  ("Joshua D. Drake", )
    Re: Time to update list of contributors  (Gregory Stark, )
     Re: Time to update list of contributors  (Josh Berkus, )
      Re: Time to update list of contributors  ("Joshua D. Drake", )
       Re: Time to update list of contributors  (Josh Berkus, )
        Re: Time to update list of contributors  ("Joshua D. Drake", )
         Re: Time to update list of contributors  (Josh Berkus, )
          Re: Time to update list of contributors  ("Joshua D. Drake", )
        Re: Time to update list of contributors  (Alvaro Herrera <-ip.org>, )
      Re: Time to update list of contributors  (Stefan Kaltenbrunner, )
      Re: Time to update list of contributors  (Alvaro Herrera <-ip.org>, )
       Re: Time to update list of contributors  (Magnus Hagander, )
        Re: Time to update list of contributors  (Josh Berkus, )
         Re: Time to update list of contributors  (Magnus Hagander, )
          Re: Time to update list of contributors  (Robert Treat, )
           Re: Time to update list of contributors  (Gregory Stark, )
            Re: Time to update list of contributors  (Magnus Hagander, )
             Re: Time to update list of contributors  (Gregory Stark, )
              Re: Time to update list of contributors  (Magnus Hagander, )
           Re: Time to update list of contributors  (Bruce Momjian, )
           Re: Time to update list of contributors  (Magnus Hagander, )
            Re: Time to update list of contributors  (Josh Berkus, )
             Re: Time to update list of contributors  (Kevin Hunter, )
              Re: Time to update list of contributors  (Robert Treat, )
 Re: Time to update list of contributors  (Dave Page, )
  Re: [HACKERS] Time to update list of contributors  (Stefan Kaltenbrunner, )
   Re: [HACKERS] Time to update list of contributors  (Dave Page, )
    Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
     Re: [HACKERS] Time to update list of contributors  (Dave Page, )
      Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
       Re: [HACKERS] Time to update list of contributors  (Dave Page, )
        Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
         Re: [HACKERS] Time to update list of contributors  (Magnus Hagander, )
          Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
          Re: [HACKERS] Time to update list of contributors  ("Kevin Grittner", )
     Re: [HACKERS] Time to update list of contributors  (Andrew Dunstan, )
      Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
       Re: [HACKERS] Time to update list of contributors  (Andrew Dunstan, )
        Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
       Re: [HACKERS] Time to update list of contributors  (Bruce Momjian, )
        Re: [HACKERS] Time to update list of contributors  (Bruce Momjian, )
         Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
     Re: [HACKERS] Time to update list of contributors  ("Marc G. Fournier", )
      Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
      Re: [HACKERS] Time to update list of contributors  (Stefan Kaltenbrunner, )
  Re: Time to update list of contributors  (Josh Berkus, )
 Re: [HACKERS] Time to update list of contributors  (Magnus Hagander, )
  Re: [HACKERS] Time to update list of contributors  (Robert Treat, )
 Re: [HACKERS] Time to update list of contributors  ("Joshua D. Drake", )
 Re: Time to update list of contributors  (Peter Eisentraut, )
  Re: Time to update list of contributors  (Magnus Hagander, )

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  <>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +



pgsql-www by date:

From: Magnus Hagander
Date:
Subject: Re: Can we please refuse mail to the list from list addresses?
From: Andrew Sullivan
Date:
Subject: Re: Can we please refuse mail to the list from list addresses?