nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Time disappears when exporting from query

AnnaAlligood

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

Find more posts tagged with

Accepted answers

kenbuja

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.

All comments

RaineyBarton

Has anyone figured out a solution to this problem? I agree with WilliamJameson that stating the problem with respect to the shapefile date field is not a solution. If you have a layer in AGOL that has both date and time in the Date field, how then do you get it in a format that can be exported and retain time?

WilliamJameson

I guess I am dense, but restating the problem is not a solution. Referring to esri documentation about dates is also not a solution.

ArcGIS has dropped the ball on this. I have date-time in a CSV file. when converted to a shapefile the time is lost. I have over 375,000 records, so retyping anything is not an option. turns out too that converting my CSV file date-time column to text does not help either because arcMap sees that text column and identifies it as date and drops the time anyway. I cannot see a solution.

Why would anyone need 375,000+ records? ships crossing an ocean, or airplanes flying over a nation for two weeks are two reasons.

AnnaAlligood

They were recorded in pacific.

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

kenbuja

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.

AnnaAlligood

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?

kenbuja

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.