service_node
1,140 rows sorted by level descending
This data as json, CSV (advanced)
Suggested facets: level, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_loviisa, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, unit_count_municipality_hyvinkää, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, last_modified_time (date)
| 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 259 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.226278+03:00 | 5 | 258 | {} | [799] | 0 | 1400 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
| 260 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:22.232800+03:00 | 5 | 258 | {} | [326] | 0 | 1400 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
| 261 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:22.239469+03:00 | 5 | 258 | {} | [214] | 0 | 1400 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
| 263 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:22.252638+03:00 | 5 | 258 | {} | [803] | 0 | 1400 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
| 264 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.259199+03:00 | 5 | 258 | {} | [804] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 267 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:22.293996+03:00 | 5 | 265 | {} | [494] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 268 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:22.300791+03:00 | 5 | 265 | {} | [706] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 269 | [] | Vihertukkutilojen vuokraus | Uthyrning av lokaler för grönsaksgrossister | Green wholesale trade space rental | 788 | 2018-08-07T14:00:22.308088+03:00 | 5 | 265 | {} | [788] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 304 | [] | Tiedotus | Information | Information distribution | 50 | 2018-08-07T14:00:22.521378+03:00 | 5 | 303 | {} | [50] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 335 | [] | Multimedialaitteita | Multimediautrustning | Multimedia equipment | 689 | 2018-08-07T14:00:24.911616+03:00 | 5 | 334 | {} | [689] | 0 | 1402 | 7 | 7 | |||||||||||||||||||||||||||||||||
| 337 | [] | Skanneri | Skanner | Scanner | 691 | 2018-08-07T14:00:24.926601+03:00 | 5 | 334 | {} | [691] | 0 | 1402 | 43 | 45 | 2 | ||||||||||||||||||||||||||||||||
| 338 | [] | Tulostin | Skrivare | Printer | 692 | 2018-10-25T08:00:07.357556+03:00 | 5 | 334 | {} | [692] | 0 | 1402 | 52 | 54 | 2 | ||||||||||||||||||||||||||||||||
| 340 | [] | Kurssimuotoista tietokoneopetusta | Kursformad datorundervisning | Computer guidance courses | 708 | 2018-10-25T08:00:07.368287+03:00 | 5 | 339 | {} | [708] | 0 | 1402 | 15 | 16 | 1 | ||||||||||||||||||||||||||||||||
| 341 | [] | Opastusta tietokoneen käytössä (digineuvonta) | Handledning i datoranvändning (digital handledning) | Guidance on using a computer (digital guidance) | 483 | 2020-05-25T11:30:10.362485+03:00 | 5 | 339 | {"sv": ["digitalt st\u00f6d", "digitalt r\u00e5dgivning"], "fi": ["digiopastus", "digituki"], "en": ["digital quidance", "digital support"]} | [483] | 0 | 1402 | 59 | 62 | 3 | ||||||||||||||||||||||||||||||||
| 726 | [] | Kahvila | Café | Cafe | 142*239 | 2018-08-07T14:00:24.455731+03:00 | 5 | 725 | {} | [239, 142] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 727 | [] | Kauppa | Butik | Store | 142*256 | 2018-08-07T14:00:24.462954+03:00 | 5 | 725 | {} | [256, 142] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 728 | [] | Kioski | Kiosk | Kiosk | 142*309 | 2018-08-07T14:00:24.470558+03:00 | 5 | 725 | {} | [309, 142] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 729 | [] | Ravintola | Restaurang | Restaurant | 142*577 | 2018-08-07T14:00:24.477966+03:00 | 5 | 725 | {} | [577, 142] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 2021 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:22.272146+03:00 | 5 | 265 | {} | [393] | 0 | 1400 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
| 2022 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:22.279273+03:00 | 5 | 265 | {} | [718] | 0 | 1400 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 2023 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:22.286375+03:00 | 5 | 265 | {} | [765] | 0 | 1400 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 2210 | [] | Asukastilat | Invånarlokaler | Resident facilities | 888 | 2019-10-22T09:30:07.230470+03:00 | 5 | 258 | {} | [888] | 0 | 1400 | 1 | 12 | 2 | 9 | |||||||||||||||||||||||||||||||
| 63 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:21.380622+03:00 | 4 | 62 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1400 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
| 64 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:21.387379+03:00 | 4 | 62 | {} | [319] | 0 | 1400 | 5 | 5 | |||||||||||||||||||||||||||||||||
| 65 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.393701+03:00 | 4 | 62 | {} | [320] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 66 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:21.400222+03:00 | 4 | 62 | {} | [321] | 0 | 1400 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
| 67 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.407013+03:00 | 4 | 62 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 69 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.276314+02:00 | 4 | 68 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1400 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
| 70 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:21.425954+03:00 | 4 | 68 | {} | [389] | 0 | 1400 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
| 150 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:30.186216+03:00 | 4 | 149 | {} | [799] | 0 | 1401 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
| 151 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:30.193967+03:00 | 4 | 149 | {} | [326] | 0 | 1401 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
| 152 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:30.200626+03:00 | 4 | 149 | {} | [214] | 0 | 1401 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
| 154 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:30.213017+03:00 | 4 | 149 | {} | [803] | 0 | 1401 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
| 155 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:30.219845+03:00 | 4 | 149 | {} | [804] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 157 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:30.231632+03:00 | 4 | 156 | {} | [393] | 0 | 1401 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
| 158 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:30.238264+03:00 | 4 | 156 | {} | [718] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 159 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:30.247429+03:00 | 4 | 156 | {} | [765] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 160 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:30.257660+03:00 | 4 | 156 | {} | [494] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 161 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:30.270249+03:00 | 4 | 156 | {} | [706] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 162 | [] | Vihertukkutilojen vuokraus | Uthyrning av lokaler för grönsaksgrossister | Green wholesale trade space rental | 788 | 2018-08-07T14:00:30.280128+03:00 | 4 | 156 | {} | [788] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 199 | [] | kirjanpito | bokföring | accounting | 675 | 2018-08-07T14:00:30.577311+03:00 | 4 | 198 | {} | [675] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 200 | [] | laskutuksen asiakasmaksut | faktureringens kundavgifter | customer payments for invoicing | 674 | 2018-08-07T14:00:30.584039+03:00 | 4 | 198 | {} | [674] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 201 | [] | laskutus | fakturering | invoicing | 676 | 2018-08-07T14:00:30.590863+03:00 | 4 | 198 | {} | [676] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 202 | [] | maksukattoasiat | betalningstakärenden | issues regarding payment limits | 677 | 2018-08-07T14:00:30.597368+03:00 | 4 | 198 | {} | [677] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 203 | [] | maksuliikenne | penningrörelse | payment transactions | 678 | 2018-08-07T14:00:30.605414+03:00 | 4 | 198 | {} | [678] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 204 | [] | ostolaskut | köpfakturor | incoming invoices | 679 | 2018-08-07T14:00:30.612437+03:00 | 4 | 198 | {} | [679] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 205 | [] | palkanlaskenta | löneräkning | payroll administration | 680 | 2018-08-07T14:00:30.620039+03:00 | 4 | 198 | {} | [680] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 206 | [] | suoritukset | betalningar | payments | 681 | 2018-08-07T14:00:30.628457+03:00 | 4 | 198 | {} | [681] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 207 | [] | täsmäykset | avstämningar | synchronisation | 682 | 2018-08-07T14:00:30.636668+03:00 | 4 | 198 | {} | [682] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 208 | [] | yleisökassa | kassa för allmänheten | public fund | 269 | 2018-08-07T14:00:30.645432+03:00 | 4 | 198 | {} | [269] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 210 | [] | antolainat | utlåning | advances | 260 | 2018-08-07T14:00:30.661409+03:00 | 4 | 209 | {} | [260] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 211 | [] | henkilöstökassa | personalkassa | personnel fund | 262 | 2018-08-07T14:00:30.669740+03:00 | 4 | 209 | {} | [262] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 213 | [] | konserniohjaus | koncernstyrning | consolidated corporation guidance | 227 | 2018-08-07T14:00:30.685091+03:00 | 4 | 209 | {} | [227] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 227 | [] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 395 | 2018-08-07T14:00:22.030360+03:00 | 4 | 226 | {} | [395] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 228 | [] | Liikenteen ohjaus, liikennevalot | Trafikstyrning, trafikljus | Traffic control, traffic lights | 396+397 | 2018-10-24T23:30:05.577987+03:00 | 4 | 226 | {} | [397, 396] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 234 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 178 | 2020-12-02T12:30:08.656880+02:00 | 4 | 233 | {} | [178] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 235 | [] | Hankepalvelut | Projekttjänster | Project services | 185 | 2018-08-07T14:00:22.084046+03:00 | 4 | 233 | {} | [185] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 237 | [] | Maastomittauspalvelut | Terrängmätning | Field surveying services | 424 | 2018-08-07T14:00:22.090579+03:00 | 4 | 233 | {} | [424] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 247 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:22.149025+03:00 | 4 | 245 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
| 248 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:22.155735+03:00 | 4 | 245 | {} | [267] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 249 | [] | Asuntotonttien vuokraus ja myynti | Uthyrning och försäljning av bostadstomter | Selling or renting residential lots | 78 | 2018-08-07T14:00:22.162414+03:00 | 4 | 245 | {} | [78] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 250 | [] | Liike- ja toimistotonttien vuokraus ja myynti | Arrendering och försäljning av affärs- och kontorstomter | Leasing and selling of commercial and office plots | 394 | 2018-08-07T14:00:22.168975+03:00 | 4 | 245 | {} | [394] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 251 | [] | Maa-alueiden vuokraus ja myynti | Uthyrning och försäljning av markområden | Selling or renting land areas | 419 | 2018-08-07T14:00:22.176075+03:00 | 4 | 245 | {} | [419] | 0 | 1400 | 17 | 17 | |||||||||||||||||||||||||||||||||
| 256 | [] | Kauppahallimyyntipaikkojen vuokraus | Uthyrning av försäljningsplatser i saluhallar | Market hall sales location leasing | 258 | 2018-08-07T14:00:22.208042+03:00 | 4 | 255 | {} | [258] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 257 | [] | Torimyyntipaikkojen vuokraus | Uthyrning av torgförsäljningsplatser | Market square vending stall rental | 713 | 2018-08-07T14:00:22.214641+03:00 | 4 | 255 | {} | [713] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 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 | {} | [] | 0 | 1400 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
| 273 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:22.333741+03:00 | 4 | 272 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 274 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:22.341217+03:00 | 4 | 272 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 275 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:22.348354+03:00 | 4 | 272 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 281 | [] | Jatkuva valvonta | Kontinuerlig tillsyn | Continuous monitoring | 562 | 2018-08-07T14:00:22.381961+03:00 | 4 | 279 | {} | [562] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 282 | [] | Rakennus- ja toimenpideluvat | Bygglov och åtgärdstillstånd | Licences for construction and operations | 558 | 2018-08-07T14:00:22.390024+03:00 | 4 | 279 | {} | [558] | 0 | 1400 | 1 | 5 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
| 283 | [] | Rakennusrasitteet | Byggnadsservitut | Building easements | 559 | 2018-08-07T14:00:22.397931+03:00 | 4 | 279 | {} | [559] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 284 | [] | Rakennustöiden viranomaisvalvonta | Myndighetstillsyn av byggarbeten | Official oversight of construction work | 560 | 2018-08-07T14:00:22.405256+03:00 | 4 | 279 | {} | [560] | 0 | 1400 | 2 | 6 | 1 | 3 | |||||||||||||||||||||||||||||||
| 285 | [] | Rakennusvalvontamittaukset | Byggnadstillsynsmätningar | Building control measurements | 563 | 2018-08-07T14:00:22.411827+03:00 | 4 | 279 | {} | [563] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 289 | [] | Kaupungin toimitilojen suunnittelu | Planering av stadens lokaliteter | Planning city premises | 266 | 2018-08-07T14:00:22.438154+03:00 | 4 | 287 | {} | [266] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 290 | [] | Kilpipalvelut | Skylttjänster | Sign services | 481 | 2018-08-07T14:00:22.444787+03:00 | 4 | 287 | {} | [481] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 291 | [] | Materiaalipalvelut | Materialservice | Material services | 564 | 2018-08-07T14:00:22.451320+03:00 | 4 | 287 | {} | [564] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 292 | [] | Pohja- ja kalliorakennussuunnittelu | Planering av grund- och bergsbyggnad | Foundation and rock engineering | 516 | 2018-08-07T14:00:22.458169+03:00 | 4 | 287 | {} | [516] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 295 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:22.470442+03:00 | 4 | 293 | {} | [233] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 296 | [] | Mullan myynti ja toimitus | Försäljning och leverans av mylla | Selling and delivering soil | 453 | 2018-08-07T14:00:22.477143+03:00 | 4 | 293 | {} | [453] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 299 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:22.497732+03:00 | 4 | 293 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 301 | [] | Vesilaskut ja asiakaspalvelu | Vattenfakturering och kundtjänst | Billing for water and customer services | 67+781 | 2018-10-25T08:00:06.456994+03:00 | 4 | 293 | {} | [781, 67] | 0 | 1400 | 26 | 26 | |||||||||||||||||||||||||||||||||
| 303 | [304] | Aluerakentaminen | Områdesbyggandet | Regional construction | 2018-08-07T14:00:22.515802+03:00 | 4 | 302 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 318 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:24.764164+03:00 | 4 | 2147 | {} | [71] | 0 | 1402 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
| 331 | [] | WLAN-sisäpisteet | WLAN-inomhusstationer | WLAN inlets | 806 | 2018-08-07T14:00:24.883321+03:00 | 4 | 330 | {} | [806] | 0 | 1402 | 223 | 230 | 7 | ||||||||||||||||||||||||||||||||
| 332 | [] | WLAN-ulkopisteet | WLAN-utomhusstationer | WLAN outlets | 807 | 2018-08-07T14:00:24.889824+03:00 | 4 | 330 | {} | [807] | 0 | 1402 | 10 | 10 | |||||||||||||||||||||||||||||||||
| 334 | [335, 337, 338] | Tarjolla oheislaitteita | Kringutrustning finns | Supplementary equipment available | 2018-08-07T14:00:24.905778+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 54 | 56 | 2 | |||||||||||||||||||||||||||||||||
| 339 | [340, 341] | Tarjolla opastusta | Handledning ges | Guidance available | 2018-10-25T08:00:07.363024+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 60 | 64 | 1 | 3 | ||||||||||||||||||||||||||||||||
| 494 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:22.710417+03:00 | 4 | 493 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1403 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
| 495 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:22.718157+03:00 | 4 | 493 | {} | [319] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
| 496 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:22.725829+03:00 | 4 | 493 | {} | [320] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 497 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:22.733778+03:00 | 4 | 493 | {} | [321] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
| 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] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 500 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.940551+02:00 | 4 | 499 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1403 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
| 501 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:22.761746+03:00 | 4 | 499 | {} | [389] | 0 | 1403 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
| 543 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 183 | 2018-08-07T14:00:25.201364+03:00 | 4 | 542 | {} | [183] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 544 | [] | Kansainvälisten risteilyalusten laiturit | Kajer för internationella kryssningsfartyg | Piers for international cruisers | 242 | 2018-08-07T14:00:25.208722+03:00 | 4 | 542 | {} | [242] | 0 | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
| 545 | [] | Terminaalit | Terminaler | Terminals | 782 | 2018-08-07T14:00:25.217022+03:00 | 4 | 542 | {} | [782] | 0 | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
| 546 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.230897+03:00 | 4 | 542 | {} | [769] | 0 | 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] | 0 | 1402 | 54 | 69 | 1 | 2 | 1 | 1 | 1 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [service_node] ( [id] INTEGER PRIMARY KEY, [children] TEXT, [name_fi] TEXT, [name_sv] TEXT, [name_en] TEXT, [service_reference] TEXT, [last_modified_time] TEXT, [level] INTEGER, [parent] INTEGER, [keywords] TEXT, [related_services] TEXT, [period_enabled] INTEGER, [root] 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_nurmijärvi] TEXT, [unit_count_municipality_salo] TEXT, [unit_count_municipality_virolahti] TEXT, [unit_count_municipality_pornainen] TEXT, [unit_count_municipality_hämeenlinna] TEXT, [unit_count_municipality__unknown] 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] INTEGER, [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_askola] TEXT, [unit_count_municipality_kotka] TEXT, [unit_count_municipality_mäntsälä] TEXT, [unit_count_municipality_vantaa] INTEGER, [unit_count_municipality_hyvinkää] INTEGER, [unit_count_municipality_vihti] TEXT, [unit_count_municipality_kauniainen] TEXT, [unit_count_municipality_järvenpää] TEXT, [unit_count_municipality_kerava] TEXT, [unit_count_municipality_karkkila] TEXT, [unit_count_municipality_pyhtää] TEXT );