<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16660"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial>There was a bug in the 2.1.0 one that made it not work
in PostgresQL 9.2 and below since I accidentaly used 9.3
features.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/ticket/2441">http://trac.osgeo.org/postgis/ticket/2441</A>
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial>and I describe a bit here <A
href="http://www.postgresonline.com/journal/archives/317-CREATE-SCHEMA-IF-NOT-EXISTS-in-9.3-and-tiger-geocoder.html">http://www.postgresonline.com/journal/archives/317-CREATE-SCHEMA-IF-NOT-EXISTS-in-9.3-and-tiger-geocoder.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013></SPAN><SPAN
class=669513810-26082013><FONT color=#0000ff size=2 face=Arial>Sorry about that.
Can you try the one packaged in the latest 2.1.1. If you can't build
on your own, its packaged in the latest windows 2.1.1dev (just copy the
postgis_tiger_geocoder .* files in share/extension folder)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013> <FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net/windows_downloads">http://postgis.net/windows_downloads</A> (you
might need to get rid of the windows line breaks)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial>If you want you can even use the 2.2.0dev one which does Tiger
2013 (data just came out a couple of days ago) instead of Tiger 2012.
I've been using it the 2013 for MA and so far so good but need to stress test
some more. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=669513810-26082013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Tom
C<BR><B>Sent:</B> Monday, August 26, 2013 1:58 AM<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> Re: [postgis-users] PostgreSQL + PostGIS 2.1.0
Tiger Geocoding notworking<BR></FONT><BR></DIV>
<DIV></DIV>Did you add the fuzzy string match extension?<SPAN></SPAN><BR><BR>On
Monday, August 26, 2013, René Fournier wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV style="WORD-WRAP: break-word">
<DIV>So… I've done a clean/fresh install of PostgreSQL 9.2 and PostGIS 2.1.0
via MacPorts (thanks Vincent). Installed the requisite extensions:</DIV>
<DIV><BR></DIV>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV>
<DIV>CREATE EXTENSION postgis;</DIV></DIV>
<DIV>
<DIV>CREATE EXTENSION postgis_topology;</DIV></DIV>
<DIV>
<DIV>CREATE EXTENSION postgis_tiger_geocoder;</DIV></DIV>
<DIV><BR></DIV></BLOCKQUOTE>Tested the basics:
<DIV><BR></DIV>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV>
<DIV>gc5=# SELECT na.address, na.streetname,na.streettypeabbrev,
na.zip</DIV>
<DIV>gc5-# FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS
na;</DIV>
<DIV> address | streetname | streettypeabbrev | zip </DIV>
<DIV>---------+------------+------------------+-------</DIV>
<DIV> 1 | Devonshire | Pl
| 02109</DIV>
<DIV>(1 row)</DIV></DIV>
<DIV><BR></DIV></BLOCKQUOTE>Then, to get the data (Tiger 2012), generated the
loader script and ran it:<BR>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV><BR></DIV></BLOCKQUOTE>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV>
<DIV>gc5=# SELECT loader_generate_script(ARRAY['MA','RI'], 'sh') AS
result;</DIV></DIV></BLOCKQUOTE>
<DIV>
<DIV><BR></DIV>
<DIV>Bash script downloaded and added Massachusetts and Rhode Island without
complaint, also ran:</DIV>
<DIV><BR></DIV></DIV>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV>
<DIV>SELECT install_missing_indexes();</DIV></DIV></BLOCKQUOTE>
<DIV>
<DIV><BR></DIV>
<DIV>But when I try to geocode or reverse geocode, I get nothing:</DIV>
<DIV><BR></DIV></DIV>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV>
<DIV>
<DIV>gc5=# SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As
lat, </DIV></DIV></DIV>
<DIV>
<DIV>
<DIV> (addy).address As stno, (addy).streetname
As street, </DIV></DIV></DIV>
<DIV>
<DIV>
<DIV> (addy).streettypeabbrev As styp,
(addy).location As city, (addy).stateabbrev As
st,(addy).zip </DIV></DIV></DIV>
<DIV>
<DIV>
<DIV> FROM geocode('75 State Street, Boston MA
02109') As g;</DIV></DIV></DIV>
<DIV>
<DIV>
<DIV> rating | lon | lat | stno | street | styp | city | st |
zip </DIV></DIV></DIV>
<DIV>
<DIV>
<DIV>--------+-----+-----+------+--------+------+------+----+-----</DIV></DIV></DIV></BLOCKQUOTE>
<DIV>
<DIV><BR></DIV></DIV>
<DIV>There's clearly a lot of data in my geocoder DB:</DIV>
<DIV><BR></DIV>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 40px; BORDER-LEFT: medium none; PADDING-RIGHT: 0px">
<DIV>
<DIV> gc5 | postgres | UTF8 |
en_CA.UTF-8 | en_CA.UTF-8 |
| 1194 MB | pg_default
| </DIV></DIV></BLOCKQUOTE>
<DIV><BR></DIV>
<DIV>But I can't get anything from it… My previous 1.5.x PostGIS tiger
geocoder was working fine… I must be missing something obvious. Can anyone
point it out for me?</DIV>
<DIV><BR></DIV>
<DIV>…Rene</DIV></DIV></BLOCKQUOTE></BODY></HTML>