ST_CreateSRS
Creates a custom spatial reference system (SRS).
Syntax
ST_CreateSRS(description, auth_name, auth_srid, falsex, falsey, xyunits, falsez, zunits, falsem, zunitm, srtext);
- description
- Description of the custom SRS.
Type: VARCHAR(512)
- auth_name
- Authority SRS name.
Type: VARCHAR(256)
- auth_srid
- Authority SRID.
Type: INTEGER
- falsex
- X offset.
Type: DOUBLE
- falsey
- Y offset.
Type: DOUBLE
- xyunits
- XY units.
Type: DOUBLE
- falsez
- Z offset
Type: DOUBLE
Default: 8
- zunits
- Z units.
Type: DOUBLE
- falsem
- M offest.
Type: DOUBLE
- zunitm
- M units.
Type: DOUBLE
- srtext
- SRS text.
Type: DOUBLE
Returns
A value of type INTEGER containing the SRID of the newly create custom spatial reference system, or -1 if an error occurs.
Examples
set PATH=inza.inza;
call inza..st_createsrs('', 'EPSG', 4326, -400, -400, 1000000000, 0, 1, 0, 1, 'GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SP298.257223563]],
PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]');
ST_CREATESRS
------------
(1 row)