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 ksu...@gmail.com _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users