Questions tagged [date]
Time stated in terms of the day, month, and year.
324
questions
0
votes
1
answer
41
views
Find out date format in the list of house numbers
In my dataset, the data which contains house numbers are converted to date format in QGIS. Is there any script or tool to identify and convert them to normal format.
E.g.Case:
Actual Door No format is ...
- 767
4
votes
1
answer
50
views
Converting text date to numbers date using QGIS Field Calculator
I have a shapefile with polygons. Each polygon contains a date (fully written in text, for example: '2 june 2018') in the attribute table. This field is format 'text'. Now, I would like to convert ...
- 107
4
votes
1
answer
84
views
Dividing a database according to a date in QGIS?
I would like to create a new column in my database in order to work with three blocks of observations:
before 2000 (until 1999/12 included), from 2001/01 to 2009/12; from 2010/01 onwards, until today)....
- 483
1
vote
0
answers
17
views
Splitting a point vector based on a date attribute within the QGIS Graphical Modeler
I have now a model which processes two layers of points corresponding to observations at 'Time_1' and 'Time_2'. It counts the observation per quadrats in a grid and obtains two outputs: a grid with ...
1
vote
1
answer
30
views
Add "date" property to individual features within Google Earth Engine image collection
I have created an google earth engine image collection by combining multiband rasters (I previously had eleven rasters, one for each year of my analysis period, each with 365 bands). I first combined ...
- 11
0
votes
1
answer
31
views
Converting excel integer date format to date using ArcGIS
Similar question as this post: Converting excel integer date format to datetime using QGIS, but for ArcGIS.
I have a field with integer values like 45118 which came from a column in Excel containing ...
- 135
0
votes
0
answers
41
views
QGIS format date with ordinal numbers 1st 2nd 21st etc
Basic date expression as below doesn't show st nd rd th etc is there a simple way to get this
[%format_date(now(),'d MMMM yyyy')%]
I think this will work but its not pretty
case
when format_date(...
- 1,459
1
vote
0
answers
12
views
Is there a way to have QGIS treat numerical rasters as "date-rasters"?
I have a R-script outputting rasters where each raster cell contains dates (e.g. 2022-05-08).
I have considered various options to store this data in rasters and ended up using Unix Epoch data (i.e. ...
- 2,022
1
vote
1
answer
71
views
Filtering string column with datetime in PyQGIS
I have a CSV in QGIS and one of the columns is "Data/Hora GPS" with the DateTime in format (day/month/year hour:minute:second), in the field calculator I used the expression for filter:
...
- 11
0
votes
1
answer
27
views
DateAdd function syntax error
I have a date field named LAST, a short integer field named FRQ, and a date field named NEXT that I need to calculate. FRQ field is populated with frequency in months, with values that look like 6, 12,...
- 31
0
votes
1
answer
46
views
Calculating day difference between two field using ArcPy
I work with ArcGIS Pro 3.1. I have a GDB table with two date fields. I would like calculate with Python code the difference between two date in days. But the result is not correct if the months are ...
- 81
1
vote
1
answer
61
views
Select by date in attribute table using ArcPy
I want to select attributes by date, but ignore the minutes, seconds, etc. I've commented out some of the lines below and am just experimenting with hard-coded values.
The arcpy.management....
- 155
5
votes
1
answer
224
views
Calculating the day of the year with QGIS expressions
At QGIS 3.28.6 I have an attribute table containing a datetime field from which I need to populate an integer field that will contain the day of year (for example, 2/1/2018 would output to 32).
Using ...
- 7,940
0
votes
1
answer
30
views
Exclude a date for Albedo calculation
I work on a university project and I use Google engines.
I want to get albedo above a city environment, one value is weird according to other data and I wish to exclude one date corresponding to this ...
- 11
0
votes
1
answer
62
views
Display a date field in the attribute table window as yyyy-MM-dd
At 3.28.6, I have a GeoPackage table with a date field which always displays in the attribute table window as M/d/yyyy. I would like it to display as the ISO 8601 standard yyyy-MM-dd.
Using the Field ...
- 7,940
0
votes
1
answer
65
views
How to rename the different .tif files in a stacked TIFF image in DD/MM/YYYY format in R
I'm struggling to rename the TIFF files in a stacked TIFF file in date format (DD-MM-YYYY). So, far I have converted it to Date format. But, the date values are in YYYY-MM-DD format by default. How to ...
2
votes
0
answers
78
views
How to connect nearest points to increasing closest date
Given a points collection layer containing the data field ("DATADIA") with the date (YYYYY-MM-dd), how could I connect the nearest points in order of increasing date?
The expression should ...
- 811
2
votes
2
answers
107
views
Getting the file path of layer based on layer name using PyQGIS [closed]
So this is my folder:
It contains GeoPackages with the format yyyymmdd_progress.gpkg
I want to take the latest GeoPackage based on the latest GeoPackage created and stored in the folder, then use it ...
- 143
0
votes
1
answer
30
views
Supervised classification using training samples from different months
I am performing supervised classifications of forest stands in the Delta region of Buenos Aires. For these classifications, I use a set of bands and indices derived from Sentinel-2 images for ...
- 13
0
votes
0
answers
38
views
Assigning dates to a image collection which don't have any date properties attached to it
This is what I have done till now-
var image= ee.Image("users/rohithari1703/merged_IMD_raster_WGS84_collection");
//print(image);
var CHIRPS = ee.ImageCollection("UCSB-CHG/CHIRPS/...
- 1
1
vote
1
answer
29
views
Selecting lastest date per ID in QGIS field calculator
My GeoPackage contains columns like ID, date and number.
There are multiple entries/columns per ID for different dates with different numbers: e.g.
ID date number
1 31.01.22 10
1 31.12....
- 11
1
vote
0
answers
190
views
Seeing modified dates of feature classes in geodatabases from ArcGIS Desktop
I would like to see the modified date of each layers in the geodatabases. For some reason I can't see them in ArcGIS Desktop 10.8.2. However, they appear under File explorer. As the layer are into ...
- 171
1
vote
1
answer
119
views
List of day and next day in GEE
There is a list of days for a year. How can I convert it to another list in that each item includes two dates including the day and the next day?
I tried with the below code do it, but it is not ...
- 1,024
0
votes
1
answer
105
views
Wrong format of Year in Chart
I am calculating the Annual mean NDVI from S2 data and trying to plot it. However, in the chart, the format of all years is not correctly presented. The 'year' values are presented as double. How I ...
- 1
0
votes
0
answers
106
views
Obtain current date in attribute table
I'm having difficulties trying to set one function to get current date in one column on a shapefile's attribute table.
I know that using now() it does what I want, but that is static. If I check ...
0
votes
2
answers
198
views
Converting antiquated string date values to datetime values in ArcGIS Pro [closed]
I am trying to modernize an existing parcel data set that stores date information as strings in the following format: "YYYY MMM DD" 12/13/2022 would be stored as "2022 DEC 13."
Is ...
0
votes
1
answer
190
views
AGOL Date range filter on two fields
I am building a solution in AGOL (webapp, dashboard, or experience builder, but not map viewer or wab for devs) which shows events that can cover multiple days. These events are in two feature classes,...
- 178
7
votes
4
answers
501
views
Filtering date field on year using QGIS
In QGIS I'm trying to filter a specific year out of my field dates (type = QDate). It should not be so hard, still I'm unable to make it work.
I've tried for instance:
year("surveys_date") =...
- 73
1
vote
0
answers
575
views
Identify the imagery date of Google satellite picture in QGIS
I am using the Quick Map Services Plugin in QGIS. Is there a way to find out the date of the aerial image in QGIS ? I used to check Google Earth Pro and take the imagery date from the latest picture ...
- 2,217
4
votes
1
answer
103
views
Numbering row based on date field in QGIS [duplicate]
In QGIS 3.28 I just want to create a row number (Column "Número") based on the date of the column on the left ("Fecha"), I'm sure it's pretty easy but I'm completely new.
@...
0
votes
1
answer
62
views
Problems trying to export a vector into a geojson [closed]
we have a problem when trying to export vectors that contains attributes that have double / in their name. Our attribute looks like a date:
1/1/21 and even if we try to convert it to string qgis still ...
- 31
0
votes
1
answer
64
views
Reduce GOES Image Collection to get time of first fire detection in Google Earth Engine?
I am trying to extract some information from the GOES fire product in Google Earth Engine.
I have written a function that will extract the fire pixels for each image in the collection.
// OBTAIN GOES ...
- 139
0
votes
1
answer
92
views
Earthexplorer: how figuring out the adquisition dates of the images from file names?
I have a BUNCH of eMODIS NDVI V6 earthexplorer images that someone else downloaded some time ago. Given my internet and time limitations, I want to use such images in a forthcoming project. However, I ...
- 115
0
votes
1
answer
146
views
ogr2ogr auto conversion of text to date type
I have a question regarding ogr2ogr's auto-conversion of text fields to date fields, specifically in the case of additional text following the date.
input.geojson file:
{
"type": &...
- 9
0
votes
1
answer
367
views
Reading multiple rasters in folder
the rasters in that folder has dates in the naming (for eg. T43RGP_20220330T052639_NDVI) and I want the code to read the rasters one by one in the increasing order of the date.
Help me complete this ...
- 51
0
votes
0
answers
74
views
ArcGIS-Pro 3 Select Layer By Date and Time
I have a dataset which has a Time column similar to the sample data below. I am using the Select Layer by Date and Time to filter daytime records and then export that selection as a separate layer.
...
- 1,038
2
votes
1
answer
374
views
ArcGIS Pro 3 Create year, month and day columns
Based on the sample data column below, what tool I can use in ArcGIS Pro 3 to create the Year, Month and Day columns in the attribute table?
The purpose is to then use these columns to create a space ...
- 1,038
0
votes
1
answer
340
views
Quick Map Services (QMS) Google Satellite Imagery Source Date
I have digitized landform features using the QMS Google Satellite as a reference basemap, and therefore need to know the date the image was taken. Is the plugin a 'live' updating feed from Google ...
- 1
1
vote
0
answers
23
views
USGS Multiple Dates listed and I want to know what they mean
I want to take a look at a piece of land over time and evaluate the change in topography over time. I am using USGS to download some data and I realized they give you a list of dates that correspond ...
- 11
1
vote
2
answers
438
views
ArcGIS Pro Field Calculator: Updating each row with a minute added to previous time
I'm trying to update each row in my point shapefile with a date. What I want is the first row in my below table to read 7/14/2022 12:00:00 AM, second row to be 7/14/2022 12:01:00 AM, third row to be 7/...
2
votes
2
answers
469
views
Eval Error: Cannot convert '21.05.19' to Date
I would like to make a date out of a string (QGIS 3.22). For this purpose, I have created a new field into which the conversion is to be made with the following formula.
to_date( "...
- 51
0
votes
1
answer
136
views
Time-enable a WFS to use on ArcGIS Online
Is it possible to time-enable a WFS with a date field properly coded as DATE in ArcGIS Online to use with the new timeline widget in Experience? If so, how?
- 1
1
vote
1
answer
276
views
Filtering active date between two date fields using file geodatabase in QGIS
I would like to save a .qlr with data stored in a file geodatabase that displays active records that fall between two DateTime fields: Start date field and End Date field (inclusive). I had this query ...
- 11
2
votes
1
answer
96
views
Making rule on dates for vector points in QGIS
In QGIS, I would like to create a rule-based on dates for some vector points. These points have a field for dates, in the format dd/mm/yy. The rule would be such that if a date is less than a certain ...
- 175
2
votes
0
answers
236
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 ...
- 21
1
vote
1
answer
658
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
3
votes
1
answer
258
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
151
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 ...
- 33
0
votes
0
answers
271
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&...
- 1,038
1
vote
1
answer
220
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