Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fetch complete dataset graphs #9

Open
adibaba opened this issue Jan 28, 2020 · 4 comments
Open

Fetch complete dataset graphs #9

adibaba opened this issue Jan 28, 2020 · 4 comments

Comments

@adibaba
Copy link
Member

adibaba commented Jan 28, 2020

Please ensure that a complete graph of a dataset is fetched.

E.g. the code below would not include a o3:

?dataSet ?predicate ?object
?object ?p2 ?o2
?o2 ?p3 ?o3

        ParameterizedSparqlString pss = new ParameterizedSparqlString("" +
                "PREFIX dcat: <http://www.w3.org/ns/dcat#> " +
                "PREFIX dct: <http://purl.org/dc/terms/> " +
                "CONSTRUCT { " + "?dataSet ?predicate ?object . " +
                "?object ?p2 ?o2} " +
                "WHERE { " +
                ( this.queryWithGraph ? "  GRAPH ?g { " : "") +
                "    ?dataSet ?predicate ?object. " +
                "    OPTIONAL { ?object ?p2 ?o2 } " +
                ( this.queryWithGraph ?  "} " : "") +
                "}");

https://github.com/projekt-opal/converter/blob/developer/dataset-fetcher/src/main/java/org/diceresearch/datasetfetcher/utility/DataSetFetcher.java#L231

@mnafshin
Copy link
Collaborator

Do we have a situation for graph of depth 3 ( i.e. ?p3 ?O3) ?

@adibaba
Copy link
Member Author

adibaba commented Jan 28, 2020

Yes, it seems like the EDP data contains such constructs.

@adibaba
Copy link
Member Author

adibaba commented Jan 29, 2020

PREFIX dcat: <http://www.w3.org/ns/dcat#>

CONSTRUCT {
  ?d ?p ?x1 .
  ?x1 ?p2 ?x2 .
  ?x2 ?p3 ?x3 .
}
WHERE {
  ?d a dcat:Dataset .
  ?d ?p ?x1 .
  ?x1 ?p2 ?x2 .
  ?x2 ?p3 ?x3 .
  VALUES ?d {
    <https://europeandataportal.eu/set/data/7768d4e3-302c-11e3-beb4-0000c1ab0db6>
  }
}
LIMIT 100
@prefix dcat:  <http://www.w3.org/ns/dcat#> .

<https://europeandataportal.eu/set/distribution/1f66dc56-ea03-4058-a901-2a43ba1abc29>
        dcat:accessURL  <https://www.statistik.at/gs-inspire/VIEW_SU_SUG_ETRS89-LAEA_1K/ows?service=wms&version=1.3.0&request=GetCapabilities> .

<https://www.statistik.at/gs-inspire/VIEW_SU_SUG_ETRS89-LAEA_1K/ows?service=wms&version=1.3.0&request=GetCapabilities>
        a       <http://xmlns.com/foaf/0.1/Document> ;
        <http://purl.org/dc/terms/description>
                "Darstellungsdienst"@de ;
        <http://purl.org/dc/terms/title>
                "SU.StatisticalGridCell"@de .

<https://europeandataportal.eu/set/data/7768d4e3-302c-11e3-beb4-0000c1ab0db6>
        dcat:distribution  <https://europeandataportal.eu/set/distribution/1f66dc56-ea03-4058-a901-2a43ba1abc29> .

example from
opaldata dataset.html?tab=query&ds=/2019-12-17-edp-de

@adibaba
Copy link
Member Author

adibaba commented Jan 29, 2020

Some more dataset URIs

PREFIX dcat: <http://www.w3.org/ns/dcat#>

SELECT ?d
WHERE {
  ?d a dcat:Dataset .
  ?d ?p ?x1 .
  ?x1 ?p2 ?x2 .
  ?x2 ?p3 ?x3 .
#  ?x3 ?p4 ?x4 .
}
LIMIT 50

d

