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

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@intevation.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@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

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