lgd-core.sml

/**
 * Sparqlify configuration file for LinkedGeoData
 *
 * Resource flavour
 *
 */

// Prefixes (these will also be used in the query responses)
Prefix geo: <http://www.opengis.net/ont/geosparql#>

Prefix dcterms: <http://purl.org/dc/terms/>
Prefix xsd: <http://www.w3.org/2001/XMLSchema#>
Prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
Prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
Prefix owl: <http://www.w3.org/2002/07/owl#>


Prefix lgd: <http://linkedgeodata.org/resource/>
Prefix lgdg: <http://linkedgeodata.org/geometry/>
Prefix lgdo: <http://linkedgeodata.org/ontology/>
Prefix lgdm: <http://linkedgeodata.org/meta/>

Prefix wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>

Prefix lu: <http://id.sirf.net/def/lu#>
Prefix wd: <http://www.wikidata.org/entity/>


Set defaultGraph = "http://linkedgeodata.org/osm/"



/**********
 * Status
 **********/
Create View status As
  Construct {
    <http://linkedgeodata.org/meta/status> ?p ?o .
  }
  With
    ?p = uri(lgdm:, ?k)
    ?o = plainLiteral(?v)
  From
    status


/**********
 * Users
 **********/
Create View users As
  Construct {
    ?s
      a dcterms:Agent ;
      rdfs:label ?l .
  }
  With
    ?s = uri(lgd:user, ?id)
    ?l = plainLiteral(?name)
  From
    users

/**********
 * Interlinks
 **********/

/*
//This view is superseded by lgd_{osmEntity}_interlinks
Create View interlinks As
  Construct {
    ?s owl:sameAs ?o .
    ?o lu:shortid ?os .
  }
  With
    ?s = uri(?s)
    ?o = uri(?o)
    ?os = plainLiteral(?o_local_name)
  Constrain
    ?s prefix "http://linkedgeodata.org"
    ?o prefix "http://dbpedia.org" "http://sws.geonames.org"
  From
    lgd_interlinks
*/


Create View lgd_node_interlinks As
  Construct {
    ?s owl:sameAs ?o .
    ?o lu:shortid ?os .
  }
  With
    ?s = uri(lgd:node, ?node_id)
    ?o = uri(?o)
    ?os = plainLiteral(?o_local_name)
  Constrain
    ?s prefix "http://linkedgeodata.org"
    ?o prefix "http://dbpedia.org" "http://sws.geonames.org"
  From
    lgd_node_interlinks


Create View lgd_way_interlinks As
  Construct {
    ?s owl:sameAs ?o .
    ?o lu:shortid ?os .
  }
  With
    ?s = uri(lgd:way, ?way_id)
    ?o = uri(?o)
    ?os = plainLiteral(?o_local_name)
  Constrain
    ?s prefix "http://linkedgeodata.org"
    ?o prefix "http://dbpedia.org" "http://sws.geonames.org"
  From
    lgd_way_interlinks


Create View lgd_relation_interlinks As
  Construct {
    ?s owl:sameAs ?o .
    ?o lu:shortid ?os .
  }
  With
    ?s = uri(lgd:relation, ?relation_id)
    ?o = uri(?o)
    ?os = plainLiteral(?o_local_name)
  Constrain
    ?s prefix "http://linkedgeodata.org"
    ?o prefix "http://dbpedia.org" "http://sws.geonames.org"
  From
    lgd_relation_interlinks




/**********
 * Ontology
 **********/


Create View classes_k As
    Construct {
        ?s a owl:Class .
        ?s lgdm:sourceKey ?k .
    }
    With
        ?s = uri(?object)
        ?k = plainLiteral(?k)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT object, k FROM lgd_map_resource_k WHERE property = 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type']];

Create View sub_classes As
    Construct {
        ?child rdfs:subClassOf ?parent .
    }
    With
        ?child  = uri(?child)
        ?parent = uri(?parent)
    Constrain
        ?child  prefix "http://linkedgeodata.org/ontology/"
        ?parent prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT a.object AS parent, b.object AS child FROM lgd_map_resource_k a JOIN lgd_map_resource_kv b ON (b.k = a.k) WHERE a.property = 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AND b.property = 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AND a.object != b.object]];


