はこだてMap+で函館スイーツの情報を得てスイーツな気分になれる SPARQL のクエリー集
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX sweets: <http://lod.fun.ac.jp/hakobura/terms/sweet#>
select ?s ?shopname ?lat ?long where {
?s sweets:shopname ?shopname.
?s geo:lat ?lat.
?s geo:long ?long.
FILTER (lang(?shopname) = 'j')
}
{
"head": {
"link": [],
"vars": [
"s",
"shopname",
"lat",
"long"
]
},
"results": {
"distinct": false,
"ordered": true,
"bindings": [
{
"s": {
"type": "uri",
"value": "urn:000010"
},
"shopname": {
"type": "literal",
"xml:lang": "j",
"value": "パティスリー ジョリクレール"
},
"lat": {
"type": "literal",
"value": "41.821807"
},
"long": {
"type": "literal",
"value": "140.6521807"
}
},
{
"s": {
"type": "uri",
"value": "urn:000011"
},
"shopname": {
"type": "literal",
"xml:lang": "j",
"value": "たいやき茶屋 北菓り"
},
"lat": {
"type": "literal",
"value": "41.7717568"
},
"long": {
"type": "literal",
"value": "140.7264132"
}
},
...
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX sweets: <http://lod.fun.ac.jp/hakobura/terms/sweet#>
select ?id ?shopname ?lat ?long where {
?s sweets:id ?id.
?s sweets:shopname ?shopname.
?s geo:lat ?lat.
?s geo:long ?long.
FILTER (lang(?shopname) = 'j')
}
{
"head": {
"link": [],
"vars": [
"id",
"shopname",
"lat",
"long"
]
},
"results": {
"distinct": false,
"ordered": true,
"bindings": [
{
"id": {
"type": "literal",
"value": "000010"
},
"shopname": {
"type": "literal",
"xml:lang": "j",
"value": "パティスリー ジョリクレール"
},
"lat": {
"type": "literal",
"value": "41.821807"
},
"long": {
"type": "literal",
"value": "140.6521807"
}
},
{
"id": {
"type": "literal",
"value": "000011"
},
"shopname": {
"type": "literal",
"xml:lang": "j",
"value": "たいやき茶屋 北菓り"
},
"lat": {
"type": "literal",
"value": "41.7717568"
},
"long": {
"type": "literal",
"value": "140.7264132"
}
},
...
<urn:000010>
のように主語にIDを入れます。
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX schema: <http://schema.org/>
PREFIX sweet: <http://lod.fun.ac.jp/hakobura/terms/sweet#>
SELECT ?shopname ?shopimage ?shopdescription ?area ?modified ?postcode ?address ?telephone ?openingHoursSpecification ?closed ?parking ?eatin ?id ?email ?url ?lat ?long ?featuredproductname ?featuredproductprice ?featuredproductimage ?featuredproductdescription
WHERE {
<urn:000010> sweet:shopname ?shopname.
<urn:000010> sweet:shopimage ?shopimage.
<urn:000010> sweet:shopdescription ?shopdescription.
<urn:000010> sweet:area ?area.
<urn:000010> dc:modified ?modified.
<urn:000010> sweet:postcode ?postcode.
<urn:000010> schema:address ?address.
<urn:000010> schema:telephone ?telephone.
<urn:000010> schema:openingHoursSpecification ?openingHoursSpecification.
<urn:000010> sweet:closed ?closed.
<urn:000010> sweet:parking ?parking.
<urn:000010> sweet:eatin ?eatin.
<urn:000010> sweet:id ?id.
<urn:000010> schema:email ?email.
<urn:000010> schema:url ?url.
<urn:000010> geo:lat ?lat.
<urn:000010> geo:long ?long.
<urn:000010> sweet:featuredproductname ?featuredproductname.
<urn:000010> sweet:featuredproductprice ?featuredproductprice.
<urn:000010> sweet:featuredproductimage ?featuredproductimage.
<urn:000010> sweet:featuredproductdescription ?featuredproductdescription.
}
店の情報は「漢字」「よみがな」の2つ取得されます
よみがなが要らなかったら FILTER (lang(?shopname) = 'j')
をSPARQLのWHEREへ入れましょう。
{
"head": {
"link": [],
"vars": [
"shopname",
"shopimage",
"shopdescription",
"area",
"modified",
"postcode",
"address",
"telephone",
"openingHoursSpecification",
"closed",
"parking",
"eatin",
"id",
"email",
"url",
"lat",
"long",
"featuredproductname",
"featuredproductprice",
"featuredproductimage",
"featuredproductdescription"
]
},
"results": {
"distinct": false,
"ordered": true,
"bindings": [
{
"shopname": {
"type": "literal",
"xml:lang": "ja-hira",
"value": "ぱてぃすりー じょりくれーる"
},
"shopimage": {
"type": "literal",
"value": "http://www.hakodate-sweets.com/pgm/img/main01-20130827040316.jpg"
},
"shopdescription": {
"type": "literal",
"value": "当店は雄大な自然が広がる「北海道・北斗市」にある洋菓子専門店です。パティシエ自慢の季節感・旬感を大事にした創作スイーツを多数取り揃えております。"
},
"area": {
"type": "literal",
"value": "函館市近郊エリア"
},
"modified": {
"type": "literal",
"value": "2016-12-14"
},
"postcode": {
"type": "literal",
"value": "049-0162"
},
"address": {
"type": "literal",
"value": "北斗市中央2-1-5"
},
"telephone": {
"type": "literal",
"value": "0138-73-0370"
},
"openingHoursSpecification": {
"type": "literal",
"value": "0138-73-4013"
},
"closed": {
"type": "literal",
"value": "10:00~20:00"
},
"parking": {
"type": "literal",
"value": "無休"
},
"eatin": {
"type": "literal",
"value": "無料あり"
},
"id": {
"type": "literal",
"value": "000010"
},
"email": {
"type": "literal",
"value": "info@hokuto-jolicreer.com"
},
"url": {
"type": "literal",
"value": "http://www.hokuto-jolicreer.com"
},
"lat": {
"type": "literal",
"value": "41.821807"
},
"long": {
"type": "literal",
"value": "140.6521807"
},
"featuredproductname": {
"type": "literal",
"xml:lang": "ja",
"value": "もちもちシュー"
},
"featuredproductprice": {
"type": "literal",
"value": "140円"
},
"featuredproductimage": {
"type": "literal",
"value": "http://www.hakodate-sweets.com/pgm/img/main02-20130827040317.jpg"
},
"featuredproductdescription": {
"type": "literal",
"value": "北斗市産「ふっくりんこ」の米粉を皮に使用したしっとり・もちもちなシュークリームです。持つとずっしりと重さを感じられるくらいにクリームたっぷりと詰めています。"
}
},
{
"shopname": {
"type": "literal",
"xml:lang": "j",
"value": "パティスリー ジョリクレール"
},
"shopimage": {
"type": "literal",
"value": "http://www.hakodate-sweets.com/pgm/img/main01-20130827040316.jpg"
},
"shopdescription": {
"type": "literal",
"value": "当店は雄大な自然が広がる「北海道・北斗市」にある洋菓子専門店です。パティシエ自慢の季節感・旬感を大事にした創作スイーツを多数取り揃えております。"
},
"area": {
"type": "literal",
"value": "函館市近郊エリア"
},
"modified": {
"type": "literal",
"value": "2016-12-14"
},
"postcode": {
"type": "literal",
"value": "049-0162"
},
"address": {
"type": "literal",
"value": "北斗市中央2-1-5"
},
"telephone": {
"type": "literal",
"value": "0138-73-0370"
},
"openingHoursSpecification": {
"type": "literal",
"value": "0138-73-4013"
},
"closed": {
"type": "literal",
"value": "10:00~20:00"
},
"parking": {
"type": "literal",
"value": "無休"
},
"eatin": {
"type": "literal",
"value": "無料あり"
},
"id": {
"type": "literal",
"value": "000010"
},
"email": {
"type": "literal",
"value": "info@hokuto-jolicreer.com"
},
"url": {
"type": "literal",
"value": "http://www.hokuto-jolicreer.com"
},
"lat": {
"type": "literal",
"value": "41.821807"
},
"long": {
"type": "literal",
"value": "140.6521807"
},
"featuredproductname": {
"type": "literal",
"xml:lang": "ja",
"value": "もちもちシュー"
},
"featuredproductprice": {
"type": "literal",
"value": "140円"
},
"featuredproductimage": {
"type": "literal",
"value": "http://www.hakodate-sweets.com/pgm/img/main02-20130827040317.jpg"
},
"featuredproductdescription": {
"type": "literal",
"value": "北斗市産「ふっくりんこ」の米粉を皮に使用したしっとり・もちもちなシュークリームです。持つとずっしりと重さを感じられるくらいにクリームたっぷりと詰めています。"
}
}
]
}
}
##店の詳細情報 店名で検索
FILTER regex(?shopname, "たいやき茶屋 北菓り")
のように店名を指定します。
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX schema: <http://schema.org/>
PREFIX sweet: <http://lod.fun.ac.jp/hakobura/terms/sweet#>
SELECT ?shopname ?shopimage ?shopdescription ?area ?modified ?postcode ?address ?telephone ?openingHoursSpecification ?closed ?parking ?eatin ?id ?email ?url ?lat ?long ?featuredproductname ?featuredproductprice ?featuredproductimage ?featuredproductdescription
WHERE {
?s sweet:shopname ?shopname.
?s sweet:shopimage ?shopimage.
?s sweet:shopdescription ?shopdescription.
?s sweet:area ?area.
?s dc:modified ?modified.
?s sweet:postcode ?postcode.
?s schema:address ?address.
?s schema:telephone ?telephone.
?s schema:openingHoursSpecification ?openingHoursSpecification.
?s sweet:closed ?closed.
?s sweet:parking ?parking.
?s sweet:eatin ?eatin.
?s sweet:id ?id.
?s schema:email ?email.
?s schema:url ?url.
?s geo:lat ?lat.
?s geo:long ?long.
?s sweet:featuredproductname ?featuredproductname.
?s sweet:featuredproductprice ?featuredproductprice.
?s sweet:featuredproductimage ?featuredproductimage.
?s sweet:featuredproductdescription ?featuredproductdescription.
FILTER regex(?shopname, "たいやき茶屋 北菓り")
}
店の情報は「漢字」のひとつだけです
{
"head": {
"link": [],
"vars": [
"shopname",
"shopimage",
"shopdescription",
"area",
"modified",
"postcode",
"address",
"telephone",
"openingHoursSpecification",
"closed",
"parking",
"eatin",
"id",
"email",
"url",
"lat",
"long",
"featuredproductname",
"featuredproductprice",
"featuredproductimage",
"featuredproductdescription"
]
},
"results": {
"distinct": false,
"ordered": true,
"bindings": [
{
"shopname": {
"type": "literal",
"xml:lang": "j",
"value": "たいやき茶屋 北菓り"
},
"shopimage": {
"type": "literal",
"value": "http://www.hakodate-sweets.com/pgm/img/main01-20130830040341.jpg"
},
"shopdescription": {
"type": "literal",
"value": "函館朝市内にある、たいやき店。生地の美味しさにこだわり、ハネ付きに仕上げています。定番の甘さ控えめの粒あん等のほか、北海道産のリンゴやじゃがいもを使ったオリジナルのたい焼きが人気です。"
},
"area": {
"type": "literal",
"value": "西部エリア"
},
"modified": {
"type": "literal",
"value": "2016-12-26"
},
"postcode": {
"type": "literal",
"value": "040-0063"
},
"address": {
"type": "literal",
"value": "函館市若松町11-10(函館朝市内)"
},
"telephone": {
"type": "literal",
"value": "0138-84-1998"
},
"openingHoursSpecification": {
"type": "literal",
"value": "10:00~19:00"
},
"closed": {
"type": "literal",
"value": "水曜日(祝日の場合翌日休)"
},
"parking": {
"type": "literal",
"value": "なし"
},
"eatin": {
"type": "literal",
"value": "なし"
},
"id": {
"type": "literal",
"value": "000011"
},
"email": {
"type": "literal",
"value": ""
},
"url": {
"type": "literal",
"value": ""
},
"lat": {
"type": "literal",
"value": "41.7717568"
},
"long": {
"type": "literal",
"value": "140.7264132"
},
"featuredproductname": {
"type": "literal",
"xml:lang": "ja",
"value": "りんごとクリームのたい焼き"
},
"featuredproductprice": {
"type": "literal",
"value": "200円"
},
"featuredproductimage": {
"type": "literal",
"value": "http://www.hakodate-sweets.com/pgm/img/main02-20130830040341.jpg"
},
"featuredproductdescription": {
"type": "literal",
"value": "コンポートした北海道産リンゴとカスタードクリームに、シナモンを振りかけて、アップルパイのような味に仕上げました。他に、地物のじゃがいもとチーズを合わせた「じゃがいもとチーズのたい焼(200円)」も人気です。"
}
}
]
}
}