servicemap

Custom SQL query returning 19 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_kirkkonummi" = :p0 order by last_modified_time 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_sipoo	unit_count_municipality_janakkala	unit_count_municipality_nurmijärvi	unit_count_municipality_hämeenlinna	unit_count_municipality__unknown	unit_count_municipality_lapinjärvi	unit_count_municipality_inkoo	unit_count_municipality_porvoo	unit_count_municipality_tuusula	unit_count_municipality_kirkkonummi	unit_count_municipality_espoo	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
221	[222, 231, 270, 305]	Kaavoitus, kiinteistöt ja rakentaminen	Planläggning, fastigheter och byggande	Planning, real estate and construction		2018-08-07T14:00:21.996119+03:00	1	1400	{}	[]	1400	367	506		1	1		1	1	1		3		2	54	69			6
231	[232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255]	Kiinteistöt ja rakennetut tilat	Fastigheter	Real estate		2018-08-07T14:00:22.059452+03:00	2	221	{}	[]	1400	311	427		1	1		1		1		2		2	48	55			5
255	[256, 257, 258, 265]	Tilojen vuokraus ja varaus	Uthyrning och reservering av lokaler	Renting out and reservation of facilities		2018-08-07T14:00:22.202500+03:00	3	231	{}	[]	1400	294	380		1	1		1		1		2		2	42	32			4
258	[2210, 259, 261, 260, 263, 264]	Vapaa-ajan tilojen vuokraus	Uthyrning av fritidslokaler	Renting recreational spaces		2018-08-07T14:00:22.220951+03:00	4	255	{}	[]	1400	292	375		1	1		1		1		2		2	40	31			4
260	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:22.232800+03:00	5	258	{}	[326]	1400	247	293		1	1		1				2		2	17	22
343	[344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503]	Kulttuuri ja vapaa-aika	Kultur och fritid	Culture and leisure		2018-08-07T14:00:22.539281+03:00	1	1403	{}	[]	1403	1745	2452		1	1	1	1	8	1		2	4	2	382	286	1		13	4
505	[2208, 506, 508, 507, 510, 511]	Vapaa-ajan tilojen vuokraus	Uthyrning av fritidslokaler	Renting recreational spaces		2018-08-07T14:00:22.797039+03:00	2	343	{}	[]	1403	292	375		1	1		1		1		2		2	40	31			4
507	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:22.812763+03:00	3	505	{}	[326]	1403	247	293		1	1		1				2		2	17	22
699	[]	Opastuspiste	Information punkt	Information point	482	2018-08-07T14:00:24.267790+03:00	4	695	{}	[482]	1403	51	73		1						2			2	14	2		1
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
742	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:24.534199+03:00	3	718	{}	[326]	1403	247	293		1	1		1				2		2	17	22
1402	[306, 512]	Liikenne ja kartat	Trafik och kartor	Traffic and maps		2018-08-07T14:00:24.647447+03:00	0		{}	[]	1402	1567	2238	1	4				1		2	1		2	581	71			8
512	[513, 521, 525, 526, 533, 534, 541]	Liikenne	Trafik	Traffic		2018-08-07T14:00:24.996122+03:00	1	1402	{}	[]	1402	1269	1864	1	4						2	1		2	540	39			6
541	[542, 547]	Vesiliikenne	Sjötrafik	Water traffic		2018-08-07T14:00:25.190941+03:00	2	512	{}	[]	1402	223	279	1	4						2	1		2	45				1
547	[548, 2199, 549, 2143, 2142]	Veneily	Båtsport	Boating		2018-08-07T14:00:25.237133+03:00	3	541	{}	[]	1402	206	262	1	4						2	1		2	45				1
122	[123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167]	Elinkeino, työ ja verotus	Näringar, arbete och beskattning	Entrepreneurship, work and taxation		2018-08-07T14:00:29.995212+03:00	1	1401	{}	[]	1401	322	452		2	1		1	2	1		2		2	51	62			5		1
146	[147, 148, 149, 156]	Tilojen vuokraus ja varaus	Uthyrning och reservering av lokaler	Renting out and reservation of facilities		2018-08-07T14:00:30.157480+03:00	2	122	{}	[]	1401	294	380		1	1		1		1		2		2	42	32			4
149	[2209, 150, 152, 151, 154, 155]	Vapaa-ajan tilojen vuokraus	Uthyrning av fritidslokaler	Renting recreational spaces		2018-08-07T14:00:30.179684+03:00	3	146	{}	[]	1401	292	375		1	1		1		1		2		2	40	31			4
151	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:30.193967+03:00	4	149	{}	[326]	1401	247	293		1	1		1				2		2	17	22