TexasCHLforum.com

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

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.

ETA:

It is Keyhole Markup Language. Here is an example;
If the coordinates of the 30.06 postings were known it would be a trivial matter to write a query to output the aforementioned file.

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?

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)

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.

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?

that1otherdude wrote:

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?

Hang tight, Russell runs texas3006.com and I am sure he is already banging out a script to get this done.

Do you have google earth installed? You can also browse texas3006.com in the meantime and get the list for you area.

Russell wrote:It'll be a little bit =) Maybe this weekend. I can do everything but the address-to-coordinate conversions. I will need to look into how to do a batch conversion with batchgeocode.

I used the sample data they provided and it just spits back out another tab delimited file with the coordinates added. I added a "key" field into the input data and the output data did contain the correct info after processing.

Russell wrote:

kd5zex wrote:

Russell wrote:It'll be a little bit =) Maybe this weekend. I can do everything but the address-to-coordinate conversions. I will need to look into how to do a batch conversion with batchgeocode.

I used the sample data they provided and it just spits back out another tab delimited file with the coordinates added. I added a "key" field into the input data and the output data did contain the correct info after processing.

If you've already done it, I would be happy to send you the output in the keyhole format above, and then you can throw that into geocode if you have the time.

The reason why it would take me a few days to get this done is work + school = no time for Russell

I have also done this type of map before, so if kd5zex is tied up, I would be happy to assist.

I am (not so successfully) patiently awaiting this

It's killing me I love new ideas like this and love seeing cooperation like you guys are doing.

I had to zip it to comply with the attachment rules.

Enjoy!