[teiid-issues] [JBoss JIRA] (TEIID-3301) Add GEOMETRY_COLUMNS view

[Tom Arnold (JIRA)]

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

Tom Arnold updated TEIID-3301:
------------------------------
    Description: 
Another OGC Simple Features implementation detail. Basically this is like a specialized version of SYS.COLUMNS, and would be used to support GIS software (like GeoServer).

http://www.carocoops.org/resources/doc/postgis/x321.html
{code}
  CREATE TABLE GEOMETRY_COLUMNS ( 
    F_TABLE_CATALOG VARCHAR(256) NOT NULL, 
    F_TABLE_SCHEMA VARCHAR(256) NOT NULL, 
    F_TABLE_NAME VARCHAR(256) NOT NULL, 
    F_GEOMETRY_COLUMN VARCHAR(256) NOT NULL,
    COORD_DIMENSION INTEGER NOT NULL, 
    SRID INTEGER NOT NULL, 
    TYPE VARCHAR(30) NOT NULL 
  )
{code}

I think we could implement this by storing SRID & friends as column properties, and then creating a view on SYS.COLUMNS & SYS.PROPERTIES.

  was:
Another OGC Simple Features implementation detail. Basically this is like a specialized version of SYS.COLUMNS, and would be used to support GIS software (like GeoServer).

http://spatialdbadvisor.com/oracle_spatial_tips_tricks/148/geometry_columns-for-oracle-spatial
{code}
CREATE TABLE GEOMETRY_COLUMNS (
  F_TABLE_CATALOG   CHARACTER VARYING NOT NULL,
  F_TABLE_SCHEMA    CHARACTER VARYING NOT NULL,
  F_TABLE_NAME      CHARACTER VARYING NOT NULL,
  F_GEOMETRY_COLUMN CHARACTER VARYING NOT NULL,
  G_TABLE_CATALOG   CHARACTER VARYING NOT NULL,
  G_TABLE_SCHEMA    CHARACTER VARYING NOT NULL,
  G_TABLE_NAME      CHARACTER VARYING NOT NULL,
  STORAGE_TYPE      INTEGER,
  GEOMETRY_TYPE     INTEGER,
  COORD_DIMENSION   INTEGER,
  MAX_PPR           INTEGER,
  SRID              INTEGER NOT NULL
  REFERENCES SPATIAL_REF_SYS,
  CONSTRAINT GC_PK PRIMARY KEY
   (F_TABLE_CATALOG, F_TABLE_SCHEMA, 
    F_TABLE_NAME, F_GEOMETRY_COLUMN)
)
{code}

I think we could implement this by storing SRID & friends as column properties, and then creating a view on SYS.COLUMNS & SYS.PROPERTIES.



> Add GEOMETRY_COLUMNS view
> -------------------------
>
>                 Key: TEIID-3301
>                 URL: https://issues.jboss.org/browse/TEIID-3301
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>              Labels: spatial
>
> Another OGC Simple Features implementation detail. Basically this is like a specialized version of SYS.COLUMNS, and would be used to support GIS software (like GeoServer).
> http://www.carocoops.org/resources/doc/postgis/x321.html
> {code}
>   CREATE TABLE GEOMETRY_COLUMNS ( 
>     F_TABLE_CATALOG VARCHAR(256) NOT NULL, 
>     F_TABLE_SCHEMA VARCHAR(256) NOT NULL, 
>     F_TABLE_NAME VARCHAR(256) NOT NULL, 
>     F_GEOMETRY_COLUMN VARCHAR(256) NOT NULL,
>     COORD_DIMENSION INTEGER NOT NULL, 
>     SRID INTEGER NOT NULL, 
>     TYPE VARCHAR(30) NOT NULL 
>   )
> {code}
> I think we could implement this by storing SRID & friends as column properties, and then creating a view on SYS.COLUMNS & SYS.PROPERTIES.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)