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
0answers
17 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 ...
1
vote
1answer
37 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
26 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=******...
0
votes
1answer
34 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.
0
votes
0answers
25 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 ...
2
votes
1answer
72 views

QGIS GeoPackage

I have some shapefiles and want to store them in a GeoPackage. Therefore I use the save as function for every layer. In the export dialog window I select the storage path and the name of my GeoPackage....
1
vote
0answers
27 views

How to specify file format of Split Vector Layer in QGIS [duplicate]

I'm attempting to use the Split Vector Layer tool in QGIS (see screenshot below) in order to separate a larger shapefile into its constituent components by object ID. The tool accomplishes this ...
1
vote
1answer
35 views

Is there a fix for “sqlite3_exe(COMMIT) failed: database is locked” QGIS 3.6 Python 3.7

I am getting an error "ogr error committing transaction: sqlite3_exe(COMMIT) failed: database is locked" when trying to edit a feature on a geopackage layer using pyqgis. It is a QGIS plugin. ...
1
vote
0answers
25 views

When using QGIS Modeler with geopackages is there any way to Extract one Specific layer when using clip function?

I would like to use QGIS modeler to allow extraction of certain layers of a geopackage. I am trying to clip a geopackage containing multiple layers using modeler and when run it the output gives only ...
0
votes
1answer
29 views

Importing Virtual field in a geopackage

I have defined a virtual field to generate additional information in dependence of another attribute. Now I want to import the shape in a geopackage. I want to have the virtual field in the geopackage ...
4
votes
0answers
55 views

Working with QGIS 3 with styles stored in spatialite database

I am working in QGIS 3.4 with a geopackage file (SQLite database) containing orography information (points, lines and polygons). In QGIS, I have defined by hand a style for every layer in geopackage (...
2
votes
1answer
45 views

Merging two different geometry layers into one (SQL, GeoPackage)

I have a point layer ('points') and a polygon layer ('multipolygons') . I want to load the points layer combined with the centroids of the polygon layer. Im using GeoPackage and tryed to go a SQL ...
2
votes
1answer
58 views

Splitting vector layer into shapefiles (not geopackage) using QGIS?

Using QGIS 3.6.3, I have a layer with ten polygons. I want to use split vector layer to split the file into ten shapefiles, But the result output file is a Geopackage. How can I get ten shapefiles by ...
1
vote
0answers
49 views

Losing data when converting from GeoPackage to File Geodatabase in ArcGIS Pro?

I have a geopackage with 422k polygons. When using Copy Features to convert into file geodatabase only 215k features remain. When I select a small subset of data and copy this, polygons which was not ...
4
votes
2answers
76 views

Geopackage raster layer name is blank in QGIS Layers panel?

I added two rasters to QGIS: "site01.tif" and "site02.tif" then added them to a geopackage. When I drag the geopackage into QGIS, the geopackage layers display as expected but the layer names are ...
3
votes
1answer
38 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. ...
3
votes
2answers
69 views

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
75 views

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
47 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
37 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
53 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
33 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
35 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
96 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
31 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
37 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
59 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
100 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
53 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
31 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
52 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
46 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
95 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
32 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
57 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
39 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
110 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
60 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
150 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
74 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
15 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
65 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 (...
5
votes
2answers
238 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
65 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
513 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
198 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
69 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
34 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
149 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
72 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 ...