service_node
186 rows where root = 1400 sorted by name_sv
This data as json, CSV (advanced)
keywords ✖
| 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120 | [] | Ympäristöhaitat ja -luvat | Miljöolägenheter och -tillstånd | Environmental detriments and permits | 823 | 2018-08-07T14:00:21.667227+03:00 | 3 | 116 | {} | [823] | 0 | 1400 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 102 | [] | Ympäristöohjelmat | Miljöprogram | Environmental programmes | 829 | 2018-08-07T14:00:21.567791+03:00 | 2 | 1 | {} | [829] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 101 | [] | Ympäristöneuvonta | Miljörådgivning | Environmental information | 827 | 2018-08-07T14:00:21.561444+03:00 | 2 | 1 | {} | [827] | 0 | 1400 | 1 | 5 | 3 | 1 | |||||||||||||||||||||||||||||||
| 121 | [] | Ympäristönsuojelumääräykset | Miljöskyddsbestämmelser | Environmental protection regulations | 828 | 2018-08-07T14:00:21.673508+03:00 | 3 | 116 | {} | [828] | 0 | 1400 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 97 | [98, 99] | Ympäristön hoito | Miljövård | Maintenance of the environment | 825 | 2018-08-07T14:00:21.535829+03:00 | 2 | 1 | {} | [825] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 29 | [] | Ympäristölautakunta | Miljövårdsnämnden | Environment committee | 824 | 2018-08-07T14:00:21.318211+03:00 | 3 | 28 | {} | [824] | 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 | |||||||||||||||||||||||||||||||
| 79 | [] | Tierakenteiden tiiviys- ja kantavuusmittaus | Mätning av vägkonstruktioners täthet och bärkraft | Measuring the solidity and bearing capacity of road constructions | 707 | 2018-08-07T14:00:21.481992+03:00 | 3 | 74 | {} | [707] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||
| 229 | [] | Nimistönsuunnittelu | Namnplanering | Nomenclature planning | 466 | 2018-08-07T14:00:22.045496+03:00 | 3 | 222 | {} | [466] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 57 | [] | Luonnonsuojelu | Naturskydd | Environmental protection | 410 | 2018-08-07T14:00:21.330807+03:00 | 2 | 1 | {} | [410] | 0 | 1400 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 73 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:21.445519+03:00 | 2 | 1 | {} | [532] | 0 | 1400 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
| 303 | [304] | Aluerakentaminen | Områdesbyggandet | Regional construction | 2018-08-07T14:00:22.515802+03:00 | 4 | 302 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 60 | [61, 62, 68, 2236, 71, 72] | Puistot ja viheralueet | Parker och grönområden | Parks and green areas | 2018-08-07T14:00:21.354530+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 520 | 967 | 1 | 268 | 173 | 5 | ||||||||||||||||||||||||||||||
| 2236 | [] | Puistoshakkilaudat | Parkschackbräden | Park chess boards | 912 | 2020-09-01T15:30:06.145353+03:00 | 3 | 60 | {} | [912] | 0 | 1400 | 24 | 24 | |||||||||||||||||||||||||||||||||
| 225 | [] | Kaavat ja kaavoitus | Planer och planlägging | Town plans and zoning | 237 | 2018-08-07T14:00:22.018653+03:00 | 3 | 222 | {} | [237] | 0 | 1400 | 5 | 9 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 77 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:21.469668+03:00 | 3 | 74 | {} | [252] | 0 | 1400 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
| 277 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:22.362599+03:00 | 3 | 270 | {} | [252] | 0 | 1400 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
| 287 | [289, 290, 291, 292] | Suunnittelu- ja rakentamispalvelut | Planerings- och byggtjänster | Design and construction services | 2018-08-07T14:00:22.425144+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 5 | 7 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 222 | [223, 224, 225, 226, 229, 230] | Kaavoitus | Planläggning | Planning | 2018-08-07T14:00:22.001028+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 9 | 15 | 2 | 3 | 1 | |||||||||||||||||||||||||||||||
| 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 | {} | [] | 0 | 1400 | 367 | 506 | 1 | 1 | 1 | 1 | 1 | 3 | 2 | 54 | 69 | 6 | ||||||||||||||||||||||||
| 61 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:21.361137+03:00 | 3 | 60 | {} | [238] | 0 | 1400 | 49 | 49 | |||||||||||||||||||||||||||||||||
| 42 | [] | Muovinkeräys | Plaståtervinning | Plastic recycling | 454 | 2018-08-07T14:00:21.846516+03:00 | 3 | 34 | {} | [454] | 0 | 1400 | 23 | 70 | 29 | 16 | 2 | ||||||||||||||||||||||||||||||
| 53 | [] | Ongelmajäteasema | Problemavfall station | Waste management station | 478 | 2018-08-07T14:00:21.933801+03:00 | 2 | 31 | {} | [478] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 235 | [] | Hankepalvelut | Projekttjänster | Project services | 185 | 2018-08-07T14:00:22.084046+03:00 | 4 | 233 | {} | [185] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 54 | [] | Rantavesien ja sisäsaariston puhtaanapito | Renhållning av strandvatten och inre skärgård | Cleaning waterfronts and inner archipelago | 572 | 2018-08-07T14:00:21.940289+03:00 | 2 | 31 | {} | [572] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 78 | [] | Katujen puhtaanapito ja talvikunnossapito | Renhållning och vinterunderhåll av gator | Street cleaning and winter maintenance | 253 | 2018-08-07T14:00:21.475789+03:00 | 3 | 74 | {} | [253] | 0 | 1400 | 1 | 6 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
| 278 | [] | Korjausrakentaminen | Renovering | Renovation construction | 333 | 2018-08-07T14:00:22.369873+03:00 | 3 | 270 | {} | [333] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 243 | [] | Korjausavustukset ja -lainat | Reparationsunderstöd och -lån | Renovation grants and loans | 332 | 2018-08-07T14:00:22.130199+03:00 | 3 | 231 | {} | [332] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 81 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:21.499406+03:00 | 3 | 80 | {} | [259] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 302 | [303] | Yhdyskuntarakentaminen | Samhällsbyggnad | Civil engineering | 2018-08-07T14:00:22.510499+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 98 | [] | Metsät | Skogar | Forests | 438 | 2020-12-02T12:30:08.292275+02:00 | 3 | 97 | {} | [438] | 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 | |||||||||||||||||||||||||||||||||
| 72 | [] | Viheralueiden hoito | Skötsel av grönområden | Green area maintenance | 787 | 2020-12-02T11:30:08.056281+02:00 | 3 | 60 | {} | [787] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 253 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:22.189946+03:00 | 3 | 231 | {} | [467] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 9 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:21.273119+03:00 | 3 | 8 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 10 | [] | 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:21.280357+03:00 | 3 | 8 | {} | [267] | 0 | 1400 | 2 | 3 | 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 | ||||||||||||||||||||||||||||||||
| 11 | [] | Opiskelija-asunnot | Studentbostäder | Student housing | 484 | 2018-08-07T14:00:21.287386+03:00 | 3 | 8 | {} | [484] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 254 | [] | Siivouspalvelut | Städningsservice | Cleaning services | 621 | 2018-08-07T14:00:22.196172+03:00 | 3 | 231 | {} | [621] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 237 | [] | Maastomittauspalvelut | Terrängmätning | Field surveying services | 424 | 2018-08-07T14:00:22.090579+03:00 | 4 | 233 | {} | [424] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 50 | [] | Tekstiilien keräys | Textilåtervinning | Textile recycling | 696 | 2018-08-07T14:00:21.906229+03:00 | 3 | 34 | {} | [696] | 0 | 1400 | 40 | 108 | 37 | 29 | 2 | ||||||||||||||||||||||||||||||
| 76 | [] | Katujen ja viheralueiden käyttöluvat ja vuokraus | Tillstånd att använda gator och grönområden och uthyrning | Permits for using streets and parks and renting | 251 | 2018-08-07T14:00:21.463483+03:00 | 3 | 74 | {} | [251] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 113 | [] | Tupakkalain valvonta | Tillsyn av tobakslagen | Tobacco Act supervision | 719 | 2018-08-07T14:00:21.625158+03:00 | 3 | 103 | {} | [719] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 75 | [] | Katu-, maa- ja viherrakentamispalvelut | Tjänster inom gatu-, mark- och grönbyggnad | Construction services for streets, land and parks | 249 | 2018-08-07T14:00:21.457195+03:00 | 3 | 74 | {} | [249] | 0 | 1400 | 1 | 5 | 4 | ||||||||||||||||||||||||||||||||
| 84 | [] | Torit | Torg | Market squares | 714 | 2018-08-07T14:00:21.493235+03:00 | 3 | 80 | {} | [714] | 0 | 1400 | 15 | 15 | |||||||||||||||||||||||||||||||||
| 80 | [81, 82, 83, 84] | Torit ja kauppahallit | Torg och saluhallar | Market squares and halls | 2018-08-07T14:00:21.488118+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 19 | 19 | ||||||||||||||||||||||||||||||||||
| 226 | [227, 228] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 2018-08-07T14:00:22.025116+03:00 | 3 | 222 | {} | [] | 0 | 1400 | 1 | 5 | 2 | 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 | ||||||||||||||||||||||||||||||||
| 47 | [] | Puujäte | Träavfall | Wood waste | 531 | 2018-08-07T14:00:21.882472+03:00 | 3 | 34 | {} | [531] | 0 | 1400 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
| 36 | [] | Bio- ja puutarhajäte | Trädgårdsavfall | Garden waste | 127 | 2018-08-07T14:00:21.797808+03:00 | 3 | 34 | {} | [127] | 0 | 1400 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 99 | [] | Puutarhapalvelut | Trädgårdstjänster | Gardening services | 533 | 2018-08-07T14:00:21.548578+03:00 | 3 | 97 | {} | [533] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 263 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:22.252638+03:00 | 5 | 258 | {} | [803] | 0 | 1400 | 17 | 16 | 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 268 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:22.300791+03:00 | 5 | 265 | {} | [706] | 0 | 1400 | 1 | 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | {} | [] | 0 | 1400 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
| 93 | [] | Vesilaskut ja asiakaspalvelu | Vattenfakturering och kundtjänst | Billing for water and customer services | 67+781 | 2018-10-24T20:30:07.186738+03:00 | 2 | 85 | {} | [781, 67] | 0 | 1400 | 26 | 26 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 85 | [87, 88, 91, 93] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:21.953530+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 293 | [295, 296, 299, 301] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:22.465138+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 91 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:21.983685+03:00 | 2 | 85 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 299 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:22.497732+03:00 | 4 | 293 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 106 | [] | Eläinlääkäripalvelut | Veterinärtjänster | Vet services | 140 | 2018-08-07T14:00:21.592468+03:00 | 3 | 103 | {} | [140] | 0 | 1400 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 74 | [76, 77, 78, 75, 79, 2205] | Tiet ja kadut | Vägar och gator | Roads and streets | 2018-08-07T14:00:21.451762+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 356 | 376 | 3 | 16 | 1 | |||||||||||||||||||||||||||||||
| 23 | [] | Luonnonvaraisten eläinten hoitola | Vårdanstalt för vilda djur | Wildlife home | 411 | 2018-08-07T14:00:21.732081+03:00 | 2 | 14 | {} | [411] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 232 | [] | Energia-avustukset | energiunderstöd | energy grants | 144 | 2018-08-07T14:00:22.065643+03:00 | 3 | 231 | {} | [144] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 6 | [] | Kaupungin asumisoikeusasunnot | stadens bostadsrättsbostäder | City's right of residence apartments | 261 | 2018-08-07T14:00:21.255121+03:00 | 3 | 5 | {} | [261] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 35 | [] | Akkujen keräys | Återvinning av bilbatterier | Car battery recycling | 45 | 2018-08-07T14:00:21.789985+03:00 | 3 | 34 | {"fi": ["akut"]} | [45] | 0 | 1400 | 34 | 79 | 18 | 26 | 1 | ||||||||||||||||||||||||||||||
| 39 | [] | Lamppujen keräys | Återvinning av lampor | Lamp recycling | 369 | 2018-08-07T14:00:21.822356+03:00 | 3 | 34 | {"fi": ["lamput"]} | [369] | 0 | 1400 | 21 | 54 | 13 | 20 | |||||||||||||||||||||||||||||||
| 46 | [] | Paristonkeräys | Återvinning av små batterier | Small battery recycling | 497 | 2018-08-07T14:00:21.875976+03:00 | 3 | 34 | {"fi": ["paristot"]} | [497] | 0 | 1400 | 16 | 46 | 12 | 18 | |||||||||||||||||||||||||||||||
| 52 | [] | Kierrätyskeskus | Återvinningscentral | Recycling centre | 298 | 2018-08-07T14:00:21.919516+03:00 | 2 | 31 | {} | [298] | 0 | 1400 | 3 | 7 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||
| 114 | [] | Uimavesien valvonta | Övervakning av badvatten | Swimming water supervision | 732 | 2018-08-07T14:00:21.631376+03:00 | 3 | 103 | {} | [732] | 0 | 1400 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 110 | [] | Talousveden valvonta | Övervakning av hushållsvatten | Domestic water supervision | 683 | 2018-08-07T14:00:21.612084+03:00 | 3 | 103 | {} | [683] | 0 | 1400 | 1 | 3 | 1 | 1 |
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 );