Re: [Geoserver-users] Dynamic generation of WMS from backend PostGIS queries?

2011-02-07 Thread Darrell Berry
thanks all for ideas. i now have 2 options to investigate, all of which look promising in one way or another: 1. askml() in postgis 2. the 2.1 sql view feature much appreciated d On 7 Feb 2011, at 16:58, Charles Galpin wrote: > Darrell, > > If you needs are modest, you can use the new sql

Re: [Geoserver-users] Dynamic generation of WMS from backend PostGIS queries?

2011-02-07 Thread Charles Galpin
Darrell, If you needs are modest, you can use the new sql view feature of the 2.1 series and implement you logic in a postgres function. Very easy to do and you get all the geoserver goodness for free (so use wms/wfs/kml/geojson/whatever). This assumes you can pass in any parameters you need a

Re: [Geoserver-users] Dynamic generation of WMS from backend PostGIS queries?

2011-02-07 Thread David Winslow
GeoServer's KML implementation (and everything else) is implemented in terms of the GeoTools DataStore and FeatureCollection API; it doesn't really work on ResultSets directly. Similarly, GeoServer is not a library, it's an application, so cases like yours aren't really at the forefront of develop

Re: [Geoserver-users] Dynamic generation of WMS from backend PostGIS queries?

2011-02-07 Thread Darrell Berry
Just to clarify -- I guess I really just want to use whatever libraries are available from geoserver to render PostGis queries -> KML. SImple as that. OR should I be looking elsewhere (other than GeoServer?!) D On 7 Feb 2011, at 14:05, Darrell Berry wrote: > Hi -- I'm not quite sure if this fa

[Geoserver-users] Dynamic generation of WMS from backend PostGIS queries?

2011-02-07 Thread Darrell Berry
Hi -- I'm not quite sure if this falls into he Users or Developers list, so if this is the wrong place, please let me know! I have an existing Java-based web service app (POJO via Axis2 on Tomcat) which now needs some geospatial data rendered up to a web client as WMS (in fact as KML) I've had