Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.zone AS zone_2,
  t0.completion_percent AS completion_percent_3,
  t0.places_count AS places_count_4,
  t0.avec_horaires AS avec_horaires_5,
  t0.avec_adresse AS avec_adresse_6,
  t0.avec_site AS avec_site_7,
  t0.avec_accessibilite AS avec_accessibilite_8,
  t0.avec_note AS avec_note_9,
  t0.name AS name_10,
  t0.population AS population_11,
  t0.siren AS siren_12,
  t0.code_epci AS code_epci_13,
  t0.codes_postaux AS codes_postaux_14,
  t0.date_created AS date_created_15,
  t0.date_modified AS date_modified_16,
  t0.avec_siret AS avec_siret_17,
  t0.avec_name AS avec_name_18,
  t0.avec_email AS avec_email_19,
  t0.osm_data_date_min AS osm_data_date_min_20,
  t0.osm_data_date_avg AS osm_data_date_avg_21,
  t0.osm_data_date_max AS osm_data_date_max_22,
  t0.budget_annuel AS budget_annuel_23,
  t0.lat AS lat_24,
  t0.lon AS lon_25,
  t0.date_labourage_requested AS date_labourage_requested_26,
  t0.date_labourage_done AS date_labourage_done_27,
  t0.kind AS kind_28
FROM
  stats t0
WHERE
  t0.zone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = '13002' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.measure AS measure_2,
  c0_.date AS date_3,
  c0_.stats_id AS stats_id_4
FROM
  city_follow_up c0_
  INNER JOIN stats s1_ ON c0_.stats_id = s1_.id
WHERE
  s1_.id = ?
  AND c0_.name IN (?, ?)
ORDER BY
  c0_.date ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id = 27502 AND c0_.name IN ('healthcare_count', 'healthcare_completion') ORDER BY c0_.date ASC, c0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.uuid_for_url AS uuid_for_url_2,
  t0.osm_kind AS osm_kind_3,
  t0.email AS email_4,
  t0.opted_out AS opted_out_5,
  t0.dead AS dead_6,
  t0.note AS note_7,
  t0.modified_date AS modified_date_8,
  t0.zip_code AS zip_code_9,
  t0.asked_humains_support AS asked_humains_support_10,
  t0.last_contact_attempt_date AS last_contact_attempt_date_11,
  t0.osm_id AS osm_id_12,
  t0.name AS name_13,
  t0.has_opening_hours AS has_opening_hours_14,
  t0.has_address AS has_address_15,
  t0.has_website AS has_website_16,
  t0.has_wheelchair AS has_wheelchair_17,
  t0.has_note AS has_note_18,
  t0.main_tag AS main_tag_19,
  t0.note_content AS note_content_20,
  t0.displayed_date AS displayed_date_21,
  t0.lat AS lat_22,
  t0.lon AS lon_23,
  t0.street AS street_24,
  t0.housenumber AS housenumber_25,
  t0.siret AS siret_26,
  t0.habitants AS habitants_27,
  t0.osm_data_date AS osm_data_date_28,
  t0.osm_version AS osm_version_29,
  t0.osm_user AS osm_user_30,
  t0.osm_uid AS osm_uid_31,
  t0.osm_changeset AS osm_changeset_32,
  t0.email_content AS email_content_33,
  t0.place_count AS place_count_34,
  t0.stats_id AS stats_id_35
FROM
  place t0
WHERE
  t0.zip_code = ?

SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.zip_code = '13002';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO action_log (
  type, data, created_at, from_url, who
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('[DEBUG][followupThemeGraph]', '{\"theme\":\"healthcare\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-14 05:16:31', NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.uuid_for_url AS uuid_for_url_2,
  t0.osm_kind AS osm_kind_3,
  t0.email AS email_4,
  t0.opted_out AS opted_out_5,
  t0.dead AS dead_6,
  t0.note AS note_7,
  t0.modified_date AS modified_date_8,
  t0.zip_code AS zip_code_9,
  t0.asked_humains_support AS asked_humains_support_10,
  t0.last_contact_attempt_date AS last_contact_attempt_date_11,
  t0.osm_id AS osm_id_12,
  t0.name AS name_13,
  t0.has_opening_hours AS has_opening_hours_14,
  t0.has_address AS has_address_15,
  t0.has_website AS has_website_16,
  t0.has_wheelchair AS has_wheelchair_17,
  t0.has_note AS has_note_18,
  t0.main_tag AS main_tag_19,
  t0.note_content AS note_content_20,
  t0.displayed_date AS displayed_date_21,
  t0.lat AS lat_22,
  t0.lon AS lon_23,
  t0.street AS street_24,
  t0.housenumber AS housenumber_25,
  t0.siret AS siret_26,
  t0.habitants AS habitants_27,
  t0.osm_data_date AS osm_data_date_28,
  t0.osm_version AS osm_version_29,
  t0.osm_user AS osm_user_30,
  t0.osm_uid AS osm_uid_31,
  t0.osm_changeset AS osm_changeset_32,
  t0.email_content AS email_content_33,
  t0.place_count AS place_count_34,
  t0.stats_id AS stats_id_35
FROM
  place t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = 27502;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.measure AS measure_3,
  t0.date AS date_4,
  t0.stats_id AS stats_id_5
FROM
  city_follow_up t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = 27502;

SELECT
  z0_.id AS id_0,
  z0_.disappeared_list AS disappeared_list_1,
  z0_.current_list AS current_list_2,
  z0_.theme AS theme_3,
  z0_.stats_id AS stats_id_4
FROM
  zone_places z0_
WHERE
  z0_.stats_id = ?
  AND z0_.theme = ?
ORDER BY
  z0_.id ASC
LIMIT
  1

SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = 27502 AND z0_.theme = 'healthcare' ORDER BY z0_.id ASC LIMIT 1;

SELECT
  1

SELECT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = 'public'
  AND table_name = 'osm_object_meta'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history';

SELECT
  COUNT(*)
FROM
  osm_object_meta
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
  AND (tags -> 'ref:INSEE') IS NOT NULL

SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL;

INSERT INTO osm_object_meta (
  osm_type, osm_id, geom, tags, version,
  osm_timestamp, changeset, osm_user,
  uid
)
SELECT
  'relation',
  latest.osm_id,
  latest.geom,
  latest.tags,
  latest.version,
  to_char(
    latest.valid_from AT TIME ZONE 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ),
  latest.changeset,
  latest.osm_user,
  latest.uid
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.osm_id,
      h.geom,
      h.tags,
      h.version,
      h.valid_from,
      h.changeset,
      h.osm_user,
      h.uid
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'boundary') = 'administrative'
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'ref:INSEE') IS NOT NULL
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) AS latest
WHERE
  NOT EXISTS (
    SELECT
      1
    FROM
      osm_object_meta m
    WHERE
      m.osm_type = 'relation'
      AND m.osm_id = latest.osm_id
  )

INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
);

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) AS wkt
FROM
  osm_object_meta m
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'ref:INSEE') = ?
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
ORDER BY
  ST_Area(geom :: geography) DESC NULLS LAST
LIMIT
  1

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref'13002'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history';

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) AS wkt
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.geom
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'ref:INSEE') = ?
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'boundary') = 'administrative'
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) latest
ORDER BY
  ST_Area(geom :: geography) DESC NULLS LAST
LIMIT
  1

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref'13002'') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

CREATE TABLE IF NOT EXISTS zone_polygon (
  insee_code TEXT PRIMARY KEY,
  geom geometry(MultiPolygon, 4326) NOT NULL,
  source TEXT NOT NULL,
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
)

CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                );

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom);

