Questions tagged [date]
Time stated in terms of the day, month, and year.
282
questions
1
vote
0
answers
17
views
Auto update date-time in QGIS
In QGIS 3.10 I need something to auto update a datetime attribute.
I need it to update only when any other attribute is updated.
I have tried the following:
Steps:
Add a Edited Date Field (ESRI uses ...
- 11
1
vote
1
answer
147
views
Date coming through as NULL when data type is set to "date" in csv/t
If I set the data type to date(DD-MM-YYYY) in the CSVt file the date comes through but as a String/text. But I really need it to be date type.
My CSV field looks like this:
NAME,DATE,TIME,SPECIES
...
- 21
1
vote
1
answer
44
views
DataTable Charts issue in Google Earth Engine
I am working on drawing a chart using datatable. So I followed the instructions in https://developers.google.com/earth-engine/guides/charts_datatable
I noticed a 30 days shift between the data and the ...
2
votes
1
answer
44
views
ArcMap - Date field
I am trying to append some data to an existing enterprise geodatabase feature class, the data I am trying to append has a date field where some entries are in correct, eg instead of 03/19/1983 they ...
- 23
0
votes
0
answers
26
views
Creating date fields in ArcGIS Pro
I am trying to create a month and a day column in ArcGIS Pro 2.8. For values I just want to have "01" and "01" for month and day respectively. So, I have 1032 rows, thus "01&...
- 614
1
vote
1
answer
36
views
filter.date not working GEE
I am trying to filter deforestation alerts (image collection) by date.
However, it does not work, because my output is empty.
My code is the following:
var date1 = ee.Number(fecha1.getRelative('day','...
- 43
0
votes
0
answers
41
views
Function returns zero features GEE when filter image collection by date
I am trying to create a function that filters a collection by a date range.
In my code, the user can select two dates in which they want to create an anlysis.
The way the code is build, the users fill ...
- 43
2
votes
1
answer
77
views
Update a date field to now(), when a checkbox has been checked in QGIS 3.16
I want to update my date field to the current date when a checkbox has been checked.The date field is Sur_com, the checkbox is Sur_check.
I have tried codes below:
First:
layer = qgis.utils.iface....
- 31
0
votes
1
answer
56
views
Change date type of entire image collection from Julian to gregorian date GEE
I am having an image collection which contains two bands, one of them is called 'Date'. The format is in Julian format. However, for my analysis I need the dates in gregorian (normal calender i ...
- 43
0
votes
1
answer
37
views
QGIS Colour points by date
I have a point layer representing bird sightings. Each sighting has a survey date associated with it. I am trying to figure out a way to have QGIS display these point in a way that each date has a ...
- 53
1
vote
0
answers
24
views
ArcGIS Pro date handling with different specificities in one column
I have a date column in my attribute table, some of the dates are just the year, and some are the month/day/year. I made the table in excel, and when I imported it into my gdb, I specific all the data ...
- 55
0
votes
1
answer
25
views
Return the acquisition time of an Landsat 7 image?
I try to get the timestamp of the least cloudy image for my region of interest (roi). I want to obtain the date of this image in the time range 2012-10-01 - 2012-12-31. I know that the image exists ...
4
votes
2
answers
179
views
Convert date/time format
My shapefile contains a attribute field called "created" (type QString) and this field holds the date and time of every feature in this format: "2022-03-04-13-28-26" (yyyy-mm-dd-hh-...
- 65
2
votes
1
answer
58
views
Convert string column to date
I have a column of type string in the following form
23/02/2021
how can I either
a) convert this column to Date format
b) create a new column where each cell contains the value in valid date format?
...
- 3,017
1
vote
1
answer
34
views
SLD - Failed to build legend preview
I write an SLD style on GeoServer. The date in label is showing with the letter 'Z' at the end (2021-07-28Z). I want to display the date parameter in the label but without the 'Z' at the end.
The '...
- 800
0
votes
2
answers
53
views
What is the standard approach to store dates as pixel values in raster? [closed]
I have a raster, where the value of a pixel should represent the date at which that pixel was deforested. Dates ranging from 2015 until today. I need resolution to be at the level of day.
I would like ...
- 123
2
votes
1
answer
56
views
GEE Image Collection to Multiband Image Outputs Gibberish
I'm using Landsat imagery in Google Earth Engine and am attempting to convert an image collection to a multiband image. However, before doing so I do two things:
I mosaic the images by date so that ...
- 395
0
votes
1
answer
29
views
"NEW" Column of Data with DATES, for export as CSV
How could I add a "NEW" Column of Data with DATES to this SCRIPT, for export as CSV
var dataset = ee.ImageCollection('UCSB-CHG/CHIRPS/DAILY')
.filter(ee.Filter.date('2021-...
4
votes
2
answers
117
views
Adding today's date to attribute table using PyQGIS
I have the following script to merge a group of layers, and I want to edit the script to add a field containing today's date in the attribute table and also delete some fields by their names?
root = ...
- 269
0
votes
1
answer
50
views
Temporal controller year / annual data step skipping
I am working with a dataset which contains annual data for years in non-QGIS format i.e. 1951, 1955, etc from 1933 to 1955.
I have used " to_date( "year" , 'yyyy')" to convert ...
- 11
2
votes
1
answer
73
views
QGIS expression function month() does not return month in MM format
Using QGIS expressions, the following expression returns 5:
month('2012-05-12') -> 5
The help, however, says that the output of this very expression is 05. I don't see an option to format the ...
- 40k
0
votes
1
answer
26
views
sunAngle() calculation in R giving wrong results
I need to find the hourly sun angle (angle at which the sun strikes the Earth) for a particular position (latitude, longitude) for a given day in Belgium. I used sunAngle() from "oce" ...
- 21
0
votes
2
answers
70
views
Finding missing dog using Google Earth [closed]
I know this isn't the place to ask, but I need help to find my dog. I was wondering if there was anyway to possible track which way he left or what happened to him. He has severe separation anxiety ...
0
votes
1
answer
83
views
Subset image collection by specific dates, cannot interpret data Google Earth Engine
I am trying to subset an image collection by a list of dates. However, I keep getting the error that my dates are not interpretable.
The date list comes from an imported csv with a list of dates.
var ...
- 15
1
vote
0
answers
45
views
Dividing layer with tracks by individual days in QGIS
I have a CSV file that includes about 150 dates containing tracks for a particular bird. I successfully added it as a layer in QGIS.
My question is how can I divide all the dates into separate days?
- 201
4
votes
3
answers
247
views
Splitting string with dates by '/'-character and getting ancient/latest date as new column in QGIS
I have dates separated by '/' character in column "date" in format RRMMDD as on the screenshot below:
I want to separate dates into another columns "date_from", "date_to"...
- 51
1
vote
1
answer
28
views
Converting dates in a feature collection to a previous date
I have a featureCollection with the dates for 2021. I would like to do a date conversion for this featureCollection to get the same dates in 2017. I have written the function above but it returns the ...
- 162
2
votes
1
answer
45
views
Reading Date property for an uploaded asset (FeatureCollection) in GEE
I have 16 points imported as an asset in GEE. Each of these points has a date property (STARTDATE) in epoch format. I am stuck at extracting this date in and using it to acquire before and after ...
- 162
0
votes
0
answers
63
views
GeoServer subtracts time difference to UTC from date stored in PostgreSQL
We have in our PostgreSQL database records that include a date, i.e. stored as data type date (yyyy-MM-dd). The data are published in Geoserver.
If we request the records from an OpenLayers ...
- 51
0
votes
0
answers
48
views
Email an alert when an attribute in a feature gets to a certain value
I am trying to see if it is possible to send an email to co-workers when an attribute field hits a certain value. We have Playground safety inspections and I want to send an email when a playground is ...
- 1
0
votes
1
answer
74
views
Modifying text box in layout view through ArcPy with ArcMap
I have the following textbox in a layout view:
Is it possible to modify the text through ArcPy?
I made that box as text, and it has no function added to it:
I just want to change the date so that ...
- 129
3
votes
0
answers
66
views
Auto updating rule based symbology categorised by date
I have a shapefile of "Detection Points". These have a "strength" attribute and a "date" on which each was made. Data collection is ongoing - that is it began in April ...
- 39
4
votes
1
answer
87
views
Visualizing most recent point by date in QGIS
Does anyone know how to visualize in QGIS, in a group of points with an associated date, the point corresponding to the last date?
For example, a vector layer with 4 points:
id
Name
Date
1
Joana
...
1
vote
1
answer
52
views
Converting date field using ArcMap
I need to convert the date field in the feature class. The original date format is 15-Jan-2012, 27-Apr-2012, likewise.
How can I convert it into MM/dd/yyyy format?
- 115
3
votes
1
answer
116
views
Building query to filter for date using QGIS
I am using QGIS.
I want to filter for all datapoints that were taken over a specific period: 01/01/2015 to 31/12/2015. If I use the 'filter features using form' I can manage this, however I wanted to ...
5
votes
1
answer
69
views
Query for adding new field that is the sum of months fields
I have a table where fields are a specific month of a year. And I just want to add a new field that is the sum of the months fields that are ticked. Practically speaking I need to know the duration of ...
- 61
1
vote
2
answers
627
views
Converting "string" date to "date" format using FME
I have a string field with values such as 04.07.21 and I am trying to write to GDB but it's not working because date format is expected and string is provided.
How can I convert these values (04.07.21)...
- 562
0
votes
0
answers
36
views
Apply a filter to average NDVI for a year with only 8 minus inside an image collection
I'm calculating the NDVI annual values for a Landsat 8 collection, one more year is not complete, it has only 8 months (from April to December).
I would like to know how I apply some kind of filter to ...
4
votes
3
answers
205
views
Capturing Date using Date and Time from Expression builder
I have a string that includes date and time like in this format: '23/02/2021 09:03', '24/02/2021 09:10' etc. I would like to use Rule based filtering to colour symbols that has date=23/02/2021. So ...
- 155
0
votes
0
answers
18
views
Sentinel2 Images
I´m using this script to download Sentinel2 Images to calculate NDVI (a green vegetation Index) using bands 4 and 8.
//Imagen para SENTINEL 2
var IMGSentinel= ee.ImageCollection ('COPERNICUS/S2')
....
10
votes
1
answer
156
views
Selecting NULL or date values by Expression in QGIS
How can I select by expression from a date field in a shapefile, dates that are NULL or >= 2020-01-01?
This doesn't work, it only selects those with dates >= 2020-01-01, not the NULLs
"...
- 51.2k
2
votes
1
answer
77
views
Filtering dates by validity in QGIS 3.14
I have a WFS data, which I'm trying to filter by DATE. I'm using query builder. I need to filter valid dates which are max three years older than current date. I can do it if I calculate three years ...
- 21
1
vote
1
answer
57
views
Choosing correct datetime format
I want to change my date (string) to a date format %Y-%m-%d for the time manager. I already try with the Field Calculator. But it is not working. What should i write in the expression. And should I ...
- 57
0
votes
1
answer
154
views
Converting excel integer date format to datetime using QGIS
How to convert Microsoft Excel date format to datetime format using QGIS?
In example: 43089 in MS Excel is 2017-12-20.
- 5,622
3
votes
0
answers
177
views
Is there a raster data format that can store dates instead of numeric values?
When storing spatiotemporal data, there is a need to store dates or time data. I know raster files can store numeric data (integer or float), but what about storing of dates data?
I'm currently ...
0
votes
1
answer
100
views
Display layer with its date in GEE
I want to display the image with its date as the layer name, but the following code does not work.
var s2 = ee.ImageCollection('COPERNICUS/S2_SR').filterBounds(roi).filterDate(startdate, enddate)....
0
votes
1
answer
107
views
ArcPy - Get Date as parameter value and calculate Date field
In my ArcPy script I have an input parameter for the Date, so the user is asked to input a date value (time is not needed) using the data type GPDate.
In the script I calculate a new field, field data ...
- 49
0
votes
1
answer
95
views
Filter a collection using nightime in Google Earth Engine
I'm working with GOES-16 full disk data, trying to calculate the frequency of low clouds in northern Chile.
I need to filter the collection so it contains only images from September 2017 at night. ...
- 15
0
votes
1
answer
58
views
Carto time-series widget: how to change bucket labels?
I am using the Carto builder animated time-series widget based on a number column that contains a year as a four digit integer. In the widget's horizontal axis, the buckets are not labeled with ...
- 21
2
votes
2
answers
267
views
Way I can find out when a shapefile was created or last updated
I'm working with 100+ layers on QGIS, and I am trying to determine when each layer was last created or updated. All the layers are shapefiles. Is there a way I can find the creation/update date?
- 21