Sorry

This feed does not validate.

In addition, interoperability with the widest range of feed readers could be improved by implementing the following recommendations.

Source: http://www.aukema.org/feeds/posts/default?alt=rss

  1. <?xml version='1.0' encoding='UTF-8'?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-8612861483458237611</atom:id><lastBuildDate>Sun, 10 Mar 2024 02:46:57 +0000</lastBuildDate><category>botswana</category><category>NOx</category><category>RIVM</category><category>Microsoft</category><category>Namibia</category><category>Tableau Software</category><category>Benchmarks</category><category>CBS</category><category>DNA</category><category>Emissie</category><category>Festool</category><category>IBM</category><category>Killer Apps</category><category>Lotus Notes</category><category>Lotusphere</category><category>Moremi</category><category>Network Bandwidth</category><category>PostgreSQL</category><category>Safari</category><category>Stikstof</category><category>TNO</category><category>zimbabwe</category><category>ATM</category><category>Albert Heijn</category><category>Apple TV</category><category>Aviation</category><category>Blackberry</category><category>Boeren</category><category>Books</category><category>Branding</category><category>Client Clock</category><category>Cloud</category><category>Compete</category><category>Database Storage</category><category>Domino</category><category>EMC</category><category>End User Demand</category><category>Exact Software</category><category>HCL</category><category>HealthCare</category><category>IBM Lotus Notes and Domino</category><category>ID105</category><category>Kasane</category><category>Landrover</category><category>Lotus</category><category>Lotus Notes Applications</category><category>LotusLive</category><category>Lotusscript Classes</category><category>Macbook</category><category>Mail Files</category><category>Marketing</category><category>Message Size</category><category>NH3</category><category>Network Sizing</category><category>Notes</category><category>OSX</category><category>Okavango</category><category>Open-Data</category><category>Performance</category><category>PgAdmin</category><category>Photo Streaming</category><category>Power7</category><category>RTL</category><category>RightFax</category><category>SQL</category><category>Sametime</category><category>Server Consolidation</category><category>Slide Show</category><category>Source Code</category><category>SourceOne</category><category>Symantec</category><category>Systainer</category><category>TCO</category><category>Tableau</category><category>Third Bridge</category><category>Vektis</category><category>Victoria Falls</category><category>Vpro koniginnedag queensday</category><category>Workspace</category><category>dashboard</category><category>emailXtender</category><category>maun</category><category>pg_dump postgresql</category><category>self-drive</category><category>statline cbs nos</category><category>sunspot</category><category>toteng</category><title>Wouter Aukema</title><description>Sees data and patterns where others don&#39;t</description><link>http://www.aukema.org/</link><managingEditor>noreply@blogger.com (Wouter Aukema)</managingEditor><generator>Blogger</generator><openSearch:totalResults>79</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-1162542427017724448</guid><pubDate>Fri, 25 Jun 2021 04:44:00 +0000</pubDate><atom:updated>2021-06-25T06:44:43.658+02:00</atom:updated><title>Loading VAERS data into Postgres</title><description>&lt;p&gt;For those who want to load VAERS data into Postgres, here&#39;s how I did it.&lt;/p&gt;&lt;p&gt;In case you have technical questions -&amp;gt; twitter: @waukema.&amp;nbsp;&lt;/p&gt;&lt;p&gt;/*&lt;/p&gt;&lt;p&gt;DROP TABLE vaers.symptoms;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;CREATE TABLE vaers.symptoms&lt;/p&gt;&lt;p&gt;(&lt;/p&gt;&lt;p&gt;&amp;nbsp; id serial NOT NULL,&lt;/p&gt;&lt;p&gt;&amp;nbsp; vaers_id char(7),&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptom1 character varying,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptomversion1 numeric,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptom2 character varying,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptomversion2 numeric,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptom3 character varying,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptomversion3 numeric,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptom4 character varying,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptomversion4 numeric,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptom5 character varying,&lt;/p&gt;&lt;p&gt;&amp;nbsp; symptomversion5 numeric&lt;/p&gt;&lt;p&gt;)&lt;/p&gt;&lt;p&gt;WITH (&lt;/p&gt;&lt;p&gt;&amp;nbsp; OIDS=FALSE&lt;/p&gt;&lt;p&gt;);&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;--msdos windows server 2008 postgres 9.3 using gnuwin32 utils:&lt;/p&gt;&lt;p&gt;--cat 2021VAERSSYMPTOMS.csv|psql -h localhost -d postgres -a -c &quot;set client_encoding=latin1; copy vaers.symptoms (VAERS_ID, SYMPTOM1, SYMPTOMVERSION1, SYMPTOM2, SYMPTOMVERSION2, SYMPTOM3, SYMPTOMVERSION3, SYMPTOM4, SYMPTOMVERSION4, SYMPTOM5, SYMPTOMVERSION5) from stdin delimiter &#39;,&#39; CSV HEADER&quot;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;create table vaers.allsymptoms as&lt;/p&gt;&lt;p&gt;(&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers_id,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom1 as symptom,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptomversion1 as symptomversion&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.symptoms&lt;/p&gt;&lt;p&gt;where&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom1 is not null&lt;/p&gt;&lt;p&gt;union all&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers_id,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom2 as symptom,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptomversion2 as symptomversion&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.symptoms&lt;/p&gt;&lt;p&gt;where&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom2 is not null&lt;/p&gt;&lt;p&gt;union all&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers_id,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom3 as symptom,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptomversion3 as symptomversion&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.symptoms&lt;/p&gt;&lt;p&gt;where&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom3 is not null&lt;/p&gt;&lt;p&gt;union all&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers_id,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom4 as symptom,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptomversion4 as symptomversion&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.symptoms&lt;/p&gt;&lt;p&gt;where&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom4 is not null&lt;/p&gt;&lt;p&gt;union all&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers_id,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom5 as symptom,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptomversion5 as symptomversion&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.symptoms&lt;/p&gt;&lt;p&gt;where&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;symptom5 is not null&lt;/p&gt;&lt;p&gt;);&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;create index ix_allsymptoms_vaers_id on vaers.allsymptoms using btree (vaers_id);&lt;/p&gt;&lt;p&gt;create index ix_allsymptoms_symptom on vaers.allsymptoms using btree (symptom);&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;drop table vaers.vax ;&lt;/p&gt;&lt;p&gt;create table vaers.vax&amp;nbsp;&lt;/p&gt;&lt;p&gt;(&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;id serial,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAERS_ID varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_TYPE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_MANU varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_LOT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_DOSE_SERIES varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_ROUTE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_SITE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_NAME varchar&lt;/p&gt;&lt;p&gt;)&lt;/p&gt;&lt;p&gt;WITH (&lt;/p&gt;&lt;p&gt;&amp;nbsp; OIDS=FALSE&lt;/p&gt;&lt;p&gt;);&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;--msdos postgres 9.3&lt;/p&gt;&lt;p&gt;--cat 2021VAERSSYMPTOMS.csv|psql -h localhost -d postgres -a -c &quot;set client_encoding=latin1; copy vaers.symptoms (VAERS_ID, SYMPTOM1, SYMPTOMVERSION1, SYMPTOM2, SYMPTOMVERSION2, SYMPTOM3, SYMPTOMVERSION3, SYMPTOM4, SYMPTOMVERSION4, SYMPTOM5, SYMPTOMVERSION5) from stdin delimiter &#39;,&#39; CSV HEADER&quot;&lt;/p&gt;&lt;p&gt;--cat 2021VAERSVAX.csv|psql -h localhost -d postgres -a -c &quot;copy vaers.vax (VAERS_ID, VAX_TYPE, VAX_MANU, VAX_LOT, VAX_DOSE_SERIES, VAX_ROUTE, VAX_SITE, VAX_NAME) from stdin delimiter &#39;,&#39; CSV HEADER&quot;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;create index ix_vax_vaers_id on vaers.vax using btree (vaers_id);&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;drop table if exists vaers.data;&lt;/p&gt;&lt;p&gt;create table vaers.data&lt;/p&gt;&lt;p&gt;(&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;id serial,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAERS_ID varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;RECVDATE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;STATE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;AGE_YRS varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;CAGE_YR varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;CAGE_MO varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;SEX varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;RPT_DATE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;SYMPTOM_TEXT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;DIED varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;DATEDIED varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;L_THREAT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ER_VISIT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;HOSPITAL varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;HOSPDAYS varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;X_STAY varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;DISABLE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;RECOVD varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_DATE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ONSET_DATE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;NUMDAYS varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;LAB_DATA varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;V_ADMINBY varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;V_FUNDBY varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;OTHER_MEDS varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;CUR_ILL varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;HISTORY varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;PRIOR_VAX varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;SPLTTYPE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;FORM_VERS varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;TODAYS_DATE varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;BIRTH_DEFECT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;OFC_VISIT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ER_ED_VISIT varchar,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ALLERGIES varchar&lt;/p&gt;&lt;p&gt;)&lt;/p&gt;&lt;p&gt;WITH (&lt;/p&gt;&lt;p&gt;&amp;nbsp; OIDS=FALSE&lt;/p&gt;&lt;p&gt;);&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;--msdos postgres 9.3&lt;/p&gt;&lt;p&gt;--cat 2021VAERSDATA.csv|psql -h localhost -d postgres -a -c &quot;set client_encoding=latin1; copy vaers.data (VAERS_ID,RECVDATE,STATE,AGE_YRS,CAGE_YR,CAGE_MO,SEX,RPT_DATE,SYMPTOM_TEXT,DIED,DATEDIED,L_THREAT,ER_VISIT,HOSPITAL,HOSPDAYS,X_STAY,DISABLE,RECOVD,VAX_DATE,ONSET_DATE,NUMDAYS,LAB_DATA,V_ADMINBY,V_FUNDBY,OTHER_MEDS,CUR_ILL,HISTORY,PRIOR_VAX,SPLTTYPE,FORM_VERS,TODAYS_DATE,BIRTH_DEFECT,OFC_VISIT,ER_ED_VISIT,ALLERGIES) from stdin delimiter &#39;,&#39; CSV HEADER&quot;&lt;/p&gt;&lt;p&gt;create index ix_data_vaers_id on vaers.data using btree (vaers_id);&lt;/p&gt;&lt;p&gt;*/&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vv.VAX_MANU as manufaturer,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vv.VAX_NAME as vax_name,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_TYPE,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;RECVDATE,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;count(distinct vd.vaers_id) as num_records&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.data vd&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;left join vaers.allsymptoms vs on vs.vaers_id = vd.vaers_id&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;left join vaers.vax vv on vv.vaers_id = vd.vaers_id&lt;/p&gt;&lt;p&gt;where&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vs.symptom = &#39;Myocard%&#39;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;--and not vd.died = &#39;Y&#39;&lt;/p&gt;&lt;p&gt;group by&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vv.VAX_MANU,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vv.VAX_NAME,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;VAX_TYPE,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;RECVDATE&lt;/p&gt;&lt;p&gt;;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;-- example:&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;WITH D as&lt;/p&gt;&lt;p&gt;(&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.recvdate,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.state,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.age_yrs,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.sex,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.recovd,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.died,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.l_threat,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.hospital,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.disable,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.ofc_visit,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vs.symptom,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vv.vax_manu,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vv.vax_type,&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vd.vaers_id&lt;/p&gt;&lt;p&gt;from&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vaers.data vd&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;left join vaers.allsymptoms vs on vs.vaers_id = vd.vaers_id&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;left join vaers.vax vv on vv.vaers_id = vd.vaers_id&lt;/p&gt;&lt;p&gt;where&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;vs.symptom_text ilike &#39;%myocardi%&#39;&lt;/p&gt;&lt;p&gt;)&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;select&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;*&lt;/p&gt;&lt;p&gt;from D&lt;/p&gt;&lt;p&gt;limit 10&lt;/p&gt;</description><link>http://www.aukema.org/2021/06/loading-vaers-data-into-postgres.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-8728319887099692007</guid><pubDate>Tue, 20 Apr 2021 06:16:00 +0000</pubDate><atom:updated>2021-04-20T08:49:04.410+02:00</atom:updated><title>Analysis of ICSR reports at ema.europa.eu</title><description>&lt;h2 style=&quot;text-align: left;&quot;&gt;Technical documentation to the article titled:&lt;/h2&gt;&lt;h2 style=&quot;text-align: left;&quot;&gt;&quot;The Costs of Covid-19 Vaccinations – &lt;span style=&quot;font-size: medium;&quot;&gt;Should we Rethink the Policy?&quot;&lt;/span&gt;&lt;/h2&gt;&lt;p&gt;This post provides documention for the analysis process that was performed with the abovementioned article (this link), as well as some additional visualisations produced from the data downloaded from EMA and ECDC.&lt;/p&gt;&lt;h2 style=&quot;text-align: left;&quot;&gt;Vaccination Volume Data from ECDC&lt;/h2&gt;&lt;p&gt;The data for COVID-19 vaccination volumes can be found here:&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea&quot; target=&quot;_blank&quot;&gt;https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea&lt;/a&gt;&amp;nbsp; &amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;h2 style=&quot;text-align: left;&quot;&gt;Individual Case Safety Reports from EMA&lt;/h2&gt;&lt;p&gt;1. To download all ICSR reports, follow the steps below.&lt;/p&gt;&lt;p&gt;Open&amp;nbsp;http://www.adrreports.eu/en/search_subst.html, navigate to &#39;C&#39; and search for COVID-19.&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL4c3v8FTUbUoA_tz4s0-O_YIpedEyIWkb1ulOid-D-_VolvFgtCHD1pTeTH5cWOb7lT4V7cvtG12FWJm8EO3d3EzysNiCpPIOJqX-mYZgDGDjIg_FJil1bnJoVpflDcMNe1DVW1UGgrnu/s1095/apr16_pic1.png&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;599&quot; data-original-width=&quot;1095&quot; height=&quot;219&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL4c3v8FTUbUoA_tz4s0-O_YIpedEyIWkb1ulOid-D-_VolvFgtCHD1pTeTH5cWOb7lT4V7cvtG12FWJm8EO3d3EzysNiCpPIOJqX-mYZgDGDjIg_FJil1bnJoVpflDcMNe1DVW1UGgrnu/w400-h219/apr16_pic1.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;To download ICSR reports for ALL forms of medication, one would need to visis the 4,000+ entries listed. As a workaround, I have a shortcut described below.&lt;/p&gt;&lt;p&gt;Since EMA does not allow the public to download all ICSR reports for all forms of medication in one go, I came up with a work around, by manipulating the url for entering their Oracle back end. By simply not specifying the identifier for a parrticular substance, all ICSR reports on all forms of medication get shown.&lt;/p&gt;&lt;p&gt;&lt;a href=&quot;https://dap.ema.europa.eu/analyticsSOAP/saw.dll?PortalPages&amp;amp;PortalPath=%2Fshared%2FPHV%20DAP%2F_portal%2FDAP&amp;amp;Action=Navigate&amp;amp;P0=1&amp;amp;P1=eq&amp;amp;P2=%22Line%20Listing%20Objects%22.%22Substance%20High%20Level%20Code%22&amp;amp;P3=&quot; target=&quot;_blank&quot;&gt;Shortcut to all Substances (incl. COVID19-vaccines)&lt;/a&gt;&lt;/p&gt;&lt;p&gt;Generate and download the ICSR Line listings for COVID, Measles and Influenza vaccines as well as the shortcut for all forms of medication, and repeat steps 2, 3 and 4 explained below, for each of the vaccines:&lt;/p&gt;&lt;p&gt;2. Export the ICSR reports to TAB-delimited text files as follows:&lt;/p&gt;&lt;p&gt;Navigate to the tab labelled &#39;Line Listing&#39;.&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge3Bek1VcVaC1znKKh6Oj3N4bM1-55wSdvktBkrNHDunDpFzicAZU1oCCFRLtQRFe0rGN9JqVN54IgQXcbbQxaz9iEh4V-W4W5SoJ1bf6HSs8W-DFDAGakKjU_rdI1vaJxkIOMCaLVu8rQ/s1711/apr16_pic2.png&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;432&quot; data-original-width=&quot;1711&quot; height=&quot;162&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge3Bek1VcVaC1znKKh6Oj3N4bM1-55wSdvktBkrNHDunDpFzicAZU1oCCFRLtQRFe0rGN9JqVN54IgQXcbbQxaz9iEh4V-W4W5SoJ1bf6HSs8W-DFDAGakKjU_rdI1vaJxkIOMCaLVu8rQ/w640-h162/apr16_pic2.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;For Geographic Region, select &#39;European Economic Area&#39;.&lt;/p&gt;&lt;p&gt;Next, click on &#39;Run Line Listing Report&#39;. This will open a new window and present you with the ICSR reports in tabular format. This may take a while.&lt;/p&gt;&lt;p&gt;Navigate all the way to the bottom and start the export as shown in the image below:&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHWW_0GubySv0j64PCIoJeAzd4fN4w7ssJbwAHLYBVh_bATbCfWcFjIlDoKS-z7jwycrSf1HsmKce9aOC61CoZOgsu4xwxnXWXpGLr6ec9oO68xUbv9izX00iIKoxzGJDThUL-uNRxeQhn/s1935/Screenshot+2021-04-16+at+22.15.49.png&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;985&quot; data-original-width=&quot;1935&quot; height=&quot;326&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHWW_0GubySv0j64PCIoJeAzd4fN4w7ssJbwAHLYBVh_bATbCfWcFjIlDoKS-z7jwycrSf1HsmKce9aOC61CoZOgsu4xwxnXWXpGLr6ec9oO68xUbv9izX00iIKoxzGJDThUL-uNRxeQhn/w640-h326/Screenshot+2021-04-16+at+22.15.49.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;The export will be saved to the default Downloads folder of your web-browser.&lt;/p&gt;&lt;p&gt;3. Convert and rename all exported files to UTF-8 encoding (e.g. using Notepad++ for Windows).&lt;/p&gt;&lt;p&gt;In the instructions below, I used a naming convention as follows: MMMDD_export_[substance].csv&lt;/p&gt;&lt;p&gt;4. Load the exported file into PostgreSQL&lt;/p&gt;&lt;p&gt;Create a schema and table in PostgreSQL (I use an old version 9.1 on an old Windows Server 2008)&lt;/p&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;CREATE SCHEMA ema;&lt;br /&gt;CREATE TABLE ema.sta_icsr&lt;br /&gt;(&lt;br /&gt;&amp;nbsp; source varchar,&lt;br /&gt;&amp;nbsp; elocnr character varying,&lt;br /&gt;&amp;nbsp; reporttype character varying,&lt;br /&gt;&amp;nbsp; evgatewayrecdate character varying,&lt;br /&gt;&amp;nbsp; primarysourcequalification character varying,&lt;br /&gt;&amp;nbsp; primarysourcecountryforregulatorypurposes character varying,&lt;br /&gt;&amp;nbsp; literaturereference character varying,&lt;br /&gt;&amp;nbsp; patientagegroup character varying,&lt;br /&gt;&amp;nbsp; patientagegroupperreporter character varying,&lt;br /&gt;&amp;nbsp; parentchildreport character varying,&lt;br /&gt;&amp;nbsp; patientsex character varying,&lt;br /&gt;&amp;nbsp; reactionlist character varying,&lt;br /&gt;&amp;nbsp; suspectdruglist character varying,&lt;br /&gt;&amp;nbsp; concomitant character varying,&lt;br /&gt;&amp;nbsp; icsrform character varying&lt;br /&gt;)&lt;br /&gt;WITH (&lt;br /&gt;&amp;nbsp; OIDS=FALSE);&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Next, load all ICSR exports into the table. I used the following DOS command:&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;for /F %f in (&#39;dir/b APR13_*.csv&#39;) do tail -n +2 %f|sed -e s#^^#%f\t#|sed -e s#\xED\xAF\x80#t#g -e s#\xED\xB6\xA9#t#g -e s#\xed\xb6\x9f#i#g -e s#\\#\\\\#g|psql -h localhost -U postgres -a -c &quot;copy ema.sta_icsr from stdin&quot;&lt;/span&gt;&lt;/div&gt;&lt;p&gt;Description of the DOS command: For each export file (%f), skip header, add a column identifying the filename, replace some unreadable characters, prepend backslashes with a backslash and tell psql to execute the copy command.&lt;/p&gt;&lt;p&gt;5. De-duplication of records&lt;/p&gt;&lt;p&gt;To de-duplicate, we need a table that holds only unique entries. Also, we need to give priority / precedence to specific substances, before we load the rest (all substances thru that manipulated url).&lt;/p&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;create table ema.dwh_geneloc (&lt;br /&gt;id serial,&lt;br /&gt;source varchar,&lt;br /&gt;elocnr varchar&lt;br /&gt;)&lt;br /&gt;without oids;&lt;br /&gt;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%pfizer%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%astrazeneca%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%moderna%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%janssen%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%MMR%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%Influenza-split-virion-inactivated%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%influenza-live-nasal%&#39;&lt;br /&gt;;&lt;br /&gt;insert into ema.dwh_geneloc (source, elocnr)&lt;br /&gt;select&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;source, elocnr&amp;nbsp;&lt;br /&gt;from&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.sta_icsr&lt;br /&gt;where&amp;nbsp;&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not (elocnr) in (select elocnr from ema.dwh_geneloc group by elocnr)&lt;br /&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;and source like &#39;%all_all%&#39;&lt;br /&gt;;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;6. Create some indexes to speed up query performance&lt;br /&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;create index ix_staicsr_source on ema.sta_icsr using btree (source);&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;create index ix_staicsr_elocnr on ema.sta_icsr using btree (elocnr);&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;create index ix_geneloc_source on ema.dwh_geneloc using btree (source);&lt;br /&gt;&lt;/span&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;create index ix_geneloc_elocnr on ema.dwh_geneloc using btree (elocnr);&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;7. Run query and export results to a text file&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;select&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;i.source,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;split_part(split_part(i.source, &#39;apr13_&#39;, 2), &#39;_&#39;, 1) as product,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;i.elocnr,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;date(to_timestamp(EVGwayRecDate, &#39;yyyy-mm-dd&#39;)) as recvd_date,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;patientagegroup,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;patientsex,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;case&amp;nbsp;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;when primarysourcequalification like &#39;Non Health%&#39; then false&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;else true&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;end as hcp_reported,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;replace(split_part(unnest(string_to_array(reactionlist, &#39;,&amp;lt;BR&amp;gt;&amp;lt;BR&amp;gt;&#39;)), E&#39;\x20\(&#39;, 1), &#39;&quot;&#39;, &#39;&#39;) as Adr_Text,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;split_part(replace(split_part(unnest(string_to_array(reactionlist, &#39;,&amp;lt;BR&amp;gt;&amp;lt;BR&amp;gt;&#39;)), E&#39;\x20\(&#39;, 2), &#39;&quot;&#39;, &#39;&#39;), &#39; - &#39;, 2) as Adr_Outcome&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;from&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.dwh_geneloc e&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;join ema.sta_icsr i on e.source = i.source and e.elocnr = i.elocnr&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;Save the query output to disk, so that you can pick ip up with a BI-tool, such as Tableau.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;8. To select only Fatal reactions, this query will do the job:&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;WITH all_icsr AS&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;(&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;select&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;i.source,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;split_part(split_part(i.source, &#39;apr13_&#39;, 2), &#39;_&#39;, 1) as product,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;i.elocnr,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;date(to_timestamp(EVGwayRecDate, &#39;yyyy-mm-dd&#39;)) as recvd_date,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;patientagegroup,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;patientsex,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;case&amp;nbsp;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;when primarysourcequalification like &#39;Non Health%&#39; then false&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;else true&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;end as hcp_reported,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;replace(split_part(unnest(string_to_array(reactionlist, &#39;,&amp;lt;BR&amp;gt;&amp;lt;BR&amp;gt;&#39;)), E&#39;\x20\(&#39;, 1), &#39;&quot;&#39;, &#39;&#39;) as Adr_Text,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;split_part(replace(split_part(unnest(string_to_array(reactionlist, &#39;,&amp;lt;BR&amp;gt;&amp;lt;BR&amp;gt;&#39;)), E&#39;\x20\(&#39;, 2), &#39;&quot;&#39;, &#39;&#39;), &#39; - &#39;, 2) as Adr_Outcome&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;from&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.dwh_geneloc e&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;join ema.sta_icsr i on e.source = i.source and e.elocnr = i.elocnr&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;)&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;select&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span&gt;&amp;nbsp; &amp;nbsp; *&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span&gt;from&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span&gt;&lt;span&gt;&amp;nbsp; &amp;nbsp; all_icsr&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span&gt;&lt;span&gt;where&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span&gt;&lt;span&gt;&lt;span&gt;&amp;nbsp; &amp;nbsp; adr_outcome ilike &#39;%fatal%&#39;&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span&gt;&lt;span&gt;&lt;span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;9. Beware of difference between ICSR and ADR&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Within EMA, an ICSR report relates to a patient / person.&lt;/div&gt;&lt;div&gt;An ICSR report can record multiple reactions and corresponding outcomes.&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;In counting the number of deaths per 100K vaccines, you should therefore not count number of reactions with fatal outcome, as this could result in multiple fatal reactions per patient.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;In the article, we have used the distinct count of unique ICSR reports.&amp;nbsp;&lt;/div&gt;&lt;div&gt;The query below illustrates the difference between the two measures:&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;with all_reports as&amp;nbsp;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;(&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;select&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;i.elocnr,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;split_part(split_part(i.source, &#39;apr13_&#39;, 2), &#39;_&#39;, 1) as product,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;split_part(replace(split_part(unnest(string_to_array(reactionlist, &#39;,&amp;lt;BR&amp;gt;&amp;lt;BR&amp;gt;&#39;)), E&#39;\x20\(&#39;, 2), &#39;&quot;&#39;, &#39;&#39;), &#39; - &#39;, 2) as adr_outcome&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;from&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;ema.dwh_geneloc e&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;join ema.sta_icsr i on e.source = i.source and e.elocnr = i.elocnr&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;)&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;select&amp;nbsp;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;product,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;count(*) as num_adr,&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;count(distinct elocnr) as num_icsr&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;from&amp;nbsp;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;all_reports&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;where&amp;nbsp;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;not product = &#39;all&#39;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;adr_outcome ilike &#39;%fatal%&#39;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;group by&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;white-space: pre;&quot;&gt; &lt;/span&gt;product&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0TrZ93wPOpylgXZ7H0vAiMiui2EuUz6dRmFLTWPbcXXTjL-uoKenEOK3DmaDtl4ygiduj1hps1dCUlySora5eW5a0-7Cg_peCq7mT-I4Ug1UZn28Iaut-gVB0s6dOkyK49WVlhU08wZFX/s438/Screenshot+2021-04-20+at+08.43.39.png&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;214&quot; data-original-width=&quot;438&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0TrZ93wPOpylgXZ7H0vAiMiui2EuUz6dRmFLTWPbcXXTjL-uoKenEOK3DmaDtl4ygiduj1hps1dCUlySora5eW5a0-7Cg_peCq7mT-I4Ug1UZn28Iaut-gVB0s6dOkyK49WVlhU08wZFX/s320/Screenshot+2021-04-20+at+08.43.39.png&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;</description><link>http://www.aukema.org/2021/04/analysis-of-icsr-reports-at-emaeuropaeu.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL4c3v8FTUbUoA_tz4s0-O_YIpedEyIWkb1ulOid-D-_VolvFgtCHD1pTeTH5cWOb7lT4V7cvtG12FWJm8EO3d3EzysNiCpPIOJqX-mYZgDGDjIg_FJil1bnJoVpflDcMNe1DVW1UGgrnu/s72-w400-h219-c/apr16_pic1.png" height="72" width="72"/></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-73653944913228239</guid><pubDate>Tue, 08 Dec 2020 01:23:00 +0000</pubDate><atom:updated>2020-12-08T02:23:01.585+01:00</atom:updated><title>Meta-data Analysis at eurosurveillance.org</title><description>&lt;h3 style=&quot;text-align: left;&quot;&gt;Background&lt;/h3&gt;&lt;p&gt;The goal is to understand how much time it typically takes for Research papers to get reviewed and accepted by &lt;a href=&quot;http://eurosurveillance.org&quot;&gt;eurosurveillance.org&lt;/a&gt;.&lt;/p&gt;&lt;p&gt;The reason for this assessment is to provide clarity around discussions of a specific research paper that was reviewed and accepted in a single day. Some scientists think it is impossible to Peer-Review research within a single day. Other scientists claim the paper went thru -the much quicker- Rapid Review procedure, as outlined on the journal&#39;s web site.&amp;nbsp;&lt;/p&gt;&lt;p&gt;To assess commonality in the review and acceptance process at eurosurveillance.org, the author collected and analysed meta-data for all 1,595 publications since 01-Jan-2015. Earlier this week, the author shared the initial findings of this assessment in a Twitter post.&amp;nbsp;&lt;/p&gt;&lt;p&gt;This six-page document aims to make these findings reproducible and verifiable by offering step by step instructions.&lt;/p&gt;&lt;h3 style=&quot;text-align: left;&quot;&gt;Summary of Findings&lt;/h3&gt;&lt;p&gt;&lt;/p&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;Of the 17 types of articles published since 2015, three types occur most frequently: Rapid Communication (385), Research (312) and Surveillance (193).&lt;/li&gt;&lt;li&gt;The average number of days between Acceptance and Reception of Research type articles is 172 (2019) and 97 (2020).&amp;nbsp;&lt;/li&gt;&lt;li&gt;In line with the Editorial Policy for Authors, the category &#39;Rapid Communication&#39; publications appear to be reviewed and accepted more quickly (18 days average) than type &#39;Research&#39; and &#39;Surveillance.&#39;&lt;/li&gt;&lt;li&gt;Except for this one Research article (on 22-jan-2020), no other article has ever been reviewed and accepted within a single day since 2015.&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAnHINxyJjKi7dfrQutUZYFQLp-cNA__tl8pZo45S448vkoB-4Le482p6Cz3BBFCLlj19TLgOeCa625zFmxHLxgtVo-kLsEmrWnlQqPw1_LX-wmMW5H1pnqnarGENu8mHo5kd2XFZjyGGV/s2048/Fullscreen_07_12_2020__00_58.png&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;Picture that places the discussed Research Paper into context&quot; border=&quot;0&quot; data-original-height=&quot;1127&quot; data-original-width=&quot;2048&quot; height=&quot;352&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAnHINxyJjKi7dfrQutUZYFQLp-cNA__tl8pZo45S448vkoB-4Le482p6Cz3BBFCLlj19TLgOeCa625zFmxHLxgtVo-kLsEmrWnlQqPw1_LX-wmMW5H1pnqnarGENu8mHo5kd2XFZjyGGV/w640-h352/Fullscreen_07_12_2020__00_58.png&quot; title=&quot;Click for Full Interactive Dashboard&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;i&gt;For a Fully Interactive Dashboard, position. your browser in landscape and&amp;nbsp;&lt;a href=&quot;https://public.tableau.com/profile/aukema#!/vizhome/Meta-dataAnalysisateurosurveillance_org/ReviewProcessDashboard&quot; target=&quot;_blank&quot;&gt;click here&lt;/a&gt;.&lt;/i&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;h3 style=&quot;text-align: left;&quot;&gt;About the Author&lt;/h3&gt;&lt;div&gt;Wouter Aukema has over 30 years of experience in processing data and analysing behaviour of organisations and systems for governments and corporations world-wide and develops analysis solutions for Fortune 100 companies. His publication at Defcon (20 years ago) caused headlines world wide. Wouter sees data and patterns where others don’t. &lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;h3 style=&quot;text-align: left;&quot;&gt;Download the Report&lt;/h3&gt;&lt;div&gt;A PDF version of the report -with step by step instructions- can be downloaded &lt;a href=&quot;https://drive.google.com/file/d/1hRi6NY8_7BJNMlBntJ1xsO7czr7Midz2/view?usp=sharing&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;.&lt;/div&gt;</description><link>http://www.aukema.org/2020/12/meta-data-analysis-at.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAnHINxyJjKi7dfrQutUZYFQLp-cNA__tl8pZo45S448vkoB-4Le482p6Cz3BBFCLlj19TLgOeCa625zFmxHLxgtVo-kLsEmrWnlQqPw1_LX-wmMW5H1pnqnarGENu8mHo5kd2XFZjyGGV/s72-w640-h352-c/Fullscreen_07_12_2020__00_58.png" height="72" width="72"/></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-3965309101242858552</guid><pubDate>Thu, 12 Mar 2020 21:25:00 +0000</pubDate><atom:updated>2020-03-13T05:48:30.251+01:00</atom:updated><title>Corona Pandemanic: Gentle Surgeons Make Stinky Wounds</title><description>Countries take different measures when it comes to the Corona Pandemanic and I was wondering if this could be visualized by the data published by&amp;nbsp;&lt;a href=&quot;https://systems.jhu.edu/&quot; target=&quot;_blank&quot;&gt;John Hopkins Universit&lt;/a&gt;y (JHU) on &lt;a href=&quot;https://github.com/CSSEGISandData/COVID-19&quot; target=&quot;_blank&quot;&gt;GitHub&lt;/a&gt;.&lt;br /&gt;
  2. &lt;br /&gt;
  3. Here&#39;s my attempt:&lt;br /&gt;
  4. &lt;br /&gt;
  5. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  6. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKocJLLr59qnQRtxI4KlwvhIG_RHh7YcwBwukXk10h6dCztpuMv2eRDYBMz3RgWfXEN3pcmlgQg8xTvBeUVlvffkS7x45d58CRTuWmh6TamarakspwHq6nDN2t9I3AIeFylVjMH86hjuaw/s1600/Corona+Infection+Rate+by+aukema.org.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;900&quot; data-original-width=&quot;1600&quot; height=&quot;360&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKocJLLr59qnQRtxI4KlwvhIG_RHh7YcwBwukXk10h6dCztpuMv2eRDYBMz3RgWfXEN3pcmlgQg8xTvBeUVlvffkS7x45d58CRTuWmh6TamarakspwHq6nDN2t9I3AIeFylVjMH86hjuaw/s640/Corona+Infection+Rate+by+aukema.org.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  7. &lt;br /&gt;
  8. &lt;i&gt;What I produced is how various countries came to their &#39;score&#39; of infections. Vertical axis: Percentage of total confirmed infections on March 11, 2020. Horizontal: Days, past 14 out of 49 total days since news came out. I picked a few countries from Asia, Europe and the USA with significant number of infections. The underlaying dashboard is available on &lt;a href=&quot;https://public.tableau.com/profile/aukema#!/&quot; target=&quot;_blank&quot;&gt;my Tableau Public repository&lt;/a&gt;.&lt;/i&gt;&lt;br /&gt;
  9. &lt;br /&gt;
  10. To my limited understanding, we are aiming for the top in a Bell-curve. This would mean that China reached their top already (see graph below for their full date-range) and that Singapore and South Korea are getting close to their tops.&lt;br /&gt;
  11. &lt;br /&gt;
  12. If we look at USA, Netherlands, Germany etc. we are still climbing up the curve. Steeply. USA is climbing even more rapidly than we are here in The Netherlands.&lt;br /&gt;
  13. &lt;br /&gt;
  14. In Dutch, we have a saying: &quot;gentle surgeons make stinky wounds&quot;.&lt;br /&gt;
  15. &lt;br /&gt;
  16. Confirmed cases in China:&lt;br /&gt;
  17. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  18. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcimGPIJKEEdlxLc0_jmsVX0w6vafON43HS8ibQcdqGLSUG56lcCNhJJSZ6RIrt0HwEsrynPqunv57ykBOfW1Gcwz3D9mIfdJs7Tio4llfb_SOw-1Uo5P3yynZ5KxlN3Id-gI4z2LPe-Ie/s1600/Screenshot+2020-03-12+at+21.52.16.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;905&quot; data-original-width=&quot;1600&quot; height=&quot;225&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcimGPIJKEEdlxLc0_jmsVX0w6vafON43HS8ibQcdqGLSUG56lcCNhJJSZ6RIrt0HwEsrynPqunv57ykBOfW1Gcwz3D9mIfdJs7Tio4llfb_SOw-1Uo5P3yynZ5KxlN3Id-gI4z2LPe-Ie/s400/Screenshot+2020-03-12+at+21.52.16.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  19. &lt;br /&gt;</description><link>http://www.aukema.org/2020/03/corona-pandemanic-gentle-surgeons-make.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKocJLLr59qnQRtxI4KlwvhIG_RHh7YcwBwukXk10h6dCztpuMv2eRDYBMz3RgWfXEN3pcmlgQg8xTvBeUVlvffkS7x45d58CRTuWmh6TamarakspwHq6nDN2t9I3AIeFylVjMH86hjuaw/s72-c/Corona+Infection+Rate+by+aukema.org.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-3039152655718856221</guid><pubDate>Thu, 20 Feb 2020 09:56:00 +0000</pubDate><atom:updated>2020-02-20T11:48:34.521+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Emissie</category><category domain="http://www.blogger.com/atom/ns#">NOx</category><category domain="http://www.blogger.com/atom/ns#">RIVM</category><category domain="http://www.blogger.com/atom/ns#">Stikstof</category><title>NOx Emissie door Industrie: Dit zijn ze.</title><description>&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;In het rapport van het Adviescollege Stikstofproblematiek werd gemeld dat de NEC-sector Industrie 50,7 kiloton NOx had uitgestoten in 2017.&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;br /&gt;
  20. &lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;Hieronder staan al die bedrijven, in een interactieve dashboard. (klik op de picture.)&lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;Overigens mooi om te zien dat de cijfers goed in de buurt komen van het rapport.&lt;br /&gt;
  21. &lt;br /&gt;
  22. &lt;a href=&quot;https://public.tableau.com/profile/aukema#!/vizhome/NOxEmissieIndustrieNL/NOxinNL&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot; target=&quot;_blank&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;905&quot; data-original-width=&quot;1377&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifwBXtSzLsB3_IFMf55IXyn9UJmCCl0G4fjiibVNxODHnFihvAfedRnoIE7Ergp0V0XxJ3LY7-uUkfGxDGYL1ZYujXiln9hFoHqIceJ19w0s2pmT-q3CWz6QFunYs8asfArjH_oHgZmqWG/s640/NOx+Emissie+door+industrie.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;De gegevens zijn afkomstig van:&amp;nbsp;&lt;a href=&quot;http://www.emissieregistratie.nl/erpubliek/erpub/facility.aspx&quot;&gt;http://www.emissieregistratie.nl/erpubliek/erpub/facility.aspx&lt;/a&gt;. Hierbij heb ik alle bedrijven geselecteerd waarvan cijfers over 2017 werden vermeld.&lt;br /&gt;
  23. &lt;br /&gt;
  24. &lt;/div&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;br /&gt;
  25. &lt;/div&gt;&lt;br /&gt;
  26. &lt;br /&gt;
  27. &lt;br /&gt;
  28. </description><link>http://www.aukema.org/2020/02/nox-emissie-door-industrie-dit-zijn-ze.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifwBXtSzLsB3_IFMf55IXyn9UJmCCl0G4fjiibVNxODHnFihvAfedRnoIE7Ergp0V0XxJ3LY7-uUkfGxDGYL1ZYujXiln9hFoHqIceJ19w0s2pmT-q3CWz6QFunYs8asfArjH_oHgZmqWG/s72-c/NOx+Emissie+door+industrie.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-1997697000747747109</guid><pubDate>Mon, 17 Feb 2020 09:44:00 +0000</pubDate><atom:updated>2020-02-17T10:44:53.014+01:00</atom:updated><title>Convert Dutch RD coordinates to WGS-84</title><description>Some weeks ago, I found &lt;a href=&quot;https://www.theinformationlab.nl/2017/04/20/x-y-coordinaten-plotten-op-kaart/&quot; target=&quot;_blank&quot;&gt;this great Tableau formula&lt;/a&gt;&amp;nbsp;by Rik van Schaik to convert x,y co-ordinates from the Dutch Rijksdriehoek system to latitude, longitude.&lt;br /&gt;
  29. &lt;br /&gt;
  30. Works great in PostgreSQL to:&lt;br /&gt;
  31. &lt;br /&gt;
  32. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;-- Based on a Tableau calculated field formula by Rik Van Schaik&lt;/span&gt;&lt;br /&gt;
  33. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;-- Added more decimals for precision&lt;/span&gt;&lt;br /&gt;
  34. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;-- Rewritten for PostgresSQL&lt;/span&gt;&lt;br /&gt;
  35. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;-- Replace x &amp;amp; y by field names of your choice&lt;/span&gt;&lt;br /&gt;
  36. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;-- feb-2020 aukema.org&lt;/span&gt;&lt;br /&gt;
  37. &lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
  38. &lt;span style=&quot;font-size: x-small;&quot;&gt;select&lt;/span&gt;&lt;br /&gt;
  39. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;52.15517440 + ((&lt;/span&gt;&lt;br /&gt;
  40. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(3235.65389 * ((y - 463000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  41. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-32.58297 * ((x - 155000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  42. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.2475 * ((y - 463000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  43. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.84978 * ((x - 155000) * 10 ^ -5) ^ 2 * ((y - 463000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  44. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.0655 * ((y - 463000) * 10 ^ -5) ^ 3) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  45. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.01709 * ((x - 155000) * 10 ^ -5) ^ 2 * ((y - 463000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  46. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.00738 * ((x - 155000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  47. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.0053 * ((x - 155000) * 10 ^ -5) ^ 4) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  48. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.00039 * ((x - 155000) * 10 ^ -5) ^ 2 * ((y - 463000) * 10 ^ -5) ^ 3) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  49. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.00033 * ((x - 155000) * 10 ^ -5) ^ 4 * ((y - 463000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  50. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.00012 * ((x - 155000) * 10 ^ -5) * ((y - 463000) * 10 ^ -5))&lt;/span&gt;&lt;br /&gt;
  51. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;) / 3600) as lat,&lt;/span&gt;&lt;br /&gt;
  52. &lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
  53. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;5.38720621 + ((&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  54. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(5260.52916 * ((x - 155000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  55. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(105.94684 * ((x - 155000) * 10 ^ -5) * ((y - 463000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  56. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(2.45656 * ((x - 155000) * 10 ^ -5) * ((y - 463000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  57. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.81885 * ((x - 155000) * 10 ^ -5) ^ 3) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  58. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.05594 * ((x - 155000) * 10 ^ -5) * ((y - 463000) * 10 ^ -5) ^ 3) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  59. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.05607 * ((x - 155000) * 10 ^ -5) ^ 3 * ((y - 463000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  60. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.01199 * ((y - 463000) * 10 ^ -5)) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  61. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.00256 * ((x - 155000) * 10 ^ -5) ^ 3 * ((y - 463000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  62. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.00128 * ((x - 155000) * 10 ^ -5) * ((y - 463000) * 10 ^ -5) ^ 4) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  63. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.00022 * ((y - 463000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  64. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(-0.00022 * ((x - 155000) * 10 ^ -5) ^ 2) +&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  65. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;(0.00026 * ((x - 155000) * 10 ^ -5) ^ 5)&lt;/span&gt;&lt;br /&gt;
  66. &lt;span style=&quot;font-size: x-small;&quot;&gt;&amp;nbsp;) / 3600) as lon&lt;/span&gt;</description><link>http://www.aukema.org/2020/02/convert-dutch-rd-coordinates-to-wgs-84.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-6977374844243016063</guid><pubDate>Fri, 31 Jan 2020 12:55:00 +0000</pubDate><atom:updated>2020-02-02T19:57:55.577+01:00</atom:updated><title>Stikstof: Nederland aan Top? Of toch Niet?</title><description>Vaak lees ik hoe wij in Nederland de hoogste stikstof emissie per vierkante kilometer scoren.&lt;br /&gt;
  67. &lt;b&gt;&lt;br /&gt;&lt;/b&gt;
  68. &lt;b&gt;Nederland is het slechtste jongetje van de EU klas&lt;/b&gt;.&lt;br /&gt;
  69. &lt;br /&gt;
  70. Maar wat als we nu eens hetzelfde rekensommetje maken, maar dan gerelateerd aan het aantal inwoners?&lt;br /&gt;
  71. &lt;br /&gt;
  72. &lt;b&gt;Nederland is slechts een gemiddelde leerling&lt;/b&gt;, zie maar:&lt;br /&gt;
  73. &lt;br /&gt;
  74. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  75. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFvXzbV4VKiZ06u-yCjvxWywG9fFg4u1S4dZLj4kHSATx6iQT5vSGfyIPnlmfXaj1r8ZlZGmjXezcUUGxjsZ_ceJofkOvqZ_MGAGh0knEotlh3PtDdgw6ocZF1VQm5B4tBEG-RyefGTBBZ/s1600/Screenshot+2020-01-31+at+13.47.44.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;853&quot; data-original-width=&quot;1600&quot; height=&quot;340&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFvXzbV4VKiZ06u-yCjvxWywG9fFg4u1S4dZLj4kHSATx6iQT5vSGfyIPnlmfXaj1r8ZlZGmjXezcUUGxjsZ_ceJofkOvqZ_MGAGh0knEotlh3PtDdgw6ocZF1VQm5B4tBEG-RyefGTBBZ/s640/Screenshot+2020-01-31+at+13.47.44.png&quot; title=&quot;Stikstof per Inwoner&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  76. &lt;br /&gt;
  77. &lt;br /&gt;
  78. &lt;br /&gt;
  79. &lt;br /&gt;
  80. &lt;br /&gt;
  81. &lt;br /&gt;
  82. &lt;br /&gt;
  83. &lt;br /&gt;
  84. &lt;br /&gt;
  85. &lt;br /&gt;
  86. &lt;br /&gt;
  87. &lt;br /&gt;
  88. &lt;br /&gt;
  89. &lt;br /&gt;
  90. &lt;br /&gt;
  91. &lt;br /&gt;
  92. &lt;br /&gt;
  93. &lt;br /&gt;
  94. &lt;br /&gt;
  95. &lt;br /&gt;
  96. Data is afkomstig van het&amp;nbsp;&lt;a href=&quot;https://www.ceip.at/&quot; target=&quot;_blank&quot;&gt;Centre on Emission Inventories and Projections&lt;/a&gt;&amp;nbsp;die hun gegevens op zeer transparantie wijze beschikbaar stellen (middels Tableau dashboards, die je kunt downloaden).&lt;br /&gt;
  97. &lt;br /&gt;</description><link>http://www.aukema.org/2020/01/stikstof-nederland-aan-top-of-toch-niet.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFvXzbV4VKiZ06u-yCjvxWywG9fFg4u1S4dZLj4kHSATx6iQT5vSGfyIPnlmfXaj1r8ZlZGmjXezcUUGxjsZ_ceJofkOvqZ_MGAGh0knEotlh3PtDdgw6ocZF1VQm5B4tBEG-RyefGTBBZ/s72-c/Screenshot+2020-01-31+at+13.47.44.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-1777985422819841011</guid><pubDate>Mon, 20 Jan 2020 20:36:00 +0000</pubDate><atom:updated>2020-01-24T15:47:35.873+01:00</atom:updated><title>RIVM NOx Bubbles</title><description>&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;/div&gt;Ruim 8.500 mensen hebben mbv.&amp;nbsp;&lt;a href=&quot;http://www.aukema.org/2020/01/rivm-nh3-administratie-op-straat.html&quot; target=&quot;_blank&quot;&gt;deze interactieve NH3 kaart&lt;/a&gt;&amp;nbsp;gekeken in hoeverre de model-data van het RIVM strookt met hun eigen beleving.&lt;br /&gt;
  98. &lt;br /&gt;
  99. Vandaag een nieuwe dashboard: NOx Bubbles. Met de NOx component uit de bron-data waarmee het RIVM hun modellen berekent. Deze nieuwe dashboard ziet er anders uit dan de vorige, omdat we met hulp van o.a. Geesje Rotgers de data veel meer betekenis konden geven.&lt;br /&gt;
  100. &lt;br /&gt;
  101. &lt;h3&gt;Nieuwe functies&lt;/h3&gt;Bij elk data-punt op de kaart, kun je de Google satelliet view erbij pakken. Ook kun je vanaf ieder data-punt je melding doen bij&amp;nbsp;&lt;a href=&quot;https://www.furorteutonicus.eu/2020/01/20/consensusemissie-meldformulier-en-protest-bij-diepenheim/&quot; target=&quot;_blank&quot;&gt;Evert Mouw&lt;/a&gt;, als jou iets opvalt.&lt;br /&gt;
  102. &lt;br /&gt;
  103. &lt;h4&gt;&lt;ul&gt;&lt;/ul&gt;&lt;/h4&gt;&lt;h4&gt;Observaties&lt;/h4&gt;Ik weet niet in hoeverre deze data-set als 100% volledig en absoluut betrouwbaar moet worden beschouwd. Wel meen ik te zien dat in de data-set gegevens lijken te ontbreken. Zo zie ik geen gegevens mbt. de NOx uitstoot door auto-bussen of militaire en civiele schiet-banen.&lt;br /&gt;
  104. &lt;br /&gt;
  105. Ook zie ik een significant aantal data-punten in de RIVM data-set gemarkeerd staan als snelweg, terwijl hiervan -volgens mijn eigen inschatting en die&amp;nbsp;&lt;a href=&quot;http://publicaties.minienm.nl/download-bijlage/111802/wegenkaart-maximumumsnelheden-op-rijkswegen-in-nederland-per-1-oktober-2019-update-16-10-19.pdf&quot; target=&quot;_blank&quot;&gt;van Rijkswaterstaat&lt;/a&gt;-&amp;nbsp;geen sprake kan zijn.&lt;br /&gt;
  106. &lt;br /&gt;
  107. NOx waarden in de RIVM data-set zijn grammen per seconde en gaan tot zes decimalen. Voor de leesbaarheid heb ik in het opening-scherm deze omgerekend (q(g/s) x 3600 x 24 x 365 / 10^6) ofwel kiloton per jaar x 1.000.&lt;br /&gt;
  108. &lt;br /&gt;
  109. Mbt. de kolommen hc(MW) en h(m) hebben we in dit dashboard niets gedaan. De waarden zitten wel in het model zelf.&lt;br /&gt;
  110. &lt;br /&gt;
  111. &lt;h4&gt;Samenwerking en verantwoording&lt;/h4&gt;Data is afkomstig van het RIVM. Evert Mouw, die er een eerste blik op wierp, heeft de RD coordinaten naar WGS omgezet. &amp;nbsp;&lt;a href=&quot;https://mobile.twitter.com/AnnvanEe&quot; target=&quot;_blank&quot;&gt;Anna van Ee&lt;/a&gt; heeft een Functional Mobile Usability Test verricht waardoor we de meeste issues eruit konden halen.&lt;br /&gt;
  112. &lt;br /&gt;
  113. &lt;h3&gt;Handleiding voor mensen met geduld&lt;/h3&gt;&lt;br /&gt;
  114. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://public.tableau.com/views/NOxBubble/KieseenBubble?:display_count=y&amp;publish=yes&amp;:origin=viz_share_link&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot; target=&quot;_blank&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1100&quot; data-original-width=&quot;1321&quot; height=&quot;332&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil4RLIUMWpugG6D8BAIWS6uI38ONckJt2djVdnnxWaYClTs_AVETXlNfrBaEK_jIGZXJYh3BZZZuJU3gSZvfFpwnGGbihLRS87IB-mvUE42qkPBtZ2lxTJiTgU-S9BrkjEPAWv6679aakQ/s400/Screenshot+2020-01-24+at+14.38.33.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;i&gt;Let op: Alles kan wat traag overkomen. 730K+ pixels op een smartphone is best pittig&lt;/i&gt;&lt;br /&gt;
  115. &lt;br /&gt;
  116. De NOx Bubble opent met acht categorieën. Klik op een categorie om de kaart te openen met focus op die categorie. De kaart opent met de waarden geplot op alle GPS-coördinaten.&lt;br /&gt;
  117. &lt;br /&gt;
  118. Elk datapunt kun je aanklikken en biedt extra functies (zie hierboven).&lt;br /&gt;
  119. Onder de kaart kun je filteren op sub-categorie. Let op: Reset dit filter voordat je andere categorie kiest.&lt;br /&gt;
  120. &lt;br /&gt;
  121. Klik op de Bubbles om te openen &amp;gt;&amp;gt;&lt;br /&gt;
  122. &lt;br /&gt;
  123. </description><link>http://www.aukema.org/2020/01/rivm-nox-bubbles.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil4RLIUMWpugG6D8BAIWS6uI38ONckJt2djVdnnxWaYClTs_AVETXlNfrBaEK_jIGZXJYh3BZZZuJU3gSZvfFpwnGGbihLRS87IB-mvUE42qkPBtZ2lxTJiTgU-S9BrkjEPAWv6679aakQ/s72-c/Screenshot+2020-01-24+at+14.38.33.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-6925415380914056243</guid><pubDate>Fri, 17 Jan 2020 10:39:00 +0000</pubDate><atom:updated>2020-01-18T13:39:33.488+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">NH3</category><category domain="http://www.blogger.com/atom/ns#">RIVM</category><title>RIVM NH3 Administratie op Straat</title><description>&lt;h2&gt;
  124. Hoeveel uitstoot van ammoniak is er in jouw buurt of straat?&lt;/h2&gt;
  125. Op deze interactieve kaart, kun je kijken of de perceptie van het RIVM overeenkomt met jouw eigen beleving.&lt;br /&gt;
  126. &lt;br /&gt;
  127. &lt;div style=&quot;text-align: left;&quot;&gt;
  128. &lt;a href=&quot;https://public.tableau.com/views/NH3volgensRIVM/NH3output?:display_count=y&amp;amp;publish=yes&amp;amp;:origin=viz_share_link&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; margin-bottom: 1em;&quot; target=&quot;_blank&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;981&quot; data-original-width=&quot;1390&quot; height=&quot;450&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicIcOP1I6hXtqdgru1Hyxyw_XxL8MZQBgvmyluC6eXmxartgnzBQzINOVg4gX0ZAcrO6Va83NVr20xYLtGuPN6O7mKnCZnw49kIS7G1hhY-aELHDlT4sPU8CMEyo71U1SRHGuhDmeAh7zn/s640/NH3+RIVM+Tableau+Dashboard.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  129. &lt;br /&gt;
  130. &lt;i&gt;Deze dashboard kun je het beste met een tablet of desktop pc openen. Met je smartphone werkt het ook. Snelheid kan wat traag overkomen. Dit zijn namelijk ruim 730,000 datapunten.&lt;/i&gt;&lt;br /&gt;
  131. &lt;br /&gt;
  132. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  133. &lt;/div&gt;
  134. &lt;h3&gt;
  135. Over de data-sets&lt;/h3&gt;
  136. Afgelopen 07-jan-2020 gaf het RIVM twee setjes data met 730K rijen vrij. Eén over NH3 en eentje over NOx. Helaas zonder enige documentatie. Om de kolomwaarden in de data te begrijpen, heb ik van het RIVM &lt;a href=&quot;https://www.rivm.nl/sites/default/files/2018-11/Maak_bronbestand-v1.8.xlsm&quot; target=&quot;_blank&quot;&gt;deze spreadsheet&lt;/a&gt; achterhaald.&lt;br /&gt;
  137. &lt;br /&gt;
  138. &lt;h3&gt;
  139. Observaties mbt de NH3 data-set&lt;/h3&gt;
  140. Men heeft bewust de macro’s (programma code) uit de spreadsheet verwijderd. Zelf zou ik dat alleen doen, als ik zou willen dat niemand kan begrijpen hoe ik de gegevens manipuleer.&lt;br /&gt;
  141. &lt;br /&gt;
  142. De data-set vertoont wel erg veel overeenkomsten met de input die door gemeente-ambtenaren mbv deze spreadsheet kennelijk worden ingeklopt.&lt;br /&gt;
  143. &lt;br /&gt;
  144. &lt;h3&gt;
  145. Samenwerking en verantwoording&lt;/h3&gt;
  146. Data is afkomstig van het RIVM. Evert Mouw, die er &lt;a href=&quot;https://www.furorteutonicus.eu/2020/01/11/stikstofdata-een-eerste-blik-op-de-emissiedata/&quot; target=&quot;_blank&quot;&gt;een eerste blik&lt;/a&gt; op wierp, heeft de RD coordinaten naar WGS omgezet. Anna van Ee gaf veel goede tips en heeft het stikstof-verhaal zeer goed in beeld. Dit is een spontane team effort, als gevolg van de ‘FDF Klets’ groep in Telegram. Tijdens een video-call met &lt;a href=&quot;http://www.rutgervandennoort.nl/&quot; target=&quot;_blank&quot;&gt;Rutger van den Noort&lt;/a&gt; en &lt;a href=&quot;https://twitter.com/robert_bor/status/1217192495752392706&quot; target=&quot;_blank&quot;&gt;Robert Bor&lt;/a&gt;, die kennelijk al eerder aan &lt;a href=&quot;https://www.rivm.nl/documenten/vragen-gesteld-door-rutger-van-der-noort-ea-inclusief-antwoorden-rivm&quot; target=&quot;_blank&quot;&gt;RIVM vragen&lt;/a&gt; stelden, kreeg ik er vertrouwen in om dit te publiceren.&lt;br /&gt;
  147. &lt;br /&gt;
  148. &lt;h2&gt;
  149. Vervolg stappen&lt;/h2&gt;
  150. &lt;br /&gt;
  151. &lt;ul&gt;
  152. &lt;li&gt;Volgende visualisatie voor NOx data (dit weekend)&lt;/li&gt;
  153. &lt;li&gt;Calibratie RIVM data met US EPA (Amerikaanse Environment Protection Agency) alsmede US Department of Agriculture.&lt;/li&gt;
  154. &lt;li&gt;Universiteit van Amsterdam (UVA) gaat aan de slag. Ik hoop echt dat het UVA met resultaten kan komen voordat de politiek nog meer Management by Surprise gaat praktiseren. Zie &lt;a href=&quot;https://www.uva.nl/content/nieuws/nieuwsberichten/2019/11/uva-gaat-stikstofdepositie-meten.html?1579203858792&quot; target=&quot;_blank&quot;&gt;deze link&lt;/a&gt;&lt;/li&gt;
  155. &lt;li&gt;Evert Mouw gaat proberen de data nog verder te verrijken richting bv. GPX.&lt;/li&gt;
  156. &lt;/ul&gt;
  157. &lt;br /&gt;
  158. &lt;br /&gt;</description><link>http://www.aukema.org/2020/01/rivm-nh3-administratie-op-straat.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicIcOP1I6hXtqdgru1Hyxyw_XxL8MZQBgvmyluC6eXmxartgnzBQzINOVg4gX0ZAcrO6Va83NVr20xYLtGuPN6O7mKnCZnw49kIS7G1hhY-aELHDlT4sPU8CMEyo71U1SRHGuhDmeAh7zn/s72-c/NH3+RIVM+Tableau+Dashboard.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-292696911063318966</guid><pubDate>Thu, 07 Nov 2019 09:15:00 +0000</pubDate><atom:updated>2019-11-07T10:16:08.573+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Boeren</category><category domain="http://www.blogger.com/atom/ns#">Emissie</category><category domain="http://www.blogger.com/atom/ns#">NOx</category><category domain="http://www.blogger.com/atom/ns#">Stikstof</category><title>30 jaar NOx Emmissiecijfers</title><description>In mijn pogingen om de oeverloos complexe stikstof discussie ietwat te verhelderen, hier de emissiecijfers van emissieregistratie.nl in grafiekvorm.&lt;br /&gt;
  159. &lt;br /&gt;
  160. Lijkt me evident dat we de Boeren, Bouwers en Burgers gewoon met rust kunnen laten.&lt;br /&gt;
  161. De verdeling voor 2018 is als volgt:&lt;br /&gt;
  162. &lt;br /&gt;
  163. &lt;table border=&quot;1&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; dir=&quot;ltr&quot; style=&quot;border-collapse: collapse; border: none; color: black; font-family: Arial; font-size: 10pt; table-layout: fixed; width: 0px;&quot; xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;&lt;colgroup&gt;&lt;col width=&quot;100&quot;&gt;&lt;/col&gt;&lt;col width=&quot;100&quot;&gt;&lt;/col&gt;&lt;/colgroup&gt;&lt;tbody&gt;
  164. &lt;tr style=&quot;height: 21px;&quot;&gt;&lt;td data-sheets-value=&quot;{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Industrie&amp;quot;}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; vertical-align: bottom;&quot;&gt;Industrie&lt;/td&gt;&lt;td data-sheets-formula=&quot;=R[0]C[-3]/R9C11&quot; data-sheets-numberformat=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;2&amp;quot;:&amp;quot;0%&amp;quot;,&amp;quot;3&amp;quot;:1}&quot; data-sheets-value=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:0.20295202952029523}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; text-align: right; vertical-align: bottom;&quot;&gt;20%&lt;/td&gt;&lt;/tr&gt;
  165. &lt;tr style=&quot;height: 21px;&quot;&gt;&lt;td data-sheets-value=&quot;{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Verkeer&amp;quot;}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; vertical-align: bottom;&quot;&gt;Verkeer&lt;/td&gt;&lt;td data-sheets-formula=&quot;=R[0]C[-3]/R9C11&quot; data-sheets-numberformat=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;2&amp;quot;:&amp;quot;0%&amp;quot;,&amp;quot;3&amp;quot;:1}&quot; data-sheets-value=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:0.5617056170561706}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; text-align: right; vertical-align: bottom;&quot;&gt;56%&lt;/td&gt;&lt;/tr&gt;
  166. &lt;tr style=&quot;height: 21px;&quot;&gt;&lt;td data-sheets-value=&quot;{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Consumenten&amp;quot;}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; vertical-align: bottom;&quot;&gt;Consumenten&lt;/td&gt;&lt;td data-sheets-formula=&quot;=R[0]C[-3]/R9C11&quot; data-sheets-numberformat=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;2&amp;quot;:&amp;quot;0%&amp;quot;,&amp;quot;3&amp;quot;:1}&quot; data-sheets-value=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:0.03649036490364904}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; text-align: right; vertical-align: bottom;&quot;&gt;4%&lt;/td&gt;&lt;/tr&gt;
  167. &lt;tr style=&quot;height: 21px;&quot;&gt;&lt;td data-sheets-value=&quot;{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Bouw&amp;quot;}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; vertical-align: bottom;&quot;&gt;Bouw&lt;/td&gt;&lt;td data-sheets-formula=&quot;=R[0]C[-3]/R9C11&quot; data-sheets-numberformat=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;2&amp;quot;:&amp;quot;0%&amp;quot;,&amp;quot;3&amp;quot;:1}&quot; data-sheets-value=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:0.029520295202952032}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; text-align: right; vertical-align: bottom;&quot;&gt;3%&lt;/td&gt;&lt;/tr&gt;
  168. &lt;tr style=&quot;height: 21px;&quot;&gt;&lt;td data-sheets-value=&quot;{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Landbouw&amp;quot;}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; vertical-align: bottom;&quot;&gt;Landbouw&lt;/td&gt;&lt;td data-sheets-formula=&quot;=R[0]C[-3]/R9C11&quot; data-sheets-numberformat=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;2&amp;quot;:&amp;quot;0%&amp;quot;,&amp;quot;3&amp;quot;:1}&quot; data-sheets-value=&quot;{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:0.16933169331693318}&quot; style=&quot;border: 1px solid rgb(204, 204, 204); overflow: hidden; padding: 2px 3px; text-align: right; vertical-align: bottom;&quot;&gt;17%&lt;/td&gt;&lt;/tr&gt;
  169. &lt;/tbody&gt;&lt;/table&gt;
  170. &lt;br /&gt;
  171. &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
  172. &lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo3x0nQ1s0QNJ_X3ao41xufhkpAyMsRElPVSPMbdM8MbnDbdcuoszctJY4qzYhQEfotX1m0PASRjRAv7yTA6wSYqxrWuedkvdKaShp6R97Gk7HT0OWv0vqxeHkNNEp5dPXFhLzphSehQet/s1600/NOx+Emissiecijfers+Nederland.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;579&quot; data-original-width=&quot;937&quot; height=&quot;394&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo3x0nQ1s0QNJ_X3ao41xufhkpAyMsRElPVSPMbdM8MbnDbdcuoszctJY4qzYhQEfotX1m0PASRjRAv7yTA6wSYqxrWuedkvdKaShp6R97Gk7HT0OWv0vqxeHkNNEp5dPXFhLzphSehQet/s640/NOx+Emissiecijfers+Nederland.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
  173. &lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Data: http://emissieregistratie.nl/erpubliek/erpub/international/nec.aspx&lt;/td&gt;&lt;/tr&gt;
  174. &lt;/tbody&gt;&lt;/table&gt;
  175. Weet dat de cijfers m.b.t. Verkeer nagenoeg geen uitstoot van Vliegverkeer bevat, zoals ik al in een eerdere blog-post had laten zien (&lt;a href=&quot;http://www.aukema.org/2019/10/cbs-leugens-over-nox-bijdrage-luchtvaart.html&quot; target=&quot;_blank&quot;&gt;link&lt;/a&gt;).</description><link>http://www.aukema.org/2019/11/30-jaar-nox-emmissiecijfers.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo3x0nQ1s0QNJ_X3ao41xufhkpAyMsRElPVSPMbdM8MbnDbdcuoszctJY4qzYhQEfotX1m0PASRjRAv7yTA6wSYqxrWuedkvdKaShp6R97Gk7HT0OWv0vqxeHkNNEp5dPXFhLzphSehQet/s72-c/NOx+Emissiecijfers+Nederland.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-2936084926385629008</guid><pubDate>Fri, 01 Nov 2019 07:01:00 +0000</pubDate><atom:updated>2019-11-01T08:01:40.928+01:00</atom:updated><title>Turkse Toeristen</title><description>Vandaag ga ik op stap met twee Turkse toeristen die een stukje Nederland willen zien. Begin dit jaar was ik op bezoek bij hen in het gastvrije Turkije. Zij spreken geen Nederlands en ik geen Turks, dus het lijkt me leuk om naar het Rijksmuseum of Mauritshuis te gaan. Jammer genoeg bieden geen van beide een oortelefoontje aan in het Turks.&lt;br /&gt;
  176. &lt;br /&gt;
  177. Dit snap ik niet. Turkije, Marokko en Polen de landen waar de meeste immigranten vandaan komen. Bijna elke gemeente-folder biedt haar info in deze talen.&lt;br /&gt;
  178. &lt;br /&gt;
  179. Welnu, dan maar een stille tocht door het museum... Zonder integratie...&lt;br /&gt;
  180. Gemiste kans, lijkt me.&lt;br /&gt;
  181. Zoveel moeite kan dit niet kosten, toch?</description><link>http://www.aukema.org/2019/11/turkse-toeristen.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-546449102575366590</guid><pubDate>Fri, 18 Oct 2019 06:31:00 +0000</pubDate><atom:updated>2019-10-18T08:31:09.647+02:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">NOx</category><category domain="http://www.blogger.com/atom/ns#">RIVM</category><title>NOx emissions according to RIVM</title><description>This morning I stumbled upon this interactive map:&amp;nbsp;&lt;a href=&quot;https://waqi.info/&quot;&gt;https://waqi.info/&lt;/a&gt;&lt;br /&gt;
  182. &lt;br /&gt;
  183. Notice the NOx concentrations are high in big cities, very low in Farmers land:&lt;br /&gt;
  184. &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
  185. &lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFxg2edcW4JnuGPUAGmSIapuji23C3c7C_PrUleDXCQEfg2Wi-RrIVA93xJhyaEZ8KpR_6_pU9lL5cWNodrtKwAXi-z8zf3BwoV_w7fsFVsYn1cIkhnIvQm683VL6y8oCYsagNm3DO7qTp/s1600/3835A90E-D696-4403-948C-EFEB864114CF.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1200&quot; data-original-width=&quot;1600&quot; height=&quot;480&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFxg2edcW4JnuGPUAGmSIapuji23C3c7C_PrUleDXCQEfg2Wi-RrIVA93xJhyaEZ8KpR_6_pU9lL5cWNodrtKwAXi-z8zf3BwoV_w7fsFVsYn1cIkhnIvQm683VL6y8oCYsagNm3DO7qTp/s640/3835A90E-D696-4403-948C-EFEB864114CF.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
  186. &lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;waqi.info&lt;/td&gt;&lt;/tr&gt;
  187. &lt;/tbody&gt;&lt;/table&gt;
  188. &lt;br /&gt;
  189. &lt;br /&gt;
  190. Also interesting to see that the source is RIVM.&lt;br /&gt;
  191. I am confused. Why is RIVM using models with assumptions when the report to government?&lt;br /&gt;
  192. Why don’t they just show the Real Thing?&lt;br /&gt;
  193. &lt;br /&gt;
  194. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  195. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6ohlHVaP8-It2cBrIoCr-CmpH0Tswq1aa4C4dZ_4P-y4cpWxutgC0WWM7e-_wW58VzEI5apdArgfv0A9psQGTWd1ifgxPpdGLBhHUMLnsmtqLlLYeIM-NmFHyiG4W_6U2jocCCv6jUYX2/s1600/18E44FAE-786A-4AAF-8124-CC48CE5F534E.jpeg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;936&quot; data-original-width=&quot;513&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6ohlHVaP8-It2cBrIoCr-CmpH0Tswq1aa4C4dZ_4P-y4cpWxutgC0WWM7e-_wW58VzEI5apdArgfv0A9psQGTWd1ifgxPpdGLBhHUMLnsmtqLlLYeIM-NmFHyiG4W_6U2jocCCv6jUYX2/s320/18E44FAE-786A-4AAF-8124-CC48CE5F534E.jpeg&quot; width=&quot;175&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  196. </description><link>http://www.aukema.org/2019/10/nox-emissions-according-to-rivm.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFxg2edcW4JnuGPUAGmSIapuji23C3c7C_PrUleDXCQEfg2Wi-RrIVA93xJhyaEZ8KpR_6_pU9lL5cWNodrtKwAXi-z8zf3BwoV_w7fsFVsYn1cIkhnIvQm683VL6y8oCYsagNm3DO7qTp/s72-c/3835A90E-D696-4403-948C-EFEB864114CF.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-8813851644696071975</guid><pubDate>Fri, 18 Oct 2019 04:17:00 +0000</pubDate><atom:updated>2019-10-18T08:18:43.381+02:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">CBS</category><category domain="http://www.blogger.com/atom/ns#">NOx</category><category domain="http://www.blogger.com/atom/ns#">RIVM</category><category domain="http://www.blogger.com/atom/ns#">TNO</category><title>NASA Factual Observations on NOx</title><description>Here in The Netherlands, farmers are assumed to cause 60+% of NOx emissions.&lt;br /&gt;
  197. Government institutes (RIVM, TNO) do not measure, they calculate using proprietary models with mainly assumptions.&lt;br /&gt;
  198. &lt;br /&gt;
  199. So who observes the factual, acual situation? NASA does.&lt;br /&gt;
  200. In this video, NASA shows the opposite:&amp;nbsp;&lt;a href=&quot;https://svs.gsfc.nasa.gov/12096&quot;&gt;https://svs.gsfc.nasa.gov/12096&lt;/a&gt;&lt;br /&gt;
  201. &lt;br /&gt;
  202. &lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
  203. &lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-XFh8ghQn2vjWSrjMr_hlw8WA6IeD6R642YQ_ERF7uBPRuqclSEIHczscVnA0gVV6YsVZNg-0AyGLpEfqPkkAyQ4rW-ZvQxLSESCd6J3sMAWKkA-cCrZTVVSMkif-oTB8e4K5jJi_dVxb/s1600/0F7BBE94-CFF5-442D-876A-A612E1353CF7.jpeg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;900&quot; data-original-width=&quot;1600&quot; height=&quot;360&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-XFh8ghQn2vjWSrjMr_hlw8WA6IeD6R642YQ_ERF7uBPRuqclSEIHczscVnA0gVV6YsVZNg-0AyGLpEfqPkkAyQ4rW-ZvQxLSESCd6J3sMAWKkA-cCrZTVVSMkif-oTB8e4K5jJi_dVxb/s640/0F7BBE94-CFF5-442D-876A-A612E1353CF7.jpeg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
  204. &lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://svs.gsfc.nasa.gov/12096&quot; style=&quot;text-align: start;&quot;&gt;https://svs.gsfc.nasa.gov/12096&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
  205. &lt;/tbody&gt;&lt;/table&gt;
  206. &lt;br /&gt;
  207. &lt;br /&gt;
  208. =&amp;gt; Dutch politicians should watch this.</description><link>http://www.aukema.org/2019/10/nasa-factual-observations-on-nox.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-XFh8ghQn2vjWSrjMr_hlw8WA6IeD6R642YQ_ERF7uBPRuqclSEIHczscVnA0gVV6YsVZNg-0AyGLpEfqPkkAyQ4rW-ZvQxLSESCd6J3sMAWKkA-cCrZTVVSMkif-oTB8e4K5jJi_dVxb/s72-c/0F7BBE94-CFF5-442D-876A-A612E1353CF7.jpeg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-5953239098357331298</guid><pubDate>Sun, 06 Oct 2019 08:50:00 +0000</pubDate><atom:updated>2019-11-07T10:17:00.548+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Aviation</category><category domain="http://www.blogger.com/atom/ns#">CBS</category><category domain="http://www.blogger.com/atom/ns#">NOx</category><category domain="http://www.blogger.com/atom/ns#">RIVM</category><category domain="http://www.blogger.com/atom/ns#">TNO</category><title>CBS and RIVM about NOx Emission from Aviation</title><description>Factual evidence versus government assumptions.&lt;br /&gt;
  209. CBS (Dutch government bureau of statistics) has a very high reputation when it comes to fact sheets.&lt;br /&gt;
  210. RIVM is a Dutch government health institute.&lt;br /&gt;
  211. &lt;br /&gt;
  212. CBS&amp;nbsp;&lt;a href=&quot;https://opendata.cbs.nl/statline/#/CBS/nl/dataset/7062/table?fromstatweb&quot; target=&quot;_blank&quot;&gt;published&lt;/a&gt; their report on NOx contribution by the various sectors of transportation.&lt;br /&gt;
  213. Regarding Air traffic, they ONLY CONSIDER TAXI, START AND LANDING.&lt;br /&gt;
  214. RIVM does the same with their NOx models.&lt;br /&gt;
  215. &lt;br /&gt;
  216. Now consider these two screenshots I took (06-oct-2019 10:32) from Plane Finder, and draw only one conclusion: TRUE OR FALSE?&lt;br /&gt;
  217. &lt;br /&gt;
  218. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  219. Air traffic &amp;lt; 3000ft to and from Schiphol:&lt;/div&gt;
  220. &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
  221. &lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEEXjQ9hwddMM_A7VXo1tnhpxa_haaJKu9_nrhPS4zdOloWJa2kIKTGx7xWlRKWHtXqKo667SWKjlh3HphIUT46Z4162T2VYnpIU7hmxdG75FT_T4NmZmxn0ZoCviBcNhi5tW9PXU4FGy3/s1600/0B62D2EF-A438-4D78-88E0-98C2AEBDF483.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1200&quot; data-original-width=&quot;1600&quot; height=&quot;480&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEEXjQ9hwddMM_A7VXo1tnhpxa_haaJKu9_nrhPS4zdOloWJa2kIKTGx7xWlRKWHtXqKo667SWKjlh3HphIUT46Z4162T2VYnpIU7hmxdG75FT_T4NmZmxn0ZoCviBcNhi5tW9PXU4FGy3/s640/0B62D2EF-A438-4D78-88E0-98C2AEBDF483.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
  222. &lt;br /&gt;&lt;/td&gt;&lt;/tr&gt;
  223. &lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Add caption&lt;/td&gt;&lt;/tr&gt;
  224. &lt;/tbody&gt;&lt;/table&gt;
  225. All air traffic:&lt;br /&gt;
  226. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  227. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYyddyDf1k1xZg_qwIzfg3CJ4w-PvQqKWvzAIV6cY8YgcpTUqTvWHBaNbbreOgEge1pTGuBK9tPqFQM-dG92euayGkKdaW7v1Bp0zz11NAjdBYKeEuOx1SxyLgs0FEZ3JMHMJEL_RPOXpJ/s1600/869A9C2A-8D98-4CC7-B57C-5111720C57AF.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1200&quot; data-original-width=&quot;1600&quot; height=&quot;480&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYyddyDf1k1xZg_qwIzfg3CJ4w-PvQqKWvzAIV6cY8YgcpTUqTvWHBaNbbreOgEge1pTGuBK9tPqFQM-dG92euayGkKdaW7v1Bp0zz11NAjdBYKeEuOx1SxyLgs0FEZ3JMHMJEL_RPOXpJ/s640/869A9C2A-8D98-4CC7-B57C-5111720C57AF.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  228. &lt;br /&gt;</description><link>http://www.aukema.org/2019/10/cbs-leugens-over-nox-bijdrage-luchtvaart.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEEXjQ9hwddMM_A7VXo1tnhpxa_haaJKu9_nrhPS4zdOloWJa2kIKTGx7xWlRKWHtXqKo667SWKjlh3HphIUT46Z4162T2VYnpIU7hmxdG75FT_T4NmZmxn0ZoCviBcNhi5tW9PXU4FGy3/s72-c/0B62D2EF-A438-4D78-88E0-98C2AEBDF483.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-6066241344922521371</guid><pubDate>Tue, 01 Oct 2019 21:39:00 +0000</pubDate><atom:updated>2019-10-01T23:44:45.448+02:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Domino</category><category domain="http://www.blogger.com/atom/ns#">HCL</category><category domain="http://www.blogger.com/atom/ns#">Lotus</category><category domain="http://www.blogger.com/atom/ns#">Notes</category><title>Lotus notes &amp; Domino now owned by HCL</title><description>That looks promising...&lt;br /&gt;
  229. &lt;br /&gt;
  230. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  231. &lt;/div&gt;
  232. &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
  233. &lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhj3di3_i0n90SNODbfowPGAF3ZQL25Og9Af2VpgiagFCrrxaz_d4qWd-XvgJvsYgAWs9EpdeUJ-PZ6Je3AEyaB8RCuiBjwJMfwNL9auaQjlFAzksGgWGh0lZNVTFfy16J4ZrcTEanx1YBG/s1600/Screenshot+2019-10-01+at+23.41.44.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1022&quot; data-original-width=&quot;1600&quot; height=&quot;408&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhj3di3_i0n90SNODbfowPGAF3ZQL25Og9Af2VpgiagFCrrxaz_d4qWd-XvgJvsYgAWs9EpdeUJ-PZ6Je3AEyaB8RCuiBjwJMfwNL9auaQjlFAzksGgWGh0lZNVTFfy16J4ZrcTEanx1YBG/s640/Screenshot+2019-10-01+at+23.41.44.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
  234. &lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Safari screen capture, Oct-01,2019 23:37 CEDT&lt;/td&gt;&lt;/tr&gt;
  235. &lt;/tbody&gt;&lt;/table&gt;
  236. &lt;br /&gt;</description><link>http://www.aukema.org/2019/10/lotus-notes-domino-now-owned-by-hcl.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhj3di3_i0n90SNODbfowPGAF3ZQL25Og9Af2VpgiagFCrrxaz_d4qWd-XvgJvsYgAWs9EpdeUJ-PZ6Je3AEyaB8RCuiBjwJMfwNL9auaQjlFAzksGgWGh0lZNVTFfy16J4ZrcTEanx1YBG/s72-c/Screenshot+2019-10-01+at+23.41.44.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-5415152453267454162</guid><pubDate>Thu, 17 Nov 2016 23:50:00 +0000</pubDate><atom:updated>2016-11-18T00:50:58.686+01:00</atom:updated><title>Verkeersintensiteit N804 Hoenderloo</title><description>De provincie Gelderland kwam recentelijk met plannen om de N804 voor alle autoverkeer &amp;nbsp;af te sluiten. Groot protest tijdens de inloopavond afgelopen maandag, zoals te zien op &lt;a href=&quot;http://www.omroepgelderland.nl/tv/programma/211935511/GLD-Vandaag/aflevering/696255904&quot; target=&quot;_blank&quot;&gt;TV Gelderland&lt;/a&gt;&amp;nbsp;(vanaf 4:30).&lt;br /&gt;
  237. &lt;br /&gt;
  238. Doel van deze blogpost is om de provincie met hun eigen feitenmateriaal bekend te maken.&lt;br /&gt;
  239. En omdat het &lt;a href=&quot;http://applicaties.gelderland.nl/EFormulieren/formulier.asp?scenarioid=N804&quot; target=&quot;_blank&quot;&gt;reactieformulier&lt;/a&gt; geen ruimte biedt om materiaal aan te leveren, kan vanuit het formulier naar dit feiten-materiaal worden gerefereerd.&lt;br /&gt;
  240. &lt;h3&gt;
  241. Feiten:&lt;/h3&gt;
  242. Onderstaande grafiek toont de verkeersintensiteit tijdens werkdagen (dus geen weekends) over de afgelopen 10 jaar, zoals door de provincie is gemeten op het permanente meetpunt Deelen.&lt;br /&gt;
  243. &lt;br /&gt;
  244. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  245. &lt;/div&gt;
  246. &lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
  247. &lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoY40COc2796CcFlJZo7XOWL1v6FvhlTJsq4UEwtq9lFfHdcYccP8GCahOvLwVNmZHo4Vk0XbPMUCIHHblZoIMvP4CS81Cmt1KBaxb7-SW8dMXaXto-y84C3yhF-1UxbosYB9MxPF6Ijak/s1600/N804+werkdagen.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;340&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoY40COc2796CcFlJZo7XOWL1v6FvhlTJsq4UEwtq9lFfHdcYccP8GCahOvLwVNmZHo4Vk0XbPMUCIHHblZoIMvP4CS81Cmt1KBaxb7-SW8dMXaXto-y84C3yhF-1UxbosYB9MxPF6Ijak/s640/N804+werkdagen.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
  248. &lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;N804 - werkdagen&lt;/td&gt;&lt;/tr&gt;
  249. &lt;/tbody&gt;&lt;/table&gt;
  250. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  251. Merk op hoe de introductie van de 60-KM zone een significante verlaging van bijna 3,000 tot 1,900 tot gevolg heeft gehad.&lt;/div&gt;
  252. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  253. &lt;br /&gt;&lt;/div&gt;
  254. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  255. Als we kijken naar de zondagen -een goede indicator voor toeristisch verkeer- ziet het beeld er vergelijkbaar uit.&amp;nbsp;&lt;/div&gt;
  256. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  257. &lt;br /&gt;&lt;/div&gt;
  258. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  259. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEqWPhXivVj0UERUVPw6ZN1UmVP5qeesVkdX6mOkNGIgCIRXL4pTYMjvP5dsXD3eQbiSMS0FZxBi7GsAEKXRUfhGS9iqahD0M4RmMnQO4-EovjNX_U8NzBgOSO6vZ5tgNzeuqXpxczNc53/s1600/N804+zondagen.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;340&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEqWPhXivVj0UERUVPw6ZN1UmVP5qeesVkdX6mOkNGIgCIRXL4pTYMjvP5dsXD3eQbiSMS0FZxBi7GsAEKXRUfhGS9iqahD0M4RmMnQO4-EovjNX_U8NzBgOSO6vZ5tgNzeuqXpxczNc53/s640/N804+zondagen.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  260. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  261. &lt;br /&gt;&lt;/div&gt;
  262. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  263. Impact van de 60-KM zone op economische activiteit in Hoenderloo bedroeg 500 bewegingen. Een totale afsluiting zal leiden tot een afname van nog eens 1,850 bewegingen.&amp;nbsp;&lt;/div&gt;
  264. &lt;h3&gt;
  265. Vragen:&lt;/h3&gt;
  266. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  267. &lt;/div&gt;
  268. &lt;ol&gt;
  269. &lt;li&gt;Is het een wens van de provincie om Hoenderloo economisch volledig lam te leggen?&lt;/li&gt;
  270. &lt;li&gt;Waarom levert de provincie geen feiten omtrent verkeersveiligheid?&lt;/li&gt;
  271. &lt;li&gt;Waarom moet ik als burger 2,500 EUR per jaar betalen voor &lt;a href=&quot;http://wiki.stelselvanoverheidsgegevens.nl/index.php/Bestand_geRegistreerde_Ongevallen_in_Nederland_(BRON)&quot; target=&quot;_blank&quot;&gt;gegevens inzake verkeersveiligheid&lt;/a&gt;?&lt;/li&gt;
  272. &lt;/ol&gt;
  273. &lt;div&gt;
  274. &lt;br /&gt;&lt;/div&gt;
  275. &lt;br /&gt;
  276. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  277. &lt;br /&gt;&lt;/div&gt;
  278. </description><link>http://www.aukema.org/2016/11/verkeersintensiteit-n804-hoenderloo.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoY40COc2796CcFlJZo7XOWL1v6FvhlTJsq4UEwtq9lFfHdcYccP8GCahOvLwVNmZHo4Vk0XbPMUCIHHblZoIMvP4CS81Cmt1KBaxb7-SW8dMXaXto-y84C3yhF-1UxbosYB9MxPF6Ijak/s72-c/N804+werkdagen.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-1765180419494467249</guid><pubDate>Thu, 24 Sep 2015 14:00:00 +0000</pubDate><atom:updated>2015-09-24T16:00:00.198+02:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Books</category><category domain="http://www.blogger.com/atom/ns#">Branding</category><category domain="http://www.blogger.com/atom/ns#">Marketing</category><title>Startup Entrepreneur Branding Book in 30 Minutes</title><description>&lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;This is how much time it took me to consume this book by Michiel Maandag.&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
  279. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
  280. &lt;br /&gt;
  281. &lt;h4&gt;
  282. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;How I got it?&amp;nbsp;&lt;/span&gt;&lt;/h4&gt;
  283. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;The author Michiel is an ex-colleague of mine and we met again after 16 (!) years. We agreed to trade his book against a cucumber from my glass-house. How Dutch &amp;amp; cool is that?&lt;/span&gt;&lt;br /&gt;
  284. &lt;h4&gt;
  285. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;Why am I Excited about this Book?&lt;/span&gt;&lt;/h4&gt;
  286. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;I can think of three quick reasons:&lt;/span&gt;&lt;br /&gt;
  287. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
  288. &lt;ol&gt;&lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;
  289. &lt;li&gt;&lt;span style=&quot;letter-spacing: 0px;&quot;&gt;Because Michiel produces a Dutch and Direct View on Branding, in a ‘Jip and Janneke’ way (Dutch for an extreme simple method to digest serious topics) and I recognise every word he writes. And I did read all 150+ pages in less than 30 minutes.&lt;/span&gt;&lt;span style=&quot;letter-spacing: 0px;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/li&gt;
  290. &lt;li&gt;&lt;span style=&quot;letter-spacing: 0px;&quot;&gt;I don’t particularly like Consultants (consider Brand Advisors one of them). Yet Michiel manages to produce a top quality book all by himself. With so much value that I dare to endorse his book to every start-up entrepreneur with serious plans.&lt;/span&gt;&lt;/li&gt;
  291. &lt;li&gt;&lt;span style=&quot;letter-spacing: 0px;&quot;&gt;The book makes me think and glue certain aspects in my mind as an entrepreneur. It also inspires me to think further than my current horizon.&lt;/span&gt;&lt;/li&gt;
  292. &lt;/span&gt;&lt;/ol&gt;
  293. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;
  294. &lt;/span&gt;&lt;br /&gt;
  295. &lt;h4&gt;
  296. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;Ready to Read?&lt;/span&gt;&lt;/h4&gt;
  297. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;I can borrow it to you if you mail me, or go here to purchase: http://www.theonlybrandbook.com/#get_it&lt;/span&gt;&lt;br /&gt;
  298. &lt;br /&gt;
  299. &lt;i&gt;Obviously I expect an equally good review on the cucumber I gave to Michiel ;-)&lt;/i&gt;&lt;br /&gt;
  300. &lt;div style=&quot;font-family: Helvetica; font-size: 11px; min-height: 13px;&quot;&gt;
  301. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;/div&gt;
  302. </description><link>http://www.aukema.org/2015/09/startup-entrepreneur-branding-book-in.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total><georss:featurename>Hoenderloo, Netherlands</georss:featurename><georss:point>52.1176211 5.8777814999999691</georss:point><georss:box>51.9615601 5.5550579999999687 52.2736821 6.2005049999999695</georss:box></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-4108446903951442297</guid><pubDate>Mon, 17 Aug 2015 21:16:00 +0000</pubDate><atom:updated>2015-08-19T23:24:36.788+02:00</atom:updated><title>How on earth did LinkedIn obtain my Google credentials?!</title><description>&lt;span style=&quot;color: #141823; font-family: helvetica, arial, sans-serif;&quot;&gt;&lt;span style=&quot;background-color: white; font-size: 14px; line-height: 19px;&quot;&gt;Today I prompted myself to log into Linkedin again. To find an amazing number of requests in my inbox. (&lt;/span&gt;&lt;/span&gt;https://www.linkedin.com/fetch/importAndInviteEntry?trk=nav_utilities_add_connx)&lt;br /&gt;
  303. &lt;br /&gt;
  304. Upon clicking the link, it struck my attention that Linkedin offered me my Gmail login on my Mac &amp;nbsp;offered me a login ID without a password prompt:&lt;br /&gt;
  305. &lt;br /&gt;
  306. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  307. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTQH5cjb6zHJTzZFmNvWsIaA6cSImDWNA_iqjJ0EjQ6IaRXjQUjub-OakEO0ofLyACG3QVijeVLZxqkRgnyv_BFfKXzAswNRc0ysDm2D-rHw7eq0KSnWtugGDTwhE6GTHqSVmO8PccaEC9/s1600/linkedin_request.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;256&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTQH5cjb6zHJTzZFmNvWsIaA6cSImDWNA_iqjJ0EjQ6IaRXjQUjub-OakEO0ofLyACG3QVijeVLZxqkRgnyv_BFfKXzAswNRc0ysDm2D-rHw7eq0KSnWtugGDTwhE6GTHqSVmO8PccaEC9/s640/linkedin_request.png&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  308. &lt;br /&gt;
  309. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  310. &lt;/div&gt;
  311. I can assure you that Linkedin does not have my Google credentials, coz all they should know about my email address is &#39;&lt;a href=&quot;mailto:linkedin.com@aukema.org&quot;&gt;linkedin at aukema.org&lt;/a&gt;.&#39;&lt;br /&gt;
  312. &lt;br /&gt;
  313. Wonder when Linkedin offers me to import addresses from my &lt;a href=&quot;https://www.rabobank.nl/&quot;&gt;bank account&lt;/a&gt;.</description><link>http://www.aukema.org/2015/08/how-on-earth-did-linkedin-obtain-my.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTQH5cjb6zHJTzZFmNvWsIaA6cSImDWNA_iqjJ0EjQ6IaRXjQUjub-OakEO0ofLyACG3QVijeVLZxqkRgnyv_BFfKXzAswNRc0ysDm2D-rHw7eq0KSnWtugGDTwhE6GTHqSVmO8PccaEC9/s72-c/linkedin_request.png" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-1464177596114214901</guid><pubDate>Fri, 14 Nov 2014 09:11:00 +0000</pubDate><atom:updated>2014-11-16T07:49:01.998+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">HealthCare</category><category domain="http://www.blogger.com/atom/ns#">Open-Data</category><category domain="http://www.blogger.com/atom/ns#">RTL</category><category domain="http://www.blogger.com/atom/ns#">Vektis</category><title>HealthCare OpenData shows cost of pregnancy at men aged 76 are the highest in the Dutch city of Lelystad</title><description>&lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  314. &lt;span style=&quot;letter-spacing: 0px;&quot;&gt;A Dutch organisation by the name Vektis recently published an open-data file showing the costs that healthcare insurers have paid in 2012. With this data set, Vektis aims to help stake holders gain a better understanding with the ultimate goal to improve quality and cost of #healthcare.&lt;/span&gt;&lt;/div&gt;
  315. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  316. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  317. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  318. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;Dutch RTL Nieuws analysed the raw data and published several articles about this (&lt;a href=&quot;http://www.rtlnieuws.nl/nieuws/binnenland/wie-zijn-het-gezondst&quot; target=&quot;_blank&quot;&gt;link&lt;/a&gt;,&amp;nbsp;in dutch) and aired it on their prime time TV news last night.&lt;/span&gt;&lt;/div&gt;
  319. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  320. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  321. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  322. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;So did I, but from a different angle:&lt;/span&gt;&lt;/div&gt;
  323. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  324. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  325. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  326. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;Vektis raw data reveals 56 men, aged 76, within the dutch city of Lelystad who expensed 2,002.29 euro for cost of maternity and obstetric healthcare. Can we conclude that 76 year old men in Lelystad expense an average of 35,76 euro for pregnancy?&lt;/span&gt;&lt;/div&gt;
  327. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  328. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  329. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  330. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;I don’t think so.&lt;/span&gt;&lt;/div&gt;
  331. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  332. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  333. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  334. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;The raw data of Vektis&amp;nbsp;contains 40 records where male people have submitted expense reports for maternity and obstetric care, totalling 20,627 euro.&lt;/span&gt;&lt;/div&gt;
  335. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  336. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  337. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  338. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;The data does not show how many expense reports were filed, nor by how many people. Therefore we have to be very very careful to draw conclusions.&lt;/span&gt;&lt;/div&gt;
  339. &lt;div style=&quot;font-family: Helvetica; min-height: 13px;&quot;&gt;
  340. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;
  341. &lt;div style=&quot;font-family: Helvetica;&quot;&gt;
  342. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;How accurate is the Vektis data?&lt;/span&gt;&lt;/div&gt;
  343. &lt;div style=&quot;font-family: Helvetica; font-size: 11px;&quot;&gt;
  344. &lt;span style=&quot;letter-spacing: 0.0px;&quot;&gt;&lt;br /&gt;
  345. &lt;/span&gt;&lt;/div&gt;
  346. &lt;div style=&quot;font-family: Helvetica; font-size: 11px;&quot;&gt;
  347. &lt;a href=&quot;http://www.vektis.nl/opendata/Vektis%20Databestand%20Zorgverzekeringswet%202012.xlsx&quot; target=&quot;_blank&quot;&gt;Link&amp;nbsp;to Vektis spreadsheet&lt;/a&gt;&amp;nbsp;&lt;/div&gt;
  348. &lt;div style=&quot;font-family: Helvetica; font-size: 11px;&quot;&gt;
  349. &lt;a href=&quot;http://www.vektis.nl/opendata/Vektis%20Databestand%20Zorgverzekeringswet%202012.csv&quot; target=&quot;_blank&quot;&gt;Link to Vektis CSV&lt;/a&gt;&amp;nbsp;&lt;/div&gt;
  350. &lt;div style=&quot;font-family: Helvetica; font-size: 11px;&quot;&gt;
  351. &lt;a href=&quot;http://www.vektis.nl/opendata/Bijsluiter%20bij%20het%20Databestand%20Zorgverzekeringswet.pdf&quot; target=&quot;_blank&quot;&gt;Detailed background info (in Dutch)&lt;/a&gt;&lt;/div&gt;
  352. </description><link>http://www.aukema.org/2014/11/dutch-healthcare-opendata-reveals-that.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-8046980446843104085</guid><pubDate>Mon, 22 Sep 2014 08:10:00 +0000</pubDate><atom:updated>2014-09-22T10:11:58.763+02:00</atom:updated><title>IPad IOS 8.0 update: why I never do (dot null) releases</title><description>&amp;nbsp;I should have known better. Things that used to work fine, no longer do.&lt;br /&gt;
  353. &lt;br /&gt;
  354. Google streetviewing a property: boom!&lt;img src=&quot;webkit-fake-url://d680262d-af24-4774-adc4-f8534019a5c1/imagepng&quot; /&gt;&lt;br /&gt;
  355. &lt;img src=&quot;webkit-fake-url://235511d4-8a6f-4805-8f52-a750f60e93fd/imagejpeg&quot; /&gt;&lt;br /&gt;
  356. &lt;br /&gt;
  357. Writing a blog post about this: now became annoying&lt;br /&gt;
  358. &lt;ol&gt;
  359. &lt;li&gt;Cursor gone&lt;/li&gt;
  360. &lt;li&gt;Focus gone&lt;/li&gt;
  361. &lt;li&gt;Selections wrong&lt;/li&gt;
  362. &lt;/ol&gt;
  363. &lt;div&gt;
  364. Under Jobs they used to do a better job...&lt;br /&gt;
  365. &lt;br /&gt;
  366. (Or should I blame Google?)&lt;/div&gt;
  367. </description><link>http://www.aukema.org/2014/09/ipad-ios-80-update-why-i-never-do.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-5375005714999853108</guid><pubDate>Fri, 01 Aug 2014 13:30:00 +0000</pubDate><atom:updated>2014-08-01T15:30:01.741+02:00</atom:updated><title>Uncovering what lies beneath...</title><description>Clarification for Information Leakage: A trusted US business partner of mine asked me for assistance. He needed help in identifying the source of a potential information leak for one of his customers.&lt;br /&gt;
  368. &lt;div&gt;
  369. &lt;br /&gt;&lt;/div&gt;
  370. &lt;div&gt;
  371. &lt;div&gt;
  372. As everyone knows, the behaviour of regular business users is rather predictable. This predictability can be visualised and wrapped in a bubble allowing for granular and non-granular analysis. &amp;nbsp;&lt;/div&gt;
  373. &lt;div&gt;
  374. &lt;br /&gt;&lt;/div&gt;
  375. &lt;div&gt;
  376. With the image below, I created a non-granular view where each bubble represents a user&#39;s normal interactions. Even with a casual glance you can immediately see how one bubble stands out from the others.&lt;br /&gt;
  377. &lt;br /&gt;&lt;/div&gt;
  378. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  379. &lt;/div&gt;
  380. &lt;div&gt;
  381. &lt;/div&gt;
  382. &lt;div style=&quot;text-align: left;&quot;&gt;
  383. &lt;/div&gt;
  384. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  385. &lt;/div&gt;
  386. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  387. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmAoku3NAj8v3hYyll8Cb6dSDd2OTsqcP-o099drPvlNFi7GKiP_hofjQQ4_N7b4PtypoTqUcVIOwnHYlnQf1RlN7cLPoPIm_Fmw8Klnnt9hhE_1HdqMmVQL1kmCtd8fkhKdnFkbNzAAjs/s1600/end+user+activity+analysis.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmAoku3NAj8v3hYyll8Cb6dSDd2OTsqcP-o099drPvlNFi7GKiP_hofjQQ4_N7b4PtypoTqUcVIOwnHYlnQf1RlN7cLPoPIm_Fmw8Klnnt9hhE_1HdqMmVQL1kmCtd8fkhKdnFkbNzAAjs/s1600/end+user+activity+analysis.jpg&quot; height=&quot;538&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  388. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  389. &lt;br /&gt;&lt;/div&gt;
  390. &lt;div&gt;
  391. This visualization provides clear evidence of one individual who had accessed the contents of more than 2,500 mail files of other employees in the organisation.&amp;nbsp;&lt;/div&gt;
  392. &lt;div&gt;
  393. &lt;br /&gt;&lt;/div&gt;
  394. &lt;div&gt;
  395. In greater detail, each bubble in the above image represents a single user who accesses a particular number of databases. &amp;nbsp;Each type of database is given a designated color, described in the legend. &amp;nbsp;The entire visualization represents the activity of 5,000 users inside the organization&#39;s IBM Domino collaboration environment.&lt;br /&gt;
  396. &lt;i&gt;&lt;br /&gt;&lt;/i&gt;
  397. &lt;i&gt;Some of you may have noticed the second largest bubble (in the blue bubbles). This represents the activity by a well-known performance monitoring tool.&lt;/i&gt;&lt;br /&gt;
  398. &lt;i&gt;&lt;br /&gt;&lt;/i&gt;
  399. A forensics engagement like this typically takes about one to two weeks to perform with a lead time &amp;lt; 24 hours. All of the work is performed remotely, with the exception of the data collection (online screen sharing session, appr. 1 hour) and presentation of findings (again online screen sharing session).&lt;/div&gt;
  400. &lt;/div&gt;
  401. </description><link>http://www.aukema.org/2014/08/uncovering-what-lies-beneath.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmAoku3NAj8v3hYyll8Cb6dSDd2OTsqcP-o099drPvlNFi7GKiP_hofjQQ4_N7b4PtypoTqUcVIOwnHYlnQf1RlN7cLPoPIm_Fmw8Klnnt9hhE_1HdqMmVQL1kmCtd8fkhKdnFkbNzAAjs/s72-c/end+user+activity+analysis.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-3069139443406079603</guid><pubDate>Tue, 08 Jul 2014 13:08:00 +0000</pubDate><atom:updated>2014-07-08T15:08:32.938+02:00</atom:updated><title>Experimental Visualisation of the IPV4 Address Space </title><description>&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  402. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1lLgOaUdDSQ8LyuvulRqrqoLQdjaP8NO5veoxLKqzJivv9fl1SyKVT-Wqsau26k2WU15MfR4PRJyC0NpmMLeOeh7OaG4AwadfaqltwZtUtvw-R4_s-7Ro8E01X0SnMaBMbaXSOok9Ohi6/s1600/global_ipv4_space.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;br /&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1lLgOaUdDSQ8LyuvulRqrqoLQdjaP8NO5veoxLKqzJivv9fl1SyKVT-Wqsau26k2WU15MfR4PRJyC0NpmMLeOeh7OaG4AwadfaqltwZtUtvw-R4_s-7Ro8E01X0SnMaBMbaXSOok9Ohi6/s1600/global_ipv4_space.jpg&quot; height=&quot;640&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
  403. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
  404. &lt;br /&gt;&lt;/div&gt;
  405. Thank you Leo from &lt;a href=&quot;http://www.anl.nl/&quot; target=&quot;_blank&quot;&gt;ANL&lt;/a&gt; for collecting this data :-)</description><link>http://www.aukema.org/2014/07/experimental-visualisation-of-ipv4.html</link><author>noreply@blogger.com (Wouter Aukema)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1lLgOaUdDSQ8LyuvulRqrqoLQdjaP8NO5veoxLKqzJivv9fl1SyKVT-Wqsau26k2WU15MfR4PRJyC0NpmMLeOeh7OaG4AwadfaqltwZtUtvw-R4_s-7Ro8E01X0SnMaBMbaXSOok9Ohi6/s72-c/global_ipv4_space.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-4390208778486136821</guid><pubDate>Wed, 02 Apr 2014 07:04:00 +0000</pubDate><atom:updated>2014-04-02T09:04:14.550+02:00</atom:updated><title>How to DOS your Imac</title><description>Have your keyboard, mouse and trackpad all connect via bluetooth.&lt;br /&gt;
  406. Next, click the bluetooth icon, turn it off and discard the warning dialog that tells you why you should not be doing this.&lt;br /&gt;
  407. &lt;br /&gt;
  408. Plugging in a usb-mouse didn&#39;t work. Remote access could have, so I guess I should enable this.</description><link>http://www.aukema.org/2014/04/how-to-dos-your-imac.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-6023725372495464813</guid><pubDate>Mon, 03 Dec 2012 14:48:00 +0000</pubDate><atom:updated>2012-12-03T15:48:36.538+01:00</atom:updated><title>Over 21,000 views on my Tumi TSA Lock video</title><description>Did you know how many people forget the number combination of their luggage locks? Imagine the trouble, if you just arrived in your hotel after a long flight.&lt;br /&gt;
  409. &lt;br /&gt;
  410. In this short instruction video I posted a while back on youtube, I show how to open a Tumi TSA approved lock if you&#39;ve forgotten the number combination.&lt;br /&gt;
  411. &lt;br /&gt;
  412. And I just discovered it&#39;s been watched more than 21,000 times in the past 9 months. Wow ;-).&lt;br /&gt;
  413. &lt;br /&gt;
  414. &lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;
  415. &lt;iframe allowfullscreen=&#39;allowfullscreen&#39; webkitallowfullscreen=&#39;webkitallowfullscreen&#39; mozallowfullscreen=&#39;mozallowfullscreen&#39; width=&#39;320&#39; height=&#39;266&#39; src=&#39;https://www.youtube.com/embed/zwN3IMXJiQ4?feature=player_embedded&#39; frameborder=&#39;0&#39;&gt;&lt;/iframe&gt;&lt;/div&gt;
  416. &lt;br /&gt;</description><link>http://www.aukema.org/2012/12/over-21000-views-on-my-tumi-tsa-lock.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8612861483458237611.post-4050946087241270903</guid><pubDate>Tue, 27 Nov 2012 14:18:00 +0000</pubDate><atom:updated>2012-11-27T15:18:44.697+01:00</atom:updated><title>Amazing experience working with IBM China</title><description>I have very good memories from working with people in the AsiaPac region, both as a guest speaker at it-security (BlackHat) conferences in Hong Kong and in performing some forensics work for the Internal Security Department in Singapore.&lt;br /&gt;
  417. &lt;br /&gt;
  418. This week I had my first experience in working together with team members from&amp;nbsp;IBM in China.&amp;nbsp;In one word: amazing!&amp;nbsp;Let me tell you why:&lt;br /&gt;
  419. &lt;br /&gt;
  420. Following the partnership that IBM and my company started this year (see &lt;a href=&quot;http://www.edbrill.com/ebrill/edbrill.nsf/dx/ibm-and-trust-factory-expanding-partnership&quot; target=&quot;_blank&quot;&gt;this link &amp;gt;&amp;gt;&lt;/a&gt;), we&amp;nbsp;needed to start supporting the non-western character-sets in our DNA solution in order to perform data collections on Lotus Domino servers in China.&lt;br /&gt;
  421. &lt;br /&gt;
  422. For this purpose, Viktor Kranz (IBM&#39;s TF/DNA coordinator inside IBM) brought me in touch with Mr. &lt;a href=&quot;http://www.linkedin.com/profile/view?id=73510031&quot; target=&quot;_blank&quot;&gt;Lin Tang of IBM China&lt;/a&gt;&amp;nbsp;or &#39;Forest Soup&#39; for those who get to know him ;-)&lt;br /&gt;
  423. &lt;br /&gt;
  424. My encounters with Forest Soup:&lt;br /&gt;
  425. &lt;ul&gt;
  426. &lt;li&gt;setting up a complete C++ dot Net 2003 IDE, including Notes C-api&amp;nbsp;&lt;/li&gt;
  427. &lt;li&gt;understanding code logic for 9,000 LOC (C++): 25 minutes&lt;/li&gt;
  428. &lt;li&gt;installation of a new Domino server: 5 minutes&lt;/li&gt;
  429. &lt;li&gt;limit questions to just 4 sharp &amp;amp; smart ones: 5 minutes&lt;/li&gt;
  430. &lt;li&gt;coming up with a plan&lt;/li&gt;
  431. &lt;li&gt;daily status updates&lt;/li&gt;
  432. &lt;li&gt;superb documentation&lt;/li&gt;
  433. &lt;li&gt;clarity in communication&lt;/li&gt;
  434. &lt;li&gt;entire new code done within a matter of days&lt;/li&gt;
  435. &lt;/ul&gt;
  436. Over the past 12.5 years in Trust Factory, I&#39;ve met -and worked with- several uber-specialists such as Bill Buchan, Daniel Nashed, Richard van den Berg, Michael Dudding, Stephan Wissel, to name a few.&lt;br /&gt;
  437. &lt;br /&gt;
  438. I&#39;m ready to add another uber-specialist to my list: Amazing Mr Tang :-)</description><link>http://www.aukema.org/2012/11/amazing-experience-working-with-ibm.html</link><author>noreply@blogger.com (Wouter Aukema)</author><thr:total>0</thr:total></item></channel></rss>
Copyright © 2002-9 Sam Ruby, Mark Pilgrim, Joseph Walton, and Phil Ringnalda