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.

Filter by
Sorted by
Tagged with
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 ...