service
60 rows where root_service_node = 1402
This data as json, CSV (advanced)
Suggested facets: keywords, unit_count_municipality_helsinki, unit_count_total, unit_count_municipality_espoo, unit_count_municipality_vantaa, unit_count_municipality_kauniainen
| id ▼ | name_fi | name_sv | name_en | period_enabled | clarification_enabled | keywords | root_service_node | 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_null | unit_count_municipality_nurmijärvi | unit_count_municipality_virolahti | unit_count_municipality_pornainen | unit_count_municipality_hämeenlinna | unit_count_municipality_salo | 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_kotka | unit_count_municipality_askola | 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_karkkila | unit_count_municipality_järvenpää | unit_count_municipality_kerava | unit_count_municipality_pyhtää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | ajoneuvojen siirrot | flyttningar av fordon | towing vehicles | 0 | 0 | {} | 1402 | 2 | 5 | 1 | 2 | |||||||||||||||||||||||||||||||
| 60 | asemakaava-arkisto | detaljplanearkiv | town plan archive | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 63 | asiakaspalvelu (joukkoliikenne) | kundtjänst (kollektivtrafik) | customer services (public transport) | 0 | 0 | {} | 1402 | 5 | 11 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||
| 65 | asiakaspalvelu (kaupunginarkisto) | kundtjänst (stadsarkivet) | customer services (city archives) | 0 | 0 | {} | 1402 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 68 | asiakaspalvelu ja neuvonta (ammatillinen koulutus) | kundbetjäning och rådgivning (yrkesutbildning) | customer service and information (vocational education and training) | 0 | 0 | {} | 1402 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
| 69 | asiakaspalvelu ja neuvonta (lukiokoulutus) | kundbetjäning och rådgivning (gymnasieutbildning) | customer service and information (general upper secondary education) | 0 | 0 | {} | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 70 | asiakaspalvelu ja neuvonta (perusopetus) | kundbetjäning och rådgivning (grundläggande utbildning) | customer service and information (basic education) | 0 | 0 | {} | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 71 | asiakaspalvelu ja neuvonta (sosiaali- ja terveyspalvelut) | kundbetjäning och rådgivning (social- och hälsovårdstjänster) | customer service and information (social and health care services) | 0 | 0 | {} | 1402 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
| 73 | asukaspysäköintitunnukset | boendeparkeringstillstånd | resident parking permits | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 155 | erikoiskirjastot | specialbibliotek | special libraries | 0 | 0 | {"fi": ["kirjastot"]} | 1402 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
| 183 | hallinto (vesiliikenteen satamat) | förvaltning (hamnar för båttrafiken) | administration (water traffic harbours) | 0 | 0 | {} | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 207 | johtotietopalvelu ja maanalaisten tilojen tietopalvelu | ledningstjänst och information om underjordiska utrymmen | information service on cabling and underground facilities | 0 | 0 | {} | 1402 | 2 | 6 | 1 | 3 | |||||||||||||||||||||||||||||||
| 209 | joukkoliikennepysäkit | kollektivtrafikens hållplatser | public transport stops | 0 | 0 | {} | 1402 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
| 210 | joukkoliikenteen liikkumisen ohjaus | mobilitetsstyrning av kollektivtrafiken | public transport movement control | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 216 | julkisen liikenteen varikot | kollektivtrafikens depåer | public transport depots | 0 | 0 | {} | 1402 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
| 242 | kansainvälisten risteilyalusten laiturit | kajer för internationella kryssningsfartyg | piers for international cruisers | 0 | 0 | {} | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
| 247 | karttapalvelut, ilmakuvat ja karttojen tilaus | karttjänster, flygbilder och beställning av kartor | mapping services, aerial photographs and ordering maps | 0 | 0 | {} | 1402 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
| 249 | katu-, maa- ja viherrakentamispalvelut | tjänster inom gatu-, mark- och grönbyggnad | construction services for streets, land and parks | 0 | 0 | {} | 1402 | 1 | 5 | 4 | ||||||||||||||||||||||||||||||||
| 250 | katu-, puisto- ja rakennuspiirustusten arkisto | arkiv för gatu-, park- och byggnadsritningar | public works department archive | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 253 | katujen puhtaanapito ja talvikunnossapito | renhållning och vinterunderhåll av gator | street cleaning and winter maintenance | 0 | 0 | {} | 1402 | 1 | 6 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
| 305 | kiinteistörekisteri | fastighetsregister | real estate register | 0 | 0 | {} | 1402 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
| 337 | kotiseutuarkisto | hembygdsarkivet | archive of local heritage | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 395 | liikennesuunnittelu | trafikplanering | traffic planning | 0 | 0 | {} | 1402 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 398 | liikenteenhallintakeskus | trafikledningscentral | urban traffic control centre | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 404 | lipunmyynti (joukkoliikenne) | biljettförsäljning (kollektivtrafik) | ticket sales (public transport) | 0 | 0 | {} | 1402 | 4 | 8 | 3 | 1 | |||||||||||||||||||||||||||||||
| 431 | matkalippujen tarkastus | biljettkontroll | ticket inspection | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 437 | metroasemat | metrostationer | metro stations | 0 | 0 | {} | 1402 | 72 | 88 | 16 | ||||||||||||||||||||||||||||||||
| 483 | opastusta tietokoneen käytössä (digineuvonta) | handledning i datoranvändning (digital handledning) | guidance on using a computer (digital guidance) | 0 | 0 | {"fi": ["digiopastus", "digituki"], "en": ["digital quidance", "digital support"], "sv": ["digitalt r\u00e5dgivning", "digitalt st\u00f6d"]} | 1402 | 59 | 62 | 3 | ||||||||||||||||||||||||||||||||
| 492 | paikkatietoaineistot ja -neuvonta | rådgivning och material inom geografisk information | location information guidance and archives | 0 | 0 | {} | 1402 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
| 535 | pysäköinninvalvonta | parkeringsövervakning | parking control | 0 | 0 | {} | 1402 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 536 | pysäköintilippuautomaatit | parkeringsbiljettautomater | parking ticket machines | 0 | 0 | {} | 1402 | 557 | 557 | |||||||||||||||||||||||||||||||||
| 537 | pysäköintitalot ja -tilat | parkeringshus och -lokaler | parking halls and facilities | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 561 | rakennusvalvonnan arkisto | byggnadstillsynens arkiv | building control archive | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 576 | rautatieasemat | järnvägsstationer | railway stations | 0 | 0 | {} | 1402 | 16 | 41 | 9 | 14 | 2 | ||||||||||||||||||||||||||||||
| 669 | sähköautojen latauspisteet | laddningsstationer för elbilar | charging stations for electric vehicles | 0 | 0 | {} | 1402 | 31 | 37 | 6 | ||||||||||||||||||||||||||||||||
| 689 | tarjolla multimedialaitteita | multimediautrustning tillgänglig | multimedia equipment | 0 | 0 | {} | 1402 | 7 | 7 | |||||||||||||||||||||||||||||||||
| 690 | tarjolla puhesyntetisaattori | talsyntetisator tillgänglig | speech synthesizer available | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 691 | tarjolla skanneri | skanner tillgänglig | scanner available | 0 | 0 | {} | 1402 | 43 | 45 | 2 | ||||||||||||||||||||||||||||||||
| 692 | tarjolla tulostin | skrivare tillgänglig | printer available | 0 | 0 | {} | 1402 | 52 | 54 | 2 | ||||||||||||||||||||||||||||||||
| 708 | tietokoneopetus (kurssimuotoinen) | datorundervisning (i kursform) | computer guidance courses | 0 | 0 | {} | 1402 | 15 | 16 | 1 | ||||||||||||||||||||||||||||||||
| 709 | tilastot ja tietopalvelut | statistiker och informationstjänster | statistics and information services | 0 | 0 | {} | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 710 | tilausliikenne | chartertrafik | charter traffic | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 735 | ulkoilusaaret | friluftsöar | recreational islands | 0 | 0 | {} | 1402 | 54 | 69 | 1 | 2 | 1 | 1 | 1 | 9 | |||||||||||||||||||||||||||
| 768 | veneiden talvisäilytys | vinterförvaring av båtar | winter storage of boats | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 769 | venesatamat | båthamnar | marinas | 0 | 0 | {} | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
| 780 | vesikulkuneuvorekisteri | farkostregister | register of ships | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 782 | vesiliikenteen satamien terminaalit | terminaler i hamnarna för vattentrafik | water traffic terminals | 0 | 0 | {} | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
| 806 | wlan-sisäpisteet | wlan-inomhusstationer | WLAN inlets | 0 | 0 | {} | 1402 | 223 | 230 | 7 | ||||||||||||||||||||||||||||||||
| 807 | wlan-ulkopisteet | wlan-utomhusstationer | WLAN outlets | 0 | 0 | {} | 1402 | 10 | 10 | |||||||||||||||||||||||||||||||||
| 809 | asiointipisteet, yleisneuvonta ja yhteispalvelu | servicepunkter, allmän rådgivning och samservicekontor | service points, general information services and citizen's offices | 0 | 0 | {"fi": ["palvelupiste"]} | 1402 | 2 | 11 | 6 | 3 | |||||||||||||||||||||||||||||||
| 814 | yleiset pysäköintialueet | allmänna parkeringsområden | public parking lots | 0 | 0 | {} | 1402 | 1 | 346 | 343 | 2 | |||||||||||||||||||||||||||||||
| 834 | yrityspysäköintitunnukset | företagsparkeringstillstånd | business parking permits | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 847 | venekerhojen venepaikat | båtklubbarnas båtplatser | boat clubs' berths | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 848 | tietotekniikkaneuvonta (opiskelijoille) | IT rådgivning för studenter | IT consultancy for students | 0 | 0 | {} | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 856 | asiakaspalvelu ja neuvonta (tekniset ja ympäristöpalvelut) | kundbetjäning och rådgivning (teknisk och miljötjänster) | customer service and advice (technical and environmental services) | 0 | 0 | {} | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 874 | asiakaspalvelu ja neuvonta (vapaa sivistystyö) | kundbetjäning och rådgivning (fritt bildningsarbete) | customer service and information (liberal adult education) | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
| 880 | korkeakoulujen kirjastot | högskolebibliotek | polytechnic libraries | 0 | 0 | {} | 1402 | 8 | 14 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||
| 881 | veneiden lyhytaikainen kiinnittyminen | kortvarig förtöjning av båtar | short-term mooring of boats | 0 | 0 | {} | 1402 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 885 | yhteiskäyttöautojen pysäköintipaikat | bilpoolparkering | parking for car share vehicles | 0 | 0 | {} | 1402 | 22 | 22 | |||||||||||||||||||||||||||||||||
| 887 | esteettömät autopaikat kadulla | p-plats för personer med rörelsehinder bredvid gatan | accessible parking space along street | 0 | 0 | {} | 1402 | 94 | 94 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [service] ( [name_fi] TEXT, [name_sv] TEXT, [name_en] TEXT, [id] INTEGER PRIMARY KEY, [period_enabled] INTEGER, [clarification_enabled] INTEGER, [keywords] TEXT, [root_service_node] INTEGER, [unit_count_municipality_helsinki] INTEGER, [unit_count_total] INTEGER, [unit_count_municipality_hanko] TEXT, [unit_count_municipality_raasepori] TEXT, [unit_count_municipality_siuntio] TEXT, [unit_count_municipality_sipoo] TEXT, [unit_count_municipality_janakkala] TEXT, [unit_count_municipality_null] INTEGER, [unit_count_municipality_nurmijärvi] TEXT, [unit_count_municipality_virolahti] TEXT, [unit_count_municipality_pornainen] TEXT, [unit_count_municipality_hämeenlinna] TEXT, [unit_count_municipality_salo] TEXT, [unit_count_municipality_lapinjärvi] TEXT, [unit_count_municipality_inkoo] TEXT, [unit_count_municipality_miehikkälä] TEXT, [unit_count_municipality_porvoo] TEXT, [unit_count_municipality_lohja] TEXT, [unit_count_municipality_tuusula] TEXT, [unit_count_municipality_kirkkonummi] TEXT, [unit_count_municipality_hamina] TEXT, [unit_count_municipality_kouvola] TEXT, [unit_count_municipality_loviisa] TEXT, [unit_count_municipality_espoo] INTEGER, [unit_count_municipality_kotka] TEXT, [unit_count_municipality_askola] TEXT, [unit_count_municipality_mäntsälä] TEXT, [unit_count_municipality_vantaa] INTEGER, [unit_count_municipality_hyvinkää] TEXT, [unit_count_municipality_vihti] TEXT, [unit_count_municipality_kauniainen] INTEGER, [unit_count_municipality_karkkila] TEXT, [unit_count_municipality_järvenpää] TEXT, [unit_count_municipality_kerava] TEXT, [unit_count_municipality_pyhtää] TEXT );