Questions tagged [date]
Time stated in terms of the day, month, and year.
178
questions
3
votes
1answer
42 views
Change data format in QGIS field calculator using format_date
I´d like to change the data format in the attribute table from yyyy-MM-dd (default) to dd.MM.yy using the format_date function in the field calculator.
Using:
format_date(date, 'dd.MM.yy')
I got ...
4
votes
2answers
1k views
Transforming ArcGIS date field to integer?
I have a featureclass with a 'date' class field named 'ACQ_DATE' formatted as:
1-8-2013
24-7-2013
etc. As you can see the number of digits is not harmonized. I want to display the dates on a ...
7
votes
4answers
965 views
Parsing serial date in ArcGIS Desktop?
I have imported a shapefile that contains a serial date number that looks like this: 41256.260799. I would like to create a new field that shows only the hour and second like this: 06:33. I've tried ...
0
votes
1answer
57 views
Grouping wildfires dates by season and getting sum and count using ArcPy?
I am having some trouble creating a new shapefile and CSV to group wildfires into seasons.
What I want to do is to group the wildfires by meteorological season (summer, fall, winter and spring) for ...
0
votes
0answers
25 views
Google Earth Engine timelapse video: How to display the date (year) of each image in the video? [duplicate]
I'm currently producing Timelapses with Google Earth Engine. I have produced the video but I haven't found a way of adding the Date (or the Year of the picture) to the different images that are being ...
0
votes
1answer
24 views
Pulling date from filename and in proper format for time enabled use?
My feature attribute table has a folderpath that indludes a date time.
Example:/documents/foldername/xyz2015OCT15063333.shp
It seems very simple, but I am not a programmer and have done my best to ...
1
vote
2answers
43 views
Introduce year instead of whole date in date type field using ArcGIS Desktop?
I have a field with numbers in it (concentration of chemical compounds that were presented in aquatic environments) and I'd like to combine them with a field which would have date type capabilities ...
2
votes
3answers
2k views
Symbolizing by year, when date column has MM/DD/YYYY?
I am trying to symbolize an SDE feature, so I can't add any new columns. The date column is formatted as MM/DD/YYYY. I would like to symbolize all 2015s as one symbol, 2016, 2017 as other unique ...
0
votes
0answers
43 views
Sorting Identify feature results by DATE field in ArcMap?
I'm using ArcMap 10.3. When I use the Identify tool, I often have many results and would like to sort those results in the Identify window. If I right-click on the layer name or features in Identify ...
0
votes
2answers
37 views
Selecting multiple date ranges using Select By Attribute?
Using ArcGIS Desktop 10.6.1. I'm interested in selecting multiple date ranges using Select By Attribute.
I've verified that each date range works. For example Date >= '2015-04-15' AND Date <= '...
1
vote
1answer
44 views
Locating date, scale, and coordinate system of shapefile in ArcMap?
I am trying to locate the date, scale, and coordinate system/projection of a shapefile in ArcMap but when I right click on the file in the table of contents and go to properties, I don't see the date ...
1
vote
0answers
50 views
Datetime on attribute tables
I have written a script to add, among other stuff, a datetime column.
I have used the arcpy.AddField_managementcommand, but it didn't have a 'Datetime' type, so I used the 'Date' type : arcpy....
1
vote
1answer
37 views
Storing date in m-dimension of PostGIS geometries
Do you know if it is possible to assign a date (whatever the format) as the 4th dimension to a geometry in PostGIS? If so, does it recognize it as a date?
0
votes
0answers
11 views
Creating polygon for each day from table with change of area over time (by day) using ArcGIS Pro?
I have a .csv with data in rows over time (date field and multiple attributes for each day) of the same single area - the fields are high temperature, low temperature, humidity, precipitation.
I want ...
3
votes
1answer
378 views
Editing date in *.ssf files?
So my trimble TSC1 Pro XRS (bought in 2000) is getting old I guess and it change byitself the date. I collected data this week, but it indicate from 1998.
I view this info because I can't apply ...
8
votes
2answers
3k views
Making automatic updated date and time field in QGIS?
I want to make a date and time updated field as I edit an attribute field in this format yyyy-mm-dd 00:00:00 (= 2016-05-08 11:04:00) - my local date/time. The data is in a QGIS 2.14 shapefile and ...
1
vote
1answer
70 views
How to have a date earlier than 1753 in QGIS date field?
I'm trying to map out some of my family tree but I've stumbled upon a problem of not being able to put in early dates.
I created the shapefile in QGIS and included a date field (dd-mm-yyyy).
Whenever ...
2
votes
1answer
232 views
Filter Specific dates in Google Earth Engine?
I've called Landsat8 images from 2014 to 2019 using filter date function. But I don't know how can I call Landsat8 images only for June, July, and August from 2014 to 2019?
Map.centerObject(geometry);...
2
votes
1answer
214 views
Add Date to raster layers in raster stack in R
I have a raster stack and I want to add to it a Date field which will include the year-month-day for every rasterlayer. I have my dates in a one column data.frame.
I tried to do this with addLayer ...
0
votes
1answer
40 views
Stripes between 2 images of Sentinel 2A (Level-1C)
Why do i get these stripes between 2 images of Sentinel 2A? (Figure)
I notice that this happened for 2 images of different sensing date (even they're just 3 days away).
Has anyone had this ...
8
votes
2answers
3k views
How to convert a string field to a date field
I have a layer with points which represent the fatal road accidents and the field "dates_14_D" contains their date but its type is string. I would like to convert this string field to date field but ...
0
votes
0answers
26 views
Selecting values with date-format by using SelectLayerByAttribute_management with input Parameter
I am working on a Tool which selects records depending on the input value.
Works fine, till I want to select date-records. I used
def buildWhereClause(self, table, field, value):
# Add DBMS-...
2
votes
1answer
392 views
Changing date format in QGIS?
I have just created a date field attribute.
In Proprieties > Fields of the layer I made this:
And the attribute tables shows this:
What I want to see is the date in this format: 07-01-2019 and ...
2
votes
3answers
120 views
Batch rename MODIS data?
I have MOD13Q1 NDVI images. Data are named in this format:
MOD13Q1.A2007049.h26v06.006.2015161224938_MODIS_Grid_16DAY_250m_500m_VI.tif
(YYYYDDD) Here 2007 is a year and 049 is day in year.
I ...
0
votes
1answer
40 views
Selecting points in polygon in a range of time (ArcGIS)
I have:
- point GPS for people (time in seconds)
- buffer GPS for a car (time in seconds)
What I want to do is for each buffer GPS coordinate, I want to find the number of GPS people points inside ...
5
votes
2answers
304 views
QGIS date fields widget - unable to select todays date?
This is something that I have lived with for several months as there is an easy workaround, but I thought I'd see if anyone knows of a solution, or whether it is a bug.
In Layer Properties > Fields I ...
0
votes
1answer
33 views
Add default month/day to known year in new date field?
I have a text field featuring a 4 digit year. How would I assign a default month and day to the year in a new date field?
ex. 2010 needs to be converted to 1/1/2010
I attempted this in the field ...
1
vote
1answer
126 views
Filter a date interval (month) shapefile
I'm trying to filter some data of a shapefile (with "Filter") for QGIS to show points in a date interval of a shapefile. I have a shapefile which has a table of attributes of sightings of animals with ...
1
vote
1answer
155 views
Filter Google Earth Engine image collection between today and 10 days ago
I wrote a small script that filters GEE image collection by date that I'm manually change:
var start_date = '2018-11-02'
var end_date = '2018-11-30'
// choose image collection
var ls8 = ee....
6
votes
2answers
1k views
Binding between QGIS custom form (Qt Designer) and date/time field in SpatiaLite database table?
For my attribute table I created a custom form in Qt Designer. The table has a date field and a time field.
In Qt Designer there are widgets for entering date and time but what data type is expected ...
1
vote
0answers
139 views
Converting double to date field using QGIS?
In ArcMap I have a table with a column with the date type yyyy-mm-dd, but after opening SQlite in QGIS, this column is written as a double type.
How do I convert data in the form of a number to a ...
1
vote
1answer
193 views
QGIS: Symbolize by date field based on current date
In QGIS 3.2.3: I have a layer/Shapefile with a date field (type DATE) that comes from a joined table. I would like to symbolize the points which are older than 10 days (based on the current date) in ...
1
vote
1answer
391 views
Arcade expression to see if current date is within two dates?
I am new to building expressions in Arcade and I am having trouble writing an expression that can be used to check start and end times of different areas and evaluate if the current date is within the ...
1
vote
1answer
1k views
Converting ee.Date object to client string in Google Earth Engine?
I'm trying to export all the images in an ImageCollection to Google Drive and by default name the output image with the date using format() function. However, when I try to name a export task by a ...
4
votes
1answer
59 views
How to determine the right time of Landsat 8?
Sorry, please help me clarify this issue.
Assume that I have information from a Landsat 8 image with the time shown as below:
Start time: 2018:288:03:13:25.1532590
Stop time: 2018:288:03:13:56....
3
votes
2answers
604 views
Filter a shapefile by date in the Query Builder of QGIS
I have a shapefile that I'm trying to filter by date (i.e. START_DATE). This same query START_DATE = '2007-07-25' works in the Attribute Table > Select features using Expression, but not in the ...
3
votes
1answer
404 views
Reducing number of points, keeping most recent data within given distance, using QGIS?
I have a HUGE dataset of points that were collected along a route. The data may change daily, and the most recent data is the most important. What I would like to do is take only 1 point from a given ...
1
vote
1answer
95 views
Stack RasterDataset taking into account the dates between images
Good morning,
I would like to stack a raster dataset taking into account the number of days between images. Sometimes the number of dates between observations are 8, 16 or 365 days. Is there any ...
1
vote
0answers
128 views
ogr2ogr: filter on date-field
ogr2ogr -spat_srs EPSG:31370 -spat 179600 167350 179800 167500 -f "ESRI Shapefile" test.shp "WFS:http://ccff02.minfin.fgov.be/geoservices/arcgis/services/WMS/Cadastral_Layers/MapServer/WFSServer?" ...
2
votes
2answers
87 views
Show “!” label when the date is close
In the attribute table I have a column "the end of the contract" with date. I want QGIS to show me the label "!" when there will be 30 days or less until the end of the contract.
1
vote
1answer
261 views
Incorrect time displaying in ArcGIS API for JavaScript popup template?
I'm creating a web map that is updated a few times a day showing voltage readings from meters on our distribution network.
This layer has a field called ReadTime, and the data type is Date.
The date ...
1
vote
1answer
255 views
Thematic map using date field in ArcGIS [duplicate]
I need to create a thematic map for time intervals (ex. 1/1/1920-31/12/1929). To every polygon corresponds a date (from a date field) and I need them to be coloured depending in which interval they ...
2
votes
1answer
132 views
Style features based on difference between current date and date in attribute table
In QGIS >2.18, is it possible to style features based on the age gap between the current date and date recorded in the attribute table. For instance I have purchased a significant amount of OS data ...
6
votes
1answer
167 views
Adding date to label in QGIS Atlas composer?
I'm trying to add the current date into a label for use in a composer for colleagues to run on a daily basis. The label is currently;
Bins to be delivered: [% "Count" %]
All I need to add is the ...
0
votes
2answers
66 views
BC Dates on cartodb.com?
I'm trying to use historical dates to build a torque map on Cartodb.com, with data going back to 8000 BC. But the date format doesn't seem to convert anything bellow 0100 01 01 (1st Jan 100 AD), and I'...
3
votes
1answer
348 views
QGIS: How to convert date values with format d-m-yyyy in a string field, into date values with format yyyy-mm-dd in a date field?
I have date values with the format d-m-yyyy in QGIS.
They are in string field.
I want to convert them into date values with the format yyyy-mm-dd.
I want them in a date field.
Can this be done ...
1
vote
1answer
35 views
Changing date format in field name from d2000_5000 to Dddmmyyyy? [closed]
I am trying to change the name of a field by using Python code where the current name is in the format (e.g.) d2000_5000, and 5000 is the decimal year (0,5 y) added to 2000. So i think that this can ...
1
vote
1answer
92 views
Creating date picker for CartoDB map?
I am working with data that I need to be able to display by day gathered, and it's gathered over a period of years. I would like the user to be able to select a date from a calendar-type picker, and ...
2
votes
1answer
1k views
Unique List of Image Dates from Image Collection in Google Earth Engine
I would like to create a list or array object containing a unique set of dates represented in an image collection for a given region of interest. I have a function that extracts and converts dates for ...
2
votes
0answers
170 views
QGIS - Default Date Formats
I manage a fairly large estate of QGIS installs in the UK and am looking to set the default date formats to the uk dd/mm/yyyy format from our MSSQL data warehouse. Its set and works correctly in the ...
