2. Assignment: Computing land use change with SQL (select query)

2.1. Assignment

Let’s assume that you work as a consultant for the planning department for the Town of Hadley, MA. Your colleagues asked you to prepare some numbers for the coming public meeting. One of major concerns of the public is a rapid residential development in the area. To provide additional insight into the residential development dynamics please compute the following:

  1. Number of areas/parcels classified as “FOREST” in 1971 and in 1999

  2. Total acreage (area) of parcels classified as “pasture” in 1999

  3. Estimate number of parcels (and their acreage) which were converted from forest, pasture and cropland into residential landuse in the period 1971-1999.