Merge pull request #1865 from mtmail/how-to-import-test-db

[nominatim.git] / docs / develop / Postcodes.md

diff --git a/docs/develop/Postcodes.md b/docs/develop/Postcodes.md
index c52f0b81e072d3fede82ac356176ef72c25838ae..ff36b0dda630e1af86b411db75838178cc50a839 100644 (file)
--- 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
@@ -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';