EXHIBIT H- DATA CONNECTIONS.pdf
PDF 83 KB Posted
- Attached to
- Water Technical Access Portal (WaterTAP) 2. 0
- Solicitation number
- 0000040529
- Issued by
- California
About this file
This is a Data Connections exhibit from the State of California Department of Technology RFP 26-014-280, detailing the technical specifications for integrating multiple data systems into the WaterTAP platform for the State Water Resources Control Board (SWRCB). The exhibit documents eight primary applications and systems to be connected, including the Safe Drinking Water Information System (SDWIS) with approximately 2 billion data points stored across 198 tables in a 50 GB Microsoft SQL Server database; the California Laboratory Intake Portal (CLIP) processing approximately 7.4 million data elements annually; the System Area Boundary Layer (SABL) containing 150,000 geospatial data points; the OnBase Enterprise Content Management system managing over 30 million documents; the electronic Annual Report (eAR) with 1.5 billion data points; the SAFER Clearinghouse with 1 million data points stored in Microsoft Azure; the Water Quality Management system with 150 GB capacity; and the Child Care Lead database. Additionally, two applications identified for future development include the Environmental Laboratory Accreditation Program (ELAP) and Operator Certification (OPCERT) system.
The data connections exhibit provides migration requirements and technical specifications for each system, with varying migration percentages ranging from zero percent (CLIP and SAFER Clearinghouse requiring no data migration) to 100 percent (SABL, Water Quality Management, and Child Care Lead). Data formats span multiple import and export standards including XML, SQL queries, CSV, KMZ, GeoJSON, PDF, Word, and Excel across the different systems. The total estimated data volume across all systems exceeds 540 GB, with individual system sizes ranging from 210 MB for the Child Care Lead database to 150 GB for the Water Quality Management system. No pricing information, contract award dates, response deadlines, or renewal terms are specified within this technical exhibit.
View the file
Other files
Show all 45
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
EXHIBIT H: DATA CONNECTIONS
EXHIBIT H: WATERTAP DATA CONNECTIONS
WaterTAP is intended to connect multiple services (such as client applications, databases, and external APIs) in a decoupled architecture.
The SWRCB applications currently within the proposed WaterTAP scope are listed below:
*All provided information within the tables below are approximate and do not constitute final figures without verification.
Table H-1: Safe Drinking Water Information System
Name SDWIS - Safe Drinking Water Information System
Location
Stored in Microsoft on-prem SQL Server.
Clone of data in Snowflake, refreshed daily
Table Parameters
Estimated Number of Data Points
2 Billion
Size 50Gb
Number of Tables 198
Migration Percentage 95%
Columns (Low, High) 2 104
Rows (Low, High) 1
31,844,763
Format Import xml
Export xml, SQL Queries
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
October 2, 2026
Table H-2: California Laboratory Intake Portal
Name CLIP - California Laboratory Intake Portal
Location EarthSoft COTS platform (Cloud based)
Table Parameters
Estimated Number of Data Points
Total number of data elements per month: 7,400,000
Annual Average Daily Total data elements received: 250,000
Estimated number of records received in 2024: 2,200,000
Average number of records received per month: 185,000
Each record contains 40 separate data elements
Size Data stored in SDWIS
Number of Tables 357
Migration Percentage No data migration required
Columns (Low, High) ** **
Rows (Low, High) ** **
Format Import csv, xml
Export csv, xml
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
Table H-3: System Area Boundary Layer
Name SABL - System Area Boundary Layer
Location On-Prem (JAVA, Oracle, ESRI GIS)
Table Parameters
Estimated Number of Data Points
150,000 located in one table
Size 20 Gb
Number of Tables 1
Migration Percentage 100%
Columns (Low, High) 31 **
Rows (Low, High) 4813 **
Format
Import KMZ
Export csv, shapefile, GeoJSON, GeoService, KML
Table H-4: OnBase Enterprise Content Management
Name OnBase ECM - Enterprise Content Management
Location On-Prem (Hyland OnBase, File servers, SQL Server
Table Parameters
Estimated Number of Data Points
30+ Million
Size **
Number of Tables 4248
Migration Percentage
Columns (Low, High) ** **
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
Name OnBase ECM - Enterprise Content Management
Rows (Low, High) ** **
Format Import PDF, word, Excel, msg, jpg, png
Export PDF, word, Excel, msg, jpg, png
Table H-5: Electronic Annual Report
Name eAR - electronic Annual Report
Location On-Prem (DotNet, SQL Server)
Table Parameters
Estimated Number of Data Points
1.5 Billion
Size 40 Gb
Number of Tables 83
Migration Percentage 10%
Columns (Low, High) ** **
Rows (Low, High) ** **
Format Import PDF, word
Export csv, txt, xml
Table H-6: SAFER Clearinghouse
Name SAFER Clearinghouse
Location Stored in Microsoft Azure (JAVA, Azure SQL Server)
Table Parameters
Estimated Number of Data Points
1 Million
Size 70 Gb
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
Name SAFER Clearinghouse
Number of Tables 550
Migration Percentage
Columns (Low, High) 0 2,465,500
Rows (Low, High) 0 140,000
Format Import csv, xml
Export csv, xml
Table H-7: Water Quality Management
Name WQM - Water Quality Management
Location Stored in Microsoft DotNet, on-prem SQL Server
Table Parameters
Estimated Number of Data Points
Size 150 Gb
Number of Tables 53
Migration Percentage 100%
Columns (Low, High) 3 23
Rows (Low, High) 2 40,533,935
Format Import csv
Export **
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
Table H-8: Child Care Lead
Name CDSS - Child Care Lead
Location On-Prem (DotNet, SQL Server)
Table Parameters
Estimated Number of Data Points
Size 210 Mb
Number of Tables 15
Migration Percentage 100%
Columns (Low, High) 2 15
Rows (Low, High) 0 68,496
Format Import csv, txt
Export csv, txt
The following applications are future development which will need to be included in WaterTAP in the future but will not be in development during WaterTAP rollout.
Table H-9: Environmental Laboratory Accreditation Program
Name ELAP - Environmental Laboratory Accreditation Program
Location On-Prem (DotNet, SQL Server, MS Access)
Number of Tables 43
Size 200 Mb
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
Table H-9: Operator Certification
Name OPCERT - Operator Certification (DWOCIS)
Location On-Prem (JAVA, Oracle)
Size <100 Mb
Table H-10: Electronic Coliform Reporting
Name RTCR - Electronic Coliform Reporting
Location TBD
Size Electronic Coliform Reporting will add 100,000 records per month.
The following applications are sunsetting with WaterTAP rollout.
Table H-11: Lead Service Line Inventory
Name LSLI - Lead Service Line Inventory
Location Microsoft Azure SQL Elastic Pool
Table Parameters
Estimated Number of Data Points
252 Million
Size **
Number of Tables 3
Migration Percentage 95%
Columns (Low, High) ** **
Rows (Low, High) ** 9,000,000+
Format Import csv, xml
Export csv, xml
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
Table H-12: Water Quality Information System
Name WQIR - Water Quality Information Reporting
Location On-Prem (DotNet, SQL Server)
Number of Tables 53
Migration Percentage 100%
Size <18Gb
All data contained in this EXHIBIT H: DATA CONNECTIONS are estimates and are intended to provide an understanding of the various applications that will interface with WaterTAP.
** Field data not available
State of California Department of Technology
RFP 26-014-280
DATA CONNECTIONS
| EXHIBIT H: DATA CONNECTIONS |
| EXHIBIT H: WATERTAP DATA CONNECTIONS |
| Table H-1: Safe Drinking Water Information System |
| Table H-2: California Laboratory Intake Portal |
| Table H-3: System Area Boundary Layer |
| Table H-4: OnBase Enterprise Content Management |
| Table H-5: Electronic Annual Report |
| Table H-6: SAFER Clearinghouse |
| Table H-7: Water Quality Management |
| Table H-8: Child Care Lead |
| Table H-9: Environmental Laboratory Accreditation Program |
| Table H-9: Operator Certification |
| Table H-10: Electronic Coliform Reporting |
| Table H-11: Lead Service Line Inventory |
| Table H-12: Water Quality Information System |
File details come from the government source that posted it. Updated .