Products Solutions Training
Resources About Galilee Contact Us

Galilee Enterprise, 4733 Tompkins Ave., Oakland, CA  94619  Phone: (510) 530-5550  Fax: (510) 531-4207   Email:

MapInfo SpatialWare® Features:

Multi-Platform Support - Support for Sun Solaris, Windows NT or 2000, and HP-UX.

Flexible Data Loading & Data Interchange - Adding ASCII data is a simple matter of formatting the data with standard SQL commands. No special converters are required. SpatialWare® also easily loads MapInfo tables (.tab) files through Easy Loader. 

MapInfo Professional® has a Universal Translator utility to convert files into .tab format. It translates bi-directionally between MapInfo Professional and other mapping environments including AutoCAD, ESRI and Intergraph. Formats include DWG, DXF, DGN, and Shape. Government formats supported in v6.0 include VPF and SDTS. The ESRI E00 format is supported by ArcLink, and the Atlas GIS native format is supported by AG*Link, both separate utilities are also included with MapInfo Professional.  Once in .tab format, files can easily be loaded into SpatialWare®.

Powerful Standard SQL for Data Access - Uses standard SQL commands to create, update, insert, delete, and select spatial objects in a table. Standard SQL makes adapting to spatial information applications easier, leveraging existing expertise and overall investment. 

Meets 'ACID' Test - Meets the database community ACID test for:

  • Atomicity - Commits all or nothing, essential for data integrity
  • Consistency - Consistency rules to allow system validation
  • Isolation - Data is not available to others until it commits and is in a consistent state
  • Durability - When data commits it is preserved with hardware or software features

Object Storage - Stores all data as objects, and includes, but is not restricted to the following geometry types: points, polylines, curves, circular arcs, and polygons.

150 Functions in Six Categories - SpatialWare® has over 150 functions that allow you to analyze and manipulate spatial data. They are grouped into six categories:

  • Spatial Predicates - analyze spatial data types to see if they meet specific conditions. A true or false is returned. 'Overlaps' and 'Contains' are examples of predicates.
  • Spatial Measurements - return number values that describe a spatial data type's shape, size, angle, rotation, or position. Examples include 'Length,' 'Perimeter,' and 'Height.' Includes both cartesian and spherical coordinate systems.
  • Spatial Functions - perform operations on spatial data types and return a spatial data type. For example, 'Union' joins two spatial data types and returns the combined result as a new spatial object.
  • Constructor Functions - create new spatial objects. For example, 'Circle' is a spatial data type using a point and radius to create the circle.
  • Observer Functions - return numbers, objects, or conditions from within a spatial object. 'Assemble' and 'Radius' are examples of Observer Functions.

Multiple Client Support - Data stored in SpatialWare® can be easily visualized using MapInfo Professional. (click to enlarge) 
Supports MapInfo clients including MapInfo Professional®, desktop mapping software; MapInfo MapX®, an OCX component, allows you to integrate a mapping object into new a pre-existing business applications; and MapInfo® MapXtreme® NT or Java editions, a mapping application server to add interactive maps to your web site. 

Overlap Function Example - Can be used in a 'Click before you dig application.' SpatialWare® can execute the query to determine if a property boundary overlaps a gas main. Another example would be a cellular coverage application. The overlap operator can be used to determine if a coverage polygon overlaps a customer's home. Below is a diagram of what SpatialWare® would return when executing an overlap query.

Buffer Function Example - Takes a geometry, buffer distance, and filter tolerance. The filter parameter specifies a filter tolerance on the buffer creation process. Returns a new 'expanded' geometry. This operator is good for radial searches.

Convex-Hull Function Example - Returns the minimum boundary around a spatial object without the boundary being concave. The result is the spatial object representing the convex hull of the perimeter.

- MapInfo SpatialWare® -

The information management tool for storing, managing and manipulating location-based data.

MapInfo SpatialWare® data management software enables businesses to store, manage, and manipulate location-based, or spatial, data within an Relational Database Management System (RDBMS). This data includes a variety of non-traditional data types, such as digital representations of highways, fiber-optic lines, sales territories or land parcels - each with a physical component. SpatialWare®, allows spatial data to be stored in the same place as traditional data, ensuring data accessibility, integrity, reliability and security.

MapInfo SpatialWare®, offers more than 150 spatial functions - and the richest set of functionality in its class - and is ideal for:

  • Cost-effective, centralized storage and management of location-based data

  • Universal accessibility (of otherwise inaccessible) location-based data

  • Large-scale deployment of powerful GIS functions and mapping applications - aligns with ISO SQL-1999 and ISO SQL/MM standards and widely used IT data storage and management practices

  • High levels of security, back-up and integrity for valuable location-based data

  • Bringing the analytical power and speed of RDBMS to location-based SQL queries

- Architecture -


® can be implemented in a two tier or three tier architecture. Two tier architecture refers to systems that are divided into two parts, the client and the server. Usually the client and server are connected to and communicate across a network. The three tier architecture consists of a client, a server/client, and a server. The top tier handles user interface and data presentation issues. The middle server/client tier is dedicated to application processing, and the bottom tier is dedicated to data management. This allows the application processing to either be shared between the client and the server machines, or to be performed on some intermediate platform, often called the 'application server'. This application server would perform the bulk of the data analysis and thus lessen the network traffic. The number of actual machines involved is typically three, but a two machine configuration is possible. 

