search

kcigeospatial / MDOT-SHA-NPDES-Next-Gen

Code and issues related to the MDOT SHA NPDES Project. Project codes: Config = 31, Management = 32.
0 stars 0 forks source link

IDDE - Time of Screen ahead in GDB Export #119

Open KCI-Ablowers opened 6 years ago

KCI-Ablowers commented 6 years ago

The time in the 'Date and Time of Screen' field in the GDB is 5 hours ahead of what was entered in Survey123. The time is correct when viewing the feature service in a webmap

table from GDB in ArcGIS- image

table from feature service in AGOL - image

talllguy commented 6 years ago

The five hour difference is due to the eastern time zone being five hours behind UTC. I'll look into what is going on there.

talllguy commented 6 years ago

Time in the form is recorded in UTC.

chrome_2018-03-01_17-39-20

talllguy commented 6 years ago

OK. Here's the thing:

Time values in Date and DateTime questions are always persisted as Coordinated Universal Time (UTC). This is important when you have people working in different time zones. ArcGIS clients will translate the stored UTC values into your local time zone, so they make sense to you. via https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis

So, the time you enter in the form is stored in UTC. You have to know that when looking at the raw data and translate back to your viewing timezone.

talllguy commented 6 years ago

@brentreeves75 @KCI-Ablowers Let's make sure to note this time zone caveat in the SOP.

KCI-Ablowers commented 6 years ago

Added it to my SOP notes. We can use your comment to describe it in the SOP.

KCI-Ablowers commented 6 years ago

@talllguy What section would this go in? QAQC?

talllguy commented 6 years ago

@KCI-Ablowers Where is it most likely to come up? I think QA QC is the right section

KCI-Ablowers commented 6 years ago

@talllguy I think this could just go in as a note somewhere around the QAQC. It doesn't seem worth too much of a call out. The doc doesn't go into great detail about any one field.

KCI-Ablowers commented 4 years ago

@talllguy - Following up on this again since we are at the point where QC of the IDDE Inspections for FY20 is on going. Is the best course of action to still add in a note somewhere in the SOP?

talllguy commented 4 years ago

Yes, I think adding it to the SOP is the way to go. Dates should be assumed to be stored in UTC (though some systems convert to local time). If the time of day is very important and there is some ambiguity here, another option is storing the local time to a string.