In [1]:
%matplotlib inline

In [165]:
import requests
from pandas.io.json import json_normalize
import pandas as pd
import numpy as np

Getting all stations:


In [36]:
r = requests.get('http://api.gios.gov.pl/pjp-api/rest/station/findAll')

In [37]:
allStations = json_normalize(r.json())

In [5]:
print(allStations[allStations["city.name"] == u"Gdańsk"])


                   addressStreet  city city.commune.communeName  \
27   ul. Powstańców Warszawskich   NaN                   Gdańsk   
46                  ul. Leczkowa   NaN                   Gdańsk   
47                 ul. Ostrzycka   NaN                   Gdańsk   
120                 ul. Kaczeńce   NaN                   Gdańsk   
143               ul. Wyzwolenia   NaN                   Gdańsk   

    city.commune.districtName city.commune.provinceName  city.id city.name  \
27                     Gdańsk                 POMORSKIE    218.0    Gdańsk   
46                     Gdańsk                 POMORSKIE    218.0    Gdańsk   
47                     Gdańsk                 POMORSKIE    218.0    Gdańsk   
120                    Gdańsk                 POMORSKIE    218.0    Gdańsk   
143                    Gdańsk                 POMORSKIE    218.0    Gdańsk   

    dateEnd            dateStart    gegrLat    gegrLon   id  \
27     None  1996-10-01 00:00:00  54.353336  18.635283  729   
46     None  1998-10-01 00:00:00  54.380279  18.620274  736   
47     None  1998-05-01 00:00:00  54.328336  18.557781  733   
120    None  1996-10-01 00:00:00  54.367778  18.701111  730   
143    None  1998-09-01 00:00:00  54.400833  18.657497  731   

                stationName  
27   AM1 Gdańsk Śródmieście  
46      AM8 Gdańsk Wrzeszcz  
47      AM5 Gdańsk Szadółki  
120        AM2 Gdańsk Stogi  
143    AM3 Gdańsk Nowy Port  

Lets see what we have in "AM5 Gdańsk Szadółki" which has id: 733


In [6]:
stationId = 733

In [7]:
r = requests.get('http://api.gios.gov.pl/pjp-api/rest/station/sensors/' + str(stationId))

In [8]:
sensors = json_normalize(r.json())

In [9]:
print(sensors)


     id  param.idParam param.paramCode param.paramFormula  \
0  4720              8              CO                 CO   
1  4727              3            PM10               PM10   
2  4723              6             NO2                NO2   
3  4725              5              O3                 O3   
4  4730              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  1998-05-01 00:00:00        733  
1  pył zawieszony PM10          None  1998-05-01 00:00:00        733  
2      dwutlenek azotu          None  1998-05-01 00:00:00        733  
3                 ozon          None  1998-05-01 00:00:00        733  
4     dwutlenek siarki          None  1998-05-01 00:00:00        733  

Lets now see data about O3 concentration - sensorId = 4725


In [23]:
sensorId = 4725

In [24]:
r = requests.get('http://api.gios.gov.pl/pjp-api/rest/data/getData/' + str(sensorId))

In [25]:
concentration = json_normalize(r.json())

In [26]:
concentrationFrame = pd.DataFrame()

In [27]:
concentrationFrame["dates"] = [d[u'date'] for d in concentration["values"].values.item()]
concentrationFrame["values"] = [d[u'value'] for d in concentration["values"].values.item()]

In [28]:
concentrationFrame.set_index(["dates"], inplace=True)
#concentrationFrame.sort_index(inplace=True)
# We cannot sort index, because it is not unique. There is 12 hours notation used, but without AM/PM distinction ;(
# But we can just reverse it until API will be fixed
concentrationFrame = concentrationFrame.iloc[::-1]

In [29]:
print(concentrationFrame)


                       values
dates                        
2017-09-28 01:00:00  39.75330
2017-09-28 02:00:00  50.82890
2017-09-28 03:00:00  58.86440
2017-09-28 04:00:00  45.70720
2017-09-28 05:00:00  42.51000
2017-09-28 06:00:00  83.89330
2017-09-28 07:00:00  52.07940
2017-09-28 08:00:00  23.49780
2017-09-28 09:00:00  19.13890
2017-09-28 10:00:00  33.90280
2017-09-28 11:00:00  40.63330
2017-09-28 12:00:00  48.43220
2017-09-28 13:00:00  54.39560
2017-09-28 14:00:00  55.71500
2017-09-28 15:00:00  63.96330
2017-09-28 16:00:00  66.22280
2017-09-28 17:00:00  64.46610
2017-09-28 18:00:00  52.28220
2017-09-28 19:00:00  40.60670
2017-09-28 20:00:00  38.34560
2017-09-28 21:00:00  46.36560
2017-09-28 22:00:00  58.75940
2017-09-28 23:00:00  50.17220
2017-09-29 00:00:00  31.58000
2017-09-29 01:00:00  17.13060
2017-09-29 02:00:00   4.32667
2017-09-29 03:00:00   4.16278
2017-09-29 04:00:00   6.48444
2017-09-29 05:00:00  20.36330
2017-09-29 06:00:00  10.55280
2017-09-29 07:00:00  20.38940
2017-09-29 08:00:00  55.20610
2017-09-29 09:00:00  32.51330
2017-09-29 10:00:00  25.64890
2017-09-29 11:00:00  29.81720
2017-09-29 12:00:00  37.15280
2017-09-29 13:00:00  46.50780
2017-09-29 14:00:00  56.36110
2017-09-29 15:00:00  66.60500
2017-09-29 16:00:00  68.54000
2017-09-29 17:00:00  64.96560
2017-09-29 18:00:00  60.31670
2017-09-29 19:00:00  51.87610
2017-09-29 20:00:00  37.92500
2017-09-29 21:00:00  50.14330
2017-09-29 22:00:00  60.19330
2017-09-29 23:00:00  40.23060
2017-09-30 00:00:00  36.26110
2017-09-30 01:00:00  18.16940
2017-09-30 02:00:00  25.21440
2017-09-30 03:00:00  20.76440
2017-09-30 04:00:00  27.81610
2017-09-30 05:00:00  11.99670
2017-09-30 06:00:00  35.71110
2017-09-30 07:00:00  49.77670
2017-09-30 08:00:00  47.17830
2017-09-30 09:00:00  35.06720
2017-09-30 10:00:00  34.69440
2017-09-30 11:00:00       NaN

In [30]:
concentrationFrame.plot(figsize=(15,5), grid=True)


Out[30]:
<matplotlib.axes._subplots.AxesSubplot at 0x7f61cc323d90>

And overall air quality index for the same station


In [31]:
r = requests.get('http://api.gios.gov.pl/pjp-api/rest/aqindex/getIndex/' + str(stationId))

In [32]:
r.json()


Out[32]:
{u'c6h6CalcDate': None,
 u'c6h6IndexLevel': None,
 u'c6h6SourceDataDate': None,
 u'coCalcDate': u'2017-09-30 11:17:42',
 u'coIndexLevel': {u'id': 0, u'indexLevelName': u'Bardzo dobry'},
 u'coSourceDataDate': u'2017-09-30 10:00:00',
 u'id': 733,
 u'no2CalcDate': u'2017-09-30 11:17:42',
 u'no2IndexLevel': {u'id': 0, u'indexLevelName': u'Bardzo dobry'},
 u'no2SourceDataDate': u'2017-09-30 10:00:00',
 u'o3CalcDate': u'2017-09-30 11:17:42',
 u'o3IndexLevel': {u'id': 1, u'indexLevelName': u'Dobry'},
 u'o3SourceDataDate': u'2017-09-30 10:00:00',
 u'pm10CalcDate': u'2017-09-30 11:17:42',
 u'pm10IndexLevel': None,
 u'pm10SourceDataDate': None,
 u'pm25CalcDate': u'2017-09-30 11:17:42',
 u'pm25IndexLevel': None,
 u'pm25SourceDataDate': None,
 u'so2CalcDate': u'2017-09-30 11:17:42',
 u'so2IndexLevel': {u'id': 0, u'indexLevelName': u'Bardzo dobry'},
 u'so2SourceDataDate': u'2017-09-30 10:00:00',
 u'stCalcDate': u'2017-09-30 11:17:42',
 u'stIndexLevel': {u'id': 1, u'indexLevelName': u'Dobry'},
 u'stSourceDataDate': u'2017-09-30 10:00:00'}

In [ ]:


In [ ]:


In [ ]:


In [38]:
allStations


