59 questions
0
votes
0
answers
16
views
Losing CRS when writing to GPKG with OGR2OG / GDAL
CRS is getting set as undefined, no matter what I run. Not a biggy, but throws a warning when I import to QGIS.
Am I doing something wrong, or is it a bug?
My codes:
ogr2ogr -f "GPKG" -nlt ...
- 21
2
votes
1
answer
42
views
Loading Geopackage PolyLines into ThinkGeo InMemoryFeatureLayer for use with ThinkGeo.UI.WinForms.MapView in C#
I am trying to find most efective way to load Geopackage polyLines geometries into ThinkGeo InMemoryFeatureLayer. I have a working solution utilizing the Microsoft Sqlite and NetTopologySuite suite / ...
- 333
0
votes
1
answer
72
views
Exporting Vector and Raster Layers to GeoPackage (gpkg) with PyQGIS
How to export layers(shape-files and GTiff) from a list into one gpkg file?
It works for vector and raster layers separately, but only one type of layers is saved in the output.
I've realised what ...
- 1
0
votes
2
answers
172
views
Geopandas read_file is confusing me when used with 'sql' parameter
I have a demo function, this is a barebones function which can help with go through very big datasets and process the data without having to load that entire dataset into memory at a time
def ...
2
votes
1
answer
79
views
How to download a geopackage file from geodataframe in a shiny app?
I have a shiny app that displays a number of layers on a map using folium.
I want to give the user the possibility to download one of the layers (a linestring geodataframe) as a geopackage file.
Here ...
0
votes
0
answers
19
views
FME 2023.1.2 Forgot to check overwrite option as a result the data is duplicate
I wanted to convert my geodatabase into a geopackage using FME. I wanted to overwrite my data unfortunately I forgot to tick the overwrite option. As a result all my data are duplicate. Is there any ...
- 101
0
votes
1
answer
162
views
Export geopackage from geojson in browser environment
I have a map-tool built in vue3, that has a bunch of different layers. I want to export all of these layers into a geopackage that the user can download. The layers can be toggled on and off and will ...
- 39
1
vote
0
answers
46
views
Bulk insert rasters into GPKG
I wonder if there is a way to bulk insert TIFF rasters into a geopackage using python or gdal, to increase write performance.
GDAL needs to open an SQLite connection per added raster file (subdataset, ...
- 1,996
0
votes
0
answers
128
views
RDS aws_s3 extension and geopackage files
I have an aws RDS (postgres) set up, and I have a table inside with a column called "aws_s3_key_path", where I need a trigger function to check whatever aws s3 key path gets added into this ...
- 21
0
votes
0
answers
56
views
How to publish Geopackage service with Domain in Geoserver
I followed the guidelines to publish Geopackge, but I got an error from Geoserver
enter image description here
I want to Publish Geopackage with Domain Using Geoserver, because attribute table should ...
0
votes
2
answers
106
views
ngageoint/geopackage-android Writing in GPKG from android
I have a project where i have to export coordinates data into a GPKG with media as blob from my app, so it can be opened in QGIS.
I have no experience at all in this field and have been battling for ...
- 101
3
votes
2
answers
292
views
Fill Subdivisions of Chloropeth Map with multiple Colors
I want to create a plot of Germany, where each of its 16 Bundesländer (Subdivisons) is colored differently, depending on the fulfillment of a handful of criteria. At the bottom you find a ...
- 319
0
votes
0
answers
111
views
geofileops gives wrong result in intersection when data is big
I m using geofileops to make geopandas functions faster however I have this problem!
from detection_algorithm.utils.database_connection import DatabaseConnection
import geopandas as gpd
import ...
1
vote
1
answer
277
views
SQLite / Geopackage AFTER INSERT trigger to calculate Length in QGIS
I have been following the guide here: https://www.northrivergeographic.com/adding-triggers-to-geopackage/ to add a trigger to a SQLite database in a Geopackage file. Geometry type is Line (...
- 135
0
votes
0
answers
595
views
How to avoid problems when saving edits in Geopackages from QGIS
I really like working with Geopackages as the data format in QGIS. Only one file per layer and no limits on the namin of attributes.
But from time to time after editing a Geopackage I get the error ...
- 101
0
votes
0
answers
458
views
Can anybody give me example of processing GeoPackage file with Geotools?
I have two things I want to perform with geopackage files. Only vector polygone layers I want to work with.
1/ access specific layer within given geopackage and retrieve rows from it (attribute table ...
- 1
0
votes
0
answers
254
views
Writing a geopackage error - violating constraints?
I have a geopackage that I want to split into many smaller geopackages. Kind of like 'tiles'. I have been successfully using the ogr2ogr tool for many countries around the world. But for some reason ...
- 917
1
vote
1
answer
251
views
How to use import Geopackage data to my Django RESTful API?
I want to create a full-stack web application to let users query parks and greenspace in the UK, something like this: https://www.barnet.gov.uk/directories/parks.
I want to build a Django RESTful API ...
- 339
0
votes
1
answer
298
views
Does ogr2ogr support selecting from gpkg using shp polygons as filter?
I have two input sources:
region.shp.
Geometry type MultiPolygon.
Currently contains 3 regions.
roads.gpkg.
One layer, "road" with geometry field named "geom" with type ...
- 5,859
1
vote
0
answers
810
views
GDAL GeoPackage (GPKG) vs Shapefile (SHP) performance
I'm trying to decide which format of vector spatial data should be used on a embedded device.
The main operation imposed on these vectors will be to rasterize the with GDAL C++ API so they can be ...
- 33
0
votes
1
answer
872
views
Read only the rows of spatial data with specific column value using st_read and SQL
I have a spatial data set and I would like to read to memory only those rows that match a given value in a certain column. Here is a reproducible example with what I've tried.
Using a shape file, I ...
- 13.8k
0
votes
0
answers
1k
views
Export a postgis table to geopackage using the database management in QGIS
I am working in QGIS through the DB Manager by running some spatial queries. After I create new tables with the queries I need to export the tables as new geopackages.
I've tried using the Export to ...
1
vote
0
answers
2k
views
How to combine multiple geopackages into one single file
I have got a series of geopackages which represent every single packet of land across England. Each geopackage is one local area and i want to combine them to create one single file for all of england....
- 33
0
votes
1
answer
411
views
Geopandas map annotate not visible
I don't understand why I can't annotate my map of the United States.
import fiona
import geopandas
import matplotlib.pyplot as plt
from shapely.geometry import Polygon,box
countries_gdf = geopandas....
- 11
1
vote
0
answers
603
views
'QGIS Processing Executor'_Issue: "sqlite3_open ... unable to open database file"
Trying to run a self built-in QGIS-model (*.model3) using the followoing 'QGIS Processing Executor' (qgis_process) command in the command line does not work.
C:\Program Files\QGIS 3.24.1\apps\Qt5\bin&...
- 31
0
votes
1
answer
726
views
Sample geopandas data in networkx example
I am trying an example provided by networkx here. This example uses a geopandas dataset in a filename cholera_cases.pkdg.
# read in example data from a geopackage file. Geopackages
# are a format for ...
- 1,493
1
vote
1
answer
751
views
Load QGIS project from geopackage
My attempt is to use the same function behind the above dialog in which QGIS allow to load project form a geopackage by giving the connection, the path.
The idea is to be able to check if a geopackage ...
- 11
0
votes
1
answer
789
views
How should we display GeoPackage on Mapbox GL JS?
We used wgrib2 to convert weather radar data into NetCDF format. We converted it to GeoPackage format using gdal_translate. We created a Color Map on QGIS 3.10 and the GeoPackage appeared as expected.
...
- 872
0
votes
1
answer
647
views
Losing the crs when writing to .gpkg with geopandas
When I write my .gpkg I am losing the CRS. I have tried setting the CRS with .set_crs, or adding the CRS when writing the .gpkg (which creates a fault - "fiona._env - WARNING - dataset filename....
- 69
0
votes
1
answer
2k
views
Can I save a GeoDataFrame that contains an array to a GeoPackage file?
I have a geopandas GeoDataFrame with some attribute columns and a geometry column (just a regular GDF). Usually I save GDF's as GeoPackage giles (.gpkg) using:
gdf.to_file('path_to_file.gpkg', driver='...
- 113
0
votes
1
answer
576
views
List all raster layers in Geopackage using pyqgis
With the following code it is super easy to list all vector layers in a geopackage:
my_gpkg = r'PATH_TO_GEOPACKAGE'
gpkg_layers = [l.GetName() for l in ogr.Open(my_gpkg )]
Is there also a way to list ...
0
votes
0
answers
581
views
Geopackage not rendering in leaflet
Having trouble geting a geopackage file to show up in leaflet-geopackage, I'm running Ubuntu 16.04, Vue 2.6.14, and Chrome Version 95.0.4638.54.
I have a mapbox image which will render, using this ...
- 23
1
vote
2
answers
146
views
~ operator in SQLITE
I'm running this part of a query on Postgres and it's running fine
where column ~ '^[0-9]'
But when I try to run it in SQLite, I get this error:
near "~": syntax error
Do you have any ...
user14705639
1
vote
0
answers
35
views
Plotted map shown small on Plots panel
I'm trying to plot a map for New-Zealand, with data taken from here. It's a geopackage of New-Zealand from gadm.
I'm currently selecting the first layer, and thought it was a projection problem so I ...
- 748
4
votes
1
answer
657
views
Geopackage not rendering polygons to map
The code to create the map:
<div id="map" style="width: 1000px; height: 700px"></div>
<script>
var map = L.map('map').setView([0,0], 1);
L.tileLayer('...
- 110
1
vote
2
answers
371
views
Slicing a large file, removing duplicates and merging into output using Pandas
So, I have a geopackage with 1.25 billion features. The file doesn't actually contain geometry and only has one attribute 'id' which is a unique id. There are a lot of duplicates and I want to remove ...
- 133
0
votes
1
answer
53
views
Best theorically way to integrate some standalone apps into a web environment?
I've developed some python standalone apps that now I want to integrate into a web environment in order to make them more user friendly for my workmates, whom aren't used to CLI and the command shell. ...
3
votes
1
answer
4k
views
How to append / add layers to geopackages in PyQGIS
For a project I am creating different layers which should all be written into one geopackage.
I am using QGIS 3.16.1 and the Python console inside QGIS which runs on Python 3.7
I tried many things but ...
- 35
0
votes
1
answer
283
views
Combining ST_CONTAINS and ST_BUFFER using same table in SQLite
I am looking to select some points within a created buffer from other points in the same table.
I would like something like this:
Select a.geom , a.type
from a
where st_contains( (st_buffer( (a.geom ...
- 25
0
votes
0
answers
1k
views
Problem importing geodata from file GDB with geopandas in python3.x
I'm working on some code to select and export geodata based on a bounding box. The data I want to select comes from 2 seperate layers in a huge File GDB (16GB) covering the entire Netherlands. I use a ...
- 1
1
vote
0
answers
367
views
Using spatialite with xerial/sqlite-jdbc on MacOS
I'm having some problems loading the spatialite extension in Java to read a GeoPackage, I have the following snippet:
import org.sqlite.SQLiteConfig;
import java.net.URI;
import java.net....
- 51
1
vote
1
answer
3k
views
Read a gpkg file from memory/zipfile
I know that it is possible to read a shapefile from a zipfile by extracting it in memory and then reading it:
https://gis.stackexchange.com/questions/250092/using-pyshp-to-read-a-file-like-object-from-...
- 388
2
votes
1
answer
142
views
how to take List<Point> from mil.nga.sf.Geometry
In my mil.nga.sf.geometry object I am getting geometry type, hasM, hasZ and point.
In my debugging I am able to see that geometry object contains list of point objects, But I am not able to take them ...
- 89
0
votes
1
answer
56
views
SQL check or uniqueness in one column in multipe tables
I have a 'unique' column, 'GID_New' that is in multiple tables. Is there a way to check if it's unique across all the tables in the QGIS project in SQL?
Can it be done in one SQL search without ...
- 1,036
0
votes
0
answers
1k
views
formula to convert X and Y coordinates 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();
...
- 2,520
1
vote
0
answers
408
views
decode the blob geometry using java
In my table I have two columns, Data and Range.
Range field is encoded binary from ArcGIS.
this format is supposed to be a standard format with in the Geo spatial industry.
https://www.gaia-gis.it/...
- 89
3
votes
2
answers
1k
views
how to 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();
...
- 89
0
votes
1
answer
3k
views
Writing geopackage attribute data in Python using Fiona module
I have very little experience in fiona module (started today!)
I have a geopackage called building.gpkg that has a field called 'id' which is NULL at the time of production.
I am trying to write a ...
- 1
0
votes
1
answer
618
views
Internal files not 'available' on Android - File.exists() returns false for any file
I am trying to access a 2.45GB Geopackage file that is stored in internal storage but whenever I try and access it I get a "File does not exist" error.
The gpkg file is being downloaded via ...
- 169
1
vote
1
answer
793
views
select geometry from geopackage in dbbrowser for sqlite
I'm using dbmanager for sqlite with spatialite module loaded and I'm trying to read a geopackage I exported before from qgis 3.12.
I perform this both selections bellow and get the 'geometry' with ...
