servicemap

Custom SQL query returning 1 row (show)

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
46262 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 10:30-14:30", "sv": "\u00f6ppet m\u00e5n-fre 10:30-14:30", "en": "open Mon-Fri 10:30-14:30"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Kipsari"}, "www": {"fi": "http://kipsari.com/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook"}, "www": {"fi": "https://www.facebook.com/kipsari/"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 49}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 20}, {"value": "true", "variable": 58}, {"value": "false", "variable": 21}, {"value": "false", "variable": 92}, {"value": "true", "variable": 104}, {"value": "false", "variable": 34}, {"value": "false", "variable": 102}, {"value": "true", "variable": 59}, {"value": "waiting_by_standing", "variable": 81}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 103}, {"value": "0", "variable": 1}, {"value": "true", "variable": 80}, {"value": "false", "variable": 23}, {"value": "false", "variable": 107}, {"value": "true", "variable": 6}, {"value": "true", "variable": 51}, {"value": "false", "variable": 84}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "false", "variable": 48}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 105}, {"value": "true", "variable": 37}, {"value": "true", "variable": 106}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 33}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 50}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "false", "variable": 29}, {"value": "false", "variable": 38}, {"value": "true", "variable": 57}, {"value": "false", "variable": 98}, {"value": "false", "variable": 53}, {"value": "false", "variable": 22}, {"value": "false", "variable": 82}, {"value": "true", "variable": 62}, {"value": "false", "variable": 44}, {"value": "true", "variable": 52}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 5}, {"value": "false", "variable": 83}] internal 17241     b5c38de6-66f7-4d1e-befb-eeca69e4f99c b5c38de6-66f7-4d1e-befb-eeca69e4f99c SELF_PRODUCED   private_service yksityinen palvelu privat tjänst private service 1         https://d42y9z8h631ib.cloudfront.net/kuvat/jpg/580x377/243869.jpg https://goo.gl/maps/XRE0N       Studio Kipsari Studio Kipsari Otakaari 7 Otsvängen 7 Otakaari 7 http://kipsari.com/ http://kipsari.com/ http://kipsari.com/   pvm/mpm lna/msa local network charge/mobile call charge   +358 44 757 4031   +358 44 757 4031 kipsarioy@gmail.com http://kipsari.com/ 2015-09-14T14:36:15+03:00 02150   kaikki espoo 2020-11-05T16:32:21.195324+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 [1376] [338] {"fi": ["Aalto-yliopisto", "Aalto Studios", "Kasvisruoka"], "sv": ["Aalto-universitetet"], "en": ["Aalto University", "Vegetarian"]} Point 24.833496 60.189034 Otakaari 7 B, 02150 Espoo         Studio Kipsari   2 2         1     2         2