Published August 5, 2019 © GPL3+

Smart Basketball Scoreboard Prototype

What if the Avnet SmartEdge Agile was used to prototype a solution to track my basketball training workouts? Let's go for it!

IntermediateFull instructions provided24 hours1,058

Things used in this project

Hardware components

Avnet SmartEdge Agile Brainium

Software apps and online services

Avnet Brainium Portal

Avnet Brainium Gateway

Story

I use to do basketball training workouts regularly and I always track the sections statistics (number of shots, scores, misses, training time, etc). Track these numbers is kind of boring and hard to accomplish.

The smart balls can be used to this but they have some drawbacks:

If you want to train with multiple balls you'll need to buy several (expensive) smart balls.
The accuracy isn't so good.
The durability of the ball.

The idea of this project is to use the Avnet SmartEdge device to prototype a solution to track all training facts.

Step 1: Avnet SmartEdge setup

First of all it's necessary to setup the Avnet SmartEdge device. I followed the instructions described in the Hands-On with the SmartEdge Agile document:

Open the box.
Charge the device.
Sign up to the Brainium portal.
Install the Brainium gateway.
Add the SmartEdge device to the Brainium portal.

All these steps are easy and they are fully described in the hands-on document.

Step 2: Brainium project creation

In the Brainium portal I created the project "Scoreboard" clicking in List of Projects item at the left menu and then in the Add Project button at the bottom right edge of the page.

The Brainium project creation

Step 3: Brainium project configuration

In the Brainium portal I selected the "Scoreboard" project clicking in List of Projects item at the left menu and then clicking in the Scoreboard project. After that I clicked in the Create Widget button at the bottom right edge of the page and added the following widgets to the project:

Visible lightness.
Temperature.
Atmospheric pressure.
Air humidity.
Acceleration (absolute value).
Proximity distance.

The Brainium project configuration

Step 4: Basketball board setup

This is my original basketball board that I regularly use to do basketball training workouts.

The original basketball board

First I removed the plastic cover under the hoop and then I removed temporarily the hoop and the net.

The basketball hoop

Then I prepared a support to the SmartEdge device using some parts I have available and fixed it in the hoop.

1 / 3 • The SmartEdge device support

Finally I fixed again the hoop and the net in the basketball board.

The basketball board with the SmartEdge device

Step 5: Basketball workout recording

In the Brainium portal I selected the "Scoreboard" project clicking in List of Projects item at the left menu and then clicking in the Scoreboard projec. After that I clicked in the StartTracking button at the top left edge of the page and then in the Record Session button at the top left edge too. At this moment Brainium portal is tracking the SmartEdge device and recording all required sensors values.

Now... it's show time!

The basketball workout recording

When the training session finished I just clicked in the End Session button to finish the recording. The sessions can be repeated as many times as you like and all the results can be accessed clicking in the RECORDED SESSIONS tab.

Step 6: Basketball workout data processing

First of all I had to get the workout data from the Brainium portal and to make things more interesting I decided to use the REST api to download the record sessions.

I developed some Bash scripts to help with this task.

The first script is the show-recordings.sh (attached at the end of the project) which uses the recordings/api/find endpoint to search for all available recordings on the Scoreboard project in the Brainium portal and show their date/time/id information.

The show-recordings.sh script execution

The second script is the get-recording.sh (attached at the end of the project) which uses the recordings/${recordingId} endpoint to get the recording URL of a specific recording Id and the wget command to download the recording file.

The get-recording.sh script execution

Finally I was able to process the workout session data stored at the recording file. All the information from the sensors of the SmartEdge device are in the recording_session.csv file in the CSV format, like the following example.

devicePublicId,dataSource,timestamp,scalar,vector  
TO136-020210000100112A,HUMIDITY,1560712053812,51,  
TO136-020210000100112A,ACCELERATION_NORM,1560712053219,9.831536293029785,  
TO136-020210000100112A,PRESSURE,1560712053809,94928,  
TO136-020210000100112A,PROXIMITY,1560712053221,200,  
TO136-020210000100112A,HUMIDITY_TEMPERATURE,1560712053812,23.492218017578125,  
TO136-020210000100112A,VISIBLE_SPECTRUM_LIGHTNESS,1560712053931,201,  
...

Using Bash again I developed the scoreboard.sh script (attached at the end of the project) which reads the recording_session.csv file and process the sensors information in the following way:

HUMIDITY, PRESSURE, TEMPERATURE and LIGHTNESS = Calculate the average of the values of each sensor.
ACCELERATION = Count the number of shots based on the hoop movements.
PROXIMITY = Count the number of the scores based on the ball presence.

