From: Brian Quinion <brian.quinion@mapquest.com>
Date: Tue, 19 Mar 2013 19:29:39 +0000 (+0000)
Subject: download dbpedia attempt at geocoords
X-Git-Tag: v2.2.0~102
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/5ae905b20a7dfa36289a8d1d596126eaa6c8ba3d?ds=inline

download dbpedia attempt at geocoords
---

diff --git a/utils/import_wikipedia.sh b/utils/import_wikipedia.sh
index 7dd5ab08..d40578dd 100755
--- a/utils/import_wikipedia.sh
+++ b/utils/import_wikipedia.sh
@@ -40,7 +40,8 @@ do
 done
 
 # precalculated lat,lon from dbpedia
-cat geo_coordinates_en.nq | grep http://www.georss.org/georss/point | sed 's|<http://dbpedia.org/resource/[^>]*> *<http://www.georss.org/georss/point> "\(-\?[-0-9.E]\+\) \(-\?[-0-9.E]\+\)"@en <http://\([a-z][a-z]\).wikipedia.org/wiki/\([^#]\+\)#> .|update pagelinks set lat=\1, lon=\2 where language = '"'"'\3'"'"' and title = decode_url_part('"'"'\4'"'"');|g' | $psqlcmd
+wget http://downloads.dbpedia.org/current/en/geo_coordinates_en.nq.bz2
+bzip2 -dc geo_coordinates_en.nq.bz2 | grep http://www.georss.org/georss/point | sed 's|<http://dbpedia.org/resource/[^>]*> *<http://www.georss.org/georss/point> "\(-\?[-0-9.E]\+\) \(-\?[-0-9.E]\+\)"@en <http://\([a-z][a-z]\).wikipedia.org/wiki/\([^#]\+\)#> .|update pagelinks set lat=\1, lon=\2 where language = '"'"'\3'"'"' and title = decode_url_part('"'"'\4'"'"');|g' | $psqlcmd
 
 # media wiki dumper
 wget https://github.com/bcollier/mwdumper/blob/master/build/mwdumper.jar