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

Permissions to select from the table containing the spatial data.

Context and remarks

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)

  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 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.

Results

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

Next

None.

Example

  1. Connect to the sample database from Interactive SQL.

  2. Click Tools » Spatial Viewer.

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

    SELECT * FROM SpatialShapes;
    Set of colored polygons and lines displayed in the Spatial Viewer

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

    Set of polygon outlines and lines displayed in the Spatial Viewer.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1