OGC SQL Conformance about h2gis HOT 12 CLOSED

Another one

-- Conformance Item T7
SELECT GeometryType(centerlines)
FROM lakes
WHERE name = 'Route 75';

lakes does not have centerlines field neither name with 'Route 75'. It should be "divided_routes" table

from h2gis.

Can you post a link to a document explaining OGC SQL conformance?

from h2gis.

Maybe it's here. Version 06-104r4?

from h2gis.

This one http://portal.opengeospatial.org/files/?artifact_id=25354 Simple Features - SQL - Types and Functions (1.2.1) unit test at end.

from h2gis.

-- Conformance Item T13

SELECT AsText(Boundary((boundary),101) FROM named_places WHERE name = 'Goose Island';

Missing parentheses..

And unit test result says it should return a LineString however the start and end point are the same and according to SFS it should be a LinearRing instead.

from h2gis.

Finally I will fix ST_Boundary and convert to LineString to follow OGC and PostGIS function.

from h2gis.

Erf It's impossible, a LineString that has the same first and last coordinate always create a LinearRing.

from h2gis.

Conformance test 28 Page 108

-- Conformance Item T28
SELECT NumInteriorRing(shore)
FROM lakes
WHERE name = 'Blue Lake';

Ring is plural it must be NumInteriorRings

from h2gis.

About test 28 http://lists.osgeo.org/pipermail/postgis-users/2006-January/010532.html

from h2gis.

Test 40

SELECT Within(boundary, footprint) FROM named_places, buildings WHERE named_places.name = 'Ashton' AND buildings.address = '215 Main Street'

boundary come from named places and it is an area like a district. Footprint is the building area. Expected result of OCG T40 is True.

However boundary is not inside footprint, this is footprint that are inside boundary. I invert parameters in this unit test:

SELECT Within(footprint,boundary) FROM named_places, buildings WHERE named_places.name = 'Ashton' AND buildings.address = '215 Main Street'

This error has been found also in POSTGIS
http://svn.osgeo.org/postgis/trunk/extras/ogc_test_suite/2_queries.sql

-- Test script reverses the correct order of arguments to 'Within()'. 
-- Specification says 'Within(g1,g2) is 'TRUE if g1 is completely 
-- contained in g2' and test explanation says we are checking if 
-- the house (g1, footprint) is within Ashton (g2, boundary).

from h2gis.

T42

SELECT Crosses(road_segments.centerline, divided_routes.centerlines) FROM road_segments, divided_routes WHERE road_segment.fid = 102 AND divided_routes.name = 'Route 75';

Missing s:

SELECT Crosses(road_segments.centerline, divided_routes.centerlines) FROM road_segments, divided_routes WHERE road_segments.fid = 102 AND divided_routes.name = 'Route 75';

from h2gis.

This bug is in OGC specification not H2GIS, close this ticket.

from h2gis.