service_node
1,140 rows sorted by unit_count_municipality__unknown descending
This data as json, CSV (advanced)
Suggested facets: level, keywords, 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_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, unit_count_municipality_karkkila
last_modified_time (date) ✖
- 2018-08-07 939
- 2018-10-25 91
- 2020-03-06 16
- 2018-10-24 12
- 2020-11-18 12
- 2019-03-05 11
- 2020-06-09 9
- 2020-06-22 8
- 2018-08-31 4
- 2020-10-02 4
- 2020-12-02 4
- 2019-10-22 3
- 2018-11-20 2
- 2019-02-12 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-05-08 2
- 2019-06-20 2
- 2019-08-22 2
- 2020-05-08 2
- 2020-08-20 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-23 1
- 2019-09-02 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-05-25 1
- 2020-12-15 1
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
343 | [344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503] | Kulttuuri ja vapaa-aika | Kultur och fritid | Culture and leisure | 2018-08-07T14:00:22.539281+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1745 | 2452 | 1 | 1 | 1 | 1 | 8 | 1 | 2 | 4 | 2 | 382 | 286 | 1 | 13 | 4 | ||||||||||||||||||||
2006 | [] | Veistokset ja julkinen taide | Skulpturer och offentlig konst | Sculptures and public art | 767 | 2018-08-07T14:00:22.854537+03:00 | 2 | 343 | {"fi": ["patsas", "patsaat", "veistos"]} | [767] | 0 | 1403 | 482 | 488 | 6 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||
551 | [552, 2151, 558, 2217, 601, 633, 666, 684, 694] | Liikunta | Idrott och motion | Sports and physical exercise | 2018-08-07T14:00:23.220207+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 2590 | 4872 | 16 | 3 | 19 | 1 | 1 | 11 | 1260 | 1 | 892 | 36 | 42 | |||||||||||||||||||||||
986 | [990, 1048, 995, 996, 997, 1028, 1042, 1017, 992, 1019, 999, 1004, 1043, 1041, 1051, 1000, 1039, 1018, 1009, 1044, 988, 998, 993, 991, 2190, 1060, 994] | Terveys | Hälsovård | Health care | 2018-08-07T14:00:29.110723+03:00 | 0 | {} | [] | 0 | 986 | 556 | 949 | 1 | 4 | 1 | 2 | 4 | 1 | 1 | 3 | 1 | 1 | 5 | 9 | 4 | 4 | 2 | 8 | 2 | 122 | 1 | 6 | 2 | 183 | 5 | 2 | 12 | 2 | 2 | 2 | 1 | ||||||
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 | |||||||||||||||||||||||||||||
122 | [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] | Elinkeino, työ ja verotus | Näringar, arbete och beskattning | Entrepreneurship, work and taxation | 2018-08-07T14:00:29.995212+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 322 | 452 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 51 | 62 | 5 | 1 | |||||||||||||||||||||||
717 | [754, 718, 2173, 2028] | Matkailu ja tapahtumat | Turism och evenemang | Things to do | 2020-03-06T18:32:07.102459+02:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1973 | 2155 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 5 | 3 | 87 | 67 | 1 | 1 | 3 | 4 | ||||||||||||||||||
1401 | [122, 171, 755] | Työ, talous ja hallinto | Arbete, ekonomi och förvaltning | Employment and public authorities | 2020-03-06T18:32:09.344909+02:00 | 0 | {} | [] | 0 | 1401 | 448 | 629 | 2 | 1 | 1 | 2 | 1 | 2 | 3 | 88 | 74 | 6 | 1 | ||||||||||||||||||||||||
1403 | [343, 551, 717, 365] | Kulttuuri, liikunta ja vapaa-aika | Kultur, motion och fritid | Culture, sports and leisure | 2018-08-07T14:00:22.534057+03:00 | 0 | {} | [] | 0 | 1403 | 5769 | 8871 | 1 | 18 | 1 | 1 | 1 | 12 | 1 | 20 | 3 | 1 | 6 | 14 | 1685 | 1 | 1238 | 1 | 37 | 57 | 4 | ||||||||||||||||
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 | |||||||||||||||||||
3 | [] | Asumisen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för boendeärenden | Electronic housing services and forms | 74 | 2018-08-07T14:00:21.236014+03:00 | 2 | 2 | {} | [74] | 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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
100 | [] | Ympäristön sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för miljöärenden | Electronic services and forms related to environmental matters | 826 | 2018-08-07T14:00:21.554721+03:00 | 2 | 1 | {} | [826] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
128 | [] | Elinkeinopalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för näringslivsservicen | Electronic services and forms related to business services | 135 | 2018-08-07T14:00:30.039148+03:00 | 2 | 122 | {} | [135] | 0 | 1401 | 1 | 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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
286 | [] | Rakentamisen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter i byggärenden | Electronic services and forms related to construction | 565 | 2018-08-07T14:00:22.418594+03:00 | 3 | 270 | {} | [565] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
306 | [307, 314, 320, 324, 329, 342] | Kartat, tietopalvelut ja viestintä | Kartor, informationstjänster och kommunikation | Maps, information services and communication | 2018-08-07T14:00:24.652419+03:00 | 1 | 1402 | {} | [] | 0 | 1402 | 307 | 389 | 1 | 42 | 36 | 3 | ||||||||||||||||||||||||||||||
314 | [319, 315, 317, 316, 2147, 2159] | Asiakaspalvelu ja neuvonta | Kundbetjäning och rådgivning | Customer service and information | 2018-08-07T14:00:24.703287+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 12 | 39 | 1 | 12 | 13 | 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 | ||||||||||||||||||||||||||||||
351 | [] | Kulttuuripalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för kulturtjänster | Electronic services and forms related to cultural services | 346 | 2018-08-07T14:00:22.590770+03:00 | 2 | 343 | {} | [346] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
491 | [492, 493, 499, 2237, 502, 2235] | Puistot ja viheralueet | Parker och grönområden | Parks and green areas | 2018-08-07T14:00:22.684763+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 520 | 967 | 1 | 268 | 173 | 5 | ||||||||||||||||||||||||||||||
502 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:22.769184+03:00 | 3 | 491 | {} | [786] | 0 | 1403 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
694 | [695, 706] | Virkistyskohteet ja palvelut | Rekreationsanläggningar och tjänster | Recreational destinations and services | 2018-08-07T14:00:24.231367+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 235 | 442 | 11 | 1 | 13 | 11 | 143 | 1 | 7 | 19 | 1 | |||||||||||||||||||||||||
706 | [710, 711, 712, 713, 714, 716] | Virkistys- ja retkeilyalueet | Rekreations- och friluftsområden | Recreational and outdoor areas | 2018-08-07T14:00:24.316869+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 11 | 38 | 1 | 1 | 2 | 3 | 18 | 1 | 1 | |||||||||||||||||||||||||||
716 | [] | Virkistysmetsä | Friluftsskog | Recreational forest | 791 | 2018-08-07T14:00:24.380867+03:00 | 4 | 706 | {} | [791] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
718 | [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] | Matkailu | Turism | Tourism | 2018-08-07T14:00:24.401683+03:00 | 2 | 717 | {} | [] | 0 | 1403 | 1880 | 2050 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 5 | 3 | 79 | 64 | 1 | 1 | 3 | 4 | ||||||||||||||||||
719 | [721, 723, 724, 725, 730] | Eläintarhat | Djurparker | Zoos | 2018-08-07T14:00:24.415879+03:00 | 3 | 718 | {} | [] | 0 | 1403 | 13 | 14 | 1 | |||||||||||||||||||||||||||||||||
723 | [] | Lipunmyynti | Biljettförsäljning | Ticket sales | 403 | 2018-08-07T14:00:24.435423+03:00 | 4 | 719 | {} | [403] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
754 | [] | Lipunmyynti tapahtumiin | Biljettförsäljning till evenemang | Ticket sales to events | 405 | 2018-08-07T14:00:24.631976+03:00 | 2 | 717 | {} | [405] | 0 | 1403 | 5 | 13 | 1 | 6 | 1 | ||||||||||||||||||||||||||||||
783 | [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] | Perhe- ja sosiaalipalvelut | Familje- och socialservice | Family and social services | 2018-08-07T14:00:27.699133+03:00 | 0 | {} | [] | 0 | 783 | 397 | 718 | 2 | 1 | 1 | 129 | 175 | 1 | 7 | 5 | |||||||||||||||||||||||||||
784 | [786, 785] | Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta | Rådgivning om social- och hälsovårdstjänster och för äldre | Information and advice of social and health services and for elderly people | 2018-08-07T14:00:27.703824+03:00 | 1 | 783 | {} | [] | 0 | 783 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
785 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:27.709008+03:00 | 2 | 784 | {} | [71] | 0 | 783 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
988 | [2146, 989] | Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta | Rådgivning om social- och hälsovårdstjänster och för äldre | Information and advice of social and health services and for elderly people | 2018-08-07T14:00:29.124487+03:00 | 1 | 986 | {} | [] | 0 | 986 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
989 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:29.129777+03:00 | 2 | 988 | {} | [71] | 0 | 986 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
999 | [] | Myrkytystietoa | Giftinformation | Poison information | 461 | 2018-08-07T14:00:29.228018+03:00 | 1 | 986 | {} | [461] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
1060 | [] | Terveyspalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter inom hälso- och sjukvården | Electronic services and forms related to health services | 704 | 2018-08-07T14:00:29.759443+03:00 | 1 | 986 | {} | [704] | 0 | 986 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
1402 | [306, 512] | Liikenne ja kartat | Trafik och kartor | Traffic and maps | 2018-08-07T14:00:24.647447+03:00 | 0 | {} | [] | 0 | 1402 | 1567 | 2238 | 1 | 4 | 1 | 2 | 1 | 2 | 581 | 71 | 8 | ||||||||||||||||||||||||||
2147 | [2148, 318] | Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta | Rådgivning om social- och hälsovårdstjänster och för äldre | Information and advice of social and health services and for elderly people | 2018-08-07T14:00:24.757653+03:00 | 3 | 314 | {} | [] | 0 | 1402 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
2151 | [] | Liikunnan sähköinen asiointi ja lomakkeet | Elektroniska tjänster och formulär för motion | Electronic services and forms related to sports | 849 | 2018-08-07T14:00:24.387923+03:00 | 2 | 551 | {} | [849] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2217 | [2218, 2219, 2220, 2221, 2223, 2224, 2225, 2226] | Senioriliikunta | Seniormotion | Senior sports | 2020-06-09T15:30:11.296799+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 88 | 104 | 1 | 4 | 10 | 1 | ||||||||||||||||||||||||||||||
2221 | [] | Senioriliikunta | Seniormotion | Senior sports | 895 | 2020-06-09T15:30:11.355674+03:00 | 3 | 2217 | {} | [895] | 0 | 1403 | 86 | 102 | 1 | 4 | 10 | 1 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
11 | [] | Opiskelija-asunnot | Studentbostäder | Student housing | 484 | 2018-08-07T14:00:21.287386+03:00 | 3 | 8 | {} | [484] | 0 | 1400 | 1 | 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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
18 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:21.700490+03:00 | 3 | 16 | {} | [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 | |||||||||||||||||||||||||||||||||
20 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:21.713262+03:00 | 3 | 16 | {} | [321] | 0 | 1400 | 4 | 5 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
26 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:21.749651+03:00 | 2 | 24 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
27 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:21.755624+03:00 | 2 | 24 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
37 | [] | Energiajäte | Energiavfall | Energy waste | 145 | 2018-08-07T14:00:21.805057+03:00 | 3 | 34 | {} | [145] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
58 | [] | Löytötavarapalvelu | Hittegodsservice | Found Property Service | 418 | 2018-08-07T14:00:21.337453+03:00 | 2 | 1 | {} | [418] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
61 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:21.361137+03:00 | 3 | 60 | {} | [238] | 0 | 1400 | 49 | 49 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
68 | [70, 69] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:21.413441+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 293 | 647 | 201 | 148 | 5 |
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 );