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 services 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
46081	[{"section_type": "LINK", "name": {"fi": "Palvelut ja liikkuminen"}, "www": {"fi": "http://www.aalto.fi/fi/about/campus/around_campus/"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "true", "variable": 109}, {"value": "at_least_3600mm", "variable": 3}, {"value": "under_20mm", "variable": 56}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 51}, {"value": "true", "variable": 74}, {"value": "true", "variable": 25}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 112}, {"value": "true", "variable": 37}, {"value": "true", "variable": 20}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 115}, {"value": "false", "variable": 82}, {"value": "false", "variable": 38}, {"value": "true", "variable": 62}, {"value": "true", "variable": 52}, {"value": "false", "variable": 33}, {"value": "no_handrails", "variable": 26}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 111}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 35}, {"value": "true", "variable": 21}, {"value": "false", "variable": 48}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 6}, {"value": "false", "variable": 103}, {"value": "true", "variable": 50}, {"value": "false", "variable": 92}, {"value": "false", "variable": 105}, {"value": "false", "variable": 28}, {"value": "false", "variable": 84}, {"value": "true", "variable": 73}, {"value": "true", "variable": 59}, {"value": "true", "variable": 104}, {"value": "2", "variable": 1}, {"value": "true", "variable": 70}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "true", "variable": 72}, {"value": "false", "variable": 34}, {"value": "under_20mm", "variable": 91}, {"value": "over_10m", "variable": 4}, {"value": "true", "variable": 5}, {"value": "true", "variable": 116}, {"value": "true", "variable": 107}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 76}, {"value": "true", "variable": 118}, {"value": "true", "variable": 117}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 23}, {"value": "false", "variable": 44}, {"value": "false", "variable": 29}, {"value": "false", "variable": 83}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "true", "variable": 75}, {"value": "true", "variable": 57}, {"value": "false", "variable": 80}, {"value": "true", "variable": 53}, {"value": "false", "variable": 102}, {"value": "true", "variable": 78}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 114}, {"value": "true", "variable": 22}, {"value": "false", "variable": 49}, {"value": "false", "variable": 98}, {"value": "false", "variable": 79}, {"value": "true", "variable": 113}]	internal	16748			b5c38de6-66f7-4d1e-befb-eeca69e4f99c	b5c38de6-66f7-4d1e-befb-eeca69e4f99c	SELF_PRODUCED		private_service	yksityinen palvelu	privat tjänst	private service	1				https://www.aalto.fi/sites/g/files/flghsv161/files/styles/1_6_1280w_800h_n/public/2018-06/aalto_university_y_block_102013_by_tuomas_uusheimo_039_pienennetty.jpg?h=9e580b19&itok=-TzWj5bF	https://www.flickr.com/photos/rumaquva/20939536002/in/album-72157657844591312/	https://goo.gl/maps/z4jbr	Aallon aulapalveluhenkilöstö palvelee ja opastaa kiinteistöissä työskenteleviä ja siellä liikkuvia vierailijoita sekä huolehtii tilojen yleisestä järjestyksestä ja turvallisuudesta. Aulapalveluhenkilöstön tunnistaa punaisista Aalto-yliopiston logolla varustetuista punaisista työpaidoista tai huppareista tai Securitaksen logolla varustetuista asuista. Heidät tavoittaa rakennuksen joko pääsisäänkäynnin läheisyydessä sijaitsevasta aulapalvelupisteestä tai tilapäisesti puhelimitse aulapalvelupisteessä ilmoitetusta numerosta.	Aalto University Lobby Services provides guidance and other services to employees and visitors of Aalto facilities, while helping to maintain the general safety and security of campus facilities. You can recognise Lobby Service staff by the red workshirts and hoodies they wear with the Aalto University logo or the uniforms they wear with the Securitas logo. They can be reached at the reception desk by building main entrances, or if temporarily away, by calling the number indicated at the reception desk.		Aalto-yliopiston kandidaattikeskuksen vahtimestarit, Otakaari 1Ä	Aalto University Undergraduate Centre, lobby services, Otakaari 1Ä	Otakaari 1	Otsvängen 1	Otakaari 1	https://www.aalto.fi/fi/palvelut/aulapalvelut	https://www.aalto.fi/sv/tjansteenheter/entretjanster	https://www.aalto.fi/en/service-entities/lobby-services		pvm/mpm	lna/msa	local network charge/mobile call charge		+358 50 384 1588		aula-ok1@aalto.fi		sci-vahtimestarit@list.aalto.fi	http://sci.aalto.fi/en/contact/facilities_janitors/	2015-08-27T13:35:25+03:00	02150		kaikki	espoo	2020-05-22T14:32:05.442815+03: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]	espoo	[1359]	[822]	{}	Point	24.827225	60.185688	PL 11000, 00076 Aalto		Otakaari 1, H-siipi			Entrétjänster i kandidatcentret	Aallon aulapalveluhenkilöstö palvelee ja opastaa kiinteistöissä työskenteleviä ja siellä liikkuvia vierailijoita.	2	2		Otnäsvägnen 1	1	P.O. Box 11000, 00076 Aalto	1			2		PB 11000, 00076 Aalto	Aalto-universitetets entrépersonal betjänar och råder både personal och gäster.	Aalto-universitetets entrépersonal betjänar och råder både personal och gäster och försäkrar utrymmenas allmänna ordning och säkerhet. Entrépersonalen bär röda arbetsskjortor eller munkjackor med Aalto-universitetets logga eller kostymer med Securitas-logga. De är anträffbara vid huvudentréns servicepunkt eller tillfälligt per telefon vid numret som anvisats vid servicepunkten.	4	Aalto University Lobby Services provides guidance and other services to employees and visitors.		Otakaari 1, H wing