1 | https://europeandataportal.eu/set/data/2b288eaf-fa1f-4fb9-a4b2-9e23a8d5e4dc
2 | https://europeandataportal.eu/set/data/24e938e8-d4b1-4349-8260-e185783c3a0e
3 | https://europeandataportal.eu/set/data/5dadbe04-b41e-41a4-bac4-48e29b3e178a
4 | https://europeandataportal.eu/set/data/091aa0f9-3bf5-4b65-a637-ad8f1b528c34
5 | https://europeandataportal.eu/set/data/e96172af-ee5c-434b-9099-8bb0d5fd6164
6 | https://europeandataportal.eu/set/data/34d4d9f9-d480-4b6c-bbeb-9d657d7cc752
7 | https://europeandataportal.eu/set/data/a23b533b-0f12-4e90-b6da-8e867614a947
8 | https://europeandataportal.eu/set/data/694b1019-6c72-3d25-a12a-f4d528a89750
9 | https://europeandataportal.eu/set/data/7768d4e3-302c-11e3-beb4-0000c1ab0db6
10 | https://europeandataportal.eu/set/data/7768d4e3-302c-11e3-beb4-0000c1ab0db6
11 | https://europeandataportal.eu/set/data/7768d4e3-302c-11e3-beb4-0000c1ab0db6
12 | https://europeandataportal.eu/set/data/7768fbbd-302c-11e3-beb4-0000c1ab0db6
13 | https://europeandataportal.eu/set/data/7768fbbd-302c-11e3-beb4-0000c1ab0db6
14 | https://europeandataportal.eu/set/data/7768fbbd-302c-11e3-beb4-0000c1ab0db6
15 | https://europeandataportal.eu/set/data/7768fbb7-302c-11e3-beb4-0000c1ab0db6
16 | https://europeandataportal.eu/set/data/7768fbb7-302c-11e3-beb4-0000c1ab0db6
17 | https://europeandataportal.eu/set/data/7768fbb7-302c-11e3-beb4-0000c1ab0db6
18 | https://europeandataportal.eu/set/data/7768fbc9-302c-11e3-beb4-0000c1ab0db6
19 | https://europeandataportal.eu/set/data/7768fbc9-302c-11e3-beb4-0000c1ab0db6
20 | https://europeandataportal.eu/set/data/7768fbc9-302c-11e3-beb4-0000c1ab0db6
21 | https://europeandataportal.eu/set/data/7768fbc3-302c-11e3-beb4-0000c1ab0db6
22 | https://europeandataportal.eu/set/data/7768fbc3-302c-11e3-beb4-0000c1ab0db6
23 | https://europeandataportal.eu/set/data/7768fbc3-302c-11e3-beb4-0000c1ab0db6
24 | https://europeandataportal.eu/set/data/7768fbe1-302c-11e3-beb4-0000c1ab0db6
25 | https://europeandataportal.eu/set/data/7768fbe1-302c-11e3-beb4-0000c1ab0db6
26 | https://europeandataportal.eu/set/data/7768fbe1-302c-11e3-beb4-0000c1ab0db6
27 | https://europeandataportal.eu/set/data/9b928d5d-6590-4feb-9551-c0d598f8098b
28 | https://europeandataportal.eu/set/data/d1d19d10-ee93-42ab-a77b-c5644f546181
29 | https://europeandataportal.eu/set/data/a1700ee0-a304-414d-bf30-23b82c6ad481
30 | https://europeandataportal.eu/set/data/bfc4008a-88fa-4757-8083-6e3e3e176b01
31 | https://europeandataportal.eu/set/data/b5e866b9-6314-40c2-8543-0489e5fb38cf
32 | https://europeandataportal.eu/set/data/2d257a0e-3992-4d02-a568-c769976aba81
33 | https://europeandataportal.eu/set/data/bd80f092-622a-42da-a0dc-8a4a79f53d7f
34 | https://europeandataportal.eu/set/data/063e40e3-3c76-44b2-b52b-3f01a814f6b5
35 | https://europeandataportal.eu/set/data/7083de07-669c-4063-a512-d197ab84790a
36 | https://europeandataportal.eu/set/data/a0e6a625-9b4c-45fb-809a-6277417e0769
37 | https://europeandataportal.eu/set/data/cc2f7705-0019-4c0b-9ce6-e0ad299bf193
38 | https://europeandataportal.eu/set/data/5304f3fd-f205-4d3e-ae65-44561b16d99f
39 | https://europeandataportal.eu/set/data/64e01045-18a3-45f0-81e0-78370f371a09
40 | https://europeandataportal.eu/set/data/c5765c3d-896b-410a-b2e5-973c5e0aab39
41 | https://europeandataportal.eu/set/data/0e15a00b-d618-485e-88e4-c7f3991dfa9b
42 | https://europeandataportal.eu/set/data/15274c1c-6294-4e32-b69f-f45db5abf4a0
43 | https://europeandataportal.eu/set/data/1ddea4a3-39c6-461e-931f-6d2ee720d634
44 | https://europeandataportal.eu/set/data/31bd5b0b-6679-4851-adb2-b4cec37e53ac
45 | https://europeandataportal.eu/set/data/6d746f2c-ce5a-4e8f-ae49-d22f98832950
46 | https://europeandataportal.eu/set/data/2e1a510e-a107-4a5c-a947-f64ec2e08f57
47 | https://europeandataportal.eu/set/data/7e580634-9989-4c17-b8d1-07cc3a9cf4b1
48 | https://europeandataportal.eu/set/data/9ccd85de-5481-11e9-92c2-482ae30f98d9
49 | https://europeandataportal.eu/set/data/9ccd85de-5481-11e9-92c2-482ae30f98d9
50 | https://europeandataportal.eu/set/data/9ccd85de-5481-11e9-92c2-482ae30f98d9

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants