How to "update" GIS tile data?

Question

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?

Answer 1

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.

How to "update" GIS tile data?

Follow this question

Related questions