Status: not yet full description
Last updated: 25.02.2017 17:26 GMT+03:00
OS: Ubuntu 16.04 LTS
Install database and append data
## 1. Install osm2pgsql full description
sudo apt-get install make cmake g++ libboost-dev libboost-system-dev \
libboost-filesystem-dev libexpat1-dev zlib1g-dev \
libbz2-dev libpq-dev libgeos-dev libgeos++-dev libproj-dev lua5.2 \
liblua5.2-dev
cd ~/src
git clone git://github.com/openstreetmap/osm2pgsql.git
cd osm2pgsql
mkdir build && cd build
cmake ..
make
sudo make install`
2. Drop old data
psql -d gis -c "DROP VIEW lowzoom_water, lowzoom_roads, lowzoom_landuse, lowzoom_borders, lowzoom_railways, lowzoom_cities;"
psql -d lowzoom -c "DROP TABLE water, landuse, roads, borders, railways, cities;"
3. Load data into database
mkdir data
cd data
wget http://data.gis-lab.info/osm_dump/dump/latest/RU-BU.osm.pbf
osm2pgsql --create --slim -d gis -C 1000 --number-processes 10 \
--style /etc/mapnik/osm2pgsql/opentopomap.style ./data/RU-BU.osm.pbf
/etc/mapnik/tools/update_lowzoom.sh
/etc/mapnik/tools/update_saddles.sh
4. Run renderd
sudo renderd -f -c /etc/renderd.conf #fixme sudo
To clear cache
sudo rm -R /var/lib/mod_tile/default/
than press F5 in browser
Generate and append changeset
## 1. Install osmosis wget http://bretth.dev.openstreetmap.org/osmosis-build/osmosis-latest.tgz mkdir osmosis mv osmosis-latest.tgz osmosis cd osmosis tar xvfz osmosis-latest.tgz rm osmosis-latest.tgz chmod a+x bin/osmosis sudo ln -s /home/developer/osm_database_update/src/osmosis/bin/osmosis /usr/local/bin/
2. Generate changeset
cd data
wget http://be.gis-lab.info/data/osm_dump/dump/RU-BU/RU-BU-170224.osm.pbf
osmosis --read-pbf file="RU-BU-170224.osm.pbf" --read-pbf file="RU-BU.osm.pbf" --derive-change --write-xml-change file="RU-BU-changeset-170224.osc" ## 3. Append changeset
osm2pgsql --slim --append -d gis RU-BU-changeset-170224.osc