In a table of linestring three segments are connected.
could Postgis generate the centroid of second segment and merge first and third at center? Is it possible?
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
The centroid of a line is not always on the line. What you want is the center along the line, you should look at the ST_LineInterpolatePoint, with a 0.5 parameter you can get the center of the second, if it's what you want.