Analysing the Development Trust Association Scotland footprint

Provisional analysis compiled by Dr Jeremy Kidwell for DTAS. Based on live, open, and reproducible code!

• Representation in areas of deprivation
• Mapping community anchors
• Bonus: social media and DTAS

• Begun in 2014 at Ediburgh Uni, now Birmingham
• Driving question: How do we improve visibility and efficacy of community-level work?
  • Generating (open access) data sets
  • Consultancy as participatory research
  • Connecting researchers, policymakers, third sector

• Ongoing research partnerships
  • Scottish Community Alliance
  • DTAS (239 sites)
  • Eco-Congregation Scotland (~400) and Eco-Church England & Wales (~2500)
  • Christians Against Poverty (600)
  • Ecolise (European network of networks)
• Additional data sets produced for
  • GWSF, City Farms & Gardens, Community Land Scotland, Church(es) of Scotland, England & Wales…
• Digital “geospatial intelligence” Carto platform up and running )

It may be useful to know the number of groups present (as above), but we can illuminate this information by testing out how frequently different types of groups appear in these areas.

We can compare this frequency against some other features. The ordnance survey tells us that total pubs in Scotland are:

[1] 3360

The total numnber of Pubs located within these deprived areas noted above is:

[1] 0.1505952

To take another example, there are (according to the Ordnance Survey), the following number of places of worship in Scotland:

[1] 4468

Of all these, our deprived areas have:

[1] 0.123769

Another example we can look at is retail grocery stores. A geospatial company called GeoLytix publishes a complete set of British retailers on a regular basis. As of last November, they indicated that there were the following number of grocery stores in Scotland:

[1] 1408

Within our deprived areas, this represents

[1] 0.1477273

We can break this down by brand to get a more interesting indication. There are the following number of Morrison's brand stores in Scotland:

[1] 60

Of these, the following percentage are located in deprived areas:

[1] 0.25

We find the predictable contrast by turning to Sainsburys. There are the following number of Sainsburys stores in Scotland:

[1] 101

Represented in our deprived areas are just:

[1] 0.06930693

Sadly, the best bellweather of a deprived area in Scotland isn't any of the above, but rather pawnbrokers and check cashing stores. There are the following number of pawnbrokers:

[1] 134

…and check cashing stores:

[1] 17

Representation in our areas of of deprivation is, for check cashing establishments:

[1] 0.2352941

and pawnbrokers:

[1] 0.3283582

I've put together two different resources for DTAS to access this data:

• On our Carto platform: a “slippy map”,
  try it yourself at http://bit.ly/dtas-map-may18
• A table of groups (forthcoming report!)

• What details can we add to this data set to make it most useful?
• What other kinds of data and analysis can you see being of value to you for strategic decision making?
• Possible demos:
  • Common Ground Map
  • Carto Platform
  • QGIS

• Research question: how do community groups use social media?

• Total Groups = 240; average founding data: 2004 (.8)
• How many have website? = 215
• How many have a facebook page? = 179; average founding date 2004 (.5)
• How many have a twitter feed? = 54; avg founded 2005 (.6)
• No social media at all? = 13; avg founded 2007 (.9)