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_stroller" = :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	short_description_fi	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
8044	[{"section_type": "LINK", "name": {"fi": "Kysymys & vastauspalsta Pulmakulma", "sv": "Fr\u00e5ge- & svarspalten Pulmakulma", "en": "Forum for questions and answers"}, "www": {"fi": "http://www.nuoret.info/", "sv": "http://www.nuoret.info/", "en": "http://www.nuoret.info/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Harrastushaku.fi", "sv": "Harrastushaku.fi", "en": "Harrastushaku.fi"}, "www": {"fi": "http://nk.hel.fi/harrastushaku/", "sv": "http://nk.hel.fi/harrastushaku/", "en": "http://nk.hel.fi/harrastushaku/"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "false", "variable": 5}, {"value": "false", "variable": 52}, {"value": "false", "variable": 107}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 40}, {"value": "true", "variable": 22}, {"value": "no_handrails", "variable": 95}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 51}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 21}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 44}, {"value": "true", "variable": 58}, {"value": "false", "variable": 33}, {"value": "false", "variable": 83}, {"value": "false", "variable": 49}, {"value": "false", "variable": 50}, {"value": "false", "variable": 105}, {"value": "false", "variable": 84}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "2", "variable": 64}, {"value": "true", "variable": 23}, {"value": "false", "variable": 97}, {"value": "true", "variable": 59}, {"value": "0", "variable": 1}, {"value": "false", "variable": 48}, {"value": "true", "variable": 57}, {"value": "true", "variable": 38}, {"value": "false", "variable": 34}, {"value": "false", "variable": 25}, {"value": "at_least_4_turning_steps", "variable": 24}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 43}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 92}, {"value": "false", "variable": 37}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 62}, {"value": "false", "variable": 94}, {"value": "false", "variable": 79}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "at_least_4_turning_steps", "variable": 39}, {"value": "true", "variable": 104}, {"value": "false", "variable": 42}, {"value": "false", "variable": 103}, {"value": "false", "variable": 98}, {"value": "false", "variable": 70}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 102}, {"value": "false", "variable": 20}, {"value": "false", "variable": 29}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 28}]	internal	3092	cfe4d81b-7366-4ae2-b87b-b986e10cd220	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED	municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1	Vartiosaaren kesätoiminta		Vartiosaari	Vårdö	Vartiosaari	http://vartiosaari.munstadi.fi/	http://vartiosaari.munstadi.fi/	http://vartiosaari.munstadi.fi/	pvm/mpm	lna/msa	local network charge/mobile call charge	+358 9 310 71668			2008-09-09T20:14:31+03:00		www.hel.fi	kaikki	helsinki	2020-11-05T16:31:02.224759+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"}	[1403]	helsinki	[405]	[291]	{}	Point	25.075846	60.18744	PL 80403, 00099 Helsingin kaupunki			11	14	5	P.O. Box 80403, 00099 City of Helsinki	1	14	PB 80403, 00099 Helsingfors stad	16
15703	[{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 23}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 28}, {"value": "false", "variable": 84}, {"value": "false", "variable": 94}, {"value": "false", "variable": 102}, {"value": "false", "variable": 70}, {"value": "false", "variable": 51}, {"value": "true", "variable": 92}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 43}, {"value": "false", "variable": 5}, {"value": "0", "variable": 1}, {"value": "false", "variable": 107}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 21}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 40}, {"value": "true", "variable": 97}, {"value": "true", "variable": 25}, {"value": "false", "variable": 50}, {"value": "false", "variable": 52}, {"value": "false", "variable": 27}, {"value": "true", "variable": 59}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 38}, {"value": "false", "variable": 29}, {"value": "false", "variable": 22}, {"value": "true", "variable": 57}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 34}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 104}, {"value": "false", "variable": 98}, {"value": "false", "variable": 103}, {"value": "true", "variable": 37}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 62}, {"value": "false", "variable": 83}, {"value": "false", "variable": 42}, {"value": "false", "variable": 96}, {"value": "narrow", "variable": 18}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 49}, {"value": "false", "variable": 33}, {"value": "true", "variable": 20}, {"value": "false", "variable": 44}, {"value": "false", "variable": 105}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 79}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "false", "variable": 48}, {"value": "false", "variable": 58}, {"value": "at_least_4_steps", "variable": 39}, {"value": "2", "variable": 64}, {"value": "handrails_on_one_side", "variable": 26}]	internal	4591	d8dab34f-a68f-4244-b906-84e7f651b8e1	520a4492-cb78-498b-9c82-86504de88dce	SELF_PRODUCED	municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1	Auroran päiväkoti		Lippajärventie 44	Klappträskvägen 44	Lippajärventie 44	http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Auroran_paivakoti	http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Auroran_paivakoti	http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Auroran_paivakoti	pvm/mpm	lna/msa	local network charge/mobile call charge	+358 43 826 8868	+358 9 8164 3362	riitta.martiskainen@espoo.fi	2015-11-03T12:03:45+02:00	02940	www.espoo.fi	kaikki	espoo	2020-11-05T13:01:01.390867+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]	espoo	[879, 1090, 2125, 871, 870]	[861, 861, 663, 160, 160]	{"fi": ["tarha", "eskari", "lastentarha"]}	Point	24.715626	60.23249	PL 3592, 02070 ESPOON KAUPUNKI		päiväkotiesiopetus	7	13	5	P.O. Box 3592, 02070 ESPOON KAUPUNKI	1	13	PB 3592, 02070 ESPOON KAUPUNKI	12
30864	[{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 537 6852", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 40 637 4414", "contact_person": null}, {"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"}, "www": null, "email": null, "phone": null, "contact_person": null}]	[{"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 104}, {"value": "false", "variable": 84}, {"value": "1_step", "variable": 93}, {"value": "true", "variable": 35}, {"value": "false", "variable": 103}, {"value": "true", "variable": 23}, {"value": "true", "variable": 70}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 50}, {"value": "true", "variable": 115}, {"value": "true", "variable": 107}, {"value": "true", "variable": 38}, {"value": "opens_automatically", "variable": 77}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 62}, {"value": "false", "variable": 78}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 114}, {"value": "true", "variable": 74}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 112}, {"value": "0", "variable": 1}, {"value": "false", "variable": 49}, {"value": "false", "variable": 25}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 43}, {"value": "false", "variable": 109}, {"value": "false", "variable": 42}, {"value": "false", "variable": 116}, {"value": "true", "variable": 20}, {"value": "false", "variable": 76}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 40}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 37}, {"value": "false", "variable": 22}, {"value": "over_20mm", "variable": 56}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 44}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 58}, {"value": "true", "variable": 113}, {"value": "false", "variable": 5}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 117}, {"value": "false", "variable": 98}, {"value": "true", "variable": 51}, {"value": "false", "variable": 79}, {"value": "false", "variable": 83}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 105}, {"value": "false", "variable": 33}, {"value": "false", "variable": 27}, {"value": "false", "variable": 52}, {"value": "false", "variable": 72}, {"value": "false", "variable": 102}, {"value": "5", "variable": 64}, {"value": "false", "variable": 28}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "false", "variable": 34}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 57}, {"value": "true", "variable": 92}, {"value": "false", "variable": 29}, {"value": "true", "variable": 75}, {"value": "true", "variable": 59}, {"value": "false", "variable": 73}]	internal	17836	154af650-9860-4994-b746-e10abb660203	83e74666-0836-4c1d-948a-4b34a8b90301	SELF_PRODUCED	municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1	Sibelius-lukio	Sibelius Upper Secondary School	Liisankatu 13	Elisabetsgatan 13	Liisankatu 13	http://www.sibel.edu.hel.fi	http://www.sibel.edu.hel.fi	http://www.sibel.edu.hel.fi	pvm/mpm	lna/msa	local network charge/mobile call charge	+358 9 310 86761	+358 50 401 3813		2015-11-27T12:11:49+02:00	00170	www.hel.fi	kaikki	helsinki	2020-11-11T16:01:16.987816+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]	helsinki	[1274, 1280, 1273, 1281, 1292, 1284, 1293, 1294, 1270, 1296, 1259, 1269]	[816, 658, 493, 493, 157, 99, 97, 96, 95, 12, 11, 10, 4]	{"fi": ["Kampus-3", "koulu", "lukio", "lukiot"]}	Point	24.956425	60.174496	PL 17304, 00099 Helsingin kaupunki	Gymnasiet Sibelius-lukio		6	15	5	P.O. Box 17304, 00099 City of Helsinki	1	15	PB 17304, 00099 Helsingfors stad	12