PRACTICAL - APPORTIONMENT

Introduction -

The purpose of the exercise is to take you through the conversion of data between geographical units. More often than not the areas you have data for will not match the exact boundaries of the area you are interested in - for this reason you will need to approximate the data to fit your area of interest.

You will convert data on welfare claimants aggregated to 2001 CAS Wards to the boundary of the Lower Lea Valley and Olympic Site. The conversion will apportion the data using weights. You will carry out two apportionment techniques; the first using the area of the ward and the second using postcode data. The Olympic Site is located in the Lower Lea Valley which forms the boundary between the London boroughs of Newham, Hackney, Tower Hamlets and Waltham Forest and does not sit neatly within existing administrative boundaries. In this scenario the planners? aim is to get some idea of the level of unemployment in the area of the site. This will be used to determine how many people will be helped by the short and long term job creation driven by the Olympics.

The exercise will introduce you to several of the concepts discussed in the lectures including conversion between geographies, data quality and accuracy, combining socio economic data with geographic data and to some of the data sets mentioned.

Data -

Data files provided are:

• The Olympic Site boundary was digitised from planning documents for the lower Lea Valley.
• The 2001 CAS Ward boundaries are from Casweb website.
• The postcodes are from EDINA and are derived from Codepoint data.
• Data on welfare claimants (data set is "WelfareClaimants.txt") from the NOMIS website.

Task -

You will generate two new datasets. The first will apportion the existing data based on the area of the wards. The second will apportion the data based on postcodes of residential delivery points.

Download the data from Moodle to your N drive. The data will need unzipping.

Load the ward and Olympic site files into ArcMap. Select the CAS Wards which are covered by the Olympic Site by going to: Selection > select by location > select features from CAS Wards that intersect the features in Olympic Boundary.

Practical: Site Suitableity Analysis

In this practical we are going to use the spatial analysis capabilities of ArcMap in a traditional planning exercise. We need to identify the location(s) of and then determine the suitability of different sites for a development project. The project is to build a leisure and sports centre in the (old) county of Avon for use by schools and the local population. There are several criteria that must be satisfied in determining a suitable location for this development:

At the end of this practical you will have learnt:

• How to undertake basic spatial analysis in a raster GIS
• How to create a density surface from point data
• How to derive slope data from a DEM in a raster GIS
• How to generate a distance surface in a raster GIS
• How to use Boolean logic in raster GIS analysis

Practical: Working with Vector Attribute Data

In this practical you will be learning how to query data in a vector GIS. You will be making non- spatial queries on a vector layer's attribute table and calculating descriptive statistics of the data. You will be undertaking simple summaries of the attribute data and creating new summary tables.

At the end of this practical you will have learnt:

• How to undertake simple queries on a vector attribute data.
• How to calculate basic descriptive and summary statistics on vector attribute data.

The data for this practical can be found on Moodle. Download and unzip "prac1.zip", and save it to your N:\ drive (i.e. your personal drive).

Firstly we are going to add some data that we can map. The data is held in a GIS layer called wards.shp and represents the electoral wards in Wales. These are used as administrative areas for which census data are available.

Practical: Spatial Queries and GIS

In this practical you will be learning how to make spatial queries in a vector GIS. You will be making simple and more advanced spatial queries on a vector layer's attribute table and calculating descriptive statistics of the data. You will also undertake a simple spatial join between two attribute tables.

At the end of this practical you will have learnt:

• How to undertake simple and advanced spatial queries on a vector layer.
• How to produce summary statistics on selected features in a layer.
• How to join the data held in two attribute tables together.

The data for this practical can be found on Moodle. Download and unzip "prac2.zip", and save it to your N:\ drive (i.e. your personal drive).

Attachment:- Assignment Files.rar