contribute.html

<!DOCTYPE html>
<html lang="en-US">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Contribute | Meteostat Developers</title>
    <meta name="generator" content="VuePress 1.9.10">
    <script>
      var _paq = window._paq = window._paq || [];
      _paq.push(['trackPageView']);
      _paq.push(['enableLinkTracking']);
      (function() {
        var u="//analytics.meteostat.org/";
        _paq.push(['setTrackerUrl', u+'matomo.php']);
        _paq.push(['setSiteId', '3']);
        var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
        g.type='text/javascript'; g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s);
      })();
    </script>
    <meta name="description" content="Documentation for the Meteostat developers platform.">
    <meta name="theme-color" content="#0678BE">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta rel="icon" type="image/png" sizes="16x16" href="https://media.meteostat.net/favicon-16x16.png">
    <meta rel="icon" type="image/png" sizes="32x32" href="https://media.meteostat.net/favicon-32x32.png">
    <meta rel="icon" href="https://meteostat.net/files/icon.svg">
    
    <link rel="preload" href="/assets/css/0.styles.edb07077.css" as="style"><link rel="preload" href="/assets/js/app.a66d0daa.js" as="script"><link rel="preload" href="/assets/js/2.d7ab5441.js" as="script"><link rel="preload" href="/assets/js/1.a9f10f41.js" as="script"><link rel="preload" href="/assets/js/43.278ca5a7.js" as="script"><link rel="prefetch" href="/assets/js/10.c9ea7b55.js"><link rel="prefetch" href="/assets/js/11.c65a877c.js"><link rel="prefetch" href="/assets/js/12.b13b8629.js"><link rel="prefetch" href="/assets/js/13.819aab7f.js"><link rel="prefetch" href="/assets/js/14.00b63fc8.js"><link rel="prefetch" href="/assets/js/15.1dba893f.js"><link rel="prefetch" href="/assets/js/16.2da67041.js"><link rel="prefetch" href="/assets/js/17.8350d343.js"><link rel="prefetch" href="/assets/js/18.81f7fe96.js"><link rel="prefetch" href="/assets/js/19.8ef002e9.js"><link rel="prefetch" href="/assets/js/20.6457403c.js"><link rel="prefetch" href="/assets/js/21.6bd85326.js"><link rel="prefetch" href="/assets/js/22.9762993b.js"><link rel="prefetch" href="/assets/js/23.d6b575db.js"><link rel="prefetch" href="/assets/js/24.71c0a62a.js"><link rel="prefetch" href="/assets/js/25.551d8799.js"><link rel="prefetch" href="/assets/js/26.878690c6.js"><link rel="prefetch" href="/assets/js/27.76b1fc18.js"><link rel="prefetch" href="/assets/js/28.61df55c8.js"><link rel="prefetch" href="/assets/js/29.22d7454a.js"><link rel="prefetch" href="/assets/js/3.f54fa9b0.js"><link rel="prefetch" href="/assets/js/30.7f853cd3.js"><link rel="prefetch" href="/assets/js/31.d6e224ec.js"><link rel="prefetch" href="/assets/js/32.5175e3e8.js"><link rel="prefetch" href="/assets/js/33.43f13c1b.js"><link rel="prefetch" href="/assets/js/34.05b6e293.js"><link rel="prefetch" href="/assets/js/35.2b9bd452.js"><link rel="prefetch" href="/assets/js/36.5706e3c2.js"><link rel="prefetch" href="/assets/js/37.f56a83c1.js"><link rel="prefetch" href="/assets/js/38.af3ceb99.js"><link rel="prefetch" href="/assets/js/39.e8086619.js"><link rel="prefetch" href="/assets/js/4.2e9c3ab7.js"><link rel="prefetch" href="/assets/js/40.3afca21c.js"><link rel="prefetch" href="/assets/js/41.ca8ad91d.js"><link rel="prefetch" href="/assets/js/42.f2978aef.js"><link rel="prefetch" href="/assets/js/44.bbcd3910.js"><link rel="prefetch" href="/assets/js/45.f5c06dcf.js"><link rel="prefetch" href="/assets/js/46.70679057.js"><link rel="prefetch" href="/assets/js/47.e41fbf02.js"><link rel="prefetch" href="/assets/js/48.93d3a79e.js"><link rel="prefetch" href="/assets/js/49.4a5915db.js"><link rel="prefetch" href="/assets/js/5.a39cf2dc.js"><link rel="prefetch" href="/assets/js/50.7d79ed92.js"><link rel="prefetch" href="/assets/js/51.b1d1c781.js"><link rel="prefetch" href="/assets/js/52.40c9f768.js"><link rel="prefetch" href="/assets/js/53.44077171.js"><link rel="prefetch" href="/assets/js/54.2c36bb0f.js"><link rel="prefetch" href="/assets/js/55.d0228d08.js"><link rel="prefetch" href="/assets/js/56.75c76bfe.js"><link rel="prefetch" href="/assets/js/57.58e702b8.js"><link rel="prefetch" href="/assets/js/58.28a3a739.js"><link rel="prefetch" href="/assets/js/59.c784cd84.js"><link rel="prefetch" href="/assets/js/6.d31b0942.js"><link rel="prefetch" href="/assets/js/60.12c7a9a4.js"><link rel="prefetch" href="/assets/js/61.52978864.js"><link rel="prefetch" href="/assets/js/62.63c6b603.js"><link rel="prefetch" href="/assets/js/63.15f07865.js"><link rel="prefetch" href="/assets/js/64.ee116015.js"><link rel="prefetch" href="/assets/js/65.38d34041.js"><link rel="prefetch" href="/assets/js/66.4d17df4f.js"><link rel="prefetch" href="/assets/js/67.c6630fa2.js"><link rel="prefetch" href="/assets/js/68.9ed7bee0.js"><link rel="prefetch" href="/assets/js/69.d21bac2c.js"><link rel="prefetch" href="/assets/js/7.ab9cd07c.js"><link rel="prefetch" href="/assets/js/70.e873f939.js"><link rel="prefetch" href="/assets/js/71.9656e54c.js"><link rel="prefetch" href="/assets/js/72.f1d34a23.js"><link rel="prefetch" href="/assets/js/73.338adbcf.js"><link rel="prefetch" href="/assets/js/74.695eb736.js"><link rel="prefetch" href="/assets/js/75.0d2227b5.js"><link rel="prefetch" href="/assets/js/76.41596a54.js"><link rel="prefetch" href="/assets/js/77.1233fe78.js"><link rel="prefetch" href="/assets/js/78.7b4e09f0.js"><link rel="prefetch" href="/assets/js/79.7c270b34.js"><link rel="prefetch" href="/assets/js/80.7285b150.js"><link rel="prefetch" href="/assets/js/81.1f517231.js"><link rel="prefetch" href="/assets/js/82.d79dbef9.js"><link rel="prefetch" href="/assets/js/83.9e00f92c.js"><link rel="prefetch" href="/assets/js/84.5a76c95c.js"><link rel="prefetch" href="/assets/js/85.daaa317b.js"><link rel="prefetch" href="/assets/js/86.68509766.js"><link rel="prefetch" href="/assets/js/vendors~docsearch.94b65286.js">
    <link rel="stylesheet" href="/assets/css/0.styles.edb07077.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/" class="home-link router-link-active"><img src="https://media.meteostat.net/icon.svg" alt="Meteostat Developers" class="logo"> <span class="site-name can-hide">Meteostat Developers</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Guide" class="dropdown-title"><span class="title">Guide</span> <span class="arrow down"></span></button> <button type="button" aria-label="Guide" class="mobile-dropdown-title"><span class="title">Guide</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/guide.html" class="nav-link">
  Overview
