id summary reporter owner description type status priority milestone component version resolution keywords cc 887 Tiger geocoder fails when address contains name of state sometimes robe robe "See: http://www.postgis.org/pipermail/postgis-users/2011-March/029236.html {{{ SELECT g.rating, ST_X(g.geomout) as lon, ST_Y(g.geomout) as lat FROM GEOCODE('2450 N COLORADO ST, PHILADELPHIA, PA, 19132') as g; ERROR: query string argument of EXECUTE is null CONTEXT: PL/pgSQL function ""location_extract"" line 54 at EXECUTE statement PL/pgSQL function ""normalize_address"" line 142 at assignment PL/pgSQL function ""geocode"" line 10 at assignment }}} for details. Though I'm not convinced it's just state name at issue (might be when there is a street prefix) since in example docs we geocode Massachusetts Avenue fine. e.g. 77 Massachusetts Avenue, Cambridge, MA 02139 doesn't give error " defect closed medium PostGIS 2.0.0 tiger geocoder master fixed history danpelota@…