Symfony Profiler

Query Metrics

15 Database Queries

13 Different statements

74.82 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.57 ms
(0.76%)

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 = ?

Parameters:

[
  25868
]

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\AdminController->cityClosures (line 1659)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.43 ms
(0.58%)

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

Parameters:

[
  "50129"
]

View formatted query View runnable query Explain query View query backtrace

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 = '50129' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\AdminController->cityClosures (line 1643)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

osm connection

Time▼

Count

Info

52.03 ms
(69.54%)

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->'shop') = 'vacant'
              OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')
            )

Parameters:

[
  "MULTIPOLYGON(((-1.601821 49.59925,-1.604145 49.59961,-1.604544 49.599366,-1.605194 49.59954,-1.605149 49.599622,-1.605685 49.599789,-1.606678 49.600398,-1.610467 49.601754,-1.610684 49.601697,-1.611121 49.601953,-1.611486 49.602198,-1.611705 49.602282,-1.612107 49.602503,-1.612362 49.602481,-1.612691 49.602539,-1.613299 49.602711,-1.613487 49.602878,-1.613672 49.602894,-1.613792 49.602983,-1.614082 49.603116,-1.614262 49.603404,-1.614587 49.603737,-1.614907 49.603666,-1.614947 49.60381,-1.615489 49.604187,-1.616252 49.604536,-1.616492 49.604626,-1.616542 49.604749,-1.616872 49.604907,-1.61723 49.605031,-1.61751 49.605285,-1.617766 49.605388,-1.617884 49.605472,-1.617888 49.605557,-1.618076 49.605584,-1.618223 49.605722,-1.618726 49.606061,-1.6189 49.606115,-1.619648 49.606408,-1.619752 49.606486,-1.619856 49.606816,-1.620009 49.606947,-1.620397 49.607111,-1.620523 49.607019,-1.62079 49.607153,-1.621017 49.607128,-1.622041 49.60786,-1.622296 49.608185,-1.622864 49.608312,-1.623396 49.608488,-1.623831 49.608678,-1.624132 49.608857,-1.624508 49.608944,-1.624881 49.608985,-1.625379 49.608995,-1.625954 49.608876,-1.626493 49.609109,-1.627043 49.609372,-1.627672 49.609711,-1.628031 49.609961,-1.628405 49.610092,-1.628905 49.610153,-1.629248 49.610158,-1.62952 49.610121,-1.630234 49.609924,-1.63059 49.60975,-1.631219 49.609744,-1.631464 49.609577,-1.632263 49.609742,-1.632495 49.609906,-1.63271 49.60997,-1.632775 49.610046,-1.633023 49.609948,-1.633413 49.610008,-1.633612 49.609988,-1.633994 49.610009,-1.634453 49.610074,-1.634554 49.610246,-1.634731 49.610252,-1.635917 49.610518,-1.636257 49.61062,-1.636619 49.610643,-1.636779 49.610678,-1.637187 49.610865,-1.637939 49.611066,-1.638319 49.61125,-1.638544 49.611208,-1.638835 49.610754,-1.639417 49.6107,-1.639744 49.61071,-1.63995 49.610751,-1.640623 49.610831,-1.641559 49.611006,-1.641524 49.611471,-1.641656 49.611607,-1.64153 49.611822,-1.642366 49.6123,-1.642826 49.612529,-1.642987 49.612687,-1.643347 49.612726,-1.643838 49.612961,-1.643971 49.613044,-1.643946 49.61319,-1.644175 49.613193,-1.644589 49.613622,-1.644799 49.613934,-1.644742 49.614055,-1.644803 49.614195,-1.645064 49.614352,-1.644947 49.614501,-1.64572 49.61506,-1.645874 49.615191,-1.646024 49.615144,-1.646273 49.615235,-1.646567 49.614991,-1.646726 49.614776,-1.646734 49.614358,-1.646591 49.614067,-1.646569 49.613943,-1.646635 49.613808,-1.647257 49.613559,-1.647634 49.613465,-1.647905 49.613451,-1.648362 49.613297,-1.648565 49.613092,-1.648962 49.612985,-1.649131 49.612856,-1.649061 49.612707,-1.649088 49.612561,-1.64924 49.612415,-1.649643 49.612246,-1.649726 49.612141,-1.649953 49.61205,-1.65028 49.611991,-1.650448 49.611912,-1.650747 49.611561,-1.65092 49.611528,-1.651297 49.611627,-1.651554 49.611618,-1.651816 49.61153,-1.652016 49.611162,-1.652355 49.61099,-1.652635 49.610801,-1.652795 49.610754,-1.652985 49.610807,-1.653145 49.610796,-1.653178 49.610631,-1.65333 49.610568,-1.65352 49.610318,-1.653962 49.610096,-1.654236 49.610046,-1.654363 49.610116,-1.654854 49.610033,-1.655312 49.609807,-1.655559 49.609759,-1.655912 49.609747,-1.656243 49.609565,-1.656684 49.609558,-1.656913 49.609483,-1.657262 49.609211,-1.657976 49.60887,-1.658336 49.60877,-1.6589 49.608699,-1.659422 49.608693,-1.659857 49.608711,-1.660181 49.608866,-1.660301 49.609056,-1.660926 49.609167,-1.661297 49.609204,-1.661562 49.609268,-1.661847 49.609266,-1.662169 49.609159,-1.662625 49.608866,-1.662852 49.608635,-1.663268 49.608444,-1.663994 49.608399,-1.66444 49.608404,-1.66454 49.608373,-1.664801 49.608512,-1.665349 49.608769,-1.66512 49.608957,-1.66555 49.609131,-1.66642 49.609433,-1.666213 49.609861,-1.666969 49.610063,-1.667319 49.610188,-1.668147 49.610363,-1.668631 49.610502,-1.669221 49.610641,-1.669388 49.610651,-1.669736 49.610754,-1.669882 49.610595,-1.670271 49.610835,-1.670762 49.611014,-1.67142 49.611297,-1.671878 49.611443,-1.672023 49.611435,-1.672298 49.611536,-1.672052 49.611647,-1.671269 49.611946,-1.671948 49.612379,-1.671908 49.612534,-1.671595 49.612458,-1.671354 49.612445,-1.67113 49.612473,-1.670719 49.612591,-1.670215 49.612788,-1.669928 49.613091,-1.669784 49.613397,-1.669381 49.613288,-1.668923 49.613682,-1.669254 49.613844,-1.669174 49.613909,-1.669016 49.614304,-1.669058 49.614343,-1.668708 49.614476,-1.667824 49.614636,-1.668608 49.615487,-1.667096 49.615846,-1.667262 49.616087,-1.667512 49.61635,-1.668186 49.61698,-1.668414 49.617213,-1.667993 49.617336,-1.667582 49.6175,-1.666648 49.618146,-1.666159 49.618291,-1.66502 49.618518,-1.664111 49.618737,-1.663294 49.618965,-1.662518 49.619312,-1.661705 49.619559,-1.662259 49.620404,-1.662768 49.62125,-1.663322 49.621083,-1.664007 49.620853,-1.664752 49.620618,-1.664929 49.620738,-1.66551 49.620988,-1.665808 49.621219,-1.666106 49.621606,-1.666592 49.622064,-1.667311 49.62264,-1.667786 49.623056,-1.668 49.623345,-1.668265 49.623752,-1.668636 49.624211,-1.668999 49.624361,-1.66935 49.624401,-1.670145 49.625115,-1.670367 49.625404,-1.670537 49.626092,-1.670582 49.626209,-1.670484 49.626522,-1.6705 49.626815,-1.67062 49.627033,-1.670926 49.627254,-1.671367 49.627403,-1.672131 49.627593,-1.672546 49.627649,-1.672835 49.62755,-1.673565 49.627743,-1.674617 49.627965,-1.675191 49.628049,-1.675858 49.628115,-1.676119 49.628109,-1.67679 49.627924,-1.676915 49.62791,-1.676884 49.628094,-1.676998 49.62856,-1.677115 49.62877,-1.677221 49.628808,-1.677567 49.628744,-1.677685 49.629182,-1.677806 49.629456,-1.677806 49.629571,-1.677945 49.629811,-1.678053 49.630249,-1.678262 49.630462,-1.67822 49.630803,-1.678162 49.631006,-1.678293 49.631041,-1.678803 49.630958,-1.67904 49.630959,-1.679606 49.630745,-1.679906 49.630658,-1.67997 49.630586,-1.680187 49.630618,-1.680565 49.630438,-1.6808 49.630424,-1.680931 49.630353,-1.681132 49.630156,-1.681288 49.630049,-1.681476 49.629984,-1.681673 49.62983,-1.682079 49.629698,-1.68284 49.629223,-1.683046 49.629138,-1.683131 49.628954,-1.684002 49.6286,-1.684283 49.628606,-1.684666 49.628426,-1.68528 49.628252,-1.685589 49.628137,-1.685742 49.628028,-1.685756 49.627912,-1.685982 49.628041,-1.686172 49.628005,-1.686133 49.628195,-1.686198 49.628426,-1.686517 49.628444,-1.686847 49.628732,-1.687142 49.629096,-1.687712 49.629698,-1.68805 49.629984,-1.688299 49.630088,-1.688184 49.63027,-1.687835 49.630527,-1.688345 49.630912,-1.688621 49.631157,-1.689176 49.631691,-1.689493 49.63194,-1.689891 49.632194,-1.690501 49.632493,-1.690984 49.632673,-1.690908 49.632862,-1.69094 49.633185,-1.69089 49.633475,-1.691002 49.633725,-1.690925 49.633995,-1.691119 49.634222,-1.691707 49.634419,-1.691789 49.634468,-1.69209 49.63432,-1.692741 49.63466,-1.69289 49.634805,-1.693279 49.634984,-1.693864 49.635178,-1.694675 49.635529,-1.694916 49.635618,-1.695284 49.6354,-1.695454 49.635255,-1.695945 49.634943,-1.696519 49.635207,-1.696953 49.635353,-1.697183 49.635235,-1.697894 49.635767,-1.698455 49.636241,-1.698524 49.63636,-1.698088 49.636544,-1.698438 49.636899,-1.698655 49.636743,-1.698997 49.636619,-1.699321 49.636388,-1.699348 49.636318,-1.699712 49.636117,-1.699908 49.635895,-1.700309 49.635592,-1.701192 49.635267,-1.70135 49.635136,-1.701603 49.635148,-1.701778 49.635036,-1.701728 49.634934,-1.702234 49.634675,-1.702585 49.634532,-1.702717 49.634342,-1.703237 49.6343,-1.70363 49.63424,-1.704315 49.63411,-1.704564 49.634215,-1.704777 49.634181,-1.705002 49.634002,-1.70508 49.633869,-1.705069 49.633766,-1.70519 49.633736,-1.705314 49.633532,-1.705492 49.633508,-1.705997 49.633356,-1.707119 49.632851,-1.707942 49.632442,-1.707956 49.632345,-1.708287 49.632205,-1.708599 49.632016,-1.709202 49.631694,-1.709704 49.631627,-1.709942 49.631516,-1.710393 49.631253,-1.71029 49.631139,-1.710327 49.631013,-1.710648 49.630771,-1.710945 49.630612,-1.711293 49.630501,-1.711459 49.630408,-1.711513 49.630301,-1.711665 49.630193,-1.71197 49.630058,-1.712786 49.629639,-1.712769 49.629556,-1.713223 49.629359,-1.713393 49.629485,-1.714118 49.629078,-1.714043 49.628958,-1.714134 49.628773,-1.714754 49.628647,-1.715424 49.62833,-1.716236 49.627861,-1.71679 49.627576,-1.717089 49.627406,-1.717904 49.626998,-1.71817 49.626967,-1.718337 49.626991,-1.718421 49.626896,-1.71853 49.626377,-1.718546 49.626205,-1.718807 49.626183,-1.719481 49.626231,-1.720055 49.626355,-1.720801 49.626587,-1.721336 49.626738,-1.721442 49.626644,-1.722095 49.626217,-1.72221 49.626204,-1.722716 49.626015,-1.722897 49.626146,-1.723865 49.626792,-1.724207 49.627039,-1.724565 49.627267,-1.724436 49.627367,-1.723486 49.628273,-1.72379 49.628391,-1.723686 49.628539,-1.723105 49.628924,-1.722899 49.628841,-1.722765 49.628879,-1.722617 49.629032,-1.72192 49.629931,-1.721844 49.629945,-1.721163 49.62973,-1.72082 49.630163,-1.720711 49.630274,-1.720256 49.630851,-1.720101 49.631096,-1.720043 49.631495,-1.71974 49.631882,-1.719628 49.631994,-1.71963 49.632217,-1.719584 49.632751,-1.719518 49.63288,-1.719291 49.633064,-1.719263 49.63319,-1.719094 49.633346,-1.719151 49.633572,-1.719174 49.633849,-1.718987 49.634065,-1.718668 49.634201,-1.718448 49.634725,-1.718316 49.634813,-1.718179 49.635074,-1.718003 49.635278,-1.717645 49.635613,-1.717607 49.635738,-1.717497 49.635828,-1.717061 49.63607,-1.716684 49.636255,-1.716366 49.636333,-1.716078 49.636591,-1.715999 49.636625,-1.715767 49.63646,-1.715417 49.636751,-1.715209 49.636887,-1.714986 49.636913,-1.714496 49.636758,-1.714225 49.636627,-1.713881 49.636595,-1.713189 49.63671,-1.712925 49.636723,-1.712983 49.636931,-1.712107 49.637052,-1.712036 49.636809,-1.711704 49.636845,-1.711246 49.636817,-1.710526 49.636857,-1.710323 49.636916,-1.710374 49.637055,-1.710109 49.63713,-1.709696 49.637289,-1.709551 49.63727,-1.709233 49.63748,-1.708728 49.637728,-1.708402 49.637829,-1.707987 49.638019,-1.707678 49.638139,-1.706888 49.638482,-1.706656 49.638611,-1.706246 49.638781,-1.706141 49.638738,-1.705858 49.638864,-1.705713 49.638961,-1.705522 49.638956,-1.704453 49.639616,-1.704334 49.639749,-1.704464 49.639823,-1.704253 49.64009,-1.70418 49.640283,-1.703993 49.640223,-1.703922 49.640267,-1.703848 49.64054,-1.703701 49.640688,-1.703503 49.641063,-1.70357 49.641339,-1.7037 49.641737,-1.703878 49.641818,-1.704061 49.641749,-1.704574 49.642074,-1.704575 49.642177,-1.704693 49.642344,-1.704603 49.642588,-1.704621 49.642783,-1.70488 49.643013,-1.704974 49.643401,-1.704861 49.643618,-1.704594 49.643957,-1.70457 49.644062,-1.704411 49.644241,-1.704308 49.644266,-1.703844 49.644624,-1.703632 49.644862,-1.703525 49.645142,-1.703258 49.645365,-1.703049 49.645326,-1.702904 49.645846,-1.702755 49.64624,-1.702758 49.64641,-1.70267 49.646634,-1.702834 49.646752,-1.702857 49.646991,-1.702987 49.647211,-1.702894 49.647337,-1.702951 49.647454,-1.703074 49.647468,-1.702576 49.648471,-1.702368 49.648762,-1.702189 49.648847,-1.702239 49.648913,-1.702118 49.649197,-1.702231 49.649455,-1.702137 49.649593,-1.702232 49.64965,-1.70236 49.649953,-1.702509 49.65019,-1.702676 49.650307,-1.702631 49.650352,-1.702818 49.650639,-1.702732 49.650791,-1.70264 49.650819,-1.702634 49.651194,-1.702417 49.651449,-1.702337 49.651734,-1.70258 49.651844,-1.702477 49.652142,-1.702363 49.652333,-1.702299 49.652526,-1.702024 49.652788,-1.701753 49.652995,-1.701497 49.653285,-1.701526 49.653335,-1.701357 49.653494,-1.701188 49.653708,-1.700997 49.65381,-1.700862 49.653835,-1.700608 49.654012,-1.700531 49.654171,-1.700529 49.654314,-1.700416 49.654369,-1.700324 49.654507,-1.700011 49.654726,-1.699886 49.654935,-1.699718 49.655101,-1.699603 49.655505,-1.699958 49.655581,-1.700357 49.655537,-1.700408 49.655444,-1.700585 49.655395,-1.700752 49.655439,-1.700903 49.65533,-1.701012 49.655376,-1.701163 49.655331,-1.701219 49.655165,-1.701633 49.655173,-1.701685 49.655065,-1.701947 49.655007,-1.702182 49.654861,-1.702456 49.654802,-1.702711 49.654642,-1.703042 49.654615,-1.703174 49.654521,-1.703603 49.654415,-1.704441 49.654592,-1.704981 49.654521,-1.705657 49.654375,-1.705935 49.654253,-1.70621 49.654094,-1.707344 49.653336,-1.707406 49.65337,-1.707777 49.653261,-1.708177 49.65291,-1.708076 49.652845,-1.709246 49.652095,-1.709518 49.651661,-1.709692 49.651503,-1.710013 49.651422,-1.710227 49.651286,-1.710426 49.651246,-1.710642 49.651327,-1.710845 49.651361,-1.711136 49.651328,-1.711627 49.651341,-1.712402 49.651311,-1.712925 49.651199,-1.713285 49.650825,-1.71313 49.650732,-1.71327 49.650635,-1.713345 49.650507,-1.713597 49.650397,-1.71403 49.650247,-1.7141 49.650153,-1.714477 49.650086,-1.714639 49.650148,-1.714793 49.650097,-1.715031 49.650097,-1.715153 49.650051,-1.715263 49.649934,-1.71527 49.64968,-1.715513 49.649758,-1.71573 49.649584,-1.715736 49.649501,-1.715893 49.649389,-1.71605 49.649208,-1.716062 49.649058,-1.716245 49.649058,-1.716492 49.648993,-1.716615 49.649005,-1.716775 49.649102,-1.717496 49.649037,-1.718191 49.648878,-1.719091 49.64852,-1.72005 49.648277,-1.720005 49.648154,-1.72012 49.648089,-1.72045 49.64806,-1.720455 49.647907,-1.720598 49.647847,-1.720552 49.647756,-1.721036 49.647696,-1.721124 49.64782,-1.721316 49.647756,-1.721654 49.647542,-1.721717 49.647427,-1.721994 49.647308,-1.722495 49.647042,-1.72268 49.647012,-1.722887 49.646777,-1.723066 49.646733,-1.723168 49.646653,-1.723335 49.64675,-1.723651 49.646825,-1.723827 49.646838,-1.724106 49.646786,-1.724163 49.646693,-1.724614 49.646637,-1.724728 49.64658,-1.725062 49.646567,-1.72549 49.646504,-1.725743 49.646375,-1.726692 49.645616,-1.726938 49.645459,-1.727586 49.644838,-1.727871 49.644748,-1.728212 49.644557,-1.728126 49.64447,-1.72831 49.644241,-1.728594 49.644104,-1.728716 49.643894,-1.729055 49.643659,-1.730017 49.64288,-1.731925 49.641369,-1.732066 49.641251,-1.732204 49.641328,-1.732716 49.641484,-1.732924 49.641828,-1.733241 49.642227,-1.733364 49.642467,-1.733471 49.643003,-1.733554 49.643095,-1.733568 49.643437,-1.733678 49.644314,-1.733704 49.644628,-1.733674 49.645412,-1.733689 49.645444,-1.734443 49.64559,-1.735021 49.645645,-1.73494 49.646104,-1.734862 49.646805,-1.734989 49.647425,-1.735245 49.647856,-1.734844 49.648053,-1.734685 49.648202,-1.734728 49.64834,-1.735111 49.648525,-1.735366 49.648609,-1.735703 49.64878,-1.736341 49.649052,-1.736998 49.649439,-1.737405 49.649525,-1.737509 49.649577,-1.737576 49.649779,-1.737704 49.649935,-1.737654 49.649975,-1.737647 49.650176,-1.737438 49.650308,-1.737154 49.650435,-1.736548 49.650478,-1.736318 49.650468,-1.735835 49.650531,-1.73545 49.650535,-1.734647 49.650684,-1.73454 49.650731,-1.734374 49.651121,-1.734241 49.651214,-1.734215 49.651566,-1.734022 49.651795,-1.733959 49.651941,-1.733816 49.652022,-1.733699 49.652209,-1.733636 49.652226,-1.733123 49.652885,-1.732694 49.653173,-1.732489 49.653429,-1.732294 49.653536,-1.731808 49.653753,-1.731098 49.653751,-1.730802 49.653771,-1.730247 49.653921,-1.730165 49.654174,-1.730021 49.654277,-1.729682 49.654335,-1.729599 49.654573,-1.729244 49.654544,-1.72903 49.654782,-1.728847 49.654872,-1.728799 49.654977,-1.729031 49.655245,-1.729045 49.655546,-1.728913 49.655799,-1.728764 49.656176,-1.728439 49.656269,-1.728277 49.656417,-1.728315 49.65657,-1.727678 49.656794,-1.727381 49.656854,-1.727652 49.657099,-1.727701 49.657271,-1.727662 49.657564,-1.72773 49.657842,-1.72783 49.657991,-1.728027 49.658189,-1.728378 49.658472,-1.728302 49.658596,-1.728218 49.658856,-1.728072 49.659179,-1.727476 49.659483,-1.727121 49.659605,-1.726824 49.659772,-1.72652 49.659869,-1.726385 49.659966,-1.726302 49.660106,-1.726323 49.660396,-1.726244 49.660621,-1.725797 49.661111,-1.725386 49.661435,-1.7249 49.661712,-1.724653 49.661771,-1.723993 49.66206,-1.723834 49.662068,-1.723805 49.661875,-1.723537 49.661939,-1.723409 49.662002,-1.723164 49.662022,-1.723134 49.662163,-1.722651 49.66227,-1.721973 49.662381,-1.722301 49.662647,-1.721137 49.663244,-1.720331 49.663609,-1.720291 49.663612,-1.719924 49.663287,-1.718955 49.662977,-1.718738 49.662835,-1.718426 49.662833,-1.717782 49.662933,-1.717135 49.662962,-1.716832 49.662963,-1.716417 49.662822,-1.71594 49.663033,-1.715681 49.663419,-1.715513 49.663576,-1.714658 49.664031,-1.714268 49.664322,-1.713784 49.664591,-1.713544 49.664674,-1.713182 49.66474,-1.712793 49.664734,-1.712209 49.664617,-1.711608 49.664535,-1.711089 49.664646,-1.710409 49.664717,-1.710433 49.664812,-1.710583 49.664942,-1.710734 49.664995,-1.710607 49.665091,-1.710115 49.665072,-1.71013 49.665139,-1.709572 49.665347,-1.709049 49.665466,-1.708584 49.665464,-1.707832 49.665414,-1.706815 49.665273,-1.706252 49.665164,-1.705838 49.664978,-1.705455 49.664945,-1.705484 49.665371,-1.705456 49.665754,-1.705378 49.666371,-1.705342 49.666773,-1.705206 49.668809,-1.705141 49.669226,-1.704711 49.670154,-1.704649 49.670256,-1.704539 49.670872,-1.704183 49.670769,-1.704178 49.670715,-1.703864 49.670619,-1.703726 49.670624,-1.703313 49.670505,-1.703244 49.670508,-1.702618 49.670334,-1.702516 49.670284,-1.701923 49.670172,-1.700863 49.669952,-1.700861 49.669934,-1.699647 49.669855,-1.699374 49.669901,-1.698781 49.669789,-1.697857 49.66969,-1.697318 49.669711,-1.696554 49.669784,-1.696222 49.669924,-1.695572 49.67003,-1.695056 49.670158,-1.694272 49.670378,-1.694222 49.670443,-1.693235 49.670868,-1.692859 49.671152,-1.692699 49.671222,-1.691959 49.671322,-1.69145 49.671522,-1.691383 49.671638,-1.691247 49.671698,-1.690344 49.671916,-1.690092 49.671954,-1.689262 49.672177,-1.688753 49.672375,-1.688503 49.672509,-1.688116 49.67283,-1.687987 49.673087,-1.687951 49.673295,-1.687689 49.673467,-1.687358 49.673786,-1.686998 49.673791,-1.686537 49.673602,-1.686575 49.673564,-1.685898 49.673293,-1.684267 49.672398,-1.683718 49.672132,-1.68328 49.671977,-1.682818 49.671918,-1.682693 49.672067,-1.682417 49.672239,-1.681999 49.672372,-1.681628 49.672405,-1.681264 49.672374,-1.680909 49.672279,-1.680573 49.672094,-1.680389 49.671903,-1.680285 49.671673,-1.680272 49.67153,-1.680332 49.671275,-1.680544 49.671015,-1.680887 49.670822,-1.680544 49.670503,-1.680328 49.670328,-1.679886 49.670041,-1.679562 49.670021,-1.679459 49.669908,-1.679344 49.669873,-1.678898 49.669854,-1.678363 49.669767,-1.67807 49.669742,-1.677434 49.669767,-1.668848 49.670979,-1.667287 49.671192,-1.66459 49.671584,-1.663398 49.671746,-1.663332 49.671632,-1.66355 49.671588,-1.663746 49.671607,-1.666896 49.671162,-1.668211 49.670986,-1.668187 49.670869,-1.668324 49.670855,-1.668348 49.670962,-1.669087 49.670862,-1.669048 49.670737,-1.6692 49.670723,-1.669223 49.67083,-1.669525 49.670791,-1.673427 49.670236,-1.674441 49.670098,-1.676658 49.669779,-1.678768 49.66949,-1.678794 49.669215,-1.678864 49.669225,-1.67884 49.669524,-1.678999 49.669743,-1.679349 49.669774,-1.679943 49.669598,-1.680003 49.66965,-1.679696 49.669779,-1.681588 49.669841,-1.681832 49.669939,-1.682059 49.670147,-1.682137 49.670387,-1.682053 49.670534,-1.681908 49.670459,-1.681574 49.670598,-1.681636 49.670676,-1.681918 49.670566,-1.682091 49.670641,-1.682278 49.671173,-1.682912 49.671284,-1.683422 49.671399,-1.683586 49.671366,-1.683729 49.671262,-1.685144 49.671414,-1.684836 49.671993,-1.685694 49.672581,-1.685936 49.672491,-1.686731 49.673,-1.686676 49.673605,-1.686765 49.673674,-1.686942 49.673631,-1.686998 49.673494,-1.687054 49.672889,-1.685477 49.671878,-1.685361 49.671361,-1.685256 49.671284,-1.683164 49.671004,-1.683093 49.67098,-1.68257 49.670568,-1.682482 49.670518,-1.682361 49.670108,-1.682261 49.669923,-1.681683 49.669675,-1.680192 49.669598,-1.68013 49.669528,-1.681054 49.669312,-1.681694 49.66918,-1.681626 49.668894,-1.681406 49.668912,-1.681397 49.668813,-1.680069 49.668855,-1.680122 49.668826,-1.68181 49.668779,-1.681822 49.668617,-1.681911 49.668523,-1.681832 49.668418,-1.682098 49.668444,-1.682462 49.668178,-1.682651 49.668126,-1.683025 49.668084,-1.683767 49.667813,-1.684011 49.667677,-1.684263 49.667253,-1.684379 49.666997,-1.68435 49.666683,-1.68424 49.666093,-1.684182 49.665906,-1.683939 49.665682,-1.683268 49.664861,-1.682864 49.664391,-1.682545 49.664088,-1.681454 49.663374,-1.680993 49.662879,-1.680247 49.66216,-1.680042 49.662186,-1.679519 49.66253,-1.679665 49.662318,-1.67931 49.66207,-1.679078 49.661962,-1.678448 49.66159,-1.677127 49.660795,-1.676352 49.660357,-1.67578 49.66001,-1.675543 49.659848,-1.675166 49.659664,-1.675074 49.659569,-1.674668 49.659377,-1.673994 49.65898,-1.673493 49.658658,-1.672776 49.658244,-1.672544 49.658136,-1.672072 49.657974,-1.671632 49.657865,-1.670889 49.657777,-1.670334 49.657771,-1.669293 49.65791,-1.669268 49.657938,-1.668658 49.658096,-1.668091 49.658109,-1.666989 49.658043,-1.666158 49.658048,-1.664188 49.658187,-1.663898 49.658198,-1.66381 49.658147,-1.663087 49.65813,-1.662241 49.658127,-1.661765 49.658082,-1.660275 49.65786,-1.659478 49.657783,-1.658645 49.657729,-1.657796 49.657725,-1.657355 49.657755,-1.656798 49.657848,-1.656345 49.657849,-1.655896 49.657828,-1.655482 49.657756,-1.655223 49.657649,-1.654907 49.657382,-1.654447 49.657048,-1.654188 49.656941,-1.653114 49.656568,-1.652915 49.656513,-1.652596 49.656516,-1.6526 49.656399,-1.652053 49.65633,-1.649265 49.656779,-1.647632 49.656967,-1.646796 49.657071,-1.64643 49.657778,-1.645667 49.658077,-1.64492 49.658403,-1.644283 49.658715,-1.644102 49.658866,-1.643653 49.658965,-1.643264 49.659105,-1.643086 49.65913,-1.642189 49.659174,-1.641745 49.659326,-1.641379 49.659421,-1.641247 49.659498,-1.640904 49.659529,-1.640752 49.65939,-1.64043 49.659502,-1.639975 49.659537,-1.639417 49.659648,-1.638495 49.659729,-1.638101 49.659816,-1.636682 49.659924,-1.636296 49.659939,-1.63598 49.659978,-1.635221 49.660016,-1.634358 49.66013,-1.633859 49.66014,-1.633534 49.660224,-1.63315 49.660266,-1.632434 49.660176,-1.631675 49.660061,-1.631124 49.659914,-1.630746 49.659986,-1.630332 49.660029,-1.629763 49.660012,-1.629316 49.659933,-1.627727 49.65973,-1.62322 49.659099,-1.617058 49.658246,-1.616241 49.658136,-1.616146 49.658089,-1.616175 49.657982,-1.616296 49.65795,-1.618472 49.658246,-1.623439 49.658912,-1.624143 49.659001,-1.624968 49.659122,-1.62788 49.659507,-1.629652 49.659762,-1.629702 49.659662,-1.629802 49.659217,-1.629908 49.658959,-1.629944 49.658776,-1.630339 49.657609,-1.630403 49.65748,-1.630404 49.657273,-1.630641 49.65732,-1.630865 49.656601,-1.630677 49.656578,-1.630748 49.656341,-1.63153 49.653929,-1.631539 49.653843,-1.631376 49.653749,-1.631288 49.653588,-1.631419 49.65338,-1.631683 49.653277,-1.632751 49.653281,-1.632782 49.6533,-1.632981 49.653869,-1.633469 49.654069,-1.63426 49.653949,-1.634529 49.653944,-1.634577 49.654079,-1.634983 49.654022,-1.634935 49.653882,-1.635181 49.653813,-1.636271 49.653649,-1.635948 49.652734,-1.635923 49.652533,-1.636111 49.652505,-1.635995 49.652177,-1.635783 49.652181,-1.635718 49.652,-1.635612 49.651865,-1.63558 49.651686,-1.635368 49.651086,-1.635231 49.651087,-1.634313 49.651222,-1.633934 49.65131,-1.633986 49.651462,-1.633818 49.65149,-1.633849 49.651586,-1.633462 49.651644,-1.633422 49.651548,-1.633255 49.651573,-1.633193 49.65141,-1.632578 49.651509,-1.632261 49.651818,-1.632462 49.652385,-1.632447 49.652406,-1.631488 49.652712,-1.631278 49.652725,-1.631072 49.65268,-1.630905 49.652552,-1.63087 49.652465,-1.629314 49.652565,-1.627893 49.652639,-1.627753 49.652477,-1.627266 49.652042,-1.627122 49.651765,-1.626755 49.650724,-1.626571 49.650236,-1.626262 49.650259,-1.626007 49.650245,-1.625554 49.650155,-1.625274 49.650035,-1.625143 49.649905,-1.625199 49.649832,-1.625375 49.649888,-1.625806 49.65009,-1.626202 49.65016,-1.626746 49.650044,-1.628295 49.64979,-1.628492 49.649651,-1.628765 49.64962,-1.628685 49.649419,-1.628422 49.649455,-1.628392 49.649369,-1.627403 49.64941,-1.627251 49.649367,-1.627154 49.649192,-1.627525 49.648625,-1.628087 49.648641,-1.62832 49.647573,-1.627804 49.647526,-1.627435 49.648151,-1.62732 49.648122,-1.626802 49.649018,-1.626581 49.649087,-1.6263 49.648983,-1.626169 49.649122,-1.626049 49.649084,-1.626112 49.648806,-1.62624 49.648604,-1.625962 49.648425,-1.625912 49.648248,-1.625939 49.648102,-1.626385 49.648031,-1.626298 49.647811,-1.626079 49.647703,-1.624906 49.647417,-1.62222 49.648848,-1.620385 49.648659,-1.619177 49.647984,-1.61916 49.647891,-1.619358 49.647841,-1.619511 49.647929,-1.619587 49.648136,-1.620425 49.648602,-1.622018 49.648772,-1.623019 49.648041,-1.624072 49.647263,-1.625112 49.646503,-1.624087 49.645894,-1.62397 49.645979,-1.623605 49.645777,-1.623613 49.645714,-1.62333 49.645556,-1.623399 49.645497,-1.623521 49.644844,-1.623468 49.64472,-1.622629 49.644644,-1.621751 49.644588,-1.620871 49.644513,-1.620257 49.644473,-1.620083 49.644381,-1.620165 49.64391,-1.619859 49.643894,-1.619821 49.6444,-1.619654 49.644388,-1.619882 49.643074,-1.619991 49.642908,-1.620147 49.642794,-1.620456 49.642684,-1.620676 49.642666,-1.621794 49.642759,-1.621824 49.642631,-1.621083 49.642561,-1.621086 49.642444,-1.621326 49.642488,-1.622234 49.642571,-1.622422 49.642501,-1.622302 49.642397,-1.621379 49.642315,-1.621116 49.642316,-1.620898 49.642199,-1.620997 49.641763,-1.620257 49.641701,-1.620285 49.641556,-1.621012 49.641618,-1.621082 49.641327,-1.621354 49.640039,-1.621098 49.6395,-1.620842 49.639428,-1.620621 49.639437,-1.620655 49.639214,-1.620448 49.6392,-1.620402 49.639412,-1.620244 49.639406,-1.620271 49.639243,-1.62009 49.639241,-1.62004 49.639318,-1.619866 49.639305,-1.619216 49.639382,-1.618905 49.639778,-1.618783 49.640586,-1.618629 49.640578,-1.618511 49.641387,-1.618399 49.642006,-1.618529 49.642012,-1.618464 49.642496,-1.618311 49.642494,-1.618278 49.642811,-1.618813 49.642908,-1.619121 49.642941,-1.619211 49.64256,-1.619309 49.642565,-1.618648 49.646162,-1.61868 49.646352,-1.618616 49.646583,-1.618407 49.646551,-1.618051 49.648599,-1.617156 49.648669,-1.617186 49.648848,-1.616608 49.648897,-1.61655 49.648863,-1.615574 49.643724,-1.615471 49.643197,-1.615347 49.643211,-1.615401 49.643497,-1.615504 49.643565,-1.615552 49.643788,-1.615139 49.643822,-1.615104 49.643589,-1.615231 49.643458,-1.615182 49.643226,-1.615086 49.643239,-1.614918 49.643065,-1.614465 49.643109,-1.613922 49.643238,-1.613479 49.643399,-1.6131 49.643503,-1.612743 49.643841,-1.612686 49.643978,-1.612786 49.644163,-1.61253 49.644245,-1.612702 49.644973,-1.61306 49.646907,-1.613116 49.646905,-1.613461 49.648737,-1.613298 49.64877,-1.612029 49.648865,-1.611634 49.646766,-1.611042 49.646813,-1.610254 49.646843,-1.610251 49.646807,-1.609948 49.646206,-1.609786 49.645339,-1.60953 49.644035,-1.608938 49.644075,-1.608764 49.644145,-1.608142 49.644628,-1.608068 49.644729,-1.608092 49.644836,-1.608313 49.644828,-1.608734 49.647044,-1.608459 49.647073,-1.608274 49.64609,-1.608257 49.646063,-1.607185 49.646158,-1.607118 49.646188,-1.60667 49.647222,-1.606205 49.64713,-1.606631 49.64617,-1.606331 49.646226,-1.605892 49.64627,-1.605688 49.646161,-1.605563 49.646157,-1.604021 49.646278,-1.602839 49.646395,-1.602626 49.646493,-1.603315 49.649995,-1.603194 49.650036,-1.602794 49.65006,-1.60273 49.650116,-1.602836 49.650517,-1.602939 49.650748,-1.604555 49.650625,-1.604823 49.65198,-1.605272 49.65419,-1.605582 49.655802,-1.605143 49.655831,-1.605227 49.656296,-1.60539 49.656415,-1.605577 49.656489,-1.60635 49.656604,-1.60633 49.656695,-1.605347 49.656552,-1.605253 49.656583,-1.605423 49.657548,-1.605625 49.658414,-1.605469 49.658528,-1.604421 49.6589,-1.602679 49.65957,-1.602114 49.659771,-1.601633 49.659969,-1.601203 49.660121,-1.600399 49.66043,-1.599996 49.660571,-1.599867 49.660531,-1.599528 49.660301,-1.598489 49.659539,-1.597822 49.65906,-1.596722 49.658247,-1.596176 49.657872,-1.59564 49.65746,-1.595004 49.657016,-1.594305 49.656493,-1.592733 49.655355,-1.592434 49.655115,-1.592175 49.654854,-1.590369 49.653266,-1.589423 49.652456,-1.589406 49.652421,-1.590401 49.65223,-1.590331 49.652062,-1.589412 49.65216,-1.589308 49.6521,-1.588943 49.652051,-1.588666 49.652053,-1.587906 49.651613,-1.58729 49.651241,-1.586966 49.651028,-1.586798 49.651007,-1.586494 49.651172,-1.586369 49.651167,-1.586077 49.651313,-1.586017 49.651415,-1.585302 49.651793,-1.584821 49.652,-1.58466 49.651907,-1.584464 49.651725,-1.584382 49.651737,-1.584464 49.652002,-1.584391 49.652013,-1.584284 49.651732,-1.584033 49.651715,-1.583162 49.651891,-1.582803 49.651905,-1.582368 49.652011,-1.582292 49.652086,-1.582349 49.652264,-1.581542 49.652376,-1.581615 49.65258,-1.584628 49.65216,-1.585124 49.652591,-1.585783 49.653143,-1.588099 49.652686,-1.588129 49.652712,-1.585528 49.653233,-1.584687 49.652509,-1.584453 49.652536,-1.583433 49.652907,-1.583261 49.652995,-1.582937 49.653097,-1.582508 49.653266,-1.581967 49.653413,-1.580809 49.653645,-1.580686 49.653659,-1.579951 49.653813,-1.579073 49.654233,-1.578722 49.654336,-1.578449 49.654382,-1.578063 49.654406,-1.577682 49.654483,-1.577317 49.654596,-1.57697 49.654744,-1.57632 49.654913,-1.575654 49.655064,-1.575349 49.655066,-1.575208 49.655198,-1.574745 49.655287,-1.574395 49.655408,-1.573162 49.655725,-1.572366 49.655971,-1.572194 49.656058,-1.572071 49.656234,-1.571802 49.656334,-1.571101 49.656405,-1.570202 49.656583,-1.570048 49.656562,-1.569947 49.656674,-1.57055 49.659396,-1.570698 49.659958,-1.570587 49.659962,-1.570574 49.659818,-1.569951 49.657025,-1.569698 49.657036,-1.56917 49.656994,-1.568482 49.656913,-1.568147 49.656858,-1.568083 49.657077,-1.568 49.657071,-1.568058 49.65679,-1.567564 49.656691,-1.567343 49.656709,-1.567283 49.656648,-1.566904 49.656599,-1.566334 49.656584,-1.565752 49.656435,-1.564123 49.656047,-1.563455 49.655856,-1.563373 49.655877,-1.562691 49.655686,-1.562082 49.655538,-1.561867 49.655465,-1.561371 49.65534,-1.56073 49.655148,-1.560063 49.654975,-1.559854 49.654965,-1.559436 49.654791,-1.558714 49.65462,-1.55871 49.654451,-1.558512 49.65439,-1.557508 49.654212,-1.557023 49.6541,-1.555927 49.653964,-1.555239 49.653898,-1.555062 49.653929,-1.554495 49.653951,-1.554395 49.654071,-1.553518 49.654338,-1.552949 49.654495,-1.552025 49.6547,-1.55182 49.655203,-1.551631 49.655264,-1.551326 49.655257,-1.550419 49.655192,-1.549292 49.655145,-1.548885 49.655097,-1.548741 49.655039,-1.548433 49.654997,-1.547652 49.654945,-1.547488 49.654816,-1.549033 49.654893,-1.55033 49.654971,-1.550813 49.654953,-1.551363 49.655058,-1.551513 49.654872,-1.551512 49.654701,-1.551096 49.654546,-1.548686 49.654414,-1.548773 49.654112,-1.548924 49.653094,-1.548858 49.651937,-1.548865 49.651869,-1.548784 49.650897,-1.548736 49.649968,-1.548701 49.649789,-1.548365 49.649663,-1.547588 49.649576,-1.547144 49.649616,-1.546561 49.649716,-1.546203 49.649759,-1.545773 49.649933,-1.545413 49.650025,-1.545257 49.650161,-1.54518 49.650446,-1.545059 49.650726,-1.544337 49.650491,-1.543934 49.650282,-1.543615 49.650171,-1.54296 49.65005,-1.542413 49.649907,-1.541992 49.649871,-1.541845 49.649887,-1.541603 49.649974,-1.541076 49.650206,-1.540613 49.65021,-1.540177 49.650139,-1.539784 49.65011,-1.539691 49.649483,-1.539631 49.649203,-1.5395 49.648979,-1.539292 49.648713,-1.539021 49.64851,-1.53852 49.648179,-1.537842 49.647846,-1.537539 49.647601,-1.53728 49.647199,-1.536525 49.64608,-1.536332 49.645881,-1.536055 49.64539,-1.535784 49.644817,-1.535499 49.644623,-1.534977 49.64353,-1.534943 49.643422,-1.534623 49.643222,-1.53457 49.643097,-1.53464 49.642905,-1.534648 49.642659,-1.534696 49.642504,-1.535354 49.641903,-1.535456 49.641848,-1.535578 49.64166,-1.535623 49.641434,-1.535432 49.641137,-1.535417 49.641012,-1.535519 49.640857,-1.536044 49.640458,-1.536118 49.640291,-1.536134 49.640125,-1.536093 49.639823,-1.53602 49.639594,-1.536128 49.639228,-1.536375 49.638746,-1.53653 49.638573,-1.536498 49.638214,-1.536419 49.637796,-1.536357 49.637603,-1.535812 49.637698,-1.535142 49.637673,-1.534881 49.637634,-1.534893 49.637042,-1.534939 49.63687,-1.535263 49.636414,-1.535343 49.636237,-1.535393 49.635843,-1.535564 49.635535,-1.535378 49.635345,-1.53484 49.634935,-1.534694 49.634841,-1.534499 49.634781,-1.534256 49.634659,-1.533977 49.634443,-1.533763 49.634167,-1.533596 49.633772,-1.533585 49.633566,-1.533741 49.633116,-1.533995 49.632598,-1.534339 49.632225,-1.534583 49.631987,-1.535184 49.631462,-1.535322 49.631223,-1.535534 49.630676,-1.535665 49.630272,-1.535801 49.629762,-1.535826 49.629448,-1.535874 49.629277,-1.536411 49.629411,-1.537237 49.629561,-1.538609 49.629736,-1.539323 49.62987,-1.540217 49.630015,-1.542677 49.630692,-1.543094 49.630775,-1.544059 49.63079,-1.544491 49.63077,-1.544815 49.63073,-1.545636 49.63058,-1.546461 49.630474,-1.546944 49.630397,-1.547109 49.630395,-1.547276 49.629305,-1.547363 49.628295,-1.547316 49.627991,-1.546854 49.626865,-1.546494 49.625947,-1.546208 49.624507,-1.546178 49.624278,-1.548763 49.623676,-1.5486 49.62351,-1.550917 49.621865,-1.551191 49.621654,-1.552069 49.620918,-1.552272 49.620728,-1.55258 49.620491,-1.553471 49.619963,-1.554254 49.619557,-1.554862 49.619199,-1.555124 49.618955,-1.555357 49.618626,-1.555184 49.618306,-1.554832 49.618006,-1.554629 49.617607,-1.554191 49.617355,-1.553577 49.617025,-1.552739 49.616388,-1.552516 49.616201,-1.551976 49.61583,-1.5518 49.615653,-1.551628 49.615546,-1.551066 49.61541,-1.550757 49.615317,-1.550369 49.615143,-1.550268 49.615055,-1.550082 49.614673,-1.549389 49.613669,-1.549228 49.613592,-1.548859 49.613095,-1.548668 49.613019,-1.54821 49.612743,-1.547778 49.612504,-1.547029 49.612175,-1.546454 49.611836,-1.546479 49.611722,-1.546736 49.611358,-1.546948 49.611156,-1.547129 49.610841,-1.547407 49.610118,-1.547637 49.609595,-1.547849 49.609386,-1.547772 49.609244,-1.547736 49.608981,-1.547734 49.608621,-1.547731 49.607879,-1.547763 49.607675,-1.547876 49.607373,-1.548047 49.60701,-1.54878 49.60568,-1.548871 49.605603,-1.549544 49.605151,-1.55018 49.604543,-1.550553 49.604125,-1.550999 49.603656,-1.551519 49.603,-1.551683 49.602736,-1.551648 49.602089,-1.551621 49.601206,-1.55162 49.600606,-1.551645 49.600263,-1.551622 49.600118,-1.551762 49.59984,-1.552038 49.599445,-1.552456 49.59892,-1.552701 49.598653,-1.552949 49.598339,-1.553132 49.598154,-1.553464 49.597732,-1.554006 49.597163,-1.554423 49.596679,-1.554716 49.59631,-1.554867 49.596021,-1.555352 49.595257,-1.55553 49.594957,-1.555946 49.594481,-1.5562 49.594075,-1.556234 49.593977,-1.556481 49.592832,-1.556567 49.592572,-1.557203 49.591936,-1.557732 49.591463,-1.558295 49.590933,-1.558427 49.590857,-1.559409 49.590566,-1.557434 49.589155,-1.556362 49.588372,-1.556187 49.588405,-1.555071 49.587616,-1.552195 49.585543,-1.552025 49.585583,-1.551717 49.585556,-1.551572 49.585481,-1.551435 49.585289,-1.551455 49.585127,-1.551558 49.585044,-1.55195 49.584963,-1.552189 49.58501,-1.55237 49.585149,-1.553879 49.584927,-1.561774 49.583797,-1.561752 49.583722,-1.563228 49.583515,-1.563734 49.583523,-1.563943 49.583503,-1.564026 49.583241,-1.564394 49.582207,-1.564658 49.581496,-1.564745 49.581208,-1.564767 49.581018,-1.564925 49.580919,-1.565081 49.580694,-1.565146 49.58069,-1.566565 49.580743,-1.566817 49.580781,-1.568427 49.580985,-1.568273 49.581391,-1.568689 49.581328,-1.568825 49.581418,-1.569044 49.581328,-1.569299 49.581277,-1.569395 49.581202,-1.569663 49.581258,-1.570178 49.581466,-1.570132 49.581584,-1.570323 49.581699,-1.570121 49.581884,-1.570184 49.582033,-1.570434 49.582151,-1.570733 49.582119,-1.570703 49.582028,-1.570865 49.58201,-1.571026 49.582157,-1.571255 49.582129,-1.571678 49.582386,-1.571784 49.582526,-1.572045 49.582607,-1.572245 49.582556,-1.572757 49.582705,-1.573194 49.582606,-1.573387 49.582504,-1.57371 49.582444,-1.573599 49.582628,-1.57431 49.583046,-1.574876 49.583151,-1.575015 49.583219,-1.575647 49.583937,-1.575836 49.584188,-1.576493 49.584579,-1.577494 49.585065,-1.577705 49.584995,-1.577686 49.585186,-1.577888 49.585306,-1.578242 49.585404,-1.57844 49.58537,-1.578925 49.5856,-1.579047 49.585682,-1.579009 49.585846,-1.578944 49.586458,-1.578981 49.58656,-1.579399 49.58684,-1.579678 49.587112,-1.580022 49.587796,-1.580367 49.588206,-1.580566 49.588767,-1.580858 49.58943,-1.580987 49.589763,-1.58104 49.589996,-1.581142 49.590228,-1.581022 49.590387,-1.581078 49.590601,-1.580538 49.590841,-1.580412 49.591198,-1.580526 49.591471,-1.580733 49.591695,-1.580791 49.591859,-1.580817 49.592805,-1.580753 49.593264,-1.580686 49.594046,-1.580768 49.594066,-1.581652 49.594094,-1.581848 49.594206,-1.582148 49.594016,-1.582158 49.593929,-1.582605 49.593671,-1.582911 49.593593,-1.583351 49.593547,-1.583643 49.593559,-1.584365 49.593726,-1.584745 49.593773,-1.585319 49.593661,-1.585797 49.593604,-1.587039 49.5931,-1.587171 49.593058,-1.589895 49.59251,-1.590431 49.592477,-1.590944 49.59233,-1.591988 49.592081,-1.593528 49.591773,-1.596066 49.591461,-1.595751 49.592738,-1.595736 49.592927,-1.595626 49.593442,-1.595592 49.59376,-1.595618 49.593967,-1.595844 49.594823,-1.596072 49.595572,-1.596239 49.596068,-1.596416 49.596673,-1.596768 49.597775,-1.597295 49.59958,-1.601108 49.59997,-1.601704 49.600043,-1.601821 49.59925)),((-1.584345 49.669291,-1.584438 49.669395,-1.584652 49.669774,-1.584735 49.669771,-1.584841 49.670028,-1.5848 49.670345,-1.584518 49.670598,-1.584277 49.670678,-1.583932 49.670719,-1.583606 49.670642,-1.582892 49.670569,-1.582779 49.670538,-1.58257 49.670375,-1.582503 49.670251,-1.582564 49.67015,-1.582766 49.670088,-1.582892 49.670101,-1.582784 49.669665,-1.582182 49.669444,-1.582205 49.669398,-1.581459 49.66912,-1.581218 49.669219,-1.581135 49.669214,-1.580851 49.66899,-1.580842 49.668892,-1.580425 49.668727,-1.579207 49.668278,-1.577857 49.667762,-1.576394 49.667223,-1.574442 49.666486,-1.573825 49.666249,-1.573565 49.666132,-1.573229 49.665947,-1.572609 49.66552,-1.572321 49.665252,-1.571873 49.664738,-1.571742 49.664509,-1.571501 49.663987,-1.571135 49.662372,-1.570783 49.660756,-1.570852 49.660753,-1.57143 49.663351,-1.571565 49.663922,-1.571641 49.664153,-1.571925 49.6647,-1.57236 49.665215,-1.572647 49.665483,-1.573165 49.66585,-1.573661 49.66612,-1.574021 49.666277,-1.574451 49.666432,-1.575428 49.666809,-1.576432 49.667177,-1.576719 49.667292,-1.578569 49.667978,-1.579272 49.668231,-1.580018 49.668518,-1.58108 49.66891,-1.582243 49.669361,-1.582607 49.668933,-1.582651 49.668958,-1.582287 49.669377,-1.583133 49.669696,-1.583393 49.669651,-1.583306 49.669456,-1.583172 49.669353,-1.583249 49.669287,-1.583399 49.669407,-1.583515 49.669619,-1.583583 49.669607,-1.583948 49.669189,-1.582944 49.668821,-1.582968 49.668784,-1.583987 49.66916,-1.584065 49.669265,-1.584345 49.669291)),((-1.665564 49.670556,-1.665407 49.670652,-1.664872 49.670718,-1.664507 49.670669,-1.664008 49.670373,-1.663959 49.670285,-1.663988 49.670149,-1.66409 49.670055,-1.664377 49.670008,-1.664872 49.670115,-1.664941 49.66995,-1.664488 49.669859,-1.66454 49.669821,-1.664993 49.669912,-1.664958 49.670138,-1.665454 49.670254,-1.665603 49.670375,-1.665564 49.670556)),((-1.647879 49.67451,-1.647583 49.674612,-1.647332 49.674594,-1.646956 49.67442,-1.646686 49.674349,-1.646336 49.674317,-1.645546 49.67432,-1.644269 49.674306,-1.641674 49.674297,-1.640313 49.674277,-1.639009 49.674273,-1.637745 49.674258,-1.635053 49.674244,-1.632178 49.674201,-1.630482 49.674157,-1.627357 49.674105,-1.625299 49.674057,-1.624355 49.674048,-1.622444 49.673999,-1.621742 49.673986,-1.621316 49.674029,-1.620689 49.673999,-1.620246 49.674007,-1.619698 49.674082,-1.61943 49.674182,-1.61899 49.674225,-1.618612 49.674186,-1.61824 49.674056,-1.618118 49.673935,-1.617829 49.673811,-1.617461 49.673725,-1.615357 49.673472,-1.613739 49.673285,-1.611895 49.673064,-1.610816 49.672943,-1.6094 49.672771,-1.605085 49.672265,-1.60197 49.671892,-1.59967 49.67161,-1.599257 49.671643,-1.599245 49.671824,-1.598607 49.671821,-1.598407 49.671757,-1.598129 49.671434,-1.5982 49.671305,-1.598409 49.671162,-1.598726 49.671132,-1.598908 49.671153,-1.599123 49.671234,-1.599247 49.671383,-1.599258 49.671499,-1.599661 49.671511,-1.599665 49.67125,-1.600237 49.671588,-1.601372 49.671716,-1.603641 49.671987,-1.613274 49.673128,-1.615644 49.673416,-1.617101 49.673586,-1.617195 49.673394,-1.617329 49.673343,-1.618069 49.673549,-1.618045 49.673586,-1.617292 49.67339,-1.617214 49.6736,-1.61811 49.673692,-1.61823 49.673642,-1.618453 49.673652,-1.618736 49.67356,-1.619322 49.673601,-1.619441 49.673695,-1.619707 49.673721,-1.619939 49.673829,-1.620731 49.673844,-1.620728 49.673655,-1.62063 49.67365,-1.619972 49.673729,-1.619967 49.673675,-1.620639 49.673596,-1.620781 49.673635,-1.620843 49.673858,-1.621997 49.673886,-1.625317 49.673949,-1.625985 49.673968,-1.628431 49.674019,-1.629153 49.674028,-1.630084 49.674055,-1.630932 49.674068,-1.632308 49.674106,-1.633364 49.674119,-1.633614 49.673975,-1.634615 49.674,-1.634836 49.674144,-1.637417 49.674154,-1.641775 49.674185,-1.643552 49.674208,-1.644551 49.674205,-1.645981 49.674223,-1.646504 49.674032,-1.646698 49.674024,-1.646605 49.674226,-1.646826 49.674217,-1.646881 49.674359,-1.647002 49.674319,-1.647018 49.674183,-1.647144 49.674052,-1.646848 49.673839,-1.646886 49.673801,-1.647183 49.674024,-1.647454 49.67395,-1.647678 49.673969,-1.647957 49.674147,-1.648003 49.674343,-1.647879 49.67451)))"
]

