From 5ae905b20a7dfa36289a8d1d596126eaa6c8ba3d Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Tue, 19 Mar 2013 19:29:39 +0000 Subject: [PATCH] download dbpedia attempt at geocoords --- utils/import_wikipedia.sh | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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|]*> * "\(-\?[-0-9.E]\+\) \(-\?[-0-9.E]\+\)"@en .|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|]*> * "\(-\?[-0-9.E]\+\) \(-\?[-0-9.E]\+\)"@en .|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 -- 2.39.5