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.
209
questions
3
votes
1answer
48 views
Adding many raster tiles to geopackage
I have many raster tiles (in tif format, SR WGS84) and, since all together are very heavy, I want to unify them in a geopackage.
I've tried to do that in QGIS, performing the following steps:
...
1
vote
0answers
32 views
QGis 3.4: GPKG vector layer with object form (relations with spatial and non-spatial datasets) to postgres database
I have QGis project with a geopackage included. One layer in the geopackage contains a attribute form with relations to other layers (spatial and non-spatial). I have to convert it to a postgres ...
1
vote
0answers
21 views
GeoServer problem zoom levels
I have created the layer (geopackage data file) and when I do layer preview from, don't appeared tiles in the different zoom levels. Also I have tested in QGIS and everything is ok. Attached case you ...
6
votes
1answer
126 views
How Can I write Geopackage Layers with Abstract/Description/Metadata using QgsVectorFileWriter
How can I use the QgsVectorFileWriter to include metadata description for Geopackage layers in a python script?
I can set the layer name using:
options.layerName = "roads_layer"
what I want is ...
1
vote
1answer
37 views
Exporting Geopackage table to directory as CSV with PyQGIS
I have the following extract from a PyQGIS script showing the final function. This script actually form part of a plugin tool for QGIS. I create three geopackage layers and save them into the chosen ...
2
votes
1answer
36 views
Updating GeoPackage records with R
I'd like to update records of a GeoPackage containing vector information in R. I've tried this:
library(sf)
library(RSQLite)
nc <- st_read(system.file("shape/nc.shp", package="sf"))
# Write Geo ...
0
votes
0answers
31 views
Overwriting geopackage with Python
I have a QGIS project file with a few geopackage vector layers. Each of them is stored in its own file.
I created the files using Python. Now I am considering updateing the files per script. Can I ...
6
votes
4answers
409 views
Reading geopackage geometries in Python
Let me state up front that I'm totally new to the field of GIS. I'm doing a project involving a database of buildings and their geometries in my home country (the Netherlands). At the moment, I'm ...
1
vote
0answers
26 views
Geopackage from maptiler in geoserver
I'm faced those days with geoserver.
I have an .gpkg file created by maptiler and want to create a layer on geoserver. The geoserver version was 2.16 and the geopackage mosaic is integrated on this ...
1
vote
0answers
40 views
QGIS: Saving TIF as Geopackage raster loses NoData cells
Background:
At 3.8.3, I right-click a TIF DEM (single-band, 32-bit floating point) and Export > Save As to a Geopackage raster.
If I use all default settings in the Export > Save As window, the ...
0
votes
0answers
58 views
Is it possible to query a geopackage (.gpkg) for features within a given bounding box?
I have GIS data with a very large layer stored within a geopackage from where I want to select features that fall within a bounding box calculated in my R session. I begin by creating a query string:
...
0
votes
1answer
29 views
Reading GeoPackage file with GeoTools: Error on missing gpkg_contents database
I am trying to read a GeoPackage file using GeoTools with:
GeoPackage gp = new GeoPackage(new File("myFile.gpkg"));
FeatureEntry fe = gp.features().get(0);
SimpleFeatureReader fr = gp.reader(fe, ...
2
votes
1answer
33 views
How do I read a layer from a .gpkg file whilst selecting on an attribute?
I have a GeoPackage (.gpkg) database with only one layer:
ogrListLayers("data/LM_data/zipped/ay_riks.gpkg")
[1] "ay_riks"
attr(,"driver")
[1] "GPKG"
attr(,"nlayers")
[1] 1
There are too many objects ...
0
votes
0answers
59 views
Reading GeoPackage file bigger than RAM size with GeoPandas?
I have a gpkg file that's around 10GB, and 8GB of RAM. So, if I were to read my file:
import geopandas as gpd
fp = "/path/to/my/file.gpkg"
data = gpd.read_file(fp)
print(data.shape)
My computer ...
8
votes
1answer
137 views
Spatialite spatial queries do not function on GeoPackage
I have downloaded some data (as GeoPackages) from this excellent website: https://data.mfe.govt.nz/layer/52757-petroleum-wells/ and https://data.mfe.govt.nz/layer/52675-location-and-extent-of-nzs-...
0
votes
0answers
21 views
Use gdal_grid with geopackage
I'm using gdal_grid to interpolate IDW mode with points in GPKG format but I don't know how to write the sequence. I'm using the following code:
gdal_grid -zfield "z" -a invdist:power=2.0:smoothin=1....
1
vote
1answer
40 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
59 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?
5
votes
1answer
254 views
Reading GeoPackage with large feature classes 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
101 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
63 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
80 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
41 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 ...
2
votes
1answer
28 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
33 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
35 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
35 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
59 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
39 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
49 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
59 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
54 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
34 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
350 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
57 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 ...
3
votes
3answers
733 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
57 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
46 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 ...
2
votes
0answers
47 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
32 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
115 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 ...
3
votes
2answers
130 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 ...
3
votes
1answer
63 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
19 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
41 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
35 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 ...
2
votes
1answer
102 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
246 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
145 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.
1
vote
0answers
46 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 ...
