Skip to main content

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.

Filter by
Sorted by
Tagged with
1 vote
0 answers
25 views

Using GeoJSON timestamped Folium plugin for data in milliseconds

I have data from different points that a car pass by, and a need to put them in a map, but one by one using their UTC time. The data goes from one millisecond to another, and I need to reflect that. ...
natalia's user avatar
  • 11
0 votes
1 answer
335 views

Finding time data in a .gpx file

This seems like a simple problem but I have searched for answers and apparently reached the limit of my experience. I have a .gpx file and I am trying to see the time data for various points along the ...
AbeFroman's user avatar
5 votes
1 answer
142 views

Joining point data in chronological order using timestamp in QGIS

I have a data set which gives me the location of livestock every 30 minutes over months. I want to join these points to show the path travelled by individual animals. I have a unique ID for each ...
Eleanor Baker's user avatar
0 votes
0 answers
71 views

Calculating from GPS time duration of a linestringM within a polygon

I am analyzing trajectories from GPS points, including timestamp (Linestring M). I need to clip trajectories that cross polygons, and calculate time spent within those polygons. However, I have 2 ...
Remi79's user avatar
  • 163
1 vote
0 answers
30 views

Add 2 hours to postgresql timestamp [duplicate]

Using Qgis, I have one postgresql column named "time" with this default expression : to_char(CURRENT_TIMESTAMP, 'HH24:MI:SS'::text) I would like to add 2 hours as I'm working in a different ...
tonyduky's user avatar
  • 567
0 votes
0 answers
142 views

ArcGIS API for JavaScript 4.23 : Cannot use SQL CAST function with layer.definitionExpression but it work fine with query builder

I'm working with features which needs to be filtered. I need to use the definition expression : https://developers.arcgis.com/javascript/latest/api-reference/esri-layers-SceneLayer.html#definition... ...
Flo's user avatar
  • 71
0 votes
0 answers
204 views

Adding new field to one attributes table based on the field on another attributes table in QGIS

I have two Geopackage layers on QGIS 3.22.2. One first one (LAST_ROUTES) shows the random extracted lines (routes) from the Istanbul highway map. Second one (LAST_POINTS) shows the points generated on ...
Ramiz Mammadli's user avatar
3 votes
1 answer
247 views

Updating Timestamp values in QGIS

As it is seen in the picture, I have the attributes table which shows the random extracted routes from Istanbul highway map and points on it. Points were uniformly distributed through 2000 random ...
Ramiz Mammadli's user avatar
2 votes
1 answer
120 views

Modifying Timestamps in QGIS

As it is seen in the picture, I have the attributes table which shows the random extracted routes from Istanbul highway map and points on it. Points are uniformly distributed through 2000 random ...
Ramiz Mammadli's user avatar
8 votes
1 answer
661 views

Why time field type is not visible in QGIS?

I have a roads.shp file which represents the highway map of Istanbul. By using Random Extract tool, I generated 2000 random routes on the existing map. Then, I needed to add uniform generated points ...
Ramiz Mammadli's user avatar
2 votes
1 answer
703 views

Importing TimeStamp data from KML into GeoDataFrame using Python

