pull in the special phrases from the wiki

diff --git a/utils/specialphrases.php b/utils/specialphrases.php
new file mode 100755 (executable)
index 0000000..5ad61ff
--- /dev/null
+++ b/utils/specialphrases.php
@@ -0,0 +1,80 @@
+#!/usr/bin/php -Cq
+<?php
+
+        require_once(dirname(dirname(__FILE__)).'/lib/init-cmd.php');
+        ini_set('memory_limit', '800M');
+
+        $aCMDOptions = array(
+                "Import and export special phrases",
+                array('help', 'h', 0, 1, 0, 0, false, 'Show Help'),
+                array('quiet', 'q', 0, 1, 0, 0, 'bool', 'Quiet output'),
+                array('verbose', 'v', 0, 1, 0, 0, 'bool', 'Verbose output'),
+
+                array('wiki-import', '', 0, 1, 0, 0, 'bool', 'Create nominatim db'),
+        );
+        getCmdOpt($_SERVER['argv'], $aCMDOptions, $aCMDResult, true, true);
+
+       $aLanguageIn = array(
+                       'af',
+                       'ar',
+                       'br',
+                       'ca',
+                       'cs',
+                       'de',
+                       'en',
+                       'es',
+                       'et',
+                       'eu',
+                       'fa',
+                       'fi',
+                       'fr',
+                       'gl',
+                       'hr',
+                       'hu',
+                       'ia',
+                       'is',
+                       'it',
+                       'ja',
+                       'mk',
+                       'nl',
+                       'no',
+                       'pl',
+                       'ps',
+                       'pt',
+                       'ru',
+                       'sk',
+                       'sv',
+                       'uk',
+                       'vi',
+               );
+
+       if ($aCMDResult['wiki-import'])
+       {
+               foreach($aLanguageIn as $sLanguage)
+               {
+                       $sURL = 'http://wiki.openstreetmap.org/wiki/Special:Export/Nominatim/Special_Phrases/'.strtoupper($sLanguage);
+                       $sWikiPageXML = file_get_contents($sURL);
+                       if (preg_match_all('#\\| ([^|]+) \\|\\| ([^|]+) \\|\\| ([^|]+) \\|\\| ([\\-YN]) \\|\\| ([\\-YN])#', $sWikiPageXML, $aMatches, PREG_SET_ORDER))
+                       {
+                               foreach($aMatches as $aMatch)
+                               {
+                                       $sLabel = $aMatch[1];
+                                       $sClass = $aMatch[2];
+                                       $sType = $aMatch[3];
+
+                                       switch(trim($aMatch[4]))
+                                       {
+                                       case 'near':
+                                               echo "select getorcreate_amenityoperator(make_standard_name('".pg_escape_string($sLabel)."'), '$sClass', '$sType', 'near');\n";
+                                               break;
+                                       case 'in':
+                                               echo "select getorcreate_amenityoperator(make_standard_name('".pg_escape_string($sLabel)."'), '$sClass', '$sType','in');\n";
+                                               break;
+                                       default:
+                                               echo "select getorcreate_amenity(make_standard_name('".pg_escape_string($sLabel)."'), '$sClass', '$sType');\n";
+                                               break;
+                                       }
+                               }
+                       }
+               }
+       }