veganism.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Veganism Social is a welcoming space on the internet for vegans to connect and engage with the broader decentralized social media community.

Administered by:

Server stats:

296
active users

#postgis

1 post1 participant0 posts today

Hm. I normally use github.com/pgautoupgrade/docke whenever I need to deploy a #postgres container because I can just increase the version in my #Ansible playbooks to perform an upgrade.

Now I need #postgis for #dawarich and there doesn't seem to be such a convenient fork to ease future upgrades.

Am I missing something? Do I really want to bother future-me with manual upgrades that may include dumping, updating and restoring? Or would I just add these steps to my playbook?

GitHubGitHub - pgautoupgrade/docker-pgautoupgrade: A PostgreSQL Docker container that automatically upgrades your databaseA PostgreSQL Docker container that automatically upgrades your database - pgautoupgrade/docker-pgautoupgrade

🚨 Call for Papers extended! 🚨
Still in holiday mode? 😎 So are we!
New deadline: 📅 **8 August 2025**

PostgreSQL, PostGIS, R, GeoServer, QGIS… whatever your geo-thing is — we want to hear about it!

🎤 Talks, lightning talks, workshops
🗣️ In English, French or Dutch
🎉 10 years of #FOSS4GBE!

📝 Submit: [shorturl.at/0Pgie]
💌 Questions? info@foss4g.be

Google DocsCall for Presentations - FOSS4G Belgium 2025FOSS4G Belgium will be held in Brussels on Thursday 25 September 2025. FOSS4G Belgium vindt plaats in Brussel op donderdag 25 september 2025. FOSS4G Belgium se tiendra à Bruxelles le jeudi 25 septembre 2025.

Im Juli macht die @FOSS_Acasdemy Sommerpause. Ab August geht's weiter mit vielen spannenden Open-Source-GIS-Schulungen!

Sichern Sie sich jetzt einen der noch verbleibenden Plätze.

Die FOSS Academy bietet Kurse rund um #Mapbender #QGIS #MapServer #PostGIS #GeoServer #ALKIS 5-tägiger Kompaktkurs & mehr.

Bis zu 6 Wochen vor Schulungsbeginn erhalten Sie 10% Frühbucherrabatt!

foss-academy.com/

Jetzt anmelden!
#FOSSGIS #GIS #GEOSPATIAL #FOSS4G #OSGeo #QGIS

Something like 10+ years ago when I was looking into #postgis , #pgrouting and other related stuff I had an idea (that's been bouncing around my skull since) for a "tripplanner for goths" that would be using DEM(my stuff) and GRASS's r.sunmask or similar, turning the raster via vector to costs and routing with that.

Now somebody built it.
mastodon.social/@sfkeller/1147

MastodonStefan F. Keller (@sfkeller@mastodon.social)Attached: 1 image New blog post about "The coolest way to find shaded paths: Vampire routing on routing.osm.ch". See https://sosm.ch/the-coolest-way-to-find-shady-paths-vampire-routing-on-routing-osm-ch/ #OSMinside #OpenStreetMap #Routing #UrbanHeat #SOSM

📣 FOSS4G Belgium 2025 🇧🇪
📍 Brussels | 📅 25 Sep 2025
🗺️ foss4g.be

FOSS4G Belgium is back. A great day to meet the open geo community. I usually stay behind the scenes as a PostgreSQL DBA, but I love seeing what people build with PostGIS.

Call for presentations is open until 21 July. If you’ve made something cool with geo or open source, share it!

Hope to see you there, maps and all 😁
#FOSS4G #PostgreSQL #PostGIS #OSGeo

www.foss4g.beFOSS4G - Belgium

@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.

#RStats #PostgreSQL #PostGIS question!

Is there a sensible -- no, *ideal* -- way to store spatiotemporal raster/NetCDFs in a PostgreSQL database? Ideally one which can still be easily queried in R.

My default approach of just converting them into dataframes and pushing everything to a database a) seems very inefficient, and b) *definitely* takes up more space than we have available in the database.

I think we could technically ask for more space, and insert indices to make using that data faster, but...seems like the wrong direction and not worth the effort.

Oregon State University | Open Source Lab ( #OSUOSL) is in jeopardy of shutting down this year because of budget cuts. OSUOSL has been vital to the functioning of OSGeo (Open Source Geospatial Foundation) lists.osgeo.org/pipermail/sac/ Projects under #OSGeo are #PostGIS, pgRouting, #QGIS GeoServer, GDAL, GEOS and others which are foundational software for the GIS community both in Open Source arena and others. If you know any corporations willing to support OSUOSL, please pass the message along.

lists.osgeo.org[Hosting] Future of OSL in jeopardy