The Spectrum Spatial supports spatial and non-spatial tables from a variety of data sources:
Data Source |
Spatial Table |
Non-Spatial Table |
XY Table |
---|---|---|---|
JDBC | n/a | 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 |
Snowflake Introduced 24.1: This feature is available after
version 24.1.
|
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) | |||
File Geodatabase | Read | Read | n/a |
MapInfo TAB | Read/Insert/Update/Delete1 | n/a | n/a |
Shapefile | Read | n/a | n/a |
Specialty tables include raster, grid, and seamless versions of .TAB. View tables are also supported. A view table is a subset of information from one or more data sources, including other view tables. Views are created with an MI SQL Select statement.
Spatial tables contain a geometry column that allows the table to be
rendered on a map or used in spatial queries. The spatial information can be stored in a MAPINFO_MapCatalog that Spectrum Spatial reads to understand the data
types. If a MAPINFO_MapCatalog does not exist for the database, the Spectrum Spatial will derive the data types directly from the data source.
Non-spatial tables containing columns for X and Y coordinates that represent a location
(that is, a point) can be expressed as a spatial table composed entirely of point geometries.
The metadata to represent the non-spatial table can either come from the MapCatalog or be part
of the named table definition. Named tables are explained in the Resources and Data section in
the Spectrum Technology PlatformSpectrum Spatial Guide.
The Spectrum Spatial also supports an extensible data provider API for accessing custom data sources. This can be downloaded from the Spectrum Spatial section of the Welcome page, under Sample Applications.
1 Insert, Update, Delete apply to native TAB and
extended native TAB (NativeX) files.