Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [timestamp]

A timestamp is a sequence of characters or encoded information identifying when a certain event occurred, usually giving date and time of day, sometimes accurate to a small fraction of a second.

0
votes
0answers
13 views

Interpolating timestamps for breakpoints for linestrings of GeoJSON

I have a GeoJSON file containing a couple of LineStrings. The properties contain the Departure and Arrival timestamp for each LineString. I would like to interpolate the timestamps for each breakpoint ...
0
votes
0answers
75 views

Timestamp mismatch in the data recorded by Vlp16 with Ublox-M8T

Currently, I am working on Velodyne vlp16, for which I recently added UbloxEVK-M8T support. The setup is working fine but when I record the data from VeloView, the GPS timestamp is showing incorrect ...
1
vote
1answer
801 views

Converting GPS points with timestamp to polylines in PostgreSQL?

I have some GPS coordinates points based on timestamp in a table. My table consists of and id, time_stamp and GPS points as the geometrical data. I want to create a line by joining all the points ...
1
vote
0answers
61 views

How to Timestamp Photo Attachments in ESRI Collector App

We need to automatically timestamp the photo attachments when using ESRI Collector APP. Either a visual timestamp on the photo or a date in the attachment name would be great. Timestamp in the ...
1
vote
1answer
65 views

Adding per-row creation time and modification time in GeoPackage geometry table?

I need to add ctime and mtime to a GPKG sqlite database in table with geometry. Apparently logic solution: add ctime column with DEFAULT CURRENT_TIMESTAMP and add trigger ON UPDATE to set mtime = ...
0
votes
0answers
83 views

False timestamps in GeoServer Shapefile/JSON WFS output

GeoServer is running with an SQL Server 2012 Database. In the database table the timestamp is a datetime2(7) datatype and has the value "2018-06-27 00:00:00.0000000". When I query the table via ...
-1
votes
1answer
722 views

How postgresql gets time zone from my data? [closed]

I have a set of data containing latitude, longitude value, time and some other my application oriented values. In my application, a device is doing a job in a particular location during some time. So, ...
0
votes
1answer
85 views

Using Date Column in Synced Table?

There is one map and one dataset in my account. The dataset is synced to a Google Sheet to which my students add data. All the layers of the map are derived from the one synced dataset. One of the ...
0
votes
2answers
203 views

Converting GPX timestamps to different format for ArcGIS Desktop?

I'm trying to figure out an easy or efficient way to convert the timestamps contained in GPX files to a different timestamp. I have data for air quality levels saved in an excel spreadsheet and want ...
1
vote
1answer
670 views

KML Time Stamp With UTC Conversion Not Working

So I have a KML Placemark with a <when> tag in it that has the dateTime that I want, however when I load it into google earth, the <when> tag disappears. Here is my code: <?xml ...
2
votes
1answer
351 views

On save add timestamp in attribute table?

I would like to add / update a timestamp value in a column of the attribute table whenever this attribute table is saved. Should I do it with an own python script or is there any in-built ...
0
votes
1answer
100 views

Want to insert a new field to CSV with filename as attribute [closed]

I have thousands of CSV files with the approximately the following structure: csv_20160601T004301Z: name,x,y, name1,23,66 name2,23,67 csv_20160601T005001Z: name,x,y, name1,23,66 name2,23,67 etc. ...
4
votes
2answers
964 views

How to convert unix time to qt time type?

How can I convert unix timestamp to qt time type using qgis field calculator? I would like to avoid importing my table into excel and convert the timestamp to qt time type.
2
votes
1answer
5k views

How to update a timestamp in SQL?

I've explored this forum fairly extensively trying to get answers as to why my SQL isn't working. I need help with the timestamp on a torque map. I've used the following formula, obviously changing ...
2
votes
2answers
3k views

NMEA to CSV with timestamp using gpsbabel

