Mastodawn

Using Cloud Rasters with #PostGIS | Crunchy Data Blog https://www.crunchydata.com/blog/using-cloud-rasters-with-postgis #gis #spatial #postgresql

Using Cloud Rasters with PostGIS | Crunchy Data Blog

Paul shows you how to access raster data stored in the cloud or object storage for PostGIS using cloud optimized GeoTIFF (aka COG) files. He also includes some functions for working with raster elevation.

Crunchy Data

Show thread

Jim Spath 3d ago

@avlcharlie I truncated the error message to fit in the 500 character limit of chaos.social. This failure probably needs a longer post for context; terse version follows:
I found I can drag a layer in QGis to my local #PostGIS database and drop it into the a DB instance. Poof! The data goes from a KML or whatever, into a fully-formed PostgreSQL object.
Until now, when the layer came from ESRI formatted x/y content. I *think* the CRS map projection being over 1000000 hit a bump. To be continued.

Douglas J Hunley 5d ago

WKB EMPTY #postgis #gis #spatial https://blog.cleverelephant.ca/2025/02/wkb-empty.html

WKB EMPTY

I have been watching the codification of spatial data types into GeoParquet and now GeoIceberg with some interest, since the work is near and dear to my heart. Writing a disk serialization for PostGIS is basically an act of format standardization – albeit a standard with only one consumer – and many of the same issues that the Parquet and Iceberg implementations are thinking about are ones I d...

Paul Ramsey

Spatialists 6d ago

MDS in geo: An example with Mapillary: Two articles by Michaël Galien on @geotribu showcase how to leverage a Modern Data Stack (#MDS) for processing geospatial data from #Mapillary. The workflow features #dbt, Apache #Airflow, #PostGIS, #SQL, and #Python, highlighting a robust...
https://spatialists.ch/posts/2025/06/09-mds-in-geo-an-example-with-mapillary/ #GIS #GISchat #geospatial #SwissGIS

MDS in geo: An example with Mapillary – Spatialists – geospatial news

Two articles by Michaël Galien on #Geotribu showcase how to leverage a Modern Data Stack (#MDS) for processing geospatial data from #Mapillary. The workflow features #dbt, Apache #Airflow, #PostGIS, #SQL, and #Python, highlighting a robust open-source approach to geospatial data engineering.

Spatialists – geospatial news

Atilio FRANCOIS Jun 4

🆕 New technical article (in English): Efficient workflow to load and explore ENC (S-57) nautical charts in PostGIS and QGIS.

🔍 Overview of the S-57 format structure
⚙️ Automated import with ogr2ogr and batch scripts
🧩 PostGIS optimization: triggers, stored procedures & indexing
🗺️ QGIS-ready in minutes for fast cartographic exploration

📘 Read the article here 👉https://www.sigterritoires.fr/index.php/en/enc-maps-in-qgis-with-postgis1/

#QGIS #PostGIS #S57 #ENC #GeoSpatial #MarineGIS #ogr2ogr #GDAL

Atilio FRANCOIS Jun 3

🆕 Nouveau billet de blog : comment charger rapidement des cartes marines ENC (S-57) dans une base PostGIS et les visualiser dans QGIS.

💡 Format S-57 expliqué
🛠️ Import automatisé avec ogr2ogr
⚙️ Triggers & procédures pour une base optimisée
📍 Prête à l’emploi en quelques minutes

#SIG #QGIS #PostGIS #CartographieMarine #S57 #OpenData

Show thread

Sandro Santilli May 28

@edbpostgres @eatonphil I tried running #PostGIS testsuite against an heaptrack injected postmaster and... it hangs at the regress/core/wkb step

FOSS Academy May 28

Im Juli machen wir Sommerpause.

Ab August gibt es dann wieder spannende Kurse rund um #Mapbender #QGIS #MapServer #PostGIS #GeoServer #ALKIS & mehr.

Sichern Sie sich jetzt schon Plätze! Bis zu 6 Wochen vor Schulungsbeginn erhalten Sie 10% Frühbucherrabatt!

Jetzt anmelden!
https://www.foss-academy.com

#FOSSGIS #GIS #GEOSPATIAL #FOSS4G #OSGeo #QGIS

OSM US May 19

Jérôme Urbain will lead a hands-on tutorial on how to download OpenStreetMap data into a PostGIS database during this #SOTMUS workshop on Thursday afternoon. Access the full schedule here: https://bit.ly/SOTMUS2025_schedule_preview

🎟️ https://bit.ly/sotmus2025tix

#MappyMonday #StateoftheMapUS #OpenStreetMap #OSM #PostGIS

Your site

GeoNe.ws May 19

#PostGIS 3.5.3 released

https://postgis.net/2025/05/PostGIS-3.5.3/

PostGIS 3.5.3

The PostGIS Team is pleased to release PostGIS 3.5.3. This version requires PostgreSQL 12 - 18beta1, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+ is needed to enable postgis_sfcgal support. To take advantage of all SFCGAL features, SFCGAL 1.5+ is needed. 3.5.3 source download md5 NEWS PDF docs: en HTML Online en ja fr zh_Hans Cheat Sheets: postgis: en ja fr zh_Hans postgis_raster: en ja fr zh_Hans postgis_topology: en ja fr zh_Hans postgis_sfcgal: en ja fr zh_Hans address standardizer, postgis_tiger_geocoder: en ja fr zh_Hans This release is a bug fix release that includes bug fixes since PostGIS 3.5.1.

PostGIS