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.
308
questions
0
votes
0answers
30 views
Getting ERROR 010161 in geopackage using ArcMap
I am using ArcMap 10.7.1.
I'm trying to share a model via geopackage. The model works fine while open in my .mxd file and shares without any errors but when I open the newly saved geopackage I receive ...
1
vote
0answers
43 views
Using Virtual Fields in Views in QGIS
I'm trying to summarize some information in a map layout in QGIS controlled by an atlas. I have parks, and connected to that I have objects within these park (points, lines and polygons).
I want a ...
5
votes
1answer
76 views
Save as GeoPackage Layer Options - use of Description and Identifier
When saving a layer as GeoPackage in QGIS 3, what is the purpose of the Layer Options DESCRIPTION and IDENTIFIER?
I'm looking at how we can manage our working data better than the current mess of ...
1
vote
1answer
29 views
Upload specific or all tables from Geopackage to PostGIS database
I would like to upload a specific table (i.e. U2018_CLC2012_V2020_20u1 (Multi Polygon)) from a Geopackage file to a PostGIS database from the command line. I tried:
ogr2ogr -f "PostgreSQL" &...
1
vote
1answer
33 views
Parsing Geopackage (gpkg) file in JavaScript into array
I am a beginner with GIS. I have the following code that is successfully creating and displaying a map:
<div id="map" style="width: 1000px; height: 700px"></div>
<...
0
votes
1answer
13 views
QGIS 3.x Removing vector layers with geopackage source with PyQgis (win 32 error)
I'm aware that there are quite a few answers out there that have to do with removing datasources that are used to populate QGIS layers, but I feel like my question is slightly different in that it ...
0
votes
2answers
51 views
Multiple base map in Qfield?
Is it possible to load 2 base maps in Qfield (both of the 2 rasters are in geopackage format), and choose wich one I want to see and maybe switch during the field work ? I tried with the map themes ...
1
vote
1answer
31 views
Geopackage and Domain values
Anyone know if would be possible to "convert" a File GDB with a set of features classes, which contain Domain values and Subtypes, in GPKG format (for editing purpose)? What I'm not ...
3
votes
2answers
44 views
Differing checksum on two otherwise identical geopackages
I found that two exactly identical Geopackages do not share the same checksum as one would probably expect (and is vital when syncing files using rsync for example). Here is a reproducible example:
...
2
votes
0answers
15 views
How to use WHERE IN clause with ogr2ogr [duplicate]
I am exporting some tables from PostGIS to a geopackage. My command to do is task is as follows
ogr2ogr -append -f GPKG E:\workspace\test.gpkg PG:service=XXXX -where app_einzugsgebiet.hauptgemeinde=...
5
votes
2answers
112 views
Count number of features in a geopackage and write to a file
I'm tasked to create a simple catalogue of 2000+ geopackages, and hope there is a way to do that with QGIS.
The idea is to batch run over all these geopackages and write the following to a CSV file;
...
1
vote
0answers
27 views
Geopackage Spatial Views in ArcGIS 10.4
I have created a geopackage with a spatial view. The first column is a unique rowid that I have aliased as OGC_FID and the second column is a geometry column. When I load this layer into ArcMap 10.4 ...
3
votes
1answer
81 views
Data conversion between Shapefile and Geopackage: does it affect accuracy of data?
I use Shapefile as interchange format and Geopackage as the format to to processing. So I convert file format at least twice between Shapefile and Geopackage.
Does/can this somehow affect the data ...
0
votes
0answers
29 views
Using Geopackage JS and Openlayers in Angular
I need to prepare a web app which is going to load a geopackage file and show the layers in OpenLayers.
First of all I was checking the current libs and also some demo information and found a minimal ...
0
votes
1answer
35 views
Importing vector files regardless of having point, line and polygon information using a geopackage in QGIS
How do I import vector files regardless of having point, line and polygon information using a geopackage in QGIS?
I am used to using a geodatabase in ESRI's ArcGIS, but since my mac is not compatible ...
5
votes
1answer
84 views
QGIS - Intersection query in a Geopackage
In QGIS 3.10.2, I wan't to calculate geometric intersections beetween two layers in a Geopackage like a view in PostgreSQL/PostGIS. The first layer is composed with features, a name attribute and a ...
2
votes
4answers
199 views
QGIS to ArcMap file delivery via geopackage
When I'm saving a new layer made in QGIS (v 3.14), it gives me only an option of saving it as .gpkg file. I sent these to a person using ArcMap for further work and he's insisting that I send him all (...
2
votes
1answer
41 views
Is it possible for QGIS to recognise GeoPackage Schema and/or Related Tables extension implementation?
I have set up a basic geo package example with the schema extension, specifically for data constraints and enums. When I bring this into QGIS v3.16, I cannot see my extension work implemented anywhere ...
1
vote
3answers
68 views
QGIS SpatiaLite layer does not display
I am having a problem in QGIS with some layers failing to display on the map canvas.
I am trying to learn about QGIS by working through the Training Manual found on docs.qgis.org. I am running version ...
1
vote
1answer
79 views
Problem with using Fiona to write out GeoJSON objects to GeoPackage layers
I'm attempting to use fiona to write out a number of GeoJSON objects to different layers in a single GeoPackage.
Here's an example json.dumps() representation of the GeoJSON object containing one ...
0
votes
0answers
57 views
How to import geopackage(. gpkg) files to GeoServer PostGIS datastore by Axios?
I am going to upload some GeoPackages files to my PostGIS datastore in GeoServer 2.18.1, I did learn this work is avaliable through curl as Ian Turan answered here I can upload my gpkg files via curl ...
9
votes
1answer
262 views
Way to restore the data in the accidentally overwritten layer by its duplicate layer in QGIS?
In QGIS 3.10.12, I duplicated a GeoPackage vector layer. I made a lot of changes to the new (duplicate) layer and accidentally saved it. Now the original layer has been wiped. The undo button is ...
8
votes
1answer
251 views
What's happening with unusually large geopackage file size?
I have been working with a Geopackage in QGIS and R for a few weeks, storing ~ 12 layers of various geometry types.
Needing to email it to a colleague, I discovered the size of the file had grown to &...
1
vote
0answers
43 views
Faulty spatial ref when writing geopackage from sf
I am using sf version 0.9-5 in R 3.6.1 in Windows, and am transforming an sf feature to the USA_Contiguous_Albers_Equal_Area_Conic projection that has ESRI authority 102003 and no EPSG code - I can ...
1
vote
0answers
38 views
Creating and writing GeoPackage Lookup Tables
I am writing Python using OGR to create and write a single vector layer in a GeoPackage. Some of the feature attributes need to be foreign keys to several lookup tables. My needs are completely ...
3
votes
1answer
74 views
Importing GeoPackage via GeoPackage vs. Import Vector in QGIS
Is there any difference when importing a GeoPackage into QGIS using the data source manager between using the section "Vector" and the section "GeoPackage"?
I did not see any ...
3
votes
0answers
35 views
Tables and view not visible in QGIS 3.10.2
Using QGIS 3.10.2 I created a geopackage DB with 2 geographic layers and some tables, later on I edited the same geopackage with the DB Browser for SQLite 3.12 and created a View, add another table ...
0
votes
1answer
31 views
Assign “parcel boundaries” to “census areas” from “MULTIPOLYGON” in GeoPackage file “.gpkg” using Python
In one layer I have “polygons layer” of all “parcel boundaries”, in another layer I have the “polygon” of “census areas”. And I would need to assign every “parcel boundaries” to the “census areas” ...
1
vote
2answers
52 views
Error updating geopackage layer attribute in Python using sqlite3
I'm attempting to update an attribute field in a geopackage layer using the Python sqlite3 module, but any attempt at update is giving an error "no such function: ST_IsEmpty".
Is there ...
0
votes
1answer
101 views
ExecuteError: ERROR 999999: Error executing function. Failed to execute (CreateFileGDB) ArcGIS Server 10.5
I am trying to convert geopackage file to geodatabase using my python script. It fails with 999999 error. This gdb is further used for the arcgis rest map service. It is only working when the service ...
2
votes
1answer
61 views
Adding GeoPackage to ArcGIS Desktop using ArcObjects
How do I add a GeoPackage layer to ArcGIS Desktop using ArcObjects code (preferably c#)?
From the ESRI documentation:
The WorkspaceFactoryProgID identifies the ProgID of the WorkspaceFactory object ...
5
votes
2answers
159 views
QGIS Geopackage export of layer symbology
I want to save several layer as one geopackage. That works fine. My problem is, that the layers in the geopackage have a different symbology than they had before. I found a video where you could ...
4
votes
1answer
84 views
Overwrite existing raster layer using PyQGIS
QgsVectorFileWriter allows you to overwrite an existing layer with your output, but I have not found a similar option with QgsRasterFileWriter. Here's my code that is writing a raster layer out to a ...
4
votes
0answers
65 views
ogr2ogr creates too many columns with LEFT JOIN
I am creating a GeoPackage using several shapefiles using ogr2ogr (GDAL 2.2.4):
ogr2ogr -f GPKG /path/to/out.gpkg -append -nln out -a_srs EPSG:4326 /path/to/in1.shp
ogr2ogr -f GPKG /path/to/out.gpkg -...
1
vote
0answers
45 views
QGIS Model Designer; save layer in geopackage with date
I have used the model designer to make a model in QGIS.
The model takes data different shapefiles, and runs a few algorithms.
The result is different layers loaded in an new project.
I manually store ...
4
votes
1answer
139 views
Remove QGIS Project from Geopackage
I recently accidentally saved a QGIS Project to the wrong Geopackage. In contrast to layers the Browser Panel in QGIS (Version 3.10) currently has no option in the context menu to remove the project ...
1
vote
0answers
104 views
Trouble with GeoPackage - is SpatiaLite a solid alternative?
I like GeoPackage because it is very versatile, small and compact and works well with QGIS. But the more I use GeoPackage and recommend it to my customers, the more negative experiences I have: ...
1
vote
0answers
56 views
Running GeoPackage with QGIS Server
I'm trying to run GeoPackage on QGIS Server and query the information. I created a file through GeoPackage's QGIS Desktop.
To do the queries I used the following tutorial:
https://docs.qgis.org/3.4/en/...
0
votes
1answer
96 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
89 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
55 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
39 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
55 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
40 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
38 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 ...
4
votes
2answers
119 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
55 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
62 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
72 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
125 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 ...
