Temporal data in separate fields

Temporal data is commonly stored in columns or fields in your attribute or stand-alone tables. An example of temporal data could be medical costs per county for 1990, 1991, 1992, and so on. In this case, each column contains a value of the medical costs for that county and the given year. To visualize this data in ArcGIS Pro, the table needs to be reformatted so that all time data is in a single column with multiple rows. This means you would need to create multiple rows for each county with a single field containing the medical costs and another field containing the corresponding years.

Use the Transpose Fields geoprocessing tool to shift the date entered in multiple fields or columns into multiple rows in a table or feature class.

Related topics