Introduction
ST_Equals
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
18. Get to know sf_household_types
Summary

Instruction

Great! Before we move on, we need to present one more new table from our database. This one is called sf_household_types.

Exercise

Select all information from the table sf_household_types.

This table stores census information about the number of specific households in a given census block.

A census block is always part of a planning district, and there are usually more than 20 census blocks in a single planning district. Here, you will find information about three types of households in each census block: both_parents_family_household, single_parent_family_household and nonfamily_household.

Stuck? Here's a hint!

The asterisk (*) operator selects all information.

Console

Code editor

Result

TableConsoleMap