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'm trying to add the footage of each point from the beginning of the line to the end. There are around 4k vertexes between the two ends that I need to put the footage from the beginning of the line and adds footage as it goes down the line.

An example would be three points total with 50 ft between them. The first point would be 0, the second point 50 and the third point 100 (that's just an example). Is there a way to do this?

I was going to break the line into segments based of vertexes to get the individual length of each segment. How would I have it add going down the line and add that combined footage to each point? I have arc 10.1, but am open to any solution/ideas.

share|improve this question
add comment

3 Answers 3

In ArcGIS, you can you the linear referencing tools for this. create one fields with the length in feet, and use this fields to create routes. Then you can use locate feature along route to extract the footage of each point.

share|improve this answer
    
This is the ArcGIS solution, but he doesn't have points yet - just the route line. And based on other questions, his license level is not sufficient to run Feature Vertices to Points. ET Geotools has a tool for this, but I don't know if that's an option - the demo could only handle 100 points at a time. Is there another way he could get points at the vertices in ArcGIS you could edit into your answer? @joebob the other alternative would be to create the points in QGIS for use in ArcGIS. –  Chris W Jun 6 at 6:58
1  
GME (spatialecology.com/gme/gmecommands.htm) can do it (line to point vertices) as well in order to stay in ArcGIS environment. Otherwise you need arcpy script and of course in QGIS. –  radouxju Jun 6 at 7:12
add comment

If you only want to do the job and it is not important to use just QGIS or arcgis, OpenJUMP 1.7.0 Plus has linear referencing tool which is very simple to use.

Open the tool

Location of the linear referencing tools

Fill in the parameters

Settings of the linear referencing tool

Result is a point layer with distances as an attribute

Output layer labeled with distances

share|improve this answer
    
I noticed that I did not answer to your question. You want to measure the distances to existing vertices, right? I can delete my answer in that case as invalid. –  user30184 Jun 5 at 20:07
    
Yeah, there aren't consistent numbers. I was just using 50 as an example. –  joebob Jun 5 at 20:25
    
Ok, I believe I can do it with Spatialite. Is it an acceptable tool for you? –  user30184 Jun 5 at 20:43
    
Is there a way to do it on MS SQL 2008? –  joebob Jun 5 at 21:39
add comment

If 'open to any solution/ideas', then you can also do it using postGIS database and window functions. If you're interested in this solution please comment my answer so I could prepare few queries for you.

share|improve this answer
add comment

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.