NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

My openstreetmap database have import the asia.osm.pbf, and the gis database have import the planet-lastest.osm.pbf, when i make an edit on the openstreetmap db by iD editor, and use osmosis command to produce a changes.osc.gz file, then i use the "osm2pgsql --append --slim -H 192.168.1.162 -P 5432 -d gis -U postgres -C 160 --number-processes 3 changes.osc.gz -e15 -o expire.list" command to import the changes.osc.gz into gis db, some error occurs, i don't know how to solve it. And i didn't find a solution on the internet, so i ask a question here, hope someone to help me.

alt text

This error disappears when i add a projection parameter "-E 3857", but other error occurs, the detail error message is:

osm2pgsql SVN version 0.82.0 (64bit id space)
Using projection SRS 3857 (EPSG:3857)
....
failed: ERROR:  INSERT has more expressions than target columns
LINE 1: ...oolean) AS INSERT INTO planet_osm_ways VALUES ($1,$2,$3,$4);
                                                               ^

asked 30 Dec '16, 13:57

yuyy's gravatar image

yuyy
236222431
accept rate: 20%

edited 02 Jan '17, 10:27

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273

1

osm2pgsql's default projection is 900913, but your tables from first (and/or previous) import is in 3087. The simplest way round this is to add a projection parameter "-E 3857". (although 3857 & 900913 are for most purposes identical, PostGIS does not know this)

(30 Dec '16, 15:35) SK53 ♦

It appears that you have downgraded your osm2pgsql version from 0.92 or later to 0.82 after doing the first import. This would explain your initial problem (since 0.92 started using EPSG:3857 as the default, while earlier versions were using EPSG:900913), as well as your follow-on problem (because osm2pgsql 0.82 was using an additional column called "pending" on the database tables that was later removed).

While you found a valid workaround for the projection issue, a workaround for the missing columns would be more cumbersome. (See https://github.com/openstreetmap/osm2pgsql/blob/master/docs/migrations.md for information on migrating osm2pgsql-imported data between versions, but note that 0.82 is so old that it might already warrant the attribute "ancient".)

You should be able to solve your problem by using the same osm2pgsql version for the initial import and the subsequent updates.

(Hat tip to lonvia and pnorman who told me this on IRC.)

permanent link

answered 02 Jan '17, 10:32

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

edited 03 Jan '17, 10:17

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×352
×263

question asked: 30 Dec '16, 13:57

question was seen: 2,690 times

last updated: 03 Jan '17, 10:17

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum