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.
49
questions
0
votes
0
answers
49
views
add 2 hours to a varchar column containing timestamp [duplicate]
I have a qgis varchar column that is used to store timestamp in this format : HH-MM-SS.
I would like to add 2 hours to every entries.
08:30:45 would become 10:30:45.
Is there a way to convert these ...
- 527
1
vote
0
answers
29
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 ...
- 527
0
votes
0
answers
131
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...
...
- 71
0
votes
0
answers
185
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 ...
- 339
3
votes
1
answer
206
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 ...
- 339
2
votes
1
answer
98
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 ...
- 339
8
votes
1
answer
508
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 ...
- 339
2
votes
1
answer
614
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 ...
2
votes
1
answer
45
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 ...
- 820
5
votes
1
answer
151
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 ...
- 3,594
4
votes
1
answer
396
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=&...
user181204
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....
1
vote
1
answer
359
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-...
- 31
0
votes
0
answers
103
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 ...
0
votes
0
answers
329
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
0
votes
0
answers
226
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 ...
- 13
2
votes
1
answer
1k
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 ...
- 21
1
vote
1
answer
504
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 ...
- 19
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 = ...
- 230
0
votes
1
answer
64
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_,
...
- 1,114
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
...
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 ...
- 31
1
vote
0
answers
236
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 ...
- 11
2
votes
1
answer
494
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 = ...
- 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, ...
- 537
0
votes
1
answer
137
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 ...
1
vote
2
answers
588
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 ...
- 11
3
votes
1
answer
877
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 ...
- 1,210
0
votes
1
answer
367
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
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 ...
- 14.6k
4
votes
1
answer
898
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 ...
- 567
1
vote
1
answer
744
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 ...
- 931
3
votes
2
answers
987
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 ...
- 31
2
votes
2
answers
5k
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 ...
- 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 ...
- 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 ...
1
vote
1
answer
242
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 ...
- 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 ...
- 87
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 ...
- 83
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 ...
- 93
0
votes
1
answer
424
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 ...
3
votes
1
answer
145
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 ...
- 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, ...
- 5,672
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 ...
- 51
1
vote
1
answer
887
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 ...
0
votes
1
answer
888
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?
- 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.
- 285
1
vote
0
answers
194
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 ...
- 41
1
vote
2
answers
1k
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 ...
- 8,320