From 1af16d951637606945fd1a6be9f075529cf6eca5 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 27 Jun 2015 16:04:32 +0000 Subject: [PATCH] #2816 show output of address_standardizer_data_us git-svn-id: http://svn.osgeo.org/postgis/trunk@13724 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/extras_address_standardizer.xml | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/doc/extras_address_standardizer.xml b/doc/extras_address_standardizer.xml index bb0a1eb69..aad3389f5 100644 --- a/doc/extras_address_standardizer.xml +++ b/doc/extras_address_standardizer.xml @@ -570,9 +570,11 @@ into includes in the future for easier maintenance. Examples Using address_standardizer_data_us extension CREATE EXTENSION address_standardizer_data_us; -- only needs to be done once -SELECT * FROM standardize_address('us_lex', +SELECT house_num, name, suftype, city, country, state, unit FROM standardize_address('us_lex', 'us_gaz', 'us_rules', 'One Devonshire Place, PH 301, Boston, MA 02109-1234'); - + house_num | name | suftype | city | country | state | unit +----------+------------+---------+--------+---------+---------------+----------------- +1 | DEVONSHIRE | PLACE | BOSTON | USA | MASSACHUSETTS | # PENTHOUSE 301 Using tables packaged with tiger geocoder. This example only works if you installec postgis_tiger_geocoder. SELECT * FROM standardize_address('tiger.pagc_lex', 'tiger.pagc_gaz', 'tiger.pagc_rules', 'One Devonshire Place, PH 301, Boston, MA 02109-1234'); -- 2.50.1