How to create st_geomtery layer in Teradata database.

1439
0
02-22-2017 10:54 AM

How to create st_geomtery layer in Teradata database.

Use the following SQL statement:

CREATE TABLE test (OBJECTID INTEGER NOT NULL PRIMARY KEY, shape ST_GEOMETRY);

insert into test values (1, NEW ST_GEOMETRY('ST_POINT', -73.960257, 40.768823, 1619));

insert into test values (2, NEW ST_GEOMETRY('ST_POINT', -78.960257, 40.768823, 1619));

insert into test values (3, NEW ST_GEOMETRY('ST_POINT', -83.960257, 40.768823, 1619));

insert into test values (4, NEW ST_GEOMETRY('ST_POINT', -33.960257, 40.768823, 1619));

>> If we will create the table without specifying the SRID (1619) following error will be encountered :

      "error opening feature class. Spatial reference entry does not exist"

Version history
Last update:
‎02-22-2017 10:54 AM
Updated by:
Contributors