X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/f42e40712e1a20d9e6ca1e497123a0c16c83be82..9025b0ec78bd770e74a1bed85c8d2e43ce5f571a:/docs/develop/Postcodes.md?ds=sidebyside diff --git a/docs/develop/Postcodes.md b/docs/develop/Postcodes.md index c52f0b81..343b8de3 100644 --- a/docs/develop/Postcodes.md +++ b/docs/develop/Postcodes.md @@ -1,6 +1,7 @@ # Postcodes in Nominatim -The blog post [Nominatim and Postcodes](https://www.openstreetmap.org/user/lonvia/diary/43143) +The blog post +[Nominatim and Postcodes](https://www.openstreetmap.org/user/lonvia/diary/43143) describes the handling implemented since Nominatim 3.1. Postcode centroids (aka 'calculated postcodes') are generated by looking at all @@ -13,7 +14,7 @@ country's format, e.g. if Swiss postcodes are 4 digits. ## Regular updating calculated postcodes The script to rerun the calculation is -`build/utils/update.php --calculate-postcodes` +`nominatim refresh --postcodes` and runs once per night on nominatim.openstreetmap.org. @@ -22,8 +23,9 @@ and runs once per night on nominatim.openstreetmap.org. In the Nominatim database run ```sql -SELECT osm_type, osm_id, class, type, - st_x(centroid) as lon, st_y(centroid) at lat +SELECT address->'postcode' as pc, + osm_type, osm_id, class, type, + st_x(centroid) as lon, st_y(centroid) as lat FROM placex WHERE country_code='fr' AND upper(trim (both ' ' from address->'postcode')) = '33210';