Questions tagged [date]

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

24 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
218 views

Current date in query builder Qgis

I'm trying to put a query on a vectorlayer with the current date. The following code works, but I want the current date to be dynamic: cast ("Starttijdstip" as character) < '2018/03/01' AND '...
2
votes
0answers
25 views

Why the data type of date column is showing as string in QGIS but back in csv file it is date type?

I have created a .csvt file as name as same csv file and placed in same directory. After that data type of date column are showing as a date type but when I am checking it in attribute table values ...
2
votes
0answers
196 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 ...
2
votes
0answers
91 views

Does qgis support postgresql range types?

I added a postgis layer with date range column in Qgis but that field is not listed in Qgis.
2
votes
0answers
295 views

openLayers and geoserver: WMSGetFeatureInfo does not return feature beyond wrapdateline

I built a map made of several layers. I need to display the layers features fields at the place where the user clicks (see the controler code hereafter). The layers are correctly displayed and go ...
1
vote
0answers
20 views

Image Age Information of XYZ Base Map in QGIS

Is there a way to find the age of the imagery of a base map via pyqgis? Any help on this would be much appreciated.Thanks.
1
vote
0answers
87 views

Using ArcGIS Pro to select all data collected “Yesterday” regardless of the time of day

I am using ArcGIS Pro 2.4.3. I can upgrade if needed. I am reading a hosted feature layer from my Organisation's AGOL site in ArcGIS Pro. This is using the standard Esri Data Store. This dataset ...
1
vote
0answers
24 views

GEE - Get date of ImageCollection mosaic

I have created mosaics by date from an ImageCollection and now want to label each mosaic with its corresponding date. This is my function to label the ImageCollection: var date_label_pos = ee....
1
vote
0answers
58 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
0answers
199 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?" ...
1
vote
0answers
157 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
0answers
39 views

define startMonth for jqtimeline plugin in a webmap

I created a webmap with timeline function by using leaflet.js and jqtimeline plugin. Do you know a possibility to not just define the startYear but a startMonth with jqtimeline plugin? The reason is ...
1
vote
0answers
412 views

ArcGIS Server Rest API date issue

I am using "date '2015-8-10'" in ArcGIS Server REST API to retreive records from map services. But it returns the error "Fail to Execute". My date is stored as "10-AUG-15". When it is in the right ...
1
vote
0answers
118 views

qgis 2.8.1 date filter gives incorrect selection results

I am running QGIS 2.8.1 on ubuntu 14.04 x64. I applied a date filter to a shapefile using the layer Properties_General "Query Builder" button. So the query was "LOCATION START DATE" >= '01/01/...
1
vote
0answers
209 views

How to transform Invalid Date format in Data Interoperability

My workbench is running into some date data it is rejecting. Here is the error I'm receiving... The invalid value '20100419000000' was supplied to the field 'install_date_orig' I believe the feature ...
0
votes
1answer
31 views

Trouble with using Freemarker to formate Date for GeoServer GetFeatureInfo

I'm having some trouble while trying to use the Freemarker Template to display dates in the desired format. I store points with a date information in a PostGIS database written through an FME-process ...
0
votes
0answers
9 views

Extracting the dates of Google Earth Pro VHR images using a grid?

I am doing a study on land use change and needed to quantify the bias due to poor coverage of some regions. First I would like to know if this is an issue at all in my case study. I have a ...
0
votes
0answers
67 views

Getting week number from date using Arcade with ArcGIS Online

How can I get the week number (week position in year) from a date with ArcGIS Online’s Arcade?
0
votes
0answers
33 views

Updating Date Field based on date value ONLY from another field using ArcGIS Field Calculator

In ArcMap 10.4 I have the following code in Pre-Logic Script Code Section in Field Calculator with python option selected and show code block: from datetime import datetime def myfunction(date_text):...
0
votes
1answer
84 views

Definition Queries for most recent date in ArcGIS Pro

I have a feature class containing sample results for locations that includes thousands of records. Many of these are overlapping and have the same location ID. I need to label each sample based on the ...
0
votes
0answers
32 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-...
0
votes
0answers
71 views

Format ArcMap Date format

I am really new to Python and I am trying to create a tool using arcpy where I am using the calender as the data type for one of the parameters in the tool. The date format ArcMap is giving me is ...
0
votes
0answers
91 views

How to get work time-series with AM and PM data?

I read tutorial and get all work with data like 20170526, but how to get it's work if I have AM and PM data for specifieded date? As I understand from docs date placing and shp to date field, and ...
0
votes
0answers
247 views

MapInfo Populating Dates in Table

I am opening an Excel spreadsheet in MapInfo. One column of the Excel spreadsheet holds a date per row. Some of the rows dont have an assigned date this is fine. When opening the table in MapInfo, ...