[postgis-devel] Updates to address standardizer

maplabs at light42.com maplabs at light42.com
Fri Apr 26 10:07:37 PDT 2013

does this call look right to you Steve?

create table cc_s_03_13_std_addr as
select (f).* from ( select c.pkey,
    'select * from lex'::text,  
    'select * from gaz'::text,  
    'select * from rules'::text,  
    'select 1::integer as id, address as micro, city||'', CA ''||zip as macro
      from cc_s_h_03_13'::text 
  ) as f                                
  from cc_s_h_03_13 c offset 0)

On Thu, 25 Apr 2013 21:11:22 -0400, Stephen Woodbridge 
<woodbri at swoodbridge.com> wrote:
Hi all,
> There have been a bunch of small updates to the pagc address 
> standardizer today. 
> * relaxed sanitizing lex, gaz and rules table names and allowed schemas
> * added "order by id" to the internal queries to select the records 
> from these tables, because changes in order can potentially impact 
> results. 
> * cleanup some compile time warnings
> * added some missing error checks so we exit nicely
> So if you are tracking this, it would be good to pull the current 
> copy (Rev: 357). 
> If you have questions on how to use this or how it works, I'll be 
> happy to answer them if I can. 
> Thanks,
>    -Steve
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel

More information about the postgis-devel mailing list