Timeline for Select points based on their date & their location (they fall within a radius of another point)
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 31, 2023 at 14:04 | vote | accept | Robert Le Brun | ||
| Jul 31, 2023 at 14:04 | |||||
| Jul 31, 2023 at 8:42 | comment | added | Robert Le Brun | Thanks, I received the following error: "Query execution error on CREATE TEMP VIEW _tview AS select row_number() over() as id, kill.Killdate, track.Trackdate, case when track.geometry is null then 'No track within 300 m' when julianday(Killdate)-julianday(Trackdate) < -14 then '2 weeks after' when julianday(Killdate)-julianday(Trackdate) > 90 then '3 months before' else 'Unreliable kill' end validation, kill.geometry from KS_Hist. as kill left join Movements_Hist. as track on st_distance(kill.geometry, track.geometry) < 300: 1 - near "as": syntax error" | |
| Jul 31, 2023 at 5:59 | comment | added | user2856 | Great answer. If only I could upvote this more than once. | |
| Jul 30, 2023 at 8:41 | history | undeleted | Bera | ||
| Jul 30, 2023 at 8:41 | history | edited | Bera | CC BY-SA 4.0 |
added 207 characters in body
|
| Jul 30, 2023 at 8:30 | history | deleted | Bera | via Vote | |
| Jul 30, 2023 at 8:30 | history | answered | Bera | CC BY-SA 4.0 |