servicemap

Custom SQL query returning 1 row (hide)

select 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, email, 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 from unit where "accessibility_shortcoming_count_visually_impaired" = :p0 and "identifiers_2_namespace" = :p1 order by id limit 101

Query parameters

This data as json, CSV

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	email	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
40823	[{"section_type": "OPENING_HOURS", "name": {"fi": "SULJETTU", "sv": "ST\u00c4NGD", "en": "CLOSED"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Poikkeusaukioloajat -", "sv": "Avvikande \u00f6ppettider -", "en": "Exceptional opening hours -"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "- Noudata turvav\u00e4lej\u00e4 ja hyv\u00e4\u00e4 hygieniaa\n- Ei varattuja vuoroja\n- Jonotus turvav\u00e4lein. Ei ohituksia.", "sv": "- F\u00f6lj s\u00e4kerhetsavst\u00e5nden och bra hygien\n- Inga reserverade turer\n- H\u00e5ll s\u00e4kerhetsavst\u00e5nd d\u00e5 du k\u00f6ar, passera inte andra personer i k\u00f6", "en": "- Please keep your distance to other customers and practice good hygiene\n- Everybody must queue while remaining at a safe distance from others"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Sis\u00e4\u00e4np\u00e4\u00e4syajat \n\n1.6. - 23.8.2020\n\nma - la 6.30 - 20.00 \nsu 9.00 - 20.00\n\nKassa suljetaan klo 20, uintiaika p\u00e4\u00e4ttyy klo 20.30 ja peseytymisaika klo 20.45. Alueelta on poistuttava klo 21.00\n\nHyppytornit (5m, 7m, 10m) avoinna \nklo 12.15-12.35\nklo 14.00-14.20\nklo 16.00-16.20\nklo 18.00-18.20\n\nPonnahduslaudat (1m, 3m) auki klo 10.00 alkaen.", "sv": "Intr\u00e4destider\n\n1.6. - 23.8.2020\n\nm\u00e5 - l\u00f6 6.30 - 20.00 \ns\u00f6 9.00 - 20.00 \n\nKassan st\u00e4ngs klockan 20.00. Bass\u00e4ngen \u00e4r \u00f6ppen till klockan 20.30 och duschutrymmena till klockan 20.45. Man m\u00e5ste l\u00e4mna omr\u00e5det klockan 21.00.", "en": "Entrance hours\n\n1.6. - 23.8.2020\n\nMon - Sat 6.30 - 20.00 \nSun 9.00 - 20.00 \n\nCash desks close at 20.00, swimming time ends at 20.30, and washing time at 20.45. Customers must leave the area by 21.00."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "kassa", "sv": "kassa", "en": "cashier"}, "www": null, "email": null, "phone": "+358 9 310 87477", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "uimavalvojat", "sv": "badvakt", "en": "lifeguard"}, "www": null, "email": null, "phone": "+358 9 310 87478", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimivastaava 8.00-16.00", "sv": "sommaranl\u00e4ggningsf\u00f6rest\u00e5ndarna 8.00 - 16.00", "en": "summer manager 8.00 - 16.00"}, "www": null, "email": null, "phone": "+358 9 310 21449", "contact_person": "Katja Kuusisto"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies", "sv": "teamchef", "en": "manager"}, "www": null, "email": null, "phone": "+358 9 310 71525", "contact_person": "Maritta Harjap\u00e4\u00e4"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "uimakoulut ja ohjattu liikunta", "sv": "simskolor", "en": "swimming schools and supervised sports"}, "www": null, "email": null, "phone": "+358 50 401 3582", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Asiakaskortin sopimusehdot", "sv": "Kundavtalsvillkor", "en": "Chargeable customer cards contract terms"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maksut/sopimusehdot", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/priser/kundavtalsvillkor", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/pricing/ghargeable-customer-cards-contract-terms"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Erityisuimakortti", "sv": "Specialsimningskort", "en": "Special swimming card"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kulttuuri-ja-vapaa-aika/liikunta/sisaliikuntapaikat/uimahallit/erityisuimakortti", "sv": "https://www.hel.fi/helsinki/sv/kultur-och-fritid/motion/idrottsplatser-inomhus/simhallar/specialsimningskort", "en": "https://www.hel.fi/helsinki/en/culture/sports/indoor/swimming/swimming+card"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Hintaryhmien m\u00e4\u00e4rittelyt", "sv": "Fastst\u00e4llande av prisgrupper", "en": "Definitions for the price groups"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maksut/hintaryhmien-maarittelyt", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/priser/faststallande-av-prisgrupper", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/pricing/definitions-for-the-price-groups"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Allm\u00e4nna ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/uimahallien-ja-uimaloiden-yleiset-jarjestyssaannot", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-simhallar-och-friluftsbad", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-indoor-and-outdoor-pools"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Uimapukuohjeistus", "sv": "Badgl\u00e4der guide", "en": "Swimwear guide"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kulttuuri-ja-vapaa-aika/liikunta/sisaliikuntapaikat/uimahallit/uimapukuohjeistus", "sv": "https://www.hel.fi/helsinki/fi/kulttuuri-ja-vapaa-aika/liikunta/sisaliikuntapaikat/uimahallit/uimapukuohjeistus", "en": "https://www.hel.fi/helsinki/fi/kulttuuri-ja-vapaa-aika/liikunta/sisaliikuntapaikat/uimahallit/uimapukuohjeistus"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Ennakkolippuja Kumpulan maauimalaan\nOsta lippu t\u00e4\u00e4lt\u00e4"}, "www": {"fi": "https://ssl.eventilla.com/cal/kumpulanmaauimala"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "false", "variable": 48}, {"value": "false", "variable": 116}, {"value": "true", "variable": 117}, {"value": "false", "variable": 98}, {"value": "false", "variable": 105}, {"value": "true", "variable": 107}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 104}, {"value": "false", "variable": 102}, {"value": "false", "variable": 103}, {"value": "true", "variable": 109}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 80}, {"value": "false", "variable": 79}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 92}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "sport_facility", "variable": 60}, {"value": "true", "variable": 50}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 51}, {"value": "false", "variable": 52}, {"value": "outdoor_swimming_pool", "variable": 61}, {"value": "false", "variable": 111}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "true", "variable": 62}, {"value": "true", "variable": 37}, {"value": "false", "variable": 112}, {"value": "false", "variable": 57}, {"value": "false", "variable": 49}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 43}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 34}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "true", "variable": 38}, {"value": "false", "variable": 33}, {"value": "true", "variable": 44}, {"value": "true", "variable": 29}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "true", "variable": 31}, {"value": "false", "variable": 28}, {"value": "false", "variable": 27}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "true", "variable": 25}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "true", "variable": 20}, {"value": "false", "variable": 21}, {"value": "true", "variable": 22}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 23}, {"value": "true", "variable": 6}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 40}, {"value": "indoor_facility", "variable": 500}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 113}, {"value": "true", "variable": 46}, {"value": "3", "variable": 1}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 114}, {"value": "true", "variable": 5}, {"value": "true", "variable": 115}, {"value": "false", "variable": 118}]	internal	18422	visithelsinki	412	aea46dd4-caec-4f97-9206-10e939dc6b8d	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED		municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1							HinnatAikuiset - kertamaksu 5 e - 10 krt / kuukausikortti 40 eMuut - kertamaksu 3 e- 10 krt / kuukausi 24 e Lapset- kertamaksu 2,50 e- 10 krt / kuukausi 20 e Sotaveteraanit, lapset alle 7v.: maksuton sisäänpääsy.- Henkilökohtainen asiakaskortti (sarjalippu) 4 e - Pyyhe 7 e - Uimapuku 7 e- Istuinalusta / saippua 1 ePukeutumistiloissa lukolliset kaapit. Varaa 50 sentin kolikko avainpantiksi.Palvelut: Pesutilat, saunat, katsomo/aurinkotasanne 25 m allas, lastenallas, kahluuallas, hyppyallas, hyppytelineet 1, 3, 5, 7,5 ja 10 m. Koripallokenttä, beach volley-kenttä, leikkialueHuom! Liikuntarajoitteisten allashissi epäkunnossa!Kahvilaavoinna ma-la klo 8-18su klo 10-18puh. 050 320 9801PysäköintialueMuuta: Puhdistusmenetelmänä toimii hiekkasuodatinpuhdistus (kloori)Huom! shortseissa uinti kielletty - lukuun ottamatta uintishortseja.Kumpulan maauimalan alueella ei ole ulkokuntosalia.Valokuvaukseen tarvitaan liikuntalaitososaston kuvauslupa.	ChargesAdults - one visit €5- 10 visits / 1 month €40 Others - one visit €3 - 10 visits / 1 month €24 Children- one visit €2,50 - 10 visits / 1 month €20War veterans, children (under 7): free of charge.- Personal customer card (10 visits) €4- costume €7 - Towel €7 - Seatcover / soap €1Services: Dressing rooms, showers, saunas, stands and sun plateau25-metre pool, children's pool, wading pool, diving pool, stands: 1, 3, 5, 7,5 and 10 m.Basketball court, volleyball court, children's play areaPlease note that the pool lift for the handicapped is out of order!Café open on Mon - Sat 8-18on Sun 10-18tel. 050 320 9801Parking lotOther info: Sand filter cleaning is used as the cleaning method (chlorine)note! Swimming in shorts is forbidden - with the exception of swimming trunks.There is no outdoor gym inside the Kumpula outdoor swimming pool area.A photography permit from the Sports Facilities Section is required for photography.		Kumpulan maauimala	Kumpula outdoor swimming pool	Allastie 1	Bassängvägen 1	Allastie 1															2014-09-05T13:29:49+03:00	00560	www.hel.fi	kaikki	helsinki	2020-11-05T16:32:04.031087+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", "61": "red"}	[1403]	helsinki	[686]	[426]	{}	Point	24.958284	60.208702		98177				Gumtäkts friluftsbad	Helsingissä on kaksi maauimalaa; Uimastadion ja Kumpulan maauimala.	2	8					1			8	lipas		I Helsingfors finns det två friluftsbad; Simstadion och Gumtäkts friluftsbad.	Priser Vuxna - engångsavgift 5 e - 10 gångers seriekort / 1 månad 40 e Andra- engångsavgift 3 e- 10 gångers seriekort / 1 månad 24 e Barn (7 - 17 år)- engångsavgift 2,50 e- 10 gångers seriekort / 1 månad 20 e Personell kundkortet (seriekort) 4 eTjänster: Omklädningsrum, duschrum, bastur, läktare/solterrass 25 m bassäng, barnbassäng, grund bassäng, hoppbassäng 1, 3, 5, 7,5 och 10 mBasketbollsplan, beach volleyplan, lekområdeObs! Bassänghissen för funktionshindrade är ur bruk!Kaféöppet må - lö 8-18sö 10-18tfn. 050 320 9801ParkeringsplatsÖvrigt: Rening med sandfilter (klor)Obs! Förbjudet att simma med andra shorts än badshorts.Inget utegym finns på friluftsbadets område.För fotografering behövs tillstånd av avdelningen för idrottsanläggningar.	5	Helsinki has two outdoor swimming pools; Helsinki Swimming Stadium and the Kumpula Outdoor Swimming Pool.