servicemap

Custom SQL query returning 16 rows (hide)

Query parameters

idchildrenname_finame_svname_enservice_referencelast_modified_timelevelparentkeywordsrelated_servicesperiod_enabledrootunit_count_municipality_helsinkiunit_count_totalunit_count_municipality_hankounit_count_municipality_raaseporiunit_count_municipality_siuntiounit_count_municipality_sipoounit_count_municipality_janakkalaunit_count_municipality_nurmijärviunit_count_municipality_salounit_count_municipality_virolahtiunit_count_municipality_pornainenunit_count_municipality_hämeenlinnaunit_count_municipality__unknownunit_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_askolaunit_count_municipality_kotkaunit_count_municipality_mäntsäläunit_count_municipality_vantaaunit_count_municipality_hyvinkääunit_count_municipality_vihtiunit_count_municipality_kauniainenunit_count_municipality_järvenpääunit_count_municipality_keravaunit_count_municipality_karkkilaunit_count_municipality_pyhtää
633 [634, 639, 646, 654, 663] Ulkokentät ja liikuntapuistot Utomhusplaner och idrottsparker Outdoor fields and sports parks   2018-08-07T14:00:23.790680+03:00 2 551 {} 0 1403 1261 2383                         1     1           636       457   4 23        
646 [578, 647, 648, 649, 650, 651, 652, 653] Lähiliikunta ja liikuntapuistot Närmotion och idrottsparker Neighbourhood sports facilities and parks   2018-08-07T14:00:23.877348+03:00 3 633 {} 0 1403 345 650                               1           196       95   3 10        
648 [] Lähiliikuntapaikka Näridrottsplats Neighbourhood sports area 415 2018-08-07T14:00:23.898085+03:00 4 646 {} 0 1403 134 229                               1           64       26     4        
789 [] Lastensuojelun laitospalvelu Institutionstjänster inom barnskyddet Institutional service for child welfare 380 2018-08-07T14:00:27.738722+03:00 2 787 {} 0 783 12 37                               1           7       16 1            
1009 [1011, 1012, 1013, 2161, 1014, 1015, 1016, 1010] Sairaalat Sjukhus Hospitals   2018-08-07T14:00:29.308401+03:00 1 986 {} 0 986 35 52                             1 1           6   2   5 2            
1010 [] Yliopistolliset sairaalat Universitetssjukhus University hospitals 820 2018-08-07T14:00:29.314677+03:00 2 1009 {} 0 986 18 31                             1 1           4   2   3 2            
1018 [] Röntgen Röntgen X-rays 606 2018-08-07T14:00:29.396972+03:00 1 986 {} 0 986 11 42 1 1   1   1                 2 1 1 1 1 1 1 6   1 1 6 1 1   1 1 1  
1097 [1187, 1255, 1098] Perusopetus Grundläggande utbildning Basic education   2018-08-07T14:00:25.451107+03:00 1 1087 {} 0 1087 414 568                               1           97       55 1            
1120 [1123, 1124, 1127, 1129, 1122, 1130, 1131, 1135, 1136, 1139, 1141, 1134, 1142, 1143, 1147, 1146, 1160, 1162, 1163, 1164, 1165, 1166, 1167, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:25.674488+03:00 3 1098 {} 0 1087 109 213                               1           73       29 1            
1173 [] Erityisluokkaopetus Undervisning i specialklass Special class education 660 2018-08-07T14:00:26.138862+03:00 3 1098 {} 1 1087 4 10                               1           5                      
1372 [1373, 1374, 1375] Oppilas- ja opiskelijahuolto Elevvård Pupil and student care   2018-08-07T14:00:27.603403+03:00 1 1087 {} 0 1087 241 388                               1           2       136 1   7        
2164 [] Kouluterveydenhuolto Skolhälsovård School health care 339 2018-08-07T14:00:29.207544+03:00 2 997 {} 0 986 160 236                               1           1       68 1   5        
2165 [] Kouluterveydenhuolto Skolhälsovård School health care 339 2018-08-07T14:00:27.619794+03:00 3 1373 {} 0 1087 160 236                               1           1       68 1   5        
783 [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] Perhe- ja sosiaalipalvelut Familje- och socialservice Family and social services   2018-08-07T14:00:27.699133+03:00 0   {} 0 783 397 718       2             1         1           129       175 1   7   5    
1403 [343, 551, 717, 365] Kulttuuri, liikunta ja vapaa-aika Kultur, motion och fritid Culture, sports and leisure   2018-08-07T14:00:22.534057+03:00 0   {} 0 1403 5769 8871 1     18 1 1       1 12 1 20   3 1 6 14       1685     1 1238 1 37 57 4      
551 [552, 2151, 558, 2217, 601, 633, 666, 684, 694] Liikunta Idrott och motion Sports and physical exercise   2018-08-07T14:00:23.220207+03:00 1 1403 {} 0 1403 2590 4872       16             3   19     1 1 11       1260     1 892   36 42