Viewing spatial data as images (Spatial Viewer)

You can view multiple geometries as an image to understand what the data in the database represents using the Spatial Viewer.

Prérequis

You must have SELECT privilege on the table you are selecting from, or the SELECT ANY TABLE system privilege.

Contexte et remarques

The order of rows in a result matter to how the image appears in the Spatial Viewer because the image is drawn in the order in which the rows are processed, with the most recent appearing on the top. Shapes that occur later in a result set can obscure ones that occur earlier in the result set.

View spatial data as images (Spatial Viewer)

Connect to your database in Interactive SQL, click Tools » Spatial Viewer.
In the Spatial Viewer, execute a query similar to the following in the SQL pane and then click Execute:
SELECT * FROM GROUPO.SpatialShapes;
Use the Draw Outlined Polygons tool to remove the coloring from the polygons in a drawing to reveal the outline of all shapes. This tool is located beneath the image, near the controls for saving, zooming, and panning.

Résultat

All of the geometries in the result set are displayed in the Results area as one image.

Suivant

None.

Exemple

Connect to the sample database from Interactive SQL.
Click Tools » Spatial Viewer.

In the Spatial Viewer, execute the following query in the SQL pane:

SELECT * FROM GROUPO.SpatialShapes;

Set of colored polygons and lines displayed in the Spatial Viewer

Here is an example of how the image appears as outlines using the Draw Outlined Polygons tool:

Discuter à propos de cette page dans DocCommentXchange.