Skip to main content
Question

Read geometry from Sqlite

  • October 30, 2023
  • 2 replies
  • 146 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.

gpt_geoinfo
sigbets

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

gpt_geoinfo

Community Stats

32,120
Posts
121,954
Replies
39,772
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility 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.