topic Re: Advice on Storing Multiple Temporal/Time-Aware Attributes in Data Management Questions

Advice on Storing Multiple Temporal/Time-Aware Attributes

HenryKo3 — Wed, 10 Aug 2016 02:29:20 GMT

Are there any best practice / advice on storing multiple temporal attributes in geodatabases (SQL or file)?

We have a feature class that have multiple attributes that change over time. For example, a "Cities" feature class can have attributes of "Population Size", "Pollution", "Accident Counts"... etc that change over time (per year). We want to show the attribute changes over time as a time-aware layer in ArcMap and a JavaScript API app.

What would be the best way of storing such information? So I will have a "Cities" feature class. Should I have separate tables such as "CitiesPopulationSize" and "CitiesAccidentCounts", or should I use one single table storing all the time-based attributes? We can have many time-aware attributes for the several feature classes.

Anyone got any ideas/experience with this?

Re: Advice on Storing Multiple Temporal/Time-Aware Attributes

BirajaNayak — Thu, 11 Aug 2016 17:45:23 GMT

Hi Henry,

Have you checked archive option in geodatabase. Here is the web help link:

The archive process—ArcGIS Help | ArcGIS for Desktop

It helps to keep track of chnages of feature in time.

Hope this helps.

Thanks,

Biraja

Re: Advice on Storing Multiple Temporal/Time-Aware Attributes

XanderBakker — Thu, 11 Aug 2016 18:11:29 GMT

I would probably use separate featureclasses for each attribute ("Population Size", "Pollution", "Accident Counts", etc), since the change in time may take different time intervals. Enable time according to the specifics for each attribute.

Do you have single dates per feature or start and end dates? I assume that a city has multiple features each with its own measurement (or projection of the data into future).

Re: Advice on Storing Multiple Temporal/Time-Aware Attributes

HenryKo3 — Mon, 15 Aug 2016 07:57:50 GMT

Hi Xander, most of them will have a single date value based on year, some will have start and end dates (also based on year).

Re: Advice on Storing Multiple Temporal/Time-Aware Attributes

DanPatterson_Retired — Mon, 15 Aug 2016 08:12:06 GMT

Then keep everything separate and bring the pieces together as you find a need for them. Since you seem to have a disparate collection of information, there is little to be gained by aggregation into a fixed structure until you know what you wish to do with the data. Nothing is stopping you from aggregating at a later stage, since the aggregation structure may become more apparent as you get more data.