R/queries.R

In jimjonesbr/sdd: R package for dealing with the SDD vocabulary

find_query <- "

SELECT DISTINCT 
      ?datasetType 
      ?datasourceType
      ?datasource 
      ?datasourceName
      ?dataset 
      ?host
      ?hostAlias
      ?hostAddress
      ?hostPort
      ?userName
      ?userPassword
      ?beginning
      ?end
      ?wkt
      ?storageField

WHERE {

      OPTIONAL{?datasource <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://giv-lodum.uni-muenster.de/resource/fdd#Array> .}
      OPTIONAL{?datasource <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://giv-lodum.uni-muenster.de/resource/fdd#Table> .}
      OPTIONAL{?datasource <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://giv-lodum.uni-muenster.de/resource/fdd#Shapefile> .}
      OPTIONAL{?datasource <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://giv-lodum.uni-muenster.de/resource/fdd#GeoTIFF> .}

      ?datasource <http://giv-lodum.uni-muenster.de/resource/fdd#hasHost> ?host .
      ?host <http://giv-lodum.uni-muenster.de/resource/fdd#hasAlias> ?hostAlias .
      ?host <http://giv-lodum.uni-muenster.de/resource/fdd#hasAddress> ?hostAddress .
      ?host <http://giv-lodum.uni-muenster.de/resource/fdd#hasPort> ?hostPort .
      ?datasource <http://giv-lodum.uni-muenster.de/resource/fdd#hasDataSet> ?dataset .

      ?dataset a ?datasetType	.
      ?datasource a ?datasourceType	.

      OPTIONAL{		
          ?dataset <http://giv-lodum.uni-muenster.de/resource/fdd#hasExtent> ?temporalExtent .			
          ?temporalExtent <http://www.w3.org/2006/time#hasBeginning> ?instantBeginning .
          ?instantBeginning <http://www.w3.org/2006/time#inXSDDateTime> ?beginning .
          ?temporalExtent <http://www.w3.org/2006/time#hasEnd> ?instantEnd .
          ?instantEnd <http://www.w3.org/2006/time#inXSDDateTime> ?end .			
      }

      OPTIONAL{
          ?dataset <http://giv-lodum.uni-muenster.de/resource/fdd#hasExtent> ?spatialExtent .		
          ?spatialExtent <http://www.opengis.net/ont/geosparql/1.0#hasGeometry> ?geometry .
          ?geometry <http://www.opengis.net/ont/geosparql/1.0#asWKT> ?wkt .
      }

      ?dataset <http://giv-lodum.uni-muenster.de/resource/fdd#hasPostition> ?position .

      OPTIONAL{?position <http://giv-lodum.uni-muenster.de/resource/fdd#isStoredAt>  ?storageField .}
      OPTIONAL{?position <http://giv-lodum.uni-muenster.de/resource/fdd#xIsStoredAt> ?xStorageField .}
      OPTIONAL{?position <http://giv-lodum.uni-muenster.de/resource/fdd#yIsStoredAt> ?yStorageField .}
      OPTIONAL{?position <http://giv-lodum.uni-muenster.de/resource/fdd#zIsStoredAt> ?zStorageField .}
      OPTIONAL{?position <http://giv-lodum.uni-muenster.de/resource/fdd#tIsStoredAt> ?tStorageField .}

      ?datasource <http://giv-lodum.uni-muenster.de/resource/fdd#hasName> ?datasourceName .
      ?datasource <http://giv-lodum.uni-muenster.de/resource/fdd#hasUser> ?user .
      ?user <http://giv-lodum.uni-muenster.de/resource/fdd#hasName> ?userName .
      ?user <http://giv-lodum.uni-muenster.de/resource/fdd#hasPassword> ?userPassword .

}
"