<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type
data-hsystem="true">
<META name=GENERATOR content="MSHTML 10.00.9200.17116"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>Yah that definitely looks wrong as Steve noted. ca_addr
has tons more addr and edges.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>It could be my changes to support tiger_2014. I tested
on windows on a couple of states (not any you listed though) but not
on Linux (that was 9.4b2). But any rate I think its more likely the
changes for the tiger extension than anything else.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>Did address_standardizer extension install
okay.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>Should just be now a simple</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>CREATE EXTENSION address_standardizer;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=900494701-19102014><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-devel-bounces@lists.osgeo.org
[mailto:postgis-devel-bounces@lists.osgeo.org] <B>On Behalf Of </B>Brian M
Hamlin<BR><B>Sent:</B> Saturday, October 18, 2014 1:32 PM<BR><B>To:</B> PostGIS
Development Discussion<BR><B>Subject:</B> [postgis-devel] Loading TIGER data for
the geocoder<BR></FONT><BR></DIV>
<DIV></DIV>
<STYLE>P {
PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px; PADDING-RIGHT: 0px
}
</STYLE>
<P>pg 9.4b3<BR>postgis 2.2 trunk<BR>--<BR><BR>does this look right to
you?<BR>(conts of records in each table in tiger_data)</P>
<P><BR></P>
<P><BR></P></BODY></HTML>