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
1 vote
1 answer
18 views

Using GDAL/OGR to remove a specific layer from a geopackage

Is there any way to remove some layers from geopackage instead of creating new geopackage with only layers I need. Example:- I have a geopackage containing: Bars (Point) Bars_reprojected (Point) ...
1 vote
0 answers
29 views

QGIS won't open ANY shapefile or geopackage

Running a clean install of QGIS 3.22.10 on a Lenovo laptop running Windows 10. I cannot open any shapefile. Every time I try to open one I get the following error message: Invalid Data Source: xxx.shp ...
  • 19
0 votes
0 answers
22 views

Using multiple geopackage vector layers in modeler

I reproduce a project with the qgis graphic modeler, as it turns out some steps needed to be repeated in the future, maybe by less experienced GIS users and also for documentation purposes. However on ...
  • 53
0 votes
1 answer
52 views

Command line tool to convert vector GPKG to PNG

I have around 30,000 vector .gpkg files that I'd like to convert each to a .png or .jpg file. Is there any command line tool that does this? I tried GDAL but it did not work: $ gdal_translate ...
  • 129
7 votes
1 answer
231 views

Can I start QGIS with a project from a GeoPackage?

I can save a QGIS project within a GeoPackage, which is nice since it can include the data too. But can I start QGIS (from the command line, or otherwise on GUI systems) such that it gets the project ...
  • 53.8k
1 vote
0 answers
33 views

QGIS 3.10 problem with uploading Geopackage uploaded vector layers shown displaced

I am trying to upload a Geopackage file containing various vector layers into my project (currently using QGIS 3.10). Uploaded layers are shown as if they were displaced on the base map of Google ...
1 vote
0 answers
24 views

Add image/photo as Blob to a geopandas dataframe and then save to a geopackage *.gpkg

Trying to switch from doing this through spatialite, and fully containing it within geopandas. I have a file with the image's file locations in it, and loop through them all. Open each image and add ...
  • 151
2 votes
1 answer
38 views

Properly closing GeoPackage after opening by OGR so as to delete it later

I am creating a program that downloads a GeoPackage from online, opens it, makes a copy of the first layer as a shapefile, and then (hopefully) deletes the GeoPackage. However, I'm not able to delete ...
  • 688
3 votes
1 answer
89 views

Opening QGIS project says layers not available

I created a QGIS project with four geopackage layers for an uni project. I made sure to include all four geopackage layers in the same folder as the QGIS project and then zipped it to send it to my ...
  • 31
0 votes
1 answer
25 views

Create view and display in QGIS of a spatial table in geopackage or SpatiaLite

I need to create 4 views of a spatial table in a geopackage or SpatiaLite (no preference at the moment). I tried with geopackage, but the view is displayed as a datatable and not displayed as a layer ...
  • 343
2 votes
2 answers
37 views

Incorrect geopackage field type when exporting via GeoServer

When downloading geopackages via GeoServer from the data provider datamap.gov.wales (e.g. this one) I get a geopackage containing the designation_date field, which is marked as TIMESTAMP. The raw WFS ...
  • 6,484
1 vote
0 answers
34 views

Unable to import raster into geopackage in QGIS

Whenever I try to import a raster layer in the form of a geotiff into a geopackage in QGIS I just end up getting a black area with no values. Am I not importing the raster properly or do geopackages ...
1 vote
0 answers
12 views

Issue with geopackage syncing - geometries not populating in QGIS after sync (Qfield 2.2.1/QGIS 3.22.4)

I have a geopackage I have created and followed all steps I did last time I used QField--when packaged for offline editing, the geopackage from QGIS gets changed from "test" to "data&...
0 votes
0 answers
26 views

QGIS adds layer to GEOPACKAGE layer but displays "could not find layer"

I have noticed something strange when merging layers (not matching attribute tables) together. When I try this QGIS responses 'Export in vector data failed. Could not find layer.' So far so bad. When ...
  • 389
0 votes
1 answer
26 views

QGIS/GDAL Python- Export WMTS to geopackage raster, only for set extent and resolution

The problem: I need to export imagery from a WMTS or XYZ webtile source for a variety of geographically dispersed areas. It will be used in Qfield, so needs to exported as a geopackage raster. In ...
  • 188
2 votes
0 answers
50 views

Newly created multipolygon layer fails to save due to large file size

I used the function "Join attributes by location" to join a number of polygon circles (a multipoylgon layer) with the values of the points (multipoint layer) that are "contained" ...
  • 33
0 votes
0 answers
27 views

Create Spatial Index from geopackage not working

I downloaded BGT data from https://www.pdok.nl/introductie/-/article/basisregistratie-grootschalige-topografie-bgt- in QGIS 3.24.2-Tisler. I can't clip this data and get a message: 'no spatial index ...
0 votes
1 answer
36 views

Avoiding malformed images serving raster data from GeoServer with a Geopackage store

I'm attempting to use the Geopackage format to serve raster data in GeoServer 2.21.0 (OpenJDK 11 on Ubuntu) and am getting odd results when using layer preview or WMS GetMap to view the data. (Since I ...
  • 101
1 vote
1 answer
32 views

Correct syntax for filtering of geopackages (SQL)

I already asked about this topic, but I am still struggling. I created a geopackage with railways of Germany. I need to filter some sections out. I understand that geopackages work with SQL syntax for ...
  • 389
3 votes
1 answer
46 views

Can a Geopackage Boolean field contain a NULL value?

QGIS 3.24.3. When I create a Geopackage Boolean field, the default display is the word false, displayed in italics. Likewise, if I calculate the Boolean field = NULL, they also display as an italic ...
  • 7,080
1 vote
0 answers
60 views

Why will Geopandas not read geopackage into dataframe? [closed]

