Things used in this project

Hardware components:
R8326274 01
Raspberry Pi 2 Model B
×1
Cottonwood: TTL UART Long Range UHF RFID reader (ISO18000-6C EPC G2)
×1
8dbi Mid-Range UHF RFID Antenna
For best results, a commercial grade long range UHF RFID circular antenna is recommended
×1
Male N-J to MMCX-J Interface Cable
×1
CP2102 USB 2.0 to UART TTL 6PIN Module Serial Converter
×1
5VDC 2A Power Supply Center-positive 5.5x2.1mm barrel connector
The Cottonwood board requires it's own power supply
×1
Software apps and online services:
W9gt7hzo
Microsoft Azure
Web management interface and Web API service end-point hosting, database hosting
10
Microsoft Windows 10 IoT Core

Schematics

USB to UART TTL Wiring
USB to UART TTL Wiring
Wp 20150916 20 59 05 rich
Cottonwood Wiring
- CP2102 GND to Cottonwood GND
- CP2102 TX to Cottonwood RX
- CP2102 RX to Cottonwood TX
Wp 20150916 21 03 12 rich

Code

trackerwebdb Database ScriptSQL
Create a SQL Azure database named trackerwebdb and run this script
USE [trackerwebdb]
GO
/****** Object:  Table [dbo].[Monitor]    Script Date: 9/17/2015 4:07:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Monitor](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IpAddress] [varchar](23) NULL,
	[FriendlyName] [varchar](50) NULL,
	[Location] [varchar](255) NULL,
	[Status] [int] NULL,
	[LastPing] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Tag]    Script Date: 9/17/2015 4:07:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tag](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TagId] [varchar](35) NULL,
	[FriendlyName] [varchar](50) NULL,
	[Description] [varchar](500) NULL,
	[BlobId] [varchar](300) NULL,
	[Status] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Tracking]    Script Date: 9/17/2015 4:07:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tracking](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TagId] [int] NULL,
	[MonitorId] [int] NULL,
	[Reading] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)

GO
/****** Object:  View [dbo].[InventoryView]    Script Date: 9/17/2015 4:07:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[InventoryView]
	AS 
	select t.id as TagId,
	   t.friendlyname as TagFriendlyName,
	   (select max(tj.reading) from tracking tj where tj.tagid=t.id) as Reading,
	   CASE WHEN (select max(tk.reading) from tracking tk where tk.tagid=t.id) IS NOT NULL THEN
			(select m.location from monitor m 
					inner join tracking tk on m.id=tk.monitorid
			where tk.tagid=t.id and tk.reading=(select max(reading) from tracking where tagid=t.id))
	   ELSE
		'N/A'
	   END as Location
	from tag t
GO
ALTER TABLE [dbo].[Tracking]  WITH CHECK ADD  CONSTRAINT [FK_Tracking_Monitor] FOREIGN KEY([MonitorId])
REFERENCES [dbo].[Monitor] ([Id])
GO
ALTER TABLE [dbo].[Tracking] CHECK CONSTRAINT [FK_Tracking_Monitor]
GO
ALTER TABLE [dbo].[Tracking]  WITH CHECK ADD  CONSTRAINT [FK_Tracking_Tag] FOREIGN KEY([TagId])
REFERENCES [dbo].[Tag] ([Id])
GO
ALTER TABLE [dbo].[Tracking] CHECK CONSTRAINT [FK_Tracking_Tag]
GO
Headed Cottonwood Tester Application
A headed universal application that allows you to manually communicate with the Cottonwood Long Range UHF RFID board
Web interface for monitor and device management, web api reading endpoint
Web interface that allows the user to register monitors and tags. Also provides Web API end point for readings from the Monitors.
RFID Scanner - Background Application that reads UHF RFID tags
Background Universal Application that reads available UHF RFID tags from the Cottonwood board and sends them to a cloud service. Also contains the class library of the Cottonwood class.

Credits

Photo
Carey Payette

Sr. Software Engineer at Falafel Software

Contact

Replications

Did you replicate this project? Share it!

I made one

Love this project? Think it could be improved? Tell us what you think!

Give feedback

Comments

Similar projects you might like

PHPoc Blue to Control Door Knob by MQTT Protocol and Cortana
Intermediate
  • 68
  • 7

Programming a PHPoc Blue board to control a servo motor to rotate the knob of a door using MQTT Protocol through voice command.

ConnectTheDots with Particle Azure IoT Hub Integration
Intermediate
  • 558
  • 7

Protip

This project will allow you to connect your Particle device into an Azure IoT Hub for viewing data in real-time through an ASP.NET web app!

Adding RC Transmitter/Receiver to Control Mecanum Bot
Intermediate
  • 521
  • 6

Full instructions

We previously showed our Mecanum Bot being controlled by a wireless Xbox controller, now we added RC transmitter/receiver.

Cat Door with Pet Recognition
Intermediate
  • 4,550
  • 21

Full instructions

Use object detection to let your cat in and out of the house with a motion-activated pet door.

Lego Mindstorms  Elevator
Intermediate
  • 144
  • 2

A 3-story elevator with a mechanical door made from Lego Mindstorms and programmed on RoboCore. It moves up and down and reacts to buttons.

Lego Mindstorms Elevator

Team ElevatorRoboCore

I'm Fine for the Workplace
Intermediate
  • 592
  • 5

Full instructions

A system to let someone ask for help at school or in the workplace without having to do it publicly.

I'm Fine for the Workplace

Team National Star and EDF Energy Hackathon

Add projectSign up / Login