[postgis-users] Null results from geocode_intersection, postgis 2.0.1, postgreSQL 9.1.6

Katie Urey ksurey at gmail.com
Tue Oct 30 19:12:52 PDT 2012


Friends,

geocode_intersection returns nothing.  I'm a newbie!...So, I'd like some ideas.

First, the postgis (2.0.1) and PostgreSQL  9.1.6 versions:

POSTGIS="2.0.1 r9979" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23
September 2009" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
LIBJSON="UNKNOWN" RASTER

PostgreSQL 9.1.6 on i686-pc-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 32-bit
(1 row)

These commands return expected results:

 SELECT pprint_addy(normalize_address('100 NW 10th Ave, Portland,
Oregon 97239'));
 SELECT geomout FROM geocode_intersection( 'NW Davis', 'NW 10th',
'OR', 'PORTLAND');
select * from geocode('100 NW 10th Ave, Portland, OR 97239');

This ireturns nothing, even wihen I change the case, add a zipcode..
alter the names of the streets to include Ave/St...

select * from geocode_intersection('NW Davis', 'NW 10th', 'OR', 'Portland');

No results from this either:
SELECT addy, geomout,rating
FROM geocode_intersection('nw davis  st ', 'nw 10 ave', 'or',
'portland', '', 1);

Do I reload Oregon Data.  Correct a typo?  Reinstall postgis?
Reinstall the function?

thanks,

--
Katie Urey
ksurey at gmail.com



More information about the postgis-users mailing list