I’m quite sure that it works 
It would be more like a WPS. I hoped for the cql_filter intersects command but this is returning the whole geometry and is not clipping (which is correct).
Stefan
-----Ursprüngliche Nachricht-----
Von: Chris Holmes [mailto:cholmes@anonymised.com]
Gesendet am: Dienstag, 29. Januar 2008 21:32
An: Ziegler Stefan
Cc: aaime; geoserver-users
Betreff: Re: [Geoserver-users] sql queries
I’m 98% sure that’s still going to return the whole geometry. What you
really want is clipping of the polygon.
I’m not sure if there’s a command to do this in postgis. I searched a
bit and found this:
http://postgis.refractions.net/pipermail/postgis-users/2003-November/003437.html
Maybe that could help? If your data is really large splitting it up
could help…
Ziegler Stefan wrote:
Thanks. No no, everything works fine. I still have my own pdf output
problem. As geoserver requests always the whole feature the pdf gets
very big sometimes. Just wanted to hardcode a “select
intersection(bbox,the_geom)…” and see what happens (dull approach
though…).Stefan
-----Ursprüngliche Nachricht-----
Von: Andrea Aime [mailto:aaime@anonymised.com]
Gesendet am: Dienstag, 29. Januar 2008 21:16
An: Ziegler Stefan
Cc: geoserver-users
Betreff: Re: [Geoserver-users] sql queriesZiegler Stefan ha scritto:
Hi
can someone tell me where the sql queries are build in the sources for
the wms/wfs requests? Thanks.Inside the datastores. OGC Filter representations are turned into
sql by SQLBuilder, FilterToSql and friends (hem, subclasses) whose
actual implementation depends on the dbms capabilities.Trying to hunt down some misbehaviour?
Cheers
Andrea
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
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
!DSPAM:4005,479f8bab197215332866982!
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/!DSPAM:4005,479f8bab197215332866982!
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4005,479f8bab197215332866982!