Timeline for Store GPS trace with timestamps, then interpolate location by time
Current License: CC BY-SA 3.0
21 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 15, 2016 at 17:47 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 16, 2016 at 3:19 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 13, 2016 at 16:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 14, 2016 at 2:31 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 9, 2016 at 13:29 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 8, 2016 at 22:18 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 9, 2016 at 20:30 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 22, 2015 at 16:12 | answer | added | Jesse Crocker | timeline score: 1 | |
| Dec 15, 2014 at 13:41 | history | reopened |
Get Spatial R.K. radouxju AndreJ MerseyViking |
||
| Dec 14, 2014 at 22:41 | review | Reopen votes | |||
| Dec 15, 2014 at 13:41 | |||||
| Dec 14, 2014 at 22:21 | comment | added | Steve Bennett | I've added a clearer statement - hth. | |
| Dec 14, 2014 at 22:20 | history | edited | Steve Bennett | CC BY-SA 3.0 |
added 253 characters in body
|
| Dec 14, 2014 at 19:30 | history | closed |
Simbamangu Mapperz♦ |
Needs details or clarity | |
| Dec 14, 2014 at 15:48 | review | Close votes | |||
| Dec 14, 2014 at 19:30 | |||||
| Dec 14, 2014 at 15:31 | comment | added | Simbamangu | @SteveBennett, what is the output you are looking for? There are a few solutions but depends on whether you're looking for companion files, individual frames with metadata, etc. | |
| Dec 10, 2014 at 2:58 | comment | added | Steve Bennett | @JohnBarça, yeah I'm not sure about that column. I suspect it's a seconds-since-epoch that matches the faulty 1970-01-01 date in the other table. So 011806.0 (not 118806) is about 3am UTC, or around 2pm local time (Victoria, Australia). (The two fragments I quoted don't correspond exactly.) | |
| Dec 9, 2014 at 20:42 | comment | added | Chris W | Related: gis.stackexchange.com/questions/53641 and gis.stackexchange.com/questions/9736 | |
| Dec 9, 2014 at 7:52 | comment | added | Simbamangu | What is the actual output you would like to have? Do you want to have individual frames from the video saved with lat/lon text, or a companion file that shows position for each frame during a video? | |
| Dec 9, 2014 at 6:35 | comment | added | John Powell | Loading the data is straightforward, using the copy command, and ST_MakePoint in an update to calculate a geometry column (point), that could be used as a basis for ST_Line_Interpolate_Point. Obviously, if this is dynamic, this update could be put in a trigger, or similar. | |
| Dec 9, 2014 at 6:30 | comment | added | John Powell | Yes, you should be able to use ST_Line_Interpolate_Point for this, using the change in time and required framerate to calculate the second parameter. I would have put up an example, but I am not too sure what the units are in your UTCTime column, as 0118806.0 doesn't look like a unix timestamp or current UTC time. | |
| Dec 9, 2014 at 5:57 | history | asked | Steve Bennett | CC BY-SA 3.0 |