Class 3.3 – Views

create view housing_cases as
select * from cases where casetype in ('Housing', 'RUCO')

Q: Find all housing_cases on your street.

Use ST_DWithin(geography, geography, meters) to find housing cases in a nearby circle.

Q: Find all closereasons and how many of each.

Create a new view serious_cases with just the demo'd ones.