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-19 Warnings on a Dataset

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