0
votes
2answers
49 views

Split lines into non-overlapping subsets based on points

Given a table with line geometry, and one or more points that are snapped to this line in a separate table, I would like to split each line with one or more intersecting points at each of the ...
0
votes
1answer
52 views

Best method to find routes from a set of points

I have lines table (postgis enabled database) representing the streets. I have collected few gps points along a route and I would like to match it with the streets in order. Scenario - I am jogging ...
2
votes
1answer
100 views

How to access M-values in QGIS?

I am working with Linear Reference Systems and I know is very easy to get M coordinate (M-value) from a shapefile in ArcGIS. But, how to get the M-value in QGis? If you have doubts about my issue, ...
1
vote
0answers
112 views

PostGIS: How to distinguish overlapping routes (i.e., LineStrings) based on their direction?

I have a set of routes which are represented by LineStrings in my PostGIS database. These routes represent journeys that people make. I want to come up with routes that (a) overlap, and (b) have the ...
2
votes
0answers
259 views

How to use the linear referencing plugin?

I need a guide how to use this plugin properly, I'm a newbie on PostGIS and I'm trying to use the linear referencing plugin of QGIS. I've created a database on postgreSQL with the postGIS extension ...
1
vote
2answers
200 views

Postgis 2.0 - How to get a Point from given LinestringM and a measure?

If I have a cable route linear referenced and stored in a LinestringM with M value is the length (in meters) from the start of the route - for example: LINESTRING M (0 0 0, 10 0 20, 12 0 40, 20 0 50, ...
3
votes
2answers
1k views

How to get accurate mile markers from DOT ShapeFile?

I'm having trouble getting accurate mile markers through route traversal using PostGIS. Based on the discussion in Geocode from mile marker/milepost to latitude/longitude?, I downloaded Texas ...