The results were really good... but not perfect :-(

The scoreboard.sh script execution

Actually, in the above recording session, it was made 40 shots and 32 of them were scored correctly (8 were missed). In other words, the SmartEdge device was able to recognize correctly 100% of the shots (40) but it just was able to detect 81% of the 32 scored shots (26).

Step 7: Final considerations

The SmartEdge device and the Brainium portal are very simple to setup/use and it was proved to be an excellent solution for really quick prototype development.
The SmartEdge device comes with a lot of sensors available.
The Brainium portal has a lot of great features and the API access is easy to use and very useful.
The proximity sensor was not able to identify correctly the presence of the ball probably due to the interference caused by the sun light.

Based in this project results I successfully developed the Smart basketball scoreboard project which proposed a definitive solution for this task.

It's really worth to take a look.

Smart basketball scoreboard final solution

Have fun...

#!/bin/bash
#------------------------------------------------------------------------------#
# Filename    : show-recordings.sh                                             #
# Description : Show available project recordings                              #
# Author      : Marcelo Avila de Oliveira <marceloavilaoliveira@gmail.com>     #
#------------------------------------------------------------------------------#

#------------------------------------------------------------------------------#
# VARIABLES                                                                    #
#------------------------------------------------------------------------------#

rest_path=https://ns01-api.brainium.com/api/v1
project_id=893
access_token=xxxxx

#------------------------------------------------------------------------------#
# MAIN                                                                         #
#------------------------------------------------------------------------------#

echo ""
echo "=> Showing recordings"
echo ""

echo "Date/Time                  Id"
echo "-----------------------    ------------------------"

curl --silent --request POST "$rest_path/recordings/api/find" --header "Content-Type: application/json" --header "Authorization: Bearer $access_token" --data "
{
    \"projectIds\" : [ \"$project_id\" ]
}" | jq --raw-output '.content[] | .startedAt + " => " + .id'

echo ""

#!/bin/bash
#------------------------------------------------------------------------------#
# Filename    : get-recording.sh                                               #
# Description : Download a recording file                                      #
# Author      : Marcelo Avila de Oliveira <marceloavilaoliveira@gmail.com>     #
#------------------------------------------------------------------------------#

#------------------------------------------------------------------------------#
# VARIABLES                                                                    #
#------------------------------------------------------------------------------#

rest_path=https://ns01-api.brainium.com/api/v1
access_token=xxxxx

#------------------------------------------------------------------------------#
# MAIN                                                                         #
#------------------------------------------------------------------------------#

echo ""
echo "=> Getting the recording file URL"
echo ""

file_url=$(curl --silent --request GET "$rest_path/recordings/$1" --header "Content-Type: application/json" --header "Authorization: Bearer $access_token" | jq --raw-output '.linkOnExportedFile')

echo ""
echo "=> Downloading the recording file"
echo ""

wget --output-document recording_session.csv "$file_url"

echo ""

#!/bin/bash
#------------------------------------------------------------------------------#
# Filename    : scoreboard.sh                                                  #
# Description : Smart basketball training tracker                              #
# Author      : Marcelo Avila de Oliveira <marceloavilaoliveira@gmail.com>     #
#------------------------------------------------------------------------------#

#------------------------------------------------------------------------------#
# VARIABLES                                                                    #
#------------------------------------------------------------------------------#

source=
timestamp=0
value=0

date_ini=
date_end=

shots_num=0
scores_num=0

shots_wait=0
scores_wait=0

temperature_tot=0
humidity_tot=0
lightness_tot=0
pressure_tot=0

temperature_num=0
humidity_num=0
lightness_num=0
pressure_num=0

#------------------------------------------------------------------------------#
# MAIN                                                                         #
#------------------------------------------------------------------------------#

echo ""
echo "=> Calculating statistics"
echo ""

# The recording_session.csv file is formated as following:
#
# devicePublicId,dataSource,timestamp,scalar,vector
# TO136-020210000100112A,HUMIDITY,1560712053812,51,
# TO136-020210000100112A,ACCELERATION_NORM,1560712053219,9.831536293029785,
# TO136-020210000100112A,PRESSURE,1560712053809,94928,
# TO136-020210000100112A,PROXIMITY,1560712053221,200,
# TO136-020210000100112A,HUMIDITY_TEMPERATURE,1560712053812,23.492218017578125,
# TO136-020210000100112A,VISIBLE_SPECTRUM_LIGHTNESS,1560712053931,201,
# ...

# For each line of the recording_session.csv file
while read -r line
do
    # Get the dataSource (HUMIDITY, ACCELERATION_NORM, etc) and the scalar value
    source=$(echo $line | cut -d "," -f 2)
    timestamp=$(echo $line | cut -d "," -f 3)
    value=$(echo $line | cut -d "," -f 4)

    if [[ $date_ini = "" ]]
    then
        # Keep the initial date/time
        date_ini=$(date "+%Y-%m-%d %H:%M:%S" -d @${timestamp:0:10})
    fi

    case $source in
        # Check the acceleration (shots)
        ACCELERATION_NORM)
            if [[ $shots_wait -eq 0 ]]
            then
                if (( $(echo "$value > 10" | bc -l) || $(echo "$value < 9.6" | bc -l) ))
                then
                    # An acceleration was found
                    # Increment the number of shots
                    shots_num=$(echo "$shots_num+1" | bc)
                    # Start a wait time
                    shots_wait=1
                fi
            elif [[ $shots_wait -lt 50 ]]
            then
                shots_wait=$(echo "$shots_wait+1" | bc)
            else
                # Wait time finished
                shots_wait=0
            fi;;
        # Check the proximity (scores)
        PROXIMITY)
            if [[ $scores_wait -eq 0 ]]
            then
                if (( $(echo "$value < 100" | bc -l) ))
                then
                    # a proximity was found
                    # Increment the number of scores
                    scores_num=$(echo "$scores_num+1" | bc)
                    # Start a wait time
                    scores_wait=1
                fi
            elif [[ $scores_wait -lt 30 ]]
            then
                scores_wait=$(echo "$scores_wait+1" | bc)
            else
                # Wait time finished
                scores_wait=0
            fi;;
        # Check the temperature
        HUMIDITY_TEMPERATURE)
            temperature_num=$(echo "$temperature_num+1" | bc)
            temperature_tot=$(echo "$temperature_tot+$value" | bc );;
        # Check the humidity
        HUMIDITY)
            humidity_num=$(echo "$humidity_num+1" | bc)
            humidity_tot=$(echo "$humidity_tot+$value" | bc );;
        # Check the lightness
        VISIBLE_SPECTRUM_LIGHTNESS)
            lightness_num=$(echo "$lightness_num+1" | bc)
            lightness_tot=$(echo "$lightness_tot+$value" | bc );;
        # Check the pressure
        PRESSURE)
            pressure_num=$(echo "$pressure_num+1" | bc)
            pressure_tot=$(echo "$pressure_tot+$value" | bc );;
    esac
