servicemap

Custom SQL query returning 3 rows (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 order by id limit 101

Query parameters

This data as json, CSV

id	connections	accessibility_properties	identifiers_0_namespace	identifiers_0_value	department	root_department	provider_type	contract_type_id	contract_type_description_fi	contract_type_description_sv	contract_type_description_en	is_active	name_fi	name_en	street_address_fi	street_address_sv	street_address_en	www_fi	www_sv	www_en	call_charge_info_fi	call_charge_info_sv	call_charge_info_en	phone	accessibility_phone	accessibility_email	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	name_sv	accessibility_shortcoming_count_reduced_mobility	accessibility_shortcoming_count_wheelchair	accessibility_shortcoming_count_stroller	address_postal_full_en	accessibility_shortcoming_count_hearing_aid	accessibility_shortcoming_count_rollator	address_postal_full_sv	accessibility_shortcoming_count_visually_impaired
2859	[{"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "false", "variable": 43}, {"value": "true", "variable": 40}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 51}, {"value": "false", "variable": 84}, {"value": "false", "variable": 62}, {"value": "true", "variable": 57}, {"value": "false", "variable": 82}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 49}, {"value": "true", "variable": 25}, {"value": "true", "variable": 38}, {"value": "false", "variable": 79}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 33}, {"value": "false", "variable": 22}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 96}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 42}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 20}, {"value": "false", "variable": 52}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 37}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "true", "variable": 23}, {"value": "true", "variable": 92}, {"value": "false", "variable": 105}, {"value": "false", "variable": 80}, {"value": "false", "variable": 50}, {"value": "false", "variable": 97}, {"value": "false", "variable": 29}, {"value": "false", "variable": 102}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 34}, {"value": "false", "variable": 27}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 48}, {"value": "false", "variable": 28}, {"value": "false", "variable": 59}, {"value": "false", "variable": 70}, {"value": "false", "variable": 107}, {"value": "false", "variable": 21}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 103}, {"value": "false", "variable": 44}, {"value": "false", "variable": 104}, {"value": "over_20mm", "variable": 56}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 58}, {"value": "at_least_4_steps", "variable": 93}, {"value": "2", "variable": 63}, {"value": "true", "variable": 94}, {"value": "false", "variable": 5}, {"value": "0", "variable": 1}, {"value": "false", "variable": 83}]	internal	1407	18b157ac-e863-4482-8bd7-3c737e6fe6d6	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED	municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1	Perhepäivähoito Jakomäki-Puistola-Suutarila	Family day care Suutarila	Linnunradantie 8	Vintergatsvägen 8	Linnunradantie 8	https://www.hel.fi/varhaiskasvatus/fi/pph-alueittain/puistola-jakomaki-suutarila/puistola-jakomaki-suutarila	https://www.hel.fi/helsinki/fi/kasvatus-ja-koulutus/paivahoito/perhepaivahoito/perhepaivahoitoalueet/pph-puistola-jakomaki	https://www.hel.fi/varhaiskasvatus/fi/pph-alueittain/puistola-jakomaki-suutarila/puistola-jakomaki-suutarila	pvm/mpm	lna/msa	local network charge/mobile call charge	+358 9 310 73465	+358 9 310 73465	pph.suutarila@hel.fi	2007-11-15T00:00:00+02:00	00740	www.hel.fi	kaikki	helsinki	2021-01-01T07:30:43.995493+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", "61": "red"}	[1405]	helsinki	[962]	[506]	{}	Point	25.006842	60.280216	PL 74999, 00099 Helsingin kaupunki		6	13	4	P.O. Box 74999, 00099 City of Helsinki	1	13	PB 74999, 00099 Helsingfors stad	14
9020	[{"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}]	[{"value": "false", "variable": 53}, {"value": "false", "variable": 62}, {"value": "false", "variable": 84}, {"value": "false", "variable": 76}, {"value": "true", "variable": 78}, {"value": "false", "variable": 79}, {"value": "false", "variable": 25}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 50}, {"value": "waiting_by_standing", "variable": 81}, {"value": "0", "variable": 1}, {"value": "true", "variable": 72}, {"value": "false", "variable": 29}, {"value": "false", "variable": 102}, {"value": "false", "variable": 33}, {"value": "true", "variable": 70}, {"value": "false", "variable": 82}, {"value": "true", "variable": 23}, {"value": "false", "variable": 58}, {"value": "false", "variable": 21}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 104}, {"value": "false", "variable": 83}, {"value": "false", "variable": 48}, {"value": "true", "variable": 92}, {"value": "false", "variable": 80}, {"value": "spiral_staircase", "variable": 93}, {"value": "false", "variable": 103}, {"value": "false", "variable": 73}, {"value": "spiral_staircase", "variable": 24}, {"value": "false", "variable": 44}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 75}, {"value": "false", "variable": 59}, {"value": "under_20mm", "variable": 56}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "6", "variable": 63}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "false", "variable": 22}, {"value": "true", "variable": 20}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 98}, {"value": "false", "variable": 49}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 38}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "requires_use_of_door_phone_and_is_heavy", "variable": 54}, {"value": "false", "variable": 107}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 51}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 94}, {"value": "false", "variable": 5}, {"value": "false", "variable": 105}, {"value": "true", "variable": 74}, {"value": "false", "variable": 34}, {"value": "true", "variable": 52}]	internal	3741	d4b3a166-9fa0-4846-9d63-ff1fdab670b6	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED	municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1	Sijaishuollon asiakasohjaus ja valvonta	Client supervising in foster care	Toinen linja 4 A	Andra linjen 4 A	Toinen linja 4 A				pvm/mpm	lna/msa	local network charge/mobile call charge	+358 9 310 5015	+358 9 310 46889	juha.jokinen@hel.fi	2009-01-26T15:22:59+02:00	00530	www.hel.fi	kaikki	helsinki	2020-11-27T13:01:09.464180+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", "61": "red"}	[783]	helsinki	[789]	[380]	{}	Point	24.946972	60.181797	PL 6090, 00099 Helsingin kaupunki	Klienthandledning inom vård utom hemmet	7	8	2	P.O. Box 6090, 00099 City of Helsinki	1	8	PB 6090, 00099 Helsingfors stad	14
43924	[{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001", "sv": "Information g\u00e4llande reservationer av skolornas utrymmen p\u00e5 kv\u00e4llar och helger: gymnastiksalar 09 310 87800, \u00f6vriga utrymmen 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "ruotsinkielinen perusopetus luokille 1-5", "sv": "grundl\u00e4ggande utbildning p\u00e5 svenska f\u00f6r \u00e5rskurserna 1-5", "en": "basic education for grades 1-5 in Swedish"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "false", "variable": 103}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 22}, {"value": "true", "variable": 37}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 49}, {"value": "true", "variable": 105}, {"value": "true", "variable": 25}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 79}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 51}, {"value": "true", "variable": 50}, {"value": "true", "variable": 5}, {"value": "false", "variable": 106}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 94}, {"value": "false", "variable": 21}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 48}, {"value": "true", "variable": 40}, {"value": "true", "variable": 59}, {"value": "false", "variable": 97}, {"value": "true", "variable": 92}, {"value": "false", "variable": 44}, {"value": "false", "variable": 6}, {"value": "false", "variable": 58}, {"value": "false", "variable": 102}, {"value": "false", "variable": 104}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 70}, {"value": "false", "variable": 53}, {"value": "false", "variable": 28}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 62}, {"value": "false", "variable": 34}, {"value": "false", "variable": 96}, {"value": "7", "variable": 64}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 23}, {"value": "true", "variable": 20}, {"value": "false", "variable": 33}, {"value": "true", "variable": 38}, {"value": "false", "variable": 43}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "false", "variable": 98}, {"value": "false", "variable": 84}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 29}, {"value": "false", "variable": 107}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 83}, {"value": "true", "variable": 57}, {"value": "at_least_4_turning_steps", "variable": 93}]	internal	20696	e61d617e-26a0-4fd1-b7db-ccebfecfb95b	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED	municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1	Hoplaxskolan: Munksnäs-enheten 0-5	Hoplaxskolan: Munksnäs-enheten 0-5	Lokkalantie 9	Locklaisvägen 9	Lokkalantie 9	https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan	https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan	https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan	pvm/mpm	lna/msa	local network charge/mobile call charge	+358 9 310 86678			2015-11-27T12:11:49+02:00	00330	www.hel.fi	kaikki	helsinki	2020-12-03T13:01:46.544945+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", "61": "red"}	[1087, 1405]	helsinki	[1194, 1208, 1214, 2128, 1095, 2126, 1093, 1189]	[862, 601, 159, 33, 27, 24]	{"fi": ["eskari"], "en": ["basiceducation", "basic education"]}	Point	24.880447	60.19969	PL 33302, 00099 Helsingin kaupunki	Hoplaxskolan: Munksnäs-enheten 0-5	7	11	1	P.O. Box 33302, 00099 City of Helsinki	1	11	PB 33302, 00099 Helsingfors stad	14