[postgis-tickets] [PostGIS] #2193: Utilize PAGC parser as drop in replacement for tiger normalizer

[PostGIS]

#2193: Utilize PAGC parser as drop in replacement for tiger normalizer
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  enhancement     |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.1.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by woodbri):

 pcre.dll is only used in address_parser which takes an address in a single
 string and tries to break it into components. This is pretty handy and I
 think most people will want to use it.

 I don't have a strong feeling about static linking or not on Windows.

 For the rules.sql, lexicon.sql, gazeteer.sql as part of the extension, I
 think I would make these a separate extension if possible, may be like:

 {{{
 CREATE EXTENSION tiger_support_tables;
 CREATE EXTENSION canada_support_tables;
 CREATE EXTENSION navteq_support_tables;
 CREATE EXTENSION foobar_support_tables;
 }}}

 While the current geocoder is focused on Tiger, using this extension makes
 it trivial to support other data like Canadian Census data, or commercial
 data like Navteq or TeleAtlas, just be loading a different set of lexicon,
 gazeteer and rules. I have already done this by by using splitting the the
 vendor data into one table and then standardizing into a second table the
 is linked by the vendor data table gid. This essentially allow you to
 decouple the vendor data for the standardizer and geocoder search and
 result scoring. My code is not totally there yet but it is moving in that
 direction.

 I can see people wanting to add their own changes to these tables, but I
 can also see the need to wholesale replace them for different data as I'm
 doing. That said, I can work around whatever you think is best for the
 tiger geocoder.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2193#comment:1>
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.