done < <(cat recording_session.csv | sed '1d' | sort --field-separator=, --key=3,3n)
# cat recording_session.csv => List recording_session.csv file
# sed '1d'                  => Remove the header line
# sort                      => Sort the file
#     --field-separator=,   => Use "-" as the field separator
#     --key=3,3n            => Sort numerically by the third field (timestamp)

# Keep the final date/time
date_end=$(date "+%Y-%m-%d %H:%M:%S" -d @${timestamp:0:10})

echo ""
echo "=> Showing statistics"
echo ""

echo "Start       = $date_ini"
echo "Finish      = $date_end"
echo ""
echo "Shots       = $shots_num (100%)"
echo "Scores      = $scores_num ($(echo "100*$scores_num/$shots_num" | bc)%)"
echo "Misses      = $(echo "$shots_num-$scores_num" | bc) ($(echo "100*($shots_num-$scores_num)/$shots_num" | bc)%)"
echo ""
echo "Temperature = $(echo "$temperature_tot/$temperature_num" | bc) C"
echo "Humidity    = $(echo "$humidity_tot/$humidity_num" | bc) %"
echo "Lightness   = $(echo "$lightness_tot/$lightness_num" | bc) lux"
echo "Pressure    = $(echo "$pressure_tot/$pressure_num" / 100 | bc) hPa"
echo ""

Credits

Marcelo Ávila de Oliveira

5 projects • 9 followers

Smart Basketball Scoreboard Prototype

Things used in this project

Hardware components

Software apps and online services

Story

Step 1: Avnet SmartEdge setup

Step 2: Brainium project creation

Step 3: Brainium project configuration

Step 4: Basketball board setup

Step 5: Basketball workout recording

Step 6: Basketball workout data processing

Step 7: Final considerations

Code

show-recordings.sh

get-recording.sh

scoreboard.sh

Credits

Marcelo Ávila de Oliveira

Comments

Embed the widget on your own site

Smart Basketball Scoreboard Prototype

Smart Basketball Scoreboard Prototype

Things used in this project

Hardware components

Software apps and online services

Story

Step 1: Avnet SmartEdge setup

Step 2: Brainium project creation

Step 3: Brainium project configuration

Step 4: Basketball board setup

Step 5: Basketball workout recording

Step 6: Basketball workout data processing

Step 7: Final considerations

Code

show-recordings.sh

get-recording.sh

scoreboard.sh

Credits

Marcelo Ávila de Oliveira

Comments

Related channels and tags