On Thu, Nov 29, 2007 at 03:45:51PM +0000, Gregory Stark wrote:
> "Robert Treat" <xzilla@users.sourceforge.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