Skip to main content
Solved

What versions of OGC Geopackage and SQLite does FME produce ?

  • November 11, 2022
  • 2 replies
  • 47 views
lifalin2016
Contributor
Forum|alt.badge.img+29

I'm having a hard time determining which version of OGCGEOPACKAGE that FME produces ? It's not in the writer doc, so I'm asking here.

And subsequently, what version of SQLite is produced? (newest is 3.39.4 from Sep 29 this year)

As far as I can gather, the versions has been fixed since 2020.0? Is this true?

In the "gpkg_extensions" table I found a reference to "spec120", which may (or may not) indicate, that the Geopackage version is 1.2.0, a fairly old version (newest is 1.3.1).

And the real question is what extensions are the SQLite database born with? Clearly not "foreign _keys".

Can one update some template database if one needs a newer version/more extensions?

Cheers.

Best answer by evieatsafe

Hi @Lars I Nielsen​ thanks for your questions! There is more than one question here, but I'll try to answer most of what you asked to the best of my ability.

 

  • GeoPackage Writer produces version 1.2.0 because we are limited to the version that GDAL supports
  • We do have an internal ticket (FMEENGINE-75532) to track the upgrade of the GeoPackage Reader/Writer to 1.3.1 when support becomes available
  • The OGC GeoPackage version that we support is better documented by OGC themselves (here).

 

  • SQLite Writer produces version 3.36.0
  • Not sure on what extensions they are created with

 

Hope this helps!

View original
-- Cheers, Lars I.
Did this help you find an answer to your question?

2 replies

evieatsafe
Safer
  • evieatsafeSafer
  • Safer
  • Best Answer
  • November 18, 2022

Hi @Lars I Nielsen​ thanks for your questions! There is more than one question here, but I'll try to answer most of what you asked to the best of my ability.

 

  • GeoPackage Writer produces version 1.2.0 because we are limited to the version that GDAL supports
  • We do have an internal ticket (FMEENGINE-75532) to track the upgrade of the GeoPackage Reader/Writer to 1.3.1 when support becomes available
  • The OGC GeoPackage version that we support is better documented by OGC themselves (here).

 

  • SQLite Writer produces version 3.36.0
  • Not sure on what extensions they are created with

 

Hope this helps!

Happy to help - Evie
gedgg
Contributor
Forum|alt.badge.img+1
  • gedggContributor
  • Contributor
  • December 5, 2024
  • SQLite Writer produces version 3.36.0
  • Not sure on what extensions they are created with

 

has there been update on this?

 

Thanks

Reply


Helpful Members This Week

Community Stats

31,347
Posts
118,893
Replies
38,962
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.