Hi Andrea, Sorry for the delay. I did a bunch of tests with the spatial functions in Geoserver and they tend to work best when each layer has the same native SRS. A good example is a CQL filter that intersects a layer in one native SRS with another in another native SRS. It does not seem to project on the fly. At least, from my tests I could not get it to work as expected. I'm happy to describe my tests more if interested.
After reviewing and testing Geoserver's capabilities for spatial queries, I decided to do all the spatial functions in PostGIS then output the results as a list of for a simple CQL filter (e..g "id=1 OR id=2...."). I like this approach because then I can use st_transform on each input layer so all are in the same coordinate system. Users can then throw any layer in any projection at the tool and it will just work (fingers crossed, of course). Thanks! Cliff On Fri, Feb 21, 2020 at 6:15 AM Andrea Aime <[email protected]> wrote: > On Thu, Feb 20, 2020 at 10:27 PM Cliff Patterson <[email protected]> > wrote: > >> I have a PG/PostGIS database containing layers in EPSG:26917 (UTM) and >> EPSG:4326. All layers are loaded into Geoserver and the declared SRS is >> 4326. For the layers in EPSG:26917 I reproject native to declared so all >> layers are in 4326 (Geoserver version: 2.15.1). I have a web application >> that loads the layers and I plan to use CQL filters to perform a range of >> functions, such as bbox selections. However, it seems that spatial CQL >> functions use the native SRS not the declared SRS. >> > > The declared SRS in the layer page you mean? That's odd, we have code to > reproject the filter from the declared SRS down to native before execution: > > https://github.com/geoserver/geoserver/blob/9406f0e93d8bef0da25df322ef9a7054d6d74ef0/src/main/src/main/java/org/vfny/geoserver/global/GeoServerFeatureSource.java#L441 > > In your case I assume you have the "reproject to native" SRS handling > since the two SRSs are pretty darn different right? > > Cheers > Andrea > > == > > GeoServer Professional Services from the experts! Visit > http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf > Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa > (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 > http://www.geo-solutions.it http://twitter.com/geosolutions_it > ------------------------------------------------------- *Con riferimento > alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - > Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni > circostanza inerente alla presente email (il suo contenuto, gli eventuali > allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i > destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per > errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le > sarei comunque grato se potesse darmene notizia. This email is intended > only for the person or entity to which it is addressed and may contain > information that is privileged, confidential or otherwise protected from > disclosure. We remind that - as provided by European Regulation 2016/679 > “GDPR” - copying, dissemination or use of this e-mail or the information > herein by anyone other than the intended recipient is prohibited. If you > have received this email by mistake, please notify us immediately by > telephone or e-mail.* > -- Cliff Patterson Ph.D. *PSD* | Senior GIS Consultant P: 519-690-2565 ext. 2616 www.psdrcs.com London | 148 Fullarton St. 9th Floor
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
