Spatial Manager allows you to create a named table for a file-based
(TAB and shapefile) or JDBC database datasource. These instructions explain how to
create a single, non-spatial named table or one with a datasource that has a spatial
column.
To create a named table in Spatial Manager:
-
From the Create drop-down located in the toolbar, select
Table.
Note: This is disabled if you do not have sufficient permissions.
The Create Table page appears.
-
In the Choose a Datasource section, select a connection
from the Connection list.
Information about the connection appears to the right, including its
location in the repository, and its source folder (where the data it points to
is located) for a file-based connection or its URL for a JDBC database
connection.
-
From the Datasource list, select the source of the data
for the named table.
Note: You can only select a GeoPackage table as a datasource if you are running
Spectrum Spatial on Windows or Linux (CentOS).
Information about the datasource appears to the right.
-
Decide whether to change the Volatile flag or use the default.
The Volatile flag is set to True by default. This setting is appropriate for
data sources that are frequently updated. Spectrum Spatial checks with the
data source to see if the table schema can change, and if so, empties the
cache and reloads the table, although at some expense to performance. Change
the Volatile setting to False for tables that you know are not going to
change over time or change infrequently. A setting of False aids in data
access performance, especially for batch operations such as map tile
generation. See Data Source Volatility for more
information.
-
If you selected a shapefile as a datasource, the Additional
Info section appears. Character Set and Coordinate System are
required fields. The Character Set field is populated with the value read from
the shapefile's .dbf or .cpg file. If the shapefile does not have a character
set, then the field defaults to a character set of ISO-8859-1. The Coordinate
System field is populated with the value from the shapefile's .prj file. If the
coordinate system is missing or cannot be understood, then the field defaults to
a coordinate system of epsg:4326. By default, Spectrum Spatial creates a spatial
index for your shapefile to improve performance of spatial queries. Disable this
setting if you are concerned about performance loss due to the initial creation
of the spatial index file.
-
In the Repository Info section, the New Table
Name field uses the name of the chosen datasource as the default.
You can accept the default name or change it. Spatial Manager
will warn you if another named table exists with that name. Names are case sensitive and cannot contain
the following characters: / \ : [ ] | * { } "
-
The Repository Folder field defaults to the location you
were at in the repository when you selected . You can accept the default path or change it.
-
Click Create.
The details page for the new named table appears.