Texas3006.com is open to the public!

CHL discussions that do not fit into more specific topics

Moderators: carlson1, Charles L. Cotton

User avatar
G.A. Heath
Senior Member
Posts: 2987
Joined: Sat Mar 31, 2007 9:39 pm
Location: Western Texas

Post by G.A. Heath »

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)
propellerhead
Senior Member
Posts: 917
Joined: Tue May 09, 2006 9:12 am
Location: The part of Texas that isn't like Texas

Post by propellerhead »

Category, not catagory.
1TallTXn
Member
Posts: 163
Joined: Thu Dec 01, 2005 5:41 pm
Location: S DFW
Contact:

Post by 1TallTXn »

Good to see a listing. Thanks!
Taurus PT-111MP
Springfield XD-9 Service
KBCraig
Banned
Posts: 5251
Joined: Fri May 06, 2005 3:32 am
Location: Texarkana

Post by KBCraig »

Russell wrote:The category "financial" has been added
Excellent. I edited Red River Credit Union to reflect this.
Stupid
Senior Member
Posts: 910
Joined: Fri Nov 11, 2005 12:02 am

Post by Stupid »

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;
User avatar
Charles L. Cotton
Site Admin
Posts: 17788
Joined: Wed Dec 22, 2004 9:31 pm
Location: Friendswood, TX
Contact:

Post by Charles L. Cotton »

Stupid wrote:Can you add a section of general off-limit places?
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.

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.
Post Reply

Return to “General Texas CHL Discussion”