[Geoserver-users] Open Street Map and Geoserver

GeoServer GeoServer User
1

I just wanted to chime in here, as I happened to be looking into the same thing at the moment. I’m new to the list, so forgive me if this has been talked about already. What I’m trying to do, is set-up a web-interface whereby residents can add point data with attributes to a map. I’ve got a nicely functional installation of GeoServer running, and WFS-T is obviously the way forward, but I’m having trouble “seeing” the system architecture. So far, this is what I see:

*PostGIS DB
*Geoserver backend, serving data stored in PostGIS through the WFS-T specification
*Front end - This is where I’m at a loss.

The link you provided Chris (http://geo.openplans.org/tschaub/wfsv/feature-editor.html#) looks like exactly what I need (although I didn’t see any attribute editing function ality (yet, I suppose)). So, currently, if you were out to make a map of your favorite restaurants & wanted people to add to it & store the data in a DB backend (not shapefiles,as I’ve learned), what is the best way forward?

Best Regards,

Andrew Schroeder

-------- Original Message --------
Subject: Re: [Geoserver-users] Open Street Map and Geoserver
From: Chris Holmes cholmes@anonymised.com
Date: Thu, September 27, 2007 4:22 pm
To: “Tom (JDi Solutions)” tom.dean@anonymised.com
Cc: Rahkonen Jukka Jukka.Rahkonen@anonymised.com,
geoserver-users@lists.sourceforge.net

You can download the planet dump from OSM, and there are scripts to
convert it in to postgis, though I know of none for oracle.

GeoServer does not support GPX or OSM. I think someone is writing a GPX
datastore, and writing one for OSM wouldn’t be hard. But the problem
with those will be there’s no spatial index, so they won’t serve very
fast. I’d recommend converting to a database to serve it. You also
could convert to shapefile, they have scripts to do that I believe,
though that holds up less well for transactions.

As for reprojection, once you get the data in to GeoServer then it can
reproject it in to whatever projection you want.

The one thing I’m not clear on is how you’d contribute back to OSM? If
you just use their editing interface then it works, but then it’d be
awhile till your data got the update. I would like to work with them to
figure out how we could set up GeoServer’s as nodes on to the main OSM
database, to let contributions there go back in. Soon we should be able
to handle logins, and perhaps could have a version that hooks straight
up to their user database and does authentication the same way, and then
could do batch imports to their main db.

As for GeoCollaboration stuff, yeah, it’s goal is to enable similar
things in GeoServer, not so much direct integration, though it should
make direct integration easier, and we would be very psyched if OSM or
at least part of the community made use of GeoServer. They’ve shown no
interest in the past, but we lacked authors and versions and all, which
are now emerging.

We still need to do a lot of UI work on it, but you can see our first
sketches at http://geo.openplans.org/tschaub/wfsv/feature-editor.html#
It’s better when you set most of the preferences to true. And you can
try viewing the history and do diffs there, and then click on numbers to
do rollbacks.

Chris

Tom (JDi Solutions) wrote:

Thanks Jukka, I’ll check that out…

On 9/27/07, Rahkonen Jukka <Jukka.Rahkonen@mmmtike.fi
mailto:[Jukka.Rahkonen@mmmtike.fi](http://email.secureserver.net/pcompose.php#Compose)> wrote:

Hi,

I have never tried it myself, but you can download all OSM data in
one bundle. Have a look at
http://wiki.openstreetmap.org/index.php/Planet.osm
<http://wiki.openstreetmap.org/index.php/Planet.osm>
If you are in UK there seems to be also a smaller excerp available.
From the same page you can find more advice as well. Tell if you
will have success.

-Jukka Rahkonen-

Lähettäjä: geoserver-users-bounces@lists.sourceforge.net
mailto:[geoserver-users-bounces@lists.sourceforge.net](http://email.secureserver.net/pcompose.php#Compose)
[mailto:geoserver-users-bounces@lists.sourceforge.net
mailto:[geoserver-users-bounces@lists.sourceforge.net](http://email.secureserver.net/pcompose.php#Compose)]
*Puolesta *Tom (JDi Solutions)
Lähetetty: 27. syyskuuta 2007 10:54
Vastaanottaja: geoserver-users@lists.sourceforge.net
mailto:[geoserver-users@lists.sourceforge.net](http://email.secureserver.net/pcompose.php#Compose)
Aihe: [Geoserver-users] Open Street Map and Geoserver

Hi all,

I wonder if someone has any experience of using Open Street
Map? I’d like to contribute to and then use Open Street Map
data in my applications but I have come up against several
problems and I wonder if anyone has any suggestions.

  1. Open Street Map is recorded in lat/long (4326) but we use
    British National Grid Projection (27700) so if I’m to be able to
    display OSM data in OpenLayers I need to be able to convert the
    bounding box for a WMS request to lat/long before requesting
    it. Even then if my understanding of projections is correct it
    will come out slightly skewed? I could use Oracle to do this
    since it has a transform function which transforms co-ordinates
    from one projection to another but this has been shown to have a
    slight offset (with Google earth at least) so may not be good
    enough. Does Geoserver have any external functions which can be
    used without having to get into the java?

  2. Ideally it would be nice to be able to periodically copy the
    data from Open Street Map, reproject the whole lot and then
    serve it from our own server using Geoserver but Open Street Map
    only allows downloads of small sets of data at a time and they
    are in .GPX or .OSM and I can’t seem to find any way to convert
    them. Does Geoserver have any plans to support either of these
    formats?

I have read the GeoCollaboration page on the wiki but this seems
to be less about direct integration with Open Street Map and
more about enabling that sort of project to be run using
Geoserver. Is that right?

I realise I should probably post this to the Open Street Map
mailing list but I thought I’d get your thoughts on it first?

Tom

!DSPAM:4005,46fb675092881030819293!

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4005,46fb675092881030819293!

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fb675092881030819293!

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

2

The front end is openlayers. http://openlayers.org

If you want the versioning stuff then you need 1.6-beta3, with versioning enabled on a postgis versioning backend. It's still pretty bleeding edge functionality.

But for the front end openlayers is the best route forward, we've added some stuff there that makes WFS-T work a lot better.

Chris

aschroeder@anonymised.com wrote:

I just wanted to chime in here, as I happened to be looking into the same thing at the moment. I'm new to the list, so forgive me if this has been talked about already. What I'm trying to do, is set-up a web-interface whereby residents can add point data with attributes to a map. I've got a nicely functional installation of GeoServer running, and WFS-T is obviously the way forward, but I'm having trouble "seeing" the system architecture. So far, this is what I see:

*PostGIS DB
*Geoserver backend, serving data stored in PostGIS through the WFS-T specification
*Front end - This is where I'm at a loss.

The link you provided Chris (http://geo.openplans.org/tschaub/wfsv/feature-editor.html#) looks like exactly what I need (although I didn't see any attribute editing functionality (yet, I suppose)). So, currently, if you were out to make a map of your favorite restaurants & wanted people to add to it & store the data in a DB backend (not shapefiles,as I've learned), what is the best way forward?

Best Regards,

Andrew Schroeder

    -------- Original Message --------
    Subject: Re: [Geoserver-users] Open Street Map and Geoserver
    From: Chris Holmes <cholmes@anonymised.com>
    Date: Thu, September 27, 2007 4:22 pm
    To: "Tom (JDi Solutions)" <tom.dean@anonymised.com>
    Cc: Rahkonen Jukka <Jukka.Rahkonen@anonymised.com>,
    geoserver-users@lists.sourceforge.net

    You can download the planet dump from OSM, and there are scripts to
    convert it in to postgis, though I know of none for oracle.

    GeoServer does not support GPX or OSM. I think someone is writing a GPX
    datastore, and writing one for OSM wouldn't be hard. But the problem
    with those will be there's no spatial index, so they won't serve very
    fast. I'd recommend converting to a database to serve it. You also
    could convert to shapefile, they have scripts to do that I believe,
    though that holds up less well for transactions.

    As for reprojection, once you get the data in to GeoServer then it can
    reproject it in to whatever projection you want.

    The one thing I'm not clear on is how you'd contribute back to OSM? If
    you just use their editing interface then it works, but then it'd be
    awhile till your data got the update. I would like to work with them to
    figure out how we could set up GeoServer's as nodes on to the main OSM
    database, to let contributions there go back in. Soon we should be able
    to handle logins, and perhaps could have a version that hooks straight
    up to their user database and does authentication the same way, and
    then
    could do batch imports to their main db.

    As for GeoCollaboration stuff, yeah, it's goal is to enable similar
    things in GeoServer, not so much direct integration, though it should
    make direct integration easier, and we would be very psyched if OSM or
    at least part of the community made use of GeoServer. They've shown no
    interest in the past, but we lacked authors and versions and all, which
    are now emerging.

    We still need to do a lot of UI work on it, but you can see our first
    sketches at http://geo.openplans.org/tschaub/wfsv/feature-editor.html#
    It's better when you set most of the preferences to true. And you can
    try viewing the history and do diffs there, and then click on
    numbers to
    do rollbacks.

    Chris

    Tom (JDi Solutions) wrote:
     > Thanks Jukka, I'll check that out...
     >
     > On 9/27/07, *Rahkonen Jukka* <Jukka.Rahkonen**@mmmtike.fi
    <http://email.secureserver.net/pcompose.php#Compose&gt;
     > <mailto:Jukka.Rahkonen**@mmmtike.fi
    <http://email.secureserver.net/pcompose.php#Compose&gt;&gt;&gt; wrote:
     >
     > Hi,
     >
     > I have never tried it myself, but you can download all OSM data in
     > one bundle. Have a look at
     > http://wiki.openstreetmap.org/index.php/Planet.osm
     > <http://wiki.openstreetmap.org/index.php/Planet.osm&gt;
     > If you are in UK there seems to be also a smaller excerp available.
     > From the same page you can find more advice as well. Tell if you
     > will have success.
     >
     > -Jukka Rahkonen-
     >
    ------------------------------------------------------------------------
     > *Lähettäjä:* geoserver-users-bounces**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;
     > <mailto:geoserver-users-bounces**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;&gt;
     > [mailto:geoserver-users-bounces**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;
     > <mailto:geoserver-users-bounces**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;&gt;\]
     > *Puolesta *Tom (JDi Solutions)
     > *Lähetetty:* 27. syyskuuta 2007 10:54
     > *Vastaanottaja:* geoserver-users**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;
     > <mailto:geoserver-users**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;&gt;
     > *Aihe:* [Geoserver-users] Open Street Map and Geoserver
     >
     > Hi all,
     >
     > I wonder if someone has any experience of using Open Street
     > Map? I'd like to contribute to and then use Open Street Map
     > data in my applications but I have come up against several
     > problems and I wonder if anyone has any suggestions.
     >
     > 1. Open Street Map is recorded in lat/long (4326) but we use
     > British National Grid Projection (27700) so if I'm to be able to
     > display OSM data in OpenLayers I need to be able to convert the
     > bounding box for a WMS request to lat/long before requesting
     > it. Even then if my understanding of projections is correct it
     > will come out slightly skewed? I could use Oracle to do this
     > since it has a transform function which transforms co-ordinates
     > from one projection to another but this has been shown to have a
     > slight offset (with Google earth at least) so may not be good
     > enough. Does Geoserver have any external functions which can be
     > used without having to get into the java?
     >
     > 2. Ideally it would be nice to be able to periodically copy the
     > data from Open Street Map, reproject the whole lot and then
     > serve it from our own server using Geoserver but Open Street Map
     > only allows downloads of small sets of data at a time and they
     > are in .GPX or .OSM and I can't seem to find any way to convert
     > them. Does Geoserver have any plans to support either of these
     > formats?
     >
     > I have read the GeoCollaboration page on the wiki but this seems
     > to be less about direct integration with Open Street Map and
     > more about enabling that sort of project to be run using
     > Geoserver. Is that right?
     >
     > I realise I should probably post this to the Open Street Map
     > mailing list but I thought I'd get your thoughts on it first?
     >
     > Tom
     >
    ------------------------------------------------------------------------
     >
    -------------------------------------------------------------------------
     > This SF.net email is sponsored by: Microsoft
     > Defy all challenges. Microsoft(R) Visual Studio 2005.
     > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
     >
     > !DSPAM:4005,46fb675092881030819293!
     >
    ------------------------------------------------------------------------
     >
     > _______________________________________________
     > Geoserver-users mailing list
     > Geoserver-users**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;
     > https://lists.sourceforge.net/lists/listinfo/geoserver-users
     >
     > !DSPAM:4005,46fb675092881030819293!
    ------------------------------------------------------------------------
    -------------------------------------------------------------------------
    This SF.net email is sponsored by: Microsoft
    Defy all challenges. Microsoft(R) Visual Studio 2005.
    http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
    ------------------------------------------------------------------------
    _______________________________________________
    Geoserver-users mailing list
    Geoserver-users**@lists.sourceforge.net
    <http://email.secureserver.net/pcompose.php#Compose&gt;
    https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fc44f345012090977483!

3

and we’re using OpenLayers here too, it’s definitely got all you need to plot and save points.

As for contributing to OSM, the plan is to use their tools (JOSM) to contribute and then we’ll just have to wait for the contributed data to appear in the planet.osm. The site says they update it every week so I guess that will have to do for now. I’d love to be able to sponsor some sort of collaboration between GeoServer and Open Street Map in the future as one of our clients is a local authority in the UK who have street data from builders plans even before the tarmac has actually been laid and require the most up to date mapping possible. Ordnance Survey data is obviously on a whole other level in terms of accuracy and detail but is often 6 months behind development on the ground. There’s some management support for it but it remains just one of the many things we’d like to do so is definitely one for the future. Local Authorities in the UK move very slowly too so don’t anybody go holding their breath!

One final thing is I have managed to convert the PostGIS script to Oracle (a handful of search and replace did the job) and will be testing that out over the next week or so. The final piece of the puzzle is an .sld for styling it. If anyone knows where to get one please let me know, there’s a lot of attribute data to sift through in there so writing one from scratch could take a little while!

If you think it’s appropriate I’ll write a short page of my findings on the geoserver wiki.

Tom

On 9/28/07, Chris Holmes < cholmes@anonymised.com> wrote:

The front end is openlayers. http://openlayers.org

If you want the versioning stuff then you need 1.6-beta3, with
versioning enabled on a postgis versioning backend. It’s still pretty
bleeding edge functionality.

But for the front end openlayers is the best route forward, we’ve added
some stuff there that makes WFS-T work a lot better.

Chris

aschroeder@anonymised.com wrote:

I just wanted to chime in here, as I happened to be looking into the
same thing at the moment. I’m new to the list, so forgive me if this
has been talked about already. What I’m trying to do, is set-up a
web-interface whereby residents can add point data with attributes to a
map. I’ve got a nicely functional installation of GeoServer running,
and WFS-T is obviously the way forward, but I’m having trouble “seeing”
the system architecture. So far, this is what I see:

*PostGIS DB
*Geoserver backend, serving data stored in PostGIS through the WFS-T
specification
*Front end - This is where I’m at a loss.

The link you provided Chris
(http://geo.openplans.org/tschaub/wfsv/feature-editor.html#) looks like
exactly what I need (although I didn’t see any attribute editing
functionality (yet, I suppose)). So, currently, if you were out to make
a map of your favorite restaurants & wanted people to add to it & store
the data in a DB backend (not shapefiles,as I’ve learned), what is the
best way forward?

Best Regards,

Andrew Schroeder

-------- Original Message --------
Subject: Re: [Geoserver-users] Open Street Map and Geoserver
From: Chris Holmes <cholmes@anonymised.com>
Date: Thu, September 27, 2007 4:22 pm
To: “Tom (JDi Solutions)” < tom.dean@anonymised.com>
Cc: Rahkonen Jukka <Jukka.Rahkonen@anonymised.com.>,
geoserver-users@lists.sourceforge.net

You can download the planet dump from OSM, and there are scripts to
convert it in to postgis, though I know of none for oracle.

GeoServer does not support GPX or OSM. I think someone is writing a GPX
datastore, and writing one for OSM wouldn’t be hard. But the problem
with those will be there’s no spatial index, so they won’t serve very
fast. I’d recommend converting to a database to serve it. You also
could convert to shapefile, they have scripts to do that I believe,
though that holds up less well for transactions.

As for reprojection, once you get the data in to GeoServer then it can
reproject it in to whatever projection you want.

The one thing I’m not clear on is how you’d contribute back to OSM? If
you just use their editing interface then it works, but then it’d be
awhile till your data got the update. I would like to work with them to
figure out how we could set up GeoServer’s as nodes on to the main OSM
database, to let contributions there go back in. Soon we should be able
to handle logins, and perhaps could have a version that hooks straight
up to their user database and does authentication the same way, and
then
could do batch imports to their main db.

As for GeoCollaboration stuff, yeah, it’s goal is to enable similar
things in GeoServer, not so much direct integration, though it should
make direct integration easier, and we would be very psyched if OSM or
at least part of the community made use of GeoServer. They’ve shown no
interest in the past, but we lacked authors and versions and all, which
are now emerging.

We still need to do a lot of UI work on it, but you can see our first
sketches at http://geo.openplans.org/tschaub/wfsv/feature-editor.html#
It’s better when you set most of the preferences to true. And you can
try viewing the history and do diffs there, and then click on
numbers to
do rollbacks.

Chris

Tom (JDi Solutions) wrote:

Thanks Jukka, I’ll check that out…

On 9/27/07, Rahkonen Jukka <Jukka.Rahkonen**@mmmtike.fi
< http://email.secureserver.net/pcompose.php#Compose>
<mailto:Jukka.Rahkonen**@mmmtike.fi
< http://email.secureserver.net/pcompose.php#Compose>>> wrote:

Hi,

I have never tried it myself, but you can download all OSM data in
one bundle. Have a look at
http://wiki.openstreetmap.org/index.php/Planet.osm
<http://wiki.openstreetmap.org/index.php/Planet.osm >
If you are in UK there seems to be also a smaller excerp available.
From the same page you can find more advice as well. Tell if you
will have success.

-Jukka Rahkonen-

Lähettäjä: geoserver-users-bounces**@lists.sourceforge.net
<http://email.secureserver.net/pcompose.php#Compose>
<mailto: geoserver-users-bounces**@lists.sourceforge.net
<http://email.secureserver.net/pcompose.php#Compose>>
[mailto: geoserver-users-bounces**@lists.sourceforge.net
<http://email.secureserver.net/pcompose.php#Compose>
<mailto: geoserver-users-bounces**@lists.sourceforge.net
<http://email.secureserver.net/pcompose.php#Compose>>]
*Puolesta *Tom (JDi Solutions)
Lähetetty: 27. syyskuuta 2007 10:54
Vastaanottaja: geoserver-users**@lists.sourceforge.net
< http://email.secureserver.net/pcompose.php#Compose>
<mailto:geoserver-users**@lists.sourceforge.net
< http://email.secureserver.net/pcompose.php#Compose>>
Aihe: [Geoserver-users] Open Street Map and Geoserver

Hi all,

I wonder if someone has any experience of using Open Street
Map? I’d like to contribute to and then use Open Street Map
data in my applications but I have come up against several
problems and I wonder if anyone has any suggestions.

  1. Open Street Map is recorded in lat/long (4326) but we use
    British National Grid Projection (27700) so if I’m to be able to
    display OSM data in OpenLayers I need to be able to convert the
    bounding box for a WMS request to lat/long before requesting
    it. Even then if my understanding of projections is correct it
    will come out slightly skewed? I could use Oracle to do this
    since it has a transform function which transforms co-ordinates
    from one projection to another but this has been shown to have a
    slight offset (with Google earth at least) so may not be good
    enough. Does Geoserver have any external functions which can be
    used without having to get into the java?

  2. Ideally it would be nice to be able to periodically copy the
    data from Open Street Map, reproject the whole lot and then
    serve it from our own server using Geoserver but Open Street Map
    only allows downloads of small sets of data at a time and they
    are in .GPX or .OSM and I can’t seem to find any way to convert
    them. Does Geoserver have any plans to support either of these
    formats?

I have read the GeoCollaboration page on the wiki but this seems
to be less about direct integration with Open Street Map and
more about enabling that sort of project to be run using
Geoserver. Is that right?

I realise I should probably post this to the Open Street Map
mailing list but I thought I’d get your thoughts on it first?

Tom

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4005,46fb675092881030819293!

Geoserver-users mailing list
Geoserver-users**@lists.sourceforge.net
<http://email.secureserver.net/pcompose.php#Compose>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fb675092881030819293!

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Geoserver-users mailing list
Geoserver-users**@lists.sourceforge.net
< http://email.secureserver.net/pcompose.php#Compose>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fc44f345012090977483!

4

Tom (JDi Solutions) wrote:

and we're using OpenLayers here too, it's definitely got all you need to plot and save points.

As for contributing to OSM, the plan is to use their tools (JOSM) to contribute and then we'll just have to wait for the contributed data to appear in the planet.osm. The site says they update it every week so I guess that will have to do for now. I'd love to be able to sponsor some sort of collaboration between GeoServer and Open Street Map in the future as one of our clients is a local authority in the UK who have street data from builders plans even before the tarmac has actually been laid and require the most up to date mapping possible. Ordnance Survey data is obviously on a whole other level in terms of accuracy and detail but is often 6 months behind development on the ground. There's some management support for it but it remains just one of the many things we'd like to do so is definitely one for the future. Local Authorities in the UK move very slowly too so don't anybody go holding their breath!

Cool. We just finished up the week at the foss4g conference, and your email spurred me to talk to Nick Black of Open Street Map about collaboration potentials. We agreed that a first step would be to make recommendations for how people wanting to use GeoServer could easily ingest OSM data and then have clear links back to JOSM and the other OSM editing tools. Aka exactly what you're doing.

In the future if someone can get some funding we could explore something like GeoServer's as local nodes for OSM, so edits can be made on GeoServer with WFS-T and federated back to the core OSM database. This would require some good thinking and work on both sides - OSM's API would need to improve to do batch imports, GeoServer would need to make an OSM data store, and we'd have to figure out how we'd authenticate against OSM's user base and pass author tags back.

All of this should be possible, but would definitely require a bit of funding.

One final thing is I have managed to convert the PostGIS script to Oracle (a handful of search and replace did the job) and will be testing that out over the next week or so. The final piece of the puzzle is an .sld for styling it. If anyone knows where to get one please let me know, there's a lot of attribute data to sift through in there so writing one from scratch could take a little while!

If you think it's appropriate I'll write a short page of my findings on the geoserver wiki.

Sounds great. Definitely put up a page on the GeoServer wiki, if you've not done so before note that it's currently a bit of a bitch - http://docs.codehaus.org/display/GEOSDOC/Guide+to+Documenting+GeoServer

You also might put the Oracle script up on OSM's wiki, as others could be interested in it.

best regards,

Chris

Tom

On 9/28/07, *Chris Holmes* < cholmes@anonymised.com <mailto:cholmes@anonymised.com>> wrote:

    The front end is openlayers. http://openlayers.org

    If you want the versioning stuff then you need 1.6-beta3, with
    versioning enabled on a postgis versioning backend. It's still pretty
    bleeding edge functionality.

    But for the front end openlayers is the best route forward, we've added
    some stuff there that makes WFS-T work a lot better.

    Chris

    aschroeder@anonymised.com <mailto:aschroeder@anonymised.com> wrote:
     > I just wanted to chime in here, as I happened to be looking into the
     > same thing at the moment. I'm new to the list, so forgive me if this
     > has been talked about already. What I'm trying to do, is set-up a
     > web-interface whereby residents can add point data with
    attributes to a
     > map. I've got a nicely functional installation of GeoServer running,
     > and WFS-T is obviously the way forward, but I'm having trouble
    "seeing"
     > the system architecture. So far, this is what I see:
     >
     > *PostGIS DB
     > *Geoserver backend, serving data stored in PostGIS through the WFS-T
     > specification
     > *Front end - This is where I'm at a loss.
     >
     > The link you provided Chris
     > (http://geo.openplans.org/tschaub/wfsv/feature-editor.html#)
    looks like
     > exactly what I need (although I didn't see any attribute editing
     > functionality (yet, I suppose)). So, currently, if you were out
    to make
     > a map of your favorite restaurants & wanted people to add to it &
    store
     > the data in a DB backend (not shapefiles,as I've learned), what
    is the
     > best way forward?
     >
     > Best Regards,
     >
     > Andrew Schroeder
     >
     > -------- Original Message --------
     > Subject: Re: [Geoserver-users] Open Street Map and Geoserver
     > From: Chris Holmes <cholmes@anonymised.com
    <mailto:cholmes@anonymised.com>>
     > Date: Thu, September 27, 2007 4:22 pm
     > To: "Tom (JDi Solutions)" < tom.dean@anonymised.com
    <mailto:tom.dean@anonymised.com>>
     > Cc: Rahkonen Jukka <Jukka.Rahkonen@anonymised.com
    <mailto:Jukka.Rahkonen@anonymised.com>>,
     > geoserver-users@lists.sourceforge.net
    <mailto:geoserver-users@lists.sourceforge.net>
     >
     > You can download the planet dump from OSM, and there are
    scripts to
     > convert it in to postgis, though I know of none for oracle.
     >
     > GeoServer does not support GPX or OSM. I think someone is
    writing a GPX
     > datastore, and writing one for OSM wouldn't be hard. But the
    problem
     > with those will be there's no spatial index, so they won't
    serve very
     > fast. I'd recommend converting to a database to serve it. You
    also
     > could convert to shapefile, they have scripts to do that I
    believe,
     > though that holds up less well for transactions.
     >
     > As for reprojection, once you get the data in to GeoServer
    then it can
     > reproject it in to whatever projection you want.
     >
     > The one thing I'm not clear on is how you'd contribute back
    to OSM? If
     > you just use their editing interface then it works, but then
    it'd be
     > awhile till your data got the update. I would like to work
    with them to
     > figure out how we could set up GeoServer's as nodes on to the
    main OSM
     > database, to let contributions there go back in. Soon we
    should be able
     > to handle logins, and perhaps could have a version that hooks
    straight
     > up to their user database and does authentication the same
    way, and
     > then
     > could do batch imports to their main db.
     >
     > As for GeoCollaboration stuff, yeah, it's goal is to enable
    similar
     > things in GeoServer, not so much direct integration, though
    it should
     > make direct integration easier, and we would be very psyched
    if OSM or
     > at least part of the community made use of GeoServer. They've
    shown no
     > interest in the past, but we lacked authors and versions and
    all, which
     > are now emerging.
     >
     > We still need to do a lot of UI work on it, but you can see
    our first
     > sketches at
    http://geo.openplans.org/tschaub/wfsv/feature-editor.html#
     > It's better when you set most of the preferences to true. And
    you can
     > try viewing the history and do diffs there, and then click on
     > numbers to
     > do rollbacks.
     >
     > Chris
     >
     > Tom (JDi Solutions) wrote:
     > > Thanks Jukka, I'll check that out...
     > >
     > > On 9/27/07, *Rahkonen Jukka* <Jukka.Rahkonen**@mmmtike.fi
    <mailto:Jukka.Rahkonen**@mmmtike.fi>
     > < http://email.secureserver.net/pcompose.php#Compose&gt;
     > > <mailto:Jukka.Rahkonen**@mmmtike.fi
    <mailto:Jukka.Rahkonen**@mmmtike.fi>
     > < http://email.secureserver.net/pcompose.php#Compose&gt;&gt;&gt; wrote:
     > >
     > > Hi,
     > >
     > > I have never tried it myself, but you can download all OSM
    data in
     > > one bundle. Have a look at
     > > http://wiki.openstreetmap.org/index.php/Planet.osm
     > > <http://wiki.openstreetmap.org/index.php/Planet.osm
    <http://wiki.openstreetmap.org/index.php/Planet.osm&gt;&gt;
     > > If you are in UK there seems to be also a smaller excerp
    available.
     > > From the same page you can find more advice as well. Tell
    if you
     > > will have success.
     > >
     > > -Jukka Rahkonen-
     > >
     > ------------------------------------------------------------------------
     > > *Lähettäjä:*
    geoserver-users-bounces**@lists.sourceforge.net
    <mailto:geoserver-users-bounces**@lists.sourceforge.net>
     > <http://email.secureserver.net/pcompose.php#Compose&gt;
     > > <mailto: geoserver-users-bounces**@lists.sourceforge.net
    <mailto:geoserver-users-bounces**@lists.sourceforge.net>
     > <http://email.secureserver.net/pcompose.php#Compose&gt;&gt;
     > > [mailto: geoserver-users-bounces**@lists.sourceforge.net
    <mailto:geoserver-users-bounces**@lists.sourceforge.net>
     > <http://email.secureserver.net/pcompose.php#Compose&gt;
     > > <mailto: geoserver-users-bounces**@lists.sourceforge.net
    <mailto:geoserver-users-bounces**@lists.sourceforge.net>
     > <http://email.secureserver.net/pcompose.php#Compose&gt;&gt;\]
     > > *Puolesta *Tom (JDi Solutions)
     > > *Lähetetty:* 27. syyskuuta 2007 10:54
     > > *Vastaanottaja:* geoserver-users**@lists.sourceforge.net
    <mailto:geoserver-users**@lists.sourceforge.net>
     > < http://email.secureserver.net/pcompose.php#Compose&gt;
     > > <mailto:geoserver-users**@lists.sourceforge.net
    <mailto:geoserver-users**@lists.sourceforge.net>
     > < http://email.secureserver.net/pcompose.php#Compose&gt;&gt;
     > > *Aihe:* [Geoserver-users] Open Street Map and Geoserver
     > >
     > > Hi all,
     > >
     > > I wonder if someone has any experience of using Open Street
     > > Map? I'd like to contribute to and then use Open Street Map
     > > data in my applications but I have come up against several
     > > problems and I wonder if anyone has any suggestions.
     > >
     > > 1. Open Street Map is recorded in lat/long (4326) but we use
     > > British National Grid Projection (27700) so if I'm to be
    able to
     > > display OSM data in OpenLayers I need to be able to
    convert the
     > > bounding box for a WMS request to lat/long before requesting
     > > it. Even then if my understanding of projections is correct it
     > > will come out slightly skewed? I could use Oracle to do this
     > > since it has a transform function which transforms
    co-ordinates
     > > from one projection to another but this has been shown to
    have a
     > > slight offset (with Google earth at least) so may not be good
     > > enough. Does Geoserver have any external functions which
    can be
     > > used without having to get into the java?
     > >
     > > 2. Ideally it would be nice to be able to periodically
    copy the
     > > data from Open Street Map, reproject the whole lot and then
     > > serve it from our own server using Geoserver but Open
    Street Map
     > > only allows downloads of small sets of data at a time and
    they
     > > are in .GPX or .OSM and I can't seem to find any way to
    convert
     > > them. Does Geoserver have any plans to support either of these
     > > formats?
     > >
     > > I have read the GeoCollaboration page on the wiki but this
    seems
     > > to be less about direct integration with Open Street Map and
     > > more about enabling that sort of project to be run using
     > > Geoserver. Is that right?
     > >
     > > I realise I should probably post this to the Open Street Map
     > > mailing list but I thought I'd get your thoughts on it first?
     > >
     > > Tom
     > >
     > ------------------------------------------------------------------------
     > >
     > -------------------------------------------------------------------------
     > > This SF.net email is sponsored by: Microsoft
     > > Defy all challenges. Microsoft(R) Visual Studio 2005.
     > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
    <http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/&gt;
     > >
     > ------------------------------------------------------------------------
     > >
     > > _______________________________________________
     > > Geoserver-users mailing list
     > > Geoserver-users**@lists.sourceforge.net
    <mailto:Geoserver-users**@lists.sourceforge.net>
     > <http://email.secureserver.net/pcompose.php#Compose&gt;
     > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
     > >
     > > !DSPAM:4005,46fb675092881030819293!
     > ------------------------------------------------------------------------

     > -------------------------------------------------------------------------
     > This SF.net email is sponsored by: Microsoft
     > Defy all challenges. Microsoft(R) Visual Studio 2005.
     > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
     > ------------------------------------------------------------------------
     > _______________________________________________
     > Geoserver-users mailing list
     > Geoserver-users**@lists.sourceforge.net
    <mailto:Geoserver-users**@lists.sourceforge.net>
     > < http://email.secureserver.net/pcompose.php#Compose&gt;
     > https://lists.sourceforge.net/lists/listinfo/geoserver-users
     >
     > !DSPAM:4005,46fc44f345012090977483!

!DSPAM:4005,46fcb83f137511628642973!

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4005,46fcb83f137511628642973!

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

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fcb83f137511628642973!

5

Hi Chris (and others),

I thought I’d introduce myself - I talked with Chris at FOSS4G about integrating GeoServer / OSM functionality - specifically allowing editing of OSM data, held in the central OSM db, using some of the GeoServer tools. This all sounds really exciting, and fits well with some planned enhancements to the OSM API.

With regards to the Oracle import script, I can get SVN access for the author, or I can add it to OSM SVN myself.

Best,

On 29 Sep 2007, at 16:49, Chris Holmes wrote:

Tom (JDi Solutions) wrote:

and we’re using OpenLayers here too, it’s definitely got all you need to plot and save points.
As for contributing to OSM, the plan is to use their tools (JOSM) to contribute and then we’ll just have to wait for the contributed data to appear in the planet.osm. The site says they update it every week so I guess that will have to do for now. I’d love to be able to sponsor some sort of collaboration between GeoServer and Open Street Map in the future as one of our clients is a local authority in the UK who have street data from builders plans even before the tarmac has actually been laid and require the most up to date mapping possible. Ordnance Survey data is obviously on a whole other level in terms of accuracy and detail but is often 6 months behind development on the ground. There’s some management support for it but it remains just one of the many things we’d like to do so is definitely one for the future. Local Authorities in the UK move very slowly too so don’t anybody go holding their breath!

Cool. We just finished up the week at the foss4g conference, and your email spurred me to talk to Nick Black of Open Street Map about collaboration potentials. We agreed that a first step would be to make recommendations for how people wanting to use GeoServer could easily ingest OSM data and then have clear links back to JOSM and the other OSM editing tools. Aka exactly what you’re doing.

In the future if someone can get some funding we could explore something like GeoServer’s as local nodes for OSM, so edits can be made on GeoServer with WFS-T and federated back to the core OSM database. This would require some good thinking and work on both sides - OSM’s API would need to improve to do batch imports, GeoServer would need to make an OSM data store, and we’d have to figure out how we’d authenticate against OSM’s user base and pass author tags back.

All of this should be possible, but would definitely require a bit of funding.

One final thing is I have managed to convert the PostGIS script to Oracle (a handful of search and replace did the job) and will be testing that out over the next week or so. The final piece of the puzzle is an .sld for styling it. If anyone knows where to get one please let me know, there’s a lot of attribute data to sift through in there so writing one from scratch could take a little while!
If you think it’s appropriate I’ll write a short page of my findings on the geoserver wiki.

Sounds great. Definitely put up a page on the GeoServer wiki, if you’ve not done so before note that it’s currently a bit of a bitch - http://docs.codehaus.org/display/GEOSDOC/Guide+to+Documenting+GeoServer

You also might put the Oracle script up on OSM’s wiki, as others could be interested in it.

best regards,

Chris

Tom
On 9/28/07, Chris Holmes < cholmes@anonymised.com1… <mailto:cholmes@anonymised.com>> wrote:
The front end is openlayers. http://openlayers.org
If you want the versioning stuff then you need 1.6-beta3, with
versioning enabled on a postgis versioning backend. It’s still pretty
bleeding edge functionality.
But for the front end openlayers is the best route forward, we’ve added
some stuff there that makes WFS-T work a lot better.
Chris
aschroeder@anonymised.com <mailto:aschroeder@anonymised.com> wrote:

I just wanted to chime in here, as I happened to be looking into the
same thing at the moment. I’m new to the list, so forgive me if this
has been talked about already. What I’m trying to do, is set-up a
web-interface whereby residents can add point data with
attributes to a
map. I’ve got a nicely functional installation of GeoServer running,
and WFS-T is obviously the way forward, but I’m having trouble
“seeing”
the system architecture. So far, this is what I see:

*PostGIS DB
*Geoserver backend, serving data stored in PostGIS through the WFS-T
specification
*Front end - This is where I’m at a loss.

The link you provided Chris
(http://geo.openplans.org/tschaub/wfsv/feature-editor.html#)
looks like
exactly what I need (although I didn’t see any attribute editing
functionality (yet, I suppose)). So, currently, if you were out
to make
a map of your favorite restaurants & wanted people to add to it &
store
the data in a DB backend (not shapefiles,as I’ve learned), what
is the
best way forward?

Best Regards,

Andrew Schroeder

-------- Original Message --------
Subject: Re: [Geoserver-users] Open Street Map and Geoserver
From: Chris Holmes <cholmes@anonymised.com
<mailto:cholmes@anonymised.com>>
Date: Thu, September 27, 2007 4:22 pm
To: “Tom (JDi Solutions)” < tom.dean@anonymised.com94…
<mailto:tom.dean@anonymised.com…>>
Cc: Rahkonen Jukka <Jukka.Rahkonen@anonymised.com
<mailto:Jukka.Rahkonen@anonymised.com>>,
geoserver-users@lists.sourceforge.net
<mailto:geoserver-users@lists.sourceforge.net>

You can download the planet dump from OSM, and there are
scripts to
convert it in to postgis, though I know of none for oracle.

GeoServer does not support GPX or OSM. I think someone is
writing a GPX
datastore, and writing one for OSM wouldn’t be hard. But the
problem
with those will be there’s no spatial index, so they won’t
serve very
fast. I’d recommend converting to a database to serve it. You
also
could convert to shapefile, they have scripts to do that I
believe,
though that holds up less well for transactions.

As for reprojection, once you get the data in to GeoServer
then it can
reproject it in to whatever projection you want.

The one thing I’m not clear on is how you’d contribute back
to OSM? If
you just use their editing interface then it works, but then
it’d be
awhile till your data got the update. I would like to work
with them to
figure out how we could set up GeoServer’s as nodes on to the
main OSM
database, to let contributions there go back in. Soon we
should be able
to handle logins, and perhaps could have a version that hooks
straight
up to their user database and does authentication the same
way, and
then
could do batch imports to their main db.

As for GeoCollaboration stuff, yeah, it’s goal is to enable
similar
things in GeoServer, not so much direct integration, though
it should
make direct integration easier, and we would be very psyched
if OSM or
at least part of the community made use of GeoServer. They’ve
shown no
interest in the past, but we lacked authors and versions and
all, which
are now emerging.

We still need to do a lot of UI work on it, but you can see
our first
sketches at
http://geo.openplans.org/tschaub/wfsv/feature-editor.html#
It’s better when you set most of the preferences to true. And
you can
try viewing the history and do diffs there, and then click on
numbers to
do rollbacks.

Chris

Tom (JDi Solutions) wrote:

Thanks Jukka, I’ll check that out…

On 9/27/07, Rahkonen Jukka <Jukka.Rahkonen**@mmmtike.fi
<mailto:Jukka.Rahkonen@mmmtike.fi>
< http://email.secureserver.net/pcompose.php#Compose>
<mailto:Jukka.Rahkonen@mmmtike.fi
<mailto:Jukka.Rahkonen**@mmmtike.fi>
< http://email.secureserver.net/pcompose.php#Compose>>> wrote:

Hi,

I have never tried it myself, but you can download all OSM
data in
one bundle. Have a look at
http://wiki.openstreetmap.org/index.php/Planet.osm
<http://wiki.openstreetmap.org/index.php/Planet.osm
<http://wiki.openstreetmap.org/index.php/Planet.osm>>
If you are in UK there seems to be also a smaller excerp
available.
From the same page you can find more advice as well. Tell
if you
will have success.

-Jukka Rahkonen-

Lähettäjä:
geoserver-users-bounces**@lists.sourceforge.net
<mailto:geoserver-users-bounces@lists.sourceforge.net>
<http://email.secureserver.net/pcompose.php#Compose>
<mailto: geoserver-users-bounces@lists.sourceforge.net
<mailto:geoserver-users-bounces@lists.sourceforge.net>
<http://email.secureserver.net/pcompose.php#Compose>>
[mailto: geoserver-users-bounces@lists.sourceforge.net
<mailto:geoserver-users-bounces@lists.sourceforge.net>
<http://email.secureserver.net/pcompose.php#Compose>
<mailto: geoserver-users-bounces@lists.sourceforge.net
<mailto:geoserver-users-bounces@lists.sourceforge.net>
<http://email.secureserver.net/pcompose.php#Compose>>]
Puolesta Tom (JDi Solutions)
Lähetetty: 27. syyskuuta 2007 10:54
Vastaanottaja: geoserver-users@lists.sourceforge.net
<mailto:geoserver-users@lists.sourceforge.net>
< http://email.secureserver.net/pcompose.php#Compose>
<mailto:geoserver-users@lists.sourceforge.net
<mailto:geoserver-users@lists.sourceforge.net>
< http://email.secureserver.net/pcompose.php#Compose>>
Aihe: [Geoserver-users] Open Street Map and Geoserver

Hi all,

I wonder if someone has any experience of using Open Street
Map? I’d like to contribute to and then use Open Street Map
data in my applications but I have come up against several
problems and I wonder if anyone has any suggestions.

  1. Open Street Map is recorded in lat/long (4326) but we use
    British National Grid Projection (27700) so if I’m to be
    able to
    display OSM data in OpenLayers I need to be able to
    convert the
    bounding box for a WMS request to lat/long before requesting
    it. Even then if my understanding of projections is correct it
    will come out slightly skewed? I could use Oracle to do this
    since it has a transform function which transforms
    co-ordinates
    from one projection to another but this has been shown to
    have a
    slight offset (with Google earth at least) so may not be good
    enough. Does Geoserver have any external functions which
    can be
    used without having to get into the java?

  2. Ideally it would be nice to be able to periodically
    copy the
    data from Open Street Map, reproject the whole lot and then
    serve it from our own server using Geoserver but Open
    Street Map
    only allows downloads of small sets of data at a time and
    they
    are in .GPX or .OSM and I can’t seem to find any way to
    convert
    them. Does Geoserver have any plans to support either of these
    formats?

I have read the GeoCollaboration page on the wiki but this
seems
to be less about direct integration with Open Street Map and
more about enabling that sort of project to be run using
Geoserver. Is that right?

I realise I should probably post this to the Open Street Map
mailing list but I thought I’d get your thoughts on it first?

Tom

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
<http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/>

Geoserver-users mailing list
Geoserver-users**@lists.sourceforge.net
<mailto:Geoserver-users**@lists.sourceforge.net>
<http://email.secureserver.net/pcompose.php#Compose>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fb675092881030819293!

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Geoserver-users mailing list
Geoserver-users**@lists.sourceforge.net
<mailto:Geoserver-users**@lists.sourceforge.net>
< http://email.secureserver.net/pcompose.php#Compose>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46fc44f345012090977483!
!DSPAM:4005,46fcb83f137511628642973!

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
!DSPAM:4005,46fcb83f137511628642973!

Geoserver-users mailing list
Geoserver-users@anonymised.comforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4005,46fcb83f137511628642973!
<cholmes.vcf>

Nick Black

http://www.zxv.ltd.uk

+44(0)7835054292