[postgis-users] Tiger geocoder, Spanish street types are pushed to the end

[Paragon Corporation]

James,
Which version are you using?  I assume the 2.1.0SVN one?

That we can probably change the structure of a bit since it hasn't been
released yet and can probalby get away with change the norm_addy type as
well which we've been dragging our feet on a bit
Mostly because it brings along a bunch of upgrade issues we'd need to
provide for people using tiger already.

If  you look at the file

tiger_2011\tables\lookup_tables_2011.sql

The street_type_lookup values is what controls how Camino is treated.

That probably will require another field at some point we are guessing to
better follow the Tiger Feature name types convention of Prefix Type /
Suffix type (and possibly Spanish column) they document in 

http://www.census.gov/geo/www/tiger/tgrshp2011/TGRSHP2011_TechDoc_E.pdf

I think we are missing a bunch too.  Haven't bothered reconciling their list
with what we have.

That's probably a good start.  The normalize_address function itself is
kinda scary to looku at but you can if you want.  We were hoping to
modularize it a bit more later.


Hope that helps,
Leo and Regina
http://www.postgis.us



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of James
Marca
Sent: Thursday, September 27, 2012 4:06 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Tiger geocoder,Spanish street types are pushed
to the end

On Thu, Sep 27, 2012 at 03:56:53PM -0400, Paragon Corporation wrote:
> James,
> 
> Sadly this is a known issue and one we haven't settled on the best way 
> to fix without resorting to major surgery.

oops, my bad.  I forgot to look at the open tickets.

> 
> Here is the ticket for it:
> 
> http://trac.osgeo.org/postgis/ticket/1118
> 
> If you can add your examples to the ticket and add yourself to cc for 
> the ticket that would be great.  We'll add these to our regress tests 
> when we finally come up with a palpable fix.

I'll do it now

> 
> 
> In MA we have similar issues, but mostly with french streets locally 
> they are a rare occurrence, but Leo feels your pain about Cali since 
> he's a San Diego boy.

I was going to say this might be a problem in other countries, but, duh,
Tiger is US-only.

> 
> Sorry we couldn't be more helpful.

I'm a reasonably competent hacker, so if you point me at the right
file(s) I'd be happy to try my hand.

Regards,
James