My name is Jessie Shapiro. I am a motivated and professional Spatial Data Scientist based in Salt Lake City, UT with 5+ years of experience. I have a strong passion for exploring applications of GIS in fields of wildlife ecology and natural resource management. I'm proficient and comfortable with executing spatial analysis and manipulating geospatial data in various platforms such as ESRI’s ArcGIS software, R Studio, Jupyter Notebooks, and the Google Cloud Platform. I'm able to adapt technical skills to successfully execute a broad-range of projects.
Jessie Shapiro
jessieshap@gmail.com
Developed a curated GIS repository of enviornmental datasets for the Wyoming and GYE made accessible. Visit site at wildlifemovetools.org
The Migration Timing dashboard provides key metrics for wildlife migrations in Utah. Migration dates for wildlife are updated from real-time GPS tracking data. Metrics are calculated using BigQuery GIS functions and connected directly to a repository of GPS tracking data of migrating animals. The dashboard summarizes migration timing in Utah, that was not possible before.
Developed wildlifemovetools.org to host freely accessible geospatial data and a range of web application tools tailored for wildlife research and conservation in Wyoming and GYE.
Develop an R Shiny application to analyze movement patterns and assign migration dates for GPS collared ungulates. The application is connected directly to the Wildlife Tracker database hosted in the Google Cloud Platform, creating an efficient and seamless workflow for Utah. Users query and assign dates through an interactive map and NSD plots. Assigned dates are uploaded directly to GCP where further analysis can be run in the cloud environment.
Project manager of the Wildlife Tracker system, a cloud tool used to store big data on GPS collared animal movements and visualize data through a front-end web application for the Utah Division of Wildlife Resources. Maintain the data warehouse of over 43,000,000 animal locations and 10,000 individual animals. Develop new features and enhancements to the Wildlife Tracking system, including data loading and validation. The system required skills in Google Cloud Services (Cloud Run, App Engine, BigQuery, Cloud Scheduler, Cloud Functions, Cloud Storage) and Python, SQL and Javascript. To learn more click here.
This work aims to develop a relational spatial database system for Forestry, Fire, and State Lands to monitor invasive species treatment and management efforts on Utah’s sovereign lands that integrate field collection efforts and improve data accessibility. The database will serve as the backbone for managing associations between entities, use in-field observations, and have a flexible but controlled data-sharing environment that will help quantify and monitor invasive species effectively.
Mule deer spring migration is simulated in a Net logo model using an agent based model approach, which allows for a simple rule structure to determine mule deer interactions with environment. The ABM simulates behaviors of an individual’s decision to stay and leave a stop over site based on the resources available and energy expenditure. The emergent behavior from the model will provide insight into how mule deer explore stop over sites in times of good vegetation and poor.
Build and deploy a cloud function that pulls data from BigQuery and updates tickers on a public facing website. Development of the cloud function required skills in BigQuery, GCP, Python and SQL.
Analyze Utah Division of Wildlife Resource's movement data repository using Brownian Bridge Movement Models methods to map areas that facilitate movement. Optimize cloud resources by writing R Scripts to be ran in the GCP Vertex AI.
This report explores spatial patterns in mule deer road carcass reports in San Juan County, Utah for the four movement seasons. To mitigate for wildlife-vehicle collisions, state agenceis collaborated to build wildlife fencing and crossing structures in the high frequency collision sites. The effectiveness of these wildlife fencing was tested and at a broader spatial scale, variables of what might lead to collisions was modeled.
Develop and design spatial relational database of avian nests on Army Garrison Camp Williams. A spatial database is needed to organize nest locations, history and survey areas so that managers can make thoughtful recommendations. Efforts streamlined data collection in the field.
Develop data feed that scrapes location data daily from avian tracking units in CTT accounts and uploads location data to BigQuery. Development of the data feed required skills in BigQuery, GCP, Python and SQL.
The spatial relationship between nest locations of lark sparrow's and environmental parameters such as vegetation, elevation, aspect and slope were investigated in a habitat suitability model. The predictive model is designed for application to the large study area on Camp Williams that represents preferential lark sparrow nesting habitat. The final habitat model is a weighted sum of the four environmental variables that were ranked based on expert opinion and data collection.
Develop and produce analytical workflows, technical assessments, interactive dashboards, and research to help manage and conserve big game habitat related to the wildlife management and conservation needs of USDA’s Working Lands for Wildlife Program and Wyoming Game and Fish Department. Additionaly provide analytical, data management, and research support for the Merkle Research Group, Wyoming Cooperative Fish and Wildlife Research Unit, Wyoming Migration Initiative, as well as state, federal, and NGO cooperators and partners.
Support technical geospatial, data, research and application developments and products for the Wildlife Migration Initiative. Manage, analyze and visualize big data using cloud computing. Perform research analysis and complete various GIS and research-based projects using R statistical packages, ESRI products, and GCP. Build customized solutions for processing wildlife movements with R Shiny apps.
Maintain, edit and ensure quality control of spatial databases of wildlife locations for the State of Utah. Create programming scripts that detect and repair problems in the data. Assist in the migration of spatial SQL database to google cloud platform and development of web applications. Map migration corridors and home ranges using Brownian Bridge Movement Model for Utah using R scripts. Prepare GIS data requests for regional staff and partners.
Developed relational spatial database for raptor and passerine survey. Develop web applications to streamline field data collection. Write and draft technical reports based on passerine demographics, raptor and vegetation surveys. Identify information from analyses that suggest developing patterns of problems or complaints from which general specific trends can be discerned, suggesting a need for further investigation.
Transcribe nesting burrowing owl behaviors. Perform literature searches on North American passerines for comparative analysis on latitudinal pattern in clutch size. Responsible for data management and entry of passerine nest data in MS Access.
Use a variety of geospatial tools to find, edit, digitize, geo-reference and display data using ESRI GIS software. Collaborate with management to see technical projects through from conception to completion.
Software/Web: ESRI ArcGIS (ArcGIS Pro, ArcGIS 9.3-10.7, ArcGIS Online, Survey123, Experience Builder, WebApp Builder, ArcServer, Field Maps), QGIS, Leaflet, PostGIS, Mapbox, R Studio, R Shiny, Google Cloud Platform (BigQuery, AI Notebooks, Cloud Functions, Cloud Run, GeoViz, Data Studio, CloudSQL), Visual Studio, PgAdmin, PostgreSQL, MSSQL, Netlogo, MS Access
Programming: SQL, R, Python, JavaScript, HTML, CSS
Project Management: Trello, Asana, G Suite