[Geoserver-users] sql queries

GeoServer GeoServer User
1

No problem.
Since the sql queries is done with geotools and not with “native” geoserver sources, what is the best way to play around with it? Get the geotools sources, apply my changes, compile the stuff and put the jars in an existing geoserver installation? Does this workflow work?

Stefan

-----Ursprüngliche Nachricht-----
Von: Chris Holmes [mailto:cholmes@anonymised.com]
Gesendet am: Dienstag, 29. Januar 2008 21:56
An: Ziegler Stefan
Cc: geoserver-users
Betreff: Re: [Geoserver-users] sql queries

Ah, right. I misread ‘intersection’ as ‘intersects’, I apologize.

Chris

Ziegler Stefan wrote:

I’m quite sure that it works :wink: 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 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

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!

!DSPAM:4005,479f90f5204711628642973!

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,479f90f5204711628642973!

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,479f90f5204711628642973!

2

Yup, that works great. You'll have to restart geoserver to make it pick up the changes. Building GeoTools can be a bit annoying, but once you get it working you just need to build the module you're working on and drop it in to GeoServer.

best regards,

Chris

Ziegler Stefan wrote:

No problem.
Since the sql queries is done with geotools and not with "native" geoserver sources, what is the best way to play around with it? Get the geotools sources, apply my changes, compile the stuff and put the jars in an existing geoserver installation? Does this workflow work?

Stefan

-----Ursprüngliche Nachricht-----
Von: Chris Holmes [mailto:cholmes@anonymised.com]
Gesendet am: Dienstag, 29. Januar 2008 21:56
An: Ziegler Stefan
Cc: geoserver-users
Betreff: Re: [Geoserver-users] sql queries

Ah, right. I misread 'intersection' as 'intersects', I apologize.

Chris

Ziegler Stefan wrote:

I'm quite sure that it works :wink: 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 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
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> 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!

!DSPAM:4005,479f90f5204711628642973!

------------------------------------------------------------------------

-------------------------------------------------------------------------
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,479f90f5204711628642973!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,479f90f5204711628642973!

!DSPAM:4005,479f9582213101804284693!