<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hello,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I installed osm2pgsql using the instructions here: <a
href="http://wiki.openstreetmap.org/wiki/Osm2pgsql">http://wiki.openstreetmap.org/wiki/Osm2pgsql</a><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Then I used this <<a
href="http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer/README.txt">http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer/README.txt</a>>
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.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>When I run the optional util.update.php I get the following
error:<o:p></o:p></p>
<p class=MsoNormal> Call to undefined method DB_Error::setFetchMode()
in /var/lib/pgsql/gazetteer/util.update.php on line 45<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Any help would be greatly appreciated.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Cheers!<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>-jason<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Version info:<o:p></o:p></p>
<p class=MsoNormal>gazetteer/osm2pgsql - SVN revision 19015<o:p></o:p></p>
<p class=MsoNormal>CentOS 5.3<o:p></o:p></p>
<p class=MsoNormal>PostgreSQL 8.3.8<o:p></o:p></p>
<p class=MsoNormal>PHP 5.1.6<o:p></o:p></p>
<p class=MsoNormal>PostGIS 1.3.6-1<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Commands used for ingest:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>pg_ctl -D /dfs/data1/pgsql-data/ -l
/var/log/pgsql stop<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>sleep 3<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>rm -rf /dfs/data1/pgsql-data ||
exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>initdb -D /dfs/data1/pgsql-data ||
exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>pg_ctl -D /dfs/data1/pgsql-data/ -l
/var/log/pgsql start<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>sleep 3<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>createuser -s osm || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>createdb -E UTF8 -O osm gazetteer
|| exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>createlang plpgsql gazetteer ||
exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>psql -d gazetteer -f
/usr/share/pgsql/contrib/_int.sql || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>psql -d gazetteer -f
/usr/share/pgsql/contrib/pg_trgm.sql || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'># README says
"lwpostgis.sql", but I assume "lwpostgis-64.sql" is
appropriate for a 64bit machine<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>psql -d gazetteer -f
/usr/share/pgsql/contrib/lwpostgis-64.sql || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>psql -d gazetteer -f
/usr/share/pgsql/contrib/spatial_ref_sys.sql || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>psql -d gazetteer -f
/usr/share/osm2pgsql/900913.sql || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>echo running osm2pgsql<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'># I receive the same errors when
using the planet-latest.osm. to make tests faster I've been testing w/ the<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'># cloudmade denmark.osm file
acquired here:<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'># <a
href="http://downloads.cloudmade.com/europe/denmark#breadcrumbs">http://downloads.cloudmade.com/europe/denmark#breadcrumbs</a><o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>/usr/share/osm2pgsql/osm2pgsql -lsc
-C 2048 -O gazetteer -U postgres -m -d gazetteer /dfs/data1/osm/denmark.osm.bz2
|| exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cd /var/lib/pgsql/gazetteer<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>echo osm2pgsql done<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>createuser -SDR www-data<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>createuser -SDR apache<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_worldboundaries.sql |
sed -e s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'># README says to run these after
the import*sql files, but I get function missing errors if I do that.<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>echo loading functions<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'># The first time through causes errors
b/c of dependencies. The second pass errors are the interesting ones.<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat gazetteer-functions.sql | psql
-d gazetteer 2> /dev/null > /dev/null || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>echo loading tables<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat gazetteer-tables.sql | psql -d
gazetteer || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>echo loading functions again<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat gazetteer-functions.sql | psql
-d gazetteer || exit -1<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_country_name.sql | sed
-e s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_gb_postcodearea.sql |
sed -e s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_gb_postcode.sql | sed -e
s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_specialwords.sql | sed
-e s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_us_statecounty.sql | sed
-e s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'>cat import_state.sql | sed -e
s/twain/osm/g | psql -d gazetteer || exit<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>psql -d gazetteer -f
gazetteer-index.sql<o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>echo all done<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><i>Jason R. Surratt<o:p></o:p></i></p>
<p class=MsoNormal>SPADAC<o:p></o:p></p>
<p class=MsoNormal>email: <a href="mailto:jason.surratt@spadac.com">jason.surratt@spadac.com</a><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>