[teiid-issues] [JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table
[
https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin...
]
Tom Arnold commented on TEIID-3300:
-----------------------------------
Steve, how can I lookup values from this table in a system function? I'm trying to do
something like this...
{code}
public static GeometryType transform(GeometryType geom, int srid) {
String srcParams = lookup('spatial_ref_sys',
'proj4text','srid', getSrid(geom));
String tgtParams = lookup('spatial_ref_sys',
'proj4text','srid', srid);
return transform(geom, srcParams, tgtParams);
}
{code}
Add SPATIAL_REF_SYS table
-------------------------
Key: TEIID-3300
URL: https://issues.jboss.org/browse/TEIID-3300
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Tom Arnold
Assignee: Steven Hawkins
Labels: spatial
Fix For: 8.10
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)