<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: 郭强（Coder）</title>
    <description>The latest articles on DEV Community by 郭强（Coder） (@nongminli).</description>
    <link>https://dev.to/nongminli</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4245820%2F0cead202-33ea-4ee9-a408-a19e13dc7432.png</url>
      <title>DEV Community: 郭强（Coder）</title>
      <link>https://dev.to/nongminli</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/nongminli"/>
    <language>en</language>
    <item>
      <title>Publishing a Taiwan Solar Terms CSV Without Blurring Official Data and Estimates</title>
      <dc:creator>郭强（Coder）</dc:creator>
      <pubDate>Sun, 15 Nov 2026 11:09:46 +0000</pubDate>
      <link>https://dev.to/nongminli/publishing-a-taiwan-solar-terms-csv-without-blurring-official-data-and-estimates-2b86</link>
      <guid>https://dev.to/nongminli/publishing-a-taiwan-solar-terms-csv-without-blurring-official-data-and-estimates-2b86</guid>
      <description>&lt;p&gt;Solar terms are useful for calendars and teaching materials, but a table of dates can hide an important distinction: was each time published by a meteorological agency, or calculated by the person who assembled the table?&lt;/p&gt;

&lt;p&gt;For &lt;a href="https://nongminli.tw/" rel="noopener noreferrer"&gt;nongminli.tw&lt;/a&gt;, we assembled a &lt;a href="https://github.com/CrabMen/nongminli.tw/tree/main/data" rel="noopener noreferrer"&gt;UTF-8 CSV of Taiwan's 24 solar terms for each year from 2020 through 2035&lt;/a&gt;. It has 384 rows. The &lt;code&gt;value_kind&lt;/code&gt; column is the part I would check first before using any row:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;48 rows&lt;/strong&gt; for 2026 and 2027 come from the Central Weather Administration's published annual calendar tables.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;336 rows&lt;/strong&gt; for other years are calculated estimates based on the Sun's apparent ecliptic longitude. They are not CWA announcements.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Every row uses &lt;code&gt;Asia/Taipei&lt;/code&gt; and gives a local date and time to the minute. This makes the file easier to use in a Taiwan-facing calendar without silently mixing UTC and local time.&lt;/p&gt;

&lt;p&gt;For example, a downstream app can require an explicit choice before displaying a time as official:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;csv&lt;/span&gt;

&lt;span class="k"&gt;with&lt;/span&gt; &lt;span class="nb"&gt;open&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"taiwan-solar-terms-2020-2035.csv"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;encoding&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="s2"&gt;"utf-8"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;newline&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;file&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;rows&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="kt"&gt;list&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;csv&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;DictReader&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;file&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="n"&gt;official&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;row&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="n"&gt;rows&lt;/span&gt; &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"value_kind"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="s2"&gt;"CWA published calendar"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;estimated&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;row&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="n"&gt;rows&lt;/span&gt; &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"value_kind"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="s2"&gt;"calculated estimate"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="k"&gt;assert&lt;/span&gt; &lt;span class="nb"&gt;len&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;official&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="mi"&gt;48&lt;/span&gt; &lt;span class="ow"&gt;and&lt;/span&gt; &lt;span class="nb"&gt;len&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;estimated&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="mi"&gt;336&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Keeping the provenance field in the application model is more useful than hiding the distinction in a footnote.&lt;/p&gt;

&lt;h2&gt;
  
  
  What we checked
&lt;/h2&gt;

&lt;p&gt;We compared the calculation with the CWA's &lt;a href="https://www.cwa.gov.tw/Data/astronomy/2026cal.pdf" rel="noopener noreferrer"&gt;2026 calendar&lt;/a&gt; and &lt;a href="https://www.cwa.gov.tw/Data/astronomy/2027cal.pdf" rel="noopener noreferrer"&gt;2027 calendar&lt;/a&gt;. Across those 48 solar terms, the local dates matched and the largest difference in the published minute was one minute. That is a useful check of the calculation; it does &lt;strong&gt;not&lt;/strong&gt; verify the remaining years against official tables. Some annual PDFs include a few terms from the following January. We still classify all 2028 rows as estimates because the dataset takes a complete set of 24 terms from each calendar year.&lt;/p&gt;

&lt;p&gt;The release also includes &lt;a href="https://github.com/CrabMen/nongminli.tw/blob/main/data/taiwan-climate-normals-five-stations-1991-2020.csv" rel="noopener noreferrer"&gt;1991–2020 monthly climate normals for five Taiwan stations&lt;/a&gt;: Taipei, Taichung, Kaohsiung, Hualien, and Hengchun. There are 480 rows: five stations × eight measurements × twelve months. These are long-term monthly averages, not a daily weather forecast. The Kaohsiung entry refers to the station used by the source table, not an interchangeable modern station record.&lt;/p&gt;

&lt;h2&gt;
  
  
  Make the release auditable
&lt;/h2&gt;

&lt;p&gt;Alongside the CSV files, we published a &lt;a href="https://github.com/CrabMen/nongminli.tw/blob/main/data/manifest.json" rel="noopener noreferrer"&gt;manifest&lt;/a&gt; with the source URLs, capture dates, and SHA-256 hashes of the source snapshots and output files. A small &lt;code&gt;python3 scripts/verify_data.py&lt;/code&gt; command checks the output hashes, column shapes, and row counts. The script works offline and does not modify the files.&lt;/p&gt;

&lt;p&gt;The &lt;a href="https://github.com/CrabMen/nongminli.tw/blob/main/data/DATA-LICENSE.md" rel="noopener noreferrer"&gt;license note&lt;/a&gt; also separates our own calculation, selection, and explanations from the CWA's original records. Our own contribution is offered under CC BY 4.0; CWA source material remains subject to its original terms and attribution. Reusing the CSV should not be described as receiving a new license from the CWA or as an official endorsement of the calculated rows.&lt;/p&gt;

&lt;p&gt;If you use this data to build a calendar, keep &lt;code&gt;value_kind&lt;/code&gt; visible in your pipeline. If you need an exact official time for research or a consequential decision, check that year's original CWA publication rather than assuming an estimate is authoritative. The files, field notes, and verification command are in the &lt;a href="https://github.com/CrabMen/nongminli.tw/tree/main/data" rel="noopener noreferrer"&gt;public data directory&lt;/a&gt;; the site's broader &lt;a href="https://nongminli.tw/sources" rel="noopener noreferrer"&gt;source notes&lt;/a&gt; explain where other calendar fields come from.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;An AI agent wrote this article. Its dataset counts, URLs, comparison result, and licensing distinctions were checked against the published files and source notes before publication.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>opensource</category>
      <category>data</category>
      <category>python</category>
    </item>
  </channel>
</rss>
