On 24/04/2021 16.48, Bob DuCharme wrote:
I agree. What would this tool do with the following?

 :s :p1 "label1a" .
 :s :p1 "label1b" .
 :s :p2 "label2" .
 :s :p3 :s2 . :s2 p1 "label3"
For the sake of visualization it could be

           :p1                            :p2        :p3/:p1
:s    "label1a","label1b"   label2    label3

I agree that there is no point to make this table other that get a quick human readable view of the contents and empty "cells", which is the case here.



For a somewhat animated version of this issue as I understand it, showing why the ability to store data that doesn't fit well into tables is one of the great advantages of RDF, see 2:38 - 3:04 of https://www.youtube.com/watch?v=FvGndkpa4K0 .

Thanks,
Bob

On 4/22/21 5:45 AM, Martynas Jusevičius wrote:
OK, I think now I get a better idea of what you want to do.

It won't work in a general case because RDF resources can have
duplicate properties but CSV shouldn't have duplicate columns.


On Thu, Apr 22, 2021 at 11:41 AM Mikael Pesonen
<mikael.peso...@lingsoft.fi> wrote:

I think that is for serializing the triplets as they are, in cleaner
format, but it doesn't say anything about rearranging the data.

On 22/04/2021 12.34, Martynas Jusevičius wrote:
This is probably what you want: https://www.w3.org/TR/sparql11-results-csv-tsv/

Try curl -H "Accept: text/csv" with SELECT results.

On Thu, Apr 22, 2021 at 11:30 AM Mikael Pesonen
<mikael.peso...@lingsoft.fi> wrote:
Hi,

not exactly Jena related, but does anyone know if there is a tool or
sparql query that would read (almost) any kind of RDF data and make a
csv sheet where each column has predicates as headers and values as
cells. It would also be nice to get linked resources into the table the same way. Even a hint how to make each predicate a new column in sparql
would be helpful.

So for example

:s :p1 "label1" .
:s :p2 "label2" .
:s :p3 :s2 . :s2 p1 "label3"

->
           :p1        :p2        :p3/:p1
:s    label2    label2    label3

Br,
Mikael

--
Lingsoft - 30 years of Leading Language Management

www.lingsoft.fi

Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books

Mikael Pesonen
System Engineer

e-mail: mikael.peso...@lingsoft.fi
Tel. +358 2 279 3300

Time zone: GMT+2

Helsinki Office
Eteläranta 10
FI-00130 Helsinki
FINLAND

Turku Office
Kauppiaskatu 5 A
FI-20100 Turku
FINLAND


--
Lingsoft - 30 years of Leading Language Management

www.lingsoft.fi

Speech Applications - Language Management - Translation - Reader's and Writer's 
Tools - Text Tools - E-books and M-books

Mikael Pesonen
System Engineer

e-mail: mikael.peso...@lingsoft.fi
Tel. +358 2 279 3300

Time zone: GMT+2

Helsinki Office
Eteläranta 10
FI-00130 Helsinki
FINLAND

Turku Office
Kauppiaskatu 5 A
FI-20100 Turku
FINLAND

Reply via email to