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
0 votes
0 answers
48 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... ...
user avatar
  • 71
0 votes
0 answers
37 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 ...
user avatar
3 votes
1 answer
102 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 ...
user avatar
2 votes
1 answer
47 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 ...
user avatar
7 votes
1 answer
124 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 ...
user avatar
2 votes
1 answer
33 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 ...
user avatar
  • 710
5 votes
1 answer
126 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 ...
user avatar
  • 2,865
4 votes
1 answer
151 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
0 votes
1 answer
634 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....
user avatar
1 vote
1 answer
149 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-...
user avatar
0 votes
0 answers
63 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 ...
user avatar
0 votes
0 answers
146 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
user avatar
0 votes
0 answers
136 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 ...
user avatar
2 votes
1 answer
807 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 ...
user avatar
2 votes
1 answer
471 views

Add a timestamp to a dataframe in Python/Earth Engine

I came across an example kindly 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 ...
user avatar
1 vote
1 answer
947 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 = ...
user avatar
0 votes
1 answer
53 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_, ...
user avatar
  • 828
0 votes
2 answers
699 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 ...
user avatar
1 vote
1 answer
835 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 ...
user avatar
1 vote
0 answers
207 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 ...
user avatar
  • 11
2 votes
1 answer
340 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 = ...
user avatar
-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, ...
user avatar
  • 517
0 votes
1 answer
124 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 ...
user avatar
1 vote
2 answers
464 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 ...
user avatar
  • 11
3 votes
1 answer
806 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 ...
user avatar
  • 1,160
0 votes
1 answer
349 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. ...
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 ...
user avatar
4 votes
1 answer
615 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 ...
user avatar
  • 549
1 vote
1 answer
614 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 ...
user avatar
  • 851
3 votes
2 answers
866 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 ...
user avatar
2 votes
2 answers
4k 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 ...
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 ...
user avatar
  • 51
1 vote
1 answer
981 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 ...
user avatar
1 vote
1 answer
224 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 ...
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 ...
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 ...
user avatar
0 votes
2 answers
5k 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 ...
user avatar
  • 93
0 votes
1 answer
419 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 ...
user avatar
3 votes
1 answer
130 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 ...
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, ...
user avatar
1 vote
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 ...
user avatar
1 vote
1 answer
856 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 ...
user avatar
0 votes
1 answer
849 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?
user avatar
  • 121
6 votes
3 answers
2k 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.
user avatar
  • 285
1 vote
0 answers
173 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 ...
user avatar
1 vote
2 answers
876 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 ...
user avatar
  • 8,129