Mauro Michielon michimau
michimau
/ gist:4f83ee2e1b2b9821c9562b0c4fb82d46
Created
August 6, 2020 12:42
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 dcterms: <http://purl.org/dc/terms/> | |
| PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| PREFIX dct: <http://purl.org/dc/terms/> | |
| PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |
| PREFIX data: <http://www.eea.europa.eu/portal_types/Data#> | |
| PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> | |
| PREFIX ontology: <http://rdfdata.eionet.europa.eu/eea/ontology/> | |
| PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#> | |
michimau
/ AutomaticQA_70654
Last active
August 5, 2020 12:28
https://cdrtest.eionet.europa.eu/fr/eu/aqd/d/envxyp3fg/AutomaticQA_70654
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 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/> | |
| PREFIX aq: <http://reference.eionet.europa.eu/aq/ontology/> | |
| PREFIX dcterms: <http://purl.org/dc/terms/> | |
| PREfIX contreg: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| SELECT DISTINCT | |
| ?inspireLabel | |
| WHERE { |
michimau
/ AutomaticQA_70654
Created
August 5, 2020 12:22
https://cdrtest.eionet.europa.eu/fr/eu/aqd/d/envxyp3fg/AutomaticQA_70654
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 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/> | |
| PREFIX aq: <http://reference.eionet.europa.eu/aq/ontology/> | |
| PREFIX dcterms: <http://purl.org/dc/terms/> | |
| PREfIX contreg: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#> | |
| SELECT DISTINCT | |
| ?inspireLabel | |
| WHERE { |
michimau
/ gist:a67ef7e300214e99a501fc657b6fef60
Created
June 19, 2020 12:53
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
| 2020-06-19 12:53:07.279:WARN:oejw.WebAppContext:main: Failed startup of context o.e.j.w.WebAppContext@e45f292{editor-catalogue,/editor-catalogue,[file:///tmp/jetty/jetty-0_0_0_0-8080-editor-catalogue_war-_editor-catalogue-any-3354151055436081181.dir/webapp/, jar:file:///tmp/jetty/jetty-0_0_0_0-8080-editor-catalogue_war-_editor-catalogue-any-3354151055436081181.dir/webapp/WEB-INF/lib/emberjs-1.9.0-1.jar!/META-INF/resources, jar:file:///tmp/jetty/jetty-0_0_0_0-8080-editor-catalogue_war-_editor-catalogue-any-3354151055436081181.dir/webapp/WEB-INF/lib/envjs-1.2.jar!/META-INF/resources, jar:file:///tmp/jetty/jetty-0_0_0_0-8080-editor-catalogue_war-_editor-catalogue-any-3354151055436081181.dir/webapp/WEB-INF/lib/json2-20110223.jar!/META-INF/resources, jar:file:///tmp/jetty/jetty-0_0_0_0-8080-editor-catalogue_war-_editor-catalogue-any-3354151055436081181.dir/webapp/WEB-INF/lib/jquery-1.10.2-1.jar!/META-INF/resources, jar:file:///tmp/jetty/jetty-0_0_0_0-8080-editor-catalogue_war-_editor-catalogue-any-3354151055436081 |
michimau
/ gist:37d44d207216e78cc574c18bebbf14ef
Created
June 16, 2020 14:23
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
| 16-Jun-2020 14:16:54.147 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [jeeves.config.springutil.JeevesContextLoaderListener] | |
| java.lang.RuntimeException: Exception raised | |
| at jeeves.server.JeevesEngine.handleStartupError(JeevesEngine.java:108) | |
| at jeeves.config.springutil.JeevesContextLoaderListener.contextInitialized(JeevesContextLoaderListener.java:88) | |
| at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4770) | |
| at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5236) | |
| at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) | |
| at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) | |
| at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) | |
| at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:744) |
michimau
/ gist:c397fe394c151a3f87163f31c7458e8a
Created
June 16, 2020 08:44
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
| version: '2' | |
| volumes: | |
| sdi-esdata1: | |
| external: true | |
| driver: rancher-nfs | |
| sdi-esdata: | |
| external: true | |
| driver: rancher-nfs | |
| services: |
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/> |
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
/ 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
/ -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 |