mosquito-gis

Static website created to show results of Spring 2020 Mosquito Population Analysis independent study for the CDC's Midwest Center of Excellence for Vector-Borne Diseases (MCEVBD).

The focus of this project was digitizing catch-basins and mosquito traps in Milwaukee County, as well as creating a relational database tracking mosquito larvae levels. The static website was created to display the findings. Because the focus of the project was GIS, in the interest of time creating the website, the bulk of the text was formated using Microsoft Word-converted html documents. Those documents (index_page.html and maps_page.html) were then referenced from index.html and maps.html.

Project site was hosted using Amazon Web Services (AWS) Simple Storage Service (S3).

Motivation:

The objective of this semester-long independent study was to work with the Center for Disease Control and Prevention’s (CDC) Upper Midwest Center of Excellence for Vector-Borne Disease (MCEVBD) Mosquito Team to identify and map existing catch basins (storm drains) and mosquito trap sites within four separate study areas in Milwaukee County. I was tasked with producing maps the Mosquito Team could carry in the field to better locate sampled catch basins and mosquito traps, calculate the most efficient routes the team could take to visit each catch basin and trap, and build a geodatabase that would allow additional analysis to be preformed on the collected data.

Database Tables:

Catch-Basin (CB) Table Attributes:

There is a unique CB table for each of the four study areas.

• Object ID generated by ArcMap
• Shape point
• CB Number
• Location study area
• Additional location comments
• Key unique identifier for each CB, used to relate to Mosquito Larvae Data Table
• Latitude
• Longitude

Trap Table Attributes:

There is a unique Trap table for each of the four study areas.

• Object ID generated by ArcMap
• Shape point
• Trap Number
• CDC trap boolean value: indicates use of CDC trap
• Gravid trap boolean value: indicates use of Gravid trap
• Location study area
• Additional location comments addresses, resident contact information, etc.
• Year year trap was utlized
• Latitude
• Longitude

Mosquito Larvae Data Table Attributes:

Contains all the mosquito Larvae data collected - referenced via the Key field from the CB tables.

• Object ID generated by ArcMap
• Date
• Epidemiological Week
• Site study area
• CB number
• Treatment
• Treatment Date
• Early
• Late
• Pupae
• Number pupae
• Pass/Fail
• Days post treatment
• Weeks post treatment
• Key unique identifier for each CB, used to relate with CB Tables

Example of Maintained Data Connection:

Shortest Route Analysis:

Using ArcMap’s Network Analyst extension, a shortest path analysis was conducted for each of the study areas. The shortest route for visiting each CB and the shortest route for visiting each trap were calculated for each study area.

Route Analysis Settings:

• Reorder Stops to Find Optimal Route
• Preserve First Stop
• Preserve Last Stop
• Accumulate on Length

Credits:

Thank you to the Upper Midwest Center of Excellence for Vector-Borne Disease for the project.

Site navigation bar adapted from w3schools.com/css/css_navbar.

Site map slideshow containers adapted from w3schools.com/howto/js_slideshow.