Tom Arnold created TEIID-3301: --------------------------------- Summary: 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 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_colum... {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. -- This message was sent by Atlassian JIRA (v6.3.11#6341)