Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Spatial Data User's GuideThe HCL OneDB™ Spatial Data User's Guide contains information to assist you in using the HCL® OneDB® spatial extension. The HCL® OneDB® spatial extension adds custom data types and supporting routines to the server.
Introducing the IBM Informix Spatial DataBlade Module
Preparing for spatial dataBefore you load spatial data, you must prepare the database server for spatial data.
The spatial_references tableThe spatial_references table contains a spatial reference ID (SRID) for each spatial reference system.
Predefined spatial reference systemsThe spatial_references table contains over 1000 predefined spatial reference systems.

Predefined spatial reference systems

The spatial_references table contains over 1000 predefined spatial reference systems.

The following table lists the predefined spatial reference systems.

Table 1. Predefined spatial reference systems
Authority	Authority IDs (SRIDs)	Description
EPSG	2000 - 2999	Projection systems defined by the EPSG
EPSG	46008	GEOGCS NAD 1927
EPSG	4759	GEOGCS NAD 1983_NSRS2007
EPSG	4322	GEOGCS WGS 1972
EPSG	4326	GEOGCS WGS 1984
EPSG	4760	GEOGCS WGS 1966
EPSG	32601 - 23760	WGS 1984 UTM Zones
ESRI	54001 - 54004 54008 - 54019 54021 - 54032 54034 54042 - 54046 54048 - 54053	Various world projection systems

The false origin and scale values for the system are derived from the Projected Bounds of the underlying Coordinate System. For example, EPSG 2193 (NZGD_2000_New_Zealand_Transverse_Mercator) derives the falsex, falsey and xyunits values based on the extent of the projection system:

falsex = -6020520.00000
falsey = -1997720.00000
xyunits = 375371289.4930

The z and m coordinates for all predefined spatial reference systems have the following values in the following columns:

falsez = -50000.0
zunits = 1000.0
falsem = -1000.0
munits = 1000.0