“It was raining in Beyoğlu, and the rented Mercedes slid past the grilled and unlit windows of cautious Greek and Armenian jewelers. The street was almost empty, only a few dark-coated figures on the sidewalks turning to stare after the car.
‘This was formerly the prosperous European section of Ottoman Istanbul,’ purred the Mercedes.”
| Website | https://jaxartes.net |
| Location | Berlin |
Thank you to everyone who joined us last night for a delightful Geomob Berlin.
Here's our recap of the evening.
First things first, thanks to hosts UP42 https://up42.com for sharing their office with us.
UP42 is currently hiring: https://up42.com/company/careers
1/n
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/
Slides from my talk on "Aircraft Trajectories in PostGIS" at FOSS4G: https://www.jaxartes.net/Trigona-Harany%20-%20Aircraft%20trajectories%20in%20PostGIS%20-%20FOSS4G%202023.pdf
There should be a video at some point as well.
Sounds like a great idea right? In this episode, Paul Ramsey explains why you shouldn't ... unless you want to ... and how you can ... if you have to. You can find Paul's blog here: http://blog.cleverelephant.ca/about Previous episodes with Pau...
PostGIS supports geometries with a Z dimension and geometries with measure values, but there are not a lot of examples of *both* of these being used together. One use case is the analysis of airplane tracks which requires both - that is to say every vertex has an altitude and a timestamp. This talk will show how to convert ADS-B data transmitted from aircraft into these LINESTRINGZM geometries, which can then be analyzed as trajectories using native PostGIS functions. With this dataset and this tool, we can do things such as determine anomalous changes in an aircraft's velocity or altitude and find the exact point in time at which two aircraft came closest to one another. I will cover how to use Python and PostgreSQL's PL/Python language extension to import the data and QGIS to render the data, but the analysis will be be done in SQL.
Geomob
Paul Ramsey 🗳️