[postgis-devel] [PostGIS] #1366: geocode_intersection returns nothing with lowercase state
PostGIS
trac at osgeo.org
Sun Dec 11 18:13:45 PST 2011
#1366: geocode_intersection returns nothing with lowercase state
----------------------------+-----------------------------------------------
Reporter: arencambre | Owner: robe
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.0.0
Component: tiger geocoder | Version: trunk
Keywords: |
----------------------------+-----------------------------------------------
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.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1366>
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-devel
mailing list