Since the launch of Census 2011 the AIRO mapping team have developed a series of interactive mapping tools to visualise the results on a national and local authority/regional authority level (see here). This has been a joint project with the Central Statistics Office (CSO) and to date has been very successful with a high number of users viewing and interacting with this publically funded dataset. The aim of this collaboration was to improve access to the results of Census 2011 and thereby make a contribution towards improving evidence informed planning in Ireland. Over the last couple of weeks the team have been working on the recently released Place of Work, School or College Census of Anonymised Records (POWSCAR) dataset.
This dataset contains 2.78 million records where the location of the place of work, school or college was coded for each person on the basis of the reply that was given to Question 34 on the census form: “What is the Full Name and Address of your place of work, school or college”.
Using this information the CSO matched the employer/school name and address against addresses on the An Post GeoDirectory. In the case of workers, where the coder could not find an exact match they coded to a near match if they could find a GeoDirectory address on the same street or in the same town as the address stated on the form. In the case of students, an exact match was only accepted for the school or college address. The coordinates retrieved from the GeoDirectory match were then linked back to the place of work, school or college Electoral District (ED) and Town and Small Area by superimposing digital boundaries. In some cases it was not possible to match the destination of the worker/student with GeoDirectory, this was a result of a very poor return of address information or the workers destination was classed as being ‘mobile’. The final dataset is effectively an origin-destination matrix that links the place of residence of the worker/student, either at Electoral Division (ED) or Small Area (SA) level, to the work/school/college destination of the worker/student at the ED, SA and 250m grid level. The dataset contain a wealth of information about each work trip such as age, gender, industry of employment, education level, mode of transport, household occupancy status, one-off housing indicator, socio-economic group etc. Similar data is available about those attending schools/college although not as detailed and much of the data is compressed for disclosure reasons – we will do a further piece on this in a couple of weeks.
In 2011, places of work, school or college with an address in Northern Ireland were also coded in the same way by utilising the NI Pointer address database. NI County, Ward, Towns (2001) and 2001 Census output areas were derived by superimposing digital boundaries. This is a big step forward in understanding the cross-border travel to work catchments that exist in Ireland and the CSO should be commended for realising the benefits of going this extra step in the development of this dataset. Where the person indicated a work, school or college address abroad these records were coded to a specific code to indicate that the person was working abroad i.e. outside Ireland or Northern Ireland.
Due to the level of detail available within the dataset it is not as ‘open’ as the rest of the Census 2011. As there are some minor risks to data disclosure, use of the dataset is restricted and is only available to bone fide researchers who are approved by CSO and signed up as Officers of Statistics for the duration of the research they propose to undertake. A key point on all of this is that All material published from POWSCAR must be approved in advance by CSO.
The following table gives a summary of the POWSCAR address coding process:
|Persons in private households or establishmentsenumerated and resident in Ireland||1,013,292||1,770,644||2,783,936||100.0|
|Place of work, school or college address (Q34)was matched to a GeoDirectory address point||929,154||1,362,742||2,291,896||82.3|
|Place of work, school or college address (Q34)blank or uncodeable||78,956||147,251||226,207||8.1|
|No fixed place of work indicated at Q34||‐||148,177||148,177||5.3|
|Works from home indicated in Q34||‐||106,055||106,055||3.8|
|Place of work, school or college address (Q34)was matched to a NI Pointer database addresspoint||3,117||6,419||9,536||0.3|
|Place of work, school or college address (Q34)overseas||1,447||‐||0.1|
|Home school indicated at Q34||618||‐||0.0|
AIRO POWCAR Mapping:
To get started on work with the POWSCAR dataset the AIRO team have developed travel to work catchments for all 22 Gateways and Hubs and made these accessible via an interactive mapping tool. Each map is based on the percentage of workers within each ED that work within the selected settlement boundary (boundaries based on CSO Settlements). Our analysis here is only based on the workfore where we have information on the destination of workers and therefore excludes those classed as Mobile workers (148,177 or 10% of workers) and workers with an uncodable or Blank destination (147,251 or 9.9%). Users can select a settlement to view the extent of the catchment and then click on an ED to get information on the number/percentage of workers employed within the selected settlement.
The map below details the extent of the travel to work catchment for the Dublin City settlement boundary, an area of about 317 sqkm and including all major employment locations in the local authorities of Dublin City, South County Dublin and DLR. The settlement boundary does not however include many of the large employment locations in south Fingal such as Dublin Airport, Swords, Malahide and Portmarnock. In total there are 457,046 people with a work destination in the Dublin Settlement boundary. Of these, 74% also reside within the Dublin City settlement and 26% reside outside the settlement boundary highlighting the high levels of inward commuting. Of the workers who reside within the Dublin City settlement boundary a total of 12.5% (48,801) commute out of the settlement to employmant destinations.
Red areas on the map highlight where >50% of the workers in an ED are employed within the settlement boundary. The orange band represents areas where over 30% of workers in an ED commute to the Dublin settlement boundary and extend to towns such as Drogheda, Ashbourne, Maynooth, Newbridge, Blessington and Wicklow town. The pale orange band is based on 10% to 30% of workers and extends much further towards the Mid East, Midlands and parts of the Border region with towns such as Kells, Navan, Mullingar, Portarlington, Portlaoise, Gorey and Dundalk.
To access the tool and view the different catchments for all Gateways and Hubs please click here. In the map viewer, click on an area to get specific information on that ED.
A link to the tool is also available on our census mapping home page on the AIRO site where you can also access other mapping tools developed over the last number of months. View Census Mapping home page
This is the first step at mapping the travel to work catchments for the main settlements in Ireland. We’re hoping to do some additional work on job’s desnity within settlements and also roll out catchments for other towns. Happy to take suggestions on what is useful for planners, policy makers and general public who would find this information of use.
Justin Gleeson & Eoghan McCarthy