How to style geoserver with imposm-schemed database?

[Chris Stylianou]

Hi, I'm currently trying to install Geoserver with our OSM postgis database which we used imposm to import into it (We previously use MapServer).

I've been able to create a new database store and pull out all the layers that imposm created during the import. I've then published each of those layers and created a layer group to combine these layers.

Where I'm struggling I believe is that I cannot find any styles (SLD) that work with the imposm layer structure. All the Geoserver SLD's I find for OSM seem to only contain the layers:

• planet_osm_line
• planet_osm_point
• planet_osm_polygon
• planet_osm_roads


But imposm breaks OSM down into:

• osm_admin
• osm_aeroways
• osm_amenities
• osm_buildings
• osm_landusages
• osm_landusages_gen0
• osm_landusages_gen1
• osm_mainroads
• osm_mainroads_gen0
• osm_mainroads_gen1
• osm_minorroads
• osm_motorways
• osm_motorways_gen0
• osm_motorways_gen1
• osm_places
• osm_railways
• osm_railways_gen0
• osm_railways_gen1
• osm_roads
• osm_roads_gen0
• osm_roads_gen1
• osm_transport_areas
• osm_transport_points
• osm_waterareas
• osm_waterareas_gen0
• osm_waterareas_gen1
• osm_waterways

I've tried using mapscript to convert mapservers map file to an SLD, but when I use this in geoserver I just seem to get blank images when using the WMS service from Geoserver.

Does anyone have a working SLD, or maybe I'm doing something else wrong? Or is it a case that imposm really doesn't work with Geoserver and I need to look at using osm2psql?

[Oliver Tonnhofer]

On 23.08.2012, at 14:56, Chris Stylianou wrote:

> Hi, I'm currently trying to install Geoserver with our OSM postgis database which we used imposm to import into it (We previously use MapServer).

> [...]

> Does anyone have a working SLD, or maybe I'm doing something else wrong? Or is it a case that imposm really doesn't work with Geoserver and I need to look at using osm2psql?

Imposm is just a tool that fills a PostGIS database with OpenStreetMap data. So there is as much Geoserver support in Imposm as for Mapserver or Mapnik.

For existing stylings? I'm only aware of the styling that was used for the WMS shootout in Denver last year. The code is here[0], but I don't know if someone is maintaining it somewhere else.

http://svn.osgeo.org/osgeo/foss4g/benchmarking/wms/2011/geoserver/

Regards,
Oliver

--
Oliver Tonnhofer | Omniscale GmbH & Co KG | http://omniscale.de
http://mapproxy.org | https://github.com/olt | @oltonn