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 community
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....