I want to find out the nearest point on my road network which is a multiline string from a point with lat lon value. I have tried the following codes but it giving a error message that my road network is not a line.
SELECT ST_AsText(ST_Line_Interpolate_Point(foo.the_line, ST_Line_Locate_Point(foo.the_line, ST_GeomFromText('POINT(90.402 23.752)')))) FROM (SELECT ST_GeomFromText(geom) As the_line from roads) As foo;
geom is my geometry column with multiLineString
roads is the table name
90.402 and Lat
Projected Coordinate system UTM_Zone_46N