I tried to convert a file in NMEA to csv using gpsbabel, $ gpsbabel -i nmea -f GPS_20160204_092027.log -o csv -F GPS_20160204_092027.csv I get a csv file with only latitude and longitude, but was ...
0
votes
1answer
412 views

CartoDB Torque Time Stamp

I have two spreadsheets that came from the same data export. One 25k points, one 55k points. Both have a time column including year, day, time down to the second. The first worked perfectly (25k ...
2
votes
1answer
1k views

Store GPS trace with timestamps, then interpolate location by time

I'd like to: Load a 1-second interval GPS trace (not GPX) into PostGIS Then query the table at sub-second accuracy (about 5Hz), and get PostGIS to interpolate the location by time. Is this possible, ...
4
votes
2answers
562 views

Using timestamp in text format published parameter of FME?

I have an FME workspace (FME 2015.1) that creates an output file, let's say result.xslx. What I would like to do is to build up the output file name from various parameters, e.g. the project name and ...
4
votes
1answer
317 views

How to calculate location at given time from GPX track

I have a number of sound files with timestamps (HH:MM:SS), made when walking a transect. I need to know where I was when each file was saved. To do this I have a GPX track of the route I took - I can ...
1
vote
1answer
271 views

Garmin gpx - wrong timestamp when importing it into Qgis

When I copy a track (day) from a Garmin Oregon 550 to the PC an import it into Qgis a the timestamp is 2 hours earlier than it should be. When I import it via Garmin Basecamp, export it and open it ...
3
votes
2answers
529 views

Retaining timestamp when saving gpx as shp in QGIS?

I'm somewhat new to QGIS. I used my Garmin GPS unit to record my tracks while collecting plant specimens for a plant inventory. When I collected each plant I noted the time of collection. I want to ...
0
votes
2answers
3k views

How can I edit gpx tracks, property timestamp and waypoints?

I want to reconstruct the historical movements of a military regiment. I am looking for a publisher, in the end I wish a gpx file. A priori there is full, yet I find none that corresponds: I need to ...
1
vote
1answer
901 views

Format of Date/Time Field in Datasets for use in CartoDB Torque CAT

I have a Date/Time field in my data set on cartodb that is formatted as follows: 2016-02-09T10:30:00Z that is the value in the first row. The data type is set to 'date'. I want to use this field to ...
1
vote
1answer
210 views

Torque time legend incorrect compared to dataset timestamp

I am creating a map within the CartoDB map creator based on a dataset (spatially located within CT timezone) with a timestamp range of "2015-11-19 11:00:00' AND '2015-11-19 17:00:00" (UTC) but when ...
2
votes
1answer
663 views

Convert UTC to local time in map label using an expression

I am trying to figure out a way to convert a datetime stamp of the last_edited_date (tracking changes) that is stored in UTC to local time. I am putting together a map service that allows our heavy ...
1
vote
0answers
2k views

Converting UNIX time to datetime in R [closed]

I am trying to convert a 13 character UNIX timestamp to datetime and I am getting a year that is in the 44000's. I'm not sure what I am doing wrong, hopefully someone can help. library(maptools) GMT ...
1
vote
0answers
79 views

Data Collection Solutions

I am seeking a new data collection software for a team of biologists who track migrating animals from planes through aerial telemetry. I currently use Delorme TOPO USA but when collecting point data ...
0
votes
1answer
716 views

Combine two separate georeferenced data sets in one table using CartoDB

I have two tables each georeferenced in CartoDB with the same timestamps, can I merge the two and keep the georeferenced data so I have two sets of points but in one table?
1
vote
0answers
153 views

Save GM directions as KML - with timestamps?

In Google Maps I use Get Directions and after saving the result as a 'map' and opening it in My Places I am able to save it as a KML. All fine up to a point, allowing me to display the route in Google ...
1
vote
2answers
573 views

Filter out osm data that have been edited after some timestamp

I want to get data after some timestamp. I have downloaded the osm file of the area. I went through the osmosis documentation but could not find a way to filter it by time. The result should be same ...