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.
4
votes
2answers
42 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
45 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:...
2
votes
1answer
41 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 ...
-2
votes
0answers
43 views
A new GIS rollout, what vector data format would you use? [closed]
I am going to be involved in rolling out a new GIS system across an organisation that uses a variety of different GIS formats, DWG, Shapefile etc.
They are moving to an ESRI stack and I am ...
1
vote
2answers
35 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
10 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
45 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 (...
2
votes
1answer
42 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
22 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 ...
1
vote
1answer
63 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
54 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
51 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
30 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
113 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
36 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
8 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
49 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
36 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
49 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
314 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
38 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
38 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
91 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
71 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
40 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
42 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
70 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?
3
votes
1answer
79 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
60 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
39 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 ...
0
votes
0answers
74 views
Clip all layers of a GeoPackage (GPKG) in one step
I would like to clip all layers of a GPKG-File to a given extend (canvas, mask layer, rectangle...) in one step. I could use clipping in batch mode but isn't there a nicer solution doing this in one ...
1
vote
1answer
140 views
Point disappears when zooming in - QGIS 3.4.1
I had a vector layer stored in GeoPackage format with a text field (lbl_text) that was being used to create labels on a map. After creating 3 points I decided it would be nice to rotate my labels, so ...
2
votes
1answer
109 views
How to use “Merge vector layers” in QGIS using Geopackages as output with FIDs duplicated
I'm using QGIS 3.2.3 in Windows and I created a tessellation with polygons (Voronoi tiling / Thiessen polygons) with the built-in tool "Voronoi Diagrams", (Call this layer LAYER1). Afterwards, I used ...
0
votes
2answers
65 views
Creating Custom Shapefile that can be snapped in location with no dragging using QGIS?
I am trying to create a custom shapefile consisted of 16 waypoints orientated around an origin point. the 16 waypoints are to be 2m apart from the central waypoint (like an axis, with 0 being the ...
2
votes
1answer
210 views
Query layer with leaflet-geopackage
I'm trying to find any documentation to help me understand and use the leaflet-geopackage plugin.
what I want to do is use the full potential of the .gpkg file as a database and query only part of the ...
1
vote
1answer
103 views
how to change encoding of a geopackage in QGIS 3
For other formats you just go to Label >> Properties >> Source and there's a clickable button to select from a list of locales; but this box is grayed out for GPKG, is there a way to change the ...
0
votes
0answers
49 views
Does Geopackage field length affect performance?
I have moved away from shapefiles, and now store most of my desktop spatial data in a Geopackage. One of my fields is used to store research notes and is 'Type TEXT' with a character limit of 254.
I ...
0
votes
1answer
187 views
How does QGIS 3.2.3 handle or create spatial indexes within a geopackage?
My frame of reference is:
Does QGIS automatically use spatialite spatial indexes?
This explain that QGIS uses QgsSpatiaLiteFeatureIterator for Spatialite Data Provider
Spatial indexes in GeoPackage ...
3
votes
1answer
2k views
How do I write a GeoPandas dataframe into a single file (preferably JSON or GeoPackage)?
I'm new to GIS and having a basic beginner problem. I've got data in the form of a geopackage .gpkg from GADM.org. I can read in and use the data without problem using Geopandas (via built-in Fiona)....
1
vote
1answer
172 views
Storing metadata in Geopackage for QGIS?
Is there a way to store metadata in a Geopackage along with the layer data?
I'm using QGIS 2.18.24. When you add or edit metadata via the "Metadata" pane of the layer's Properties, this is saved in ...
1
vote
1answer
59 views
Geopackages don't work on drive D:/
All of the Geopackages stored on one of my drives (D:/) appear to be corrupted, and don't work, but work fine if they are copied to another drive. The other file formats on the same drive all work ...
0
votes
1answer
73 views
Using ArcPy to produce lyr files pointing at geopackage?
I have hundreds of lyr files with a complex tree structure containing both layer groups and nested layers.
What I would like to achieve is to grab each lyr files, iterate through every single layer (...
3
votes
1answer
110 views
Inserting tags (multi-values) in field of attribute table with QGIS?
I am setting up a QGIS project using a Geopackage (or shapefile) concerning the areas named with some historical toponyms and writing a brief description of them.
In the attribute table I would like ...
0
votes
0answers
32 views
Analyze rasters in Geopackage?
Are the out-of-the-box geoprocessing tools in QGIS and ArcMap able to analyze rasters stored in a geopackage? Or do they need to be extracted to e.g. GeoTiff first?
I'm thinking, for instance, of ...
1
vote
1answer
38 views
Storing geometry from a layer into a geopackage file with geotools plugin
How can I store a geometry to a geopackage file?
FeatureIterator<SimpleFeature> fi = getLayer().getFeatureIterator((Envelope) null);
GeoPackage geopkg = new GeoPackage(...);
geopkg.init();
...
0
votes
1answer
119 views
Geoserver generated Geopackage not displaying in maps
We have a geoserver instance with Geotiff layers created as layers and mosaics.
When I query the geoserver to getMap as a png or image it displays the correct map data. When I change the output ...
1
vote
0answers
111 views
GeoServer GetMap with geopackage very slow (with high zoom levels)
I have a GeoServer instance and have imported multiple high res tiff files as layers and created a layergroup from the layers. When I call the WMS endpoint with a specified bbox and the geopackage ...
0
votes
0answers
151 views
QGIS does not seem to make use of spatial index when using GeoPackages
I have a QGIS project with several Geopackage-Layers.
The project is quite slow in comparison to a project with shapefile or database layers.
I started QGIS together with DebugView to find out what ...
1
vote
1answer
164 views
How do I insert rows into a spatial table within a geopackage file via a SQL INSERT statement?
I am attempting to insert rows into a spatial table within a geopackage file using DBeaver 5.1.1.
I receive an error from the triggers, referencing functions that don't exist: ST_IsEmpty. Do I need ...
2
votes
0answers
160 views
Does GeoPackage support simultaneous editing?
I am looking to move a mess of shapefiles to a newer format, either Spatialite or Geopackage.
I have read that Spatialite can handle multiple users editing the same file more or less simultaneously. ...
