[Geocoding] Error in Address looks like it always converts "Grand" to "gr"

Thu Mar 7 20:28:29 UTC 2019

Hi Looks like it changes Grand to gr and doesn't find the address!!!
Thanks, Bill

Debug output for Geocode::lookup
Geocode:  'Query' => '420 Grand Oak Hillsborough, NC USA'
          'Structured query' => False
          'Name keys' => 'short_name:en-US', 'name:en-US', 'short_name:en', 'name:en', 'short_name', 'name', 'brand', 'official_name:en-US', 'official_name:en', 'official_name', 'ref', 'type'
          'Excluded place IDs' => 
          'Try reversed query' => True
          'Limit (for searches)' => 20
          'Limit (for results)' => 10
          'Country codes' => 
          'Bounded search' => False
          'Viewbox' => 
          'Route points' => 
          'Route width' => False
          'Max rank' => 20
          'Min address rank' => 0
          'Max address rank' => 30
          'Address rank list' => 
Query Preprocessing
Normalized query:  '420 grand oak hillsborough nc usa'Search context:  'Near radius' => False
                 'Near point (SQL)' => ''
                 'Bounded viewbox' => False
                 'Viewbox (SQL, small)' => ''
                 'Viewbox (SQL, large)' => ''
                 'Viewbox (SQL, centre)' => ''
                 'Countries (SQL)' => ''
                 'Excluded IDs (SQL)' => ''Base search:  'Search rank' => 0
              'Country code' => ''
              'Name terms' => 
              'Name terms (stop words)' => 
              'Address terms' => 
              'Address terms (stop words)' => 
              'Address terms (full words)' => 
              'Special search' => 0
              'Class' => ''
              'Type' => ''
              'House number' => ''
              'Postcode' => ''Final query phrases:  0 => '420 Grand Oak Hillsborough'
                      1 => ' NC USA'
Tokenization
Phrases:
| Type | Phrase | Words | WordSets |
| '' | '420 gr oak hillsborough' | 0 => '420'
1 => 'gr'
2 => 'oak'
3 => 'hillsborough' | 0 => 0 => '420 gr oak hillsborough'
1 => 0 => '420'
     1 => 'gr oak hillsborough'
2 => 0 => '420'
     1 => 'gr'
     2 => 'oak hillsborough'
3 => 0 => '420'
     1 => 'gr'
     2 => 'oak'
     3 => 'hillsborough'
4 => 0 => '420'
     1 => 'gr oak'
     2 => 'hillsborough'
5 => 0 => '420 gr'
     1 => 'oak hillsborough'
6 => 0 => '420 gr'
     1 => 'oak'
     2 => 'hillsborough'
7 => 0 => '420 gr oak'
     1 => 'hillsborough' |
| '' | 'nc usa' | 0 => 'nc'
1 => 'usa' | 0 => 0 => 'nc usa'
1 => 0 => 'nc'
     1 => 'usa' |

Tokens:  ' 420 gr oak hillsborough' => ' 420 gr oak hillsborough'
         '420 gr oak hillsborough' => '420 gr oak hillsborough'
         ' 420' => ' 420'
         420 => '420'
         ' gr oak hillsborough' => ' gr oak hillsborough'
         'gr oak hillsborough' => 'gr oak hillsborough'
         ' gr' => ' gr'
         'gr' => 'gr'
         ' oak hillsborough' => ' oak hillsborough'
         'oak hillsborough' => 'oak hillsborough'
         ' oak' => ' oak'
         'oak' => 'oak'
         ' hillsborough' => ' hillsborough'
         'hillsborough' => 'hillsborough'
         ' gr oak' => ' gr oak'
         'gr oak' => 'gr oak'
         ' 420 gr' => ' 420 gr'
         '420 gr' => '420 gr'
         ' 420 gr oak' => ' 420 gr oak'
         '420 gr oak' => '420 gr oak'
         ' nc usa' => ' nc usa'
         'nc usa' => 'nc usa'
         ' nc' => ' nc'
         'nc' => 'nc'
         ' usa' => ' usa'
         'usa' => 'usa'
