3.6.3.1 Enabling Spatial on a View-Based Dataset with Latitude and Longitude Columns

Spatial Studio allows you to create spatial index on a dataset created from a view containing latitude and longitude columns, thereby enabling you to visualize and analyze views.

The following steps enable you to create latitude/longitude index on a view-based dataset.

The instructions assume:

• You have created a dataset from a view having latitude and longitude columns.

  See Creating a Dataset from Database Tables or Views for more information on creating a dataset from a view.

• This view-based dataset is listed on the Datasets page with a warning icon since the dataset is not spatially enabled for visualization.

1. Navigate to the Datasets page.
2. Click on the warning icon to view the issues on the view-based dataset.
3. Click Create Latitude/Longitude Index.
   The Latitude and Longitude Columns window opens as shown:

   Figure 3-19 Creating a Latitude/Longitude Index on a View-Based Dataset

   
   Description of "Figure 3-19 Creating a Latitude/Longitude Index on a View-Based Dataset"
4. Select the Latitude Column.
5. Select the Longitude Column.
6. Select the Reuse lat/lon index on the base table checkbox.
   Note that irrespective of whether the spatial index on the latitude and longitude columns exists in the underlying base table (or view) or not, you must always select this checkbox. If there is no spatial index in the underlying base table (or view), Spatial Studio will simply update the dataset's metadata and mark it as ready for spatial visualization. This enables you to perform map visualizations, although it may not be as performant as when there is a spatial index in place.
7. Click OK.
   A background task of type Create lon-lat index gets executed. A successful completion of this task on the Jobs page indicates that the dataset is spatially enabled for visualization.

   You can now use this view-based dataset for visualization on the Active Project page.