halestudio / hale

(Spatial) data harmonisation with hale»studio (formerly HUMBOLDT Alignment Editor)
143 stars 44 forks source link

[BUG]: Geopackage reader: For Geopackages containing a boolean field, the value 'true' is read as '1' #1223

Open JohannaOtt opened 2 months ago

JohannaOtt commented 2 months ago

Describe the bug When importing a geopackage file containing a boolean field with true values, the values are read as 1

To Reproduce Steps to reproduce the behavior:

  1. Go to Import source schema and import the attached geopackage as schema
  2. Go to Import source data and import the geopackage as source data
  3. Rightclick on BoolField in the Schema Explorer and open the Properties
  4. Chose the section Occurring values
  5. Click the refresh button and the occurring values - it is 1

testExportFlo.zip

Expected behavior I would expect the occurring value to be true as this is the value I assigned to the field when creating the geopackage file with hale»studio.

Additional context I am using Version 5.1.0. release Build 202402261605 Revision 883baf4ade99dbe0acdacc84b9492eb98444ecd9

When loading the data to QGIS, the value is true as expected which is why the error must be in the Geopackage reader, not the writer.

github-actions[bot] commented 1 week ago

This issue has been automatically marked as stale because it has not had activity in the last 60 days. It will be closed in two weeks if no further activity occurs. Thank you for your contributions.