Skip to main content
Question

Geopackage writer

  • February 28, 2025
  • 3 replies
  • 44 views

karije
Participant
Forum|alt.badge.img+1

Hi All, I'm working to create GeoPackage file and when I create OGCGEOPACKAGE writer, all the user attributes are in lowercase and I can’t change them to become uppercase. is it because of the OGC standards change?

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+52

What version do you use? I tried to reproduce this in 2024.2 and 2023.2 but could not. When looking in the Changelog I found:

Fixed

Geopackage Writer: write attribute names as lowercase

2024.1

Build 24600


bwn
Evangelist
Forum|alt.badge.img+26
  • Evangelist
  • February 28, 2025

Yes, this was fixed in later FME versions and similar thread last year.   It seemed to have been a misinterpretation by Safe of the OGC Geopackage standard.  It recommends, but does not require, field names be created in lower case format.

The lower case recommendation in the Geopackage standard came from OGC thinking that this was the most reliable way to stop downstream GIS applications from breaking/behaving abnormally when connected to a Geopackage SQLite-based database.  But it isn’t a limitation of the Geopackage format itself, nor the Geopackage standard.

Similarly, user raising same issue last year confirmed fixed from memory in latest FME version (I just can’t seem to find the thread 😕 )


karije
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • March 2, 2025

The FME version that I’m using is 2024.1.


Reply


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