Mauro Michielon michimau
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "title","uuid","createdate" | |
| "Annual above ground vegetation productivity time-series, version 1, Aug. 2018","29ae2d47-7af2-4c09-ba5f-e2fbb7c2b0d1","2019-12-03T16:16:53" | |
| "Annual above ground vegetation season length time-series 2000-2016 - version 1, Aug. 2018","1be91ed4-2eb1-46d6-8453-5246c9e9d446","2019-12-04T16:58:59" | |
| "Annual start of vegetation growing season time-series 2000-2016, version 1, Mar. 2019",f4b01c76-29f7-4075-b13f-5dc5a9c18ae2,"2019-12-16T12:22:28" | |
| "Assessment of contaminant status of indicators of biological effects using CHASE+, Dec. 2019","49eb412e-3002-492c-8323-ab5cac07fc40","2020-01-09T07:39:50" | |
| "Assessment of contamination status of biota using CHASE+, Mar. 2019",dfe9061b-84ad-4ef1-ba83-519ab61ebb40,"2020-01-09T13:25:38" | |
| "Assessment of contamination status of seawater using CHASE+, Mar. 2019",e542e9a1-715a-48e2-8c6c-d8a30541ca93,"2020-01-09T12:50:36" | |
| "Assessment of contamination status of sediments using CHASE+, Mar. 2019",cd87cd22-0a6f-499b-9e27-9691e6e46030,"2020-01-09T12:14:34" | |
| "Asse |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | |
| PREFIX dcterms: <http://purl.org/dc/terms/> | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| PREFIX aq: <http://rdfdata.eionet.europa.eu/airquality/ontology/> | |
| PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#> | |
| PREFIX obligations: <http://rod.eionet.europa.eu/obligations/> | |
| PREFIX aqdd: <http://dd.eionet.europa.eu/property/> | |
| SELECT DISTINCT |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | |
| PREFIX dcterms: <http://purl.org/dc/terms/> | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| PREFIX aq: <http://rdfdata.eionet.europa.eu/airquality/ontology/> | |
| PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#> | |
| PREFIX obligations: <http://rod.eionet.europa.eu/obligations/> | |
| PREFIX aqdd: <http://dd.eionet.europa.eu/property/> | |
| SELECT DISTINCT |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | |
| PREFIX dcterms: <http://purl.org/dc/terms/> | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| PREFIX aq: <http://rdfdata.eionet.europa.eu/airquality/ontology/> | |
| PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#> | |
| PREFIX obligations: <http://rod.eionet.europa.eu/obligations/> | |
| PREFIX aqdd: <http://dd.eionet.europa.eu/property/> | |
| SELECT DISTINCT |
michimau
/ eunis sscientificName and hasSynonym
Last active
May 11, 2020 10:10
eunis sscientificName ad hasSynonym
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PREFIX species-schema: <http://eunis.eea.europa.eu/rdf/species-schema.rdf#> | |
| PREFIX tdwg-terms: <http://rs.tdwg.org/dwc/terms/> | |
| SELECT DISTINCT | |
| ?id as ?uri | |
| str(?id) AS ?id | |
| LCASE(?scientificName) AS ?scientificName | |
| bif:replace(LCASE(?scientificName), " ", "_") AS ?folder_name | |
| LCASE(?sscientificName) AS ?hasSynonym | |
| WHERE {{ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 5/18/2020 3:56:58 PM[2020-05-18 13:56:58.418] - DEBUG --- eionet.cr.harvest.scheduled.UrgentHarvestQueue : Pull harvest added to the urgent queue, url = http://www.eea.europa.eu/data-and-maps/data/lcp-9 - (UrgentHarvestQueue.java:108) | |
| 5/18/2020 3:57:05 PM[2020-05-18 13:57:05.987] - DEBUG --- eionet.cr.harvest.BaseHarvest : - (BaseHarvest.java:289) | |
| 5/18/2020 3:57:05 PM[2020-05-18 13:57:05.987] - INFO --- eionet.cr.harvest.BaseHarvest : Starting harvest [http://www.eea.europa.eu/data-and-maps/data/lcp-9] - (BaseHarvest.java:290) | |
| 5/18/2020 3:57:06 PM[2020-05-18 13:57:06.014] - DEBUG --- eionet.cr.harvest.PullHarvest : Connecting http://www.eea.europa.eu/data-and-maps/data/lcp-9 [http://www.eea.europa.eu/data-and-maps/data/lcp-9] - (PullHarvest.java:321) | |
| 5/18/2020 3:57:06 PM[2020-05-18 13:57:06.019] - |
michimau
/ -2141781932
Created
May 20, 2020 11:52
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select * from CR.cr3user.harvest where harvest_source_id = -2141781932 | |
| Query result: | |
| harvest_id | |
| INTEGER harvest_source_id | |
| INTEGER type | |
| VARCHAR username | |
| VARCHAR status | |
| VARCHAR started |
michimau
/ at least one harvest failure
Last active
May 21, 2020 07:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT hs.harvest_source_id, url, MAX(h.harvest_id) AS harvest_id, MAX(started) AS started | |
| FROM CR.cr3user.harvest AS h, CR.cr3user.harvest_source AS hs | |
| WHERE h.harvest_source_id = hs.harvest_source_id AND status = 'started' | |
| |=----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------------------=| | |
| |harvest_source_id|url |harvest_id|started | | |
| |=----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------------------=| | |
| |-2141793209 |http://cdr.eionet.europa.eu/de/eu/aqd/c/envvhw_xw/DE_C_AssessmentRegime_2013.xml |
michimau
/ query:getSamplingPoint($cdrUrl as xs:string)
Created
June 2, 2020 14:04
query:getSamplingPoint($cdrUrl as xs:string)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #https://svn.eionet.europa.eu/repositories/Reportnet/AirQuality/trunk/xqueries/aqd-query.xquery | |
| from: | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| PREFIX aqd: <http://rdfdata.eionet.europa.eu/airquality/ontology/> | |
| SELECT ?localId ?inspireLabel | |
| WHERE { | |
| ?samplingPoint a aqd:AQD_SamplingPoint; |
michimau
/ query:getG14
Created
June 2, 2020 18:46
https://svn.eionet.europa.eu/repositories/Reportnet/AirQuality/trunk/xqueries/aqd-query.xquery - query:getG14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #create tew separate queries: | |
| #countOnB | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX aq: <http://reference.eionet.europa.eu/aq/ontology/> | |
| PREFIX aqd: <http://rdfdata.eionet.europa.eu/airquality/ontology/> | |
| PREFIX prop: <http://dd.eionet.europa.eu/property/> | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| PREFIX aqd: <http://rdfdata.eionet.europa.eu/airquality/ontology/> |