Hi
you should somehow connect the variable ?place to the variable ?country
there are some properties in DBpedia you can use like:
select count( distinct ?place)
where {
?place a <http://dbpedia.org/ontology/Place>.
?place rdfs:label ?placeName.
?country ?p ?o.
filter(?p = <http://purl.org/dc/terms/subject> && ?o = <
http://dbpedia.org/resource/Category:European_countries>)
?place <http://dbpedia.org/ontology/locationCountry> ?country.
filter(langMatches( lang(?placeName), "fr" )).
}
You can find the list of possible properties by this query:
select distinct ?x
where {
?place a <http://dbpedia.org/ontology/Place>.
?country ?p ?o.
filter(?p = <http://purl.org/dc/terms/subject> && ?o = <
http://dbpedia.org/resource/Category:European_countries>)
?place ?x ?country.
}
Select one you aim at your query.
Best Regards
On Sun, Dec 11, 2011 at 6:13 AM, Liam Kirsher <[email protected]> wrote:
> **
> I can get the list of the countries, but how to combine with the rest of
> the query?
> Okay, I tried this to get the count of all the articles about places in
> Europe that are in French. However, it times out. Is this the correct
> query?
>
> select ?country count(?place)
> where {
> ?place a
> <http://dbpedia.org/ontology/Place><http://dbpedia.org/ontology/Place>
> .
> ?place rdfs:label ?placeName. filter(langMatches( lang(?placeName),
> "fr" )).
> ?country ?p ?o. filter(?p =
> <http://purl.org/dc/terms/subject><http://purl.org/dc/terms/subject>&& ?o =
> <http://dbpedia.org/resource/Category:European_countries><http://dbpedia.org/resource/Category:European_countries>
> )
>
> }
>
> On 12/10/2011 03:44 PM, Mohamed Morsey wrote:
>
> Hi Liam,
>
> On 12/09/2011 09:21 PM, Liam Kirsher wrote:
>
> Mohamed,
>
> Thanks so much! That was very helpful, and I now have most of what I
> needed.
>
>
> Perfect, then good luck with your next step ;)
>
> The remaining thing is somewhat similar -- just to get entries in a
> particular language anywhere in Europe.
> Simply substituting Europe as the region does not work. I imagine there
> might be some way to get the list of European countries and filter on
> membership in the list.
>
>
> You can use the following query to get a list of all European countries:
>
>
> SELECT ?country WHERE { ?country ?p ?o. filter(?p =
> <http://purl.org/dc/terms/subject> <http://purl.org/dc/terms/subject> &&
> ?o =
> <http://dbpedia.org/resource/Category:European_countries><http://dbpedia.org/resource/Category:European_countries>)
> }
>
>
>
> Thanks again!
> Liam
>
>
>
> --
> Kind Regards
> Mohamed Morsey
> Department of Computer Science
> University of Leipzig
>
>
> --
> Liam Kirsher
> PGP: http://liam.numenet.com/pgp/
>
>
>
> ------------------------------------------------------------------------------
> Learn Windows Azure Live! Tuesday, Dec 13, 2011
> Microsoft is holding a special Learn Windows Azure training event for
> developers. It will provide a great way to learn Windows Azure and what it
> provides. You can attend the event by watching it streamed LIVE online.
> Learn more at http://p.sf.net/sfu/ms-windowsazure
> _______________________________________________
> Dbpedia-discussion mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>
>
--
Saeedeh Shekarpour
Phd student
Department of Computer Science, University of Leipzig
Research Group: http://aksw.org
هر آنکسی که دراین حلقه نیست زنده به عشق
بر او نمرده به فتوی من نماز کنید
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