View formatted query View runnable query Explain query View query backtrace

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 -> 'shop') = 'vacant'
    OR EXISTS (
      SELECT
        1
      FROM
        unnest(
          akeys(tags)
        ) k
      WHERE
        k LIKE 'was:%'
    )
  )

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(((-1.601821 49.59925,-1.604145 49.59961,-1.604544 49.599366,-1.605194 49.59954,-1.605149 49.599622,-1.605685 49.599789,-1.606678 49.600398,-1.610467 49.601754,-1.610684 49.601697,-1.611121 49.601953,-1.611486 49.602198,-1.611705 49.602282,-1.612107 49.602503,-1.612362 49.602481,-1.612691 49.602539,-1.613299 49.602711,-1.613487 49.602878,-1.613672 49.602894,-1.613792 49.602983,-1.614082 49.603116,-1.614262 49.603404,-1.614587 49.603737,-1.614907 49.603666,-1.614947 49.60381,-1.615489 49.604187,-1.616252 49.604536,-1.616492 49.604626,-1.616542 49.604749,-1.616872 49.604907,-1.61723 49.605031,-1.61751 49.605285,-1.617766 49.605388,-1.617884 49.605472,-1.617888 49.605557,-1.618076 49.605584,-1.618223 49.605722,-1.618726 49.606061,-1.6189 49.606115,-1.619648 49.606408,-1.619752 49.606486,-1.619856 49.606816,-1.620009 49.606947,-1.620397 49.607111,-1.620523 49.607019,-1.62079 49.607153,-1.621017 49.607128,-1.622041 49.60786,-1.622296 49.608185,-1.622864 49.608312,-1.623396 49.608488,-1.623831 49.608678,-1.624132 49.608857,-1.624508 49.608944,-1.624881 49.608985,-1.625379 49.608995,-1.625954 49.608876,-1.626493 49.609109,-1.627043 49.609372,-1.627672 49.609711,-1.628031 49.609961,-1.628405 49.610092,-1.628905 49.610153,-1.629248 49.610158,-1.62952 49.610121,-1.630234 49.609924,-1.63059 49.60975,-1.631219 49.609744,-1.631464 49.609577,-1.632263 49.609742,-1.632495 49.609906,-1.63271 49.60997,-1.632775 49.610046,-1.633023 49.609948,-1.633413 49.610008,-1.633612 49.609988,-1.633994 49.610009,-1.634453 49.610074,-1.634554 49.610246,-1.634731 49.610252,-1.635917 49.610518,-1.636257 49.61062,-1.636619 49.610643,-1.636779 49.610678,-1.637187 49.610865,-1.637939 49.611066,-1.638319 49.61125,-1.638544 49.611208,-1.638835 49.610754,-1.639417 49.6107,-1.639744 49.61071,-1.63995 49.610751,-1.640623 49.610831,-1.641559 49.611006,-1.641524 49.611471,-1.641656 49.611607,-1.64153 49.611822,-1.642366 49.6123,-1.642826 49.612529,-1.642987 49.612687,-1.643347 49.612726,-1.643838 49.612961,-1.643971 49.613044,-1.643946 49.61319,-1.644175 49.613193,-1.644589 49.613622,-1.644799 49.613934,-1.644742 49.614055,-1.644803 49.614195,-1.645064 49.614352,-1.644947 49.614501,-1.64572 49.61506,-1.645874 49.615191,-1.646024 49.615144,-1.646273 49.615235,-1.646567 49.614991,-1.646726 49.614776,-1.646734 49.614358,-1.646591 49.614067,-1.646569 49.613943,-1.646635 49.613808,-1.647257 49.613559,-1.647634 49.613465,-1.647905 49.613451,-1.648362 49.613297,-1.648565 49.613092,-1.648962 49.612985,-1.649131 49.612856,-1.649061 49.612707,-1.649088 49.612561,-1.64924 49.612415,-1.649643 49.612246,-1.649726 49.612141,-1.649953 49.61205,-1.65028 49.611991,-1.650448 49.611912,-1.650747 49.611561,-1.65092 49.611528,-1.651297 49.611627,-1.651554 49.611618,-1.651816 49.61153,-1.652016 49.611162,-1.652355 49.61099,-1.652635 49.610801,-1.652795 49.610754,-1.652985 49.610807,-1.653145 49.610796,-1.653178 49.610631,-1.65333 49.610568,-1.65352 49.610318,-1.653962 49.610096,-1.654236 49.610046,-1.654363 49.610116,-1.654854 49.610033,-1.655312 49.609807,-1.655559 49.609759,-1.655912 49.609747,-1.656243 49.609565,-1.656684 49.609558,-1.656913 49.609483,-1.657262 49.609211,-1.657976 49.60887,-1.658336 49.60877,-1.6589 49.608699,-1.659422 49.608693,-1.659857 49.608711,-1.660181 49.608866,-1.660301 49.609056,-1.660926 49.609167,-1.661297 49.609204,-1.661562 49.609268,-1.661847 49.609266,-1.662169 49.609159,-1.662625 49.608866,-1.662852 49.608635,-1.663268 49.608444,-1.663994 49.608399,-1.66444 49.608404,-1.66454 49.608373,-1.664801 49.608512,-1.665349 49.608769,-1.66512 49.608957,-1.66555 49.609131,-1.66642 49.609433,-1.666213 49.609861,-1.666969 49.610063,-1.667319 49.610188,-1.668147 49.610363,-1.668631 49.610502,-1.669221 49.610641,-1.669388 49.610651,-1.669736 49.610754,-1.669882 49.610595,-1.670271 49.610835,-1.670762 49.611014,-1.67142 49.611297,-1.671878 49.611443,-1.672023 49.611435,-1.672298 49.611536,-1.672052 49.611647,-1.671269 49.611946,-1.671948 49.612379,-1.671908 49.612534,-1.671595 49.612458,-1.671354 49.612445,-1.67113 49.612473,-1.670719 49.612591,-1.670215 49.612788,-1.669928 49.613091,-1.669784 49.613397,-1.669381 49.613288,-1.668923 49.613682,-1.669254 49.613844,-1.669174 49.613909,-1.669016 49.614304,-1.669058 49.614343,-1.668708 49.614476,-1.667824 49.614636,-1.668608 49.615487,-1.667096 49.615846,-1.667262 49.616087,-1.667512 49.61635,-1.668186 49.61698,-1.668414 49.617213,-1.667993 49.617336,-1.667582 49.6175,-1.666648 49.618146,-1.666159 49.618291,-1.66502 49.618518,-1.664111 49.618737,-1.663294 49.618965,-1.662518 49.619312,-1.661705 49.619559,-1.662259 49.620404,-1.662768 49.62125,-1.663322 49.621083,-1.664007 49.620853,-1.664752 49.620618,-1.664929 49.620738,-1.66551 49.620988,-1.665808 49.621219,-1.666106 49.621606,-1.666592 49.622064,-1.667311 49.62264,-1.667786 49.623056,-1.668 49.623345,-1.668265 49.623752,-1.668636 49.624211,-1.668999 49.624361,-1.66935 49.624401,-1.670145 49.625115,-1.670367 49.625404,-1.670537 49.626092,-1.670582 49.626209,-1.670484 49.626522,-1.6705 49.626815,-1.67062 49.627033,-1.670926 49.627254,-1.671367 49.627403,-1.672131 49.627593,-1.672546 49.627649,-1.672835 49.62755,-1.673565 49.627743,-1.674617 49.627965,-1.675191 49.628049,-1.675858 49.628115,-1.676119 49.628109,-1.67679 49.627924,-1.676915 49.62791,-1.676884 49.628094,-1.676998 49.62856,-1.677115 49.62877,-1.677221 49.628808,-1.677567 49.628744,-1.677685 49.629182,-1.677806 49.629456,-1.677806 49.629571,-1.677945 49.629811,-1.678053 49.630249,-1.678262 49.630462,-1.67822 49.630803,-1.678162 49.631006,-1.678293 49.631041,-1.678803 49.630958,-1.67904 49.630959,-1.679606 49.630745,-1.679906 49.630658,-1.67997 49.630586,-1.680187 49.630618,-1.680565 49.630438,-1.6808 49.630424,-1.680931 49.630353,-1.681132 49.630156,-1.681288 49.630049,-1.681476 49.629984,-1.681673 49.62983,-1.682079 49.629698,-1.68284 49.629223,-1.683046 49.629138,-1.683131 49.628954,-1.684002 49.6286,-1.684283 49.628606,-1.684666 49.628426,-1.68528 49.628252,-1.685589 49.628137,-1.685742 49.628028,-1.685756 49.627912,-1.685982 49.628041,-1.686172 49.628005,-1.686133 49.628195,-1.686198 49.628426,-1.686517 49.628444,-1.686847 49.628732,-1.687142 49.629096,-1.687712 49.629698,-1.68805 49.629984,-1.688299 49.630088,-1.688184 49.63027,-1.687835 49.630527,-1.688345 49.630912,-1.688621 49.631157,-1.689176 49.631691,-1.689493 49.63194,-1.689891 49.632194,-1.690501 49.632493,-1.690984 49.632673,-1.690908 49.632862,-1.69094 49.633185,-1.69089 49.633475,-1.691002 49.633725,-1.690925 49.633995,-1.691119 49.634222,-1.691707 49.634419,-1.691789 49.634468,-1.69209 49.63432,-1.692741 49.63466,-1.69289 49.634805,-1.693279 49.634984,-1.693864 49.635178,-1.694675 49.635529,-1.694916 49.635618,-1.695284 49.6354,-1.695454 49.635255,-1.695945 49.634943,-1.696519 49.635207,-1.696953 49.635353,-1.697183 49.635235,-1.697894 49.635767,-1.698455 49.636241,-1.698524 49.63636,-1.698088 49.636544,-1.698438 49.636899,-1.698655 49.636743,-1.698997 49.636619,-1.699321 49.636388,-1.699348 49.636318,-1.699712 49.636117,-1.699908 49.635895,-1.700309 49.635592,-1.701192 49.635267,-1.70135 49.635136,-1.701603 49.635148,-1.701778 49.635036,-1.701728 49.634934,-1.702234 49.634675,-1.702585 49.634532,-1.702717 49.634342,-1.703237 49.6343,-1.70363 49.63424,-1.704315 49.63411,-1.704564 49.634215,-1.704777 49.634181,-1.705002 49.634002,-1.70508 49.633869,-1.705069 49.633766,-1.70519 49.633736,-1.705314 49.633532,-1.705492 49.633508,-1.705997 49.633356,-1.707119 49.632851,-1.707942 49.632442,-1.707956 49.632345,-1.708287 49.632205,-1.708599 49.632016,-1.709202 49.631694,-1.709704 49.631627,-1.709942 49.631516,-1.710393 49.631253,-1.71029 49.631139,-1.710327 49.631013,-1.710648 49.630771,-1.710945 49.630612,-1.711293 49.630501,-1.711459 49.630408,-1.711513 49.630301,-1.711665 49.630193,-1.71197 49.630058,-1.712786 49.629639,-1.712769 49.629556,-1.713223 49.629359,-1.713393 49.629485,-1.714118 49.629078,-1.714043 49.628958,-1.714134 49.628773,-1.714754 49.628647,-1.715424 49.62833,-1.716236 49.627861,-1.71679 49.627576,-1.717089 49.627406,-1.717904 49.626998,-1.71817 49.626967,-1.718337 49.626991,-1.718421 49.626896,-1.71853 49.626377,-1.718546 49.626205,-1.718807 49.626183,-1.719481 49.626231,-1.720055 49.626355,-1.720801 49.626587,-1.721336 49.626738,-1.721442 49.626644,-1.722095 49.626217,-1.72221 49.626204,-1.722716 49.626015,-1.722897 49.626146,-1.723865 49.626792,-1.724207 49.627039,-1.724565 49.627267,-1.724436 49.627367,-1.723486 49.628273,-1.72379 49.628391,-1.723686 49.628539,-1.723105 49.628924,-1.722899 49.628841,-1.722765 49.628879,-1.722617 49.629032,-1.72192 49.629931,-1.721844 49.629945,-1.721163 49.62973,-1.72082 49.630163,-1.720711 49.630274,-1.720256 49.630851,-1.720101 49.631096,-1.720043 49.631495,-1.71974 49.631882,-1.719628 49.631994,-1.71963 49.632217,-1.719584 49.632751,-1.719518 49.63288,-1.719291 49.633064,-1.719263 49.63319,-1.719094 49.633346,-1.719151 49.633572,-1.719174 49.633849,-1.718987 49.634065,-1.718668 49.634201,-1.718448 49.634725,-1.718316 49.634813,-1.718179 49.635074,-1.718003 49.635278,-1.717645 49.635613,-1.717607 49.635738,-1.717497 49.635828,-1.717061 49.63607,-1.716684 49.636255,-1.716366 49.636333,-1.716078 49.636591,-1.715999 49.636625,-1.715767 49.63646,-1.715417 49.636751,-1.715209 49.636887,-1.714986 49.636913,-1.714496 49.636758,-1.714225 49.636627,-1.713881 49.636595,-1.713189 49.63671,-1.712925 49.636723,-1.712983 49.636931,-1.712107 49.637052,-1.712036 49.636809,-1.711704 49.636845,-1.711246 49.636817,-1.710526 49.636857,-1.710323 49.636916,-1.710374 49.637055,-1.710109 49.63713,-1.709696 49.637289,-1.709551 49.63727,-1.709233 49.63748,-1.708728 49.637728,-1.708402 49.637829,-1.707987 49.638019,-1.707678 49.638139,-1.706888 49.638482,-1.706656 49.638611,-1.706246 49.638781,-1.706141 49.638738,-1.705858 49.638864,-1.705713 49.638961,-1.705522 49.638956,-1.704453 49.639616,-1.704334 49.639749,-1.704464 49.639823,-1.704253 49.64009,-1.70418 49.640283,-1.703993 49.640223,-1.703922 49.640267,-1.703848 49.64054,-1.703701 49.640688,-1.703503 49.641063,-1.70357 49.641339,-1.7037 49.641737,-1.703878 49.641818,-1.704061 49.641749,-1.704574 49.642074,-1.704575 49.642177,-1.704693 49.642344,-1.704603 49.642588,-1.704621 49.642783,-1.70488 49.643013,-1.704974 49.643401,-1.704861 49.643618,-1.704594 49.643957,-1.70457 49.644062,-1.704411 49.644241,-1.704308 49.644266,-1.703844 49.644624,-1.703632 49.644862,-1.703525 49.645142,-1.703258 49.645365,-1.703049 49.645326,-1.702904 49.645846,-1.702755 49.64624,-1.702758 49.64641,-1.70267 49.646634,-1.702834 49.646752,-1.702857 49.646991,-1.702987 49.647211,-1.702894 49.647337,-1.702951 49.647454,-1.703074 49.647468,-1.702576 49.648471,-1.702368 49.648762,-1.702189 49.648847,-1.702239 49.648913,-1.702118 49.649197,-1.702231 49.649455,-1.702137 49.649593,-1.702232 49.64965,-1.70236 49.649953,-1.702509 49.65019,-1.702676 49.650307,-1.702631 49.650352,-1.702818 49.650639,-1.702732 49.650791,-1.70264 49.650819,-1.702634 49.651194,-1.702417 49.651449,-1.702337 49.651734,-1.70258 49.651844,-1.702477 49.652142,-1.702363 49.652333,-1.702299 49.652526,-1.702024 49.652788,-1.701753 49.652995,-1.701497 49.653285,-1.701526 49.653335,-1.701357 49.653494,-1.701188 49.653708,-1.700997 49.65381,-1.700862 49.653835,-1.700608 49.654012,-1.700531 49.654171,-1.700529 49.654314,-1.700416 49.654369,-1.700324 49.654507,-1.700011 49.654726,-1.699886 49.654935,-1.699718 49.655101,-1.699603 49.655505,-1.699958 49.655581,-1.700357 49.655537,-1.700408 49.655444,-1.700585 49.655395,-1.700752 49.655439,-1.700903 49.65533,-1.701012 49.655376,-1.701163 49.655331,-1.701219 49.655165,-1.701633 49.655173,-1.701685 49.655065,-1.701947 49.655007,-1.702182 49.654861,-1.702456 49.654802,-1.702711 49.654642,-1.703042 49.654615,-1.703174 49.654521,-1.703603 49.654415,-1.704441 49.654592,-1.704981 49.654521,-1.705657 49.654375,-1.705935 49.654253,-1.70621 49.654094,-1.707344 49.653336,-1.707406 49.65337,-1.707777 49.653261,-1.708177 49.65291,-1.708076 49.652845,-1.709246 49.652095,-1.709518 49.651661,-1.709692 49.651503,-1.710013 49.651422,-1.710227 49.651286,-1.710426 49.651246,-1.710642 49.651327,-1.710845 49.651361,-1.711136 49.651328,-1.711627 49.651341,-1.712402 49.651311,-1.712925 49.651199,-1.713285 49.650825,-1.71313 49.650732,-1.71327 49.650635,-1.713345 49.650507,-1.713597 49.650397,-1.71403 49.650247,-1.7141 49.650153,-1.714477 49.650086,-1.714639 49.650148,-1.714793 49.650097,-1.715031 49.650097,-1.715153 49.650051,-1.715263 49.649934,-1.71527 49.64968,-1.715513 49.649758,-1.71573 49.649584,-1.715736 49.649501,-1.715893 49.649389,-1.71605 49.649208,-1.716062 49.649058,-1.716245 49.649058,-1.716492 49.648993,-1.716615 49.649005,-1.716775 49.649102,-1.717496 49.649037,-1.718191 49.648878,-1.719091 49.64852,-1.72005 49.648277,-1.720005 49.648154,-1.72012 49.648089,-1.72045 49.64806,-1.720455 49.647907,-1.720598 49.647847,-1.720552 49.647756,-1.721036 49.647696,-1.721124 49.64782,-1.721316 49.647756,-1.721654 49.647542,-1.721717 49.647427,-1.721994 49.647308,-1.722495 49.647042,-1.72268 49.647012,-1.722887 49.646777,-1.723066 49.646733,-1.723168 49.646653,-1.723335 49.64675,-1.723651 49.646825,-1.723827 49.646838,-1.724106 49.646786,-1.724163 49.646693,-1.724614 49.646637,-1.724728 49.64658,-1.725062 49.646567,-1.72549 49.646504,-1.725743 49.646375,-1.726692 49.645616,-1.726938 49.645459,-1.727586 49.644838,-1.727871 49.644748,-1.728212 49.644557,-1.728126 49.64447,-1.72831 49.644241,-1.728594 49.644104,-1.728716 49.643894,-1.729055 49.643659,-1.730017 49.64288,-1.731925 49.641369,-1.732066 49.641251,-1.732204 49.641328,-1.732716 49.641484,-1.732924 49.641828,-1.733241 49.642227,-1.733364 49.642467,-1.733471 49.643003,-1.733554 49.643095,-1.733568 49.643437,-1.733678 49.644314,-1.733704 49.644628,-1.733674 49.645412,-1.733689 49.645444,-1.734443 49.64559,-1.735021 49.645645,-1.73494 49.646104,-1.734862 49.646805,-1.734989 49.647425,-1.735245 49.647856,-1.734844 49.648053,-1.734685 49.648202,-1.734728 49.64834,-1.735111 49.648525,-1.735366 49.648609,-1.735703 49.64878,-1.736341 49.649052,-1.736998 49.649439,-1.737405 49.649525,-1.737509 49.649577,-1.737576 49.649779,-1.737704 49.649935,-1.737654 49.649975,-1.737647 49.650176,-1.737438 49.650308,-1.737154 49.650435,-1.736548 49.650478,-1.736318 49.650468,-1.735835 49.650531,-1.73545 49.650535,-1.734647 49.650684,-1.73454 49.650731,-1.734374 49.651121,-1.734241 49.651214,-1.734215 49.651566,-1.734022 49.651795,-1.733959 49.651941,-1.733816 49.652022,-1.733699 49.652209,-1.733636 49.652226,-1.733123 49.652885,-1.732694 49.653173,-1.732489 49.653429,-1.732294 49.653536,-1.731808 49.653753,-1.731098 49.653751,-1.730802 49.653771,-1.730247 49.653921,-1.730165 49.654174,-1.730021 49.654277,-1.729682 49.654335,-1.729599 49.654573,-1.729244 49.654544,-1.72903 49.654782,-1.728847 49.654872,-1.728799 49.654977,-1.729031 49.655245,-1.729045 49.655546,-1.728913 49.655799,-1.728764 49.656176,-1.728439 49.656269,-1.728277 49.656417,-1.728315 49.65657,-1.727678 49.656794,-1.727381 49.656854,-1.727652 49.657099,-1.727701 49.657271,-1.727662 49.657564,-1.72773 49.657842,-1.72783 49.657991,-1.728027 49.658189,-1.728378 49.658472,-1.728302 49.658596,-1.728218 49.658856,-1.728072 49.659179,-1.727476 49.659483,-1.727121 49.659605,-1.726824 49.659772,-1.72652 49.659869,-1.726385 49.659966,-1.726302 49.660106,-1.726323 49.660396,-1.726244 49.660621,-1.725797 49.661111,-1.725386 49.661435,-1.7249 49.661712,-1.724653 49.661771,-1.723993 49.66206,-1.723834 49.662068,-1.723805 49.661875,-1.723537 49.661939,-1.723409 49.662002,-1.723164 49.662022,-1.723134 49.662163,-1.722651 49.66227,-1.721973 49.662381,-1.722301 49.662647,-1.721137 49.663244,-1.720331 49.663609,-1.720291 49.663612,-1.719924 49.663287,-1.718955 49.662977,-1.718738 49.662835,-1.718426 49.662833,-1.717782 49.662933,-1.717135 49.662962,-1.716832 49.662963,-1.716417 49.662822,-1.71594 49.663033,-1.715681 49.663419,-1.715513 49.663576,-1.714658 49.664031,-1.714268 49.664322,-1.713784 49.664591,-1.713544 49.664674,-1.713182 49.66474,-1.712793 49.664734,-1.712209 49.664617,-1.711608 49.664535,-1.711089 49.664646,-1.710409 49.664717,-1.710433 49.664812,-1.710583 49.664942,-1.710734 49.664995,-1.710607 49.665091,-1.710115 49.665072,-1.71013 49.665139,-1.709572 49.665347,-1.709049 49.665466,-1.708584 49.665464,-1.707832 49.665414,-1.706815 49.665273,-1.706252 49.665164,-1.705838 49.664978,-1.705455 49.664945,-1.705484 49.665371,-1.705456 49.665754,-1.705378 49.666371,-1.705342 49.666773,-1.705206 49.668809,-1.705141 49.669226,-1.704711 49.670154,-1.704649 49.670256,-1.704539 49.670872,-1.704183 49.670769,-1.704178 49.670715,-1.703864 49.670619,-1.703726 49.670624,-1.703313 49.670505,-1.703244 49.670508,-1.702618 49.670334,-1.702516 49.670284,-1.701923 49.670172,-1.700863 49.669952,-1.700861 49.669934,-1.699647 49.669855,-1.699374 49.669901,-1.698781 49.669789,-1.697857 49.66969,-1.697318 49.669711,-1.696554 49.669784,-1.696222 49.669924,-1.695572 49.67003,-1.695056 49.670158,-1.694272 49.670378,-1.694222 49.670443,-1.693235 49.670868,-1.692859 49.671152,-1.692699 49.671222,-1.691959 49.671322,-1.69145 49.671522,-1.691383 49.671638,-1.691247 49.671698,-1.690344 49.671916,-1.690092 49.671954,-1.689262 49.672177,-1.688753 49.672375,-1.688503 49.672509,-1.688116 49.67283,-1.687987 49.673087,-1.687951 49.673295,-1.687689 49.673467,-1.687358 49.673786,-1.686998 49.673791,-1.686537 49.673602,-1.686575 49.673564,-1.685898 49.673293,-1.684267 49.672398,-1.683718 49.672132,-1.68328 49.671977,-1.682818 49.671918,-1.682693 49.672067,-1.682417 49.672239,-1.681999 49.672372,-1.681628 49.672405,-1.681264 49.672374,-1.680909 49.672279,-1.680573 49.672094,-1.680389 49.671903,-1.680285 49.671673,-1.680272 49.67153,-1.680332 49.671275,-1.680544 49.671015,-1.680887 49.670822,-1.680544 49.670503,-1.680328 49.670328,-1.679886 49.670041,-1.679562 49.670021,-1.679459 49.669908,-1.679344 49.669873,-1.678898 49.669854,-1.678363 49.669767,-1.67807 49.669742,-1.677434 49.669767,-1.668848 49.670979,-1.667287 49.671192,-1.66459 49.671584,-1.663398 49.671746,-1.663332 49.671632,-1.66355 49.671588,-1.663746 49.671607,-1.666896 49.671162,-1.668211 49.670986,-1.668187 49.670869,-1.668324 49.670855,-1.668348 49.670962,-1.669087 49.670862,-1.669048 49.670737,-1.6692 49.670723,-1.669223 49.67083,-1.669525 49.670791,-1.673427 49.670236,-1.674441 49.670098,-1.676658 49.669779,-1.678768 49.66949,-1.678794 49.669215,-1.678864 49.669225,-1.67884 49.669524,-1.678999 49.669743,-1.679349 49.669774,-1.679943 49.669598,-1.680003 49.66965,-1.679696 49.669779,-1.681588 49.669841,-1.681832 49.669939,-1.682059 49.670147,-1.682137 49.670387,-1.682053 49.670534,-1.681908 49.670459,-1.681574 49.670598,-1.681636 49.670676,-1.681918 49.670566,-1.682091 49.670641,-1.682278 49.671173,-1.682912 49.671284,-1.683422 49.671399,-1.683586 49.671366,-1.683729 49.671262,-1.685144 49.671414,-1.684836 49.671993,-1.685694 49.672581,-1.685936 49.672491,-1.686731 49.673,-1.686676 49.673605,-1.686765 49.673674,-1.686942 49.673631,-1.686998 49.673494,-1.687054 49.672889,-1.685477 49.671878,-1.685361 49.671361,-1.685256 49.671284,-1.683164 49.671004,-1.683093 49.67098,-1.68257 49.670568,-1.682482 49.670518,-1.682361 49.670108,-1.682261 49.669923,-1.681683 49.669675,-1.680192 49.669598,-1.68013 49.669528,-1.681054 49.669312,-1.681694 49.66918,-1.681626 49.668894,-1.681406 49.668912,-1.681397 49.668813,-1.680069 49.668855,-1.680122 49.668826,-1.68181 49.668779,-1.681822 49.668617,-1.681911 49.668523,-1.681832 49.668418,-1.682098 49.668444,-1.682462 49.668178,-1.682651 49.668126,-1.683025 49.668084,-1.683767 49.667813,-1.684011 49.667677,-1.684263 49.667253,-1.684379 49.666997,-1.68435 49.666683,-1.68424 49.666093,-1.684182 49.665906,-1.683939 49.665682,-1.683268 49.664861,-1.682864 49.664391,-1.682545 49.664088,-1.681454 49.663374,-1.680993 49.662879,-1.680247 49.66216,-1.680042 49.662186,-1.679519 49.66253,-1.679665 49.662318,-1.67931 49.66207,-1.679078 49.661962,-1.678448 49.66159,-1.677127 49.660795,-1.676352 49.660357,-1.67578 49.66001,-1.675543 49.659848,-1.675166 49.659664,-1.675074 49.659569,-1.674668 49.659377,-1.673994 49.65898,-1.673493 49.658658,-1.672776 49.658244,-1.672544 49.658136,-1.672072 49.657974,-1.671632 49.657865,-1.670889 49.657777,-1.670334 49.657771,-1.669293 49.65791,-1.669268 49.657938,-1.668658 49.658096,-1.668091 49.658109,-1.666989 49.658043,-1.666158 49.658048,-1.664188 49.658187,-1.663898 49.658198,-1.66381 49.658147,-1.663087 49.65813,-1.662241 49.658127,-1.661765 49.658082,-1.660275 49.65786,-1.659478 49.657783,-1.658645 49.657729,-1.657796 49.657725,-1.657355 49.657755,-1.656798 49.657848,-1.656345 49.657849,-1.655896 49.657828,-1.655482 49.657756,-1.655223 49.657649,-1.654907 49.657382,-1.654447 49.657048,-1.654188 49.656941,-1.653114 49.656568,-1.652915 49.656513,-1.652596 49.656516,-1.6526 49.656399,-1.652053 49.65633,-1.649265 49.656779,-1.647632 49.656967,-1.646796 49.657071,-1.64643 49.657778,-1.645667 49.658077,-1.64492 49.658403,-1.644283 49.658715,-1.644102 49.658866,-1.643653 49.658965,-1.643264 49.659105,-1.643086 49.65913,-1.642189 49.659174,-1.641745 49.659326,-1.641379 49.659421,-1.641247 49.659498,-1.640904 49.659529,-1.640752 49.65939,-1.64043 49.659502,-1.639975 49.659537,-1.639417 49.659648,-1.638495 49.659729,-1.638101 49.659816,-1.636682 49.659924,-1.636296 49.659939,-1.63598 49.659978,-1.635221 49.660016,-1.634358 49.66013,-1.633859 49.66014,-1.633534 49.660224,-1.63315 49.660266,-1.632434 49.660176,-1.631675 49.660061,-1.631124 49.659914,-1.630746 49.659986,-1.630332 49.660029,-1.629763 49.660012,-1.629316 49.659933,-1.627727 49.65973,-1.62322 49.659099,-1.617058 49.658246,-1.616241 49.658136,-1.616146 49.658089,-1.616175 49.657982,-1.616296 49.65795,-1.618472 49.658246,-1.623439 49.658912,-1.624143 49.659001,-1.624968 49.659122,-1.62788 49.659507,-1.629652 49.659762,-1.629702 49.659662,-1.629802 49.659217,-1.629908 49.658959,-1.629944 49.658776,-1.630339 49.657609,-1.630403 49.65748,-1.630404 49.657273,-1.630641 49.65732,-1.630865 49.656601,-1.630677 49.656578,-1.630748 49.656341,-1.63153 49.653929,-1.631539 49.653843,-1.631376 49.653749,-1.631288 49.653588,-1.631419 49.65338,-1.631683 49.653277,-1.632751 49.653281,-1.632782 49.6533,-1.632981 49.653869,-1.633469 49.654069,-1.63426 49.653949,-1.634529 49.653944,-1.634577 49.654079,-1.634983 49.654022,-1.634935 49.653882,-1.635181 49.653813,-1.636271 49.653649,-1.635948 49.652734,-1.635923 49.652533,-1.636111 49.652505,-1.635995 49.652177,-1.635783 49.652181,-1.635718 49.652,-1.635612 49.651865,-1.63558 49.651686,-1.635368 49.651086,-1.635231 49.651087,-1.634313 49.651222,-1.633934 49.65131,-1.633986 49.651462,-1.633818 49.65149,-1.633849 49.651586,-1.633462 49.651644,-1.633422 49.651548,-1.633255 49.651573,-1.633193 49.65141,-1.632578 49.651509,-1.632261 49.651818,-1.632462 49.652385,-1.632447 49.652406,-1.631488 49.652712,-1.631278 49.652725,-1.631072 49.65268,-1.630905 49.652552,-1.63087 49.652465,-1.629314 49.652565,-1.627893 49.652639,-1.627753 49.652477,-1.627266 49.652042,-1.627122 49.651765,-1.626755 49.650724,-1.626571 49.650236,-1.626262 49.650259,-1.626007 49.650245,-1.625554 49.650155,-1.625274 49.650035,-1.625143 49.649905,-1.625199 49.649832,-1.625375 49.649888,-1.625806 49.65009,-1.626202 49.65016,-1.626746 49.650044,-1.628295 49.64979,-1.628492 49.649651,-1.628765 49.64962,-1.628685 49.649419,-1.628422 49.649455,-1.628392 49.649369,-1.627403 49.64941,-1.627251 49.649367,-1.627154 49.649192,-1.627525 49.648625,-1.628087 49.648641,-1.62832 49.647573,-1.627804 49.647526,-1.627435 49.648151,-1.62732 49.648122,-1.626802 49.649018,-1.626581 49.649087,-1.6263 49.648983,-1.626169 49.649122,-1.626049 49.649084,-1.626112 49.648806,-1.62624 49.648604,-1.625962 49.648425,-1.625912 49.648248,-1.625939 49.648102,-1.626385 49.648031,-1.626298 49.647811,-1.626079 49.647703,-1.624906 49.647417,-1.62222 49.648848,-1.620385 49.648659,-1.619177 49.647984,-1.61916 49.647891,-1.619358 49.647841,-1.619511 49.647929,-1.619587 49.648136,-1.620425 49.648602,-1.622018 49.648772,-1.623019 49.648041,-1.624072 49.647263,-1.625112 49.646503,-1.624087 49.645894,-1.62397 49.645979,-1.623605 49.645777,-1.623613 49.645714,-1.62333 49.645556,-1.623399 49.645497,-1.623521 49.644844,-1.623468 49.64472,-1.622629 49.644644,-1.621751 49.644588,-1.620871 49.644513,-1.620257 49.644473,-1.620083 49.644381,-1.620165 49.64391,-1.619859 49.643894,-1.619821 49.6444,-1.619654 49.644388,-1.619882 49.643074,-1.619991 49.642908,-1.620147 49.642794,-1.620456 49.642684,-1.620676 49.642666,-1.621794 49.642759,-1.621824 49.642631,-1.621083 49.642561,-1.621086 49.642444,-1.621326 49.642488,-1.622234 49.642571,-1.622422 49.642501,-1.622302 49.642397,-1.621379 49.642315,-1.621116 49.642316,-1.620898 49.642199,-1.620997 49.641763,-1.620257 49.641701,-1.620285 49.641556,-1.621012 49.641618,-1.621082 49.641327,-1.621354 49.640039,-1.621098 49.6395,-1.620842 49.639428,-1.620621 49.639437,-1.620655 49.639214,-1.620448 49.6392,-1.620402 49.639412,-1.620244 49.639406,-1.620271 49.639243,-1.62009 49.639241,-1.62004 49.639318,-1.619866 49.639305,-1.619216 49.639382,-1.618905 49.639778,-1.618783 49.640586,-1.618629 49.640578,-1.618511 49.641387,-1.618399 49.642006,-1.618529 49.642012,-1.618464 49.642496,-1.618311 49.642494,-1.618278 49.642811,-1.618813 49.642908,-1.619121 49.642941,-1.619211 49.64256,-1.619309 49.642565,-1.618648 49.646162,-1.61868 49.646352,-1.618616 49.646583,-1.618407 49.646551,-1.618051 49.648599,-1.617156 49.648669,-1.617186 49.648848,-1.616608 49.648897,-1.61655 49.648863,-1.615574 49.643724,-1.615471 49.643197,-1.615347 49.643211,-1.615401 49.643497,-1.615504 49.643565,-1.615552 49.643788,-1.615139 49.643822,-1.615104 49.643589,-1.615231 49.643458,-1.615182 49.643226,-1.615086 49.643239,-1.614918 49.643065,-1.614465 49.643109,-1.613922 49.643238,-1.613479 49.643399,-1.6131 49.643503,-1.612743 49.643841,-1.612686 49.643978,-1.612786 49.644163,-1.61253 49.644245,-1.612702 49.644973,-1.61306 49.646907,-1.613116 49.646905,-1.613461 49.648737,-1.613298 49.64877,-1.612029 49.648865,-1.611634 49.646766,-1.611042 49.646813,-1.610254 49.646843,-1.610251 49.646807,-1.609948 49.646206,-1.609786 49.645339,-1.60953 49.644035,-1.608938 49.644075,-1.608764 49.644145,-1.608142 49.644628,-1.608068 49.644729,-1.608092 49.644836,-1.608313 49.644828,-1.608734 49.647044,-1.608459 49.647073,-1.608274 49.64609,-1.608257 49.646063,-1.607185 49.646158,-1.607118 49.646188,-1.60667 49.647222,-1.606205 49.64713,-1.606631 49.64617,-1.606331 49.646226,-1.605892 49.64627,-1.605688 49.646161,-1.605563 49.646157,-1.604021 49.646278,-1.602839 49.646395,-1.602626 49.646493,-1.603315 49.649995,-1.603194 49.650036,-1.602794 49.65006,-1.60273 49.650116,-1.602836 49.650517,-1.602939 49.650748,-1.604555 49.650625,-1.604823 49.65198,-1.605272 49.65419,-1.605582 49.655802,-1.605143 49.655831,-1.605227 49.656296,-1.60539 49.656415,-1.605577 49.656489,-1.60635 49.656604,-1.60633 49.656695,-1.605347 49.656552,-1.605253 49.656583,-1.605423 49.657548,-1.605625 49.658414,-1.605469 49.658528,-1.604421 49.6589,-1.602679 49.65957,-1.602114 49.659771,-1.601633 49.659969,-1.601203 49.660121,-1.600399 49.66043,-1.599996 49.660571,-1.599867 49.660531,-1.599528 49.660301,-1.598489 49.659539,-1.597822 49.65906,-1.596722 49.658247,-1.596176 49.657872,-1.59564 49.65746,-1.595004 49.657016,-1.594305 49.656493,-1.592733 49.655355,-1.592434 49.655115,-1.592175 49.654854,-1.590369 49.653266,-1.589423 49.652456,-1.589406 49.652421,-1.590401 49.65223,-1.590331 49.652062,-1.589412 49.65216,-1.589308 49.6521,-1.588943 49.652051,-1.588666 49.652053,-1.587906 49.651613,-1.58729 49.651241,-1.586966 49.651028,-1.586798 49.651007,-1.586494 49.651172,-1.586369 49.651167,-1.586077 49.651313,-1.586017 49.651415,-1.585302 49.651793,-1.584821 49.652,-1.58466 49.651907,-1.584464 49.651725,-1.584382 49.651737,-1.584464 49.652002,-1.584391 49.652013,-1.584284 49.651732,-1.584033 49.651715,-1.583162 49.651891,-1.582803 49.651905,-1.582368 49.652011,-1.582292 49.652086,-1.582349 49.652264,-1.581542 49.652376,-1.581615 49.65258,-1.584628 49.65216,-1.585124 49.652591,-1.585783 49.653143,-1.588099 49.652686,-1.588129 49.652712,-1.585528 49.653233,-1.584687 49.652509,-1.584453 49.652536,-1.583433 49.652907,-1.583261 49.652995,-1.582937 49.653097,-1.582508 49.653266,-1.581967 49.653413,-1.580809 49.653645,-1.580686 49.653659,-1.579951 49.653813,-1.579073 49.654233,-1.578722 49.654336,-1.578449 49.654382,-1.578063 49.654406,-1.577682 49.654483,-1.577317 49.654596,-1.57697 49.654744,-1.57632 49.654913,-1.575654 49.655064,-1.575349 49.655066,-1.575208 49.655198,-1.574745 49.655287,-1.574395 49.655408,-1.573162 49.655725,-1.572366 49.655971,-1.572194 49.656058,-1.572071 49.656234,-1.571802 49.656334,-1.571101 49.656405,-1.570202 49.656583,-1.570048 49.656562,-1.569947 49.656674,-1.57055 49.659396,-1.570698 49.659958,-1.570587 49.659962,-1.570574 49.659818,-1.569951 49.657025,-1.569698 49.657036,-1.56917 49.656994,-1.568482 49.656913,-1.568147 49.656858,-1.568083 49.657077,-1.568 49.657071,-1.568058 49.65679,-1.567564 49.656691,-1.567343 49.656709,-1.567283 49.656648,-1.566904 49.656599,-1.566334 49.656584,-1.565752 49.656435,-1.564123 49.656047,-1.563455 49.655856,-1.563373 49.655877,-1.562691 49.655686,-1.562082 49.655538,-1.561867 49.655465,-1.561371 49.65534,-1.56073 49.655148,-1.560063 49.654975,-1.559854 49.654965,-1.559436 49.654791,-1.558714 49.65462,-1.55871 49.654451,-1.558512 49.65439,-1.557508 49.654212,-1.557023 49.6541,-1.555927 49.653964,-1.555239 49.653898,-1.555062 49.653929,-1.554495 49.653951,-1.554395 49.654071,-1.553518 49.654338,-1.552949 49.654495,-1.552025 49.6547,-1.55182 49.655203,-1.551631 49.655264,-1.551326 49.655257,-1.550419 49.655192,-1.549292 49.655145,-1.548885 49.655097,-1.548741 49.655039,-1.548433 49.654997,-1.547652 49.654945,-1.547488 49.654816,-1.549033 49.654893,-1.55033 49.654971,-1.550813 49.654953,-1.551363 49.655058,-1.551513 49.654872,-1.551512 49.654701,-1.551096 49.654546,-1.548686 49.654414,-1.548773 49.654112,-1.548924 49.653094,-1.548858 49.651937,-1.548865 49.651869,-1.548784 49.650897,-1.548736 49.649968,-1.548701 49.649789,-1.548365 49.649663,-1.547588 49.649576,-1.547144 49.649616,-1.546561 49.649716,-1.546203 49.649759,-1.545773 49.649933,-1.545413 49.650025,-1.545257 49.650161,-1.54518 49.650446,-1.545059 49.650726,-1.544337 49.650491,-1.543934 49.650282,-1.543615 49.650171,-1.54296 49.65005,-1.542413 49.649907,-1.541992 49.649871,-1.541845 49.649887,-1.541603 49.649974,-1.541076 49.650206,-1.540613 49.65021,-1.540177 49.650139,-1.539784 49.65011,-1.539691 49.649483,-1.539631 49.649203,-1.5395 49.648979,-1.539292 49.648713,-1.539021 49.64851,-1.53852 49.648179,-1.537842 49.647846,-1.537539 49.647601,-1.53728 49.647199,-1.536525 49.64608,-1.536332 49.645881,-1.536055 49.64539,-1.535784 49.644817,-1.535499 49.644623,-1.534977 49.64353,-1.534943 49.643422,-1.534623 49.643222,-1.53457 49.643097,-1.53464 49.642905,-1.534648 49.642659,-1.534696 49.642504,-1.535354 49.641903,-1.535456 49.641848,-1.535578 49.64166,-1.535623 49.641434,-1.535432 49.641137,-1.535417 49.641012,-1.535519 49.640857,-1.536044 49.640458,-1.536118 49.640291,-1.536134 49.640125,-1.536093 49.639823,-1.53602 49.639594,-1.536128 49.639228,-1.536375 49.638746,-1.53653 49.638573,-1.536498 49.638214,-1.536419 49.637796,-1.536357 49.637603,-1.535812 49.637698,-1.535142 49.637673,-1.534881 49.637634,-1.534893 49.637042,-1.534939 49.63687,-1.535263 49.636414,-1.535343 49.636237,-1.535393 49.635843,-1.535564 49.635535,-1.535378 49.635345,-1.53484 49.634935,-1.534694 49.634841,-1.534499 49.634781,-1.534256 49.634659,-1.533977 49.634443,-1.533763 49.634167,-1.533596 49.633772,-1.533585 49.633566,-1.533741 49.633116,-1.533995 49.632598,-1.534339 49.632225,-1.534583 49.631987,-1.535184 49.631462,-1.535322 49.631223,-1.535534 49.630676,-1.535665 49.630272,-1.535801 49.629762,-1.535826 49.629448,-1.535874 49.629277,-1.536411 49.629411,-1.537237 49.629561,-1.538609 49.629736,-1.539323 49.62987,-1.540217 49.630015,-1.542677 49.630692,-1.543094 49.630775,-1.544059 49.63079,-1.544491 49.63077,-1.544815 49.63073,-1.545636 49.63058,-1.546461 49.630474,-1.546944 49.630397,-1.547109 49.630395,-1.547276 49.629305,-1.547363 49.628295,-1.547316 49.627991,-1.546854 49.626865,-1.546494 49.625947,-1.546208 49.624507,-1.546178 49.624278,-1.548763 49.623676,-1.5486 49.62351,-1.550917 49.621865,-1.551191 49.621654,-1.552069 49.620918,-1.552272 49.620728,-1.55258 49.620491,-1.553471 49.619963,-1.554254 49.619557,-1.554862 49.619199,-1.555124 49.618955,-1.555357 49.618626,-1.555184 49.618306,-1.554832 49.618006,-1.554629 49.617607,-1.554191 49.617355,-1.553577 49.617025,-1.552739 49.616388,-1.552516 49.616201,-1.551976 49.61583,-1.5518 49.615653,-1.551628 49.615546,-1.551066 49.61541,-1.550757 49.615317,-1.550369 49.615143,-1.550268 49.615055,-1.550082 49.614673,-1.549389 49.613669,-1.549228 49.613592,-1.548859 49.613095,-1.548668 49.613019,-1.54821 49.612743,-1.547778 49.612504,-1.547029 49.612175,-1.546454 49.611836,-1.546479 49.611722,-1.546736 49.611358,-1.546948 49.611156,-1.547129 49.610841,-1.547407 49.610118,-1.547637 49.609595,-1.547849 49.609386,-1.547772 49.609244,-1.547736 49.608981,-1.547734 49.608621,-1.547731 49.607879,-1.547763 49.607675,-1.547876 49.607373,-1.548047 49.60701,-1.54878 49.60568,-1.548871 49.605603,-1.549544 49.605151,-1.55018 49.604543,-1.550553 49.604125,-1.550999 49.603656,-1.551519 49.603,-1.551683 49.602736,-1.551648 49.602089,-1.551621 49.601206,-1.55162 49.600606,-1.551645 49.600263,-1.551622 49.600118,-1.551762 49.59984,-1.552038 49.599445,-1.552456 49.59892,-1.552701 49.598653,-1.552949 49.598339,-1.553132 49.598154,-1.553464 49.597732,-1.554006 49.597163,-1.554423 49.596679,-1.554716 49.59631,-1.554867 49.596021,-1.555352 49.595257,-1.55553 49.594957,-1.555946 49.594481,-1.5562 49.594075,-1.556234 49.593977,-1.556481 49.592832,-1.556567 49.592572,-1.557203 49.591936,-1.557732 49.591463,-1.558295 49.590933,-1.558427 49.590857,-1.559409 49.590566,-1.557434 49.589155,-1.556362 49.588372,-1.556187 49.588405,-1.555071 49.587616,-1.552195 49.585543,-1.552025 49.585583,-1.551717 49.585556,-1.551572 49.585481,-1.551435 49.585289,-1.551455 49.585127,-1.551558 49.585044,-1.55195 49.584963,-1.552189 49.58501,-1.55237 49.585149,-1.553879 49.584927,-1.561774 49.583797,-1.561752 49.583722,-1.563228 49.583515,-1.563734 49.583523,-1.563943 49.583503,-1.564026 49.583241,-1.564394 49.582207,-1.564658 49.581496,-1.564745 49.581208,-1.564767 49.581018,-1.564925 49.580919,-1.565081 49.580694,-1.565146 49.58069,-1.566565 49.580743,-1.566817 49.580781,-1.568427 49.580985,-1.568273 49.581391,-1.568689 49.581328,-1.568825 49.581418,-1.569044 49.581328,-1.569299 49.581277,-1.569395 49.581202,-1.569663 49.581258,-1.570178 49.581466,-1.570132 49.581584,-1.570323 49.581699,-1.570121 49.581884,-1.570184 49.582033,-1.570434 49.582151,-1.570733 49.582119,-1.570703 49.582028,-1.570865 49.58201,-1.571026 49.582157,-1.571255 49.582129,-1.571678 49.582386,-1.571784 49.582526,-1.572045 49.582607,-1.572245 49.582556,-1.572757 49.582705,-1.573194 49.582606,-1.573387 49.582504,-1.57371 49.582444,-1.573599 49.582628,-1.57431 49.583046,-1.574876 49.583151,-1.575015 49.583219,-1.575647 49.583937,-1.575836 49.584188,-1.576493 49.584579,-1.577494 49.585065,-1.577705 49.584995,-1.577686 49.585186,-1.577888 49.585306,-1.578242 49.585404,-1.57844 49.58537,-1.578925 49.5856,-1.579047 49.585682,-1.579009 49.585846,-1.578944 49.586458,-1.578981 49.58656,-1.579399 49.58684,-1.579678 49.587112,-1.580022 49.587796,-1.580367 49.588206,-1.580566 49.588767,-1.580858 49.58943,-1.580987 49.589763,-1.58104 49.589996,-1.581142 49.590228,-1.581022 49.590387,-1.581078 49.590601,-1.580538 49.590841,-1.580412 49.591198,-1.580526 49.591471,-1.580733 49.591695,-1.580791 49.591859,-1.580817 49.592805,-1.580753 49.593264,-1.580686 49.594046,-1.580768 49.594066,-1.581652 49.594094,-1.581848 49.594206,-1.582148 49.594016,-1.582158 49.593929,-1.582605 49.593671,-1.582911 49.593593,-1.583351 49.593547,-1.583643 49.593559,-1.584365 49.593726,-1.584745 49.593773,-1.585319 49.593661,-1.585797 49.593604,-1.587039 49.5931,-1.587171 49.593058,-1.589895 49.59251,-1.590431 49.592477,-1.590944 49.59233,-1.591988 49.592081,-1.593528 49.591773,-1.596066 49.591461,-1.595751 49.592738,-1.595736 49.592927,-1.595626 49.593442,-1.595592 49.59376,-1.595618 49.593967,-1.595844 49.594823,-1.596072 49.595572,-1.596239 49.596068,-1.596416 49.596673,-1.596768 49.597775,-1.597295 49.59958,-1.601108 49.59997,-1.601704 49.600043,-1.601821 49.59925)),((-1.584345 49.669291,-1.584438 49.669395,-1.584652 49.669774,-1.584735 49.669771,-1.584841 49.670028,-1.5848 49.670345,-1.584518 49.670598,-1.584277 49.670678,-1.583932 49.670719,-1.583606 49.670642,-1.582892 49.670569,-1.582779 49.670538,-1.58257 49.670375,-1.582503 49.670251,-1.582564 49.67015,-1.582766 49.670088,-1.582892 49.670101,-1.582784 49.669665,-1.582182 49.669444,-1.582205 49.669398,-1.581459 49.66912,-1.581218 49.669219,-1.581135 49.669214,-1.580851 49.66899,-1.580842 49.668892,-1.580425 49.668727,-1.579207 49.668278,-1.577857 49.667762,-1.576394 49.667223,-1.574442 49.666486,-1.573825 49.666249,-1.573565 49.666132,-1.573229 49.665947,-1.572609 49.66552,-1.572321 49.665252,-1.571873 49.664738,-1.571742 49.664509,-1.571501 49.663987,-1.571135 49.662372,-1.570783 49.660756,-1.570852 49.660753,-1.57143 49.663351,-1.571565 49.663922,-1.571641 49.664153,-1.571925 49.6647,-1.57236 49.665215,-1.572647 49.665483,-1.573165 49.66585,-1.573661 49.66612,-1.574021 49.666277,-1.574451 49.666432,-1.575428 49.666809,-1.576432 49.667177,-1.576719 49.667292,-1.578569 49.667978,-1.579272 49.668231,-1.580018 49.668518,-1.58108 49.66891,-1.582243 49.669361,-1.582607 49.668933,-1.582651 49.668958,-1.582287 49.669377,-1.583133 49.669696,-1.583393 49.669651,-1.583306 49.669456,-1.583172 49.669353,-1.583249 49.669287,-1.583399 49.669407,-1.583515 49.669619,-1.583583 49.669607,-1.583948 49.669189,-1.582944 49.668821,-1.582968 49.668784,-1.583987 49.66916,-1.584065 49.669265,-1.584345 49.669291)),((-1.665564 49.670556,-1.665407 49.670652,-1.664872 49.670718,-1.664507 49.670669,-1.664008 49.670373,-1.663959 49.670285,-1.663988 49.670149,-1.66409 49.670055,-1.664377 49.670008,-1.664872 49.670115,-1.664941 49.66995,-1.664488 49.669859,-1.66454 49.669821,-1.664993 49.669912,-1.664958 49.670138,-1.665454 49.670254,-1.665603 49.670375,-1.665564 49.670556)),((-1.647879 49.67451,-1.647583 49.674612,-1.647332 49.674594,-1.646956 49.67442,-1.646686 49.674349,-1.646336 49.674317,-1.645546 49.67432,-1.644269 49.674306,-1.641674 49.674297,-1.640313 49.674277,-1.639009 49.674273,-1.637745 49.674258,-1.635053 49.674244,-1.632178 49.674201,-1.630482 49.674157,-1.627357 49.674105,-1.625299 49.674057,-1.624355 49.674048,-1.622444 49.673999,-1.621742 49.673986,-1.621316 49.674029,-1.620689 49.673999,-1.620246 49.674007,-1.619698 49.674082,-1.61943 49.674182,-1.61899 49.674225,-1.618612 49.674186,-1.61824 49.674056,-1.618118 49.673935,-1.617829 49.673811,-1.617461 49.673725,-1.615357 49.673472,-1.613739 49.673285,-1.611895 49.673064,-1.610816 49.672943,-1.6094 49.672771,-1.605085 49.672265,-1.60197 49.671892,-1.59967 49.67161,-1.599257 49.671643,-1.599245 49.671824,-1.598607 49.671821,-1.598407 49.671757,-1.598129 49.671434,-1.5982 49.671305,-1.598409 49.671162,-1.598726 49.671132,-1.598908 49.671153,-1.599123 49.671234,-1.599247 49.671383,-1.599258 49.671499,-1.599661 49.671511,-1.599665 49.67125,-1.600237 49.671588,-1.601372 49.671716,-1.603641 49.671987,-1.613274 49.673128,-1.615644 49.673416,-1.617101 49.673586,-1.617195 49.673394,-1.617329 49.673343,-1.618069 49.673549,-1.618045 49.673586,-1.617292 49.67339,-1.617214 49.6736,-1.61811 49.673692,-1.61823 49.673642,-1.618453 49.673652,-1.618736 49.67356,-1.619322 49.673601,-1.619441 49.673695,-1.619707 49.673721,-1.619939 49.673829,-1.620731 49.673844,-1.620728 49.673655,-1.62063 49.67365,-1.619972 49.673729,-1.619967 49.673675,-1.620639 49.673596,-1.620781 49.673635,-1.620843 49.673858,-1.621997 49.673886,-1.625317 49.673949,-1.625985 49.673968,-1.628431 49.674019,-1.629153 49.674028,-1.630084 49.674055,-1.630932 49.674068,-1.632308 49.674106,-1.633364 49.674119,-1.633614 49.673975,-1.634615 49.674,-1.634836 49.674144,-1.637417 49.674154,-1.641775 49.674185,-1.643552 49.674208,-1.644551 49.674205,-1.645981 49.674223,-1.646504 49.674032,-1.646698 49.674024,-1.646605 49.674226,-1.646826 49.674217,-1.646881 49.674359,-1.647002 49.674319,-1.647018 49.674183,-1.647144 49.674052,-1.646848 49.673839,-1.646886 49.673801,-1.647183 49.674024,-1.647454 49.67395,-1.647678 49.673969,-1.647957 49.674147,-1.648003 49.674343,-1.647879 49.67451)))', 4326))
            AND (
              (tags->'shop') = 'vacant'
              OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')
            );

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\OsmDatabaseService->getClosedLikePlaces (line 803)
3	App\Service\Motocultrice->getClosedLikePlaces (line 179)
4	App\Controller\AdminController->cityClosures (line 1698)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

