sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexís Manin (Jira) <j...@apache.org>
Subject [jira] [Created] (SIS-515) CRS management for SQL/PostGIS filter
Date Wed, 07 Jul 2021 14:27:00 GMT
Alexís Manin created SIS-515:
--------------------------------

             Summary: CRS management for SQL/PostGIS filter
                 Key: SIS-515
                 URL: https://issues.apache.org/jira/browse/SIS-515
             Project: Spatial Information Systems
          Issue Type: Bug
          Components: Storage
            Reporter: Alexís Manin
            Assignee: Alexís Manin


When using the `sis-sqlstore` datastore upon a PostGIS table with a geometry column,

if a bbox filter is applied on a FeatureSet, its conversion to an SQL clause for it ignore
any CRS information. In this case, the resulting clause is wrong, apart for the case where
the CRS is already aligned.

 

We must at least try to write geometry SRID when possible (so, use [EWKT format|[https://postgis.net/docs/ST_GeomFromEWKT.html]).]

 

Otherwise, when we can determine a common CRS in advance (most likely the one of the implied
geometry column for optimisation purpose), we could try to reproject before-hand the literal
filter (if any).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message