Inventory of resources supplied for your database

Db2® Spatial Extender provides the database with several resources to enable it for support of spatial operations.

These resources are:
  • Stored procedures. Spatial operations such as commands to import spatial data, invoke one of these stored procedures to perform the operation.
  • Spatial data types. You must assign a spatial data type to each table or view column that is to contain spatial data.
  • Db2 Spatial Extender catalog. Certain operations depend on this catalog. For example, before you can access a spatial column from the visualization tools, the tool might require that the spatial column be registered in the catalog.
  • A spatial grid index. You can define grid indexes on spatial columns.
  • Spatial functions. You use these to work with spatial data in a number of ways such as determining relationships between geometries and to generate more spatial data.
  • Definitions of coordinate systems.
  • Default spatial reference systems.
  • Two schemas: DB2GSE and ST_INFORMTN_SCHEMA. DB2GSE contains the objects just listed: stored procedures, spatial data types, the Db2 Spatial Extender catalog, and so on. Views in the catalog are available also in ST_INFORMTN_SCHEMA to conform with the SQL/MM standard..