The New York Trees census dataset - Exam

You work with the new york trees dataset which you should already have loaded in your postgresql server.

If not, the sql file to restore the database is available https://skatai.com/assets/db/new_york_trees.sql

In a psql session, you can restore the database with

\i <path to the sql file>/new_york_trees.sql

or the equivalent for windows.

This will create

• the new_york_trees database
• the trees table

which holds 65423 trees.