<div dir="ltr">Thank you for your report.<div><br></div><div>I followed your suggestions but I run into one more question. </div><div>The readme file that documents the geocoder tool says it's necessary to "Create a folder called gisdata on root of server or your local pc".</div>
<div><br></div><div>What is considered to be the root of the server? The directory where Postgres is installed?</div><div><br></div><div>Thank you for your support,</div><div><br></div><div>Andre</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Thu, Apr 17, 2014 at 10:37 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Andre,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">If you plan to do geocoding, then you need to load tiger
data. Next steps here:</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://postgis.net/docs/manual-2.1/postgis_installation.html#tiger_geocoder_loading_data" target="_blank">http://postgis.net/docs/manual-2.1/postgis_installation.html#tiger_geocoder_loading_data</a>
</font></span></div>
<div> </div>
<div><span></span><font face="Arial"><font color="#0000ff"><font>H<span>ope that
helps,</span></font></font></font></div>
<div><span></span><span></span><font face="Arial"><font color="#0000ff"><font>R<span>egina</span></font></font></font></div>
<div><span></span><span></span><font face="Arial"><font color="#0000ff"><font><a href="http://www.postgis.us" target="_blank">h<span>ttp://www.postgis.us</span></a></font></font></font></div>
<div><span></span><span></span><font face="Arial"><font color="#0000ff"><font><a href="http://postgis.net" target="_blank">h<span>ttp://postgis.net</span></a></font></font></font></div>
<div><font face="Arial"><font color="#0000ff"><font><span></span></font></font></font> </div>
<div><font face="Arial"><font color="#0000ff"><font><span></span></font></font></font> </div>
<div><br></div>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Andre
Mano<br><b>Sent:</b> Wednesday, April 16, 2014 7:22 PM<br><b>To:</b>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] TIGER
geocoder<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr">
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">Hi users,</div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><br></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">I am a bit lost on
the necessary steps in order to use the TIGER geocoding tool. This is what I
have done so far:</div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><br></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">
<p style="MARGIN-BOTTOM:0pt;MARGIN-TOP:0pt;LINE-HEIGHT:1.15" dir="ltr"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;FONT-WEIGHT:bold;BACKGROUND-COLOR:transparent">#
Enable geocoding capabilities</span></p><br><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;FONT-WEIGHT:bold;BACKGROUND-COLOR:transparent"></span>
<p style="MARGIN-BOTTOM:0pt;MARGIN-LEFT:36pt;MARGIN-TOP:0pt;LINE-HEIGHT:1.15" dir="ltr"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent">CREATE
EXTENSION fuzzystrmatch; </span></p>
<p style="MARGIN-BOTTOM:0pt;MARGIN-LEFT:36pt;MARGIN-TOP:0pt;LINE-HEIGHT:1.15" dir="ltr"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent">CREATE
EXTENSION postgis_tiger_geocoder;</span></p>
<p style="MARGIN-BOTTOM:0pt;MARGIN-LEFT:36pt;MARGIN-TOP:0pt;LINE-HEIGHT:1.15" dir="ltr"><span style="FONT-FAMILY:Arial;WHITE-SPACE:pre-wrap;FONT-WEIGHT:bold;LINE-HEIGHT:1.15;BACKGROUND-COLOR:transparent"><br></span></p>
<p style="MARGIN-BOTTOM:0pt;MARGIN-LEFT:36pt;MARGIN-TOP:0pt;LINE-HEIGHT:1.15" dir="ltr"><span style="FONT-FAMILY:Arial;WHITE-SPACE:pre-wrap;FONT-WEIGHT:bold;LINE-HEIGHT:1.15;BACKGROUND-COLOR:transparent">#
Test Geocoding capabilities</span></p><br><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;FONT-WEIGHT:bold;BACKGROUND-COLOR:transparent"></span>
<p style="MARGIN-BOTTOM:0pt;MARGIN-LEFT:36pt;MARGIN-TOP:0pt;LINE-HEIGHT:1.15" dir="ltr"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent">SELECT
na.address, na.streetname,na.streettypeabbrev, na.zip</span></p><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent">FROM
normalize_address('1 Devonshire Place, Boston, MA 02109') AS
na;</span><br></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent"><br></span></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent">(Returns,
as expected: 1;"Devonshire";"Pl";"02109")</span></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><span style="FONT-FAMILY:Arial;VERTICAL-ALIGN:baseline;WHITE-SPACE:pre-wrap;BACKGROUND-COLOR:transparent"><br></span></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">But now I don't know
exactly what I have to do. I have read the documentation, but still I am not
very secure of what I should do. Does anyone here with experience with the TIGER
geocoder can give me a hint? </div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><br></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">(PostgresSQL 9.3,
PostGIS 2.1, Win7 Enterprise 64bits)</div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><br></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">Thank you,</div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><br></div>
<div style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">Andre</div>
<div><br></div>-- <br>..................................<br>André Mano<br><a style="COLOR:rgb(0,0,153)" href="http://opussig.blogspot.com/" target="_blank"><font size="1">http://opussig.blogspot.com/</font></a><br></div>
</div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>..................................<br>
André Mano<br><a style="color:rgb(0,0,153)" href="http://opussig.blogspot.com/" target="_blank"><font size="1">http://opussig.blogspot.com/</font></a><br>
</div>