Loading...
HomeMy WebLinkAboutAddendum 1 - RFP - 10134 Public-Facing Water Quality Data Visualization DashboardAddendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard ADDENDUM NO. 1 Description: RFP 10134 Public-Facing Water Quality Data Visualization Dashboard Bids Due: 3:00 PM MT on April 1st, 2025 To all prospective bidders under the specifications and contract documents described above, the following changes/additions are hereby made and detailed in the following sections of this addendum: Exhibit 1- Questions and Answers Please contact Moutaz Badawi, Buyer II, at abadawi@fcgov.com with any questions regarding this addendum. RECEIPT OF THIS ADDENDUM MUST BE ACKNOWLEDGED BY A WRITTEN STATEMENT ENCLOSED WITH THE RFP STATING THAT THIS ADDENDUM HAS BEEN RECEIVED. nd Floor 970.221.6775 970.221.6707 fcgov.com/purchasing Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard Exhibit 1 Questions and Answers 1. What are the specific technical environments and platforms preferred or currently in use by the client? Power BI is our reporting tool. Data is stored in Azure Synapse Data Lake 2. Are there existing systems that need integration, and what are they? The system will integrate with the Poudre Water Quality Network (PWQN), which consists of eight real-time water quality monitoring stations. The data is stored and processed in the City’s cloud-based data management platform, Microsoft Azure. 3. What are the data security requirements for APIs and web solutions? The service provider must ensure secure web communications, role-based logical access control, secure data transfer, incident response, vulnerability assessments, and network monitoring. 4. Are there any specific compliance standards applicable? The project must comply with ADA accessibility standards, Colorado’s Privacy Act (C.R.S. § 6-1-1301), and the State’s Accessibility Standards for Individuals with Disabilities. 5. How should scalability and high availability be addressed within the proposed design? The dashboard should be designed with future growth in mind, allowing for additional data sources as additional water quality meters may be added to the network. Since these will be public facing design for Power BI security, settings and load tracking/limiting is necessary. 6. What is the expected project timeline and milestone requirements? The project is expected to be completed in 12 months with the following milestones: • Dashboard Needs & Requirements: Apr – Aug 2025 • Dashboard Design & Development: Aug 2025 – Apr 2026 • Data Integration: May 2025 – Dec 2025 • Dashboard Usability Testing: Mar 2026 • Training & Documentation: Mar – May 2026 • Public Launch: Apr 2026 7. Who is the primary stakeholder, and what is their decision-making process? The City’s Communications and Engagement Team (C&E Team) will lead stakeholder outreach and engagement, with technical support from the service provider. The public- facing data dashboard is intended to share PWQN data with community members, City water resource managers, and researchers. The selected consultant will engage with the City project manager and core project team in the decision-making process to ensure the project meets the needs of its stakeholders while aligning with the project goals, budget, and timeline. Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard 8. Are there specific reporting structures or documentation standards required? The service provider must provide: • User manuals and technical documentation • Training sessions for City staff on dashboard use and maintenance 9. What are the risk management and mitigation expectations? It is expected that the selected consultant work with the City’s core project team to document risks and identify strategies to mitigate these risks. 10. How does the client prefer to handle change management and project updates? The City prefers a structured and transparent approach to change management and project updates. The City’s project manager will work with the selected consultant team’s project manager at the beginning of the project to establish a routine communication schedule and identify communication tools to share project status updates and changes that may occur throughout the project. Any change requests for work outside of the contracted scope of work will require a formal process. Updates, decisions, and change requests will be documented for future reference and accountability. 11. Are there any existing brand guidelines or design standards to follow? The selected consultant will be required to work within the City’s brand guidelines and design standards. 12. What are the key user personas or target audience profiles for the solutions? The dashboard is intended for the general public, researchers, and resource managers to access and interact with water quality data. 13. Are there specific accessibility requirements to meet? The dashboard must comply with ADA accessibility guidelines and provide English and Spanish language support 14. Does the client have any preferences for UX/UI practices or frameworks? Standard Power BI visuals are preferred. Custom are allowed if they meet security requirements and are externally maintained. 15. Are there existing design assets or libraries that need to be used or referenced? Data will be available in ADLS Gen 2 and may be moved to a Dedicated SQL Pool if necessary. 16. What was the annual spend for the previous year on this Project? There is dedicate budget to operate and maintain the water quality monitoring stations at $50K per year. The build out of the database management system was a collaborative effort between Colorado State University (CSU) and the City’s IT Department. The estimate in-kind cost for CSU’s time to build and integrate data workflows and pipelines was approximately $30K. 17. Are you open to a hybrid delivery model with a mix of offshore and onshore resources? Yes. Offshore resource must be discussed with the City prior to any work conducted. Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard 18. Work will be onsite or remote? Work can be performed remote. 19. The PWQN data is already stored in the cloud. Should the dashboard be built directly on this existing data, or should the solution include data integration, validation, curation, and management before it is made available for visualization? Yes, the dashboard will be built directly on the existing data. Data workflows and pipelines have already been established to assure and control the quality of the data prior to the data being stored in the data lake and displayed to the public. Additional data processing maybe required to meet the dashboard requirements (i.e. hourly averages) and the consultant will work with the City’s IT Department to meet these requirements as allowed by the project goals, timeline, and budget. 20. Does the City require a workflow where ingested data undergoes a review process before being displayed to the public? If so, who would be responsible for reviewing and curating the data? Data workflows and pipelines have already been established to assure and control the quality of the data prior to the data being stored in the data lake and displayed to the public. Additional data processing maybe required to meet the dashboard requirements (i.e. hourly averages) and the consultant will work with the City’s IT Department to meet these requirements as allowed by the project goals, timeline, and budget. 21. Will the final dashboard solution be hosted by PWQN, or is the vendor expected to provide hosting services? The final dashboard solution will be hosted and operated and maintained by the City’s IT Department. The consultant is responsible for providing any documentation that will support on-going dashboard operations and maintenance. 22. Is there an existing dashboard of any kind for the PWQN? How are the data currently viewed and accessed? The source data are currently viewed in HydroVu, a data platform provided by the water quality instrument manufacture, In-Situ Inc. Data workflows and pipelines have been established to pull data from this platform into the City’s Microsoft database management solution. 23. We assume that the water quality data collected is stored in the Cloud. Will the consultant have, and how specifically, will they gain access to the data? Yes, the data are processed and stored in Microsoft Azure. The selected consultant will work with the City’s IT Department to gain accessed to Azure. 24. For the deliverable, will the consultant be working through the City’s Power Bi platform? Or is the consultant expected to build the dashboard on their own platform, and hand over the deliverable to the City at the completion of the project? The dashboard must be built using the City’s Microsoft Power BI platform. Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard 25. Would there be interest or consideration of a ESRI GIS dashboard, versus Power Bi? Yes, if a GIS dashboard meets our stakeholders’ needs and requirements. The consultant would need to present, in detail. the data movement and processing, and complete that work. 26. Will the consultant be integrating directly with any City or State (CSU) networks, or just receiving data directly through the Cloud? All data for the dashboard will be processed and stored in the City’s database management solution, Microsoft Azure. 27. What is the "existing database architecture"? (AWS, Google, MS) Is the data from the 8 water quality stations The existing database architecture built within the Microsoft Azure environment. The data from the eight water quality stations are processed and stored within this database management system. 28. Is the city expecting a flat cost for this work or an hourly rate with a not to exceed amount? The project budget must not exceed $45,000, and the service provider cannot charge more than 10% overhead. 29. Section D estimates this as a year-long project but section F provides a budget limitation of $45,000. Is this correct? Yes. 30. What are the different data sources that will be integrated into the dashboard The primary data source that will be integrated into the dashboard is water quality data collected by a network of real-time sensors collecting various in-stream water quality measurements. Additional, data sources may include other hydrometeorological data (temperature, precipitation, streamflow, etc.) but this will be determined by stakeholder requirements. 31. Can you provide details on the types of data sources (e.g., real-time sensors, historical databases, external APIs) The current data sources include data from eight real-time water quality meters and historical data (2018-present) from these stations. These data are pulled into the City’s database management system via HydroVu’s API. HydroVu is the current data viewing platform provided by the instrument manufacturer, In-Situ Inc. 32. What is the format of the data from each source (e.g., CSV, JSON, XML) Parquet files. 33. What is the approximate size of the data that needs to be visualized on the dashboard? Is there a trend of growing the database size, if yes please share details. The eight water quality monitoring stations collect data every 15 minutes for a minimum of four water quality parameters. The size of the data that needs to be visualized will Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard depend on the stakeholders’ needs and requirements (i.e. 15-minute data vs. aggregated data). 34. What type of database is currently being used to store the data (e.g., RDBMS, NoSQL) Microsoft Azure 35. Are there any specific database technologies or platforms being used (e.g., MySQL, PostgreSQL, MongoDB)? Azure Synapse, ADLS Gen 2 36. How frequently is the data updated or refreshed The data are collected every 15 minutes and pulled from the HydroVu API into Microsoft Azure every three hours. 37. Are there any data quality checks or validation processes in place for incoming data Data is automatically checked for quality and control before being made available. 38. What are the key parameters and metrics that need to be visualized on the dashboard pH, temperature, specific conductivity, dissolved oxygen, water clarity, and chlorophyll-a. 39. Are there any specific requirements for data security and access control? This would need to be discussed with the City’s IT department. 40. How many users are expected to access the dashboard concurrently? The dashboard will be public-facing and at this time we do not have an idea of how many users will be accessing the dashboard concurrently. 41. Are there any performance benchmarks or requirements for data visualization and interaction Currently, there are no performance benchmarks. The requirements for data visualization will be determined through targeted stakeholder outreach and engagement efforts at the start of the project. 42. What is the expected load on the system during peak usage times? The expected load is currently unknown since this is intended to be public facing and usage could fluctuate. 43. Are there any existing APIs or data integration tools currently in use? Yes, In-Situ Inc.’s HydroVU and Microsoft Azure. 44. Are there any specific compliance or regulatory requirements related to data handling and visualization? The City has standards relating to City branding, which will be supplied by City to Service Provider. Service Provider shall adhere to the branding standards in performing the services required by this Agreement. Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard 45. Do you expect this to be a COTS Solution, or can it be a custom-developed solution we build specifically for you? COTS 46. Can you please provide more detail on city’s existing data management platform? Microsoft Purview is used to inventory data for data governance. 47. What are all the data source systems need to be integrated with the Power BI dashboard? Please provide the list. Azure Synapse is our analytics platform and will hold all data sets necessary for this reporting effort. 48. Do you have any real-time streaming data sources? If yes, please specify. No 49. Can you please list the third-party tools that needed to be integrated? None required 50. Do you have any data warehousing requirement? If yes, do you have any preference in terms of technologies (Azure SQL DWH, AWS RedShift, etc.,)? Tools available in Azure Synapse will be considered. Data is housed in ADLS Gen 2 with no expectation of using anything else between that and Power BI. 51. Who will be responsible for managing the hosting of the solution? The City’s IT Department. 52. How many users do you have? Please provide the internal and external users who utilize this system? The dashboard is intended to be used by the general public, internal City water resource managers and researchers. We do not have an idea of how many users will be accessing the dashboard at this time. 53. Who are the primary stakeholders collaborating with the vendor, and what are their roles? The project manager and core project team, which include the City’s IT Department and communications, engagement and marketing team. 54. How many dashboards is the vendor required to develop? One. 55. What are the expectations and timeline for ongoing support and maintenance after the solution implemented? The dashboard will be hosted, operated, and maintained by the City’s IT Department after the solution is implemented. The consultant will be responsible for providing any documentation and training to support on-going operations and maintenance. Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard 56. Do you expect the vendor to perform any tasks on-site, or can all work be performed remotely? All work can be performed remotely. 57. Do you accept off-shore resources for this project? Yes. 58. Will the service provider be granted access to connect to the data within the City’s cloud- based data management platform? Yes. 59. If so, what are the available data access options? Does the platform provide API access, or will there be direct connection options to the database(s)? There will be direct connection options to the City’s database management solution, Microsoft Azure. 60. What types of future data sources should be considered for compatibility (e.g., APIs, data lakes, other third-party integrations)? Microsoft Fabric 61. What are the expected future data types (structured, semi-structured, unstructured, streaming data)? Additional water quality meters that stream real-time data may be added to the PWQN in the future. 62. Will the dashboard require real-time data ingestion and processing, or will it operate on batch processing? Batch processing. 63. Given that water quality data is collected every 15 minutes, should the dashboard refresh at the same interval to reflect the most recent monitoring results? The data are currently pulled into the City’s database management system every three hours. Dashboard reporting frequency will be determined by stakeholder requirements, but reporting will likely occur at a minimum of every 3 hours. 64. If a 15-minute refresh interval is required, will PWQN be responsible for ensuring that data is collected and available at these intervals? Yes. 65. Are there any additional parameters, beyond pH, temperature, dissolved oxygen, and water clarity, that should be considered for monitoring and visualization? Specific conductivity, fDOM, and chlorophyll-a. Addendum 1 RFP 10134 Public-Facing Water Quality Data Visualization Dashboard 66. If additional metrics are required, will they originate from a different data source, or will all necessary data for the dashboard be provided through the City’s cloud-based data management platform? All water quality data will be accessible through the City’s cloud-based data management platform. Additional data (hydrometeorological data) may be originate from different data sources. 67. Should the dashboard include multilingual support, specifically the ability to switch between English and Spanish? Yes.