Create View classes_kv As
    Construct {
        ?s a owl:Class .
        ?s lgdm:sourceTag ?t .
        ?t lgdm:key ?k .
        ?t lgdm:value ?v .
    }
    With
        ?s = uri(?object)
        ?t = uri(?object, "/key/", ENCODE_FOR_URI(?k), "/value/", ENCODE_FOR_URI(?v))
        ?k = plainLiteral(?k)
        ?v = plainLiteral(?v)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
        ?t prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT object, k, v FROM lgd_map_resource_kv WHERE property = 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type']];



// Resource labels
Create View view_resource_labels As
    Construct {
        ?s rdfs:label ?o .
    }
    With
        ?s = uri(?resource)
        ?o = plainLiteral(?label, ?language)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_resource_label;



// Properties
Create View view_properties_k As
    Construct {
        ?s
            a rdf:Property ;
            a owl:ObjectProperty ;
            rdfs:domain spatial:Feature ;
            rdfs:range owl:Thing .
    }
    With
        ?s = uri(?property)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_map_resource_prefix


/* TODO Not sure how to adress the following tables best...
Create View view_object_properties As
    Construct {
        ?s
            a rdf:Property ;
            a owl:ObjectProperty ;
            rdfs:domain spatial:Feature ;
            rdfs:range lgdo:Sport .
    }
    With

    From
        [[SELECT property FROM lgd_map_resource_kv WHERE


Create View static_properties As
    Construct {
        <http://linkedgeodata.org/ontology/motorcar>
 http://www.w3.org/1999/02/22-rdf-syntax-ns#type
 http://linkedgeodata.org/ontology/featuresSport
 http://linkedgeodata.org/ontology/wheelchair
 http://linkedgeodata.org/ontology/agricultural
 http://linkedgeodata.org/ontology/featuresAbutters

    }
*/

Create View property_int As
    Construct {
        ?s
            a rdf:Property ;
            a owl:DatatypeProperty ;
            rdfs:range xsd:integer .
    }
    With
        ?s = uri(?property)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT a.property FROM lgd_map_datatype a WHERE a.datatype = 'int']]


Create View property_double As
    Construct {
        ?s
            a rdf:Property ;
            a owl:DatatypeProperty ;
            rdfs:range xsd:double .
    }
    With
        ?s = uri(?property)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT a.property FROM lgd_map_datatype a WHERE a.datatype = 'float']]


Create View property_boolean As
    Construct {
        ?s
            a rdf:Property ;
            a owl:DatatypeProperty ;
            rdfs:range xsd:boolean .
    }
    With
        ?s = uri(?property)
    Constrain
        ?s prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT a.property FROM lgd_map_datatype a WHERE a.datatype = 'boolean']]




/*************
 * Nodes
 *************/

// Node geometries
Create View lgd_nodes As
    Construct {
        ?n a lgdm:Node .
        ?n a geo:Feature .
        ?n lgdo:version ?v .
        ?n dcterms:contributor ?u .
        ?n dcterms:modified ?d .
        ?n lgdo:changeset ?c .

        ?n wgs:long ?xx .
        ?n wgs:lat ?yy .

        ?n lgdo:gadmSameAs ?gadm .
    }
    With
        ?n = uri(concat(lgd:node, ?id))
        ?v = typedLiteral(?version, xsd:int)
        ?u = uri(concat(lgd:user, ?user_id))
        ?d = typedLiteral(?tstamp, xsd:dateTime)
        ?c = typedLiteral(?changeset_id, xsd:int)
        //?g = typedLiteral(?geom, virtrdf:geometry)
        ?xx = typedLiteral(?x, xsd:double)
        ?yy = typedLiteral(?y, xsd:double)

        ?gadm = uri(concat("http://gadm.geovocab.org/services/withinRegion?lat=", ?y_text , "&long=", ?x_text, "#point"))

    From
        [[SELECT *, ST_X(geom::geometry) x, ST_Y(geom::geometry) y, ST_X(geom::geometry)::float4::text x_text, ST_Y(geom::geometry)::float4::text y_text FROM nodes]];


Create View lgd_nodes_geometry As
    Construct {
        ?n geo:hasGeometry ?g .

        ?g a geo:hasGeometry .
        ?g geo:asWKT ?o .
    }
    With
        ?n = uri(concat(lgd:node, ?id))
        ?g = uri(concat(lgdg:node, ?id))
        ?o = typedLiteral(?geom, geo:wktLiteral)
    From
      lgd_nodes_geometry


