-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of DelazJ
Sent: Tuesday, 21 May 2019 1:51 PM
To: Bernd Vogelgesang
Cc: qgis-user
Subject: Re: [Qgis-user] Query cross-table "similar" time stamps?
Hi Bernd
I did not understand that you were looking for a way to create a virtual
Hi Bernd
I did not understand that you were looking for a way to create a virtual
layer. Virtual layers require SQL instructions and in this particular case,
I think you'll need window function (I don't know if supported by the
SpatiaLite provider in the backend and don't have time to give it a
Hi Harrisou,
this looks a lot what I imagined (in the sense of some wicked nested
expression stuff i never would get to myself).
Am 18.05.19 um 11:42 schrieb DelazJ:
Hi Bernd,
Hum.. interesting. Assuming you have two layers: *tracks (id_track,
date_track)* and *birds(id_bird, date_bird)*, the
Hi Bernd,
Hum.. interesting. Assuming you have two layers: *tracks (id_track,
date_track)* and *birds(id_bird, date_bird)*, the idea is to get the id of
the highest among the date_track(s) lower than the date_bird for each bird.
Am I right?
I gave it a shot and i think i have some working
Hi Mike,
thank you for your hint, but the distance between the point and the
track is of no relevance for me.
It seems that the screenshot I posted is a bit misleading
(https://i.stack.imgur.com/MqPhK.jpg). Seems I picked a point where the
associated trackpoints are also the closest ones. But
Hi,
I'm thinking this is easier done outside of QGIS, but if you
want to do in within QGIS this is one way:
https://www.qgistutorials.com/en/docs/nearest_neighbor_analysis.html
Mike
On 5/15/2019 1:17 PM, qgis-user-requ...@lists.osgeo.org wrote:
Hi folks,
I'm sure there must be some "easy"
Uupss, wrong link. That was a similar question from 7 years ago ;)
https://gis.stackexchange.com/q/322544/8202
Bernd
Am 15.05.19 um 13:27 schrieb Bernd Vogelgesang:
Hi folks,
I'm sure there must be some "easy" solution, but hours of searching
provided no examples I could learn from to develop
Hi folks,
I'm sure there must be some "easy" solution, but hours of searching
provided no examples I could learn from to develop a solution:
I have a point layer of bird observations and a GPS-track recorded while
observing the birds in an area.
For the interpretation of the findings it would be