Lesley-Anne Kelly

✌️

Read the full analysis 4/4 pressandjournal.co.uk/fp/news/transp…

The article also takes a closer look at how many crashes happen in rural versus urban sections of the road. Once again QGIS was use to find all the crashes overlapping with or immediately adjacent to settlements defined by Scottish Government Spatial Data on Localities. 3/4

The heatmap is based on the density of crashes within a one-kilometre radius. Larger numbers or more closely clustered crashes within that radius appear with a darker shade, like this one found near Morgan McVeighs restaurant in Insch with three crashes. 2/4 #ddj #datajournalism

We have analysed when crashes happen on the A96, but today we want to provide a better answer for the question of where they happen. Using QGIS I created a heatmap along the road from Aberdeen to Inverness showing clustered accident blackspots. 1/4 #dataviz

Ema also looked at whether more crashes have happened in urban stretches of the road vs rural. pressandjournal.co.uk/fp/news/transp… #ddj #dataviz #datajournalism

It's easy to look at our maps from earlier in this series and think that the crashes are fairly evenly distributed - that's why we created a heatmap that highlights the density of crashes around a 1km radius. pressandjournal.co.uk/fp/news/transp… #ddj #dataviz #datajournalism

The latest article in our A96 series - @EmaSabljak used QGIS to analyse the spatial data and identify clusters. #ddj #dataviz #datajournalism

Latest part of our series is a tribute to those who lost their lives from @Undercover_Ross He trawled through clippings and reports to compile details on all of the lives lost in recent years.

Brilliant journalism by @elmorrice & @EmaSabljak at @pressjournal @DC_Thomson . This is the value of a printed/digital press. pressandjournal.co.uk/fp/news/transp… (1/2)

@glynmottershead Definitely made use of Stats19! A lot of it had to be joined manually (well in R and python) though for various reasons.

@L_A_Kelly Got to love Stats19

Our latest investigation is now live - a deep dive into the toll of crashes on the A96. #ddj #datajournalism #dataviz #A96

Our Live team will keep the data updated going forward so that we always have up to date data available.

Crash data suffers from quite a severe lag due to the level of detail involved so for the first time we've brought that data right up to date by combining it with data from our reporting and police reports. #ddj #datajournalism #dataviz #A96 pressandjournal.co.uk/fp/news/transp…

Essential Friday reading 🎾

Been absolutely dying to share this. Racket charts, tennis ball scatter plots, top trumps cards🎾😍 @JudyMurray I hope we did your son proud! #ddj #datajournalism #dataviz

These photos were taken just one day apart. I reported this fly tipping on the @fixmystreet app and @DundeeCouncil cleared it swiftly. Community reporting apps such as this are a great way for communities to see change in their local area and improve the environment!

Also someone drew me and handed it to me at the bar at intermission and I'm so touched it has to be shared.

Last night I stood on the stage of a sold out Rep for #PKN_DND When @GillianEasson asked me my response was "that sounds terrifying but I kinda like doing terrifying things" That held up - utterly terrifying but I had so much fun.