[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