Re: [Mapbender-users] Re: [Freegis-list] Re: [GENERAL]

Hi,

We've developed an automatic email mapping capability from Google Maps
API.

To try it out, we mapped origins of emails to this group from October
2, 2005 2 pm (EST) through October 14th, 9 am (EST).

The result of this map is at:
http://www.zeesource.net/maps/map.do?group=456

Would like to hear what you think of it.

Best wishes

Claire

--
Claire McLister                       mclister(at)zeesource(dot)net
1684 Nightingale Avenue     Suite 201
Sunnyvale, CA 94087        408-733-2737(fax)

http://www.zeesource.net

Hi,

Pretty neat: I'm glad I'm not on that map!

Regards,

Arthur

On 10/24/05, Claire McLister <mclister(at)zeesource(dot)net> wrote:
> Hi,
>
> We've developed an automatic email mapping capability from Google Maps
> API.
>
> To try it out, we mapped origins of emails to this group from October
> 2, 2005 2 pm (EST) through October 14th, 9 am (EST).
>
> The result of this map is at:
> http://www.zeesource.net/maps/map.do?group=456
>
> Would like to hear what you think of it.
>
> Best wishes
>
> Claire
>
> --
> Claire McLister mclister(at)zeesource(dot)net
> 1684 Nightingale Avenue Suite 201
> Sunnyvale, CA 94087 408-733-2737(fax)
>
> http://www.zeesource.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

I'm not sure if you show up in the wrong place, but you do show up in
Mountain View, California.

