Uploaded image for project: 'Spatial Information Systems'
  1. Spatial Information Systems
  2. SIS-515

CRS management for SQL/PostGIS filter

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.1, 1.2
    • 1.5
    • Storage
    • None

    Description

      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).

      Attachments

        Activity

          People

            amanin Alexís Manin
            amanin Alexís Manin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 48h
                48h
                Remaining:
                Remaining Estimate - 48h
                48h
                Logged:
                Time Spent - Not Specified
                Not Specified