Ticket #1366 (closed defect: fixed)

Opened 19 months ago

Last modified 19 months ago

geocode_intersection returns nothing with lowercase state

Reported by: arencambre Owned by: robe
Priority: medium Milestone: PostGIS 2.0.0
Component: tiger geocoder Version: trunk
Keywords: Cc: aren@…

Description

If I run this:

SELECT addy, ST_X(ST_SetSRID(geomout,4326)), ST_Y(ST_SetSRID(geomout,4326)), rating
FROM geocode_intersection('ross', 'harwood', 'tx', 'dallas')

...I get no results.

If I run this:

SELECT addy, ST_X(ST_SetSRID(geomout,4326)), ST_Y(ST_SetSRID(geomout,4326)), rating
FROM geocode_intersection('ross', 'harwood', 'TX', 'dallas')

...I get expected results.

The only difference is capitalization of the state field: if not uppercase, I get no results.

Change History

Changed 19 months ago by robe

  • status changed from new to closed
  • resolution set to fixed

fixed at r8355

Note: See TracTickets for help on using tickets.