[Live-demo] [OSGeo] #1634: PostGIS Quickstart needs updating

OSGeo trac_osgeo at osgeo.org
Wed Jun 15 12:20:58 PDT 2016


#1634: PostGIS Quickstart needs updating
----------------------+--------------------------
 Reporter:  camerons  |       Owner:  live-demo@…
     Type:  defect    |      Status:  new
 Priority:  major     |   Milestone:
Component:  LiveDVD   |  Resolution:
 Keywords:  postgis   |
----------------------+--------------------------

Comment (by darkblueb):

 extension `standardize_address` confirmed -- there may be an ''Easter
 Egg''
 {{{
 user=# 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');
  house_num |    name    | suftype |  city  | country |     state     |
 unit
 -----------+------------+---------+--------+---------+---------------+-----------------
  1         | DEVONSHIRE | PLACE   | BOSTON | USA     | MASSACHUSETTS | #
 PENTHOUSE 301
 (1 row)
 }}}

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1634#comment:2>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.


More information about the Live-demo mailing list