SELECT word_id, word_token, word, class, type, country_code, operator, search_name_count FROM word WHERE word_token in (' 420 gr oak hillsborough','420 gr oak hillsborough',' 420','420',' gr oak hillsborough','gr oak hillsborough',' gr','gr',' oak hillsborough','oak hillsborough',' oak','oak',' hillsborough','hillsborough',' gr oak','gr oak',' 420 gr','420 gr',' 420 gr oak','420 gr oak',' nc usa','nc usa',' nc','nc',' usa','usa')

SELECT word_id, word_token, word, class, type, country_code, operator, coalesce(search_name_count, 0) as count FROM word WHERE word_token in (' 420 gr oak hillsborough','420 gr oak hillsborough',' 420','420',' gr oak hillsborough','gr oak hillsborough',' gr','gr',' oak hillsborough','oak hillsborough',' oak','oak',' hillsborough','hillsborough',' gr oak','gr oak',' 420 gr','420 gr',' 420 gr oak','420 gr oak',' nc usa','nc usa',' nc','nc',' usa','usa')
Valid Tokens:
| Group | ID | Type | Info |
| 420 | 655694 | 'word' | 'partial' => True
'count' => 5217 |
|  420 | 1690243 | 'word' | 'partial' => False
'count' => 1171 |
|  420 | 52572346 | 'postcode' | '420()' |
|  420 | 51767594 | 'house number' | 'nr' => '420' |
| gr | 182581 | 'word' | 'partial' => True
'count' => 180258 |
|  gr | 3784453 | 'word' | 'partial' => False
'count' => 1870 |
|  gr | 54678847 | 'country' | 'gr' |
|  gr | 52145780 | 'house number' | 'nr' => 'gr' |
|  gr oak | 17092488 | 'word' | 'partial' => False
'count' => 9 |
| gr oak | 17092489 | 'word' | 'partial' => True
'count' => 0 |
| hillsborough | 1064958 | 'word' | 'partial' => True
'count' => 1170 |
|  hillsborough | 18523891 | 'word' | 'partial' => False
'count' => 34 |
| nc | 959784 | 'word' | 'partial' => True
'count' => 11770 |
|  nc | 27720391 | 'word' | 'partial' => False
'count' => 47 |
|  nc | 54679020 | 'country' | 'nc' |
|  nc | 52129535 | 'house number' | 'nr' => 'nc' |
| oak | 770548 | 'word' | 'partial' => True
'count' => 82366 |
|  oak | 28614548 | 'word' | 'partial' => False
'count' => 429 |
|  oak | 52132316 | 'house number' | 'nr' => 'oak' |
| usa | 34685 | 'word' | 'partial' => True
'count' => 1750 |
|  usa | 34684 | 'word' | 'partial' => False
'count' => 117 |
|  usa | 54626835 | 'country' | 'us' |

Search candidates

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 7 | # gr oak(17092488)# | 
 | #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 8 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |
| 8 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |
| 8 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | nc |
| 8 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | nc |
| 8 | # 420(1690243)# | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 
 |
| 8 | # 420(1690243)# | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 
 |
| 8 | # gr(3784453)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 8 | # gr oak(17092488)# | 
 | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 8 | 
 | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | POSTCODE | 
 | 
 | 
 | 
 |
| 8 | 
 | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | POSTCODE | 
 | 
 | 
 | 
 |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | nc |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | nc |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 9 | # 420(1690243)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | #gr(182581)# | us | 
 | 
 | 
 | 
 | 
 |
| 9 | # 420(1690243)# | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 9 | # 420(1690243)# | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 9 | # 420(1690243)# | 
 | # gr(3784453)#, #hillsborough(1064958)#, #nc(959784)# | #oak(770548)# | us | 
 | 
 | 
 | 
 | 
 |
| 9 | # 420(1690243)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | gr |
| 9 | # 420(1690243)# | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)# | 
 | us | 
 | 
 | 
 | 
 | nc |
