Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.zone AS zone_1,
  s0_.completion_percent AS completion_percent_2,
  s0_.places_count AS places_count_3,
  s0_.avec_horaires AS avec_horaires_4,
  s0_.avec_adresse AS avec_adresse_5,
  s0_.avec_site AS avec_site_6,
  s0_.avec_accessibilite AS avec_accessibilite_7,
  s0_.avec_note AS avec_note_8,
  s0_.name AS name_9,
  s0_.population AS population_10,
  s0_.siren AS siren_11,
  s0_.code_epci AS code_epci_12,
  s0_.codes_postaux AS codes_postaux_13,
  s0_.date_created AS date_created_14,
  s0_.date_modified AS date_modified_15,
  s0_.avec_siret AS avec_siret_16,
  s0_.avec_name AS avec_name_17,
  s0_.avec_email AS avec_email_18,
  s0_.osm_data_date_min AS osm_data_date_min_19,
  s0_.osm_data_date_avg AS osm_data_date_avg_20,
  s0_.osm_data_date_max AS osm_data_date_max_21,
  s0_.budget_annuel AS budget_annuel_22,
  s0_.lat AS lat_23,
  s0_.lon AS lon_24,
  s0_.date_labourage_requested AS date_labourage_requested_25,
  s0_.date_labourage_done AS date_labourage_done_26,
  s0_.kind AS kind_27
FROM
  stats s0_
WHERE
  s0_.zone = ?
ORDER BY
  s0_.id ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.zone AS zone_1, s0_.completion_percent AS completion_percent_2, s0_.places_count AS places_count_3, s0_.avec_horaires AS avec_horaires_4, s0_.avec_adresse AS avec_adresse_5, s0_.avec_site AS avec_site_6, s0_.avec_accessibilite AS avec_accessibilite_7, s0_.avec_note AS avec_note_8, s0_.name AS name_9, s0_.population AS population_10, s0_.siren AS siren_11, s0_.code_epci AS code_epci_12, s0_.codes_postaux AS codes_postaux_13, s0_.date_created AS date_created_14, s0_.date_modified AS date_modified_15, s0_.avec_siret AS avec_siret_16, s0_.avec_name AS avec_name_17, s0_.avec_email AS avec_email_18, s0_.osm_data_date_min AS osm_data_date_min_19, s0_.osm_data_date_avg AS osm_data_date_avg_20, s0_.osm_data_date_max AS osm_data_date_max_21, s0_.budget_annuel AS budget_annuel_22, s0_.lat AS lat_23, s0_.lon AS lon_24, s0_.date_labourage_requested AS date_labourage_requested_25, s0_.date_labourage_done AS date_labourage_done_26, s0_.kind AS kind_27 FROM stats s0_ WHERE s0_.zone = '02118' ORDER BY s0_.id ASC LIMIT 1;

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

"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 ('stats_de_ville', '{\"insee_code\":\"02118\",\"nom\":\"02118\"}', '2026-07-15 23:29:27', 'https://osm-labo.cipherbliss.com/admin/labourer/02118?deleteMissing=1&disableFollowUpCleanup=1', NULL);

"COMMIT"

"COMMIT";

SELECT
  COUNT(*)
FROM
  osm_object t0
WHERE
  t0.zone = ?

SELECT COUNT(*) FROM osm_object t0 WHERE t0.zone = '02118';

SELECT
  s0_.id AS id_0,
  s0_.places_count AS places_count_1,
  s0_.emails_count AS emails_count_2,
  s0_.completion_percent AS completion_percent_3,
  s0_.emails_sent AS emails_sent_4,
  s0_.date AS date_5,
  s0_.names_count AS names_count_6,
  s0_.opening_hours_count AS opening_hours_count_7,
  s0_.website_count AS website_count_8,
  s0_.address_count AS address_count_9,
  s0_.siret_count AS siret_count_10,
  s0_.stats_id AS stats_id_11
FROM
  stats_history s0_
WHERE
  s0_.stats_id = ?
ORDER BY
  s0_.id DESC
LIMIT
  100

SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = 27177 ORDER BY s0_.id DESC LIMIT 100;

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

SELECT
  p0_.osm_user AS osm_user_0,
  COUNT(p0_.id) AS sclr_1,
  AVG(
    (
      CASE WHEN p0_.has_opening_hours = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_address = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_website = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_wheelchair = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_note = 1 THEN
        1
      ELSE
        0
      END
    )
  ) / 5 * 100 AS sclr_2
FROM
  place p0_
WHERE
  p0_.osm_user IS NOT NULL
  AND p0_.osm_user <> ''
  AND p0_.stats_id = ?
GROUP BY
  p0_.osm_user
ORDER BY
  sclr_1 DESC
LIMIT
  100

SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = 27177 GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.disappeared_list AS disappeared_list_2,
  t0.current_list AS current_list_3,
  t0.theme AS theme_4,
  t0.stats_id AS stats_id_5
FROM
  zone_places t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = 27177;

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

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
  osm_object_meta

