servicemap

Custom SQL query returning 101 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 (unit_count_total > :p1 or (unit_count_total = :p1 and ((id > :p0)))) order by unit_count_total, id 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	period_enabled	root	unit_count_municipality_helsinki	unit_count_total	unit_count_municipality__unknown	unit_count_municipality_porvoo	unit_count_municipality_espoo	unit_count_municipality_vantaa	unit_count_municipality_vihti	unit_count_municipality_kauniainen
217	[]	Sisäinen tarkastus	Intern revision	Internal auditing	176	2018-08-07T14:00:30.706266+03:00	3	216	{}	[176]	0	1401	1	2			1
228	[]	Liikenteen ohjaus, liikennevalot	Trafikstyrning, trafikljus	Traffic control, traffic lights	396+397	2018-10-24T23:30:05.577987+03:00	4	226	{}	[397, 396]	0	1400		2			1	1
229	[]	Nimistönsuunnittelu	Namnplanering	Nomenclature planning	466	2018-08-07T14:00:22.045496+03:00	3	222	{}	[466]	0	1400		2			1	1
230	[]	Viestintä ja vuorovaikutus	Kommunikation och påverkan	Communications and interaction	785	2018-08-07T14:00:22.052241+03:00	3	222	{}	[785]	0	1400	2	2
237	[]	Maastomittauspalvelut	Terrängmätning	Field surveying services	424	2018-08-07T14:00:22.090579+03:00	4	233	{}	[424]	0	1400	2	2
240	[]	Kiinteistöhuolto ja isännöinti	Fastighetsunderhåll och -förvaltning	Janitorial and landlord services	303	2018-08-07T14:00:22.109816+03:00	3	231	{}	[303]	0	1400	1	2			1
243	[]	Korjausavustukset ja -lainat	Reparationsunderstöd och -lån	Renovation grants and loans	332	2018-08-07T14:00:22.130199+03:00	3	231	{}	[332]	0	1400		2			1	1
250	[]	Liike- ja toimistotonttien vuokraus ja myynti	Arrendering och försäljning av affärs- och kontorstomter	Leasing and selling of commercial and office plots	394	2018-08-07T14:00:22.168975+03:00	4	245	{}	[394]	0	1400		2			1	1
256	[]	Kauppahallimyyntipaikkojen vuokraus	Uthyrning av försäljningsplatser i saluhallar	Market hall sales location leasing	258	2018-08-07T14:00:22.208042+03:00	4	255	{}	[258]	0	1400	1	2				1
257	[]	Torimyyntipaikkojen vuokraus	Uthyrning av torgförsäljningsplatser	Market square vending stall rental	713	2018-08-07T14:00:22.214641+03:00	4	255	{}	[713]	0	1400	1	2				1
264	[]	Tilaussaunat	Beställningsbastur	Reservation-only sauna	804	2018-08-07T14:00:22.259199+03:00	5	258	{}	[804]	0	1400	1	2			1
273	[]	Asiakaspalvelu	Kundtjänst	Customer services	62	2018-08-07T14:00:22.333741+03:00	4	272	{}	[62]	0	1400	1	2				1
278	[]	Korjausrakentaminen	Renovering	Renovation construction	333	2018-08-07T14:00:22.369873+03:00	3	270	{}	[333]	0	1400	1	2			1
286	[]	Rakentamisen sähköinen asiointi ja lomakkeet	Elektroniska tjänster och blanketter i byggärenden	Electronic services and forms related to construction	565	2018-08-07T14:00:22.418594+03:00	3	270	{}	[565]	0	1400		2	1		1
292	[]	Pohja- ja kalliorakennussuunnittelu	Planering av grund- och bergsbyggnad	Foundation and rock engineering	516	2018-08-07T14:00:22.458169+03:00	4	287	{}	[516]	0	1400	1	2				1
295	[]	Jäteveden puhdistamo	Avloppsreningsverk	Sewage treatment plant	233	2018-08-07T14:00:22.470442+03:00	4	293	{}	[233]	0	1400	1	2			1
296	[]	Mullan myynti ja toimitus	Försäljning och leverans av mylla	Selling and delivering soil	453	2018-08-07T14:00:22.477143+03:00	4	293	{}	[453]	0	1400	1	2		1
299	[]	Vedenpuhdistuslaitos	Vattenreningsverket	Water treatment plant	766	2018-08-07T14:00:22.497732+03:00	4	293	{}	[766]	0	1400	2	2
342	[]	Tilastot ja tietopalvelut	Statistik och informationstjänst	Statistics and information services	709	2018-10-25T08:00:07.381081+03:00	2	306	{}	[709]	0	1402	2	2
351	[]	Kulttuuripalvelujen sähköinen asiointi ja lomakkeet	Elektroniska tjänster och blanketter för kulturtjänster	Electronic services and forms related to cultural services	346	2018-08-07T14:00:22.590770+03:00	2	343	{}	[346]	0	1403		2	1			1
381	[]	Demostudio	Demostudio	Demo studio	130	2018-08-07T14:00:22.931253+03:00	3	368	{}	[130]	0	1403	1	2				1
396	[]	Jalkapallo	Fotboll	Football	203	2018-08-07T14:00:22.956950+03:00	3	368	{}	[203]	0	1403		2				2
410	[]	Konsolipelit	Konsolspel	Console games	330	2018-08-07T14:00:23.006235+03:00	3	368	{}	[330]	0	1403	1	2				1
437	[]	Monistuspalvelu	Kopieringstjänst	Copying service	443	2018-08-07T14:00:23.067329+03:00	3	368	{}	[443]	0	1403	2	2
467	[]	Skeittaus	Skateboardåkning	Skateboarding	629	2018-08-07T14:00:23.144513+03:00	3	368	{}	[629]	0	1403	1	2				1
468	[]	Soitonopetus	Instrumentundervisning	Teaching music	632	2018-08-07T14:00:23.150860+03:00	3	368	{}	[632]	0	1403	1	2				1
480	[]	Tyttökerho / tyttöryhmät	Flickklubb / flickgrupper	Girls' club / Girl groups	722	2018-08-07T14:00:23.175639+03:00	3	368	{}	[722]	0	1403		2				2
481	[]	Valokuvaus	Fotografering	Photography	741	2018-08-07T14:00:23.182310+03:00	3	368	{}	[741]	0	1403	1	2			1
485	[]	Viikonlopputoiminta	Veckoslutsverksamhet	Weekend activities	789	2018-08-07T14:00:23.188643+03:00	3	368	{}	[789]	0	1403	2	2
498	[]	Opaskoira-aitaukset	Inhägnat områden för ledarhundar	Fenced areas for guide dogs	480	2018-08-07T14:00:22.741237+03:00	4	493	{}	[480]	0	1403	2	2
511	[]	Tilaussaunat	Beställningsbastur	Reservation-only sauna	804	2018-08-07T14:00:22.844464+03:00	3	505	{}	[804]	0	1403	1	2			1
523	[]	Liikenteen ohjaus, liikennevalot	Trafikstyrning, trafikljus	Traffic control, traffic lights	396+397	2018-10-24T23:30:06.706293+03:00	3	521	{}	[397, 396]	0	1402		2			1	1
543	[]	Hallintopalvelut	Förvaltningstjänster	Administrative services	183	2018-08-07T14:00:25.201364+03:00	4	542	{}	[183]	0	1402	2	2
567	[568, 569]	Katetut talviurheilupaikat	Vintersportplatser under tak	Covered winter sports facilities		2018-08-07T14:00:23.339639+03:00	3	558	{}	[]	0	1403	2	2
618	[]	Petanque - halli	Petanquehall	Petanque hall	512	2018-08-07T14:00:23.673008+03:00	4	614	{}	[512]	0	1403	1	2				1
626	[]	Parkour- Sali	Parkoursal	Parkour hall	500	2018-08-07T14:00:23.737371+03:00	4	624	{}	[500]	0	1403	1	2			1
651	[]	Pyöräilyrata	Cykelåkningsbana	Velodrome	539	2018-08-07T14:00:23.920549+03:00	4	646	{}	[539]	0	1403	1	2			1
682	[]	Soutustadion	Roddstadion	Rowing stadium	643	2018-08-07T14:00:24.150686+03:00	4	677	{}	[643]	0	1403	2	2
683	[]	Vesihiihtoalue	Område för vattenskidåkning	Water ski area	777	2018-08-07T14:00:24.157225+03:00	4	677	{}	[777]	0	1403	1	2			1
691	[]	Kylpylä	Badinrättning	Spa	361	2018-08-07T14:00:24.210042+03:00	4	690	{}	[361]	0	1403		2			1	1
700	[]	Rantautumispaikka	Ilandstigningsplats	Boat dock	571	2018-08-07T14:00:24.275183+03:00	4	695	{}	[571]	0	1403	2	2
703	[]	Tupa	Stuga	Hut	721	2018-08-07T14:00:24.296823+03:00	4	695	{}	[721]	0	1403		2			1		1
727	[]	Kauppa	Butik	Store	142*256	2018-08-07T14:00:24.462954+03:00	5	725	{}	[256, 142]	0	1403	2	2
728	[]	Kioski	Kiosk	Kiosk	142*309	2018-08-07T14:00:24.470558+03:00	5	725	{}	[309, 142]	0	1403	2	2
741	[]	Kioskit	Kiosker	Kiosks	309	2018-08-07T14:00:24.527473+03:00	3	718	{}	[309]	0	1403	2	2
758	[]	Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät	stadsstyrelsens och stadsförvaltningens beredningsuppgifter	preparatory assignments for City Government and City Council	274	2018-08-07T14:00:30.769165+03:00	4	757	{}	[274]	0	1401	1	2						1
761	[]	Lautakunnat ja johtokunnat	Nämnder och direktioner	Committees and boards	386	2018-08-07T14:00:30.800171+03:00	4	757	{}	[386]	0	1401	1	2				1
762	[]	Valtuustoryhmät, kansalaislähetystöt	Stadsfullmäktigegrupper, medborgardelegationer	Council groups, public delegations	743	2018-08-07T14:00:30.809629+03:00	4	757	{}	[743]	0	1401	1	2				1
770	[771, 773, 774]	Avioliitto ja rekisteröity parisuhde	Äktenskap och registrering av partnerskap	Marriage and registered partnership		2018-08-07T14:00:30.869982+03:00	3	769	{}	[]	0	1401	1	2			1
771	[]	Avioehto	Äktenskapsförord	Prenuptial agreement	82	2018-08-07T14:00:30.878414+03:00	4	770	{}	[82]	0	1401	1	2			1
773	[]	Parisuhteen rekisteröinti	Registrering av partnerskap	Registration of partnerships	498	2018-08-07T14:00:30.891417+03:00	4	770	{}	[498]	0	1401	1	2			1
774	[]	Siviilivihkiminen	Civil vigsel	Civil marriage	628	2018-08-07T14:00:30.898033+03:00	4	770	{}	[628]	0	1401	1	2			1
776	[]	Kotikunta- ja väestötiedot	Uppgifter om hemkommun och befolkningsinformation	Municipality of residence and population information	335	2018-08-07T14:00:30.913192+03:00	3	769	{}	[335]	0	1401	1	2			1
777	[]	Kuluttajansuoja ja neuvonta	Konsumentskydd och rådgivning	Consumer protection and advice	347	2018-08-07T14:00:30.921943+03:00	3	769	{}	[347]	0	1401	1	2			1
778	[]	Nimiasiat	Namnärenden	Name matters	465	2018-08-07T14:00:30.930146+03:00	3	769	{}	[465]	0	1401	1	2			1
779	[]	Oikeusaputoimistot	Rättshjälpsbyråerna	Legal aid offices	476	2018-08-07T14:00:30.939138+03:00	3	769	{}	[476]	0	1401		2			1	1
780	[]	Perinnönjako	Arvskifte	Distribution of estate	508	2018-08-07T14:00:30.947784+03:00	3	769	{}	[508]	0	1401	1	2			1
838	[]	Selviämishoitoasema	Tillnyktringsstation	Detoxification centre	618	2018-08-07T14:00:28.067660+03:00	2	830	{}	[618]	0	783	1	2			1
841	[]	Etuuskäsittely	Förmånsbehandling	Benefit processing	167	2018-08-07T14:00:28.085946+03:00	2	839	{}	[167]	0	783	1	2			1
856	[]	Sovittelutoiminta	Medlingsverksamhet	Mitigation services	644	2018-08-07T14:00:28.189606+03:00	2	845	{}	[644]	0	783	1	2				1
860	[]	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:28.215634+03:00	1	783	{}	[636]	0	783	1	2				1
877	[]	kielikylpy englanti	språkbad, engelska	language immersion, English	663*292	2018-08-07T14:00:28.303776+03:00	4	870	{}	[663, 292]	0	1405		2			2
897	[903, 898]	Arabiankielinen päivähoito	Arabiskspråkig dagvård	Day care in Arabic	58	2018-08-07T14:00:28.436562+03:00	3	869	{}	[58]	0	1405	2	2
898	[]	päivähoito	dagvård	day care	58	2018-08-07T14:00:28.442943+03:00	4	897	{}	[58]	0	1405	2	2
913	[919, 914]	Espanjankielinen päivähoito	Spanskspråkig dagvård	Day care in Spanish	164	2018-08-07T14:00:28.527678+03:00	3	869	{}	[164]	0	1405	2	2
914	[]	päivähoito	dagvård	day care	164	2018-08-07T14:00:28.533814+03:00	4	913	{}	[164]	0	1405	2	2
919	[]	esiopetus	förskoleundervisning	pre-primary education	164*160	2018-08-07T14:00:28.559368+03:00	4	913	{}	[164, 160]	1	1405	2	2
937	[938]	Saksankielinen päivähoito	Tyskspråkig dagvård	Day care in German	614	2018-08-07T14:00:28.671882+03:00	3	869	{}	[614]	0	1405	2	2
938	[]	päivähoito	dagvård	day care	614	2018-08-07T14:00:28.681434+03:00	4	937	{}	[614]	0	1405	2	2
953	[959, 954]	Vironkielinen päivähoito	Estniskspråkig dagvård	Day care in Estonian	795	2018-08-07T14:00:28.794858+03:00	3	869	{}	[795]	0	1405	1	2			1
954	[]	päivähoito	dagvård	day care	795	2018-08-07T14:00:28.802386+03:00	4	953	{}	[795]	0	1405	1	2			1
982	[]	Puistotäti	Parktant	Park aunt	528	2019-03-05T14:30:09.685579+02:00	3	975	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[528]	0	1405	2	2
994	[]	Työterveyshuolto	Företagshälsovård	Occupational health care	726	2018-08-07T14:00:29.175755+03:00	1	986	{}	[726]	0	986	1	2			1
1011	[]	Kaupungin psykiatrinen sairaala	Stadens psykiatriska sjukhus	City Psychiatric Hospital	263	2018-08-07T14:00:29.322493+03:00	2	1009	{}	[263]	0	986	2	2
1014	[]	Päiväsairaala	Dagsjukhus	Day hospital	553	2018-08-07T14:00:29.349793+03:00	2	1009	{}	[553]	0	986		2			1	1
1016	[]	Synnytyssairaalat	Förlossningssjukhus	Maternity hospitals	667	2018-08-07T14:00:29.368533+03:00	2	1009	{}	[667]	0	986	1	2			1
1021	[]	HUS:n erikoissairaanhoito	HNS:s specialsjukvård	HUS specialised health care	440	2018-08-07T14:00:29.421431+03:00	2	1019	{}	[440]	0	986	2	2
1025	[]	Psykiatrinen perhehoito	Psykiatrisk familjevård	Psychiatric family care	523	2018-08-07T14:00:29.453053+03:00	2	1019	{}	[523]	0	986	2	2
1026	[]	Psykiatrinen päiväsairaala	Psykiatriskt dagsjukhus	Psychiatric day hospital	524	2018-08-07T14:00:29.460729+03:00	2	1019	{}	[524]	0	986	2	2
1027	[]	Psykoterapia	Psykoterapi	Psychotherapy	526	2018-08-07T14:00:29.469348+03:00	2	1019	{}	[526]	0	986	2	2
1044	[]	Silmätaudit	Ögonsjukdomar	Eye diseases	622	2018-08-07T14:00:29.630771+03:00	1	986	{}	[622]	0	986	1	2				1
1059	[]	Selviämishoitoasema	Tillnyktringsstation	Detoxification centre	618	2018-08-07T14:00:29.743322+03:00	2	1051	{}	[618]	0	986	1	2			1
1060	[]	Terveyspalvelujen sähköinen asiointi ja lomakkeet	Elektroniska tjänster och blanketter inom hälso- och sjukvården	Electronic services and forms related to health services	704	2018-08-07T14:00:29.759443+03:00	1	986	{}	[704]	0	986		2	1			1
1063	[]	Maanpuolustusyhdistykset	Försvarsföreningar	National defence associations	422	2018-08-07T14:00:29.780736+03:00	2	1062	{}	[422]	0	1061	2	2
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]	0	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]	0	1061	1	2			1
1096	[]	Esi- ja starttiopetus	Förskoleundervisning, startklasser	Pre-primary and start class education	595	2018-10-25T08:00:07.533093+03:00	3	1093	{}	[595]	1	1087		2			2
1252	[]	Seurakuntien ryhmät	Församlingarnas grupper	Groups organised by parishes	596*620	2018-08-07T14:00:26.734846+03:00	4	1249	{}	[620, 596]	1	1087	2	2
1288	[]	B-japani	B-japanska	B-Japanese	14891+16191+30091+38391+56691+61191+65891+77091+792*91	2018-10-25T08:00:08.673017+03:00	4	1271	{}	[792, 770, 658, 611, 566, 383, 300, 161, 148, 91]	1	1087	1	2				1
1290	[]	B-latina	B-latin	B-Latin	14893+16193+30093+38393+56693+61193+65893+77093+792*93	2018-10-25T08:00:08.690591+03:00	4	1271	{}	[792, 770, 658, 611, 566, 383, 300, 161, 148, 93]	1	1087	1	2				1
1315	[]	B-suomi	B-finska	B-Finnish	598*98	2018-08-07T14:00:27.199171+03:00	4	1303	{}	[598, 98]	1	1087	2	2
1317	[]	B-englanti	B-engelska	B-English	598*88	2018-08-07T14:00:27.214095+03:00	4	1303	{}	[598, 88]	1	1087	2	2
1328	[]	Painotettu lukio	Gymnasium med betoning	Specialised upper secondary school	598*493	2018-08-07T14:00:27.295727+03:00	3	1298	{}	[598, 493]	1	1087	2	2
1353	[1355, 1354]	Oppisopimuskoulutus	Läroavtalsutbildning	Apprenticeship training		2018-08-07T14:00:27.464000+03:00	1	1087	{}	[]	0	1087	1	2				1
1354	[]	Suomenkielinen oppisopimuskoulutus	Läroavtalsutbildning på finska	Apprenticeship training in Finnish	659	2018-08-07T14:00:27.469481+03:00	2	1353	{}	[659]	1	1087	1	2				1
1356	[1357]	Ammattikorkeakoulut	Yrkeshögskolor	Polytechnics	654	2018-08-07T14:00:27.483584+03:00	1	1087	{}	[654]	0	1087	1	2						1
1357	[]	Suomenkielinen ammattikorkeakoulukoulutus	Yrkeshögskoleutbildning på finska	Polytechnic education in Finnish	654	2018-08-07T14:00:27.490338+03:00	2	1356	{}	[654]	0	1087	1	2						1
1375	[]	Koulupsykologi	Skolpsykolog	School psychologist	343	2018-08-07T14:00:27.641064+03:00	2	1372	{}	[343]	0	1087		2				2
1379	[]	Perusopetuksen neuvonta	Kundbetjäning och rådgivning (grundläggande utbildning)	Customer service and information (basic education)	70	2018-08-07T14:00:27.673059+03:00	2	1378	{}	[70]	0	1087	1	2			1
1380	[]	Lukiokoulutuksen neuvonta	Kundbetjäning och rådgivning (gymnasieutbildning)	Customer service and information (general upper secondary education)	69	2018-08-07T14:00:27.679921+03:00	2	1378	{}	[69]	0	1087	1	2			1
2005	[]	Valtuustotalot	Fullmäktigehus	Council buildings	744	2018-08-07T14:00:30.401425+03:00	4	173	{}	[744]	0	1401		2			1			1