</a></li><li class="dropdown-item"><!----> <a href="/formats.html" class="nav-link">
  Formats &amp; Units
</a></li><li class="dropdown-item"><!----> <a href="/terms.html" class="nav-link">
  Terms &amp; License
</a></li><li class="dropdown-item"><!----> <a href="/quality.html" class="nav-link">
  Data Quality
</a></li><li class="dropdown-item"><!----> <a href="/sources.html" class="nav-link">
  Data Sources
</a></li><li class="dropdown-item"><!----> <a href="/contribute.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  Contribute
</a></li><li class="dropdown-item"><!----> <a href="/donate.html" class="nav-link">
  Donate
</a></li><li class="dropdown-item"><!----> <a href="/faq.html" class="nav-link">
  FAQ
</a></li></ul></div></div><div class="nav-item"><a href="/api/" class="nav-link">
  JSON API
</a></div><div class="nav-item"><a href="/python/" class="nav-link">
  Python
</a></div><div class="nav-item"><a href="/bulk/" class="nav-link">
  Bulk Data
</a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Project" class="dropdown-title"><span class="title">Project</span> <span class="arrow down"></span></button> <button type="button" aria-label="Project" class="mobile-dropdown-title"><span class="title">Project</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><h4>
          Meteostat
        </h4> <ul class="dropdown-subitem-wrapper"><li class="dropdown-subitem"><a href="https://meteostat.net/en" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Webapp
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://twitter.com/meteost" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Twitter
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://medium.com/meteostat" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Blog
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://www.linkedin.com/company/meteostat/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  LinkedIn
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://www.paypal.me/meteostat" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Donation
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></li><li class="dropdown-item"><h4>
          Legal
        </h4> <ul class="dropdown-subitem-wrapper"><li class="dropdown-subitem"><a href="/terms.html" class="nav-link">
  Terms &amp; License
