I previously had downloaded a metro extract from the OSM metro extracts page, and now found a site that offers individual state extract PBFs. I followed the instructions at http://switch2osm.org/loading-osm-data/ and for some reason the new data I imported, while it did not error out or anything and is taking up the additional space - is not displaying when I view my tile server. I did a rm -fr /var/lib/tile as well as service restarts on apache2 & renderd, and after that didn't work even fully rebooted the machine. It's still stuck looking like it's "cached" the old tiles and isn't displaying the new "larger area" of data. In psql, I did a \dt and it shows the same # of tables and table names. The size of the database, again, has increased - was ~270 MBs and is now ~862 MBs - so the data IS in there, just not displaying. Do I have to drop the gis database and re-create it from the templates? Or is there an easier way to update this data?

asked 17 Jul '14, 19:46

f00dl3's gravatar image

f00dl3
1111
accept rate: 0%


If you use osm2pgsql with default settings by default it'll replace the previous data, so the fact that you're still seeing it is odd (if it's not tile or browser cache).

A bit of a long shot, but is it possible that you used a different database name this time and are still pointing at the old one?

You could try looking in the database with psql to see if the data that you're expecting to be there actually is. For example, I recently made a change to a local database to include an "industrial" column, and to check that the data was actually there I did:

psql -c "select osm_id,industrial from planet_osm_polygon where industrial = 'warehouse'" gis

which returned for me

  osm_id   | industrial 
-----------+------------
 280982430 | warehouse
 280982431 | warehouse
(2 rows)

The osm_ids above are the way IDs that of the features concerned. You might want to select something that exists in your old set of data, and your new one.

permanent link

answered 17 Jul '14, 23:32

SomeoneElse's gravatar image

SomeoneElse ♦
32.2k63333752
accept rate: 15%

Your answer
toggle preview

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:

×547
×160
×121

question asked: 17 Jul '14, 19:46

question was seen: 2,701 times

last updated: 17 Jul '14, 23:32

powered by OSQA