IBM® Informix® 12.10

What's new in spatial data for IBM Informix, Version 12.10

This publication includes information about new features and changes in existing functionality.

The following changes and enhancements are relevant to this publication. For a complete list of what's new in this release, go to What's new in Informix®.

Table 1. What's new for the IBM Informix Spatial Data User's Guide for 12.10.xC7
Overview Reference
Convert spatial data to GeoJSON format

You can now display spatial data in JSON-based applications by converting a geometry to a BSON document in GeoJSON format. Run the SE_AsBSON function on a geometry to return a BSON document.

The SE_AsBSON() function
Table 2. What's new for the IBM Informix Spatial Data User's Guide for 12.10.xC3
Overview Reference
Enhancements for handling spatial data

You can transform spatial data between spatial reference systems that are in different geographic coordinate systems. Previously, you transformed data only within the same geographic coordinate system.

You can choose from many more predefined spatial reference systems instead of defining most of the systems that you need.

You can calculate the distance and area for data that is based on the round-Earth model. If your geometries have a spatial reference system that is based on angular units, you can calculate distance and area in meaningful linear units. Specify the appropriate unit of measure to convert angular units to linear units in the ST_Area, ST_Buffer, ST_Distance, ST_Length, and ST_Perimeter functions. You can specify predefined units of measure or define your own units of measure. The SE_Nearest function calculates distance between geometries that are in geographic coordinate systems by applying the linear unit of measure of meters.

Informix spatial data types now conform to the OpenGIS Simple Features Specification for SQL Revision 1.1 and the ISO/IEC 13249-3 SQL/MM Part 3: Spatial. The Informix spatial solution is based on the ESRI SDE 10.2 Shape and PE libraries.

The ST_Transform() function

The spatial_references table

Units of measure

The SE_Nearest() and SE_NearestBbox() functions


Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.