[
https://issues.jboss.org/browse/TEIID-3301?page=com.atlassian.jira.plugin...
]
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)