3.10.2.5.1 Enabling Spatiotemporal for a Dataset

In order to visualize and animate moving objects, you must enable Spatiotemporal for the dataset containing spatiotemporal data on the Datasets page.

Spatial Studio considers a dataset to contain spatiotemporal data only if it meets the following requirements:

• It must be based on a geometry table or view with a geometry column or pair of latitude/longitude columns.
• There must be one or more “moving objects” or entities uniquely identified by one of the columns.
• There must be a column of the type TIMESTAMP, that stores the UTC datetime of the entities as they are being observed and recorded. Alternatively, date-type columns are also supported.
• The dataset's underlying table or view must have ongoing inserts with recently obtained location data of entities being observed or monitored.

You can perform the following steps to enable spatiotemporal for a dataset. The instructions assume that the dataset containing spatiotemporal data is already existing in your database schema.

1. Navigate to the Datasets page.
2. Right-click on the spatiotemporal dataset and click Properties.
   The Dataset Properties dialog opens.
3. Click the Spatiotemporal tab.
   The tab display opens as shown:

   Figure 3-53 Enabling Spatiotemporal for a Dataset

   
   Description of "Figure 3-53 Enabling Spatiotemporal for a Dataset"
4. Switch ON Enable Spatiotemporal.
5. Select the Entity_ID Column that identifies a set of unique entities.
   The Entity_ID Column is not a unique column as each entity can have many recordings of its locations in the same table.
6. Select the Timestamp (or Date) Column.
   • Both date-type and timestamp-type columns are supported.
   • If using a timestamp-type column, then note that Spatial Studio supports only UTC (Coordinated Universal Time) or GMT (Greenwich Mean Time) time zone for visualizing moving objects.
7. Specify Data Change Rate to indicate the approximate frequency of the live feed updates in the table.
8. Optionally, select the Altitude Column for Cesium Map Visualization only.
9. Click Apply.

Your dataset is now enabled for spatiotemporal data visualization.