I have the same question as described in this question.
I have numerous milepost addresses (like Milepost 58.3 , US 30,NJ
)
Is there a way to do this in PostGIS?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this communityI have the same question as described in this question.
I have numerous milepost addresses (like Milepost 58.3 , US 30,NJ
)
Is there a way to do this in PostGIS?
UPDATE Schema.Table1
SET Geom1 = ST_AsEWKT(ST_LineInterpolatePoint(ST_LineMerge(ST_Force2D(a.geom)), Schema.Table2.Milepost/(St_length(a.geom)/1600)))
FROM Schema.Table1 As a
where a.RoadName = Schema.Table2.RoadName
This Query did the trick to Geocode and update the values.Thank You Guys....