servicemap

Custom SQL query returning 8 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ää
490 [] Nuorten neuvonta ja ohjaus Rådgivning och handledning för ungdomar Advice and guidance for young people 471 2018-08-07T14:00:23.202058+03:00 2 365 {} 0 1403 7 22                                           3       12              
613 [] Voimailusali Styrketräningssal Weight training hall 797 2018-08-07T14:00:23.637831+03:00 4 608 {} 0 1403 22 39                                           5       12              
632 [] Yksittäinen yleisurheilun suorituspaikka Enstaka övningsplats för friidrott Stand-alone athletics venue 810 2018-08-07T14:00:23.783286+03:00 4 624 {} 0 1403 9 22                                                   12     1        
652 [] Skeitti / rullaluistelupaikka Plats för skejtning/rullskridskoåkning Skateboarding/roller-blading rink 630 2018-08-07T14:00:23.929996+03:00 4 646 {} 0 1403 27 51                                           11       12     1        
751 [] Ravintolat Restauranger Restaurants 577 2018-08-07T14:00:24.595794+03:00 3 718 {} 0 1403 663 699                             1   1         22       12              
852 [] Muun sosiaalihuollon asumispalvelut Boendetjänster inom övrig socialvård Residential services for other social welfare 637 2018-08-07T14:00:28.163665+03:00 2 845 {} 0 783 11 26       1                                   1       12     1        
992 [] Lääkärin vastaanotto Läkarmottagning Doctor's reception 417 2018-08-07T14:00:29.162295+03:00 1 986 {"fi": ["mielenterveys", "terveysasemat"]} 0 986 26 50                                           11       12     1        
993 [] Terveydenhoitajan vastaanotto Hälsovårdarens mottagning Nurse's reception 702 2018-08-07T14:00:29.169309+03:00 1 986 {} 0 986 26 50                                           11       12     1