<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Open Sans";
panose-1:2 11 6 6 3 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.gmail-m7858643998349936536gmail-m-2163510735313765453msolistparagraph, li.gmail-m7858643998349936536gmail-m-2163510735313765453msolistparagraph, div.gmail-m7858643998349936536gmail-m-2163510735313765453msolistparagraph
{mso-style-name:gmail-m_7858643998349936536gmail-m-2163510735313765453msolistparagraph;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.gmail-m7858643998349936536gmail-m-2163510735313765453msohyperlink
{mso-style-name:gmail-m_7858643998349936536gmail-m-2163510735313765453msohyperlink;}
span.EstilCorreuElectrnic20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="CA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#44546A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:JA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black"><img width="205" height="36" style="width:2.1354in;height:.375in" id="Imatge_x0020_40" src="cid:image001.jpg@01D59A47.95220D50" alt="cid:image001.jpg@01D0949D.00022020"></span><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-align:justify"><b><span lang="ES" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:red;mso-fareast-language:JA">__________________________________________________________________________</span></b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="margin-left:21.3pt;text-align:justify"><b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA">Núria Majó i Crespo</span></b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA">
<b><o:p></o:p></b></span></p>
<p class="MsoNormal" style="margin-left:21.3pt;text-align:justify"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA">Àrea de solucions transversals<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:21.3pt;text-align:justify"><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:JA">Centre de Telecomunicacions i Tecnologies de la Informació<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><b><span style="font-family:"Calibri",sans-serif">De:</span></b><span style="font-family:"Calibri",sans-serif"> Barcelona <barcelona-bounces@lists.osgeo.org>
<b>En nom de </b>Jorge Sanz<br>
<b>Enviat:</b> dimecres, 13 de novembre de 2019 13:03<br>
<b>Per a:</b> Geoinquiets Barcelona <barcelona@lists.osgeo.org><br>
<b>Tema:</b> Re: [Geoinquiets Barcelona] Dades obertes<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">On Wed, 13 Nov 2019 at 12:48, Majó Crespo, Núria <<a href="mailto:nuria.majo@gencat.cat">nuria.majo@gencat.cat</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#44546A"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black"><img border="0" width="205" height="36" style="width:2.1354in;height:.375in" id="gmail-m_7858643998349936536Imatge_x0020_40" src="cid:image001.jpg@01D59A47.95220D50" alt="cid:image001.jpg@01D0949D.00022020"></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt;text-align:justify">
<b><span lang="ES" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:red">__________________________________________________________________________</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black"> </span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0cm;text-align:justify">
<b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black">Núria Majó i Crespo</span></b><span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black">
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0cm;text-align:justify">
<span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black">Àrea de solucions transversals</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0cm;text-align:justify">
<span style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black">Centre de Telecomunicacions i Tecnologies de la Informació</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<b><span style="font-family:"Calibri",sans-serif">De:</span></b><span style="font-family:"Calibri",sans-serif"> Barcelona <<a href="mailto:barcelona-bounces@lists.osgeo.org" target="_blank">barcelona-bounces@lists.osgeo.org</a>>
<b>En nom de </b>Jorge Sanz<br>
<b>Enviat:</b> dimecres, 13 de novembre de 2019 12:09<br>
<b>Per a:</b> Geoinquiets Barcelona <<a href="mailto:barcelona@lists.osgeo.org" target="_blank">barcelona@lists.osgeo.org</a>><br>
<b>Tema:</b> Re: [Geoinquiets Barcelona] Dades obertes</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
On Tue, 12 Nov 2019 at 12:43, Majó Crespo, Núria <<a href="mailto:nuria.majo@gencat.cat" target="_blank">nuria.majo@gencat.cat</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hola</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">A dades obertes gencat tens diversos conjunts amb volum i dimensió temporal per fer exercicis interessants.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Tots tenen accés via API molt fàcil, que pots usar per a mantenir les dades actualitzades periòdicament.( Si vols et puc passar un breu manual d’exemples d’us de l’API.)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="gmail-m7858643998349936536gmail-m-2163510735313765453msolistparagraph" style="margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:Symbol;color:#1F497D">·</span><span style="font-size:7.0pt;color:#1F497D">
</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Un del interessants és el de qualitat de l’aire (tècnicament immissions ;-) que deies. Té dades per hora, carregades diàriament, són series històriques de gairebé 20 anys,
i de diversos contaminants. I conté coordenades de cada una de les mesures.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:88.8pt">
<span class="gmail-m7858643998349936536gmail-m-2163510735313765453msohyperlink"><span style="font-size:11.5pt;font-family:"Open Sans";color:#2279A6;background:white"><a href="https://analisi.transparenciacatalunya.cat/Medi-Ambient/Dades-d-immissi-dels-punts-de-mesurament-de-la-Xar/uy6k-2s8r" target="_blank"><span style="color:#2279A6;text-decoration:none">https://analisi.transparenciacatalunya.cat/Medi-Ambient/Dades-d-immissi-dels-punts-de-mesurament-de-la-Xar/uy6k-2s8r</span></a></span></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:70.8pt">
Núria aquest l'havia vist i el tinc carregat però existeix una taula mestra de les estacions o les tinc que extraure de les mesures?<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Crec que es pot descarregar d’aquí:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<a href="http://sig.gencat.cat/visors/hipermapa.html#param=param&color=vermell&background=orto_ICC&BBOX=169712.5,4495025.000465,624287.5,4741975.000465&layers=ATMOSFERA_XARXA_VPCA" target="_blank">http://sig.gencat.cat/visors/hipermapa.html#param=param&color=vermell&background=orto_ICC&BBOX=169712.5,4495025.000465,624287.5,4741975.000465&layers=ATMOSFERA_XARXA_VPCA</a><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:35.4pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">No veig cóm, la opció que crec que és per exportar està desactivada. No passa res, un poc de SQL i au.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Merci!!!<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">-- <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Jorge Sanz<br>
<a href="http://twitter.com/xurxosanz" target="_blank">http://twitter.com/xurxosanz</a><br>
<a href="http://jorgesanz.net" target="_blank">http://jorgesanz.net</a><o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>