[Geocoding] gazetteer-index.sql explained

[Frans Hals]

I found and changed the points to gazetteerworld before receiving these
errors.
Will SVN the new one and make the checks.

Thanks for your help!

Frans

2010/1/23 Brian Quinion <openstreetmap at brian.quinion.co.uk>

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20100123/6c8eaa8e/attachment.html>