-- Class Definition that includes SPIN Rules

SPARQL CLEAR GRAPH <urn:spin:rule:geospatial:lib> ;

SPARQL DROP SPIN  LIBRARY <urn:spin:rule:geospatial:lib> ; 

TTLP ('
@prefix owl:     <http://www.w3.org/2002/07/owl#> .
@prefix sp:    <http://spinrdf.org/sp#> .
@prefix spl:    <http://spinrdf.org/spl#> .
@prefix spin:    <http://spinrdf.org/spin#> .
@prefix rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs:    <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd:     <http://www.w3.org/2001/XMLSchema#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix  rel:  <http://purl.org/vocab/relationship/> .
@prefix wdrs: <http://www.w3.org/2007/05/powder-s#> .
@prefix schema: <http://schema.org/> .
@prefix sioc: <http://rdfs.org/sioc/ns#> . 

sioc:Item
a rdfs:Class ;
rdfs:label "An Item"^^xsd:string ;
spin:rule
          [ a sp:Construct ;
            rdfs:label "Latitude Rule" ;
            rdfs:comment """Handler for different kinds of Latitude oriented fields (relations). """ ;
            sp:text """
 
					CONSTRUCT { ?this <#hasLatitude> ?n. }
					WHERE
							{
								FILTER (contains(str(?p),"latitude") || contains(str(?p),"Latitude") ) .
								?this ?p ?n 

							}
					"""
           ] ;

		  
spin:rule

          [ a sp:Construct ;
            rdfs:label "Longitude Rule" ;
            rdfs:comment """  Handler for different kinds of Longitude oriented fields (relations) """ ;
            sp:text """
					CONSTRUCT { ?this <#hasLongitude> ?n. }
					WHERE
							{
								FILTER (contains(str(?p),"longitude") || contains(str(?p),"Longitude") ) .
								?this ?p ?n 

							}
					"""
           ] .
			  
   
',
'', 'urn:spin:rule:geospatial:lib', 4096)
;

-- Macro Generation 
-- Diagnostic for reading what's generated from SPIN descriptions		
-- SELECT SPARQL_SPIN_GRAPH_TO_DEFSPIN('urn:spin:rule:geospatial:lib');



EXEC ('SPARQL ' || SPARQL_SPIN_GRAPH_TO_DEFSPIN('urn:spin:rule:geospatial:lib'));

-- Test Queries

-- Data Set #1

SPARQL 

DEFINE get:soft "soft"
DEFINE input:macro-lib <urn:spin:rule:geospatial:lib>  


SELECT ?x ?y ?z
FROM <http://bostonopendata-boston.opendata.arcgis.com/datasets/465e00f9632145a1ad645a27d27069b4_2.csv>
WHERE { 

?x a sioc:Item .
?x <#hasLatitude> ?y.
?x <#hasLongitude> ?z.

}  ;


-- Data Set #2

SPARQL 

DEFINE get:soft "soft"
DEFINE input:macro-lib <urn:spin:rule:geospatial:lib>  

SELECT ?y ?z
FROM <http://bostonopendata-boston.opendata.arcgis.com/datasets/465e00f9632145a1ad645a27d27069b4_2.csv>
FROM <http://bostonopendata-boston.opendata.arcgis.com/datasets/de08c6fe69c942509089e6db98c716a3_0.csv>
FROM <http://kingsley.idehen.net/DAV/home/danielhm/Public/ca-cities-sample.csv>
WHERE { 

?x a sioc:Item .

?x <#hasLatitude> ?y .
?x <#hasLongitude> ?z .

}