[postgis-devel] Subject=Re: Updates to address standardizer

[Stephen Woodbridge]

On 8/1/2013 11:24 AM, Stephen Woodbridge wrote:
> On 8/1/2013 9:45 AM, Mitchell Gibbs wrote:
>> Thanks very much for all of your work on integrating the PAGC address
>> parser into PostGIS. I'm new to PostGIS and was getting frustrated with
>> the old address parser. The PAGC standardizer took some time to figure
>> out but now that's I've got it working the quality of the results is
>> much better and the performance is a huge boost.
>>
>> I am finding a situation that is confounding the current version and I
>> wondered if there might be a simple solution.
>>
>> If an apartment has a designation like "1SW", the standardizer returns
>> nothing. (e.g. "12345 S EVANS RD APT 1SW, OAK PARK, IL 60453"). Changing
>> the unit designation to 1S or 1W works fine.
>>
>> Any advice?
>
> You can add the following rule to the rules table:
>
> insert rules set rule='16 0 22 -1 16 17 17 -1 4 7';

Obviously, this should be:

insert into rules (rule) values ('16 0 22 -1 16 17 17 -1 4 7');

The rules table the is packed with the the tiger_geocoder, I think has 
additional columns to identify user added rules and you might need to 
set values for other columns also.

-Steve

> This parses:
>
> APT 1 SW as:
>
> UNITH NUMBER DIRECT -> UNITH UNITT UNITT
>    16    0     22    -1   16    17    17  -1 EXTRA RANK(7)
>
> You wil have to read more about the rules in pagclib and the pagc docs.
> You can also use pagc_stand to get some diagnostic output on how the
> standardizer works.
>
> -Steve
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel