Ticket #1366 (closed defect: fixed)
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
Note: See
TracTickets for help on using
tickets.
