Changes between Version 1 and Version 2 of GIS/OpenStreetMap

Timestamp:

12/06/12 12:33:30 (12 years ago)

Author:

Fran Boon

Comment:

--

GIS/OpenStreetMap

@@ -82 +82 @@
 ALTER TABLE ways OWNER TO osm;
 \q
+exit
 
-cd planet
-wget http://download.geofabrik.de/openstreetmap/africa.osm.bz2
-bzcat /home/osm/planet/africa.osm.bz2 | /home/osm/osmosis/bin/osmosis --read-xml file=/dev/stdin --tf accept-nodes amenity=hospital,place_of_worship,school --tf accept-ways amenity=hospital,place_of_worship,school --write-pbf /home/osm/planet/eurosha.osm.pbf
+cd /home/osm/planet
+wget http://download.geofabrik.de/openstreetmap/africa.osm.pbf
+/home/osm/osmosis/bin/osmosis --read-pbf /home/osm/planet/africa.osm.pbf --tf accept-nodes amenity=hospital,place_of_worship,school --tf accept-ways amenity=hospital,place_of_worship,school --write-pbf /home/osm/planet/eurosha.osm.pbf
 su postgres
 /home/osm/osmosis/bin/osmosis --read-pbf /home/osm/planet/eurosha.osm.pbf --write-pgsql database=osm user=osm password=planet
@@ -91 +92 @@
 cd /home/osm/planet/replication
 /home/osm/osmosis/bin/osmosis --rrii
+sudo -H -u postgres psql -d osm -c "select max(tstamp) from nodes";
 http://toolserver.org/~mazder/replicate-sequences/
-ls -l /home/osm/planet/africa.osm.bz2
-vi state.txt
+Put timestamp into site, select hourly
+vim state.txt
+# paste in contents from website
+vim configuration.txt
+baseUrl=http://planet.openstreetmap.org/replication/hour
 
 /home/osm/osmosis/bin/osmosis --rri workingDirectory=/home/osm/planet/replication/ --simc --read-pbf /home/osm/planet/eurosha.osm.pbf --ac --tf accept-nodes amenity=hospital,place_of_worship,school --tf accept-ways amenity=hospital,place_of_worship,school --tf reject-relations --write-pbf /home/osm/planet/eurosha-new.osm.pbf
@@ -109 +114 @@
 /home/osm/osmosis/bin/osmosis --rri workingDirectory=/home/osm/planet/replication/ --simc --read-pbf /home/osm/planet/eurosha.osm.pbf --ac --tf accept-nodes amenity=hospital,place_of_worship,school --tf accept-ways amenity=hospital,place_of_worship,school --tf reject-relations --write-pbf /home/osm/planet/eurosha-new.osm.pbf
 /home/osm/osmosis/bin/osmosis --read-pbf /home/osm/planet/eurosha-new.osm.pbf --read-pbf /home/osm/planet/eurosha.osm.pbf --dc --write-pgsql-change database=osm user=osm password=planet
+mv /home/osm/planet/eurosha-new.osm.pbf /home/osm/planet/eurosha.osm.pbf
 fi
 
 chmod 0755 /home/osm/replicate.sh
 vim /etc/crontab
-1 3   * * * root    /home/osm/replicate.sh
+1 *   * * * root    /home/osm/replicate.sh
 }}}
 
 Monitor:
 {{{
+su postgres
 psql -d osm -c "select max(tstamp) from nodes";
 }}}