I have calculate distance from one point to a linestring. I have used the following query
WITH data AS ( SELECT geom::geometry AS road_network from linestring) SELECT ST_Distance(ST_Line_Interpolate_Point(road_network, ST_Line_Locate_Point(road_network,ST_GeomFromText('POINT(90.402 23.753)'))), ST_GeomFromText('POINT(90.402 23.753)')) as Dist FROM data ORDER BY Dist Limit 1
Its returning the following result
I want to get the result in Meter. How can I convert it? I am using WGS84 projection system. I know the
ST_Transform function but I need a perfect query where I use this function.