/*
Create view lgd_sameAs_gadm As
    Construct {
        ?n owl:sameAs ?gadm .
    }
    With
        ?n = uri(concat(lgd:node, ?id))
        ?gadm = uri(concat("http://gadm.geovocab.org/services/withinRegion?lat=", ?y , "&long=", ?x, "#point"))
    From
        [[SELECT id, ST_X(geom::geometry)::float4::text x, ST_Y(geom::geometry)::float4::text y FROM nodes]];


Create View lgd_node_geometries As
    Construct {
        ?n a geo:hasGeometry .
        ?n geo:asWKT ?o .
    }
    With
        ?n = uri(concat(lgdg:node, ?id))
        ?o = typedLiteral(?geom, geo:wktLiteral)
    From
        nodes;
*/

Create View lgd_node_tags_resource_k As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_node_tags_resource_k


Create View lgd_node_tags_resource_kv As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_node_tags_resource_kv

Create View lgd_node_tags_resource_kd As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?node_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_node_tags_resource_kd

Create View lgd_node_tags_boolean As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:boolean)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_node_tags_boolean

Create View lgd_node_tags_int As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        //?p = uri(concat('http://linkedgeodata.org/ontology/', ENCODE_FOR_URI(?k)))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:int)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_node_tags_int

Create View lgd_node_tags_float As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:float)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_node_tags_float

Create View lgd_node_tags_text As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = plainLiteral(?v, ?language)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/" "http://xmlns.com/foaf/0.1/"
    From
        lgd_node_tags_text

Create View lgd_node_tags_string As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(concat('http://linkedgeodata.org/ontology/', ENCODE_FOR_URI(?k)))
        ?o = plainLiteral(?v)
    From
        lgd_node_tags_string


Create View lgd_node_tags_uri As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(lgd:node, ?node_id)
        ?p = uri(?property)
        ?o = uri(?v)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/" "http://xmlns.com/foaf/0.1/"
    From
        lgd_node_tags_uri


/*************
 * Ways
 *************/

Create View lgd_ways As
    Construct {
        ?w a lgdm:Way .
        ?w a geo:Feature .
        ?w lgdo:version ?v .
        ?w dcterms:contributor ?u .
        ?w dcterms:modified ?d .
        ?w lgdo:changeset ?c .
    }
    With
        ?w = uri(concat(lgd:way, ?id))
        ?v = typedLiteral(?version, xsd:int)
        ?u = uri(concat(lgd:user, ?user_id))
        ?d = typedLiteral(?tstamp, xsd:dateTime)
        ?c = typedLiteral(?changeset_id, xsd:int)
        //?g = typedLiteral(?geom, virtrdf:geometry)
    From
        ways;

Create View lgd_ways_geometry As
    Construct {
        ?w geo:hasGeometry ?g .

        ?g a geo:hasGeometry .
        ?g geo:asWKT ?o .
    }
    With
        ?w = uri(concat(lgd:way, ?id))
        ?g = uri(concat(lgdg:way, ?id))
        ?o = typedLiteral(?geom, geo:wktLiteral)
    From
      lgd_ways_geometry


/*
Create View lgd_ways_linestrings As
    Construct {
        ?w a geo:hasGeometry .
        ?w geo:asWKT ?g .
    }
    With
        //?w = uri(concat(lgd:way, ?id))
        ?w = uri(concat(lgdg:way, ?id))
        ?g = typedLiteral(?linestring, geo:wktLiteral)
    From
        [[SELECT id, linestring FROM ways a WHERE a.id NOT IN (SELECT way_id FROM simple_polys)]];
*/


/*
Create View ways_polygons As
    Construct {
        ?w a geo:hasGeometry .
        ?w geo:asWKT ?g .
    }
    With
        //?w = uri(concat(lgd:way, ?way_id))
        ?w = uri(concat(lgdg:way, ?way_id))
        ?g = typedLiteral(?polygon, geo:wktLiteral)
    From
        simple_polys;
*/


/*
Create View view_way_to_nodes As
    Construct {
        ?w lgdo:hasNodes ?wn .
    }
    With
        ?w = uri(concat(lgd:way, ?id))
        ?wn = uri(concat(lgd:waynode, ?id))
    From
        ways;
*/


Create View lgd_pos_seq As
    Construct {
        ?w lgdo:posSeq ?wn .
    }
    With
        ?w = uri(concat(lgdg:way, ?id))
        ?wn = uri(concat(lgdg:posSeq, ?id))
    From
        ways;

Create View lgd_pos_seq_type As
    Construct {
        ?wn a rdf:Seq .
    }
    With
        ?wn = uri(concat(lgdg:posSeq, ?id))
    From
        ways;


