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 = '97307' 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 = 26778 AND c0_.name IN ('rnb_count', 'rnb_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 = '97307';

"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\":\"rnb\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-13 02:00:25', 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 = 26778;

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

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 = 26778 AND z0_.theme = 'rnb' 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'97307'') = ?
  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'97307'') = ?
      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 = '97307';

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, 'ref:FR:RNB')
  )

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(((-52.339998 4.915773,-52.339579 4.91554,-52.338865 4.915264,-52.337991 4.915036,-52.337566 4.914898,-52.337315 4.91474,-52.337168 4.914619,-52.337023 4.91444,-52.33688 4.914219,-52.336804 4.913991,-52.336675 4.913514,-52.336589 4.913305,-52.336378 4.912881,-52.336204 4.912563,-52.335958 4.912041,-52.335777 4.911562,-52.335671 4.911232,-52.335544 4.910994,-52.335259 4.910561,-52.335154 4.910335,-52.335011 4.909781,-52.33473 4.909071,-52.334401 4.908208,-52.334284 4.907801,-52.334185 4.907544,-52.334109 4.907417,-52.333757 4.907114,-52.3337 4.907027,-52.333373 4.906247,-52.332999 4.905401,-52.332881 4.905088,-52.332837 4.904892,-52.332824 4.904578,-52.332788 4.904424,-52.332614 4.904133,-52.332462 4.903961,-52.332273 4.903672,-52.332192 4.903499,-52.332078 4.903173,-52.331523 4.902016,-52.331374 4.901652,-52.331295 4.901396,-52.331142 4.900826,-52.330914 4.90032,-52.33067 4.899852,-52.330489 4.899441,-52.330391 4.899117,-52.330196 4.898722,-52.329839 4.898099,-52.329578 4.897529,-52.329437 4.897152,-52.329218 4.896747,-52.329146 4.896425,-52.329018 4.896083,-52.328848 4.895857,-52.328674 4.895744,-52.328481 4.89566,-52.328078 4.895579,-52.327762 4.895493,-52.327433 4.895344,-52.326995 4.895174,-52.326768 4.895104,-52.326374 4.895008,-52.325934 4.894937,-52.325529 4.894795,-52.325097 4.894677,-52.324798 4.894505,-52.32426 4.89437,-52.323982 4.894287,-52.323749 4.894181,-52.322833 4.893814,-52.322559 4.89367,-52.322297 4.893493,-52.321731 4.892968,-52.321192 4.892498,-52.320796 4.892141,-52.32006 4.891456,-52.319906 4.89137,-52.319473 4.891189,-52.319298 4.891161,-52.318682 4.890976,-52.318259 4.890804,-52.317969 4.890663,-52.317767 4.890609,-52.317592 4.890616,-52.317374 4.890688,-52.316952 4.890781,-52.316601 4.890821,-52.316046 4.89092,-52.315838 4.890997,-52.315168 4.891196,-52.315018 4.891067,-52.314877 4.890812,-52.314774 4.89057,-52.314658 4.890226,-52.314476 4.88953,-52.314425 4.889228,-52.314412 4.888926,-52.314414 4.888338,-52.314432 4.887694,-52.314477 4.886643,-52.314471 4.886167,-52.314485 4.884655,-52.314423 4.884403,-52.314337 4.884265,-52.314161 4.884107,-52.313889 4.884,-52.313672 4.883964,-52.313347 4.88394,-52.313013 4.883958,-52.312694 4.883993,-52.3119 4.88419,-52.311268 4.884294,-52.311 4.884286,-52.310738 4.884253,-52.310538 4.884202,-52.310379 4.884093,-52.310226 4.883898,-52.30996 4.883493,-52.309657 4.882834,-52.309592 4.882628,-52.309548 4.882353,-52.309507 4.881827,-52.309423 4.881329,-52.309334 4.881016,-52.309136 4.880566,-52.308981 4.88026,-52.308887 4.880115,-52.308414 4.879637,-52.308151 4.879312,-52.308018 4.87911,-52.307981 4.878921,-52.308015 4.878816,-52.308491 4.877778,-52.308803 4.877278,-52.309013 4.876992,-52.309233 4.876747,-52.309393 4.876605,-52.310502 4.875775,-52.310787 4.875531,-52.310946 4.875354,-52.31108 4.875165,-52.311241 4.874893,-52.311424 4.874544,-52.311629 4.874018,-52.311752 4.87358,-52.311855 4.873107,-52.311865 4.872787,-52.311701 4.872102,-52.311643 4.871711,-52.311525 4.871089,-52.311397 4.870231,-52.311236 4.869521,-52.311111 4.869316,-52.310891 4.869161,-52.309864 4.868547,-52.309495 4.86843,-52.308296 4.868125,-52.307856 4.868022,-52.307683 4.867949,-52.30513 4.866682,-52.303941 4.866146,-52.303626 4.865999,-52.303439 4.865889,-52.30318 4.865706,-52.302413 4.865086,-52.302166 4.864801,-52.301953 4.86445,-52.301616 4.863839,-52.301348 4.863477,-52.300991 4.863032,-52.300774 4.862696,-52.300298 4.86192,-52.300057 4.861427,-52.299941 4.861163,-52.29978 4.860604,-52.299457 4.859567,-52.299296 4.858988,-52.298841 4.857547,-52.298576 4.856628,-52.298306 4.855753,-52.298152 4.85537,-52.297856 4.854681,-52.297589 4.854305,-52.297342 4.853925,-52.296997 4.853441,-52.296511 4.852791,-52.296453 4.852592,-52.296372 4.852481,-52.2961 4.852318,-52.295961 4.852113,-52.295775 4.851961,-52.295537 4.851688,-52.294963 4.851121,-52.29461 4.850801,-52.293941 4.850134,-52.293692 4.849873,-52.293039 4.849314,-52.292754 4.849229,-52.291592 4.848858,-52.291346 4.848748,-52.290883 4.848665,-52.290672 4.848657,-52.290189 4.848744,-52.289804 4.848665,-52.289556 4.848563,-52.289405 4.848427,-52.289282 4.84839,-52.289027 4.848194,-52.28887 4.84816,-52.288608 4.848038,-52.288519 4.847946,-52.288377 4.847966,-52.288193 4.848046,-52.288057 4.84806,-52.287985 4.848017,-52.287833 4.847808,-52.2878 4.847688,-52.287822 4.847559,-52.288165 4.847192,-52.288278 4.846999,-52.288372 4.84672,-52.288595 4.846393,-52.288802 4.84582,-52.289092 4.845059,-52.289402 4.844656,-52.289599 4.844379,-52.289748 4.844242,-52.290066 4.843878,-52.290418 4.843404,-52.290887 4.842753,-52.291373 4.84204,-52.291801 4.841279,-52.292351 4.84038,-52.293412 4.838605,-52.293782 4.837789,-52.293883 4.837468,-52.294176 4.836844,-52.294349 4.836592,-52.294743 4.835942,-52.294932 4.835543,-52.295192 4.83521,-52.295314 4.835093,-52.295389 4.83484,-52.295689 4.83418,-52.295899 4.833829,-52.296203 4.833277,-52.296642 4.832654,-52.296921 4.832135,-52.296848 4.831858,-52.296915 4.831295,-52.297046 4.83054,-52.297206 4.829912,-52.297473 4.829176,-52.297889 4.827807,-52.298016 4.827195,-52.298194 4.826622,-52.298321 4.826146,-52.298485 4.825618,-52.298756 4.824711,-52.295804 4.823609,-52.296338 4.821664,-52.29668 4.81947,-52.296841 4.816248,-52.296901 4.814959,-52.296964 4.810716,-52.296937 4.809634,-52.29721 4.807937,-52.298963 4.801096,-52.300294 4.797503,-52.302113 4.792784,-52.304022 4.789155,-52.305731 4.786146,-52.306818 4.783996,-52.307375 4.782673,-52.309094 4.776761,-52.309692 4.774648,-52.310248 4.773248,-52.310737 4.772161,-52.311526 4.770585,-52.311875 4.769964,-52.312922 4.768161,-52.313683 4.766964,-52.314658 4.765573,-52.31556 4.764335,-52.31706 4.762468,-52.318061 4.761271,-52.320931 4.757806,-52.322102 4.756145,-52.323246 4.754252,-52.32359 4.753471,-52.32378 4.753098,-52.324292 4.751613,-52.325487 4.748251,-52.325997 4.7474,-52.326535 4.746574,-52.326833 4.746231,-52.328152 4.744875,-52.328595 4.74458,-52.32897 4.74436,-52.329248 4.74417,-52.330336 4.743734,-52.330871 4.743489,-52.331779 4.743024,-52.333141 4.742515,-52.334774 4.741636,-52.335211 4.741386,-52.336421 4.740408,-52.338031 4.740528,-52.33958 4.740743,-52.340214 4.740893,-52.340749 4.741136,-52.34106 4.741316,-52.34158 4.741692,-52.342183 4.742262,-52.342834 4.742979,-52.343363 4.74369,-52.34395 4.744542,-52.34478 4.745869,-52.345649 4.747289,-52.346377 4.748465,-52.347235 4.749901,-52.348149 4.751452,-52.349209 4.75307,-52.349543 4.753656,-52.35008 4.754499,-52.350707 4.755357,-52.351323 4.756119,-52.352032 4.756864,-52.353045 4.757912,-52.353563 4.758297,-52.354139 4.758699,-52.354668 4.758996,-52.354908 4.759108,-52.355242 4.75924,-52.355536 4.759333,-52.356272 4.759526,-52.356668 4.759604,-52.357052 4.759658,-52.35737 4.759718,-52.357818 4.75978,-52.359087 4.759884,-52.359405 4.759923,-52.359948 4.760069,-52.360458 4.760149,-52.361012 4.760173,-52.362441 4.760216,-52.363125 4.760223,-52.363595 4.760238,-52.363895 4.760296,-52.364125 4.760385,-52.364433 4.760564,-52.364932 4.760921,-52.365209 4.761139,-52.365376 4.761312,-52.366149 4.762175,-52.366836 4.763073,-52.367054 4.763389,-52.36741 4.764101,-52.367591 4.764424,-52.367786 4.764711,-52.368141 4.765151,-52.368596 4.765473,-52.369055 4.76577,-52.369776 4.766171,-52.370058 4.76632,-52.370281 4.766416,-52.370414 4.766443,-52.37067 4.766439,-52.37103 4.766359,-52.37173 4.766136,-52.372068 4.765999,-52.372229 4.765911,-52.372424 4.765724,-52.372983 4.765726,-52.373485 4.765757,-52.373945 4.765855,-52.374263 4.765945,-52.374883 4.766187,-52.375121 4.766303,-52.375349 4.766487,-52.375431 4.766672,-52.375487 4.76694,-52.375499 4.767249,-52.375468 4.767492,-52.375398 4.767833,-52.375303 4.768155,-52.375088 4.768734,-52.374973 4.768982,-52.374505 4.769888,-52.374322 4.770259,-52.374096 4.770801,-52.373981 4.771154,-52.373807 4.771796,-52.373568 4.772769,-52.373493 4.773035,-52.373468 4.773214,-52.373488 4.773386,-52.373558 4.773559,-52.373732 4.773696,-52.373972 4.773811,-52.374223 4.773897,-52.374472 4.773927,-52.374694 4.773927,-52.374972 4.773897,-52.375551 4.773767,-52.376083 4.773616,-52.376613 4.77348,-52.37688 4.773428,-52.377393 4.773388,-52.377877 4.773437,-52.378531 4.773557,-52.37883 4.773645,-52.379318 4.773745,-52.379557 4.773875,-52.379643 4.773976,-52.379806 4.774347,-52.379912 4.774779,-52.380205 4.776154,-52.38055 4.778003,-52.380726 4.77933,-52.380753 4.780017,-52.380621 4.781293,-52.380416 4.78353,-52.380494 4.783974,-52.380677 4.784382,-52.380959 4.784656,-52.382308 4.785392,-52.382804 4.785632,-52.383161 4.785973,-52.383489 4.786554,-52.3836 4.787099,-52.38354 4.787593,-52.383309 4.787965,-52.382666 4.788431,-52.382015 4.788747,-52.380721 4.789317,-52.38002 4.789871,-52.379465 4.790514,-52.379013 4.791276,-52.378564 4.792346,-52.378527 4.792645,-52.378668 4.793125,-52.378834 4.793388,-52.37911 4.793543,-52.379529 4.793609,-52.380745 4.793687,-52.381255 4.793758,-52.381649 4.793908,-52.382152 4.794213,-52.382589 4.794645,-52.38276 4.795015,-52.38279 4.795475,-52.382707 4.795796,-52.382399 4.79646,-52.381406 4.79761,-52.381036 4.798423,-52.381036 4.798795,-52.38115 4.799027,-52.381626 4.799468,-52.38269 4.800244,-52.383486 4.801149,-52.383652 4.801443,-52.383689 4.80171,-52.383339 4.803166,-52.383108 4.804226,-52.383059 4.804629,-52.382999 4.805883,-52.382938 4.806879,-52.38276 4.80915,-52.382682 4.810931,-52.382619 4.811879,-52.382892 4.812524,-52.382905 4.812843,-52.382866 4.812977,-52.382418 4.813646,-52.381894 4.814344,-52.381661 4.814608,-52.381226 4.815056,-52.380668 4.815662,-52.379885 4.816431,-52.379621 4.816722,-52.379164 4.817167,-52.378976 4.817418,-52.378771 4.817769,-52.378465 4.818376,-52.378319 4.818787,-52.378282 4.818953,-52.378298 4.81944,-52.378288 4.819827,-52.378205 4.820392,-52.378041 4.821201,-52.377844 4.822142,-52.37777 4.822725,-52.377722 4.823332,-52.377709 4.823739,-52.377732 4.824055,-52.377812 4.824431,-52.377934 4.824775,-52.37809 4.825066,-52.378292 4.825346,-52.378639 4.825659,-52.379706 4.826527,-52.38023 4.826915,-52.380852 4.82742,-52.381351 4.82785,-52.381736 4.828236,-52.381881 4.828508,-52.381977 4.828759,-52.382069 4.829071,-52.382179 4.829333,-52.382186 4.829466,-52.38213 4.82961,-52.381965 4.82983,-52.381626 4.83024,-52.381418 4.830513,-52.381241 4.830694,-52.381044 4.830853,-52.380307 4.8312,-52.379421 4.831654,-52.378613 4.832106,-52.378314 4.832292,-52.377713 4.832983,-52.377354 4.833455,-52.376823 4.834293,-52.376744 4.834529,-52.376706 4.834718,-52.376666 4.835083,-52.376706 4.835679,-52.376786 4.835963,-52.376925 4.836229,-52.377084 4.836414,-52.37733 4.836603,-52.377601 4.836779,-52.378331 4.837089,-52.378865 4.837263,-52.379338 4.837345,-52.379629 4.837359,-52.380316 4.837341,-52.380815 4.837219,-52.381041 4.837135,-52.381783 4.836791,-52.382293 4.836503,-52.38284 4.836182,-52.383772 4.835648,-52.385366 4.834771,-52.38578 4.834524,-52.386125 4.834339,-52.386365 4.834262,-52.386781 4.834206,-52.387069 4.834211,-52.387996 4.834373,-52.388544 4.834496,-52.388974 4.834617,-52.38956 4.834924,-52.390212 4.835481,-52.390648 4.835877,-52.391036 4.836299,-52.391765 4.837369,-52.391878 4.837593,-52.391901 4.837742,-52.391867 4.837925,-52.391754 4.838108,-52.391637 4.838201,-52.391458 4.83827,-52.391181 4.838319,-52.390847 4.838314,-52.39047 4.838336,-52.389986 4.838438,-52.389129 4.838642,-52.388576 4.838846,-52.387887 4.839117,-52.387243 4.839383,-52.387022 4.839567,-52.386792 4.839869,-52.38672 4.840036,-52.386649 4.840313,-52.386625 4.840519,-52.38665 4.840693,-52.386798 4.841109,-52.387035 4.841542,-52.387209 4.841924,-52.38736 4.842294,-52.387607 4.843105,-52.387794 4.843618,-52.388133 4.844038,-52.388721 4.844493,-52.389066 4.8449,-52.389292 4.845196,-52.389852 4.846,-52.39004 4.846422,-52.390337 4.846653,-52.390448 4.846844,-52.390504 4.847301,-52.390775 4.847555,-52.391072 4.848005,-52.391687 4.848749,-52.392151 4.849091,-52.392338 4.849283,-52.3924 4.849501,-52.392508 4.849676,-52.392717 4.849903,-52.393011 4.850098,-52.393353 4.850207,-52.394331 4.850374,-52.395154 4.850215,-52.39567 4.850184,-52.396918 4.85005,-52.397949 4.849879,-52.399373 4.849579,-52.400758 4.849408,-52.401437 4.849234,-52.403906 4.848641,-52.404613 4.848421,-52.405299 4.848135,-52.405984 4.847693,-52.40625 4.847565,-52.406466 4.847425,-52.406652 4.847355,-52.406806 4.847473,-52.407083 4.847812,-52.40717 4.848283,-52.407108 4.848744,-52.407043 4.848957,-52.407026 4.84917,-52.407102 4.849318,-52.407748 4.849703,-52.407847 4.849853,-52.40784 4.849995,-52.407766 4.850217,-52.407548 4.850597,-52.407463 4.850833,-52.407464 4.851149,-52.407431 4.85166,-52.407296 4.851913,-52.407094 4.852186,-52.406793 4.852397,-52.406293 4.852711,-52.406181 4.852883,-52.406101 4.853268,-52.406104 4.85356,-52.406201 4.853896,-52.406343 4.854164,-52.406633 4.854595,-52.406898 4.854965,-52.407143 4.855246,-52.407359 4.855581,-52.407434 4.855769,-52.407509 4.856114,-52.407603 4.856409,-52.407733 4.85693,-52.407917 4.857376,-52.408093 4.85759,-52.408504 4.857967,-52.408796 4.858401,-52.408985 4.858781,-52.409191 4.859166,-52.409341 4.859561,-52.409531 4.860127,-52.409829 4.861269,-52.409919 4.86153,-52.410068 4.862322,-52.410059 4.862712,-52.41011 4.863122,-52.410208 4.863335,-52.41035 4.863444,-52.410515 4.863515,-52.410897 4.863536,-52.411305 4.863731,-52.411773 4.864213,-52.4114 4.86451,-52.410509 4.864913,-52.409567 4.865064,-52.408449 4.865041,-52.407353 4.864703,-52.405989 4.864022,-52.404709 4.863244,-52.403553 4.862298,-52.402556 4.861119,-52.400838 4.858919,-52.399629 4.857315,-52.398822 4.856544,-52.398035 4.855954,-52.396769 4.855474,-52.395692 4.855187,-52.394049 4.855214,-52.392524 4.855574,-52.391255 4.856013,-52.390118 4.856674,-52.38861 4.857781,-52.387517 4.858862,-52.386877 4.859825,-52.386054 4.861361,-52.385539 4.862958,-52.385337 4.864649,-52.38547 4.866309,-52.386106 4.8687,-52.386897 4.870253,-52.388555 4.872702,-52.389714 4.874222,-52.390917 4.876083,-52.391619 4.877353,-52.391789 4.878516,-52.391736 4.880071,-52.391556 4.880778,-52.39103 4.881732,-52.39006 4.883054,-52.389702 4.883586,-52.388746 4.884718,-52.387643 4.885937,-52.386546 4.886848,-52.38509 4.888108,-52.383902 4.889272,-52.382367 4.890736,-52.380763 4.892498,-52.379662 4.893731,-52.378264 4.895375,-52.376965 4.897392,-52.375886 4.899924,-52.374792 4.903153,-52.373258 4.903962,-52.369361 4.90601,-52.367509 4.90695,-52.36678 4.905986,-52.365814 4.9047,-52.364061 4.902377,-52.364031 4.902467,-52.364062 4.90268,-52.36397 4.90281,-52.363823 4.90294,-52.363665 4.903026,-52.363337 4.903039,-52.362863 4.903467,-52.362684 4.903599,-52.362193 4.904021,-52.362048 4.904113,-52.361974 4.904113,-52.361737 4.903889,-52.361595 4.903933,-52.361355 4.90411,-52.361303 4.904235,-52.361198 4.904278,-52.361147 4.904486,-52.361262 4.904578,-52.361221 4.904679,-52.361128 4.904663,-52.361057 4.904764,-52.360864 4.904829,-52.360827 4.905099,-52.360201 4.905294,-52.359527 4.905457,-52.359484 4.905588,-52.35936 4.905543,-52.35933 4.905371,-52.359491 4.905355,-52.35989 4.905252,-52.360749 4.904994,-52.360809 4.904773,-52.360463 4.904617,-52.360334 4.904675,-52.360443 4.904873,-52.360379 4.905017,-52.360162 4.905137,-52.359765 4.905243,-52.359664 4.905197,-52.359522 4.905301,-52.359259 4.905212,-52.359068 4.905288,-52.358909 4.90516,-52.358898 4.905077,-52.358979 4.905016,-52.358862 4.904823,-52.358758 4.904776,-52.358312 4.904454,-52.358033 4.904352,-52.35787 4.904376,-52.357718 4.904148,-52.357556 4.904032,-52.357289 4.903934,-52.357053 4.903795,-52.356899 4.903738,-52.356772 4.903735,-52.356598 4.903779,-52.356119 4.90381,-52.355874 4.903815,-52.355477 4.903895,-52.355366 4.90389,-52.355166 4.903799,-52.354847 4.903819,-52.354647 4.903765,-52.354325 4.903633,-52.353977 4.903513,-52.353674 4.903489,-52.353411 4.9035,-52.353182 4.90354,-52.353011 4.903613,-52.35244 4.903739,-52.351975 4.903895,-52.351579 4.903963,-52.351283 4.904078,-52.350609 4.904389,-52.350181 4.904529,-52.349784 4.904624,-52.349362 4.904757,-52.348563 4.90516,-52.348099 4.905465,-52.3478 4.905701,-52.347274 4.906067,-52.346946 4.906361,-52.346347 4.906808,-52.345696 4.907268,-52.345421 4.907577,-52.344881 4.908094,-52.344636 4.908382,-52.34421 4.90881,-52.343889 4.909272,-52.343371 4.910176,-52.343049 4.910655,-52.34273 4.911036,-52.342256 4.911636,-52.341789 4.912282,-52.34125 4.913299,-52.340903 4.913902,-52.340634 4.914433,-52.340401 4.91496,-52.340138 4.915743,-52.339998 4.915773)))', 4326))
            AND (exist(tags, 'ref:FR:RNB'));