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:
_______________________________________________
Geocoding mailing list
Geocoding@openstreetmap.org
https://lists.openstreetmap.org/listinfo/geocoding
