I need to update only Brazilian addresses

Question

I am trying to update only one country (Brazil), but when I follow the instructions and modify the local.php url to http://download.geofabrik.de/south-america/brazil-updates/ I get an error when I run

 ./utils/setup.php --osmosis-init
 ./utils/setup.php --create-functions --enable-diff-updates
 ./utils/update.php --import-osmosis-all --no-npi

Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=2000MB, maxblocks=256000*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=2000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /home/osm/Nominatim-2.5.0/data/osmosischange.osc
Using XML parser.
Processing: Node(112k 2.6k/s) Way(7k 0.87k/s) Relation(160 40.00/s)node cache: stored: 109400(100.00%), storage efficiency: 53.83% (dense blocks: 53, sparse nodes: 74475), hit rate: 24.99%
Osm2pgsql failed due to ERROR: insert_rel failed: ERROR:  value "37945" is out of range for type smallint
(7)

I need to update only Brazil.

Answer 1

1

There was bad (well too much) data inserted into OpenStreetMap which makes osm2pgsql fail which affected lots of users of Nominatim who do hourly/minutely update. I think those with daily updates were not affected. Have a look at https://lists.openstreetmap.org/pipermail/geocoding/2017-March/001859.html

permanent link

answered 16 Mar '17, 22:16

mtmail
4.8k●15●74
accept rate: 27%

Yes, that looks like the same osm2pgsql error that I saw when updating a rendering DB.

(16 Mar '17, 22:24) SomeoneElse ♦

I need to update only Brazilian addresses

Follow this question

Related questions