<div dir="ltr">Regina and Sara,<div><br></div><div>Thank you for responding to me :).</div><div><br></div><div>I may have misunderstood what you were telling me and potentially the instructions. The steps to make it work correctly are:</div><div><ol><li>Generate the nation script</li><li>Execute the nation script<br></li><li>Generate the state script</li><li>Execute the state script</li></ol><div>The following is incorrect (which is what I did):</div></div><div><ul><li><font size="2">Generate the nation script</font></li><li><font size="2">Generate the state script</font></li><li><font size="2">Execute the nation script<br></font></li><li>Execute the state script</li></ul><div>I believe I was confused because I read step 7 of <a href="http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension">http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension</a> as a generate step for both the nation and state scripts. Then I read step 8 as an execution step for both the nation and state scripts.</div></div><div><br></div><div>Thank you both for your help!</div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Nov 23, 2016 at 3:23 PM Frank Quick <<a href="mailto:fquick1y@gmail.com">fquick1y@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class="gmail_msg">Regina,<div class="gmail_msg"><br class="gmail_msg"></div><div class="gmail_msg">I believe I followed those steps... what are the wget commands that are being generated? I'll try running through the process again in the next couple of hours and post the results (and the generated scripts).</div><div class="gmail_msg"><br class="gmail_msg"></div><div class="gmail_msg">Abe</div></div><br class="gmail_msg"><div class="gmail_quote gmail_msg"><div dir="ltr" class="gmail_msg">On Wed, Nov 23, 2016 at 12:57 PM Regina Obe <<a href="mailto:lr@pcorp.us" class="gmail_msg" target="_blank">lr@pcorp.us</a>> wrote:<br class="gmail_msg"></div><blockquote class="gmail_quote gmail_msg" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">One more note, since your state load is messed up, you should drop any state tables created.<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><a href="http://postgis.net/docs/manual-2.3/Drop_State_Tables_Generate_Script.html" class="gmail_msg" target="_blank">http://postgis.net/docs/manual-2.3/Drop_State_Tables_Generate_Script.html</a><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:10.0pt;font-family:"Courier New"" class="gmail_msg">SELECT drop_state_tables_generate_script('CA');<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:10.0pt;font-family:"Courier New"" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:10.0pt;font-family:"Courier New"" class="gmail_msg">Will not actually drop but will generate the drop statements you can run.<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><div class="gmail_msg"><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><b class="gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"> Regina Obe [mailto:<a href="mailto:lr@pcorp.us" class="gmail_msg" target="_blank">lr@pcorp.us</a>] <br class="gmail_msg"><b class="gmail_msg">Sent:</b> Wednesday, November 23, 2016 3:54 PM</span></p></div></div></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><div class="gmail_msg"><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"><br class="gmail_msg"><b class="gmail_msg">To:</b> 'PostGIS Users Discussion' <<a href="mailto:postgis-users@lists.osgeo.org" class="gmail_msg" target="_blank">postgis-users@lists.osgeo.org</a>><br class="gmail_msg"></span></p></div></div></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><div class="gmail_msg"><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"><b class="gmail_msg">Subject:</b> RE: [postgis-users] TIGER 2016 Setup Question<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div></div></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">Hmm that's very odd. <u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">I see wget for those when I run:<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">SELECT Loader_Generate_Script(ARRAY['CA'], 'sh');<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">You followed these instructions:<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><a href="http://postgis.net/docs/manual-2.3/postgis_installation.html#install_tiger_geocoder_extension" class="gmail_msg" target="_blank">http://postgis.net/docs/manual-2.3/postgis_installation.html#install_tiger_geocoder_extension</a><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">If you are using pgAdmin to generate the script, make sure you have Query Editor -> Max. characters per column set to something very large.<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">It's usually low like 255, so most of the script would be truncated if you copied and pasted from pgAdmin.<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><b class="gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org" class="gmail_msg" target="_blank">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b class="gmail_msg">On Behalf Of </b>Frank Quick</span></p></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"><br class="gmail_msg"><b class="gmail_msg">Sent:</b> Wednesday, November 23, 2016 3:43 PM<br class="gmail_msg"><b class="gmail_msg">To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" class="gmail_msg" target="_blank">postgis-users@lists.osgeo.org</a>><br class="gmail_msg"></span></p></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"><b class="gmail_msg">Subject:</b> Re: [postgis-users] TIGER 2016 Setup Question<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div></div><div lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_-5420471652526225088m_-2164180356408129502WordSection1 gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">Regina,<u class="gmail_msg"></u><u class="gmail_msg"></u></p><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">Thank you for responding!<u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">I'm definitely downloading successfully from the census site.<u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">I'm on Mac OS X v10.11.1.<u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">I noticed the script didn't generate any wget commands for addr/edges/features/faces.<u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">Abe<u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in">On Wed, Nov 23, 2016 at 12:31 PM Regina Obe <<a href="mailto:lr@pcorp.us" class="gmail_msg" target="_blank">lr@pcorp.us</a>> wrote:<u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" class="gmail_msg"><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">Yap seems something went wrong with your load.</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">I get this:</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">rating | lon | lat | stno | street | styp | city | st | zip</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">--------+-------------------+------------------+------+--------+------+---------------+----+-------</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> 0 | -122.406147398092 | 37.7853683917931 | 835 | Market | St | San Francisco | CA | 94103</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">(1 row)</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">You might want to check the folder the script downloads to and make sure it did download the addr/edges/featnames files. I've had issues with the census site in that if you download enough states, their akmai lockout thing kicks in so then you are denied from their site for a couple of days. Not sure if that is what you are running into.</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">Which OS are you on. It's also possible I made a mistake somewhere in the script that is affecting your OS.</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">Thanks,</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">Regina</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><b class="gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg">From:</span></b></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" class="gmail_msg" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b class="gmail_msg">On Behalf Of </b>Frank Quick</span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="gmail_msg"><br class="gmail_msg"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><b class="gmail_msg">Sent:</b> Wednesday, November 23, 2016 2:49 PM</span><br class="gmail_msg"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><b class="gmail_msg">To:</b> <a href="mailto:postgis-users@lists.osgeo.org" class="gmail_msg" target="_blank">postgis-users@lists.osgeo.org</a></span><br class="gmail_msg"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><b class="gmail_msg">Subject:</b> [postgis-users] TIGER 2016 Setup Question</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">I'm attempting to get the geocoder extension to work. When I try to geocode a common address, I get a latitude and longitude that's pretty far off and the street information is missing. Example:</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat, (addy).address As stno, (addy).streetname As street, (addy).streettypeabbrev As styp, (addy).location As city, (addy).stateabbrev As st,(addy).zip FROM geocode('835 market street, san francisco ca 94103') AS g;</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> rating | lon | lat | stno | street | styp | city | st | zip</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">--------+-----------------+------------------+------+--------+------+---------------+----+-------</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> 100 | -122.6939756117 | 37.7597150026058 | | | | San Francisco | CA | 94103</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">Here are the counts of some of the tables that I believe are/should be populated after running the loader script:</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.addr: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.edges: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.faces: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.featnames: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.place: 1522</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.cousub: 397</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.county: 3233</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.state: 56</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.zip_lookup_base: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.zip_state: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.zip_state_loc: 0</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">The loader script appears to not be downloading a few datasets:</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/ADDR" class="gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/ADDR</a></span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/EDGES" class="gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/EDGES</a></span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/FEATNAMES" class="gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/FEATNAMES</a></span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p><p class="MsoNormal gmail_msg" style="margin-left:2.0in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg">·</span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:7.0pt;color:#212121" class="gmail_msg"> </span></span><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/FACES" class="gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/FACES</a></span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">Does any one know if I'm missing crucial data? If so, is it possible to back fill from previous years? If not, what else could be going on here?</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.5in"><span class="m_-5420471652526225088m_-2164180356408129502gmailmsg gmail_msg"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">Thanks</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p></div></div></div></div><p class="MsoNormal gmail_msg" style="margin-left:1.0in">_______________________________________________<br class="gmail_msg">postgis-users mailing list<br class="gmail_msg"><a href="mailto:postgis-users@lists.osgeo.org" class="gmail_msg" target="_blank">postgis-users@lists.osgeo.org</a><br class="gmail_msg"><a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" class="gmail_msg" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><u class="gmail_msg"></u><u class="gmail_msg"></u></p></blockquote></div></div></div>_______________________________________________<br class="gmail_msg">
postgis-users mailing list<br class="gmail_msg">
<a href="mailto:postgis-users@lists.osgeo.org" class="gmail_msg" target="_blank">postgis-users@lists.osgeo.org</a><br class="gmail_msg">
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></blockquote></div>