Named Tables

Location Intelligence Module stages, services, and operations require named tables to access various types of data. Named tables are resources that reference data in various formats (see table below). This section describes how to add Location Intelligence Module named table resources. Named tables are stored in the Spectrum Spatial repository, and can be used by all spatial services.

For each type of supported data sources we support three types of tables: Spatial (table with Geometry column), XY (table with X and Y columns), and Non-Spatial (table without geometry column and no column hints specified that reference X and Y columns). Each of these types of tables are supported using a different data provider resulting in a different type of named table. When creating named tables you must specify the correct type. This is important for operations such as inserting, updating, or reading data to and from a table. The following table outlines the supported data sources and the type of table required for read and insert operations:

Table 1. Supported Data Sources

Data Source

Spatial Table

Non-Spatial Table

XY Table

JDBC n/a Read/Insert/Update/Delete Read/Insert/Update/Delete
SAP HANA Read/Insert/Update/Delete Read/Insert/Update/Delete Read/Insert/Update/Delete
Oracle Read/Insert/Update/Delete Read/Insert/Update/Delete Read/Insert/Update/Delete
MS SQL Server Read/Insert/Update/Delete Read/Insert/Update/Delete Read/Insert/Update/Delete
PostGreSQL/PostGIS Read/Insert/Update/Delete Read/Insert/Update/Delete Read/Insert/Update/Delete
GeoPackage Read/Insert/Update/Delete Read/Insert/Update/Delete n/a
View Read Read Read
Table Formats (file-based data sources)      
Shapefile Read n/a n/a
MapInfo TAB Read/Insert/Update/Delete1 n/a n/a
1 Insert, Update, Delete apply to native TAB and extended native TAB (NativeX) files on Windows operating systems only.