[Geocoding] gazetteer-index.sql explained

[Brian Quinion]

On Sat, Jan 23, 2010 at 5:48 PM, Frans Hals <fhals7 at googlemail.com> wrote:
> Thanks for your quick reply.
> I first tried to use util.update.php as you suggested before but didn't come
> to a result:
>
> PHP Notice:  Undefined index:  index-instances in
> /store/osm/applications/utils/export/osm2pgsql/gazetteer/util.update.php on
> line 236
> Rank: 1, total to do: 0
>
> This happened to me for all ranks up to 30.

The message is just a warning - I suspect the problem is that I've
once again accidentally committed the file pointing at gazetteerworld
instead of the default gazetteer database.  I need to be more careful.

I've updated the file and added some extra error checking.  At the
very least it should now tell you what the problem is.  Do an svn
update to get the new version.

If you still don't get anything try running:

select geometry_index(geometry,indexed,name),count(*) from placex
where rank_search = 26 and indexed = false and name is not null group
by geometry_index(geometry,indexed,name);

if you don't get any lines back then it thinks there is nothing that
needs indexing - which would be weard!  If something comes back you
are either on the wrong database or its a permissions problem?

--
 Brian