service_node
297 rows where root = 1403 sorted by unit_count_municipality_kauniainen
This data as json, CSV (advanced)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
344 | [] | Kasvitieteelliset puutarhat | Botaniska trädgårdar | Botanic gardens | 248 | 2018-08-07T14:00:22.544317+03:00 | 2 | 343 | {} | [248] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
346 | [] | Erikoiskirjastot | Specialbibliotek | Special libraries | 155 | 2018-08-07T14:00:22.558572+03:00 | 3 | 345 | {"fi": ["kirjastot"]} | [155] | 0 | 1403 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
348 | [] | Laitoskirjastot | Anstaltsbibliotek | Institutional libraries | 368 | 2018-08-07T14:00:22.571974+03:00 | 3 | 345 | {} | [368] | 0 | 1403 | 8 | 8 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
356 | [] | Kurssitoiminta | Kursverksamhet | Courses | 356 | 2018-08-07T14:00:22.623521+03:00 | 3 | 352 | {} | [356] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
358 | [] | Ooppera ja baletti | Operan och balett | Opera and ballet | 479 | 2018-08-07T14:00:22.636644+03:00 | 3 | 352 | {} | [479] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
359 | [] | Tanssitilat | Dansutrymmen | Dance facilities | 686 | 2018-08-07T14:00:22.643791+03:00 | 3 | 352 | {} | [686] | 0 | 1403 | 12 | 15 | 1 | 2 | |||||||||||||||||||||||||||||||
360 | [] | Teatterit | Teatrar | Theatres | 694 | 2018-08-07T14:00:22.651704+03:00 | 3 | 352 | {} | [694] | 0 | 1403 | 50 | 62 | 10 | 2 | |||||||||||||||||||||||||||||||
361 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:22.659080+03:00 | 2 | 343 | {} | [432] | 0 | 1403 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
362 | [363, 364] | Museot | Museer | Museums | 2018-08-07T14:00:22.665582+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 64 | 96 | 1 | 4 | 1 | 13 | 8 | 1 | 4 | |||||||||||||||||||||||||||
363 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:22.670926+03:00 | 3 | 362 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
364 | [] | Taidemuseo | Konstmuseer | Art museums | 672 | 2018-08-07T14:00:22.677535+03:00 | 3 | 362 | {} | [672] | 0 | 1403 | 61 | 88 | 1 | 4 | 1 | 10 | 6 | 1 | 4 | ||||||||||||||||||||||||||
367 | [] | Katutaidepaikat | Platser för gatukonst | Street art locations | 254 | 2018-08-07T14:00:22.877110+03:00 | 2 | 365 | {} | [254] | 0 | 1403 | 12 | 12 | |||||||||||||||||||||||||||||||||
371 | [] | Askartelu | Hobbyverksamhet | Hobby crafts | 72 | 2018-08-07T14:00:22.898108+03:00 | 3 | 368 | {} | [72] | 0 | 1403 | 3 | 9 | 2 | 4 | |||||||||||||||||||||||||||||||
374 | [] | Av- ja leirivälinelainaamo | Utlåning av AV-utrustning och campingutrustning | Loaning service for audiovisual and camping equipment | 81 | 2018-08-07T14:00:22.905139+03:00 | 3 | 368 | {} | [81] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
378 | [] | Bänditoiminta/-tila | Bandverksamhet eller bandlokal | Band activity or practice space | 128 | 2018-08-07T14:00:22.924860+03:00 | 3 | 368 | {} | [128] | 0 | 1403 | 2 | 12 | 5 | 5 | |||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
389 | [] | Fillari- ja moottoripaja | Cykel- och motorverkstad | Workshop for bicycles and mopeds | 168 | 2018-08-07T14:00:22.937466+03:00 | 3 | 368 | {} | [168] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
391 | [] | Futsal | Futsal | Futsal | 170 | 2018-08-07T14:00:22.944059+03:00 | 3 | 368 | {} | [170] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
395 | [] | Internet | Internet | Internet | 202 | 2018-08-07T14:00:22.950721+03:00 | 3 | 368 | {} | [202] | 0 | 1403 | 2 | 15 | 13 | ||||||||||||||||||||||||||||||||
396 | [] | Jalkapallo | Fotboll | Football | 203 | 2018-08-07T14:00:22.956950+03:00 | 3 | 368 | {} | [203] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
399 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 231 | 2018-08-07T14:00:22.963009+03:00 | 3 | 368 | {} | [231] | 0 | 1403 | 6 | 8 | 2 | ||||||||||||||||||||||||||||||||
403 | [] | Keramiikka | Keramik | Pottery | 287 | 2018-08-07T14:00:22.976243+03:00 | 3 | 368 | {} | [287] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
405 | [] | Kesätoiminta | Sommarverksamhet | Summer activities | 291 | 2018-08-07T14:00:22.992018+03:00 | 3 | 368 | {} | [291] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
410 | [] | Konsolipelit | Konsolspel | Console games | 330 | 2018-08-07T14:00:23.006235+03:00 | 3 | 368 | {} | [330] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
415 | [] | Kuntosali | Gym | Gym | 349 | 2018-08-07T14:00:23.013463+03:00 | 3 | 368 | {} | [349] | 0 | 1403 | 11 | 1 | 10 | ||||||||||||||||||||||||||||||||
419 | [] | Kädentaidot | Hantverk | Arts and Crafts | 362 | 2018-08-07T14:00:23.026643+03:00 | 3 | 368 | {} | [362] | 0 | 1403 | 3 | 15 | 10 | 2 | |||||||||||||||||||||||||||||||
421 | [] | Käsityöt | Handarbeten | Handicrafts | 363 | 2018-08-07T14:00:23.033043+03:00 | 3 | 368 | {} | [363] | 0 | 1403 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||
424 | [] | Lautapelit | Brädspel | Board games | 387 | 2018-08-07T14:00:23.039435+03:00 | 3 | 368 | {} | [387] | 0 | 1403 | 14 | 13 | 1 | ||||||||||||||||||||||||||||||||
426 | [] | Leiritoiminta | Lägerverksamhet | Camping activities | 391 | 2018-08-07T14:00:23.046486+03:00 | 3 | 368 | {} | [391] | 0 | 1403 | 1 | 6 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
429 | [] | Liikunta | Idrott | Sports | 399 | 2018-08-07T14:00:23.053156+03:00 | 3 | 368 | {} | [399] | 0 | 1403 | 10 | 9 | 1 | ||||||||||||||||||||||||||||||||
433 | [] | Media | Media | Media | 433 | 2018-08-07T14:00:23.060583+03:00 | 3 | 368 | {} | [433] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
437 | [] | Monistuspalvelu | Kopieringstjänst | Copying service | 443 | 2018-08-07T14:00:23.067329+03:00 | 3 | 368 | {} | [443] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
438 | [] | Moottorihalli | Motorhall | Motorhall | 445 | 2018-08-07T14:00:23.074919+03:00 | 3 | 368 | {} | [445] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
440 | [] | Mopokerho | Mopedklubb | Moped club | 452 | 2018-08-07T14:00:23.082022+03:00 | 3 | 368 | {} | [452] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
442 | [] | Musiikki | Musik | Music | 455 | 2018-08-07T14:00:23.088590+03:00 | 3 | 368 | {} | [455] | 0 | 1403 | 4 | 19 | 14 | 1 | |||||||||||||||||||||||||||||||
446 | [] | Pelit | Spel | Games | 503 | 2018-08-07T14:00:23.094780+03:00 | 3 | 368 | {} | [503] | 0 | 1403 | 1 | 24 | 15 | 8 | |||||||||||||||||||||||||||||||
448 | [] | Pingis | Bordtennis | Table tennis | 515 | 2018-08-07T14:00:23.100999+03:00 | 3 | 368 | {} | [515] | 1 | 1403 | 1 | 17 | 12 | 4 | |||||||||||||||||||||||||||||||
449 | [] | Poikakerho / poikaryhmät | Pojkklubb / pojkgrupper | Boys' club / Boy groups | 518 | 2018-08-07T14:00:23.107321+03:00 | 3 | 368 | {} | [518] | 0 | 1403 | 1 | 16 | 14 | 1 | |||||||||||||||||||||||||||||||
452 | [] | Puutyö | Slöjd | Woodwork | 534 | 2018-08-07T14:00:23.113213+03:00 | 3 | 368 | {} | [534] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
453 | [] | Pyöräkoulu | Cykelskola | Bicycle school | 541 | 2018-08-07T14:00:23.119521+03:00 | 3 | 368 | {} | [541] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
454 | [] | Pöytäfutis | Bordfotboll | Table football | 554 | 2018-08-07T14:00:23.125546+03:00 | 3 | 368 | {} | [554] | 0 | 1403 | 11 | 10 | 1 | ||||||||||||||||||||||||||||||||
455 | [] | Pöytäjääkiekko | Bordshockey | Table hockey | 555 | 2018-08-07T14:00:23.132016+03:00 | 3 | 368 | {} | [555] | 0 | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
458 | [] | Retkeily | Camping | Trekking | 580 | 2018-08-07T14:00:23.138224+03:00 | 3 | 368 | {} | [580] | 0 | 1403 | 2 | 7 | 5 | ||||||||||||||||||||||||||||||||
467 | [] | Skeittaus | Skateboardåkning | Skateboarding | 629 | 2018-08-07T14:00:23.144513+03:00 | 3 | 368 | {} | [629] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
468 | [] | Soitonopetus | Instrumentundervisning | Teaching music | 632 | 2018-08-07T14:00:23.150860+03:00 | 3 | 368 | {} | [632] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
470 | [] | Sähly | Innebandy | Floorball | 670 | 2018-08-07T14:00:23.157134+03:00 | 3 | 368 | {} | [670] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
473 | [] | Tanssi | Dans | Dance | 685 | 2018-08-07T14:00:23.163347+03:00 | 3 | 368 | {} | [685] | 0 | 1403 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
480 | [] | Tyttökerho / tyttöryhmät | Flickklubb / flickgrupper | Girls' club / Girl groups | 722 | 2018-08-07T14:00:23.175639+03:00 | 3 | 368 | {} | [722] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
481 | [] | Valokuvaus | Fotografering | Photography | 741 | 2018-08-07T14:00:23.182310+03:00 | 3 | 368 | {} | [741] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
485 | [] | Viikonlopputoiminta | Veckoslutsverksamhet | Weekend activities | 789 | 2018-08-07T14:00:23.188643+03:00 | 3 | 368 | {} | [789] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
490 | [] | Nuorten neuvonta ja ohjaus | Rådgivning och handledning för ungdomar | Advice and guidance for young people | 471 | 2018-08-07T14:00:23.202058+03:00 | 2 | 365 | {} | [471] | 0 | 1403 | 7 | 22 | 3 | 12 | |||||||||||||||||||||||||||||||
492 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:22.690959+03:00 | 3 | 491 | {} | [238] | 0 | 1403 | 49 | 49 | |||||||||||||||||||||||||||||||||
493 | [494, 495, 496, 497, 498] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:22.700110+03:00 | 3 | 491 | {} | [] | 0 | 1403 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
494 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:22.710417+03:00 | 4 | 493 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1403 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
495 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:22.718157+03:00 | 4 | 493 | {} | [319] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
496 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:22.725829+03:00 | 4 | 493 | {} | [320] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
497 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:22.733778+03:00 | 4 | 493 | {} | [321] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
498 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:22.741237+03:00 | 4 | 493 | {} | [480] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
500 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.940551+02:00 | 4 | 499 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1403 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
503 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:22.776545+03:00 | 2 | 343 | {} | [532] | 0 | 1403 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
507 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:22.812763+03:00 | 3 | 505 | {} | [326] | 0 | 1403 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
511 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.844464+03:00 | 3 | 505 | {} | [804] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
552 | [553, 2007] | Eläinurheilualueet | Anläggningar för djursport | Animal sports areas | 2018-08-07T14:00:23.225274+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 27 | 75 | 31 | 17 | ||||||||||||||||||||||||||||||||
553 | [554, 555, 556, 557] | Hevosurheilu | Hästsport | Equestrian sports | 2018-08-07T14:00:23.231236+03:00 | 3 | 552 | {} | [] | 0 | 1403 | 19 | 64 | 31 | 14 | ||||||||||||||||||||||||||||||||
554 | [] | Esteratsastuskenttä | Bana för banhoppning | Show jumping field | 166 | 2018-08-07T14:00:23.236991+03:00 | 4 | 553 | {} | [166] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
555 | [] | Ratsastuskenttä | Ridbana | Equestrian field | 574 | 2018-08-07T14:00:23.243825+03:00 | 4 | 553 | {} | [574] | 0 | 1403 | 8 | 36 | 20 | 8 | |||||||||||||||||||||||||||||||
556 | [] | Ratsastusmaneesi | Ridmanege | Riding manège | 575 | 2018-08-07T14:00:23.250876+03:00 | 4 | 553 | {} | [575] | 0 | 1403 | 8 | 24 | 10 | 6 | |||||||||||||||||||||||||||||||
557 | [] | Ravirata | Travbana | Horse racing track | 578 | 2018-08-07T14:00:23.257255+03:00 | 4 | 553 | {} | [578] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
559 | [560, 561, 562, 563] | Ampumaurheilupaikat | Sportskytteplatser | Shooting sports facilities | 2018-08-07T14:00:23.287538+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 6 | 10 | 1 | 3 | ||||||||||||||||||||||||||||||||
560 | [] | Ampumarata | Skjutbana | Open-air shooting range | 54 | 2018-08-07T14:00:23.293024+03:00 | 4 | 559 | {} | [54] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
561 | [] | Ampumaurheilukeskus | Sportskyttecentrum | Shooting sports centre | 55 | 2018-08-07T14:00:23.299465+03:00 | 4 | 559 | {} | [55] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
562 | [] | Jousiammuntamaastorata | Terrängbana för bågskytte. | Field archery course | 212 | 2018-08-07T14:00:23.305715+03:00 | 4 | 559 | {} | [212] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
563 | [] | Jousiammuntarata | Bågskyttebana | Archery range | 213 | 2018-08-07T14:00:23.312216+03:00 | 4 | 559 | {} | [213] | 0 | 1403 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
565 | [] | Harjoitushyppyrimäki | Träningshoppbacke | Ski jumping hill for training | 186 | 2018-08-07T14:00:23.324523+03:00 | 4 | 564 | {} | [186] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
567 | [568, 569] | Katetut talviurheilupaikat | Vintersportplatser under tak | Covered winter sports facilities | 2018-08-07T14:00:23.339639+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 2 | ||||||||||||||||||||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
569 | [] | Hiihtotunneli | Skidtunnel | Ski tunnel | 194 | 2018-08-07T14:00:23.351595+03:00 | 4 | 567 | {} | [194] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
572 | [573, 574] | Kiipeilypaikat | Klättringsplatser | Climbing venues | 2018-08-07T14:00:23.370651+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 5 | 14 | 6 | 3 | ||||||||||||||||||||||||||||||||
573 | [] | Kiipeilykallio | Klätterberg | Climbing rock | 306 | 2018-08-07T14:00:23.375633+03:00 | 4 | 572 | {} | [306] | 0 | 1403 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
574 | [] | Ulkokiipeilyseinä | Utomhusklättervägg | Open-air climbing wall | 736 | 2018-08-07T14:00:23.381720+03:00 | 4 | 572 | {} | [736] | 0 | 1403 | 5 | 10 | 5 | ||||||||||||||||||||||||||||||||
579 | [] | Hevosreitti | Hästled | Horse track | 190 | 2018-08-07T14:00:23.406242+03:00 | 4 | 577 | {} | [190] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
580 | [] | Koirahiihtolatu | Spår för hundspann | Dog skijoring track | 318 | 2018-08-07T14:00:23.413028+03:00 | 4 | 577 | {} | [318] | 0 | 1403 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
582 | [] | Kävelyreitti | Promenadled/Friluftsled | Outdoor route | 364 | 2018-08-07T14:00:23.426422+03:00 | 4 | 577 | {} | [364] | 0 | 1403 | 23 | 42 | 18 | 1 | |||||||||||||||||||||||||||||||
585 | [] | Maastopyöräilyreitti | Mountainbikeled | Cross-country biking route | 425 | 2018-08-07T14:00:23.448007+03:00 | 4 | 577 | {} | [425] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
586 | [] | Melontareitti | Paddlingsled | Canoe route | 434 | 2018-08-07T14:00:23.454892+03:00 | 4 | 577 | {} | [434] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
590 | [] | Retkeilyreitti | Utflyktsled | Hiking route | 582 | 2018-08-07T14:00:23.482263+03:00 | 4 | 577 | {} | [582] | 0 | 1403 | 4 | 19 | 2 | 8 | 5 | ||||||||||||||||||||||||||||||
592 | [593, 594, 595, 596] | Maastohiihtokeskukset | Längdåkningscentra | Cross-country ski resorts | 2018-08-07T14:00:23.496608+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 3 | 8 | 1 | 2 | 2 | |||||||||||||||||||||||||||||||
593 | [] | Ampumahiihdon harjoittelualue | Träningsområde för skidskytte | Training area for biathlon | 52 | 2018-08-07T14:00:23.502563+03:00 | 4 | 592 | {} | [52] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
594 | [] | Ampumahiihtokeskus | Skidskyttecentrum | Biathlon centre | 53 | 2018-08-07T14:00:23.509751+03:00 | 4 | 592 | {} | [53] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
596 | [] | Kilpahiihtokeskus | Skidtävlingscentrum | Ski competition centre | 307 | 2018-08-07T14:00:23.524927+03:00 | 4 | 592 | {} | [307] | 0 | 1403 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
597 | [600] | Suunnistusalueet | Orienteringsområden | Orienteering areas | 2018-08-07T14:00:23.531981+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
600 | [] | Suunnistusalue | Orienteringsområde | Orienteering area | 666 | 2018-08-07T14:00:23.551634+03:00 | 4 | 597 | {} | [666] | 0 | 1403 | 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 );