4 rows where picture_entrance_url = "https://www.google.com/maps/uv?hl=fi&pb=!1s0x46920bcb75fc2af1%3A0x92329e4a48daba63!2m22!2m2!1i80!2i80!3m1!2i20!16m16!1b1!2m2!1m1!1e1!2m2!1m1!1e3!2m2!1m1!1e5!2m2!1m1!1e4!2m2!1m1!1e6!3m1!7e115!4s%2Fmaps%2Fplace%2Fressun%2Blukio%2F%4060.1958984%2C24.9065391%2C3a%2C75y%2C332.16h%2C90t%2Fdata%3D*213m4*211e1*213m2*211sNZPp78zXnEmo_J-YRV5DoA*212e0*214m2*213m1*211s0x46920bcb75fc2af1%3A0x92329e4a48daba63!5sressun%20lukio%20-%20Google-haku&imagekey=!1e10!2sAF1QipOcmlwhlw1TYuoyibO_o0naVSqbE2RnfQg7iXu2&sa=X" sorted by accessibility_shortcoming_count_visually_impaired

View and edit SQL

Suggested facets: connections, department, contract_type_id, contract_type_description_fi, contract_type_description_en, streetview_entrance_url, street_address_sv, street_address_en, www_sv, www_en, accessibility_phone, accessibility_www, root_service_nodes, created_time (date), last_modified_time (date)

picture_entrance_url

  • https://www.google.com/maps/uv?hl=fi&pb=!1s0x46920bcb75fc2af1%3A0x92329e4a48daba63!2m22!2m2!1i80!2i80!3m1!2i20!16m16!1b1!2m2!1m1!1e1!2m2!1m1!1e3!2m2!1m1!1e5!2m2!1m1!1e4!2m2!1m1!1e6!3m1!7e115!4s%2Fmaps%2Fplace%2Fressun%2Blukio%2F%4060.1958984%2C24.9065391%2C3a%2C75y%2C332.16h%2C90t%2Fdata%3D*213m4*211e1*213m2*211sNZPp78zXnEmo_J-YRV5DoA*212e0*214m2*213m1*211s0x46920bcb75fc2af1%3A0x92329e4a48daba63!5sressun%20lukio%20-%20Google-haku&imagekey=!1e10!2sAF1QipOcmlwhlw1TYuoyibO_o0naVSqbE2RnfQg7iXu2&sa=X · 4
id connections accessibility_properties identifiers_0_namespace identifiers_0_value identifiers_1_namespace identifiers_1_value department root_department provider_type organizer_type contract_type_id contract_type_description_fi contract_type_description_sv contract_type_description_en is_active deleted_at organizer_name organizer_business_id picture_url picture_entrance_url streetview_entrance_url description_fi description_en short_description name_fi name_en street_address_fi street_address_sv street_address_en www_fi www_sv www_en address_postal_full call_charge_info_fi call_charge_info_sv call_charge_info_en picture_caption phone fax accessibility_phone accessibility_email accessibility_www created_time address_zip data_source extensions_maintenance_group extensions_maintenance_organization last_modified_time accessibility_viewpoints root_service_nodes municipality service_nodes services keywords location_type location_coordinates_0 location_coordinates_1 address_postal_full_fi identifiers_2_value picture_caption_fi call_charge_info www name_sv short_description_fi accessibility_shortcoming_count_reduced_mobility accessibility_shortcoming_count_wheelchair location picture_caption_sv accessibility_shortcoming_count_stroller address_postal_full_en accessibility_shortcoming_count_hearing_aid street_address contract_type accessibility_shortcoming_count_rollator identifiers_2_namespace address_postal_full_sv short_description_sv description_sv accessibility_shortcoming_count_visually_impaired ▼ short_description_en description picture_caption_en
5837 [{"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Opiskeluterveydenhuollon esitietolomake"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=2151"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 105}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 38}, {"value": "false", "variable": 92}, {"value": "false", "variable": 98}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 46}, {"value": "true", "variable": 57}, {"value": "false", "variable": 117}, {"value": "false", "variable": 111}, {"value": "opens_easily_manually", "variable": 77}, {"value": "true", "variable": 5}, {"value": "3", "variable": 64}, {"value": "true", "variable": 23}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 50}, {"value": "false", "variable": 84}, {"value": "true", "variable": 109}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 59}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "false", "variable": 116}, {"value": "true", "variable": 58}, {"value": "10", "variable": 1}, {"value": "false", "variable": 62}, {"value": "at_least_3600mm", "variable": 3}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "on_door", "variable": 110}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 37}, {"value": "false", "variable": 22}, {"value": "false", "variable": 104}, {"value": "false", "variable": 102}, {"value": "true", "variable": 74}, {"value": "false", "variable": 33}, {"value": "1_step", "variable": 24}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 79}, {"value": "true", "variable": 42}, {"value": "true", "variable": 70}, {"value": "true", "variable": 52}, {"value": "false", "variable": 34}, {"value": "false", "variable": 21}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 72}, {"value": "true", "variable": 73}, {"value": "true", "variable": 112}, {"value": "true", "variable": 75}, {"value": "true", "variable": 40}, {"val… internal 2443     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1         https://www.google.com/maps/uv?hl=fi&pb=!1s0x46920bcb75fc2af1%3A0x92329e4a48daba63!2m22!2m2!1i80!2i80!3m1!2i20!16m16!1b1!2m2!1m1!1e1!2m2!1m1!1e3!2m2!1m1!1e5!2m2!1m1!1e4!2m2!1m1!1e6!3m1!7e115!4s%2Fmaps%2Fplace%2Fressun%2Blukio%2F%4060.1958984%2C24.9065391%2C3a%2C75y%2C332.16h%2C90t%2Fdata%3D*213m4*211e1*213m2*211sNZPp78zXnEmo_J-YRV5DoA*212e0*214m2*213m1*211s0x46920bcb75fc2af1%3A0x92329e4a48daba63!5sressun%20lukio%20-%20Google-haku&imagekey=!1e10!2sAF1QipOcmlwhlw1TYuoyibO_o0naVSqbE2RnfQg7iXu2&sa=X https://www.google.com/maps/place/Lehtikuusentie+4,+00270+Helsinki/@60.1959001,24.9066515,17z/data=!4m13!1m7!3m6!1s0x469209f5c4d8fdd3:0x8fe9095b269f15be!2sLehtikuusentie+4,+00270+Helsinki!3b1!8m2!3d60.1964202!4d24.9059846!3m4!1s0x469209f5c4d8fdd3:0x8fe9095b269f15be!8m2!3d60.1964202!4d24.9059846       Ressun lukio, opiskeluterveydenhuolto Ressu Upper Secondary School, student health care Kalevankatu 8-10 Kalevagatan 8-10 Kalevankatu 8-10         pvm/mpm lna/msa local network charge/mobile call charge   +358 40 162 0751   +358 9 310 68515   https://www.hel.fi/ressul/fi/yhteystiedot/ 2008-07-10T22:13:17+03:00 00100 www.hel.fi kaikki helsinki 2020-11-27T13:01:05.299786+02:00 {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [986, 1087] helsinki [2166, 2167] [863] {} Point 24.938286 60.167324 PL 10304, 00099 Helsingin kaupunki         Gymnasiet Ressun lukio, hälsovård för studerande             P.O. Box 10304, 00099 City of Helsinki 1         PB 10304, 00099 Helsingfors stad     4      
46065 [] [{"value": "under_20mm", "variable": 56}, {"value": "10", "variable": 1}, {"value": "opens_easily_manually", "variable": 54}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 53}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 52}, {"value": "false", "variable": 21}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 5}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "true", "variable": 29}, {"value": "false", "variable": 22}, {"value": "false", "variable": 28}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 25}, {"value": "true", "variable": 51}, {"value": "true", "variable": 38}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "false", "variable": 34}, {"value": "false", "variable": 49}, {"value": "true", "variable": 44}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 46}, {"value": "true", "variable": 37}, {"value": "true", "variable": 50}, {"value": "false", "variable": 48}, {"value": "3", "variable": 64}, {"value": "false", "variable": 103}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 115}, {"value": "false", "variable": 62}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "false", "variable": 117}, {"value": "true", "variable": 75}, {"value": "true", "variable": 74}, {"value": "false", "variable": 92}, {"value": "true", "variable": 78}, {"value": "opens_easily_manually", "variable": 77}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "true", "variable": 107}, {"value": "true", "variable": 106}, {"value": "true", "variable": 113}, {"value": "true", "variable": 105}, {"value": "true", "variable": 114}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 109}, {"value": "true", "variable": 112}, {"value": "indoor_facility", "variable"… internal 15902 lipas 78862 35b58d19-2e0b-416b-9877-eb156144bbdf 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1         https://www.google.com/maps/uv?hl=fi&pb=!1s0x46920bcb75fc2af1%3A0x92329e4a48daba63!2m22!2m2!1i80!2i80!3m1!2i20!16m16!1b1!2m2!1m1!1e1!2m2!1m1!1e3!2m2!1m1!1e5!2m2!1m1!1e4!2m2!1m1!1e6!3m1!7e115!4s%2Fmaps%2Fplace%2Fressun%2Blukio%2F%4060.1958984%2C24.9065391%2C3a%2C75y%2C332.16h%2C90t%2Fdata%3D*213m4*211e1*213m2*211sNZPp78zXnEmo_J-YRV5DoA*212e0*214m2*213m1*211s0x46920bcb75fc2af1%3A0x92329e4a48daba63!5sressun%20lukio%20-%20Google-haku&imagekey=!1e10!2sAF1QipOcmlwhlw1TYuoyibO_o0naVSqbE2RnfQg7iXu2&sa=X https://www.google.com/maps/place/Lehtikuusentie+4,+00270+Helsinki/@60.1964202,24.9037959,17z/data=!3m1!4b1!4m5!3m4!1s0x469209f5c4d8fdd3:0x8fe9095b269f15be!8m2!3d60.1964202!4d24.9059846       Ressun lukio / Kuntosali   Kalevankatu 8-10 Kalevagatan 8-10 Kalevankatu 8-10 https://www.hel.fi/ressul/fi https://www.hel.fi/ressul/fi https://www.hel.fi/ressul/fi   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 82122   +358 9 310 82122 kanslia.reslu@edu.hel.fi https://www.hel.fi/ressul/fi 2015-08-25T14:13:23+03:00 00100 www.hel.fi kaikki helsinki 2020-08-12T10:36:20.889337+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [1403] helsinki [611] [350] {} Point 24.93841 60.16705           Ressu gymnasium / Gym     1         1               4      
46070 [] [{"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 29}, {"value": "true", "variable": 6}, {"value": "false", "variable": 48}, {"value": "true", "variable": 27}, {"value": "true", "variable": 59}, {"value": "false", "variable": 34}, {"value": "false", "variable": 84}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 50}, {"value": "true", "variable": 57}, {"value": "false", "variable": 53}, {"value": "true", "variable": 38}, {"value": "false", "variable": 31}, {"value": "true", "variable": 115}, {"value": "indoor_facility", "variable": 500}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 51}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "smooth", "variable": 17}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 103}, {"value": "false", "variable": 49}, {"value": "true", "variable": 109}, {"value": "true", "variable": 112}, {"value": "false", "variable": 83}, {"value": "true", "variable": 113}, {"value": "true", "variable": 107}, {"value": "false", "variable": 33}, {"value": "false", "variable": 116}, {"value": "true", "variable": 114}, {"value": "true", "variable": 5}, {"value": "true", "variable": 78}, {"value": "true", "variable": 44}, {"value": "false", "variable": 117}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 52}, {"value": "opens_easily_manually", "variable": 77}, {"value": "true", "variable": 20}, {"value": "true", "variable": 58}, {"value": "sufficiently_wide", "variable": 18}, {"value": "under_10m", "variable": 4}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 70}, {"value": "false", "variable": 98}, {"value": "false", "variable": 46}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 76}, {"value": "false", "variable": 22}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 111}, {"value": "false", "variable": 21}, {"value": "true", "variable": 106}, {"value": "true", "variable… internal 15945 lipas 80753 35b58d19-2e0b-416b-9877-eb156144bbdf 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1         https://www.google.com/maps/uv?hl=fi&pb=!1s0x46920bcb75fc2af1%3A0x92329e4a48daba63!2m22!2m2!1i80!2i80!3m1!2i20!16m16!1b1!2m2!1m1!1e1!2m2!1m1!1e3!2m2!1m1!1e5!2m2!1m1!1e4!2m2!1m1!1e6!3m1!7e115!4s%2Fmaps%2Fplace%2Fressun%2Blukio%2F%4060.1958984%2C24.9065391%2C3a%2C75y%2C332.16h%2C90t%2Fdata%3D*213m4*211e1*213m2*211sNZPp78zXnEmo_J-YRV5DoA*212e0*214m2*213m1*211s0x46920bcb75fc2af1%3A0x92329e4a48daba63!5sressun%20lukio%20-%20Google-haku&imagekey=!1e10!2sAF1QipOcmlwhlw1TYuoyibO_o0naVSqbE2RnfQg7iXu2&sa=X https://www.google.com/maps/place/Lehtikuusentie+4,+00270+Helsinki/@60.1964202,24.9037959,17z/data=!3m1!4b1!4m5!3m4!1s0x469209f5c4d8fdd3:0x8fe9095b269f15be!8m2!3d60.1964202!4d24.9059846       Ressun lukio / Liikuntasali   Kalevankatu 8-10 Kalevagatan 8-10 Kalevankatu 8-10 https://www.hel.fi/ressul/fi https://www.hel.fi/ressul/fi https://www.hel.fi/ressul/fi   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 82122   +358 9 310 82122 kanslia.reslu@edu.hel.fi https://www.hel.fi/ressul/fi 2015-08-25T14:13:37+03:00 00100 www.hel.fi kaikki helsinki 2020-08-12T10:36:20.930769+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [1403] helsinki [612] [402] {} Point 24.938446 60.16705           Ressu gymnasium / Idrottssal     1         1               4      
55495 [{"section_type": "LINK", "name": {"fi": "Ruokalista", "sv": "Meny", "en": "Menu"}, "www": {"fi": "https://ruokalistat.azurewebsites.net/#/home", "sv": "https://ruokalistat.azurewebsites.net/#/home", "en": "https://ruokalistat.azurewebsites.net/#/home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 74}, {"value": "opens_easily_manually", "variable": 54}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "indoor_facility", "variable": 500}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 114}, {"value": "true", "variable": 50}, {"value": "true", "variable": 106}, {"value": "true", "variable": 20}, {"value": "false", "variable": 53}, {"value": "false", "variable": 62}, {"value": "true", "variable": 29}, {"value": "true", "variable": 57}, {"value": "on_door", "variable": 110}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "under_20mm", "variable": 91}, {"value": "sufficiently_wide", "variable": 18}, {"value": "10", "variable": 1}, {"value": "true", "variable": 59}, {"value": "true", "variable": 37}, {"value": "false", "variable": 84}, {"value": "false", "variable": 111}, {"value": "true", "variable": 23}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 73}, {"value": "true", "variable": 109}, {"value": "smooth", "variable": 17}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "under_20mm", "variable": 56}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 117}, {"value": "true", "variable": 107}, {"value": "true", "variable": 112}, {"value": "false", "variable": 83}, {"value": "false", "variable": 116}, {"value": "true", "variable": 5}, {"value": "false", "variable": 46}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "opens_easily_manually", "variable": 77}, {"value": "true", "variable": 58}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 104}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "false", "variable": 79}, {"value": "false", "variable": 48}, {"value": "false", "variable": 34}, {"value"… internal 24815     8f9c0bf4-5855-4cbd-b130-37da20a9595b 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   service_by_municipally_owned_company kunnan liikelaitoksen palvelu tjänst från kommunalt affärsverk service by municipally owned company 1         https://www.google.com/maps/uv?hl=fi&pb=!1s0x46920bcb75fc2af1%3A0x92329e4a48daba63!2m22!2m2!1i80!2i80!3m1!2i20!16m16!1b1!2m2!1m1!1e1!2m2!1m1!1e3!2m2!1m1!1e5!2m2!1m1!1e4!2m2!1m1!1e6!3m1!7e115!4s%2Fmaps%2Fplace%2Fressun%2Blukio%2F%4060.1958984%2C24.9065391%2C3a%2C75y%2C332.16h%2C90t%2Fdata%3D*213m4*211e1*213m2*211sNZPp78zXnEmo_J-YRV5DoA*212e0*214m2*213m1*211s0x46920bcb75fc2af1%3A0x92329e4a48daba63!5sressun%20lukio%20-%20Google-haku&imagekey=!1e10!2sAF1QipOcmlwhlw1TYuoyibO_o0naVSqbE2RnfQg7iXu2&sa=X https://www.google.com/maps/place/Lehtikuusentie+4,+00270+Helsinki/@60.1964202,24.9037959,17z/data=!3m1!4b1!4m5!3m4!1s0x469209f5c4d8fdd3:0x8fe9095b269f15be!8m2!3d60.1964202!4d24.9059846       Kouluravintola, Ressun lukio School restaurant, Ressun lukio Kalevankatu 8 Kalevagatan 8 Kalevankatu 8 https://www.hel.fi/palvelukeskus/fi/Ateriapalvelut/ https://www.hel.fi/palvelukeskus/sv/maltidstjanster/ https://www.hel.fi/palvelukeskus/en/food-services/   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 82135   +358 9 310 82135 Kouluravintola.Ressu_lu@hel.fi https://www.hel.fi/ressul/fi 2017-11-03T00:02:06+02:00 00100 www.hel.fi kaikki helsinki 2020-05-22T13:02:14.368178+03:00 {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} [1087] helsinki [1376] [338] {} Point 24.938444 60.167095 PL 10304, 00099 Helsingin kaupunki         Skolrestaurang, Ressun lukio             P.O. Box 10304, 00099 City of Helsinki 1         PB 10304, 00099 Helsingfors stad     4      

Advanced export

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

CSV options:

CREATE TABLE [unit] (
   [id] INTEGER PRIMARY KEY,
   [connections] TEXT,
   [accessibility_properties] TEXT,
   [identifiers_0_namespace] TEXT,
   [identifiers_0_value] TEXT,
   [identifiers_1_namespace] TEXT,
   [identifiers_1_value] TEXT,
   [department] TEXT,
   [root_department] TEXT,
   [provider_type] TEXT,
   [organizer_type] TEXT,
   [contract_type_id] TEXT,
   [contract_type_description_fi] TEXT,
   [contract_type_description_sv] TEXT,
   [contract_type_description_en] TEXT,
   [is_active] INTEGER,
   [deleted_at] TEXT,
   [organizer_name] TEXT,
   [organizer_business_id] TEXT,
   [picture_url] TEXT,
   [picture_entrance_url] TEXT,
   [streetview_entrance_url] TEXT,
   [description_fi] TEXT,
   [description_en] TEXT,
   [short_description] TEXT,
   [name_fi] TEXT,
   [name_en] TEXT,
   [street_address_fi] TEXT,
   [street_address_sv] TEXT,
   [street_address_en] TEXT,
   [www_fi] TEXT,
   [www_sv] TEXT,
   [www_en] TEXT,
   [address_postal_full] TEXT,
   [call_charge_info_fi] TEXT,
   [call_charge_info_sv] TEXT,
   [call_charge_info_en] TEXT,
   [picture_caption] TEXT,
   [phone] TEXT,
   [fax] TEXT,
   [email] TEXT,
   [accessibility_phone] TEXT,
   [accessibility_email] TEXT,
   [accessibility_www] TEXT,
   [created_time] TEXT,
   [address_zip] TEXT,
   [data_source] TEXT,
   [extensions_maintenance_group] TEXT,
   [extensions_maintenance_organization] TEXT,
   [last_modified_time] TEXT,
   [accessibility_viewpoints] TEXT,
   [root_service_nodes] TEXT,
   [municipality] TEXT,
   [service_nodes] TEXT,
   [services] TEXT,
   [keywords] TEXT,
   [location_type] TEXT,
   [location_coordinates_0] FLOAT,
   [location_coordinates_1] FLOAT,
   [address_postal_full_fi] TEXT,
   [identifiers_2_value] TEXT,
   [picture_caption_fi] TEXT,
   [call_charge_info] TEXT,
   [www] TEXT,
   [name_sv] TEXT,
   [short_description_fi] TEXT,
   [accessibility_shortcoming_count_reduced_mobility] TEXT,
   [accessibility_shortcoming_count_wheelchair] TEXT,
   [location] TEXT,
   [picture_caption_sv] TEXT,
   [accessibility_shortcoming_count_stroller] TEXT,
   [address_postal_full_en] TEXT,
   [accessibility_shortcoming_count_hearing_aid] TEXT,
   [street_address] TEXT,
   [contract_type] TEXT,
   [accessibility_shortcoming_count_rollator] TEXT,
   [identifiers_2_namespace] TEXT,
   [address_postal_full_sv] TEXT,
   [short_description_sv] TEXT,
   [description_sv] TEXT,
   [accessibility_shortcoming_count_visually_impaired] TEXT,
   [short_description_en] TEXT,
   [description] TEXT,
   [picture_caption_en] TEXT
);