(To see that type 'hooger' next to the 'Name' filter above the map and
click on 'Filter'.

Claire

On Oct 24, 2005, at 12:15 PM, Arthur Hoogervorst wrote:

> Hi,
>
> Pretty neat: I'm glad I'm not on that map!
>
>
> Regards,
>
>
> Arthur
>
>
> On 10/24/05, Claire McLister <mclister(at)zeesource(dot)net> wrote:
>> Hi,
>>
>> We've developed an automatic email mapping capability from Google
>> Maps
>> API.
>>
>> To try it out, we mapped origins of emails to this group from
>> October
>> 2, 2005 2 pm (EST) through October 14th, 9 am (EST).
>>
>> The result of this map is at:
>> http://www.zeesource.net/maps/map.do?group=456
>>
>> Would like to hear what you think of it.
>>
>> Best wishes
>>
>> Claire
>>
>> --
>> Claire McLister mclister(at)zeesource(dot)net
>> 1684 Nightingale Avenue Suite 201
>> Sunnyvale, CA 94087 408-733-2737(fax)
>>
>> http://www.zeesource.net
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend

On Mon, 24 Oct 2005, Claire McLister wrote:

> Hi,
>
> We've developed an automatic email mapping capability from Google Maps
> API.
>
> To try it out, we mapped origins of emails to this group from October
> 2, 2005 2 pm (EST) through October 14th, 9 am (EST).
>
> The result of this map is at:
> http://www.zeesource.net/maps/map.do?group=456
>
> Would like to hear what you think of it.
>

How about using Postgres/PostGIS & UMN mapserver for a fully Open Source
software & Postgres based map?

For a map like the one at
http://www.qgis.org/index.php?option=com_wrapper&Itemid=53

perhaps on the Postgres web site?

Brent Wood

Thanks.

I looked at the Mapserver maps, and at first glance it seems Google
Maps API provides better map images and more interactive features
(zooming, panning, JS popups, satellite/map views, etc.)

So, what would be the advantage of Mapserver apart from it being based
on Open Source?

We use Postgresql server to store the data. Currently, we do not use
PostGIS as we do not do much geographical queries. Over time we could
move in that direction to offer better geographical query support.

Posting this (or a more detailed map) on the Postgresql web site sounds
like a great idea. We could even allow people to add markers for their
locations, and even enter more information about themselves to help
postgresql users connect with each other. One potential opportunity is
for users to quickly find consultants in their own area.

How would we initiate this activity?

Best wishes

Claire

On Oct 24, 2005, at 2:28 PM, Brent Wood wrote:

> How about using Postgres/PostGIS & UMN mapserver for a fully Open
> Source
> software & Postgres based map?
>
> For a map like the one at
> http://www.qgis.org/index.php?option=com_wrapper&Itemid=53
>
> perhaps on the Postgres web site?

Actually I have already made a basic google map for the website[1] meant
to replace the old developers map. Check out the blog post at
http://people.planetpostgresql.org/xzilla/index.php?/archives/76-Maptastic.html

I'd be interested in talking more about getting more content into the
map and getting it in officially; One concern I had was finding a way to
include information that won't bog down end users with too much data.
(I've noticed large numbers of points tend to do that)

Robert Treat

On Tue, 2005-10-25 at 12:11, Claire McLister wrote:
> Thanks.
>
> I looked at the Mapserver maps, and at first glance it seems Google
> Maps API provides better map images and more interactive features
> (zooming, panning, JS popups, satellite/map views, etc.)
>
> So, what would be the advantage of Mapserver apart from it being based
> on Open Source?
>
> We use Postgresql server to store the data. Currently, we do not use
> PostGIS as we do not do much geographical queries. Over time we could
> move in that direction to offer better geographical query support.
>
> Posting this (or a more detailed map) on the Postgresql web site sounds
> like a great idea. We could even allow people to add markers for their
> locations, and even enter more information about themselves to help
> postgresql users connect with each other. One potential opportunity is
> for users to quickly find consultants in their own area.
>
> How would we initiate this activity?
>
> Best wishes
>
> Claire
>
> On Oct 24, 2005, at 2:28 PM, Brent Wood wrote:
>
> > How about using Postgres/PostGIS & UMN mapserver for a fully Open
> > Source
> > software & Postgres based map?
> >
> > For a map like the one at
> > http://www.qgis.org/index.php?option=com_wrapper&Itemid=53
> >
> > perhaps on the Postgres web site?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

On Tue, 25 Oct 2005, Claire McLister wrote:

> Thanks.
>
> I looked at the Mapserver maps, and at first glance it seems Google
> Maps API provides better map images and more interactive features
> (zooming, panning, JS popups, satellite/map views, etc.)
>
> So, what would be the advantage of Mapserver apart from it being based
> on Open Source?

More vector datasets to overlay & more control of the output map. For
example in New Zealand, we have access to higher resolution imagery than
google maps, as well as detailed vector data.

But I also think it could make a nice showcase for an Open Soure suite,
with Postgres, PostGIS, GEOS, GDAL/OGR, Proj4, Mapserver, using global &
local datasets, etc.

>
> We use Postgresql server to store the data. Currently, we do not use
> PostGIS as we do not do much geographical queries. Over time we could
> move in that direction to offer better geographical query support.
>
> Posting this (or a more detailed map) on the Postgresql web site sounds
> like a great idea. We could even allow people to add markers for their
> locations, and even enter more information about themselves to help
> postgresql users connect with each other. One potential opportunity is
> for users to quickly find consultants in their own area.
>
> How would we initiate this activity?

I'll forward this to a few people in the Open Source web mapping community
who may be able to assist.

>
> Best wishes
>
> Claire
>
> On Oct 24, 2005, at 2:28 PM, Brent Wood wrote:
>
> > How about using Postgres/PostGIS & UMN mapserver for a fully Open
> > Source
> > software & Postgres based map?
> >
> > For a map like the one at
> > http://www.qgis.org/index.php?option=com_wrapper&Itemid=53
> >
> > perhaps on the Postgres web site?
>
>

Robert Treat wrote:
> Actually I have already made a basic google map for the website[1] meant
> to replace the old developers map. Check out the blog post at
> http://people.planetpostgresql.org/xzilla/index.php?/archives/76-Maptastic.html
>
> I'd be interested in talking more about getting more content into the
> map and getting it in officially; One concern I had was finding a way to
> include information that won't bog down end users with too much data.
> (I've noticed large numbers of points tend to do that)

I do like the fact you pulled the names off the emails as well as the
email addresses. That is important.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

> I do like the fact you pulled the names off the emails as well as the
> email addresses. That is important.
>

Is there a plugin I am missing to make this work in Firefox? I just get
a blank grey screen.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Hi Joshua,

No, you should not need a plugin. Can you open the Firefox Javascript
console and see if you get errors in Javascript? The mapping relies
heavily on Javascript and sometimes that gives errors. I just tried it
on Firefox 1.0 and it showed up okay.

Let me know if the problem persists and we can try to resolve it.

Claire

On Oct 25, 2005, at 4:59 PM, Joshua D. Drake wrote:

>
>> I do like the fact you pulled the names off the emails as well as the
>> email addresses. That is important.
>>
>
> Is there a plugin I am missing to make this work in Firefox? I just get
> a blank grey screen.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
> --
> The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>

I took a look at your map, this is great wonderful that you were
already thinking along these lines.

Looks like there are two issues here: (1) Getting the data points for
users/developers maps, and (2) using the most appropriate mapping
technology.

I think we can use the Zeemaps service (http://www.zeemaps.com) for
number (1) above. The way this works is that you create a map and set a
few passwords: (a) moderator, (b) member, and (c) viewer. Using the
moderator password, you can set certain map properties, e.g.,
attributes to maintain with each entry, color legends, etc. With a
member password you can modify entries and their attributes, and with a
viewer password you can just see details without the ability to modify
anything. A casual user can just see the map with the markers and their
names, without access to any details for the entries. Hence
distributing the member password to the group and having each person
add his or her details would be a good way to go. The number of points
for Postgresql users can, of course, go pretty high. So far, we have
seen reasonable performance with up to 500-600 markers. I don't know if
there is an easy way of partitioning the user base into segments that
can fit within this range. Another idea would be to just split the map
after say 500 points.

For the number (2) the choice seems to be between Google Maps vs.
Mapserver and its associated Open Source tools. Having looked at
Brent's follow up emails, it seems that Mapserver and associated
toolkits can give much more flexibility. Plus they have the advantage
that we are not limited by Google's terms, the most annoying of which
is that you cannot save, copy, or distribute the map images created.
So, it seems best to move towards the Open Source alternatives,
specially since they have better images as Brent points out. I've been
looking at some of the Mapserver toolkits, and there seems to be an
overwhelming amount of choice available for what to pick and not. So, I
don't feel qualified to pick the right technologies to use for the base
implementation. If someone can pick the mantle on that, I'd be happy to
work with that person to see how we can exchange information from the
map points stored from (1). If for the time being you feel comfortable
continuing with Google Maps, then there's multiple ways we can share
information developed by (1) through some kind of a web service API.

Claire

On Oct 25, 2005, at 2:33 PM, Robert Treat wrote:

> Actually I have already made a basic google map for the website[1]
> meant
> to replace the old developers map. Check out the blog post at
> http://people.planetpostgresql.org/xzilla/index.php?/archives/76-
> Maptastic.html
>
> I'd be interested in talking more about getting more content into the
> map and getting it in officially; One concern I had was finding a way
> to
> include information that won't bog down end users with too much data.
> (I've noticed large numbers of points tend to do that)
>
>
> Robert Treat
>
>
> On Tue, 2005-10-25 at 12:11, Claire McLister wrote:
>> Thanks.
>>
>> I looked at the Mapserver maps, and at first glance it seems Google
>> Maps API provides better map images and more interactive features
>> (zooming, panning, JS popups, satellite/map views, etc.)
>>
>> So, what would be the advantage of Mapserver apart from it being based
>> on Open Source?
>>
>> We use Postgresql server to store the data. Currently, we do not use
>> PostGIS as we do not do much geographical queries. Over time we could
>> move in that direction to offer better geographical query support.
>>
>> Posting this (or a more detailed map) on the Postgresql web site
>> sounds
>> like a great idea. We could even allow people to add markers for their
>> locations, and even enter more information about themselves to help
>> postgresql users connect with each other. One potential opportunity is
>> for users to quickly find consultants in their own area.
>>
>> How would we initiate this activity?
>>
>> Best wishes
>>
>> Claire
>>
>> On Oct 24, 2005, at 2:28 PM, Brent Wood wrote:
>>
>>> How about using Postgres/PostGIS & UMN mapserver for a fully Open
>>> Source
>>> software & Postgres based map?
>>>
>>> For a map like the one at
>>> http://www.qgis.org/index.php?option=com_wrapper&Itemid=53
>>>
>>> perhaps on the Postgres web site?
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

On Wednesday 26 October 2005 18:24, Claire McLister wrote:
> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
> > There has recently been a thread on the Postgres user list about a web
> > based postgres user/developer map. Claire has built a Google map based
> > system, getting locations from IP addresses.
>
> Just so people know, this map can be found at:
>
> http://www.zeesource.net/maps/map.do?group=456
>

I'm going to loop in a few more people here :-), namely the pg web team who
will probably be able to give pointers on site integration. One thing to keep
in mind is that the postgresql website is statically mirrored onto a number
of different servers, so any solution we come up with will ideally allow
itself to that. I believe a google maps system can do this (we can mirror the
javascript code and the location/data file on all mirrors and the google map
will work with it as is), which is why I originally went with that type of
solution.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Good point. This might actually be a problem. Google Maps API requires
each server that is serving the map to be registered with Google, and
send the corresponding key when making the Javascript request.

Unless the mirrors can each send their own keys, this will not work.

Claire

On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:

> On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>> There has recently been a thread on the Postgres user list about a
>>> web
>>> based postgres user/developer map. Claire has built a Google map
>>> based
>>> system, getting locations from IP addresses.
>>
>> Just so people know, this map can be found at:
>>
>> http://www.zeesource.net/maps/map.do?group=456
>>
>
> I'm going to loop in a few more people here :-), namely the pg web
> team who
> will probably be able to give pointers on site integration. One thing
> to keep
> in mind is that the postgresql website is statically mirrored onto a
> number
> of different servers, so any solution we come up with will ideally
> allow
> itself to that. I believe a google maps system can do this (we can
> mirror the
> javascript code and the location/data file on all mirrors and the
> google map
> will work with it as is), which is why I originally went with that
> type of
> solution.
>
> --
> Robert Treat
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Claire McLister wrote:
> Good point. This might actually be a problem. Google Maps API requires
> each server that is serving the map to be registered with Google, and
> send the corresponding key when making the Javascript request.
>
> Unless the mirrors can each send their own keys, this will not work.
>
> Claire

Hi, more cross posting...

Sounds like this task should be solved using WMS and WFS services.
Google is cool but in order to foster both Open Source and standards
(OGC) we would suggest to use e.g. MapServer as WMS to produce the maps
and GeoServer as WFS to manage geomtries. Those OWS services could then
be included in any OWS client, web interface, etc. Everything is there
and ready to go, the effort to get it to run should be minimal.

Our clients usually operate PostgreSQL databases with several million
geometries - those 500 to 600 markers could be hosted on any
antediluvian box and still be fast. You will know what to about
mirroring, we would probably suggest to implement P2P - read Ward
Cunninghams ideas int he keynote at the Wikimania conference this summer...

We have done the user mmapping Mapbender users with tooltips, direct
link to the website, etc. You can have a look at it on the project
homepage http://www.mapbender.org
Its done Wiki-style so that users can enter their own position (use the
blue flag) or remove or edit any position (use the i-button). No user
accounts yet but security and authentication is in place and have just
not yet been necessary (still waiting for spatial spam...)

We will spread word about spatial data management using
PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
Frankfurt/Main, Germany.

This idea is on short notice but i would be really very excited if i
could show the map there! We suggest the following alterantive actions:

- It should be easy to add a geometry_column to the existing PostgreSQL
database which alredy has the positions. Add a GeoServer WFS to access
the geomtry and a MapServer for WMS display.
- Alternatively send Paolo or us or both the geo-positions and we add
them to our existing OWS infrastructure (that will takt a few hours of
work only).

Beause there is not so much time until the conference this would just be
be a prototype which should in the long run move to the PostgreSQL or
PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
Wikipedia software) is also right now introducing geometries to the Wiki
database - obviously also using PostgreSQL/PostGIS. This would be
another cool multiplier.. and there we also meet with Google again.

Best, Arnulf.

> On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
>
>> On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>>
>>> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>>
>>>> There has recently been a thread on the Postgres user list about a web
>>>> based postgres user/developer map. Claire has built a Google map based
>>>> system, getting locations from IP addresses.
>>>
>>>
>>> Just so people know, this map can be found at:
>>>
>>> http://www.zeesource.net/maps/map.do?group=456
>>>
>>
>> I'm going to loop in a few more people here :-), namely the pg web
>> team who
>> will probably be able to give pointers on site integration. One thing
>> to keep
>> in mind is that the postgresql website is statically mirrored onto a
>> number
>> of different servers, so any solution we come up with will ideally allow
>> itself to that. I believe a google maps system can do this (we can
>> mirror the
>> javascript code and the location/data file on all mirrors and the
>> google map
>> will work with it as is), which is why I originally went with that
>> type of
>> solution.
>>
>> --
>> Robert Treat
>> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> _______________________________________________
> Freegis-list mailing list
> Freegis-list(at)intevation(dot)de
> https://intevation.de/mailman/listinfo/freegis-list

Arnulf,

Thanks for your message. I looked at the mapbender site, and it looks
like it has the basic functions except the password protection, which
you will probably need at some point:-) The performance from here
(California) was slow, and the map image did not look as good as
Google's. I suppose we have better map images available?

I could not find Cunninghams talk on P2P style wiki's, but seems to me
that it would be too much work for a simple web page. Ideally, we'd
just want to have a static map with possibly Javascript popups. That
way, the performance can be good and the web site doesn't become that
onerous that the pg www group kicks us out.

So, a question to you and Palo: Can you generate such static map
(along with Javascript code) from Mapserver?

Claire

On Oct 28, 2005, at 3:44 AM, Arnulf Christl wrote:

> Claire McLister wrote:
>> Good point. This might actually be a problem. Google Maps API
>> requires each server that is serving the map to be registered with
>> Google, and send the corresponding key when making the Javascript
>> request.
>> Unless the mirrors can each send their own keys, this will not work.
>> Claire
>
> Hi, more cross posting...
>
> Sounds like this task should be solved using WMS and WFS services.
> Google is cool but in order to foster both Open Source and standards
> (OGC) we would suggest to use e.g. MapServer as WMS to produce the
> maps and GeoServer as WFS to manage geomtries. Those OWS services
> could then be included in any OWS client, web interface, etc.
> Everything is there and ready to go, the effort to get it to run
> should be minimal.
>
> Our clients usually operate PostgreSQL databases with several million
> geometries - those 500 to 600 markers could be hosted on any
> antediluvian box and still be fast. You will know what to about
> mirroring, we would probably suggest to implement P2P - read Ward
> Cunninghams ideas int he keynote at the Wikimania conference this
> summer...
>
> We have done the user mmapping Mapbender users with tooltips, direct
> link to the website, etc. You can have a look at it on the project
> homepage http://www.mapbender.org
> Its done Wiki-style so that users can enter their own position (use
> the blue flag) or remove or edit any position (use the i-button). No
> user accounts yet but security and authentication is in place and have
> just not yet been necessary (still waiting for spatial spam...)
>
> We will spread word about spatial data management using
> PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
> http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
> Frankfurt/Main, Germany.
>
> This idea is on short notice but i would be really very excited if i
> could show the map there! We suggest the following alterantive
> actions:
>
> - It should be easy to add a geometry_column to the existing
> PostgreSQL database which alredy has the positions. Add a GeoServer
> WFS to access the geomtry and a MapServer for WMS display.
> - Alternatively send Paolo or us or both the geo-positions and we add
> them to our existing OWS infrastructure (that will takt a few hours of
> work only).
>
> Beause there is not so much time until the conference this would just
> be be a prototype which should in the long run move to the PostgreSQL
> or PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
> Wikipedia software) is also right now introducing geometries to the
> Wiki database - obviously also using PostgreSQL/PostGIS. This would be
> another cool multiplier.. and there we also meet with Google again.
>
> Best, Arnulf.
>
>
>> On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
>>> On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>>>
>>>> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>>>
>>>>> There has recently been a thread on the Postgres user list about a
>>>>> web
>>>>> based postgres user/developer map. Claire has built a Google map
>>>>> based
>>>>> system, getting locations from IP addresses.
>>>>
>>>>
>>>> Just so people know, this map can be found at:
>>>>
>>>> http://www.zeesource.net/maps/map.do?group=456
>>>>
>>>
>>> I'm going to loop in a few more people here :-), namely the pg web
>>> team who
>>> will probably be able to give pointers on site integration. One
>>> thing to keep
>>> in mind is that the postgresql website is statically mirrored onto a
>>> number
>>> of different servers, so any solution we come up with will ideally
>>> allow
>>> itself to that. I believe a google maps system can do this (we can
>>> mirror the
>>> javascript code and the location/data file on all mirrors and the
>>> google map
>>> will work with it as is), which is why I originally went with that
>>> type of
>>> solution.
>>>
>>> --
>>> Robert Treat
>>> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>> _______________________________________________
>> Freegis-list mailing list
>> Freegis-list(at)intevation(dot)de
>> https://intevation.de/mailman/listinfo/freegis-list
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

FYI, here is a map of my PostgreSQL trips, using Google:

http://candle.pha.pa.us/main/writings/map.html

---------------------------------------------------------------------------

Claire McLister wrote:
> I took a look at your map, this is great wonderful that you were
> already thinking along these lines.
>
> Looks like there are two issues here: (1) Getting the data points for
> users/developers maps, and (2) using the most appropriate mapping
> technology.
>
> I think we can use the Zeemaps service (http://www.zeemaps.com) for
> number (1) above. The way this works is that you create a map and set a
> few passwords: (a) moderator, (b) member, and (c) viewer. Using the
> moderator password, you can set certain map properties, e.g.,
> attributes to maintain with each entry, color legends, etc. With a
> member password you can modify entries and their attributes, and with a
> viewer password you can just see details without the ability to modify
> anything. A casual user can just see the map with the markers and their
> names, without access to any details for the entries. Hence
> distributing the member password to the group and having each person
> add his or her details would be a good way to go. The number of points
> for Postgresql users can, of course, go pretty high. So far, we have
> seen reasonable performance with up to 500-600 markers. I don't know if
> there is an easy way of partitioning the user base into segments that
> can fit within this range. Another idea would be to just split the map
> after say 500 points.
>
> For the number (2) the choice seems to be between Google Maps vs.
> Mapserver and its associated Open Source tools. Having looked at
> Brent's follow up emails, it seems that Mapserver and associated
> toolkits can give much more flexibility. Plus they have the advantage
> that we are not limited by Google's terms, the most annoying of which
> is that you cannot save, copy, or distribute the map images created.
> So, it seems best to move towards the Open Source alternatives,
> specially since they have better images as Brent points out. I've been
> looking at some of the Mapserver toolkits, and there seems to be an
> overwhelming amount of choice available for what to pick and not. So, I
> don't feel qualified to pick the right technologies to use for the base
> implementation. If someone can pick the mantle on that, I'd be happy to
> work with that person to see how we can exchange information from the
> map points stored from (1). If for the time being you feel comfortable
> continuing with Google Maps, then there's multiple ways we can share
> information developed by (1) through some kind of a web service API.
>
> Claire
>
>
> On Oct 25, 2005, at 2:33 PM, Robert Treat wrote:
>
> > Actually I have already made a basic google map for the website[1]
> > meant
> > to replace the old developers map. Check out the blog post at
> > http://people.planetpostgresql.org/xzilla/index.php?/archives/76-
> > Maptastic.html
> >
> > I'd be interested in talking more about getting more content into the
> > map and getting it in officially; One concern I had was finding a way
> > to
> > include information that won't bog down end users with too much data.
> > (I've noticed large numbers of points tend to do that)
> >
> >
> > Robert Treat
> >
> >
> > On Tue, 2005-10-25 at 12:11, Claire McLister wrote:
> >> Thanks.
> >>
> >> I looked at the Mapserver maps, and at first glance it seems Google
> >> Maps API provides better map images and more interactive features
> >> (zooming, panning, JS popups, satellite/map views, etc.)
> >>
> >> So, what would be the advantage of Mapserver apart from it being based
> >> on Open Source?
> >>
> >> We use Postgresql server to store the data. Currently, we do not use
> >> PostGIS as we do not do much geographical queries. Over time we could
> >> move in that direction to offer better geographical query support.
> >>
> >> Posting this (or a more detailed map) on the Postgresql web site
> >> sounds
> >> like a great idea. We could even allow people to add markers for their
> >> locations, and even enter more information about themselves to help
> >> postgresql users connect with each other. One potential opportunity is
> >> for users to quickly find consultants in their own area.
> >>
> >> How would we initiate this activity?
> >>
> >> Best wishes
> >>
> >> Claire
> >>
> >> On Oct 24, 2005, at 2:28 PM, Brent Wood wrote:
> >>
> >>> How about using Postgres/PostGIS & UMN mapserver for a fully Open
> >>> Source
> >>> software & Postgres based map?
> >>>
> >>> For a map like the one at
> >>> http://www.qgis.org/index.php?option=com_wrapper&Itemid=53
> >>>
> >>> perhaps on the Postgres web site?
> >>
> >>
> >> ---------------------------(end of
> >> broadcast)---------------------------
> >> TIP 6: explain analyze is your friend
> >
> > --
> > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

On Friday 28 October 2005 06:44, Arnulf Christl wrote:
> Yet another idea: Mediawiki (the
> Wikipedia software) is also right now introducing geometries to the Wiki
> database - obviously also using PostgreSQL/PostGIS. This would be
> another cool multiplier.. and there we also meet with Google again.

Wha? mediawiki is planning to use postgis with thier software? I'm currently
working with some folks on a working port of wikimedia to postgresql
(allowing things like transactions and full text searching all in the same
database). That would certainly seem to dovetail into this... you have any
links I could read up on the wikipedia/postgis effort on ?

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

On Fri, Oct 28, 2005 at 09:47:17PM -0400, Robert Treat wrote:
> On Friday 28 October 2005 06:44, Arnulf Christl wrote:
> > Yet another idea: Mediawiki (the
> > Wikipedia software) is also right now introducing geometries to the Wiki
> > database - obviously also using PostgreSQL/PostGIS. This would be
> > another cool multiplier.. and there we also meet with Google again.
>
> Wha? mediawiki is planning to use postgis with thier software? I'm currently
> working with some folks on a working port of wikimedia to postgresql
> (allowing things like transactions and full text searching all in the same
> database). That would certainly seem to dovetail into this... you have any
> links I could read up on the wikipedia/postgis effort on ?
>

There's nothing yet written down. There's some working code, and I'm
just improving it from "proof of concept" stage to pre-production level.
The code I'm working on is an extension to MediaWiki. It is independent
of the article storage. I'm sure storing everything in one DB would be
better from a design point of view, but it's easier for us to scale if
we keep things apart. Especially new features like these where we've no
idea about the performance impact.

If you're improving MediaWiki's Postgres support we'd of course be happy
to get your patches into the main code tree.

Regards,

JeLuF

Actually all of the mirrors (at least the official ones) work from the same
url (www.postgresql.org) so in theory they should all be able to work from
the same key. I've yet to test this theory, but I do think it would work.

Robert Treat

On Thursday 27 October 2005 13:21, Claire McLister wrote:
> Good point. This might actually be a problem. Google Maps API requires
> each server that is serving the map to be registered with Google, and
> send the corresponding key when making the Javascript request.
>
> Unless the mirrors can each send their own keys, this will not work.
>
> Claire
>
> On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
> > On Wednesday 26 October 2005 18:24, Claire McLister wrote:
> >> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
> >>> There has recently been a thread on the Postgres user list about a
> >>> web
> >>> based postgres user/developer map. Claire has built a Google map
> >>> based
> >>> system, getting locations from IP addresses.
> >>
> >> Just so people know, this map can be found at:
> >>
> >> http://www.zeesource.net/maps/map.do?group=456
> >
> > I'm going to loop in a few more people here :-), namely the pg web
> > team who
> > will probably be able to give pointers on site integration. One thing
> > to keep
> > in mind is that the postgresql website is statically mirrored onto a
> > number
> > of different servers, so any solution we come up with will ideally
> > allow
> > itself to that. I believe a google maps system can do this (we can
> > mirror the
> > javascript code and the location/data file on all mirrors and the
> > google map
> > will work with it as is), which is why I originally went with that
> > type of
> > solution.
> >
> > --
> > Robert Treat
> > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Where are we on this? Can we get it added to our web site? Can we have
usernames added to the map?

---------------------------------------------------------------------------

Arnulf Christl wrote:
> Claire McLister wrote:
> > Good point. This might actually be a problem. Google Maps API requires
> > each server that is serving the map to be registered with Google, and
> > send the corresponding key when making the Javascript request.
> >
> > Unless the mirrors can each send their own keys, this will not work.
> >
> > Claire
>
> Hi, more cross posting...
>
> Sounds like this task should be solved using WMS and WFS services.
> Google is cool but in order to foster both Open Source and standards
> (OGC) we would suggest to use e.g. MapServer as WMS to produce the maps
> and GeoServer as WFS to manage geomtries. Those OWS services could then
> be included in any OWS client, web interface, etc. Everything is there
> and ready to go, the effort to get it to run should be minimal.
>
> Our clients usually operate PostgreSQL databases with several million
> geometries - those 500 to 600 markers could be hosted on any
> antediluvian box and still be fast. You will know what to about
> mirroring, we would probably suggest to implement P2P - read Ward
> Cunninghams ideas int he keynote at the Wikimania conference this summer...
>
> We have done the user mmapping Mapbender users with tooltips, direct
> link to the website, etc. You can have a look at it on the project
> homepage http://www.mapbender.org
> Its done Wiki-style so that users can enter their own position (use the
> blue flag) or remove or edit any position (use the i-button). No user
> accounts yet but security and authentication is in place and have just
> not yet been necessary (still waiting for spatial spam...)
>
> We will spread word about spatial data management using
> PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
> http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
> Frankfurt/Main, Germany.
>
> This idea is on short notice but i would be really very excited if i
> could show the map there! We suggest the following alterantive actions:
>
> - It should be easy to add a geometry_column to the existing PostgreSQL
> database which alredy has the positions. Add a GeoServer WFS to access
> the geomtry and a MapServer for WMS display.
> - Alternatively send Paolo or us or both the geo-positions and we add
> them to our existing OWS infrastructure (that will takt a few hours of
> work only).
>
> Beause there is not so much time until the conference this would just be
> be a prototype which should in the long run move to the PostgreSQL or
> PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
> Wikipedia software) is also right now introducing geometries to the Wiki
> database - obviously also using PostgreSQL/PostGIS. This would be
> another cool multiplier.. and there we also meet with Google again.
>
> Best, Arnulf.
>
>
> > On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
> >
> >> On Wednesday 26 October 2005 18:24, Claire McLister wrote:
> >>
> >>> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
> >>>
> >>>> There has recently been a thread on the Postgres user list about a web
> >>>> based postgres user/developer map. Claire has built a Google map based
> >>>> system, getting locations from IP addresses.
> >>>
> >>>
> >>> Just so people know, this map can be found at:
> >>>
> >>> http://www.zeesource.net/maps/map.do?group=456
> >>>
> >>
> >> I'm going to loop in a few more people here :-), namely the pg web
> >> team who
> >> will probably be able to give pointers on site integration. One thing
> >> to keep
> >> in mind is that the postgresql website is statically mirrored onto a
> >> number
> >> of different servers, so any solution we come up with will ideally allow
> >> itself to that. I believe a google maps system can do this (we can
> >> mirror the
> >> javascript code and the location/data file on all mirrors and the
> >> google map
> >> will work with it as is), which is why I originally went with that
> >> type of
> >> solution.
> >>
> >> --
> >> Robert Treat
> >> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> >
> >
> > _______________________________________________
> > Freegis-list mailing list
> > Freegis-list(at)intevation(dot)de
> > https://intevation.de/mailman/listinfo/freegis-list
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Bruce Momjian wrote:
> Where are we on this? Can we get it added to our web site? Can we have
> usernames added to the map?

Hi,
yes, both can be done. But our server and connectivity are sort of slow,
so I was talking to some people whether they could host the services.
This will take a few more days. Anybody interested in operating a
spatial data infrastructure on stable servers (preferrably FreeBSD or
some Linux) with good connectivity feel free to contact us.

Additionally we got lost in a few technical discussions about whether to
implement the full scale service oriented standardized I-can-add-myself
version using PostgreSQL with PostGIS (which I would really like to see
as it promotes using PG as spatial data backend and also gives us GIS
guys a chance to show off cool technology).

Claire favored an easy-to-use google-maps approach which would mean less
effort getting to run (they have it all up and running) but less
compatibility and unsolved copyright issues regarding the background maps.

Give us a few more days, by the weekend I will post a link so that
people can have a look at it. The link will ship with a list of which
software is being used and how it is configured. Ideally someone "near"
the PostgreSQL homepage could operate the service (we GIS folks never
stop considering spatial proximity).

What has to be done anyway is collect the coordinates of the users. It
would be nice to not start off with a blank map. We can provide some 20
users in Germany (most of them spatial). Either the name of a city or
the decimal degree coordinates of the position will do.

Best, Arnulf.

> Arnulf Christl wrote:
>
>>Claire McLister wrote:
>>
>>>Good point. This might actually be a problem. Google Maps API requires
>>>each server that is serving the map to be registered with Google, and
>>>send the corresponding key when making the Javascript request.
>>>
>>>Unless the mirrors can each send their own keys, this will not work.
>>>
>>>Claire
>>
>>Hi, more cross posting...
>>
>>Sounds like this task should be solved using WMS and WFS services.
>>Google is cool but in order to foster both Open Source and standards
>>(OGC) we would suggest to use e.g. MapServer as WMS to produce the maps
>>and GeoServer as WFS to manage geomtries. Those OWS services could then
>>be included in any OWS client, web interface, etc. Everything is there
>>and ready to go, the effort to get it to run should be minimal.
>>
>>Our clients usually operate PostgreSQL databases with several million
>>geometries - those 500 to 600 markers could be hosted on any
>>antediluvian box and still be fast. You will know what to about
>>mirroring, we would probably suggest to implement P2P - read Ward
>>Cunninghams ideas int he keynote at the Wikimania conference this summer...
>>
>>We have done the user mmapping Mapbender users with tooltips, direct
>>link to the website, etc. You can have a look at it on the project
>>homepage http://www.mapbender.org
>>Its done Wiki-style so that users can enter their own position (use the
>>blue flag) or remove or edit any position (use the i-button). No user
>>accounts yet but security and authentication is in place and have just
>>not yet been necessary (still waiting for spatial spam...)
>>
>>We will spread word about spatial data management using
>>PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
>>http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
>>Frankfurt/Main, Germany.
>>
>>This idea is on short notice but i would be really very excited if i
>>could show the map there! We suggest the following alterantive actions:
>>
>>- It should be easy to add a geometry_column to the existing PostgreSQL
>>database which alredy has the positions. Add a GeoServer WFS to access
>>the geomtry and a MapServer for WMS display.
>>- Alternatively send Paolo or us or both the geo-positions and we add
>>them to our existing OWS infrastructure (that will takt a few hours of
>>work only).
>>
>>Beause there is not so much time until the conference this would just be
>>be a prototype which should in the long run move to the PostgreSQL or
>>PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
>>Wikipedia software) is also right now introducing geometries to the Wiki
>>database - obviously also using PostgreSQL/PostGIS. This would be
>>another cool multiplier.. and there we also meet with Google again.
>>
>>Best, Arnulf.
>>
>>
>>
>>>On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
>>>
>>>
>>>>On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>>>>
>>>>
>>>>>On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>>>>
>>>>>
>>>>>>There has recently been a thread on the Postgres user list about a web
>>>>>>based postgres user/developer map. Claire has built a Google map based
>>>>>>system, getting locations from IP addresses.
>>>>>
>>>>>
>>>>>Just so people know, this map can be found at:
>>>>>
>>>>> http://www.zeesource.net/maps/map.do?group=456
>>>>>
>>>>
>>>>I'm going to loop in a few more people here :-), namely the pg web
>>>>team who
>>>>will probably be able to give pointers on site integration. One thing
>>>>to keep
>>>>in mind is that the postgresql website is statically mirrored onto a
>>>>number
>>>>of different servers, so any solution we come up with will ideally allow
>>>>itself to that. I believe a google maps system can do this (we can
>>>>mirror the
>>>>javascript code and the location/data file on all mirrors and the
>>>>google map
>>>>will work with it as is), which is why I originally went with that
>>>>type of
>>>>solution.
>>>>
>>>>--
>>>>Robert Treat
>>>>Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>>>
>>>
>>>_______________________________________________
>>>Freegis-list mailing list
>>>Freegis-list(at)intevation(dot)de
>>>https://intevation.de/mailman/listinfo/freegis-list
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>
>

please let us know if we can be useful. what we can bring in is a nice yet
simple interface by Armin Burger we're helping to develop. See e.g.:
http://www.fauna.regione.toscana.it/pmapper/
All the best.
pc

At 08:30, mercoledì 07 dicembre 2005, Arnulf Christl has probably written:
> Bruce Momjian wrote:
> > Where are we on this? Can we get it added to our web site? Can we have
> > usernames added to the map?
>
...
--
Paolo Cavallini
email+jabber: cavallini(at)faunalia(dot)it
www.faunalia.it
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy Tel: (+39)348-3801953

On Wed, 2005-12-07 at 02:30, Arnulf Christl wrote:
> Bruce Momjian wrote:
> > Where are we on this? Can we get it added to our web site? Can we have
> > usernames added to the map?
>
> Hi,
> yes, both can be done. But our server and connectivity are sort of slow,
> so I was talking to some people whether they could host the services.
> This will take a few more days. Anybody interested in operating a
> spatial data infrastructure on stable servers (preferrably FreeBSD or
> some Linux) with good connectivity feel free to contact us.
>

I'm fairly certain we can drum up some server space once we're ready to
host this for the postgresql site. For now even slow connectivity is
probably fine as it will only be a few people looking at it until we
finalize what we really need.

> Additionally we got lost in a few technical discussions about whether to
> implement the full scale service oriented standardized I-can-add-myself
> version using PostgreSQL with PostGIS (which I would really like to see
> as it promotes using PG as spatial data backend and also gives us GIS
> guys a chance to show off cool technology).
>

As a side note, we need folks to help out with the elephant database
monitoring project. That seems like an ideal project to help show off
postgis. http://pgfoundry.org/projects/wilddb/

> Claire favored an easy-to-use google-maps approach which would mean less
> effort getting to run (they have it all up and running) but less
> compatibility and unsolved copyright issues regarding the background maps.
>

Hmm...I thought this was all something that could be relatively easy to
solve. I think the main problem here was that I needed to test whether
the maps mirroring would work in the main site; I believe it would, but
this should probably be confirmed, and I haven't had time to get back to
it. The other side being that showing of postgis does have a nice
political upside that seems worth following up on.

> Give us a few more days, by the weekend I will post a link so that
> people can have a look at it. The link will ship with a list of which
> software is being used and how it is configured. Ideally someone "near"
> the PostgreSQL homepage could operate the service (we GIS folks never
> stop considering spatial proximity).

Yes, the plan would be to integrate it fully into the postgresql web
infrastructure. We just need to figure out what that will take.

>
> What has to be done anyway is collect the coordinates of the users. It
> would be nice to not start off with a blank map. We can provide some 20
> users in Germany (most of them spatial). Either the name of a city or
> the decimal degree coordinates of the position will do.

I see this as sort of a secondary thing, but I already have coordinates
for most of the people listed on our developers page, so we can always
start with that. I'm not against the idea of plotting other points
though; we could have points for support companies, points for mailing
list users, do some type of frapper style sign up; but that's secondary.
The first step is figuring setting up a system to display the
coordinates, then we can add more knobs on how to get the coordinates.

>
> Best, Arnulf.
>
> > Arnulf Christl wrote:
> >
> >>Claire McLister wrote:
> >>
> >>>Good point. This might actually be a problem. Google Maps API requires
> >>>each server that is serving the map to be registered with Google, and
> >>>send the corresponding key when making the Javascript request.
> >>>
> >>>Unless the mirrors can each send their own keys, this will not work.
> >>>
> >>>Claire
> >>
> >>Hi, more cross posting...
> >>
> >>Sounds like this task should be solved using WMS and WFS services.
> >>Google is cool but in order to foster both Open Source and standards
> >>(OGC) we would suggest to use e.g. MapServer as WMS to produce the maps
> >>and GeoServer as WFS to manage geomtries. Those OWS services could then
> >>be included in any OWS client, web interface, etc. Everything is there
> >>and ready to go, the effort to get it to run should be minimal.
> >>
> >>Our clients usually operate PostgreSQL databases with several million
> >>geometries - those 500 to 600 markers could be hosted on any
> >>antediluvian box and still be fast. You will know what to about
> >>mirroring, we would probably suggest to implement P2P - read Ward
> >>Cunninghams ideas int he keynote at the Wikimania conference this summer...
> >>
> >>We have done the user mmapping Mapbender users with tooltips, direct
> >>link to the website, etc. You can have a look at it on the project
> >>homepage http://www.mapbender.org
> >>Its done Wiki-style so that users can enter their own position (use the
> >>blue flag) or remove or edit any position (use the i-button). No user
> >>accounts yet but security and authentication is in place and have just
> >>not yet been necessary (still waiting for spatial spam...)
> >>
> >>We will spread word about spatial data management using
> >>PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
> >>http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
> >>Frankfurt/Main, Germany.
> >>
> >>This idea is on short notice but i would be really very excited if i
> >>could show the map there! We suggest the following alterantive actions:
> >>
> >>- It should be easy to add a geometry_column to the existing PostgreSQL
> >>database which alredy has the positions. Add a GeoServer WFS to access
> >>the geomtry and a MapServer for WMS display.
> >>- Alternatively send Paolo or us or both the geo-positions and we add
> >>them to our existing OWS infrastructure (that will takt a few hours of
> >>work only).
> >>
> >>Beause there is not so much time until the conference this would just be
> >>be a prototype which should in the long run move to the PostgreSQL or
> >>PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
> >>Wikipedia software) is also right now introducing geometries to the Wiki
> >>database - obviously also using PostgreSQL/PostGIS. This would be
> >>another cool multiplier.. and there we also meet with Google again.
> >>
> >>Best, Arnulf.
> >>
> >>
> >>
> >>>On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
> >>>
> >>>
> >>>>On Wednesday 26 October 2005 18:24, Claire McLister wrote:
> >>>>
> >>>>
> >>>>>On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
> >>>>>
> >>>>>
> >>>>>>There has recently been a thread on the Postgres user list about a web
> >>>>>>based postgres user/developer map. Claire has built a Google map based
> >>>>>>system, getting locations from IP addresses.
> >>>>>
> >>>>>
> >>>>>Just so people know, this map can be found at:
> >>>>>
> >>>>> http://www.zeesource.net/maps/map.do?group=456
> >>>>>
> >>>>
> >>>>I'm going to loop in a few more people here :-), namely the pg web
> >>>>team who
> >>>>will probably be able to give pointers on site integration. One thing
> >>>>to keep
> >>>>in mind is that the postgresql website is statically mirrored onto a
> >>>>number
> >>>>of different servers, so any solution we come up with will ideally allow
> >>>>itself to that. I believe a google maps system can do this (we can
> >>>>mirror the
> >>>>javascript code and the location/data file on all mirrors and the
> >>>>google map
> >>>>will work with it as is), which is why I originally went with that
> >>>>type of
> >>>>solution.
> >>>>
> >>>>--
> >>>>Robert Treat
> >>>>Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> >>>
> >>>
> >>>_______________________________________________
> >>>Freegis-list mailing list
> >>>Freegis-list(at)intevation(dot)de
> >>>https://intevation.de/mailman/listinfo/freegis-list
> >>
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

I like the idea that people can add themselves, but I also liked the
dynamic ability of seeing all email posters from the last few months.
Can we have both?

---------------------------------------------------------------------------

Robert Treat wrote:
> On Wed, 2005-12-07 at 02:30, Arnulf Christl wrote:
> > Bruce Momjian wrote:
> > > Where are we on this? Can we get it added to our web site? Can we have
> > > usernames added to the map?
> >
> > Hi,
> > yes, both can be done. But our server and connectivity are sort of slow,
> > so I was talking to some people whether they could host the services.
> > This will take a few more days. Anybody interested in operating a
> > spatial data infrastructure on stable servers (preferrably FreeBSD or
> > some Linux) with good connectivity feel free to contact us.
> >
>
> I'm fairly certain we can drum up some server space once we're ready to
> host this for the postgresql site. For now even slow connectivity is
> probably fine as it will only be a few people looking at it until we
> finalize what we really need.
>
> > Additionally we got lost in a few technical discussions about whether to
> > implement the full scale service oriented standardized I-can-add-myself
> > version using PostgreSQL with PostGIS (which I would really like to see
> > as it promotes using PG as spatial data backend and also gives us GIS
> > guys a chance to show off cool technology).
> >
>
> As a side note, we need folks to help out with the elephant database
> monitoring project. That seems like an ideal project to help show off
> postgis. http://pgfoundry.org/projects/wilddb/
>
> > Claire favored an easy-to-use google-maps approach which would mean less
> > effort getting to run (they have it all up and running) but less
> > compatibility and unsolved copyright issues regarding the background maps.
> >
>
> Hmm...I thought this was all something that could be relatively easy to
> solve. I think the main problem here was that I needed to test whether
> the maps mirroring would work in the main site; I believe it would, but
> this should probably be confirmed, and I haven't had time to get back to
> it. The other side being that showing of postgis does have a nice
> political upside that seems worth following up on.
>
> > Give us a few more days, by the weekend I will post a link so that
> > people can have a look at it. The link will ship with a list of which
> > software is being used and how it is configured. Ideally someone "near"
> > the PostgreSQL homepage could operate the service (we GIS folks never
> > stop considering spatial proximity).
>
> Yes, the plan would be to integrate it fully into the postgresql web
> infrastructure. We just need to figure out what that will take.
>
> >
> > What has to be done anyway is collect the coordinates of the users. It
> > would be nice to not start off with a blank map. We can provide some 20
> > users in Germany (most of them spatial). Either the name of a city or
> > the decimal degree coordinates of the position will do.
>
> I see this as sort of a secondary thing, but I already have coordinates
> for most of the people listed on our developers page, so we can always
> start with that. I'm not against the idea of plotting other points
> though; we could have points for support companies, points for mailing
> list users, do some type of frapper style sign up; but that's secondary.
> The first step is figuring setting up a system to display the
> coordinates, then we can add more knobs on how to get the coordinates.
>
> >
> > Best, Arnulf.
> >
> > > Arnulf Christl wrote:
> > >
> > >>Claire McLister wrote:
> > >>
> > >>>Good point. This might actually be a problem. Google Maps API requires
> > >>>each server that is serving the map to be registered with Google, and
> > >>>send the corresponding key when making the Javascript request.
> > >>>
> > >>>Unless the mirrors can each send their own keys, this will not work.
> > >>>
> > >>>Claire
> > >>
> > >>Hi, more cross posting...
> > >>
> > >>Sounds like this task should be solved using WMS and WFS services.
> > >>Google is cool but in order to foster both Open Source and standards
> > >>(OGC) we would suggest to use e.g. MapServer as WMS to produce the maps
> > >>and GeoServer as WFS to manage geomtries. Those OWS services could then
> > >>be included in any OWS client, web interface, etc. Everything is there
> > >>and ready to go, the effort to get it to run should be minimal.
> > >>
> > >>Our clients usually operate PostgreSQL databases with several million
> > >>geometries - those 500 to 600 markers could be hosted on any
> > >>antediluvian box and still be fast. You will know what to about
> > >>mirroring, we would probably suggest to implement P2P - read Ward
> > >>Cunninghams ideas int he keynote at the Wikimania conference this summer...
> > >>
> > >>We have done the user mmapping Mapbender users with tooltips, direct
> > >>link to the website, etc. You can have a look at it on the project
> > >>homepage http://www.mapbender.org
> > >>Its done Wiki-style so that users can enter their own position (use the
> > >>blue flag) or remove or edit any position (use the i-button). No user
> > >>accounts yet but security and authentication is in place and have just
> > >>not yet been necessary (still waiting for spatial spam...)
> > >>
> > >>We will spread word about spatial data management using
> > >>PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
> > >>http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
> > >>Frankfurt/Main, Germany.
> > >>
> > >>This idea is on short notice but i would be really very excited if i
> > >>could show the map there! We suggest the following alterantive actions:
> > >>
> > >>- It should be easy to add a geometry_column to the existing PostgreSQL
> > >>database which alredy has the positions. Add a GeoServer WFS to access
> > >>the geomtry and a MapServer for WMS display.
> > >>- Alternatively send Paolo or us or both the geo-positions and we add
> > >>them to our existing OWS infrastructure (that will takt a few hours of
> > >>work only).
> > >>
> > >>Beause there is not so much time until the conference this would just be
> > >>be a prototype which should in the long run move to the PostgreSQL or
> > >>PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
> > >>Wikipedia software) is also right now introducing geometries to the Wiki
> > >>database - obviously also using PostgreSQL/PostGIS. This would be
> > >>another cool multiplier.. and there we also meet with Google again.
> > >>
> > >>Best, Arnulf.
> > >>
> > >>
> > >>
> > >>>On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
> > >>>
> > >>>
> > >>>>On Wednesday 26 October 2005 18:24, Claire McLister wrote:
> > >>>>
> > >>>>
> > >>>>>On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
> > >>>>>
> > >>>>>
> > >>>>>>There has recently been a thread on the Postgres user list about a web
> > >>>>>>based postgres user/developer map. Claire has built a Google map based
> > >>>>>>system, getting locations from IP addresses.
> > >>>>>
> > >>>>>
> > >>>>>Just so people know, this map can be found at:
> > >>>>>
> > >>>>> http://www.zeesource.net/maps/map.do?group=456
> > >>>>>
> > >>>>
> > >>>>I'm going to loop in a few more people here :-), namely the pg web
> > >>>>team who
> > >>>>will probably be able to give pointers on site integration. One thing
> > >>>>to keep
> > >>>>in mind is that the postgresql website is statically mirrored onto a
> > >>>>number
> > >>>>of different servers, so any solution we come up with will ideally allow
> > >>>>itself to that. I believe a google maps system can do this (we can
> > >>>>mirror the
> > >>>>javascript code and the location/data file on all mirrors and the
> > >>>>google map
> > >>>>will work with it as is), which is why I originally went with that
> > >>>>type of
> > >>>>solution.
> > >>>>
> > >>>>--
> > >>>>Robert Treat
> > >>>>Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
> > >>>
> > >>>
> > >>>_______________________________________________
> > >>>Freegis-list mailing list
> > >>>Freegis-list(at)intevation(dot)de
> > >>>https://intevation.de/mailman/listinfo/freegis-list
> > >>
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Bruce Momjian schrieb:
> I like the idea that people can add themselves, but I also liked the
> dynamic ability of seeing all email posters from the last few months.
> Can we have both?
>
Well but who has a GPS-Header in his/her MUA?

