<div dir="ltr">Regina,<div><br></div><div>Thank you for responding!</div><div><br></div><div>I'm definitely downloading successfully from the census site.</div><div><br></div><div>I'm on Mac OS X v10.11.1.</div><div><br></div><div>I noticed the script didn't generate any wget commands for addr/edges/features/faces.</div><div><br></div><div>Abe</div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Nov 23, 2016 at 12:31 PM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" 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_5541665183078530594WordSection1 gmail_msg"><p class="MsoNormal 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.<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">I get this:<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_5541665183078530594WordSection1 gmail_msg"><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">rating | lon | lat | stno | street | styp | city | st | zip<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_5541665183078530594WordSection1 gmail_msg"><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"> 0 | -122.406147398092 | 37.7853683917931 | 835 | Market | St | San Francisco | CA | 94103<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">(1 row)<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><p class="MsoNormal 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.<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">Which OS are you on. It's also possible I made a mistake somewhere in the script that is affecting your OS.<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><p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="gmail_msg">Thanks,<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">Regina<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><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><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"> 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<br class="gmail_msg"><b class="gmail_msg">Sent:</b> Wednesday, November 23, 2016 2:49 PM<br class="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><br class="gmail_msg"><b class="gmail_msg">Subject:</b> [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_5541665183078530594WordSection1 gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.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:.5in"><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:<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><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;<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> rating | lon | lat | stno | street | styp | city | st | zip<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">--------+-----------------+------------------+------+--------+------+---------------+----+-------<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"> 100 | -122.6939756117 | 37.7597150026058 | | | | San Francisco | CA | 94103<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div></div></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><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:<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.addr: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.edges: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.faces: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.featnames: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.place: 1522<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.cousub: 397<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.county: 3233<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.state: 56<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.zip_lookup_base: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.zip_state: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><span style="font-size:10.0pt;color:#212121" class="gmail_msg">tiger.zip_state_loc: 0<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">The loader script appears to not be downloading a few datasets:<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div></div></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><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><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><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><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><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><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p><p class="MsoNormal gmail_msg" style="margin-left:1.0in"><u class="gmail_msg"></u><span style="font-size:10.0pt;font-family:Symbol;color:#212121" class="gmail_msg"><span class="gmail_msg">·<span style="font:7.0pt "Times New Roman"" class="gmail_msg"> </span></span></span><u class="gmail_msg"></u><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><u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><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?<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p></div><div class="gmail_msg"><p class="MsoNormal gmail_msg" style="margin-left:.5in"><span style="font-size:10.0pt;color:#212121" class="gmail_msg">Thanks<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_5541665183078530594WordSection1 gmail_msg"></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>