</a></li><li class="dropdown-subitem"><a href="https://meteostat.net/en/legal" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Legal Disclosure
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://meteostat.net/en/privacy" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Privacy
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></li></ul></div></div><div class="nav-item"><a href="https://github.com/meteostat" target="_blank" rel="noopener noreferrer" class="nav-link external">
  GitHub
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div> <!----></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Guide" class="dropdown-title"><span class="title">Guide</span> <span class="arrow down"></span></button> <button type="button" aria-label="Guide" class="mobile-dropdown-title"><span class="title">Guide</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/guide.html" class="nav-link">
  Overview
</a></li><li class="dropdown-item"><!----> <a href="/formats.html" class="nav-link">
  Formats &amp; Units
</a></li><li class="dropdown-item"><!----> <a href="/terms.html" class="nav-link">
  Terms &amp; License
</a></li><li class="dropdown-item"><!----> <a href="/quality.html" class="nav-link">
  Data Quality
</a></li><li class="dropdown-item"><!----> <a href="/sources.html" class="nav-link">
  Data Sources
</a></li><li class="dropdown-item"><!----> <a href="/contribute.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  Contribute
</a></li><li class="dropdown-item"><!----> <a href="/donate.html" class="nav-link">
  Donate
</a></li><li class="dropdown-item"><!----> <a href="/faq.html" class="nav-link">
  FAQ
</a></li></ul></div></div><div class="nav-item"><a href="/api/" class="nav-link">
  JSON API
</a></div><div class="nav-item"><a href="/python/" class="nav-link">
  Python
</a></div><div class="nav-item"><a href="/bulk/" class="nav-link">
  Bulk Data
</a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Project" class="dropdown-title"><span class="title">Project</span> <span class="arrow down"></span></button> <button type="button" aria-label="Project" class="mobile-dropdown-title"><span class="title">Project</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><h4>
          Meteostat
        </h4> <ul class="dropdown-subitem-wrapper"><li class="dropdown-subitem"><a href="https://meteostat.net/en" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Webapp
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://twitter.com/meteost" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Twitter
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://medium.com/meteostat" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Blog
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://www.linkedin.com/company/meteostat/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  LinkedIn
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://www.paypal.me/meteostat" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Donation
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></li><li class="dropdown-item"><h4>
          Legal
        </h4> <ul class="dropdown-subitem-wrapper"><li class="dropdown-subitem"><a href="/terms.html" class="nav-link">
  Terms &amp; License
