Questions tagged [geopackage]
GeoPackage is an OGC format for vector, tiled and raster data, plus associated metadata, built on top of SQLite. It is described as the modern alternative to formats like SDTS and Shapefile.
451
questions
0
votes
0
answers
9
views
'QGIS Processing Executor'_Issue: "sqlite3_open ... unable to open database file"
Trying to run a self built-in QGIS-model (*.model3) using the followoing 'QGIS Processing Executor' (qgis_process) command in the command line does not work.
C:\Program Files\QGIS 3.24.1\apps\Qt5\bin&...
- 1
0
votes
1
answer
35
views
PyQGIS script (.py) runs correctly on Windows but not on Mac
I wrote a script that takes a vector layer already present in my QGIS project and refactor fields as I wish.
I created the script to avoid doing plenty of times the same refactorization manually every ...
- 47
0
votes
1
answer
29
views
GDAL loop through gpkg layers
I've a gpkg with several vector layers inside, i'd like to build a spatial index for each
I'm using very simple gdal/sql process:
ogrinfo -SQL "SELECT CreateSpatialIndex('gis_layer_01', 'geom')&...
- 91
0
votes
1
answer
59
views
Handling too many geopackages in QGIS
I have been using this 3.24 for a month or more. Now that I am using it, I have created every project using this one.
I am facing an issue with this version (not sure if this problem is only for this ...
- 1
0
votes
0
answers
28
views
Exporting all layers from folder holding temporary layers as gpkg using PyQGIS
I tried exporting all temporary scratch layers residing in a projects specific folder using PyQGIS as .gpkg format, also to mention that exported .gpkg files have to be visible in the project after ...
- 493
0
votes
0
answers
29
views
Obtain CRS compliant WKT from GeoPackage with ogrinfo
I would like to obtain the WKT for a few geometries stored in a GeoPackage file with orginfo. That is the function of the -al parameter. However, when applied directly to the file in question it ...
- 3,664
3
votes
1
answer
103
views
GeoPackage, SQLite: features count but don't exist (QGIS)
GeoPackage is my favorite geo-format but I also have some strange behaviors. One of them: I delete all records/features within a table using QGIS -> Delete Features or SQL statement but there are ...
- 7,663
1
vote
0
answers
29
views
Different number of records in gpkg vs. shapefile after join
I'm using pyqgis 3.10.1.and trying do Spatial join with one-to-many option for points and multipolygon. After processing result shows me too low number of records. I save results to geopackage but ...
- 31
0
votes
0
answers
18
views
Can Rasterio python package read/open rasters stored in a Geopackage? [duplicate]
I've searched a lot and I couldn't find any code sample using rasterio to open rasters stored in a Geopackage.
If someone knows anything about this topic, I would be greateful if the knowledge could ...
- 105
1
vote
1
answer
57
views
How can I read a raster in a Geopackage with python?
I'm having a hard time trying to read (with python) a raster that I've saved in a Geopackage.
I thought there would be a simple like rasterData = rasterio.open(gpkgPath, layer='DEM'), but when I run ...
- 105
4
votes
2
answers
196
views
Geopackage in QGIS: Search and replace in all attribute fields at once
The context
I have a Geopackage file opened in QGIS. It was created by importing a CSV file. However, when importing, something regarding encoding went wrong: I have several special characters like ...
- 40k
0
votes
0
answers
11
views
Geopackage Arc Geometry in ArcGIS Pro
I have a question regarding the Geopackage Geometry circular arc within ArcGIS Pro 2.7:
Within the information it is stated that following geometries are supported:
What can you do with a GeoPackage ...
3
votes
2
answers
65
views
Merging/Dissolving multiple layers in QGIS Virtual Layer
I have several polygon layers that I would like to merge and dissolve within a virtual layer in QGIS. So that any changes made to the individual layers will automatically update in the merged/...
- 33
0
votes
0
answers
76
views
How should we display GeoPackage on Mapbox GL JS?
We used wgrib2 to convert weather radar data into NetCDF format. We converted it to GeoPackage format using gdal_translate. We created a Color Map on QGIS 3.10 and the GeoPackage appeared as expected.
...
- 101
0
votes
2
answers
43
views
Loading specific layer by its name from GeoPackage
How can I load a specific layer by its name from a GeoPackage into the project. I tried the graphical model designer, but it always loads a layer from the geopackage and labels it with my layer name (...
- 159
0
votes
0
answers
88
views
Importing shapefile into a geopackage not working in QGIS 3.24.1
Whenever I try to import any kind of .shp file (with any kind of geometry) to any gpkg database, it gives numerous errors, such as:
Error 7 Failed to load layer
or
Error 5
Failed to create fid field (...
- 1
2
votes
1
answer
65
views
Virtual-Layer/SQL-View: SQL to get list of all values in a group (SpatiaLite/GeoPackage) [closed]
I have a GeoPackage-Table and it's looking like that:
id data
-- ----
1 A
1 A
1 B
2 A
2 B
3 B
3 B
I need a virtual layer or a SQL-View that should look like that:
id data
--...
- 7,663
1
vote
0
answers
57
views
Repairing corrupted geopackage
QGIS doesn't recognize a geopackage ("invalid source"), DB Manager connects to the gpkg but doesn't find the file ("file not found") when trying to open.
The software DB Browser ...
0
votes
1
answer
30
views
Unable to make GeoPackages and MBTiles compatible in MapTiler Cloud using gdal_translate
I'm using gdal_translate to convert TIF files to GeoPackage and MBTiles. The geopackage/MBTiles are uploaded to MapTiler Cloud. They upload to MapTiler Cloud even if they are not "clean tileset&...
- 1,127
2
votes
1
answer
46
views
Deleted Layer in Geopackage still visible in QGIS
I have created a multitable Geopackage as a Database. After some work, I decided to replace one layer with a different layer, so I created a new layer and deleted the old one via the DB-Manager in ...
- 1,446
1
vote
0
answers
61
views
Save GeoPandas geodata frame into a file including symbology to open in QGIS [closed]
I'm working in Python with the GeoPandas library, and I would like to save GeoDataframes into shapefiles or geopackage files with symbology.
I've read that in QGIS, it is possible to save the ...
0
votes
1
answer
54
views
Reset fid in GeoPackage table
Is it possible to reset the fid of my GeoPackage table so it begins with value '1' again after clearing the table?
The background is: I have a more or less complex table I would like to "reuse&...
- 7,663
-1
votes
1
answer
40
views
SQL statement for count of different ranges [closed]
In QGIS, I want to make a SQL-statement which should return the counts of different year ranges e.g. in column 1 should be the total count for distinct values for all years, in column 2 1950-1990, in ...
- 851
0
votes
1
answer
50
views
setAlias doesn't work on geopackage
I'm trying to add multiple fields to a geopackage layer and set their aliases at the same time. It is working on a temp layer but not on the geopackage, why?
lyr = iface.activeLayer()
p = lyr....
- 51.3k
4
votes
1
answer
120
views
QGIS Geopackage saves layers in wrong order
I would like to save my file as the .geopackage file. Unfortunately, I've noticed that the order of the layers is not correct. It doesn't correspond to the order in the "Layers" panel.
I saw,...
- 3,594
8
votes
1
answer
115
views
Meaning of maximum field length of 0 for GeoPackage in QGIS
I have looked around for the answer, but have not found anything reliable.
When creating a new layer or new fields in a GeoPackage one sometimes has to enter the parameter Maximum Length, sometimes ...
- 1,446
4
votes
1
answer
91
views
QGIS 3.22 sorting by attributes does not work in gpkg-files
Since I updated from QGIS 3.16 to 3.22 I have the following problem in attribute tables: in gpkg files the sorting option (alphabetical) does not work - sometimes!
I tried it with projects in qgz- or ...
- 309
2
votes
1
answer
22
views
Deleting entries (duplicates) from a GPKG using OGR
I tried to delete duplicates from a GPKG file using ogr2ogr and a SQLite statement from SO:
ogr2ogr -sql "DELETE FROM layer WHERE rowid NOT IN (SELECT MIN(rowid) FROM layer GROUP BY ...
- 3,215
5
votes
1
answer
101
views
Automatically fill in attributes of parent feature in QGIS
I have a data table that holds different information about buildings in a GeoPackage. Different elements of the buildings can be entered, e.g. sometimes I only have the building as a whole, sometimes ...
- 1,446
6
votes
1
answer
254
views
Renaming GeoPackage layer to be the same as GeoPackage file
I have a GeoPackage file that has been renamed, but the layer inside the GeoPackage keeps the original name, is it possible to automatically put the same name on the layer as the file?
Example:
...
- 744
0
votes
0
answers
30
views
Save/convert geopackage to DWG
Is there a way to save data from a geopackage to a DXF/DWG without saving each layer to a DXF in the process and then stitching them together in CAD?
- 621
1
vote
1
answer
72
views
QGIS / QField wrong entry from value relation
I am absolutely puzzled what went wrong here:
I am setting up a project in QGIS 3.16.11 which should be taken into field with QField 1.11 in order to collect data about the local situation concerning ...
- 13
0
votes
0
answers
78
views
Shape integrity error
I'm working with a vector layer (from a geopackage) which I would like to convert to a raster layer. However, when I convert it certain parts just disappear. If I scroll through the attribute table ...
- 75
7
votes
1
answer
127
views
Is it possible to restrict using IDs already used on a different layer in QGIS?
I am working on a rather complex data model for a GIS-project in QGIS 3.16.3. The entire data model is stored in one single geopackage. Different layers are used to represent different geometry types ...
- 1,446
2
votes
0
answers
39
views
Batch embed SVG markers to geopackage
I have recently converted my QGIS project with more than 70 layers to a GeoPackage in order to be able to hand the project over to other persons and computers. The project includes over 100 SVG ...
- 675
3
votes
0
answers
129
views
Unable to open Geopackage on QGIS : .gpkg is not a valid data source
I am trying to open two files, they are both coming from this source :
[https://geoservices.ign.fr/rpg#telechargement][1]
(Two first links that I downloaded through FileZilla).
But once the unizpping ...
- 567
1
vote
0
answers
49
views
Importing and applying style stored in GeoPackage
I'm trying to use a GeoPackage to store a collection of styles - the idea is that each map sheet (it's a geological map) comes as a series of shapefiles, and of course each shapefile require its own ...
- 374
0
votes
0
answers
47
views
How can I change the geometry of a Geopackage
I have a Geopackage that has a geometry field geom. I updated the field successfully with SQL: SET geometry=MakePoint(555985,5755607,25832)
But for some reason the geometry type is set to ...
2
votes
0
answers
45
views
Get file path of Geopackage with PyQGIS [duplicate]
I want to get the Geopackage file path where my layer is stored in.
Layer = QgsProject.instance().mapLayersByName('DAT')[0]
print(Layer.source())
But this only gives me the path with layer pointer:
/...
- 457
3
votes
1
answer
122
views
Change to field name of gpkg layer not retained using ogr
I am trying to update the names of the fields in a gpkg layer using the ogr Python package. I have gotten most of the way using this answer to another question on the subject using SetName on the ...
- 33
0
votes
0
answers
43
views
Can ArcGIS Desktop read label properties in geopackages created in QGIS?
Can ArcGIS Desktop read the labels, including the label placement and label formatting, in geopackages created in QGIS?
- 19
2
votes
0
answers
120
views
Create a empty geopackage with PyQGIS
I'm trying to create a new GeoPackage with an empty layer in it. I tried this code from this answer.
from qgis.core import *
from qgis.PyQt.QtCore import QVariant
QgsApplication([], False)
...
0
votes
0
answers
35
views
Adding new field to one attributes table based on the field on another attributes table in QGIS
I have two Geopackage layers on QGIS 3.22.2. One first one (LAST_ROUTES) shows the random extracted lines (routes) from the Istanbul highway map. Second one (LAST_POINTS) shows the points generated on ...
- 329
2
votes
1
answer
87
views
SynchronizeFromQField just opens the QField project
I am using QField with QGIS. I don't understand the purpose of the tool Synchronize from QField.
I successfully created a QGIS project with relative paths (with data from a geopackage), successfully ...
- 21
0
votes
0
answers
49
views
Storing Metadata in GeoPackage using GeoPandas or Fiona
I would like to store some metadata in a GeoPackage file. The metadata would be relevant to the entire file, not just to each individual geometry. An example might be assigning license text or ...
2
votes
1
answer
44
views
Modifying Timestamps in QGIS
As it is seen in the picture, I have the attributes table which shows the random extracted routes from Istanbul highway map and points on it. Points are uniformly distributed through 2000 random ...
- 329
3
votes
1
answer
68
views
What are the GeoPackage metadata conventions supported in GeoServer?
I'm trying to find information on how best to write metadata into a multilayer GeoPackage so that it can be read into a GeoServer instance.
My chain of treatment would be to:
Modify layers in an ...
- 1,393
6
votes
1
answer
103
views
First added layer loses its symbology when adding the same layer twice but with different names using PYQGIS QgsProject.instance().layerTreeRoot()
I’m trying to insert the same layer from a GPKG several times to the same QGIS project. I’d like to give it different names first as well as symbology and filters afterwards.
The code below works for ...
- 188
0
votes
1
answer
74
views
Copy a Geopackage to another folder using PYQGIS
I try to copy a GPKG to another folder. The result is the correct named copied GPKG but there is only one layer in the copy. It’s the layer with the same name as the GPKG. The other features (1x ...
- 188
0
votes
0
answers
29
views
Crash when using vertex tool to move elements with categorical symbols from multiple layers (gpkg only)
I have been battling with a crash occuring when I move several vertices from multiple layers using the vertex tool. QGis hangs for a while and then needs to be interupted.
The Qgis consol displays no ...
- 1