Out[38]:
addressStreet city city.commune.communeName city.commune.districtName city.commune.provinceName city.id city.name dateEnd dateStart gegrLat gegrLon id stationName
0 ul. Orzechowa NaN Biała Podlaska Biała Podlaska LUBELSKIE 26.0 Biała Podlaska None 1993-04-07 00:00:00 52.029194 23.149389 236 BiałaP-Orzechowa
1 ul. Waszyngtona 16 NaN Białystok Białystok PODLASKIE 35.0 Białystok None 2004-09-01 00:00:00 53.126689 23.155869 605 Białystok-Miejska
2 ul. 42 Pułku Piechoty NaN Białystok Białystok PODLASKIE 35.0 Białystok None 2004-09-01 00:00:00 53.138614 23.229903 606 Białystok-Podmiejska
3 ul. Kopalniana NaN Czerwionka-Leszczyny rybnicki ŚLĄSKIE 145.0 Czerwionka-Leszczyny None 2013-12-22 00:00:00 50.16385 18.659977 9000 Czerwionka-Leszczyny, ul. Kopalniana
4 ul. Piłsudskiego 26 NaN Dzierżoniów dzierżoniowski DOLNOŚLĄSKIE 198.0 Dzierżoniów None 2005-01-01 00:00:00 50.732817 16.648050 16 Dzierżoniów - Piłsudskiego
5 ul. Ogińskiego 6 NaN Jelenia Góra Jelenia Góra DOLNOŚLĄSKIE 319.0 Jelenia Góra None 2014-10-20 00:00:00 50.913433 15.765608 9153 Jelenia Góra - Ogińskiego
6 ul. Wały Gen. Sikorskiego 12 NaN Toruń Toruń KUJAWSKO-POMORSKIE 966.0 Toruń None 2012-03-01 00:00:00 53.012261 18.606203 145 Toruń Airpointer
7 ul. Wyb. J.Conrada-Korzeniowskiego 18 NaN Wrocław Wrocław DOLNOŚLĄSKIE 1064.0 Wrocław None 2005-01-01 00:00:00 51.129378 17.029250 117 Wrocław - Korzeniowskiego
8 al. Górnośląska NaN Katowice Katowice ŚLĄSKIE 350.0 Katowice None 2011-01-01 00:00:00 50.246795 19.019469 813 Katowice, ul. Plebiscytowa/A4
9 ul. Bolesława Śmiałego 5 NaN Kędzierzyn-Koźle kędzierzyńsko-kozielski OPOLSKIE 355.0 Kędzierzyn-Koźle None 2005-01-01 00:00:00 50.349608 18.236575 568 K-Koźle automat 1
10 ul. Dietla NaN Kraków Kraków MAŁOPOLSKIE 415.0 Kraków None 2016-01-01 00:00:00 50.057447 19.946008 10121 Kraków, ul. Dietla
11 None NaN Krempna jasielski PODKARPACKIE 421.0 Krempna None 2014-10-06 00:00:00 49.511297 21.498606 9175 Krempna-MPN-WIOS
12 al. Rzeczypospolitej 10/12 NaN Legnica Legnica DOLNOŚLĄSKIE 453.0 Legnica None 2004-10-01 00:00:00 51.204503 16.180513 52 Legnica - Rzeczypospolitej
13 Rąbka 1a NaN Łeba lęborski POMORSKIE 506.0 Łeba None 2004-03-31 00:00:00 54.754139 17.534528 750 IMGW Łeba - Rąbka
14 al. Jana Pawła II 15 NaN Łódź Łódź ŁÓDZKIE 516.0 Łódź None 2015-10-27 00:00:00 51.754613 19.434925 10058 Łódź-Jana Pawła II 15
15 ul. Srebrna 1a NaN Nowa Ruda kłodzki DOLNOŚLĄSKIE 602.0 Nowa Ruda None 2011-01-01 00:00:00 50.579914 16.514422 67 Nowa Ruda - Srebrna
16 ul. Pułaskiego 6/8 NaN Piastów pruszkowski MAZOWIECKIE 685.0 Piastów None 2003-08-01 00:00:00 52.191728 20.837489 488 Piastów-Pułaskiego
17 ul. Krakowskie Przedmieście 13 NaN Piotrków Trybunalski Piotrków Trybunalski ŁÓDZKIE 703.0 Piotrków Trybunalski None 2009-12-15 00:00:00 51.404406 19.696956 322 Piotrków Tryb.-Krakowskie Przedmieście
18 Rejtana NaN Rzeszów Rzeszów PODKARPACKIE 810.0 Rzeszów None 2010-02-01 00:00:00 50.024242 22.010575 671 Rzeszów-Nowe Miasto
19 ul. Pułaskiego NaN Suwałki Suwałki PODLASKIE 906.0 Suwałki None 1992-03-18 00:00:00 54.117878 22.934608 622 Suwałki, ul. Pułaskiego 73
20 ul. Andrzejewskiego 23 NaN Szczecin Szczecin ZACHODNIOPOMORSKIE 917.0 Szczecin None 2004-12-31 00:00:00 53.380975 14.663347 986 Szczecin_Andrzejewskiego
21 ul. Zdrojowa NaN Augustów augustowski PODLASKIE 8.0 Augustów None 2017-01-01 00:00:00 53.859528 23.000750 10054 Augustów - mobilne
22 None NaN Zwierzyniec zamojski LUBELSKIE 34.0 Biały Słup None 2006-01-01 00:00:00 50.590806 22.997889 240 Biały Słup (RPN)
23 Juliusza Słowackiego 2 NaN Bolesławiec bolesławiecki DOLNOŚLĄSKIE 55.0 Bolesławiec None 2017-01-01 00:00:00 51.263245 15.570354 10035 Bolesławiec
24 None NaN Krynki sokólski PODLASKIE 63.0 Borsukowizna None 2004-09-01 00:00:00 53.215492 23.642153 612 Borsukowizna-Wiejska
25 ul. Bażyńskiego 6 NaN Elbląg Elbląg WARMIŃSKO-MAZURSKIE 202.0 Elbląg None 2005-06-15 00:00:00 54.167847 19.410942 861 WIOŚ Elbląg ul. Bażyńskiego
26 Ujęcie wody NaN Witonia łęczycki ŁÓDZKIE 209.0 Gajew None 2003-11-01 00:00:00 52.143250 19.233225 291 Gajew
27 ul. Powstańców Warszawskich NaN Gdańsk Gdańsk POMORSKIE 218.0 Gdańsk None 1996-10-01 00:00:00 54.353336 18.635283 729 AM1 Gdańsk Śródmieście
28 ul. Wendy NaN Gdynia Gdynia POMORSKIE 219.0 Gdynia None 2000-12-01 00:00:00 54.525274 18.536382 739 AM10 Gdynia Śródmieście
29 None NaN Wola Mysłowska łukowski LUBELSKIE 301.0 Jarczew None 1985-10-01 00:00:00 51.814367 21.972375 248 IMGW-Jarczew
... ... ... ... ... ... ... ... ... ... ... ... ... ...
132 os. Piastów NaN Kraków Kraków MAŁOPOLSKIE 415.0 Kraków None 2016-01-01 00:00:00 50.099361 20.018317 10139 Kraków, os. Piastów
133 ul. Bujaka NaN Kraków Kraków MAŁOPOLSKIE 415.0 Kraków None 2010-01-01 00:00:00 50.010575 19.949189 401 Kraków, ul. Bujaka
134 ul. Koszyka NaN Opole Opole OPOLSKIE 645.0 Opole None 2017-01-01 00:00:00 50.666736 17.899137 10374 Opole automat 5
135 ul. Kusocińskiego NaN Piła pilski WIELKOPOLSKIE 699.0 Piła None 2003-01-01 00:00:00 53.154408 16.759572 920 Pila, ul. Kusocinkiego
136 Grunwaldzka NaN Przemyśl Przemyśl PODKARPACKIE 748.0 Przemyśl None 2013-01-01 00:00:00 49.784339 22.756239 665 Przemysl-Grunwaldzka-WIOS
137 ul. Tochtermana 1 NaN Radom Radom MAZOWIECKIE 771.0 Radom None 2003-08-01 00:00:00 51.399084 21.147474 515 Radom-Tochtermana
138 None NaN Solec-Zdrój buski ŚWIĘTOKRZYSKIE 860.0 Solec Zdrój None 2017-01-01 00:00:00 50.358659 20.886184 10455 Solec-Zdrój, MOBILNA
139 ul. Bitwy pod Płowcami NaN Sopot Sopot POMORSKIE 861.0 Sopot None 1998-07-01 00:00:00 54.431667 18.579722 734 AM6 Sopot
140 ul. Lubelska 51 NaN Sosnowiec Sosnowiec ŚLĄSKIE 862.0 Sosnowiec None 2010-04-01 00:00:00 50.285956 19.184399 837 Sosnowiec, ul. Lubelska 51
141 Osiedle PAN 1 NaN Grójec grójecki MAZOWIECKIE 19.0 Belsk Duży None 1991-07-01 00:00:00 51.835120 20.791556 460 Belsk-IGFPAN
142 Plac Poznański NaN Bydgoszcz Bydgoszcz KUJAWSKO-POMORSKIE 90.0 Bydgoszcz None 2006-01-06 00:00:00 53.121764 17.987906 156 Bydgoszcz Plac Poznański
143 ul. Armii Krajowej 2 NaN Częstochowa Częstochowa ŚLĄSKIE 146.0 Częstochowa None 2010-01-01 00:00:00 50.817676 19.117426 798 Częstochowa, ul. AK/Jana Pawła II
144 ul. Wyzwolenia NaN Gdańsk Gdańsk POMORSKIE 218.0 Gdańsk None 1998-09-01 00:00:00 54.400833 18.657497 731 AM3 Gdańsk Nowy Port
145 ul. Mewy 34 NaN Gliwice Gliwice ŚLĄSKIE 221.0 Gliwice None 2005-01-01 00:00:00 50.279333 18.655764 809 Gliwice, ul. Mewy 34
146 ul. Piłsudskiego 51 NaN Grudziądz Grudziądz KUJAWSKO-POMORSKIE 269.0 Grudziądz None 2012-03-01 00:00:00 53.493550 18.762139 142 Grudziądz Airpointer
147 Sikorskiego NaN Jasło jasielski PODKARPACKIE 306.0 Jasło None 2009-08-01 00:00:00 49.744886 21.454617 638 Jaslo-Sikorskiego-WIOS
148 ul. Ks. Romana Sitko NaN Tarnów Tarnów MAŁOPOLSKIE 958.0 Tarnów None 2016-01-01 00:00:00 50.017875 20.993000 10120 Tarnów, ul. Ks. Romana Sitko
149 ul. M. Skłodowskiej-Curie 34 NaN Zabrze Zabrze ŚLĄSKIE 1073.0 Zabrze None 2001-01-01 00:00:00 50.3165 18.772375 848 Zabrze, ul. M. Curie-Skłodowskiej 34
150 ul. Jagiellońska 68 NaN Kielce Kielce ŚWIĘTOKRZYSKIE 360.0 Kielce None 2010-01-01 00:00:00 50.872549 20.604998 761 Kielce, ul. Jagiellońska
151 Złoty Róg NaN Kraków Kraków MAŁOPOLSKIE 415.0 Kraków None 2016-01-01 00:00:00 50.081197 19.895358 10123 Kraków, ul. Złoty Róg
152 ul. Malczewskiego NaN Lębork lęborski POMORSKIE 464.0 Lębork None 2012-01-01 00:00:00 54.546167 17.746194 742 AM16 Lębork Malczewskiego
153 ul. Mickiewicza NaN Malbork malborski POMORSKIE 527.0 Malbork None 2012-01-01 00:00:00 54.031247 19.032899 741 AM15 Malbork Mickiewicza
154 Plac Słowackiego NaN Nowy Targ nowotarski MAŁOPOLSKIE 626.0 Nowy Targ None 2016-03-21 00:00:00 49.483597 20.028992 10254 Nowy Targ, Plac Słowackiego
155 ul. Puszkina 16 NaN Olsztyn Olsztyn WARMIŃSKO-MAZURSKIE 639.0 Olsztyn None 2004-06-01 00:00:00 53.789233 20.486075 877 WIOŚ Olsztyn ul. Puszkina
156 ul. Żołnierzy AK 9 NaN Oława oławski DOLNOŚLĄSKIE 642.0 Oława None 2008-07-01 00:00:00 50.942073 17.291333 70 Oława - Żołnierzy AK
157 Ujęcie wody NaN Wola Krzysztoporska piotrkowski ŁÓDZKIE 673.0 Parzniewice None 2003-10-17 00:00:00 51.291175 19.517556 319 Parzniewice
158 ul. Konarskiego 11 NaN Siedlce Siedlce MAZOWIECKIE 823.0 Siedlce None 2012-01-01 00:00:00 52.172145 22.282001 517 Siedlce-Konarskiego
159 None NaN Bytnica krośnieński LUBUSKIE 848.0 Smolary Bytnickie None 2005-01-01 00:00:00 52.172222 15.206667 374 Smolary Bytnickie
160 ul. Dudka NaN Sulęcin sulęciński LUBUSKIE 903.0 Sulęcin None 2011-01-26 00:00:00 52.437722 15.122444 376 Sulęcin ul. Dudka
161 Guty Duże 4 NaN NaN NaN NaN NaN NaN None 2016-01-01 00:00:00 52.943172 21.288167 9913 Guty Duże

162 rows × 13 columns


In [83]:
stationsId = allStations["id"]

In [84]:
sid = list(stationsId)

In [85]:
allsensors = pd.DataFrame()

In [86]:
for station in sid:
    print(station)
    sensorlist = json_normalize(requests.get('http://api.gios.gov.pl/pjp-api/rest/station/sensors/' + str(station)).json())
    print(sensorlist)
    print("--------------------------")
    allsensors = allsensors.append(sensorlist)
    #if station == 9000:
    #    break


236
      id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  15727              6             NO2                NO2   dwutlenek azotu   
1   1676              5              O3                 O3              ozon   
2  14348              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2015-07-01 00:00:00        236  
1          None  2010-01-01 00:00:00        236  
2          None  2014-01-01 00:00:00        236  
--------------------------
605
     id  param.idParam param.paramCode param.paramFormula  \
0  3996              8              CO                 CO   
1  4001              6             NO2                NO2   
2  4005             69           PM2.5              PM2.5   
3  4006              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2004-09-01 00:00:00        605  
1       dwutlenek azotu          None  2004-09-01 00:00:00        605  
2  pył zawieszony PM2.5          None  2009-07-01 00:00:00        605  
3      dwutlenek siarki          None  2004-09-01 00:00:00        605  
--------------------------
606
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  4011              6             NO2                NO2   dwutlenek azotu   
1  4013              5              O3                 O3              ozon   
2  4016              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2004-09-01 00:00:00        606  
1          None  2004-09-01 00:00:00        606  
2          None  2004-09-01 00:00:00        606  
--------------------------
9000
      id  param.idParam param.paramCode param.paramFormula param.paramName  \
0  14498             10            C6H6               C6H6          benzen   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2013-12-22 00:00:00       9000  
--------------------------
16
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  101              3            PM10               PM10  pył zawieszony PM10   
1   99              6             NO2                NO2      dwutlenek azotu   
2  102              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2005-01-01 00:00:00         16  
1          None  2005-01-01 00:00:00         16  
2          None  2005-01-01 00:00:00         16  
--------------------------
9153
      id  param.idParam param.paramCode param.paramFormula  \
0  14707              8              CO                 CO   
1  14730              3            PM10               PM10   
2  14734             10            C6H6               C6H6   
3  14727              6             NO2                NO2   
4  14731             69           PM2.5              PM2.5   
5  14729              5              O3                 O3   
6  14733              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2014-10-20 00:00:00       9153  
1   pył zawieszony PM10          None  2014-10-20 00:00:00       9153  
2                benzen          None  2014-10-20 00:00:00       9153  
3       dwutlenek azotu          None  2014-10-20 00:00:00       9153  
4  pył zawieszony PM2.5          None  2014-10-20 00:00:00       9153  
5                  ozon          None  2014-10-20 00:00:00       9153  
6      dwutlenek siarki          None  2014-10-20 00:00:00       9153  
--------------------------
145
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  853              3            PM10               PM10  pył zawieszony PM10   
1  850              6             NO2                NO2      dwutlenek azotu   
2  855              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2012-03-01 00:00:00        145  
1          None  2012-03-01 00:00:00        145  
2          None  2012-03-01 00:00:00        145  
--------------------------
117
      id  param.idParam param.paramCode param.paramFormula  \
0    660              8              CO                 CO   
1  14395              3            PM10               PM10   
2    658             10            C6H6               C6H6   
3    665              6             NO2                NO2   
4    670             69           PM2.5              PM2.5   
5    667              5              O3                 O3   
6    672              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2005-01-01 00:00:00        117  
1   pył zawieszony PM10          None  2014-01-03 00:00:00        117  
2                benzen          None  2005-01-01 00:00:00        117  
3       dwutlenek azotu          None  2005-01-01 00:00:00        117  
4  pył zawieszony PM2.5          None  2008-06-01 00:00:00        117  
5                  ozon          None  2005-01-01 00:00:00        117  
6      dwutlenek siarki          None  2005-01-01 00:00:00        117  
--------------------------
813
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  5343              8              CO                 CO      tlenek węgla   
1  5346              6             NO2                NO2   dwutlenek azotu   
2  5354              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2011-01-01 00:00:00        813  
1          None  2011-01-01 00:00:00        813  
2          None  2011-01-01 00:00:00        813  
--------------------------
568
     id  param.idParam param.paramCode param.paramFormula  \
0  3836              8              CO                 CO   
1  3843              3            PM10               PM10   
2  3834             10            C6H6               C6H6   
3  3839              6             NO2                NO2   
4  3844             69           PM2.5              PM2.5   
5  3841              5              O3                 O3   
6  3847              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2005-01-01 00:00:00        568  
1   pył zawieszony PM10          None  2005-01-01 00:00:00        568  
2                benzen          None  2005-01-01 00:00:00        568  
3       dwutlenek azotu          None  2005-01-01 00:00:00        568  
4  pył zawieszony PM2.5          None  2009-07-01 00:00:00        568  
5                  ozon          None  2005-01-01 00:00:00        568  
6      dwutlenek siarki          None  2005-01-01 00:00:00        568  
--------------------------
10121
      id  param.idParam param.paramCode param.paramFormula  \
0  16377              3            PM10               PM10   
1  16516              6             NO2                NO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2016-01-01 00:00:00      10121  
1      dwutlenek azotu          None  2016-01-01 00:00:00      10121  
--------------------------
9175
      id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  14753              6             NO2                NO2   dwutlenek azotu   
1  14756              5              O3                 O3              ozon   
2  14751              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2014-10-06 00:00:00       9175  
1          None  2014-10-06 00:00:00       9175  
2          None  2014-10-06 00:00:00       9175  
--------------------------
52
      id  param.idParam param.paramCode param.paramFormula  \
0    285              8              CO                 CO   
1  14397              3            PM10               PM10   
2    282             10            C6H6               C6H6   
3    291              6             NO2                NO2   
4    293              5              O3                 O3   
5    297              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00         52  
1  pył zawieszony PM10          None  2014-03-20 00:00:00         52  
2               benzen          None  2013-01-01 00:00:00         52  
3      dwutlenek azotu          None  2005-01-01 00:00:00         52  
4                 ozon          None  2011-08-01 00:00:00         52  
5     dwutlenek siarki          None  2005-01-01 00:00:00         52  
--------------------------
750
     id  param.idParam param.paramCode param.paramFormula param.paramName  \
0  4959              5              O3                 O3            ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2005-01-01 00:00:00        750  
--------------------------
10058
      id  param.idParam param.paramCode param.paramFormula  \
