unique-should-properties-spoi-sparql.txt 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. geo:asWKT (errors)
  2. poi:address (no)
  3. dc:identifier (no)
  4. dc:rights (no)
  5. locn:locatorDesignator (error)
  6. locn:adminUnitL1 (no)
  7. locn:fullAddress (error)
  8. locn:postCode (no)
  9. locn:postName (error)
  10. poi:region (error)
  11. <http://www.w3.org/ns/locnfullAddress> (no)
  12. PREFIX geo: <http://www.opengis.net/ont/geosparql#>
  13. PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
  14. PREFIX virtrdf: <http://www.openlinksw.com/schemas/virtrdf#>
  15. PREFIX poi: <http://www.openvoc.eu/poi#>
  16. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  17. PREFIX locn: <http://www.w3.org/ns/locn#>
  18. PREFIX dc: <http://purl.org/dc/elements/1.1/>
  19. SELECT ?Resource
  20. FROM <http://www.sdi4apps.eu/poi.rdf>
  21. WHERE {
  22. ?Resource poi:region ?obj .
  23. }
  24. GROUP BY ?Resource
  25. HAVING(COUNT(?obj) > 1)
  26. #limit 10
  27. ### different languages label
  28. ''
  29. ru
  30. de
  31. pt
  32. en
  33. fr
  34. it
  35. cs
  36. ro
  37. pl
  38. fi
  39. la
  40. es
  41. cz
  42. lv
  43. PREFIX geo: <http://www.opengis.net/ont/geosparql#>
  44. PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
  45. PREFIX virtrdf: <http://www.openlinksw.com/schemas/virtrdf#>
  46. PREFIX poi: <http://www.openvoc.eu/poi#>
  47. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  48. PREFIX locn: <http://www.w3.org/ns/locn#>
  49. PREFIX dc: <http://purl.org/dc/elements/1.1/>
  50. SELECT distinct (lang(?obj))
  51. FROM <http://www.sdi4apps.eu/poi.rdf>
  52. WHERE {
  53. ?Resource rdfs:label ?obj .
  54. }
  55. #### different language title
  56. ''
  57. en
  58. de
  59. cs
  60. PREFIX geo: <http://www.opengis.net/ont/geosparql#>
  61. PREFIX geof: <http://www.opengis.net/def/function/geosparql/>
  62. PREFIX virtrdf: <http://www.openlinksw.com/schemas/virtrdf#>
  63. PREFIX poi: <http://www.openvoc.eu/poi#>
  64. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  65. PREFIX locn: <http://www.w3.org/ns/locn#>
  66. PREFIX dc: <http://purl.org/dc/elements/1.1/>
  67. SELECT DISTINCT ?Resource1 ?Resource2
  68. FROM <http://www.sdi4apps.eu/poi/czech>
  69. WHERE {
  70. ?Resource1 a ?type1 .
  71. ?Resource1 rdfs:label ?label1 .
  72. ?Resource2 a ?type2 .
  73. ?Resource2 rdfs:label ?label2 .
  74. #FILTER(lcase(str(?label1) = lcase(str(?label1) ) .
  75. FILTER ( ?Resource1 != ?Resource2 )
  76. FILTER regex(?label1, ?label2, "i")
  77. }
  78. limit 10