Open Data

 

Articles and How to guides

Automatic Identification System (AIS) data – let’s track vessels!

Ahoy there! Did you know that you can track the location of vessels? All you need is the AIS data transmitted by the vessel. AIS data provides a wealth of information including current location, course, and speed all of which can all be used to make waves in the field of data analytics.

Open Data – Encouraging case studies in Scotland

How are Scottish companies and organisations using open data? What data originating in Scotland has been made open to the world. Those were the questions posed at 2020 Scottish Open Data Unconference

R Project – create line chart

Follow along practical example – In an R script upload a spreadsheet, manipulate the data by pivoting columns, and then producing a line chart with data points.

Hackathon – Plotting Shipwrecks Off The Coast of Scotland

Over 23,000 ships have been wrecked off the coast of Scotland. I was astounded when I discovered that figure as it’s far higher than I would have guessed. I quickly went from being astonished to being quite sombre thinking about how many lives would have been lost at sea. Why am I telling you this? Well …..

Using Wikimedia Commons Artwork in a Power BI report

#worldbookday2022 Discovered last month that some illustrations for The Frog Prince, a fairy tale by the Brothers Grimm, are held by Aberdeen Archives, Museums and Galleries (AAGM). I came across the artwork whilst taking part in a wiki editathon. Couldn’t resist giving The Frog Prince it’s own page (page 3) in this very draft report - https://lnkd.in/eRa97d4S

Easy – Plotting items on a map using Power BI

It’s easy to plot items onto a map using Power BI. With a few clicks data can be gathered, a map created, and markers plotted onto the map. Simple!

RShiny – add catchment areas to a map using geoJSON

This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API.

R Project – create bar chart – uses gglot2 package

Follow along practical example – In an R script upload a spreadsheet, manipulate the data by removing column/variable, change variable name, and pivot columns, and then producing a bar chart.

Easy – Insert Wikipedia extracts into Power BI using an API

This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API.

Easy – to insert a Google Map into a web page just copy and paste

It’s easy to insert a Google map into a website. These short instructions show you how to copy and paste one line of html code to create your Google map.

YouTube

Wikipedia extracts for ships arriving in Aberdeen Harbour

Mapping Wikidata Shipwreck data in Power BI

Combine Dundee places with monuments dataset using Append

Treemap Power BI project using Scottish Tourism Open Data

map of school catchment areas

RShiny project - Plot polygons from GeoJSON file to leaflet map and plot circles from excel file

R project create line chart with dots and hover over

R Project - create line chart with points (ggplot2 & plotly) from spreadsheet-includes data pivot

Track direction of ship movement in R Shiny app using AIS open data

Mapping Wikidata Shipwreck data in an R Shiny App

Using OpenStreetMap osmosis extract street names from polygon on map for display in RShiny table

Using OpenStreetMap osmosis extract street names from polygon on map for display in RShiny table

RProject spreadsheet to barchart

R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column

Pin It on Pinterest

Share This