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
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 ...