# git clone
mvn clean compile package -q -e
java -jar ./target/TreeTableTsvFx-0.1-shaded.jar --help

Examples (bash)

Get children of Genghis Khan

read -r -d '' sparql <<'EOF'
PREFIX gas: <http://www.bigdata.com/rdf/gas#>

SELECT ?item ?itemLabel (SAMPLE(YEAR(?birthDate)) AS ?birthYear) (SAMPLE(YEAR(?deathDate)) AS ?deathYear) ?links ?parentId
WHERE {
  SERVICE gas:service {
    gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ;
                gas:in wd:Q720 ;
                gas:traversalDirection "Forward" ;
                gas:out ?item ;
                gas:out1 ?depth ;
                gas:out2 ?parentId ;  # Capture the parent ID
                gas:maxIterations 4 ;
                gas:linkType wdt:P40 .
  }
  OPTIONAL { ?item wdt:P569 ?birthDate. }
  OPTIONAL { ?item wdt:P570 ?deathDate. }
  OPTIONAL { ?item wikibase:sitelinks ?links. }
  #OPTIONAL { ?item wdt:P40 ?linkTo }
  #OPTIONAL { ?item wdt:P18 ?pic }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "mul,en" }
}
GROUP BY ?item ?itemLabel ?links ?parentId
EOF

curl -X POST -H "Content-Type: application/sparql-query" -H "Accept: text/csv" --data "$sparql" https://query.wikidata.org/sparql | java -jar target/TreeTableTsvFx-0.1-shaded.jar , -

Create and open CSV:

read -r -d '' csv <<'EOF'
id,name,parentId
1,root,
2,child,1
3,alsoChild,1
4,grandChild,2
5,alsoGrandChild,2
6,anotherRootForNoReason,
7,childWithDanglingParentId,999
EOF
echo -e "$csv" > data.csv
java -jar target/TreeTableTsvFx-0.1-shaded.jar , data.csv

Examples (powershell)

Get descendants of a person from Wikidata

$sparql = @'
#defaultView:Graph
# Descendants of a person
PREFIX gas: <http://www.bigdata.com/rdf/gas#>

SELECT ?item ?itemLabel (SAMPLE(YEAR(?birthDate)) AS ?birthYear) (SAMPLE(YEAR(?deathDate)) AS ?deathYear) ?links ?parent
WHERE {
  SERVICE gas:service {
    gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ;
                gas:in wd:Q9439 ; # Q9439=Victoria Q130734=NicholasI
                gas:traversalDirection "Forward" ;
                gas:out ?item ;
                gas:out1 ?depth ;
                gas:out2 ?parent ;
                gas:maxIterations 4 ;   # Depth
                gas:linkType wdt:P40 .
  }
  OPTIONAL { ?item wdt:P569 ?birthDate. }
  OPTIONAL { ?item wdt:P570 ?deathDate. }
  OPTIONAL { ?item wikibase:sitelinks ?links. }
  #OPTIONAL { ?item wdt:P40 ?linkTo }
  #OPTIONAL { ?item wdt:P18 ?pic }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "mul,en,ru" }
}
GROUP BY ?item ?itemLabel ?links ?parent
'@
Invoke-RestMethod -Uri https://query.wikidata.org/sparql -Body @{query=$sparql} -Headers @{
#   "Content-Type" = "application/sparql-query"
   "Accept" = "text/csv"
} | ConvertFrom-Csv | 
    ConvertTo-Csv -Delimiter "`t" -UseQuotes Never | 
    java -jar .\target\TreeTableTsvFx-0.1-shaded.jar `t --column-types=url,string,double,double,double,url -