[ home | files | links | topics | stickers | about ]



Todays Stats

Visitors: 233
Referrers: 16
User Agents: 91
Pages Served: 1094
 
Total Pages
Served:

4668102


Search


Texas Historical Markers
programming : by Tommy - September 1st 2011, 10:51AM
programming
While arguably probably not my best work, it only took me all of a couple hours, I present a listing of all the Texas Historical Markers. I don't know why I never linked to it before. Maybe I'm not too proud of it, but I wanted to give you access to it. What features do I need to add?

I discovered one evening that Texas has a database of all historical markers in the state freely available online in a comma separated value file (among other formats). What's a geek to do but grab the file and throw it in a MySQL database!
I whipped up a quick drop-down list of all the marker names and used AJAX to show the marker's text. A couple of simple URLs allow you to see, generally, where the marker is located. I have the location information in the database, but it's not Lat/Long which would make for easy map-making. Perhaps that will be my next step. Found a supporting .txt file that has most of the Lat/Long. A simple JOIN from the database fixed that problem. (though, to be honest, some of the coordinates are way off. Unless Texas has markers in Mexico.)

At any rate, take it or leave it, there it is: http://n5dux.com/histmark/
Tweet|Google+|Facebook


tags: texas history php database


+ Mackieman
  Sep 19, 2011 16:19
  
#18778
I wonder if it's possible to extend that out so one could create one's own map of markers visited.

reply




-+- neodux blog -+-
Page generated for 54.146.5.196 in 0.01191 seconds.
rss 2.0 feed