Skip to main content

Search

Items tagged with: PostGIS

osm2pgsql moved to it's own GitHub organization, no longer using the OpenStreetMap org

#osm2pgsql #OSM #OpenStreetMap #GitHub #PostGIS #PostgreSQL
https://osm2pgsql.org/news/2023/09/20/new-github-organisation.html

New Github Organisation - News - osm2pgsql

osm2pgsql.org
#osm #openstreetmap #github #postgis #osm2pgsql #postgresql

PgOSM Flex is ready to go with Postgres 16 and PostGIS 3.4! 🤓 🐘 🗺️

#pgosm #postgis #postgres #postgresql #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.10.2

Release 0.10.2 · rustprooflabs/pgosm-flex

PgOSM Flex 0.10.2 Commit hash: f45b3f6 The commit hash from this git repo shows up with the PgOSM Flex version number in SELECT pgosm_flex_version FROM osm.pgosm_flex; If you see this version wit...
GitHub
#openstreetmap #postgis #gischat #postgresql #postgres #pgosm

I knew I talked about #postgis a lot... but didn't think it was so much that my toddler would be taking an interest in already.

Yesterday I came into my office to find him thumbing through one of my favorite books on it, PostGIS in Action
#gischat
#postgis #gischat

"Where" is a fundamental question for people (think: where are you from? where do you live?)—and as Regina Obe says: "Where is the universal foreign key."

Which is why it was sooooo fascinating 🤯 for Pino de Candia & me to talk to @pwramsey & Regina Obe today on the #PathToCitusCon podcast 🎙️
about why people care about PostGIS and Postgres.

I will share the link to the #podcast episode 🎧 as soon as Carol Smith & @asw publish it later this week! Soon soon.

#PostgreSQL #PostGIS #GIS
#podcast #postgis #gis #postgresql #pathtocituscon @Paul Ramsey 🗳️ @asw

The FOSS4G team has been posting this year's talks and mine just hit the channel: https://www.youtube.com/watch?v=gl7LMEPvAmo

A companion article is here: https://www.jaxartes.net/pages/ads-b/

#foss4g #foss4g2023 #postgis #openskynetwork #adsb

Multidimensional data in PostGIS

ADS-B data # Can standard geospatial tools be used with transmissions from Automatic Dependent Surveillance-Broadcast (ADS-B) equipment aboard aircraft? I wanted to find out because unlike most geospatial data, ADS-B has a third dimension and a fourt…
Benjamin Trigona-Harany (www.jaxartes.net)
#foss4g #postgis #foss4g2023 #openskynetwork #adsb

Hey PgOSM Flex Users! Can you help test / code review in the next couple of weeks? I'll be updating the PR I just started. Moving DB deploy away from Sqitch...

Yes... this will fix a bug I recently introduced...

More importantly -- this continues the move toward being more flexible! This change has been brewing for a while 🤓

https://github.com/rustprooflabs/pgosm-flex/pull/324

#pgosm #openstreetmap #postgis

Restructuring DB deploy code from Sqitch to managed by Python by rustprooflabs · Pull Request #324 · rustprooflabs/pgosm-flex

Closes #318. As much as I love Sqitch, it isn't appropriate for this use. Sqitch expects what it deploys doesn't change without it knowing. This simply isn't the case with anything deployed via P...
GitHub
#openstreetmap #postgis #pgosm

Such an innocent looking query... I didn't expect it to do this!

One table has 500 rows, the other has 381k. Table stats are accurate. The planner still decides it will return 39M rows, roughly 20% of what a cartesian join. The screenshot is from pgMustard, plan here: https://app.pgmustard.com/#/explore/486276b3-d9e5-4bc8-a1eb-a3a23cd1caf4?highlighted=0

SELECT *
FROM store_potential_customers p
INNER JOIN osm.road_line r
ON r.route_motor
WHERE p.geom <-> r.geom < 100
;

@michristofides
#postgis #postgresql #postgres #performance
#postgis #postgresql #performance #postgres @michristofides

Treffen Sie die Trainer und Trainerinnen der FOSS Academy auf der #FOSSGIS2023 in Berlin.

Am WhereGroup Stand informieren wir Sie gerne zu Schulungen rund um #OpenSource #geospatial
https://fossgis-konferenz.de/2023/sponsor/002_wheregroup.php

#QGIS #MapServer #Mapbender #PostGIS #FOSSGIS #OSGeo #GeoServer & mehr

FOSSGIS 2023 - WhereGroup GmbH

Die FOSSGIS-Konferenz ist im D-A-CH Raum die führende Konferenz für Freie und Open Source Software für Geoinformationssysteme OpenStreetMap.
fossgis-konferenz.de
#opensource #osgeo #qgis #postgis #geospatial #geoserver #fossgis2023 #mapserver #mapbender #fossgis

Check out the new #PostGIS Function of the Week channel.

See functions in action & learn a lot.
https://www.youtube.com/@auchindowngeo

Thanks a lot to Rhys Stewart.
#OSGeo #FOSS4G #SQL #PostgreSQL

Auchindown

Partagez vos vidéos avec vos amis, vos proches et le monde entier
YouTube
#osgeo #foss4g #postgis #postgresql #sql

This website uses cookies to recognize revisiting and logged in users. You accept the usage of these cookies by continue browsing this website.

⇧