Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1291814

Summary:	RFE To expose VDBs as Geospatial databases
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Stelios Kousouris <stkousso>
Component:	Teiid	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED UPSTREAM	QA Contact:	Filip Elias <felias>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	6.2.0	CC:	aszczucz, blafond, cojan, jolee, mbaluch, stkousso, thauser, vhalbert
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-12-21 22:03:38 UTC	Type:	Enhancement
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Stelios Kousouris 2015-12-15 16:06:46 UTC

Description of problem:

In this JIRA https://issues.jboss.org/browse/JBDVPL-287 we provide spatial functions for DV to DB downstream running of these functions. The aim would be to allow VDBs to expose geospatial function execution on the views by the clients

RWS a Dutch agency which manages bridges etc. and their maintenance in The Netherlands utilizes WMS/WFS web services implemented by ArcGIS, Geoserver, MapServer, QGIS to locate places of interest (bridges) on map along with their features. To achieve this we need to integrate and run geospatial functions on the backends (some are already planned in for 6.3) but since the consuming clients require WMS/WFS input we would require DV to also expose the geospatial functions via the JDBC/ODBC drivers to the client apps (ArcGIS, Geoserver etc.). Hence DV VDBs would need to appear GIS compliant datasources.

Comment 1 Van Halbert 2015-12-15 16:15:24 UTC

Do you have details on what it means to be GIS compliant?

Comment 2 Cojan van Ballegooijen 2015-12-15 18:38:56 UTC

See 

http://www.esri.com/~/media/Files/Pdfs/library/whitepapers/pdfs/supported-ogc-iso-standards.pdf

WMS - http://www.opengeospatial.org/standards/wms
WFS - http://www.opengeospatial.org/standards/wfs

RWS is using MapViewer to show maps based on WMS services. The WMS services are provided by a GeoServer like ArcGIS or GeoServer. 

OData has also some capabilities in the Geo space especially on the .Net libraries side.
See http://www.odata.org/libraries/ for Microsoft.Spatial (OData v4) and System.Spatial (OData v1-3)

Comment 3 Van Halbert 2015-12-21 22:03:38 UTC

Closing as this has been logged in product planning.