Spatial Data Analyst                                      
NAFTA-Geographer

November 5, 2007 – January 21, 2016,  (37.5hrs per week)
Ministry of Forests Lands and Natural Resource Operations
Cranbrook, British Columbia, CANADA     


DUTIES

  • Perform GIS analysis on a wide range of environmental and social issues throughout British Columbia, Canada.

  • Facilitate data visualization & statistical products for an audience of provincial, federal, first nations, university, regional, and municipal government clients.

  • Utilize ESRI ArcGIS 10.2 Model Builder, Python, FileMaker Pro, SQL Management Studio, Access and numerous other GIS/GPS software packages to analyze and deliver digital spatial & non-spatial products.

  • Committee Involvement:

            -Crown of the Continent - Coordinate with environmental managers & scientists from the Alberta government, BC government, Montana, USA government agencies and university & business partners to discuss and model the ecological condition of a trans-boundary environment.  Harmonizing GIS datasets across this international landscape and disseminating relevant spatial and environmental information to this group from the BC government is one of my roles. 

            -Mobile GIS Working Group - Participate in province wide group whose goal is development of provincial infrastructure to support GIS/GPS and field mapping efforts on iPad/iPhone and Windows tablets.  Attend software training sessions on FileMaker Pro database software and app development.  Delivering provincial messaging around IT security issues, development of forestry related iPad applications, and supporting regional field staff with geographic products for environmental regulatory work is one of my roles within this group.
            -Data Managers Working Group - Participate in province wide group to discuss and facilitate resolution of provincial and regional spatial data issues.  This group is comprised of GIS analysts, GIS coordinators and IT managers that all bring forward concerns relevant to the operations of their own region, or area of expertise.  I represent over 50 regional data users on this group and assisted in development of a Share point site for the group.  I present data concerns relevant to the Kootenay Boundary Region of southeast BC to this group on our bimonthly conference calls.

PROJECTS

  • PM2.5 Air Quality Analysis- I was lead GIS data analyst on multi-stakeholder air quality assessment within a local air shed.  Among my roles were to coordinate with the project statistician to develop sound methods for removing outlier data point data from our large dataset and rationalizing the distance that we would extrapolate this point data.  I provided expertise in how to display the results of our information in a way that would be useful to policy makers and NGO's facilitating a clean stove exchange program.  Converting our large collection of PM2.5 data to raster to raster allowed me to show measures of spatial variability (min, mean, max) across the urban and rural landscape being affected by wood smoke air pollution.  Our mobile air pollution monitoring utilized a nephelometer, Toyota Prius, and a GPS unit set to coincide with a 15 second sampling interval used by the nephelometer. Our mobile air pollution sampling campaign ran for 18 nights in winter along a predetermined 100km route.  Our work was summarized in a published paper that I co-authored at: 
    (Air Quality, Atmosphere & Health)   Portfolio

 

  • Values Assessment & Cumulative Effects Model (VAM) – Using ArcGIS 10.1 Model Builder, and Python I developed a land use assessment & planning tool to assist with an array of projects throughout British Columbia, Canada.  Tool development required me to consult directly with land managers, planners, and natural resource experts to produce a comprehensive spatial dataset of relevant natural, cultural, and economic (NCE) values.  Values Assessment Model outputs include an interactive map product (A), a spatial statistics product that allows for rapid visualization of key NCE values (B), and finally a cumulative effects assessment of the NCE values to focus management objectives (C).  The land use planning tool was designed to be defendable and transparent at open house meetings throughout the Kootenay Boundary Region of BC.  This tool has supported decision making in many areas of BC including the BC Coastal Conservancies project. I personally delivered model products to several remote first nations around Bella Coola BC.  My model allowed first nations to engage in economic development while avoiding map units that were off limits due to natural, ecological and cultural concerns.   Portfolio

  • Timber Harvest Sustainability - Using ArcGIS 10.1 & Python I worked with the regional fire district manager, and a fellow analyst to identify the number of years current logging trends could be sustained. To achieve this, I used ArcGIS Model Builder with Spatial Analyst functionality to convert all relevant forest stand data including: site series index, % pine, volume as well as topographic characteristics (slope, elevation, aspect) into 100m raster datasets. The  results of my work (D) provided Ministry of Forests managers with a number, in years, that current logging trends could be sustained.  Results have received wide review and acceptance within government and relevant industry.   My poster (E)  was shown at the ESRI international users conference in San Diego, CA. This Timber Harvest Sustainability method is now being used to inform legally mandated forest review.

  • Landslide Likelihood | Linked to fish habitat - Working closely with a government hydrologist and a geomorphologist from academia, I used ArcGIS 10.2, Model builder and Python to perform a series of complex spatial analysis functions to produce a spatial data product that could be used to determine if landslides were linked to class 1 fish habitat.  This product is being used to govern how logging companies place roads within critical fish habitat watersheds.  Portfolio