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.

Prerequisites

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

Task

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.

  1. Connect to your database in Interactive SQL, click Tools » Spatial Viewer.
  2. In the Spatial Viewer, execute a query similar to the following in the SQL pane and then click Execute:
    SELECT * FROM GROUPO.SpatialShapes;
  3. 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.

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