Re: [postgis-users] Re: [Freegis-list] Re: [GENERAL] - Mailing list pgsql-www

From Ezequias Rodrigues da Rocha
Subject Re: [postgis-users] Re: [Freegis-list] Re: [GENERAL]
Date
Msg-id 439EDA82.8040001@recife.pe.gov.br
Whole thread Raw
In response to Re: [Freegis-list] Re: [GENERAL] Map of Postgresql Users (OT)  (Claire McLister <mclister@zeesource.net>)
List pgsql-www
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@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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com
msn:ezequias@hotmail.com


pgsql-www by date:

Previous
From: Robert Treat
Date:
Subject: Re: postgresql.nl
Next
From: Josh Berkus
Date:
Subject: 8.1.1 News Item,
tags