<!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=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Brian,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Just noticed something else really odd about your
numbers.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Your CA And DC numbers are the same -- almost like you loaded
DC in CA. Not sure how I could have screwed up that
badly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Were you trying to parallel load states by chance? I
never finished the parallel loading logic I was moving toward, so I guess its
possible if you were trying to parallel load data (having two processes handling
different states) something strange might have happened.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Anyway I'll check on windows and Linux to see if I get same
odd behavior.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273355801-19102014><FONT color=#0000ff
size=2 face=Arial>Regina</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>Paragon
Corporation<BR><B>Sent:</B> Saturday, October 18, 2014 9:51 PM<BR><B>To:</B>
'PostGIS Development Discussion'<BR><B>Subject:</B> Re: [postgis-devel] Loading
TIGER data for the geocoder<BR></FONT><BR></DIV>
<DIV></DIV>
<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>