[Geocoding] [OpenStreetMap] #5111: 'France' relationship probably broken

[OpenStreetMap]

#5111: 'France' relationship probably broken
------------------------+-------------------------
  Reporter:  zeenix@…   |      Owner:  geocoding@…
      Type:  defect     |     Status:  new
  Priority:  major      |  Milestone:
 Component:  nominatim  |    Version:
Resolution:             |   Keywords:
------------------------+-------------------------

Comment (by lonvia):

 It turns out that the relation for
 [http://nominatim.openstreetmap.org/details.php?place_id=98156803
 Metropolitan France] has inconsistent data because the admin_level has
 been reduced from 2 to 3. admin_level has been updated to level 3 but
 rank_address is still at 4. That means that it clashes with the actual
 country relation for
 [http://nominatim.openstreetmap.org/details.php?place_id=9157173744
 France] in the place_address table overriding it as an address part, so
 France is no longer an official part of the address. When computing the
 address details, admin_level is used instead rank_address and then
 Metropolitan France becomes a state, so that there is no country in the
 address.

 The proper way of fixing would be to replace a place in the placex table
 when the admin level changes. But in the case of the Metropolitan France
 relation that means that the entire country gets reindexed which is not
 really doable. I can neither think of any way to hack the change of the
 admin level into the placex and place_addressline tables in a way that
 would actually fix the problem above.

 So I'm thinking of doing the replacement in placex and putting a hard
 limit of around 10000 on the number of
 [https://github.com/twain47/Nominatim/blob/master/sql/functions.sql#L1955
 linked objects to be reindexed]. @twain47 any better ideas?

-- 
Ticket URL: <https://trac.openstreetmap.org/ticket/5111#comment:2>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world