service_node

186 rows where root = 1400 sorted by service_reference

✎ View and edit SQL

This data as json, CSV (advanced)

unit_count_municipality_porvoo ✖

root ✖

  • 1400 · 86 ✖
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ää
41 [] Metallinkeräys Metallavfall Small metal waste 436 2018-08-07T14:00:21.839149+03:00 3 34 {} [436] 0 1400 50 137                                           46       37     4        
98 [] Metsät Skogar Forests 438 2020-12-02T12:30:08.292275+02:00 3 97 {} [438] 0 1400 1 1                                                                  
35 [] Akkujen keräys Återvinning av bilbatterier Car battery recycling 45 2018-08-07T14:00:21.789985+03:00 3 34 {"fi": ["akut"]} [45] 0 1400 34 79                                           18       26     1        
88 [] Mullan myynti ja toimitus Försäljning och leverans av mylla Selling and delivering soil 453 2018-08-07T14:00:21.964747+03:00 2 85 {} [453] 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                                    
42 [] Muovinkeräys Plaståtervinning Plastic recycling 454 2018-08-07T14:00:21.846516+03:00 3 34 {} [454] 0 1400 23 70                                           29       16     2        
229 [] Nimistönsuunnittelu Namnplanering Nomenclature planning 466 2018-08-07T14:00:22.045496+03:00 3 222 {} [466] 0 1400   2                                           1       1              
253 [] Nuohous Sotning Chimney sweeping 467 2018-08-07T14:00:22.189946+03:00 3 231 {} [467] 0 1400   1                                           1                      
69 [] Ohjattu leikkipuistotoiminta Ledd lekparksverksamhet Supervised playground activities 475 2019-03-05T14:30:06.276314+02:00 4 68 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [475] 0 1400 69 80                                           8       3              
53 [] Ongelmajäteasema Problemavfall station Waste management station 478 2018-08-07T14:00:21.933801+03:00 2 31 {} [478] 0 1400 1 2                                           1                      
21 [] Opaskoira-aitaukset Inhägnat områden för ledarhundar Fenced areas for guide dogs 480 2018-08-07T14:00:21.719558+03:00 3 16 {} [480] 0 1400 2 2                                                                  
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                                                                  
290 [] Kilpipalvelut Skylttjänster Sign services 481 2018-08-07T14:00:22.444787+03:00 4 287 {} [481] 0 1400 1 1                                                                  
11 [] Opiskelija-asunnot Studentbostäder Student housing 484 2018-08-07T14:00:21.287386+03:00 3 8 {} [484] 0 1400   1                                           1                      
44 [] Pahvinkeräys Insamling av wellpapp Corrugated cardboard recycling 491 2018-08-07T14:00:21.860147+03:00 3 34 {} [491] 0 1400 2 7                                           1       2     2        
267 [] Pakastamotilojen vuokraus Uthyrning av fryslokaler Cold storage space rental 494 2018-08-07T14:00:22.293996+03:00 5 265 {} [494] 0 1400 1 1                                                                  
45 [] Paperinkeräys Insamling av papper Paper recycling 496 2018-08-07T14:00:21.867001+03:00 3 34 {} [496] 0 1400 166 466                                           125       156     19        
46 [] Paristonkeräys Återvinning av små batterier Small battery recycling 497 2018-08-07T14:00:21.875976+03:00 3 34 {"fi": ["paristot"]} [497] 0 1400 16 46                                           12       18              
304 [] Tiedotus Information Information distribution 50 2018-08-07T14:00:22.521378+03:00 5 303 {} [50] 0 1400 1 1                                                                  
292 [] Pohja- ja kalliorakennussuunnittelu Planering av grund- och bergsbyggnad Foundation and rock engineering 516 2018-08-07T14:00:22.458169+03:00 4 287 {} [516] 0 1400 1 2                                                   1              
118 [] Pohjavesitiedot Grundvatteninformation Groundwater information 517 2018-08-07T14:00:21.654694+03:00 3 116 {} [517] 0 1400 2 3                                                   1              
47 [] Puujäte Träavfall Wood waste 531 2018-08-07T14:00:21.882472+03:00 3 34 {} [531] 0 1400 2 5                                           2       1              
73 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:21.445519+03:00 2 1 {} [532] 0 1400 44 74                                           14       16              
99 [] Puutarhapalvelut Trädgårdstjänster Gardening services 533 2018-08-07T14:00:21.548578+03:00 3 97 {} [533] 0 1400 1 2                                                   1              
282 [] Rakennus- ja toimenpideluvat Bygglov och åtgärdstillstånd Licences for construction and operations 558 2018-08-07T14:00:22.390024+03:00 4 279 {} [558] 0 1400 1 5                                           1       2     1        
283 [] Rakennusrasitteet Byggnadsservitut Building easements 559 2018-08-07T14:00:22.397931+03:00 4 279 {} [559] 0 1400   1                                           1                      
284 [] Rakennustöiden viranomaisvalvonta Myndighetstillsyn av byggarbeten Official oversight of construction work 560 2018-08-07T14:00:22.405256+03:00 4 279 {} [560] 0 1400 2 6                                           1       3              
281 [] Jatkuva valvonta Kontinuerlig tillsyn Continuous monitoring 562 2018-08-07T14:00:22.381961+03:00 4 279 {} [562] 0 1400   1                                           1                      
285 [] Rakennusvalvontamittaukset Byggnadstillsynsmätningar Building control measurements 563 2018-08-07T14:00:22.411827+03:00 4 279 {} [563] 0 1400 1 3                                           1       1              
291 [] Materiaalipalvelut Materialservice Material services 564 2018-08-07T14:00:22.451320+03:00 4 287 {} [564] 0 1400 3 3                                                                  
286 [] Rakentamisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter i byggärenden Electronic services and forms related to construction 565 2018-08-07T14:00:22.418594+03:00 3 270 {} [565] 0 1400   2                     1                     1                      
54 [] Rantavesien ja sisäsaariston puhtaanapito Renhållning av strandvatten och inre skärgård Cleaning waterfronts and inner archipelago 572 2018-08-07T14:00:21.940289+03:00 2 31 {} [572] 0 1400 2 2                                                                  
48 [] Sekajäte Blandat avfall Mixed waste 617 2018-08-07T14:00:21.889545+03:00 3 34 {} [617] 0 1400 2 6                                           2       1     1        
25 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:21.743023+03:00 2 24 {} [62] 0 1400 1 2                                                   1              
273 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:22.333741+03:00 4 272 {} [62] 0 1400 1 2                                                   1              
254 [] Siivouspalvelut Städningsservice Cleaning services 621 2018-08-07T14:00:22.196172+03:00 3 231 {} [621] 0 1400 1 1                                                                  
109 [] Sisätilojen tuholaiset Inomhus skadedjur Interior pests 626 2018-08-07T14:00:21.605181+03:00 3 103 {} [626] 0 1400 1 1                                                                  
119 [] Sisäympäristö Inomhusmiljö Indoor environment 627 2018-08-07T14:00:21.660811+03:00 3 116 {} [627] 0 1400 1 1                                                                  
223 [] Asiakaspalvelu Kundtjänst Customer services 64 2018-08-07T14:00:22.006084+03:00 3 222 {} [64] 0 1400   3                                           1       1     1        
49 [] Sähkö- ja elektroniikkaromu El- och elekronikskrot Electric and electronic junk 668 2018-10-25T08:00:06.218463+03:00 3 34 {} [668] 0 1400 11 24                                           7       6              
93 [] Vesilaskut ja asiakaspalvelu Vattenfakturering och kundtjänst Billing for water and customer services 67+781 2018-10-24T20:30:07.186738+03:00 2 85 {} [781, 67] 0 1400 26 26                                                                  
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                                                                  
110 [] Talousveden valvonta Övervakning av hushållsvatten Domestic water supervision 683 2018-08-07T14:00:21.612084+03:00 3 103 {} [683] 0 1400 1 3                                           1       1              
50 [] Tekstiilien keräys Textilåtervinning Textile recycling 696 2018-08-07T14:00:21.906229+03:00 3 34 {} [696] 0 1400 40 108                                           37       29     2        
111 [] Terveystarkastaja Hälsoinspektör Health inspector 705 2018-08-07T14:00:21.618445+03:00 3 103 {} [705] 0 1400   2                                           1       1              
268 [] Teurastamotilojen vuokraus Uthyrning av slakterilokaler Slaughterhouse rental 706 2018-08-07T14:00:22.300791+03:00 5 265 {} [706] 0 1400 1 1                                                                  
79 [] 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:21.481992+03:00 3 74 {} [707] 0 1400 1 1                                                                  
257 [] Torimyyntipaikkojen vuokraus Uthyrning av torgförsäljningsplatser Market square vending stall rental 713 2018-08-07T14:00:22.214641+03:00 4 255 {} [713] 0 1400 1 2                                                   1              
84 [] Torit Torg Market squares 714 2018-08-07T14:00:21.493235+03:00 3 80 {} [714] 0 1400 15 15                                                                  
2022 [] Tuotantotilojen vuokraus Uthyrning av produktionslokaler Production facility rental 718 2018-08-07T14:00:22.279273+03:00 5 265 {} [718] 0 1400 3 4                                           1                      
113 [] Tupakkalain valvonta Tillsyn av tobakslagen Tobacco Act supervision 719 2018-08-07T14:00:21.625158+03:00 3 103 {} [719] 0 1400   2                                           1       1              
114 [] Uimavesien valvonta Övervakning av badvatten Swimming water supervision 732 2018-08-07T14:00:21.631376+03:00 3 103 {} [732] 0 1400 1 4                                 1         1       1              
3 [] Asumisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för boendeärenden Electronic housing services and forms 74 2018-08-07T14:00:21.236014+03:00 2 2 {} [74] 0 1400   1                     1                                            
51 [] Vaarallinen jäte Farligt avfall Hazardous waste 740 2018-08-07T14:00:21.912639+03:00 3 34 {} [740] 0 1400 16 44                                           11       17              
4 [] Asumisen tuet Bostadsbidrag Housing allowances 75 2018-08-07T14:00:21.243003+03:00 2 2 {} [75] 0 1400 3 9       1                                   2       2         1    
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} [76] 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
2023 [] Varastotilojen vuokraus Uthyrning av lagerlokaler Storage space rental 765 2018-08-07T14:00:22.286375+03:00 5 265 {} [765] 0 1400 3 4                                           1                      
91 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:21.983685+03:00 2 85 {} [766] 0 1400 2 2                                                                  
299 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:22.497732+03:00 4 293 {} [766] 0 1400 2 2                                                                  
104 [] Asumisterveys Boendehälsa Housing health 77 2018-08-07T14:00:21.579504+03:00 3 103 {} [77] 0 1400 2 5                                 1         1       1              
249 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:22.162414+03:00 4 245 {} [78] 0 1400 1 3                                           1       1              
305 [] Viestintä Kommunikation Communications 784 2018-08-07T14:00:22.528397+03:00 2 221 {} [784] 0 1400 1 1                                                                  
230 [] Viestintä ja vuorovaikutus Kommunikation och påverkan Communications and interaction 785 2018-08-07T14:00:22.052241+03:00 3 222 {} [785] 0 1400 2 2                                                                  
71 [] Viheralueet Grönområden Green areas 786 2018-08-07T14:00:21.432517+03:00 3 60 {} [786] 0 1400 51 102                     1                     50                      
72 [] Viheralueiden hoito Skötsel av grönområden Green area maintenance 787 2020-12-02T11:30:08.056281+02:00 3 60 {} [787] 0 1400 1 1                                                                  
269 [] Vihertukkutilojen vuokraus Uthyrning av lokaler för grönsaksgrossister Green wholesale trade space rental 788 2018-08-07T14:00:22.308088+03:00 5 265 {} [788] 0 1400 1 1                                                                  
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} [79] 0 1400 1 3                                           1       1              
271 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:22.320238+03:00 3 270 {} [79] 0 1400 1 3                                           1       1              
27 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:21.755624+03:00 2 24 {} [798] 0 1400 4 4                                                                  
275 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:22.348354+03:00 4 272 {} [798] 0 1400 4 4                                                                  
259 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:22.226278+03:00 5 258 {} [799] 0 1400 3 8                                           2       1     2        
263 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.252638+03:00 5 258 {} [803] 0 1400   17                                           16             1        
264 [] Tilaussaunat Beställningsbastur Reservation-only sauna 804 2018-08-07T14:00:22.259199+03:00 5 258 {} [804] 0 1400 1 2                                           1                      
94 [] Yleisövessat Allmänna toaletter Public toilets 819 2018-10-25T08:00:06.064613+03:00 2 1 {} [819] 0 1400 39 39                                                                  
120 [] Ympäristöhaitat ja -luvat Miljöolägenheter och -tillstånd Environmental detriments and permits 823 2018-08-07T14:00:21.667227+03:00 3 116 {} [823] 0 1400 2 5                                 1         1       1              
29 [] Ympäristölautakunta Miljövårdsnämnden Environment committee 824 2018-08-07T14:00:21.318211+03:00 3 28 {} [824] 0 1400   1                                                   1              
97 [98, 99] Ympäristön hoito Miljövård Maintenance of the environment 825 2018-08-07T14:00:21.535829+03:00 2 1 {} [825] 0 1400 2 3                                                   1              
100 [] Ympäristön sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för miljöärenden Electronic services and forms related to environmental matters 826 2018-08-07T14:00:21.554721+03:00 2 1 {} [826] 0 1400   1                     1                                            
101 [] Ympäristöneuvonta Miljörådgivning Environmental information 827 2018-08-07T14:00:21.561444+03:00 2 1 {} [827] 0 1400 1 5                                           3       1              
121 [] Ympäristönsuojelumääräykset Miljöskyddsbestämmelser Environmental protection regulations 828 2018-08-07T14:00:21.673508+03:00 3 116 {} [828] 0 1400 2 4                                 1                 1              
102 [] Ympäristöohjelmat Miljöprogram Environmental programmes 829 2018-08-07T14:00:21.567791+03:00 2 1 {} [829] 0 1400 1 2                                                   1              
115 [] Ympäristötutkimus ja tilastointi Miljöforskning och statistikförning Environmental research and compilation of statistics 830 2018-08-07T14:00:21.637464+03:00 2 1 {} [830] 0 1400 1 3                                           1       1              
2191 [] Hitas-asunnot Hitas-bostäder Hitas owner-occupied housing 877 2019-03-05T14:30:06.194077+02:00 2 2 {} [877] 0 1400 399 399                                                                  
2210 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:07.230470+03:00 5 258 {} [888] 0 1400 1 12                                           2       9              
2211 [] Kyllästetyn puujätteen keräys Insamling av impregnerat träavfall Impregnated wood waste collection 889 2020-01-02T14:30:07.726283+02:00 3 34 {} [889] 0 1400 2 4                                           1       1              
2236 [] Puistoshakkilaudat Parkschackbräden Park chess boards 912 2020-09-01T15:30:06.145353+03:00 3 60 {} [912] 0 1400 24 24                                                                  

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