SELECT COUNT(*) FROM osm_object_meta;

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
  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 (
    (tags -> 'amenity') = ANY(
      ARRAY[ 'library',
      'townhall',
      'restaurant',
      'fast_food',
      'cafe',
      'fuel',
      'pharmacy',
      'bank',
      'bar',
      'hospital',
      'post_office',
      'clinic',
      'pub',
      'car_wash',
      'ice_cream',
      'driving_school',
      'cinema',
      'car_rental',
      'nightclub',
      'bureau_de_change',
      'studio',
      'internet_cafe',
      'money_transfer',
      'casino',
      'vehicle_inspection',
      'frozen_food',
      'boat_rental',
      'coworking_space',
      'workshop',
      'personal_service',
      'camping',
      'dancing_school',
      'training',
      'ski_school',
      'ski_rental',
      'dive_centre',
      'driver_training',
      'nursing_home',
      'funeral_hall',
      'doctors',
      'dentist',
      'theatre',
      'kindergarten',
      'language_school',
      'stripclub',
      'veterinary',
      'convenience',
      'supermarket',
      'clothes',
      'hairdresser',
      'car_repair',
      'bakery',
      'beauty',
      'car',
      'hardware',
      'mobile_phone',
      'butcher',
      'furniture',
      'car_parts',
      'alcohol',
      'florist',
      'scooter',
      'variety_store',
      'electronics',
      'shoes',
      'optician',
      'jewelry',
      'mall',
      'gift',
      'doityourself',
      'greengrocer',
      'books',
      'bicycle',
      'chemist',
      'department_store',
      'laundry',
      'travel_agency',
      'stationery',
      'pet',
      'sports',
      'confectionery',
      'tyres',
      'cosmetics',
      'computer',
      'tailor',
      'tobacco',
      'storage_rental',
      'dry_cleaning',
      'trade',
      'copyshop',
      'motorcycle',
      'funeral_directors',
      'beverages',
      'newsagent',
      'garden_centre',
      'massage',
      'pastry',
      'interior_decoration',
      'general',
      'deli',
      'toys',
      'houseware',
      'wine',
      'seafood',
      'pawnbroker',
      'tattoo',
      'paint',
      'wholesale',
      'photo',
      'second_hand',
      'bed',
      'kitchen',
      'outdoor',
      'fabric',
      'antiques',
      'coffee',
      'gas',
      'e-cigarette',
      'perfumery',
      'craft',
      'hearing_aids',
      'money_lender',
      'appliance',
      'electrical',
      'tea',
      'motorcycle_repair',
      'boutique',
      'baby_goods',
      'bag',
      'musical_instrument',
      'dairy',
      'pet_grooming',
      'music',
      'carpet',
      'rental',
      'fashion_accessories',
      'cheese',
      'chocolate',
      'medical_supply',
      'leather',
      'sewing',
      'cannabis',
      'locksmith',
      'games',
      'video_games',
      'hifi',
      'window_blind',
      'caravan',
      'tool_hire',
      'household_linen',
      'bathroom_furnishing',
      'shoe_repair',
      'watches',
      'nutrition_supplements',
      'fishing',
      'erotic',
      'frame',
      'grocery',
      'boat',
      'repair',
      'weapons',
      'gold_buyer',
      'lighting',
      'pottery',
      'security',
      'groundskeeping',
      'herbalist',
      'curtain',
      'health_food',
      'flooring',
      'printer_ink',
      'anime',
      'camera',
      'scuba_diving',
      'candles',
      'printing',
      'garden_furniture',
      'food',
      'estate_agent',
      'insurance',
      'it',
      'accountant',
      'employment_agency',
      'tax_advisor',
      'financial',
      'advertising_agency',
      'logistics',
      'newspaper',
      'financial_advisor',
      'consulting',
      'travel_agent',
      'coworking',
      'moving_company',
      'lawyer',
      'architect',
      'construction_company',
      'credit_broker',
      'graphic_design',
      'property_management',
      'cleaning' ] :: text[]
    )
    OR (
      exist(tags, 'shop')
      AND COALESCE(tags -> 'shop', '') NOT ILIKE '%vacant%'
      AND COALESCE(tags -> 'shop', '') <> ''
    )
    OR (tags -> 'tourism') = ANY(
      ARRAY[ 'hotel', 'hostel', 'motel',
      'wilderness_hut', 'yes', 'chalet',
      'gallery', 'guest_house', 'museum',
      'zoo', 'theme_park', 'aquarium',
      'alpine_hut', 'apartment' ] :: text[]
    )
    OR (
      exist(tags, 'healthcare')
      AND COALESCE(tags -> 'healthcare', '') <> ''
    )
    OR (tags -> 'information') = 'office'
    OR (
      exist(tags, 'office')
      AND COALESCE(tags -> 'office', '') <> ''
    )
  )

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(((3.390405 49.421333,3.388772 49.42064,3.388326 49.422324,3.381462 49.420474,3.381348 49.420596,3.38046 49.420271,3.380196 49.420131,3.380677 49.419754,3.378427 49.418081,3.376614 49.415971,3.372461 49.417248,3.368794 49.418063,3.363348 49.418771,3.366686 49.421341,3.368897 49.424205,3.369358 49.423975,3.369827 49.423881,3.370073 49.423884,3.370862 49.42408,3.371379 49.424282,3.371548 49.424405,3.371665 49.424549,3.371648 49.424846,3.371673 49.424996,3.371815 49.425186,3.372392 49.425067,3.372319 49.425213,3.372299 49.425375,3.372328 49.425733,3.372932 49.42621,3.373217 49.426366,3.373062 49.426888,3.372953 49.426883,3.372733 49.427308,3.373276 49.427501,3.373486 49.427509,3.373746 49.42747,3.374405 49.427526,3.374694 49.427519,3.376151 49.427696,3.376033 49.428137,3.376219 49.428181,3.376257 49.428497,3.376954 49.428467,3.37737 49.428419,3.377693 49.428103,3.37792 49.428001,3.378344 49.428016,3.37859 49.428071,3.378905 49.428181,3.379765 49.426708,3.380027 49.426753,3.380109 49.426695,3.380291 49.426811,3.380519 49.426781,3.380826 49.426829,3.381218 49.426623,3.381372 49.426693,3.381438 49.426581,3.38162 49.426611,3.381675 49.426511,3.381644 49.426323,3.381511 49.426218,3.381585 49.426122,3.381988 49.426172,3.382117 49.426286,3.38224 49.426212,3.382545 49.426287,3.38287 49.426439,3.383365 49.426596,3.383437 49.426719,3.38361 49.42671,3.383876 49.426839,3.383791 49.426988,3.384253 49.42705,3.384418 49.427194,3.384651 49.427213,3.384946 49.427391,3.385614 49.427201,3.385901 49.427027,3.385853 49.426975,3.38649 49.42672,3.387024 49.426373,3.387972 49.425641,3.390405 49.421333)))', 4326))
            AND (
              (tags->'amenity') = ANY(ARRAY['library','townhall','restaurant','fast_food','cafe','fuel','pharmacy','bank','bar','hospital','post_office','clinic','pub','car_wash','ice_cream','driving_school','cinema','car_rental','nightclub','bureau_de_change','studio','internet_cafe','money_transfer','casino','vehicle_inspection','frozen_food','boat_rental','coworking_space','workshop','personal_service','camping','dancing_school','training','ski_school','ski_rental','dive_centre','driver_training','nursing_home','funeral_hall','doctors','dentist','theatre','kindergarten','language_school','stripclub','veterinary','convenience','supermarket','clothes','hairdresser','car_repair','bakery','beauty','car','hardware','mobile_phone','butcher','furniture','car_parts','alcohol','florist','scooter','variety_store','electronics','shoes','optician','jewelry','mall','gift','doityourself','greengrocer','books','bicycle','chemist','department_store','laundry','travel_agency','stationery','pet','sports','confectionery','tyres','cosmetics','computer','tailor','tobacco','storage_rental','dry_cleaning','trade','copyshop','motorcycle','funeral_directors','beverages','newsagent','garden_centre','massage','pastry','interior_decoration','general','deli','toys','houseware','wine','seafood','pawnbroker','tattoo','paint','wholesale','photo','second_hand','bed','kitchen','outdoor','fabric','antiques','coffee','gas','e-cigarette','perfumery','craft','hearing_aids','money_lender','appliance','electrical','tea','motorcycle_repair','boutique','baby_goods','bag','musical_instrument','dairy','pet_grooming','music','carpet','rental','fashion_accessories','cheese','chocolate','medical_supply','leather','sewing','cannabis','locksmith','games','video_games','hifi','window_blind','caravan','tool_hire','household_linen','bathroom_furnishing','shoe_repair','watches','nutrition_supplements','fishing','erotic','frame','grocery','boat','repair','weapons','gold_buyer','lighting','pottery','security','groundskeeping','herbalist','curtain','health_food','flooring','printer_ink','anime','camera','scuba_diving','candles','printing','garden_furniture','food','estate_agent','insurance','it','accountant','employment_agency','tax_advisor','financial','advertising_agency','logistics','newspaper','financial_advisor','consulting','travel_agent','coworking','moving_company','lawyer','architect','construction_company','credit_broker','graphic_design','property_management','cleaning']::text[])
           OR (exist(tags, 'shop') AND COALESCE(tags->'shop','') NOT ILIKE '%vacant%' AND COALESCE(tags->'shop','') <> '')
           OR (tags->'tourism') = ANY(ARRAY['hotel','hostel','motel','wilderness_hut','yes','chalet','gallery','guest_house','museum','zoo','theme_park','aquarium','alpine_hut','apartment']::text[])
           OR (exist(tags, 'healthcare') AND COALESCE(tags->'healthcare','') <> '')
           OR (tags->'information') = 'office'
           OR (exist(tags, 'office') AND COALESCE(tags->'office','') <> '')
        );