[pgsql-www] [Freegis-list] Re: [GENERAL] Map of Postgresql Users (OT)

[Claire McLister]

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