[
https://issues.jboss.org/browse/TEIID-3301?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3301:
---------------------------------------
JTS IO classes support 3d but last time I played with them they would
drop the Z coordinate when writing WKT.
Yes I've added a doc note and a check in GeomtryUtils.getGeometry to say that this
implementation is effectively 2d.
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.
As far as I know that could work for mysql/postgresql, but I'm not sure about oracle.
However if there is much overhead for mysql, I would just rely on the internal storage
format rather than a similar function based conversion. Also if the geometry value is
being computed by a function/expression, the resulting sql could take a performance hit as
the expression will be repeated. Which is why it seems simpler to stick with the ewkb
result from postgresql.
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)