Introduction
Points
Linestrings
Polygons
Summary

Instruction

Great! Let's take a look at the other table with linestrings that we have in our database.

Exercise

Select all the information from the table sf_bicycle_routes.

This table is quite similar to the one with railways. Each bicycle route has a unique identifier (id), a geometrical representation (course) and a rating of its condition (condition_rating) on a scale from 1 to 3.

Stuck? Here's a hint!

Use the SELECT * FROM ... expression.

Console

Code editor

Result

TableConsoleMap