#geopackage — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #geopackage, aggregated by home.social.
-
Sichten in GeoPackage erstellen – so geht's! 👀
GeoPackage unterstützt Views – aber QGIS legt diese nicht so einfach an wie PostGIS oder SpatiaLite. 💡
In unserem Q(GIS)&A-Blogbeitrag erfahren Sie:
• Wofür sind Sichten nützlich?
• Warum fehlt die „Sicht erstellen"-Schaltfläche?
• Wie setzen Sie gpkg_contents & gpkg_geometry_columns korrekt?Inkl. Beispieldaten & SQL-Vorlagen zum Download! 🎁
👉 https://www.wheregroup.com/ueber-uns/blog/qgisa-wie-erstelle-ich-sichten-in-einer-geopackage
-
Sichten in GeoPackage erstellen – so geht's! 👀
GeoPackage unterstützt Views – aber QGIS legt diese nicht so einfach an wie PostGIS oder SpatiaLite. 💡
In unserem Q(GIS)&A-Blogbeitrag erfahren Sie:
• Wofür sind Sichten nützlich?
• Warum fehlt die „Sicht erstellen"-Schaltfläche?
• Wie setzen Sie gpkg_contents & gpkg_geometry_columns korrekt?Inkl. Beispieldaten & SQL-Vorlagen zum Download! 🎁
👉 https://www.wheregroup.com/ueber-uns/blog/qgisa-wie-erstelle-ich-sichten-in-einer-geopackage
-
RE: https://en.osm.town/@geofabrik/116369760352860779
#GeoPackage files from @geofabrik
Remember, geofabrik can make any data file format you want, for any area, just email `[email protected]`! -
RE: https://en.osm.town/@geofabrik/116369760352860779
#GeoPackage files from @geofabrik
Remember, geofabrik can make any data file format you want, for any area, just email `[email protected]`! -
@russss @geofabrik I switched away from #shapefiles to #geopackage because shp can't be more than 4 (or is it 2) GiB.
Otherwise I haven't been convinced... -
@russss @geofabrik I switched away from #shapefiles to #geopackage because shp can't be more than 4 (or is it 2) GiB.
Otherwise I haven't been convinced... -
Clip and Reproject CORINE Land Cover Data in QGIS
-
Store Data, Styles and Project in a GeoPackage with QGIS
-
Store Data, Styles and Project in a GeoPackage with QGIS
-
The reason I made a sample dataset was that I thought it was a bit sluggish querying the GeoPackage file from DuckDB. The query in the image took 2.56 s on the GeoPackage file. I now tried to save the entire dataset into a Parquet file (sorted on county and municipality) and compressed with ZSTD. The same query takes 0.0140s.
Also the Parquet file is 141 MiB compared to 1.18 GiB for the GeoPackage file. The Parquet file is smaller than the original zip file with the GeoPackage file.
-
The reason I made a sample dataset was that I thought it was a bit sluggish querying the GeoPackage file from DuckDB. The query in the image took 2.56 s on the GeoPackage file. I now tried to save the entire dataset into a Parquet file (sorted on county and municipality) and compressed with ZSTD. The same query takes 0.0140s.
Also the Parquet file is 141 MiB compared to 1.18 GiB for the GeoPackage file. The Parquet file is smaller than the original zip file with the GeoPackage file.
-
#viewinline: A new no-fuss way to visualize your vector data and rasters right in the #terminal: viewinline is a lightweight #Python utility by @Keiko_geo that renders #GeoTIFF-s, #GeoPackage-s, #GeoJSON-s, and #Shapefile-s instantly in #iterm2 (and other compatible terminals).
https://spatialists.ch/posts/2025/11/04-viewinline/ #GIS #GISchat #geospatial #SwissGIS -
#viewinline: A new no-fuss way to visualize your vector data and rasters right in the #terminal: viewinline is a lightweight #Python utility by @Keiko_geo that renders #GeoTIFF-s, #GeoPackage-s, #GeoJSON-s, and #Shapefile-s instantly in #iterm2 (and other compatible terminals).
https://spatialists.ch/posts/2025/11/04-viewinline/ #GIS #GISchat #geospatial #SwissGIS -
Geo Cloud Converter: Maphub.co launches #GeoCloudConverter, a browser-based #WASM tool that transforms common geospatial file types — #GeoJSON, #Shapefile, #KML, #GPX, CSV, #GeoPackage, or #GeoTIFF – into modern, #cloudnative formats like #GeoParquet, #FlatGeobuf,...
https://spatialists.ch/posts/2025/10/28-geo-cloud-converter/ #GIS #GISchat #geospatial #SwissGIS -
Geo Cloud Converter: Maphub.co launches #GeoCloudConverter, a browser-based #WASM tool that transforms common geospatial file types — #GeoJSON, #Shapefile, #KML, #GPX, CSV, #GeoPackage, or #GeoTIFF – into modern, #cloudnative formats like #GeoParquet, #FlatGeobuf,...
https://spatialists.ch/posts/2025/10/28-geo-cloud-converter/ #GIS #GISchat #geospatial #SwissGIS -
learned about #pocketbase - a one-file #backend using #sqlite as #database
it automatically creates an #api - optionally with #authentication
could be a base for a minimalistic #geodata server based on #geopackage #gpkg
#ogc #gischat #spatial #geospatial -
learned about #pocketbase - a one-file #backend using #sqlite as #database
it automatically creates an #api - optionally with #authentication
could be a base for a minimalistic #geodata server based on #geopackage #gpkg
#ogc #gischat #spatial #geospatial -
Did you know that you can package a complete #QGIS :qgis: project (incl. all your layers and data) in a single #Geopackage file, e.g. to move it to another system?
Practical examples, on the new hub:
https://hub.qgis.org/geopackages/?sort=upload_date&order=desc -
Did you know that you can package a complete #QGIS :qgis: project (incl. all your layers and data) in a single #Geopackage file, e.g. to move it to another system?
Practical examples, on the new hub:
https://hub.qgis.org/geopackages/?sort=upload_date&order=desc -
@robintw GeoPackages!
+ They can hold vector and raster data.
+ They are fully functioning SQLite databases.
+ They can include style information.
+ They can be emailed / SCP'd around the world.
+ You can synchronise and combine data from multiple users with @merginmaps.
+ It's an OGC standard so they work with ESRI tooling as well.As that last point suggests, geopackages aren't exclusive to QGIS, but QGIS gives the tools to make the most of them.
-
@robintw GeoPackages!
+ They can hold vector and raster data.
+ They are fully functioning SQLite databases.
+ They can include style information.
+ They can be emailed / SCP'd around the world.
+ You can synchronise and combine data from multiple users with @merginmaps.
+ It's an OGC standard so they work with ESRI tooling as well.As that last point suggests, geopackages aren't exclusive to QGIS, but QGIS gives the tools to make the most of them.
-
@rspfau In #QGIS try to run the fix tool, create a spatial index and save the layer as a #geopackage Then try again to filter You dataset.
-
@rspfau In #QGIS try to run the fix tool, create a spatial index and save the layer as a #geopackage Then try again to filter You dataset.
-
I get some of the #gis tradeoffs that might lead someone to publish data as a #geopackage instead of #geojson but there are so many tools and workflows for the latter (json) that I'm having a hard time finding in the former (package).
Anybody have a intro to *analyzing* the geopackage format type blog post (or series) for folks just getting started?
Here's my more concrete query I'm struggling through: How can I find which feature in the dataset contains a particular Point location?
-
I get some of the #gis tradeoffs that might lead someone to publish data as a #geopackage instead of #geojson but there are so many tools and workflows for the latter (json) that I'm having a hard time finding in the former (package).
Anybody have a intro to *analyzing* the geopackage format type blog post (or series) for folks just getting started?
Here's my more concrete query I'm struggling through: How can I find which feature in the dataset contains a particular Point location?
-
Introduction to GIS with QGIS [tutorial]
--
https://libguides.brown.edu/gis_data_tutorials/intro_qgis <-- shared Brown University tutorial/self-lead class
--
"This tutorial was created for a day-long introductory GIS workshop and for self-directed learners, using the free and open source QGIS desktop software. Download QGIS and install it for Windows, Mac, or Linux. It's recommended that you install the same version of QGIS that's being used in the tutorial, which is written for the stable long term release…”
#GIS #spatial #mapping #QGIS #opensource #opendata #tutorial #desktop #geopackage #selflearning #selftaught #onlinelearning #education #learning #elearning #onlineclasses #distancelearning #onlinecourses #onlineeducation #online #school #virtuallearning #learn #usecase #free -
Introduction to GIS with QGIS [tutorial]
--
https://libguides.brown.edu/gis_data_tutorials/intro_qgis <-- shared Brown University tutorial/self-lead class
--
"This tutorial was created for a day-long introductory GIS workshop and for self-directed learners, using the free and open source QGIS desktop software. Download QGIS and install it for Windows, Mac, or Linux. It's recommended that you install the same version of QGIS that's being used in the tutorial, which is written for the stable long term release…”
#GIS #spatial #mapping #QGIS #opensource #opendata #tutorial #desktop #geopackage #selflearning #selftaught #onlinelearning #education #learning #elearning #onlineclasses #distancelearning #onlinecourses #onlineeducation #online #school #virtuallearning #learn #usecase #free -
Ahora en #siglibre2024 María Guzmán habla de #geopackage porque necesitaba hacer cosas de drenaje de agua.
-
Ahora en #siglibre2024 María Guzmán habla de #geopackage porque necesitaba hacer cosas de drenaje de agua.
-
Built a webmap to generate random geodata with export to #Geopackage #FlatGeobuf #CSV #GeoJSON or #PGDump
Besides #wgs84 (latitude/longitude) all #UTM projections are supported dynamically by location
Thanks to #GDAL #WebAssembly this works completely in the browser and does not require server processing 🤩
Demo: https://jakobmiksch.github.io/random-geodata/
Repo: https://github.com/jakobMiksch/random-geodata
#gischat #vuejs #openlayers -
Built a webmap to generate random geodata with export to #Geopackage #FlatGeobuf #CSV #GeoJSON or #PGDump
Besides #wgs84 (latitude/longitude) all #UTM projections are supported dynamically by location
Thanks to #GDAL #WebAssembly this works completely in the browser and does not require server processing 🤩
Demo: https://jakobmiksch.github.io/random-geodata/
Repo: https://github.com/jakobMiksch/random-geodata
#gischat #vuejs #openlayers -
Hey #spatial #R folks, is it possible to extract geometries from #ggplot as files? That is, the point, line, and polygon geometries in the graphs to #geopackage or #shapefile etc.
It is possible with #seaborn and #matplotlib, but that's Python not R. There's a nice and lightning fast #EdgeBundling technique in the newest ggplot, which is very promising for the #visualization of massive #mobility data.
There is also something in #HoloViews but I do not understand that library at all.
-
Hey #spatial #R folks, is it possible to extract geometries from #ggplot as files? That is, the point, line, and polygon geometries in the graphs to #geopackage or #shapefile etc.
It is possible with #seaborn and #matplotlib, but that's Python not R. There's a nice and lightning fast #EdgeBundling technique in the newest ggplot, which is very promising for the #visualization of massive #mobility data.
There is also something in #HoloViews but I do not understand that library at all.
-
Missed your 25th birthday @shapefiIe (July 1998); that is 175 years in technology years! 🙃 😜 🤔 😁
(and some are worried about Joe Biden!)
--
Nothing personal, but #shapefilesmustdie
https://www.gis-blog.com/geopackage-vs-shapefile/
#GIS #spatial #mapping #shapefiles #geopackage #moderntechnology #technology #mappymeme -
Missed your 25th birthday @shapefiIe (July 1998); that is 175 years in technology years! 🙃 😜 🤔 😁
(and some are worried about Joe Biden!)
--
Nothing personal, but #shapefilesmustdie
https://www.gis-blog.com/geopackage-vs-shapefile/
#GIS #spatial #mapping #shapefiles #geopackage #moderntechnology #technology #mappymeme -
@rony I often try queries out right in #QGIS as scratch layers. The query syntax is a useful mix of Python and SQL and it has great built-in help and I like that I can review the results as a table or as a map. I also learned now to "join" a spatial table with a CSV file.
I'm a big fan of #postgres too, but for the inherently visual nature of spatial data, I like QGIS as a query tool.
Since #GeoPackage files are just SQLite files, sometimes I use the `sqlite` CLI to query those!
-
@rony I often try queries out right in #QGIS as scratch layers. The query syntax is a useful mix of Python and SQL and it has great built-in help and I like that I can review the results as a table or as a map. I also learned now to "join" a spatial table with a CSV file.
I'm a big fan of #postgres too, but for the inherently visual nature of spatial data, I like QGIS as a query tool.
Since #GeoPackage files are just SQLite files, sometimes I use the `sqlite` CLI to query those!
-
Here are some interesting things that I learned about #sqlite WAL mode this morning while debugging a #GeoPackage issue:
+ #QGIS opens GeoPackages in WAL mode
+ WAL mode persists, so subsequent connections from any application will be in WAL mode
+ Calling `PRAGMA journal_mode=DELETE;` turns off WAL mode and cleans up `-wal` and `-shm` files
+ WAL mode does not work across network file systems (or, in my case, between #WSL and Windows)The docs are worth reading:
-
Here are some interesting things that I learned about #sqlite WAL mode this morning while debugging a #GeoPackage issue:
+ #QGIS opens GeoPackages in WAL mode
+ WAL mode persists, so subsequent connections from any application will be in WAL mode
+ Calling `PRAGMA journal_mode=DELETE;` turns off WAL mode and cleans up `-wal` and `-shm` files
+ WAL mode does not work across network file systems (or, in my case, between #WSL and Windows)The docs are worth reading:
-
Earlier I complained about some data not having descriptions of its fields. I figured I should lead by example and start adding comments to the fields in my tables in my GeoPackages. I thought it might be neat to make a little tool that turns your GeoPackage into some pretty HTML documentation.
Then I learned that #GeoPackage (#SQLite) doesn't support field comments!
-
Earlier I complained about some data not having descriptions of its fields. I figured I should lead by example and start adding comments to the fields in my tables in my GeoPackages. I thought it might be neat to make a little tool that turns your GeoPackage into some pretty HTML documentation.
Then I learned that #GeoPackage (#SQLite) doesn't support field comments!
-
Celebrating some progress - retrieving DEMs, reprojecting, clipping, recalculating elevation from meters to feet, generating 2ft & 100ft contours, converting #GeoPackage layers to DXF files (all using #GDAL and #OGR CLIs), manually aligning in #AutoCAD and putting them in dedicated layers. #mappingmonday
-
WIP: I'm generating Facade-X like #RDF triples from an OGC #GeoPackage 😁 big memory issues tho
-
WIP: I'm generating Facade-X like #RDF triples from an OGC #GeoPackage 😁 big memory issues tho