[Geocoding] Nominatim query returns weird output instead of json
Mathias Versichele
mathias.versichele at geointelligence.be
Tue May 19 09:03:32 UTC 2015
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/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20150519/a041bf53/attachment-0001.html>
More information about the Geocoding
mailing list