<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Co’s,
<div class=""><br class="">
</div>
<div class="">hier een paar voorbeelden van stored procedures in postgres.</div>
<div class=""><br class="">
</div>
<div class="">
<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'Menlo';font-size:9.0pt;" class=""><span style="color:#808080;" class="">-- functie die in verschillende tabellen zoekt of een bepaalde text voorkomt en logt dit in de console<br class=""></span><span style="color:#cc7832;font-weight:bold;" class="">CREATE OR REPLACE FUNCTION </span>bsos.<span style="color:#ffc66d;font-style:italic;" class="">searchReferences</span><span style="color:#9876aa;font-style:italic;" class="">(</span>searchTerm <span style="color:#cc7832;font-weight:bold;" class="">TEXT</span><span style="color:#9876aa;font-style:italic;" class="">)<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RETURNS VOID AS </span><span style="color:#9876aa;font-style:italic;" class="">$$<br class=""></span><span style="color:#cc7832;font-weight:bold;" class="">DECLARE<br class=""></span><span style="color:#cc7832;font-weight:bold;" class=""> </span>_events domainevententry%<span style="color:#cc7832;font-weight:bold;" class="">ROWTYPE</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span>_sagas sagaentry%<span style="color:#cc7832;font-weight:bold;" class="">ROWTYPE</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span>_jobs qrtz_job_details%<span style="color:#cc7832;font-weight:bold;" class="">ROWTYPE</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#9876aa;font-style:italic;" class="">BEGIN<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'===================================================================================='</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'Searching "%" in domain events'</span><span style="color:#cc7832;" class="">, </span>searchTerm<span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FOR </span>_events <span style="color:#cc7832;font-weight:bold;" class="">IN SELECT </span><span style="color:#ffc66d;" class="">*<br class=""></span><span style="color:#ffc66d;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FROM </span>domainevententry<br class=""> <span style="color:#cc7832;font-weight:bold;" class="">WHERE </span><span style="color:#ffc66d;font-style:italic;" class="">encode</span><span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#9876aa;" class="">payload</span><span style="color:#cc7832;" class="">, </span><span style="color:#6a8759;" class="">'escape'</span><span style="color:#9876aa;font-style:italic;" class="">) </span>~* searchTerm<br class=""> <span style="color:#cc7832;font-weight:bold;" class="">ORDER BY </span><span style="color:#9876aa;font-weight:bold;" class="">timestamp</span><span style="color:#cc7832;" class="">, </span><span style="color:#9876aa;" class="">sequencenumber<br class=""></span><span style="color:#9876aa;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">LOOP<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'------------------------------------------------------------------------------------'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">' -> found a match for event with id "%" - type "%" - timestamp "%"'</span><span style="color:#cc7832;" class="">, </span>_events.<span style="color:#9876aa;" class="">eventidentifier</span><span style="color:#cc7832;" class="">, </span>_events.<span style="color:#9876aa;" class="">type</span><span style="color:#cc7832;" class="">, </span>_events.<span style="color:#9876aa;" class="">timestamp</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">' -> "%"'</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;font-style:italic;" class="">encode</span><span style="color:#9876aa;font-style:italic;" class="">(</span>_events.<span style="color:#9876aa;" class="">payload</span><span style="color:#cc7832;" class="">, </span><span style="color:#6a8759;" class="">'escape'</span><span style="color:#9876aa;font-style:italic;" class="">)</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">END </span><span style="color:#cc7832;font-weight:bold;" class="">LOOP</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'------------------------------------------------------------------------------------'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""><br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'===================================================================================='</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'Searching "%" in sagas'</span><span style="color:#cc7832;" class="">, </span>searchTerm<span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FOR </span>_sagas <span style="color:#cc7832;font-weight:bold;" class="">IN SELECT </span>se.<span style="color:#ffc66d;" class="">*<br class=""></span><span style="color:#ffc66d;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FROM </span>sagaentry se<br class=""> <span style="color:#cc7832;font-weight:bold;" class="">WHERE </span><span style="color:#ffc66d;font-style:italic;" class="">encode</span><span style="color:#9876aa;font-style:italic;" class="">(</span>se.<span style="color:#9876aa;" class="">serializedsaga</span><span style="color:#cc7832;" class="">, </span><span style="color:#6a8759;" class="">'escape'</span><span style="color:#9876aa;font-style:italic;" class="">) </span>~* searchTerm<br class=""> <span style="color:#cc7832;font-weight:bold;" class="">OR </span>se.<span style="color:#9876aa;" class="">sagaid </span><span style="color:#cc7832;font-weight:bold;" class="">IN </span><span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#cc7832;font-weight:bold;" class="">SELECT </span>ave.<span style="color:#9876aa;" class="">sagaid<br class=""></span><span style="color:#9876aa;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FROM </span>associationvalueentry ave<br class=""> <span style="color:#cc7832;font-weight:bold;" class="">WHERE </span>ave.<span style="color:#9876aa;" class="">associationvalue </span>= searchTerm<span style="color:#9876aa;font-style:italic;" class="">)<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> LOOP<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'------------------------------------------------------------------------------------'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">' -> found a match for saga with id "%" and type "%"'</span><span style="color:#cc7832;" class="">, </span>_sagas.<span style="color:#9876aa;" class="">sagaid</span><span style="color:#cc7832;" class="">, </span>_sagas.<span style="color:#9876aa;" class="">sagatype</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">' -> "%"'</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;font-style:italic;" class="">encode</span><span style="color:#9876aa;font-style:italic;" class="">(</span>_sagas.<span style="color:#9876aa;" class="">serializedsaga</span><span style="color:#cc7832;" class="">, </span><span style="color:#6a8759;" class="">'escape'</span><span style="color:#9876aa;font-style:italic;" class="">)</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">END </span><span style="color:#cc7832;font-weight:bold;" class="">LOOP</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'------------------------------------------------------------------------------------'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""><br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'===================================================================================='</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'Searching "%" in quartz jobs'</span><span style="color:#cc7832;" class="">, </span>searchTerm<span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FOR </span>_jobs <span style="color:#cc7832;font-weight:bold;" class="">IN SELECT </span><span style="color:#ffc66d;" class="">*<br class=""></span><span style="color:#ffc66d;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">FROM </span>qrtz_job_details<br class=""> <span style="color:#cc7832;font-weight:bold;" class="">WHERE </span><span style="color:#ffc66d;font-style:italic;" class="">encode</span><span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#9876aa;" class="">job_data</span><span style="color:#cc7832;" class="">, </span><span style="color:#6a8759;" class="">'escape'</span><span style="color:#9876aa;font-style:italic;" class="">) </span>~* searchTerm<br class=""> <span style="color:#9876aa;font-style:italic;" class="">LOOP<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'------------------------------------------------------------------------------------'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">' -> found a match'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">' -> "%"'</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;font-style:italic;" class="">encode</span><span style="color:#9876aa;font-style:italic;" class="">(</span>_jobs.<span style="color:#9876aa;" class="">job_data</span><span style="color:#cc7832;" class="">, </span><span style="color:#6a8759;" class="">'escape'</span><span style="color:#9876aa;font-style:italic;" class="">)</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">END </span><span style="color:#cc7832;font-weight:bold;" class="">LOOP</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RAISE NOTICE </span><span style="color:#6a8759;" class="">'------------------------------------------------------------------------------------'</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""><br class=""></span><span style="color:#9876aa;font-style:italic;" class="">END</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#9876aa;font-style:italic;" class="">$$ </span><span style="color:#cc7832;font-weight:bold;" class="">LANGUAGE </span>plpgsql</pre>
<div class=""><br class="">
</div>
<div class="">
<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'Menlo';font-size:9.0pt;" class=""><span style="color:#808080;" class="">-- index op json array moet mogelijk gemaakt worden; kan enkel via IMMUTABLE function<br class=""></span><span style="color:#808080;" class="">-- <a href="http://stackoverflow.com/questions/18404055/index-for-finding-an-element-in-a-json-array" class="">http://stackoverflow.com/questions/18404055/index-for-finding-an-element-in-a-json-array</a><br class=""></span><span style="color:#cc7832;font-weight:bold;" class="">CREATE OR REPLACE FUNCTION </span><span style="color:#ffc66d;font-style:italic;" class="">json_val_arr</span><span style="color:#9876aa;font-style:italic;" class="">(</span>_j <span style="color:#cc7832;font-weight:bold;" class="">JSON</span><span style="color:#cc7832;" class="">, </span>_key <span style="color:#cc7832;font-weight:bold;" class="">TEXT</span><span style="color:#9876aa;font-style:italic;" class="">)<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RETURNS TEXT </span><span style="color:#9876aa;font-style:italic;" class="">[] </span><span style="color:#cc7832;font-weight:bold;" class="">AS<br class=""></span><span style="color:#cc7832;font-weight:bold;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">$$<br class=""></span><span style="color:#cc7832;font-weight:bold;" class="">SELECT </span><span style="color:#ffc66d;font-style:italic;" class="">array_agg</span><span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#9876aa;" class="">elem</span>->>_key<span style="color:#9876aa;font-style:italic;" class="">)<br class=""></span><span style="color:#cc7832;font-weight:bold;" class="">FROM </span><span style="color:#ffc66d;font-style:italic;" class="">json_array_elements</span><span style="color:#9876aa;font-style:italic;" class="">(</span>_j<span style="color:#9876aa;font-style:italic;" class="">) </span><span style="color:#cc7832;font-weight:bold;" class="">AS </span>x<span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#9876aa;" class="">elem</span><span style="color:#9876aa;font-style:italic;" class="">)<br class=""></span><span style="color:#9876aa;font-style:italic;" class="">$$<br class=""></span><span style="color:#cc7832;font-weight:bold;" class="">LANGUAGE SQL IMMUTABLE</span></pre>
<div class=""><br class="">
</div>
</div>
<div class="">
<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'Menlo';font-size:9.0pt;" class=""><span style="color:#cc7832;font-weight:bold;" class="">CREATE OR REPLACE FUNCTION </span><span style="color:#ffc66d;font-style:italic;" class="">trfn_log_cud</span><span style="color:#9876aa;font-style:italic;" class="">() </span><span style="color:#cc7832;font-weight:bold;" class="">RETURNS trigger AS </span><span style="color:#9876aa;font-style:italic;" class="">$$<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> BEGIN<br class=""></span><span style="color:#9876aa;font-style:italic;" class=""> IF (</span><span style="color:#ffc66d;" class="">TG_OP </span>= <span style="color:#6a8759;" class="">'DELETE'</span><span style="color:#9876aa;font-style:italic;" class="">) </span><span style="color:#cc7832;font-weight:bold;" class="">THEN<br class=""></span><span style="color:#cc7832;font-weight:bold;" class=""> RAISE WARNING </span><span style="color:#6a8759;" class="">'% (%): %'</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;" class="">TG_TABLE_NAME</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;" class="">TG_OP</span><span style="color:#cc7832;" class="">, </span><span style="color:#cc7832;font-weight:bold;" class="">OLD</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RETURN OLD</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">ELSIF </span><span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#ffc66d;" class="">TG_OP </span>= <span style="color:#6a8759;" class="">'INSERT'</span><span style="color:#9876aa;font-style:italic;" class="">) </span><span style="color:#cc7832;font-weight:bold;" class="">THEN<br class=""></span><span style="color:#cc7832;font-weight:bold;" class=""> RAISE WARNING </span><span style="color:#6a8759;" class="">'% (%): % '</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;" class="">TG_TABLE_NAME</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;" class="">TG_OP</span><span style="color:#cc7832;" class="">, </span><span style="color:#cc7832;font-weight:bold;" class="">NEW</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RETURN NEW</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">ELSIF </span><span style="color:#9876aa;font-style:italic;" class="">(</span><span style="color:#ffc66d;" class="">TG_OP </span>= <span style="color:#6a8759;" class="">'UPDATE'</span><span style="color:#9876aa;font-style:italic;" class="">) </span><span style="color:#cc7832;font-weight:bold;" class="">THEN<br class=""></span><span style="color:#cc7832;font-weight:bold;" class=""> RAISE WARNING </span><span style="color:#6a8759;" class="">'% (%): % -> %' </span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;" class="">TG_TABLE_NAME</span><span style="color:#cc7832;" class="">, </span><span style="color:#ffc66d;" class="">TG_OP</span><span style="color:#cc7832;" class="">, </span><span style="color:#cc7832;font-weight:bold;" class="">OLD</span><span style="color:#cc7832;" class="">, </span><span style="color:#cc7832;font-weight:bold;" class="">NEW</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#cc7832;font-weight:bold;" class="">RETURN NEW</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">END </span><span style="color:#cc7832;font-weight:bold;" class="">IF</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#cc7832;" class=""> </span><span style="color:#9876aa;font-style:italic;" class="">END</span><span style="color:#cc7832;" class="">;<br class=""></span><span style="color:#9876aa;font-style:italic;" class="">$$ </span><span style="color:#cc7832;font-weight:bold;" class="">LANGUAGE </span>plpgsql</pre>
<div class=""><br class="">
</div>
</div>
<div class=""><font size="5" class=""><b class=""><i class=""><u class="">DISCLAIMER:</u></i></b></font></div>
<div class=""><br class="">
</div>
<div class="">Deze werden gebruikt in BSOS om dingen te debuggen of om indexen te maken. Het is niet de bedoeling om business logica in een stored procedure te steken.</div>
<div class=""><br class="">
</div>
<div class="">
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class="">Met vriendelijke groeten,<o:p class=""></o:p></font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class=""> </font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<b class=""><span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class="">Christophe De Blende<o:p class=""></o:p></font></span></b></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class="">Ontwikkelaar<o:p class=""></o:p></font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class=""> <o:p class=""></o:p></font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class="">DEPARTEMENT <b class="">OMGEVING</b><o:p class=""></o:p></font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class="">Afdeling Data- en Informatiebeheer, en Digitale Maatschappij<o:p class=""></o:p></font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<font color="#cc5621" class=""><span lang="NL-BE" style="font-size: 11pt;" class=""><b class="">M </b>0498 16 13 87</span></font></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class="">Koning Albert II-laan 20 bus 8, 1000 Brussel<o:p class=""></o:p></font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<b class=""><span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class=""><a href="http://www.omgevingvlaanderen.be/" class=""><span style="text-decoration: none;" class="">www.omgevingvlaanderen.be</span></a><o:p class=""></o:p></font></span></b></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class=""> </font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL" class=""><font color="#cc5621" class=""><a href="https://twitter.com/omgevingVL" class=""><span lang="EN-GB" style="font-size: 11pt; text-decoration: none;" class=""><br class="Apple-interchange-newline" style="color: rgb(0, 105, 217); font-family: Calibri; font-size: 14.666666984558105px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;">
<span style="color: rgb(0, 105, 217); font-family: Calibri; font-size: 14.666666984558105px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;"><span><span><img apple-inline="yes" id="D9EA40AD-6BAE-4696-B7EF-B0226D2CD545" src="cid:image001.png@01D2C81C.23755FE0" class=""></span></span></span></span></a><a href="https://twitter.com/omgevingVL" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><span lang="EN-GB" style="font-size: 11pt; text-decoration: none;" class=""><span lang="NL-BE" style="font-family: Calibri; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 11pt;" class=""> </span><span lang="NL" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""></span></span></a><a href="https://www.facebook.com/Departementomgeving" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><span lang="EN-GB" style="font-size: 11pt; text-decoration: none;" class=""><span><span><span><img apple-inline="yes" id="4235C01A-4FF5-4401-B955-8AA6C9E15BE3" src="cid:image002.png@01D2C81C.23755FE0" class=""></span></span></span></span></a><a href="https://www.facebook.com/Departementomgeving" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><span lang="EN-GB" style="font-size: 11pt; text-decoration: none;" class=""><span><font color="#cc5621" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""></font></span></span></a><font color="#cc5621" style="color: rgb(204, 86, 33); font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><a href="https://www.facebook.com/Departementomgeving" class=""><span lang="EN-GB" style="font-size: 11pt; text-decoration: none;" class=""><span lang="NL-BE" style="font-family: Calibri; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 11pt;" class=""> </span><span lang="NL" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""></span></span></a></font><a href="https://www.linkedin.com/company/departement-omgeving" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><span lang="EN-GB" style="font-size: 11pt; text-decoration: none;" class=""><span><font color="#cc5621" class=""><span><span><img apple-inline="yes" id="3A44E174-10DB-457C-B899-9F0EC7A52560" src="cid:image003.png@01D2C81C.23755FE0" class=""></span></span></font></span></span></a><font color="#cc5621" class=""><a href="https://www.linkedin.com/company/departement-omgeving" style="font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><span style="font-size: 11pt;" class=""><font color="#cc5621" class="">
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span lang="NL-BE" style="font-size: 11pt;" class=""><font color="#cc5621" class=""><br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
</font></span></div>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;" class="">
<span style="font-size: 11pt;" class=""><font color="#cc5621" class=""><br class="Apple-interchange-newline">
<span></span></font></span></div>
</font></span></a><font color="#cc5621" style="color: rgb(204, 86, 33); font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><span><br class="Apple-interchange-newline">
<span><img apple-inline="yes" id="A1B276AA-D56E-4882-8A2C-F5DDD352C08A" src="cid:image004.png@01D2C81C.23755FE0" class=""></span>
<div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(0, 0, 0); margin: 0px; padding: 0px; font-family: Arial, sans-serif; font-size: 14px;" class="">
</div>
<p style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(0, 0, 0); margin: 10px 0px 0px; padding: 0px; font-family: Arial, sans-serif; font-size: 14px;" class="">
<u class=""></u></p>
</span></font></font></font></span></div>
<font color="#cc5621" class=""><font color="#cc5621" style="color: rgb(204, 86, 33); font-family: Calibri; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""></font></font></div>
<br class="">
</div>
</body>
</html>