I have a time aware map service which is based on a polygon feature class and a stand alone table with the time series data joined to the polygons on a polygon ID field. It is the situation described as Temporal data in separate tables. The service has been working fine but now I need to append new time series data every month.
What is the best way to do this?
I need to minimise manual interventions so I wonder if it is possible to insert the new data through the RESTful API. I am concerned that the service will not pick it up automatically because they will be out of the date range defined in the map document. I also suspect that some columns in the time series table would need re-indexing and I am afraid I can't do that while the service is running.
Any suggestions welcome.