1 / 14

Rome Hackathon Results: Federated Query Select Sum Total by NACE, Year, Region

Analyze Rome Hackathon results & issues using federated query for sum total calculations based on NACE code, year, and region. Compare Italian and French data on arrivals per NACE code. Learn about Rome University's Ontology-Based Data Management approach and AGID's ONTOPIA projects. Explore ISPRA Environment Agency's datasets on air quality, gas emissions, biodiversity conservation, natural hazards, marine/coastal data, EU/international projects, and more.

courtneyj
Download Presentation

Rome Hackathon Results: Federated Query Select Sum Total by NACE, Year, Region

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Rome Hackathon results6-7-8 March 2019

  2. LOS Pipeline

  3. Rome Hackathon results and issues

  4. Rome Hackathon results and issues

  5. Rome Hackathon results and issues

  6. Federated Query select (sum (?val) as ?total) ?nace ?year ?reg where { { ?oss <http://purl.org/linked-data/cube#dataset> <http://ld.linked-open-statistics.org/data/fr_TOUR_ds> . ?oss <http://ld.linked-open-statistics.org/vocab/NACE> ?nace . # ?oss <http://ld.linked-open-statistics.org/vocab/ISO> ?iso . ?oss <http://ld.linked-open-statistics.org/vocab/Value> ?val . ?oss <http://ld.linked-open-statistics.org/vocab/Year> ?year . ?oss <http://ld.linked-open-statistics.org/vocab/NutsRegion> ?reg. ?oss <http://ld.linked-open-statistics.org/vocab/NutsRegion> <http://ld.linked-open-statistics.org/data/conceptscheme/NutsRegion/FR> . #FILTER (?iso = <http://ld.linked-open-statistics.org/data/conceptscheme/ISO/IT>). } union { SERVICE <http://hackathon2019.ontotext.com/repositories/hackathon2019> { ?ossi <http://purl.org/linked-data/cube#dataset> <http://ld.linked-open-statistics.org/data/it_TOUR_ds> . ?ossi <http://ld.linked-open-statistics.org/vocab/NACE> ?nace . #?oss <http://ld.linked-open-statistics.org/vocab/ISO> ?iso . ?ossi <http://ld.linked-open-statistics.org/vocab/Value> ?val . ?ossi <http://ld.linked-open-statistics.org/vocab/Year> ?year . ?ossi <http://ld.linked-open-statistics.org/vocab/NutsRegion> ?reg. ?ossi <http://ld.linked-open-statistics.org/vocab/NutsRegion> <http://ld.linked-open-statistics.org/data/conceptscheme/NutsRegion/IT> . } } } GROUP BY ?nace ?year ?reg Accessing Italian and French figures on Number of Arrivals per NACE code

  7. Other interventions: Rome University

  8. Other interventions: Rome University

  9. Other interventions: Rome University Rome University believes that Ontology-Based Data Management provides an excellent formal basis for a new, well-founded methodology for open data management

  10. Other interventions: AGID ONTOPIA AGID (Agency for Digital Italy) presented ONTOPIA <number>

  11. ONTOPIA Ontological stack <number>

  12. Data & Analytics Framework (National (Big) Data platform) Other projects of PA (e.g., ArCo, NoiPA) and private companies AGID: ONTOPIA current reuse

  13. ISPRA Environment Agency dati.isprambiente.it

  14. ISPRA Environment Agency 13 Air Quality and Gas Emission databases - not merged, - potentiallysemantically documented - potentiallyreusable and neutral with respect to the tools necessary for their reuse (including commercial),   - many of them produced and processed directly by ISPRA (including real-time data) 60 Biodiversity Conservation databases 25 Natural Hazards and Land Consumption databases 154 Databases 12 Marine and Coastal databases 24 EU/international project databases 20 Other Environmental databases

More Related