Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a dataset that describes a few million incidents along Texas roadways. The vast majority of incidents only list a highway name and a milepost. For example, milepost 120 on I-20 or milepost 263 on US 60.

How would I convert these milepost/highways to latitude and longitude?

This is for a low-budget academic project, so trying to stick with free tools as much as possible.

My Google searching hasn't turned up much fruit, although some indications are that TxDOT may have data I could request through the Texas Public Information Act, but not sure yet.

share|improve this question

3 Answers 3

up vote 4 down vote accepted

I'd try to contact Michael Chamberlain at TxDOT. He's made a lot of progress in opening up TxDOT data, for example this map viewer. His contact info is at the end of this presentation.

I suspect you might need the TRM Data Export, as described here.

If you have a table of points with: HighwayName Latitude Longitude Mile

Then it is a matter of interpolating lat/long between two adjacent rows using the Mile post value (safe to assume flat earth here). If you have historic data, keep in mind road re-alignments can sometimes result in milepoint changes. I think TxDOT tried to manage this using a method described in this paper, but was unsuccessful.

share|improve this answer
    
Thank you for the tip! I will check on Michael. I was able to get that article through my university's library. Thanks for suggesting it as the TxDOT system seemed confusing per the stuff I found in their online documentation. –  Aren Cambre Dec 2 '10 at 3:35
    
Contacted Michael. The data I need is the TxDOT Roadways 2010 at tnris.state.tx.us/datadownload/download.jsp. He said I will need to use linear referencing still, but that's a start. –  Aren Cambre Dec 3 '10 at 22:36
    
Just as follow up, the data at that URL (now tnris.org/get-data?quicktabs_maps_data=1) did not have mile markers. I had to separately request mile marker geo-data directly from TxDOT. –  Aren Cambre Nov 14 '12 at 3:38

Here is another Free Software GIS with LRS support: http://grass.osgeo.org/grass64/manuals/html64_user/lrs.html . The page includes references to two publications as well.

share|improve this answer
    
Thanks. I did download and review GRASS GIS a few weeks ago but moved to Quantum GIS as it appeared to have broader usage and actually includes GRASS GIS 6.4 as a package. But not sure Quantum GIS's LR module is as thorough as GRASS's. –  Aren Cambre Dec 2 '10 at 3:42

This is a problem of linear referencing. Here is a great description from the OpenGeo site http://opengeo.org/products/coredevelopment/postgis/lrs/

It looks like all the features are not yet in PostGIS. I am not sure of any other FOSS package that supports it.

Depending on the licensing at your university you may have access to ESRI software which I know supports it.

The other problem is getting your hands on the data - which getting the DOT may be helpful though the format they give you might be a problem.

share|improve this answer
    
Per markusN, looks like GRASS GIS supports it, and Quantum GIS also has a LR module. We do have ArcGIS, but it's going to be a pain to get it on my laptop due to licensing. Plus I'd like to acquire GIS app skills that I can use anywhere, not just in context of the degree I'm working on, so hoping (naively?) that the FOSS packages may be sufficient? –  Aren Cambre Dec 2 '10 at 3:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.