I have shapefile which doesn’t have continuous network. I want to connect it to the nearest line and create continuous line from it. the postgis table has three columns- gid,objectid and geom.The geom is in multi line.now i want to connect this line to the nearest line and make it one line . i try this query but its not connecting to the nearest line.

select st_makeline(st_linemerge(geom::geometry)) from footpath

enter image description here.

closed as too broad by ahmadhanb, Vince, LaughU, Andre Silva, Erik Mar 25 at 12:13

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.