How to create st_geomtery layer in Teradata database.

Document created by MLather-esristaff on Feb 22, 2017
Version 1Show Document
  • View in full screen mode

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"

1 person found this helpful

Attachments

    Outcomes