Time disappears when exporting from query

129
4
Jump to solution
07-06-2018 09:07 AM
Highlighted
New Contributor

I am attempting to make a time-series in ArcGIS Online. I already have my four layers set up in ArcMap, and have successfully run time series on them all. The date fields are coded as dates and I've attached a screenshot for reference. The tables are made using Query Tables, as I have somewhere in the vicinity of 1500 records that needed matching to time stamps. Here's my problem - whenever I export the data to a shapefile, to fold it into a .zip for Online, the time stamps are shortened to just the date. Since all my data takes place on the same day, but at different times, I very much need those. Can anyone let me know what I am doing wrong? Why are my times disappearing when exporting? At first I thought it was a character # issue,  but shortening didn't help with anything.

Thanks in advance!!

Attribute table with all the time stamps

Attribute table after exporting

Tags (1)
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Honored Contributor

Shapefiles Date fields can only hold date information, not time. From the documentation:

However, for coverages and shapefiles, the time portion is truncated from the datetime value. For example, the datetime 2002-08-20 12:00:00 PM is stored in a coverage or shapefile as 2002-08-20.

View solution in original post

4 Replies
Highlighted
MVP Honored Contributor

Shapefiles Date fields can only hold date information, not time. From the documentation:

However, for coverages and shapefiles, the time portion is truncated from the datetime value. For example, the datetime 2002-08-20 12:00:00 PM is stored in a coverage or shapefile as 2002-08-20.

View solution in original post

Highlighted
New Contributor

Thank you, that was a silly oversight!

I now have another problem - When importing, the time zone is wrong. I first did it in Pacific, then realized ArcGIS operates in UTC. I changed my time-enabled layer in ArcMap to UTC+adjusted for DST, but my time stamps are still off. Am I missing something? Not changing the right thing?

Reply
0 Kudos
Highlighted
MVP Honored Contributor

Are the features' time in UTC or Pacific? You should set them to the time zone they were recorded in. Otherwise, AGOL will assume they are UTC.

And don't forget to mark the question as answered.

Reply
0 Kudos
Highlighted
New Contributor

They were recorded in pacific. 

Ive tried with both and both end up imported as the wrong time. 

Reply
0 Kudos