| 9 | # 420(1690243)# | 
 | # gr oak(17092488)#, #hillsborough(1064958)# | 
 | us | 
 | 
 | 
 | 
 | nc |
| 9 | # gr(3784453)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 9 | # gr(3784453)# | 
 | #hillsborough(1064958)#, #nc(959784)# | #oak(770548)# | us | 
 | 
 | 
 | 
 | 420 |
| 9 | #gr oak(17092489)#, #hillsborough(1064958)# | 
 | #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 9 | #gr oak(17092489)# | 
 | #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 9 | 
 | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | POSTCODE | 
 | 
 | 
 | 
 |
| 9 | 
 | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | POSTCODE | 
 | 
 | 
 | 
 |
| 9 | 
 | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | #gr(182581)# | us | POSTCODE | 
 | 
 | 
 | 
 |
| 9 | 
 | 
 | # gr(3784453)#, #hillsborough(1064958)#, #nc(959784)# | #oak(770548)# | us | POSTCODE | 
 | 
 | 
 | 
 |
| 10 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |
| 10 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |
| 10 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)# | #oak(770548)#, #gr(182581)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, #420(655694)# | #gr(182581)# | 
 | 
 | 
 | 
 | 
 | 
 |
| 10 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#, #420(655694)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | 
 |
| 10 | # usa(34684)# | 
 | #hillsborough(1064958)# | #oak(770548)#, #gr(182581)# | 
 | 
 | 
 | 
 | 420 | nc |
| 10 | #usa(34685)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | nc |
| 10 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, #420(655694)# | #gr(182581)# | 
 | 
 | 
 | 
 | 
 | nc |
| 10 | #usa(34685)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | nc |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)# | 
 | 
 | 
 | 
 | 
 | 420 | gr |
| 10 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr(3784453)#, #420(655694)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | nc |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | oak |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 
 | 420 |
| 10 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | 420 |
| 10 | # 420(1690243)# | 
 | #hillsborough(1064958)#, #nc(959784)# | #gr(182581)#, #oak(770548)# | us | 
 | 
 | 
 | 
 | 
 |
| 10 | # 420(1690243)# | 
 | # gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | 
 |
| 10 | # 420(1690243)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #gr(182581)# | 
 | 
 | 
 | 
 | 
 | 
 |
| 10 | # 420(1690243)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | gr |
| 10 | # 420(1690243)# | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |
| 10 | # 420(1690243)# | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |
| 10 | # 420(1690243)# | 
 | # oak(28614548)#, #hillsborough(1064958)# | #gr(182581)# | us | 
 | 
 | 
 | 
 | nc |
| 10 | # 420(1690243)# | 
 | # gr(3784453)#, #hillsborough(1064958)# | #oak(770548)# | us | 
 | 
 | 
 | 
 | nc |
| 10 | # 420(1690243)# | 
 | #hillsborough(1064958)#, #nc(959784)# | #oak(770548)# | us | 
 | 
 | 
 | 
 | gr |
| 10 | #gr oak(17092489)# | 
 | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 10 | #gr oak(17092489)#, #hillsborough(1064958)# | 
 | #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 10 | # oak(28614548)# | #gr(182581)# | #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 10 | # gr(3784453)# | 
 | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | 420 |
| 10 | # 420(1690243)# | 
 | # gr(3784453)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | oak |
| 10 | # oak(28614548)#, #hillsborough(1064958)# | #gr(182581)# | #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 10 | 
 | 
 | # gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #oak(770548)# | 
 | POSTCODE | 
 | 
 | 
 | 
 |
| 10 | 
 | 
 | #hillsborough(1064958)#, #nc(959784)# | #gr(182581)#, #oak(770548)# | us | POSTCODE | 
 | 
 | 
 | 
 |
| 10 | 
 | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #gr(182581)# | 
 | POSTCODE | 
 | 
 | 
 | 
 |
| 11 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 11 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 11 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 11 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 11 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 11 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 11 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, #420(655694)# | #oak(770548)#, #gr(182581)# | 
 | 
 | 
 | 
 | 
 | 
 |
