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 "accessibility_shortcoming_count_stroller" = :p0 and "service_nodes" = :p1 order by id 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
15372	[{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}]	[{"value": "true", "variable": 92}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 44}, {"value": "false", "variable": 97}, {"value": "true", "variable": 42}, {"value": "true", "variable": 27}, {"value": "false", "variable": 28}, {"value": "false", "variable": 84}, {"value": "true", "variable": 104}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 43}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "true", "variable": 23}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 6}, {"value": "3", "variable": 64}, {"value": "false", "variable": 49}, {"value": "true", "variable": 96}, {"value": "false", "variable": 20}, {"value": "false", "variable": 29}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "false", "variable": 21}, {"value": "true", "variable": 94}, {"value": "false", "variable": 107}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 57}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 102}, {"value": "true", "variable": 59}, {"value": "true", "variable": 105}, {"value": "false", "variable": 50}, {"value": "false", "variable": 58}, {"value": "true", "variable": 5}, {"value": "at_least_4_steps", "variable": 24}, {"value": "0", "variable": 1}, {"value": "over_20mm", "variable": 56}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "false", "variable": 103}, {"value": "false", "variable": 106}, {"value": "true", "variable": 38}, {"value": "false", "variable": 70}, {"value": "false", "variable": 62}, {"value": "true", "variable": 40}, {"value": "false", "variable": 79}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 52}, {"value": "true", "variable": 37}, {"value": "indoor_facility", "variable": 500}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 22}, {"value": "true", "variable": 51}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 25}, {"value": "false", "variable": 33}, {"value": "at_least_4_steps", "variable": 39}]	internal	4423			d8dab34f-a68f-4244-b906-84e7f651b8e1	520a4492-cb78-498b-9c82-86504de88dce	SELF_PRODUCED		municipal_service	kunnallinen palvelu	kommunal tjänst	municipal service	1							Pakankylän koulu on iloinen ja turvallinen koulu, jossa lapsi saa perustiedot ja taidot elämäänsä varten omista tarpeistaan lähtien. Erityisen tärkeinä taitoina pidämme toisen kunnioittamista ja kannustamista sekä erilaisuuden hyväksymistä.Yhdessä tekemällä luomme yhteenkuuluvuuden ja yhteisöllisyyden tunteen kaikkien kouluyhteisöön kuuluvien välille. Ympäristöystävällisyys on koulumme arkea.Koulussamme on noin 107 oppilasta eskareista kuudesluokkalaisiin.			Pakankylän koulu		Snettansintie 9	Snettansvägen 9	Snettansintie 9	http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Alakoulut/Pakankylan_koulu	http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Alakoulut/Pakankylan_koulu	http://www.espoo.fi/en-US/Childcare_and_education/Comprehensive_education		pvm/mpm	lna/msa	local network charge/mobile call charge		+358 43 825 3753			+358 9 8164 0417	matti.jokela@espoo.fi		2015-11-03T12:03:45+02:00	02740	www.espoo.fi	kaikki	espoo	2020-03-13T09:31:04.966733+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": "red"}	[1087]	espoo	[1123, 1134, 1146, 1100]	[661, 108, 34, 15]	{"fi": ["ala-aste", "koulu"]}	Point	24.677307	60.283375	PL 74302, 02070 ESPOON KAUPUNKI						Pakankylän koulu on iloinen ja turvallinen koulu, jossa lapsi saa perustiedot ja taidot elämäänsä varten omista tarpeistaan lähtien.	5	12			4	P.O. Box 74302, 02070 ESPOO CITY	1			12		PB 74302, 02070 ESBO STAD			7