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.
491
questions
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 ...
- 11
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 ...
- 57
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&...
- 11
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 ...
- 57
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,
...
- 129
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 ...
- 21
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 ...
- 13
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?
- 675
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 ...
- 103
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 ...
- 57.4k
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&...
- 1
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,743
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 ...
- 33
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 ...
- 105
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 ...
- 105
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