Temporal data can be stored in a variety of ways. Here are some best practices you can follow when storing your temporal data.
Store time stamps in a date field
It is recommended that you store the time stamps of your temporal data in a date field. This is a database field type specifically for storing time and date information. It is most efficient for query performance and supports more sophisticated database queries than when storing time in a numeric or string field.
Depending on your needs, you can also store the time stamps in your data in string or numeric fields. For example, yearly data can be stored as 2000, 2001, and so on.
Date display is only supported for the range of AD100 to AD10,000. To work with dates outside this range, it is recommended that you convert your values into either a numeric format (and filter using the range slider) or a string format (for labeling).
You can choose to use the Convert Time Field geoprocessing tool to convert a string or numeric field containing time stamps into a date field.
Store temporal data in a row format
If you're using temporal data in ArcGIS Pro, store the time values associated with individual features in a row format. Each feature or row in a table can have either time values in one field representing a time instant or time values in two fields representing the beginning and end of the observation.
Depending on whether the attributes of your data change over time or the shape of each feature changes over time, you can choose to store your temporal data in a single table or in separate tables.
Often you'll have time represented in columns in your attribute table, for instance, medical costs per county for 1990, 1991, and 1992. To visualize this data through time, the table must be reformatted such that the time values are in row format.
Index fields that contain time values
To improve time visualization and query performance, it is recommended that you index the fields containing the time values. You can use the Add Attribute Index geoprocessing tool to add an index to a field in an existing table or feature class.
Use standard time
For temporal data collected in regions where time is adjusted for daylight saving time, you should store the time values in your data in standard time. Data collected with daylight saving time can be difficult to maintain. Daylight saving can vary from region to region, and the rules defining the daylight saving adjustments can change over time.
Storing the time values in standard time prevents any loss or overlaps of data during data compilation and allows time visualization during the transition hours without ambiguity.