Strabon

view scripts/query.sh @ 1422:f86d1129ce79

it turns out that there is no simple way of having the datatype of a constant geometry available in the query builder, thus it is not easy for geof:getSRID to determine the correct datatype and return the appropriate URI for the CRS, when that has SRID 4326. Therefore, we choose to always return CRS84, even for strdf:WKT arguments. Notice, that when geof:getSRID is called evaluated in Java, we have such information available and we can return the correct result. However, we chose in changeset 1420:37792dd7041b to always push the evaluation of all spatial functions in the database. The respective tests have been updated as well.
author Babis Nikolaou <charnik@di.uoa.gr>
date Tue Sep 23 14:05:26 2014 +0300 (2014-09-23)
parents e8c6881d0fff
children
line source
1 #!/bin/bash
2 #BASE=/home/strabon/experiments/data/naive/10mil
3 #10mil 0.01 11552771
4 #100mil 0.0034 99758140
5 #500mil 0.0015 512505143
6 #1bil 0.001 1153249211
8 DB="noa-d4_1"
9 LOGPATH="/home/strabon/experiments/logs"
10 STEP="0.01"
11 TOTALTRIPLES="11552771"
13 (cd jars/target &&
14 java -cp $(for file in `ls -1 *.jar`; do myVar=$myVar./$file":"; done; echo $myVar;) eu.earthobservatory.runtime.monetdb.QueryOp localhost 50000 $DB monetdb monetdb
15 "PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> PREFIX clc: <http://teleios.di.uoa.gr/ontologies/clcOntology.owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> PREFIX teleios: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> PREFIX gag: <http://www.semanticweb.org/ontologies/2011/gagKallikratis.rdf#> PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> PREFIX georss: <http://www.georss.org/georss/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX lgdo: <http://linkedgeodata.org/ontology/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX iman: <http://teleios.di.uoa.gr/ontologies/imageAnnotationOntology.owl#> PREFIX eolo: <http://www.dlr.de/ontologies/EOLO.owl#> SELECT ?h ?hGeo ?hAcqTime ?hConfidence ?hProvider ?hConfirmation ?hSensor WHERE { ?h a noa:Hotspot ; noa:hasGeometry ?hGeo ; noa:hasAcquisitionTime ?hAcqTime ; noa:hasConfidence ?hConfidence ; noa:isProducedBy ?hProvider ; noa:hasConfirmation ?hConfirmation ; noa:isDerivedFromSensor ?hSensor ; FILTER( \"2007-08-23T00:00:00\" <= str(?hAcqTime) && str(?hAcqTime) <= \"2007-08-26T23:59:59\" ) . FILTER( strdf:contains(\"POLYGON((21.027 38.36, 23.77 38.36, 23.77 36.05, 21.027 36.05, 21.027 38.36))\"^^strdf:WKT, ?hGeo) ) .}"
16 XML)