9.15 ms
(12.23%)

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

Parameters:

[
  "50129"
]

View formatted query View runnable query Explain query View query backtrace

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'50129'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchBoundaryWkt (line 292)
3	App\Service\ZonePolygonResolver->fetchBoundaryWktFromMeta (line 236)
4	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():100} (line 100)
5	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
6	App\Service\ZonePolygonResolver->polygonWkt (line 62)
7	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
8	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
9	App\Service\Motocultrice->getClosedLikePlaces (line 179)
10	App\Controller\AdminController->cityClosures (line 1698)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

3.16 ms
(4.22%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmDatabaseService->hasOsmObjectMetaTable (line 2375)
3	App\Service\Motocultrice->canQueryPostgisZone (line 255)
4	App\Service\Motocultrice->getClosedLikePlaces (line 177)
5	App\Controller\AdminController->cityClosures (line 1698)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.76 ms
(3.68%)

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

Parameters:

[
  "public"
  "osm_object_meta"
]

View formatted query View runnable query Explain query View query backtrace

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';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->postgresTableExists (line 563)
3	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 495)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
8	App\Service\Motocultrice->getClosedLikePlaces (line 179)
9	App\Controller\AdminController->cityClosures (line 1698)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

2.61 ms
(3.49%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 500)
3	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
4	App\Service\ZonePolygonResolver->polygonWkt (line 62)
5	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
6	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
7	App\Service\Motocultrice->getClosedLikePlaces (line 179)
8	App\Controller\AdminController->cityClosures (line 1698)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.29 ms
(1.73%)

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
)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
);

