Coming up for air

You have not seen any posts for the past couple of months because I have been busy migrating the IoT Map data from a big Google Sheet to a “real” database and of course learning some technologies along the way including MongoDB, Express, Node.js, Mongoose, EJS.

As I migrate the data there’s some cleanup to be done including back-filling attributes that I added along the way. Right now I’m going back and adding all of the social network IDs for each organization.

Here’s a sneak peak at one organization’s (Amazon) profile and set of IoT products/services:

https://www.iotmap.ca/IoTMapTake3.html

That’s not what the final UI will look like, just a sample of the data that I have collected. Below is the corresponding Mongo document for Amazon.

Each organization has one or more products, in this case Alexa, Dash, Echo, AWS IoT, Prime Music. Once done, you’ll be able to select any of the integrations / technologies and see the other products and organizations that integrate or use those technologies.

Of course, the end goal is a more dynamic map that you can filter on the fly and find the info you need much faster.

I am going back into my hole now for a bit and look forward to providing another update soon.

{
 "_id" : ObjectId("58d7b8b026c1581164004abe"),
 "name" : "Amazon",
 "slug" : "amazon",
 "url" : "www.amazon.com",
 "date_added" : "Fri, 02 Sep 16 00:00:00 +0000",
 "social_network" : [
 {
 "service" : "LinkedIn",
 "account" : "1586",
 "url" : "www.linkedin.com/company/1586"
 },
 {
 "service" : "Facebook",
 "account" : "Amazon",
 "url" : "www.facebook.com/Amazon"
 },
 {
 "service" : "Twitter",
 "account" : "Amazon",
 "url" : "www.twitter.com/Amazon"
 },
 {
 "service" : "Instagram",
 "account" : "amazon",
 "url" : "https://www.instagram.com/amazon/"
 },
 {
 "service" : "YouTube",
 "url" : "https://www.youtube.com/user/amazon"
 }
 ],
 "stock" : {
 "exchange" : "NASDAQ",
 "ticker_symbol" : "AMZN",
 "url" : "http://www.nasdaq.com/symbol/amzn/real-time"
 },
 "history" : {
 "founded_year" : "1994"
 },
 "location" : [
 {
 "head_office" : true,
 "address" : {
 "street" : "12th Avenue South",
 "suite" : "Suite 1200",
 "city" : "Seattle",
 "state_province" : "Washington",
 "country" : "United States",
 "zip_postal" : "98144"
 }
 }
 ],
 "product" : [
 {
 "_id" : ObjectId("58d7b8ad26c15811640045fe"),
 "name" : "Alexa",
 "slug" : "alexa",
 "url" : "developer.amazon.com/public/solutions/alexa",
 "primary_category" : "Home Automation",
 "secondary_category" : "Hub",
 "description" : "voice service powering Echo, provides capabilities (skills) to interact with devices using voice",
 "software" : true,
 "integration" : [
 {
 "_id" : ObjectId("58d7b8ad26c15811640049ba"),
 "name" : "Stringify",
 "slug" : "stringify",
 "type" : "platform"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004601"),
 "name" : "Echo",
 "slug" : "echo",
 "type" : "voice"
 },
 {
 "_id" : ObjectId("58d7b8ad26c158116400482b"),
 "name" : "Iris Smart Hub",
 "slug" : "iris-smart-hub",
 "type" : "home-hub"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004746"),
 "name" : "Connected Appliances",
 "slug" : "connected-appliances",
 "type" : "appliance"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640046a6"),
 "name" : "CE Smart LED",
 "slug" : "ce-smart-led",
 "type" : "light"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004747"),
 "name" : "GE Light Bulbs",
 "slug" : "ge-light-bulbs",
 "type" : "light"
 },
 {
 "_id" : ObjectId("58d7b8ad26c158116400482e"),
 "name" : "Caseta Wireless",
 "slug" : "caseta-wireless",
 "type" : "light"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004678"),
 "name" : "Cor Thermostat",
 "slug" : "cor-thermostat",
 "type" : "thermostat"
 },
 {
 "_id" : ObjectId("58d7b8ad26c158116400479d"),
 "name" : "iDevices Thermostat",
 "slug" : "idevices-thermostat",
 "type" : "thermostat"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004886"),
 "name" : "Nest Thermostat",
 "slug" : "nest-thermostat",
 "type" : "thermostat"
 },
 {
 "_id" : ObjectId("58d7b8ad26c158116400479c"),
 "name" : "iDevices Switch",
 "slug" : "idevices-switch",
 "type" : "power"
 },
 {
 "_id" : ObjectId("58d7b8ad26c158116400495b"),
 "name" : "iHome Smart Plug",
 "slug" : "ihome-smart-plug",
 "type" : "power"
 }
 ],
 "protocol" : [
 "IFTT"
 ],
 "wireless_interface" : [
 "Wi-Fi"
 ]
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004600"),
 "name" : "Prime Music",
 "slug" : "prime-music",
 "url" : "www.amazon.com/primemusic",
 "primary_category" : "Services",
 "secondary_category" : "Music",
 "description" : "a benefit of an Amazon Prime Membership, featuring 2 million songs, ad-free and on-demand",
 "service" : true,
 "application" : [
 "iOS",
 "Android"
 ]
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004601"),
 "name" : "Echo",
 "slug" : "echo",
 "url" : "www.amazon.com/echo",
 "primary_category" : "Home Automation",
 "secondary_category" : "Hub",
 "description" : "hands-free speaker you control with your voice. Echo connects to the Alexa Voice Service to play music, provide information, news, sports scores, weather, and more",
 "service" : true,
 "application" : [
 "iOS",
 "Android"
 ],
 "integration" : [
 {
 "_id" : ObjectId("58d7b8ad26c15811640047af"),
 "name" : "Initial State",
 "slug" : "initial-state",
 "type" : "platform"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004623"),
 "name" : "Arrayent Connect",
 "slug" : "arrayent-connect",
 "type" : "platform"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004600"),
 "name" : "Prime Music",
 "slug" : "prime-music",
 "type" : "music"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640045ff"),
 "name" : "iHeartRadio",
 "slug" : "iheartradio",
 "type" : "music"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004616"),
 "name" : "Pandora Internet Radio",
 "slug" : "pandora-internet-radio",
 "type" : "music"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004610"),
 "name" : "Spotify",
 "slug" : "spotify",
 "type" : "music"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004611"),
 "name" : "TuneIn",
 "slug" : "tunein",
 "type" : "music"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004647"),
 "name" : "WeMo",
 "slug" : "wemo",
 "type" : "home-hub"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640047b2"),
 "name" : "Insteon Hub Pro",
 "slug" : "insteon-hub-pro",
 "type" : "home-hub"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004960"),
 "name" : "Almond",
 "slug" : "almond",
 "type" : "home-hub"
 },
 {
 "_id" : ObjectId("58d7b8ad26c158116400494d"),
 "name" : "SmartThings Hub",
 "slug" : "smartthings-hub",
 "type" : "home-hub"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004a54"),
 "name" : "Wink",
 "slug" : "wink",
 "type" : "home-hub"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640048ef"),
 "name" : "Hue",
 "slug" : "hue",
 "type" : "light"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640046e6"),
 "name" : "ecobee",
 "slug" : "ecobee",
 "type" : "thermostat"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004886"),
 "name" : "Nest Thermostat",
 "slug" : "nest-thermostat",
 "type" : "thermostat"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004a0f"),
 "name" : "TP-Link Smart Plug",
 "slug" : "tp-link-smart-plug",
 "type" : "power"
 }
 ],
 "wireless_interface" : [
 "Wi-Fi"
 ]
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004602"),
 "name" : "AWS IoT",
 "slug" : "aws-iot",
 "url" : "aws.amazon.com/iot",
 "primary_category" : "IoT Platform",
 "secondary_category" : "Developer",
 "description" : "real-time analytics: rules engine, Amazon Kinesis, AWS Lambda",
 "software" : true,
 "integration" : [
 {
 "_id" : ObjectId("58d7b8ad26c15811640045d0"),
 "name" : "Concert IoT",
 "slug" : "concert-iot",
 "type" : "platform"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640045fe"),
 "name" : "Alexa",
 "slug" : "alexa",
 "type" : "voice"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004601"),
 "name" : "Echo",
 "slug" : "echo",
 "type" : "voice"
 }
 ],
 "feature" : [
 "Device Management",
 "Real Time Analytics",
 "no",
 "Rules Engine",
 "Visualization"
 ],
 "encryption" : [
 "SSL",
 "TLS"
 ],
 "authentication" : [
 "X.509",
 "SigV4"
 ],
 "protocol" : [
 "REST"
 ],
 "primary_platform" : "Many",
 "hardware_platform" : [
 {
 "_id" : ObjectId("58d7b8ad26c1581164004642"),
 "name" : "BeagleBone",
 "slug" : "beaglebone"
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004916"),
 "name" : "Dragon Board",
 "slug" : "dragon-board"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640047bb"),
 "name" : "Intel Edison",
 "slug" : "intel-edison"
 },
 {
 "_id" : ObjectId("58d7b8ad26c15811640049e8"),
 "name" : "TI CC3200",
 "slug" : "ti-cc3200"
 }
 ]
 },
 {
 "_id" : ObjectId("58d7b8ad26c1581164004603"),
 "name" : "Dash",
 "slug" : "dash",
 "url" : "fresh.amazon.com/dash",
 "primary_category" : "Things",
 "secondary_category" : "Buttons",
 "description" : "shopping, hand held scanner and voiice recognition",
 "service" : true,
 "wireless_interface" : [
 "Wi-Fi"
 ],
 "wifi_chip" : [
 "Broadcom"
 ]
 }
 ]
}

Leave a Reply

Your email address will not be published. Required fields are marked *