Skip site navigation (1) Skip section navigation (2)

Re: Time to update list of contributors

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-www(at)postgresql(dot)org,Josh Berkus <josh(at)agliodbs(dot)com>,Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>,"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: Time to update list of contributors
Date: 2007-11-29 16:25:20
Message-ID: 20071129162520.GQ8718@svr2.hagander.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-www
On Thu, Nov 29, 2007 at 03:45:51PM +0000, Gregory Stark wrote:
> "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> writes:
> 
> > On Wednesday 28 November 2007 16:09, Magnus Hagander wrote:
> >> 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. 
> 
> Aren't these two sides of the same coin? First you add postgis columns to the
> database to gather latitude and longitude for each developer in the database.
> Then you have the web site use Postgres's xml support to generate the xml
> document that you use with google maps to actually generate the map.

Don't need postgis columns to do that. Just store the coordinates in float
columns. Google does all the GIS stuff on them.

//Magnus

In response to

Responses

pgsql-www by date

Next:From: Gregory StarkDate: 2007-11-29 16:29:41
Subject: Re: Time to update list of contributors
Previous:From: Magnus HaganderDate: 2007-11-29 16:24:46
Subject: Re: Can we please refuse mail to the list from list addresses?

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-11-29 16:26:53
Subject: Status report on 8.3 release
Previous:From: Alvaro HerreraDate: 2007-11-29 16:13:57
Subject: Re: pgwin32_open returning EINVAL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group