#	File/Call
1	App\Service\ZonePolygonResolver->syncAdminLevel8RelationsFromHistory (line 554)
2	App\Service\ZonePolygonResolver->resolvePolygon (line 97)
3	App\Service\ZonePolygonResolver->polygonWkt (line 62)
4	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
5	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
6	App\Service\Motocultrice->getClosedLikePlaces (line 179)
7	App\Controller\AdminController->cityClosures (line 1698)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.21 ms
(1.61%)

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

Parameters:

[
  "50129"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 422)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
8	App\Service\Motocultrice->getClosedLikePlaces (line 179)
9	App\Controller\AdminController->cityClosures (line 1698)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.45 ms
(0.60%)

SELECT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1

SELECT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\OsmDatabaseService->isAvailable (line 2364)
3	App\Service\Motocultrice->canQueryPostgisZone (line 254)
4	App\Service\Motocultrice->getClosedLikePlaces (line 177)
5	App\Controller\AdminController->cityClosures (line 1698)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.43 ms
(0.57%)

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

Parameters:

[
  "50129"
]

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Service\ZonePolygonResolver->fetchBoundaryWkt (line 292)
3	App\Service\ZonePolygonResolver->fetchBoundaryWktFromHistory (line 259)
4	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():101} (line 101)
5	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
6	App\Service\ZonePolygonResolver->polygonWkt (line 62)
7	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
8	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
9	App\Service\Motocultrice->getClosedLikePlaces (line 179)
10	App\Controller\AdminController->cityClosures (line 1698)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.40 ms
(0.54%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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);

