View difference between Paste ID: CuBQk0xX and y0Tp8GFd
SHOW: | | - or go back to the newest paste.
1
##### THE FOLLOWING QUERY GIVES ME THIS ERROR :
2
# Warning: odbc_exec(): SQL error: [unixODBC][OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SQ200: Stack Overflow in cost model, SQL state 37000 in SQLExecDirect in /var/www/html/ontowiki-scripts/model_the_source-virtuoso_to_webmap.php on line 20
3
4
##### BUT IT WORKS IF I COMMENT OUT (in the FILTER clause)
5
# AND
6
# bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(<?=$xmin?> <?=$ymin?>, <?=$xmax?> <?=$ymax?>)") )
7
8
##### AND IT ALSO WORKS IF I COMMENT OUT (in the FILTER clause)
9
# ?min_zoom <= "<?=$zoom?>"^^xsd:integer
10
# AND
11
# ?max_zoom >= "<?=$zoom?>"^^xsd:integer
12
# AND
13
14
##### SO IT'S ONLY WHEN I COMBINE BOTH THAT I GET THE ERROR ?!?!
15
16
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
17
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
18
PREFIX : <http://dhlabpc2.epfl.ch/OntoWiki/vtm/#>
19
20
SELECT *
21
FROM <http://dhlabpc2.epfl.ch/OntoWiki/vtm/>
22
23
WHERE{
24
    # select the entity
25
    ?entity a ?class .
26
27
    # whose class is a subclass of :class_entity
28
    ?class rdfs:subClassOf :class_entity .
29
30
    # get details for the subclass        
31
    ?class rdfs:label ?subclass_label .
32
    ?class :zindex ?zindex .
33
    ?class :min_zoom ?min_zoom .
34
    ?class :max_zoom ?max_zoom .
35
  
36
    # that have a defined shape
37
    ?entity :shape_defined_by ?geometry_defining_entity .
38
    ?geometry_defining_entity geo:geometry ?geom .
39
40
    FILTER (
41
        ?min_zoom <= 19
42-
        ?min_zoom <= "<?=$zoom?>"^^xsd:integer
42+
43
        ?max_zoom >= 19
44-
        ?max_zoom >= "<?=$zoom?>"^^xsd:integer
44+
45
        bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(12.3352 45.4382, 12.33521 45.43821)") )
46-
        bif:st_intersects ( ?geom, bif:st_geomfromtext("BOX(<?=$xmin?> <?=$ymin?>, <?=$xmax?> <?=$ymax?>)") )
46+
47
48
}
49
ORDER BY ?entity
50
51
LIMIT 500