Incorrect format for dbpedia-owl:productionStartYear and productionEndYear values

[knudmoeller]

In DBpedia 3.9, values of dbpedia-owl:productionStartYear and productionEndYear (for automobile infoboxes) have the xsd:gYear datatype. That is as expected.

However, the actual value literals are ISO8601-formatted, which is wrong.

The following query illustrates this:

PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?s ?date 
WHERE {
  ?s dbpedia-owl:productionStartYear ?date .
}
LIMIT 100

The results have the following incorrect format:

"1961-01-01T00:00:00+02:00"^^xsd:gYear

The correct format would be:

"1961"^^xsd:gYear

[ninniuz]

I think this is a problem with Virtuoso, because:

1. the mapping server shows the correct format
   http://mappings.dbpedia.org/server/extraction/en/extract?title=Shin_Meiwa_US-1A&revid=&format=n-triples
2. same happens when reading the raw triples from DBpedia 3.9
   http://dbpedia.org/resource/Shin_Meiwa_US-1A http://dbpedia.org/ontology/productionStartYear "0001"^^http://www.w3.org/2001/XMLSchema#gYear .

[jimkont]

This is a 2+ year old bug in virtuoso
http://www.mail-archive.com/search?q=gyear&l=dbpedia-discussion%40lists.sourceforge.net

On Mon, Jan 20, 2014 at 7:03 PM, Andrea Di Menna
notifications@github.comwrote:

I think this is a problem with Virtuoso, because:

1. the mapping server shows the correct format

http://mappings.dbpedia.org/server/extraction/en/extract?title=Shin_Meiwa_US-1A&revid=&format=n-triples
2) same happens when reading the raw triples from DBpedia 3.9
http://dbpedia.org/resource/Shin_Meiwa_US-1A
http://dbpedia.org/ontology/productionStartYear "0001"^^
http://www.w3.org/2001/XMLSchema#gYear .

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/154#issuecomment-32777499
.

Kontokostas Dimitris

[knudmoeller]

Thanks, you're right of course. Just as a little add-on, here is my work-around to still get the correct year values from Virtuoso:

PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>

SELECT DISTINCT ?s ?year 
WHERE {
  ?s dbpedia-owl:productionStartYear ?date .
  BIND(YEAR(?date) AS ?year)
}
LIMIT 100

(Of course, all of the results in this query are still wrong with respect to reality - but that's obviously due to the fact that the infobox templates were incorrectly used by the Wikipedia editors)