<html><head></head><body><div class="ydpc35fa67fyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">Hi Looks like it changes Grand to gr and doesn't find the address!!!</div><div class="ydpc35fa67fyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><br></div><div class="ydpc35fa67fyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">Thanks, Bill<br></div><div class="ydpc35fa67fyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><br></div><div class="ydpc35fa67fyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><span><pre><h2>Debug output for Geocode::lookup</h2></pre>
<pre><b>Geocode:</b> 'Query' => '420 Grand Oak Hillsborough, NC USA'
'Structured query' => <i>False</i>
'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' => <i>True</i>
'Limit (for searches)' => 20
'Limit (for results)' => 10
'Country codes' =>
'Bounded search' => <i>False</i>
'Viewbox' =>
'Route points' =>
'Route width' => <i>False</i>
'Max rank' => 20
'Min address rank' => 0
'Max address rank' => 30
'Address rank list' => </pre>
<hr><pre><h3>Query Preprocessing</h3></pre>
<pre><b>Normalized query:</b> '420 grand oak hillsborough nc usa'</pre>
<pre><b>Search context:</b> 'Near radius' => <i>False</i>
'Near point (SQL)' => ''
'Bounded viewbox' => <i>False</i>
'Viewbox (SQL, small)' => ''
'Viewbox (SQL, large)' => ''
'Viewbox (SQL, centre)' => ''
'Countries (SQL)' => ''
'Excluded IDs (SQL)' => ''</pre>
<pre><b>Base search:</b> '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' => ''</pre>
<pre><b>Final query phrases:</b> 0 => '420 Grand Oak Hillsborough'
1 => ' NC USA'</pre>
<hr><pre><h3>Tokenization</h3></pre>
<b>Phrases:</b>
<table class="yahoo-compose-table-card" border="1">
<tbody><tr>
<th><small>Type</small></th>
<th><small>Phrase</small></th>
<th><small>Words</small></th>
<th><small>WordSets</small></th>
</tr>
<tr>
<td><pre>''</pre></td>
<td><pre>'420 gr oak hillsborough'</pre></td>
<td><pre>0 => '420'
1 => 'gr'
2 => 'oak'
3 => 'hillsborough'</pre></td>
<td><pre>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'</pre></td>
</tr>
<tr>
<td><pre>''</pre></td>
<td><pre>'nc usa'</pre></td>
<td><pre>0 => 'nc'
1 => 'usa'</pre></td>
<td><pre>0 => 0 => 'nc usa'
1 => 0 => 'nc'
1 => 'usa'</pre></td>
</tr>
</tbody></table>
<pre><b>Tokens:</b> ' 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'</pre>
<p><tt><font color="#aaa">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')</font></tt></p>
<p><tt><font color="#aaa">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')</font></tt></p>
<b>Valid Tokens:</b>
<table class="yahoo-compose-table-card" border="1">
<tbody><tr>
<th><small>Group</small></th>
<th><small>ID</small></th>
<th><small>Type</small></th>
<th><small>Info</small></th>
</tr>
<tr>
<td><pre>420</pre></td>
<td><pre>655694</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 5217</pre></td>
</tr>
<tr>
<td><pre> 420</pre></td>
<td><pre>1690243</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 1171</pre></td>
</tr>
<tr>
<td><pre> 420</pre></td>
<td><pre>52572346</pre></td>
<td><pre>'postcode'</pre></td>
<td><pre>'420()'</pre></td>
</tr>
<tr>
<td><pre> 420</pre></td>
<td><pre>51767594</pre></td>
<td><pre>'house number'</pre></td>
<td><pre>'nr' => '420'</pre></td>
</tr>
<tr>
<td><pre>gr</pre></td>
<td><pre>182581</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 180258</pre></td>
</tr>
<tr>
<td><pre> gr</pre></td>
<td><pre>3784453</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 1870</pre></td>
</tr>
<tr>
<td><pre> gr</pre></td>
<td><pre>54678847</pre></td>
<td><pre>'country'</pre></td>
<td><pre>'gr'</pre></td>
</tr>
<tr>
<td><pre> gr</pre></td>
<td><pre>52145780</pre></td>
<td><pre>'house number'</pre></td>
<td><pre>'nr' => 'gr'</pre></td>
</tr>
<tr>
<td><pre> gr oak</pre></td>
<td><pre>17092488</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 9</pre></td>
</tr>
<tr>
<td><pre>gr oak</pre></td>
<td><pre>17092489</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 0</pre></td>
</tr>
<tr>
<td><pre>hillsborough</pre></td>
<td><pre>1064958</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 1170</pre></td>
</tr>
<tr>
<td><pre> hillsborough</pre></td>
<td><pre>18523891</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 34</pre></td>
</tr>
<tr>
<td><pre>nc</pre></td>
<td><pre>959784</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 11770</pre></td>
</tr>
<tr>
<td><pre> nc</pre></td>
<td><pre>27720391</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 47</pre></td>
</tr>
<tr>
<td><pre> nc</pre></td>
<td><pre>54679020</pre></td>
<td><pre>'country'</pre></td>
<td><pre>'nc'</pre></td>
</tr>
<tr>
<td><pre> nc</pre></td>
<td><pre>52129535</pre></td>
<td><pre>'house number'</pre></td>
<td><pre>'nr' => 'nc'</pre></td>
</tr>
<tr>
<td><pre>oak</pre></td>
<td><pre>770548</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 82366</pre></td>
</tr>
<tr>
<td><pre> oak</pre></td>
<td><pre>28614548</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 429</pre></td>
</tr>
<tr>
<td><pre> oak</pre></td>
<td><pre>52132316</pre></td>
<td><pre>'house number'</pre></td>
<td><pre>'nr' => 'oak'</pre></td>
</tr>
<tr>
<td><pre>usa</pre></td>
<td><pre>34685</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>True</i>
'count' => 1750</pre></td>
</tr>
<tr>
<td><pre> usa</pre></td>
<td><pre>34684</pre></td>
<td><pre>'word'</pre></td>
<td><pre>'partial' => <i>False</i>
'count' => 117</pre></td>
</tr>
<tr>
<td><pre> usa</pre></td>
<td><pre>54626835</pre></td>
<td><pre>'country'</pre></td>
<td><pre>'us'</pre></td>
</tr>
</tbody></table>
<hr><pre><h3>Search candidates</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>7</td><td># gr oak(17092488)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>8</td><td># 420(1690243)#</td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>8</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>8</td><td># gr(3784453)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>8</td><td># gr oak(17092488)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>8</td><td><br></td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>8</td><td><br></td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td>#gr(182581)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#</td><td>#oak(770548)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>gr</td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>9</td><td># 420(1690243)#</td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>9</td><td># gr(3784453)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>9</td><td># gr(3784453)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td>#oak(770548)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>9</td><td>#gr oak(17092489)#, #hillsborough(1064958)#</td><td><br></td><td>#nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>9</td><td>#gr oak(17092489)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>9</td><td><br></td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td><br></td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td><br></td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td>#gr(182581)#</td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>9</td><td><br></td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#</td><td>#oak(770548)#</td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>10</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>10</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#</td><td>#oak(770548)#, #gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, #420(655694)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#, #420(655694)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#</td><td>#oak(770548)#, #gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>10</td><td>#usa(34685)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, #420(655694)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>10</td><td>#usa(34685)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>gr</td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr(3784453)#, #420(655694)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>oak</td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td>#gr(182581)#, #oak(770548)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>gr</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#</td><td>#gr(182581)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#</td><td>#oak(770548)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td>#oak(770548)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>gr</td></tr><tr><td>10</td><td>#gr oak(17092489)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td>#gr oak(17092489)#, #hillsborough(1064958)#</td><td><br></td><td>#nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td># oak(28614548)#</td><td>#gr(182581)#</td><td>#hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td># gr(3784453)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>oak</td></tr><tr><td>10</td><td># oak(28614548)#, #hillsborough(1064958)#</td><td>#gr(182581)#</td><td>#nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>10</td><td><br></td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#oak(770548)#</td><td><br></td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td><br></td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td>#gr(182581)#, #oak(770548)#</td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>10</td><td><br></td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#gr(182581)#</td><td><br></td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, #420(655694)#</td><td>#oak(770548)#, #gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>gr</td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>gr</td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, #420(655694)#</td><td>#oak(770548)#, #gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>11</td><td>#usa(34685)#, #nc(959784)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#</td><td>#oak(770548)#, #gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>oak</td></tr><tr><td>11</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>oak</td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#gr(182581)#, #oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td>#hillsborough(1064958)#</td><td>#gr(182581)#, #oak(770548)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #usa(34685)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>gr</td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #usa(34685)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, #hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>oak</td></tr><tr><td>11</td><td># oak(28614548)#, #hillsborough(1064958)#</td><td>#gr(182581)#</td><td>#nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>11</td><td># oak(28614548)#</td><td>#gr(182581)#</td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>11</td><td># hillsborough(18523891)#</td><td>#gr(182581)#, #oak(770548)#</td><td>#nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr><tr><td>11</td><td># 420(1690243)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td>#gr(182581)#</td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>oak</td></tr></tbody></table><hr><pre><h3>Search Loop, group 1, loop 1</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>7</td><td># gr oak(17092488)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 2</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 3</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 4</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 5</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 6</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># 420(1690243)#</td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 7</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># 420(1690243)#</td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 8</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># gr(3784453)#</td><td><br></td><td># oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 9</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td># gr oak(17092488)#</td><td><br></td><td>#hillsborough(1064958)#, #nc(959784)#, #usa(34685)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 10</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td><br></td><td><br></td><td># gr oak(17092488)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 2, loop 11</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>8</td><td><br></td><td><br></td><td># gr(3784453)#, # oak(28614548)#, #hillsborough(1064958)#, #nc(959784)#</td><td><br></td><td>us</td><td>POSTCODE</td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 12</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 13</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 14</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 15</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 16</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr oak(17092488)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 17</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # gr(3784453)#</td><td>#oak(770548)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 18</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>nc</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 19</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#hillsborough(1064958)#, # oak(28614548)#</td><td>#gr(182581)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td>nc</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 20</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 3, loop 21</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>9</td><td># usa(34684)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # gr oak(17092488)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 4, loop 22</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>10</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td>420</td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
<hr><pre><h3>Search Loop, group 5, loop 23</h3></pre>
<table class="yahoo-compose-table-card" border="1"><tbody><tr><th>rank</th><th>Name Tokens</th><th>Name Not</th><th>Address Tokens</th><th>Address Not</th><th>country</th><th>operator</th><th>class</th><th>type</th><th>postcode</th><th>housenumber</th></tr><tr><td>11</td><td>#usa(34685)#</td><td><br></td><td>#nc(959784)#, #hillsborough(1064958)#, # oak(28614548)#, # gr(3784453)#, #420(655694)#</td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td><td><br></td></tr></tbody></table><p><tt><font color="#aaa">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</font></tt></p>
<b>Place IDs:</b>
<table class="yahoo-compose-table-card" border="1">
</table>
</span><br></div></body></html>