Tino Wildenhain wrote:
> Bruce Momjian schrieb:
> > I like the idea that people can add themselves, but I also liked the
> > dynamic ability of seeing all email posters from the last few months.
> > Can we have both?
> >
> Well but who has a GPS-Header in his/her MUA?

Well, I know someone did such a map by using the coordinates of their IP
address. It wasn't perfect, but it was close for lots of people.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

On Wed, 2005-12-07 at 10:27, Bruce Momjian wrote:
> Tino Wildenhain wrote:
> > Bruce Momjian schrieb:
> > > I like the idea that people can add themselves, but I also liked the
> > > dynamic ability of seeing all email posters from the last few months.
> > > Can we have both?
> > >
> > Well but who has a GPS-Header in his/her MUA?
>
> Well, I know someone did such a map by using the coordinates of their IP
> address. It wasn't perfect, but it was close for lots of people.
>

Yeah I think that's how we would do it. Could probably also do the same
for the website traffic too. Point being that we need to get the
infrastructure in place to do the mapping and then we should be able to
do several different schemes for getting input.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Hi All,

The only objection that I've heard to using Google maps is there
are some 'copyright issues'. AFAIK, Google Maps come with a fairly
liberal license. As long as you use it in a web application that is
freely accessible to users, you are within their terms of use. The
problem with other approaches was to get wide ranging map images.

