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

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

Pulse Train Hat for Raspberry Pi Mecanum Bot Example
Intermediate
  • 653
  • 15

Full instructions

With this example, we show how to use the PTHAT and wireless Xbox controller to control a Mecanum Bot.

GooglePi - Google Assistant on Raspberry Pi
Intermediate
  • 15,054
  • 85

Full instructions

A DIY Google Home using your Raspberry Pi.

Pre-Collision Assist with Pedestrian Detection - Honda Civic
Intermediate
  • 1,614
  • 19

Full instructions

Combine Walabot's RF radar with real-time hazard detection and classification from camera, powered by TensorFlow with YOLO approach.

Detect Motion With OpenCV, No PIR Sensor Needed
Intermediate
  • 802
  • 14

Full instructions

If you have a HAT connected to your Raspberry Pi, you can't use your GPIO. But what if you want to detect motion? This project can help!

Smart Garden
Intermediate
  • 125
  • 2

Smart Garden is plant environmental monitoring system.

Pigeon: A 3D-Printed, Pi Zero W-Powered Cloud Camera
Intermediate
  • 1,243
  • 26

Full instructions

Pigeon is a simple cloud home surveillance camera project that uses the new Raspberry Pi Zero W single-board computer ($10).

ProjectsCommunitiesTopicsContestsLiveAppsBetaFree StoreBlogAdd projectSign up / Login
Feedback