[postgis-devel] Loading TIGER data for the geocoder

[Stephen Woodbridge]

Regina,

I talked with Brian today. From what I can gather, there might have been 
some issues with the linux scripts and Brian made some changes to work 
around the problems. So it is not clear if the problem is with your 
scripts or his changes to them. If you have a way to test load CA on 
linux and verify that is working as you expect that is probably a good 
first step.

I missed that the CA and DC numbers were the same. That is a good clue 
as to what the problem might be.

Regardless, at some point, I was thinking that it might make sense to 
get together work out a design for a new geocoder. My geocoder is really 
simple in its design with main two tables:

1. streets table which is my preprocessed tiger streets data
2. stdstreets table which is the standardized addresses of the streets table

I have a few other tables but 99% of the geocoder only needs those two 
tables and the only table that need to be queried it the stdstreets 
table except when you have a candidate record and you need the geometry 
which is only in the streets table to compute the location. A couple of 
hours and a white board and we could map the whole thing out.

So let me know when you are not crazy busy and you want to do this.

-Steve

On 10/18/2014 10:02 PM, Paragon Corporation wrote:
> Brian,
> Just noticed something else really odd about your numbers.
> 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.
> 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.
> Anyway I'll check on windows and Linux to see if I get same odd behavior.
> Thanks,
> Regina
>
> ------------------------------------------------------------------------
> *From:* postgis-devel-bounces at lists.osgeo.org
> [mailto:postgis-devel-bounces at lists.osgeo.org] *On Behalf Of *Paragon
> Corporation
> *Sent:* Saturday, October 18, 2014 9:51 PM
> *To:* 'PostGIS Development Discussion'
> *Subject:* Re: [postgis-devel] Loading TIGER data for the geocoder
>
> Yah that definitely looks wrong as Steve noted. ca_addr has tons more
> addr and edges.
> 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.
> Did address_standardizer extension install okay.
> Should just be now a simple
> CREATE EXTENSION address_standardizer;
> Thanks,
> Regina
>
> ------------------------------------------------------------------------
> *From:* postgis-devel-bounces at lists.osgeo.org
> [mailto:postgis-devel-bounces at lists.osgeo.org] *On Behalf Of *Brian M Hamlin
> *Sent:* Saturday, October 18, 2014 1:32 PM
> *To:* PostGIS Development Discussion
> *Subject:* [postgis-devel] Loading TIGER data for the geocoder
>
> pg 9.4b3
> postgis 2.2 trunk
> --
>
> does this look right to you?
> (conts of records in each table in tiger_data)
>
>
>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>