In Brief
Turning Mosquito Test Results into Actionable Maps
Harris County Public Health in Texas regularly tests mosquitoes for diseases that can pose a risk to residents, but turning those results into geographic information required staff to manually process data and create maps for analysis and public communication.
Resource Data developed an automated GIS solution that transforms new test results into spatial data and powers an interactive map showing mosquito-borne disease activity and treatment areas across the county, giving staff and residents faster access to current public health information.
Key Takeaways
From Test Results to Timely Public Information
-
Automating Mosquito Surveillance Mapping
Resource Data helped Harris County Public Health turn ongoing mosquito test results into automatically updated GIS data and interactive public maps.
-
Mapping Disease Activity Without Pinpointing Test Locations
Positive results are connected to county-defined mosquito-control areas, giving residents useful geographic context without exposing exact trap locations.
-
Connecting Disease Activity and Treatment Information
Interactive maps make it easier to see confirmed mosquito-borne disease activity alongside recent and cumulative mosquito-control treatments.
-
Building a Foundation for Ongoing Public Awareness
The GIS approach established a sustainable way to keep changing mosquito activity and treatment information accessible to the public.
Meet Our Client
Harris County Public Health
Harris County Public Health serves communities across Harris County, Texas, through programs focused on protecting and improving public health. Its Mosquito & Vector Control Division monitors mosquito populations and mosquito-borne diseases to help reduce the risk of transmission to residents.
As part of that work, teams collect mosquitoes from traps located throughout the county and test samples for diseases including West Nile virus, St. Louis encephalitis, chikungunya, dengue, and Zika. The results help the division understand where disease activity is occurring and support mosquito control and public education efforts.
The Challenge
A Manual Process Behind Every Map Update
Mosquito test results arrived as spreadsheets with tabular data, leaving Harris County Public Health with several steps before that information could be used geographically. Staff had to bring the data into GIS, identify positive results, convert them into spatial features, and create or update maps as new results became available.
The division also needed to communicate mosquito activity and treatment information to the public without displaying the exact locations of positive tests. The challenge was not simply creating a map but finding a more efficient way to turn ongoing surveillance data into useful geographic information that could support both Public Health staff and residents.
The Solution
Automating the Path from Spreadsheet to Map
Resource Data developed Texas History Navigator as a mobile experience built around where users are and where they want to go. The app connects THC’s historical information with geolocation and an ArcGIS Online interactive map, allowing residents and visitors to search thousands of historical markers, museums, and heritage sites, see what is nearby, and learn more as they travel.
As THC looked for new ways to encourage exploration, the app expanded beyond location-based discovery. Resource Data added user accounts, check-ins, points, levels, and badges that let users track the places they visit and progress as they explore more of the state. Plan My Trip also allows users to select multiple destinations, arrange their stops, and continue the route in Google Maps or Apple Maps.
We were able to take tabular mosquito test results, connect them to Harris County’s operational areas, and automate everything needed to turn that data into information the public could use.
- Dave Saleh, GIS Lead, Resource Data
Features
Built to Keep Disease and Treatment Data Current
-
Automated Data Processing for Up-to-Date Maps
Python scripts process new test spreadsheets, identify positive results and their locations, update the corresponding GIS features, and publish the data to the web map automatically.
-
County-Defined Areas for Clearer Disease Mapping
Positive tests are mapped to Harris County’s established mosquito-control areas instead of exact trap locations, providing geographic context while protecting location privacy.
-
Disease-Specific Layers for Confirmed Activity
Map layers show the general areas where mosquito-borne disease activity has been confirmed and distinguish the disease detected.
-
Recent Treatment Mapping for Current Information
Treatment areas remain highlighted for seven days, giving users a clear view of recent mosquito-control activity.
-
Cumulative Treatment History for Long-Term Context
Color-coded areas show how many times an area has been treated during the year, making treatment patterns easier to understand.
Results
Making Mosquito Activity Easier to See and Understand
The interactive maps gave residents a more accessible way to understand where mosquito-borne disease activity had been identified and where mosquito-control treatments were taking place across Harris County. Instead of relying on static information, users could explore current activity geographically and see how it is related to their area.
Live maps remain part of Harris County’s mosquito-control resources today, providing current information on confirmed disease activity and treatment areas.