I am trying to read in a geopackage as a dataframe using Geopandas. I am using Python 3.8, Geopandas 0.10.2, and Fiona 1.8.20. The geopackage I was using to test this is publicly available in any of ...
  • 1,729
1 vote
1 answer
53 views

Changing color of all layers in geopackage at once in QGIS

For a project I am working in QGIS all the layers within a geopackage need to be the same color. Is there a way I can change the color of all the layers to same color simultaneously or do I need to ...
0 votes
0 answers
20 views

Is it possible to force a GeoPackage to have same coordinate reference system for all tables?

At the creation of GeoPackage, is it possible to define one CRS for every table in GeoPackage? so that later it won't be possible to have layers with different CRS in the same GeoPackage?
  • 1,527
1 vote
1 answer
58 views

PyQGIS : QgsVectorFileWriter.writeAsVectorFormatV3 export Z dimension not working

I am trying to make a plugin for QGIS using pyQGIS. I would like to make a script that export the Z dimension (with offset) using this snippet: QgsVectorFileWriter.writeAsVectorFormatV3( vl, ...
0 votes
0 answers
22 views

ogr2ogr's sql works with small number of inputs to filter geopackage, but doesn't with large input

I have a .txt file that has all the features I want to select. It looks like this in the small version: ('100mN25991E46719','100mN25993E46718','100mN26000E46712','100mN26002E46691','100mN26003E46700','...
  • 717
0 votes
0 answers
81 views

GeoPandas doesn't read FID column from geopackage

I'm trying to open a geopackage with GeoPandas. From QGIS I can see three columns into FAT as you can see below: I expect to see the same columns when I open these data with GeoPandas, but is not so. ...
2 votes
1 answer
74 views

Batch importing shapefiles to geopackage as separate layers using QGIS

I have ~60 shp files with biological data (1 per species) and it would be useful to be able to have these in a single geopackage. I can export them individually and set the layer to the species name ...
1 vote
1 answer
138 views

"Changing feature ID of feature 123 is not allowed" when saving a GeoPackage (.gpkg) layer in QGIS

I have been editing making some attribute and geometry edits to a GeoPackage layer, and when I go to save the changes, I get the above error for 8 features. This error apparently prevents me from ...
1 vote
0 answers
110 views

Export a postgis table to geopackage using the DB database manager in QGIS

I am working in QGIS through the DB Manager by running some spatial queries. After I create new tables with the queries I need to export the tables as new geopackages. I've tried using the Export to ...
3 votes
2 answers
184 views

How to create non spatial index for geopackage data

I know QGIS/GDAL can create a spatial index for data in a geopackage. But what about non spatial data, how do I create an index for a non spatial data column using QGIS/GDAL for a geopackage data set?
3 votes
1 answer
46 views

Can I organize a Geopackage similarly to the structure of a geodatabase?

I've been looking all over the Internet if there is a way to organize a geopackage similar to a geodatabase, that is, to create multiple groups (similar to feature datasets in a gdb) within the ...
  • 31
2 votes
1 answer
49 views

Use ogrinfo to get names from column and count rows of large(ish) geopackage

I think this is a really silly question, yet I can't solve it quickly now: I want to work with this rather large geopackage: https://data.statistik.gv.at/data/...
  • 717
5 votes
1 answer
64 views

Feature without geometry in Geopackage layer

I am working on a QGIS project where I have a layer called "Developments" within a Geopackage document. The layer is a polygon layer where I add all renewable energy projects within my ...
3 votes
1 answer
75 views

Corine landcover Geopackage for Germany only

I've downloaded the CLC from https://land.copernicus.eu/pan-european/corine-land-cover/clc2018?tab=download as a geopackage because I could not find geopackages for just Germany. Thus the datasize is ...
  • 389
3 votes
2 answers
157 views

Exporting several layers as GeoPackages at same time in QGIS

I have dozens of temporary Layers. I'd like to export them all as GeoPackages, but I am unsure how to go about doing so without doing each one individually. I was reviewing this code Exporting several ...
1 vote
1 answer
115 views

Convert gpkg to OSM using ogr2ogr

I tried converting .osm file to .gpkg file and it works just fine, like this: $ ogr2ogr output2.gpkg somefile.osm 0...10...20...30...40...50...60...70...80...90...100 - done. but when I reverse it ...
  • 764
6 votes
1 answer
85 views

Compound primary keys prevents QGIS updates

I have a problem with a selected table in a geopackage database. QGIS is preventing updates only, from happening on a particular table, in this database. QGIS is preventing editing of values, via the ...
  • 2,953
1 vote
1 answer
148 views

Exporting feature class from GDB into GeoPackage using ArcGIS Pro

I am using ArcGIS Pro 2.7. I'm trying to export a feature class from an ESRI GDB into a GeoPackage using the following geoprocessing tools/methods, and all seem to fail: Connect to SQLite (Geopackage)...
  • 2,218
6 votes
0 answers
47 views

Exporting Geopackage converts milliseconds of QDateTime to zero

I use this solution to display actual QDateTime value with milliseconds in a temporary memory layer. And I use another solution to export as CSV the value including the millisecond value. But then, I ...
2 votes
1 answer
324 views

DriverError when reading GeoPackage with geopandas

I develop an import system that supports popular geoformats. Sometimes I get a DriverError reading GeoPackage files with geopandas, but at times it works well. My code is simple: gdf = gpd.read_file(...
0 votes
1 answer
91 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&...
0 votes
1 answer
48 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
117 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
83 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
75 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 votes
1 answer
157 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,753
1 vote
0 answers
38 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 ...
0 votes
0 answers
19 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 ...
1 vote
1 answer
203 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 ...
4 votes
2 answers
236 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 ...
  • 44.9k

1
2 3 4 5
10