Skip to main content
Question

Read geometry from Sqlite

  • October 30, 2023
  • 2 replies
  • 194 views
marketa
Contributor
Forum|alt.badge.img+2

Hello,

 

is it possible to read geometry from Sqlite in FME 2023? In FME 2022 I was using SQLite Spatial (GDAL) (deprecated), but I'm missing this format in the new version.

 

Thank you.

    2 replies

    david_r
    Celebrity
    • david_rCelebrity
    • October 30, 2023

    Try using the SpatiaLite reader/writer:

    https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/spatialite_native/spatialite_native.htm

    marketa
    Contributor
    Forum|alt.badge.img+2
    • marketaContributor
    • Author
    • Contributor
    • October 30, 2023

    I tried this format and it did not work. I'm still having the same problem that the geometry is not read:

    imagewhen using SQLite creator with the same query, the geometry is read properly in FME 2022:

    image

      Community Stats

      32,751
      Posts
      124,208
      Replies
      41,263
      Members
      Terms & ConditionsAccessibility statement
      A product of
      Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.