What's Next
A Foundation for Ongoing Public Health Mapping
Mosquito surveillance does not stop with a single season. By connecting ongoing test data with GIS and public-facing maps, Harris County established a foundation for keeping mosquito activity and treatment information accessible as conditions change.
Our Work
Inspiring stories to read next.
Case Study FAQ
A public health department can automate recurring mosquito surveillance mapping with a Python workflow that processes incoming test spreadsheets, identifies positive results, locates the associated records, updates GIS features, and publishes refreshed map data. This turns a repeatable series of data-processing steps into a consistent pipeline from spreadsheet to web map.
Resource Data implemented this approach for Harris County Public Health using Python and Esri GIS. Each positive test was geographically processed and matched to one of the county’s mosquito-control areas before the updated GIS data was published to an interactive map. The technical value is a reliable connection between tabular surveillance results and the geographic layers used for analysis and public communication, without introducing new data sources or requiring staff to rebuild each map update manually.
The documented Harris County workflow automated four core actions: processing new spreadsheets, identifying positive mosquito tests and their locations, updating the corresponding GIS features, and publishing the results to the web map. It also associated positive results with county-defined mosquito-control areas so the public display did not reveal exact trap locations. The case study does not describe formal quality-assurance controls, automated error thresholds, approval gates, or testing procedures.
A public health agency designing a similar workflow should separately define how it will handle incomplete records, unexpected spreadsheet formats, unmatched locations, duplicate results, and publication approval. Those are implementation recommendations, not documented features of the Harris County solution. Making that distinction helps technical evaluators assess both the proven automation pattern and the additional governance or validation controls their own data environment may require.
GIS can protect exact mosquito trap locations by assigning each positive test to a larger, approved reporting geography and publishing that area instead of the collection point. The map still communicates where confirmed disease activity has occurred, but at a level of precision chosen for public use.
For Harris County Public Health, Resource Data connected positive mosquito test results to the county’s established mosquito-control areas. Disease-specific layers then showed the general areas of confirmed activity without displaying individual trap sites. This GIS design preserves the spatial relationship between a test result and the county’s operating geography while separating internal collection locations from public map features. It is a practical technical pattern for agencies that need meaningful geographic context without publishing point-level surveillance locations.
An interactive GIS map can combine disease and treatment information through coordinated layers with different display rules. Disease-specific layers identify the general areas where mosquito-borne disease activity has been confirmed, while treatment layers show both recent mosquito-control activity and longer-term treatment patterns.
In Harris County’s map, treatment areas remain highlighted for seven days, giving users a current view of mosquito-control work. A color-coded cumulative layer shows how many times an area has been treated during the year. Together with the disease-activity layers, these views help residents and Public Health staff understand where confirmed activity and treatment have occurred across the county. The layers provide geographic context; they do not establish that a treatment caused a particular change in disease activity or prove treatment effectiveness.
GIS automation reduces the repetitive manual work required to keep a mosquito surveillance map current. Staff can spend less time repeatedly preparing spatial data and rebuilding map updates as new test results arrive, while the surveillance program continues collecting and testing mosquitoes through its established process.
Before the Harris County project, staff had to bring spreadsheet data into GIS, identify positive results, convert them into spatial features, and create or update maps. Resource Data replaced those recurring production steps with an automated path to the interactive map. The operational value is a workflow better suited to ongoing surveillance: updates follow a repeatable process, public information can remain current as conditions change, and existing staff capacity can be used more effectively. The case study documents the workflow improvement but does not quantify labor, time, or cost savings.
A useful public mosquito-borne disease map should show the general area of confirmed activity, identify the disease detected, and explain where mosquito-control treatment has occurred recently and over time. It should provide enough local context to be useful without exposing exact surveillance locations that the agency has chosen not to publish.
Harris County’s interactive map combines disease-specific activity layers with treatment information. Positive tests are displayed through county-defined mosquito-control areas rather than individual trap sites; recent treatment areas remain highlighted for seven days; and color coding shows cumulative annual treatment history. This gives residents a clearer geographic view than static, nonspatial information alone. It also gives Public Health a consistent way to communicate changing disease and treatment activity without implying that a mapped area predicts an individual’s health risk.
Keeping a mosquito surveillance map useful beyond one season requires a repeatable way to process new test results, stable rules for public geography, and map layers that can represent changing disease and treatment information. The map must operate as an ongoing public health resource rather than a one-time visualization.
Resource Data’s solution connected recurring spreadsheet-based results to an automated GIS workflow and interactive web map. Positive tests could be associated with established mosquito-control areas, while treatment information appeared as both a seven-day recent view and a cumulative annual history. The case study confirms that live maps remain part of Harris County’s mosquito-control resources. That continued use demonstrates the value of designing the data workflow and public map together, while ongoing maintenance, ownership, and support responsibilities should be planned according to each agency’s operating environment.
The business case for GIS automation is strongest when a public health program repeatedly performs the same manual steps to turn surveillance data into public information. Automating that path can make updates more consistent, improve the use of existing data and GIS capabilities, and support an ongoing communication need rather than a single map request.
Harris County Public Health began with mosquito test results delivered as spreadsheets and a multi-step manual mapping process. Resource Data connected that recurring input to an Esri-based GIS workflow and interactive map that also displayed recent and cumulative treatment information. The documented outcome is an automated processing and publishing approach that keeps disease-activity and treatment information accessible to the public. Agencies building an investment case should evaluate their own update effort, maintenance needs, audience requirements, and technology costs rather than assuming a specific return based on this example.
A public health leader should evaluate fit by examining the current source data, repeated manual tasks, operational geographies, public-disclosure rules, and the map views needed by staff and residents. A custom GIS workflow is most appropriate when those program-specific elements must be connected through defined processing and publishing rules.
The Harris County project aligned recurring mosquito test spreadsheets, the county’s established mosquito-control areas, Python automation, Esri GIS, and an interactive public map. That alignment shows how a solution can be designed around an existing surveillance and communication workflow. For another agency, careful scoping may reduce implementation uncertainty and help the project deliver useful results sooner, but those are potential advantages rather than measured Harris County outcomes. Technical evaluators should also assess licensing, security review, maintenance ownership, procurement, and total cost based on their own environment.
A public agency can balance transparency with responsible disclosure by defining what geographic detail residents need, what location information should remain internal, and how those rules will be applied consistently in public maps. The goal is to provide useful local context without publishing more precise surveillance information than the program intends to release.
Harris County Public Health followed that approach by displaying confirmed disease activity through county-defined mosquito-control areas rather than exact trap locations. Residents can also see recent treatment areas and cumulative annual treatment patterns, which adds context about the county’s mosquito-control response. From a governance perspective, using an established reporting geography makes the disclosure decision consistent across updates instead of relying on ad hoc map editing. Each agency should select its public geography and review process according to its own operational, public-records, and communications requirements.