[Geoserver-users] sql queries

GeoServer GeoServer User
1

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 queries

Ziegler 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@anonymised.comceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

2

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 queries

Ziegler 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!