<div dir="ltr">Sara,<div><br></div><div>I ran the nation script before I ran the state script. Though, I didn't check to see if the nation script error'd at all. I can check to see if that's the case later today and post back my results!</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Nov 23, 2016 at 12:46 PM Sara Yurman <<a href="mailto:syurman@spatialfocus.com">syurman@spatialfocus.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">Hi Frank,<div class="gmail_msg"><br class="gmail_msg"></div><div class="gmail_msg">I was wondering if you had run the script for a state or group of states without running the script for the nation? </div><div class="gmail_msg"><br class="gmail_msg"></div><div class="gmail_msg">I did this, thinking that I just wanted my little bit. Had the same results you did. Doesn't work that way. Once I followed the instructions properly it worked fine. <a href="http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension" class="gmail_msg" target="_blank">http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension</a></div><div class="gmail_msg"><br class="gmail_msg"></div><div class="gmail_msg">Hope that helps,</div><div class="gmail_msg"><br class="gmail_msg"></div><div class="gmail_msg">Sara</div></div><div dir="ltr" class="gmail_msg"><div class="gmail_msg">-- <br class="gmail_msg"><div class="m_-3230969385646336388gmail_signature gmail_msg"><div dir="ltr" class="gmail_msg">Sara Yurman, GISP<br class="gmail_msg">Spatial Focus, LLC<br class="gmail_msg">Geodata Architects<br class="gmail_msg"><a href="http://www.spatialfocus.com/" class="gmail_msg" target="_blank">http://www.spatialfocus.com/</a><br class="gmail_msg">Office: <a href="tel:(404)%20378-0989" value="+14043780989" class="gmail_msg" target="_blank">(404) 378-0989</a><br class="gmail_msg">Fax: <a href="tel:(404)%20806-6257" value="+14048066257" class="gmail_msg" target="_blank">(404) 806-6257</a></div></div></div></div><div dir="ltr" class="gmail_msg"><div class="gmail_extra gmail_msg"><div class="gmail_quote gmail_msg">On Wed, Nov 23, 2016 at 2:49 PM, Frank Quick <span dir="ltr" class="gmail_msg"><<a href="mailto:fquick1y@gmail.com" class="gmail_msg" target="_blank">fquick1y@gmail.com</a>></span> wrote:<br class="gmail_msg"></div></div></div><div dir="ltr" class="gmail_msg"><div class="gmail_extra gmail_msg"><div class="gmail_quote gmail_msg"><blockquote class="gmail_quote gmail_msg" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class="gmail_msg"><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px">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:</div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px"><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px"><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg 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;</div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"> rating | lon | lat | stno | street | styp | city | st | zip</div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">--------+-----------------+------------------+------+--------+------+---------------+----+-------</div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"> 100 | -122.6939756117 | 37.7597150026058 | | | | San Francisco | CA | 94103</div></div></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px"><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px">Here are the counts of some of the tables that I believe are/should be populated after running the loader script:</div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px"><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><ul class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.addr: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.edges: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.faces: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.featnames: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.place: 1522<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.cousub: 397<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.county: 3233<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.state: 56<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.zip_lookup_base: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.zip_state: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">tiger.zip_state_loc: 0<br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li></ul><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg">The loader script appears to not be downloading a few datasets:</div></div></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px"><ul class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/ADDR" class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/ADDR</a><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/EDGES" class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/EDGES</a><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/FEATNAMES" class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/FEATNAMES</a><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></li><li class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"><a href="http://www2.census.gov/geo/tiger/TIGER2016/FACES" class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" target="_blank">www2.census.gov/geo/tiger/TIGER2016/FACES</a></li></ul></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px">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?</div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px"><br class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg"></div><div class="m_-3230969385646336388gmail-m_-1528643100693756903gmail_msg gmail_msg" style="color:rgb(33,33,33);font-size:13px">Thanks</div></div>
<br class="gmail_msg"></blockquote></div></div></div><div dir="ltr" class="gmail_msg"><div class="gmail_extra gmail_msg"><div class="gmail_quote gmail_msg"><blockquote class="gmail_quote gmail_msg" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">_______________________________________________<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><br class="gmail_msg"></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>