On Thu, Dec 10, 2009 at 8:03 PM, Jason Surratt <[email protected]>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
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
