📈 More stations

1 files changed, 22 insertions, 0 deletions

diff --git a/src/main/java/dev/morling/onebrc/CreateMeasurements.java b/src/main/java/dev/morling/onebrc/CreateMeasurements.java
index ff4b7d7..5f1fdae 100644
--- a/src/main/java/dev/morling/onebrc/CreateMeasurements.java
+++ b/src/main/java/dev/morling/onebrc/CreateMeasurements.java
@@ -52,6 +52,28 @@ public class CreateMeasurements {
             System.exit(1);
         }
 
+        // data from https://en.wikipedia.org/wiki/List_of_cities_by_average_temperature;
+        // converted using https://wikitable2csv.ggor.de/
+        // brought to form using DuckDB:
+        // D copy (
+        //     select City, regexp_extract(Year,'(.*)\n.*', 1) as AverageTemp
+        //     from (
+        //         select City,Year
+        //         from read_csv_auto('List_of_cities_by_average_temperature_1.csv', header = true)
+        //         union
+        //         select City,Year
+        //         from read_csv_auto('List_of_cities_by_average_temperature_2.csv', header = true)
+        //         union
+        //         select City,Year
+        //         from read_csv_auto('List_of_cities_by_average_temperature_3.csv', header = true)
+        //         union
+        //         select City,Year
+        //         from read_csv_auto('List_of_cities_by_average_temperature_4.csv', header = true)
+        //         union
+        //         select City,Year
+        //         from read_csv_auto('List_of_cities_by_average_temperature_5.csv', header = true)
+        //         )
+        // ) TO 'output.csv' (HEADER, DELIMITER ',');
         List<WeatherStation> stations = Arrays.asList(
                 new WeatherStation("Adelaide", 17.3),
                 new WeatherStation("Melbourne", 15.1),