Rural Evidence Hub Tutorial

1
(No Transcript)
2
Rural Evidence Hub Tutorial

• This tutorial is intended to assist new users of
  the Rural Evidence Hub (REH).
• By working through the tutorial users should
  become familiar with most of the functionality of
  the REH system and will be able to run simple and
  complex queries, produce and manipulate maps and
  download datasets.
• The tutorial consists of 68 slides. It is
  therefore recommended that single printed copies
  of the tutorial should be shared with fellow
  users, rather than everyone printing their own
  copy.
• The Rural Statistics Unit will provide support to
  new users and they can be contacted on 01904
  455592 (GTN 5137 5592). The email address is
  rural.statistics_at_defra.gsi.gov.uk

3
(No Transcript)
4
REH Home Page

• All REH queries are initiated from this page.
• In order to return to the home page, from
  anywhere and at any time, click on Rural
  Evidence Hub (see the red arrow on the next
  slide)
• Users have two ways in to start to select their
  data.
• They can select the geography first and then the
  subject useful if the geography is known, ie a
  particular local authority, and the user then
  wants to see what data is available for it.
• Or they can select the subject first and then the
  geography useful if the data is known, ie
  number of households without a car, and the user
  then wants to see which geographies are available
  for it.
• This purely a matter of choice, it makes no
  difference to the query that is generated.

5
(No Transcript)
6
Example Query

• In order to demonstrate some of the functionality
  of the Rural Evidence Hub we will construct the
  following query
• We will select 24 Local and Unitary Authorities,
  all of those in the North-East of England plus
  Crewe and Nantwich for the North-West.
• We will select four columns of data - the total
  number of rural households, plus the number of
  rural households within 02km, 2-4km and 4-6km of
  a Primary School.
• We will apply the full rural definition to this
  data so that we can see individual totals broken
  down into urban and rural subtotals.
• We will map the data, showing the distribution of
  the total number of rural households within each
  of the 24 selected Local and Unitary Authorities.
• We will start by clicking once on I need
  statistics, a statistical map or research
  documents for a geographic area (see red arrow
  on next slide).

7
(No Transcript)
8
Select Geography

• The list of available geographies is now
  presented. At the moment there are seven
  different geographies for which REH data is
  available or planned (the Pathfinder County
  Councils will shortly be added to this list)
• The national total for England.
• Government Office Regions - of which there are 9.
• Local and Unitary Authorities there are 354 in
  England. 49 of these are entirely urban , the
  remaining 305 are partly or wholly rural.
• Lower Super Output Areas this geography will
  become increasingly important as time goes on.
  For the moment there is no data available for
  this geography so it should be ignored. When
  data becomes available this geography will be
  described in detail.
• Parliamentary Constituencies there are 529 of
  these in England. 158 of them are entirely
  urban, the remaining 371 are partly rural. All
  of them contain some urban population.
• Ward (1998) Ward boundaries change each year.
  Data is commonly available based on 1998
  boundaries, even though the data may have been
  collected after this time.
• Ward (2003) The other common ward boundaries
  for which data is available. These boundaries are
  used for the 2001 Population Census data and for
  a broad range of other datasets currently being
  made available across Government.

9
(No Transcript)
10
Select Geography contd

• In our example we want to extract data for all of
  the Local Authorities in the North-East of
  England, plus Crewe and Nantwich from the
  North-West region.
• We will choose Local and Unitary Authorities
  from the list of available geographies, and then
  we will click next.
• It is possible to drill down to select only
  certain wards within a Local Authority and this
  will be described later in the tutorial.
• Navigation around the REH screens is done by
  using next and previous and NOT by using the
  Back and Forward arrows on the Internet Explorer
  toolbar.
• In order to undo the last next or previous
  entered, click on cancel.
• If accidental use is made of the Internet
  Explorer Back Arrow then a refresh using the F5
  key should return you the the Rural Evidence Hub

11
(No Transcript)
12
Select Geography contd

• In response to this selection we are presented
  with a complete list of all Local and Unitary
  Authorities. These are ordered by Region. It
  is possible to select all of the Authorities from
  a given region by double clicking the All
  option which appears to the right of the region
  name.