0  16228              8              CO                 CO   
1  16250              3            PM10               PM10   
2  16249             10            C6H6               C6H6   
3  16231              6             NO2                NO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2015-11-27 00:00:00      10058  
1  pył zawieszony PM10          None  2015-11-27 00:00:00      10058  
2               benzen          None  2015-11-27 00:00:00      10058  
3      dwutlenek azotu          None  2015-11-27 00:00:00      10058  
--------------------------
67
      id  param.idParam param.paramCode param.paramFormula  \
0  14706              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2014-10-20 00:00:00         67  
--------------------------
488
      id  param.idParam param.paramCode param.paramFormula  \
0   3339              6             NO2                NO2   
1  14779             69           PM2.5              PM2.5   
2  14352              5              O3                 O3   
3   3348              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0       dwutlenek azotu          None  2003-08-01 00:00:00        488  
1  pył zawieszony PM2.5          None  2015-01-01 00:00:00        488  
2                  ozon          None  2014-01-01 00:00:00        488  
3      dwutlenek siarki          None  2003-08-01 00:00:00        488  
--------------------------
322
     id  param.idParam param.paramCode param.paramFormula  \
0  2239              8              CO                 CO   
1  2245              3            PM10               PM10   
2  2242              6             NO2                NO2   
3  2244              5              O3                 O3   
4  2248              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2009-12-15 00:00:00        322  
1  pył zawieszony PM10          None  2009-12-15 00:00:00        322  
2      dwutlenek azotu          None  2009-12-15 00:00:00        322  
3                 ozon          None  2009-12-15 00:00:00        322  
4     dwutlenek siarki          None  2009-12-15 00:00:00        322  
--------------------------
671
      id  param.idParam param.paramCode param.paramFormula  \
0   4379              8              CO                 CO   
1  14466              3            PM10               PM10   
2   4376             10            C6H6               C6H6   
3   4383              6             NO2                NO2   
4   4385              5              O3                 O3   
5   4391              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2013-01-01 00:00:00        671  
1  pył zawieszony PM10          None  2014-01-01 00:00:00        671  
2               benzen          None  2013-01-01 00:00:00        671  
3      dwutlenek azotu          None  2013-01-01 00:00:00        671  
4                 ozon          None  2013-01-01 00:00:00        671  
5     dwutlenek siarki          None  2013-01-01 00:00:00        671  
--------------------------
622
      id  param.idParam param.paramCode param.paramFormula  \
0  14876             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM2.5          None  2014-06-01 00:00:00        622  
--------------------------
986
     id  param.idParam param.paramCode param.paramFormula  \
0  6352              3            PM10               PM10   
1  6348              6             NO2                NO2   
2  6354             69           PM2.5              PM2.5   
3  6350              5              O3                 O3   
4  6357              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2004-12-31 00:00:00        986  
1       dwutlenek azotu          None  2004-12-31 00:00:00        986  
2  pył zawieszony PM2.5          None  2009-08-01 00:00:00        986  
3                  ozon          None  2004-12-31 00:00:00        986  
4      dwutlenek siarki          None  2004-12-31 00:00:00        986  
--------------------------
10054
      id  param.idParam param.paramCode param.paramFormula  \
0  16251              8              CO                 CO   
1  16257              3            PM10               PM10   
2  16258              6             NO2                NO2   
3  16254             69           PM2.5              PM2.5   
4  16253              5              O3                 O3   
5  16255              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2017-01-01 00:00:00      10054  
1   pył zawieszony PM10          None  2017-01-01 00:00:00      10054  
2       dwutlenek azotu          None  2017-01-01 00:00:00      10054  
3  pył zawieszony PM2.5          None  2017-01-01 00:00:00      10054  
4                  ozon          None  2017-01-01 00:00:00      10054  
5      dwutlenek siarki          None  2017-01-01 00:00:00      10054  
--------------------------
240
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  1688              6             NO2                NO2   dwutlenek azotu   
1  1690              5              O3                 O3              ozon   
2  1693              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2006-01-01 00:00:00        240  
1          None  2006-01-01 00:00:00        240  
2          None  2006-01-01 00:00:00        240  
--------------------------
10035
      id  param.idParam param.paramCode param.paramFormula  \
0  16408              8              CO                 CO   
1  16388              3            PM10               PM10   
2  16410              6             NO2                NO2   
3  16407              5              O3                 O3   
4  16406              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2017-01-01 00:00:00      10035  
1  pył zawieszony PM10          None  2017-01-01 00:00:00      10035  
2      dwutlenek azotu          None  2017-01-01 00:00:00      10035  
3                 ozon          None  2017-01-01 00:00:00      10035  
4     dwutlenek siarki          None  2017-01-01 00:00:00      10035  
--------------------------
612
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  4040              6             NO2                NO2   dwutlenek azotu   
1  4042              5              O3                 O3              ozon   
2  4045              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2004-09-01 00:00:00        612  
1          None  2004-09-01 00:00:00        612  
2          None  2005-09-01 00:00:00        612  
--------------------------
861
     id  param.idParam param.paramCode param.paramFormula  \
0  5673              8              CO                 CO   
1  5683              3            PM10               PM10   
2  5671             10            C6H6               C6H6   
3  5678              6             NO2                NO2   
4  5680              5              O3                 O3   
5  5686              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-06-15 00:00:00        861  
1  pył zawieszony PM10          None  2005-06-15 00:00:00        861  
2               benzen          None  2005-06-15 00:00:00        861  
3      dwutlenek azotu          None  2005-06-15 00:00:00        861  
4                 ozon          None  2005-06-15 00:00:00        861  
5     dwutlenek siarki          None  2005-06-15 00:00:00        861  
--------------------------
291
     id  param.idParam param.paramCode param.paramFormula  \
0  2035              3            PM10               PM10   
1  2031              6             NO2                NO2   
2  2033              5              O3                 O3   
3  2039              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2003-11-01 00:00:00        291  
1      dwutlenek azotu          None  2003-11-01 00:00:00        291  
2                 ozon          None  2003-11-01 00:00:00        291  
3     dwutlenek siarki          None  2009-01-15 00:00:00        291  
--------------------------
729
     id  param.idParam param.paramCode param.paramFormula  \
0  4676              8              CO                 CO   
1  4681              3            PM10               PM10   
2  4679              6             NO2                NO2   
3  4683              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2010-01-01 00:00:00        729  
1  pył zawieszony PM10          None  1998-03-01 00:00:00        729  
2      dwutlenek azotu          None  1998-03-01 00:00:00        729  
3     dwutlenek siarki          None  1998-03-01 00:00:00        729  
--------------------------
739
     id  param.idParam param.paramCode param.paramFormula  \
0  4793              3            PM10               PM10   
1  4791              6             NO2                NO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2001-05-01 00:00:00        739  
1      dwutlenek azotu          None  2000-12-01 00:00:00        739  
--------------------------
248
     id  param.idParam param.paramCode param.paramFormula param.paramName  \
0  1741              5              O3                 O3            ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  1996-01-01 00:00:00        248  
--------------------------
842
     id  param.idParam param.paramCode param.paramFormula  \
0  5515              3            PM10               PM10   
1  5512              6             NO2                NO2   
2  5514              5              O3                 O3   
3  5516              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2013-10-01 00:00:00        842  
1      dwutlenek azotu          None  2012-01-01 00:00:00        842  
2                 ozon          None  2012-01-01 00:00:00        842  
3     dwutlenek siarki          None  2012-01-01 00:00:00        842  
--------------------------
544
      id  param.idParam param.paramCode param.paramFormula  \
0   3688              8              CO                 CO   
1   3694              3            PM10               PM10   
2   3691              6             NO2                NO2   
3  16287             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2013-01-01 00:00:00        544  
1   pył zawieszony PM10          None  2013-01-01 00:00:00        544  
2       dwutlenek azotu          None  2013-01-01 00:00:00        544  
3  pył zawieszony PM2.5          None  2016-01-01 00:00:00        544  
--------------------------
961
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  6212              6             NO2                NO2   dwutlenek azotu   
1  6214              5              O3                 O3              ozon   
2  6218              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2003-01-01 00:00:00        961  
1          None  2004-01-01 00:00:00        961  
2          None  2003-01-01 00:00:00        961  
--------------------------
379
      id  param.idParam param.paramCode param.paramFormula  \
0   2554              8              CO                 CO   
1   2563              3            PM10               PM10   
2   2559              6             NO2                NO2   
3  14633              5              O3                 O3   
4   2566              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2014-11-06 00:00:00        379  
1  pył zawieszony PM10          None  2013-12-01 00:00:00        379  
2      dwutlenek azotu          None  2005-01-01 00:00:00        379  
3                 ozon          None  2014-12-01 00:00:00        379  
4     dwutlenek siarki          None  2005-01-01 00:00:00        379  
--------------------------
285
      id  param.idParam param.paramCode param.paramFormula  \
0  16744              3            PM10               PM10   
1  14367             10            C6H6               C6H6   
2   2001              6             NO2                NO2   
3   2008              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2017-01-01 00:00:00        285  
1               benzen          None  2014-01-01 00:00:00        285  
2      dwutlenek azotu          None  2011-10-01 00:00:00        285  
3     dwutlenek siarki          None  2011-01-01 00:00:00        285  
--------------------------
856
      id  param.idParam param.paramCode param.paramFormula  \
0  14916              3            PM10               PM10   
1  14917              6             NO2                NO2   
2  14915              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2015-01-01 00:00:00        856  
1      dwutlenek azotu          None  2015-01-01 00:00:00        856  
2     dwutlenek siarki          None  2015-01-01 00:00:00        856  
--------------------------
10119
      id  param.idParam param.paramCode param.paramFormula  param.paramName  \
0  16486              6             NO2                NO2  dwutlenek azotu   
1  16488              5              O3                 O3             ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2016-01-01 00:00:00      10119  
1          None  2016-01-01 00:00:00      10119  
--------------------------
946
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  6104              6             NO2                NO2   dwutlenek azotu   
1  6106              5              O3                 O3              ozon   
2  6108              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2005-04-21 00:00:00        946  
1          None  2005-04-21 00:00:00        946  
2          None  2005-04-21 00:00:00        946  
--------------------------
266
      id  param.idParam param.paramCode param.paramFormula  \
0   1888              8              CO                 CO   
1   1900              3            PM10               PM10   
2   1885             10            C6H6               C6H6   
3   1895              6             NO2                NO2   
4  16472             69           PM2.5              PM2.5   
5   1897              5              O3                 O3   
6   1902              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2010-05-21 00:00:00        266  
1   pył zawieszony PM10          None  2010-05-21 00:00:00        266  
2                benzen          None  2010-05-21 00:00:00        266  
3       dwutlenek azotu          None  2010-05-21 00:00:00        266  
4  pył zawieszony PM2.5          None  2015-01-01 00:00:00        266  
5                  ozon          None  2010-05-21 00:00:00        266  
6      dwutlenek siarki          None  2010-05-21 00:00:00        266  
--------------------------
10794
      id  param.idParam param.paramCode param.paramFormula  \
0  17800              3            PM10               PM10   
1  17796              6             NO2                NO2   
2  17801             69           PM2.5              PM2.5   
3  17799              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2017-10-01 00:00:00      10794  
1       dwutlenek azotu          None  2017-10-01 00:00:00      10794  
2  pył zawieszony PM2.5          None  2017-10-01 00:00:00      10794  
3      dwutlenek siarki          None  2017-10-01 00:00:00      10794  
--------------------------
769
      id  param.idParam param.paramCode param.paramFormula  \
0   5085              3            PM10               PM10   
1   5083              6             NO2                NO2   
2  14878              5              O3                 O3   
3   5087              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2010-01-01 00:00:00        769  
1      dwutlenek azotu          None  2010-03-22 00:00:00        769  
2                 ozon          None  2014-03-25 00:00:00        769  
3     dwutlenek siarki          None  2010-03-22 00:00:00        769  
--------------------------
314
     id  param.idParam param.paramCode param.paramFormula  \
0  2199              3            PM10               PM10   
1  2195              6             NO2                NO2   
2  2197              5              O3                 O3   
3  2204              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2003-11-01 00:00:00        314  
1      dwutlenek azotu          None  2003-11-01 00:00:00        314  
2                 ozon          None  2008-12-09 00:00:00        314  
3     dwutlenek siarki          None  2003-11-01 00:00:00        314  
--------------------------
501
      id  param.idParam param.paramCode param.paramFormula  \
0   3420              8              CO                 CO   
1   3429              3            PM10               PM10   
2   3419             10            C6H6               C6H6   
3   3425              6             NO2                NO2   
4  14376             69           PM2.5              PM2.5   
5  16765              5              O3                 O3   
6   3434              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2003-08-01 00:00:00        501  
1   pył zawieszony PM10          None  2003-08-01 00:00:00        501  
2                benzen          None  2003-08-01 00:00:00        501  
3       dwutlenek azotu          None  2003-08-01 00:00:00        501  
4  pył zawieszony PM2.5          None  2014-01-01 00:00:00        501  
5                  ozon          None  2016-01-01 00:00:00        501  
6      dwutlenek siarki          None  2003-08-01 00:00:00        501  
--------------------------
497
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  3409              8              CO                 CO      tlenek węgla   
1  3407             10            C6H6               C6H6            benzen   
2  3412              6             NO2                NO2   dwutlenek azotu   
3  3414              5              O3                 O3              ozon   
4  3418              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  1993-01-01 00:00:00        497  
1          None  2001-01-01 00:00:00        497  
2          None  1993-01-01 00:00:00        497  
3          None  2010-01-01 00:00:00        497  
4          None  1993-01-01 00:00:00        497  
--------------------------
437
     id  param.idParam param.paramCode param.paramFormula  \
0  3023              3            PM10               PM10   
1  3020              6             NO2                NO2   
2  3026              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2003-12-31 00:00:00        437  
1      dwutlenek azotu          None  2003-12-31 00:00:00        437  
2     dwutlenek siarki          None  2003-12-31 00:00:00        437  
--------------------------
725
      id  param.idParam param.paramCode param.paramFormula  \
0   4632              8              CO                 CO   
1  16071              3            PM10               PM10   
2   4629             10            C6H6               C6H6   
3   4638              6             NO2                NO2   
4   4640              5              O3                 O3   
5   4649              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2004-06-01 00:00:00        725  
1  pył zawieszony PM10          None  2016-01-01 00:00:00        725  
2               benzen          None  2004-06-01 00:00:00        725  
3      dwutlenek azotu          None  2004-06-01 00:00:00        725  
4                 ozon          None  2004-06-01 00:00:00        725  
5     dwutlenek siarki          None  2004-06-01 00:00:00        725  
--------------------------
736
     id  param.idParam param.paramCode param.paramFormula  \
