Skip to main content

Questions tagged [date]

Time stated in terms of the day, month, and year.

Filter by
Sorted by
Tagged with
1 vote
1 answer
56 views

Can't read the numbers in the calendar in QGIS because it is too dark

When I create a layer with a date field in QGIS 3.34.4 and activate the NOT NULL restriction in the layer options, the background color in the layer formular let the numbers disappear. I couldn't find ...
Blabsl's user avatar
  • 393
1 vote
1 answer
42 views

GDAL ogr2ogr ESRIJSON to PG Date Formatting

I'm trying to load some data from an Esri Feature Server URL into PostGIS, using ogr2ogr but seem to be facing some issues with the date formats. The below code should in theory load all the World ...
Tim R's user avatar
  • 33
1 vote
1 answer
77 views

How to filter by date in a WFS request?

I'm using the following GetFeature request to filter features by a date field. (The layer is, for testing purposes, hosted by a local GeoServer instance and its data is stored in a GeoPackage file on ...
goofy4224's user avatar
0 votes
1 answer
24 views

Using band epoch to obtain date time stamp of data from a specific location

I would like to use JAXA/ALOS/PALSAR/YEARLY/SAR_EPOCH' V2 for HH HV backscatter values and have tried to use epoch band to display date of observation using: var obsdate = data.select('epoch') I was ...
gymo5FLG's user avatar
0 votes
1 answer
146 views

Calculate date difference between current date and previous date using Arcade with ArcGIS Pro

I can't find the error in my code. I am trying to calculate the difference between the current date and a previous inspection date. I want the difference to be calculated in days. I am using ArcGIS ...
user237830's user avatar
1 vote
3 answers
177 views

FME DateFormatter is not correctly setting white spaces to null and DateTimeConverter doesn't offert this option

Using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) at the time of writing, I'd like to format a date field from an Excel spreadsheet into an ISO date which should then be written to a PostgreSQL ...
swiss_knight's user avatar
  • 10.5k
0 votes
0 answers
19 views

Extract values from a raster (imported as a NetCDF file) to table - problematic date/time column

I have a NetCDF file with sea surface height data, which I imported into ArcMap as a raster. I plotted the points and extracted the values at each location using the sample tool. In the raster, each ...
D. Kyriakoudi's user avatar
3 votes
2 answers
165 views

Showing attribute field of date type with years in four digits in QGIS

The problem In QGIS 3.34 Prizren, I have an attribute field of date type. Unfortunately, years are shown only with two digits: 23 instead of 2023. As a historian, this is really bad as it could be ...
Babel's user avatar
  • 73.2k
0 votes
3 answers
638 views

Calculate Field Date

So I created a Date field in a dataset with 5 rows and so I then right clicked on Calculate Field to enter the date (all 5 rows have the same date). The date I entered was 1/1/2022 but Pro did not ...
Arthur_Morgan's user avatar
2 votes
1 answer
103 views

Calculating age of overlaying points with virtual fields in QGIS: optimize compute-intensive approach

I am working on a project in QGIS, where I have two point layers, named "Infrastructures" and "Inspections". In my system, whenever an infrastructure is inspected, a new point ...
MartinMap's user avatar
  • 8,338
7 votes
1 answer
69 views

Finding out date format in the list of house numbers in QGIS

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 ...
Bruno B's user avatar
  • 849
4 votes
1 answer
229 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 ...
BramV's user avatar
  • 107
4 votes
1 answer
94 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)....
Geo_it's user avatar
  • 523
0 votes
0 answers
26 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 ...
Sebastian Silva's user avatar
1 vote
1 answer
371 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 ...
Rachel's user avatar
  • 11
0 votes
1 answer
181 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 ...
Matt Leonard's user avatar
0 votes
0 answers
52 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(...
Sethinacan's user avatar
  • 1,726
1 vote
0 answers
16 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. ...
Honeybear's user avatar
  • 2,524
1 vote
1 answer
113 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: ...
Mestrexama's user avatar
0 votes
1 answer
68 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,...
Roney's user avatar
  • 31
0 votes
1 answer
139 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 ...
GisT's user avatar
  • 91
1 vote
1 answer
321 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....
Skel80's user avatar
  • 155
5 votes
1 answer
310 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 ...
Stu Smith's user avatar
  • 8,192
0 votes
1 answer
38 views

Excluding 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 ...
Lilian's user avatar
  • 11
0 votes
1 answer
360 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 ...
Stu Smith's user avatar
  • 8,192
0 votes
1 answer
149 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 ...
shravani banerjee's user avatar
2 votes
0 answers
107 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 ...
Acperience's user avatar
  • 1,142
2 votes
2 answers
182 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 ...
charliey's user avatar
  • 163
0 votes
1 answer
76 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 ...
Ivan Insua's user avatar
1 vote
0 answers
170 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/...
Anisha's user avatar
  • 11
1 vote
1 answer
45 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....
Vileralala's user avatar
1 vote
0 answers
540 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 ...
GIS Noh's user avatar
  • 321
1 vote
1 answer
207 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 ...
HMadadi's user avatar
  • 1,046
0 votes
1 answer
194 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 ...
Arjumand's user avatar
0 votes
0 answers
252 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 ...
ScuffedBradPitt's user avatar
0 votes
2 answers
387 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 ...
Richard Livingston's user avatar
0 votes
1 answer
326 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,...
maverickGIS's user avatar
7 votes
4 answers
1k 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") =...
Jessica's user avatar
  • 73
1 vote
0 answers
1k 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 ...
Enzo Baldini's user avatar
  • 2,347
4 votes
1 answer
131 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. @...
Julio Palomino's user avatar
1 vote
1 answer
101 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 ...
Robert West's user avatar
0 votes
1 answer
78 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 ...
Eli Simonson's user avatar
0 votes
1 answer
151 views

Figuring out aduisition dates of images from file names using Earthexplorer

I have multiple 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 ...
perep1972's user avatar
  • 115
0 votes
1 answer
236 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": &...
Wulan's user avatar
  • 9
0 votes
1 answer
471 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 ...
surdeep's user avatar
  • 51
0 votes
0 answers
102 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. ...
Arthur_Morgan's user avatar
2 votes
1 answer
621 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 ...
Arthur_Morgan's user avatar
0 votes
1 answer
815 views

Quick Map Services (QMS) Google Satellite Imagery Source Date

I have digitized landform features using the QMS Google Satellite as a reference basemap in QGIS, and therefore need to know the date the image was taken. Is the plugin a 'live' updating feed from ...
Freya's user avatar
  • 1
1 vote
0 answers
27 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 ...
Sara's user avatar
  • 11
1 vote
2 answers
695 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/...
Connor Garrett's user avatar

1
2 3 4 5
7