I have a KML file that I have converted from Garmin .FIT to KML via GPSBabel. The resulting KML file looks to be fine. Example (Note: I have changed coordinate values so they don't point anywhere ...
rollingnowhere's user avatar
2 votes
1 answer
46 views

OSM timestamp missing in SpatiaLite layer

I have downloaded and converted a geofabrik pbf file to a db file. When I open it as a SpatiaLite layer there is no timestamp for each feature. Is there a way to get this information or is it lost ...
brink's user avatar
  • 820
5 votes
1 answer
156 views

Marking point with the single extreme value in QGIS

I am working on a system with a continuously updating database of earthquakes. For one of the presentation, I want a map showing the last events. I have the timestamp for each event, so I have made a ...
MortenSickel's user avatar
  • 3,834
4 votes
1 answer
500 views

Formating timestamp correctly in QGIS

I am trying to automatically update timestamp of a feature from WFS-T connection in QGIS 3.16. According to the DescribeFeatureType, the attribute is defined as following: <xsd:element minOccurs=&...
user avatar
1 vote
1 answer
1k views

Converting ordered image bands to image collection and add/restore time stamp in Google Earth Engine [closed]

I received this collection of ordered multiband images and would like to convert them to a single collection, adding a timestamp (system:time_end and system:time_start): https://code.earthengine....
Andrea Markos's user avatar
1 vote
1 answer
396 views

Error generating chart: No features contain non-null values of "system:time_start". for Landsat 8 T1_SR

It's weird, when I run the attached code on Landsat8 TOA band it works fine. But when I switch out the bands to the SR band I get the message below: Error generating chart: No features contain non-...
WhitmanCD's user avatar
0 votes
0 answers
114 views

Restoring timestamp property on Image Collections after multiple operations

EDIT: My mistake was calling system:time_start 'day' at the very beginning of my script. So when I called 'system:time_start' later on, it didn't work. When I replaced that by 'day', it worked ...
Loukas Garanis's user avatar
0 votes
0 answers
409 views

Removing T and Z in WFS timestamp o/p field by changing configurations in GeoServer

Geoserver is appending T and Z in the values of timestamp columns(postgres DB) in WFS o/p. Current Output:2020-12-11T00:00:00Z Expected Output:DEC-11-2020 00:00:00
Dattu Macherla's user avatar
0 votes
0 answers
243 views

How to calculate interpolated timestamps of linearly referenced points in ArcGIS?

I have a point feature class with timestamp attribute belongs to bus-gps smartcard data-set. I've used linear referencing tool to snap these points to a bus-route. So there are milepoints in the ...
YellowFace's user avatar
2 votes
1 answer
2k views

Creating a QGIS Timestamp Field

I'm attempting to use the timestamp function in QGIS 3.4 to record daily progress on projects my technicians work on in QGIS, something that updates automatically when edits are made in the attribute ...
Krys Farrar's user avatar
1 vote
1 answer
506 views

Adding timestamp to dataframe in Google Earth Engine Python API

I came across an example shared on YouTube by Madhu Mysore. Here is the link: https://www.youtube.com/watch?v=IGUYSeoeHhg&t=2105s. I changed the code as I am not interested in regions at the ...
user156168's user avatar
1 vote
1 answer
1k views

Add time stamp to an imageCollection of Google Earth Engine

On the Mapping over an ImageCollection documentation page, in order for adding time stamp the function is written as // This function adds a band representing the image timestamp. var addTime = ...
OverFlow Police's user avatar
0 votes
1 answer
67 views

Converted timezone does not display properly in ArcMap

(Oracle 12c geodatabase) I have a view that converts a UTC timestamp to Eastern Time using the from_tz function: create or replace view test_vw as ( select cast(rownum as number(38,0)) as rownum_, ...
User1974's user avatar
  • 1,172
0 votes
2 answers
1k views

GeoServer Timestamp/Timezone error convert

Date format in PostgreSQL, -> 2019-10-30 08:46:44 Created WFS, but got a problem. GeoServer is converting the date. I think it somehow something with timezones. Output WFS -> 2019-10-30T07:46:44Z ...
Tim van Heteren's user avatar
1 vote
1 answer
1k views

GEE error when extracting image timestamp

I have filtered Sentinel 2 images to get suitable cloud free images from the time period I require, however I cannot figure out how to extract the date from the images, but with my current code I get ...
user3444391's user avatar
1 vote
0 answers
246 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 ...
Aragon's user avatar
  • 11
2 votes
1 answer
567 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 = ...
Jack's user avatar
  • 41
-1 votes
1 answer
1k 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, ...
LSG's user avatar
  • 537
0 votes
1 answer
140 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 ...
user113597's user avatar
1 vote
2 answers
645 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 ...
Javier's user avatar
  • 11
3 votes
1 answer
886 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 ...
JoeBe's user avatar
  • 1,230
0 votes
1 answer
380 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. ...
Stinkender's user avatar
4 votes
2 answers
1k 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 ...
Jochen Schwarze's user avatar
4 votes
1 answer
1k 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 ...
Thomas's user avatar
  • 567
1 vote
1 answer
779 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 ...
user16032's user avatar
  • 931
3 votes
2 answers
1k 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 ...
Nastassja's user avatar
2 votes
2 answers
6k 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 ...
Annex's user avatar
  • 23
2 votes
1 answer
7k 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 ...
csl's user avatar
  • 51
1 vote
1 answer
1k 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 ...
GIS Adjunct in Training's user avatar
1 vote
1 answer
245 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 ...
neogeo's user avatar
  • 13
2 votes
1 answer
1k 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 ...
rwnichols's user avatar
1 vote
0 answers
3k 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 ...
Michael 's user avatar
0 votes
2 answers
6k 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 ...
David's user avatar
  • 93
0 votes
1 answer
425 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 ...
Ryan Buck's user avatar
3 votes
1 answer
148 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 ...
S. Burke's user avatar
  • 139
2 votes
1 answer
2k 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, ...
Steve Bennett's user avatar
2 votes
1 answer
2k 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 ...
john mathew's user avatar
1 vote
1 answer
897 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 ...
Darksaint2014's user avatar
0 votes
1 answer
893 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?
eWizardII's user avatar
  • 121
6 votes
3 answers
3k 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.
euler's user avatar
  • 285