unit
1 row where identifiers_2_namespace = "lipas" and short_description_en = "Nudist beach, separate areas for women and men."
This data as json, CSV (advanced)
accessibility_shortcoming_count_stroller ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40993 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lis\u00e4tietoa", "sv": "Mer information", "en": "More information"}, "www": null, "email": null, "phone": "+358 9 310 1691", "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}] | [] | internal | 18111 | visithelsinki | 1921 | 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.Ei uinninvalvontaa. Nudistiranta, naisille ja miehille erilliset, aidatut alueet. Uimala on yhteiskäytössä keskiviikkoisin ja sunnuntaisin, jolloin uima-asua on käytettävä. Palvelut: pukusuoja, ulkosuihku, WC. | 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. No lifeguard on duty. Nudist beach, separate areas for women and men. The swimming pool is in mixed-sex use on Wednesdays and Sundays, so a bathing suit is mandatory.Services: cabin, toilet, showers. | Seurasaaren uimala | Seurasaari baths | Seurasaari | Fölisön | Seurasaari | 2014-09-05T13:29:49+03:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:05.061078+02:00 | [1403] | helsinki | [688] | [730] | {} | Point | 24.879047 | 60.182514 | 99631 | Fölisöns badhus | Nudistiranta, naisille ja miehille erilliset, aidatut alueet. | lipas | Naturistbadstrand, inhägnade områden för kvinnor och män. | 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.Ingenbad bevakning. Naturistbadstrand, inhägnade områden för kvinnor och män. Badinrättningen används gemensamt på onsdagar och söndagar, och då är badkläder obligatoriska.Tjänster: dusch, omklädningsrum, WC. | Nudist beach, separate areas for women and men. |
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 );