ST_SRID |
|
Release 9.3 |
sde.st_srid(g1 st_geometry)
st_srid (g1 st_geometry)
CREATE TABLE srid_test (g1 sde.st_geometry);
CREATE TABLE srid_test (g1 st_geometry);
NOTE: If you want to use an actual SRID value, either use one of your existing SRIDs and alter the coordinates to fit, or insert the spatial references given at the end of this example and run this example with the SRID you assign for it.
OracleINSERT INTO srid_test VALUES (
sde.st_pointfromtext ('point (10.01 50.76)', 0)
);
INSERT INTO srid_test VALUES (
st_point ('point (10.01 50.76)', 0)
);
SELECT sde.st_srid (g1) SRID_G1
FROM srid_test;
SRID_G1
0
SELECT st_srid (g1) AS SRID_G1
FROM srid_test;
srid_g1
0
INSERT INTO SDE.ST_SPATIAL_REFERENCES VALUES (
'GCS_North_American_1983',
{1 | <next srid>},
-400,
-400,
1000000000,
-100000,
10000,
-100000,
10000,
9.999E35,
-9.999E35,
9.999E35,
-9.999E35,
9.999E35,
-9.999E35,
9.999E35,
-9.999E35,
4269,
'GCS_North_American_1983',
'PROJECTED',
NULL,
NULL,
'GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]',
'ArcSDE SpRef'
);
INSERT INTO st_spatial_references VALUES (
'GCS_North_American_1983',
{1 | <next srid>},
-400,
-400,
1000000000,
-100000,
10000,
-100000,
10000,
9.999E35,
-9.999E35,
9.999E35,
-9.999E35,
9.999E35,
-9.999E35,
9.999E35,
-9.999E35,
4269,
'GCS_North_American_1983',
'PROJECTED',
NULL,
NULL,
'GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]',
'ArcSDE SpRef'
);