[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:comment-tabpanel&focusedCommentId=13038200#comment-13038200 ] 

Tom Arnold commented on TEIID-3301:
-----------------------------------

Could we do blob concatenation in all cases to return SRID 32bit int + WKB? I've only tried it on MySQL so far but it seems like it should work on the others as well. For example:
{code}
select shape from cola_markets;

select ST_AsTeiidFormat(shape) from cola_markets;

select CONCAT(RPAD(REVERSE(CHAR(SRID(shape))), 4, CHAR(0)), AsWKB(shape)) from cola_markets;
{code}

{quote}
It does directly support the srid / three dimensional aspects of ewkb, which would be useful for reading values from postgis.
{quote}
I've been intentionally avoiding 3d so far because it seems to be poorly supported. For example, newer versions of WKT support 3d in a way that is incompatible with EWKT. JTS IO classes support 3d but last time I played with them they would drop the Z coordinate when writing WKT.

> 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
>             Fix For: 8.10
>
>
> 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)