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.
272
questions
0
votes
1answer
23 views
Using GeoPandas generated .gpkg in ArcMap
I am using GeoPandas to create .gpkg files. Using GeoDataFrame.to_file()
When opening the files in ArcMap, it takes a long time updating the file extent. Files already have an spatial index as this is ...
0
votes
2answers
20 views
GeoServer (GeoPackage) + Leaflet [closed]
I have placed 10 geopackage files locally on GeoServer. I also added a plugin for vector tiles. Tell me the code to open them via Leaflet and that when you click on the object there is information.
0
votes
0answers
24 views
Joining geometry tables in GeoPackage using SQL
I want to join two geometry tables (table1 containing and table2) inside the same GeoPackage and eventually two tables in two separate GeoPackage. Just to be clear, when I open the GeoPackage in QGIS, ...
1
vote
1answer
16 views
Use ogr2ogr to filter GeoPackage by geometry type
I have a GeoPackage that has features of different geometry types (Point & Polygon, see below) on the same layer. How can I filter all polygons from the file and create a new GeoPackage using ...
2
votes
1answer
36 views
Sharing QGIS projects with Geopackage connections
I've built a QGIS template project that I'm using for repetitive municipal projects that I'm sharing with other users on the local network, the layers are organized and stylized within geopackage ...
1
vote
0answers
17 views
Open only part of a GeoPackage layer with a certain geometry type in GeoPandas
I have a GeoPackage (743 MB, zipped) that has one layer, but two geometry types inside that layer (Point and Polygon). When I open the file in QGIS 3.10, QGIS presents a dialogue to me that lets me ...
1
vote
0answers
25 views
QGIS: How to avoid using coalesce() in GPKG query layer for correct type casting?
I query the following layer via DB Manager:
select fid, geom, cast((field2*100/field1-100) as double) as dev from table
field1 and field2 are integers and have NULL values. Now in the DB manager's ...
3
votes
2answers
82 views
Any potential problems backing up open GeoPackages using Python routine
I'm looking at creating a simple backup routine, using standard Python, to backup my GeoPackages.
The routine needs to be flexible enough to be able to backup the geopackage, whilst it is open (in ...
2
votes
0answers
50 views
Database compatibility between QGIS and ArcMap [closed]
I'm picking up ArcMap having started off in QGIS. I've been struggling for a while now to make databases that both QGIS 3.10 and ArcMap 10.7 can read and write. It seems ArcMap imposes much stricter ...
2
votes
0answers
44 views
Using Geopackages and Drive in QGIS
I have been working with geopackages at a company where we have all our data sync in a drive. The thing is that when I save a project, QGIS creates an extra geopackage with the same name as the ...
2
votes
1answer
30 views
GDAL GeoTIFF to GeoPackage overview building failed error
I have multiple GeoTIFFs in UTM projection. I need to create GPKG SQLite databases. I noticed that some (Example3) conversions are failing with overview error. What is cause for the failure ? How ...
3
votes
0answers
46 views
Writing layer to Geopackage using PyQGIS
I have a PyQGIS script which carries out a number of operations on layers and writes the results to Shape files. However I understand that GeoPackages have a number of advantages (not having multiple ...
1
vote
0answers
19 views
Features with geomety issues or unexpected CRS in Geopackage tables
In my project I've been asked to make some data validations to GeoPackage tables previous to start processing the data. I'm doing this with FME Dekstop.
Among other properties I should validate that ...
2
votes
1answer
27 views
Save 1-band-raster to geopackage results in 4-band-raster
I have a 1-band-raster (geotiff) and want to export it to a geopackage in QGIS 3.14. When I do that (right-click --> export --> save as), it results in a 4-band-raster. How can I prevent that?
0
votes
1answer
40 views
Writing the table layer_styles in a Geopackage
I made a pyQGIS script to backup the PostGIS tables of my team. I needed to save each table style in the Gpkg's layer_styles.
Here's an extract of how I've done but I would prefer to implement the ...
3
votes
2answers
60 views
Extracting catalog consisting of name of layerdata/table of different geopackages
Currently we have an organizing and tracking of files problem.
Right now we have our geodata organized in different geopackages (.GPKG files) for specific areas.
The problem is that the amount of ...
1
vote
1answer
28 views
Save QGIS project to GeoPackage using PyQGIS
How it is possible save qgis project to GeoPackage in PyQGIS?
the image is user interface but I need in code
2
votes
1answer
107 views
How to read geometry from gpkg?
I have a gpkg file. I trying to open it with spatial_lite gui and cast geometry to GML.
select AsGML(geom) from MyTable
but i got null. I tried another functions AsText(), AsWKT(), st_asText()... but ...
2
votes
1answer
27 views
Importing existing .gpkg files to create new Geopackage layer using QGIS
I'm a new QGIS user running 3.14.0 on a Mac with Mojave 10.14.6. While following along with this tutorial (https://www.youtube.com/watch?v=kCnNWyl9qSE), I reached around the 22 minute mark and ...
0
votes
1answer
41 views
How do you pull EPSG:4326 tiles from GeopackageJS using OpenLayers 6?
I'm trying to leverage GeopackageJS for use in a mapping application using OpenLayers 6, but the documentation seems to be really iffy-- the link to the API documentation actually 404s and the ...
1
vote
0answers
42 views
QGIS 2.14.9 refuses to open GeoPackage file
I tried to open in QGIS 2.14.9 a .gpkg file but this action resulted in an error message stating that the file is not a valid or recognised data source. However, QGIS includes support for the ...
3
votes
0answers
36 views
Multiple styles for GeoPackage
I am constructing a geopackage from vector layers that have values for number of years, each year is an attribute (1965, 1995, 2025, 2055, 2085). I have styled the layers and added the styles to the ...
0
votes
0answers
17 views
Maintaining Form Designs with one Geopackage to Multiple Different Projects
Long time reader, first time poster.
I work for an Archaeological consulting company in Australia and one of the major parts of our job is to go out and survey for aboriginal heritage sites before ...
1
vote
1answer
82 views
QField and Inputapp with PostgreSQL available on the internet
I have been using both tools in field work, making use of forms to facilitate filling in information using spatial databases in geopackage format. It has worked very well, but we have to take care to ...
1
vote
0answers
24 views
Create attribute field on a geopackage with precision using QGIS 3.4 [closed]
On a QGIS geopckage when I create a new field for decimal numbers, I can only create it as a decimal (real). So it populates the field with many decimals as shown. I don't mind having more decimal ...
0
votes
0answers
28 views
Read geopackage in Matlab
How do I load geopackage (https://www.geopackage.org/) in Matlab. I am trying to replace the shapefiles with geopackage due to several limitations inherent in shapefile.
1
vote
0answers
29 views
Modify columns data type when importing from CSV to GeoPackage with PyQGIS
I'm trying to import several CSV files into a GeoPackage using PyQGIS when opening a project as described in this question using this code:
from qgis.core import *
from qgis.utils import iface
import ...
0
votes
0answers
34 views
Well Known Binary GeometryCollection for GeoPackage doesn't show in QGIS
I wanted to test QGIS/GeoPackage with the Well Known Binary for: WKBGeometryCollection(WKBMultipoint(WKBPoint, WKBpoint))
I was guided by the document "OGC 06-103r4" for Geopackage and generated the ...
1
vote
1answer
88 views
Importing CSV table to geopackage with PyQgis using CSV file name
I'm trying to import some CSV with the same name of the file in a geopackage using PyQGIS before opening a project, but what I'm using doesn't work
I'm using this code:
from qgis.core import *
...
3
votes
1answer
54 views
Loading style from GeoPackage with PyQGIS
Reading the documentation I do not understand how the the row in layer_styles is specified (and why a table name has to be given)...
layer.loadNamedStyleFromDatabase('/path/to/geopackage/','...
-1
votes
1answer
69 views
PyQGIS control creation Atlas Layout
I have an Atlas Layout and the process of creating the JPG or PDF is very long, and that is why I would be interested in the program informing me what file is being created at that moment and how much ...
1
vote
0answers
31 views
QGIS: Creating a layer group in a geopackage: to group layers and tables with a value relation
Currently I have all my layers and tables group inside a geo package, these also have some style settings including value relations to have choice lists with multiple choices and filtering.
The ...
0
votes
0answers
32 views
Virtual layer with st_buffer from geopackage layer
I'm trying to make a virtual layer that has a buffer over a layer of lines.
If I run the following query on a layer in shapefile it works correctly
create view river as select st_buffer(geometry,50) ...
0
votes
0answers
39 views
getting convert X and Y to lat and long
I have a table called IK_TEMP and it contains columns called data, range .
String sql = "SELECT DATA, RANGE FROM IK_TEMP";
try (Connection conn = this.connect();
...
0
votes
0answers
52 views
Copy tables from Server Database to a Geopackage with no geometry and with geometries using PyQGIS
I am making an application in PyQGIS that uses tables that are on an SQL server.
I want to make a copy of all those tables in a local Geopackage, because I want to use my application in my laptop ...
2
votes
0answers
31 views
Delete content from vector files stored in Geopackage
I have packaged a group of vector files (shapefiles, 30-ish) into a Geopackage database including styles, with a view to being able to use that GPKG as a standardised template with containers for ...
1
vote
2answers
67 views
Convert a polygon geopackage into a multi-polygon geopackage in QGIS
I have a series of polygons in a geopackage file of QGIS polygons. Is it possible to transfer the contents of this file to another geopackage that has multipolygons as vector data type?
I need to fix ...
0
votes
1answer
140 views
Convert GeoPackage to ESRI shapefile format
I learned that to convert a DWG file with all its layers from AutoCAD to an ESRI shapefile format in QGIS, one has to first import it as a GeoPackage, and then convert it from a GeoPackage to a ...
0
votes
1answer
40 views
GeoPackage to Shapefile export
When creating a GeoPackage vector layer in QGIS 3.10.x, it provides the following geometry types: Point, Line, Polygon, Multipoint, MultiLine, MultiPolygon, CompoundCurve, CurvePolygon, MultiCurve, ...
1
vote
0answers
55 views
PyQGIS: Problems with deleting attributes from Geopackage-Layer
I am struggling with a rather simple task.
While trying to delete an attribute field from a Geopackage-Layer (Polygon and Multipolygon) I encounter results I can't understand.
My Geopackage a.gpkg ...
0
votes
1answer
43 views
How to create a vector layer from loaded layer from GeoPackage?
Firstly, I load layers from gpkg (GeoPackage). Secondly, I need to create a vector layer from one loaded layer which is named stops.
Second point I cant do it, because I need to mark a column, that ...
1
vote
1answer
28 views
How to specify output table name in GeoPackage when using ogr2ogr
I want to convert a GeoJSON file to a Layer within a GeoPackage.
For this, I'm trying to use the following command:
ogr2ogr dist.gpkg mah.geojson -nlt PROMOTE_TO_MULTI
This sucessfully creates a ...
2
votes
1answer
87 views
QGIS: OGR error when editing Geopackage layers : database is locked
I started to draw new polygons in a layer within an existing GeoPackage that I previously created.
However, after editing several layers, I sometimes (apart that it doesn't happen when editing one ...
0
votes
0answers
18 views
Deploy GeoPackage file as a web service [duplicate]
I have a .gpkg GeoPackage from here unzpped and stored on a cloud server. I want to make it possible to use as one of the URL based geo-services listed in QGIS (WMS, GeoNode etc) : So people can zoom ...
0
votes
0answers
21 views
How to efficiently pass QgsMapLayer to geopandas.read_file()?
I want to do statistics using geopandas/pysal on existing layers - all geopackage loaded in QGIS.
Now
layer.source()
>>>'/path/to/gpkg|layername=layer'
uri = sel_bystr(layerStr).source()....
0
votes
0answers
22 views
Extract data from Geopackage .gpkg using lat long bounds [duplicate]
I have a .gpkg.tar.gz data file whose size is 3.8 GiB. Uncompressed to .gpkg, its size is 8.5 GiB.
It is spanning a large geographical area. I want to extract data from this for a small area, given ...
2
votes
1answer
46 views
Query Geopackage using spatial index in QGIS DB manager
I would like to do spatial join in QGIS DB manager on geopackage database.
The query should look like this
select * from Soil_C_cadaster a,
(select * from Soil_C_cadaster
where forest_c is null) b
...
0
votes
0answers
30 views
Geopackage: Table created with python doesn't show up in QGIS's DB manager
In my python script I want to create a table in a Geopackage that will hold new values to be joined on existing data later. Anyway for table creation I use this:
def creaTable(name,sqlcon):
c = ...
1
vote
1answer
62 views
Rescuing Geopackage that appears corrupted with wal mode open QGIS
I tried to re-open a QGIS map document that referenced several layers stored in geopackages. These layers failed to load, with the "Handle unavailable layers" dialog. I think they were open in -wal ...
1
vote
1answer
73 views
Apply style to a layer in a geopackage using PyQGIS
I have a geopackage containing layers and styles stored, I need to assign one of the layers a style defined by its name. I have seen several examples but they use styles stored in external files and I ...
