Re: [postgis-users] Geocoding cross streets?

2011-12-01 Thread Aren Cambre
My question is already answered: someone committed changes at http://trac.osgeo.org/postgis/ticket/1333#comment:3. Are these already in the SVN trunk? Aren On Wed, Nov 30, 2011 at 6:29 PM, Aren Cambre a...@arencambre.com wrote: Based on the conversation below, it appears there is already a

Re: [postgis-users] Geocoding cross streets?

2011-11-29 Thread Stephen Woodbridge
On 11/29/2011 12:20 AM, Stephen Frost wrote: Steve, * Stephen Woodbridge (wood...@swoodbridge.com) wrote: This is probably a fairly clean and only little more complex than hello world, but not majorly so, if you want to try your hand at it. Pretty sure that I could manage it- but I'm

Re: [postgis-users] Geocoding cross streets?

2011-11-29 Thread Stephen Woodbridge
On 11/29/2011 12:42 PM, Stephen Frost wrote: * Stephen Woodbridge (wood...@swoodbridge.com) wrote: I currently have some lists of names that are converted to optimized pcre regular expressions. I uses these to help separate the street from the city name. The lists are only used to create header

[postgis-users] Geocoding cross streets?

2011-11-28 Thread Aren Cambre
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

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Adam Eskreis
I'd suggest looking into Google's geocoder API. On Mon, Nov 28, 2011 at 12:26 PM, Aren Cambre a...@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,

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Johnathan Leppert
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 a...@arencambre.com wrote: I have the TIGER geocoder running with PostGIS 2.0 as per

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Aren Cambre
Hey, thanks! I used this query: *SELECT g.rating, ST_X(geomout) AS lon, ST_Y(geomout) AS lat, (addy).* FROM geocode('') as g;* * * where ** is replaced with strings like: - *erin and tralee, dallas, tx* - *erin tralee, dallas, tx* - *sagecanyon sagegreen, houston, tx* Those

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Paragon Corporation
To: PostGIS Users Discussion Subject: Re: [postgis-users] Geocoding cross streets? Hey, thanks! I used this query: SELECT g.rating, ST_X(geomout) AS lon, ST_Y(geomout) AS lat, (addy).* FROM geocode('') as g; where is replaced with strings like: * erin and tralee, dallas, tx

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Stephen Woodbridge
...@postgis.refractions.net mailto:postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Aren Cambre *Sent:* Monday, November 28, 2011 3:14 PM *To:* PostGIS Users Discussion *Subject:* Re: [postgis-users] Geocoding cross streets? Hey, thanks

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Paragon Corporation
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen Woodbridge Sent: Monday, November 28, 2011 5:39 PM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Geocoding cross streets? On 11/28/2011 5:28 PM, Aren Cambre wrote: I think that *geocode_intersection

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Stephen Woodbridge
-users-boun...@postgis.refractions.net] On Behalf Of Stephen Woodbridge Sent: Monday, November 28, 2011 5:39 PM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Geocoding cross streets? On 11/28/2011 5:28 PM, Aren Cambre wrote: I think that *geocode_intersection* function

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Stephen Frost
* Paragon Corporation (l...@pcorp.us) wrote: The cross streets feature takes a different algorithm. We do have that coded as a sub process in one of our projects, but it's not committed in tiger geocoder. Feel free to post a ticket under tiger_geocoder if you are interested in seeing it

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Aren Cambre
@postgis.refractions.net Subject: Re: [postgis-users] Geocoding cross streets? On 11/28/2011 5:28 PM, Aren Cambre wrote: I think that *geocode_intersection* function would be perfect! I just entered an enhancement request at http://trac.osgeo.org/postgis/**ticket/1333http://trac.osgeo.org/postgis/ticket

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Stephen Woodbridge
: Re: [postgis-users] Geocoding cross streets? On 11/28/2011 5:28 PM, Aren Cambre wrote: I think that *geocode_intersection* function would be perfect! I just entered an enhancement request at http://trac.osgeo.org/postgis

Re: [postgis-users] Geocoding cross streets?

2011-11-28 Thread Stephen Frost
Steve, * Stephen Woodbridge (wood...@swoodbridge.com) wrote: This is probably a fairly clean and only little more complex than hello world, but not majorly so, if you want to try your hand at it. Pretty sure that I could manage it- but I'm curious.. Do you use an external sources or bits of