Create View view_waynodes As
    Construct {
        ?wn ?p ?n .
    }
    With
        ?wn = uri(concat(lgdg:posSeq, ?way_id))
        ?p = uri(concat(rdf:_, ?sid))
        ?n = uri(concat(lgdg:node, ?node_id))
    From
        [[SELECT *, sequence_id + 1 AS sid FROM way_nodes]]


Create View lgd_way_tags_resource_k As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_way_tags_resource_k

Create View lgd_way_tags_resource_kv As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_way_tags_resource_kv

Create View lgd_way_tags_resource_kd As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_way_tags_resource_kd

Create View lgd_way_tags_boolean As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:boolean)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_way_tags_boolean

Create View lgd_way_tags_int As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:int)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_way_tags_int

Create View lgd_way_tags_float As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:float)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_way_tags_float

Create View lgd_way_tags_text As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = plainLiteral(?v, ?language)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/" "http://xmlns.com/foaf/0.1/"
    From
        lgd_way_tags_text

Create View lgd_way_tags_string As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(concat('http://linkedgeodata.org/ontology/', ENCODE_FOR_URI(?k)))
        ?o = plainLiteral(?v)
    From
        lgd_way_tags_string


Create View lgd_way_tags_uri As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(lgd:way, ?way_id)
        ?p = uri(?property)
        ?o = uri(?v)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/" "http://xmlns.com/foaf/0.1/"
    From
        lgd_way_tags_uri



/*********
 * RELATIONS
 *********/

Create View lgd_relations As
    Construct {
        ?s a lgdm:Relation .
        ?s a geo:Feature .
        ?s lgdo:version ?v .
        ?s dcterms:contributor ?u .
        ?s dcterms:modified ?d .
        ?s lgdo:changeset ?c .
        //?w geo:hasGeometry ?g .

        ?s lgdo:members ?m .
        ?m a rdf:Seq .

    }
    With
        ?s = uri(concat(lgd:relation, ?id))
        ?v = typedLiteral(?version, xsd:int)
        ?u = uri(concat(lgd:user, ?user_id))
        ?d = typedLiteral(?tstamp, xsd:dateTime)
        ?c = typedLiteral(?changeset_id, xsd:int)
        //?g = uri(concat(lgdg:relation, ?id))

        ?m = uri(lgd:rmembers, ?id)

    From
        relations
        //[[SELECT id, version, user_id, tstamp, changeset_id FROM relations]];

/*
Create View lgd_relations_geometry As
    Construct {
        ?s geo:hasGeometry ?g .

        ?g a geo:hasGeometry .
        ?g geo:asWKT ?o .
    }
    With
        ?s = uri(lgd:relation, ?id)
        ?g = uri(lgdg:relation, ?id)
        ?o = typedLiteral(?geom, geo:wktLiteral)
    From
      lgd_relations_geometry
*/

/*
Create View lgd_relation_geoms As
  Construct {
    ?s geo:hasGeometry ?g .

    ?g a geo:hasGeometry .
    ?g geo:asWKT ?o .
  }
  With
    ?s = uri(lgd:relation, ?relation_id)
    ?g = uri(lgdg:relation, ?relation_id)
    ?o = typedLiteral(?geom, geo:wktLiteral)
  From
    lgd_relation_geoms
*/

Create View lgd_relation_members_all As
  Construct {
        ?m ?p ?i .
        ?i lgdo:role ?r .
  }
  With
        ?m = uri(lgd:rmembers, ?relation_id)
        ?p = uri(rdf:_, ?sid)
        ?i = uri(lgd:rmember, ?relation_id, "_", ?sid)
        ?r = plainLiteral(?member_role)
  From
    [[SELECT *, sequence_id + 1 AS sid FROM relation_members]]


Create View lgd_relation_members_seq_nodes As
    Construct {
        ?i lgdo:ref ?n
    }
    With
        ?i = uri(lgd:rmember, ?relation_id, "_", ?sid)
        ?n = uri(lgd:node, ?member_id)
    From
        [[SELECT *, sequence_id + 1 AS sid FROM relation_members WHERE member_type = 'N']];

Create View lgd_relation_members_seq_ways As
    Construct {
        ?i lgdo:ref ?w
    }
    With
        ?i = uri(lgd:rmember, ?relation_id, "_", ?sid)
        ?w = uri(lgd:way, ?member_id)
    From
        [[SELECT *, sequence_id + 1 AS sid FROM relation_members WHERE member_type = 'W']];