0  4755              8              CO                 CO   
1  4761              3            PM10               PM10   
2  4758              6             NO2                NO2   
3  4762             69           PM2.5              PM2.5   
4  4760              5              O3                 O3   
5  4764              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  1998-10-01 00:00:00        736  
1   pył zawieszony PM10          None  1998-10-01 00:00:00        736  
2       dwutlenek azotu          None  1998-10-01 00:00:00        736  
3  pył zawieszony PM2.5          None  2010-01-01 00:00:00        736  
4                  ozon          None  2005-01-25 00:00:00        736  
5      dwutlenek siarki          None  1998-10-01 00:00:00        736  
--------------------------
733
     id  param.idParam param.paramCode param.paramFormula  \
0  4720              8              CO                 CO   
1  4727              3            PM10               PM10   
2  4723              6             NO2                NO2   
3  4725              5              O3                 O3   
4  4730              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  1998-05-01 00:00:00        733  
1  pył zawieszony PM10          None  1998-05-01 00:00:00        733  
2      dwutlenek azotu          None  1998-05-01 00:00:00        733  
3                 ozon          None  1998-05-01 00:00:00        733  
4     dwutlenek siarki          None  1998-05-01 00:00:00        733  
--------------------------
732
     id  param.idParam param.paramCode param.paramFormula  \
0  4709              8              CO                 CO   
1  4715              3            PM10               PM10   
2  4712              6             NO2                NO2   
3  4714              5              O3                 O3   
4  4717              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  1997-03-01 00:00:00        732  
1  pył zawieszony PM10          None  1997-03-01 00:00:00        732  
2      dwutlenek azotu          None  1997-03-01 00:00:00        732  
3                 ozon          None  1997-03-01 00:00:00        732  
4     dwutlenek siarki          None  1997-03-01 00:00:00        732  
--------------------------
870
     id  param.idParam param.paramCode param.paramFormula  \
0  5716              8              CO                 CO   
1  5721              3            PM10               PM10   
2  5718              6             NO2                NO2   
3  5720              5              O3                 O3   
4  5722              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-06-19 00:00:00        870  
1  pył zawieszony PM10          None  2005-06-07 00:00:00        870  
2      dwutlenek azotu          None  2005-06-07 00:00:00        870  
3                 ozon          None  2005-06-07 00:00:00        870  
4     dwutlenek siarki          None  2005-06-19 00:00:00        870  
--------------------------
361
     id  param.idParam param.paramCode param.paramFormula  \
0  2411              8              CO                 CO   
1  2421              3            PM10               PM10   
2  2410             10            C6H6               C6H6   
3  2416              6             NO2                NO2   
4  2418              5              O3                 O3   
5  2425              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        361  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        361  
2               benzen          None  2006-01-01 00:00:00        361  
3      dwutlenek azotu          None  2005-01-01 00:00:00        361  
4                 ozon          None  2005-01-01 00:00:00        361  
5     dwutlenek siarki          None  2005-01-01 00:00:00        361  
--------------------------
109
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  608              8              CO                 CO         tlenek węgla   
1  618              3            PM10               PM10  pył zawieszony PM10   
2  605             10            C6H6               C6H6               benzen   
3  614              6             NO2                NO2      dwutlenek azotu   
4  616              5              O3                 O3                 ozon   
5  621              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2005-01-01 00:00:00        109  
1          None  2005-03-20 00:00:00        109  
2          None  2005-01-01 00:00:00        109  
3          None  2005-01-01 00:00:00        109  
4          None  2005-01-01 00:00:00        109  
5          None  2005-01-01 00:00:00        109  
--------------------------
9202
      id  param.idParam param.paramCode param.paramFormula  \
0  14866              8              CO                 CO   
1  14868              3            PM10               PM10   
2  14852              6             NO2                NO2   
3  14855              5              O3                 O3   
4  14854              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2015-01-01 00:00:00       9202  
1  pył zawieszony PM10          None  2015-01-01 00:00:00       9202  
2      dwutlenek azotu          None  2015-01-01 00:00:00       9202  
3                 ozon          None  2015-01-01 00:00:00       9202  
4     dwutlenek siarki          None  2015-01-01 00:00:00       9202  
--------------------------
459
     id  param.idParam param.paramCode param.paramFormula  \
0  3188              8              CO                 CO   
1  3195              3            PM10               PM10   
2  3191              6             NO2                NO2   
3  3193              5              O3                 O3   
4  3198              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2003-12-31 00:00:00        459  
1  pył zawieszony PM10          None  2004-08-20 00:00:00        459  
2      dwutlenek azotu          None  2003-12-31 00:00:00        459  
3                 ozon          None  2004-01-01 00:00:00        459  
4     dwutlenek siarki          None  2003-12-31 00:00:00        459  
--------------------------
600
     id  param.idParam param.paramCode param.paramFormula  \
0  3970              3            PM10               PM10   
1  3964             10            C6H6               C6H6   
2  3968              6             NO2                NO2   
3  3972              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2005-01-01 00:00:00        600  
1               benzen          None  2005-01-01 00:00:00        600  
2      dwutlenek azotu          None  2005-01-01 00:00:00        600  
3     dwutlenek siarki          None  2005-01-01 00:00:00        600  
--------------------------
382
      id  param.idParam param.paramCode param.paramFormula  \
0   2589              8              CO                 CO   
1  14618              3            PM10               PM10   
2   2594              6             NO2                NO2   
3   2596              5              O3                 O3   
4   2601              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2012-09-01 00:00:00        382  
1  pył zawieszony PM10          None  2014-07-01 00:00:00        382  
2      dwutlenek azotu          None  2012-09-01 00:00:00        382  
3                 ozon          None  2012-09-01 00:00:00        382  
4     dwutlenek siarki          None  2012-09-01 00:00:00        382  
--------------------------
400
      id  param.idParam param.paramCode param.paramFormula  \
0   2745              8              CO                 CO   
1   2750              3            PM10               PM10   
2  16500             10            C6H6               C6H6   
3   2747              6             NO2                NO2   
4   2752             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2003-12-31 00:00:00        400  
1   pył zawieszony PM10          None  2004-08-20 00:00:00        400  
2                benzen          None  2016-01-01 00:00:00        400  
3       dwutlenek azotu          None  2003-12-31 00:00:00        400  
4  pył zawieszony PM2.5          None  2009-08-01 00:00:00        400  
--------------------------
9233
      id  param.idParam param.paramCode param.paramFormula  \
0  15013              8              CO                 CO   
1  15015              3            PM10               PM10   
2  15014              6             NO2                NO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2014-01-01 00:00:00       9233  
1  pył zawieszony PM10          None  2014-01-01 00:00:00       9233  
2      dwutlenek azotu          None  2014-01-01 00:00:00       9233  
--------------------------
590
      id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  16160              6             NO2                NO2   dwutlenek azotu   
1  16158              5              O3                 O3              ozon   
2  16149              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2016-01-01 00:00:00        590  
1          None  2016-01-01 00:00:00        590  
2          None  2016-01-01 00:00:00        590  
--------------------------
10030
      id  param.idParam param.paramCode param.paramFormula  \
0  16174              8              CO                 CO   
1  16178              3            PM10               PM10   
2  16181              6             NO2                NO2   
3  16180              5              O3                 O3   
4  16177              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2017-01-01 00:00:00      10030  
1  pył zawieszony PM10          None  2017-01-01 00:00:00      10030  
2      dwutlenek azotu          None  2017-01-01 00:00:00      10030  
3                 ozon          None  2017-01-01 00:00:00      10030  
4     dwutlenek siarki          None  2017-01-01 00:00:00      10030  
--------------------------
331
      id  param.idParam param.paramCode param.paramFormula  \
0  16642              8              CO                 CO   
1  16630              3            PM10               PM10   
2  16638              6             NO2                NO2   
3  17716              5              O3                 O3   
4  16633              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2015-02-26 00:00:00        331  
1  pył zawieszony PM10          None  2015-02-26 00:00:00        331  
2      dwutlenek azotu          None  2015-02-26 00:00:00        331  
3                 ozon          None  2016-01-01 00:00:00        331  
4     dwutlenek siarki          None  2015-02-26 00:00:00        331  
--------------------------
834
     id  param.idParam param.paramCode param.paramFormula  \
0  5457              8              CO                 CO   
1  5466              3            PM10               PM10   
2  5454             10            C6H6               C6H6   
3  5461              6             NO2                NO2   
4  5463              5              O3                 O3   
5  5470              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        834  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        834  
2               benzen          None  2011-06-01 00:00:00        834  
3      dwutlenek azotu          None  2005-01-01 00:00:00        834  
4                 ozon          None  2007-01-01 00:00:00        834  
5     dwutlenek siarki          None  2005-01-01 00:00:00        834  
--------------------------
10414
      id  param.idParam param.paramCode param.paramFormula  \
0  17184              3            PM10               PM10   
1  17185             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2017-01-01 00:00:00      10414  
1  pył zawieszony PM2.5          None  2017-01-01 00:00:00      10414  
--------------------------
789
     id  param.idParam param.paramCode param.paramFormula  \
0  5158              8              CO                 CO   
1  5167              3            PM10               PM10   
2  5162              6             NO2                NO2   
3  5164              5              O3                 O3   
4  5171              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        789  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        789  
2      dwutlenek azotu          None  2005-01-01 00:00:00        789  
3                 ozon          None  2005-01-01 00:00:00        789  
4     dwutlenek siarki          None  2005-01-01 00:00:00        789  
--------------------------
795
     id  param.idParam param.paramCode param.paramFormula  \
0  5205              8              CO                 CO   
1  5212              3            PM10               PM10   
2  5208              6             NO2                NO2   
3  5210              5              O3                 O3   
4  5216              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        795  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        795  
2      dwutlenek azotu          None  2005-01-01 00:00:00        795  
3                 ozon          None  2011-01-01 00:00:00        795  
4     dwutlenek siarki          None  2005-01-01 00:00:00        795  
--------------------------
206
     id  param.idParam param.paramCode param.paramFormula  \
0  1405              3            PM10               PM10   
1  1407             69           PM2.5              PM2.5   
2  1403              5              O3                 O3   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2012-01-01 00:00:00        206  
1  pył zawieszony PM2.5          None  2009-06-03 00:00:00        206  
2                  ozon          None  2009-04-09 00:00:00        206  
--------------------------
530
     id  param.idParam param.paramCode param.paramFormula  \
0  3576              8              CO                 CO   
1  3584              3            PM10               PM10   
2  3575             10            C6H6               C6H6   
3  3580              6             NO2                NO2   
4  3585             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2003-08-01 00:00:00        530  
1   pył zawieszony PM10          None  2003-08-01 00:00:00        530  
2                benzen          None  2003-08-01 00:00:00        530  
3       dwutlenek azotu          None  2003-08-01 00:00:00        530  
4  pył zawieszony PM2.5          None  2009-12-01 00:00:00        530  
--------------------------
282
     id  param.idParam param.paramCode param.paramFormula param.paramName  \
0  1983              5              O3                 O3            ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2006-09-01 00:00:00        282  
--------------------------
902
     id  param.idParam param.paramCode param.paramFormula  \
0  5895              8              CO                 CO   
1  5904              3            PM10               PM10   
2  5899              6             NO2                NO2   
3  5902              5              O3                 O3   
4  5906              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2004-01-01 00:00:00        902  
1  pył zawieszony PM10          None  2004-01-01 00:00:00        902  
2      dwutlenek azotu          None  2004-01-01 00:00:00        902  
3                 ozon          None  2004-01-01 00:00:00        902  
4     dwutlenek siarki          None  2004-01-01 00:00:00        902  
--------------------------
740
      id  param.idParam param.paramCode param.paramFormula  \
0   4806              8              CO                 CO   
1   4817              3            PM10               PM10   
2  16057             10            C6H6               C6H6   
3   4812              6             NO2                NO2   
4   4819             69           PM2.5              PM2.5   
5   4814              5              O3                 O3   
6   4822              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2012-01-01 00:00:00        740  
1   pył zawieszony PM10          None  2012-01-01 00:00:00        740  
2                benzen          None  2016-01-01 00:00:00        740  
3       dwutlenek azotu          None  2012-01-01 00:00:00        740  
4  pył zawieszony PM2.5          None  2012-01-01 00:00:00        740  
5                  ozon          None  2012-01-01 00:00:00        740  
6      dwutlenek siarki          None  2012-01-01 00:00:00        740  
--------------------------
402
     id  param.idParam param.paramCode param.paramFormula  \
0  2783              8              CO                 CO   
1  2792              3            PM10               PM10   
2  2779             10            C6H6               C6H6   
3  2788              6             NO2                NO2   
4  2794             69           PM2.5              PM2.5   
5  2797              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2004-08-20 00:00:00        402  
1   pył zawieszony PM10          None  2009-07-20 00:00:00        402  
2                benzen          None  2005-01-01 00:00:00        402  
3       dwutlenek azotu          None  2003-08-20 00:00:00        402  
4  pył zawieszony PM2.5          None  2004-08-20 00:00:00        402  
5      dwutlenek siarki          None  2004-08-20 00:00:00        402  
--------------------------
10034
      id  param.idParam param.paramCode param.paramFormula  \
0  16383              8              CO                 CO   
1  16376              3            PM10               PM10   
2  16385              6             NO2                NO2   
3  16382              5              O3                 O3   
4  16380              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2017-01-01 00:00:00      10034  
1  pył zawieszony PM10          None  2017-01-01 00:00:00      10034  
2      dwutlenek azotu          None  2017-01-01 00:00:00      10034  
3                 ozon          None  2017-01-01 00:00:00      10034  
4     dwutlenek siarki          None  2017-01-01 00:00:00      10034  
--------------------------
429
     id  param.idParam param.paramCode param.paramFormula  \
0  2976              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2004-08-20 00:00:00        429  
--------------------------
943
     id  param.idParam param.paramCode param.paramFormula  \
