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.
194
questions
0
votes
0answers
4 views
Append different geometry to layer within GeoPackage
I have a layer with lines - I export it qith QGIS to a new geopackage. A second layer with the same table structure but containing polygons should go into the same geopackage and preferably into the ...
1
vote
0answers
31 views
Foreign Keys in Geopackage
How to create foreign keys and cardinality in a Geopackage with QGIS or FME? It's easy to get the tables, but how can I set the relations between the tables?
-2
votes
0answers
24 views
Geopackage in Postgresql [on hold]
I am a beginner to learn Postgis, Postgresql and Geopackage. I have read a lot of documents on the web about them, but it's specialized. Can everyone explain help me what are they? and how are they ...
4
votes
1answer
110 views
Reading GeoPackage with large number of features is very slow
I'm running a project which provides OpenStreetMap data on a global scale as GeoPackages. The data is created/transferred from a PostGIS database to GeoPackage by ogr2ogr.
Issue: Initially reading of ...
1
vote
1answer
69 views
Georeferencing DWG using QGIS?
I am using QGIS 3.4.11 on Windows 10 x64.
I have three large DWG files that are the output of a survey (each roughly 5MB). No problem to import them into QGIS as geopackages using the built in DXF/...
2
votes
0answers
39 views
Use QGIS for collaboration on a Geopackage on Google Drive [closed]
We have a few peoples working on a small QGIS project using Geopackage as the main data storage. The GeoPackage is stored on a share Google drive. By working I mean reading for now but looking for ...
2
votes
1answer
43 views
Adding feature to geopackage layer and regenerating primary key using PyQGIS?
I have an existing geopackage layer in my QGIS project. I want to duplicate a feature on the layer via PyQGIS:
layer = iface.activeLayer()
layer.startEditing()
sourcefeat = next(layer.getFeatures()) ...
1
vote
0answers
30 views
How to rename a geopackage table in Python?
I'm trying to rename a geopackage table from a QGIS 3.8.0 Python processing script.
But it leaves a broken dataset in 2 parts, where the tabular data table has been renamed but leaves the geometry ...
1
vote
1answer
21 views
Standalone python script - Qgis - QgsVectorLayer points to wrong feature class in gpkg
GPKG file has multiple featureclasses in it. I create a layer to a specific featureclass using QgsVectorLayer but it always points to the first FC in the gpkg file.
This is a stand alone python ...
1
vote
0answers
28 views
Can QGIS load filtered layers on open from geopackage file?
I have some external processing (FME from SAFE software) which generates a geopackage file with a set of tables.
Is it possible to load a set of filtered tables from a geopackage file when opening ...
2
votes
0answers
27 views
Copy multiple rasterfiles into geopackage
I have a folder with ~100+ raster images which covers my study area (the data comes in .ecw or .tiff, i have both at hand). How do i get them into one geopackage without having to go the export -> ...
0
votes
0answers
26 views
Calculating shortest route in Geopackage/SQLite
Are there any graph analysis tools written for a SQLite database? What I'm looking for is something akin to pgRouting but for SQLite. I can't find anything with a significant user base, which is ...
1
vote
0answers
44 views
Sharing GeoPackage for collaborative work (web, ftp, cloud…) [closed]
I would like to share a GeoPackage as part of a GIS project (QGIS) with one of my customer. Only the customer will edit the GPKG.
I could use a cloud service like Google, Dropbox or pCloud. But that ...
1
vote
1answer
30 views
Transforming a GeoPackage table's geometry column into GeoJSON?
I have a GeoPackage that is downloaded to client devices for a mobile app. I need the clients to query the GeoPackage to retrieve a GeoJSON representation of the geom column. I'm familiar with ...
3
votes
1answer
44 views
Where is attribute form widget saved
When i create widgets for the attribute form in the properties of a layer:
Is this stored in the geopackage layer or in the QGIS project file?
1
vote
0answers
47 views
Create SQL View in GeoPackage in GeoServer
In GeoServer 2.15.2 I can "publish" an entire layer from a GeoPackage. No issues there, works great.
However, If I attempt to "Configure a new SQL view..." using that same layer in the GeoPackage (...
0
votes
1answer
34 views
Prevent GeoPackage from saving when it is not edited in QGIS
So in QGIS, GeoPackage will be automatically saved when it is read even if you didn't edit. How to avoid this from happening?
1
vote
0answers
26 views
Multiple attribute layers with same geometry in geopackage with ogr2ogr
I have multiple PostGIS tables I want to export to a single gpkg file. The tables have identical schema, and identical geometries -- the numerical attributes differ. How do I create a gpkg file, using ...
3
votes
2answers
133 views
QField Points to PostGIS DB
QGIS Desktop 3.6.2.
PostgreSQL/postGIS: PostgreSQL 10.5 on Windows x86-64
Server hosting PostgreSQL: Windows Server 2012 R2
Android on Nokia 6.1
QField App
QGIS Plugins: QFieldSync
I'm trying to save ...
0
votes
1answer
43 views
Multiple entries of same layer in Geopackage
I have a geopackage database of many layers which I have added and deleted over time. I think because of that, I get several entries of the same layer. For example when I use the statistics tool, I ...
2
votes
2answers
172 views
Export all layers of GPKG to Shapefile with QGIS 3.x
Is there a way to export all layers of a GPKG (Geopackage) database to shapefiles in ONE STEP? Or just a selection? It's a lot of work to export all layers one by one.
1
vote
1answer
45 views
How to change the Coordinate System of an Existing Table in a GeoPackage?
While writing some data to a GeoPackage, I set the wrong Coordinate System.
The Actual Coordinates are in a Particular UTM System, but the Table has been set as having data in EPSG:4326.
How do I ...
2
votes
0answers
39 views
Possible bottleneck in QGIS 1:n relation?
I've set up a 1:n relation linking two layers of the same geopackage. That are about 200k polygons in parcels and 700k rows in owners (non spatial). Now it works as expected but it is painstakingly ...
1
vote
0answers
30 views
Adding raster layers to an existing GeoPackage in R
I have a GPKG file with a few vector layers. I have a few processing steps in my script and every now and then a new layer is added to the file. This works fine for vector layers using something like
...
2
votes
0answers
26 views
Error while deleting field in geopackage using QGIS 3.4.2
I have a geopackage file and I would like to delete a field. I run into unexpected behavior.
My process:
Open QGIS
Add gepackage layer
Open attribute table
Enable Edit mode
Click remove field
...
0
votes
0answers
99 views
GPKG and GPKG-WAL - not sure if main process finished
I am performing ZonalStatistics (mean value from a Float32 virtual raster) in QGIS 3.4 on a huge geopackage layer. Originally it was 240 GB and after few days the process became odd:
The QGIS process ...
2
votes
1answer
62 views
Is there any way to reorder layers in GeoPackage and change the default naming in QGIS?
I have successfully saved several layers in one GeoPackage in QGIS 3.8. This is how it looks like in DB manager:
I found out that the ordering of the layers is somehow strange when loading the GPKG ...
2
votes
1answer
46 views
Adding a Geopackage layer as a hardwired input to an algorithm in the QGIS graphical modeler
I have a geopackage layer that I want to always be used in an algorithm in the QGIS 3.6 graphical modeler. When I use the triple dots to navigate to the geopackage it doesn't give me the option to ...
1
vote
0answers
18 views
Loading rasters from a GeoPackage into QGIS modeler based on attribute information?
I am looking to load raster layers from a GeoPackage based on strings of attribute information that is stored in a field. The process I am looking for is as follows:
Site Boundary created before the ...
0
votes
1answer
33 views
Saving default layer name to spatialite/geopackage table?
I'm a huge fan of being able to save default symbology to spatialite/geopackage tables, however, I don't like that when I import a table as a layer it takes on the name "database name table_name".
...
1
vote
0answers
32 views
Geopackage vector data type
I am reading a shapefile in Python using geopandas, join some tabular data and export to geopackage using geopandas.
The entire process is very easy. However, when I export the vector data, the file ...
1
vote
1answer
63 views
Create view table with QGIS and Geopackage
Working with QGIS 3.4.9 and Geopackage. I created a View table. The command runs without errors, the view is created but does not appear in QGIS. What do I need to do?
1
vote
1answer
101 views
ogr2ogr write multiple layers to one geopackage
I'm using ogr2ogr to write a SQL query from PostGIS to a GeoPackage in a linux shell.
Query by Query to many GPKG:
ogr2ogr -f "GPKG" point.gpkg PG:"host=localhost dbname=data user=user password=******...
2
votes
2answers
112 views
QField does not open Raster.gpkg?
Qfield cannot load GeoPackage raster data exported with Qgis 3.8.0. Download vector data from the gpkg file. The test with a single raster file in a GeoPackage also failed.
0
votes
0answers
35 views
Saving symbology in GeoPackage with ArcMap?
I'm working with a GeoPackage file containing polygons in ArcMap 10.6.2
I have hundreds of different classes symbolized one by one that I have stored in a LYR file.
It could be possible to save all ...
3
votes
1answer
98 views
QGIS GeoPackage
I have some shapefiles and want to store them in a GeoPackage. Therefore I use the save as function for every layer. In the export dialog window I select the storage path and the name of my GeoPackage....
1
vote
0answers
32 views
How to specify file format of Split Vector Layer in QGIS [duplicate]
I'm attempting to use the Split Vector Layer tool in QGIS (see screenshot below) in order to separate a larger shapefile into its constituent components by object ID. The tool accomplishes this ...
1
vote
2answers
86 views
Is there a fix for “sqlite3_exe(COMMIT) failed: database is locked” QGIS 3.6 Python 3.7
I am getting an error "ogr error committing transaction: sqlite3_exe(COMMIT) failed: database is locked" when trying to edit a feature on a geopackage layer using pyqgis. It is a QGIS plugin. ...
1
vote
0answers
41 views
When using QGIS Modeler with geopackages is there any way to Extract one Specific layer when using clip function?
I would like to use QGIS modeler to allow extraction of certain layers of a geopackage.
I am trying to clip a geopackage containing multiple layers using modeler and when run it the output gives only ...
0
votes
1answer
34 views
Importing Virtual field in a geopackage
I have defined a virtual field to generate additional information in dependence of another attribute. Now I want to import the shape in a geopackage. I want to have the virtual field in the geopackage ...
6
votes
0answers
100 views
Working with QGIS 3 with styles stored in spatialite database
I am working in QGIS 3.4 with a geopackage file (SQLite database) containing orography information (points, lines and polygons).
In QGIS, I have defined by hand a style for every layer in geopackage (...
2
votes
1answer
62 views
Merging two different geometry layers into one (SQL, GeoPackage)
I have a point layer ('points') and a polygon layer ('multipolygons') . I want to load the points layer combined with the centroids of the polygon layer.
Im using GeoPackage and tryed to go a SQL ...
3
votes
1answer
147 views
Splitting vector layer into shapefiles (not geopackage) using QGIS?
Using QGIS 3.6.3, I have a layer with ten polygons. I want to use split vector layer to split the file into ten shapefiles, But the result output file is a Geopackage.
How can I get ten shapefiles by ...
4
votes
2answers
81 views
Geopackage raster layer name is blank in QGIS Layers panel?
I added two rasters to QGIS: "site01.tif" and "site02.tif" then added them to a geopackage. When I drag the geopackage into QGIS, the geopackage layers display as expected but the layer names are ...
3
votes
1answer
51 views
Data source not found when opening .qgs file
I am using QGIS 3.6.1 with the new geopackage (.gpkg) format. When some of my co-workers open my .qgs-file, QGIS (same version as mine) does to not find the data source for most of the layers. ...
3
votes
2answers
96 views
Write two layers to geopackage
I am trying to write two layers into geopackage without success.
from qgis.PyQt.QtCore import *
def drawLay ( namee, x1, y1 ) :
lay = QgsVectorLayer('Point?crs=epsg:2039', namee , 'memory')
...
3
votes
1answer
113 views
Including metadata when importing features into GeoPackage using ArcGIS Desktop?
After much frustration reading vague documentation and getting obscure errors I managed to create a GeoPackage using ArcMap v10.6.1 and import features into it.
I was very happy until I discovered ...
1
vote
1answer
60 views
Some OSM tags in polygons and some in points - how to bring them together
Tagging objects in OSM can sometimes be done as polygon or as point. For example ruins or museum
So far so good, but finding a specific object in a osm-dataset makes it necessary to look into the ...
0
votes
0answers
47 views
Getting error while adding few layers to GeoPackage using PyQGIS?
I get error message when trying enter few layers to geopackage using PyQGIS 3.6.2.
This is my code:
from qgis.core import QgsVectorFileWriter
options = QgsVectorFileWriter.SaveVectorOptions()
...
1
vote
1answer
118 views
How to create table with geometry column in GPKG with spatialite?
I want to create a vectorial GPKG with spatialite.
With the help of the documenation (here: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html#p16gpkg ), I've created a sql script that look ...
