[Geocoding] Nominatim Install Problems

[Ciprian Talaba]

On Thu, Dec 10, 2009 at 8:03 PM, Jason Surratt <jason.surratt at spadac.com>wrote:

>  Hello,
>
>
>
> I have about 4 million addresses that I need to geocode. These addresses
> are mostly in the US, but about 200K of them are in Europe and a smattering
> elsewhere. I already have an approach for geocoding US addresses, but I'd
> like to try using Nominatim for geocoding the non-US addresses.
>
>
>
> Rather than inappropriately slamming the Nominatim server with bulk
> requests I'm trying to install Nominatim on one of my Linux boxes. However,
> I'm running into some problems getting it installed.
>
>
>
> I installed osm2pgsql using the instructions here:
> http://wiki.openstreetmap.org/wiki/Osm2pgsql
>
>
>
> Then I used this <
> http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer/README.txt>
> as a template for ingesting the planet-latest.osm data and building the
> indexes. The exact commands I've run are at the bottom of the email.
>
>
>
> The only error messages of consequence that I receive relate to inserting
> data into placex from place during the gazetteer-index.sql. This appears to
> be due to an SRID constraint, but that seems appropriate as the tables have
> different SRIDs. The other ERROR messages relate to missing "IF EXISTS" in
> drop commands.
>
>
>
> After the import completes I can access the search page and the searches
> complete, however it always returns an empty result set. I'm not sure what I
> should look at in the database for clues, but when poking around the word
> table it appears that only data related to the import*.sql files is
> available.
>
>
>
> When I run the optional util.update.php I get the following error:
>
>                 Call to undefined method DB_Error::setFetchMode() in
> /var/lib/pgsql/gazetteer/util.update.php on line 45
>
>


You can try to set debug mode (in website/.htlib/settings.php) to get more
info about the queries and their results.

--Ciprian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20091211/8c25bd6e/attachment.html>