I can help you there, the database dump, once I find it, also has the lat and lon for the zip code. This along with a little math will let you do a radius search.
Lets say I living in Seagraves Tx want to find all the 30.06 signs reported to your site in say 100 miles of my location could enter my zip code and choose 100 miles by either entering it or selecting it from a drop down menu (suggested).
Once I click submit the php script would do some math and determine what latitudes and longitudes make up the 100 mile radius and then search the DB for signs that the zip codes fall into that area. In my case that should return results from roughly Lubbock to Odessa. The down side is that it would add additional DB queries to the script and db unless the database is extended to include lat/lon (The end user would never have to see this as it could be input based on city name and/or zipcode)
Texas3006.com is open to the public!
Moderators: carlson1, Charles L. Cotton
-
- Senior Member
- Posts: 917
- Joined: Tue May 09, 2006 9:12 am
- Location: The part of Texas that isn't like Texas
Can you add a section of general off-limit places?
Please help the wounded store owner who fought off 3 robbers. He doesn't have medical insurance.
http://www.giveforward.com/ramoncastillo" onclick="window.open(this.href);return false;
http://www.click2houston.com/news/26249961/detail.html" onclick="window.open(this.href);return false;
http://www.giveforward.com/ramoncastillo" onclick="window.open(this.href);return false;
http://www.click2houston.com/news/26249961/detail.html" onclick="window.open(this.href);return false;
- Charles L. Cotton
- Site Admin
- Posts: 17788
- Joined: Wed Dec 22, 2004 9:31 pm
- Location: Friendswood, TX
- Contact:
That's a great idea I'm going to have to steal. We get that question a lot. I admire Russell for his efforts to keep up with 30.06 postings, something I wouldn't attempt to do, but the statutory "off-limits" areas rarely change.Stupid wrote:Can you add a section of general off-limit places?
I'll post a list in the CHL Checklist section along with citations to the Texas Penal Code. This might be a good addition to Texas3006.com also.
Thanks,
Chas.