Select to view content in your preferred language

Temporal data in separate tables - How to enable time?

888
2
08-03-2019 11:45 AM
deleted-user-RXn6tsFwTuvX
Deactivated User

I am trying to set up a temporal dataset as outlined here:

http://desktop.arcgis.com/en/arcmap/10.3/map/time/temporal-data-in-separate-tables.htm

My data consists of one set of polygon features (Parcels) representing agricultural land parcels (Fields: Parcel ID, Parcel Name) and a seperate table (pH_Values) containing soil ph values on specific dates (Fields: Parcel ID, pH).

Parcels: Parcel ID, Parcel Name

pH_Values: Parcel ID, pH, Date

I have followed the instructions at the above link to create a one-to-many relate with Parcel ID as the relate field.This seems to work fine. 

My issue is when I try to enable time on the polycon layer. I right-click properties -> Time and Select Layer TIme (Each feature has a single time field). However the only fields available to select are the orginal Parcels fields (Parcel ID, Parcel Name) and the fields from the related table are not present. 

Both my layers are in the same geodatabase. Can anyone provide some guidance on how to do this?

0 Kudos
2 Replies
KoryKramer
Esri Community Moderator

You might want to look at

Example 3: A one-to-many join to prepare data for temporal animation

http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/examples-of-queries-with-th...

You essentially need to get to a point where all the data (one record for each time point) is in a single table.  That can be done in different ways, one of those being through the query table.  

0 Kudos
deleted-user-RXn6tsFwTuvX
Deactivated User

Thanks, yes a one-to-many join does work and I've seen the query table route proposed by others (in fact in Pro it seems that I can create a one-to-many join directly without needing to make a query table even though I was under the impression that this should be limited to the first instance only). I think it is better practice to keep data seperate rather than creating a 3rd table.

According to the link in my post it should be possible to do this using a relate rather than a join.

0 Kudos