TexasCHLforum.com

Updated .kml file and the website all sans Taco Cabana entries.
http://www.batchgeocode.com/map/?i=3c64 ... 7eab8b1238

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

Enjoy!

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.

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

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.