<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.gmailmsg
{mso-style-name:gmail_msg;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>One more note, since your state load is messed up, you should drop any state tables created.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><a href="http://postgis.net/docs/manual-2.3/Drop_State_Tables_Generate_Script.html">http://postgis.net/docs/manual-2.3/Drop_State_Tables_Generate_Script.html</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>SELECT drop_state_tables_generate_script('CA');<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>Will not actually drop but will generate the drop statements you can run.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Regina Obe [mailto:lr@pcorp.us] <br><b>Sent:</b> Wednesday, November 23, 2016 3:54 PM<br><b>To:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org><br><b>Subject:</b> RE: [postgis-users] TIGER 2016 Setup Question<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hmm that's very odd. <o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I see wget for those when I run:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>SELECT Loader_Generate_Script(ARRAY['CA'], 'sh');<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>You followed these instructions:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><a href="http://postgis.net/docs/manual-2.3/postgis_installation.html#install_tiger_geocoder_extension">http://postgis.net/docs/manual-2.3/postgis_installation.html#install_tiger_geocoder_extension</a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If you are using pgAdmin to generate the script, make sure you have Query Editor -> Max. characters per column set to something very large.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>It's usually low like 255, so most of the script would be truncated if you copied and pasted from pgAdmin.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Frank Quick<br><b>Sent:</b> Wednesday, November 23, 2016 3:43 PM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-users] TIGER 2016 Setup Question<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><div><p class=MsoNormal style='margin-left:1.0in'>Regina,<o:p></o:p></p><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'>Thank you for responding!<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'>I'm definitely downloading successfully from the census site.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'>I'm on Mac OS X v10.11.1.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'>I noticed the script didn't generate any wget commands for addr/edges/features/faces.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:1.0in'>Abe<o:p></o:p></p></div></div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><div><div><p class=MsoNormal style='margin-left:1.0in'>On Wed, Nov 23, 2016 at 12:31 PM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<o:p></o:p></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'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Yap seems something went wrong with your load.</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I get this:</span></span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>rating | lon | lat | stno | street | styp | city | st | zip</span></span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>--------+-------------------+------------------+------+--------+------+---------------+----+-------</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> 0 | -122.406147398092 | 37.7853683917931 | 835 | Market | St | San Francisco | CA | 94103</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>(1 row)</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Which OS are you on. It's also possible I made a mistake somewhere in the script that is affecting your OS.</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b></span><span class=gmailmsg><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Frank Quick</span></span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br><span class=gmailmsg><b>Sent:</b> Wednesday, November 23, 2016 2:49 PM</span><br><span class=gmailmsg><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a></span><br><span class=gmailmsg><b>Subject:</b> [postgis-users] TIGER 2016 Setup Question</span></span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>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><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'> </span></span><o:p></o:p></p></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>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><o:p></o:p></p></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'> </span></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'> rating | lon | lat | stno | street | styp | city | st | zip</span></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>--------+-----------------+------------------+------+--------+------+---------------+----+-------</span></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'> 100 | -122.6939756117 | 37.7597150026058 | | | | San Francisco | CA | 94103</span></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'> </span></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>Here are the counts of some of the tables that I believe are/should be populated after running the loader script:</span></span><o:p></o:p></p></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.addr: 0</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.edges: 0</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.faces: 0</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.featnames: 0</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.place: 1522</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.cousub: 397</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.county: 3233</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.state: 56</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.zip_lookup_base: 0</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.zip_state: 0</span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>tiger.zip_state_loc: 0</span></span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>The loader script appears to not be downloading a few datasets:</span></span><o:p></o:p></p></div></div></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'><a href="http://www2.census.gov/geo/tiger/TIGER2016/ADDR" target="_blank">www2.census.gov/geo/tiger/TIGER2016/ADDR</a></span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'><a href="http://www2.census.gov/geo/tiger/TIGER2016/EDGES" target="_blank">www2.census.gov/geo/tiger/TIGER2016/EDGES</a></span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'><a href="http://www2.census.gov/geo/tiger/TIGER2016/FEATNAMES" target="_blank">www2.census.gov/geo/tiger/TIGER2016/FEATNAMES</a></span></span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:2.0in'><span class=gmailmsg><span style='font-size:10.0pt;font-family:Symbol;color:#212121'>·</span></span><span class=gmailmsg><span style='font-size:7.0pt;color:#212121'> </span></span><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'><a href="http://www2.census.gov/geo/tiger/TIGER2016/FACES" target="_blank">www2.census.gov/geo/tiger/TIGER2016/FACES</a></span></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>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><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'> </span></span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.5in'><span class=gmailmsg><span style='font-size:10.0pt;color:#212121'>Thanks</span></span><o:p></o:p></p></div></div></div></div><p class=MsoNormal style='margin-left:1.0in'>_______________________________________________<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/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div></div></body></html>