383 rows where level = 3

View and edit SQL

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, 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ää
6 [] Kaupungin asumisoikeusasunnot stadens bostadsrättsbostäder City's right of residence apartments 261 2018-08-07T14:00:21.255121+03:00 3 5 {} 0 1400 1 1                                                                  
9 [] Kaupungin tai kunnan vuokra-asunnot Stadens eller kommunens hyresbostäder City's or municipality's rental apartments 268 2018-08-07T14:00:21.273119+03:00 3 8 {} 0 1400 9 12                                           2             1        
10 [] 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:21.280357+03:00 3 8 {} 0 1400 2 3                                           1                      
11 [] Opiskelija-asunnot Studentbostäder Student housing 484 2018-08-07T14:00:21.287386+03:00 3 8 {} 0 1400   1                                           1                      
17 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:21.693384+03:00 3 16 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 0 1400 94 140                                           22       24              
18 [] Koirakäymälät Hundtoaletter Dog toilets 319 2018-08-07T14:00:21.700490+03:00 3 16 {} 0 1400 5 5                                                                  
19 [] Koirametsät Hundskogar Forest dog runs 320 2018-08-07T14:00:21.707130+03:00 3 16 {} 0 1400 1 1                                                                  
20 [] Koirauimarannat Hundbadstränder Dog beaches 321 2018-08-07T14:00:21.713262+03:00 3 16 {} 0 1400 4 5                                                   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 {} 0 1400 2 2                                                                  
29 [] Ympäristölautakunta Miljövårdsnämnden Environment committee 824 2018-08-07T14:00:21.318211+03:00 3 28 {} 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"]} 0 1400 34 79                                           18       26     1        
36 [] Bio- ja puutarhajäte Trädgårdsavfall Garden waste 127 2018-08-07T14:00:21.797808+03:00 3 34 {} 0 1400 2 4                                           1       1              
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} 0 1400   1                                                   1              
38 [] Kartonginkeräys Insamling av kartong Cardboard recycling 246 2018-08-07T14:00:21.813795+03:00 3 34 {"fi": ["kartonki"]} 0 1400 54 140                                           46       36     4        
39 [] Lamppujen keräys Återvinning av lampor Lamp recycling 369 2018-08-07T14:00:21.822356+03:00 3 34 {"fi": ["lamput"]} 0 1400 21 54                                           13       20              
40 [] Lasinkeräys Glasåtervinning Glass recycling 374 2018-08-07T14:00:21.831316+03:00 3 34 {} 0 1400 50 138                                           46       37     5        
41 [] Metallinkeräys Metallavfall Small metal waste 436 2018-08-07T14:00:21.839149+03:00 3 34 {} 0 1400 50 137                                           46       37     4        
42 [] Muovinkeräys Plaståtervinning Plastic recycling 454 2018-08-07T14:00:21.846516+03:00 3 34 {} 0 1400 23 70                                           29       16     2        
44 [] Pahvinkeräys Insamling av wellpapp Corrugated cardboard recycling 491 2018-08-07T14:00:21.860147+03:00 3 34 {} 0 1400 2 7                                           1       2     2        
45 [] Paperinkeräys Insamling av papper Paper recycling 496 2018-08-07T14:00:21.867001+03:00 3 34 {} 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"]} 0 1400 16 46                                           12       18              
47 [] Puujäte Träavfall Wood waste 531 2018-08-07T14:00:21.882472+03:00 3 34 {} 0 1400 2 5                                           2       1              
48 [] Sekajäte Blandat avfall Mixed waste 617 2018-08-07T14:00:21.889545+03:00 3 34 {} 0 1400 2 6                                           2       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 {} 0 1400 11 24                                           7       6              
50 [] Tekstiilien keräys Textilåtervinning Textile recycling 696 2018-08-07T14:00:21.906229+03:00 3 34 {} 0 1400 40 108                                           37       29     2        
51 [] Vaarallinen jäte Farligt avfall Hazardous waste 740 2018-08-07T14:00:21.912639+03:00 3 34 {} 0 1400 16 44                                           11       17              
61 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:21.361137+03:00 3 60 {} 0 1400 49 49                                                                  
62 [63, 64, 65, 66, 67] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:21.368201+03:00 3 60 {} 0 1400 102 149                                           22       25              
68 [70, 69] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:21.413441+03:00 3 60 {} 0 1400 293 647                                           201       148     5        
71 [] Viheralueet Grönområden Green areas 786 2018-08-07T14:00:21.432517+03:00 3 60 {} 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 {} 0 1400 1 1                                                                  
75 [] Katu-, maa- ja viherrakentamispalvelut Tjänster inom gatu-, mark- och grönbyggnad Construction services for streets, land and parks 249 2018-08-07T14:00:21.457195+03:00 3 74 {} 0 1400 1 5                                                   4              
76 [] 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:21.463483+03:00 3 74 {} 0 1400 1 3                                           1       1              
77 [] 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:21.469668+03:00 3 74 {} 0 1400 1 18                                           2       14     1        
78 [] Katujen puhtaanapito ja talvikunnossapito Renhållning och vinterunderhåll av gator Street cleaning and winter maintenance 253 2018-08-07T14:00:21.475789+03:00 3 74 {} 0 1400 1 6                                           1       3     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 {} 0 1400 1 1                                                                  
81 [] Kauppahallit Saluhallar Market halls 259 2018-08-07T14:00:21.499406+03:00 3 80 {} 0 1400 3 3                                                                  
82 [] Kirpputorit Lopptorg Flea markets 315 2018-08-07T14:00:21.505503+03:00 3 80 {} 0 1400 3 3                                                                  
83 [] Markkinat Marknader Markets 427 2018-08-07T14:00:21.511515+03:00 3 80 {} 0 1400 2 2                                                                  
84 [] Torit Torg Market squares 714 2018-08-07T14:00:21.493235+03:00 3 80 {} 0 1400 15 15                                                                  
96 [] Luontokoulu Miljöcentralens naturskola Nature school 412 2018-08-07T14:00:21.529831+03:00 3 95 {} 0 1400 1 3                                           2                      
98 [] Metsät Skogar Forests 438 2020-12-02T12:30:08.292275+02:00 3 97 {} 0 1400 1 1                                                                  
99 [] Puutarhapalvelut Trädgårdstjänster Gardening services 533 2018-08-07T14:00:21.548578+03:00 3 97 {} 0 1400 1 2                                                   1              
104 [] Asumisterveys Boendehälsa Housing health 77 2018-08-07T14:00:21.579504+03:00 3 103 {} 0 1400 2 5                                 1         1       1              
105 [] Elintarvikevalvonta Livsmedelsbevakning Food control 137 2018-08-07T14:00:21.585963+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
106 [] Eläinlääkäripalvelut Veterinärtjänster Vet services 140 2018-08-07T14:00:21.592468+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
107 [] Eläinsuojelu Djurskydd Animal protection 141 2018-08-07T14:00:21.598706+03:00 3 103 {} 0 1400 1 4                                           1       2              
109 [] Sisätilojen tuholaiset Inomhus skadedjur Interior pests 626 2018-08-07T14:00:21.605181+03:00 3 103 {} 0 1400 1 1                                                                  
110 [] Talousveden valvonta Övervakning av hushållsvatten Domestic water supervision 683 2018-08-07T14:00:21.612084+03:00 3 103 {} 0 1400 1 3                                           1       1              
111 [] Terveystarkastaja Hälsoinspektör Health inspector 705 2018-08-07T14:00:21.618445+03:00 3 103 {} 0 1400   2                                           1       1              
113 [] Tupakkalain valvonta Tillsyn av tobakslagen Tobacco Act supervision 719 2018-08-07T14:00:21.625158+03:00 3 103 {} 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 {} 0 1400 1 4                                 1         1       1              
117 [] Maaperä ja vesi Jordmånen och vatten Ground and water 423 2018-08-07T14:00:21.648552+03:00 3 116 {} 0 1400 1 3                                           1       1              
118 [] Pohjavesitiedot Grundvatteninformation Groundwater information 517 2018-08-07T14:00:21.654694+03:00 3 116 {} 0 1400 2 3                                                   1              
119 [] Sisäympäristö Inomhusmiljö Indoor environment 627 2018-08-07T14:00:21.660811+03:00 3 116 {} 0 1400 1 1                                                                  
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 {} 0 1400 2 5                                 1         1       1              
121 [] Ympäristönsuojelumääräykset Miljöskyddsbestämmelser Environmental protection regulations 828 2018-08-07T14:00:21.673508+03:00 3 116 {} 0 1400 2 4                                 1                 1              
135 [] Kaupungin tai kunnan vuokra-asunnot Stadens eller kommunens hyresbostäder City's or municipality's rental apartments 268 2018-08-07T14:00:30.087071+03:00 3 134 {} 0 1401 9 12                                           2             1        
136 [] 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:30.094025+03:00 3 134 {} 0 1401 2 3                                           1                      
137 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:30.100472+03:00 3 134 {} 0 1401 1 3                                           1       1              
138 [] Liike- ja toimistotonttien vuokraus ja myynti Arrendering och försäljning av affärs- och kontorstomter Leasing and selling of commercial and office plots 394 2018-08-07T14:00:30.106922+03:00 3 134 {} 0 1401   2                                           1       1              
139 [] Maa-alueiden vuokraus ja myynti Uthyrning och försäljning av markområden Selling or renting land areas 419 2018-08-07T14:00:30.113920+03:00 3 134 {} 0 1401   17                                                   17              
142 [] Elinkeinomarkkinointi Näringslivmarknadsföring Business marketing 133 2018-08-07T14:00:30.132324+03:00 3 141 {} 0 1401 2 2                                                                  
144 [] Matkailumarkkinointi Marknadsföring av turism Tourism marketing 428 2018-08-07T14:00:30.145003+03:00 3 141 {} 0 1401 2 4                                                   2              
145 [] Tapahtumamarkkinointi Evenemangsmarknadsföring Event marketing 688 2018-08-07T14:00:30.151217+03:00 3 141 {} 0 1401   2                                                   2              
147 [] Kauppahallimyyntipaikkojen vuokraus Uthyrning av försäljningsplatser i saluhallar Market hall sales location leasing 258 2018-08-07T14:00:30.162809+03:00 3 146 {} 0 1401 1 2                                                   1              
148 [] Torimyyntipaikkojen vuokraus Uthyrning av torgförsäljningsplatser Market square vending stall rental 713 2018-08-07T14:00:30.169994+03:00 3 146 {} 0 1401 1 2                                                   1              
149 [2209, 150, 152, 151, 154, 155] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:30.179684+03:00 3 146 {} 0 1401 292 375       1 1         1   1     2     2       40       31     4        
168 [] Alkavien yrittäjien neuvonta Rådgivning för nya företagare Advice for start-up entrepreneurs 48 2018-08-07T14:00:30.339989+03:00 3 167 {} 0 1401 4 8                                           2       2              
169 [] Maahanmuuttajayrittäjien neuvonta Rådgivning för invandrarföretagare Advice for immigrant entrepreneurs 421 2018-08-07T14:00:30.346437+03:00 3 167 {} 0 1401 4 6                                           1       1              
173 [2004, 2003, 2005] Hallinnon toimipisteet Förvaltningens verksamhetsställen Administrative offices   2018-08-07T14:00:30.377254+03:00 3 172 {} 0 1401 56 67                                   1       2       7     1        
176 [] Postipalvelut Posttjänster Postal services 224 2018-08-07T14:00:30.419580+03:00 3 172 {} 0 1401 1 1                                                                  
182 [] Henkilöstöpolitiikka ja -strategia Personalpolitik och -strategi Personnel policy and strategy 220 2018-08-07T14:00:30.473352+03:00 3 180 {} 0 1401 3 3                                                                  
183 [] Henkilöstöravintolat Personalrestaurang Staff restaurants 221 2018-08-07T14:00:30.479735+03:00 3 180 {} 0 1401 23 26                                           2       1              
185 [] Rekrytointi Rekrytering Recruitment 225 2018-08-07T14:00:30.493982+03:00 3 180 {} 0 1401 2 2                                                                  
188 [] Kelan etuudet FPA:s förmåner Kela benefits 286 2018-08-07T14:00:30.511334+03:00 3 187 {} 0 1401 3 9       1                                   2       2         1    
189 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:30.517534+03:00 3 187 {} 0 1401 14 20                                           2       3     1        
192 [] 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.528561+03:00 3 191 {} 0 1401 1 2                                                         1        
193 [] Kaupunginhallitus Stadsstyrelsen City Board 272 2018-08-07T14:00:30.534760+03:00 3 191 {} 0 1401 2 4                                           1       1              
194 [] Kaupunginvaltuusto Stadsfullmäktige City Council 273 2018-08-07T14:00:30.540753+03:00 3 191 {} 0 1401 2 5                                           1       1     1        
195 [] Lautakunnat ja johtokunnat Nämnder och direktioner Committees and boards 386 2018-08-07T14:00:30.546848+03:00 3 191 {} 0 1401 1 2                                                   1              
196 [] Valtuustoryhmät, kansalaislähetystöt Stadsfullmäktigegrupper, medborgardelegationer Council groups, public delegations 743 2018-08-07T14:00:30.552905+03:00 3 191 {} 0 1401 1 2                                                   1              
198 [199, 200, 201, 202, 203, 204, 205, 206, 207, 208] Taloushallinto Ekonomiförvaltning Financial administration 487 2018-08-07T14:00:30.570887+03:00 3 197 {} 0 1401 8 8                                                                  
209 [210, 211, 213] Varainhallinta Finansförvaltning Assets management   2018-08-07T14:00:30.654818+03:00 3 197 {} 0 1401 3 3                                                                  
217 [] Sisäinen tarkastus Intern revision Internal auditing 176 2018-08-07T14:00:30.706266+03:00 3 216 {} 0 1401 1 2                                           1                      
218 [] Ulkoinen tarkastus Extern revision External auditing 177 2018-08-07T14:00:30.714388+03:00 3 216 {} 0 1401   1                                           1                      
220 [] Avustusten sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för bidragsärenden Electronic services and forms related to benefits 87 2018-08-07T14:00:30.732707+03:00 3 219 {} 0 1401   1                                                   1              
223 [] Asiakaspalvelu Kundtjänst Customer services 64 2018-08-07T14:00:22.006084+03:00 3 222 {} 0 1400   3                                           1       1     1        
224 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:22.012371+03:00 3 222 {} 0 1400 2 4                                                   1     1        
225 [] Kaavat ja kaavoitus Planer och planlägging Town plans and zoning 237 2018-08-07T14:00:22.018653+03:00 3 222 {} 0 1400 5 9                                           1       2     1        
226 [227, 228] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:22.025116+03:00 3 222 {} 0 1400 1 5                                           2       1     1        
229 [] Nimistönsuunnittelu Namnplanering Nomenclature planning 466 2018-08-07T14:00:22.045496+03:00 3 222 {} 0 1400   2                                           1       1              
230 [] Viestintä ja vuorovaikutus Kommunikation och påverkan Communications and interaction 785 2018-08-07T14:00:22.052241+03:00 3 222 {} 0 1400 2 2                                                                  
232 [] Energia-avustukset energiunderstöd energy grants 144 2018-08-07T14:00:22.065643+03:00 3 231 {} 0 1400   1                                           1                      
233 [234, 235, 237] Hallinto Förvaltning Administration   2018-08-07T14:00:22.072503+03:00 3 231 {} 0 1400 3 6                                                   3              
238 [] Hissiprojekti Anskaffning av hissar (gamla höghus) Lift procurement (old residential buildings) 195 2018-08-07T14:00:22.097017+03:00 3 231 {} 0 1400 1 1                                                                  
239 [] Kaupanvahvistus Bestyrkande av köp Public purchase witnessing 255 2018-08-07T14:00:22.103157+03:00 3 231 {} 0 1400 1 3                                           1       1              
240 [] Kiinteistöhuolto ja isännöinti Fastighetsunderhåll och -förvaltning Janitorial and landlord services 303 2018-08-07T14:00:22.109816+03:00 3 231 {} 0 1400 1 2                                           1                      
241 [] Kiinteistönmuodostus Fastighetsbildning Property formation 304 2018-08-07T14:00:22.116719+03:00 3 231 {} 0 1400   5                                           1       4              
242 [] Kiinteistörekisteri Fastighetsregister Real estate register 305 2018-08-07T14:00:22.123611+03:00 3 231 {} 0 1400   4                                           1       3              

Next page

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