Integrated Breakout Session Briefing for Cary, NC

This information provided by Smart Cities Council North America.
Wed, 2018-06-06 20:57 -- SCC Staff

Challenge statement

How can Cary more effectively access and analyze cross-sector data from legacy and IoT systems to enable a ONE Cary approach to community understanding and improvement?



  • Data Management Program
  • Integration
  • Analysis


Specific questions relating to this topic that can inform the discussion

  • Describe where the Town of Cary should be in 6 months, one year and three years from now in this focus area?
  • What API and Security standards should be required with any implementation?
  • What are data considerations (i.e. format, retention schedule, correlation, etc.)?
  • Where does data need to be bi-directional, stored/processed at the edge, discarded?
  • Are there any preferences for data management methodology?


Why is this topic important?

Data is arguably one of the most valuable assets of the town, second to our Citizens and Staff. An integrated data infrastructure will ensure that the organization and the citizens we serve are supported with sound data analytics and good data quality practices. It will also get us to the final "Predictable" State that will consist of fully integrated internal and cloud-based networks, platforms for full automation and AI.



Elaborate on challenge statement (what are the specific concerns?)

  • Privacy violations 
  • Data security 
  • Civil liability 
  • Regulatory liability 
  • Siloed, Legacy Networks and Applications with no APIs
  • Excessive costs in keeping redundant, obsolete and trivial data including documents, backups and SharePoint
  • Growth in data from IoT and smart devices

Define solutions that have been implemented to date and those being planned

Below are Cary’s networks and applications being connected to our cloud platforms (Salesforce, O365, ESRI, Box, Okta)

  • Traffic (Fiber) – 200+ traffic controllers and video cameras
  • Scada (Verizon Wireless and AT&T Fiber) – Three Waste Water Plants, One water plant, 10 Tier One Pump Stations
  • Aquastar (TOC/Sensus Licensed 900 MHz) – 65,000+ Water Meters
  • P25 Public Safety Radio Network (Licensed 800 MHz) – 1,000 Cary + 15,000 Wake Subscribers
  • 911 PSAP (AT&T)
  • Business Network (Mainly Town owned fiber, some wireless) - VoIP, Virtual Servers & Storage, AS400, Wi-Fi, Building Automation, Security systems, SAS Data Management, etc.
  • SSC IoT Specific Deployments – Smart Parking (Cisco Kinetics for Cities/NWN/Quentela), Wi-Fi Beacon People Counters (Cisco Kinetics for Cities), Smart Lighting (Trilliant), Automated Traffic Tickets (Traffic/Dellboomi/Salesforce), Scada/People Counting/GISInc/ESRI


What have we accomplished so far?

  • Moving to "Proactive" State (Connected and Smart City 2.0) – This involves connecting our siloed internal and cloud-based networks/systems to our major platforms, which includes data management strategy (ex. Fitbit for the Town, Dashboards, Automatic Ticket Generation, etc.). Includes some regional connections/integrations.


  • We are securing management buy-in and have engaged with business units in order to design a master data management project plan. We have established use cases and work flows for both the Fire Department and Police Department using technology already existing in the Town. In addition, we are assessing a use case for SCADA. Our comprehensive assessment will include technology and workflow requirements for data across the enterprise such as CJIS, HIPAA and other regulatory and data ethics issues.


Define benefits being sought from new or expanded set of solutions

  • Future/Ultimate "Predictable" State (Connected and Smart City 3.0 ) – Secure full integration of all internal and cloud-based networks, platforms for full automation and AI. (ex. Stormwater sensor triggers interaction with traffic network, Waze, and Salesforce). This will be an environment where we can easily build what we want regardless of the silos. Includes many regional connections/integrations. All of this while keeping the focus around the citizen experience improvement, operational efficiency improvement, evidence-based outcomes and economic development.


  • Data management pieces include:
    • Future-oriented regulation of data processing and respect for the rights to privacy and to data protection  
    • Localized data control/ownership, but not localized storage, "no more Access data bases on laptops!"
    • Privacy conscious engineering and design of data processing products and services  
    • Empowered individuals  
    • Provide real-time situational awareness information to 311, 911 and other departments

Define additional topics (if any) City wants to explore in working group