service_node
186 rows where root = 1400 sorted by service_reference
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
68 | [70, 69] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:21.413441+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
95 | [96] | Ympäristökasvatus | Miljöfostran | Environmental education | 2018-08-07T14:00:21.524750+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 3 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
226 | [227, 228] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 2018-08-07T14:00:22.025116+03:00 | 3 | 222 | {} | [] | 0 | 1400 | 1 | 5 | 2 | 1 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
233 | [234, 235, 237] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:22.072503+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 3 | 6 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
272 | [273, 274, 275] | Energia | Energi | Energy | 2018-08-07T14:00:22.327547+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
302 | [303] | Yhdyskuntarakentaminen | Samhällsbyggnad | Civil engineering | 2018-08-07T14:00:22.510499+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
303 | [304] | Aluerakentaminen | Områdesbyggandet | Regional construction | 2018-08-07T14:00:22.515802+03:00 | 4 | 302 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||||||||||||||||
105 | [] | Elintarvikevalvonta | Livsmedelsbevakning | Food control | 137 | 2018-08-07T14:00:21.585963+03:00 | 3 | 103 | {} | [137] | 0 | 1400 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
107 | [] | Eläinsuojelu | Djurskydd | Animal protection | 141 | 2018-08-07T14:00:21.598706+03:00 | 3 | 103 | {} | [141] | 0 | 1400 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
232 | [] | Energia-avustukset | energiunderstöd | energy grants | 144 | 2018-08-07T14:00:22.065643+03:00 | 3 | 231 | {} | [144] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
37 | [] | Energiajäte | Energiavfall | Energy waste | 145 | 2018-08-07T14:00:21.805057+03:00 | 3 | 34 | {} | [145] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
26 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:21.749651+03:00 | 2 | 24 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
274 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:22.341217+03:00 | 4 | 272 | {} | [146] | 0 | 1400 | 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 | |||||||||||||||||||||||||||||||||
238 | [] | Hissiprojekti | Anskaffning av hissar (gamla höghus) | Lift procurement (old residential buildings) | 195 | 2018-08-07T14:00:22.097017+03:00 | 3 | 231 | {} | [195] | 0 | 1400 | 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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
87 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:21.958557+03:00 | 2 | 85 | {} | [233] | 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 | ||||||||||||||||||||||||||||||||
33 | [] | Jätteenkäsittelykeskus | Avfallshanteringscentral | Waste treatment centre | 234 | 2018-08-07T14:00:21.773147+03:00 | 2 | 31 | {} | [234] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
61 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:21.361137+03:00 | 3 | 60 | {} | [238] | 0 | 1400 | 49 | 49 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
239 | [] | Kaupanvahvistus | Bestyrkande av köp | Public purchase witnessing | 255 | 2018-08-07T14:00:22.103157+03:00 | 3 | 231 | {} | [255] | 0 | 1400 | 1 | 3 | 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 | ||||||||||||||||||||||||||||||||
81 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:21.499406+03:00 | 3 | 80 | {} | [259] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
240 | [] | Kiinteistöhuolto ja isännöinti | Fastighetsunderhåll och -förvaltning | Janitorial and landlord services | 303 | 2018-08-07T14:00:22.109816+03:00 | 3 | 231 | {} | [303] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
241 | [] | Kiinteistönmuodostus | Fastighetsbildning | Property formation | 304 | 2018-08-07T14:00:22.116719+03:00 | 3 | 231 | {} | [304] | 0 | 1400 | 5 | 1 | 4 | ||||||||||||||||||||||||||||||||
242 | [] | Kiinteistörekisteri | Fastighetsregister | Real estate register | 305 | 2018-08-07T14:00:22.123611+03:00 | 3 | 231 | {} | [305] | 0 | 1400 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
82 | [] | Kirpputorit | Lopptorg | Flea markets | 315 | 2018-08-07T14:00:21.505503+03:00 | 3 | 80 | {} | [315] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
19 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.707130+03:00 | 3 | 16 | {} | [320] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
65 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.393701+03:00 | 4 | 62 | {} | [320] | 0 | 1400 | 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 | ||||||||||||||||||||||||||||||||
66 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:21.400222+03:00 | 4 | 62 | {} | [321] | 0 | 1400 | 4 | 5 | 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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
278 | [] | Korjausrakentaminen | Renovering | Renovation construction | 333 | 2018-08-07T14:00:22.369873+03:00 | 3 | 270 | {} | [333] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
244 | [] | Lainhuuto | Lagfart | Registration of title to property | 367 | 2018-08-07T14:00:22.136957+03:00 | 3 | 231 | {} | [367] | 0 | 1400 | 1 | 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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
57 | [] | Luonnonsuojelu | Naturskydd | Environmental protection | 410 | 2018-08-07T14:00:21.330807+03:00 | 2 | 1 | {} | [410] | 0 | 1400 | 2 | 4 | 1 | 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 | |||||||||||||||||||||||||||||||||
96 | [] | Luontokoulu | Miljöcentralens naturskola | Nature school | 412 | 2018-08-07T14:00:21.529831+03:00 | 3 | 95 | {} | [412] | 0 | 1400 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
58 | [] | Löytötavarapalvelu | Hittegodsservice | Found Property Service | 418 | 2018-08-07T14:00:21.337453+03:00 | 2 | 1 | {} | [418] | 0 | 1400 | 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 | |||||||||||||||||||||||||||||||||
117 | [] | Maaperä ja vesi | Jordmånen och vatten | Ground and water | 423 | 2018-08-07T14:00:21.648552+03:00 | 3 | 116 | {} | [423] | 0 | 1400 | 1 | 3 | 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 | |||||||||||||||||||||||||||||||||
83 | [] | Markkinat | Marknader | Markets | 427 | 2018-08-07T14:00:21.511515+03:00 | 3 | 80 | {} | [427] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 |
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 );