[teiid-issues] [JBoss JIRA] (TEIID-3301) Add GEOMETRY_COLUMNS view
Steven Hawkins (JIRA)
issues at jboss.org
Fri Feb 6 08:12:49 EST 2015
[ https://issues.jboss.org/browse/TEIID-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038303#comment-13038303 ]
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)
More information about the teiid-issues
mailing list