Creating a Table
Spectrum 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.
Spectrum Spatial only supports reading GHX files for MRR. When creating Named tables for other supported Raster and GRID types in Spectrum Spatial, delete the GHX files so that Spectrum Spatial uses the original style. To have the modified style persist for use in Spectrum Spatial, convert the supported Raster or GRID to MRR.
To create a named table in Spectrum 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.
-
When creating a named table for an Oracle, PostGIS, or SQL Server
connection, there is a choice of:
- Seeing a datasource list and picking an existing database table or database view from the database or
- Entering your own database specific query.
-
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.
- If you choose to enter your own database query, enter the query into the text area. It will be validated when you try to save the named table.
-
In the Settings section:
- 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.
-
The Column Hints fields are optional and are shown when
you choose a JDBC connection. Following are the supported input fields:
- 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. Spectrum 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.