Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
8. WKT for points


Great! These are our tables with points. As we already know we can change the format in which they are stored in the database to Well-Known Text using the following query:

FROM sf_tram_stops;

The query above will show the coordinates of each tram stop in a form that we can easily read and interpret.


Display the coordinates column of the ATM whose id is equal to 1 from the sf_atms table in a human-readable format (Well-Known Text).

The answer you get starts with the word POINT (which tells us that the geometry is a point). It is followed by parentheses, within which you will find the X and Y coordinates of the point.

Stuck? Here's a hint!

Use ST_AsText(coordinates) in your solution to convert the column to WKT.