</a></li><li class="dropdown-subitem"><a href="https://meteostat.net/en/legal" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Legal Disclosure
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-subitem"><a href="https://meteostat.net/en/privacy" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Privacy
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></li></ul></div></div><div class="nav-item"><a href="https://github.com/meteostat" target="_blank" rel="noopener noreferrer" class="nav-link external">
  GitHub
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div> <!----></nav> <div class="carbon-ads"></div> <ul class="sidebar-links"><li><section class="sidebar-group depth-0"><p class="sidebar-heading open"><span>Essentials</span> <!----></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/guide.html" class="sidebar-link">Introduction</a></li><li><a href="/formats.html" class="sidebar-link">Formats &amp; Units</a></li><li><a href="/terms.html" class="sidebar-link">Terms &amp; License</a></li><li><a href="/quality.html" class="sidebar-link">Data Quality</a></li><li><a href="/sources.html" class="sidebar-link">Data Sources</a></li><li><a href="/contribute.html" aria-current="page" class="active sidebar-link">Contribute</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/contribute.html#weather-stations" class="sidebar-link">Weather Stations</a></li><li class="sidebar-sub-header"><a href="/contribute.html#data-routines" class="sidebar-link">Data Routines</a></li><li class="sidebar-sub-header"><a href="/contribute.html#python-library" class="sidebar-link">Python Library</a></li><li class="sidebar-sub-header"><a href="/contribute.html#documentation" class="sidebar-link">Documentation</a></li></ul></li><li><a href="/donate.html" class="sidebar-link">Donate</a></li><li><a href="/faq.html" class="sidebar-link">FAQ</a></li></ul></section></li><li><section class="sidebar-group depth-0"><p class="sidebar-heading"><span>Interfaces</span> <!----></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/api/" class="sidebar-link">JSON API</a></li><li><a href="/python/" class="sidebar-link">Python Library</a></li><li><a href="/bulk/" class="sidebar-link">Bulk Data</a></li></ul></section></li><li><section class="sidebar-group depth-0"><p class="sidebar-heading"><span>Connect</span> <!----></p> <ul class="sidebar-links sidebar-group-items"><li><a href="https://twitter.com/meteost" target="_blank" rel="noopener noreferrer" class="sidebar-link">Twitter<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li><a href="https://www.linkedin.com/company/meteostat/" target="_blank" rel="noopener noreferrer" class="sidebar-link">LinkedIn<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li><a href="https://medium.com/meteostat" target="_blank" rel="noopener noreferrer" class="sidebar-link">Blog<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></section></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="contribute"><a href="#contribute" class="header-anchor">#</a> Contribute</h1> <p>Meteostat is an open initiative which does not operate on a primarily commercial basis. We believe that weather and climate data should be freely available to everyone. Therefore, Meteostat operates multiple interfaces which provide free access to meteorological data. Operating, maintaining and growing the project is only possible with the help of people like you.</p> <p>This section contains information about how to contribute to Meteostat. It also defines general principles and concepts which serve as a foundation for the project and its architecture.</p> <p>If you want to support Meteostat on its mission of making weather and climate data available to everyone, you have multiple options to choose from:</p> <ul><li>Contribute to our open source repositories on <a href="https://github.com/meteostat" target="_blank" rel="noopener noreferrer">GitHub<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li> <li>Spread the news about Meteostat on social media or your website</li> <li>Make a <a href="/contributing.html#donations">donation</a></li></ul> <p>Meteostat's goal is to publish the majority of its coding under the MIT license on <a href="https://github.com/meteostat" target="_blank" rel="noopener noreferrer">GitHub<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>. Feel free to open an issue if you run into a bug or create a pull request for new features and fixes.</p> <h2 id="weather-stations"><a href="#weather-stations" class="header-anchor">#</a> Weather Stations</h2> <p>Meteostat provides an open directory of weather stations everyone can edit, share and build upon. The list of weather stations is available on <a href="https://github.com/meteostat/weather-stations" target="_blank" rel="noopener noreferrer">GitHub<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>.</p> <p>If you want to add a missing station, please create a new file in the <code>stations</code> folder according to the template described <a href="https://github.com/meteostat/weather-stations#properties" target="_blank" rel="noopener noreferrer">here<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>. If possible, please to also add the weather station to the CSV files in <a href="https://github.com/meteostat/routines/tree/master/resources" target="_blank" rel="noopener noreferrer">this directory<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>. Adding the corresponding identifier to the CSV files will make sure all available data is collected properly.</p> <h3 id="joining-stations"><a href="#joining-stations" class="header-anchor">#</a> Joining Stations</h3> <p>It can happen that the same weather station appears twice under different IDs. In this case, all duplicates should be unified in a single JSON file under a common identifier.</p> <ol><li>Pick one of the existing JSON files.</li> <li>Add all identifiers and details available for this weather station. In case of inconsistencies, do some research or open an issue.</li> <li>Delete all duplicates.</li> <li>Create a pull request.</li></ol> <p>The following steps require access to the Meteostat database and can only be executed by admins:</p> <details class="custom-block details"><summary>Show steps for admins</summary> <ol start="5"><li>Merge the PR into <code>master</code>.</li> <li>Run the station import on Banff.</li> <li>Delete corresponding entries in the <code>stations_inventory</code> table</li> <li>Clean the Bulk server by running the following Shell command inside the <code>bulk</code> directory:</li></ol> <div class="language-sh extra-class"><pre class="language-sh"><code><span class="token function">find</span> <span class="token builtin class-name">.</span> <span class="token parameter variable">-name</span> <span class="token string">'$duplicate.csv.gz'</span> <span class="token parameter variable">-delete</span>
</code></pre></div><p>You'll have to replace <code>$duplicate</code> with the ID of a/the duplicate weather station. Repeat this for all duplicates.</p> <ol start="10"><li>Run the following SQL script for all duplicates:</li></ol> <p>Replace <code>$target</code> with the unique ID of the unified weather station and <code>$origin</code> with the ID of the duplicate. Please note that the table prefixes are required to avoid ambiguity in MariaDB. It might take a few minutes for the script to complete.</p> <p>This will be moved to our data management repository in the future.</p> <div class="language-sql extra-class"><pre class="language-sql"><code><span class="token comment">-- daily_ghcn</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>date<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>date<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>daily_ghcn<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

  <span class="token comment">-- daily_national</span>
  <span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>date<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
      <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
    <span class="token punctuation">)</span>
  <span class="token keyword">SELECT</span>
    <span class="token string">'$target'</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>date<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
  <span class="token keyword">FROM</span>
    <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
  <span class="token keyword">WHERE</span>
    <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
  <span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
    <span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>daily_national<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- hourly_isd</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>hourly_isd<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- hourly_metar</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>hourly_metar<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- hourly_model</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>hourly_model<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- hourly_national</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>hourly_national<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- hourly_synop</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>time<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>temp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wspd<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wpgt<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>wdir<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>rhum<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>snow<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>coco<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>hourly_synop<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- monthly_global</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>year<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>month<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>year<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>month<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>