In the two tier scenario, the SpatialWare
® server acts as a data server and spatial processing server to MapInfo clients communicating through the SpatialWare® ODBC driver. A three tier approach could leave the spatial processing and data on one machine, but place applications using any of the SpatialWare® interfaces (ODBC or C-API) on a middle tier that would then interact with the end users. SpatialWare® and MapInfo products offer several choices so that any of the configurations described above can be accommodated. An example of a three tier implementation would be: SpatialWare® as the data server and spatial processing server, MapInfo Professional as the client making spatial queries to the SpatialWare® Server, and MapXtreme® as a web client generating maps from the results of the spatial queries. SpatialWare® fully integrates with MapInfo Professional as a desktop client. This environment provides a complete and advanced set of capabilities to visualize and perform spatial analysis. 

Other MapInfo products can also be used with SpatialWare
® as desktop clients such as MapMarker®, MapX®, and MapXtreme® MapBasic® and its ability to interface with SpatialWare® also provides a way for sophisticated users and developers to build customized and tailored applications.

SpatialWare® for Microsoft SQL Server

® for SQL Server is made up of three main components: 

Spatial Data Type - SpatialWare
® supports a spatial data type called ST_Spatial, which is a SQL Server user-defined datatype, to store geometry data within tables of a database. Database management systems such as SQL Server support data types such as integer, float and character to support scalar data. There is a need for a more complex data type designed to store spatial information. SpatialWare® provides the storage mechanism and necessary functionality to store, retrieve and analyze the contents of the data type. SpatialWare® also allows this type to be 'cast' to useful derivative types for use by client software. The geometries stored in this data type can either be two dimensional or three dimensional. The datatype and the SQL functions are based on ISO SQL/Multimedia standards and OpenGIS Consortium standards. In order to perform useful operations on a column of type ST_Spatial, the column must be 'spatialized' using a SpatialWare® stored procedure. 

Spatial Indexing - Spatial Indexing is mandatory when spatial data is being searched. A sequential scan of spatial data is typically very expensive since the geometry information stored is normally quite complex, and tables can have large members of rows. SpatialWare
® implements a special indexing scheme based on R-Trees, that is specifically designed to index multidimensional (geometry) data. It is very well suited to the distribution patterns typical for spatial data. The implementation is specially tuned so that no knowledge of that data (or likely future extent, volume or distribution of the data) is required to achieve optimum performance. A spatial index is created on a column of type ST_Spatial using a SpatialWare® stored procedure. SpatialWare® maintains the index through database triggers when the geometries in the indexed column change as a result of an INSERT, UPDATE or DELETE operation. 

Spatial Functions - SpatialWare
® contains over 150 spatial functions and predicates. These are extensions to the SQL language, to retrieve data from tables with the ability to compute new geometric values or qualify data based upon geometric relationships. A query which uses spatial functions and predicates is presented to SQL Server via a SpatialWare® stored procedure. A query, which uses Spatial functions and predicates, is presented to SQL Server via a SpatialWare® stored procedure. The query extensions can be logically grouped into the following:

Function Type Description
Constructor Function Create geometry from a string using the ST_Spatial function.
Measurement Functions Perform calculations on geometries to find a measurable characteristic, such as length, or area.
Observer Functions Return numbers, objects, or attributes from within a geometry. (e.g., X ordinate of a point, Nth Vertex of a polyline.)
Coordinate Transformation Functions Transform geometries from one coordinate system to another. Coordinate systems may be geographic (longitude/latitude), or projected (e.g., Mercator, Robinson).
Spatial Functions Perform operations on geometries to create new geometries. (e.g., create a buffer zone around a road (linear) geometry.)
Spatial Predicates Analyze geometries or pairs of geometries to see if they meet specific conditions. These functions return TRUE or FALSE (1 or 0) values and are generally used within a WHERE clause. (e.g., find overlapping geometries.)
SpatialWare® for Informix

For Informix, SpatialWare® is implemented as a DataBlade and client products. The SpatialWare® DataBlade provides comprehensive object relational implementation of geospatial database management system. It fully leverages and is compliant with IDS DataBlade technology. The SpatialWare® DataBlade plugs into the INFORMIX-Dynamic Server.2000 (IDS) to natively manage spatial data. This provides powerful spatial analysis capabilities, and also optimizes the performance of your database. SpatialWare® products are the applications and utilities that access the database.

System Requirements:

Microsoft SQL Server:

- SQL Server 2000 
- Microsoft Windows 2000/XP/Vista/7
- System administration & database privileges for setting up the database environment 
- Internet browser to access documentation 
- CD recommended on server for installation

DataBlade for Informix 9.3 Databases System Requirements: 

- Informix Dynamic Server with the Universal Data Option Version 9.3
- Sun Solaris 2.8, HP/UX 11.0 Operating System
- TCP/IP Network
- CD recommended on server for installation
- Graphics display recommended on server
- Informix Dynamic Server with Universal Data Option 
- System administration & database privileges for setting up the Informix environment
- An Internet browser & access for documentation
- E-mail account to obtain a license file

Call Galilee at (510) 530-5550
for pricing information on
Products and Services

Contact with comments or questions regarding this site. 
© Copyright 2004, Galilee Enterprise, All rights reserved.