sueden.social ist einer von vielen unabhängigen Mastodon-Servern, mit dem du dich im Fediverse beteiligen kannst.
Eine Community für alle, die sich dem Süden hingezogen fühlen. Wir können alles außer Hochdeutsch.

Serverstatistik:

1,8 Tsd.
aktive Profile

#pgrouting

0 Beiträge0 Beteiligte0 Beiträge heute
Anita Graser 🇪🇺🇺🇦🇬🇪<p>Only until end of July: <a href="https://fosstodon.org/tags/Geospatial" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Geospatial</span></a> ebook sale at <span class="h-card" translate="no"><a href="https://beta.birdsite.live/users/locatepress" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>locatepress</span></a></span> </p><p>Use coupon code: SUMMERSUN25</p><p>for your 10% discount on any e-book, including the <a href="https://fosstodon.org/tags/Spanish" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Spanish</span></a> edition of Discover QGIS </p><p><a href="https://mailchi.mp/locatepress/locate-press-summer-sale-8340239?e=e6235e72b6" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mailchi.mp/locatepress/locate-</span><span class="invisible">press-summer-sale-8340239?e=e6235e72b6</span></a></p><p><a href="https://fosstodon.org/tags/gischat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>gischat</span></a> <a href="https://fosstodon.org/tags/qgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>qgis</span></a> <a href="https://fosstodon.org/tags/leaflet" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>leaflet</span></a> <a href="https://fosstodon.org/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a></p>
Hacker News<p>Postgres as a Graph Database: (Ab)Using PgRouting — <a href="https://supabase.com/blog/pgrouting-postgres-graph-database" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">supabase.com/blog/pgrouting-po</span><span class="invisible">stgres-graph-database</span></a><br><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Postgres</span></a> <a href="https://mastodon.social/tags/Graph" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Graph</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/PgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PgRouting</span></a> <a href="https://mastodon.social/tags/Supabase" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Supabase</span></a> <a href="https://mastodon.social/tags/TechBlog" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechBlog</span></a> <a href="https://mastodon.social/tags/DataVisualization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataVisualization</span></a></p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p><a href="https://fosstodon.org/tags/PostGISDay" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGISDay</span></a> 2024 does not disappoint: so many inspiring talks all around 🤩 </p><p><a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://fosstodon.org/tags/pgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgRouting</span></a> <a href="https://fosstodon.org/tags/MobilityDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MobilityDB</span></a> <a href="https://fosstodon.org/tags/OSGeo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OSGeo</span></a> <a href="https://fosstodon.org/tags/GISChat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GISChat</span></a></p>
Regina Obe<p>If you haven't registered for a <a href="https://mapstodon.space/tags/FOSS4GNA" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FOSS4GNA</span></a> <span class="h-card" translate="no"><a href="https://fosstodon.org/@foss4gna" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>foss4gna</span></a></span> <a href="https://mapstodon.space/tags/pgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgRouting</span></a> <a href="https://mapstodon.space/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> <a href="https://mapstodon.space/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> don't wait register till it's too late for 2 workshops <a href="https://www.foss4gna.org/#tickets" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">foss4gna.org/#tickets</span><span class="invisible"></span></a> . <a href="https://talks.osgeo.org/foss4g-na-2024/talk/ZUW7H7/#pgRouting" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">talks.osgeo.org/foss4g-na-2024</span><span class="invisible">/talk/ZUW7H7/#pgRouting</span></a> learn how to prepare data and trip planning (car, train, bicycle) and use <a href="https://mapstodon.space/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> to display your planned route. Fundamentals of <a href="https://mapstodon.space/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> and how to use it for basic spatial analysis <a href="https://talks.osgeo.org/foss4g-na-2024/talk/BM3LAN/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">talks.osgeo.org/foss4g-na-2024</span><span class="invisible">/talk/BM3LAN/</span></a></p>
Raúl Nanclares 🍜<p><a href="https://fosstodon.org/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a> 3.6 is now included in the <a href="https://fosstodon.org/tags/Fedora" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Fedora</span></a> repos! Less compiling needed :D</p>
Jakob Miksch<p><span class="h-card" translate="no"><a href="https://urbanists.social/@markstos" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>markstos</span></a></span> I guess you must edit the OSM file when you want to use a routing engine like OpenTripPlanner, OSRM, GraphHopper or Valhalla</p><p>Alternatively you can use <a href="https://mastodon.social/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a><br>It is much slower than other routing engines but it is much easier to add custom data or to do fine grained weighting of each edge </p><p>Here a blog post <a href="https://jakobmiksch.eu/post/openstreetmap_routing/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jakobmiksch.eu/post/openstreet</span><span class="invisible">map_routing/</span></a></p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p>Awesome <a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> extension bonanza at <a href="https://fosstodon.org/tags/PostGISDay" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGISDay</span></a> presented by Regina Obe </p><p><a href="https://fosstodon.org/tags/GISChat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GISChat</span></a> <a href="https://fosstodon.org/tags/MobilityDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MobilityDB</span></a> <a href="https://fosstodon.org/tags/pgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgRouting</span></a> <a href="https://fosstodon.org/tags/h3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>h3</span></a> <a href="https://fosstodon.org/tags/PointClouds" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PointClouds</span></a> <a href="https://fosstodon.org/tags/Topology" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Topology</span></a> <a href="https://fosstodon.org/tags/geocoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>geocoding</span></a></p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p><a href="https://fosstodon.org/tags/PostGISDay" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGISDay</span></a> news -- new <a href="https://fosstodon.org/tags/book" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>book</span></a> release:</p><p>"Spatial <a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> A Practical Approach to Modern <a href="https://fosstodon.org/tags/GIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GIS</span></a> Using SQL" by Matthew Forrest at <a href="https://fosstodon.org/tags/LocatePress" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LocatePress</span></a> 📚 </p><p><a href="https://locatepress.com/book/spatial-sql" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">locatepress.com/book/spatial-s</span><span class="invisible">ql</span></a></p><p><a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> <a href="https://fosstodon.org/tags/PGRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PGRouting</span></a> <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://fosstodon.org/tags/Textbook" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Textbook</span></a> <a href="https://fosstodon.org/tags/SpatialDataScience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SpatialDataScience</span></a> <a href="https://fosstodon.org/tags/SDI" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SDI</span></a> <a href="https://fosstodon.org/tags/GISChat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GISChat</span></a></p>
RustProof Labs 🐘🌎<p><span class="h-card" translate="no"><a href="https://mapstodon.space/@pokateo" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>pokateo</span></a></span> It's cool and rainy here in Colorado!</p><p>All the playing around I've done with the H3 hexes in PostGIS is paying off in spades! I'm even using that to bring hex-based spatial analysis into MS SQL databases where some production data lives.</p><p>It's been a whole cool thing, and in the next week it'll all come together finally! I'll try to get around to writing about it 🤓 </p><p><a href="https://mastodon.social/tags/gischat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>gischat</span></a> <a href="https://mastodon.social/tags/postgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgis</span></a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgres</span></a> <a href="https://mastodon.social/tags/openstreetmap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>openstreetmap</span></a> <a href="https://mastodon.social/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a> <a href="https://mastodon.social/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a></p>
RustProof Labs 🐘🌎<p>New post: Getting started with <a href="https://mastodon.social/tags/MobilityDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MobilityDB</span></a>. A good portion of the post explains how I used PostGIS and pgRouting to prepare OpenStreetMap data to feed into MobilityDB.</p><p>Stay tuned, more to come on this topic! Barely scratching the surface here 🤓 </p><p><a href="https://blog.rustprooflabs.com/2023/08/postgis-mobility-db" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.rustprooflabs.com/2023/08</span><span class="invisible">/postgis-mobility-db</span></a></p><p><a href="https://mastodon.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> <a href="https://mastodon.social/tags/pgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgRouting</span></a> <a href="https://mastodon.social/tags/OpenStreetMap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenStreetMap</span></a> <a href="https://mastodon.social/tags/OSM" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OSM</span></a> <a href="https://mastodon.social/tags/gischat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>gischat</span></a></p>
Dave Signer<p>And as a participant I am very much looking forward to this workshop about pgRouting. <a href="https://talks.osgeo.org/foss4g-2023-workshop/talk/3Q9HNX/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">talks.osgeo.org/foss4g-2023-wo</span><span class="invisible">rkshop/talk/3Q9HNX/</span></a> I think I haven't dealt with routing that much since my bachelor thesis 15 years ago (at that time very intensively instead) but here I am again 🙂</p><p><a href="https://fosstodon.org/tags/foss4g2023" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>foss4g2023</span></a> <a href="https://fosstodon.org/tags/qgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>qgis</span></a> <a href="https://fosstodon.org/tags/opengisch" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>opengisch</span></a> <a href="https://fosstodon.org/tags/postgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgis</span></a> <a href="https://fosstodon.org/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a></p>
Elizabeth Stark<p>Looking for a good advanced book / tutorial / course on <a href="https://hachyderm.io/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> - I am rejigging our approach to managing permissions / roles / schemas / workflows and plugins like <a href="https://hachyderm.io/tags/postgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgis</span></a> and <a href="https://hachyderm.io/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a>. Would appreciate any links or even a boost to help spread the question. I promise to turn the learning into some summary blog posts in return</p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p><span class="h-card"><a href="https://mastodon.social/@IvanSanchez" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>IvanSanchez</span></a></span> <span class="h-card"><a href="https://mapstodon.space/@jeremy" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>jeremy</span></a></span><br>+1 that's the way to go. Would love to see a blog post on using the <a href="https://fosstodon.org/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a> or <a href="https://fosstodon.org/tags/qgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>qgis</span></a> plug-in solution</p><p><a href="https://fosstodon.org/tags/gischat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>gischat</span></a> <a href="https://fosstodon.org/tags/graphanalytics" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>graphanalytics</span></a></p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p>3. A Beginner’s Guide to <a href="https://fosstodon.org/tags/pgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgRouting</span></a> <br><a href="http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting/" rel="nofollow noopener" target="_blank"><span class="invisible">http://</span><span class="ellipsis">anitagraser.com/2011/02/07/a-b</span><span class="invisible">eginners-guide-to-pgrouting/</span></a></p><p>The second <a href="https://fosstodon.org/tags/Routing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Routing</span></a> post in the top-10</p><p>Eventually, I ended up implementing the <a href="https://fosstodon.org/tags/QGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>QGIS</span></a> pgRoutingLayer plugin <a href="https://plugins.qgis.org/plugins/pgRoutingLayer/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">plugins.qgis.org/plugins/pgRou</span><span class="invisible">tingLayer/</span></a></p><p><a href="https://fosstodon.org/tags/NLS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NLS</span></a> <a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostGIS</span></a> <a href="https://fosstodon.org/tags/GISChat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GISChat</span></a></p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p>8. <a href="https://fosstodon.org/tags/pgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgRouting</span></a> 2.0 for <a href="https://fosstodon.org/tags/Windows" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Windows</span></a> quick guide<br><a href="http://anitagraser.com/2013/07/06/pgrouting-2-0-for-windows-quick-guide/" rel="nofollow noopener" target="_blank"><span class="invisible">http://</span><span class="ellipsis">anitagraser.com/2013/07/06/pgr</span><span class="invisible">outing-2-0-for-windows-quick-guide/</span></a></p><p><a href="https://fosstodon.org/tags/GISChat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GISChat</span></a> <a href="https://fosstodon.org/tags/QGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>QGIS</span></a> <a href="https://fosstodon.org/tags/Routing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Routing</span></a></p>
Roel Huybrechts<p>The background map was designed in <a href="https://mastodon.social/tags/QGis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>QGis</span></a> with data from <a href="https://mastodon.social/tags/OSM" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OSM</span></a> combined with the SRTM height model from NASA. The segments and routes were optimised using a routable in-game network in <a href="https://mastodon.social/tags/PgRouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PgRouting</span></a> and were drawn on top of the map in <a href="https://mastodon.social/tags/Inkscape" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Inkscape</span></a>. Small details will be instantly recognisable for Belgian railway users.</p><p>Check out the full map and detailed making-of on my website: <a href="https://roel.huybrechts.re/2022/ticket-to-ride-belgium/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">roel.huybrechts.re/2022/ticket</span><span class="invisible">-to-ride-belgium/</span></a></p>
Raúl Nanclares 🍜<p><a href="https://fosstodon.org/tags/osm" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>osm</span></a> data to <a href="https://fosstodon.org/tags/pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgrouting</span></a> <a href="https://fosstodon.org/tags/postgis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgis</span></a> <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a> database using <a href="https://fosstodon.org/tags/osm2pgrouting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>osm2pgrouting</span></a>. Your routeable network in a few hours! Everything open. 💗 Openstreetmap</p>