While it would be nice to showcase some of the other technologies,
maybe we can get started on the map and move towards the showcase as
the technologies and infrastructure becomes available.

To kick things off, I have created a map for Postgresql users at:

http://www.zeesource.net/maps/map.do?group=1122

Go ahead and add yourself to the map with the password 'pgsql'. You
can add entries to the map either by specifying a location
information (address (US), city, state, and country) or just double
click on a location.

Use the color coding of Green -> Consultant, Red -> User, and
Yellow -> developer.

With this map, at least we'll start to collect the location
information in one place. We do have an 'Export CSV' feature, so we
can export this data to other maps and infrastructure as desired.

Let me know if you have any questions or comments.

Claire

On Dec 7, 2005, at 6:35 AM, Robert Treat wrote:

> On Wed, 2005-12-07 at 02:30, Arnulf Christl wrote:
>> Bruce Momjian wrote:
>>> Where are we on this? Can we get it added to our web site? Can
>>> we have
>>> usernames added to the map?
>>
>> Hi,
>> yes, both can be done. But our server and connectivity are sort of
>> slow,
>> so I was talking to some people whether they could host the services.
>> This will take a few more days. Anybody interested in operating a
>> spatial data infrastructure on stable servers (preferrably FreeBSD or
>> some Linux) with good connectivity feel free to contact us.
>>
>
> I'm fairly certain we can drum up some server space once we're
> ready to
> host this for the postgresql site. For now even slow connectivity is
> probably fine as it will only be a few people looking at it until we
> finalize what we really need.
>
>> Additionally we got lost in a few technical discussions about
>> whether to
>> implement the full scale service oriented standardized I-can-add-
>> myself
>> version using PostgreSQL with PostGIS (which I would really like
>> to see
>> as it promotes using PG as spatial data backend and also gives us GIS
>> guys a chance to show off cool technology).
>>
>
> As a side note, we need folks to help out with the elephant database
> monitoring project. That seems like an ideal project to help show off
> postgis. http://pgfoundry.org/projects/wilddb/
>
>> Claire favored an easy-to-use google-maps approach which would
>> mean less
>> effort getting to run (they have it all up and running) but less
>> compatibility and unsolved copyright issues regarding the
>> background maps.
>>
>
> Hmm...I thought this was all something that could be relatively
> easy to
> solve. I think the main problem here was that I needed to test whether
> the maps mirroring would work in the main site; I believe it would,
> but
> this should probably be confirmed, and I haven't had time to get
> back to
> it. The other side being that showing of postgis does have a nice
> political upside that seems worth following up on.
>
>> Give us a few more days, by the weekend I will post a link so that
>> people can have a look at it. The link will ship with a list of which
>> software is being used and how it is configured. Ideally someone
>> "near"
>> the PostgreSQL homepage could operate the service (we GIS folks never
>> stop considering spatial proximity).
>
> Yes, the plan would be to integrate it fully into the postgresql web
> infrastructure. We just need to figure out what that will take.
>
>>
>> What has to be done anyway is collect the coordinates of the
>> users. It
>> would be nice to not start off with a blank map. We can provide
>> some 20
>> users in Germany (most of them spatial). Either the name of a city or
>> the decimal degree coordinates of the position will do.
>
> I see this as sort of a secondary thing, but I already have
> coordinates
> for most of the people listed on our developers page, so we can always
> start with that. I'm not against the idea of plotting other points
> though; we could have points for support companies, points for mailing
> list users, do some type of frapper style sign up; but that's
> secondary.
> The first step is figuring setting up a system to display the
> coordinates, then we can add more knobs on how to get the coordinates.
>
>>
>> Best, Arnulf.
>>
>>> Arnulf Christl wrote:
>>>
>>>> Claire McLister wrote:
>>>>
>>>>> Good point. This might actually be a problem. Google Maps API
>>>>> requires
>>>>> each server that is serving the map to be registered with
>>>>> Google, and
>>>>> send the corresponding key when making the Javascript request.
>>>>>
>>>>> Unless the mirrors can each send their own keys, this will not
>>>>> work.
>>>>>
>>>>> Claire
>>>>
>>>> Hi, more cross posting...
>>>>
>>>> Sounds like this task should be solved using WMS and WFS services.
>>>> Google is cool but in order to foster both Open Source and
>>>> standards
>>>> (OGC) we would suggest to use e.g. MapServer as WMS to produce
>>>> the maps
>>>> and GeoServer as WFS to manage geomtries. Those OWS services
>>>> could then
>>>> be included in any OWS client, web interface, etc. Everything is
>>>> there
>>>> and ready to go, the effort to get it to run should be minimal.
>>>>
>>>> Our clients usually operate PostgreSQL databases with several
>>>> million
>>>> geometries - those 500 to 600 markers could be hosted on any
>>>> antediluvian box and still be fast. You will know what to about
>>>> mirroring, we would probably suggest to implement P2P - read Ward
>>>> Cunninghams ideas int he keynote at the Wikimania conference
>>>> this summer...
>>>>
>>>> We have done the user mmapping Mapbender users with tooltips,
>>>> direct
>>>> link to the website, etc. You can have a look at it on the project
>>>> homepage http://www.mapbender.org
>>>> Its done Wiki-style so that users can enter their own position
>>>> (use the
>>>> blue flag) or remove or edit any position (use the i-button). No
>>>> user
>>>> accounts yet but security and authentication is in place and
>>>> have just
>>>> not yet been necessary (still waiting for spatial spam...)
>>>>
>>>> We will spread word about spatial data management using
>>>> PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
>>>> http://www.opendbcon.net (database fundamentals) on Nov. 8. and
>>>> 9. in
>>>> Frankfurt/Main, Germany.
>>>>
>>>> This idea is on short notice but i would be really very excited
>>>> if i
>>>> could show the map there! We suggest the following alterantive
>>>> actions:
>>>>
>>>> - It should be easy to add a geometry_column to the existing
>>>> PostgreSQL
>>>> database which alredy has the positions. Add a GeoServer WFS to
>>>> access
>>>> the geomtry and a MapServer for WMS display.
>>>> - Alternatively send Paolo or us or both the geo-positions and
>>>> we add
>>>> them to our existing OWS infrastructure (that will takt a few
>>>> hours of
>>>> work only).
>>>>
>>>> Beause there is not so much time until the conference this would
>>>> just be
>>>> be a prototype which should in the long run move to the
>>>> PostgreSQL or
>>>> PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
>>>> Wikipedia software) is also right now introducing geometries to
>>>> the Wiki
>>>> database - obviously also using PostgreSQL/PostGIS. This would be
>>>> another cool multiplier.. and there we also meet with Google again.
>>>>
>>>> Best, Arnulf.
>>>>
>>>>
>>>>
>>>>> On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
>>>>>
>>>>>
>>>>>> On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>>>>>>
>>>>>>
>>>>>>> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>>>>>>
>>>>>>>
>>>>>>>> There has recently been a thread on the Postgres user list
>>>>>>>> about a web
>>>>>>>> based postgres user/developer map. Claire has built a Google
>>>>>>>> map based
>>>>>>>> system, getting locations from IP addresses.
>>>>>>>
>>>>>>>
>>>>>>> Just so people know, this map can be found at:
>>>>>>>
>>>>>>> http://www.zeesource.net/maps/map.do?group=456
>>>>>>>
>>>>>>
>>>>>> I'm going to loop in a few more people here :-), namely the pg
>>>>>> web
>>>>>> team who
>>>>>> will probably be able to give pointers on site integration.
>>>>>> One thing
>>>>>> to keep
>>>>>> in mind is that the postgresql website is statically mirrored
>>>>>> onto a
>>>>>> number
>>>>>> of different servers, so any solution we come up with will
>>>>>> ideally allow
>>>>>> itself to that. I believe a google maps system can do this (we
>>>>>> can
>>>>>> mirror the
>>>>>> javascript code and the location/data file on all mirrors and the
>>>>>> google map
>>>>>> will work with it as is), which is why I originally went with
>>>>>> that
>>>>>> type of
>>>>>> solution.
>>>>>>
>>>>>> --
>>>>>> Robert Treat
>>>>>> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Freegis-list mailing list
>>>>> Freegis-list(at)intevation(dot)de
>>>>> https://intevation.de/mailman/listinfo/freegis-list
>>>>
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>

