<div dir="ltr">Luma, Regina,<div><br></div><div>Thank you once more. Everything is on a local machine. In fact it's a one user database (me) that I will, hopefully, use just for geocoding purposes.</div><div>All clearer now.</div>
<div><br></div><div>Regards,</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Apr 17, 2014 at 8:59 PM, 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">No not directory where Postgres is
installed.</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">On Windows something like C:\gisdata or
E:\gisdata</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">On Linux /gisdata</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">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><font color="#0000ff" 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><font color="#0000ff" 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 class="">
<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">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://postgis.net" target="_blank">http://postgis.net</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><br>
</div><div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><div class=""><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></div><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 class="h5">
<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>
<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" target="_blank">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>
</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>