NYCPHP Meetup

[Andy Crain]

Check out the U.S. Census Bureau's TIGER files:
http://www.census.gov/geo/www/tiger/. They're used primarily for GIS work,
but you can use the underlying .dbf files for streets. They contain address
ranges for every street in the U.S. So, a particular street segment record
would have something like name:Main St., left_from: 120, left_to 300, right
from: 121, right_to: 301.
In a GIS, you could pull out only those street segments within 3.5 miles of
your customer's address, then match queries against that limited set of
street segments.
Andy Crain


> -----Original Message-----
> From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org]
> On Behalf Of Joseph Crawford
> Sent: Tuesday, October 05, 2004 12:33 PM
> To: NYPHP Talk
> Subject: [nycphp-talk] Search By Distance In Miles
> Importance: High
> 
> Guys,
> 
> i know you can use a lon/lat database to search for things X miles
> from a zip code, has anyone here ever had the challenge of marking an
> address as the center of a radius and searching for other addresses
> within 3 miles of that address?
> 
> i am asking because a potential client only delivers up to 3.5 miles
> from his shop, however he has over 20,000 customers in that small
> area.  Now have you ever heard of doing a search to find out if an
> address is 3.5 miles from his shop address? the client checked with
> mapquest and they want something like $35,000 a year to provide him
> with this service.
> 
> --
> Joseph Crawford Jr.
> Codebowl Solutions
> codebowl at gmail.com
> 802-558-5247
> 
> For a GMail account
> contact me OFF-LIST
> _______________________________________________
> New York PHP Talk
> Supporting AMP Technology (Apache/MySQL/PHP)
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.newyorkphp.org
>