Is there an #opensource moving objects database extension for @postgresql @postgis? #giscience #compsci #gistribe
7:16pm Aug 3rd 2016 via TweetDeck
Only found Hermes hermes-mod.java.net but it's not open source #gistribe
7:23pm Aug 3rd 2016 via TweetDeck in reply to underdarkGIS
This is doable by using daterange or tstzrange types for temporal and postgis for spatial aspects. postgresql.org/docs/current/s…
8:54pm Aug 3rd 2016 via TweetDeck in reply to underdarkGIS
Do you know any examples where this is used to model moving objects e.g. cars or animals? #gistribe
11:22am Aug 4th 2016 via TweetDeck in reply to hruske
No, not really. I can come up with an example, if it helps.
1:14pm Aug 4th 2016 via TweetDeck in reply to underdarkGIS
If it's not too much trouble, that would be great! Essentially, I envision a moving point (trajectory) datatype
1:19pm Aug 4th 2016 via TweetDeck in reply to hruske
e.g. which truck passed checkpoint A during a given hour, should interpolate positions between observations
8:08am Aug 5th 2016 via TweetDeck in reply to pwramsey hruske
or when and where were truck A and B at the same location
8:09am Aug 5th 2016 via TweetDeck in reply to underdarkGIS pwramsey hruske
between the temporal and linear referencing in postgis, all the functionality is there
1:26pm Aug 5th 2016 via Twitter for Android in reply to pwramsey underdarkGIS hruske
.@bitnerd @pwramsey @hruske lot of queries working already, thanks to your recommendations. Any tips for computing speeds along LinestringM?
9:53pm Aug 9th 2016 via TweetDeck in reply to bitnerd
You could do a sum(ST_Length(geom, true)) / (upper(timeslice) - lower(timeslice)) calc to get avg. speed @bitnerd @pwramsey
10:05pm Aug 9th 2016 via TweetDeck in reply to underdarkGIS
thank you! Was thinking of speed between consecutive points rather than just average over whole trajectory
10:06pm Aug 9th 2016 via TweetDeck in reply to hruske bitnerd pwramsey
Yeah, you don't need to sum it, you can do this per row, at least as per my example, and get segment speed. @bitnerd @pwramsey
10:10pm Aug 9th 2016 via TweetDeck in reply to underdarkGIS
great, so I'll try with lead window fun. Thank you!
10:18pm Aug 9th 2016 via Twitter for Android in reply to hruske bitnerd pwramsey
any recomm. to get location along LinestringM trajectories at a certain time each day, e.g. any day at midnight?
2:57pm Feb 20th 2017 via TweetDeck in reply to underdarkGIS hruske bitnerd pwramsey
You're storing timestamps in measure, right?
4:22pm Feb 20th 2017 via TweetDeck in reply to underdarkGIS bitnerd pwramsey
4:33pm Feb 20th 2017 via Twitter for Android in reply to hruske bitnerd pwramsey
I can query one certain day at midnight but not all possible midnights that way, as far as I can tell ...
4:53pm Feb 20th 2017 via TweetDeck in reply to pwramsey hruske bitnerd
ooooh, totally doable. My kind of puzzle, will play tmrw when at computer
7:41pm Feb 20th 2017 via Twitter for Android in reply to underdarkGIS pwramsey hruske
great, thank you! I'll also give this puzzle a go some more
12:02pm Feb 21st 2017 via TweetDeck in reply to bitnerd pwramsey hruske
your optimism was a great motivation, here's my first take, if trajectories don't cross day borders
12:22pm Feb 21st 2017 via TweetDeck in reply to underdarkGIS bitnerd pwramsey hruske
Nice work! Here's the solution to the speed along trajectory question btw anitagraser.com/2016/10/09/mov…
12:54pm Feb 21st 2017 via TweetDeck in reply to billdollins
Connect with Twitter
A website by @jwheare