[postgis-users] Geocoding cross streets?

Aren Cambre aren at arencambre.com
Mon Nov 28 12:13:39 PST 2011


Hey, thanks!

I used this query:

*SELECT g.rating, ST_X(geomout) AS lon, ST_Y(geomout) AS lat, (addy).* FROM
geocode('XXXX') as g;*
*
*
where *XXXX* is replaced with strings like:

   - *erin and tralee, dallas, tx*
   - *erin & tralee, dallas, tx*
   - *sagecanyon & sagegreen, houston, tx*

Those produce lat/longs that are a few miles from the correct locations.
*
*
Aren

On Mon, Nov 28, 2011 at 1:33 PM, Johnathan Leppert <
johnathan.leppert at gmail.com> wrote:

> Cross-streets should be supported. Can you supply your exact query and
> what versions of PostGIS and geocoder you are using?
>
> Johnathan
>
> On Mon, Nov 28, 2011 at 9:26 AM, Aren Cambre <aren at arencambre.com> wrote:
>
>> I have the TIGER geocoder running with PostGIS 2.0 as per
>> http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data.
>>
>> It seems to do well finding street addresses, but it can't seem to find
>> cross streets. For example, if I geocode *sagecanyon and sagegreen,
>> houston, tx*, I get a location on the other side of town. Here's a
>> Google Map showing both: http://g.co/maps/nphp9
>>
>> Can I even use the TIGER geocoder for cross streets?
>>
>> Aren
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
> --
> *Johnathan*
> Software Engineer
> San Francisco, California
> *Follow me on Twitter: @iamleppert <http://twitter.com/#!/iamleppert>*
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111128/4c0b7c40/attachment.html>


More information about the postgis-users mailing list