ArcGIS Pro

Working with Online feature service date-time attributes in non-UTC time zones in ArcGIS Pro 2.7

Problem

If you work with ArcGIS Online hosted feature services in ArcGIS Pro and your service has date fields, then you may have noticed that date-time values for web feature layers in ArcGIS Pro are always in UTC. This can be seen when you:

This leads to two issues:

It can be frustrating, as the data can appear incorrect, and it can also potentially lead to incorrect data entry.

 

Solution

We are pleased to announce that with the ArcGIS Pro 2.7 and ArcGIS Online December releases, these problems are resolved.

Here is what you need to do:

A) Configure your feature service with a preferred time zone.

Just like the date field’s default time zone, this is something you will set at the service level and all layers in that feature service will inherit the settings.

  1. Go to the service UpdateDefinition operation page (you must be the owner of the feature service).
    • https://servicesdev.arcgis.com/…/arcgis/rest/admin/services/<yourServerName>/FeatureServer/updateDefinition?token=<token>&f=pjson
  2. Remove everything from the text box.
  3. Copy-paste the JSON below into the text box. This example sets the time zone to Australian Eastern Standard Time.
  4. Click the Update Layer Definition button.

B) Use ArcGIS Pro 2.7 or a later release.

  1. Add the feature service to ArcGIS Pro.
  2. Open the service’s attribute table. Any date-time values displayed in Sydney, Australia time will no longer be 11 hours behind.
    A date value of 1/16/2018 will appear as ‘1/16/2018’, and not ‘1/15/2018 1:00:00 PM’.
  3. If you want, you can check the layer’s time zone. There are two places you can see this information:
    • In the Layer Properties page’s Time tab, you can view the layer’s Time Zone. With this example, it would be set to ‘(UTC+10:00) Canberra, Melbourne, Sydney)’ instead of UTC.
    • In the date field header’s tooltip, you can view the same time zone ID.
  4. If you want to label your features with date-time values, we recommend you to use the following Arcade expression:
    Text($feature.DateOfActivity, "DD/MM/YYYY HH:mm:ss A")

 

Limitations

A feature service you can try right now…

For your convenience, here is a feature service where the preferred time zone is configured to AUS Eastern Standard Time. You can find the original feature service here which does not have a preferred time zone set. Add both of them to ArcGIS Pro 2.7 or later, and see the difference.

Useful help topics

About the authors

Tanu is a product engineer on Esri Mapping Team focusing on map service, print service, and ArcGIS Pro. He also works on spatio-temporal analysis, spatial aggregation and real-time data. Tanu’s background includes a masters in Urban Planning from University of Akron, Ohio, USA and a bachelor degree from Khulna University, Bangladesh, and worked as GIS Coordinator in City of West Springfield, and GIS Specialist in a hydrology modeling center in Bangladesh before joining Esri.

Connect:

Greg is a Product Engineer for the Mapping team on ArcGIS Pro, with interests in cartography, technical writing, editing, and data visualization. He is a Wisconsin native and started his Esri journey in 2013.

Connect:

Joined Esri in 1999, currently managing the Map Exploration software development sub-team working on ArcGIS Pro. Likes 3D and animations.

Connect:

Leave a Reply

Please Login to comment

Next Article

ArcGIS Hub says goodbye to Internet Explorer and Edge Legacy

Read this article