Yes, we do have an 'IP Map' capability to take the originating IP
address of the email and try to map its location. While not always
accurate, it does give a general sense of where the emails are coming
from, so helps in understanding the geographical reach.

We mapped emails for messages to the pgsql-general list a while ago.
The resulting map is at:

http://www.zeesource.net/maps/map.do?group=456

We were waiting for someone from the pgsql-www team to tell us if
they want to embed such maps on the Postgtresql.org web site.

Claire

On Dec 7, 2005, at 7:48 AM, Robert Treat wrote:

> On Wed, 2005-12-07 at 10:27, Bruce Momjian wrote:
>> Tino Wildenhain wrote:
>>> Bruce Momjian schrieb:
>>>> I like the idea that people can add themselves, but I also liked
>>>> the
>>>> dynamic ability of seeing all email posters from the last few
>>>> months.
>>>> Can we have both?
>>>>
>>> Well but who has a GPS-Header in his/her MUA?
>>
>> Well, I know someone did such a map by using the coordinates of
>> their IP
>> address. It wasn't perfect, but it was close for lots of people.
>>
>
> Yeah I think that's how we would do it. Could probably also do the
> same
> for the website traffic too. Point being that we need to get the
> infrastructure in place to do the mapping and then we should be
> able to
> do several different schemes for getting input.
>
>
> Robert Treat
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>

