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 |