[Geoserver-users] Q: map single row from PostGIS with WMS

Hi,

I need a GeoServer recipe for the following scenario. I have the following sources:

- PostGIS table containing routes with unique id and a geometry column as OGC LINESTRING
- remote WMS serving background maps

I need to configure/construct a request (WMS/WFS?) that draws a single row (route) on a background map. The server should do all the rendering.

Using GS 1.5.0rc1 I have been able to configure the PostGIS "route" datasource and local GeoTIFF map data. I can render these as layers using WMS requests. But I can't figure out how to select a single row (route) using WMS. I can select a row using WFS and ogc-filter but that outputs GML. I also can calculate the bbox extent of a single route. So two questions remain:

1- how to configure a remote WMS where GeoServer acts as proxy
2- how to (server-side) render a single PostGIS row on a map served by the remote WMS

Any ideas (WMC?,custom WFS Outputformat?)/suggestions welcome ! best,

--Just

Just van den Broecke
http://www.justobjects.nl
The Netherlands

Just van den Broecke wrote:

Hi,

I need a GeoServer recipe for the following scenario. I have the following sources:

- PostGIS table containing routes with unique id and a geometry column as OGC LINESTRING
- remote WMS serving background maps

I need to configure/construct a request (WMS/WFS?) that draws a single row (route) on a background map. The server should do all the rendering.

Using GS 1.5.0rc1 I have been able to configure the PostGIS "route" datasource and local GeoTIFF map data. I can render these as layers using WMS requests. But I can't figure out how to select a single row (route) using WMS. I can select a row using WFS and ogc-filter but that outputs GML. I also can calculate the bbox extent of a single route. So two questions remain:

1- how to configure a remote WMS where GeoServer acts as proxy

This is not yet possible. It's called a 'cascading WMS', and we don't support it yet. But you could probably accomplish the same thing in your client, just point your client at both GeoServer WMS and your background WMS.

2- how to (server-side) render a single PostGIS row on a map served by the remote WMS

So the traditional way is to use SLD, which works with WMS - you specify not only filters, but also the symbology of how you want to render it. In your case you'd set up a featureid filter. You can pass in SLD from the client and GeoServer will render it.

Recently we've also added the ability for the WMS to take a filter. This isn't well documented, since it's not an official OGC thing, but many servers support it and many people just try it. This is probably an easier solution for you, just pass in the ogc-filter to the WMS. It should work with 1.5.0rc1. Just use the FILTER parameter in the same way you would in a WFS Get request.

best regards,

Chris

Any ideas (WMC?,custom WFS Outputformat?)/suggestions welcome ! best,

--Just

Just van den Broecke
http://www.justobjects.nl
The Netherlands

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,45defd72191341804284693!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org