topic Re: Collector and Editor Tracking in ArcGIS Collector Questions

Collector and Editor Tracking

jaykapalczynski — Tue, 03 May 2016 13:26:56 GMT

When I enable editor tracking 4 fields are added.

The name of the user who created it.
The date and time it was created.
The name of the user who edited it.
The date and time it was last edited.

But when I look at the data that is recorded the date field is looking like Greenwich time....

Where do I need to specify what time zone I am in to make this record the accurate time?

Thanks in advance.

Re: Collector and Editor Tracking

PeteCrosier — Tue, 03 May 2016 13:50:09 GMT

I think you have two choices - UTC or the database's timezone. UTC is the default. At the time of enabling editor tracking, if you're using the Enable Editor Tracking tool, you can choose between the two. I would imagine that if you enable this within the ArcGIS Online interface then it will pick UTC.

Re: Collector and Editor Tracking

jaykapalczynski — Tue, 03 May 2016 15:19:01 GMT

Where would you set this in ArcGIS Online?

Re: Collector and Editor Tracking

AbhijitSarkar2 — Thu, 01 Sep 2016 07:42:56 GMT

00129: <value> Editor Tracking dates in database time zone—Help | ArcGIS for Desktop

Re: Collector and Editor Tracking

DougMorgenthaler — Thu, 01 Sep 2016 18:57:19 GMT

I'd recommend storing the time in UTC unless you have a specific reason not to; clients like Collector for ArcGIS will automatically apply the appropriate time zone offset so it is displayed in local time of the device/user rather than where the database physically resides (which might be in a different time zone altogether).

-Doug

Re: Collector and Editor Tracking

RandyBurton — Thu, 01 Sep 2016 21:24:39 GMT

I also suggest using UTC. I will query features using the REST API and Python with a line of code to convert the time zone from UTC, such as:

editTime = time.strftime('%c', time.localtime(feature['attributes']['EditDate']/1000))‍‍

In addition, there is a Convert Time Zone tool in the Data Management - Fields toolset that can assist in this process if you are downloading the feature in a file geodatabase.