http://labs.europeana.eu/api/linked-open-data-data-downloads

[bpga...@gmail.com]

Dear Friends

It is really the ocean of knowledge here in this group about europeana.eu.

I need to download the books data through the following query

PREFIX edm: <http://www.europeana.eu/schemas/edm/>
PREFIX ore: <http://www.openarchives.org/ore/terms/>
SELECT ?title ?creator ?mediaURL ?date ?identifier ?format ?language ?type ?contributor
WHERE {
  ?CHO edm:type "TEXT" ;
      ore:proxyIn ?proxy;
      dc:title ?title ;
      dc:creator ?creator ;
      dc:date ?date ;
      dc:identifier ?identifier ;
      dc:format ?format ;
      dc:language ?language ;
      dc:type ?type ;
      dc:contributor ?contributor .
  ?proxy edm:isShownBy ?mediaURL .
FILTER (?format > "10" && ?format < "5000")
}
LIMIT 100

I tried downloading the books metadata through http://sparql.europeana.eu/. The result is completely not clear why the same title is coming multiple time. Please guide me.

BPG

[Hugo Manguinhas]

Dear sender,

Thank you for your email!

There is nothing wrong with your query... what is happening is that you are projecting all the variables in your select (?title ?creator ?mediaURL ?date ?identifier ?format ?language ?type ?contributor ) and since there may be more than one value for each of the variables, the system will need to output them back multiplied by all possible combinations.

Now, there are two ways to work with it, either you use that query and implement some logic to rebuild what you need, or use the following query:

PREFIX edm: <http://www.europeana.eu/schemas/edm/>

PREFIX ore: <http://www.openarchives.org/ore/terms/>

SELECT ?CHO 

WHERE {

  ?CHO edm:type "TEXT" ;

       dc:format ?format ;

       ore:proxyIn ?proxy .

FILTER (?format > "10" && ?format < "5000")

}

LIMIT 100

Which gets you the URIs for all the results and for each of them make a DESCRIBE query (or another SELECT if you need to get data from more resources than the CHO) like so:

DESCRIBE ?CHO

Hope this helps!

Best regards,

Hugo

[bpga...@gmail.com]

Dear Hugo

First of all i am really thankful to you for your reply. I am not computer or coding expert but working on a project which gives you the details of sources of old treasure books.While searching on internet i found that europeana.eu is also sharing data of all its collection. I am more concerned with book that too those books which are not available any where in the world. I found one source that is http://archive.org/ and got their database as per my requirement.Now when i reached to europeana.eu i tried all available scripts but could not get the desired results. I just need the following fields of all the books which are available in pdf format with europeana.eu

title, creator, format, date, language, mediaURL, identifier

sorted date wise or format wise

If possible please guide me in this project.

thanks

BPG

[bpga...@gmail.com]

Dear Hugo

i was trying to search a book through SPARQL but did not find the same. the book i was searching was "
Der Psalter latein vnd teutsch : trewlich verdolmetscht vnd gruntlich ausgelecht, mit Christlicher erkleru[n]g, aus Dionysio Carthusiano, vn[d] vil andern heilgen lerern versamlet. Dar bey des Alten vnd Neuwen testamentz Cantica oder geseng ausgelegt. Durch die Carthauser in Collen" this book is showing in the europeana.eu but not coming through SPARQL.

The query i run was

PREFIX edm: <http://www.europeana.eu/schemas/edm/>
PREFIX ore: <http://www.openarchives.org/ore/terms/>
SELECT ?title ?creator ?mediaURL ?date ?identifier ?format ?language ?type ?contributor
WHERE {
  ?CHO edm:type "TEXT" ;
      ore:proxyIn ?proxy;
      dc:title ?title ;
      dc:creator ?creator ;
      dc:date ?date ;
      dc:identifier ?identifier ;
      dc:format ?format ;
      dc:language ?language ;
      dc:type ?type ;
      dc:contributor ?contributor .
  ?proxy edm:isShownBy ?mediaURL .

FILTER (regex(?title, "^Der Psalter latein vnd teutsch"))
}

Please guide where i am making mistake

thanks

BPG