[postgis-tickets] [PostGIS] #1118: Street pretypes that aren't directional prefixes

[PostGIS]

#1118: Street pretypes that aren't directional prefixes
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  robe          
     Type:  defect               |      Status:  new           
 Priority:  medium               |   Milestone:  PostGIS Future
Component:  pagc_address_parser  |     Version:  1.5.X         
 Keywords:                       |  
---------------------------------+------------------------------------------

Comment(by robe):

 Yah I was thinking of it in future.  I'll ticket that I'm leaning toward
 using hstore to store the normalized hash for the tiger set possibly only
 doing it for the obvious ambiguities.

 The issue I have with doing it for after load and for all

 1) inserting is a lot less painful than updating since updating requires
 both an insert and delete. So its faster to do on load.

 2) Since this is in flux, they'll be a lot of updating going on initially
 so I don't want to push that on users until things are more stable, plus
 it complicates update script with update requiring user data changes --
 something I kind of want to stay away from until I have my upgrade bullet
 proof.

 3) I actually don't think its necessary to standardize all tiger (I would
 say about 85% or more of it is fine).  For the most part there aren't that
 many ambiguities and a lot of those would be long and painful to itemize
 and doing it by lex is probably not the right way.

 Clearly for things like Camino etc that would be the right thing.

 so I'm thinking more along a hybrid.  It would also make my hstore index
 way shorter and faster to scan if its only the questionable problematic
 ones that need to be changed.  Anyway I'll put in a separate future
 ticket.  For PostGIS 2.1 I would like to change the norm_addy structure
 since that is part issue that I am mixing pre abbrev with post abbrevs.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1118#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.