Hello list, I just compiled and set up 2.4.0, and imported the latest Luxembourg snapshot (without any error messages). Calling an example url returns output that resembles some kind of json (arrays, key-value pairs) structure followed by some tables, etc. What am I doing wrong.
Url: http://144.76.36.45/nominatim/search.php?q=route%20de%20luxembourg%2018,%20echternach&format=json&addressdetails=1 Output: string 'select word_id,word_token, word, class, type, country_code, operator, search_name_count from word where word_token in (' rt de luxembourg 18','rt de luxembourg 18',' rt','rt',' de luxembourg 18','de luxembourg 18',' de','de',' luxembourg 18','luxembourg 18',' luxembourg','luxembourg',' 18','18',' de luxembourg','de luxembourg',' rt de','rt de',' rt de luxembourg','rt de luxembourg',' echternach','echternach')' *(length=412)* *array* *(size=2)* 0 => *array* *(size=3)* 'string' => string 'rt de luxembourg 18' *(length=19)* 'words' => *array* *(size=4)* 0 => string 'rt' *(length=2)* 1 => string 'de' *(length=2)* 2 => string 'luxembourg' *(length=10)* 3 => string '18' *(length=2)* 'wordsets' => *array* *(size=8)* 0 => *array* *(size=1)* ... 1 => *array* *(size=2)* ... 2 => *array* *(size=3)* ... 3 => *array* *(size=4)* ... 4 => *array* *(size=3)* ... 5 => *array* *(size=2)* ... 6 => *array* *(size=3)* ... 7 => *array* *(size=2)* ... 1 => *array* *(size=3)* 'string' => string 'echternach' *(length=10)* 'words' => *array* *(size=1)* 0 => string 'echternach' *(length=10)* 'wordsets' => *array* *(size=1)* 0 => *array* *(size=1)* ... *array* *(size=11)* 'echternach' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '5049' *(length=4)* 'word_token' => string 'echternach' *(length=10)* 'word' => null 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* 'rt de luxembourg' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '5636' *(length=4)* 'word_token' => string 'rt de luxembourg' *(length=16)* 'word' => null 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* ' luxembourg' => *array* *(size=2)* 0 => *array* *(size=8)* 'word_id' => string '11379' *(length=5)* 'word_token' => string ' luxembourg' *(length=11)* 'word' => string 'Luxembourg' *(length=10)* 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* 1 => *array* *(size=8)* 'word_id' => string '48411' *(length=5)* 'word_token' => string ' luxembourg' *(length=11)* 'word' => null 'class' => null 'type' => null 'country_code' => string 'lu' *(length=2)* 'operator' => null 'search_name_count' => string '0' *(length=1)* ' 18' => *array* *(size=2)* 0 => *array* *(size=8)* 'word_id' => string '12657' *(length=5)* 'word_token' => string ' 18' *(length=3)* 'word' => string '18' *(length=2)* 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* 1 => *array* *(size=8)* 'word_id' => string '48386' *(length=5)* 'word_token' => string ' 18' *(length=3)* 'word' => null 'class' => string 'place' *(length=5)* 'type' => string 'house' *(length=5)* 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* ' rt de luxembourg' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '38904' *(length=5)* 'word_token' => string ' rt de luxembourg' *(length=17)* 'word' => string 'Route de Luxembourg' *(length=19)* 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* ' echternach' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '43215' *(length=5)* 'word_token' => string ' echternach' *(length=11)* 'word' => string 'Echternach' *(length=10)* 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '0' *(length=1)* 18 => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '12658' *(length=5)* 'word_token' => string '18' *(length=2)* 'word' => null 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '31491' *(length=5)* 'de' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '36' *(length=2)* 'word_token' => string 'de' *(length=2)* 'word' => null 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '969451' *(length=6)* 'luxembourg' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '30' *(length=2)* 'word_token' => string 'luxembourg' *(length=10)* 'word' => null 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '637' *(length=3)* 'rt' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '771' *(length=3)* 'word_token' => string 'rt' *(length=2)* 'word' => null 'class' => null 'type' => null 'country_code' => null 'operator' => null 'search_name_count' => string '107327' *(length=6)* ' de' => *array* *(size=1)* 0 => *array* *(size=8)* 'word_id' => string '113327' *(length=6)* 'word_token' => string ' de' *(length=3)* 'word' => null 'class' => null 'type' => null 'country_code' => string 'de' *(length=2)* 'operator' => null 'search_name_count' => string '0' *(length=1)* *array* *(size=12)* 3 => *array* *(size=2)* 0 => *array* *(size=16)* 'iSearchRank' => int 3 'iNamePhrase' => int -1 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=2)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=0)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 3 'iNamePhrase' => int -1 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=0)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 4 => *array* *(size=2)* 0 => *array* *(size=16)* 'iSearchRank' => int 4 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=2)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=0)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 4 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=0)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 6 => *array* *(size=1)* 0 => *array* *(size=16)* 'iSearchRank' => int 6 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=2)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=0)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 7 => *array* *(size=2)* 0 => *array* *(size=16)* 'iSearchRank' => int 7 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=2)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 7 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 8 => *array* *(size=2)* 0 => *array* *(size=16)* 'iSearchRank' => int 8 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=2)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 8 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 9 => *array* *(size=1)* 0 => *array* *(size=16)* 'iSearchRank' => int 9 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=2)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 10 => *array* *(size=1)* 0 => *array* *(size=16)* 'iSearchRank' => int 10 'iNamePhrase' => int 0 'sCountryCode' => boolean false 'aName' => *array* *(size=2)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 11 => *array* *(size=2)* 0 => *array* *(size=16)* 'iSearchRank' => int 11 'iNamePhrase' => int 0 'sCountryCode' => string 'de' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=2)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=1)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 11 'iNamePhrase' => int 0 'sCountryCode' => string 'de' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=1)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 12 => *array* *(size=4)* 0 => *array* *(size=16)* 'iSearchRank' => int 12 'iNamePhrase' => int 0 'sCountryCode' => string 'de' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=2)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=1)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 12 'iNamePhrase' => int 0 'sCountryCode' => string 'lu' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=1)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 2 => *array* *(size=16)* 'iSearchRank' => int 12 'iNamePhrase' => int 0 'sCountryCode' => string 'lu' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=0)* ... 'aFullNameAddress' => *array* *(size=0)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 3 => *array* *(size=16)* 'iSearchRank' => int 12 'iNamePhrase' => int 0 'sCountryCode' => string 'de' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=1)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 13 => *array* *(size=2)* 0 => *array* *(size=16)* 'iSearchRank' => int 13 'iNamePhrase' => int 0 'sCountryCode' => string 'de' *(length=2)* 'aName' => *array* *(size=2)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=1)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 1 => *array* *(size=16)* 'iSearchRank' => int 13 'iNamePhrase' => int 1 'sCountryCode' => string 'lu' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=0)* ... 'aFullNameAddress' => *array* *(size=0)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '18' *(length=2)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 14 => *array* *(size=1)* 0 => *array* *(size=16)* 'iSearchRank' => int 14 'iNamePhrase' => int 0 'sCountryCode' => string 'de' *(length=2)* 'aName' => *array* *(size=2)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=2)* ... 'aNameNonSearch' => *array* *(size=1)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* 15 => *array* *(size=1)* 0 => *array* *(size=16)* 'iSearchRank' => int 15 'iNamePhrase' => int 0 'sCountryCode' => string 'lu' *(length=2)* 'aName' => *array* *(size=1)* ... 'aAddress' => *array* *(size=1)* ... 'aFullNameAddress' => *array* *(size=1)* ... 'aNameNonSearch' => *array* *(size=2)* ... 'aAddressNonSearch' => *array* *(size=0)* ... 'sOperator' => string '' *(length=0)* 'aFeatureName' => *array* *(size=0)* ... 'sClass' => string '' *(length=0)* 'sType' => string '' *(length=0)* 'sHouseNumber' => string '' *(length=0)* 'fLat' => string '' *(length=0)* 'fLon' => string '' *(length=0)* 'fRadius' => string '' *(length=0)* rankName TokensName NotAddress TokensAddress Notcountryoperatorclasstype house#LatLonRadius3# rt de luxembourg(38904)##18(12658)#, #echternach(5049)# 3# rt de luxembourg(38904)##echternach(5049)#184#rt de luxembourg(5636)##18(12658)#, #echternach(5049)#4#rt de luxembourg(5636)##echternach(5049)#186#rt de luxembourg(5636)#, #18(12658)##echternach(5049)#7# luxembourg(11379)##rt(771)#, #de(36)##18(12658)#, #echternach(5049)#7# luxembourg(11379)##rt(771)#, #de(36)##echternach(5049)#188#luxembourg(30)##rt(771)#, #de(36)##18(12658)#, #echternach(5049)#8#luxembourg(30)##rt(771)#, #de(36)##echternach(5049)#189# luxembourg(11379)#, #18(12658)##rt(771)#, #de(36)##echternach(5049)#10#luxembourg(30)#, #18(12658)##rt(771)#, #de(36)##echternach(5049)#11# luxembourg(11379)# #rt(771)##18(12658)#, #echternach(5049)#de11# luxembourg(11379)##rt(771)# #echternach(5049)#de1812#luxembourg(30)##rt(771)##18(12658)#, #echternach(5049)#de12# 18(12657)##rt(771)#, #de(36)##echternach(5049)#lu12# echternach(43215)##rt(771)#, #de(36)#lu1812#luxembourg(30)##rt(771)# #echternach(5049)#de1813# luxembourg(11379)#, #18(12658)##rt(771)# #echternach(5049)#de13#echternach(5049)##rt(771)#, #de(36)#lu1814#luxembourg(30)#, #18(12658)##rt(771)##echternach(5049)#de15#18(12658)##rt(771)#, #de(36)# #echternach(5049)#lu ------------------------------ *Search Loop, group 1, loop 1*rankName TokensName NotAddress TokensAddress Notcountryoperatorclasstypehouse#LatLonRadius3# rt de luxembourg(38904)##18(12658)#, #echternach(5049)# string 'select place_id, (select count(*) from (select unnest(ARRAY[12657,43215]) INTERSECT select unnest(nameaddress_vector))s) as exactmatch from search_name where name_vector @> ARRAY[38904] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[12658,5049] order by (case when importance = 0 OR importance IS NULL then 0.75-(search_rank::float/40) else importance end) DESC, exactmatch DESC limit 20' *(length=402)* *Place IDs:* *array* *(size=0)* *empty* ------------------------------ *Search Loop, group 1, loop 2*rankName TokensName NotAddress TokensAddress Notcountryoperatorclasstypehouse#LatLonRadius3# rt de luxembourg(38904)# #echternach(5049)#18 string 'select place_id, (select count(*) from (select unnest(ARRAY[12657,43215]) INTERSECT select unnest(nameaddress_vector))s) as exactmatch from search_name where name_vector @> ARRAY[38904] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[5049] and address_rank between 16 and 27 order by exists(select place_id from placex where parent_place_id = search_name.place_id and transliteration(housenumber) ~* E'\\m18\\M' limit 1) desc, - abs(26 - address_rank) + 3 DESC, exactmatch DESC limit 20' *(length=500)* string 'select place_id from placex where parent_place_id in (128785,159889,156420,154281,151966,167208,147437,139788,139099,138424,132010,130529,147431,151243,152244,138234,139594,135350,135347) and transliteration(housenumber) ~* E'\\m18\\M' limit 20' *(length=244)* *Place IDs:* *array* *(size=1)* 0 => string '149133' *(length=6)* ------------------------------ string 'select osm_type,osm_id,class,type,admin_level,rank_search,rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id, calculated_country_code as country_code,get_address_by_language(place_id, ARRAY['short_name:nl-NL','short_name:nl','short_name:en-US','short_name:en','short_name:fr','short_name:es','name:nl-NL','name:nl','name:en-US','name:en','name:fr','name:es','place_name:nl-NL','place_name:nl','place_name:en-US','place_name:en','place_name:fr','place_name:es','official_name:nl-NL',''... *(length=4917)* *Recheck words:<\i>array (size=4) 1 => string 'route' (length=5) 3 => string 'de' (length=2) 5 => string 'luxembourg' (length=10) 9 => string 'echternach' (length=10)* -- Dr. ir. Mathias Versichele Information Manager Tel: +32 (09)241.56.35 <%2B32%20%2809%29%2F241.56.35> Mobile: +32 (0)485.16.07.08 <%2B32%20%280%29473.44.59.29> www.geointelligence.be Technologiepark 3 9052 Zwijnaarde BTW: BE0836331228 *RetailSonar Day 2015* *Getting grip on omnichannel dynamics**Subscribe now! <https://retailsonar.com/retailsonar-day-2015-getting-grip-on-omnichannel-dynamics/>* <http://www.geointelligence.be/home-2/>
_______________________________________________ Geocoding mailing list [email protected] https://lists.openstreetmap.org/listinfo/geocoding