0  6062              8              CO                 CO   
1  6067              3            PM10               PM10   
2  6065              6             NO2                NO2   
3  6068             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2005-01-01 00:00:00        943  
1   pył zawieszony PM10          None  2005-01-01 00:00:00        943  
2       dwutlenek azotu          None  2005-01-01 00:00:00        943  
3  pył zawieszony PM2.5          None  2008-01-01 00:00:00        943  
--------------------------
9179
      id  param.idParam param.paramCode param.paramFormula  param.paramName  \
0  14804              6             NO2                NO2  dwutlenek azotu   
1  14826              5              O3                 O3             ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2015-05-04 00:00:00       9179  
1          None  2015-05-04 00:00:00       9179  
--------------------------
983
     id  param.idParam param.paramCode param.paramFormula  \
0  6322              3            PM10               PM10   
1  6320              6             NO2                NO2   
2  6324              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2011-01-01 00:00:00        983  
1      dwutlenek azotu          None  2011-01-01 00:00:00        983  
2     dwutlenek siarki          None  2011-01-01 00:00:00        983  
--------------------------
950
      id  param.idParam param.paramCode param.paramFormula  \
0  14892              3            PM10               PM10   
1  16526             10            C6H6               C6H6   
2   6140              6             NO2                NO2   
3   6142              5              O3                 O3   
4   6144              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2014-11-01 00:00:00        950  
1               benzen          None  2016-01-01 00:00:00        950  
2      dwutlenek azotu          None  2011-01-01 00:00:00        950  
3                 ozon          None  2011-01-01 00:00:00        950  
4     dwutlenek siarki          None  2011-01-01 00:00:00        950  
--------------------------
805
     id  param.idParam param.paramCode param.paramFormula  \
0  5277              8              CO                 CO   
1  5286              3            PM10               PM10   
2  5274             10            C6H6               C6H6   
3  5281              6             NO2                NO2   
4  5283              5              O3                 O3   
5  5290              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        805  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        805  
2               benzen          None  2005-01-01 00:00:00        805  
3      dwutlenek azotu          None  2005-01-01 00:00:00        805  
4                 ozon          None  2005-01-01 00:00:00        805  
5     dwutlenek siarki          None  2005-01-01 00:00:00        805  
--------------------------
738
     id  param.idParam param.paramCode param.paramFormula  \
0  4774              3            PM10               PM10   
1  4769              6             NO2                NO2   
2  4772              5              O3                 O3   
3  4777              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2009-12-01 00:00:00        738  
1      dwutlenek azotu          None  2009-12-01 00:00:00        738  
2                 ozon          None  2009-12-01 00:00:00        738  
3     dwutlenek siarki          None  2009-12-01 00:00:00        738  
--------------------------
466
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  3229              6             NO2                NO2   dwutlenek azotu   
1  3231              5              O3                 O3              ozon   
2  3237              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2003-08-01 00:00:00        466  
1          None  2003-08-01 00:00:00        466  
2          None  2003-08-01 00:00:00        466  
--------------------------
143
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  828              3            PM10               PM10  pył zawieszony PM10   
1  824              6             NO2                NO2      dwutlenek azotu   
2  831              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2012-02-20 00:00:00        143  
1          None  2012-02-20 00:00:00        143  
2          None  2012-02-20 00:00:00        143  
--------------------------
444
     id  param.idParam param.paramCode param.paramFormula  \
0  3070              3            PM10               PM10   
1  3066              6             NO2                NO2   
2  3068              5              O3                 O3   
3  3073              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2010-01-01 00:00:00        444  
1      dwutlenek azotu          None  2010-01-01 00:00:00        444  
2                 ozon          None  2011-07-01 00:00:00        444  
3     dwutlenek siarki          None  2010-01-01 00:00:00        444  
--------------------------
552
      id  param.idParam param.paramCode param.paramFormula  \
0   3764              3            PM10               PM10   
1   3760              6             NO2                NO2   
2  14688             69           PM2.5              PM2.5   
3   3762              5              O3                 O3   
4   3769              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2003-08-01 00:00:00        552  
1       dwutlenek azotu          None  2003-08-01 00:00:00        552  
2  pył zawieszony PM2.5          None  2015-01-01 00:00:00        552  
3                  ozon          None  2010-01-01 00:00:00        552  
4      dwutlenek siarki          None  2003-08-01 00:00:00        552  
--------------------------
129
    id  param.idParam param.paramCode param.paramFormula  \
0  737              8              CO                 CO   
1  740              6             NO2                NO2   
2  744             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2005-01-01 00:00:00        129  
1       dwutlenek azotu          None  2005-01-01 00:00:00        129  
2  pył zawieszony PM2.5          None  2011-01-01 00:00:00        129  
--------------------------
114
    id  param.idParam param.paramCode param.paramFormula  param.paramName  \
0  642              6             NO2                NO2  dwutlenek azotu   
1  644              5              O3                 O3             ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2005-01-01 00:00:00        114  
1          None  2005-01-01 00:00:00        114  
--------------------------
132
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  759              3            PM10               PM10  pył zawieszony PM10   
1  757              6             NO2                NO2      dwutlenek azotu   
2  760              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2008-09-01 00:00:00        132  
1          None  2008-09-01 00:00:00        132  
2          None  2008-09-01 00:00:00        132  
--------------------------
355
     id  param.idParam param.paramCode param.paramFormula  \
0  2370              8              CO                 CO   
1  2377              3            PM10               PM10   
2  2373              6             NO2                NO2   
3  2378             69           PM2.5              PM2.5   
4  2382              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2003-09-01 00:00:00        355  
1   pył zawieszony PM10          None  2003-09-01 00:00:00        355  
2       dwutlenek azotu          None  2003-09-01 00:00:00        355  
3  pył zawieszony PM2.5          None  2009-01-01 00:00:00        355  
4      dwutlenek siarki          None  2003-09-01 00:00:00        355  
--------------------------
134
      id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0    771              8              CO                 CO      tlenek węgla   
1  14735             10            C6H6               C6H6            benzen   
2    776              6             NO2                NO2   dwutlenek azotu   
3    782              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2007-01-01 00:00:00        134  
1          None  2014-10-17 00:00:00        134  
2          None  2005-01-01 00:00:00        134  
3          None  2005-01-01 00:00:00        134  
--------------------------
952
      id  param.idParam param.paramCode param.paramFormula  \
0  14891              8              CO                 CO   
1  14972              3            PM10               PM10   
2   6161              6             NO2                NO2   
3   6165             69           PM2.5              PM2.5   
4  14890              5              O3                 O3   
5   6168              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2014-11-01 00:00:00        952  
1   pył zawieszony PM10          None  2014-11-01 00:00:00        952  
2       dwutlenek azotu          None  2010-01-01 00:00:00        952  
3  pył zawieszony PM2.5          None  2010-01-01 00:00:00        952  
4                  ozon          None  2014-11-01 00:00:00        952  
5      dwutlenek siarki          None  2010-01-01 00:00:00        952  
--------------------------
38
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  224              3            PM10               PM10  pył zawieszony PM10   
1  221              6             NO2                NO2      dwutlenek azotu   
2  223              5              O3                 O3                 ozon   
3  225              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2009-06-05 00:00:00         38  
1          None  2009-06-05 00:00:00         38  
2          None  2009-06-05 00:00:00         38  
3          None  2009-06-05 00:00:00         38  
--------------------------
10435
      id  param.idParam param.paramCode param.paramFormula  \
0  17243              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2017-01-01 00:00:00      10435  
--------------------------
743
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  4885              8              CO                 CO      tlenek węgla   
1  4891              6             NO2                NO2   dwutlenek azotu   
2  4893              5              O3                 O3              ozon   
3  4898              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2012-01-01 00:00:00        743  
1          None  2012-01-01 00:00:00        743  
2          None  2012-01-01 00:00:00        743  
3          None  2012-01-01 00:00:00        743  
--------------------------
618
     id  param.idParam param.paramCode param.paramFormula  \
0  4079              3            PM10               PM10   
1  4075              6             NO2                NO2   
2  4082              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2004-05-20 00:00:00        618  
1      dwutlenek azotu          None  2005-06-01 00:00:00        618  
2     dwutlenek siarki          None  2005-06-01 00:00:00        618  
--------------------------
295
     id  param.idParam param.paramCode param.paramFormula  \
0  2060              8              CO                 CO   
1  2069              3            PM10               PM10   
2  2064              6             NO2                NO2   
3  2071             69           PM2.5              PM2.5   
4  2066              5              O3                 O3   
5  2076              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2003-11-01 00:00:00        295  
1   pył zawieszony PM10          None  2003-11-01 00:00:00        295  
2       dwutlenek azotu          None  2003-11-01 00:00:00        295  
3  pył zawieszony PM2.5          None  2009-06-12 00:00:00        295  
4                  ozon          None  2003-11-01 00:00:00        295  
5      dwutlenek siarki          None  2003-11-01 00:00:00        295  
--------------------------
74
    id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  441              6             NO2                NO2   dwutlenek azotu   
1  444              5              O3                 O3              ozon   
2  450              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2010-01-01 00:00:00         74  
1          None  2010-01-01 00:00:00         74  
2          None  2010-01-01 00:00:00         74  
--------------------------
778
     id  param.idParam param.paramCode param.paramFormula  \
0  5109              8              CO                 CO   
1  5115              3            PM10               PM10   
2  5112              6             NO2                NO2   
3  5116             69           PM2.5              PM2.5   
4  5114              5              O3                 O3   
5  5118              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2012-01-01 00:00:00        778  
1   pył zawieszony PM10          None  2012-01-01 00:00:00        778  
2       dwutlenek azotu          None  2012-01-01 00:00:00        778  
3  pył zawieszony PM2.5          None  2012-01-01 00:00:00        778  
4                  ozon          None  2012-01-01 00:00:00        778  
5      dwutlenek siarki          None  2012-01-01 00:00:00        778  
--------------------------
944
     id  param.idParam param.paramCode param.paramFormula  \
0  6076              8              CO                 CO   
1  6085              3            PM10               PM10   
2  6074             10            C6H6               C6H6   
3  6081              6             NO2                NO2   
4  6083              5              O3                 O3   
5  6087              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        944  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        944  
2               benzen          None  2005-01-01 00:00:00        944  
3      dwutlenek azotu          None  2005-01-01 00:00:00        944  
4                 ozon          None  2005-01-01 00:00:00        944  
5     dwutlenek siarki          None  2005-01-01 00:00:00        944  
--------------------------
9593
      id  param.idParam param.paramCode param.paramFormula  param.paramName  \
0  15688              6             NO2                NO2  dwutlenek azotu   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2015-06-01 00:00:00       9593  
--------------------------
987
     id  param.idParam param.paramCode param.paramFormula  \
0  6362              8              CO                 CO   
1  6360             10            C6H6               C6H6   
2  6379              6             NO2                NO2   
3  6383             69           PM2.5              PM2.5   
4  6385              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2004-12-31 00:00:00        987  
1                benzen          None  2004-12-31 00:00:00        987  
2       dwutlenek azotu          None  2004-12-31 00:00:00        987  
3  pył zawieszony PM2.5          None  2006-03-14 00:00:00        987  
4      dwutlenek siarki          None  2004-12-31 00:00:00        987  
--------------------------
989
     id  param.idParam param.paramCode param.paramFormula  \
0  6396              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2004-12-31 00:00:00        989  
--------------------------
609
     id  param.idParam param.paramCode param.paramFormula  \
0  4024              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2011-01-01 00:00:00        609  
--------------------------
158
    id  param.idParam param.paramCode param.paramFormula  \
0  987              8              CO                 CO   
1  995              3            PM10               PM10   
2  991              6             NO2                NO2   
3  996             69           PM2.5              PM2.5   
4  993              5              O3                 O3   
5  998              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  1995-01-21 00:00:00        158  
1   pył zawieszony PM10          None  1995-01-21 00:00:00        158  
2       dwutlenek azotu          None  1995-01-21 00:00:00        158  
3  pył zawieszony PM2.5          None  2007-02-01 00:00:00        158  
4                  ozon          None  1995-01-21 00:00:00        158  
5      dwutlenek siarki          None  1995-01-21 00:00:00        158  
--------------------------
164
     id  param.idParam param.paramCode param.paramFormula  param.paramName  \
0  1048             10            C6H6               C6H6           benzen   
1  1061              6             NO2                NO2  dwutlenek azotu   
2  1063              5              O3                 O3             ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2011-01-01 00:00:00        164  
1          None  2007-03-01 00:00:00        164  
2          None  2007-03-01 00:00:00        164  
--------------------------
11
   id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  50              6             NO2                NO2   dwutlenek azotu   
1  52              5              O3                 O3              ozon   
2  56              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  1996-07-01 00:00:00         11  
1          None  1996-07-01 00:00:00         11  
2          None  1996-07-01 00:00:00         11  
--------------------------
14
   id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  92              3            PM10               PM10  pył zawieszony PM10   
1  88              6             NO2                NO2      dwutlenek azotu   
2  94              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  1996-07-11 00:00:00         14  
1          None  1996-07-01 00:00:00         14  
2          None  1996-07-01 00:00:00         14  
--------------------------
10005
      id  param.idParam param.paramCode param.paramFormula  \
0  16173              3            PM10               PM10   
1  16216              6             NO2                NO2   
2  16171              5              O3                 O3   
3  16214              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2017-01-01 00:00:00      10005  
1      dwutlenek azotu          None  2017-01-01 00:00:00      10005  
2                 ozon          None  2017-01-01 00:00:00      10005  
3     dwutlenek siarki          None  2017-01-01 00:00:00      10005  
--------------------------
531
     id  param.idParam param.paramCode param.paramFormula param.paramName  \
0  3591              5              O3                 O3            ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2003-09-30 00:00:00        531  
--------------------------
550
     id  param.idParam param.paramCode param.paramFormula  \
0  3730              3            PM10               PM10   
1  3725              6             NO2                NO2   
2  3731             69           PM2.5              PM2.5   
3  3727              5              O3                 O3   
4  3736              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2003-08-01 00:00:00        550  
1       dwutlenek azotu          None  2003-08-01 00:00:00        550  
2  pył zawieszony PM2.5          None  2009-05-01 00:00:00        550  
3                  ozon          None  2003-08-01 00:00:00        550  
4      dwutlenek siarki          None  2003-08-01 00:00:00        550  
--------------------------
562
      id  param.idParam param.paramCode param.paramFormula  \
