| 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(dot) Drake" <jd(at)commandprompt(dot)com> |
| Subject: | Re: Time to update list of contributors |
| Date: | 2007-11-29 15:45:51 |
| Message-ID: | 87hcj5kqc0.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Douglas McNaught | 2007-11-29 16:00:44 | Re: convert int to bytea |
| Previous Message | Tom Lane | 2007-11-29 15:37:30 | Re: pgwin32_open returning EINVAL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-11-29 15:55:23 | Re: Can we please refuse mail to the list from list addresses? |
| Previous Message | Robert Treat | 2007-11-29 15:32:28 | Re: Time to update list of contributors |