[postgis-tickets] [PostGIS] #3161: geocode_intersection returns a null rating for a specific intersection

PostGIS trac at osgeo.org
Thu Jun 11 20:25:28 PDT 2015


#3161: geocode_intersection returns a null rating for a specific 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'm using the TIGER data for Pennsylvania (loaded with
 `Loader_Generate_Script`) to geocode a large quantity of addresses. One
 particular address returns a NULL rating, despite returning an address:

 {{{
 crime=# SELECT rating, pprint_addy(addy), st_astext(geomout) FROM
 geocode_intersection('Main St', 'Geneva St', 'PA', 'Pittsburgh', '15201');
  rating | pprint_addy |         st_astext
 --------+-------------+----------------------------
         | Main St, PA | POINT(-80.22262 41.571597)
 (1 row)

 crime=# SELECT rating IS NULL, pprint_addy(addy), st_astext(geomout) FROM
 geocode_intersection('Main St', 'Geneva St', 'PA', 'Pittsburgh', '15201');
  ?column? | pprint_addy |         st_astext
 ----------+-------------+----------------------------
  t        | Main St, PA | POINT(-80.22262 41.571597)
 (1 row)
 }}}

 The point returned is not in Pittsburgh, but I don't know if that's
 TIGER's fault or PostGIS's.

 My version is
 {{{
  PostgreSQL 9.3.8 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
 4.8.4-2ubuntu1~14.04) 4.8.4, 64-bit POSTGIS="2.1.2 r12389"
 GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER
 }}}
 Thanks.

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


More information about the postgis-tickets mailing list