<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"
data-hsystem="true"><style>p{margin: 0;padding: 0;}</style></head><body><p>On
Fri, 26 Apr 2013 10:07:37 -0700, maplabs@light42.com wrote:<br>does this call
look right to you Steve?<br>
> <br>
> create table cc_s_03_13_std_addr as<br>
> select (f).* from ( select c.pkey,<br>
> standardize_address( <br>
> 'select * from lex'::text, <br>
> 'select * from gaz'::text, <br>
> 'select * from rules'::text, <br>
> 'select 1::integer as id, address as micro, city||'', CA ''||zip as
macro<br>
> from cc_s_h_03_13'::text <br>
> ) as f <br>
> from cc_s_h_03_13 c offset 0)<br>
> s;<br>
> </p><p><br></p><p>Something isnt right with that.. it makes far too many
results..</p><p>at any rate, I disregarded sew-refactor2 and built
sew-refactor</p><p>This appears to run.. starting to look into it
now..</p><p>--</p><p>drop table if exists cc_sales_std_addrs_03_13
cascade; create table cc_sales_std_addrs_03_13 (id integer not null primary
key,building varchar,house_num varchar,predir varchar,qual varchar,pretype
varchar,name varchar,suftype varchar,sufdir varchar,ruralroute varchar,extra
varchar,city varchar,state varchar,country varchar,postcode varchar,box
varchar,unit varchar,name_dmeta varchar);<br><br>insert into
cc_sales_std_addrs_03_13 (id, building, house_num, predir, qual, pretype, name,
suftype, sufdir, ruralroute, extra, city, state, country, postcode, box, unit,
name_dmeta)select *, coalesce(nullif(dmetaphone(name),''), name) as
name_dmetafrom standardize_address('select * from lex order by id','select *
from gaz order by id','select * from rules order by id','select pkey as
id,address as micro,array_to_string(ARRAY[city,''CA'',zip], '','') as macrofrom
cc_sales_history_03_13order by pkey');<br></p><p><br></p><p>--</p><p>Brian M
Hamlin</p><p>OSGeo California Chapter</p><p>415-717-4462
cell</p><p><br></p></body></html>