| 11 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |
| 11 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | 
 |
| 11 | #usa(34685)# | 
 | #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | nc |
| 11 | #usa(34685)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |
| 11 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | gr |
| 11 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | gr |
| 11 | #usa(34685)# | 
 | #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | nc |
| 11 | #usa(34685)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |
| 11 | # usa(34684)# | 
 | #hillsborough(1064958)#, #420(655694)# | #oak(770548)#, #gr(182581)# | 
 | 
 | 
 | 
 | 
 | nc |
| 11 | #usa(34685)#, #nc(959784)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 11 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)# | #oak(770548)#, #gr(182581)# | 
 | 
 | 
 | 
 | 
 | 420 |
| 11 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | oak |
| 11 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | oak |
| 11 | # 420(1690243)# | 
 | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #gr(182581)#, #oak(770548)# | 
 | 
 | 
 | 
 | 
 | 
 |
| 11 | # 420(1690243)# | 
 | #hillsborough(1064958)# | #gr(182581)#, #oak(770548)# | us | 
 | 
 | 
 | 
 | nc |
| 11 | # 420(1690243)# | 
 | # gr(3784453)#, #hillsborough(1064958)#, #usa(34685)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | nc |
| 11 | # 420(1690243)# | 
 | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | #oak(770548)# | 
 | 
 | 
 | 
 | 
 | gr |
| 11 | # 420(1690243)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #usa(34685)# | #gr(182581)# | 
 | 
 | 
 | 
 | 
 | nc |
| 11 | # 420(1690243)# | 
 | # gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | oak |
| 11 | # oak(28614548)#, #hillsborough(1064958)# | #gr(182581)# | #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 11 | # oak(28614548)# | #gr(182581)# | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |
| 11 | # hillsborough(18523891)# | #gr(182581)#, #oak(770548)# | #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |
| 11 | # 420(1690243)# | 
 | #hillsborough(1064958)#, #nc(959784)# | #gr(182581)# | us | 
 | 
 | 
 | 
 | oak |

Search Loop, group 1, loop 1

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 7 | # gr oak(17092488)# | 
 | #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[18523891,27720391,34684]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[17092488] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,959784] and country_code = 'us' 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'\\m420\\M' LIMIT 1) OR EXISTS( SELECT place_id FROM location_property_osmline WHERE parent_place_id = search_name.place_id AND startnumber is not NULL AND 420>=startnumber AND 420<=endnumber LIMIT 1)) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 2, loop 2

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,28614548,3784453] ORDER BY (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 2, loop 3

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,17092488] ORDER BY (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 2, loop 4

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 420 | nc |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,17092488] 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'\\mnc\\M' LIMIT 1) ) DESC, (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 2, loop 5

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | nc |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,28614548,3784453] 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'\\mnc\\M' LIMIT 1) ) DESC, (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 2, loop 6

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # 420(1690243)# | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[18523891,27720391,34684]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[1690243] and nameaddress_vector @> ARRAY[17092488,1064958,959784] and country_code = 'us' ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 2, loop 7

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # 420(1690243)# | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[3784453,28614548,18523891,27720391,34684]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[1690243] and nameaddress_vector @> ARRAY[3784453,28614548,1064958,959784] and country_code = 'us' ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 2, loop 8

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # gr(3784453)# | 
 | # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | 
 | 
 | 
 | 
 | 420 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[28614548,18523891,27720391,34684]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[3784453] and nameaddress_vector @> ARRAY[28614548,1064958,959784] and country_code = 'us' 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'\\m420\\M' LIMIT 1) OR EXISTS( SELECT place_id FROM location_property_osmline WHERE parent_place_id = search_name.place_id AND startnumber is not NULL AND 420>=startnumber AND 420<=endnumber LIMIT 1)) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 2, loop 9

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | # gr oak(17092488)# | 
 | #hillsborough(1064958)#, #nc(959784)#, #usa(34685)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[18523891,27720391,34684]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[17092488] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,959784,34685] 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'\\m420\\M' LIMIT 1) OR EXISTS( SELECT place_id FROM location_property_osmline WHERE parent_place_id = search_name.place_id AND startnumber is not NULL AND 420>=startnumber AND 420<=endnumber LIMIT 1)) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 2, loop 10

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | 
 | 
 | # gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | POSTCODE | 
 | 
 | 
 | 
 |

