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 "root" = :p0 order by unit_count_total 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_sipoo	unit_count_municipality__unknown	unit_count_municipality_inkoo	unit_count_municipality_espoo	unit_count_municipality_mäntsälä	unit_count_municipality_vantaa	unit_count_municipality_vihti	unit_count_municipality_kauniainen
358	[]	Ooppera ja baletti	Operan och balett	Opera and ballet	479	2018-08-07T14:00:22.636644+03:00	3	352	{}	[479]	1403	1	1
391	[]	Futsal	Futsal	Futsal	170	2018-08-07T14:00:22.944059+03:00	3	368	{}	[170]	1403		1						1
453	[]	Pyöräkoulu	Cykelskola	Bicycle school	541	2018-08-07T14:00:23.119521+03:00	3	368	{}	[541]	1403	1	1
470	[]	Sähly	Innebandy	Floorball	670	2018-08-07T14:00:23.157134+03:00	3	368	{}	[670]	1403		1						1
496	[]	Koirametsät	Hundskogar	Forest dog runs	320	2018-08-07T14:00:22.725829+03:00	4	493	{}	[320]	1403	1	1
557	[]	Ravirata	Travbana	Horse racing track	578	2018-08-07T14:00:23.257255+03:00	4	553	{}	[578]	1403		1				1
560	[]	Ampumarata	Skjutbana	Open-air shooting range	54	2018-08-07T14:00:23.293024+03:00	4	559	{}	[54]	1403		1				1
561	[]	Ampumaurheilukeskus	Sportskyttecentrum	Shooting sports centre	55	2018-08-07T14:00:23.299465+03:00	4	559	{}	[55]	1403		1	1
562	[]	Jousiammuntamaastorata	Terrängbana för bågskytte.	Field archery course	212	2018-08-07T14:00:23.305715+03:00	4	559	{}	[212]	1403		1				1
564	[565]	Hyppyrimäet	Hoppbackar	Ski jumping hills		2018-08-07T14:00:23.318569+03:00	3	558	{}	[]	1403	1	1
565	[]	Harjoitushyppyrimäki	Träningshoppbacke	Ski jumping hill for training	186	2018-08-07T14:00:23.324523+03:00	4	564	{}	[186]	1403	1	1
568	[]	Curlingrata	Curlingbana	Curling sheet	129	2018-08-07T14:00:23.345064+03:00	4	567	{}	[129]	1403	1	1
569	[]	Hiihtotunneli	Skidtunnel	Ski tunnel	194	2018-08-07T14:00:23.351595+03:00	4	567	{}	[194]	1403	1	1
585	[]	Maastopyöräilyreitti	Mountainbikeled	Cross-country biking route	425	2018-08-07T14:00:23.448007+03:00	4	577	{}	[425]	1403		1						1
586	[]	Melontareitti	Paddlingsled	Canoe route	434	2018-08-07T14:00:23.454892+03:00	4	577	{}	[434]	1403		1						1
593	[]	Ampumahiihdon harjoittelualue	Träningsområde för skidskytte	Training area for biathlon	52	2018-08-07T14:00:23.502563+03:00	4	592	{}	[52]	1403		1	1
594	[]	Ampumahiihtokeskus	Skidskyttecentrum	Biathlon centre	53	2018-08-07T14:00:23.509751+03:00	4	592	{}	[53]	1403		1				1
597	[600]	Suunnistusalueet	Orienteringsområden	Orienteering areas		2018-08-07T14:00:23.531981+03:00	3	558	{}	[]	1403		1						1
600	[]	Suunnistusalue	Orienteringsområde	Orienteering area	666	2018-08-07T14:00:23.551634+03:00	4	597	{}	[666]	1403		1						1
644	[]	Pikaluistelurata	Bana hastighetsåkning på skridsko	Speed-skating track	514	2018-08-07T14:00:23.862975+03:00	4	639	{}	[514]	1403	1	1
668	[]	Jokamies- ja rallicross -rata	Allemans- och rallycrossbana	Everyman racing and rallycross track	208	2018-08-07T14:00:24.052754+03:00	4	667	{}	[208]	1403		1						1
673	[]	Moottorirata	Motorbana	Formula race track	449	2018-08-07T14:00:24.087804+03:00	4	667	{}	[449]	1403	1	1
674	[]	Moottoriurheilukeskus	Centrum för motorsport	Motor sports centre	450	2018-08-07T14:00:24.095559+03:00	4	667	{}	[450]	1403		1						1
675	[676]	Urheiluilmailualueet	Områden för flygsport	Sport aviation areas		2018-08-07T14:00:24.102541+03:00	3	666	{}	[]	1403	1	1
676	[]	Urheiluilmailualue	Område för flygsport	Sport aviation area	739	2018-08-07T14:00:24.108363+03:00	4	675	{}	[739]	1403	1	1
681	[]	Soudun ja melonnan sisäharjoittelutila	Inomhusträningsutrymme för rodd och paddling	Indoor training facility for rowing and canoeing	642	2018-08-07T14:00:24.143385+03:00	4	677	{}	[642]	1403	1	1
712	[]	Muu luonnonsuojelualue, jolla on virkistyspalveluita	Annat naturskyddsområde med rekreationstjänster	Other nature conservation area with recreational services	458	2018-08-07T14:00:24.351095+03:00	4	706	{}	[458]	1403	1	1
716	[]	Virkistysmetsä	Friluftsskog	Recreational forest	791	2018-08-07T14:00:24.380867+03:00	4	706	{}	[791]	1403		1		1
724	[]	Luonnonvaraisten eläinten hoitola	Vårdanstalt för vilda djur	Wildlife home	411	2018-08-07T14:00:24.442228+03:00	4	719	{}	[411]	1403	1	1
726	[]	Kahvila	Café	Cafe	142*239	2018-08-07T14:00:24.455731+03:00	5	725	{}	[239, 142]	1403	1	1
729	[]	Ravintola	Restaurang	Restaurant	142*577	2018-08-07T14:00:24.477966+03:00	5	725	{}	[577, 142]	1403	1	1
743	[]	Leirintäalueet	Campingområden	Camping sites	390	2018-08-07T14:00:24.541305+03:00	3	718	{}	[390]	1403	1	1
2009	[]	Koiraurheiluhalli	Hundsporthall	Dog sports hall	323	2018-08-07T14:00:23.274980+03:00	4	2007	{}	[323]	1403	1	1
2151	[]	Liikunnan sähköinen asiointi ja lomakkeet	Elektroniska tjänster och formulär för motion	Electronic services and forms related to sports	849	2018-08-07T14:00:24.387923+03:00	2	551	{}	[849]	1403		1		1
2155	[]	Kasvitarha	Köksträdgård	Kitchen garden	853	2018-08-07T14:00:22.969353+03:00	3	368	{}	[853]	1403	1	1
2235	[]	Viheralueiden hoito	Skötsel av grönområden	Green area maintenance	787	2020-12-02T11:30:08.949266+02:00	3	491	{}	[787]	1403	1	1
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]	1403		2		1				1
381	[]	Demostudio	Demostudio	Demo studio	130	2018-08-07T14:00:22.931253+03:00	3	368	{}	[130]	1403	1	2						1
396	[]	Jalkapallo	Fotboll	Football	203	2018-08-07T14:00:22.956950+03:00	3	368	{}	[203]	1403		2						2
410	[]	Konsolipelit	Konsolspel	Console games	330	2018-08-07T14:00:23.006235+03:00	3	368	{}	[330]	1403	1	2						1
437	[]	Monistuspalvelu	Kopieringstjänst	Copying service	443	2018-08-07T14:00:23.067329+03:00	3	368	{}	[443]	1403	2	2
467	[]	Skeittaus	Skateboardåkning	Skateboarding	629	2018-08-07T14:00:23.144513+03:00	3	368	{}	[629]	1403	1	2						1
468	[]	Soitonopetus	Instrumentundervisning	Teaching music	632	2018-08-07T14:00:23.150860+03:00	3	368	{}	[632]	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]	1403		2						2
481	[]	Valokuvaus	Fotografering	Photography	741	2018-08-07T14:00:23.182310+03:00	3	368	{}	[741]	1403	1	2				1
485	[]	Viikonlopputoiminta	Veckoslutsverksamhet	Weekend activities	789	2018-08-07T14:00:23.188643+03:00	3	368	{}	[789]	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]	1403	2	2
511	[]	Tilaussaunat	Beställningsbastur	Reservation-only sauna	804	2018-08-07T14:00:22.844464+03:00	3	505	{}	[804]	1403	1	2				1
567	[568, 569]	Katetut talviurheilupaikat	Vintersportplatser under tak	Covered winter sports facilities		2018-08-07T14:00:23.339639+03:00	3	558	{}	[]	1403	2	2
618	[]	Petanque - halli	Petanquehall	Petanque hall	512	2018-08-07T14:00:23.673008+03:00	4	614	{}	[512]	1403	1	2						1
626	[]	Parkour- Sali	Parkoursal	Parkour hall	500	2018-08-07T14:00:23.737371+03:00	4	624	{}	[500]	1403	1	2				1
651	[]	Pyöräilyrata	Cykelåkningsbana	Velodrome	539	2018-08-07T14:00:23.920549+03:00	4	646	{}	[539]	1403	1	2				1
682	[]	Soutustadion	Roddstadion	Rowing stadium	643	2018-08-07T14:00:24.150686+03:00	4	677	{}	[643]	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]	1403	1	2				1
691	[]	Kylpylä	Badinrättning	Spa	361	2018-08-07T14:00:24.210042+03:00	4	690	{}	[361]	1403		2				1		1
700	[]	Rantautumispaikka	Ilandstigningsplats	Boat dock	571	2018-08-07T14:00:24.275183+03:00	4	695	{}	[571]	1403	2	2
703	[]	Tupa	Stuga	Hut	721	2018-08-07T14:00:24.296823+03:00	4	695	{}	[721]	1403		2				1			1
727	[]	Kauppa	Butik	Store	142*256	2018-08-07T14:00:24.462954+03:00	5	725	{}	[256, 142]	1403	2	2
728	[]	Kioski	Kiosk	Kiosk	142*309	2018-08-07T14:00:24.470558+03:00	5	725	{}	[309, 142]	1403	2	2
741	[]	Kioskit	Kiosker	Kiosks	309	2018-08-07T14:00:24.527473+03:00	3	718	{}	[309]	1403	2	2
2154	[]	Teatteri	Teater	Theatre	852	2018-08-07T14:00:23.169545+03:00	3	368	{}	[852]	1403	1	2				1
2162	[]	Digitaalinen nuorisotyö	Digital ungdomsarbete	Digital youth work	859	2018-08-07T14:00:23.214339+03:00	2	365	{}	[859]	1403		2				1		1
2224	[]	Seniorisäpinät	Seniorisäpinät	Seniorisäpinät	903	2020-06-09T15:30:11.400501+03:00	3	2217	{}	[903]	1403	2	2
344	[]	Kasvitieteelliset puutarhat	Botaniska trädgårdar	Botanic gardens	248	2018-08-07T14:00:22.544317+03:00	2	343	{}	[248]	1403	3	3
438	[]	Moottorihalli	Motorhall	Motorhall	445	2018-08-07T14:00:23.074919+03:00	3	368	{}	[445]	1403	2	3						1
452	[]	Puutyö	Slöjd	Woodwork	534	2018-08-07T14:00:23.113213+03:00	3	368	{}	[534]	1403	2	3				1
473	[]	Tanssi	Dans	Dance	685	2018-08-07T14:00:23.163347+03:00	3	368	{}	[685]	1403		3				2		1
554	[]	Esteratsastuskenttä	Bana för banhoppning	Show jumping field	166	2018-08-07T14:00:23.236991+03:00	4	553	{}	[166]	1403	3	3
579	[]	Hevosreitti	Hästled	Horse track	190	2018-08-07T14:00:23.406242+03:00	4	577	{}	[190]	1403	2	3						1
595	[]	Hiihtomaa	Skidland	Cross-country ski park	192	2018-08-07T14:00:23.517563+03:00	4	592	{}	[192]	1403	3	3
596	[]	Kilpahiihtokeskus	Skidtävlingscentrum	Ski competition centre	307	2018-08-07T14:00:23.524927+03:00	4	592	{}	[307]	1403		3				1		2
620	[]	Skeittihalli	Skateboardhall	Skateboarding hall	631	2018-08-07T14:00:23.687502+03:00	4	614	{}	[631]	1403	2	3				1
661	[]	Rullakiekkokenttä	Inlinehockeyplan	Roller hockey field	585	2018-08-07T14:00:24.003615+03:00	4	654	{}	[585]	1403	2	3						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
730	[]	Vesibussilaiturit	Vattenbussbryggor	Water bus platforms	142*776	2018-08-07T14:00:24.485125+03:00	4	719	{}	[776, 142]	1403	3	3
739	[]	Kaupat ja myymälät	Butiker och affärer	Shops and outlets	256	2018-08-07T14:00:24.513136+03:00	3	718	{}	[256]	1403	2	3				1
740	[]	Kauppahallit	Saluhallar	Market halls	259	2018-08-07T14:00:24.520703+03:00	3	718	{}	[259]	1403	3	3
2026	[]	Kirjastoautopalvelut	Bokbussar	Mobile libraries	312	2018-08-07T14:00:22.565354+03:00	3	345	{}	[312]	1403	1	3				1		1
356	[]	Kurssitoiminta	Kursverksamhet	Courses	356	2018-08-07T14:00:22.623521+03:00	3	352	{}	[356]	1403		4				4
374	[]	Av- ja leirivälinelainaamo	Utlåning av AV-utrustning och campingutrustning	Loaning service for audiovisual and camping equipment	81	2018-08-07T14:00:22.905139+03:00	3	368	{}	[81]	1403	3	4				1
405	[]	Kesätoiminta	Sommarverksamhet	Summer activities	291	2018-08-07T14:00:22.992018+03:00	3	368	{}	[291]	1403	1	4	1			1		1
409	[]	Kokkikerho	Kockklubb	Cook club	325	2018-08-07T14:00:22.999540+03:00	3	368	{}	[325]	1403		4						4
455	[]	Pöytäjääkiekko	Bordshockey	Table hockey	555	2018-08-07T14:00:23.132016+03:00	3	368	{}	[555]	1403		4				3		1
504	[]	Ruoka - ja cateringpalvelut	Catering	Catering	587	2018-08-07T14:00:22.784722+03:00	2	343	{}	[587]	1403		4				2		2
573	[]	Kiipeilykallio	Klätterberg	Climbing rock	306	2018-08-07T14:00:23.375633+03:00	4	572	{}	[306]	1403		4				1		3
580	[]	Koirahiihtolatu	Spår för hundspann	Dog skijoring track	318	2018-08-07T14:00:23.413028+03:00	4	577	{}	[318]	1403	1	4						3
625	[]	Miekkailutila	Utrymme för fäktning	Fencing venue	439	2018-08-07T14:00:23.729643+03:00	4	624	{}	[439]	1403	3	4				1
656	[]	Jalkapallostadion	Fotbollsstadion	Football stadium	205	2018-08-07T14:00:23.964244+03:00	4	654	{}	[205]	1403	1	4				1		1		1
672	[]	Moottoripyöräilyalue	Område för motorcykelsport	Motorcycling area	448	2018-08-07T14:00:24.080942+03:00	4	667	{}	[448]	1403	1	4				1		2
697	[]	Laavu, kota tai kammi	Vindskydd eller kåta	Lean-to, goahti (Lapp tent shelter) or 'kammi' earth lodge	365	2018-08-07T14:00:24.250943+03:00	4	695	{}	[365]	1403		4						3	1
713	[]	Retkeilyalue	Utflyktsområde	Hiking area	581	2018-08-07T14:00:24.359089+03:00	4	706	{}	[581]	1403	2	4				1	1
723	[]	Lipunmyynti	Biljettförsäljning	Ticket sales	403	2018-08-07T14:00:24.435423+03:00	4	719	{}	[403]	1403	3	4		1
2223	[]	Senioripalloilu	Bollsport för seniorer	Ball games for seniors	899	2020-06-09T15:30:11.384469+03:00	3	2217	{}	[899]	1403	4	4
389	[]	Fillari- ja moottoripaja	Cykel- och motorverkstad	Workshop for bicycles and mopeds	168	2018-08-07T14:00:22.937466+03:00	3	368	{}	[168]	1403	4	5				1
403	[]	Keramiikka	Keramik	Pottery	287	2018-08-07T14:00:22.976243+03:00	3	368	{}	[287]	1403	2	5				3
418	[]	Kuvataide	Bildkonst	Visual arts	359	2018-08-07T14:00:23.020022+03:00	3	368	{}	[359]	1403	2	5				2				1
433	[]	Media	Media	Media	433	2018-08-07T14:00:23.060583+03:00	3	368	{}	[433]	1403	4	5				1
440	[]	Mopokerho	Mopedklubb	Moped club	452	2018-08-07T14:00:23.082022+03:00	3	368	{}	[452]	1403	2	5				2		1
495	[]	Koirakäymälät	Hundtoaletter	Dog toilets	319	2018-08-07T14:00:22.718157+03:00	4	493	{}	[319]	1403	5	5
497	[]	Koirauimarannat	Hundbadstränder	Dog beaches	321	2018-08-07T14:00:22.733778+03:00	4	493	{}	[321]	1403	4	5						1
670	[]	Karting-rata	Kartingbana	Kart circuit	245	2018-08-07T14:00:24.066651+03:00	4	667	{}	[245]	1403	2	5				1		2