[postgis-tickets] [PostGIS] #2968: TIGER Geocoder data loading misc

[PostGIS]

#2968: TIGER Geocoder data loading misc
----------------------------+-----------------------------------------------
 Reporter:  darkblueb       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.2.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by darkblueb):

 {{{ create extension postgis_tiger_geocoder; }}}

 executes, but '''address_standardizer''' is not added.

 {{{ addr_test_94=# \df add*  => no results }}}

 executing
 {{{ create extension address_standardizer; }}}

 {{{
 addr_test_94=# create extension address_standardizer ;
 CREATE EXTENSION

 ##--
 addr_test_94=# select * FROM parse_address('1 Devonshire Place, Boston, MA
 02109-1234');
  num |      street      | street2 |      address1      |  city  | state |
 zip  | zipplus | country
 -----+------------------+---------+--------------------+--------+-------+-------+---------+---------
  1   | Devonshire Place |         | 1 Devonshire Place | Boston | MA    |
 02109 | 1234    | US
 (1 row)

 ##--
 addr_test_94=# SELECT *  FROM standardize_address('tiger.pagc_lex',
    'tiger.pagc_gaz', 'tiger.pagc_rules', 'One Devonshire Place, PH 301,
 Boston, MA 02109-1234');

  building | house_num | predir | qual | pretype |    name    | suftype |
 sufdir | ruralroute | extra |  city  | state | country | postcode | box |
 unit
 ----------+-----------+--------+------+---------+------------+---------+--------+------------+-------+--------+-------+---------+----------+-----+-----------------
           | 1         |        |      |         | DEVONSHIRE | PL      |
 |            |       | BOSTON | MA    | USA     | 02109    |     | #
 PENTHOUSE 301
 (1 row)


 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2968#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.