A Vector Theme Dataset is a specialized Tabular Dataset containing columnar data from an ESRI Shape File or possibly other formats in future versions. In addition to columnar data as in Tabular Datasets Vector Theme Dataset also contain geometric data or features. Features may be points, lines or polygons. The tabular dataset may contain any number of columns (fields).

ESRI Shape File and MapInfo Tab File from a File Source.

Regardless of source a vector theme dataset is defined as a SQL query containing the three usual sections: SELECT, FROM, and WHERE. The configuration dialog reflects these three sections.

SELECT
ID (Optional): Field or column name for ID.
Z (Optional): Field or column name for Z coordinates. Be sure to check the “Z = Elevation” and “Z = Depth” radio buttons. Note: If Z = Depth the Z values are converted to elevation using the designated scene terrain model surface. See Project Settings.
Additional fields (Optional): List the names of the fields that should be included in the resulting dataset. The default “*” means that all fields will be included. Warning: In joins including multiple tables this may result in a large number of fields. If this box is left blank all fields are included.

FROM
List the tables that contain the fields listed above in the SELECT box. Note: For Shape File Sources this is always the filename.

WHERE
Fixed Extent: By default the dataset extent is identical to the current scene extent. However, this option makes it is possible to fix the extent to any area.

Extent: Defines a rectangular area where data are extracted from the source.

Additional “WHERE” conditions (optional): The dataset may be refined further using SQL. This makes it possible to use regular SQL to query the source within the extent. This is an advanced option that can be used for users that has an in depth knowledge of the source format.

Preview Buttons
Preview SQL…: Shows a preview of the resulting query. Advanced users can use this option to analyze the resulting query.
Preview Data…: Shows a preview of the data resulting from the query using the Dataset Viewer.