I am using ArcGIS Desktop 10.2.2.
I have a file geodatabase with two files, a table and a feature class with point geometry.
- The feature class contains transit stops with the stop number and the geography of each stop
- The table contains boardings per trip per day at each stop, with time and date information for each record.
This is obviously a many-to-one relationship, because there's only a few hundred stops but hundreds of boarding records at each stop. What I would like to do is join the table to the feature class so that I end up with a feature class with each boarding record linked with the relevant geography for the stop. (My goal is to produce a time series animation showing boardings over time.) However, there doesn't seem to be a straightforward way to join geographic data to a table and transform that into a feature class.
Do I need to do a more complex workaround?
I do have the lat-long data, so I could just create a feature class from the table using that data, but isn't there an automatic way to do it that doesn't force me to re-create geographic data?
I'm using ArcGIS 10.2.2 Basic on Windows 7.