[teiid-issues] [JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table
Steven Hawkins (JIRA)
issues at jboss.org
Mon Feb 23 15:31:49 EST 2015
[ https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13042996#comment-13042996 ]
Steven Hawkins edited comment on TEIID-3300 at 2/23/15 3:31 PM:
----------------------------------------------------------------
lookup is routed to the ProcessorDataManager, so it only has a stub function method. Also since it's materialized with a primary key it's effectively redundant to use lookup.
You could use the internal Connection that is provided by CommandContext - add the CommandContext as the first function parameter and use CommandContext.getConnection to execute the equivalent prepared statements.
was (Author: shawkins):
lookup is routed to the ProcessorDataManager, so it only has a stub function method. Also since it's materialized with a primary key it's effectively redundant to use lookup.
You could use the internal Connection that is provided by CommandContext - add the CommandContext as the first paremeter and used CommandContext.getConnection to execute the equivalent prepared statements.
> 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_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