<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16866"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=837583108-17042014><FONT color=#0000ff
size=2 face=Arial>Andre,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=837583108-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=837583108-17042014><FONT color=#0000ff
size=2 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 class=837583108-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=837583108-17042014><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net/docs/manual-2.1/postgis_installation.html#tiger_geocoder_loading_data">http://postgis.net/docs/manual-2.1/postgis_installation.html#tiger_geocoder_loading_data</A>
</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=837583108-17042014></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>H<SPAN class=837583108-17042014>ope that
helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=837583108-17042014></SPAN><SPAN
class=837583108-17042014></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN class=837583108-17042014>egina</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=837583108-17042014></SPAN><SPAN
class=837583108-17042014></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><A href="http://www.postgis.us">h<SPAN
class=837583108-17042014>ttp://www.postgis.us</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=837583108-17042014></SPAN><SPAN
class=837583108-17042014></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><A href="http://postgis.net">h<SPAN
class=837583108-17042014>ttp://postgis.net</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=837583108-17042014></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=837583108-17042014></SPAN></FONT></FONT></FONT> </DIV>
<DIV><BR></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Andre
Mano<BR><B>Sent:</B> Wednesday, April 16, 2014 7:22 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] TIGER
geocoder<BR></FONT><BR></DIV>
<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></BODY></HTML>