todd ellis<p><a href="https://eldritch.cafe/tags/RStats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RStats</span></a> <a href="https://eldritch.cafe/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://eldritch.cafe/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> question!</p><p>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. </p><p>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.</p><p>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.</p>
Recent searches
No recent searches
Search options
Only available when logged in.
eupolicy.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
This Mastodon server is a friendly and respectful discussion space for people working in areas related to EU policy. When you request to create an account, please tell us something about you.
Administered by:
Server stats:
226active users
eupolicy.social: About · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.3.6
#postgis
0 posts · 0 participants · 0 posts today
Bora M. Alper<p>I'm very impressed how easy it is to use <a href="https://mastodon.social/tags/OpenStreetMap" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenStreetMap</span></a> data locally:</p><p>1. Download a subset of OSM on <a href="https://download.geofabrik.de/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">download.geofabrik.de/</span><span class="invisible"></span></a> for your country.<br>2. Use Osmium to filter by tags and export into a TSV.<br>3. Import the TSV into <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> using a single \copy command.<br>4. Create a btree_gist index for <a href="https://mastodon.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> geospatial and ordinary queries.</p><p>In less than 5 min, you're ready to run queries like "nearest restaurants around me" locally & fast!</p><p>Kudos for making it so simple, which is not easy. =)</p>
Amᵃᵖanda 🔜 CFC<p>oh boy, `spatialite` doesn't use a geographic index? You need to do this complicated nested queries to use it?</p><p>🤯🤯🤯</p><p>Maybe I need to switch to <a href="https://en.osm.town/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a> <br><a href="https://en.osm.town/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://en.osm.town/tags/gis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gis</span></a> <a href="https://en.osm.town/tags/spatialite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spatialite</span></a></p>
Regina Obe<p>Oregon State University | Open Source Lab ( <a href="https://mapstodon.space/tags/OSUOSL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OSUOSL</span></a>) 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) <a href="https://lists.osgeo.org/pipermail/sac/2025-April/016732.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">lists.osgeo.org/pipermail/sac/</span><span class="invisible">2025-April/016732.html</span></a> Projects under <a href="https://mapstodon.space/tags/OSGeo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OSGeo</span></a> are <a href="https://mapstodon.space/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a>, pgRouting, <a href="https://mapstodon.space/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>QGIS</span></a> 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.</p>
tardisx<p>I always wanted to play with osm2pgsql. Getting it running was easier than I thought. I now have access to crucial information, like knowing I'd have to travel 3200km to reach the bakery which is furthest from my house but still on the Australian mainland.</p><p><a href="https://fosstodon.org/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/osm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>osm</span></a></p>
Sven Geggus<p><span class="h-card" translate="no"><a href="https://chaos.social/@blinry" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>blinry</span></a></span> There is a tool called nik4 which can render such images <a href="https://github.com/Zverik/Nik4" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/Zverik/Nik4</span><span class="invisible"></span></a>. Unfortunately it will need a full featured <a href="https://karlsruhe-social.de/tags/Postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgis</span></a> Rendering-Database containing OSM Data. An easier but less flexible way to get printable maps is <a href="https://print.get-map.org" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">print.get-map.org</span><span class="invisible"></span></a></p>
geoObserver<p><a href="https://mastodon.social/tags/FOSSGIS2025" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSSGIS2025</span></a> <a href="https://mastodon.social/tags/overpass" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>overpass</span></a> <a href="https://mastodon.social/tags/turbo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>turbo</span></a> goes <a href="https://mastodon.social/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a> mit frederik ram @geofabrik</p>
Oslandia<p>👋 <a href="https://fosstodon.org/tags/introduction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>introduction</span></a></p><p>🗺 Oslandia is a French SME specializing in OpenSource Geographical Systems ( <a href="https://fosstodon.org/tags/GIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GIS</span></a> ). We design and implement IT systems to manage geographical data.</p><p>🎓 We are an opensource editor of <a href="https://fosstodon.org/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>QGIS</span></a>, experts of <a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a>, <a href="https://fosstodon.org/tags/GDAL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GDAL</span></a>, <a href="https://fosstodon.org/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a>, Web 3D visualization & more …</p><p>👩💻 Our team of ~30 (great) people is distributed all over France & full remote is at the heart of our organization.</p><p>🔗 More info : <a href="https://oslandia.com" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">oslandia.com</span><span class="invisible"></span></a> and linkedin</p><p>➡️ We will post company updates and GIS-related infos</p>
Dr John A Stevenson<p><span class="h-card" translate="no"><a href="https://mastodon.me.uk/@robintw" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>robintw</span></a></span> The crucial difference between <a href="https://fosstodon.org/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>QGIS</span></a> and <a href="https://fosstodon.org/tags/ESRI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ESRI</span></a> tools is their relationship to the underlying data structures.</p><p>QGIS was written as a front-end to <a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a>. As such, it respects all the data management e.g. IDs, relationships and constraints from the db. This applies to Oracle, GeoPackage, too. All other DB tooling e.g. SQL scripting works as normal.</p><p>1/2</p>
Geotribu<p>💫 Rejoignez le côté <a href="https://mapstodon.space/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>QGIS</span></a> de la Force au travers de cette <a href="https://mapstodon.space/tags/GeoRDP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GeoRDP</span></a> teintée de sabres géolaser, de <a href="https://mapstodon.space/tags/mviewer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mviewer</span></a>, de paquets python de la <a href="https://mapstodon.space/tags/MAIF" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MAIF</span></a> et de l'<span class="h-card" translate="no"><a href="https://social.numerique.gouv.fr/@InseeFr" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>InseeFr</span></a></span>, d'ipv6, de <a href="https://mapstodon.space/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> qui bruissent et qui barrissent...</p><p>Cela écrit à plusieurs mains, avec de la contribution que la <a href="https://mapstodon.space/tags/Geotribu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Geotribu</span></a> est toujours ravie d'accueillir !</p><p>✍️ Thomas Bouché - Loic Ecault - <span class="h-card" translate="no"><a href="https://mapstodon.space/@geojulien" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>geojulien</span></a></span> - <span class="h-card" translate="no"><a href="https://mapstodon.space/@guilhem_allaman" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>guilhem_allaman</span></a></span> </p><p>👏 Thanks <span class="h-card" translate="no"><a href="https://mapstodon.space/@pokateo" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>pokateo</span></a></span> for the visuals !</p><p>N'hésitez pas à vous manifester pour la prochaine 😉 </p><p>🔗 <a href="https://geotribu.fr/rdp/2025/rdp_2025-02-21/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">geotribu.fr/rdp/2025/rdp_2025-</span><span class="invisible">02-21/</span></a></p>
Cédric Villemain<p><span class="h-card" translate="no"><a href="https://fosstodon.org/@data_bene" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>data_bene</span></a></span> qui héberge <span class="h-card" translate="no"><a href="https://mastodon.social/@oslandia" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>oslandia</span></a></span> a cette occasion, <a href="https://mastodon.tetaneutral.net/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a> et <a href="https://mastodon.tetaneutral.net/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> sur le même stand!</p>
Anita Graser 🇪🇺🇺🇦🇬🇪<p>What's your favorite minimal geospatial (meta)data management stack right now? </p><p>Guess a classic would be <a href="https://fosstodon.org/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> and <a href="https://fosstodon.org/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>QGIS</span></a> PgMetadata plugin </p><p>Cloud-native / flat file-only equivalents? <a href="https://fosstodon.org/tags/STAC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>STAC</span></a> all the way?</p><p><a href="https://fosstodon.org/tags/GISChat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GISChat</span></a></p>
Sandro Santilli<p><a href="https://mapstodon.space/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> 3.5.2 is out:<br><a href="https://postgis.net/2025/01/PostGIS-3.5.2/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">postgis.net/2025/01/PostGIS-3.</span><span class="invisible">5.2/</span></a></p>
LavX News<p>Unlocking the Power of GIS: A Comprehensive Laravel Project for Developers</p><p>Dive into the world of Geographical Information Systems (GIS) with a new educational project built on Laravel, PostGIS, and OpenLayers. This initiative not only serves as a learning platform for devel...</p><p><a href="https://news.lavx.hu/article/unlocking-the-power-of-gis-a-comprehensive-laravel-project-for-developers" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.lavx.hu/article/unlocking</span><span class="invisible">-the-power-of-gis-a-comprehensive-laravel-project-for-developers</span></a></p><p><a href="https://mastodon.cloud/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>news</span></a> <a href="https://mastodon.cloud/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://mastodon.cloud/tags/Laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Laravel</span></a> <a href="https://mastodon.cloud/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> <a href="https://mastodon.cloud/tags/OpenLayers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenLayers</span></a></p>
Astrid Emde<p>Willkommen 2025! Freue mich auf ein weiteres Jahr als Dozentin der FOSS Academy.</p><p>Unter dem Motto "Aufwind durch Wissen" schult das FOSS Academy Team schon seit Jahren rund um das Thema Open Source Geospatial.</p><p>Die Themen sind <a href="https://mastodon.social/tags/OpenStreetMap" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenStreetMap</span></a> <a href="https://mastodon.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> <a href="https://mastodon.social/tags/QGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>QGIS</span></a> <a href="https://mastodon.social/tags/Mapbender" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Mapbender</span></a> <a href="https://mastodon.social/tags/MapServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MapServer</span></a> <a href="https://mastodon.social/tags/GeoServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GeoServer</span></a> <a href="https://mastodon.social/tags/MapProxy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MapProxy</span></a> <a href="https://mastodon.social/tags/GDI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GDI</span></a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://mastodon.social/tags/Geospatial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Geospatial</span></a> <a href="https://mastodon.social/tags/FOSSGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSSGIS</span></a> <a href="https://mastodon.social/tags/OSGeo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OSGeo</span></a> & mehr</p><p>Darüber hinaus findet an jedem 1. Donnerstag im Monat ein kostenloses einstündiges Web-Seminar statt.</p><p>Informationen unter<br><a href="https://foss-academy.com" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">foss-academy.com</span><span class="invisible"></span></a></p>
FOSS Academy<p>Am kommenden Donnerstag 9. Januar 2025 starten die monatlichen <span class="h-card" translate="no"><a href="https://mastodon.social/@foss_academy" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>foss_academy</span></a></span> Web-Seminare 2025!</p><p>Im Web-Seminar mit Mathias Gröbe geht es um:</p><p><a href="https://mastodon.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> Tipps und Tricks – Geodatenverarbeitung mit <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p><p>Kostenloses einstündiges Web-Seminar<br>10.00 - 11.00 Uhr<br>Jetzt schon anmelden!<br><a href="https://foss-academy.com/web-seminare/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">foss-academy.com/web-seminare/</span><span class="invisible"></span></a><br><a href="https://mastodon.social/tags/FOSSGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSSGIS</span></a> <a href="https://mastodon.social/tags/GIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GIS</span></a> <a href="https://mastodon.social/tags/GEOSPATIAL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GEOSPATIAL</span></a> <a href="https://mastodon.social/tags/FOSS4G" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS4G</span></a> <a href="https://mastodon.social/tags/OSGeo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OSGeo</span></a> <a href="https://mastodon.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a> <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a></p>
Felt<p>Using PostGIS and need a modern cloud-native GIS for spatial data analysis and visualization? Connect your PostgreSQL database with Felt! Preview live layers, keep data up-to-date, and build powerful dashboards for the entire team. Learn more here: <a href="https://felt.com/blog/felt-postgis-integration-gis-database-spatial-analysis-and-visualization?utm_source=mastodon&utm_medium=social&utm_campaign=source_connectors" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">felt.com/blog/felt-postgis-int</span><span class="invisible">egration-gis-database-spatial-analysis-and-visualization?utm_source=mastodon&utm_medium=social&utm_campaign=source_connectors</span></a></p><p><a href="https://mas.to/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://mas.to/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a> <a href="https://mas.to/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>data</span></a> <a href="https://mas.to/tags/gis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gis</span></a></p>
Jeroen Ticheler<p>“Without <a href="https://mastodon.nl/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a>, <a href="https://mastodon.nl/tags/FOSS4G" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS4G</span></a> would not be here” <br>Quote from Gilberto Camara in his opening keynote at <a href="https://mastodon.nl/tags/FOSS4G2024" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS4G2024</span></a><br>Congratulatory David Blasby & Paul Ramsey!</p>
Camille Monchicourt<p>Le Parc national des Écrins recherche un·e stagiaire en développement web (<a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a>, <a href="https://mastodon.social/tags/Flask" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Flask</span></a>, <a href="https://mastodon.social/tags/Django" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Django</span></a>, <a href="https://mastodon.social/tags/Javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Javascript</span></a>, <a href="https://mastodon.social/tags/Typescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Typescript</span></a>, <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a>, <a href="https://mastodon.social/tags/PostGIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostGIS</span></a>, <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a>) : <a href="https://www.ecrins-parcnational.fr/stage-developpement-web-python-javascript-postgis" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">ecrins-parcnational.fr/stage-d</span><span class="invisible">eveloppement-web-python-javascript-postgis</span></a></p><p>Celui-ci fera une analyse comparative des différentes solutions technologiques et travaillera ensuite sur la modernisation et l'homogénéisation des outils d'inventaire du patrimoine bâti et géologique, ainsi que le suivi des constats de prédation.</p>
Marcos Dione<p>Thanks to <a href="https://botsin.space/@planetpostgresql/113510452678670732" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">botsin.space/@planetpostgresql</span><span class="invisible">/113510452678670732</span></a> I got importing Europe on my puny rig from some 43h to 14h! I didn't quite used the same numbers because I only have 32GiB and it's also my desktop, and I'm also pretty sure I can reduce some numbers given that I don't import the whole planet.</p><p><a href="https://en.osm.town/tags/OpenStreetMap" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenStreetMap</span></a> <a href="https://en.osm.town/tags/osm2pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>osm2pgsql</span></a> <a href="https://en.osm.town/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://en.osm.town/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a></p>
ExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload