analytics/informix/extend/spatial.8.22.FC2/examples/sql/se_createsrid.sql

-- This example demonstrates how to use the SE_CreateSrid function
-- to create a new entry in the spatial_references table, given
-- the XY extent of a spatial data set.


EXECUTE FUNCTION SE_CreateSrid (166, -48, 180, -34,
                                "New Zealand: lat/lon coords");


-- SE_CreateSrid will return the srid of the newly created
-- spatial_references table entry.  It uses the formula:
--       new_srid = MAX(srid) + 1
-- to choose a new srid.  Depending on what other srids are already
-- present in the spatial_references table, you may need to adjust
-- the following query slightly to inspect the new entry:

SELECT * FROM spatial_references WHERE srid = 1001;