[prev in list] [next in list] [prev in thread] [next in thread]
List: qgis-user
Subject: [Qgis-user] Spatial and Temporal query?
From: Robert Le Brun via QGIS-User <qgis-user () lists ! osgeo ! org>
Date: 2023-08-07 14:50:38
Message-ID: 1315469F-3D75-494D-B02F-3DD910E7D20A () lebrun ! co ! za
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi,
I am trying to execute the following:
I am studying lions, and their kill sites.
I currently have around 890 historic kill site locations with the record date on a \
CSV file (with some other attribute info). The data is old and I am looking to \
confirm the reliability of it (looking for additional proof) by looking at the collar \
(movement) data, a different CSV file with many (67000) locations and their dates, of \
the lions over the time around when the kills were recorded.
So, within a 300m radius of each Kill location I am looking to see what movement \
happened within the 300m area 3 months before and 2 weeks after the kill (date) was \
recorded.
I have made a buffer around each kill, have clipped the points that fall within the \
300m area but cannot separate and sort them efficiently.
There are 890 Kill sites and 67000 movement points over a 12 year period that I need \
to analyse, so doing the entire process manually isn't feasible.
I have tried the DB manager using the following SQL Query but this doesn't seem to \
extract exactly what's needed:
select row_number() over() as id,
kill.killdate,
track.tracktime,
case
when track.geometry is null then 'No track within 300 m'
when julianday(killdate)-julianday(tracktime) < -14 then '2 weeks after'
when julianday(killdate)-julianday(tracktime) > 90 then '3 months before'
else 'Unreliable kill'
end validation,
kill.geometry
from lionkillsite as kill
left join liongpstrack as track
on st_distance(kill.geometry, track.geometry) < 300
My kill table/layer is named lionkillsite, gps track table liongpstrack, my date \
field in kill table killdate, track date column tracktime.
Thanks.
[Attachment #5 (unknown)]
<html><head><meta http-equiv="Content-Type" content="text/html; \
charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
line-break: after-white-space;" class=""><span style="font-size: 14px;" \
class="">Hi, </span><div class=""><span style="font-size: 14px;" class=""><br \
class=""></span></div><div class=""><span style="font-size: 14px;" class="">I am \
trying to execute the following:</span></div><div class=""><br class=""></div><div \
class=""><p style="margin: 0px 0px 1.1em; padding: 0px; border: 0px; \
font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class="">I am studying lions, and their kill sites.</p><p style="margin: \
0px 0px 1.1em; padding: 0px; border: 0px; font-variant-ligatures: normal; \
font-variant-numeric: inherit; font-variant-east-asian: inherit; \
font-variant-alternates: inherit; font-stretch: inherit; line-height: inherit; \
font-family: -apple-system, system-ui, "Segoe UI Adjusted", "Segoe \
UI", "Liberation Sans", sans-serif; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class="">I currently have around 890 historic kill site locations with the \
record date on a CSV file (with some other attribute info). The data is old and I am \
looking to confirm the reliability of it (looking for additional proof) by looking at \
the collar (movement) data, a different CSV file with many (67000) locations and \
their dates, of the lions over the time around when the kills were recorded.</p><p \
style="margin: 0px 0px 1.1em; padding: 0px; border: 0px; font-variant-ligatures: \
normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; \
font-variant-alternates: inherit; font-stretch: inherit; line-height: inherit; \
font-family: -apple-system, system-ui, "Segoe UI Adjusted", "Segoe \
UI", "Liberation Sans", sans-serif; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class="">So, within a 300m radius of each Kill location I am looking to see \
what movement happened within the 300m area 3 months before and 2 weeks after the \
kill (date) was recorded.</p><div style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class="">I have made a buffer around each kill, have clipped the points \
that fall within the 300m area but cannot separate and sort them \
efficiently. </div></div><div style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class=""><br class=""></div><div style="margin: 0px; padding: 0px; border: \
0px; font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class="">There are 890 Kill sites and 67000 movement points over a 12 year \
period that I need to analyse, so doing the entire process manually isn't \
feasible.</div><div style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class=""><br class=""></div><div style="margin: 0px; padding: 0px; border: \
0px; font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class="">I have tried the DB manager using the following SQL Query but this \
doesn't seem to extract exactly what's needed:</div><div style="margin: 0px; padding: \
0px; border: 0px; font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class=""><br class=""></div><div style="margin: 0px; padding: 0px; border: \
0px; font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: inherit; font-family: -apple-system, system-ui, "Segoe UI \
Adjusted", "Segoe UI", "Liberation Sans", sans-serif; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 15px; vertical-align: baseline; \
box-sizing: inherit; clear: both; --_pr-img-mb: 0; color: rgb(35, 38, 41); orphans: \
2; widows: 2; background-color: rgb(249, 248, 246); text-decoration-thickness: \
initial;" class=""><pre class="s-code-block lang-sql" style="margin-top: 0px; \
margin-bottom: calc(1.5em); padding: var(--su12); border: 0px; \
font-variant-ligatures: normal; font-variant-numeric: inherit; \
font-variant-east-asian: inherit; font-variant-alternates: inherit; font-stretch: \
inherit; line-height: var(--lh-md); font-family: var(--ff-mono); font-optical-sizing: \
inherit; -webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: var(--fs-body1); vertical-align: \
baseline; box-sizing: inherit; width: auto; max-height: 600px; overflow: auto; \
background-color: var(--highlight-bg); border-radius: var(--br-md); \
--_cb-line-numbers-bg: var(--black-050); color: var(--highlight-color); \
overflow-wrap: normal; text-decoration-thickness: initial;"><code class="language-sql \
hljs" style="margin: 0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: var(--_pr-code-fs); \
vertical-align: baseline; box-sizing: inherit; white-space: inherit;"><i \
class=""><span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">select</span> <span class="hljs-built_in" style="margin: \
0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-literal);">row_number</span>() <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">over</span>() <span class="hljs-keyword" style="margin: \
0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-keyword);">as</span> id, kill.killdate,
track.tracktime,
<span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">case</span> <span class="hljs-keyword" style="margin: \
0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-keyword);">when</span> track.geometry \
<span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">is</span> <span class="hljs-keyword" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-keyword);">null</span> <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">then</span> <span class="hljs-string" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-variable);">'No track within 300 \
m'</span> <span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">when</span> julianday(killdate)<span class="hljs-operator" \
style="margin: 0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit;">-</span>julianday(tracktime) <span class="hljs-operator" \
style="margin: 0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit;"><</span> <span class="hljs-number" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-namespace);">-14</span> <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">then</span> <span class="hljs-string" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-variable);">'2 weeks after'</span> <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">when</span> julianday(killdate)<span class="hljs-operator" \
style="margin: 0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit;">-</span>julianday(tracktime) <span class="hljs-operator" \
style="margin: 0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit;">></span> <span class="hljs-number" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-namespace);">90</span> <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">then</span> <span class="hljs-string" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-variable);">'3 months before'</span> \
<span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">else</span> <span class="hljs-string" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-variable);">'Unreliable kill'</span> \
<span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">end</span> validation, kill.geometry
<span class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">from</span> lionkillsite <span class="hljs-keyword" \
style="margin: 0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-keyword);">as</span> kill <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">left</span> <span class="hljs-keyword" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-keyword);">join</span> liongpstrack <span \
class="hljs-keyword" style="margin: 0px; padding: 0px; border: 0px; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; font-size: 13px; \
vertical-align: baseline; box-sizing: inherit; color: \
var(--highlight-keyword);">as</span> track <span class="hljs-keyword" style="margin: \
0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-keyword);">on</span> \
st_distance(kill.geometry, track.geometry) <span class="hljs-operator" style="margin: \
0px; padding: 0px; border: 0px; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit;"><</span> <span class="hljs-number" style="margin: 0px; \
padding: 0px; border: 0px; font-variant-ligatures: inherit; font-variant-position: \
inherit; font-variant-caps: inherit; font-variant-numeric: inherit; \
font-variant-alternates: inherit; font-variant-east-asian: inherit; font-stretch: \
inherit; line-height: inherit; font-family: inherit; font-optical-sizing: inherit; \
-webkit-font-kerning: inherit; font-feature-settings: inherit; \
font-variation-settings: inherit; font-size: 13px; vertical-align: baseline; \
box-sizing: inherit; color: var(--highlight-namespace);">300</span></i><span \
style="font-style: inherit;" class=""> </span></code></pre><p style="margin: 0px 0px \
1.1em; padding: 0px; border: 0px; font-variant-ligatures: normal; \
font-variant-numeric: inherit; font-variant-east-asian: inherit; \
font-variant-alternates: inherit; font-stretch: inherit; line-height: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; vertical-align: baseline; box-sizing: \
inherit; clear: both; --_pr-img-mb: 0; text-decoration-thickness: initial;" \
class="">My kill table/layer is named <strong style="margin: 0px; padding: 0px; \
border: 0px; font-style: inherit; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; vertical-align: baseline; box-sizing: \
inherit;" class="">lionkillsite</strong>, gps track table <strong style="margin: \
0px; padding: 0px; border: 0px; font-style: inherit; font-variant-ligatures: inherit; \
font-variant-position: inherit; font-variant-caps: inherit; font-variant-numeric: \
inherit; font-variant-alternates: inherit; font-variant-east-asian: inherit; \
font-stretch: inherit; line-height: inherit; font-family: inherit; \
font-optical-sizing: inherit; -webkit-font-kerning: inherit; font-feature-settings: \
inherit; font-variation-settings: inherit; vertical-align: baseline; box-sizing: \
inherit;" class="">liongpstrack</strong>, my date field in kill table <strong \
style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; \
font-variant-ligatures: inherit; font-variant-position: inherit; font-variant-caps: \
inherit; font-variant-numeric: inherit; font-variant-alternates: inherit; \
font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; \
font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: inherit; \
font-feature-settings: inherit; font-variation-settings: inherit; vertical-align: \
baseline; box-sizing: inherit;" class="">killdate</strong>, track date \
column <strong style="margin: 0px; padding: 0px; border: 0px; font-style: \
inherit; font-variant-ligatures: inherit; font-variant-position: inherit; \
font-variant-caps: inherit; font-variant-numeric: inherit; font-variant-alternates: \
inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: \
inherit; font-family: inherit; font-optical-sizing: inherit; -webkit-font-kerning: \
inherit; font-feature-settings: inherit; font-variation-settings: inherit; \
vertical-align: baseline; box-sizing: inherit;" \
class="">tracktime</strong>. </p><div class="">Thanks.</div></div></body></html>
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic