"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.
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production
Tuning