Claire McLister wrote:
> Yes, we do have an 'IP Map' capability to take the originating IP
> address of the email and try to map its location. While not always
> accurate, it does give a general sense of where the emails are coming
> from, so helps in understanding the geographical reach.
>
> We mapped emails for messages to the pgsql-general list a while ago.
> The resulting map is at:
>
> http://www.zeesource.net/maps/map.do?group=456
>
> We were waiting for someone from the pgsql-www team to tell us if
> they want to embed such maps on the Postgtresql.org web site.

Yes, very nice. Can we have user names added to that, if they appeared
in the email?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Thanks.

Some people raised privacy issues, so we try to give an indication of
the email address without giving out too much more. We also do not
store any other information from the email.

I think the concern was combining location information with other
information. So, we are unable to add names with the entries :-(

Claire

On Dec 7, 2005, at 9:20 AM, Bruce Momjian wrote:

> Claire McLister wrote:
>> Yes, we do have an 'IP Map' capability to take the originating IP
>> address of the email and try to map its location. While not always
>> accurate, it does give a general sense of where the emails are coming
>> from, so helps in understanding the geographical reach.
>>
>> We mapped emails for messages to the pgsql-general list a while ago.
>> The resulting map is at:
>>
>> http://www.zeesource.net/maps/map.do?group=456
>>
>> We were waiting for someone from the pgsql-www team to tell us if
>> they want to embed such maps on the Postgtresql.org web site.
>
> Yes, very nice. Can we have user names added to that, if they
> appeared
> in the email?
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square,
> Pennsylvania 19073
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

Claire McLister wrote:
> Thanks.
>
> Some people raised privacy issues, so we try to give an indication of
> the email address without giving out too much more. We also do not
> store any other information from the email.
>
> I think the concern was combining location information with other
> information. So, we are unable to add names with the entries :-(

If they posted to a public list, I don't see any privacy issues with
showing their name. We could allow some to opt-out, but we don't even
offer that feature with our email archives, so I don't even see the
point of that. Finding the location of the IP address is also public,
so I don't see the issue here.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Technically there is no privacy issue, as all the information is
indeed public. We did receive one threat (not from anyone on these
email list, but another list) to damage our servers so I think we
have to be careful.

Allowing a simple opt-out should solve this issue.

So, would you like to see another map of postings to pgsql-general?

Claire

On Dec 7, 2005, at 9:31 AM, Bruce Momjian wrote:
>
> If they posted to a public list, I don't see any privacy issues with
> showing their name. We could allow some to opt-out, but we don't even
> offer that feature with our email archives, so I don't even see the
> point of that. Finding the location of the IP address is also public,
> so I don't see the issue here.

Claire McLister wrote:
> Technically there is no privacy issue, as all the information is
> indeed public. We did receive one threat (not from anyone on these
> email list, but another list) to damage our servers so I think we
> have to be careful.
>
> Allowing a simple opt-out should solve this issue.
>
> So, would you like to see another map of postings to pgsql-general?

Yes.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Claire McLister wrote:
> Hi All,
>
> The only objection that I've heard to using Google maps is there are
> some 'copyright issues'. AFAIK, Google Maps come with a fairly liberal
> license. As long as you use it in a web application that is freely
> accessible to users, you are within their terms of use. The problem
> with other approaches was to get wide ranging map images.
>
> While it would be nice to showcase some of the other technologies,
> maybe we can get started on the map and move towards the showcase as
> the technologies and infrastructure becomes available.
>
> To kick things off, I have created a map for Postgresql users at:
>
> http://www.zeesource.net/maps/map.do?group=1122
>
> Go ahead and add yourself to the map with the password 'pgsql'. You
> can add entries to the map either by specifying a location information
> (address (US), city, state, and country) or just double click on a
> location.
>
> Use the color coding of Green -> Consultant, Red -> User, and Yellow
> -> developer.

does developer mean postgresql developer( contributes code to the
postgresql code base), or any developer that utilizes postgresql in
their applications?

Developer means postgresql developer (contributes code to postresql
code base), otherwise the person is a 'User'.

I've changed the legend to say 'PG Developer' to make this clearer.

Let me know if you have alternate legend title suggestions.

On Dec 7, 2005, at 1:46 PM, Reid Thompson wrote:

>
> does developer mean postgresql developer( contributes code to the
> postgresql code base), or any developer that utilizes postgresql in
> their applications?

Can anybody tell me what is the member passord ?

Ezequias

Claire McLister wrote:

> Arnulf,
>
> Thanks for your message. I looked at the mapbender site, and it looks
> like it has the basic functions except the password protection, which
> you will probably need at some point:-) The performance from here
> (California) was slow, and the map image did not look as good as
> Google's. I suppose we have better map images available?
>
> I could not find Cunninghams talk on P2P style wiki's, but seems to me
> that it would be too much work for a simple web page. Ideally, we'd
> just want to have a static map with possibly Javascript popups. That
> way, the performance can be good and the web site doesn't become that
> onerous that the pg www group kicks us out.
>
> So, a question to you and Palo: Can you generate such static map
> (along with Javascript code) from Mapserver?
>
> Claire
>
> On Oct 28, 2005, at 3:44 AM, Arnulf Christl wrote:
>
>> Claire McLister wrote:
>>
>>> Good point. This might actually be a problem. Google Maps API
>>> requires each server that is serving the map to be registered with
>>> Google, and send the corresponding key when making the Javascript
>>> request.
>>> Unless the mirrors can each send their own keys, this will not work.
>>> Claire
>>
>>
>> Hi, more cross posting...
>>
>> Sounds like this task should be solved using WMS and WFS services.
>> Google is cool but in order to foster both Open Source and standards
>> (OGC) we would suggest to use e.g. MapServer as WMS to produce the
>> maps and GeoServer as WFS to manage geomtries. Those OWS services
>> could then be included in any OWS client, web interface, etc.
>> Everything is there and ready to go, the effort to get it to run
>> should be minimal.
>>
>> Our clients usually operate PostgreSQL databases with several million
>> geometries - those 500 to 600 markers could be hosted on any
>> antediluvian box and still be fast. You will know what to about
>> mirroring, we would probably suggest to implement P2P - read Ward
>> Cunninghams ideas int he keynote at the Wikimania conference this
>> summer...
>>
>> We have done the user mmapping Mapbender users with tooltips, direct
>> link to the website, etc. You can have a look at it on the project
>> homepage http://www.mapbender.org
>> Its done Wiki-style so that users can enter their own position (use
>> the blue flag) or remove or edit any position (use the i-button). No
>> user accounts yet but security and authentication is in place and
>> have just not yet been necessary (still waiting for spatial spam...)
>>
>> We will spread word about spatial data management using
>> PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
>> http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
>> Frankfurt/Main, Germany.
>>
>> This idea is on short notice but i would be really very excited if i
>> could show the map there! We suggest the following alterantive actions:
>>
>> - It should be easy to add a geometry_column to the existing
>> PostgreSQL database which alredy has the positions. Add a GeoServer
>> WFS to access the geomtry and a MapServer for WMS display.
>> - Alternatively send Paolo or us or both the geo-positions and we add
>> them to our existing OWS infrastructure (that will takt a few hours
>> of work only).
>>
>> Beause there is not so much time until the conference this would just
>> be be a prototype which should in the long run move to the PostgreSQL
>> or PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
>> Wikipedia software) is also right now introducing geometries to the
>> Wiki database - obviously also using PostgreSQL/PostGIS. This would
>> be another cool multiplier.. and there we also meet with Google again.
>>
>> Best, Arnulf.
>>
>>
>>> On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
>>>
>>>> On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>>>>
>>>>> On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>>>>
>>>>>> There has recently been a thread on the Postgres user list about
>>>>>> a web
>>>>>> based postgres user/developer map. Claire has built a Google map
>>>>>> based
>>>>>> system, getting locations from IP addresses.
>>>>>
>>>>>
>>>>>
>>>>> Just so people know, this map can be found at:
>>>>>
>>>>> http://www.zeesource.net/maps/map.do?group=456
>>>>>
>>>>
>>>> I'm going to loop in a few more people here :-), namely the pg web
>>>> team who
>>>> will probably be able to give pointers on site integration. One
>>>> thing to keep
>>>> in mind is that the postgresql website is statically mirrored onto
>>>> a number
>>>> of different servers, so any solution we come up with will ideally
>>>> allow
>>>> itself to that. I believe a google maps system can do this (we can
>>>> mirror the
>>>> javascript code and the location/data file on all mirrors and the
>>>> google map
>>>> will work with it as is), which is why I originally went with that
>>>> type of
>>>> solution.
>>>>
>>>> --
>>>> Robert Treat
>>>> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>>>
>>> _______________________________________________
>>> Freegis-list mailing list
>>> Freegis-list(at)intevation(dot)de
>>> https://intevation.de/mailman/listinfo/freegis-list
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users(at)postgis(dot)refractions(dot)net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com
msn:ezequias(at)hotmail(dot)com

