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