[Geocoding] gazetteer-index.sql explained

[Frans Hals]

Hi Brian,

now it's running nicely verbose:

Rank: 0, total to do: 0
[...]
Rank: 24, total to do: 0
Rank: 25, total to do: 74241
355538: 1, 74241 remaining (15:32:37)
360464: 1, 74240 remaining (15:34:12)
365465: 2, 74239 remaining (15:35:47)

BTW: Line 88, 94 and 138 still referenced gazetteerworld.

Thanks
Frans


> 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/88a3c399/attachment.html>