TexasCHLforum.com

Russell wrote:The script is now available again. If anyone is interested let me know and I will enable the feature on your account so that when you login at http://www.texas3006.com" onclick="window.open(this.href);return false; you will see the link under your username.

I'd like the feature on mine if you get a chance..

thanks!

Russell wrote:The retrieve data file itself has been taken down for now while I work on a new version of the site, since the database structure itself is going to be changed a bit.

After the new release of the site if anyone is still interested in having raw access to the data I will have a special section of the site where you can login and retrieve it anytime you want

Fantastic. Everyone who makes use of this owes you thanks for your hard work and ingenuity. Thank You!

SkinnyB78 wrote: this rocks!!!

I was thinking that it could get to a point where we could get to something like Gas Buddy (a collaborative effort like Russell has done with http://texas3006.com/" onclick="window.open(this.href);return false; or something like that.. it would be great for color coding for easy visual reference.. I uploaded Russel's data (this one still has all the Taco Cabana's in it but it is just something to play around with at this point...) I'm sure much smarter people than I (and more tech savvy) already know how to put it together as a collaborative map that can grow....

a very rough incomplete draft can be found at the following link to an Open Google Map...


http://maps.google.com/maps/ms?hl=en&ie ... 14511b&z=7" onclick="window.open(this.href);return false;

Russell wrote:Here you go!

http://www.texas3006.com/retrieve_data.php" onclick="window.open(this.href);return false;


It is bar delimited, so just copy/paste this into http://www.batchgeocode.com/" onclick="window.open(this.href);return false; and select bar delimited and you should be good to go.

I tested it and it could map 236/239 addresses. It wouldn't tell me which ones it couldn't map though.

Let me know if you need anything else on that output.

Awesome!

kd5zex wrote:

Russell wrote:I would be happy to write a quick php script to output the whole entries database into a file with that markup language if wanted, however I do not know how to get coordinates from addresses easily.

Any thoughts?

http://www.batchgeocode.com/ I tried this service on a few addresses and it came out dead on. I did not try the batch method so I don't know what kind of output it produces.

You could create the tab delimeted file, use that tool and push the coordinate data into the DB.

This is manual and is not optimal but you could get a .kmz in pretty short order and then work out a way to automate it.

Is there any legwork that a tech-dumb guy (me) could do?

Russell wrote:I would be happy to write a quick php script to output the whole entries database into a file with that markup language if wanted, however I do not know how to get coordinates from addresses easily.

Any thoughts?

I sent a link to the Moderators over at Texas3006.com and maybe they can help with this...


(thanks for being willing to help out I am really impressed at the members of this forum..good people)

kd5zex wrote:It probably would not be a monumental task to take the data from texas3006.com and dump it into a google earth .kmz file. I don't know the format of the .kmz but if I had to guess it is some sort of xml.

Does anyone know a Moderator over there that might be willing to help get the data necessary to do this?

Is anyone here tech savvy enough to figure out how to put together a map of businesses/restaurants/etc.. that post 30.06 or are otherwise CHL unfriendly?

I have two reasons to want something like this:

1. I want to keep fresh on business around me that I frequent now (I haven't received plastic yet) but haven't yet seen the 30.06 posted (I AM looking for them).


More Importantly

2. I am not interested in patronizing businesses that are not gun friendly.


Thanks, and please don't beat me up too bad if this is dumb idea..