[postgis-tickets] [PostGIS] #3162: geocode_intersection crashes on an intersection

[PostGIS]

#3162: geocode_intersection crashes on an intersection
----------------------------+---------------------------
 Reporter:  alexreinhart    |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 2.1.8
Component:  tiger geocoder  |    Version:  2.1.x
 Keywords:                  |
----------------------------+---------------------------
 I am using the Pennsylvania TIGER data (loaded with
 `Loader_Generate_Script`) to geocode a large quantity of addresses. I
 consistently get the following error in `geocode_intersection` with one
 intersection:
 {{{
 crime=# SELECT rating, pprint_addy(addy), st_astext(geomout)
 crime-# FROM geocode_intersection('Brighton Rd', 'Viruth St', 'PA',
 'Pittsburgh', '15212');
 ERROR:  invalid input syntax for integer: "3865-99"
 CONTEXT:  PL/pgSQL function
 geocode_intersection(text,text,text,text,text,integer) line 122 at
 assignment
 }}}
 Google Maps suggests the intersection does exist, but I don't have an easy
 way to examine the TIGER data to see if it's included.

 Thanks.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3162>
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.