OpenStreetMap

Adding columns to a non-updatable import.

Posted by Marcos Dione on 9 August 2016 in English (English)

I reimported Europe lately, but I forgot a column. Because I had several space problems which I had to solve by hand (and also because it takes a lot of time), I simply sat down and reprocessed the extract with pysomium, adding the missing data to the rendering database. More details in my glob

Comment from woodpeck on 9 August 2016 at 23:18

Another approach would have been to filter out all objects that have a castle_type column using osmosis, and then feeding the resulting file to the database via osm2pgsql -a (provided you have done your original import with –slim).

Note that your approach, as documented, does not work for relations as those will appear with negative IDs in planet_osm_polygon; you need to duplicate the “way” method and do a “… where osm_id = -%s” for this to work.

Comment from Marcos Dione on 10 August 2016 at 04:45

@woodpeck: well, the fact is that I’m using –slim, but also –drop, because of my space constraints. And thanks for the info about relations, in this case I didn’t have any problem because there are no relations with a castle_type tag.

Login to leave a comment