• It is also possible to select any single
  Authority by clicking twice on its name.
• The percentage of the population living in the
  rural part of an Authority is available to the
  right of the name (you may have to expand the
  width of this part of the screen in order to see
  this data).
• In the example assume we have already selected
  North East All and we now go on to select Crewe
  and Nantwich from the list of Authorities in the
  North-West Region.

13
(No Transcript)
14
(No Transcript)
15
Select Geography contd

• As Authorities are selected they move from the
  left of the screen to the right of the screen.
• It can be seen that the number of areas selected
  has increased by one from 23 to 24. This will
  continue to increment as additional Local
  Authorities are added to the list of selected
  Authorities.
• To deselect an authority from the list simply
  double click on its name and it will return to
  the choose area list on the left of the screen.
• The name (or part of the name) of an Authority
  can be entered into the Filter on box and all
  matches will appear in the choose area list.
• Authorities with no Rural population can be
  removed from the choose area list by ticking
  the Exclude wholly urban areas box.
• Once all of the Authorities have been selected
  click next.

16
Select Geography contd

• There are three further choices available now
  that all of the geographies have been selected.
• If totals for each of the selected geographies
  are required then select Query data in order to
  continue to define the query.
• If some of the selected geographies need to be
  drilled into, for instance if only some of the
  wards are required for a particular Authority,
  then select from the list of lower level
  geographies that can be drilled into.
• If high level Rural Focus Reports are required
  for the selected geographies then select View
  reports
• The second and third of these options will be
  described later in the tutorial. For now, we
  will select the Query data option.

17
(No Transcript)
18
Search Data

• We are now presented with a Search Data tutorial
  screen. This will always appear upon entry to
  the search data function. This screen is
  designed to provide assistance and advice on how
  to find data easily.
• Click next if the tutorial is not required, or
  once it has been read.

19
(No Transcript)
20
Search Data

• There are two ways of finding data.
• All data is categorised into a series of popular
  searches. These include subjects such as Access
  to Services, Health, Education etc. Selecting
  any one of these popular search words will guide
  you to specific data.
• Alternatively enter a keyword directly into the
  Freetext search option.
• For instance, in order to obtain data on the
  numbers of Hindus living in Rural England one
  could select Demographics from the popular search
  list. Religion will then appear in the list of
  subjects available under Demographics and from
  here datasets containing information on religion
  can be accessed.
• Entering the word Hindu as a Freetext search
  option will generate a list of all datasets
  containing information on Hindus.

21
Search Data contd

• In our example we want to find out about the
  number of rural households within 6km of a
  primary school for the 24 Local Authorities that
  we have selected.
• We will find this data by popular search, and
  will select Access to services from the list.

22
(No Transcript)
23
Search Data contd

• There are ten different subjects for which Access
  to Service data is available.
• From the list we will select Access to a Primary
  School and then click enter.
• You will note that the available time periods
  box shows that data is available for 2004. The
  latest period for which data is available for a
  subject will always show in this box. If data
  for an earlier period is required then look to
  see which other years are available and select
  accordingly.

24
(No Transcript)
25
Search Data contd

• The list of available datasets containing
  information on access to primary schools is now
  presented.
• At the moment there is only one such dataset.
• A brief description of this dataset, and the
  geographies for which data is available is shown.
• We will select this dataset and click next.

26
(No Transcript)
27
Search Data contd

• Now that the dataset has been selected, details
  about the range of data contained within it are
  shown.
• The initial screen identifies that the dataset
  contains 12 columns of data.
• We can either select all of these columns, or we
  can choose only some of them.
• In our example we will choose only four of the
  columns
• (view next three slides).

28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Search Data contd

• Now that we have selected the required data it
  may be possible to apply the rural definition to
  it. (this will not always be the case, although
  once the ward and LA/UA classifications become
  available they will be applied urgently to all
  existing REH data)
• If the data supports the rural definition then we
  will be presented with a screen that will allow
  the data to be viewed as either single totals for
  each selected geography, or with separate totals
  for the urban and rural parts of each geography.
• Totals are available for
• Single Total (choose whole of the geographic
  areas).
• Urban and Rural (choose Urban/Rural).
• Sparse Rural, Less Sparse Rural (choose
  Sparse/Less Sparse).
