Web Services
Embedded Files
Brown Fields And Their Impact On Water Quality In Mecklenburg County In A Story Map
Brown Fields And Their Impact On Water Quality In Mecklenburg County In A Story Map
Fig.1. Web App with tools to query and graph
Problem
Problem
In the 1900s, Mecklenburg County, NC was lined with textile mills. Chemicals were used in processes, and those still exist today in sites known as brown fields. With precipitation, storm water carries the contaminants and runoff into the storm drainage system, leading to streams which is our source for drinking water. One chemical, acetic acid, is very soluble in water and easily leaches from the ground into streams in large quantities. This study assess the impact from acid contaminants by acid spread proximity to storm drainage.
Results
Results
The results were interweaved into a story map (Fig.2), with the kriged area showing pockets of high acidity surface near streams where the water quality rating was flagged red. The story map integrated graphs, an interactive web app, and query tools.
Fig.2. Brown fields results interweave into a story map with interactive tools
Analysis
Analysis
Soil samples from 36 sites were sent to NC Agriculture Agronomic Services (NCAAS) for pH testing. Spatial analysis was used to select sites using two geoprocesses: 1) proximity to storm drainage and 2) pH of the soil. The brown fields were geocoded, converted to polygons and selected for proximity to storm drainage feature layer. The soil pH data was kriged. A Web App was created to show results from the two geoprocesses with tools to query the pH and graph the water quality rating for each stream (Fig.1).
Reflection
Reflection
After some research, the general consensus is uncontrolled experiments like the soil collection in urbanized areas would be difficult to keep the pH data stationary. Common kriging cannot be used due to violation of the stationarity assumption. The other difficulty is pH value is highly sensitive to environmental factors even though care is taken to ensure random samples from each site are collected. Unlike other projects, this one truly counts as a science experiment from conducting sample collection, lab testing, data geo-analysing and publishing for public use.
George Washington Birthplace Monument Web App With Geoprocessing Tool Using Model Builder and ArcGIS Enterprise
George Washington Birthplace Monument Web App With Geoprocessing Tool Using Model Builder and ArcGIS Enterprise
Fig.1. Model builder published as a geoprocessing service
Problem
Problem
The George Washington Birthplace Monument Web App requires a geoprocessing tool to buffer and intersect the fishing spots with the type of water body to analyze the habitat of game fish. The purpose is to gather information on the environment conducive for the fish to spawn, maintaining fishery sustainability.
Results
Results
The Buffer and Intersect widget used the PostgreSQL database and output on the Web App (Fig.2). The results can be downloaded from the Attribute widget, or printed out as a pdf format.
Fig.2. Web App with query, buffer and intersect tools and print function
Analysis
Analysis
The model builder (Fig.1) was used to define the geoprocesses buffer and intersect as a single model to be exported. The model builder used ArcGIS Enterprise geodatabase as input and output to the scratch workspace. After executing, it was published to the ArcGIS Online as a geoprocessing service. The REST end points were added to the Web App.
Reflection
Reflection
The ability to bring geoprocessing tools to the Web App makes it possible for users to have the same functionality on the Web App as the software ArcPro but without the formal training, or the license required to operate the software. The National Park Services is employing this model for their users.
Covid-19 Cases In United States On A Dashboard
Covid-19 Cases In United States On A Dashboard
Fig.1. Covid-19 dashboard created from Covid-19 project.
Problem
Problem
The project on trend analysis for Covid-19 cases was completed and needed to be visualized in a format familiar to the public - a dashboard.
Analysis
Analysis
The dashboard app takes in CDC data in csv format, the web map created and creates sections that highlight the total case count in October, the web map highlighting each state case count, the map legend, a graphical chart for total cumulative case count.
Reflection
Reflection
Dashboards integrate chart, graphs, tables and maps as an app on the web. They are different from traditional web apps. Their use and functionality are different from traditional web apps because they do not include the use of widgets. Dashboards are only informational.
Page updated
Google Sites
Report abuse