The SE_CreateSrtextList() function

The SE_CreateSrtextList() function returns the OGC well-known text representation of every spatial reference system that uses the specified ESRI Projection Engine ID number. The text for each spatial reference system is separated by a new line character.

If the specified ID number is used by a single spatial reference system, the SE_CreateSrtextList() function returns the same text as the SE_CreateSrtext() function. The ID numbers are in the file pedef.h, in the directory $ONEDB_HOME/extend/spatial.version/include.

Syntax

SE_CreateSrtextList (factory_id int)

Return type

LVARCHAR

Example

To return the spatial reference system text for the ID 5109:

EXECUTE FUNCTION SE_CreateSrtextList(5109);


(expression)  PROJCS["ETRS_1989_NTM_Zone_9",GEOGCS["GCS_ETRS_1989",DATUM["D_ETR
              S_1989",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Gre
              enwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Trans
              verse_Mercator"],PARAMETER["False_Easting",100000.0],PARAMETER["F
              alse_Northing",1000000.0],PARAMETER["Central_Meridian",9.5],PARAM
              ETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",58.0],UNI
              T["Meter",1.0]]
              VDATUM["Normaal_Amsterdams_Peil"]

1 row(s) retrieved.

The ID 5109 has two spatial reference system types: a Projected Coordinate System and a vertical datum.