[teiid-issues] [JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table
Tom Arnold (JIRA)
issues at jboss.org
Sat Jan 24 01:40:49 EST 2015
Tom Arnold created TEIID-3300:
---------------------------------
Summary: Add SPATIAL_REF_SYS table
Key: TEIID-3300
URL: https://issues.jboss.org/browse/TEIID-3300
Project: Teiid
Issue Type: Feature Request
Reporter: Tom Arnold
Assignee: Steven Hawkins
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_sys.sql
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)
More information about the teiid-issues
mailing list