1. Guide
  2. Using Oracle Spatial Studio
  3. Spatial Studio Datasets Page
  4. Datasets with Issues

3.6.3 Datasets with Issues

All datasets in Spatial Studio must meet certain data requirements in order to be used for map visualization and analysis.

Otherwise, Spatial Studio highlights these datasets with a warning on the Datasets page.

You may click on the warning icon to view the issues. You can then click on the resolution link under the issue to prepare the dataset as required for analysis, as shown:

Figure 3-31 Warnings on a Dataset

Description of Figure 3-31 follows
Description of "Figure 3-31 Warnings on a Dataset"
The following table lists a few common issues that are highlighted on a dataset.

Table 3-2 Selected List of Dataset Issues

Issue Cause Spatial Studio Resolution
No key column was found Primary key is missing on the dataset.
  • Click Go to Dataset Columns to create a dataset key.

    The Dataset Properties configuration window opens.

  • Select a column containing unique values and switch ON Use as Key.
  • Click Validate key.
  • Click Apply.
This dataset needs spatial metadata and index The geometry column in the dataset does not have the spatial metadata or a spatial index or both. Click Create Spatial Metadata and Index to create the spatial metadata and index for the geometry column.
Preparation Required for mapping and spatial analysis It can be due to one of the following reasons:
  • The dataset contains address information but the geographic coordinates are missing.
  • Latitude and Longitude index are missing for latitude/longitude data in the dataset.
 Depending on the cause, you may need to perform one of the following:
  • Click Geocode Addresses
  • Click Create Latitude/Longitude Index

Parent topic: Spatial Studio Datasets Page

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-32 Creating a Latitude/Longitude Index on a View-Based Dataset

    Description of Figure 3-32 follows
    Description of "Figure 3-32 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.

Parent topic: Datasets with Issues