[Geocoding] Fwd: Nominatim re-install on Europe

Simon Nuttall info at cyclestreets.net
Sat Aug 31 06:54:13 UTC 2013


Following on from the problem I had at:
http://lists.openstreetmap.org/pipermail/geocoding/2013-August/000948.html

I updated the git repo and submodules, recompiled and resumed another
Europe wide import. But 48 hours in again hit the same problem:

Reading in file: /home/nominatim/Nominatim/data/osmosischange.osc
COPY_END for place failed: ERROR:  column "addr_place" of relation
"placex" does not exist
LINE 2:       street, addr_place, isin, postcode, country_code, extr...
                      ^
QUERY:  insert into placex (osm_type, osm_id, class, type, name,
admin_level, housenumber,
      street, addr_place, isin, postcode, country_code, extratags, geometry)
      values (NEW.osm_type
        ,NEW.osm_id
        ,NEW.class
        ,NEW.type
        ,NEW.name
        ,NEW.admin_level
        ,NEW.housenumber
        ,NEW.street
        ,NEW.addr_place
        ,NEW.isin
        ,NEW.postcode
        ,NEW.country_code
        ,NEW.extratags
        ,NEW.geometry
        )
CONTEXT:  PL/pgSQL function "place_insert" line 78 at SQL statement
COPY place, line 1: "N  1       amenity restaurant      "name"=>"3390
Restó", "addr:housename"=>"3390 Restó"    100     3390    Sarmiento
   \N      ..."

Error occurred, cleaning up
Error: 1
root at antonio:~/src/nominatim-install#

-- 
Simon Nuttall

Route Master, CycleStreets.net



More information about the Geocoding mailing list