SELECT
  ST_AsText(
    ST_Multi(geom)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = '13002';

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(geom)
  ) AS lat,
  ST_X(
    ST_Centroid(geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND (
    exist(tags, 'healthcare')
    OR (tags -> 'amenity') IN (
      'doctors', 'pharmacy', 'hospital',
      'clinic', 'social_facility'
    )
  )

SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((5.548449 43.335822,5.545942 43.335344,5.544659 43.334561,5.544068 43.334497,5.543629 43.334318,5.542361 43.333906,5.540623 43.332965,5.540462 43.332557,5.540132 43.332367,5.53999 43.33183,5.539192 43.331439,5.538122 43.331206,5.536733 43.330468,5.536396 43.330326,5.535982 43.329933,5.534929 43.328902,5.53403 43.328346,5.533784 43.328101,5.533632 43.327865,5.533328 43.327658,5.532839 43.327271,5.532454 43.327095,5.532086 43.326825,5.531661 43.326424,5.531211 43.326143,5.529953 43.325303,5.52959 43.324735,5.528742 43.324209,5.528195 43.323707,5.527448 43.322986,5.526974 43.322598,5.525877 43.321772,5.524834 43.321255,5.523853 43.320948,5.522817 43.320778,5.522477 43.320941,5.522013 43.321066,5.52171 43.321087,5.521328 43.320999,5.521103 43.320901,5.520486 43.320872,5.519724 43.320887,5.518936 43.321013,5.518655 43.321137,5.518337 43.321235,5.517943 43.321313,5.517545 43.321209,5.517406 43.321153,5.51735 43.321224,5.516991 43.321225,5.516857 43.321173,5.516266 43.321076,5.515748 43.321122,5.515026 43.321493,5.514685 43.321645,5.51428 43.321856,5.513979 43.321895,5.513719 43.321881,5.513526 43.321818,5.512671 43.321227,5.512534 43.321178,5.512553 43.320796,5.512525 43.320547,5.512395 43.320225,5.510023 43.319232,5.509553 43.319028,5.509154 43.318837,5.509104 43.318834,5.50849 43.318611,5.508565 43.318374,5.508287 43.318369,5.507941 43.318265,5.506975 43.317934,5.506225 43.317893,5.50589 43.317952,5.505704 43.31785,5.505135 43.317786,5.504553 43.31777,5.503216 43.317568,5.502908 43.317567,5.501825 43.317643,5.501548 43.31743,5.501496 43.317359,5.50145 43.317026,5.501254 43.31643,5.501014 43.316268,5.500755 43.316002,5.500577 43.31567,5.500283 43.315356,5.500026 43.315189,5.499664 43.315136,5.498484 43.315184,5.498355 43.315181,5.497839 43.314954,5.497467 43.315437,5.496106 43.315279,5.495684 43.315056,5.49552 43.315003,5.49513 43.315016,5.494881 43.31511,5.494104 43.315508,5.493509 43.315288,5.492739 43.31506,5.492552 43.315181,5.4921 43.315105,5.491612 43.315163,5.490982 43.315115,5.490526 43.315204,5.489819 43.315174,5.489395 43.315214,5.488814 43.31524,5.488116 43.315401,5.487823 43.31543,5.487443 43.315442,5.486865 43.315367,5.486456 43.31521,5.486079 43.315132,5.48586 43.315133,5.485253 43.315074,5.484544 43.315035,5.484372 43.314984,5.483729 43.314862,5.483348 43.314713,5.482713 43.314141,5.482469 43.313897,5.482335 43.31382,5.481692 43.313687,5.481031 43.313667,5.480833 43.313712,5.48014 43.313973,5.479745 43.314138,5.47966 43.314218,5.479624 43.314378,5.479455 43.314451,5.478886 43.314448,5.478476 43.314427,5.478025 43.314461,5.477541 43.314534,5.476771 43.314566,5.476146 43.314545,5.475779 43.31458,5.475119 43.314682,5.475101 43.314776,5.474873 43.315355,5.474675 43.315652,5.474326 43.315907,5.473868 43.316145,5.473217 43.316509,5.472449 43.316827,5.472173 43.31696,5.471882 43.31714,5.471608 43.317466,5.471364 43.3177,5.471395 43.317947,5.471064 43.318651,5.470982 43.318859,5.47085 43.319718,5.470701 43.319749,5.470808 43.319917,5.470452 43.320019,5.470058 43.320172,5.469979 43.320248,5.469751 43.320317,5.469212 43.320563,5.469351 43.320759,5.468668 43.321207,5.468147 43.321637,5.467107 43.322517,5.466998 43.3226,5.466613 43.322999,5.466412 43.323206,5.464002 43.325759,5.46389 43.32592,5.463629 43.32622,5.463522 43.326306,5.463054 43.326796,5.462965 43.326863,5.459532 43.330587,5.458859 43.331111,5.458242 43.331481,5.456786 43.333354,5.455827 43.334301,5.454805 43.335592,5.455034 43.335712,5.455536 43.335971,5.455817 43.336043,5.456242 43.336042,5.456821 43.336023,5.45729 43.336147,5.456952 43.336565,5.457304 43.336794,5.457994 43.337081,5.458844 43.337256,5.458698 43.33746,5.45832 43.33768,5.459113 43.338146,5.459377 43.338144,5.460005 43.33834,5.460428 43.338503,5.460607 43.338592,5.460925 43.338699,5.461098 43.338813,5.461392 43.339142,5.462255 43.339864,5.462435 43.339736,5.462918 43.339344,5.463167 43.339561,5.463816 43.340038,5.464167 43.340345,5.464333 43.340676,5.464482 43.340802,5.464716 43.340787,5.46527 43.340564,5.465425 43.340525,5.465596 43.340633,5.465898 43.34087,5.466006 43.340473,5.466258 43.339998,5.466508 43.339701,5.466583 43.339705,5.466915 43.33997,5.46718 43.340083,5.467551 43.340106,5.467838 43.340203,5.468028 43.340386,5.468066 43.340664,5.46778 43.341265,5.467741 43.341428,5.467801 43.341533,5.468008 43.341642,5.468285 43.341714,5.468621 43.341676,5.468931 43.341689,5.469167 43.34175,5.469704 43.342032,5.470013 43.342363,5.470177 43.342607,5.470095 43.343173,5.470402 43.343238,5.470025 43.343666,5.469992 43.343959,5.470043 43.34426,5.470158 43.344513,5.470484 43.344889,5.470854 43.345263,5.471072 43.345422,5.471772 43.345796,5.472078 43.345943,5.472285 43.346014,5.472668 43.346069,5.473002 43.346049,5.474024 43.345852,5.474269 43.345846,5.474397 43.345884,5.474521 43.345986,5.474602 43.346178,5.47459 43.346401,5.474521 43.346514,5.474368 43.34665,5.473502 43.347102,5.47329 43.347268,5.473176 43.347457,5.472843 43.348338,5.472742 43.348637,5.472622 43.349302,5.472722 43.349508,5.473259 43.349927,5.474305 43.350587,5.474645 43.350656,5.474921 43.350593,5.47551 43.350359,5.475865 43.35031,5.47634 43.350285,5.476586 43.35033,5.476704 43.350445,5.476727 43.350611,5.476553 43.35123,5.476495 43.351924,5.476456 43.35219,5.476395 43.352327,5.476303 43.352395,5.476123 43.35243,5.475922 43.352425,5.475888 43.352661,5.47553 43.353093,5.475379 43.353395,5.475056 43.353969,5.474735 43.354224,5.474462 43.354517,5.474374 43.354638,5.474236 43.355088,5.474115 43.35599,5.474443 43.356258,5.474468 43.356324,5.474425 43.356552,5.474214 43.357253,5.474158 43.357731,5.474059 43.358089,5.473563 43.35887,5.473221 43.35935,5.473086 43.359706,5.472583 43.36055,5.472503 43.360724,5.472357 43.361492,5.471882 43.361708,5.471972 43.361941,5.472259 43.362458,5.472752 43.363184,5.472898 43.36361,5.472966 43.364175,5.473132 43.364493,5.473223 43.364766,5.473371 43.365118,5.473436 43.365923,5.473345 43.366145,5.473388 43.366308,5.473391 43.366505,5.473491 43.366694,5.473429 43.366949,5.473468 43.367164,5.473423 43.367299,5.473134 43.367687,5.473004 43.36794,5.472937 43.368207,5.472865 43.368239,5.472784 43.368589,5.472657 43.368908,5.472574 43.369263,5.472639 43.3694,5.472821 43.369615,5.473031 43.370008,5.473166 43.37017,5.473189 43.370414,5.473336 43.370702,5.473447 43.370785,5.473471 43.370965,5.473401 43.371184,5.473399 43.371477,5.473342 43.371878,5.473283 43.372043,5.473324 43.372397,5.473617 43.372893,5.473936 43.373234,5.474398 43.373777,5.474485 43.373984,5.474721 43.374093,5.474799 43.374172,5.474941 43.374418,5.475361 43.374793,5.475595 43.374951,5.475676 43.375046,5.475788 43.375561,5.475949 43.375802,5.476472 43.376258,5.476696 43.37637,5.476872 43.376518,5.476898 43.376618,5.476829 43.376814,5.476924 43.376923,5.477071 43.377008,5.477323 43.377259,5.477472 43.377508,5.477528 43.377716,5.477761 43.378103,5.477733 43.378259,5.477555 43.378494,5.477451 43.378746,5.477288 43.378943,5.477248 43.379075,5.477337 43.37939,5.477324 43.379579,5.477363 43.379744,5.477537 43.380037,5.477591 43.380273,5.477559 43.380464,5.477481 43.380646,5.477382 43.380739,5.477006 43.380893,5.476844 43.381071,5.476897 43.381456,5.47694 43.381602,5.477086 43.381686,5.477463 43.381834,5.477703 43.381965,5.478047 43.382207,5.478211 43.382523,5.478178 43.382819,5.478285 43.383101,5.478309 43.383298,5.478386 43.383342,5.478787 43.383265,5.479499 43.383229,5.480177 43.383735,5.480163 43.383999,5.480246 43.3845,5.48026 43.384827,5.479967 43.385159,5.479839 43.385359,5.480995 43.384934,5.481136 43.384914,5.481356 43.3848,5.481737 43.38471,5.482248 43.384539,5.483277 43.384414,5.483589 43.384403,5.484088 43.384424,5.484267 43.384454,5.485528 43.384414,5.486796 43.384447,5.487133 43.384463,5.488747 43.384628,5.48965 43.384743,5.490057 43.38486,5.491145 43.385146,5.491824 43.385186,5.493167 43.385283,5.494155 43.385311,5.49438 43.385333,5.495043 43.385507,5.496099 43.385798,5.496585 43.385942,5.497663 43.386243,5.498026 43.386354,5.498697 43.386505,5.499038 43.38662,5.499691 43.386811,5.500186 43.386938,5.500527 43.386996,5.501087 43.387128,5.501662 43.387297,5.50365 43.387837,5.504427 43.388057,5.504861 43.387783,5.506778 43.386729,5.507978 43.385956,5.508272 43.385599,5.508764 43.384972,5.508996 43.384738,5.509855 43.384286,5.510231 43.384105,5.511095 43.383629,5.511917 43.383156,5.512956 43.382508,5.513738 43.383044,5.514198 43.383392,5.514506 43.383548,5.514778 43.385677,5.514971 43.385969,5.51705 43.386646,5.519014 43.386579,5.521385 43.387046,5.523343 43.387507,5.523825 43.387557,5.525565 43.387625,5.527495 43.387578,5.52855 43.387384,5.530335 43.387433,5.531171 43.387507,5.531578 43.387796,5.532098 43.387884,5.53261 43.388026,5.533355 43.388192,5.53375 43.388299,5.544659 43.390756,5.544938 43.390376,5.545196 43.390187,5.545616 43.390049,5.546192 43.389833,5.546345 43.389747,5.546846 43.389312,5.547148 43.388979,5.547347 43.388823,5.547525 43.388735,5.548005 43.388578,5.548699 43.388329,5.548812 43.388251,5.549 43.388262,5.549407 43.388168,5.54954 43.388065,5.550009 43.387567,5.55016 43.387461,5.550722 43.387171,5.551029 43.386926,5.551705 43.38649,5.552171 43.386333,5.552448 43.386184,5.554173 43.385756,5.552686 43.384827,5.552951 43.384741,5.553631 43.384372,5.554053 43.384211,5.555159 43.383111,5.556617 43.381543,5.556751 43.38149,5.557032 43.38106,5.557123 43.380865,5.557435 43.380617,5.557531 43.380165,5.557595 43.380024,5.557671 43.379514,5.557675 43.379207,5.557619 43.378821,5.557631 43.37873,5.557957 43.378388,5.558037 43.378214,5.558089 43.37792,5.558409 43.376962,5.558599 43.376795,5.558621 43.376727,5.558969 43.376585,5.559022 43.376503,5.559005 43.376295,5.558913 43.376152,5.558878 43.375852,5.558782 43.375404,5.558967 43.375386,5.559082 43.375207,5.559179 43.375127,5.559939 43.373233,5.560066 43.372931,5.559905 43.371581,5.56033 43.370848,5.560332 43.370386,5.560364 43.370279,5.560735 43.369902,5.560958 43.368735,5.561969 43.363915,5.561872 43.363492,5.56227 43.362927,5.562383 43.362689,5.56249 43.36265,5.562635 43.362504,5.562781 43.362267,5.562854 43.362249,5.563065 43.362016,5.563193 43.361738,5.563317 43.361623,5.56345 43.361172,5.563364 43.360926,5.56341 43.360704,5.563635 43.360523,5.563707 43.360398,5.56387 43.360002,5.563769 43.359806,5.563354 43.359598,5.563258 43.3593,5.563222 43.358563,5.563169 43.358446,5.563343 43.358323,5.563806 43.358161,5.564278 43.357974,5.564702 43.357763,5.565696 43.356663,5.565263 43.35622,5.564082 43.355457,5.56364 43.355092,5.562972 43.354638,5.561989 43.354195,5.561582 43.354093,5.560985 43.353916,5.559914 43.353543,5.559688 43.353435,5.5594 43.353335,5.558625 43.352485,5.558421 43.352325,5.558289 43.352131,5.55823 43.351949,5.558048 43.351745,5.55793 43.3515,5.558099 43.346111,5.555624 43.345244,5.552193 43.345986,5.551241 43.345549,5.54999 43.345153,5.5483 43.344464,5.547529 43.344515,5.547346 43.344542,5.547049 43.344675,5.546734 43.344656,5.546454 43.344693,5.546325 43.344682,5.546126 43.344757,5.546002 43.344731,5.547852 43.341029,5.547945 43.340874,5.547981 43.340325,5.548156 43.33868,5.548213 43.338449,5.548185 43.337817,5.548154 43.337491,5.548282 43.336972,5.548325 43.336698,5.548391 43.33646,5.548449 43.335822)))', 4326))
            AND (exist(tags, 'healthcare') OR (tags->'amenity') IN ('doctors','pharmacy','hospital','clinic','social_facility'));