11 - use case: longest time series in Berlin

11.1 select station

Choose station in Berlin with longest monthly average recordings (according to metadata, which is not always correct).

##      Berlin-Adlershof Berlin-Alexanderplatz           Berlin-Buch 
##                   395                   399                   400 
## Berlin-Charlottenburg    Berlin-Dahlem (FU)  Berlin-Dahlem (LFAG) 
##                   401                   403                   402
Stations_id von_datum bis_datum Stationshoehe geoBreite geoLaenge Stationsname Bundesland res var per hasfile ndays
403 1719-01-01 2019-09-30 51 52.5 13.3  Berlin-Dahlem (FU) Berlin monthly kl historical TRUE 109845
402 1830-01-01 1962-12-31 55 52.5 13.3  Berlin-Dahlem (LFAG) Berlin monthly kl historical TRUE 48576
429 1890-07-01 1987-01-31 32 52.6 13.2  Berlin-Spandau Berlin monthly kl historical TRUE 35277
433 1938-01-01 2019-09-30 48 52.5 13.4  Berlin-Tempelhof Berlin monthly kl historical TRUE 29857
408 1883-01-01 1951-11-30 35 52.5 13.4  Berlin-Invalidenstrasse Berlin monthly kl historical TRUE 25169
400 1951-01-01 2019-09-30 60 52.6 13.5  Berlin-Buch Berlin monthly kl historical TRUE 25109
427 1957-01-01 2019-09-30 46 52.4 13.5  Berlin-Schoenefeld Brandenburg monthly kl historical TRUE 22917
5138 1945-01-01 2003-12-31 446 47.8 9.16 Ueberlingen/Bodensee Baden-Wuerttemberg monthly kl historical TRUE 21548
430 1961-01-01 2019-09-30 36 52.6 13.3  Berlin-Tegel Berlin monthly kl historical TRUE 21456
435 1964-01-01 2006-12-31 45 52.4 13.2  Berlin-Zehlendorf Berlin monthly kl historical TRUE 15705
399 1975-01-01 2015-05-31 36 52.5 13.4  Berlin-Alexanderplatz Berlin monthly kl historical TRUE 14760
425 1946-01-01 1982-06-30 38 52.4 13.5  Berlin-Rudow Berlin monthly kl historical TRUE 13329
424 1954-01-01 1980-12-31 36 52.5 13.5  Berlin-Ostkreuz Berlin monthly kl historical TRUE 9861
420 1993-05-01 2019-09-30 60 52.5 13.6  Berlin-Marzahn Berlin monthly kl historical TRUE 9648
417 1930-09-01 1956-10-31 43 52.4 13.3  Berlin-Lichterfelde (Sued) Berlin monthly kl historical TRUE 9557
410 1996-06-01 2018-11-30 33 52.4 13.7  Berlin-Kaniswall Berlin monthly kl historical TRUE 8217
407 1958-01-01 1978-03-31 48 52.6 13.3  Berlin-Frohnau Berlin monthly kl historical TRUE 7394
432 1978-04-01 1994-12-31 36 52.6 13.3  Berlin-Tegeler Fliesstal Berlin monthly kl historical TRUE 6118
416 1982-07-01 1996-09-30 47 52.4 13.4  Berlin-Lichtenrade Berlin monthly kl historical TRUE 5205
434 1947-01-01 1960-12-31 35 52.5 13.5  Berlin-Treptow Berlin monthly kl historical TRUE 5113
422 1956-01-01 1964-12-31 35 52.5 13.4  Berlin-Mitte Berlin monthly kl historical TRUE 3287
395 1948-07-01 1953-12-31 38 52.4 13.5  Berlin-Adlershof Berlin monthly kl historical TRUE 2009
405 1951-04-01 1954-12-31 37 52.5 13.6  Berlin-Friedrichshagen Berlin monthly kl historical TRUE 1370