Re: [Freegis-list] Re: [GENERAL] Map of Postgresql Users - Mailing list pgsql-www

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

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