servicemap

Custom SQL query returning 38 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_municipality_kauniainen" = :p0 order by name_sv 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_raasepori	unit_count_municipality_siuntio	unit_count_municipality_sipoo	unit_count_municipality_nurmijärvi	unit_count_municipality_virolahti	unit_count_municipality_pornainen	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ää
355	[]	Kulttuurin monitoimitalot	Allaktivitetshus för kultur	Multi-functional culture venues	345	2018-08-07T14:00:22.617002+03:00	3	352	{}	[345]	1403	8	18																3				5			2
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
532	[]	Yleiset pysäköintialueet	Allmänna parkeringsområden	Public parking lot	814	2018-08-07T14:00:25.132843+03:00	3	526	{}	[814]	1402	1	346																343							2
657	[]	Koripallokenttä	Basketplan	Basketball court	331	2018-08-07T14:00:23.971455+03:00	4	654	{}	[331]	1403	153	256																64				37			2
1083	[1084, 1086]	Väestönsuojat	Befolkningsskyddsrum	Public shelters		2018-08-07T14:00:29.937480+03:00	1	1061	{}	[]	1061	47	49																							2
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
1361	[1362, 1363]	Suomenkielinen työväenopisto	Finska arbetarinstitutet	Finnish adult education centre	665	2020-11-18T07:30:12.844488+02:00	2	1360	{}	[665]	1087	50	59																7							2
1371	[]	Kansanopisto	Folkhögskola	Folk high school	244	2020-11-18T07:30:12.932144+02:00	2	1360	{}	[244]	1087		3																1							2
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
611	[]	Kuntosali	Gym	Gym	350	2018-08-07T14:00:23.623495+03:00	4	608	{}	[350]	1403	151	237																45				39			2
150	[]	Harrastustilat	Hobbylokaler	Hobby facilities	799	2018-08-07T14:00:30.186216+03:00	4	149	{}	[799]	1401	3	8																2				1			2
259	[]	Harrastustilat	Hobbylokaler	Hobby facilities	799	2018-08-07T14:00:22.226278+03:00	5	258	{}	[799]	1400	3	8																2				1			2
506	[]	Harrastustilat	Hobbylokaler	Hobby facilities	799	2018-08-07T14:00:22.804088+03:00	3	505	{}	[799]	1403	3	8																2				1			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
647	[]	Liikuntapuisto	Idrottspark	Sports park	401	2018-08-07T14:00:23.890605+03:00	4	646	{}	[401]	1403		7																3				2			2
44	[]	Pahvinkeräys	Insamling av wellpapp	Corrugated cardboard recycling	491	2018-08-07T14:00:21.860147+03:00	3	34	{}	[491]	1400	2	7																1				2			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
520	[]	Rautatieasemat	Järnvägsstationer	Railway stations	576	2018-08-07T14:00:25.051739+03:00	3	513	{}	[576]	1402	16	41																9				14			2
515	[]	Joukkoliikennepysäkit	Kollektivtrafikens hållplatser	Public transport stops	209	2018-08-07T14:00:25.015254+03:00	3	513	{}	[209]	1402		3																1							2
1017	[]	Laboratorio	Laboratorium	Laboratory	366	2018-08-07T14:00:29.386729+03:00	1	986	{}	[366]	986	22	88	3	1	1	3	1	1	1	1	2	6	3	3	1	7	1	10	1	3	1	8	1	1	2	1	1	1	1
662	[]	Tenniskenttäalue	Område med tennisbanor	Tennis court area	700	2018-10-25T08:00:07.016431+03:00	4	654	{"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]}	[700]	1403	45	83																11				25			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
42	[]	Muovinkeräys	Plaståtervinning	Plastic recycling	454	2018-08-07T14:00:21.846516+03:00	3	34	{}	[454]	1400	23	70																29				16			2
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
1033	[]	Kuntoutussuunnittelu ja -ohjaus	Rehabiliteringsplanering och -handledning	Rehabilitation planning and guidance	355	2018-08-07T14:00:29.523750+03:00	2	1028	{}	[355]	986		4																1				1			2
824	[]	Vanhusten itsenäinen asuminen	Självständigt boende för äldre	Independent habitation for the elderly	757	2018-08-07T14:00:27.977916+03:00	2	819	{}	[757]	783		4																				2			2
642	[]	Luistelukenttä	Skridskobana	Ice-skating field	406	2018-08-07T14:00:23.848959+03:00	4	639	{}	[406]	1403	136	308																100				70			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
576	[]	Laskettelun suorituspaikat	Slalombackar och alpina skidcentra	Ski slopes and downhill ski resorts	376	2018-08-07T14:00:23.393272+03:00	4	575	{}	[376]	1403	2	6																2							2
820	[]	Vanhuspalvelun sosiaalityö	Socialt arbete inom äldreomsorgen	Service for the elderly, social work	764	2018-08-07T14:00:27.951192+03:00	2	819	{}	[764]	783	5	16																1				8			2
1365	[1366, 1368, 1367]	Ruotsinkielinen työväenopisto	Svenska arbetarinstitutet	Swedish adult education centre	605	2020-11-18T07:30:12.874521+02:00	2	1360	{}	[605]	1087	6	9																1							2
50	[]	Tekstiilien keräys	Textilåtervinning	Textile recycling	696	2018-08-07T14:00:21.906229+03:00	3	34	{}	[696]	1400	40	108																37				29			2
1043	[]	Omahoitotarvikejakelu	Utdelning av egenvårdsartiklar	Distribution of self-care supplies	477	2018-08-07T14:00:29.623935+03:00	1	986	{"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]}	[477]	986	1	6																				3			2
357	[]	Näyttelytilat	Utställningslokaler	Exhibition spaces	474	2018-08-07T14:00:22.630116+03:00	3	352	{}	[474]	1403	105	114																7							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
876	[]	kielikylpy ruotsi	språkbad, svenska	language immersion, Swedish	663*294	2018-08-07T14:00:28.297483+03:00	4	870	{}	[663, 294]	1405	9	19																5				3			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