0   3802              3            PM10               PM10   
1  14379             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2003-08-01 00:00:00        562  
1  pył zawieszony PM2.5          None  2014-01-01 00:00:00        562  
--------------------------
814
     id  param.idParam param.paramCode param.paramFormula  \
0  5376              3            PM10               PM10   
1  5371              6             NO2                NO2   
2  5378             69           PM2.5              PM2.5   
3  5373              5              O3                 O3   
4  5382              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2003-01-01 00:00:00        814  
1       dwutlenek azotu          None  1992-01-01 00:00:00        814  
2  pył zawieszony PM2.5          None  2009-01-01 00:00:00        814  
3                  ozon          None  1997-01-13 00:00:00        814  
4      dwutlenek siarki          None  1992-01-01 00:00:00        814  
--------------------------
966
     id  param.idParam param.paramCode param.paramFormula  \
0  6238              3            PM10               PM10   
1  6236              6             NO2                NO2   
2  6240              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2006-10-05 00:00:00        966  
1      dwutlenek azotu          None  2006-10-05 00:00:00        966  
2     dwutlenek siarki          None  2006-10-05 00:00:00        966  
--------------------------
10447
      id  param.idParam param.paramCode param.paramFormula  \
0  17309              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2017-01-01 00:00:00      10447  
--------------------------
471
      id  param.idParam param.paramCode param.paramFormula  \
0   3257              6             NO2                NO2   
1  14378             69           PM2.5              PM2.5   
2   3259              5              O3                 O3   
3   3265              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0       dwutlenek azotu          None  2003-08-01 00:00:00        471  
1  pył zawieszony PM2.5          None  2014-01-01 00:00:00        471  
2                  ozon          None  2003-08-01 00:00:00        471  
3      dwutlenek siarki          None  2003-08-01 00:00:00        471  
--------------------------
296
      id  param.idParam param.paramCode param.paramFormula  \
0   2080              8              CO                 CO   
1   2087              3            PM10               PM10   
2   2079             10            C6H6               C6H6   
3   2083              6             NO2                NO2   
4  16805             69           PM2.5              PM2.5   
5   2085              5              O3                 O3   
6   2088              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2012-01-01 00:00:00        296  
1   pył zawieszony PM10          None  2012-01-01 00:00:00        296  
2                benzen          None  2012-01-01 00:00:00        296  
3       dwutlenek azotu          None  2012-01-01 00:00:00        296  
4  pył zawieszony PM2.5          None  2015-01-29 00:00:00        296  
5                  ozon          None  2012-01-01 00:00:00        296  
6      dwutlenek siarki          None  2012-01-01 00:00:00        296  
--------------------------
10438
      id  param.idParam param.paramCode param.paramFormula  \
0  17271              3            PM10               PM10   
1  17270             10            C6H6               C6H6   
2  17266              6             NO2                NO2   
3  17272             69           PM2.5              PM2.5   
4  17269              5              O3                 O3   
5  17265              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2017-01-01 00:00:00      10438  
1                benzen          None  2017-01-01 00:00:00      10438  
2       dwutlenek azotu          None  2017-01-01 00:00:00      10438  
3  pył zawieszony PM2.5          None  2017-01-01 00:00:00      10438  
4                  ozon          None  2017-01-01 00:00:00      10438  
5      dwutlenek siarki          None  2017-01-01 00:00:00      10438  
--------------------------
659
      id  param.idParam param.paramCode param.paramFormula  \
0   4274              8              CO                 CO   
1  14416              3            PM10               PM10   
2   4278              6             NO2                NO2   
3  14448              5              O3                 O3   
4   4285              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2006-07-01 00:00:00        659  
1  pył zawieszony PM10          None  2014-04-01 00:00:00        659  
2      dwutlenek azotu          None  2006-07-01 00:00:00        659  
3                 ozon          None  2014-04-04 00:00:00        659  
4     dwutlenek siarki          None  2006-07-01 00:00:00        659  
--------------------------
426
     id  param.idParam param.paramCode param.paramFormula  \
0  2941              3            PM10               PM10   
1  2938              6             NO2                NO2   
2  2944              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2010-09-01 00:00:00        426  
1      dwutlenek azotu          None  2010-09-01 00:00:00        426  
2     dwutlenek siarki          None  2010-09-01 00:00:00        426  
--------------------------
584
      id  param.idParam param.paramCode param.paramFormula  \
0   3902              3            PM10               PM10   
1  14781              5              O3                 O3   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2011-11-01 00:00:00        584  
1                 ozon          None  2014-04-06 00:00:00        584  
--------------------------
485
      id  param.idParam param.paramCode param.paramFormula  \
0  16046              8              CO                 CO   
1  17225              3            PM10               PM10   
2  16048              6             NO2                NO2   
3  16044             69           PM2.5              PM2.5   
4  16050              5              O3                 O3   
5  16051              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2016-01-01 00:00:00        485  
1   pył zawieszony PM10          None  2017-01-01 00:00:00        485  
2       dwutlenek azotu          None  2016-01-01 00:00:00        485  
3  pył zawieszony PM2.5          None  2016-01-01 00:00:00        485  
4                  ozon          None  2016-01-01 00:00:00        485  
5      dwutlenek siarki          None  2016-01-01 00:00:00        485  
--------------------------
748
     id  param.idParam param.paramCode param.paramFormula  \
0  4947              8              CO                 CO   
1  4950              3            PM10               PM10   
2  4946             10            C6H6               C6H6   
3  4948              6             NO2                NO2   
4  4952              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2007-02-01 00:00:00        748  
1  pył zawieszony PM10          None  2007-02-01 00:00:00        748  
2               benzen          None  2007-02-01 00:00:00        748  
3      dwutlenek azotu          None  2007-02-01 00:00:00        748  
4     dwutlenek siarki          None  2007-02-01 00:00:00        748  
--------------------------
443
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  3055              6             NO2                NO2   dwutlenek azotu   
1  3057              5              O3                 O3              ozon   
2  3058              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2004-11-01 00:00:00        443  
1          None  2004-11-01 00:00:00        443  
2          None  2004-11-01 00:00:00        443  
--------------------------
730
     id  param.idParam param.paramCode param.paramFormula  \
0  4695              3            PM10               PM10   
1  4686             10            C6H6               C6H6   
2  4691              6             NO2                NO2   
3  4697              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  1996-10-01 00:00:00        730  
1               benzen          None  2010-10-01 00:00:00        730  
2      dwutlenek azotu          None  1996-10-01 00:00:00        730  
3     dwutlenek siarki          None  1996-10-01 00:00:00        730  
--------------------------
449
      id  param.idParam param.paramCode param.paramFormula  \
0   3116              8              CO                 CO   
1   3123              3            PM10               PM10   
2  16707             10            C6H6               C6H6   
3   3120              6             NO2                NO2   
4  15246              5              O3                 O3   
5   3127              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2010-09-01 00:00:00        449  
1  pył zawieszony PM10          None  2010-09-01 00:00:00        449  
2               benzen          None  2017-01-01 00:00:00        449  
3      dwutlenek azotu          None  2010-09-01 00:00:00        449  
4                 ozon          None  2014-01-01 00:00:00        449  
5     dwutlenek siarki          None  2010-09-01 00:00:00        449  
--------------------------
841
     id  param.idParam param.paramCode param.paramFormula  \
0  5505              3            PM10               PM10   
1  5501              6             NO2                NO2   
2  5508              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2005-01-01 00:00:00        841  
1      dwutlenek azotu          None  2005-01-01 00:00:00        841  
2     dwutlenek siarki          None  2005-01-01 00:00:00        841  
--------------------------
225
     id  param.idParam param.paramCode param.paramFormula  \
0  1534              8              CO                 CO   
1  1544              3            PM10               PM10   
2  1539              6             NO2                NO2   
3  1548              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        225  
1  pył zawieszony PM10          None  2005-03-01 00:00:00        225  
2      dwutlenek azotu          None  2005-01-01 00:00:00        225  
3     dwutlenek siarki          None  2005-01-01 00:00:00        225  
--------------------------
845
     id  param.idParam param.paramCode param.paramFormula  \
0  5540              8              CO                 CO   
1  5547              3            PM10               PM10   
2  5543              6             NO2                NO2   
3  5545              5              O3                 O3   
4  5550              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        845  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        845  
2      dwutlenek azotu          None  2005-01-01 00:00:00        845  
3                 ozon          None  2005-01-01 00:00:00        845  
4     dwutlenek siarki          None  2005-01-01 00:00:00        845  
--------------------------
387
      id  param.idParam param.paramCode param.paramFormula  \
0   2649              8              CO                 CO   
1  14428              3            PM10               PM10   
2   2647             10            C6H6               C6H6   
3   2657              6             NO2                NO2   
4   2664             69           PM2.5              PM2.5   
5   2659              5              O3                 O3   
6   2668              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2005-01-01 00:00:00        387  
1   pył zawieszony PM10          None  2013-12-01 00:00:00        387  
2                benzen          None  2005-01-01 00:00:00        387  
3       dwutlenek azotu          None  2005-01-01 00:00:00        387  
4  pył zawieszony PM2.5          None  2009-06-01 00:00:00        387  
5                  ozon          None  2005-01-01 00:00:00        387  
6      dwutlenek siarki          None  2005-01-01 00:00:00        387  
--------------------------
853
     id  param.idParam param.paramCode param.paramFormula  \
0  5618              3            PM10               PM10   
1  5600             10            C6H6               C6H6   
2  5612              6             NO2                NO2   
3  5619             69           PM2.5              PM2.5   
4  5615              5              O3                 O3   
5  5623              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2005-01-01 00:00:00        853  
1                benzen          None  2013-01-01 00:00:00        853  
2       dwutlenek azotu          None  2005-01-01 00:00:00        853  
3  pył zawieszony PM2.5          None  2013-01-01 00:00:00        853  
4                  ozon          None  2005-01-01 00:00:00        853  
5      dwutlenek siarki          None  2005-01-01 00:00:00        853  
--------------------------
10554
      id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  17443              8              CO                 CO      tlenek węgla   
1  17439              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2017-01-01 00:00:00      10554  
1          None  2017-01-01 00:00:00      10554  
--------------------------
84
    id  param.idParam param.paramCode param.paramFormula param.paramName  \
0  493              5              O3                 O3            ozon   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2006-01-01 00:00:00         84  
--------------------------
190
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  1283              6             NO2                NO2   dwutlenek azotu   
1  1285              5              O3                 O3              ozon   
2  1289              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2007-09-05 00:00:00        190  
1          None  2011-01-01 00:00:00        190  
2          None  1996-01-01 00:00:00        190  
--------------------------
10434
      id  param.idParam param.paramCode param.paramFormula  \
0  17232              8              CO                 CO   
1  17239              3            PM10               PM10   
2  17230             10            C6H6               C6H6   
3  17235              6             NO2                NO2   
4  17240             69           PM2.5              PM2.5   
5  17237              5              O3                 O3   
6  17241              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2017-01-01 00:00:00      10434  
1   pył zawieszony PM10          None  2017-01-01 00:00:00      10434  
2                benzen          None  2017-01-01 00:00:00      10434  
3       dwutlenek azotu          None  2017-01-01 00:00:00      10434  
4  pył zawieszony PM2.5          None  2017-01-01 00:00:00      10434  
5                  ozon          None  2017-01-01 00:00:00      10434  
6      dwutlenek siarki          None  2017-01-01 00:00:00      10434  
--------------------------
10139
      id  param.idParam param.paramCode param.paramFormula  \
0  16784              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2016-01-01 00:00:00      10139  
--------------------------
401
     id  param.idParam param.paramCode param.paramFormula  \
0  2770              3            PM10               PM10   
1  2766              6             NO2                NO2   
2  2772             69           PM2.5              PM2.5   
3  2768              5              O3                 O3   
4  2774              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2010-01-01 00:00:00        401  
1       dwutlenek azotu          None  2010-01-01 00:00:00        401  
2  pył zawieszony PM2.5          None  2010-01-01 00:00:00        401  
3                  ozon          None  2010-01-01 00:00:00        401  
4      dwutlenek siarki          None  2010-01-01 00:00:00        401  
--------------------------
10374
      id  param.idParam param.paramCode param.paramFormula  \
0  16147              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2017-01-01 00:00:00      10374  
--------------------------
920
      id  param.idParam param.paramCode param.paramFormula  \
0   5973              8              CO                 CO   
1  14893              3            PM10               PM10   
2   5979              6             NO2                NO2   
3   5984              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-04-21 00:00:00        920  
1  pył zawieszony PM10          None  2014-11-01 00:00:00        920  
2      dwutlenek azotu          None  2003-01-01 00:00:00        920  
3     dwutlenek siarki          None  2003-01-01 00:00:00        920  
--------------------------
665
      id  param.idParam param.paramCode param.paramFormula  \
0   4336              3            PM10               PM10   
1  14771             10            C6H6               C6H6   
2   4333              6             NO2                NO2   
3   4338             69           PM2.5              PM2.5   
4  14772              5              O3                 O3   
5   4339              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2013-01-01 00:00:00        665  
1                benzen          None  2014-10-06 00:00:00        665  
2       dwutlenek azotu          None  2013-01-01 00:00:00        665  
3  pył zawieszony PM2.5          None  2013-01-01 00:00:00        665  
4                  ozon          None  2014-10-06 00:00:00        665  
5      dwutlenek siarki          None  2013-01-01 00:00:00        665  
--------------------------
515
      id  param.idParam param.paramCode param.paramFormula  \
0   3487              8              CO                 CO   
1   3497              3            PM10               PM10   
2   3486             10            C6H6               C6H6   
3   3492              6             NO2                NO2   
4  14377             69           PM2.5              PM2.5   
5   3494              5              O3                 O3   
6   3502              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2003-08-01 00:00:00        515  
1   pył zawieszony PM10          None  2003-08-01 00:00:00        515  
2                benzen          None  2003-08-01 00:00:00        515  
3       dwutlenek azotu          None  2003-08-01 00:00:00        515  
4  pył zawieszony PM2.5          None  2014-01-01 00:00:00        515  
5                  ozon          None  2003-08-01 00:00:00        515  
6      dwutlenek siarki          None  2003-08-01 00:00:00        515  
--------------------------
10455
      id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  17254              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2017-01-01 00:00:00      10455  
