<div dir="ltr"><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">Hi users,</div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
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-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
<p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt"><span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial;font-weight:bold">               # Enable geocoding capabilities</span></p>
<br><span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial;font-weight:bold"></span><p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;margin-left:36pt">
<span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial">CREATE EXTENSION fuzzystrmatch; </span></p><p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;margin-left:36pt">
<span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial">CREATE EXTENSION postgis_tiger_geocoder;</span></p><p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;margin-left:36pt">
<span style="line-height:1.15;white-space:pre-wrap;background-color:transparent;font-family:Arial;font-weight:bold"><br></span></p><p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;margin-left:36pt"><span style="line-height:1.15;white-space:pre-wrap;background-color:transparent;font-family:Arial;font-weight:bold"># Test Geocoding capabilities</span></p>
<br><span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial;font-weight:bold"></span><p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;margin-left:36pt">
<span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial">SELECT na.address, na.streetname,na.streettypeabbrev, na.zip</span></p><span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial">               FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na;</span><br>
</div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial"><br></span></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
<span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial">              (Returns, as expected: 1;"Devonshire";"Pl";"02109")</span></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
<span style="vertical-align:baseline;white-space:pre-wrap;background-color:transparent;font-family:Arial"><br></span></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">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-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">(PostgresSQL 9.3, PostGIS 2.1, Win7 Enterprise 64bits)</div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
<br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">Thank you,</div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px"><br></div><div style="font-family:arial,sans-serif;font-size:12.800000190734863px">
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>