• Rural Towns, Rural Villages and Rural Dispersed
  (choose Villages/Towns/Dispersed).
• Urban, Sparse Rural Towns, Sparse Rural Villages,
  Sparse Rural Dispersed, Less Sparse Rural Towns,
  Less Sparse Rural Villages, Less Sparse Rural
  Dispersed (Choose Full Standard Rural
  Definition).
• In our example we will select the Full Standard
  Rural Definition

32
(No Transcript)
33
Select Query Options

• Now we have selected our geography, we have
  selected the data and we have also selected the
  way in which we want to apply the rural
  definition to our output.
• We are now presented with a screen which shows
  the components of the query which we have built.
• It can be seen that we are asking for both a data
  table and a map to be produced.
• (View next two screens)

34
(No Transcript)
35
(No Transcript)
36
Select Query Options contd

• The data table will contain a large number of
  cells containing data that will be generated from
  the query.
• There will be data for 24 Local Authorities.
• For each of these there are 4 columns of data.
• For each of these columns there will be 11
  separate totals (the result of applying the full
  rural definition for the data)
• There will therefore be 24 x 4 x 11 separate
  pieces of data, a total of 1056 cells in our data
  table
• The map will show all 24 authorities but only one
  data column can be mapped at a time
• At the moment the column that is to be mapped is
  the total for rural households. We will leave
  this as it is.
• Similarly only one of the 11 rural definition
  types can be mapped. At the moment it is
  defaulting to the Rural and Urban total.
• We will change this to select the Rural total.

37
Select Query Options contd

• On the next slide you will see that the Urban
  and Rural option is highlighted. Navigate down
  over the Rural option, highlight it and then
  click finished
• We have now changed the map display option to map
  only totals for Rural households.
• It would have been possible to select Rural Towns
  and then data for the total number of households
  within rural towns would have been mapped for
  each Local/Unitary Authority.
• We can produce many different maps from one data
  table.

38
(No Transcript)
39
REH Query Results

• Now that we have decided what data we want to
  appear on our map we click on Run Query.
• The query will now be run on the Rural Evidence
  Hub and after a short while the output should
  appear on your computer screen.
• The next two slides show the results of our
  query, the map and the data table.
• The map shows the distribution across North East
  England, by Local Authority, and it also includes
  Crewe and Nantwich.
• The data table shows some of the 1056 cells of
  data that our query has generated.

40
(No Transcript)
41
(No Transcript)
42
REH Query Results contd

• The REH Query Results has four clickable options
  above the map.
• These are
• ltlt Back to Search Data tool
• show query definition
• show query output options
• show available downloads
• show available downloads will display the
  options that are available for downloading the
  query results.
• These include downloading the data table to a
  .csv file (a comma separated values file), or if
  it a very large data table it can be zipped and
  then downloaded. Other options allow the map to
  be downloaded as an image file and the map legend
  to be downloaded as an image file.
• Once downloaded the map and its legend can be
  copied and pasted into MS-Word, Excel, Powerpoint
  etc.

43
(No Transcript)
44
REH Query Results contd

• show query definition gives details of what
  options were selected for the query and which has
  resulted in the individual cells contained within
  the data table.

45
(No Transcript)
46
REH Query Results contd

• show query output options gives details of what
  options were selected for the output of data.
• It is possible to change the options from this
  screen and then to rerun the query (by clicking
  on Refresh Query)
• This is a very useful screen should many maps be
  required from the one data table.

47
(No Transcript)
48
Mapping functions

• The information button (see the red arrow on the
  next slide) can be clicked upon to obtain data
  the active layer on the map (for more information
  on active layers see slide 53). It works like
  this
• Click on the button. You are now in
  information mode on the map.
• Now position the cursor over one of the Local
  Authority polygons on the map, and then click
  once.
• After a few seconds an Information at Point box
  will appear to the right of the map with the
  following information for the point that has been
  selected the name of the Local Authority and
  the data that is active for the map. In the
  example the data relates to the number of rural
  households.
• This process can be repeated as many times as is
  desired.
• (view next two slides)

49
(No Transcript)
50
(No Transcript)
51
Mapping functions

