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 = '13019' 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 = 26958 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 = '13019';

"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 06:09:22', 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 = 26958;

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 = 26958;

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 = 26958 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'13019'') = ?
  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'13019'') = ?
      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 = '13019';

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.310788 43.431564,5.310069 43.433604,5.309954 43.433795,5.309641 43.434003,5.309438 43.434229,5.309256 43.434511,5.30892 43.434683,5.308229 43.435145,5.307524 43.435643,5.306753 43.436229,5.305879 43.43759,5.30554 43.437957,5.305134 43.438484,5.304942 43.438809,5.304513 43.43942,5.304155 43.439789,5.303896 43.440118,5.303679 43.440357,5.30362 43.440464,5.303369 43.441233,5.303119 43.441712,5.302939 43.442347,5.302737 43.442836,5.302525 43.443063,5.302078 43.443499,5.302032 43.443613,5.302162 43.444086,5.302067 43.444257,5.301941 43.444801,5.301802 43.445157,5.301485 43.445541,5.301008 43.446031,5.301339 43.446338,5.301627 43.446768,5.301817 43.447168,5.301938 43.447361,5.302129 43.447581,5.30234 43.447773,5.302704 43.448035,5.303876 43.448677,5.305408 43.449606,5.306247 43.4501,5.306456 43.450264,5.307968 43.451189,5.309131 43.45171,5.309427 43.45183,5.310273 43.451943,5.310756 43.452146,5.312387 43.452773,5.314087 43.453613,5.314807 43.453914,5.315718 43.454462,5.316047 43.454565,5.316729 43.454683,5.317322 43.455127,5.317686 43.455141,5.318265 43.455225,5.31861 43.455482,5.319866 43.456279,5.320266 43.456563,5.320453 43.456633,5.320618 43.456756,5.321113 43.457027,5.322638 43.457798,5.323127 43.458022,5.324294 43.458584,5.325844 43.459412,5.326991 43.460064,5.327187 43.460134,5.327631 43.46039,5.329317 43.461325,5.329393 43.461792,5.328888 43.462555,5.328441 43.463296,5.327401 43.464979,5.326015 43.467175,5.325848 43.467406,5.324719 43.469111,5.324652 43.469194,5.324013 43.47023,5.323835 43.470093,5.323282 43.470642,5.323075 43.470794,5.322921 43.470997,5.322666 43.471171,5.322682 43.471805,5.322777 43.472141,5.322866 43.472345,5.32291 43.472683,5.322812 43.473002,5.322794 43.473145,5.322637 43.473473,5.322271 43.473768,5.321921 43.473948,5.321755 43.474089,5.321507 43.474348,5.321223 43.474693,5.321104 43.474876,5.320975 43.475158,5.320722 43.47587,5.32058 43.476433,5.32046 43.476636,5.320255 43.476856,5.320056 43.477033,5.319887 43.477236,5.319816 43.477413,5.31978 43.478137,5.319857 43.478887,5.319866 43.479165,5.320709 43.479776,5.321087 43.480024,5.320178 43.483352,5.320027 43.484103,5.32046 43.484346,5.32088 43.484624,5.321029 43.48468,5.321679 43.485075,5.321817 43.484895,5.322052 43.484672,5.322494 43.484432,5.322615 43.4844,5.323037 43.484405,5.323274 43.484433,5.32367 43.484557,5.323879 43.484696,5.324073 43.484912,5.324526 43.485487,5.324704 43.485608,5.324902 43.485419,5.325041 43.485232,5.325386 43.484874,5.325696 43.484584,5.325732 43.484514,5.326105 43.484785,5.326504 43.485048,5.3268 43.485204,5.327061 43.485417,5.32748 43.485638,5.32784 43.485791,5.328325 43.486104,5.330061 43.487181,5.330412 43.487438,5.331497 43.488119,5.333014 43.488072,5.333441 43.488079,5.333778 43.488224,5.334025 43.488389,5.33433 43.48854,5.334441 43.488626,5.334966 43.48892,5.336856 43.488186,5.337767 43.487853,5.338671 43.487554,5.339142 43.487441,5.339461 43.48732,5.340275 43.486088,5.340838 43.485114,5.342454 43.484277,5.343866 43.483474,5.344928 43.482266,5.34557 43.482335,5.347875 43.482524,5.34893 43.482571,5.349147 43.482477,5.351548 43.481211,5.353359 43.480237,5.354108 43.479765,5.35439 43.479677,5.356315 43.480077,5.357752 43.481141,5.358038 43.481061,5.358189 43.481054,5.358954 43.480688,5.35916 43.480621,5.359951 43.480428,5.360111 43.480355,5.36029 43.480124,5.360645 43.479768,5.360628 43.479697,5.361297 43.479447,5.361546 43.479004,5.361665 43.478657,5.361661 43.478546,5.361769 43.47845,5.362133 43.478222,5.362269 43.477961,5.362284 43.477815,5.362564 43.477242,5.362621 43.476729,5.362919 43.47593,5.363836 43.47508,5.364 43.474966,5.364224 43.474714,5.364414 43.474346,5.364816 43.473726,5.364953 43.473469,5.365406 43.473035,5.365718 43.47277,5.366022 43.47273,5.366718 43.472566,5.368299 43.472206,5.369545 43.471911,5.370328 43.471786,5.37128 43.471582,5.373152 43.472253,5.3755 43.470785,5.376812 43.469988,5.377273 43.469687,5.378117 43.468042,5.378323 43.467622,5.37888 43.466611,5.379177 43.466096,5.379404 43.465624,5.379955 43.465461,5.381981 43.464823,5.384035 43.464201,5.384918 43.463925,5.386059 43.463031,5.387334 43.46207,5.387495 43.461934,5.387833 43.459926,5.388013 43.458823,5.388179 43.457761,5.38825 43.457214,5.388172 43.456671,5.387982 43.455666,5.387793 43.454827,5.387777 43.454707,5.387497 43.454782,5.387382 43.454422,5.38734 43.453387,5.387311 43.453127,5.387902 43.452216,5.388563 43.451232,5.38793 43.45001,5.387422 43.449085,5.387272 43.448779,5.387584 43.448789,5.38772 43.448281,5.388021 43.446872,5.388122 43.446605,5.388369 43.446368,5.388612 43.446026,5.388968 43.445944,5.389496 43.445689,5.389908 43.445399,5.390182 43.445005,5.390104 43.444733,5.390347 43.444519,5.39049 43.444254,5.390493 43.444011,5.390538 43.443842,5.390487 43.443571,5.390301 43.443126,5.390265 43.442883,5.390424 43.442765,5.390481 43.44261,5.390478 43.441821,5.390511 43.441706,5.391027 43.441173,5.391353 43.440818,5.391742 43.440445,5.392007 43.440121,5.392149 43.439898,5.392271 43.439454,5.392381 43.439247,5.392407 43.438859,5.39242 43.437977,5.39246 43.437633,5.392368 43.437358,5.392096 43.43632,5.391964 43.435613,5.391636 43.434758,5.391452 43.434457,5.390953 43.433893,5.391435 43.433719,5.390741 43.433333,5.390629 43.432994,5.390885 43.432764,5.390465 43.432489,5.389884 43.432252,5.389587 43.432166,5.389188 43.432147,5.388054 43.432013,5.387304 43.431599,5.387163 43.431463,5.386457 43.431177,5.38624 43.431008,5.385917 43.430695,5.385256 43.430282,5.385031 43.430169,5.384592 43.429892,5.384488 43.429611,5.384423 43.429521,5.384422 43.428978,5.384467 43.428827,5.384612 43.428581,5.384469 43.428247,5.384276 43.42824,5.384203 43.42812,5.383663 43.427558,5.383608 43.42753,5.384099 43.426912,5.383883 43.425502,5.383381 43.425227,5.381146 43.424151,5.380119 43.423684,5.379521 43.423201,5.377425 43.421634,5.377001 43.421356,5.375414 43.420279,5.374938 43.419995,5.374552 43.419965,5.373942 43.419877,5.373348 43.41977,5.373166 43.419752,5.372527 43.419615,5.371997 43.419533,5.371407 43.419491,5.370865 43.419486,5.36984 43.419435,5.369608 43.419438,5.369361 43.419488,5.368915 43.419486,5.368403 43.419382,5.367906 43.419356,5.367589 43.419356,5.367471 43.41933,5.366813 43.420222,5.366579 43.420133,5.365766 43.419938,5.364896 43.419681,5.36534 43.419442,5.365744 43.41919,5.364765 43.418614,5.364457 43.41847,5.363831 43.418106,5.363916 43.417914,5.363479 43.41777,5.360843 43.417009,5.360471 43.41745,5.359753 43.418138,5.359423 43.418018,5.35842 43.417718,5.357789 43.418899,5.357703 43.418875,5.357252 43.419726,5.357014 43.420241,5.356845 43.420479,5.356662 43.42084,5.35641 43.420937,5.356083 43.421093,5.355829 43.421298,5.355697 43.421505,5.355626 43.421809,5.355538 43.421995,5.353978 43.421517,5.353636 43.421458,5.352804 43.421285,5.352266 43.421147,5.350747 43.420818,5.349171 43.420458,5.347404 43.420063,5.347235 43.419995,5.346785 43.419877,5.346085 43.419752,5.344187 43.419296,5.343789 43.419516,5.342992 43.419901,5.34255 43.420172,5.34194 43.420474,5.341656 43.420564,5.341363 43.420607,5.341059 43.420624,5.340276 43.420708,5.339828 43.420825,5.339679 43.420966,5.339497 43.421208,5.339274 43.421381,5.339075 43.421445,5.338723 43.421513,5.338302 43.421639,5.338079 43.421736,5.337179 43.421978,5.336972 43.422057,5.336494 43.422281,5.336226 43.422432,5.335423 43.422799,5.334773 43.423152,5.334469 43.423332,5.334008 43.423636,5.333349 43.423989,5.332904 43.42411,5.332586 43.42424,5.332022 43.42459,5.331626 43.424863,5.330961 43.425406,5.330352 43.425794,5.329726 43.426042,5.329369 43.426278,5.329178 43.426426,5.328565 43.426747,5.327954 43.427143,5.327732 43.42722,5.327346 43.427522,5.326879 43.42786,5.32654 43.428066,5.32616 43.428229,5.325397 43.428442,5.325154 43.428484,5.324561 43.428692,5.324373 43.428809,5.324026 43.428953,5.323503 43.429114,5.322757 43.429282,5.322445 43.429382,5.322238 43.429413,5.317537 43.429403,5.31678 43.429653,5.316491 43.429642,5.316094 43.429674,5.315801 43.429725,5.315744 43.429794,5.315504 43.429892,5.314994 43.430277,5.314603 43.430415,5.314335 43.430471,5.314189 43.430537,5.31395 43.430575,5.313641 43.430668,5.313211 43.430848,5.312887 43.430936,5.31242 43.431118,5.31225 43.431248,5.311357 43.431571,5.311225 43.431579,5.310821 43.431525,5.310788 43.431564)))', 4326))
            AND (exist(tags, 'healthcare') OR (tags->'amenity') IN ('doctors','pharmacy','hospital','clinic','social_facility'));