service_node
297 rows where root = 1403
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||
575 | [576] | Laskettelurinteet ja rinnehiihtokeskukset | Slalombackar och alpina skidcentra | Ski slopes and downhill ski resorts | 2018-08-07T14:00:23.388106+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 6 | 2 | 2 | ||||||||||||||||||||||||||||||||
576 | [] | Laskettelun suorituspaikat | Slalombackar och alpina skidcentra | Ski slopes and downhill ski resorts | 376 | 2018-08-07T14:00:23.393272+03:00 | 4 | 575 | {} | [376] | 0 | 1403 | 2 | 6 | 2 | 2 | |||||||||||||||||||||||||||||||
577 | [579, 580, 581, 582, 583, 584, 585, 586, 590] | Liikunta- ja ulkoilureitit | Idrotts- och friluftsleder | Sports and outdoor recreation routes | 2018-08-07T14:00:23.400833+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 132 | 401 | 3 | 1 | 1 | 105 | 147 | 9 | 3 | |||||||||||||||||||||||||||
578 | [] | Frisbeegolf-rata | Frisbeegolfbana | Disc golf course | 169 | 2018-08-07T14:00:23.883764+03:00 | 4 | 646 | {} | [169] | 0 | 1403 | 8 | 27 | 10 | 8 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
581 | [] | Kuntorata | Konditionsbana | Jogging track | 348 | 2018-08-07T14:00:23.419850+03:00 | 4 | 577 | {} | [348] | 0 | 1403 | 45 | 82 | 22 | 14 | 1 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
583 | [] | Latu | Skidspår | Ski track | 191 | 2018-08-07T14:00:23.433650+03:00 | 4 | 577 | {} | [191] | 0 | 1403 | 45 | 208 | 2 | 1 | 39 | 117 | 3 | 1 | |||||||||||||||||||||||||||
584 | [] | Luontopolku | Naturstig | Nature trail | 413 | 2018-08-07T14:00:23.440979+03:00 | 4 | 577 | {} | [413] | 0 | 1403 | 12 | 41 | 1 | 1 | 24 | 1 | 1 | 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 | |||||||||||||||||||||||||||||||||
601 | [602, 606, 608, 614, 624] | Sisäliikuntatilat | Anläggningar för inomhusidrott | Indoor sports facilities | 2018-08-07T14:00:23.557871+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 795 | 1314 | 278 | 229 | 12 | |||||||||||||||||||||||||||||||
602 | [603, 604] | Jäähallit | Ishallar | Ice-skating arenas | 2018-08-07T14:00:23.562977+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 12 | 24 | 7 | 4 | 1 | |||||||||||||||||||||||||||||||
603 | [] | Harjoitusjäähalli | Övningsishall | Training ice arena | 187 | 2018-08-07T14:00:23.568317+03:00 | 4 | 602 | {} | [187] | 0 | 1403 | 10 | 17 | 5 | 2 | |||||||||||||||||||||||||||||||
604 | [] | Kilpajäähalli | Tävlingsishall | Competition ice arena | 308 | 2018-08-07T14:00:23.575267+03:00 | 4 | 602 | {} | [308] | 0 | 1403 | 2 | 7 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||
606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
607 | [] | Keilahalli | Bowlinghall | Bowling alley | 285 | 2018-08-07T14:00:23.595829+03:00 | 4 | 606 | {} | [285] | 0 | 1403 | 7 | 11 | 2 | 2 | |||||||||||||||||||||||||||||||
608 | [609, 610, 611, 612, 613] | Kuntoilukeskukset ja liikuntasalit | Konditionsidrottscentra och idrottssalar | Fitness centres and sports halls | 2018-08-07T14:00:23.602837+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 576 | 949 | 188 | 177 | 8 | |||||||||||||||||||||||||||||||
609 | [] | Kamppailulajien sali | Sal för kampsport | Martial arts hall | 241 | 2018-08-07T14:00:23.609044+03:00 | 4 | 608 | {} | [241] | 0 | 1403 | 47 | 64 | 13 | 4 | |||||||||||||||||||||||||||||||
610 | [] | Kuntokeskus | Konditionsidrottscentrum | Fitness centre | 625 | 2018-08-07T14:00:23.616327+03:00 | 4 | 608 | {} | [625] | 0 | 1403 | 48 | 97 | 28 | 20 | 1 | ||||||||||||||||||||||||||||||
611 | [] | Kuntosali | Gym | Gym | 350 | 2018-08-07T14:00:23.623495+03:00 | 4 | 608 | {} | [350] | 0 | 1403 | 151 | 237 | 45 | 39 | 2 | ||||||||||||||||||||||||||||||
612 | [] | Liikuntasali | Idrottssal | Gymnastics hall | 402 | 2018-08-07T14:00:23.630490+03:00 | 4 | 608 | {} | [402] | 0 | 1403 | 308 | 512 | 97 | 102 | 5 | ||||||||||||||||||||||||||||||
613 | [] | Voimailusali | Styrketräningssal | Weight training hall | 797 | 2018-08-07T14:00:23.637831+03:00 | 4 | 608 | {} | [797] | 0 | 1403 | 22 | 39 | 5 | 12 | |||||||||||||||||||||||||||||||
614 | [615, 616, 617, 618, 619, 620, 621, 622, 623] | Liikuntahallit | Idrottshallar | Sports halls | 2018-08-07T14:00:23.644666+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 149 | 233 | 60 | 22 | 2 | |||||||||||||||||||||||||||||||
615 | [] | Jalkapallohalli | Fotbollshall | Football hall | 204 | 2018-08-07T14:00:23.650553+03:00 | 4 | 614 | {} | [204] | 0 | 1403 | 8 | 18 | 6 | 3 | 1 | ||||||||||||||||||||||||||||||
616 | [] | Liikuntahalli | Idrottshall | Sports hall | 400 | 2018-08-07T14:00:23.657783+03:00 | 4 | 614 | {} | [400] | 0 | 1403 | 24 | 38 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||
617 | [] | Monitoimihalli / areena | Allaktivitetshall/multiarena | Multipurpose hall/arena | 444 | 2018-08-07T14:00:23.665496+03:00 | 4 | 614 | {} | [444] | 0 | 1403 | 97 | 133 | 36 | ||||||||||||||||||||||||||||||||
618 | [] | Petanque - halli | Petanquehall | Petanque hall | 512 | 2018-08-07T14:00:23.673008+03:00 | 4 | 614 | {} | [512] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
619 | [] | Salibandyhalli | Innebandyhall | Floorball hall | 616 | 2018-08-07T14:00:23.680694+03:00 | 4 | 614 | {} | [616] | 0 | 1403 | 4 | 12 | 4 | 4 | |||||||||||||||||||||||||||||||
620 | [] | Skeittihalli | Skateboardhall | Skateboarding hall | 631 | 2018-08-07T14:00:23.687502+03:00 | 4 | 614 | {} | [631] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
621 | [] | Squash-halli | Squashhall | Squash hall | 645 | 2018-08-07T14:00:23.695720+03:00 | 4 | 614 | {} | [645] | 0 | 1403 | 4 | 10 | 5 | 1 | |||||||||||||||||||||||||||||||
622 | [] | Sulkapallohalli | Badmintonhall | Badminton hall | 647 | 2018-08-07T14:00:23.705272+03:00 | 4 | 614 | {} | [647] | 0 | 1403 | 9 | 18 | 5 | 4 | |||||||||||||||||||||||||||||||
623 | [] | Tennishalli | Tennishall | Tennis hall | 699 | 2018-08-07T14:00:23.714268+03:00 | 4 | 614 | {} | [699] | 0 | 1403 | 13 | 23 | 7 | 3 | |||||||||||||||||||||||||||||||
624 | [625, 626, 627, 628, 629, 630, 631, 632] | Yksittäiset lajikohtaiset sisäliikuntapaikat | Enstaka grenspecifika anläggningar för inomhusidrott | Indoor venues for various sports | 2018-08-07T14:00:23.722887+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 118 | 186 | 43 | 24 | 1 | |||||||||||||||||||||||||||||||
625 | [] | Miekkailutila | Utrymme för fäktning | Fencing venue | 439 | 2018-08-07T14:00:23.729643+03:00 | 4 | 624 | {} | [439] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
626 | [] | Parkour- Sali | Parkoursal | Parkour hall | 500 | 2018-08-07T14:00:23.737371+03:00 | 4 | 624 | {} | [500] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
627 | [] | Pöytätennistila | Utrymme för bordtennis | Table tennis venue | 556 | 2018-08-07T14:00:23.745237+03:00 | 4 | 624 | {} | [556] | 0 | 1403 | 22 | 46 | 22 | 2 | |||||||||||||||||||||||||||||||
628 | [] | Sisäampumarata | Inomhusskjutbana | Indoor shooting range | 623 | 2018-08-07T14:00:23.753170+03:00 | 4 | 624 | {} | [623] | 0 | 1403 | 5 | 7 | 1 | 1 | |||||||||||||||||||||||||||||||
629 | [] | Sisäkiipeilyseinä | Klättervägg inomhus | Indoor climbing wall | 624 | 2018-08-07T14:00:23.760205+03:00 | 4 | 624 | {} | [624] | 0 | 1403 | 14 | 19 | 3 | 2 | |||||||||||||||||||||||||||||||
630 | [] | Tanssitila | Utrymme för dans | Dance studio | 687 | 2018-08-07T14:00:23.767727+03:00 | 4 | 624 | {} | [687] | 0 | 1403 | 58 | 71 | 10 | 3 | |||||||||||||||||||||||||||||||
631 | [] | Telinevoimistelutila | Utrymme för redskapsgymnastik | Artistic gymnastics facility | 697 | 2018-08-07T14:00:23.775695+03:00 | 4 | 624 | {} | [697] | 0 | 1403 | 6 | 15 | 5 | 4 | |||||||||||||||||||||||||||||||
632 | [] | Yksittäinen yleisurheilun suorituspaikka | Enstaka övningsplats för friidrott | Stand-alone athletics venue | 810 | 2018-08-07T14:00:23.783286+03:00 | 4 | 624 | {} | [810] | 0 | 1403 | 9 | 22 | 12 | 1 | |||||||||||||||||||||||||||||||
633 | [634, 639, 646, 654, 663] | Ulkokentät ja liikuntapuistot | Utomhusplaner och idrottsparker | Outdoor fields and sports parks | 2018-08-07T14:00:23.790680+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 1261 | 2383 | 1 | 1 | 636 | 457 | 4 | 23 | ||||||||||||||||||||||||||||
634 | [635, 636, 637, 638] | Golfkentät | Golfbanor | Golf courses | 2018-08-07T14:00:23.796742+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 18 | 50 | 23 | 9 | ||||||||||||||||||||||||||||||||
635 | [] | Golfin harjoitusalue | Träningsområde för golf | Golf training area | 173 | 2018-08-07T14:00:23.802245+03:00 | 4 | 634 | {} | [173] | 0 | 1403 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
636 | [] | Golfin harjoitushalli | Övningshall för golf | Golf training hall | 174 | 2018-08-07T14:00:23.808994+03:00 | 4 | 634 | {} | [174] | 0 | 1403 | 6 | 10 | 4 | ||||||||||||||||||||||||||||||||
637 | [] | Golfkenttä | Golfbana | Golf course | 175 | 2018-08-07T14:00:23.815939+03:00 | 4 | 634 | {} | [175] | 0 | 1403 | 4 | 16 | 9 | 3 | |||||||||||||||||||||||||||||||
638 | [] | Ratagolf | Bangolf | Minigolf course | 573 | 2018-08-07T14:00:23.822729+03:00 | 4 | 634 | {} | [573] | 0 | 1403 | 7 | 18 | 7 | 4 | |||||||||||||||||||||||||||||||
639 | [641, 642, 643, 644, 645] | Jääurheilualueet ja luonnonjäät | Isidrottsområden och naturisar | Ice sports areas and sites with natural ice | 2018-08-07T14:00:23.829697+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 165 | 358 | 114 | 77 | 2 | |||||||||||||||||||||||||||||||
641 | [] | Kaukalo | Rink | Rink | 235 | 2018-08-07T14:00:23.842218+03:00 | 4 | 639 | {} | [235] | 0 | 1403 | 13 | 15 | 2 | ||||||||||||||||||||||||||||||||
642 | [] | Luistelukenttä | Skridskobana | Ice-skating field | 406 | 2018-08-07T14:00:23.848959+03:00 | 4 | 639 | {} | [406] | 0 | 1403 | 136 | 308 | 100 | 70 | 2 | ||||||||||||||||||||||||||||||
643 | [] | Luistelureitti | Skridskoled | Ice-skating route | 407 | 2018-08-07T14:00:23.856181+03:00 | 4 | 639 | {} | [407] | 0 | 1403 | 4 | 9 | 2 | 3 | |||||||||||||||||||||||||||||||
644 | [] | Pikaluistelurata | Bana hastighetsåkning på skridsko | Speed-skating track | 514 | 2018-08-07T14:00:23.862975+03:00 | 4 | 639 | {} | [514] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
645 | [] | Tekojääkenttä | Konstis | Mechanically frozen open-air ice rink | 695 | 2018-08-07T14:00:23.870223+03:00 | 4 | 639 | {} | [695] | 0 | 1403 | 11 | 25 | 10 | 4 | |||||||||||||||||||||||||||||||
646 | [578, 647, 648, 649, 650, 651, 652, 653] | Lähiliikunta ja liikuntapuistot | Närmotion och idrottsparker | Neighbourhood sports facilities and parks | 2018-08-07T14:00:23.877348+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 345 | 650 | 1 | 196 | 95 | 3 | 10 | |||||||||||||||||||||||||||||
647 | [] | Liikuntapuisto | Idrottspark | Sports park | 401 | 2018-08-07T14:00:23.890605+03:00 | 4 | 646 | {} | [401] | 0 | 1403 | 7 | 3 | 2 | 2 | |||||||||||||||||||||||||||||||
648 | [] | Lähiliikuntapaikka | Näridrottsplats | Neighbourhood sports area | 415 | 2018-08-07T14:00:23.898085+03:00 | 4 | 646 | {} | [415] | 0 | 1403 | 134 | 229 | 1 | 64 | 26 | 4 | |||||||||||||||||||||||||||||
649 | [] | Parkour- alue | Parkourområde | Parkour area | 499 | 2018-08-07T14:00:23.905280+03:00 | 4 | 646 | {} | [499] | 0 | 1403 | 2 | 11 | 5 | 4 | |||||||||||||||||||||||||||||||
650 | [] | Pyöräilyalue | Cykelåkningsområde | Cycling area | 538 | 2018-08-07T14:00:23.912521+03:00 | 4 | 646 | {} | [538] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
651 | [] | Pyöräilyrata | Cykelåkningsbana | Velodrome | 539 | 2018-08-07T14:00:23.920549+03:00 | 4 | 646 | {} | [539] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
652 | [] | Skeitti / rullaluistelupaikka | Plats för skejtning/rullskridskoåkning | Skateboarding/roller-blading rink | 630 | 2018-08-07T14:00:23.929996+03:00 | 4 | 646 | {} | [630] | 0 | 1403 | 27 | 51 | 11 | 12 | 1 | ||||||||||||||||||||||||||||||
653 | [] | Ulkokuntoiluvälineet | Konditionspark för utomhusaktiviteter | Fitness training park | 737 | 2018-08-07T14:00:23.939410+03:00 | 4 | 646 | {} | [737] | 0 | 1403 | 168 | 320 | 100 | 43 | 3 | 6 | |||||||||||||||||||||||||||||
654 | [655, 656, 657, 658, 659, 660, 661, 662] | Pallokentät | Bollplaner | Ball games courts | 2018-08-07T14:00:23.947305+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 697 | 1266 | 1 | 283 | 273 | 1 | 11 | |||||||||||||||||||||||||||||
655 | [] | Beachvolleykenttä | Beachvolleyplan | Beach volleyball court | 125 | 2018-08-07T14:00:23.954884+03:00 | 4 | 654 | {} | [125] | 0 | 1403 | 39 | 85 | 27 | 18 | 1 | ||||||||||||||||||||||||||||||
656 | [] | Jalkapallostadion | Fotbollsstadion | Football stadium | 205 | 2018-08-07T14:00:23.964244+03:00 | 4 | 654 | {} | [205] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
657 | [] | Koripallokenttä | Basketplan | Basketball court | 331 | 2018-08-07T14:00:23.971455+03:00 | 4 | 654 | {} | [331] | 0 | 1403 | 153 | 256 | 64 | 37 | 2 | ||||||||||||||||||||||||||||||
658 | [] | Lentopallokenttä | Volleybollplan | Volleyball court | 392 | 2018-08-07T14:00:23.980139+03:00 | 4 | 654 | {} | [392] | 0 | 1403 | 46 | 86 | 1 | 10 | 28 | 1 | |||||||||||||||||||||||||||||
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
660 | [] | Pesäpallostadion | Bobollsstadion | Baseball stadium | 511 | 2018-08-07T14:00:23.995997+03:00 | 4 | 654 | {} | [511] | 0 | 1403 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
661 | [] | Rullakiekkokenttä | Inlinehockeyplan | Roller hockey field | 585 | 2018-08-07T14:00:24.003615+03:00 | 4 | 654 | {} | [585] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
662 | [] | Tenniskenttäalue | Område med tennisbanor | Tennis court area | 700 | 2018-10-25T08:00:07.016431+03:00 | 4 | 654 | {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} | [700] | 0 | 1403 | 45 | 83 | 11 | 25 | 2 | ||||||||||||||||||||||||||||||
663 | [664, 665] | Yleisurheilukentät ja -paikat | Planer och platser för friidrott | Athletics fields and venues | 2018-08-07T14:00:24.019648+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 36 | 59 | 20 | 3 | ||||||||||||||||||||||||||||||||
664 | [] | Yleisurheilukenttä | Friidrottsplan | Athletics field | 817 | 2018-08-07T14:00:24.025516+03:00 | 4 | 663 | {} | [817] | 0 | 1403 | 8 | 17 | 6 | 3 | |||||||||||||||||||||||||||||||
665 | [] | Yleisurheilun harjoitusalue | Träningsområde för friidrott | Athletics training area | 818 | 2018-08-07T14:00:24.033733+03:00 | 4 | 663 | {} | [818] | 0 | 1403 | 28 | 42 | 14 | ||||||||||||||||||||||||||||||||
666 | [667, 675, 677] | Vene-, ilmailu- ja moottoriurheilu | Anläggningar för båtsport, flygsport och motorsport | Boating, aviation and motor sports | 2018-08-07T14:00:24.041279+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 9 | 18 | 3 | 6 | ||||||||||||||||||||||||||||||||
667 | [668, 670, 672, 673, 674] | Moottoriurheilualueet | Områden för motorsport | Motor sports areas | 2018-08-07T14:00:24.047385+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 4 | 12 | 2 | 6 | ||||||||||||||||||||||||||||||||
668 | [] | Jokamies- ja rallicross -rata | Allemans- och rallycrossbana | Everyman racing and rallycross track | 208 | 2018-08-07T14:00:24.052754+03:00 | 4 | 667 | {} | [208] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
670 | [] | Karting-rata | Kartingbana | Kart circuit | 245 | 2018-08-07T14:00:24.066651+03:00 | 4 | 667 | {} | [245] | 0 | 1403 | 2 | 5 | 1 | 2 | |||||||||||||||||||||||||||||||
672 | [] | Moottoripyöräilyalue | Område för motorcykelsport | Motorcycling area | 448 | 2018-08-07T14:00:24.080942+03:00 | 4 | 667 | {} | [448] | 0 | 1403 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
673 | [] | Moottorirata | Motorbana | Formula race track | 449 | 2018-08-07T14:00:24.087804+03:00 | 4 | 667 | {} | [449] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
674 | [] | Moottoriurheilukeskus | Centrum för motorsport | Motor sports centre | 450 | 2018-08-07T14:00:24.095559+03:00 | 4 | 667 | {} | [450] | 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 );