Introduction

Purpose

This document is part of a project evaluating the importance of hill farming in Scottish communities. It compares census data at output area level (as downloaded), to aggregations at agricultural parish level. The aggregated parishes are then compared to civic parishes, which are broadly similar in name and boundary to the agricultural parishes.

## OGR data source with driver: GPKG 
## Source: "/home/mspencer/Cloud/Michael/SRUC/hill_farms/data/spatial/ag_parishes_2016.gpkg", layer: "simplified_parishes"
## with 932 features
## It has 4 fields
## OGR data source with driver: GPKG 
## Source: "/home/mspencer/Cloud/Michael/SRUC/hill_farms/data/spatial/ag_parishes_2016.gpkg", layer: "Scotland"
## with 71 features
## It has 1 fields
## Warning: Column `PARName` joining factor and character vector, coercing
## into character vector
## Warning in `[<-.factor`(`*tmp*`, list, value = 0): invalid factor level, NA
## generated

## Warning in `[<-.factor`(`*tmp*`, list, value = 0): invalid factor level, NA
## generated

Absolute values for agricultural parishes

Proportions for agricultural parishes

Checks

Aggregated to agricultural parishes

  • Total people in 2011 = 5293375
  • Total working population in 2011 = 2515940
  • Ag/for/fish working population in 2011 = 41875
  • Proportion in land/primary of total population in 2011 = 0.791%
  • Proportion in land/primary of working population in 2011 = 1.66%

  • Total people in 2001 = 5055821
  • Total working population in 2001 = 2258453
  • Ag/for/fish working population in 2001 = 54982
  • Proportion in land/primary of total population in 2001 = 1.09%
  • Proportion in land/primary of working population in 2001 = 2.43%

Using census output areas

These values are the benchmark, as they are unaltered from the downloaded versions.

## OGR data source with driver: ESRI Shapefile 
## Source: "/home/mspencer/Cloud/Michael/SRUC/hill_farms/data/spatial/OutputArea2011_MHW.shp", layer: "OutputArea2011_MHW"
## with 46351 features
## It has 13 fields
## Warning: Column `code`/`census_id` joining factor and character vector,
## coercing into character vector
  • Total people in 2011 = 5295403
  • Total working population in 2011 = 2516895
  • Ag/for/fish working population in 2011 = 41902
  • Proportion in land/primary of total population in 2011 = 0.791%
  • Proportion in land/primary of working population in 2011 = 1.66%

  • Total people in 2001 = 5062011
  • Total working population in 2001 = 2261281
  • Ag/for/fish working population in 2001 = 55145
  • Proportion in land/primary of total population in 2001 = 1.09%
  • Proportion in land/primary of working population in 2001 = 2.44%

Aggregation is causing inflation in certain areas. Likely due to rounding error, where proportions of a person are increased to the nearest whole number. These errors are very small across the whole of Scotland, but may have impact in isolated parishes.

Differences between ag parishes and census OA

Using the census data as a benchmark, census data have been subtracted from aggregated data. Hence negative values mean aggregated data are less than the census output area data.

  • Total people in 2011 = -2028
  • Total working population in 2011 = -955
  • Ag/for/fish working population in 2011 = -27

  • Total people in 2001 = -6190
  • Total working population in 2001 = -2828
  • Ag/for/fish working population in 2001 = -162

Maps of census output areas

Compared to historic parishes

Used here are employment figures.

## Warning: Missing column names filled in: 'X1' [1]
## Warning in rbind(names(probs), probs_f): number of columns of result is not
## a multiple of vector length (arg 1)
## Warning: 3 parsing failures.
## row # A tibble: 3 x 5 col     row col   expected   actual    file                                    expected   <int> <chr> <chr>      <chr>     <chr>                                   actual 1   863 <NA>  20 columns 1 columns '~/Cloud/Michael/SRUC/hill_farms/data/… file 2   864 <NA>  20 columns 1 columns '~/Cloud/Michael/SRUC/hill_farms/data/… row 3   865 <NA>  20 columns 1 columns '~/Cloud/Michael/SRUC/hill_farms/data/…
## Warning: Missing column names filled in: 'X1' [1]
## OGR data source with driver: ESRI Shapefile 
## Source: "/home/mspencer/Cloud/Michael/SRUC/hill_farms/data/spatial", layer: "CivilParish1930"
## with 871 features
## It has 8 fields

2001 and 2011 census sic match

Not all census sic codes match, this is how they have been joined:

  • A_agri=Percentage of people aged 16 to 74 working in: Agriculture, hunting and forestry + Percentage of people aged 16 to 74 working in: Fishing,
  • B_mining=Percentage of people aged 16 to 74 working in: Mining and quarrying,
  • C_manufacture=Percentage of people aged 16 to 74 working in: Manufacturing,
  • F_construction=Percentage of people aged 16 to 74 working in: Construction,
  • G_retail=Percentage of people aged 16 to 74 working in: Wholesale and retail trade, repairs,
  • I_accommo=Percentage of people aged 16 to 74 working in: Hotels and restaurants,
  • K_finance=Percentage of people aged 16 to 74 working as: Financial intermediaries,
  • L_estate=Percentage of people aged 16 to 74 working in: Real estate, renting and business activities,
  • O_public=Percentage of people aged 16 to 74 working in: Public administration and defence, social security,
  • P_edu=Percentage of people aged 16 to 74 working in: Education,
  • Q_health=Percentage of people aged 16 to 74 working in: Health and social work,
  • other=Percentage of people aged 16 to 74 working in: Other)

Civil parish change

How has employment changed in civil parishes between the 2001 and 2011 census?

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

## Warning: Column `name`/`parish` joining factor and character vector,
## coercing into character vector

Comparing agricultural and civic parishes

There are two agricultural parishes called Cathcart, when their populations are added together they sum to the population of the civic parish with the same name.

Total working population in 2011 for aggregated agricultural parishes is 2515940 people and for civic parishes 2516895 people. In 2001 the total working population for aggregated agricultural parishes is 2258453 people and for civic parishes 2261281 people.

SIC code A from 2011 was used as a base, but was different in 2001. I have aggregated two 2001 employment categories to create one broadly comparable to the SIC A of 2011. The working in agriculture/forestry/fishing population for aggregated parishes in 2011 is 41875 people and for civic parishes 41902 people. compare them to the census output area value, which is 41902 people. The same values for 2001 are: aggregated agricultural parishes, 54982; civic parishes 55136 people; output areas 55145 people. The largest differences are between the civic parishes and the output areas/aggregated parishes for 2001. This difference is attributed to the civic parishes which do not have names which match the agricutural parishes.