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.
152 questions
3
votes
1answer
26 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. ...
2
votes
2answers
42 views
PyQgis : 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
55 views
+50
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
33 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
27 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
29 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 ...
0
votes
1answer
25 views
Cannot clip because “unable to open database file”. Do I need to create a geopackage from shapefiles, and if so, how?
I am working with some shapefiles in QGIS 3.2.1, and I would like to clip one shape file to another, and I am having the following error message.
Input parameters:
{ 'INPUT' : '.../Data/landcover/...
1
vote
0answers
26 views
Does ArcGIS support curves in geopackage?
When I export a featureclass to a geopackage (with spatial type 'geopackage') in ArcGIS 10.4, true curves are densified to lines consisting of many short straight segments.
Is this a shortcoming of ...
1
vote
0answers
38 views
Deleting vector layer from Geopackage using PyQGIS?
Programmatically I have added the vector layers to an existing Geo Package in QGIS 3.2 using python. Similarly, I would like to delete a layer from the existing Geo package using python code. But ...
0
votes
1answer
29 views
ArcGIS GeoPackage ArcMap Drawing Error [closed]
I am trying to understand the meaning of this error. I created spatial data using the sf package in R and wrote out the data as a GeoPackage (i.e. a .gpkg). However, whenever I add the data into ...
2
votes
3answers
32 views
View attribute (/field) names of a geopackage table without opening the whole file
I have a large geopackage file (15gb) for which I'd like to see the attribute (/field/column) names. Is this possible without loading the whole file?
Edit:
It would be ideal if there was a command ...
1
vote
1answer
51 views
What is the difference between geopackage and shapefiles? [closed]
I'm trying to figure out what Geopackages are and often I read "it's like a shapefile but not quite." Sometimes I also read that it's the equivalent to the ESRI Geodatabase.
What is the actual ...
3
votes
0answers
68 views
Does GeoPackage support topology?
Does GeoPackage support topology?
I am looking for resources that discuss this topic in more detail.
I googled and did not come across good resources that discuss this question in detail. I could ...
2
votes
0answers
38 views
Renaming attribute/field names in GeoPackage Layer using PyQGIS? [closed]
I need to rename the attribute field names in a GeoPackage layer by using Python QGIS 3.2.
0
votes
0answers
17 views
gdal_merge adds black borders
I'm using gdal_merge.py to merge a few GeoTIFF's into a GeoPackage. The source files are UTM33 projection, 3 bands (RGB) without Nodata tags. They make up a non-rectangular mosaic, so gdal_merge ...
1
vote
0answers
34 views
Very large GeoTIFF dataset to GeoPackage
I'm trying to mosaic a large GeoTIFF dataset into a GeoPackage with Gdalwarp
(no reprojection). There are 512 .tif files, each with a single 8-bit grayscale
band, and 1 meter resolution. I'm using -...
1
vote
0answers
36 views
Synchronisation problems using QFieldSync
When resynchronizing data from QField GPKG project to QGis SHP project, using QFieldSync, attribute data are shifted to the right column. There is a lag, I have never seen something like that before.
...
2
votes
0answers
63 views
Using geopackage trigger in Qfield
I tried to create triger in geopackage so one layer would get updated by data from the other, both in the same geopackage. It worked perfectly within deskop Qgis but I get this error message in Qfield:...
2
votes
1answer
24 views
Valid datetime in GeoPackage
I am adding spatial objects to a GeoPackage database. To register a new spatial table I use a formulation like:
INSERT INTO gpkg_contents
(table_name, data_type, identifier, description, ...
2
votes
1answer
35 views
Writing Non Spatial Table into Geopackage - Python
Just wondering how to write a non spatial (aspatial) table to geopackage using python. I have attempted using Fiona,
geopackage = 'some_geo.gpkg'
layer = 'test_layer'
schema = {'geometry': {'type'...
0
votes
1answer
29 views
Importing GeoPackage into GeoServer?
I've created a geopackage through gdal_translate (overviews with gdaladdo)
In geoserver 2.13/2.15 I can create the geopackage store with no problems, but then geoseverver won't fetch the tables/...
4
votes
2answers
86 views
Is a PK required for GeoPackage vector layers?
According to geopackage.org's "Getting Started With GeoPackage" guide, features are stored in user-defined data tables. It seems like it says that these tables require a primary key:
Other than the ...
2
votes
2answers
57 views
FME Search Envelope error when using Geopackage?
I try to use FME Search Envelope to clip my data smaller. Unfortunately it interrupt all after few seconds.
I am using GeoPackage, is it fatal problem to use FME:s search envelope?
2019-03-14 14:43:...
3
votes
1answer
102 views
Rename layer in gpkg using QGIS or PyQGIS?
I have a gpkg of several layers. How can I rename them in the gpkg as well as in the QGIS layers list?
Basically, I have layer foo in my QGIS project, whose source is filename.gpkg|layername=foo. I ...
1
vote
2answers
57 views
Does GeoPackage impose a maximum number of (non-geometry) columns per feature?
Working in R, I tried to write a simple feature file with 402 rows and 1170 columns (only one geometry column) and got the following error:
> dim(sf_object)
## [1] 402 1170
> sf::write_sf(...
1
vote
0answers
13 views
Geopackage drops fields during import [closed]
When I use the ogr2ogr -f command to create a geopackage the first layer imports correctly but every layer after that drops fields. Can anybody explain why it does this?
1
vote
1answer
58 views
Why can't I reproject geopackage layer from WGS84 to ETRS89/UTM (QGIS3.6)
I accidentally digitized a layer (geopackage) in WGS84 (EPSG 4326). Now I need to reproject it into ETRS89/UTM zone 32N (EPSG 25832). I tried it in different ways which usually work without a problem (...
4
votes
2answers
199 views
Geopackage - select on geometry column returns null
In DB Manager in QGIS 2.18.26
I want to select geometries in geopackage table.
The returned geometry column is null but the source layer can be loaded as a geometry table in Qgis and i can read the ...
0
votes
1answer
35 views
How to specify GPKG Driver in GDAL/OGR under C++?
Working under CentOS (Linux), we have run up against the 4GB shapefile (dbf) limitation in our Monte Carlo model. We've decided to switch to GeoPackage to output our point attributes. I cannot find a ...
2
votes
1answer
250 views
QGIS 3: How to rename attribute/field names for Geopackage Layer
Issue: I need to rename several attributes/fields in a geopackage layer. How to do this?
Linked Issue: there are numerous pages on how to rename the attributes/fields of a shapefile. However there do ...
1
vote
1answer
128 views
Create geometry column in Geopackage with SQL
How to create a table with geometry column that is recognized as spatial layer? I use the DB manager from QGIS 3.4.2
I use the following:
CREATE TABLE 'sample_attribute_with_geometry' (
id INTEGER ...
0
votes
0answers
62 views
What is difference between BLOB and tile in GeoPackage?
I'm new to GeoPackage, but wrote some code that will read an image file into a buffer and I then insert that buffer into the GeoPackage as a BLOB.
The image files are GeoTIFFs which contain latitude, ...
0
votes
0answers
32 views
Working with CAD-import in QGIS
I'm working with QGIS3 and I imported a CAD-File (.dwg). Now, its in Geopackage format, but I made somehow a mistake by importing it, cause I'm not able to work with the different layers. They are ...
6
votes
1answer
133 views
CRS information not recognized when geopackage is loaded
I am starting to transition from .shp to geopackage data format in QGIS. There are many benefits to the format that give it an advantage over shapefile for many of my projects. However, I am having a ...
0
votes
1answer
57 views
Changing srs-definition string in geopackage with ogr2ogr
When creating a geopackage with ogr2ogr in WGS84 (EPSG:4326), the srs-definition string cannot be interpreted correctly when loading the data into ArcGIS. ArcGIS does not project the data corretly ...
0
votes
0answers
13 views
GEOMETRY error when trying Tegola with a geopackage
I get an error saying "Error: could not register providers: unsupported geometry type: GEOMETRY" when trying to tegola_windows_amd64_cgo version 0.8.1 on a geopackage file. The gpkg file contains only ...
0
votes
1answer
88 views
QGIS 3.4 Geopackage Raster Handling and DB Manager
I just discovered a little mytery on Geopackage rasters and QGIS 3.4:
- Exporting a img-Raster into a Geopackage works fine - also opening it
- Opening the this "geopackage raster" in ArcGIS Pro 2.3....
0
votes
1answer
126 views
How to populate a feature table in a GeoPackage file using GDAL?
I want to use the binary version of GDAL to avoid programming in C or Java here. So I have created a SQL file and I want to run it using the following command :
ogrinfo.exe empty.gpkg -sql @...
0
votes
0answers
87 views
QGIS Projects and files between multiple computers
I currently run QGIS on my laptop and Mac. On my laptop I keep my Geopackage and project files in a folder on my hard drive. I have Goodsync setup to backup this folder to a shared drive on my NAS. I ...
2
votes
1answer
732 views
Open GPKG embedded layers in python
I have a gpkg with multiple tables, and I am trying to load it with geopandas:
import geopandas as gpd
filename = '~/example.gpkg'
gdf = gpd.read_file(filename)'
This returns the first table/layer ...
3
votes
1answer
47 views
How to export a unique ID field of a geopackage
When I am converting my geopackage file in shapefile, the unique ID field is not exported. I could duplicate it before exportation, but I wanted to know if it could be done in one step, in order not ...
0
votes
1answer
74 views
Can a Geopackage style be deleted through SQL window in DB Manager?
I am trying to clean up a Geopackage and as part of this I would like to delete some styles from the "layer_styles" table. I have tried doing this with the below query in the SQL window of the DB ...
2
votes
1answer
206 views
QGIS 3 Python Load all layer from geopackage
I am loading all layers from a geopackage in a QGIS 3 canvas in Python using a list with all layernames and the following code:
databasepath = "X:/test.gpkg"
layer = ["1","2","3","4"]
for i in ...
0
votes
0answers
94 views
GeoServer Exception When Publishing A Layer Based On A Geopackage Store
I exported a map from MapTiler to a GeoPackage, and created a store in GeoServer for it. When I tried publishing the layer based on that store, I got the following exception:
org.apache.wicket....
0
votes
0answers
113 views
OGR Python: Copying features from one datasource to another works with shapefile but not with geopackage
I have a shp/dbf EPSG4674 input datasource, and I want to copy features from one layer of this input datasource, create a new output datasource and write these features to that output datasource.
As ...
1
vote
1answer
54 views
Are there limitations how many layers there should be in a geopackage?
Are there limitations how many layers there should be in a geopackage?
It is advantageous to allocate layers into groups to several gqkg, instead of only one gqkg. (I work with approx. 50 layers.)
2
votes
2answers
79 views
GUI for managing GeoPackage (and other geodata forms)?
I know that the browser in QGIS has quite a bit of capability for managing GeoPackages and other geodata, but I was wondering if there was a lightweight, standalone tool similar to ArcCatalog?
5
votes
1answer
96 views
How to prevent gpkg size increase when I delete attributes?
I have a file, polygons.gpkg that I am using in QGIS. Its original file size is 48MB.
When I do nothing except delete a handful of the attribute table's fields, I expect the file size to decrease. ...
1
vote
1answer
67 views
Geometry based automatic fill of fields in attribute table
I'm looking for solutions for auto-fill attribute table fields of spatial layer on QGIS from updates in geometry.
All layers were created as polygon shapefiles. Attribute table fields are dependent ...
1
vote
1answer
50 views
How to maintain data types in QGIS when importing from PostGIS?
I have data stored in an AWS RDS PostgreSQL database with the PostGIS extension enabled. When I connect to the data from within QGIS (2.18.2) the data types are not preserved. For example a column of ...