• The Zoom in (see the red arrow on the next slide)
  can be clicked upon to zoom in on part of the
  map. It works like this
• Click on the button. You are now in zoom in
  mode on the map.
• Now position the cursor over any part of the map,
  and then click once.
• A refreshed map will be displayed zooming in on
  the point that you clicked at.
• This process can be continually repeated to
  zoom right in.
• Zoom out the next button to the right, works in
  exactly the same way.

52
(No Transcript)
53
Mapping functions

• The next slide shows the effect of continuing to
  zoom in, but it also introduces another useful
  feature. This is show map detail options.
• When this is clicked upon a box called Map
  Layers will appear.
• With this box it is possible to turn on extra
  layers to those which are available by default.
• For instance if one selects Cities and Towns, by
  clicking within the square box to the right, then
  the names of cities and towns will appear on the
  map once the refresh button is used.
• If one selected Villages then the names of the
  villages would only appear when it is sensible
  for them to do so. With the map as it is on the
  next slide, displaying all villages would result
  in a mass of text (because there are so many
  villages in the area of the map) and the map
  would be obscured. The REH will display village
  names when the map is zoomed in to the right
  level, provided that villages have been selected
  as a map layer.
• Only one layer can be active at any time. To
  change the active map layer click on the circular
  box on this screen (just to the right of the
  square box). When one uses the information
  button, the information that is passed back
  relates only to the active layer.
• (view next two slides)

54
(No Transcript)
55
(No Transcript)
56
Mapping functions

• There are a further two buttons that appear at
  the top of the map (see red arrow on next slide).
  These are the resize map buttons. It is
  possible to increase and decrease the size of the
  map as it appears on the screen.
• One can keep resizing until the desired size is
  reached.
• It is also possible to move in a North, South,
  East and West direction away from the area
  displayed on the map (and also to move in a
  diagonal direction) by clicking on the eight
  options that appear just outside the border of
  the map itself.
• This is difficult to explain in words, have a go
  and see what happens.
• The next slide shows the effect of resizing once
  upwards.

57
(No Transcript)
58
Select Geography contd

• We will now show how to drill down to lower
  geographies and also show how to view the Rural
  Focus Reports.
• We click on Rural Evidence Hub at the top of
  the screen to return to the Home Page.

59
(No Transcript)
60
Select Geography contd

• We have selected I need statistics, a
  statistical map or research documents for a
  geographic area and then selected Local
  Authority as our geography.
• We then select Chester-le-Street, Derwentside and
  Durham from the list of Authorities in the
  North-East.
• We have therefore moved them to the right of the
  Select Information on a Geographic Area screen
  and we have then clicked next.
• We now see the screen What do you want to do
  with your selected Geography. The last time we
  saw this screen we chose Query data. We will
  now choose Drill down to Ward 2003.

61
(No Transcript)
62
Select Geography contd

• We want to select all wards in Chester-le-Street
  and Derwentside, but only three of the wards in
  Durham. Once we have done this we will have
  identified the geography for our data table and
  for our map.
• By selecting this screen we will be invited to
  select which wards we want to include for the
  three Local Authorities.
• We select Chester-le-Street All, Derwentside All,
  and then the three wards we need for Durham.
  As we select them they move to the right of the
  screen.
• Once selected we press next, select Query
  data and carry on as before.
• (view next three slides)

63
(No Transcript)
64
(No Transcript)
65
(No Transcript)
66
Select Geography contd

• We will now view the Rural Focus Reports.
• We have selected I need statistics, a
  statistical map or research documents for a
  geographic area and then selected Local
  Authority as our geography.
• We then select Chester-le-Street from the list of
  Authorities in the North-East.
• We have therefore moved it to the right of the
  Select Information on a Geographic Area screen
  and we have then clicked next.
• We now see the screen What do you want to do
  with your selected Geography. This time we
  select View Reports
• We can now view the Rural Focus Report for
  Chester-le-Street. This is a 25 page highlight
  report on rural issues, in PDF format, and it can
  be downloaded to your PC.
• Rural Focus Reports are also available for the
  371 Parliamentary Constituencies in England that
  have some rural population.
• (view next two slides)

67
(No Transcript)
68
(No Transcript)