<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>monthly_global<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>

<span class="token comment">-- normals_global</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span>
  <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span> <span class="token punctuation">(</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>start<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>end<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>month<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
    <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span>
  <span class="token punctuation">)</span>
<span class="token keyword">SELECT</span>
  <span class="token string">'$target'</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>start<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>end<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>month<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span>
<span class="token keyword">FROM</span>
  <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span> <span class="token keyword">AS</span> <span class="token identifier"><span class="token punctuation">`</span>d<span class="token punctuation">`</span></span>
<span class="token keyword">WHERE</span>
  <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span>
<span class="token keyword">ON</span> <span class="token keyword">DUPLICATE</span> <span class="token keyword">KEY</span> <span class="token keyword">UPDATE</span>
  <span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tavg<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmin<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tmax<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>prcp<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>tsun<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token keyword">COALESCE</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">,</span> <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span><span class="token punctuation">.</span><span class="token identifier"><span class="token punctuation">`</span>pres<span class="token punctuation">`</span></span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> <span class="token identifier"><span class="token punctuation">`</span>normals_global<span class="token punctuation">`</span></span> <span class="token keyword">WHERE</span> <span class="token identifier"><span class="token punctuation">`</span>station<span class="token punctuation">`</span></span> <span class="token operator">=</span> <span class="token string">'$origin'</span><span class="token punctuation">;</span>
</code></pre></div></details> <h2 id="data-routines"><a href="#data-routines" class="header-anchor">#</a> Data Routines</h2> <p>All automated routines, for both import &amp; export of data, are available <a href="https://github.com/meteostat/routines" target="_blank" rel="noopener noreferrer">here<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>. By adding new data sources, you can help Meteostat improve its data coverage.</p> <h2 id="python-library"><a href="#python-library" class="header-anchor">#</a> Python Library</h2> <p>Please refer to <a href="/python/contributing">this page</a>.</p> <h2 id="documentation"><a href="#documentation" class="header-anchor">#</a> Documentation</h2> <p>Last but not least, this documentation is an <a href="https://github.com/meteostat/dev" target="_blank" rel="noopener noreferrer">open source project<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>, too. Keeping our docs up-to-date is crucial. If you are contributing to parts of our ecosystem, please make sure to add corresponding documentation. Also, if anything appears to be unclear or misleading in one of our articles, feel free to propose changes.</p> <p>The Meteostat team will review all pull requests. Once a PR has been approved and merged into the <code>master</code> branch, Meteostat will automatically deploy changes into the productive environment.</p></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/meteostat/dev/edit/main/src/contribute.md" target="_blank" rel="noopener noreferrer">Edit this page</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">Last Updated:</span> <span class="time">2/18/2022, 1:29:58 PM</span></div></footer> <div class="page-nav"><p class="inner"><span class="prev">
      ←
      <a href="/sources.html" class="prev">
        Data Sources
      </a></span> <span class="next"><a href="/donate.html">
        Donate
      </a>
      →
    </span></p></div> </main></div><div class="global-ui"></div></div>
    <script src="/assets/js/app.a66d0daa.js" defer></script><script src="/assets/js/2.d7ab5441.js" defer></script><script src="/assets/js/1.a9f10f41.js" defer></script><script src="/assets/js/43.278ca5a7.js" defer></script>
  </body>
</html>