Quality Assessment and Monitoring of 280 Open Data Portals
SPARQL Endpoint
Access the DCAT metadata desciptions and their respective quality assessments via a SPARQL endpoint.
The endpoint API is located at https://data.wu.ac.at/sparql/.
Available Graphs
The following versions (i.e. snapshots) of the datasets are available as named graphs:
- https://data.wu.ac.at/portalwatch/ld/2040
- https://data.wu.ac.at/portalwatch/ld/2002
- https://data.wu.ac.at/portalwatch/ld/2001
- https://data.wu.ac.at/portalwatch/ld/1940
- https://data.wu.ac.at/portalwatch/ld/1937
- https://data.wu.ac.at/portalwatch/ld/1935
- https://data.wu.ac.at/portalwatch/ld/1934
- https://data.wu.ac.at/portalwatch/ld/1851
- https://data.wu.ac.at/portalwatch/ld/1849
- https://data.wu.ac.at/portalwatch/ld/1841
- https://data.wu.ac.at/portalwatch/ld/1839
- https://data.wu.ac.at/portalwatch/ld/1836
- https://data.wu.ac.at/portalwatch/ld/1832
- https://data.wu.ac.at/portalwatch/ld/1830
- https://data.wu.ac.at/portalwatch/ld/1821
- https://data.wu.ac.at/portalwatch/ld/1820
- https://data.wu.ac.at/portalwatch/ld/1812
- https://data.wu.ac.at/portalwatch/ld/1811
- https://data.wu.ac.at/portalwatch/ld/1808
- https://data.wu.ac.at/portalwatch/ld/1801
- https://data.wu.ac.at/portalwatch/ld/1751
- https://data.wu.ac.at/portalwatch/ld/1742
- https://data.wu.ac.at/portalwatch/ld/1731
- https://data.wu.ac.at/portalwatch/ld/1721
- https://data.wu.ac.at/portalwatch/ld/1711
- https://data.wu.ac.at/portalwatch/ld/1710
- https://data.wu.ac.at/portalwatch/ld/1701
- https://data.wu.ac.at/portalwatch/ld/1652
- https://data.wu.ac.at/portalwatch/ld/1650
- https://data.wu.ac.at/portalwatch/ld/1648
- https://data.wu.ac.at/portalwatch/ld/1641
- https://data.wu.ac.at/portalwatch/ld/1640
- https://data.wu.ac.at/portalwatch/ld/1638
- https://data.wu.ac.at/portalwatch/ld/1636
- https://data.wu.ac.at/portalwatch/ld/1631
- https://data.wu.ac.at/portalwatch/ld/1630
- https://data.wu.ac.at/portalwatch/ld/1627
- https://data.wu.ac.at/portalwatch/ld/1626
- https://data.wu.ac.at/portalwatch/ld/1624
Example Queries
Get the list of portals and respective number of datasets for a snapshot:
select ?activity ?start ?end ?portal count(?d) as ?datasets from <https://data.wu.ac.at/portalwatch/ld/1935> where { ?activity odpw:fetched ?portal ; prov:startedAtTime ?start ; prov:endedAtTime ?end . ?portal dcat:dataset ?d . } group by ?activity ?start ?end ?portal order by desc(?datasets)
Select all portals that describe transportation data, i.e., portals holding datasets that use "transportation" as a keyword:
select distinct(?p) from <https://data.wu.ac.at/portalwatch/ld/1935> where { ?p dcat:dataset ?d. ?d a dcat:Dataset. ?d dcat:keyword "transportation". }
List all organizations at the Austrian data portal data.gv.at and the average availability of contact email addresses in the dataset descriptions:
select ?orga sum(?v)/count(?v) as ?emailmetric from <https://data.wu.ac.at/portalwatch/ld/1935> where { <http://data.gv.at> dcat:dataset ?d . ?d dct:publisher ?o . ?o foaf:name ?orga . ?d dqv:hasQualityMeasurement ?m . ?m dqv:isMeasurementOf pwq:ContactEmail . ?m dqv:value ?v . } group by ?orga
Namespaces
PREFIX odpw: <http://data.wu.ac.at/ns/odpw#> PREFIX pwq: <https://data.wu.ac.at/portalwatch/quality#> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX dqv: <http://www.w3.org/ns/dqv#> PREFIX prov: <http://www.w3.org/ns/prov#> PREFIX csvw: <http://www.w3.org/ns/csvw#>