87 rows where root = 1402

View and edit SQL

Suggested facets: children, level, parent, keywords, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_kirkkonummi, unit_count_municipality_espoo, unit_count_municipality_vantaa, unit_count_municipality_kauniainen, last_modified_time (date)

root

  • 1402 · 87
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ää
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        
307 [308, 313, 309, 310, 312] Arkistot Arkiv Archives   2018-08-07T14:00:24.657353+03:00 2 306 {} 0 1402 4 11                                           2       4     1        
308 [] Asemakaava-arkisto Detaljplanearkiv Town plan archive 60 2018-08-07T14:00:24.662512+03:00 3 307 {} 0 1402   1                                                         1        
309 [] Kaupunginarkiston asiakaspalvelu Stadsarkivets kundtjänst City Archives customer service 65 2018-08-07T14:00:24.669496+03:00 3 307 {} 0 1402 2 4                                           1       1              
310 [] Kiinteistörekisteri Fastighetsregister Real estate register 305 2018-08-07T14:00:24.676288+03:00 3 307 {} 0 1402   4                                           1       3              
312 [] Rakennusvalvonnan arkisto Byggnadstillsynsverkets arkiv Building Control archive 561 2018-08-07T14:00:24.689378+03:00 3 307 {} 0 1402 1 1                                                                  
313 [] Katu-, puisto- ja rakennuspiirustusten arkisto Arkiv för gatu-, park- och byggnadsritningar Public works department archive 250 2018-08-07T14:00:24.696359+03:00 3 307 {} 0 1402 1 1                                                                  
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        
315 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:24.709417+03:00 3 314 {} 0 1402 2 4                                                   1     1        
316 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.717090+03:00 3 314 {} 0 1402 2 12                                           6       4              
317 [2138, 2135, 2137, 2136] Kasvatuksen ja koulutuksen neuvonta Rådgivning om fostran och utbildning Day care and education information and advice   2018-08-07T14:00:24.723868+03:00 3 314 {} 0 1402 4 6                                           2                      
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 {} 0 1402 1 9                     1                     1       6              
319 [] Asiointipisteet, yleisneuvonta ja yhteispalvelu Servicepunkter, allmän rådgivning och samservicekontor Service points, General information and Citizen's offices 809 2019-04-11T16:30:09.599681+03:00 3 314 {"fi": ["palvelupiste"]} 0 1402 2 11                                           6       3              
320 [321, 322, 323] Kartat ja paikkatietopalvelut Kartor och geografisk information Maps and location information services   2018-08-07T14:00:24.796452+03:00 2 306 {} 0 1402 4 10                                           2       4              
321 [] Johtotietopalvelu ja maanalaisten tilojen tietopalvelu Ledningstjänsten och information om underjordiska utrymmen Information service on cabling and underground facilities 207 2018-08-07T14:00:24.801557+03:00 3 320 {} 0 1402 2 6                                           1       3              
322 [] Karttapalvelut, ilmakuvat ja karttojen tilaus Karttjänster, flygbilder och beställning av kartor Mapping services, aerial photographs and ordering maps 247 2018-08-07T14:00:24.808369+03:00 3 320 {} 0 1402 3 6                                           1       2              
323 [] Paikkatietoneuvonta ja -aineistot Rådgivning och material inom geografisk information Location information guidance and archives 492 2018-08-07T14:00:24.814824+03:00 3 320 {} 0 1402 1 3                                                   2              
324 [325, 2040, 2193, 327, 328, 2194] Kirjastot Bibliotek Libraries   2018-08-07T14:00:24.821378+03:00 2 306 {} 0 1402 83 125                                           26       14     2        
325 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:24.829787+03:00 3 324 {"fi": ["kirjastot"]} 0 1402 27 29                                           2                      
327 [] Laitoskirjastot Anstaltsbibliotek Institutional libraries 368 2018-08-07T14:00:24.845380+03:00 3 324 {} 0 1402 8 8                                                                  
328 [] Yleiset kirjastot Allmänna bibliotek Public libraries 813 2018-11-20T14:00:07.881833+02:00 3 324 {"en": ["library", "libraries"], "fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"]} 0 1402 39 71                                           20       11     1        
329 [2153, 330, 333, 2149] Nettipisteet ja tietotekniikkapalvelut Internetstationer och datatekniktjänster Internet access points and IT services   2018-10-25T08:00:07.323845+03:00 2 306 {} 0 1402 246 257                                           3       8              
330 [331, 332] Langaton internet, wlan Trådlöst internet, wlan Wireless internet, wlan   2018-10-25T08:00:07.331877+03:00 3 329 {} 0 1402 233 240                                                   7              
331 [] WLAN-sisäpisteet WLAN-inomhusstationer WLAN inlets 806 2018-08-07T14:00:24.883321+03:00 4 330 {} 0 1402 223 230                                                   7              
332 [] WLAN-ulkopisteet WLAN-utomhusstationer WLAN outlets 807 2018-08-07T14:00:24.889824+03:00 4 330 {} 0 1402 10 10                                                                  
333 [334, 339] Tietokone ja internet Dator och internet Computer and internet   2018-10-25T08:00:07.342286+03:00 3 329 {} 0 1402 63 67                                           1       3              
334 [335, 337, 338] Tarjolla oheislaitteita Kringutrustning finns Supplementary equipment available   2018-08-07T14:00:24.905778+03:00 4 333 {} 0 1402 54 56                                                   2              
335 [] Multimedialaitteita Multimediautrustning Multimedia equipment 689 2018-08-07T14:00:24.911616+03:00 5 334 {} 0 1402 7 7                                                                  
337 [] Skanneri Skanner Scanner 691 2018-08-07T14:00:24.926601+03:00 5 334 {} 0 1402 43 45                                                   2              
338 [] Tulostin Skrivare Printer 692 2018-10-25T08:00:07.357556+03:00 5 334 {} 0 1402 52 54                                                   2              
339 [340, 341] Tarjolla opastusta Handledning ges Guidance available   2018-10-25T08:00:07.363024+03:00 4 333 {} 0 1402 60 64                                           1       3              
340 [] Kurssimuotoista tietokoneopetusta Kursformad datorundervisning Computer guidance courses 708 2018-10-25T08:00:07.368287+03:00 5 339 {} 0 1402 15 16                                           1                      
341 [] Opastusta tietokoneen käytössä (digineuvonta) Handledning i datoranvändning (digital handledning) Guidance on using a computer (digital guidance) 483 2020-05-25T11:30:10.362485+03:00 5 339 {"sv": ["digitalt st\u00f6d", "digitalt r\u00e5dgivning"], "fi": ["digiopastus", "digituki"], "en": ["digital quidance", "digital support"]} 0 1402 59 62                                                   3              
342 [] Tilastot ja tietopalvelut Statistik och informationstjänst Statistics and information services 709 2018-10-25T08:00:07.381081+03:00 2 306 {} 0 1402 2 2                                                                  
512 [513, 521, 525, 526, 533, 534, 541] Liikenne Trafik Traffic   2018-08-07T14:00:24.996122+03:00 1 1402 {} 0 1402 1269 1864 1     4                 2   1     2       540       39     6        
513 [514, 515, 516, 518, 519, 520] Joukkoliikenne Kollektivtrafik Public transport   2018-08-07T14:00:25.002057+03:00 2 512 {} 0 1402 99 151                                           27       21     4        
514 [] Asiakaspalvelu ja lipunmyynti Kundtjänst och biljettförsäljning Customer service and ticket sales 63+404 2018-10-24T20:00:07.778946+03:00 3 513 {} 0 1402 5 11                                           2       3     1        
515 [] Joukkoliikennepysäkit Kollektivtrafikens hållplatser Public transport stops 209 2018-08-07T14:00:25.015254+03:00 3 513 {} 0 1402   3                                           1             2        
516 [] Julkisen liikenteen varikot Kollektivtrafikens depåer Public transport depots 216 2018-08-07T14:00:25.022696+03:00 3 513 {} 0 1402 5 9                                                   4              
518 [] Matkalippujen tarkastus Biljettkontroll Ticket inspection 431 2018-08-07T14:00:25.036866+03:00 3 513 {} 0 1402 1 1                                                                  
519 [] Metroasemat Metrostationer Metro stations 437 2018-08-07T14:00:25.044266+03:00 3 513 {} 0 1402 72 88                                           16                      
520 [] Rautatieasemat Järnvägsstationer Railway stations 576 2018-08-07T14:00:25.051739+03:00 3 513 {} 0 1402 16 41                                           9       14     2        
521 [522, 523] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:25.059349+03:00 2 512 {} 0 1402 1 5                                           2       1     1        
522 [] Liikennesuunnittelu Trafikplanering Traffic planning 395 2018-08-07T14:00:25.064660+03:00 3 521 {} 0 1402 1 3                                           1             1        
523 [] Liikenteen ohjaus, liikennevalot Trafikstyrning, trafikljus Traffic control, traffic lights 396+397 2018-10-24T23:30:06.706293+03:00 3 521 {} 0 1402   2                                           1       1              
525 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:25.085327+03:00 2 512 {} 0 1402 1 1                                                                  
526 [527, 528, 2207, 529, 530, 2204, 532] Pysäköinti Parkering Parking   2018-08-07T14:00:25.093849+03:00 2 512 {} 0 1402 559 1023                                           460       2     2        
527 [] Ajoneuvojen siirrot Flyttning av fordon Towing vehicles 44 2018-08-07T14:00:25.100072+03:00 3 526 {} 0 1402 2 5                                           1       2              
528 [] Asukas- ja yrityspysäköintitunnukset Boende- och företagsparkering Residential and corporate parking 73+834 2018-10-24T23:30:06.727092+03:00 3 526 {} 0 1402 1 1                                                                  
529 [] Pysäköinninvalvonta Parkeringsövervakning Parking control 535 2018-08-07T14:00:25.113802+03:00 3 526 {} 0 1402 1 3                                           1       1              
530 [] Pysäköintilippuautomaatit Parkeringsbiljettautomater Parking ticket machines 536 2018-08-07T14:00:25.120116+03:00 3 526 {} 0 1402 557 557                                                                  
532 [] Yleiset pysäköintialueet Allmänna parkeringsområden Public parking lot 814 2018-08-07T14:00:25.132843+03:00 3 526 {} 0 1402 1 346                                           343             2        
533 [] Sähköautojen latauspisteet Laddstationer för elbilar Charging stations for electric vehicles 669 2018-08-07T14:00:25.139376+03:00 2 512 {} 0 1402 31 37                                           6                      
534 [536, 537, 538, 535, 539, 2206] Tiet ja kadut Vägar och gator Roads and streets   2018-08-07T14:00:25.145762+03:00 2 512 {} 0 1402 356 376                                           3       16     1        
535 [] Katu-, maa- ja viherrakentamispalvelut Tjänster inom gatu-, mark- och grönbyggnad Construction services for streets, land and parks 249 2018-08-07T14:00:25.151160+03:00 3 534 {} 0 1402 1 5                                                   4              
536 [] Katujen ja viheralueiden käyttöluvat ja vuokraus Tillstånd att använda gator och grönområden och uthyrning Permits for using streets and parks and renting 251 2018-08-07T14:00:25.157311+03:00 3 534 {} 0 1402 1 3                                           1       1              
537 [] Katujen ja viheralueiden suunnittelu ja rakennuttaminen Planering och byggande av gator och grönområden Design and development of streets and parks 252 2018-08-07T14:00:25.163756+03:00 3 534 {} 0 1402 1 18                                           2       14     1        
538 [] Katujen puhtaanapito ja talvikunnossapito Renhållning och vinterunderhåll av gator Street cleaning and winter maintenance 253 2018-08-07T14:00:25.170663+03:00 3 534 {} 0 1402 1 6                                           1       3     1        
539 [] Tierakenteiden tiiviys- ja kantavuusmittaus Mätning av vägkonstruktioners täthet och bärkraft Measuring the solidity and bearing capacity of road constructions 707 2018-08-07T14:00:25.177483+03:00 3 534 {} 0 1402 1 1                                                                  
541 [542, 547] Vesiliikenne Sjötrafik Water traffic   2018-08-07T14:00:25.190941+03:00 2 512 {} 0 1402 223 279 1     4                 2   1     2       45             1        
542 [543, 544, 545, 2198, 546, 2144] Satamat ja laiturit Hamn och bryggor Harbours, piers and quays   2018-08-07T14:00:25.196186+03:00 3 541 {} 0 1402 168 209       2                 1         1       36             1        
543 [] Hallintopalvelut Förvaltningstjänster Administrative services 183 2018-08-07T14:00:25.201364+03:00 4 542 {} 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 {} 0 1402 6 6                                                                  
545 [] Terminaalit Terminaler Terminals 782 2018-08-07T14:00:25.217022+03:00 4 542 {} 0 1402 6 6                                                                  
546 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.230897+03:00 4 542 {} 0 1402 147 188       2                 1         1       36             1        
547 [548, 2199, 549, 2143, 2142] Veneily Båtsport Boating   2018-08-07T14:00:25.237133+03:00 3 541 {} 0 1402 206 262 1     4                 2   1     2       45             1        
548 [] Ulkoilusaaret Friluftsöar Recreational islands 735 2018-10-25T08:00:07.487309+03:00 4 547 {} 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 {} 0 1402 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        
2040 [] Kirjastoautopalvelut Bokbussar Mobile libraries 312 2018-08-07T14:00:24.837192+03:00 3 324 {} 0 1402 1 3                                           1       1              
2135 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:24.729525+03:00 4 317 {} 0 1402 1 1                                                                  
2136 [] Perusopetuksen neuvonta Kundbetjäning och rådgivning (grundläggande utbildning) Customer service and information (basic education) 70 2018-08-07T14:00:24.736470+03:00 4 317 {} 0 1402 1 2                                           1                      
2137 [] Lukiokoulutuksen neuvonta Kundbetjäning och rådgivning (gymnasieutbildning) Customer service and information (general upper secondary education) 69 2018-08-07T14:00:24.743644+03:00 4 317 {} 0 1402 1 2                                           1                      
2138 [] Ammatillisen koulutuksen neuvonta Kundbetjäning och rådgivning (yrkesutbildning) Customer service and information (vocational education and training) 68 2018-08-07T14:00:24.750620+03:00 4 317 {} 0 1402 3 5                                           2                      
2142 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.242377+03:00 4 547 {} 0 1402 147 188       2                 1         1       36             1        
2143 [] Venekerhojen venepaikat Båtklubbarnas båtplatser Boat parking for yacht clubs 847 2018-08-07T14:00:25.248772+03:00 4 547 {} 0 1402 1 1                                                                  
2144 [] Vesibussilaiturit Vattenbussbryggor Water bus platforms 776 2018-08-07T14:00:25.224191+03:00 4 542 {} 0 1402 3 3                                                                  
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              
2148 [] Ikääntyvien neuvonta Rådgivning för åldringar Information and advice for elderly people 199 2018-08-07T14:00:24.771984+03:00 4 2147 {} 0 1402   4                                           2       2              
2149 [2150] Tietotekniikkaneuvonta IT rådgivning IT consultancy   2018-08-07T14:00:24.972880+03:00 3 329 {} 0 1402   2                                           2                      
2150 [] Tietotekniikkaneuvonta opiskelijoille IT rådgivning för studenter IT consultancy for students 848 2018-08-07T14:00:24.978309+03:00 4 2149 {} 0 1402   2                                           2                      
2159 [] Teknisten ja ympäristöpalvelujen neuvonta Rådgivning om teknisk och miljötjänster Information and advice of technical and environmental services 856 2018-08-07T14:00:24.779960+03:00 3 314 {} 0 1402 1 2                                           1                      
2193 [] Korkeakoulujen kirjastot Högskolebibliotek Polytechnic libraries 880 2019-03-20T13:30:07.442599+02:00 3 324 {} 0 1402 8 14                                           3       2     1        
2198 [] Veneiden lyhytaikainen kiinnittyminen Kortvarig förtöjning av båtar Short-term mooring of boats 881 2019-05-08T14:30:08.739155+03:00 4 542 {} 0 1402 4 4                                                                  
2199 [] Veneiden lyhytaikainen kiinnittyminen Kortvarig förtöjning av båtar Short-term mooring of boats 881 2019-05-08T14:30:08.752556+03:00 4 547 {} 0 1402 4 4                                                                  
2204 [] Yhteiskäyttöautojen pysäköintipaikat Bilpoolparkering Parking for car share vehicles 885 2019-09-02T10:30:09.552872+03:00 3 526 {} 0 1402   22                                           22                      
2207 [] Esteettömät autopaikat kadulla P-plats för personer med rörelsehinder bredvid gatan Accessible parking space along street 887 2020-02-12T09:30:09.092906+02:00 3 526 {} 0 1402   94                                           94                      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);