SELECT p.place_id FROM location_postcode p , search_name s WHERE s.place_id = p.parent_place_id AND array_cat(s.nameaddress_vector, s.name_vector) @> ARRAY[17092488,1064958,959784] AND p.postcode = '420' AND p.country_code = 'us' LIMIT 20
Place IDs:

Search Loop, group 2, loop 11

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 8 | 
 | 
 | # gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)# | 
 | us | POSTCODE | 
 | 
 | 
 | 
 |

SELECT p.place_id FROM location_postcode p , search_name s WHERE s.place_id = p.parent_place_id AND array_cat(s.nameaddress_vector, s.name_vector) @> ARRAY[3784453,28614548,1064958,959784] AND p.postcode = '420' AND p.country_code = 'us' LIMIT 20
Place IDs:

Search Loop, group 3, loop 12

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,28614548,3784453,655694] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 3, loop 13

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,28614548] ORDER BY (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 3, loop 14

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,3784453] ORDER BY (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 3, loop 15

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,17092488,655694] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 3, loop 16

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,17092488,655694] 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'\\mnc\\M' LIMIT 1) ) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 3, loop 17

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # gr(3784453)# | #oak(770548)# | 
 | 
 | 
 | 
 | 420 | nc |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,3784453] 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'\\mnc\\M' LIMIT 1) ) DESC, (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 3, loop 18

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | nc |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,28614548,3784453,655694] 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'\\mnc\\M' LIMIT 1) ) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 3, loop 19

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #hillsborough(1064958)#, # oak(28614548)# | #gr(182581)# | 
 | 
 | 
 | 
 | 420 | nc |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[1064958,28614548] 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'\\mnc\\M' LIMIT 1) ) DESC, (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 3, loop 20

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,28614548,3784453] 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'\\m420\\M' LIMIT 1) OR EXISTS( SELECT place_id FROM location_property_osmline WHERE parent_place_id = search_name.place_id AND startnumber is not NULL AND 420>=startnumber AND 420<=endnumber LIMIT 1)) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 3, loop 21

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 9 | # usa(34684)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)# | 
 | 
 | 
 | 
 | 
 | 
 | 420 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34684] and array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[959784,1064958,17092488] 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'\\m420\\M' LIMIT 1) OR EXISTS( SELECT place_id FROM location_property_osmline WHERE parent_place_id = search_name.place_id AND startnumber is not NULL AND 420>=startnumber AND 420<=endnumber LIMIT 1)) DESC, - abs(26 - address_rank) + 3 DESC, exactmatch DESC LIMIT 40
Place IDs:

Search Loop, group 4, loop 22

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 10 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)# | 
 | 
 | 
 | 
 | 
 | 420 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34685] and nameaddress_vector @> ARRAY[959784,1064958,28614548,3784453] ORDER BY (SELECT min(ST_Distance(search_name.centroid, p.geometry)) FROM location_postcode p WHERE p.postcode = '420'), (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

Search Loop, group 5, loop 23

| rank | Name Tokens | Name Not | Address Tokens | Address Not | country | operator | class | type | postcode | housenumber |
| 11 | #usa(34685)# | 
 | #nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)# | 
 | 
 | 
 | 
 | 
 | 
 | 
 |

SELECT place_id, ( SELECT count(*) FROM ( SELECT unnest(ARRAY[27720391,18523891,28614548,3784453,1690243]) INTERSECT SELECT unnest(nameaddress_vector) ) s) as exactmatch FROM search_name WHERE name_vector @> ARRAY[34685] and nameaddress_vector @> ARRAY[959784,1064958,28614548,3784453,655694] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC, exactmatch DESC LIMIT 20
Place IDs:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20190307/7f9fe14e/attachment-0001.html>