Virtual fencing dashboard
Live demo, simulated data
A browser simulation of a ranch: 48 collared cows, 8 pastures, 3 radio gateways. A fence shrinks to move the herd to the next field. Then things break. A gateway goes offline, GPS (Global Positioning System) signals lie, and a fence update never reaches 8 collars.
It started as an unpaid interview exercise for a cattle startup. My job was the database design. Two decisions were mine. Every table carries an organization id, so one platform can serve many ranchers. And a fence move goes through three states: planned, pushed, executed. For the exercise I also learned to read Bluetooth Low Energy and LoRa (long-range radio) messages and tested them on a couple of real devices I own.
The brief called a move done when 80% of collars confirmed. I think that's too low, because the other 20% are cows standing in the wrong field. So the demo judges each collar and shows the move as partial.
The company changed focus before I could show them any of it, so I rebuilt it as a simulation. I designed it and directed it. Claude wrote the code.