EuroBillTracker

Burdie wrote: ↑Mon Dec 04, 2023 11:27 am If you look at Kleman's tour the france, you see that he has 'Corse' but on the map it is not coulored blue

aloxe wrote: ↑Mon Dec 04, 2023 10:46 pm I assume Burdie has also notes recorded in Cherbourg (both 50100 and 50110) because the request of his cities returns Cherbourg with the following object:

Code: Select all

{"city":"Cherbourg","country":"France","top_zipcode":"50110","nrlocations":2}

This is why I expect the empty array to contain 2 postcodes.

+---------+---------+----------+------------+-------+-----------------------+
| user_id | country | location | date       | count | city                  |
+---------+---------+----------+------------+-------+-----------------------+
|   11641 | France  |    42917 | 2006-04-16 |     0 | Cherbourg             |
|   11641 | France  |    42922 | 2007-03-26 |     0 | Cherbourg             |
|   11641 | France  |   604308 | 2007-03-26 |     7 | Cherbourg-en-Cotentin |
|   11641 | France  |   658492 | 2006-04-16 |     1 | Cherbourg-en-Cotentin |
+---------+---------+----------+------------+-------+-----------------------+

aloxe wrote: ↑Tue Dec 05, 2023 9:42 am Cherbourg-en-Cotentin is the merge of Cherbourg-Octeville with some surrounding municipalities as you can see on the map:

Cherbourg-Octeville being already a merger municipality from Cherbourg and Octeville in 2000 if I remember well.

avij wrote: ↑Tue Dec 05, 2023 8:14 am Burdie had previously entered some notes from Cherbourg but then later on edited them to be Cherbourg-en-Cotentin. This left the aforementioned "usernotelocations" table in the following state (actually the city name is from another table, but included here for clarity):

Code: Select all

+---------+---------+----------+------------+-------+-----------------------+
| user_id | country | location | date       | count | city                  |
+---------+---------+----------+------------+-------+-----------------------+
|   11641 | France  |    42917 | 2006-04-16 |     0 | Cherbourg             |
|   11641 | France  |    42922 | 2007-03-26 |     0 | Cherbourg             |
|   11641 | France  |   604308 | 2007-03-26 |     7 | Cherbourg-en-Cotentin |
|   11641 | France  |   658492 | 2006-04-16 |     1 | Cherbourg-en-Cotentin |
+---------+---------+----------+------------+-------+-----------------------+

tralla wrote: ↑Wed Dec 06, 2023 6:46 pm Can you have a look at the link to the Luxembourg site? It doesn't work for me.