unit
3 rows where identifiers_2_namespace = "lipas" and short_description_en = "The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan."
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40142 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 1.6. - 9.8.2020\nklo 10.00 - 20.00", "sv": "Perioden 1.6. - 9.8.2020\nkl 10.00 - 20.00", "en": "Period 1.6. - 9.8.2020\n10.00 - 20.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Uimarantakausi alkaa normaalisti 1.6."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "rannan henkil\u00f6kunta", "sv": "strandpersonal", "en": "beach personnel"}, "www": null, "email": null, "phone": "+358 9 310 21416, +358 40 670 0176", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Ulkoliikunta.fi -karttapalvelu", "sv": "Tj\u00e4nsten Utemotionskarta", "en": "The Outdoor Exercise Map"}, "www": {"fi": "https://ulkoliikunta.fi/", "sv": "https://ulkoliikunta.fi/", "en": "https://ulkoliikunta.fi/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/uimarantojen-jarjestyssaannot", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/ordningsstadga-for-badstrander", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-beaches"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Kahvila Bistro Badenbaden, facebook", "sv": "Kaf\u00e9 Bistro Badenbaden, facebook", "en": "Caf\u00e9 Bistro Badenbaden, facebook"}, "www": {"fi": "https://www.facebook.com/bistrobadenbaden/?fref=ts", "sv": "https://www.facebook.com/bistrobadenbaden/?fref=ts", "en": "https://www.facebook.com/bistrobadenbaden/?fref=ts"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "handrails_on_both_sides", "variable": 520}, {"value": "true", "variable": 581}, {"value": "less_than_20m", "variable": 503}, {"value": "ramp_under_6m_long", "variable": 518}, {"value": "elsewhere", "variable": 574}, {"value": "true", "variable": 576}, {"value": "at_least_4_steps", "variable": 512}, {"value": "true", "variable": 527}, {"value": "true", "variable": 533}, {"value": "0", "variable": 1}, {"value": "not_easy_to_count", "variable": 521}, {"value": "false", "variable": 575}, {"value": "not_guided_but_clear", "variable": 504}, {"value": "false", "variable": 516}, {"value": "false", "variable": 529}, {"value": "asphalt", "variable": 506}, {"value": "handrails_on_one_side", "variable": 582}, {"value": "false", "variable": 572}, {"value": "true", "variable": 513}, {"value": "true", "variable": 517}, {"value": "true", "variable": 505}, {"value": "flush_toilet_in_dressing_room", "variable": 536}, {"value": "dressing_room_for_men_women", "variable": 571}, {"value": "smooth", "variable": 507}, {"value": "smooth", "variable": 577}, {"value": "handrails_on_one_side", "variable": 514}, {"value": "true", "variable": 537}, {"value": "false", "variable": 519}, {"value": "true", "variable": 579}, {"value": "sufficiently_wide", "variable": 578}, {"value": "ramp_under_6m_long", "variable": 586}, {"value": "outdoor_facility", "variable": 500}, {"value": "true", "variable": 525}, {"value": "true", "variable": 511}, {"value": "true", "variable": 515}, {"value": "true", "variable": 583}, {"value": "false", "variable": 584}, {"value": "true", "variable": 589}, {"value": "false", "variable": 522}, {"value": "handrails_on_both_sides", "variable": 588}, {"value": "true", "variable": 510}, {"value": "over_20mm", "variable": 591}, {"value": "reachable_by_car", "variable": 501}, {"value": "sufficiently_wide", "variable": 532}, {"value": "sufficiently_wide", "variable": 508}, {"value": "false", "variable": 592}, {"value": "true", "variable": 509}, {"value": "false", "variable": 587}, {"value": "true", "variable": 528}, {… | internal | 14238 | visithelsinki | 143 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. Ulkoliikunta.fi -palvelusta löydät reaaliaikaista tietoa pääkaupunkiseudun uimarantojen kunnosta - sinilevätilanteesta ja veden lämpötilasta.Uinninvalvonta.Esteetömyys: Ranta esteetön uimareille valvonta-aikana(rannalle levitetään matto pyörätuolilla liikkumista varten ja rannalla myös kelluva uintituoli) Nämä saa pyydettäessä rantapelastajilta.Palvelut: pukusuoja, suihku, suihkupyörätuoli, WC, kuntovälineet, koripallokenttä, Beach-volley -kenttä, Kahvila Bistro BadenBaden. | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. In the Outdoor Exercise Map service you can find information on the beaches in the metropolitan area - the algae situation and the water temperature.Lifeguard on duty.Accessibility: The beach is accessible when the beach has lifeguard supervision. A carpet is spread out for wheelchairs and there is also a floating bating chair on the beach. These are available on request from the lifeguards.Services: cabin, toilet, shower, shower wheelchair basketball ground, Beach-volley ground, weightlifting area, Café Bistro Badenbaden. | Hietarannan uimaranta | Hietaranta beach | Hiekkarannantie 11 | Sandstrandsvägen 11 | Hiekkarannantie 11 | 2014-09-05T13:29:49+03:00 | 00100 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:59.843362+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red"} | [1403] | helsinki | [689] | [731] | {} | Point | 24.907427 | 60.173553 | 100614 | Sandstrands badstrand | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. | 4 | 4 | 4 | lipas | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. I tjänsten Utemotionskarta hittar du information i realtid om badstränderna i huvudstadsregionen - algläget och vattnets temperatur.Badbevakning.Tillgänglighet: Stranden är tillgänglig för simmare under den tid stranden har bevakning. En matta kan bredas ut på stranden för rullstolar och det finns en flytande badstol att låna. Dessa fås av badvakterna på begären.Tjänster: omklädningsrum, WC, Dush, rullstol för dusch, Beach-volleyplan, basketbollplan, Kafé Bistro Badenbaden. | 2 | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. | ||||||||||||||||||||||||||||||||||||
| 40559 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 1.6. - 9.8.2020\nklo 10.00 - 18.00", "sv": "Perioden 1.6. - 9.8.2020\nkl 10.00 - 18.00", "en": "Period 1.6. - 9.8.2020\n10.00 - 18.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Uimarantakausi alkaa normaalisti 1.6."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "rannan henkil\u00f6kunta", "sv": "strandpersonal", "en": "beach personnel"}, "www": null, "email": null, "phone": "+358 9 310 71462", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Ulkoliikunta.fi -karttapalvelu", "sv": "Tj\u00e4nsten Utemotionskarta", "en": "The Outdoor Exercise Map"}, "www": {"fi": "https://ulkoliikunta.fi/", "sv": "https://ulkoliikunta.fi/", "en": "https://ulkoliikunta.fi/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/uimarantojen-jarjestyssaannot", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/ordningsstadga-for-badstrander", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-beaches"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 563}, {"value": "false", "variable": 550}, {"value": "true", "variable": 537}, {"value": "true", "variable": 538}, {"value": "true", "variable": 525}, {"value": "smooth", "variable": 543}, {"value": "more_than_200m", "variable": 502}, {"value": "outdoors", "variable": 2}, {"value": "at_least_4_steps", "variable": 512}, {"value": "false", "variable": 551}, {"value": "false", "variable": 522}, {"value": "false", "variable": 560}, {"value": "no_handrails", "variable": 548}, {"value": "false", "variable": 530}, {"value": "true", "variable": 510}, {"value": "false", "variable": 509}, {"value": "false", "variable": 558}, {"value": "true", "variable": 542}, {"value": "not_guided_not_clear", "variable": 504}, {"value": "under_20mm", "variable": 557}, {"value": "true", "variable": 565}, {"value": "true", "variable": 535}, {"value": "true", "variable": 505}, {"value": "false", "variable": 513}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "cubicle_with_bench", "variable": 571}, {"value": "false", "variable": 529}, {"value": "true", "variable": 533}, {"value": "false", "variable": 516}, {"value": "true", "variable": 566}, {"value": "true", "variable": 527}, {"value": "at_least_3600mm", "variable": 3}, {"value": "flush_toilet_separate", "variable": 536}, {"value": "false", "variable": 564}, {"value": "true", "variable": 511}, {"value": "reachable_by_car", "variable": 501}, {"value": "opens_easily_manually", "variable": 556}, {"value": "3", "variable": 521}, {"value": "no_handrails", "variable": 514}, {"value": "true", "variable": 567}, {"value": "outdoor_facility", "variable": 500}, {"value": "true", "variable": 528}, {"value": "false", "variable": 547}, {"value": "false", "variable": 539}, {"value": "false", "variable": 517}, {"value": "true", "variable": 545}, {"value": "smooth", "variable": 507}, {"value": "sufficiently_wide", "variable": 544}, {"value": "beach", "variable": 61}, {"value": "true", "variable": 534}, {"value": "false", "variable": 568}, {"value": "true", "var… | internal | 18540 | visithelsinki | 1920 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. Ulkoliikunta.fi -palvelusta löydät reaaliaikaista tietoa pääkaupunkiseudun uimarantojen kunnosta - sinilevätilanteesta ja veden lämpötilasta.Uinninvalvonta. Palvelut: pukusuoja (suljetaan 17.30), suihku, WC, kuntovälineet, leikkipaikka, kioskivaunu | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. In the Outdoor Exercise Map service you can find information on the beaches in the metropolitan area - the algae situation and the water temperature.Lifeguard on duty. Services: cabin (closed 17.30), toilet, shower, weightlifting area, kiosk cart | Mustikkamaan uimaranta | Mustikkamaa beach | Mustikkamaanpolku 2 | Blåbärslandsstigen 2 | Mustikkamaanpolku 2 | 2014-09-05T13:29:49+03:00 | 00570 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:02.365036+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red"} | [1403] | helsinki | [689] | [731] | {} | Point | 24.99305 | 60.17906 | 100470 | Blåbärslandets badstrand | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. | 8 | 7 | 1 | 7 | lipas | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. I tjänsten Utemotionskarta hittar du information i realtid om badstränderna i huvudstadsregionen - algläget och vattnets temperatur.Badbevakning. Tjänster: omklädningsrum (stängs kl. 17.30), WC, dusch, motionsredskap, kioskvagn | 6 | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. | |||||||||||||||||||||||||||||||||||
| 41601 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 1.6. - 9.8.2020\nklo 10.00 - 18.00", "sv": "Perioden 1.6. - 9.8.20120\nkl 10.00 - 18.00", "en": "Period 1.6. - 9.8.2020\n10.00 - 18.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Uimarantakausi alkaa normaalisti 1.6."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "rannan henkil\u00f6kunta", "sv": "strandpersonal", "en": "beach personnel"}, "www": null, "email": null, "phone": "+358 9 310 23668", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Ulkoliikunta.fi -karttapalvelu", "sv": "Tj\u00e4nsten Utemotionskarta", "en": "The Outdoor Exercise Map"}, "www": {"fi": "https://ulkoliikunta.fi/", "sv": "https://ulkoliikunta.fi/", "en": "https://ulkoliikunta.fi/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/uimarantojen-jarjestyssaannot", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/ordningsstadga-for-badstrander", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-beaches"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "smooth", "variable": 577}, {"value": "false", "variable": 537}, {"value": "3", "variable": 521}, {"value": "true", "variable": 528}, {"value": "outdoor_sport_facility", "variable": 60}, {"value": "3_consecutive_steps", "variable": 580}, {"value": "true", "variable": 594}, {"value": "sufficiently_wide", "variable": 578}, {"value": "false", "variable": 529}, {"value": "true", "variable": 592}, {"value": "not_guided_not_clear", "variable": 504}, {"value": "false", "variable": 573}, {"value": "false", "variable": 593}, {"value": "true", "variable": 534}, {"value": "false", "variable": 581}, {"value": "false", "variable": 530}, {"value": "dressing_room_for_men_women", "variable": 571}, {"value": "opens_easily_manually", "variable": 590}, {"value": "beach", "variable": 61}, {"value": "true", "variable": 570}, {"value": "false", "variable": 505}, {"value": "false", "variable": 595}, {"value": "true", "variable": 535}, {"value": "between_100_200m", "variable": 503}, {"value": "false", "variable": 584}, {"value": "false", "variable": 587}, {"value": "true", "variable": 585}, {"value": "ramp_under_6m_long", "variable": 586}, {"value": "true", "variable": 572}, {"value": "no_handrails", "variable": 582}, {"value": "reachable_by_car", "variable": 501}, {"value": "true", "variable": 533}, {"value": "true", "variable": 579}, {"value": "true", "variable": 589}, {"value": "true", "variable": 576}, {"value": "true", "variable": 527}, {"value": "0", "variable": 1}, {"value": "gravel", "variable": 506}, {"value": "flush_toilet_separate", "variable": 536}, {"value": "outdoor_facility", "variable": 500}, {"value": "true", "variable": 525}, {"value": "handrails_on_both_sides", "variable": 588}, {"value": "false", "variable": 522}, {"value": "over_20mm", "variable": 591}] | internal | 10430 | visithelsinki | 1922 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. Ulkoliikunta.fi -palvelusta löydät reaaliaikaista tietoa pääkaupunkiseudun uimarantojen kunnosta - sinilevätilanteesta ja veden lämpötilasta.Uinninvalvonta. Palvelut: pukusuoja (suljetaan 17.30), suihku, WC, kuntovälineet, leikkipaikka, kioski | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. In the Outdoor Exercise Map service you can find information on the beaches in the metropolitan area - the algae situation and the water temperature.Lifeguard on duty. Services: cabin (closed 17.30), toilet, shower, kiosk, children's playground, weightlifting area | Munkkiniemen uimaranta | Munkkiniemi beach | Munkkiniemenranta 44 | Munksnässtrand 44 | Munkkiniemenranta 44 | 2014-09-05T13:29:49+03:00 | 00330 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:08.295116+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": null, "51": "red", "52": "red"} | [1403] | helsinki | [689] | [731] | {} | Point | 24.856968 | 60.201145 | 99227 | Munksnäs badstrand | Kaupunki valvoo uimarantoja uimakaudella ja ottaa rantojen vedestä vesinäytteitä näytteenottosuunnitelman mukaan. | 4 | 4 | 4 | lipas | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. | Helsingfors stad övervakar badstränder under säsongen för simning utomhus och tar vattenprover på stränder enligt vattenprovtagningsplanet. I tjänsten Utemotionskarta hittar du information i realtid om badstränderna i huvudstadsregionen - algläget och vattnets temperatur.Badbevakning. Tjänster: omklädningsrum (stängs kl. 17.30), WC, dusch, kiosk, lekplats, motionsredskap | 3 | The City of Helsinki supervises the beaches during the swimming season and takes samples of the beach water in accordance with the sampling plan. |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );