Planning Mapping Tool
The primary objective of the project was to fully automate mapping functions associated with the entitlement process. The secondary objective was to implement a solution considered to be scalable and that can accommodate changes to the business function. The successful project provided an automated solution that addresses limitations in the existing mapping application (ArcReader) while providing a stable and scalable platform to meet future needs.
Tree Management Software
In 2007, the City of Roseville developed an Urban Forestry Work Plan, which begins with assessing the current condition of the City’s urban forest. Therefore, one of the Urban Forester’s first tasks was to conduct an inventory of the community’s forest. An inventory is the best foundation for an active and productive urban forestry program. A full tree inventory will give the urban forest management team and local residents vital information about tree diversity, size and age classes, condition, location, maintenance needs, pests and diseases, overhead utilities, planting spaces, hardscape damages, and potential hazards. Moreover, with this information the Urban Forester can allocate resources appropriately to the various tree management functions.
A software solution is required to efficiently and cost-effectively manage the tree inventory. In order to properly manage the City’s natural resources including the urban forest, a fully functional tree management and tree inventory software was essential. Furthermore, this software was absolutely necessary to analyze the City’s urban forest in order to develop long and short term management plans such as pruning and reforestation plans.
Traffic Mobile Device
Traffic Signal Operations technicians need to be able to access and manage the Advanced Traffic Management Systems (ATMS) while in the field. Limitations of laptops include the need for physical connections (challenging in bucket truck), not readily available, lengthy startup times, mobility, sunlight readability, ruggedness, cost, and battery life. These limitations impact how responsive technicians can be in managing the system while in the field and on call. The objective of this project was to provide handheld wireless mobile devices to Traffic Signal Operations technicians with secure access into the ATMS network. This gave technicians the ability to manage the system more effectively with a single, small form factor device that they carry with them at all times.
Power Partners Hosting Agreement
As of 2010, Roseville Electric was contracting with an outside vendor for hosting services associated with the “Power Partners” demand response program. Power Partners is a voluntary program that allows Roseville residents to help reduce peak energy use during hot summer months. These residents agree to have wireless control devices attached to their air conditioning units, which can be used to cycle the unit off and on during peak energy periods. The outside vendor hosts the software necessary to initiate and terminate cycling activities. Roseville Electric staff directs these activities via a web-based portal provided by the vendor.
This project focused on determining the initial and ongoing costs to move this function in-house prior to the end of Fiscal Year 2011. This included an analysis of the expertise and equipment needed in order to provide the same level of service provided by the outside vendor.
During a flood threat, the City’s Emergency Operations Center (EOC) requires real time radar, satellite and access to National Weather Service issuance of watches and warnings information. This data is integral to the City’s Flood Warning and Response Plan. The Department of Public Works, Floodplain Management Section currently possesses and maintains software that collects radar, satellite, and NWS warning data. This software publishes the data on custom generated maps, focusing on the flood threat within the Roseville area.
The EOC staff would have real-time access to “flash movie loops” of radar and satellite imagery overlaid on maps focusing on the Roseville area. These loops can display a wide variety of information that will provide EOC staff with current and comprehensive weather information in a concise format. EOC Staff will also have necessary weather and NWS warning and advisory information at their disposal in a format that focuses on current flood threat in Roseville. Direct access to this data will provide the EOC staff with the information required to implement the emergency service procedures described within the City’s Flood Warning and Response Plan.
Police Mobile ID
This project deployed 30 handheld PC’s to Police that perform mobile thumbprint identification of subjects (Mobile ID) as well as performing electronic citations in the field (e-Citation). This enabled officers to identify subjects of interest using their thumbprint, as well as write citations by scanning driver’s license and vehicle registration (barcode) information. Records clerks receive the information on a computer screen rather than paper citations.
Information Security Compliance
The City needs to conform to several security mandates across different business functions. The City should have a thorough understanding of those requirements and ensure we are compliant. However, the mandates are complex and change often. We need a baseline analysis of our current security state, compared to a state of compliance, and prioritize the steps to become compliant.
The objective of this project is to develop a Request for Proposal (RFP) to identify which of these laws and regulations are mandated for the City; what best practices should be followed; to identify and classify critical data, and to draft and implement necessary practices and policies.
The City needs to understand the gap between our current security standards compared to the mandates listed above. We need an expert who is knowledgeable about the applicable regulations and mandates and can document the most effective path to compliance. It is recommended that a Request for Proposal be developed to perform a gap analysis and direction for the City.
9-1-1 Replacement Digital Recording System
At this time, the technology was old, inadequate, and unable to support the environment. The need for a fully redundant system was clear. This replacement project substituted outdated and no longer manufactured or supported back-up systems. This positively impacted the I.T. Department, as they no longer needed to fund a back-up system nor spend resources on maintenance.
Library System Upgrade
Integrated Library Systems (ILS) are databases that store, organize, sort and retrieve all the information concerning a library’s materials and customers. ILS also facilitates transactions between libraries allowing customers to borrow materials from different libraries. In short, an ILS is the backbone that allows a library to function and share information with other libraries.
This project was intended to replace the outdated library system, which was difficult for customers to use. It did not include features they had come to expect elsewhere, such as the ability to share their reading lists, or be notified when new books are added. Customization was difficult for staff to undertake, and not supported by the vendor. In order to add features, costly third-party solutions are required to extend usability until a replacement is implemented. The replacement would be easier for customers to use. It allows them to communicate in ways they expect such as texting and social networking. It has the functionality they have come to expect in the greater Internet and software in general. It is cost-effective, and allows staff to easily create, modify, or change the software to suit customer needs. It is open and flexible to accommodate changes in computing and library operations. An easy-to-use and cost-effective solution will help the library meet the City Manager’s initiative by ensuring the Library is “open for business”.
Consumer Technology Pilot Project
There is a growing demand for certain consumer technologies to be used for business by City of Roseville Employees. As a result the IT Department developed a pilot project to determine the feasibility of implement strategic technology solutions utilizing consumer type technology.
- Identify business opportunities
- Identify a management solution (to manage the technologies)
- Identify security concerns/solutions
- Develop policies and procedures
- Identify support needs
Emergency Operating Center
Lessons learned exercises from the recent Emergency Operations Center (EOC) activations have highlighted the need to include all departments in the EOC function. The Fire Department has organized a citywide committee chartered to develop cross-functional capabilities for the EOC. The committee will be responsible for developing emergency plans that must comply with State and Federal guidelines. The purpose of this concept is to streamline the emergency planning process.
The intent of this project is to implement a web-based GIS application to provide a single common display of relevant EOC information and the status of important City infrastructure. There currently is not a common view of information. Information and status are compiled using multiple applications, tools, and data sources. After the project is complete, a single source of information will be available. This Common Operating Picture facilitates collaboration when the EOC is activated and assists all functions of the EOC to achieve situational awareness. The current emergency planning process is manual (word documents) – and done by a small group of experts that know how to develop the plans.
With a larger committee of inexperienced emergency planners – a tool that guides the process and develops State/Federal compliant plans is crucial. The website will help ensure quality planning and will make it easier to bring new committee members in with minimal training.
The City of Roseville, California (the “City”) has implemented strong water demand reduction measures and is on track to comply with the 20% by 2020 Water Conservation Plan (20% by 2020 Plan) target of 247 Gallons Per Capita Per Day (GPCD). The City’s primary goals are to: (a) use water efficiently and eliminate water waste; (b) maintain water conservation goals consistent with the 20% by 2020 Plan and the California Urban Water Conservation Council (CUWCC); and (c) incorporate social norms to optimize water conservation programs.
The City has requested a proposal for services that would engage WaterSmart to provide a communication and outreach program intended to reduce annual water demand by residents of single-‐family homes (the “Customers”), increase participation in the City’s water conservation programs, and improve the City’s understanding of their residential customers’ water use (the “Program”).
Project Management Office
Currently IT Planning and Administration offers project management templates, training and mentoring to our staff running projects. We are looking at expanding the support and services we offer by creating a Project Management Office (PMO). We are researching to create a plan on the best approach to developing a PMO office to meet our needs today as well as grow the PMO to meet the needs of our future dynamic organization. An outcome of this research project will be a PMO Charter.
Initially we would be looking at offering a services and support based PMO office. This would allow our culture to better understand the value and to grow our staff expertise in the field of project management. As our organization matures in the area of project management we would look at increasing the portfolio management components.
Areas we will be exploring for the initial release are listed on our website.
Web Conferencing Service
The objective of a Web Conferencing Service is to improve efficiency, collaboration, and communication, as well as eliminate travel time between meeting sites.
A basic cost saving analysis: 10 meetings with 5 individuals per day / driving across town at an average of 10 miles apart – may contribute to ~$555 per day in fuel and maintenance cost, multiply by ~200 working days on 30 minutes’ drive time = approximately $111,000 to $500,000 cost avoidance
Following a presentation to the Technology Users Group discussing web conferencing, a team was formed to investigate options, features, and pricing of available solutions.