Create View lgd_relation_members_seq_relations As
    Construct {
        ?i lgdo:ref ?r
    }
    With
        ?i = uri(lgd:rmember, ?relation_id, "_", ?sid)
        ?r = uri(lgd:relation, ?member_id)
    From
        [[SELECT *, sequence_id + 1 AS sid FROM relation_members WHERE member_type = 'R']];


/*
Create View relation_members_nodes As
    Construct {
        ?s lgdo:hasMember ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?o = uri(concat(lgd:node, ?member_id))
    From
        [[SELECT relation_id, member_id FROM relation_members WHERE member_type = 'N']];
*/





Create View lgd_relation_tags_resource_k As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_relation_tags_resource_k

Create View lgd_relation_tags_resource_kv As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_relation_tags_resource_kv

Create View lgd_relation_tags_resource_kd As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?relation_id))
        ?p = uri(?property)
        ?o = uri(?object)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
        ?o prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_relation_tags_resource_kd

Create View lgd_relation_tags_boolean As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:boolean)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_relation_tags_boolean

Create View lgd_relation_tags_int As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:int)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_relation_tags_int

Create View lgd_relation_tags_float As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = typedLiteral(?v, xsd:float)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        lgd_relation_tags_float

Create View lgd_relation_tags_text As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = plainLiteral(?v, ?language)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/" "http://xmlns.com/foaf/0.1/"
    From
        lgd_relation_tags_text

Create View lgd_relation_tags_string As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(concat('http://linkedgeodata.org/ontology/', ENCODE_FOR_URI(?k)))
        ?o = plainLiteral(?v)
    From
        lgd_relation_tags_string


Create View lgd_relation_tags_uri As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(lgd:relation, ?relation_id)
        ?p = uri(?property)
        ?o = uri(?v)
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/" "http://www.w3.org/" "http://xmlns.com/foaf/0.1/"
    From
        lgd_relation_tags_uri



Create View lgd_node_tags_resource_prefix As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = uri(concat(?object_prefix, ?v))
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT * FROM lgd_node_tags_resource_prefix WHERE post_processing='none']]

Create View lgd_way_tags_resource_prefix As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:way, ?way_id))
        ?p = uri(?property)
        ?o = uri(concat(?object_prefix, ?v))
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT * FROM lgd_way_tags_resource_prefix WHERE post_processing='none']]

Create View lgd_relation_tags_resource_prefix As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:relation, ?relation_id))
        ?p = uri(?property)
        ?o = uri(concat(?object_prefix, ?v))
    Constrain
        ?p prefix "http://linkedgeodata.org/ontology/"
    From
        [[SELECT * FROM lgd_relation_tags_resource_prefix WHERE post_processing='none']]


/**
 * Wikidata mappings
 */

Create View node_tags_wikidata As
  Construct { ?s lgdo:wikidata ?o }
  With
    ?s = uri(concat(lgd:node, ?node_id))
    ?o = uri(concat(wd:, ?v))
  From [[SELECT * FROM node_tags WHERE k = 'wikidata']];

Create View way_tags_wikidata As
  Construct { ?s lgdo:wikidata ?o }
  With
    ?s = uri(concat(lgd:way, ?way_id))
    ?o = uri(concat(wd:, ?v))
  From [[SELECT * FROM way_tags WHERE k = 'wikidata']];

Create View relation_tags_wikidata As
  Construct { ?s lgdo:wikidata ?o }
  With
    ?s = uri(concat(lgd:relation, ?relation_id))
    ?o = uri(concat(wd:, ?v))
  From [[SELECT * FROM relation_tags WHERE k = 'wikidata']];



/*

// Classes and object properties (generic)
Create View view_prefixed_properties As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = uri(?object)
    From
        node_generic_resources;




// Object Properties with prefix
// The prefix datatype causes troubles
Create View view_prefixed_properties As
    Construct {
        ?s ?p ?o .
    }
    With
        ?s = uri(concat(lgd:node, ?node_id))
        ?p = uri(?property)
        ?o = uri(concat(?object_prefix, ?v))
    From
        lgd_node_tags_prefix;

*/



/**
 * Copyright (C) 2009-2012, LinkedGeoData team at the MOLE research
 * group at AKSW / University of Leipzig
 *
 * This file is part of LinkedGeoData.
 *
 * LinkedGeoData is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * LinkedGeoData is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 */