--------------------------
734
     id  param.idParam param.paramCode param.paramFormula  \
0  4733              8              CO                 CO   
1  4738              3            PM10               PM10   
2  4736              6             NO2                NO2   
3  4741              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  1998-07-01 00:00:00        734  
1  pył zawieszony PM10          None  1998-07-01 00:00:00        734  
2      dwutlenek azotu          None  1998-07-01 00:00:00        734  
3     dwutlenek siarki          None  1998-07-01 00:00:00        734  
--------------------------
837
     id  param.idParam param.paramCode param.paramFormula  \
0  5480              3            PM10               PM10   
1  5478              6             NO2                NO2   
2  5481              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2010-04-01 00:00:00        837  
1      dwutlenek azotu          None  2010-04-01 00:00:00        837  
2     dwutlenek siarki          None  2010-04-01 00:00:00        837  
--------------------------
460
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  3199              8              CO                 CO      tlenek węgla   
1  3201              6             NO2                NO2   dwutlenek azotu   
2  3203              5              O3                 O3              ozon   
3  3205              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  1991-07-01 00:00:00        460  
1          None  1991-07-01 00:00:00        460  
2          None  1991-07-01 00:00:00        460  
3          None  1991-07-01 00:00:00        460  
--------------------------
156
    id  param.idParam param.paramCode param.paramFormula  \
0  952              8              CO                 CO   
1  965              3            PM10               PM10   
2  949             10            C6H6               C6H6   
3  959              6             NO2                NO2   
4  966             69           PM2.5              PM2.5   
5  969              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2006-01-06 00:00:00        156  
1   pył zawieszony PM10          None  2006-01-06 00:00:00        156  
2                benzen          None  2006-01-06 00:00:00        156  
3       dwutlenek azotu          None  2006-01-06 00:00:00        156  
4  pył zawieszony PM2.5          None  2012-06-18 00:00:00        156  
5      dwutlenek siarki          None  2006-01-06 00:00:00        156  
--------------------------
798
     id  param.idParam param.paramCode param.paramFormula  \
0  5228              8              CO                 CO   
1  5232              3            PM10               PM10   
2  5230              6             NO2                NO2   
3  5233              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2010-01-01 00:00:00        798  
1  pył zawieszony PM10          None  2010-01-01 00:00:00        798  
2      dwutlenek azotu          None  2010-01-01 00:00:00        798  
3     dwutlenek siarki          None  2010-01-01 00:00:00        798  
--------------------------
731
     id  param.idParam param.paramCode param.paramFormula  \
0  4701              8              CO                 CO   
1  4706              3            PM10               PM10   
2  4703              6             NO2                NO2   
3  4707              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  1998-09-01 00:00:00        731  
1  pył zawieszony PM10          None  1998-09-01 00:00:00        731  
2      dwutlenek azotu          None  1998-09-01 00:00:00        731  
3     dwutlenek siarki          None  1998-09-01 00:00:00        731  
--------------------------
809
     id  param.idParam param.paramCode param.paramFormula  \
0  5312              3            PM10               PM10   
1  5309              6             NO2                NO2   
2  5313             69           PM2.5              PM2.5   
3  5317              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2005-01-01 00:00:00        809  
1       dwutlenek azotu          None  2005-01-01 00:00:00        809  
2  pył zawieszony PM2.5          None  2009-01-01 00:00:00        809  
3      dwutlenek siarki          None  2005-01-01 00:00:00        809  
--------------------------
142
    id  param.idParam param.paramCode param.paramFormula      param.paramName  \
0  806              8              CO                 CO         tlenek węgla   
1  812              3            PM10               PM10  pył zawieszony PM10   
2  809              6             NO2                NO2      dwutlenek azotu   
3  814              1             SO2                SO2     dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2012-03-01 00:00:00        142  
1          None  2012-03-01 00:00:00        142  
2          None  2012-03-01 00:00:00        142  
3          None  2012-03-01 00:00:00        142  
--------------------------
638
     id  param.idParam param.paramCode param.paramFormula  \
0  4196              3            PM10               PM10   
1  4192              6             NO2                NO2   
2  4194              5              O3                 O3   
3  4200              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2009-08-01 00:00:00        638  
1      dwutlenek azotu          None  2012-01-01 00:00:00        638  
2                 ozon          None  2012-01-01 00:00:00        638  
3     dwutlenek siarki          None  2012-01-01 00:00:00        638  
--------------------------
10120
      id  param.idParam param.paramCode param.paramFormula  \
0  16465              8              CO                 CO   
1  16457              3            PM10               PM10   
2  16460              6             NO2                NO2   
3  16494             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2016-01-01 00:00:00      10120  
1   pył zawieszony PM10          None  2016-01-01 00:00:00      10120  
2       dwutlenek azotu          None  2016-01-01 00:00:00      10120  
3  pył zawieszony PM2.5          None  2017-01-01 00:00:00      10120  
--------------------------
848
     id  param.idParam param.paramCode param.paramFormula  \
0  5564              8              CO                 CO   
1  5573              3            PM10               PM10   
2  5568              6             NO2                NO2   
3  5570              5              O3                 O3   
4  5579              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2005-01-01 00:00:00        848  
1  pył zawieszony PM10          None  2005-01-01 00:00:00        848  
2      dwutlenek azotu          None  2005-01-01 00:00:00        848  
3                 ozon          None  2005-01-01 00:00:00        848  
4     dwutlenek siarki          None  2005-01-01 00:00:00        848  
--------------------------
761
      id  param.idParam param.paramCode param.paramFormula  \
0   5026              8              CO                 CO   
1   5036              3            PM10               PM10   
2  14612             10            C6H6               C6H6   
3   5032              6             NO2                NO2   
4   5038             69           PM2.5              PM2.5   
5   5034              5              O3                 O3   
6   5041              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2010-01-01 00:00:00        761  
1   pył zawieszony PM10          None  2010-01-01 00:00:00        761  
2                benzen          None  2014-01-01 00:00:00        761  
3       dwutlenek azotu          None  2010-01-01 00:00:00        761  
4  pył zawieszony PM2.5          None  2010-01-01 00:00:00        761  
5                  ozon          None  2010-01-01 00:00:00        761  
6      dwutlenek siarki          None  2010-01-01 00:00:00        761  
--------------------------
10123
      id  param.idParam param.paramCode param.paramFormula  \
0  16786              3            PM10               PM10   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2016-01-01 00:00:00      10123  
--------------------------
742
      id  param.idParam param.paramCode param.paramFormula  \
0   4860              8              CO                 CO   
1  16070              3            PM10               PM10   
2   4866              6             NO2                NO2   
3   4868              5              O3                 O3   
4   4873              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2012-01-01 00:00:00        742  
1  pył zawieszony PM10          None  2016-01-01 00:00:00        742  
2      dwutlenek azotu          None  2012-01-01 00:00:00        742  
3                 ozon          None  2012-01-01 00:00:00        742  
4     dwutlenek siarki          None  2012-01-01 00:00:00        742  
--------------------------
741
     id  param.idParam param.paramCode param.paramFormula  \
0  4834              8              CO                 CO   
1  4845              3            PM10               PM10   
2  4840              6             NO2                NO2   
3  4842              5              O3                 O3   
4  4848              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2012-01-01 00:00:00        741  
1  pył zawieszony PM10          None  2012-01-01 00:00:00        741  
2      dwutlenek azotu          None  2012-01-01 00:00:00        741  
3                 ozon          None  2012-01-01 00:00:00        741  
4     dwutlenek siarki          None  2012-01-01 00:00:00        741  
--------------------------
10254
      id  param.idParam param.paramCode param.paramFormula  \
0  16905              3            PM10               PM10   
1  16904              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2016-03-21 00:00:00      10254  
1     dwutlenek siarki          None  2016-03-21 00:00:00      10254  
--------------------------
877
     id  param.idParam param.paramCode param.paramFormula  \
0  5754              8              CO                 CO   
1  5766              3            PM10               PM10   
2  5752             10            C6H6               C6H6   
3  5761              6             NO2                NO2   
4  5768             69           PM2.5              PM2.5   
5  5763              5              O3                 O3   
6  5770              1             SO2                SO2   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0          tlenek węgla          None  2005-01-01 00:00:00        877  
1   pył zawieszony PM10          None  2005-01-01 00:00:00        877  
2                benzen          None  2005-05-01 00:00:00        877  
3       dwutlenek azotu          None  2005-01-01 00:00:00        877  
4  pył zawieszony PM2.5          None  2009-03-27 00:00:00        877  
5                  ozon          None  2004-06-01 00:00:00        877  
6      dwutlenek siarki          None  2005-01-01 00:00:00        877  
--------------------------
70
    id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  397              6             NO2                NO2   dwutlenek azotu   
1  402              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2008-07-01 00:00:00         70  
1          None  2008-07-01 00:00:00         70  
--------------------------
319
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  2219              6             NO2                NO2   dwutlenek azotu   
1  2221              5              O3                 O3              ozon   
2  2222              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2003-10-17 00:00:00        319  
1          None  2003-10-17 00:00:00        319  
2          None  2003-10-17 00:00:00        319  
--------------------------
517
     id  param.idParam param.paramCode param.paramFormula  \
0  3526              3            PM10               PM10   
1  3528             69           PM2.5              PM2.5   

        param.paramName sensorDateEnd      sensorDateStart  stationId  
0   pył zawieszony PM10          None  2012-01-01 00:00:00        517  
1  pył zawieszony PM2.5          None  2012-01-01 00:00:00        517  
--------------------------
374
     id  param.idParam param.paramCode param.paramFormula   param.paramName  \
0  2504              6             NO2                NO2   dwutlenek azotu   
1  2506              5              O3                 O3              ozon   
2  2510              1             SO2                SO2  dwutlenek siarki   

  sensorDateEnd      sensorDateStart  stationId  
0          None  2005-01-01 00:00:00        374  
1          None  2005-01-01 00:00:00        374  
2          None  2005-01-01 00:00:00        374  
--------------------------
376
     id  param.idParam param.paramCode param.paramFormula  \
0  2519              8              CO                 CO   
1  2528              3            PM10               PM10   
2  2523              6             NO2                NO2   
3  2525              5              O3                 O3   
4  2532              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0         tlenek węgla          None  2011-01-26 00:00:00        376  
1  pył zawieszony PM10          None  2011-01-26 00:00:00        376  
2      dwutlenek azotu          None  2011-01-26 00:00:00        376  
3                 ozon          None  2011-01-26 00:00:00        376  
4     dwutlenek siarki          None  2011-01-26 00:00:00        376  
--------------------------
9913
      id  param.idParam param.paramCode param.paramFormula  \
0  17276              3            PM10               PM10   
1  16037              6             NO2                NO2   
2  16041              5              O3                 O3   
3  16043              1             SO2                SO2   

       param.paramName sensorDateEnd      sensorDateStart  stationId  
0  pył zawieszony PM10          None  2017-01-01 00:00:00       9913  
1      dwutlenek azotu          None  2016-01-01 00:00:00       9913  
2                 ozon          None  2016-01-01 00:00:00       9913  
3     dwutlenek siarki          None  2016-01-01 00:00:00       9913  
--------------------------

In [87]:
allsensors


Out[87]:
id param.idParam param.paramCode param.paramFormula param.paramName sensorDateEnd sensorDateStart stationId
0 15727 6 NO2 NO2 dwutlenek azotu None 2015-07-01 00:00:00 236
1 1676 5 O3 O3 ozon None 2010-01-01 00:00:00 236
2 14348 1 SO2 SO2 dwutlenek siarki None 2014-01-01 00:00:00 236
0 3996 8 CO CO tlenek węgla None 2004-09-01 00:00:00 605
1 4001 6 NO2 NO2 dwutlenek azotu None 2004-09-01 00:00:00 605
2 4005 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2009-07-01 00:00:00 605
3 4006 1 SO2 SO2 dwutlenek siarki None 2004-09-01 00:00:00 605
0 4011 6 NO2 NO2 dwutlenek azotu None 2004-09-01 00:00:00 606
1 4013 5 O3 O3 ozon None 2004-09-01 00:00:00 606
2 4016 1 SO2 SO2 dwutlenek siarki None 2004-09-01 00:00:00 606
0 14498 10 C6H6 C6H6 benzen None 2013-12-22 00:00:00 9000
0 101 3 PM10 PM10 pył zawieszony PM10 None 2005-01-01 00:00:00 16
1 99 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 16
2 102 1 SO2 SO2 dwutlenek siarki None 2005-01-01 00:00:00 16
0 14707 8 CO CO tlenek węgla None 2014-10-20 00:00:00 9153
1 14730 3 PM10 PM10 pył zawieszony PM10 None 2014-10-20 00:00:00 9153
2 14734 10 C6H6 C6H6 benzen None 2014-10-20 00:00:00 9153
3 14727 6 NO2 NO2 dwutlenek azotu None 2014-10-20 00:00:00 9153
4 14731 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2014-10-20 00:00:00 9153
5 14729 5 O3 O3 ozon None 2014-10-20 00:00:00 9153
6 14733 1 SO2 SO2 dwutlenek siarki None 2014-10-20 00:00:00 9153
0 853 3 PM10 PM10 pył zawieszony PM10 None 2012-03-01 00:00:00 145
1 850 6 NO2 NO2 dwutlenek azotu None 2012-03-01 00:00:00 145
2 855 1 SO2 SO2 dwutlenek siarki None 2012-03-01 00:00:00 145
0 660 8 CO CO tlenek węgla None 2005-01-01 00:00:00 117
1 14395 3 PM10 PM10 pył zawieszony PM10 None 2014-01-03 00:00:00 117
2 658 10 C6H6 C6H6 benzen None 2005-01-01 00:00:00 117
3 665 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 117
4 670 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2008-06-01 00:00:00 117
5 667 5 O3 O3 ozon None 2005-01-01 00:00:00 117
... ... ... ... ... ... ... ... ...
3 4842 5 O3 O3 ozon None 2012-01-01 00:00:00 741
4 4848 1 SO2 SO2 dwutlenek siarki None 2012-01-01 00:00:00 741
0 16905 3 PM10 PM10 pył zawieszony PM10 None 2016-03-21 00:00:00 10254
1 16904 1 SO2 SO2 dwutlenek siarki None 2016-03-21 00:00:00 10254
0 5754 8 CO CO tlenek węgla None 2005-01-01 00:00:00 877
1 5766 3 PM10 PM10 pył zawieszony PM10 None 2005-01-01 00:00:00 877
2 5752 10 C6H6 C6H6 benzen None 2005-05-01 00:00:00 877
3 5761 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 877
4 5768 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2009-03-27 00:00:00 877
5 5763 5 O3 O3 ozon None 2004-06-01 00:00:00 877
6 5770 1 SO2 SO2 dwutlenek siarki None 2005-01-01 00:00:00 877
0 397 6 NO2 NO2 dwutlenek azotu None 2008-07-01 00:00:00 70
1 402 1 SO2 SO2 dwutlenek siarki None 2008-07-01 00:00:00 70
0 2219 6 NO2 NO2 dwutlenek azotu None 2003-10-17 00:00:00 319
1 2221 5 O3 O3 ozon None 2003-10-17 00:00:00 319
2 2222 1 SO2 SO2 dwutlenek siarki None 2003-10-17 00:00:00 319
0 3526 3 PM10 PM10 pył zawieszony PM10 None 2012-01-01 00:00:00 517
1 3528 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2012-01-01 00:00:00 517
0 2504 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 374
1 2506 5 O3 O3 ozon None 2005-01-01 00:00:00 374
2 2510 1 SO2 SO2 dwutlenek siarki None 2005-01-01 00:00:00 374
0 2519 8 CO CO tlenek węgla None 2011-01-26 00:00:00 376
1 2528 3 PM10 PM10 pył zawieszony PM10 None 2011-01-26 00:00:00 376
2 2523 6 NO2 NO2 dwutlenek azotu None 2011-01-26 00:00:00 376
3 2525 5 O3 O3 ozon None 2011-01-26 00:00:00 376
4 2532 1 SO2 SO2 dwutlenek siarki None 2011-01-26 00:00:00 376
0 17276 3 PM10 PM10 pył zawieszony PM10 None 2017-01-01 00:00:00 9913
1 16037 6 NO2 NO2 dwutlenek azotu None 2016-01-01 00:00:00 9913
2 16041 5 O3 O3 ozon None 2016-01-01 00:00:00 9913
3 16043 1 SO2 SO2 dwutlenek siarki None 2016-01-01 00:00:00 9913

