from csvs to sensorthings in 10 minutes
TRANSCRIPT
From CSVs to SensorThingsAn Environmental Monitoring Example
sensorweb.geomatics.ucalgary.cawww.sensorup.com
0.23 litre/minute
0.25 litre/minute0.27 litre/minuteRH: 85 %
Temp: 18 Celsius
Dr. Steve Liang, Ph.D., P.Eng.Associate Professor, University of CalgaryFounder and CEO, SensorUp Inc.
About Dr. Steve Liang๏Associate Professor, Geomatics Engineering, Uni. Calgary
๏AITF-Microsoft Industry Research Chair on Open Sensor Web (2011~2014)
๏Chair OGC SensorThings API Standard Working Group
๏Rapporteur, ITU-T SG12/11 on Internet of Things Test Specifications
๏Founder and CEO, SensorUp Inc
๏Calgary’s Top 40 Under 40
About SensorUp๏We are a leader in Sensor Web
and IoT Platforms
๏We offer innovative and comprehensive SensorThings solutions.
๏We are proud member of Eclipse and Open Geospatial Consortium
News - NEST Bricked Revolv๏ “companies can
potentially disconnect your smart devices and leave them essentially useless at any time.” CBC
What will be covered
๏Environmental Monitoring
๏ Lots environmental monitoring data are still shared in CSV format
๏Transform CSVs into actionable SensorThings in 10 minutes
Water Level Monitoring System with SensorThings
http://www.environment.alberta.ca/apps/basins/default.aspx
Steps
Configure the monitoring stations in
SensorThings
Download the CSVs of the
sensor readings
Parse the CSVs and Load to
SensorThings
1 2 3
Step 1
Configure the monitoring stations in
SensorThings
Download the CSVs of the
sensor readings
Parse the CSVs and Load to
SensorThings
1 2 3
prepare the data model
Water monitoring station
Barrier Lake
Water level sensorWater level
Simple geometry
POST ThingsThing
Location
Deep Insert: check out our first webinar series for details
POST Datastreams
Change the id to the Thing you just created
POST FeatureOfInterest
Station Location and Feature of Interest??
Location of the Thing (a point)
Feature of Interest (a polygon)
Step 2
Configure the monitoring stations in
SensorThings
Download the CSVs of the
sensor readings
Parse the CSVs and Load to
SensorThings
1 2 3
Download the CSV file
Shell script to upload the observations
Let’s load it in our dashboard
GIST
https://gist.github.com/liangsteve/d26a96c02108210a89991470ec1d1fb0
Summary๏SensorThings API provides great developer
experience.
๏minimum coding
๏ Interoperability - supports OGC/ISO O&M
๏ Location and Feature of Interest can be different
๏ e.g., station is the location, lake is the FoI
We will start our next webinar series soon!
Let us know what topics interest you!!
Email: [email protected]