A MultiLineString is formed by a sequence of points and each point has latitude and longitude. Use the sql below to get the latitudes and longitudes of each point so that my MultiLineString:
SELECT St_AsText (ST_Transform("public"."Shapes".geom,4326)), "public"."Shapes"."id" FROM "public"."Shapes"
I want to get the sequence of points of each line in separate rows and lat / long in separate columns example:
ID pt_lat pt_lon 1001 lat1 lon1 1001 lat2 lon2 1001 lat3 lon3 1001 lat4 lon4 1001 lat5 lon5 1001 lat6 lon6 1002 lat1 lon1 1002 lat2 lon2 1002 lat3 lon3 1002 lat4 lon4 1002 lat5 lon5 1002 lat6 lon6
I know I can do that consuming one GeoJSON for example, but want to know if there is a native function of PostGIS for this.