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_email" = :p0 and "accessibility_shortcoming_count_visually_impaired" = :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
1314	[{"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": "0", "variable": 1}, {"value": "true", "variable": 5}, {"value": "true", "variable": 6}, {"value": "rough", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 20}, {"value": "false", "variable": 21}, {"value": "false", "variable": 22}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 33}, {"value": "false", "variable": 34}, {"value": "true", "variable": 35}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 37}, {"value": "true", "variable": 38}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "false", "variable": 40}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 42}, {"value": "false", "variable": 43}, {"value": "false", "variable": 44}, {"value": "false", "variable": 48}, {"value": "true", "variable": 49}, {"value": "true", "variable": 50}, {"value": "false", "variable": 51}, {"value": "true", "variable": 52}, {"value": "false", "variable": 53}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 57}, {"value": "false", "variable": 58}, {"value": "true", "variable": 59}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 62}, {"value": "3", "variable": 64}, {"value": "true", "variable": 70}, {"value": "false", "variable": 72}, {"value": "true", "variable": 73}, {"value": "true", "variable": 74}, {"value": "true", "variable": 75}, {"value": "true", "variable": 76}, {"value": "is_heavy", "variable": 77}, {"value": "false", "variable": 78}, {"value": "false", "variable": 79}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 92}, {"value": "false", "variable": 98}, {"value": "false", "variable": 102}, {"value": "false", "variable": 103}, {"value": "false", "variable": 104}, {"value": "false", "variable": 105}, {"value": "false", "variable": 107}, {"value": "indoor_facility", "variable": 500}]	internal	987			d4b3a166-9fa0-4846-9d63-ff1fdab670b6	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED		municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1										Hyvösen ryhmäkoti	Hyvönen group home	Kotkankatu 14-16 A	Kotkagatan 14-16 A	Kotkankatu 14-16 A	https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/hyvonen/	https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/hyvonen/	https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/hyvonen/		pvm/mpm	lna/msa	local network charge/mobile call charge		+358 9 310 43693			+358 9 310 43693	lea.polla@hel.fi		2007-11-15T00:00:00+02:00	00510	www.hel.fi	kaikki	helsinki	2020-11-27T13:01:00.326326+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": null}	[783]	helsinki	[815, 852]	[637, 275]	{}	Point	24.94342	60.192726	PL 51776, 00099 Helsingin kaupunki					Hyvönens grupphem		7	8			2	P.O. Box 51776, 00099 City of Helsinki				8		PB 51776, 00099 Helsingfors stad			12