What is this?
In my professional career I’ve used the Google Charts Javascript API (Geocharts) to develop web maps that help our marketing team target specific areas for fundraising campaigns or simply give clients visualizations of their data. I've rebuilt a few of these maps inside the Esri software suite for the interview (ArcGIS Pro/Online/Web AppBuilder) and they are attached in the Data Maps Tab above. I’ve also included a few web apps that I’ve built in the Apps tab above. These are all from a historical perspective and were built out of personal interest in the area mapped.

Use the thumbnails to open each map. The Data maps include a map, description, and a DataTable to show a sample dataset.

*If anyone from the interview is reading this, the three Web Apps that I've built need to be remade into another account as they expired. I’m in the process of remaking them and will be available again on 01/03/2019. All data maps still work.

Historic PAC Data - 2D
Historic PAC Data - 2D

This 2D map displays historic PAC data by county over a 10-year time frame (2008 to 2018) using proportional symbology. Each year consists of its own layer with a stand-alone layer to display the average PAC data over the 10-year period. Points were created from arcpy.FeatureToPoint_management() taking the centroid of an ArcGIS county layer. My starting dataset only included zip codes and total Pac from the client. Joins were made in SQL against a zip code/county name table to pull county, state names. To join my dataset to the ArcGIS county layer a custom join field was made between the two tables. Work was done in SQL, AWS, ArcGIS Pro, ArcGIS Online, and the final page/map was developed using the ArcGIS Javascript API and Bootstrap.

2018 Pac Net Gain & Loss - 3D
2018 PAC Data and Return - 3D

Using a 3D scene this map takes into account the costs it takes to run mail campaigns by displaying 2018 net Pac gains by county along with net Pac losses by county. Gains are displayed with 3D shape symbology in green while losses are shown with proportional symbology on the ground in red. I used a csv export from SQL to work offline and used arcpy.ExcelToTable_conversion() to create a stand-alone gdb. New fields were added and calculated with python expressions. arcpy.FeatureToPoint_management() was used to convert the joined layer into points using the centroid of each county. Work was done in SQL, Excel, AWS, ArcGIS Pro, ArcGIS Scene Viewer, and the final page/map was developed using the ArcGIS Javascript API and Bootstrap.

Orders 2018 - Heat & Points
Orders 2018 - Heat and Points

This 2D map displays total orders from a client by zip code using a heat map along with proportional symbology. The map consists of 2 data layers - heat and points - but totals 4 layers. The layers will switch between country and city layers depending on the extent the user is viewing. Bookmarks were created to show high order locations. To create my starting dataset, joins were done in SQL against a zip code table that included latitude and longitude fields - 4 decimal places to give street level accuracy. To keep costs down on my RDS instance a csv was exported and arcpy.ExcelToTable_conversion() was used to create a gdb. Work was done in SQL, Excel, AWS, ArcGIS Pro, ArcGIS Online, and the final page/map was developed using the ArcGIS Javascript API and Bootstrap.

Patapsco Valley - Baltimore 1908
Patapsco Valley - Baltimore 1908

The Patapsco Valley - Baltimore 1908 webapp overlays a 1908 USGS topographical map over a present day satellite imagery. The swipe tool is the main feature of this map and allows the user to pull back the 1908 map to reveal the satellite image. Bookmarks include the Liberty Dam, Mount Saint Joseph High School, Baltimore City, Old Ellicott City, along with others. In the loaded extent, Marriottsville, I have located a few of the old foundations on this map while out in the woods mountain biking.

Historic Annapolis
Historic Annapolis

The Historic Annapolis webapp consists of 3 layers. Each layer was compiled from topographical maps inside the USGS Historical Topographic Map Collection - 1892 to 1895, 1904 to 1907, and 1938 to 1946. The swipe tool allows the user to pull back each layer. Places of interest include the United States Naval Academy, the Chesapeake Bay Bridge, the Maryland State House and many others. It is interesting to see the changes on the shoreline between all the layers along with the expansion of the Naval Academy.

Hampton Roads - Naval Station Norfolk - Historic
Hampton Roads - Naval Station Norfolk - Historic

My Hampton Roads - Naval Station Norfolk - Historic webapp displays the expansive maritime development in Hampton Roads. The app contains 4 layers spanning from 1907 to 1965. As with the others, the swipe tool is the main feature in the app. A few of the layers were compiled from oceanographic maps and show the shipping lanes into Hampton Roads. Bookmarks include the Little Creek SEAL base, a shipwreck, aircraft carriers at Naval Station Norfolk, the Port of Newport News, along with many others.