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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Time to update list of contributors


  • From: Gregory Stark <stark(at)enterprisedb(dot)com>
  • To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
  • Cc: <pgsql-www(at)postgresql(dot)org>, "Magnus Hagander" <magnus(at)hagander(dot)net>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>, "Joshua D. Drake" <jd(at)commandprompt(dot)com>
  • Subject: Re: Time to update list of contributors
  • Date: Thu, 29 Nov 2007 15:45:51 +0000
  • Message-id: <87hcj5kqc0(dot)fsf(at)oxford(dot)xeocode(dot)com>

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

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group