hunleyd, to postgres
@hunleyd@fosstodon.org avatar
jriou, to random
@jriou@hachyderm.io avatar

I'm trying to build a database for my Hard Rock Café t-shirt collection and use and to find the next one to buy/visit.

It turns out the API returns 50 locations but not Amsterdam. But if I search specifically for the "Hard Rock Café Amsterdam", it's there https://www.openstreetmap.org/node/497179291

Limit is set to 1000 results.

Does anyone know why?

strk, to random
@strk@mapstodon.space avatar

I've uploaded a new version of the Topology editor plugin

The most time consuming part was drawing the icons, I hope you will
appreciate them :)

https://plugins.qgis.org/plugins/pgtopoeditor

Utopiageo, to PostgreSQL French
@Utopiageo@framapiaf.org avatar

Nous recherchons un administrateur de base de données / à Grenoble Alpes métropole
https://recrutement.grenoblealpesmetropole.fr/?page=advertisement_display&id=2288

Et aussi un apprenti ...
https://recrutement.grenoblealpesmetropole.fr/?page=advertisement_display&id=2334

Avec beaucoup de ❤️

wardrup, to random
@wardrup@babka.social avatar

It appears my Tiger geocoder isn't working well. Points aren't even being geocoded to the same street. I've even used the address standardizer function before passing them into the geocoder but it doesn't help. The address standardizer output looks great, too!

Anyone have any ideas?

foss4g, to random
@foss4g@fosstodon.org avatar

FOSS4G 2024
Belém, Pará, Brazil. December 01 - 08, 2024.

FOSSGISeV, to random German
@FOSSGISeV@mastodon.online avatar

Großes Interesse an der Session rund um API 😊
auf der

image/jpeg
image/jpeg

geoObserver, to opensource German
@geoObserver@mastodon.social avatar
louis, to PostgreSQL
@louis@emacs.ch avatar

TIL: grouping spatial objects by their proximity to each other is solved by the "Density-based spatial clustering of applications with noise (DBSCAN)" algorithm.

https://en.wikipedia.org/wiki/DBSCAN

And thanks to PostGIS I could solve a difficult task today in a matter of minutes.

Thanks,

jakobmiksch, to postgres German
@jakobmiksch@mastodon.social avatar

I always have to look up again how to start a basic database with . That’s why I write it down:

https://gist.github.com/JakobMiksch/696379464ba29dc459a8fdbe001ba15a

niconoe, to python
@niconoe@fosstodon.org avatar

Good afternoon!

I'll have some availability (2 days/week) starting in April. Don't hesitate to contact me for your projects!

Keywords: ...

jspath55, (edited ) to random
@jspath55@chaos.social avatar

I made progress learning fundamentals with .
https://jspath55.blogspot.com/2024/02/turning-meats-and-bounds-into-map.html
- "Meats & Bounds"

Mixed_Pixels, to random

We have a static STAC with +/- 25.000 images. A simple spatial + temporal query takes about 50 seconds. That's too long. Which options do we have to improve the performance?

vpicavet,
@vpicavet@mastodon.social avatar
geonews, to random
@geonews@mastodon.social avatar
RagnarHeidar, to random
@RagnarHeidar@mastodon.social avatar

We finally managed to publish an English version of the volcanic hazard map for

Out of all the map I´ve made at the Icelandic Met Office this series of hazard maps is the biggest one yet in terms of impact, internal discussion, public discussion and weight it bears and all the decision that are made based on it. I see this map all over the internet, TikTok, YouTube thumbnails, Facebook, you name it. There is probably enough material for an extended conference talk just about this map

RagnarHeidar,
@RagnarHeidar@mastodon.social avatar

@vpicavet Yes, every single layer on this map is Additionally, the whole software stack used to create this map is including and

@osgeo 🙏🏻

lostmapper, to PostgreSQL

If you prefer articles over videos I now have a written version of "Getting Started with PostGIS in QGIS on macOS": https://lostmapper.medium.com/getting-started-with-postgis-in-qgis-on-macos-4f9c0ce8df04

jakobmiksch, to php
@jakobmiksch@mastodon.social avatar
strk, to random
@strk@mapstodon.space avatar

manual is being translated to multiple languages using
an OSGeo self-hosted instance of .

If you want to help translating it to your language you can point your
browser to https://weblate.osgeo.org/projects/postgis/ and login with
your OSGeo UserID credentials (see https://id.osgeo.org).

geonews, to random
@geonews@mastodon.social avatar
GregCocks, to PostgreSQL
@GregCocks@techhub.social avatar

'Geospatial Analysis With SQL', B.P. McClain, 2022

[I received a new version of this book - and so wanted to repost my original review]

https://post.news/@/kiwiincolorado/2YW3DEvvhqnlEmAbw2ej6QEWbHH <-- my (solicited) technical book review

@datamongerbonny @PacktPublishing

[disclaimers – (i) a publisher’s representative solicited a review of this book and provided an e-book version for that purpose but no recompense, (ii) this is my impartial, personal review - and hence is not an endorsement by my employer, implicit or otherwise.]

screen shot - Figure 1.19 - adding extensions to the database - Geospatial Analysis With SQL
screen shot - Figure 7.21 - pgAdmin display showing data output of n=15 hospitals - Geospatial Analysis With SQL
book cover - Geospatial Analysis With SQL

underdarkGIS, to random
@underdarkGIS@fosstodon.org avatar

Awesome extension bonanza at presented by Regina Obe

underdarkGIS, (edited ) to opensource
@underdarkGIS@fosstodon.org avatar

news -- new release:

"Spatial A Practical Approach to Modern Using SQL" by Matthew Forrest at 📚

https://locatepress.com/book/spatial-sql

geonews, to random
@geonews@mastodon.social avatar
underdarkGIS, to opensource
@underdarkGIS@fosstodon.org avatar

is an data management and analytics platform for (https://github.com/MobilityDB/MobilityDB). Its core function is to efficiently store and query tracks, such as vehicle . It implements the specification. MobilityDB is engineered from and , providing via

More in Esteban's talk on
https://www.crunchydata.com/community/events/postgis-day-2023

underdarkGIS, (edited ) to datascience
@underdarkGIS@fosstodon.org avatar
underdarkGIS,
@underdarkGIS@fosstodon.org avatar

is organized by the developers of , an extensions for and to manage movement data

MobilityDB is also an @osgeo community project

  • All
  • Subscribed
  • Moderated
  • Favorites
  • megavids
  • kavyap
  • DreamBathrooms
  • thenastyranch
  • magazineikmin
  • khanakhh
  • InstantRegret
  • Youngstown
  • ngwrru68w68
  • slotface
  • rosin
  • tacticalgear
  • mdbf
  • Durango
  • JUstTest
  • modclub
  • osvaldo12
  • ethstaker
  • cubers
  • normalnudes
  • everett
  • tester
  • GTA5RPClips
  • Leos
  • cisconetworking
  • provamag3
  • anitta
  • lostlight
  • All magazines