[ https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3300: ------------------------------ Description: Implement SPATIAL_REF_SYS table (from the OGC Simple Features spec). This table stores metadata about different coordinate systems and how to tranform between them. See [here|http://en.wikipedia.org/wiki/SRID] and [here|trac.osgeo.org/proj4j/] for details. {code} CREATE TABLE SPATIAL_REF_SYS ( SRID INTEGER NOT NULL PRIMARY KEY, AUTH_NAME CHARACTER VARYING(256), AUTH_SRID INTEGER, SRTEXT CHARACTER VARYING(2048) ) {code} https://raw.githubusercontent.com/postgis/postgis/svn-trunk/spatial_ref_s... This would be used in conjunction with the GeoTools referencing module or Proj4J to transform between coordinate systems in Teiid (ST_Transform function). was: Implement SPATIAL_REF_SYS table (from the OGC Simple Features spec). This table stores metadata about different coordinate systems and how to tranform between them. See [here|http://en.wikipedia.org/wiki/SRID] for details. {code} CREATE TABLE SPATIAL_REF_SYS ( SRID INTEGER NOT NULL PRIMARY KEY, AUTH_NAME CHARACTER VARYING(256), AUTH_SRID INTEGER, SRTEXT CHARACTER VARYING(2048) ) {code} https://raw.githubusercontent.com/postgis/postgis/svn-trunk/spatial_ref_s... This would be used in conjunction with the GeoTools referencing module or Proj4J to transform between coordinate systems in Teiid (ST_Transform function). -- This message was sent by Atlassian JIRA (v6.3.11#6341)