Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1968

Support OpenGIS Simple Feature Access SQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:
      None

      Description

      Support OpenGIS Simple Feature Access SQL. This is standard core functionality for spatial/geographical/geometry data, implemented by PostGIS and others.

      It basically consists of a GEOMETRY data type and about 150 functions whose names start with 'ST_', for example ST_GeomFromText and ST_Distance. H2 GIS has a good reference. (Look for the functions labeled 'OpenGIS 1.2.1'.)

      Adds a SqlConformance.allowGeometry() method to allow people to enable/disable this functionality.

      First commit will probably add a dozen or so functions, backed by a library such as ESRI Geometry API. I'd appreciate help implementing the rest.

      Spatial indexes are covered by CALCITE-1861 and are out of scope of this case. So with this feature, spatial queries will work, but predicates will be applied row-by-row.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: