<!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=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>No not directory where Postgres is
installed.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>On Windows something like C:\gisdata or
E:\gisdata</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>On Linux /gisdata</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>Technically you can create the folder anywhere as
long as you change the path in the generated script (or prechange it in the
<STRONG>tiger.loader_variables.staging_fold</STRONG> field before you generate
the script) to where you want the files put.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>Note that if you put the folder on your local pc and your
PostgreSQL server is on another machine, you'll need to have shp2pgsql and psql
executables etc accessible from your local pc.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>It's generally more efficient to just run from the machine you
have PostgreSQL installed because of network / bandwidth.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=763335118-17042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<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> Thursday, April 17, 2014 2:40 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] TIGER
geocoder<BR></FONT><BR></DIV>
<DIV></DIV>
<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="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><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
size=+0>H<SPAN>ope that helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN></SPAN><SPAN></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=+0>R<SPAN>egina</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN></SPAN><SPAN></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=+0><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
size=+0><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
size=+0><SPAN></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=+0><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></BODY></HTML>