[
https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin...
]
Tom Arnold edited comment on TEIID-3300 at 1/26/15 8:42 PM:
------------------------------------------------------------
I'd appreciate it if you could get it started; I won't be able to spend much time
on this (aside from reading issues) until the weekend.
Couple misc notes:
* Need to add PROJ4TEXT (from PostGIS inserts) to the table def. Isn't part of the
spec, but that column contains the parameters for the Proj4 library (which is my first
choice for ST_Transform / TEIID-3302).
* Need to be able to get access to this table in several places (e.g., system function for
ST_Transform).
was (Author: tom9729):
I'd appreciate it if you could get it started; I won't be able to spend much time
on this (aside from reading issues) until the weekend.
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
Labels: spatial
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|http://www.carocoops.org/resources/doc/postgis/x321.html] 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)