servicemap

Custom SQL query returning 18 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_inkoo" = :p0 order by 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	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_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ää
542	[543, 544, 545, 2198, 546, 2144]	Satamat ja laiturit	Hamn och bryggor	Harbours, piers and quays		2018-08-07T14:00:25.196186+03:00	3	541	{}	[]	1402	168	209				2								1					1				36							1
546	[]	Venesatamat	Båthamnar	Marinas	769	2018-08-07T14:00:25.230897+03:00	4	542	{}	[769]	1402	147	188				2								1					1				36							1
548	[]	Ulkoilusaaret	Friluftsöar	Recreational islands	735	2018-10-25T08:00:07.487309+03:00	4	547	{}	[735]	1402	54	69	1			2								1		1			1				9
558	[559, 564, 567, 572, 575, 577, 592, 597]	Maastoliikuntapaikat	Anläggningar för terrängidrott	Cross-country sports facilities		2018-08-07T14:00:23.281875+03:00	2	551	{}	[]	1403	151	443				5								1				1					118				153		9	5
577	[579, 580, 581, 582, 583, 584, 585, 586, 590]	Liikunta- ja ulkoilureitit	Idrotts- och friluftsleder	Sports and outdoor recreation routes		2018-08-07T14:00:23.400833+03:00	3	558	{}	[]	1403	132	401				3								1				1					105				147		9	3
584	[]	Luontopolku	Naturstig	Nature trail	413	2018-08-07T14:00:23.440979+03:00	4	577	{}	[413]	1403	12	41				1								1									24				1		1	1
633	[634, 639, 646, 654, 663]	Ulkokentät ja liikuntapuistot	Utomhusplaner och idrottsparker	Outdoor fields and sports parks		2018-08-07T14:00:23.790680+03:00	2	551	{}	[]	1403	1261	2383												1			1						636				457		4	23
654	[655, 656, 657, 658, 659, 660, 661, 662]	Pallokentät	Bollplaner	Ball games courts		2018-08-07T14:00:23.947305+03:00	3	633	{}	[]	1403	697	1266												1									283				273		1	11
658	[]	Lentopallokenttä	Volleybollplan	Volleyball court	392	2018-08-07T14:00:23.980139+03:00	4	654	{}	[392]	1403	46	86												1									10				28		1
705	[]	Venesatama	Serviceplats för båtfarare	Boating services	769	2018-08-07T14:00:24.310541+03:00	4	695	{}	[769]	1403	147	188				2								1					1				36							1
711	[]	Monikäyttöalue, jolla on virkistyspalveluita	Allaktivitetsområde med rekreationstjänster	Multipurpose area with recreational services	442	2018-08-07T14:00:24.344046+03:00	4	706	{}	[442]	1403	1	3				1								1
714	[]	Ulkoilualue	Friluftsområde	Outdoor area	733	2018-08-07T14:00:24.366593+03:00	4	706	{}	[733]	1403	2	24												1					3				17						1
717	[754, 718, 2173, 2028]	Matkailu ja tapahtumat	Turism och evenemang	Things to do		2020-03-06T18:32:07.102459+02:00	1	1403	{}	[]	1403	1973	2155				1	1	1			1	2	1	1		3		5	3				87				67	1	1	3	4
718	[2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753]	Matkailu	Turism	Tourism		2018-08-07T14:00:24.401683+03:00	2	717	{}	[]	1403	1880	2050				1	1	1			1	1	1	1		3		5	3				79				64	1	1	3	4
736	[]	Hotellit ja majoitus	Hotell och logi	Hotels and accommodation	197	2018-08-07T14:00:24.492255+03:00	3	718	{}	[197]	1403	89	115					1							1		1			2				7				13		1
986	[990, 1048, 995, 996, 997, 1028, 1042, 1017, 992, 1019, 999, 1004, 1043, 1041, 1051, 1000, 1039, 1018, 1009, 1044, 988, 998, 993, 991, 2190, 1060, 994]	Terveys	Hälsovård	Health care		2018-08-07T14:00:29.110723+03:00	0		{}	[]	986	556	949	1	4	1	2		4	1	1		3		1	1	5	9	4	4	2	8	2	122	1	6	2	183	5	2	12	2	2	2	1
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
2142	[]	Venesatamat	Båthamnar	Marinas	769	2018-08-07T14:00:25.242377+03:00	4	547	{}	[769]	1402	147	188				2								1					1				36							1