[postgis-devel] Address standardizer data templates

[Stephen Woodbridge]

On 10/25/2014 2:53 AM, Paragon Corporation wrote:
> Thinking about the new extension to hold lookup data for address
> standardizer, I was thinking of just having one. We only have us now, but
> even if it goes I don't want to have to install 20 extensions just to get
> rules,lex,gaz for each.
>
> So I am going to call it
>
> address_standardizer_data_templates
>
>
> And will package the current ones, but instead of calling the tables
> lex,gaz,rules
>
> Will call it
>
> Us_lex, us_gaz, us_rules
>
>
> So they don't conflict if we add more.
>
>
> Steve,
>
> Are you okay with that?

Yes, I think that makes sense at least for now. In the future this could 
have a lot of tables, but as we discussed earlier, one can load the 
extension copy the tables they need and then drop the extension.

Thinking about this, once you standardize your data, you need to keep 
the lex, gaz, rules tables with that data so future standardization 
calls generate compatible results. It is possible that in a version 
upgrade that the extension data has changed so you would NOT want those 
tables changing in your geocoder without restandardizing the reference 
data. So it makes sense to install and copy the desired tables. We 
should explicitly document that they should copy and drop the extension.

-Steve