servicemap

Custom SQL query returning 9 rows (hide)

Query parameters

name_finame_svname_enidperiod_enabledclarification_enabledkeywordsroot_service_nodeunit_count_municipality_helsinkiunit_count_totalunit_count_municipality_hankounit_count_municipality_raaseporiunit_count_municipality_siuntiounit_count_municipality_sipoounit_count_municipality_janakkalaunit_count_municipality_nullunit_count_municipality_nurmijärviunit_count_municipality_virolahtiunit_count_municipality_pornainenunit_count_municipality_hämeenlinnaunit_count_municipality_salounit_count_municipality_lapinjärviunit_count_municipality_inkoounit_count_municipality_miehikkäläunit_count_municipality_porvoounit_count_municipality_lohjaunit_count_municipality_tuusulaunit_count_municipality_kirkkonummiunit_count_municipality_haminaunit_count_municipality_kouvolaunit_count_municipality_loviisaunit_count_municipality_espoounit_count_municipality_kotkaunit_count_municipality_askolaunit_count_municipality_mäntsäläunit_count_municipality_vantaaunit_count_municipality_hyvinkääunit_count_municipality_vihtiunit_count_municipality_kauniainenunit_count_municipality_karkkilaunit_count_municipality_järvenpääunit_count_municipality_keravaunit_count_municipality_pyhtää
asumisterveys (ympäristöterveydenhuolto) boendehälsa (miljöhälsovård) housing health (environmental health care) 77 0 0 {} 1400 2 5                                 1         1       1              
elintarvikevalvonta (ympäristöterveydenhuolto) livsmedelstillsyn (miljöhälsovård) food control (environmental health care) 137 0 0 {} 1400 1 4                                 1         1       1              
eläinlääkäripalvelut (ympäristöterveydenhuolto) veterinärtjänster (miljöhälsovård) vet services (environmental health care) 140 0 0 {} 1400 1 4                                 1         1       1              
hiihtoladut skidspår ski tracks 191 0 0 {} 1403 45 208       2                         1         39       117   3 1        
ravintolat restauranger restaurants 577 0 0 {} 1403 663 699                             1   1         22       12              
uimavesien valvonta (ympäristöterveydenhuolto) övervakning av badvatten (miljöhälsovård) swimming water supervision (environmental health care) 732 0 0 {} 1400 1 4                                 1         1       1              
ympäristöhaitat ja -luvat miljöolägenheter och -tillstånd environmental hazards and permits 823 0 0 {} 1400 2 5                                 1         1       1              
ympäristönsuojelumääräykset miljöskyddsbestämmelser environmental protection regulations 828 0 0 {} 1400 2 4                                 1                 1              
röntgenit röntgen x-rays 606 0 0 {} 986 11 42 1 1   1     1               2 1 1 1 1 1 1 6 1   1 6 1 1   1 1 1