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
46229 [{"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "ADF", "en": "ADF"}, "www": {"fi": "https://www.facebook.com/aaltodesignfactory", "en": "https://www.facebook.com/aaltodesignfactory"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 104}, {"value": "false", "variable": 117}, {"value": "false", "variable": 21}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 103}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 70}, {"value": "false", "variable": 46}, {"value": "long_term_stay", "variable": 60}, {"value": "no_handrails", "variable": 47}, {"value": "false", "variable": 38}, {"value": "true", "variable": 51}, {"value": "false", "variable": 98}, {"value": "true", "variable": 83}, {"value": "false", "variable": 20}, {"value": "true", "variable": 109}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "false", "variable": 52}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 115}, {"value": "3", "variable": 64}, {"value": "false", "variable": 79}, {"value": "false", "variable": 29}, {"value": "true", "variable": 112}, {"value": "false", "variable": 48}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "false", "variable": 111}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 34}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 57}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 106}, {"value": "false", "variable": 62}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 49}, {"value": "false", "variable": 23}, {"value": "true", "variable": 113}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 114}, {"value": "true", "variable": 59}, {"value": "true", "variable": 116}, {"value": "true", "variable": 44}, {"value": "false", "variable": 102}, {"value": "true", "variable": 107}, {"value": "false", "variable": 92}, {"value": "true", "variable": 5}, {"value": "false", "variable": 33}, {"value": "true", "variable": 6}, {"value": "true", "variable": 37}, {"value": "true", "variable": 105}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 84}] internal 16436     b5c38de6-66f7-4d1e-befb-eeca69e4f99c b5c38de6-66f7-4d1e-befb-eeca69e4f99c SELF_PRODUCED   private_service yksityinen palvelu privat tj√§nst private service 1       https://designfactory.aalto.fi/wp-content/uploads/2018/08/web-banner-02.jpg https://blogs.aalto.fi/uudetkoekaytannot/files/2013/08/2013-08-14-12.40.41.jpg https://goo.gl/maps/kld33   Aalto Design Factory was born from a research project focused on creating an ideal physical and mental working environment for product developers and researchers. Today ADF is one of the spearhead projects and one of the first physical manifestations of Aalto University encouraging and enabling fruitful interaction between students, researchers, and professional practitioners.   Aalto-yliopiston Design Factory ADF Aalto University Design Factory ADF Betonimiehenkuja 5 Betongblandargr√§nden 5 Betonimiehenkuja 5 https://designfactory.aalto.fi/ https://designfactory.aalto.fi/ https://designfactory.aalto.fi/               +358 50 323 6586 tiina.tuulos@aalto.fi   2015-09-10T11:51:05+03:00 02150   kaikki espoo 2020-03-13T09:32:16.936863+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": "green"} [1087] espoo [1359] [822] {"en": ["collaboration", "practitioner", "research", "studies"]} Point 24.831871 60.18113 PL 17700, 02150 Espoo   ADF     Aalto-universitetets Design Factory ADF   3 4   ADF 1 P.O. Box 17700, 02150 Espoo       4   PB 17700, 02150 Espoo     3 Aalto Design Factory (ADF) is an interdisciplinary product design and learning hub uniting students, teachers, researchers, and industry.   ADF