Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostGIS

Introduction
Geometry vs. Geography
Summary

Instruction

Before we start, you'll need to familiarize yourself with the very last table of our database: usa_states.

Exercise

Select all information from table usa_states.

This table stores basic information about US states. Each state has a unique id, name, boundaries (a geography column), capital and capital_coordinates (another geography column). That's all we need for this part. You may want to take a look at the map tab to view the US states with their capitals marked.

Stuck? Here's a hint!

Use * to retrieve all rows and columns.