I have the tiger geocoder extension installed, and the tiger data loaded
for the state of Georgia.  I can get a reasonable response from the
geocode_intersection function, but geocode, geocode_address and
reverse_geocode always fetch 0 rows.

For example:

select geocode_intersection( 'Patterson Ave', 'Walnut St', 'GA',
'Scottdale', '30079', 1 );

Gives this (correct) result:

"("(312,,Patterson,Ave,,,Scottdale,GA,30079,t)",
0101000020AD100000465ED6C4021155C0AB764D486BE44040,0)"

But this:

select * geocode_address( normalize_address( '312 Patterson Ave, Scottdale
GA 30079' ) );

Yields 0 rows.  I just get the header (addy, geomout, header).

Similarly,  I can get the coordinates for the intersection:

select st_astext( geomout ) from geocode_intersection( 'Patterson Ave',
'Walnut St', 'GA', 'Scottdale', '30079', 1
 );

Results in:

"POINT(-84.265794 33.784524)"

But
select
   pprint_addy( r.addy[1]) as st1,
   pprint_addy(r.addy[2]) as st2,
   pprint_addy(r.addy[3]) as st3,
   array_to_string(r.street, ',') as cross_streets
from
   reverse_geocode( st_geomfromtext( 'POINT(-84.265794 33.784524)',
4269),true) as r
;

Gives me 0 rows again.

I'm doing something very wrong.  Any nudges in the correct direction much
appreciated.

Thanks in advance,

Sara
-- 
Sara Yurman, GISP
Spatial Focus, LLC
Geodata Architects
http://www.spatialfocus.com/
Office: (404) 378-0989
Fax:    (404) 806-6257
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to