Bruce Momjian wrote:
> I like the idea that people can add themselves, but I also liked the
> dynamic ability of seeing all email posters from the last few months.
> Can we have both?

Hi,
sorry for the cross post and delay. Here is a map interface demo where
you can add your own information Wiki-style. This is a mock-up only. It
makes exclusive use of Open Source components and freely available map
services. We'd be glad to share this know-how and eventually move the
whole thing to the PostgreSQL homepage servers. All data an locations
that you add will not be lost so just go ahead.

The map interface is linked into the Mapbender Wiki to show how it might
look like in a web site. Below the map you find a short description of
the software behind the project and how it was set up.

http://www.mapbender.org/index.php/PostgreSQL_User_Map

To open the GUI in a separate window use this URL:

http://wms1.ccgis.de/mapbender22/frames/login.php?name=mb&password=mb&mb_user_myGui=postgresql_user_s

Log in with "mb" "mb" if you see a prompt (might happen if your browser
hickups on the cookies).

Find an instruction on how to change the layout and features of the map
interface (you might need to learn how to use it, its not intended for
general click and go use). The admin-interface is also open Wiki style,
we will check and clean it up every now and then.

http://www.mapbender.org/index.php/PG_User_Map_Administration_Interface

Best regards,
Arnulf.

> ---------------------------------------------------------------------------
>
> Robert Treat wrote:
>
>>On Wed, 2005-12-07 at 02:30, Arnulf Christl wrote:
>>
>>>Bruce Momjian wrote:
>>>
>>>>Where are we on this? Can we get it added to our web site? Can we have
>>>>usernames added to the map?
>>>
>>>Hi,
>>>yes, both can be done. But our server and connectivity are sort of slow,
>>>so I was talking to some people whether they could host the services.
>>>This will take a few more days. Anybody interested in operating a
>>>spatial data infrastructure on stable servers (preferrably FreeBSD or
>>>some Linux) with good connectivity feel free to contact us.
>>>
>>
>>I'm fairly certain we can drum up some server space once we're ready to
>>host this for the postgresql site. For now even slow connectivity is
>>probably fine as it will only be a few people looking at it until we
>>finalize what we really need.
>>
>>
>>>Additionally we got lost in a few technical discussions about whether to
>>>implement the full scale service oriented standardized I-can-add-myself
>>>version using PostgreSQL with PostGIS (which I would really like to see
>>>as it promotes using PG as spatial data backend and also gives us GIS
>>>guys a chance to show off cool technology).
>>>
>>
>>As a side note, we need folks to help out with the elephant database
>>monitoring project. That seems like an ideal project to help show off
>>postgis. http://pgfoundry.org/projects/wilddb/
>>
>>
>>>Claire favored an easy-to-use google-maps approach which would mean less
>>>effort getting to run (they have it all up and running) but less
>>>compatibility and unsolved copyright issues regarding the background maps.
>>>
>>
>>Hmm...I thought this was all something that could be relatively easy to
>>solve. I think the main problem here was that I needed to test whether
>>the maps mirroring would work in the main site; I believe it would, but
>>this should probably be confirmed, and I haven't had time to get back to
>>it. The other side being that showing of postgis does have a nice
>>political upside that seems worth following up on.
>>
>>
>>>Give us a few more days, by the weekend I will post a link so that
>>>people can have a look at it. The link will ship with a list of which
>>>software is being used and how it is configured. Ideally someone "near"
>>>the PostgreSQL homepage could operate the service (we GIS folks never
>>>stop considering spatial proximity).
>>
>>Yes, the plan would be to integrate it fully into the postgresql web
>>infrastructure. We just need to figure out what that will take.
>>
>>
>>>What has to be done anyway is collect the coordinates of the users. It
>>>would be nice to not start off with a blank map. We can provide some 20
>>>users in Germany (most of them spatial). Either the name of a city or
>>>the decimal degree coordinates of the position will do.
>>
>>I see this as sort of a secondary thing, but I already have coordinates
>>for most of the people listed on our developers page, so we can always
>>start with that. I'm not against the idea of plotting other points
>>though; we could have points for support companies, points for mailing
>>list users, do some type of frapper style sign up; but that's secondary.
>>The first step is figuring setting up a system to display the
>>coordinates, then we can add more knobs on how to get the coordinates.
>>
>>
>>>Best, Arnulf.
>>>
>>>
>>>>Arnulf Christl wrote:
>>>>
>>>>
>>>>>Claire McLister wrote:
>>>>>
>>>>>
>>>>>>Good point. This might actually be a problem. Google Maps API requires
>>>>>>each server that is serving the map to be registered with Google, and
>>>>>>send the corresponding key when making the Javascript request.
>>>>>>
>>>>>>Unless the mirrors can each send their own keys, this will not work.
>>>>>>
>>>>>>Claire
>>>>>
>>>>>Hi, more cross posting...
>>>>>
>>>>>Sounds like this task should be solved using WMS and WFS services.
>>>>>Google is cool but in order to foster both Open Source and standards
>>>>>(OGC) we would suggest to use e.g. MapServer as WMS to produce the maps
>>>>>and GeoServer as WFS to manage geomtries. Those OWS services could then
>>>>>be included in any OWS client, web interface, etc. Everything is there
>>>>>and ready to go, the effort to get it to run should be minimal.
>>>>>
>>>>>Our clients usually operate PostgreSQL databases with several million
>>>>>geometries - those 500 to 600 markers could be hosted on any
>>>>>antediluvian box and still be fast. You will know what to about
>>>>>mirroring, we would probably suggest to implement P2P - read Ward
>>>>>Cunninghams ideas int he keynote at the Wikimania conference this summer...
>>>>>
>>>>>We have done the user mmapping Mapbender users with tooltips, direct
>>>>>link to the website, etc. You can have a look at it on the project
>>>>>homepage http://www.mapbender.org
>>>>>Its done Wiki-style so that users can enter their own position (use the
>>>>>blue flag) or remove or edit any position (use the i-button). No user
>>>>>accounts yet but security and authentication is in place and have just
>>>>>not yet been necessary (still waiting for spatial spam...)
>>>>>
>>>>>We will spread word about spatial data management using
>>>>>PostgreSQL/PostGIS with MapServer, GeoServer etc. at the
>>>>>http://www.opendbcon.net (database fundamentals) on Nov. 8. and 9. in
>>>>>Frankfurt/Main, Germany.
>>>>>
>>>>>This idea is on short notice but i would be really very excited if i
>>>>>could show the map there! We suggest the following alterantive actions:
>>>>>
>>>>>- It should be easy to add a geometry_column to the existing PostgreSQL
>>>>>database which alredy has the positions. Add a GeoServer WFS to access
>>>>>the geomtry and a MapServer for WMS display.
>>>>>- Alternatively send Paolo or us or both the geo-positions and we add
>>>>>them to our existing OWS infrastructure (that will takt a few hours of
>>>>>work only).
>>>>>
>>>>>Beause there is not so much time until the conference this would just be
>>>>>be a prototype which should in the long run move to the PostgreSQL or
>>>>>PostGIS homepage or Wiki or both. Yet another idea: Mediawiki (the
>>>>>Wikipedia software) is also right now introducing geometries to the Wiki
>>>>>database - obviously also using PostgreSQL/PostGIS. This would be
>>>>>another cool multiplier.. and there we also meet with Google again.
>>>>>
>>>>>Best, Arnulf.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>On Oct 26, 2005, at 6:02 PM, Robert Treat wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>On Wednesday 26 October 2005 18:24, Claire McLister wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>On Oct 26, 2005, at 2:08 PM, Brent Wood wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>There has recently been a thread on the Postgres user list about a web
>>>>>>>>>based postgres user/developer map. Claire has built a Google map based
>>>>>>>>>system, getting locations from IP addresses.
>>>>>>>>
>>>>>>>>
>>>>>>>>Just so people know, this map can be found at:
>>>>>>>>
>>>>>>>> http://www.zeesource.net/maps/map.do?group=456
>>>>>>>>
>>>>>>>
>>>>>>>I'm going to loop in a few more people here :-), namely the pg web
>>>>>>>team who
>>>>>>>will probably be able to give pointers on site integration. One thing
>>>>>>>to keep
>>>>>>>in mind is that the postgresql website is statically mirrored onto a
>>>>>>>number
>>>>>>>of different servers, so any solution we come up with will ideally allow
>>>>>>>itself to that. I believe a google maps system can do this (we can
>>>>>>>mirror the
>>>>>>>javascript code and the location/data file on all mirrors and the
>>>>>>>google map
>>>>>>>will work with it as is), which is why I originally went with that
>>>>>>>type of
>>>>>>>solution.
>>>>>>>
>>>>>>>--
>>>>>>>Robert Treat
>>>>>>>Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>>>>>>
>>>>>>
>>>>>>_______________________________________________
>>>>>>Freegis-list mailing list
>>>>>>Freegis-list(at)intevation(dot)de
>>>>>>https://intevation.de/mailman/listinfo/freegis-list
>>>>>
>>--
>>Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>
>