How to export time?
GIS Cloud offers two special fields containing time data that can be activated through the Layer Properties >> Attributes tab, those are: CREATED and MODIFIED.
CREATED records the time when the feature was created on the map while MODIFIED records the time the feature was edited.
Through MDC you can also collect time information with the following form items: Date & Time, Date & Time – only Date, Date & Time – only Time set by collectors and Time which records the time of the device when the feature was sent. Take a look at the form items overview.
GIS Cloud records time (form item Time) as a timestamp (e.g. 1482843934). The timestamp is the number of seconds that have elapsed since January 1, 1970 00:00:00 UTC/GMT, not counting leap seconds.
It is a sequence of characters or encoded information identifying when a certain event occurred, usually giving date and time of day, accurate to a small fraction of a second.
This data is usually presented in a consistent format, allowing for easy comparison of two different records and tracking progress over time.
Keeping in mind that users need a human-readable format, all the time data is converted and shown this way in the data grid. To maintain it as it is in the data grid we suggest you download it directly from the data grid in a CSV format.
More information on collecting time information can be found here.
Convert timestamp to human-readable format
In case you encounter the timestamp format it can easily be converted to a human-readable format using the converter, which can be found here.
- Contact firstname.lastname@example.org so someone could enable you to access our timestamp converter.
- In the first column enter a timestamp you want to convert.
- In the second column enter the UTC offset.
- The third column shows the result, a human-readable date and time format.
Note: UTC offset – Coordinated Universal Time offset is a time difference between your time zone and the conventionally mean time zone measured from the prime meridian (0° longitude). There are 38 time zones, ranging from UTC-12 to UTC+14.