service_node
360 rows where level = 4 sorted by unit_count_municipality_vantaa
This data as json, CSV (advanced)
Suggested facets: children, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
154 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:30.213017+03:00 | 4 | 149 | {} | [803] | 0 | 1401 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
155 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:30.219845+03:00 | 4 | 149 | {} | [804] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
157 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:30.231632+03:00 | 4 | 156 | {} | [393] | 0 | 1401 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
158 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:30.238264+03:00 | 4 | 156 | {} | [718] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
159 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:30.247429+03:00 | 4 | 156 | {} | [765] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
160 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:30.257660+03:00 | 4 | 156 | {} | [494] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
161 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:30.270249+03:00 | 4 | 156 | {} | [706] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
162 | [] | Vihertukkutilojen vuokraus | Uthyrning av lokaler för grönsaksgrossister | Green wholesale trade space rental | 788 | 2018-08-07T14:00:30.280128+03:00 | 4 | 156 | {} | [788] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
199 | [] | kirjanpito | bokföring | accounting | 675 | 2018-08-07T14:00:30.577311+03:00 | 4 | 198 | {} | [675] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
200 | [] | laskutuksen asiakasmaksut | faktureringens kundavgifter | customer payments for invoicing | 674 | 2018-08-07T14:00:30.584039+03:00 | 4 | 198 | {} | [674] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
201 | [] | laskutus | fakturering | invoicing | 676 | 2018-08-07T14:00:30.590863+03:00 | 4 | 198 | {} | [676] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
202 | [] | maksukattoasiat | betalningstakärenden | issues regarding payment limits | 677 | 2018-08-07T14:00:30.597368+03:00 | 4 | 198 | {} | [677] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
203 | [] | maksuliikenne | penningrörelse | payment transactions | 678 | 2018-08-07T14:00:30.605414+03:00 | 4 | 198 | {} | [678] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
204 | [] | ostolaskut | köpfakturor | incoming invoices | 679 | 2018-08-07T14:00:30.612437+03:00 | 4 | 198 | {} | [679] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
205 | [] | palkanlaskenta | löneräkning | payroll administration | 680 | 2018-08-07T14:00:30.620039+03:00 | 4 | 198 | {} | [680] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
206 | [] | suoritukset | betalningar | payments | 681 | 2018-08-07T14:00:30.628457+03:00 | 4 | 198 | {} | [681] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
207 | [] | täsmäykset | avstämningar | synchronisation | 682 | 2018-08-07T14:00:30.636668+03:00 | 4 | 198 | {} | [682] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
208 | [] | yleisökassa | kassa för allmänheten | public fund | 269 | 2018-08-07T14:00:30.645432+03:00 | 4 | 198 | {} | [269] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
210 | [] | antolainat | utlåning | advances | 260 | 2018-08-07T14:00:30.661409+03:00 | 4 | 209 | {} | [260] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
211 | [] | henkilöstökassa | personalkassa | personnel fund | 262 | 2018-08-07T14:00:30.669740+03:00 | 4 | 209 | {} | [262] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
213 | [] | konserniohjaus | koncernstyrning | consolidated corporation guidance | 227 | 2018-08-07T14:00:30.685091+03:00 | 4 | 209 | {} | [227] | 0 | 1401 | 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 | |||||||||||||||||||||||||||||||
234 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 178 | 2020-12-02T12:30:08.656880+02:00 | 4 | 233 | {} | [178] | 0 | 1400 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
274 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:22.341217+03:00 | 4 | 272 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
275 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:22.348354+03:00 | 4 | 272 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
281 | [] | Jatkuva valvonta | Kontinuerlig tillsyn | Continuous monitoring | 562 | 2018-08-07T14:00:22.381961+03:00 | 4 | 279 | {} | [562] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
283 | [] | Rakennusrasitteet | Byggnadsservitut | Building easements | 559 | 2018-08-07T14:00:22.397931+03:00 | 4 | 279 | {} | [559] | 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 | |||||||||||||||||||||||||||||||||
290 | [] | Kilpipalvelut | Skylttjänster | Sign services | 481 | 2018-08-07T14:00:22.444787+03:00 | 4 | 287 | {} | [481] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
291 | [] | Materiaalipalvelut | Materialservice | Material services | 564 | 2018-08-07T14:00:22.451320+03:00 | 4 | 287 | {} | [564] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
296 | [] | Mullan myynti ja toimitus | Försäljning och leverans av mylla | Selling and delivering soil | 453 | 2018-08-07T14:00:22.477143+03:00 | 4 | 293 | {} | [453] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
299 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:22.497732+03:00 | 4 | 293 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
301 | [] | Vesilaskut ja asiakaspalvelu | Vattenfakturering och kundtjänst | Billing for water and customer services | 67+781 | 2018-10-25T08:00:06.456994+03:00 | 4 | 293 | {} | [781, 67] | 0 | 1400 | 26 | 26 | |||||||||||||||||||||||||||||||||
303 | [304] | Aluerakentaminen | Områdesbyggandet | Regional construction | 2018-08-07T14:00:22.515802+03:00 | 4 | 302 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
332 | [] | WLAN-ulkopisteet | WLAN-utomhusstationer | WLAN outlets | 807 | 2018-08-07T14:00:24.889824+03:00 | 4 | 330 | {} | [807] | 0 | 1402 | 10 | 10 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
543 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 183 | 2018-08-07T14:00:25.201364+03:00 | 4 | 542 | {} | [183] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
544 | [] | Kansainvälisten risteilyalusten laiturit | Kajer för internationella kryssningsfartyg | Piers for international cruisers | 242 | 2018-08-07T14:00:25.208722+03:00 | 4 | 542 | {} | [242] | 0 | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
545 | [] | Terminaalit | Terminaler | Terminals | 782 | 2018-08-07T14:00:25.217022+03:00 | 4 | 542 | {} | [782] | 0 | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
546 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.230897+03:00 | 4 | 542 | {} | [769] | 0 | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
548 | [] | Ulkoilusaaret | Friluftsöar | Recreational islands | 735 | 2018-10-25T08:00:07.487309+03:00 | 4 | 547 | {} | [735] | 0 | 1402 | 54 | 69 | 1 | 2 | 1 | 1 | 1 | 9 | |||||||||||||||||||||||||||
549 | [] | Veneiden talvisäilytys | Vinterförvaring av båtar | Winter storage for boats | 768 | 2018-08-07T14:00:25.255633+03:00 | 4 | 547 | {} | [768] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
557 | [] | Ravirata | Travbana | Horse racing track | 578 | 2018-08-07T14:00:23.257255+03:00 | 4 | 553 | {} | [578] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
620 | [] | Skeittihalli | Skateboardhall | Skateboarding hall | 631 | 2018-08-07T14:00:23.687502+03:00 | 4 | 614 | {} | [631] | 0 | 1403 | 2 | 3 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
641 | [] | Kaukalo | Rink | Rink | 235 | 2018-08-07T14:00:23.842218+03:00 | 4 | 639 | {} | [235] | 0 | 1403 | 13 | 15 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
673 | [] | Moottorirata | Motorbana | Formula race track | 449 | 2018-08-07T14:00:24.087804+03:00 | 4 | 667 | {} | [449] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
676 | [] | Urheiluilmailualue | Område för flygsport | Sport aviation area | 739 | 2018-08-07T14:00:24.108363+03:00 | 4 | 675 | {} | [739] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
681 | [] | Soudun ja melonnan sisäharjoittelutila | Inomhusträningsutrymme för rodd och paddling | Indoor training facility for rowing and canoeing | 642 | 2018-08-07T14:00:24.143385+03:00 | 4 | 677 | {} | [642] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
682 | [] | Soutustadion | Roddstadion | Rowing stadium | 643 | 2018-08-07T14:00:24.150686+03:00 | 4 | 677 | {} | [643] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
683 | [] | Vesihiihtoalue | Område för vattenskidåkning | Water ski area | 777 | 2018-08-07T14:00:24.157225+03:00 | 4 | 677 | {} | [777] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
686 | [] | Maauimala | Utebassäng | Open-air pool | 426 | 2018-08-07T14:00:24.174926+03:00 | 4 | 685 | {} | [426] | 0 | 1403 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
698 | [] | Luontotorni | Naturtorn | Nature observation tower | 414 | 2018-08-07T14:00:24.259792+03:00 | 4 | 695 | {} | [414] | 0 | 1403 | 1 | 12 | 1 | 10 | |||||||||||||||||||||||||||||||
700 | [] | Rantautumispaikka | Ilandstigningsplats | Boat dock | 571 | 2018-08-07T14:00:24.275183+03:00 | 4 | 695 | {} | [571] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
701 | [] | Ruoanlaittopaikka | Matlagningsplats | Cooking facilities | 586 | 2018-08-07T14:00:24.282789+03:00 | 4 | 695 | {} | [586] | 0 | 1403 | 17 | 77 | 6 | 8 | 4 | 33 | 9 | ||||||||||||||||||||||||||||
702 | [] | Telttailu ja leiriytyminen | Tältning och läger | Camping | 698 | 2018-08-07T14:00:24.290069+03:00 | 4 | 695 | {} | [698] | 0 | 1403 | 2 | 12 | 1 | 8 | 1 | ||||||||||||||||||||||||||||||
703 | [] | Tupa | Stuga | Hut | 721 | 2018-08-07T14:00:24.296823+03:00 | 4 | 695 | {} | [721] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
704 | [] | Ulkoilumaja / hiihtomaja | Friluftsstuga / skidstuga | Outdoor/ski lodge | 734 | 2018-08-07T14:00:24.303405+03:00 | 4 | 695 | {} | [734] | 0 | 1403 | 3 | 8 | 4 | 1 | |||||||||||||||||||||||||||||||
705 | [] | Venesatama | Serviceplats för båtfarare | Boating services | 769 | 2018-08-07T14:00:24.310541+03:00 | 4 | 695 | {} | [769] | 0 | 1403 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
710 | [] | Matkailupalveluiden alue | Område med turisttjänster | Tourist services area | 430 | 2018-08-07T14:00:24.337371+03:00 | 4 | 706 | {} | [430] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
711 | [] | Monikäyttöalue, jolla on virkistyspalveluita | Allaktivitetsområde med rekreationstjänster | Multipurpose area with recreational services | 442 | 2018-08-07T14:00:24.344046+03:00 | 4 | 706 | {} | [442] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
712 | [] | Muu luonnonsuojelualue, jolla on virkistyspalveluita | Annat naturskyddsområde med rekreationstjänster | Other nature conservation area with recreational services | 458 | 2018-08-07T14:00:24.351095+03:00 | 4 | 706 | {} | [458] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
713 | [] | Retkeilyalue | Utflyktsområde | Hiking area | 581 | 2018-08-07T14:00:24.359089+03:00 | 4 | 706 | {} | [581] | 0 | 1403 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
714 | [] | Ulkoilualue | Friluftsområde | Outdoor area | 733 | 2018-08-07T14:00:24.366593+03:00 | 4 | 706 | {} | [733] | 0 | 1403 | 2 | 24 | 1 | 3 | 17 | 1 | |||||||||||||||||||||||||||||
716 | [] | Virkistysmetsä | Friluftsskog | Recreational forest | 791 | 2018-08-07T14:00:24.380867+03:00 | 4 | 706 | {} | [791] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
721 | [] | Eläintarha | Högholmens djurgård | Helsinki Zoo | 142 | 2018-08-07T14:00:24.428725+03:00 | 4 | 719 | {} | [142] | 0 | 1403 | 9 | 9 | |||||||||||||||||||||||||||||||||
723 | [] | Lipunmyynti | Biljettförsäljning | Ticket sales | 403 | 2018-08-07T14:00:24.435423+03:00 | 4 | 719 | {} | [403] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
724 | [] | Luonnonvaraisten eläinten hoitola | Vårdanstalt för vilda djur | Wildlife home | 411 | 2018-08-07T14:00:24.442228+03:00 | 4 | 719 | {} | [411] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
725 | [726, 727, 728, 729] | Ruokaa, juomaa ja ostoksia | Mat, dryck och inköp | Food, drinks and shopping | 2018-08-07T14:00:24.448965+03:00 | 4 | 719 | {} | [] | 0 | 1403 | 5 | 5 | ||||||||||||||||||||||||||||||||||
730 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 142*776 | 2018-08-07T14:00:24.485125+03:00 | 4 | 719 | {} | [776, 142] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
758 | [] | Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät | stadsstyrelsens och stadsförvaltningens beredningsuppgifter | preparatory assignments for City Government and City Council | 274 | 2018-08-07T14:00:30.769165+03:00 | 4 | 757 | {} | [274] | 0 | 1401 | 1 | 2 | 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 );