servicemap

Custom SQL query returning 11 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ää
hotellit ja majoitus hotell och logi hotels and accommodation 197 0 0 {} 1403 89 115         1               1   1     2       7       13   1          
laavut, kodat ja kammit vindskydd och kåtor lean-tos, goahtis (Lapp tent shelter) or 'kammi' earth lodges 365 0 0 {} 1403   4                                                   3   1          
laboratoriot laboratorier laboratories 366 0 0 {} 986 22 88   3 1 1     3 1 1       1 1 2 6 3 3 1 7 1 10 3 1 1 8 1 1 2 1 1 1 1
lentopallokentät volleybollsplaner volleyball courts 392 0 0 {} 1403 46 86                         1                 10       28   1          
luontopolut naturstigar nature trails 413 0 0 {} 1403 12 41       1                 1                 24       1   1 1        
opastuspisteet (retkeilypalvelut) informationspunkter (friluftstjänster) information points (camping services) 482 0 0 {} 1403 51 73       1                 2         2       14       2   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  
telttailu- ja leiriytymispaikat tält- och lägerplatser camping locations 698 0 0 {} 1403 2 12       1                                   8           1          
tuvat (retkeilypalvelut) stugor (friluftstjänster) huts (camping services) 721 0 0 {} 1403   2                                           1           1          
ulkoilualueet friluftsområden outdoor recreation areas 733 0 0 {} 1403 2 24                         1         3       17           1          
ulkoilumajat ja hiihtomajat friluftsstugor och skidstugor outdoor/ski lodges 734 0 0 {} 1403 3 8                                           4           1