servicemap

Custom SQL query returning 24 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 "root" = :p0 order by unit_count_municipality_tuusula limit 101

Query parameters

This data as json, CSV

id	children	name_fi	name_sv	name_en	service_reference	last_modified_time	level	parent	keywords	related_services	root	unit_count_municipality_helsinki	unit_count_total	unit_count_municipality_espoo	unit_count_municipality_vantaa	unit_count_municipality_kauniainen
1061	[1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083]	Turvallisuus	Säkerhet	Public safety		2018-08-07T14:00:29.767356+03:00	0		{}	[]	1061	130	163	17	13	3
1062	[1063, 1064]	Maanpuolustus	Försvaret	National defence		2018-08-07T14:00:29.774255+03:00	1	1061	{}	[]	1061	8	9	1
1063	[]	Maanpuolustusyhdistykset	Försvarsföreningar	National defence associations	422	2018-08-07T14:00:29.780736+03:00	2	1062	{}	[422]	1061	2	2
1064	[]	Puolustusvoimat	Försvarsmakten	The Finnish Defence Forces	529	2018-08-07T14:00:29.789161+03:00	2	1062	{}	[529]	1061	6	7	1
1065	[]	Meripelastus	Sjöräddningen	Sea rescue	435	2018-08-07T14:00:29.800283+03:00	1	1061	{}	[435]	1061	1	1
1066	[1069, 1068, 1067]	Muut turvallisuuspalvelut	Andra säkerhetstjänster	Other safety services		2018-08-07T14:00:29.808816+03:00	1	1061	{}	[]	1061	3	5	1	1
1067	[]	Turvallisuuskoulutus	Säkerhetsutbildning	Safety training	720	2018-08-07T14:00:29.819172+03:00	2	1066	{}	[720]	1061	1	1
1068	[]	Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki)	Stödtjänster inom social- och hälsovården (stöd för boende)	Social and health care services' security services (housing support)	636	2018-08-07T14:00:29.828890+03:00	2	1066	{}	[636]	1061	1	2		1
1069	[]	Muut turvapalvelut (kiinteistöt ja vartiointi)	Övrig säkerhetsservice (fastigheter och bevakning)	Other security services (real estate and guarding)	460	2018-08-07T14:00:29.836971+03:00	2	1066	{}	[460]	1061	1	2	1
1070	[1071, 1072, 1073, 1074, 1075]	Pelastustoimi	Räddningsväsendet	Rescue services		2018-08-07T14:00:29.845529+03:00	1	1061	{}	[]	1061	26	46	13	6	1
1071	[]	Nuohous	Sotning	Chimney sweeping	467	2018-08-07T14:00:29.851905+03:00	2	1070	{}	[467]	1061		1	1
1072	[]	Pelastusasemat	Räddningsstationerna	Rescue Stations	501	2018-08-07T14:00:29.858704+03:00	2	1070	{}	[501]	1061	9	21	6	6
1073	[]	Pelastuskoulu	Räddningsskolan	School of Fire and Rescue Services	502	2018-08-07T14:00:29.866063+03:00	2	1070	{}	[502]	1061	1	1
1074	[]	Sopimuspalokunnat	Avtalsbrandkårer	Volunteer fire departments	633	2018-08-07T14:00:29.872976+03:00	2	1070	{}	[633]	1061	15	23	7		1
1076	[1077]	Poliisi	Polisen	Police		2018-08-07T14:00:29.888769+03:00	1	1061	{}	[]	1061	1	6	1	4
1077	[]	Poliisilaitokset ja -asemat	Polisrättningar och -stationer	Police departments and stations	519	2018-08-07T14:00:29.893912+03:00	2	1076	{}	[519]	1061	1	6	1	4
1078	[]	Rajavartiolaitos	Gränsbevakningsväsendet	Border guard	557	2018-08-07T14:00:29.900790+03:00	1	1061	{}	[557]	1061	1	1
1079	[]	Säteilyturva	Strålsäkerhet	Radiation and nuclear safety	671	2018-08-07T14:00:29.907687+03:00	1	1061	{}	[671]	1061	1	1
1080	[1081]	Tulli	Tullen	Customs		2018-08-07T14:00:29.915254+03:00	1	1061	{}	[]	1061	4	7	1	2
1081	[]	Tullin asiointipisteet	Tullens verksamhetsställen	Customs offices	716	2018-08-07T14:00:29.921102+03:00	2	1080	{}	[716]	1061	4	7	1	2
1082	[]	Väestöhälyttimet	Befolkningslarm	Public alarm systems	805	2018-08-07T14:00:29.929327+03:00	1	1061	{}	[805]	1061	38	38
1083	[1084, 1086]	Väestönsuojat	Befolkningsskyddsrum	Public shelters		2018-08-07T14:00:29.937480+03:00	1	1061	{}	[]	1061	47	49			2
1084	[]	Yhteiskalliosuojat	Gemensamma bergskyddsrum	Shared ground shelters	808	2018-08-07T14:00:29.944094+03:00	2	1083	{}	[808]	1061	29	29
1086	[]	Yleiset väestönsuojat	Allmänna befolkningsskyddsrum	General public shelters	815	2018-08-07T14:00:29.980338+03:00	2	1083	{}	[815]	1061	27	29			2