Postgis Geocode Newbie
Hi,
I'm trying to figure out if there is something wrong with my postgis set up. I successfully loaded Oregon data using the tiger_postgis_loader.sh and 2010 data.
If I run the following query:
SELECT ST_X(geomout) as lon, ST_Y(geomout) AS lat
FROM geocode('200 North 26th Ave, Cornelius OR, 97113') As g;
I get the following values returned
100 -123.05301 45.51976 <null> <null> Cornelius OR 97113
Google Earth says the values are 123.021438 45.311855
That's 20 miles off! I need precision within about a mile. How do I know if there's something wrong with the postgis setup?
|