#	File/Call
1	App\Service\ZonePolygonResolver->ensureZonePolygonTable (line 477)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 417)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
8	App\Service\Motocultrice->getClosedLikePlaces (line 179)
9	App\Controller\AdminController->cityClosures (line 1698)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.34 ms
(0.45%)

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()
                )

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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()
                );

#	File/Call
1	App\Service\ZonePolygonResolver->ensureZonePolygonTable (line 469)
2	App\Service\ZonePolygonResolver->fetchPolygonFromStore (line 417)
3	App\Service\ZonePolygonResolver->{closure:App\Service\ZonePolygonResolver::resolvePolygon():102} (line 102)
4	App\Service\ZonePolygonResolver->resolvePolygon (line 106)
5	App\Service\ZonePolygonResolver->polygonWkt (line 62)
6	App\Service\OsmDatabaseService->requirePolygonWkt (line 2444)
7	App\Service\OsmDatabaseService->getClosedLikePlaces (line 789)
8	App\Service\Motocultrice->getClosedLikePlaces (line 179)
9	App\Controller\AdminController->cityClosures (line 1698)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
osm	doctrine.dbal.osm_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Stats	1

Entities Mapping

Class	Mapping errors
App\Entity\Stats	No errors.
App\Entity\Place	No errors.
App\Entity\StatsHistory	No errors.
App\Entity\CityFollowUp	No errors.
App\Entity\ZonePlaces	No errors.
App\Entity\SireneEntreprise	No errors.

Symfony Profiler

GET https://osm-labo.cipherbliss.com/admin/stats/50129/closures

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

osm connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping