Creating a Table

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.
Note: To create other types of named tables, see Creating a View Table or Creating an XY Table. To create a batch of named tables that share a common connection, see Creating Multiple Tables.

To create a named table in Spatial Manager:

  1. 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.
  2. 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.
  3. 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.
  4. In the Settings section:
    1. Choose whether to change the Volatile flag or use the default.

      The Volatile flag is enabled 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. Disable the Volatile setting only for tables that you know are not going to change over time or change infrequently. Disabling volatility aids in data access performance, especially for batch operations such as map tile generation. See Data Source Volatility for more information.

    2. Choose whether to set the table to be read-only. This is applicable only to MapInfo native TAB and extended native TAB (NativeX) files in a Windows operating system. For more information, see MapInfo Native TAB.
    3. Choose whether to enable spatial aggregation (applicable only to MS SQL Server data sources). For more information, see Support for Spatial Aggregation.
  5. 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.
  6. 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: / \ : [ ] | * { } "
  7. The Repository Folder field defaults to the location you were at in the repository when you selected Create > Table. You can accept the default path or change it.
  8. Click Create.
    The details page for the new named table appears.