service_node
186 rows where root = 1400 sorted by unit_count_municipality_helsinki descending
This data as json, CSV (advanced)
Suggested facets: level, keywords, unit_count_municipality_sipoo, unit_count_municipality__unknown, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_kauniainen, 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1400 | [2, 1, 14, 24, 31, 221, 85] | Asuminen ja kaupunkiympäristö | Boende och stadsmiljö | Housing and urban environment | 2018-08-07T14:00:21.224786+03:00 | 0 | {} | [] | 0 | 1400 | 2311 | 4077 | 17 | 1 | 23 | 1 | 1 | 4 | 1 | 30 | 53 | 43 | 737 | 3 | 698 | 35 | 10 | 31 | 37 | 41 | |||||||||||||||||
1 | [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] | Asumisympäristö | Boendemiljön | Housing environment | 2018-08-07T14:00:21.308151+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 1002 | 1524 | 2 | 2 | 294 | 218 | 6 | |||||||||||||||||||||||||||||
2 | [3, 4, 5, 7, 2191, 8] | Asuminen | Boende | Housing | 2018-08-07T14:00:21.231002+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 742 | 1530 | 16 | 23 | 1 | 1 | 27 | 51 | 40 | 246 | 3 | 256 | 35 | 10 | 1 | 37 | 41 | |||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2191 | [] | Hitas-asunnot | Hitas-bostäder | Hitas owner-occupied housing | 877 | 2019-03-05T14:30:06.194077+02:00 | 2 | 2 | {} | [877] | 0 | 1400 | 399 | 399 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
5 | [6] | Asumisoikeusasuminen | Bostadsrättsbostäder | Right-of-occupancy housing | 76 | 2018-08-07T14:00:21.249052+03:00 | 2 | 2 | {} | [76] | 0 | 1400 | 331 | 1108 | 15 | 23 | 1 | 27 | 51 | 40 | 242 | 3 | 253 | 35 | 10 | 37 | 40 | ||||||||||||||||||||
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 | {} | [] | 0 | 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 | {} | [] | 0 | 1400 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
68 | [70, 69] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:21.413441+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
31 | [32, 33, 34, 52, 53, 54] | Jätehuolto ja kierrätys | Avfallshantering och återvinning | Waste management and recycling | 2018-08-07T14:00:21.761620+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 215 | 572 | 1 | 150 | 186 | 20 | ||||||||||||||||||||||||||||||
34 | [35, 36, 37, 38, 2211, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51] | Keräyspisteet | Insamlingsplatser | Collection points | 2018-08-07T14:00:21.780177+03:00 | 2 | 31 | {} | [] | 0 | 1400 | 210 | 565 | 150 | 185 | 20 | |||||||||||||||||||||||||||||||
45 | [] | Paperinkeräys | Insamling av papper | Paper recycling | 496 | 2018-08-07T14:00:21.867001+03:00 | 3 | 34 | {} | [496] | 0 | 1400 | 166 | 466 | 125 | 156 | 19 | ||||||||||||||||||||||||||||||
14 | [16, 23] | Eläimet | Djur | Animals | 2018-08-07T14:00:21.679608+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 103 | 150 | 22 | 25 | ||||||||||||||||||||||||||||||||
16 | [17, 18, 19, 20, 21] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:21.685399+03:00 | 2 | 14 | {} | [] | 0 | 1400 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
62 | [63, 64, 65, 66, 67] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:21.368201+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
17 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:21.693384+03:00 | 3 | 16 | {"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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
38 | [] | Kartonginkeräys | Insamling av kartong | Cardboard recycling | 246 | 2018-08-07T14:00:21.813795+03:00 | 3 | 34 | {"fi": ["kartonki"]} | [246] | 0 | 1400 | 54 | 140 | 46 | 36 | 4 | ||||||||||||||||||||||||||||||
71 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:21.432517+03:00 | 3 | 60 | {} | [786] | 0 | 1400 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
40 | [] | Lasinkeräys | Glasåtervinning | Glass recycling | 374 | 2018-08-07T14:00:21.831316+03:00 | 3 | 34 | {} | [374] | 0 | 1400 | 50 | 138 | 46 | 37 | 5 | ||||||||||||||||||||||||||||||
41 | [] | Metallinkeräys | Metallavfall | Small metal waste | 436 | 2018-08-07T14:00:21.839149+03:00 | 3 | 34 | {} | [436] | 0 | 1400 | 50 | 137 | 46 | 37 | 4 | ||||||||||||||||||||||||||||||
61 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:21.361137+03:00 | 3 | 60 | {} | [238] | 0 | 1400 | 49 | 49 | |||||||||||||||||||||||||||||||||
270 | [271, 272, 277, 278, 279, 286, 287, 293, 302] | Rakentaminen | Byggande | Construction | 2018-08-07T14:00:22.314988+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 48 | 80 | 1 | 1 | 8 | 21 | 1 | |||||||||||||||||||||||||||||
73 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:21.445519+03:00 | 2 | 1 | {} | [532] | 0 | 1400 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
94 | [] | Yleisövessat | Allmänna toaletter | Public toilets | 819 | 2018-10-25T08:00:06.064613+03:00 | 2 | 1 | {} | [819] | 0 | 1400 | 39 | 39 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2236 | [] | Puistoshakkilaudat | Parkschackbräden | Park chess boards | 912 | 2020-09-01T15:30:06.145353+03:00 | 3 | 60 | {} | [912] | 0 | 1400 | 24 | 24 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
51 | [] | Vaarallinen jäte | Farligt avfall | Hazardous waste | 740 | 2018-08-07T14:00:21.912639+03:00 | 3 | 34 | {} | [740] | 0 | 1400 | 16 | 44 | 11 | 17 | |||||||||||||||||||||||||||||||
84 | [] | Torit | Torg | Market squares | 714 | 2018-08-07T14:00:21.493235+03:00 | 3 | 80 | {} | [714] | 0 | 1400 | 15 | 15 | |||||||||||||||||||||||||||||||||
59 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:21.345565+03:00 | 2 | 1 | {} | [432] | 0 | 1400 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
49 | [] | Sähkö- ja elektroniikkaromu | El- och elekronikskrot | Electric and electronic junk | 668 | 2018-10-25T08:00:06.218463+03:00 | 3 | 34 | {} | [668] | 0 | 1400 | 11 | 24 | 7 | 6 | |||||||||||||||||||||||||||||||
245 | [249, 248, 247, 250, 251] | Maan, tonttien ja asuntojen vuokraus ja myynti | Försäljning och uthyrning av mark, tomter, lokaler och bostäder | Sales and rental of land, lots, facilities and apartments | 2018-08-07T14:00:22.143596+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 10 | 32 | 4 | 17 | 1 | |||||||||||||||||||||||||||||||
8 | [10, 9, 11] | Vuokra-asuminen | Hyresbostäder | Rental flats | 2018-08-07T14:00:21.267377+03:00 | 2 | 2 | {} | [] | 0 | 1400 | 9 | 13 | 3 | 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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
272 | [273, 274, 275] | Energia | Energi | Energy | 2018-08-07T14:00:22.327547+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
18 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:21.700490+03:00 | 3 | 16 | {} | [319] | 0 | 1400 | 5 | 5 | |||||||||||||||||||||||||||||||||
64 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:21.387379+03:00 | 4 | 62 | {} | [319] | 0 | 1400 | 5 | 5 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
20 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:21.713262+03:00 | 3 | 16 | {} | [321] | 0 | 1400 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
27 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:21.755624+03:00 | 2 | 24 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
66 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:21.400222+03:00 | 4 | 62 | {} | [321] | 0 | 1400 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
103 | [104, 105, 106, 107, 109, 110, 111, 113, 114] | Ympäristöterveydenhuolto | Miljö- och hälsoskydd | Environmental health | 2018-08-07T14:00:21.574018+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 4 | 9 | 2 | 1 | 2 | |||||||||||||||||||||||||||||||
275 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:22.348354+03:00 | 4 | 272 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
4 | [] | Asumisen tuet | Bostadsbidrag | Housing allowances | 75 | 2018-08-07T14:00:21.243003+03:00 | 2 | 2 | {} | [75] | 0 | 1400 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
81 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:21.499406+03:00 | 3 | 80 | {} | [259] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
82 | [] | Kirpputorit | Lopptorg | Flea markets | 315 | 2018-08-07T14:00:21.505503+03:00 | 3 | 80 | {} | [315] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
233 | [234, 235, 237] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:22.072503+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 3 | 6 | 3 | |||||||||||||||||||||||||||||||||
259 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.226278+03:00 | 5 | 258 | {} | [799] | 0 | 1400 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
279 | [281, 282, 283, 284, 285] | Rakennusvalvonta | Byggnadstillsyn | Building Control | 2018-08-07T14:00:22.376681+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 3 | 11 | 2 | 5 | 1 | |||||||||||||||||||||||||||||||
291 | [] | Materiaalipalvelut | Materialservice | Material services | 564 | 2018-08-07T14:00:22.451320+03:00 | 4 | 287 | {} | [564] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
21 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.719558+03:00 | 3 | 16 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
44 | [] | Pahvinkeräys | Insamling av wellpapp | Corrugated cardboard recycling | 491 | 2018-08-07T14:00:21.860147+03:00 | 3 | 34 | {} | [491] | 0 | 1400 | 2 | 7 | 1 | 2 | 2 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
48 | [] | Sekajäte | Blandat avfall | Mixed waste | 617 | 2018-08-07T14:00:21.889545+03:00 | 3 | 34 | {} | [617] | 0 | 1400 | 2 | 6 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
57 | [] | Luonnonsuojelu | Naturskydd | Environmental protection | 410 | 2018-08-07T14:00:21.330807+03:00 | 2 | 1 | {} | [410] | 0 | 1400 | 2 | 4 | 1 | 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 | |||||||||||||||||||||||||||||||||
83 | [] | Markkinat | Marknader | Markets | 427 | 2018-08-07T14:00:21.511515+03:00 | 3 | 80 | {} | [427] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
91 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:21.983685+03:00 | 2 | 85 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
104 | [] | Asumisterveys | Boendehälsa | Housing health | 77 | 2018-08-07T14:00:21.579504+03:00 | 3 | 103 | {} | [77] | 0 | 1400 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
118 | [] | Pohjavesitiedot | Grundvatteninformation | Groundwater information | 517 | 2018-08-07T14:00:21.654694+03:00 | 3 | 116 | {} | [517] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
224 | [] | Info- ja näyttelytilat | Informations- och utställningslokaler | Info and exhibition premises | 201 | 2018-08-07T14:00:22.012371+03:00 | 3 | 222 | {} | [201] | 0 | 1400 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
230 | [] | Viestintä ja vuorovaikutus | Kommunikation och påverkan | Communications and interaction | 785 | 2018-08-07T14:00:22.052241+03:00 | 3 | 222 | {} | [785] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
237 | [] | Maastomittauspalvelut | Terrängmätning | Field surveying services | 424 | 2018-08-07T14:00:22.090579+03:00 | 4 | 233 | {} | [424] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
299 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:22.497732+03:00 | 4 | 293 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
2211 | [] | Kyllästetyn puujätteen keräys | Insamling av impregnerat träavfall | Impregnated wood waste collection | 889 | 2020-01-02T14:30:07.726283+02:00 | 3 | 34 | {} | [889] | 0 | 1400 | 2 | 4 | 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 | |||||||||||||||||||||||||||||||||
7 | [] | Asuntotuotanto | Bostadsproduktion | Housing production | 79 | 2018-08-07T14:00:21.261214+03:00 | 2 | 2 | {} | [79] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
19 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.707130+03:00 | 3 | 16 | {} | [320] | 0 | 1400 | 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 );