servicemap

Custom SQL query returning 11 rows (hide)

select id, children, name_fi, name_sv, name_en, service_reference, last_modified_time, level, parent, keywords, related_services, period_enabled, root, unit_count_municipality_helsinki, unit_count_total, unit_count_municipality_hanko, unit_count_municipality_raasepori, unit_count_municipality_siuntio, unit_count_municipality_sipoo, unit_count_municipality_janakkala, [unit_count_municipality_nurmijärvi], unit_count_municipality_salo, unit_count_municipality_virolahti, unit_count_municipality_pornainen, [unit_count_municipality_hämeenlinna], unit_count_municipality__unknown, [unit_count_municipality_lapinjärvi], unit_count_municipality_inkoo, [unit_count_municipality_miehikkälä], unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_kouvola, unit_count_municipality_loviisa, unit_count_municipality_espoo, unit_count_municipality_askola, unit_count_municipality_kotka, [unit_count_municipality_mäntsälä], unit_count_municipality_vantaa, [unit_count_municipality_hyvinkää], unit_count_municipality_vihti, unit_count_municipality_kauniainen, [unit_count_municipality_järvenpää], unit_count_municipality_kerava, unit_count_municipality_karkkila, [unit_count_municipality_pyhtää] from service_node where "related_services" = :p0 and "unit_count_municipality_kauniainen" = :p1 order by id limit 101

Query parameters

This data as json, CSV

id	children	name_fi	name_sv	name_en	last_modified_time	level	parent	keywords	related_services	root	unit_count_municipality_helsinki	unit_count_total	unit_count_municipality_sipoo	unit_count_municipality_kirkkonummi	unit_count_municipality_espoo	unit_count_municipality_vantaa	unit_count_municipality_kauniainen	unit_count_municipality_kerava
171	[2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219]	Hallinto ja talous	Förvaltning och ekonomi	Administration and economy	2018-08-07T14:00:30.363012+03:00	1	1401	{}	[]	1401	124	163	1	1	17	17	2	1
324	[325, 2040, 2193, 327, 328, 2194]	Kirjastot	Bibliotek	Libraries	2018-08-07T14:00:24.821378+03:00	2	306	{}	[]	1402	83	125			26	14	2
345	[346, 2026, 2196, 348, 349, 2197]	Kirjastot	Bibliotek	Libraries	2018-08-07T14:00:22.550752+03:00	2	343	{}	[]	1403	114	157			27	14	2
526	[527, 528, 2207, 529, 530, 2204, 532]	Pysäköinti	Parkering	Parking	2018-08-07T14:00:25.093849+03:00	2	512	{}	[]	1402	559	1023			460	2	2
575	[576]	Laskettelurinteet ja rinnehiihtokeskukset	Slalombackar och alpina skidcentra	Ski slopes and downhill ski resorts	2018-08-07T14:00:23.388106+03:00	3	558	{}	[]	1403	2	6			2		2
614	[615, 616, 617, 618, 619, 620, 621, 622, 623]	Liikuntahallit	Idrottshallar	Sports halls	2018-08-07T14:00:23.644666+03:00	3	601	{}	[]	1403	149	233			60	22	2
639	[641, 642, 643, 644, 645]	Jääurheilualueet ja luonnonjäät	Isidrottsområden och naturisar	Ice sports areas and sites with natural ice	2018-08-07T14:00:23.829697+03:00	3	633	{}	[]	1403	165	358			114	77	2
791	[794, 795, 792, 793, 796]	Muut perheiden palvelut	Övriga tjänster för familjer	Other family services	2018-08-07T14:00:27.754089+03:00	1	783	{}	[]	783	16	40			4	18	2
810	[815, 816, 817, 813, 812, 811, 818, 814, 1007]	Kehitysvammahuolto	Vård av utvecklingsstörda	Care for the developmentally disabled	2018-08-07T14:00:27.882619+03:00	1	783	{}	[]	783	56	109			12	36	2	3
1028	[1029, 1031, 1040, 1032, 1033, 1034, 1035, 1036, 1037, 1038]	Kuntoutus	Rehabilitering	Rehabilitation	2018-08-07T14:00:29.478107+03:00	1	986	{}	[]	986	33	67			16	16	2
1083	[1084, 1086]	Väestönsuojat	Befolkningsskyddsrum	Public shelters	2018-08-07T14:00:29.937480+03:00	1	1061	{}	[]	1061	47	49					2