servicemap

Custom SQL query returning 1 row (hide)

Query parameters

idconnectionsaccessibility_propertiesidentifiers_0_namespaceidentifiers_0_valueidentifiers_1_namespaceidentifiers_1_valuedepartmentroot_departmentprovider_typeorganizer_typecontract_type_idcontract_type_description_ficontract_type_description_svcontract_type_description_enis_activedeleted_atorganizer_nameorganizer_business_idpicture_urlpicture_entrance_urlstreetview_entrance_urldescription_fidescription_enshort_descriptionname_finame_enstreet_address_fistreet_address_svstreet_address_enwww_fiwww_svwww_enaddress_postal_fullcall_charge_info_ficall_charge_info_svcall_charge_info_enpicture_captionphonefaxaccessibility_phoneaccessibility_emailaccessibility_wwwcreated_timeaddress_zipdata_sourceextensions_maintenance_groupextensions_maintenance_organizationlast_modified_timeaccessibility_viewpointsroot_service_nodesmunicipalityservice_nodesserviceskeywordslocation_typelocation_coordinates_0location_coordinates_1address_postal_full_fiidentifiers_2_valuepicture_caption_ficall_charge_infowwwname_svshort_description_fiaccessibility_shortcoming_count_reduced_mobilityaccessibility_shortcoming_count_wheelchairlocationpicture_caption_svaccessibility_shortcoming_count_strolleraddress_postal_full_enaccessibility_shortcoming_count_hearing_aidstreet_addresscontract_typeaccessibility_shortcoming_count_rollatoridentifiers_2_namespaceaddress_postal_full_svshort_description_svdescription_svaccessibility_shortcoming_count_visually_impairedshort_description_endescriptionpicture_caption_en
46043 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 07:45-20, pe 07:45-18, suljettu la-su", "sv": "\u00f6ppet m\u00e5n-tor 07:45-20, fre 07:45-18, st\u00e4ngt l\u00f6r-s\u00f6n", "en": "open Mon-Thu 07:45-20, Fri 07:45-18, closed Sat-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 6}, {"value": "floor_2", "variable": 119}, {"value": "false", "variable": 34}, {"value": "true", "variable": 75}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 92}, {"value": "true", "variable": 35}, {"value": "true", "variable": 104}, {"value": "2", "variable": 1}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 106}, {"value": "true", "variable": 73}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 103}, {"value": "true", "variable": 70}, {"value": "true", "variable": 72}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 89}, {"value": "true", "variable": 88}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 117}, {"value": "floor_1", "variable": 108}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 113}, {"value": "at_least_4_steps", "variable": 93}, {"value": "true", "variable": 52}, {"value": "false", "variable": 44}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 109}, {"value": "true", "variable": 96}, {"value": "true", "variable": 97}, {"value": "false", "variable": 5}, {"value": "over_10m", "variable": 4}, {"value": "no_handrails", "variable": 26}, {"value": "under_20mm", "variable": 56}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 58}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 90}, {"value": "false", "variable": 98}, {"value": "true", "variable": 118}, {"value": "false", "variable": 79}, {"value": "false", "variable": 102}, {"value": "true", "variable": 87}, {"value": "true", "variable": 53}, {"value": "true", "variable": 78}, {"value": "true", "variable": 29}, {"value": "false", "variable": 22}, {"value": "false", "variable": 31}, {"value": "true", "variable": 25}, {"value": "true", "variable": 84}, {"value": "false", "variable": 38}, {"value": "floor_3", "variable": 120}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 48}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 86}, {"value": "true", "variable": 74}, {"value": "true", "variable": 105}, {"value": "false", "variable": 62}, {"value": "false", "variable": 111}, {"value": "false", "variable": 49}, {"value": "true", "variable": 59}, {"value": "true", "variable": 112}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 57}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 85}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "true", "variable": 50}, {"value": "true", "variable": 107}, {"value": "4", "variable": 64}, {"value": "true", "variable": 21}, {"value": "true", "variable": 94}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "true", "variable": 23}, {"value": "false", "variable": 28}, {"value": "true", "variable": 37}, {"value": "true", "variable": 116}, {"value": "false", "variable": 33}, {"value": "true", "variable": 76}, {"value": "true", "variable": 115}, {"value": "true", "variable": 83}, {"value": "true", "variable": 114}] internal 15824     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/2018-04/otakaari1-002.jpg https://www.flickr.com/photos/rumaquva/20939543162/in/album-72157657844591312/ https://goo.gl/maps/emmu6 Rakennuksen eteläpuolella sijaitsee kampuksen rakennustaiteellinen huippukohta, ympäristöään ylemmäksi terassoitu juhla-aukio. Kulttuurihistoriallisesti merkittävä ja suojeltu Kandidaattikeskus kätkee sisäänsä 11 keskisuurta salia. Vuonna 2015 valmistuneessa peruskorjauksessa huomioitiin onnistuneesti tilan käyttäjien monimuotoisuus - Kandidaattikeskukselle myönnettiin vuoden 2015 Esteetön Suomi -palkinto. The south side of the building houses the architectural masterpiece of the campus, a terrassed festival square. The culturally and historically significant, protected Undergraduate Centre houses 11 medium-sized halls. The building was renovated in 2015 with user diversity in mind, and it received the 2015 Esteetön Suomi (Accessible Finland) award.   Aalto-yliopisto kandidaattikeskus Aalto University Undergraduate Centre Otakaari 1 Otsvängen 1 Otakaari 1 https://www.aalto.fi/fi/sijainnit/kandidaattikeskus https://www.aalto.fi/sv/locations/kandidatcentret https://www.aalto.fi/locations/undergraduate-centre   pvm/mpm lna/msa local network charge/mobile call charge   +358 29 442 9280         2015-08-25T09:52:35+03:00 02150   kaikki espoo 2020-11-05T16:32:20.441750+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "green", "32": "green", "33": "red", "41": "green", "51": "red", "52": "red", "61": "green"} [986, 1087, 1403] espoo [1377, 1041, 504, 1359] [822, 587, 525, 485] {"en": ["BA studies", "Bachelor building", "ARTS", "BIZ", "SCI"], "fi": ["kandiopetus", "kanditalo", "ARTS", "BIZ", "SCI"], "sv": ["ARTS", "BIZ", "SCI"]} Point 24.827047 60.1859     Kandidaattikeskus, Otakaari 1     Aalto-universitetet kandidatcentret Alvar Aallon suunnittelema Kandidaattikeskus tunnettiin ennen Teknillisen korkeakoulun päärakennuksena. 2 2   Otnäsvägnen 1           1     Kandidatcentret designat av Alvar Aalto fungerade tidigare som Tekniska högskolans huvudbyggnad. På södra sidan om byggnaden finns campus arkitektoniska höjdpunkt, en upphöjd festivalplats. Det kulturhistoriska och skyddade Kandidatcentret har 11 medelstora salar. Byggnaden renoverades 2015 med utgångspunkt i användarnas mångfald och fick samma år Esteetön Suomi-pris. 4 The Undergraduate Centre designed by Alvar Aalto was previously known as the University of Technology main building.   Undergraduate Centre, Otakaari 1