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 "picture_entrance_url" = :p0 order by root_service_nodes 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
54394	[]	[{"value": "false", "variable": 84}, {"value": "false", "variable": 62}, {"value": "false", "variable": 103}, {"value": "false", "variable": 23}, {"value": "true", "variable": 106}, {"value": "false", "variable": 22}, {"value": "true", "variable": 70}, {"value": "true", "variable": 37}, {"value": "true", "variable": 75}, {"value": "false", "variable": 48}, {"value": "true", "variable": 57}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 73}, {"value": "true", "variable": 59}, {"value": "false", "variable": 21}, {"value": "true", "variable": 20}, {"value": "true", "variable": 51}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "opens_automatically", "variable": 77}, {"value": "under_20mm", "variable": 91}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 76}, {"value": "true", "variable": 72}, {"value": "false", "variable": 107}, {"value": "false", "variable": 102}, {"value": "true", "variable": 58}, {"value": "true", "variable": 5}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 83}, {"value": "under_20mm", "variable": 56}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 44}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 6}, {"value": "4", "variable": 64}, {"value": "false", "variable": 33}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "true", "variable": 53}, {"value": "true", "variable": 74}, {"value": "false", "variable": 92}, {"value": "false", "variable": 38}, {"value": "true", "variable": 105}, {"value": "sufficiently_wide", "variable": 18}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "false", "variable": 98}, {"value": "false", "variable": 34}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 50}, {"value": "true", "variable": 78}, {"value": "true", "variable": 104}, {"value": "false", "variable": 49}, {"value": "1", "variable": 1}, {"value": "true", "variable": 52}, {"value": "false", "variable": 29}]	internal	24050			b5c38de6-66f7-4d1e-befb-eeca69e4f99c	b5c38de6-66f7-4d1e-befb-eeca69e4f99c	OTHER_PRODUCTION_METHOD	FOUNDATION					1				http://health.aalto.fi/en/midcom-serveattachmentguid-1e6ac0c2155be16ac0c11e69fbe6d36072d6d276d27/health_technology_house_otakaari_3.jpg	http://health.aalto.fi/en/midcom-serveattachmentguid-1e6ac0c2155be16ac0c11e69fbe6d36072d6d276d27/health_technology_house_otakaari_3.jpg	https://goo.gl/maps/jcxcL3f3wdt	Health Technology House (HTH) Otakaari 3:ssa on kotipaikka muun muassa seuraaville:- Neurotieteen ja lääketieteellisen tekniikan laitos (Perustieteiden korkeakoulu)- Eräät Sähkötekniikan korkeakoulun tutkimusryhmät- Biodesign Finland (Otaniemen toimisto)- Aalto Brain Centre- Aalto NeuroImaging (toimisto)- Aalto Health Platform (toimisto)- Health Capital Helsinki (Otaniemen toimisto)- Aalto Health Factory- Opiskelijaravintola Kvarkki- Lääketieteellisen tekniikan ja neurotieteen ja - teknologian alojen opetusSuunnitelmien mukaan HTH:n tiloissa toimii tulevaisuudessa yksi tai useampia terveysteknologian alan yrityksiä.	The Health Technology House (HTH), located on Aalto University's main campus in Otaniemi, unites research groups whose work revolves around electrical devices, neuroscience, or related signal processing. The House contains most of the faculty of the Biomedical Engineering and Neuroscience and -technology subareas of Aalto's Health & Wellbeing research community. Examples of research focus areas are medical imaging equipment, neurological therapy devices, rehabilitation technologies, and neurosciences. Faculty and staff in the House produce research with high scientific quality, and there is high productivity in innovation as well. More broadly, Aalto Health Platform, uniting the university's Health & Wellbeing professors and research groups for increased collaboration, is managed from the House.Health Technology House is the current home for the following units and activities:- Department of Neuroscience and Biomedical Engineering (School of Science)- Research groups of School of Electrical Engineering- Biodesign Finland (office in Otaniemi) - Aalto Brain Centre- Aalto NeuroImaging (office)- Aalto Health Platform (office)- Health Capital Helsinki (office in Otaniemi)- Aalto Health Factory- Student restaurant Kvarkki (run by Sodexo)- Learning and teaching activities in biomedical engineering and neuroscience and -technologyIn the future, it is planned that HTH will become the new home for one or several companies in the field of health technology.		Aalto-yliopiston terveysteknologian talo	Aalto University Health Technology House	Otakaari 3	Otsvängen 3	Otakaari 3	http://health.aalto.fi/en/healthtechnologyhouse/	http://health.aalto.fi/en/healthtechnologyhouse/	http://health.aalto.fi/en/healthtechnologyhouse/									+358 9 470 01	health@aalto.fi	http://health.aalto.fi/en/healthtechnologyhouse/driving_instructions/	2017-08-30T11:47:51+03:00	02150		kaikki	espoo	2020-03-13T09:32:29.960438+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"}	[1087]	espoo	[1359]	[822]	{}	Point	24.829647	60.188343			Terveysteknologian talo				Talossa toimii useita terveysteknologian yrityksiä opetus- ja tutkimustilojen lisäksi,	1	1					1			1					1	HTH will become the home for several companies in the field of health technology.		Health Technology House