Get latitude and longitude of a geography column

Question

When doing the query in postgres to one that has a column whose data type is geography(MultiLineString, 4326) throws me the following result:

select geom from base.osm_roads_free_1 limit 100;
"0105000020E610000001000000010200000002000000ACFE08C380585EC04B598638D6FD44409A93179980585EC0A48D23D6E2FD4440"

I applied the ST_AsText (geom) function and it gives me the following result:

"MULTILINESTRING((-121.382859 41.9831,-121.382849 41.983485))"

My intention is to get into different columns longitude and latitude, example:

LON   LAT
-120.41651 40.192448
-120.416214 40.192471
-120.416055 40.192489
-120.415904 40.192524
-120.415767 40.192549
-120.415651 40.192559
-120.41553  40.192563
-120.415375 40.192546
-120.415246 40.192526
-120.415097 40.192528
-120.414956 40.192539

Answer 1

This is what ST_DumpPoints is for:

SELECT ST_X((dp).geom) AS lon, ST_Y((dp).geom) AS lat
FROM (
    SELECT ST_DumpPoints(
        ST_GeogFromText('MULTILINESTRING((-121.382859 41.9831,-121.382849 41.983485))')::geometry
    ) AS dp
) AS foo;

Output:

"lon";"lat"
-121.382859;41.9831
-121.382849;41.983485

Answer 2

Listing the coordinates in the "reverse order" (Y, X), helps me:

lat        lon
40.192448 -120.41651
40.192471 -120.416214
40.192489 -120.416055
40.192524 -120.415904
40.192549 -120.415767
40.192559 -120.415651
40.192563 -120.41553
40.192546 -120.415375
40.192526 -120.415246
40.192528 -120.415097
40.192539 -120.414956

ref.: http://maptools.com/tutorials/lat_lon/definitions

Latitude

Longitude

As mentioned above, you can also use the following:

SELECT (ST_AsLatLonText('POINT (-120.41651 40.192448)'));
    st_aslatlontext
----------------------------
40°11'32.8"N 120°24'559.4"W