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!
Introduction
Geometry vs. Geography
Summary

Instruction

Perfect! As expected, the query in the previous exercise failed. What can we do in this situation? The answer is: casting to geometry, just like we did before:

SELECT 
  ST_Area(ST_Transform(
    boundaries::geometry,
    26910))/1000000 
FROM usa_states 
WHERE name = 'Alaska';

As usual, remember about to use the right SRID!

Exercise

Write a query that will make a single polygon around all US states. Use casting to geometry to obtain the correct result.

Stuck? Here's a hint!

Use ::geometry inside ST_Union.