2.2. How To
Prev 2. Assignment: Computing land use change with SQL (select query) Next

2.2. How To

  1. Use pgAdmin to query TestGIS database, which has table "ma_lu_hadley" with landuse data for the Town of Hadley.

  2. Use table ma_lu_hadley to query from.

  3. Check [metadata] page for information on table structure and attributes.

  4. For question #1 and #2 use COUNT() and SUM() aggregate functions.

Prev Up Next
2. Assignment: Computing land use change with SQL (select query) Home 2.3. Data sources