ULAN query doesn't return full number of avaliable records

29 views

Skip to first unread message

art market

unread,

Oct 22, 2021, 10:33:48 AM10/22/21

to Getty Vocabularies as Linked Open Data

Dear Members,

when i run the following query and save results in .csv, I don't get all records available in the database, for example record http://vocab.getty.edu/page/ulan/500003600

should be there, while it is not!

My goal is to extract All artists, their gender, lifedates(birth/death).

The query is the following

select ?x ?name ?bio ?nationality ?type ?gender ?birth ?death {

?x gvp:broaderExtended ulan:500000002. # Persons, Artists

optional {?x gvp:agentTypePreferred [gvp:prefLabelGVP [xl:literalForm ?type]]}

optional {?x foaf:focus [gvp:nationalityPreferred [gvp:prefLabelGVP [xl:literalForm ?nationality]]]}

optional {?x gvp:prefLabelGVP [xl:literalForm ?name]}

optional {?x foaf:focus [gvp:biographyPreferred [schema:description ?bio]]}

optional {?x foaf:focus [gvp:biographyPreferred [schema:gender ?gender]]}

optional {?x foaf:focus [gvp:biographyPreferred [gvp:estStart ?birth]]}

optional {?x foaf:focus [gvp:biographyPreferred [gvp:estEnd ?death]]}

}

Thank you for help

Kind regards,

Elena

Vladimir Alexiev

unread,

Jul 27, 2022, 3:52:31 AM7/27/22

to Getty Vocabularies as Linked Open Data

Hi Elena! Your query can be sped up a bit by merging some of the paths like this:

optional {

?x foaf:focus [gvp:biographyPreferred ?bio
optional {?bio gvp:estStart ?birth}
optional {?bio gvp:estEnd ?death}

}

However, I think that's just too much data: 245k rows, see

select (count(*) as ?c) {
?x gvp:broaderExtended ulan:500000002
}

Is it an option for you to load to a local repository? Eg you can use GraphDB Free.