[teiid-issues] [JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table

Tom Arnold (JIRA) issues at jboss.org
Sat Jan 24 02:17:48 EST 2015


     [ https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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_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).

  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_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).



> 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|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_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