Query_Formulation_GeoVKG

GeoSPARQL Query X
-------------------------
geo <http://www.opengis.net/ont/geosparql/>
geof    <http://www.opengis.net/def/function/geosparql>
units   <http://www.opengis.net/def/uom/OGC/1.0/>
crs <http://www.opengis.net/def/crs/OGC/1.3/CRS84/>
geo-sf  <http://www.opengis.net/def/dataType/OGC-SF/1.0/>
rasdb   <http://www.semanticweb.org/RasterDataCube/>
geop    <http://www.opengis.net/def/property/OGC-GeoSPARQL/1.0/>


SELECT * {
?x rdfs:label ?region_name .
?x :averageRASTER ?output .
?r rasdb: hasRasterName ?rasterDB_name .
?r rasdb:hasDateTime ?start_time .
?r rasdb:hasDateTime ?end_time .

FILTER (?start_time = "2023-06-26T00:00:00+00:00"^^xsd:dateTimeStamp &&
?end_time = "2023-07-03T00:00:00+00:00"^^xsd:dateTimeStamp && ?rasterDB_name = 'Baveria_Temperature_MODIS_1km' )}


MAPPING (still thinking)
-------------------------
:{region} :average_temporal_query {output}^^xsd:double .


SQL Query
-------------------------
SELECT m.name_2 as region,
rasdaman_op.aggregated_result(CONCAT('select max_cells(c[start_time:end_time, 0:* , 0:*]*0.02)-273.15 from, str(rasterDB_name), AS c')) AS output
FROM    region_bavaria as m
WHERE   m.name_2 = region_name;