PTI Staff Contact: Dale Bowen
PTI is pleased to announce the winners and significant achievement award recipients of the 2019 Technology Solutions Awards.
City of Durham Enhanced cyber-security program to defend the City against ongoing cyber threats
Organizations facing major security risk in the following areas:
Based on the above threats, every organization needs an information security program to protect its systems and assets.
Technology Solutions is addressing the evolving cyber threats by enhancing a comprehensive cyber security program utilizing best-of-breed cyber security framework that embraces Information Security Governance and Risk Management.
Montgomery County Employee Identity Management
The Montgomery County, Maryland, Department of Technology Services (DTS) successfully implemented processes, policies, technology and governance to manage the full lifecycle of identity management and access control for access to County information systems resources for job applicants, employees, and former employees. The identity management solution implemented by DTS has allowed the County to improve efficiency and quality of service by reducing manual effort and errors, while at the same time providing enhanced auditability and information security.
Features implemented in the new solution include the following:
Roanoke County County of Roanoke, VA Disaster Resiliency Design and Implementation
Roanoke County has implemented a disaster resiliency strategy to minimize the impact to county staff and residents in the event the primary data center experiences an incident that might lead to the loss of data processing systems. An event such as a fire could severely impact the ability of county information technology staff to provide access to the applications and systems required by staff members directly serving the needs of the local citizens.
Previous disaster recovery planning depended on copies of vital data being captured and stored off-site. To restore systems to a fully functional state would have taken weeks to complete and would not prevent the loss of one or more days’ worth of data. The old tape backup system was replaced by backup to disk and this data was replicated to an offsite location 40 miles away.
Although data was geographically separated from the primary data center, information technology staff and management concluded a secondary site should be established for the replication of data using the capabilities of the storage area network equipment, and be in closer proximity to the primary site for faster recovery. The data would be replicated throughout the day in two hour intervals so that the off-site data would be as close to real time as possible. Technology changes to accomplish this resulted not only in faster recovery, but also an almost fully functional dual-purpose secondary data center with network and data redundancy.
City of Durham Data Center Refresh
When it comes to IT infrastructure requirements, Data Centers are a top priority. Given the explosive growth in data that needs to be managed, Data Centers the most important asset. Data centers are integral to an organization’s business and operational success.
Any interruptions in the City’s data center operations due to aging or failing hardware and infrastructure, or environmental events can virtually bring down the organization. This is why an efficient business resiliency strategy is key. This is integral to an organization's capability of providing effective Continuity of Operations Planning within its business units.
As a result, the City of Durham has endeavored on significant tasks to:
City of Durham Public Private Metropolitan Area Fiber Network Partnership Initiative!
For many local governments, the pressure is on to build a technology infrastructure that will become a foundation for its present and future smart city initiatives. Those initiatives include utilizing high speed connections and erasing the digital divide. As a result, the City of Durham has partnered with both Duke University and Durham County to build and utilize a fiber optic network to provide high speed, reliable, network connectivity to all City facilities and low-income residents that reside in Durham Public Housing Authority locations.
To keep pace with today’s technology and expectations of business and residents, future smart city technologies will require gigabit connections to every facility and other locations throughout the city. This includes enabling the City of Durham to continue to adjust its Data Center for rapidly changing technology.
Cities around the country are continuing to undergo a technological change to provide more digital services. High speed fiber will also allow local government to meet growing bandwidth requirements in support of critical emergency management and medical services, waste water management, law enforcement, public libraries, and provide greater capacity to meet future technology bandwidth requirements at significant savings. Also, the high speed connections to Durham Public housing will address the disparity within the City and help reduce the digital divide that exists in so many communities.
City of Durham Shared Audio-Video Conference Room and Digital Signage Upgrade
At the intersection of business and technology, the one constant is that people need to meet either physically or virtually. And the best place for people to work on a business problem together is in a conference room. Unfortunately, conference rooms within many organizations such as the City of Durham are on the trailing end of technology. As such, the conference rooms at the City have been unable to meet the smart technological needs of the modern working professional.
To address this issue, the City of Durham is currently undergoing a project that will upgrade the technology for all of its shared conference rooms within the City. This upgrade includes audio, video, software, and digital signage upgrades. This upgrade will also provide the City with a much needed centralized management and scheduling solution. Benefits of this upgrade include tools that foster easier collaboration, more problem solving sessions, multi-use video conferencing solutions, big-screen TVs and the creation of a culture that nurtures both creativity and connectivity. Additionally, this upgrade will allow the city to leverage existing platforms, such as Office 365 and Skype.
Miami-Dade County Offense-Incident Supplemental Reporting
Offense-Incident Reports (OIR) are written to capture, in detail, events that transpire during calls for service to law enforcement. Depending upon the scale, duration or type of event, a Supplemental Offense-Incident Report may be written to augment or change information from the original report. The program extends the current report writer that the Miami-Dade Police Department (MDPD) uses to capture original event information and allows supplemental information to be captured. The supplemental documents are processed through a supervisory and operational workflow, and then finally stored in a searchable database. The resulting documents are also loaded in the county's electronic document management system automatically.
Miami-Dade County Solid Waste Green Garbage Carts and Bulky Trash System Modernization
The Department of Solid Waste Management (DSWM) provides several waste removal related services for more than 340,000 of its' residential and commercial customer accounts. All of their residential garbage accounts are issued one green waste cart that the citizen utilizes to store their daily household waste. The citizen has a choice between three different sizes of green garbage carts (35 gallon, 65 gallon or 95 gallon). If the citizen's green waste cart is damaged or stolen, they can call the Miami Dade call center system, called 311, to request a free repair or replacement. DSWM's Garbage division has 7 Waste Carts crews that are responsible for delivering, repairing and/or replacing all of the residential green waste carts throughout Miami-Dade County. Citizens call 311 to report their green cart related problems such as broken wheels, damaged lids, stolen carts etc. The DSWM Waste Cart crew process over 35,000 311HUB citizen green waste carts service request calls each year.
Montgomery County Skype For Business Deployment
The Montgomery County, Maryland, Department of Technology Services (DTS) migrated its 200+ staff from an on-premise Private Branch Exchange (PBX) telephony system to Microsoft’s Skype for Business cloud-based Voice over Internet Protocol (VoIP) Unified Communications (UC) platform. The successful deployment of this project enhanced work flexibly, collaboration capabilities, and, continuity of operation planning (COOP), and served as a potential model for transition to Cloud-based telephony for the rest of the County workforce.
Montgomery County Workflow Engine for Complex Process Orchestration
The Montgomery County, Maryland, Department of Technology Services (DTS) successfully developed and deployed an open source Workflow Engine for Complex Process Orchestration that has improved the quality, capability and resiliency of supported processes while simultaneously enabling the Department to meet or exceed Information Technology (IT) Service Level Agreements (SLA’s).
Realized goals include:
City of Bellevue Community Cybersecurity Awareness Outreach
The City of Bellevue has a robust security awareness program and routinely educates its employees on the best practices for safe computer usage and navigating the internet while at work or at home. In the past year we had an opportunity to pass this information onto to our neighborhood communities and further enhance cybersecurity awareness. this was accomplished by utilizing an innovative approach of community meetings and social media that the Information Technology Department and Community Development Department initiated.
Local government has a responsibility and obligation to ensure safe communities. This initiative allowed the City to utilize its knowledge, staff resources, and social media to educate the community to be better on-line citizens and demonstrate how they can be safer in the "cyber-community".
City of Ocala Email Safety and Creating the Human Firewall
With the ever-growing amount of ransomware, phishing attacks, and malware targeted at City of Ocala, a new solution was required to train, educate, and test employees. Our employees are the last line of defense against hackers and unwanted efforts to compromise our business. Implementing KnowBe4’s effective and affordable Security Awareness training platform turned rampant malware infections to a thing of the past. The platform allows the City of Ocala to constantly train, send simulated phishing attacks, and integrate simple alerting. This has turned our employees into true human firewalls. Where our technical controls failed, our employees can identify malicious threats in their inboxes more readily and effectively now.
Fairfax County Fairfax Next Generation Email Security Program
As a County Government servicing about 1.5 million citizens, we have the utmost responsibility to protect the well-being of Citizens, Employees and Executives when it comes to their data. Fairfax is also home to some Fortune 500 Companies and large Government Contractors. We protect Businesses, Citizen’s and employee data with regards to taxes, sensitive personal information, businesses permits, land, Critical Infrastructure, Health and Human services and Public Safety. The Fairfax County Next Generation Email Security Program is part of the main Cyber Security program. Email is the number one threat vector used by Cyber Criminals. Majority of Security incidents originates from Spear Phishing, Malware, Ransomware and SPAM executed by the user community. Email Fraud, Identity Deception trends, Business Email Compromise (BEC) are also on the rise. Fairfax County has implemented a successful program utilizing automated email security solutions and practices.
Montgomery County Power BI Security Dashboard
The Montgomery County, Maryland, Department of Technology Services (DTS) implemented a Business Intelligence (BI) solution to enhance security awareness across all County Departments, to allow Departments to more quickly respond to critical system vulnerabilities, and to more efficiently address the backlog of high severity vulnerabilities requiring remediation.
The realized goals of this program include:
City of Scottsdale Dynamic Customer Relationship Management System
As any large governmental organization, the City of Scottsdale serves its citizens and visitors many different ways. With the wide array of services comes a number of organization units, departments, divisions and ultimately many contact points. A citizen or visitor contacting Scottsdale may not know what area or department covers a particular function and could be challenged to find the right contact. In addition, customers also contact the City for elements that the City does not control or have direct influence over.
To help our customers find the right contact as quickly as possible, the City of Scottsdale developed a solution that would be accessible, straightforward and easy to use. The ScottsdaleEZ system enables customers to come to a single, mobile responsive web portal to lodge their question, complaint, or accolade in a single, easy to use system.
The system tracks the inquiries to ensure customers, when required, can be provided feedback and gives citizens a way to monitor the progress of their requests. The platform streamlines workflows, provides analytics, and is configurable to allow Scottsdale departments to deploy a new customer contact form in a couple of hours without having to make programing changes to the system.
Greater Cleveland Regional Transit Authority Homework Hotspots
We call it – Homework Hotspots. Providing free high speed internet access to our local students while they’re travelling through our facilities. Many students take multiple vehicles/modes to get to and from school and are a captive audience while waiting for their connections.
Internet Access is crucial for today's students to keep up and get ahead and it is a huge gap for students in our community when they are not in school; this effort provides public service to them.
The project is supported by many community leaders and partners.
We've turned on the first pilot location and are pursing 12 more in the coming weeks.
Montgomery County dataMontgomery Online Resident Guide: Encouraging Community Use of Open Data
Montgomery County, Maryland (the "County") has an established open data program ("dataMontgomery") that has published nearly 300 hundred public datasets with useful government information since its inception in 2012. The dataMontgomery Online Resident Guide ("guide") was created to facilitate the ability of County residents and constituents to quickly learn how to use open data to better inform and improve their communities.
The guide can be viewed at the following URL: http://bit.ly/yourdatakey
City of Durham Enhanced Secure Employee Access to Cloud Applications
Traditionally access from outside the network boundary has always been dependent on users having a designated laptop with VPN to be able to access internal resources. Because of this issue from a feasibility and financial perspective, the City implemented an Azure Application Proxy completely hosted within Microsoft Azure to allow secure access from outside the network to resources on the City of Durham network.
The implementation of the Azure Application Proxy allows for all employees regardless of job function, location, or device platform to maintain and be able to access the internal resources that have been approved for access. This includes the intranet system, helpdesk ticketing system, and SSRS/PowerBI platforms.
City of Durham Enterprise Cloud Data Realignment Improves Availability, Security and Productivity
All enterprises struggle with managing unstructured content and the challenges of versioning, search, context, security, and availability. Unstructured data includes Email, PDFs, Video, Audio, Office, etc. or any content generated by an employee.
Traditional methods of using file servers, various content management platforms, and multiple devices are not suitable for the modern day enterprise. The City of Durham identified roughly 56 TB of unstructured data sources and is in the process of consolidating them into Office 365 platform. The City of Durham has invested in the Office 365 platform and is continually using the platform not only to migrate the unstructured data sources to, but also to introduce new functionality for the enterprise.
Miami-Dade County Architecture and Engineering (A&E) "Request to Advertise" (RTA)
The Architecture and Engineering (A&E) "Request to Advertise" application automated the current paper-based A&E process with a Web-based system to allow automated workflows, memo generation, and reporting. Request to Advertise (RTA) is a process that allows client departments to capture the scope of a project, include vendors and sub-contractors who can perform project tasks based upon their pre-qualification certification with Miami-Dade County, and attach relevant documents. The RTA is advertised to vendors to request proposals, after review by the County's procurement personnel and approval from the Board of County Commissioners.
Miami-Dade County Digital Government
The Digenda application provides a paperless alternative to the Miami-Dade County Board of County Commissioners (BCC) official agendas legislative business process.
One important goal of the Miami-Dade County Information Technology Department (ITD) has been to promote and encourage other departments to implement a "paperless" model solution to many of their business processes. After a preliminary analysis, ITD recommended that this "paperless" model would considerable benefits the BCC legislative process by providing better productivity, accessibility, and document organization. In addition, the primary focus for the implementation of the Digenda was to take advantage of new emerging mobile technologies to facilitate the BCC legislative process. These technologies include to use of mobile device features for pushing notifications and instant updates. The resulting benefit for the BCC is to have the unprecedented capability of receiving instant legislative process status alerts and review them form a centralize application at any time.
Digenda main purpose is to replace a paper driven process into a one that takes advantages of the latest digital technologies to better serve the Miami-Dade County Board of County Commissioners (BCC).
Miami-Dade County eCommerce Commission of Ethics Training Management Payment Application
The project's purpose was to enhance the Miami-Dade County Commission on Ethics and Public Trust's (COE) Training Program, by developing an online system to eliminate the manual registration and payment processes. Furthermore, the project would expand the County's accessibility to 24x7x365 and facilitate personnel reassignment to other core tasks, adding value to the County's daily operations and the services provided to our residents.
Miami-Dade County INMATE SEARCH
Inmate Search is a public facing application providing inmate data while in custody.
Inmate data includes: mugshot image, jail number, name, booking date, race, sex, date of birth, hair color, eye color, weight, height, IDS number, cell location, case number, charges and bond amount.
The system features: integration with Criminal Justice Information Systems (CJIS) mainframe database, usage load management via IP logging, IP blocking and throttling based on client IP address.
Miami-Dade County Miami-Dade County Commission Digital Agendas
The Digenda application provides a paperless alternative to the Miami-Dade County Board of County Commissioners (BCC) official Legislative Agenda business process.
An important goal of Miami-Dade County and the Miami-Dade County Information Technology Department (ITD) has been to promote and encourage the implementation of "paperless" solutions to many of their business processes. After a preliminary analysis, ITD has recommended that this "paperless" model would offer considerable benefits to the BCC legislative process; by providing better productivity, accessibility, and document organization. In addition, the primary focus for the implementation of the Digenda application was to implement the use of emerging mobile technologies to augment the BCC legislative process. This technology includes the use of the latest mobile device features for pushing notifications and instant updates. The resulting benefit for the BCC is that they would have the unprecedented ability to receive, review, and act upon instant legislative process status alerts from a central location.
Digenda's main purpose is to replace a paper driven process with one that takes advantages of the latest mobile technology to better serve the Miami-Dade County Board of County Commissioners (BCC).
Miami-Dade County Solid Waste Citizen Mobile Application
The Miami-Dade County Department of Solid Waste Management (DSWM) provides several waste removal related services for more than 340,000 of its residential and commercial customer accounts. DSWM provides access to a variety of information and services via the County's public web portal. The creation of a mobile application that expands on the existing online offerings and facilitates customer access, especially during emergencies, particularly during hurricane season, as demonstrated during the Hurricane Irma response and cleanup effort.
Miami-Dade County The Making of the New miamidade.gov
Miami-Dade County is transcending traditional perceptions of unresponsive government by listening to its customers and offering streamlined service and information delivery with the launch of a new miamidade.gov. Through in-depth analysis of data and ongoing customer engagement, miamidade.gov was rebuilt from the ground up. Miami-Dade County is moving boldly toward a hyper-connected environment where everyone and everything communicates seamlessly: person to person, person to machine and machine to machine. In this way, Miami-Dade County is upholding a principal goal in its mission: to improve the customer service experience.
Montgomery County Enterprise Service Bus – Pentaho Kettle Implementation
The Montgomery County, Maryland, Department of Technology Services (DTS) developed and operates an enhanced Enterprise Service Bus (ESB) that provides automated data transfer and integration services for the Enterprise. The enhanced ESB was developed using an open source software tool / framework called Pentaho Kettle.
What distinguishes the County's enhanced ESB from most traditional ESB implementations is the fact that Kettle operates without a traditional ESB engine, such as Mule, which has inherent restrictions and limitations. The County has achieved the following results by leveraging Kettle:
City of Bellevue Utilities Mobile Mapping Solution
Leveraging Commercial Off-The-Shelf (COTS) vendor solutions while meeting customers' unique business needs is an ongoing challenge for local government IT departments. In 2018, the City of Bellevue piloted a companion application model. Instead of customizing the vendor application, the team developed a separate companion mapping application that works together with the vendor application to provide a seamless user workflow. The City of Bellevue uses IBM Maximo for asset management and vendor application InformerWM for mobile work order management. While InformerWM is designed to provide a mobile interface to Maximo, the map view does not meet user needs. The City of Bellevue’s Information Technology Department developed a web mapping application providing the context and functionality that the Utilities department staff can use together with InformerWM. The mapping solution was accomplished through low-code development utilizing COTS products such as Latitude Geographics’ Geocortex and Esri's ArcGIS technologies. With the companion application model and low- code development, the overall application reliability has been higher and the maintenance cost has been reduced.
Miami-Dade County The Adopt-a-Tree GIS Application Suite
The Miami-Dade Information Technology Department developed a series of focused applications to support the Regulatory and Economic Resources (RER) Department Adopt-a-Tree program. The Division of Environmental Resources Management (DERM) is responsible for managing Adopt-a-Tree. The program is designed to strengthen the condition of our community's tree canopy. Miami-Dade singlefamily and duplex homeowners are eligible to adopt two free trees every year. More than 209,301 trees have been adopted since the program's inception in 2001 with an average of 6,000 adopted trees processed annually. The Information Technology Department (ITD) in conjunction with the Regulatory and Economic Resources (RER) developed a strategy and implemented a suite of solutions that would automate and integrate all components of the Adopt-a-tree program. These solutions helped streamline processes, automate paper intensive workflows, and eliminate the use of redundant legacy systems. They introduced innovative technologies such as online pre-registration, web collection, and monitoring tools. These Cloud-based GIS solutions provide a means for location analysis, data management and inventory tracking. Since its implementation, this program has been able to collect and deliver thousands of trees in a minimal timeframe allowing the citizens to skip the registration line and collect trees in a fast and effective way. The Adopt-a-Tree management team has been able to monitor the adoptions collection process in real-time. They have been able to streamline their data entry by empowering their staff thru the use of field technology meeting higher levels of service.
Montgomery County Customized Reporting Tool for the Vision Zero Web Map
Vision Zero is a nationwide effort that aims to eliminate all traffic fatalities and related severe injuries. In late 2017, then Montgomery County Executive Mr. Isiah Leggett launched a Vision Zero plan to eliminate severe and fatal traffic collisions on Montgomery County, Maryland, roads by the year 2030.
In support of this effort, the County's Department of Technology Services (DTS) – Geographic Information Systems (GIS) team (DTS-GIS) created a Vision Zero map application that aims to allow County residents the ability to inform County decision makers about issues on County roads that they consider dangerous. A dozen or so roadways and intersections with dangerous conditions are now able to be reported to County departments via the Vision Zero map. Appropriate actions can then be taken by County Department of Transportation (DOT) staff to cure roadway hazards that might contribute to traffic accidents.
Roanoke County County of Roanoke, VA VoterView Web Mapping Application
Roanoke County, Virginia's VoterView application is a customized solution that addresses the County’s need to empower their citizens to locate their election polling place and obtain information about current elected officials. The VoterView app was created from the ground up with accessibility in mind, and an emphasis was placed on integrating the latest technologies to ensure mobile compatibility and the use of location services.
The VoterView app offers government transparency to its citizens, by including contact info, polling place information and detailed voter information in an easy-to-use and mobile solution. Citizens and staff are no longer tied to desktop computers, as the VoterView app can be used on a variety of mobile devices, from any location.
This increased ease-of-use helps streamline the day-to-day operation of staff while giving citizens access to County data whenever, and wherever, they choose. Please click on the following link to launch the VoterView application https://voterview.roanokecountyva.gov.
Roanoke County County of Roanoke, VA 3-D View Web Mapping Application
Roanoke County, Virginia's 3-D View web mapping service is a customized solution that addresses the County’s need to offer comprehensive aerial photography and oblique imagery through a simple and easy to use interface. The 3-D View app was created from the ground up with accessibility in mind, and an emphasis was placed on integrating the latest technologies to ensure mobile compatibility and the use of location services.
The 3-D View app offers a new level of government transparency to its citizens, by including a vast array of acquired public data in an easy-to-use and mobile solution. Citizens and staff are no longer tied to desktop computers, as the 3-D View app can be used on a variety of mobile devices, from any location.
This increased ease-of-use helps streamline the day-to-day operation of staff while giving citizens access to County data whenever and wherever they choose, utilizing the custom autocomplete quick search based on County of Roanoke address and parcel locations. Please click on the following link to launch the 3-D View application https://gisweb.roanokecountyva.gov/3DView/index.aspx.
Roanoke County County of Roanoke, VA TriView Web Mapping Application
Roanoke County, Virginia's TriView web mapping service is a customized solution that combine Google Maps, Google Street View Eagleview’s Pictometry imagery into one embeddable control that utilizes a simple and easy to use interface. The TriView app was created from the ground up with accessibility in mind, and an emphasis was placed on integrating the latest technologies to ensure mobile compatibility and the use of location services.
The TriView app offers a new level of government transparency to its citizens, by including a vast array of acquired public data in an easy-to-use and mobile solution. Citizens and staff are no longer tied to desktop computers, as the TriView app can be used on a variety of mobile devices, from any location.
This increased ease-of-use helps streamline the day-to-day operation of staff while giving citizens access to County data whenever, and wherever, they choose. Please click on the following link to launch the TriView application https://triview.roanokecountyva.gov/?lng=-79.9872606&lat=37.22257456°=279.56770829.
City of Scottsdale Public Safety Radio Coverage Performance Analysis
The City of Scottsdale's radio engineering group developed a process beyond the industry standard of outbound signal testing by implementing the addition of inbound signal testing. This process required fabrication of new testing hardware plus the development of data processing functions and integrating with mapping software. With this capability the radio staff would be able to determine if the radio site infrastructure is not receiving very well, overlap areas that are not in phase causing high BER (bit error rate) and if the system is balanced for outbound signal level compared to the inbound signal level.
Radio manufactures typically use software modeling to provide RF coverage mapping to aid in system design for the proper RF coverage needed. The behavior of RF can be unpredictability from natural obstructions such as mountains, to man-made obstacles like steel buildings, signal integrity is one of the biggest concerns for public safety users. This solution would prove if the initial software modeling for predictive RF coverage was accurate.
Miami-Dade County Advanced Analytics to Improve Operations and Safety
Miami-Dade County Department of Corrections and Rehabilitation (MDCR) operates the eighthlargest jail system in the United States, with three correctional facilities. These facilities hold, on average, 5,600 inmates, who are awaiting trial or are serving sentences of 364 days or less. MDCR must continually strive to ensure the safety of inmates and staff. As part of the improvement to the programs, MDCR is analyzing available data and applying actionable insights to comply with policies and improve processes in areas such as inmate classifications, violence reduction, and grievance processing. Using advanced analytics, MDCR has validated important factors in the inmate classification system, reduced violent incidents, and improved awareness of grievance processing times.
Miami-Dade County Miami-Dade Police Department Off-Duty/Events Scheduling System
The Miami-Dade Police Department (MDPD) affords the opportunities to designated departmental employees to perform off-regular-duty service within the scope of their training and duty assignments, regardless of job classification. Individual districts, as well as the MDPD Special Events Unit, each managed the planning and staffing of off-duty jobs within their own districts using manual methods. A need was identified to centralize the location of all off-duty jobs allowing for an equal and fair distribution of off-duty work to the officers since available opportunities are visible throughout the entire department. With a centralized location of all off-duty services, officers would now be able to view all their off-duty work in one location and stay up to date with the approval and payment status of these jobs, customers can easily apply for a permit, request an off-duty job and pay for services online and the process of getting tickets submitted and approved would be streamlined thru proper channels since the entire process would be electronic rather than paperbased.
Montgomery County Implementation of a New 911 Emergency Communication System
The Montgomery County, Maryland, Department of Technology Services (DTS) Public Safety Data Systems (DTS-PSDS) team, in conjunction with the (1) Police and (2) Fire and Rescue Service led the efforts of a successful Emergency 911 Communications System implementation. This process included a competitive Request for Proposal (RFP), Requirements Needs Assessment, System Acquisition / Contract Award, Network and Server Infrastructure deployment, Geographic Information Systems (GIS) conversion, end-user Training, Site Floor Reconstruction, Integration and Systems Testing, and deployment-implementation in addition to multiple interface integrations uniquely required for the County's emergency operations function.
The County's dispatch process is a multi-faceted process that involves the systematic interview of persons accessing the 9-1-1 system. The Computer Aided Dispatch (CAD) system is the decision support scaffolding for the dispatch process. An effective CAD collates disparate bits of data in multiple formats, including GIS data, call type, and response plan data, quickly turning those individual data points into a visually and spatially coherent format that reduces the information processing needs of call takers and dispatchers, thus allowing them to engage in higher order thinking and exercise of judgment and discretion.
Roanoke County Roanoke Valley NextGen 911 PSAP Data Aggregation and Sharing
Roanoke County, along with the adjacent cities of Roanoke and Salem, have collaborated to build the foundation of NextGen 9-1-1 services across the Roanoke Valley. A consolidated and consistent Geographic Information Systems (GIS) base is vital to the success of NextGen 9-1-1, and Roanoke County led the effort to create a dynamic process to receive and feed GIS data into partner 9-1-1 systems.
"NextGen-9-1-1" represents the move from legacy analog telephony and network communications for transferring phone and addressing data for emergency communications to updated digital IP-based technology allowing more seamless communication across the 911 network and to emergency responders. Through significant coordination and adoption of technology, NextGen-9-1-1 will use unified networks and data transferability of caller and incident data between localities, for greater resiliency and reliability of services for the public, and make use of new telecommunications technologies including voice, photos, videos, and text messages. GIS data is a foundation for NextGen 9-1-1 address and location data, and routing for emergency services.
The goal of the project was to create a Real-Time NextGen-9-1-1 valid GIS dataset for Roanoke City, Roanoke County and Salem City Public Safety Answering Points (PSAP). The data included Road Centerlines, Address Building Points and/or Polygons, Emergency Service Zones, PSAP Boundaries, Authoritative (Fire and Rescue, Law Enforcement, or PSAP) Boundaries and County/Municipal Boundaries.
Each locality determined any data concerns or errors for each dataset and worked to resolve those issues into a central GIS repository to create a complete and seamless dataset accessible by public safety agencies across the Roanoke Valley. The project supports PSAP readiness for future technology and enhances the current efficiency of each municipal public safety agency.
Business intelligence and ESRI’s Portal to Portal Collaboration was incorporated into the automated process to support efficiencies in government service delivery across Roanoke County and the greater Roanoke Valley. The Portal to Portal Collaboration is a feature of ESRI Arcgis Portal that has not been implemented successfully by many customers. Roanoke County is one of the first to use the technology, in support of this project.
City of Durham Public Safety's Emergency Accessibility Plan
The City of Durham is immensely aware that safety and security is one of the key factors municipalities face daily. Our residents annually rate safety and security as one of the most important issues to them and their families’ year after year on our citywide survey for residents. With the heightened fear surrounding random acts of violence along with coordinated attacks, police departments around the country remain on high alert daily. Couple this with the increased speed at which information is expected to be transmitted out to the public in real time, the accessibility of information is paramount to protecting citizens in a myriad of different ways.
For the reasons listed above, the City has continued to make substantial investments in Public Safety and Cyber Security year after year. Apart from opening a new state of the art police headquarters in the heart of downtown Durham, city leadership has recognized that there’s still more to do. Additionally, public safety was one of the five goals highlighted by our City Council this fiscal year. That directive has caused us to become even more cognizant about accessibility for first responders in the event of an emergency.
City of Scottsdale Emergency Operations at the PGA Waste Management Phoenix Open
The Waste Management Phoenix Open (WMPO), a PGA Tour golf tournament, has taken place each year at the TPC Scottsdale golf course located in Scottsdale, Arizona, since 1987. This event draws extremely large crowds with the week-long total attendance totaling nearly 750,000 spectators with over 250,000 attendees on the Saturday of the event alone.
The Scottsdale Fire Department (SFD) is responsible for the safety and well-being of the golfers, media, event workers, and spectators. Each year, SFD stages an onsite Command Center from which, on any given day of the event, they dispatch over twenty-five teams of paramedics, patrolling the course by foot, bike or medical cart. Event attendance and the supporting infrastructure continue to grow year after year making it more difficult for the SFD dispatchers to manage their field personnel. Historically, personnel were managed by paper maps and memories of past tournaments.
Fire Command staff who worked the event for many years were interested in finding a technology solution for situational awareness and managing emergency medical response at the 2019 WMPO. A small team of City staff from GIS/IT and SFD joined together to implement a mobile GIS solution that would fill this need. Using existing ESRI ArcGIS software and technologies (Survey 123 & WorkForce) the team deployed a solution that allowed the SFD dispatcher to dispatch the closest appropriate paramedic unit to any incident and provided incident command staff with a dashboard of active incidents within the event.
Miami-Dade County eCitation
The Miami-Dade Police Department (MDPD) implemented the eCitation application on January 8, 2018. eCitation provides officers the ability to create citations electronically. The officers are able to create the citations and select the correct statutes. The application determines what the fine amount is or whether the driver needs to attend court. The officer is able to print the citation and give it to the driver. The information is electronically sent to Clerk of the Courts (COC) and Miami Dade's Crime Data Warehouse (CDW).
Miami-Dade County Metro-Bus Work Order Implementation
Miami-Dade Metrobus Maintenance modernized the technology used to repair and conduct preventative maintenance on its fleet of busses from a legacy mainframe system to Infor EAM (Enterprise Asset Management). Infor EAM is the enterprise asset management software tool used by the county for asset tracking, work management, equipment management, materials management and condition assessments of assets. The project leveraged the Internet of Things (IOT) devices from the EJ Ward Fueling system to capture mileage and the Computer Aided Dispatch/Automated Vehicle Locator (CAD/AVL) systems and devices to automate data collection for scheduling preventative maintenance and repair work orders.
This modernization of processes along with the use of IOT devices centralized information for the maintenance staff and facilitated their operations with tasks such as determining which equipment requires maintenance, assessing symptom versus repair codes, and determining effectiveness of work on reliability of vehicles. With the use of its internal analytics and real-time reporting, the EAM system enabled management to make informed decisions with regards to total operating cost, total repair cost, and even replace versus repair costs of an asset. Inventory parts and warranty information are tracked and managed in EAM as well, rounding out the complete solution.
The clients for this project were to be hundreds of Transit staff in the following groups:
The main beneficiaries of this projects are the county constituent who daily use the fleet of 850+ Miami-Dade County Buses.
Miami-Dade County ECM GIS Integration for Environmental Resource Management Permitting
The Division of Environmental Resources Management (DERM), within Miami Dade County's own Department of Regulatory and Economic Resources (RER), permits tens of thousands of facilities which have the potential of impacting South Florida's sensitive environment. RER DERM's electronic content management system (ECM) is used to retrieve content from over 45 environmental programs which accomplish the task of regulating such facilities under Chapter 24, the environmental code of Miami-Dade County. By modifying an existing open source based ECM solution, the County staff was able to integrate Geographical mapping and spatial visualizations with existing data already accessible to the public through the OpenData Portal. The deployed solution enables inspectors to view permitted facilities via digital aerial photography or standard street maps along with pertinent electronic content such as surveys, permits and supporting documentation. In addition, inspectors can ascertain possible environmental impacts by viewing the location and description of other permitted facilities in close proximity. The map can be used to recursively search neighboring facilities and retrieve content, without the need for address or location information. The end user goes to just one single application that provides comprehensive functionality and stays current.
Miami-Dade County GOING GREEN & MOBILE
To use existing computer/network technologies to report federally and state-mandated client assessment information in real time to the grantor by entering data directly into the state's web-based Client Information and Registration Tracking System (CIRTS).
Miami-Dade County Hauler Registration System Modernization
The Miami-Dade County Department of Solid Waste Management is required to track the activities of businesses that remove, collect or transport solid waste or recyclable material, or sell, trade, or transfer new or used tires within any unincorporated area of the County. To comply with this statutory requirement, the department issues permits for the businesses that perform these functions and ensures that they comply with the relevant statutes.
Replacing its obsolete predecessor, the modernized Hauler Registration System manages the entire permitting operation including: the application process, renewals, document generation, general notifications, vehicle assessment, and classification and permit charge assessment.
These changes have resulted in improved customer service and a streamlined, almost completely automated business process.
Roanoke County County of Roanoke, VA FloodView Web Mapping Application
Roanoke County, Virginia's FloodView application is a customized single-focused solution that addresses the County's need to offer comprehensive flood information through a graphical and simple user interface. The FloodView app was created at the start with accessibility in mind, and an emphasis was placed on integrating the latest technologies to ensure mobile compatibility and the use of location services.
The FloodView app offers a new level of government transparency to its citizens, by including a vast array of public data about floodways, flood plains, land, tax parcels, building values, land values, DFIRM panels, flood certificates and flood zone status in an easy-to-use and mobile solution. Citizens and staff are no longer tied to desktop computers, as the FloodView app can be used on a variety of mobile devices, from any location. Most importantly, the app was utilized to achieve credits for Citizen Outreach for flood mapping in FEMA’s Community Rating System (CRS).
This increased ease-of-use helps streamline the day-to-day operation of staff while giving citizens access to County data whenever, and wherever, they choose. Please click on the following link to launch the FloodView application https://gisweb.roanokecountyva.gov/floodview/.
City of Durham Building the City's Open Data Program and Data Analytics Capacity
Both public and private organizations are increasingly sophisticated in their use of data. Among the primary emerging uses of local government data are (a) delivering the public unprecedented transparency through data and (b) informing decision-making through clear and advanced analytics. In the City of Durham, the Technology Solutions' Open Data Program is driving forward processes aimed at both objectives. Through re-conceptualizing Durham's open data portal and associated policies, establishing a City-wide Data Academy to build internal capacity, and leading data-related projects with the potential for high-impact on residents, Technology Solutions is helping the City address critical challenges through the use of data.
Greater Cleveland Regional Transit Authority Procurement Card Business Intelligence Auditing
In a technology driven era, big data enables auditors to understand patterns, behavior, opportunity, and risk in their organization. Internal Audit can capture immense benefits by supplementing traditional practices with continuous auditing techniques to meet today's fast-paced demands. By using computerized scripts to automate controls tests and risk monitoring on a frequent basis, Internal Audit can provide high response-time assurance on controls effectiveness. With a low-cost investment in appropriate software and training, our organization is able to analyze 100% of transactions to assess controls, using techniques such as policy compliance, identifying potential fraud/waste/abuse red flags, merchant compliance, and validate data entry in seconds versus weeks.
The next step we’ve begun is expanding the technique to multiple areas of the agency to be able to make data driven decisions to improve efficiency with a particular focus in areas that impact our customer experience.
Miami-Dade County Transportation Trusted Data Platform
The Transportation Trusted Data Platform (TTDP) was developed for the Department of Transportation and Public Works (DTPW) as an integral part of the Miami-Dade County Transportation Smart City Mobility Architecture which will include a network of smart ecosystems. DTPW is currently undertaking several technology initiatives that will introduce real-time, large-scale streams of data from IP based smart sensors and devices. The TTDP will be the instrumental in integrating and managing these new internet of things (IoT) datasets with existing operational data. The TTDP is a comprehensive solution that allows DTPW to leverage large operational data for decision making to improve the mobility of the residents and visitors of Miami-Dade County.
Existing transportation datasets include vehicle location and telemetry, operator assignment and workforce availability, asset management, ridership, on-time performance, fare collection, customer feedback and travel times. Future IoT datasets will include Bluetooth beacon and sensor data from smart bus shelters, the Advanced Traffic Management System (ATMS), smart streetlights and smart traffic signals.
The TTDP provides Miami-Dade County Transportation business analysts, management and thirdparties self-serve access to data generated by existing and future operational systems.
City of Bellevue Water Quality Dashboard for a Smart City
Bellevue is pursuing a Smart City plan to improve quality of life, sustainability and resiliency. Advances in sensors, devices and controllers connected to the internet (Internet of Things) and producing data for analysis are being leveraged to improve operations and services. The 'drive with data' strategy of the smart city plan is being realized in the water quality operations of the Bellevue’s Utilities Department. Bellevue provides a water utilities service for over 40,000 residents and businesses and operates a water system composed of 606 miles of water mains, 24 reservoirs, 22 pump stations and 62 pressure zones. To ensure quality sensors reporting coliform bacteria, temperature, pressure and chlorine come from various systems and sources. The Water Quality Dashboard synthesizes all this data to give operations staff a view on real-time status and trends over time to achieve its mission of delivering high quality and reliable water services to the community. The Water Quality Dashboard consolidates data streams from the Utilities Department supervisory control and data acquisition (SCADA) system, Seattle Public Utilities laboratory information management system (LIMS) and the City's work order and asset management system (Maximo). The Water Quality Dashboard is the first module to be released of a comprehensive Smart City dashboard.
Durham County DCo DSS Uses Predictive Analytics to Strengthen Foster Care
In Durham County—and nationally—the number of children in foster care is consistently and sharply increasing. This impacts critical points within the system including caseworkers, foster caregivers and other items tied to County budget and resources. The business challenge faced by Durham County is to predict the number of children who will need help. This will allow the County to adjust these critical resources in advance to better match resources necessary to smoothly provide high-quality services to address fundamental needs--education, physical, mental health, safety and well-being—while establishing a permanent plan for the care of the child.
Durham County DSS implemented predictive model testing analytical tools to enable fact-based, analytical predictions, versus estimates based on opinions.
Miami-Dade County Miami-Dade County Public Housing Vacancy Compliance Portal
Employees of the Miami-Dade County Public Housing and Community Development are required to validate their data against the data maintained by the U.S. Department of Housing and Urban Development (HUD). Up until this point, this required Miami-Dade County employees to compare each data set manually. This process was inefficient, time consuming, and prone to error.
The Miami-Dade County Public Housing Vacancy Compliance Portal has provided County employees with a user interface that allows them to efficiently review and compare data from both their internal and HUD systems through Miami-Dade County's latest modernization efforts and business process automation, all while utilizing the latest, best-of-breed web development technologies.
This project entailed the import and comparison of multiple sources of data from Miami-Dade County internal systems and HUD in order to easily identify discrepancies and provide actionable data for operational staff through a user-friendly interface; removing the use of spreadsheets and significant man hours in the identification, tracking, and resolution of those discrepancies. In addition, it provides key metrics and reports from these datasets that provide enhanced business intelligence/insight.
The application also integrates the unit data with street view maps, giving the field agents and other operations staff the ability to view the public housing units. This was an added feature that was very well received and provided good value to the staff.
Montgomery County Data Center Systems Monitoring
The Montgomery County, Maryland, Department of Technology Services (DTS) implemented a new Systems Monitoring tool in the Enterprise Data Center called Zabbix. Zabbix allows for real-time monitoring of all equipment (network equipment, servers, storage, security systems, telephony systems, and environmental controls). This effort is intended to ensure 100% uptime for all systems critical to County operations and provide immediate notification and reconciliation of any system outage.