650 rows × 8 columns


In [91]:
allStations[["id", "gegrLat", "gegrLon"]]


Out[91]:
id gegrLat gegrLon
0 236 52.029194 23.149389
1 605 53.126689 23.155869
2 606 53.138614 23.229903
3 9000 50.16385 18.659977
4 16 50.732817 16.648050
5 9153 50.913433 15.765608
6 145 53.012261 18.606203
7 117 51.129378 17.029250
8 813 50.246795 19.019469
9 568 50.349608 18.236575
10 10121 50.057447 19.946008
11 9175 49.511297 21.498606
12 52 51.204503 16.180513
13 750 54.754139 17.534528
14 10058 51.754613 19.434925
15 67 50.579914 16.514422
16 488 52.191728 20.837489
17 322 51.404406 19.696956
18 671 50.024242 22.010575
19 622 54.117878 22.934608
20 986 53.380975 14.663347
21 10054 53.859528 23.000750
22 240 50.590806 22.997889
23 10035 51.263245 15.570354
24 612 53.215492 23.642153
25 861 54.167847 19.410942
26 291 52.143250 19.233225
27 729 54.353336 18.635283
28 739 54.525274 18.536382
29 248 51.814367 21.972375
... ... ... ...
132 10139 50.099361 20.018317
133 401 50.010575 19.949189
134 10374 50.666736 17.899137
135 920 53.154408 16.759572
136 665 49.784339 22.756239
137 515 51.399084 21.147474
138 10455 50.358659 20.886184
139 734 54.431667 18.579722
140 837 50.285956 19.184399
141 460 51.835120 20.791556
142 156 53.121764 17.987906
143 798 50.817676 19.117426
144 731 54.400833 18.657497
145 809 50.279333 18.655764
146 142 53.493550 18.762139
147 638 49.744886 21.454617
148 10120 50.017875 20.993000
149 848 50.3165 18.772375
150 761 50.872549 20.604998
151 10123 50.081197 19.895358
152 742 54.546167 17.746194
153 741 54.031247 19.032899
154 10254 49.483597 20.028992
155 877 53.789233 20.486075
156 70 50.942073 17.291333
157 319 51.291175 19.517556
158 517 52.172145 22.282001
159 374 52.172222 15.206667
160 376 52.437722 15.122444
161 9913 52.943172 21.288167

162 rows × 3 columns


In [155]:
finalData = pd.merge(allsensors, allStations[["id", "gegrLat", "gegrLon"]], how='inner', left_on="stationId", right_on="id")

In [166]:
def get_latest_measurement(sensorId):
    concentration = json_normalize(requests.get('http://api.gios.gov.pl/pjp-api/rest/data/getData/' + str(sensorId)).json())
    concentrationFrame = pd.DataFrame()
    concentrationFrame["dates"] = [d[u'date'] for d in concentration["values"].values.item()]
    concentrationFrame["values"] = [d[u'value'] for d in concentration["values"].values.item()]
    concentrationFrame["dates"] = pd.to_datetime(concentrationFrame["dates"])
    #print(concentrationFrame[concentrationFrame["dates"] == previousHourStr]["values"])
    try:
        return_value = concentrationFrame[concentrationFrame["dates"] == previousHourStr]["values"].item()
    except ValueError:
        return_value = np.NaN
    #print(return_value)
    return return_value

In [154]:
get_latest_measurement(sensorId=sensorId)


Out[154]:
34.6944

In [116]:
import datetime

In [129]:
previousHour = datetime.datetime.now() - datetime.timedelta(hours = 1)

In [136]:
previousHourStr = previousHour.strftime('%Y-%m-%d %H:00:00')

In [149]:
sdfasd[sdfasd["dates"] == previousHourStr]["values"].item()


Out[149]:
34.6944

In [168]:
from tqdm import tqdm, tqdm_pandas
tqdm_pandas(tqdm())


0it [00:00, ?it/s]
TqdmDeprecationWarning: Please use `tqdm.pandas(...)` instead of `tqdm_pandas(tqdm(...))`.

In [169]:
finalData["value"] = finalData["id_x"].progress_map(get_latest_measurement)


650it [03:01,  5.31it/s]

In [170]:
finalData


Out[170]:
id_x param.idParam param.paramCode param.paramFormula param.paramName sensorDateEnd sensorDateStart stationId id_y gegrLat gegrLon value
0 15727 6 NO2 NO2 dwutlenek azotu None 2015-07-01 00:00:00 236 236 52.029194 23.149389 13.10000
1 1676 5 O3 O3 ozon None 2010-01-01 00:00:00 236 236 52.029194 23.149389 32.64000
2 14348 1 SO2 SO2 dwutlenek siarki None 2014-01-01 00:00:00 236 236 52.029194 23.149389 36.76000
3 3996 8 CO CO tlenek węgla None 2004-09-01 00:00:00 605 605 53.126689 23.155869 365.00000
4 4001 6 NO2 NO2 dwutlenek azotu None 2004-09-01 00:00:00 605 605 53.126689 23.155869 11.90000
5 4005 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2009-07-01 00:00:00 605 605 53.126689 23.155869 22.00000
6 4006 1 SO2 SO2 dwutlenek siarki None 2004-09-01 00:00:00 605 605 53.126689 23.155869 3.90000
7 4011 6 NO2 NO2 dwutlenek azotu None 2004-09-01 00:00:00 606 606 53.138614 23.229903 3.70000
8 4013 5 O3 O3 ozon None 2004-09-01 00:00:00 606 606 53.138614 23.229903 46.00000
9 4016 1 SO2 SO2 dwutlenek siarki None 2004-09-01 00:00:00 606 606 53.138614 23.229903 4.10000
10 14498 10 C6H6 C6H6 benzen None 2013-12-22 00:00:00 9000 9000 50.16385 18.659977 14.33050
11 101 3 PM10 PM10 pył zawieszony PM10 None 2005-01-01 00:00:00 16 16 50.732817 16.648050 30.37940
12 99 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 16 16 50.732817 16.648050 15.68430
13 102 1 SO2 SO2 dwutlenek siarki None 2005-01-01 00:00:00 16 16 50.732817 16.648050 6.34540
14 14707 8 CO CO tlenek węgla None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 450.66300
15 14730 3 PM10 PM10 pył zawieszony PM10 None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 26.52970
16 14734 10 C6H6 C6H6 benzen None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 1.52750
17 14727 6 NO2 NO2 dwutlenek azotu None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 13.72760
18 14731 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 14.54860
19 14729 5 O3 O3 ozon None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 43.53220
20 14733 1 SO2 SO2 dwutlenek siarki None 2014-10-20 00:00:00 9153 9153 50.913433 15.765608 2.68288
21 853 3 PM10 PM10 pył zawieszony PM10 None 2012-03-01 00:00:00 145 145 53.012261 18.606203 20.38000
22 850 6 NO2 NO2 dwutlenek azotu None 2012-03-01 00:00:00 145 145 53.012261 18.606203 8.83806
23 855 1 SO2 SO2 dwutlenek siarki None 2012-03-01 00:00:00 145 145 53.012261 18.606203 6.87054
24 660 8 CO CO tlenek węgla None 2005-01-01 00:00:00 117 117 51.129378 17.029250 547.43100
25 14395 3 PM10 PM10 pył zawieszony PM10 None 2014-01-03 00:00:00 117 117 51.129378 17.029250 39.19150
26 658 10 C6H6 C6H6 benzen None 2005-01-01 00:00:00 117 117 51.129378 17.029250 0.37771
27 665 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 117 117 51.129378 17.029250 21.41170
28 670 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2008-06-01 00:00:00 117 117 51.129378 17.029250 31.58500
29 667 5 O3 O3 ozon None 2005-01-01 00:00:00 117 117 51.129378 17.029250 19.19300
... ... ... ... ... ... ... ... ... ... ... ... ...
620 4842 5 O3 O3 ozon None 2012-01-01 00:00:00 741 741 54.031247 19.032899 NaN
621 4848 1 SO2 SO2 dwutlenek siarki None 2012-01-01 00:00:00 741 741 54.031247 19.032899 4.48985
622 16905 3 PM10 PM10 pył zawieszony PM10 None 2016-03-21 00:00:00 10254 10254 49.483597 20.028992 63.54880
623 16904 1 SO2 SO2 dwutlenek siarki None 2016-03-21 00:00:00 10254 10254 49.483597 20.028992 11.49120
624 5754 8 CO CO tlenek węgla None 2005-01-01 00:00:00 877 877 53.789233 20.486075 302.45100
625 5766 3 PM10 PM10 pył zawieszony PM10 None 2005-01-01 00:00:00 877 877 53.789233 20.486075 36.69830
626 5752 10 C6H6 C6H6 benzen None 2005-05-01 00:00:00 877 877 53.789233 20.486075 0.94372
627 5761 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 877 877 53.789233 20.486075 16.78580
628 5768 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2009-03-27 00:00:00 877 877 53.789233 20.486075 20.45170
629 5763 5 O3 O3 ozon None 2004-06-01 00:00:00 877 877 53.789233 20.486075 39.38720
630 5770 1 SO2 SO2 dwutlenek siarki None 2005-01-01 00:00:00 877 877 53.789233 20.486075 3.39756
631 397 6 NO2 NO2 dwutlenek azotu None 2008-07-01 00:00:00 70 70 50.942073 17.291333 15.77880
632 402 1 SO2 SO2 dwutlenek siarki None 2008-07-01 00:00:00 70 70 50.942073 17.291333 3.14944
633 2219 6 NO2 NO2 dwutlenek azotu None 2003-10-17 00:00:00 319 319 51.291175 19.517556 11.60000
634 2221 5 O3 O3 ozon None 2003-10-17 00:00:00 319 319 51.291175 19.517556 33.20000
635 2222 1 SO2 SO2 dwutlenek siarki None 2003-10-17 00:00:00 319 319 51.291175 19.517556 7.00000
636 3526 3 PM10 PM10 pył zawieszony PM10 None 2012-01-01 00:00:00 517 517 52.172145 22.282001 24.06000
637 3528 69 PM2.5 PM2.5 pył zawieszony PM2.5 None 2012-01-01 00:00:00 517 517 52.172145 22.282001 17.03000
638 2504 6 NO2 NO2 dwutlenek azotu None 2005-01-01 00:00:00 374 374 52.172222 15.206667 7.09320
639 2506 5 O3 O3 ozon None 2005-01-01 00:00:00 374 374 52.172222 15.206667 26.54060
640 2510 1 SO2 SO2 dwutlenek siarki None 2005-01-01 00:00:00 374 374 52.172222 15.206667 2.16553
641 2519 8 CO CO tlenek węgla None 2011-01-26 00:00:00 376 376 52.437722 15.122444 497.51000
642 2528 3 PM10 PM10 pył zawieszony PM10 None 2011-01-26 00:00:00 376 376 52.437722 15.122444 41.34700
643 2523 6 NO2 NO2 dwutlenek azotu None 2011-01-26 00:00:00 376 376 52.437722 15.122444 8.07554
644 2525 5 O3 O3 ozon None 2011-01-26 00:00:00 376 376 52.437722 15.122444 40.53440
645 2532 1 SO2 SO2 dwutlenek siarki None 2011-01-26 00:00:00 376 376 52.437722 15.122444 4.56227
646 17276 3 PM10 PM10 pył zawieszony PM10 None 2017-01-01 00:00:00 9913 9913 52.943172 21.288167 NaN
647 16037 6 NO2 NO2 dwutlenek azotu None 2016-01-01 00:00:00 9913 9913 52.943172 21.288167 4.56000
648 16041 5 O3 O3 ozon None 2016-01-01 00:00:00 9913 9913 52.943172 21.288167 40.11000
649 16043 1 SO2 SO2 dwutlenek siarki None 2016-01-01 00:00:00 9913 9913 52.943172 21.288167 2.78000

650 rows × 12 columns


In [ ]: