[OSM-dev] Daily diff fails to import

Yoanis Gil Delgado gryffindor.godric at gmail.com
Thu May 26 14:58:05 BST 2011


Hi Adrian,

I think I have ran into similar issues. In my case, I skipped a few
steps and ran into also sort of *weird* issues. Is your database
properly setup? Try going over the steps here:

http://wiki.openstreetmap.org/wiki/Nominatim/Installation

using a fresh database.

Regards,

Yoanis.

On Thu, May 26, 2011 at 9:34 AM, Adrian Chapela
<achapela.rexistros at gmail.com> wrote:
> I am trying to import a daily diff and is impossible. I have tried with
> util.update.php and the result is the same.
>
> Now I am trying to the next command. Below you coud see the output.
>
> osm2pgsql -as -O gazetteer -d gazetteer -U postgres -W
> 20110405-20110406.osc.gz
> osm2pgsql SVN version 0.70.5
>
> Password:
> Using projection SRS 900913 (Spherical Mercator)
> Mid: pgsql, scale=100, cache=800MB, maxblocks=102401*8192
> Setting up table: planet_osm_nodes
> Setting up table: planet_osm_ways
> Setting up table: planet_osm_rels
>
> Reading in file: 20110405-20110406.osc.gz
> COPY_END for place failed: ERROR:  operator is not unique: geometry <>
> geometry
> LINE 5:      OR (existing.geometry != NEW.geometry AND ST_Distance(S...
>                                   ^
> HINT:  Could not choose a best candidate operator. You might need to add
> explicit type casts.
> QUERY:  SELECT existing.osm_type IS NULL
>     OR existingplacex.osm_type IS NULL
>     OR coalesce(existing.admin_level, 100) != coalesce(NEW.admin_level,
> 100)
> --     OR coalesce(existing.country_code, '') !=
> coalesce(NEW.country_code, '')
>     OR (existing.geometry != NEW.geometry AND
> ST_Distance(ST_Centroid(existing.geometry),ST_Centroid(NEW.geometry)) >
> 0.01 AND NOT
>     (ST_GeometryType(existing.geometry) in
> ('ST_Polygon','ST_MultiPolygon') AND ST_GeometryType(NEW.geometry) in
> ('ST_Polygon','ST_MultiPolygon')))
> CONTEXT:  PL/pgSQL function "place_insert" line 52 at IF
> COPY place, line 1: "\N    N    443853    highway    bus_stop
>  {"(\\"name\\",\\"Neumarkt\\")"}    100    \N    \N    \N    \N    \N
>  \N    \N    \N    \N    SRID=900..."
>
> Error occurred, cleaning up
>
>
> PostgreSQL server version is 9.0 and 8.4.7. I only want to import it to
> use with nominatim but I can't... it is very extrange. I was looking for
> the operator != isn't in the database....
>
> Have you any idea ?
>
> Regards.
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>



More information about the dev mailing list