New answers tagged geopackage
0
As @Francisco Puga's answer states, the issue is likely EXIF rotation, which QGIS' native display does not support.
If you want a workaround that fixes this on the fly, by rendering the image in HTML and QML, see my question and the several answers at Display photo stored as blob in GPKG, even though this is for an earlier version of QGIS.
Note any such on-...
2
Commonly images have some metadata embed on it called "EXIF" data. This metadata contains information about things like when the picture was taken or the "orientation" of the image.
Many software like the file explorer in Windows or Linux, or image viewers read this data to automatically rotate the image according to the EXIF orientation ...
0
You need to save/export your layer to a new layer.
Right Click -> Export -> Save features as
You will not have the same problem in the new layer.
4
The easiest way to save a vector layer to GeoPackage is to use the native:savefeatures algorithm, available from QGIS v3.16 on.
params = {'INPUT': existing_layer,
'OUTPUT': '/tmp/new_gpkg.gpkg',
'LAYER_NAME': 'new_layer_name'}
processing.run("native:savefeatures", params)
Note that you can pass additional GDAL/OGR options by ...
3
You should add the following
options.layerName = 'your_wanted_name'
Found by looking at QgsVectorFileWriter::SaveVectorOptions (C++ doc)
0
ArcGIS 'support' for geopackages is - vague and a bit limited. Unfortunately I have been down this path and encountered too many issues to reasonably suggest that ArcGIS and Geopackages will exist to a level which would allow them to totally replace proprietary ESRI file formats.
Needless to say, it looks like ArcGIS does not populate the metadata tables of ...
3
The short answer: how to solve the problem
There are at least three possibilities (screenshot for solution 1 and 2 at the bottom):
In the export/save dialog, expand Select fields to export and their export options and de-select the existing fid from export (uncheck the box). QGIS will automatically create a new fid-field with unique values.
In the export/...
6
Ogr2ogr can convert with one run all the tables that are given in the command as a list
...input.gpkg layer1 layer2 layer 3
If no layers are given in the command then all layers are processed. Layer is an optional parameter as documented in https://gdal.org/programs/ogr2ogr.html
dst_datasource_name src_datasource_name
... [layer [layer ...]]
If all ...
2
I just created an empty point geopackage file and refactored the fields. I cannot reproduce this problem in QGIS 3.18.2-Zürich.
Update: Indeed, when the text field is filled with values - refactoring converts fid to int8.
Top 50 recent answers are included
