- To promote awareness and knowledge of the benefits of data automation and Geographic Information Systems (GIS)
Senior GIS Specialist
- A booklet of maps was output to display oil and gas compressor options. The booklet amounted to approximately 30 maps of an area with different flow rates. To streamline the production of these maps, a set of Python scripts and mxd documents were developed to automatically produce maps with alternating annotation or layer appearances.
- Impervious areas within land parcels were digitized. Digitizing was done using visual inspection with ArcGIS editor tools. To streamline quality testing of results, an ArcGIS ModelBuilder workflow was designed to test results exclusive to each parcel and display parcels with no impervious areas.
- Mutually exclusive overlapping of several right of way passages was accomplished using an ArcGIS ModelBuilder workflow. The client requested one unified right - of-way with mutually exclusive stacking of disturbance limits.
- Potential locations for well and meter pads were designated using an ArcGIS ModelBuilder workflow. The workflow operated by digitizing restricted areas, buffering restricted areas and clipping restricted buffers from the permitted area.
- Client requests involved brine, water, oil and gas geoprocessing. The following are examples.
- A client requested sink to source distance and tortuosity values using an established network of routes. An ArcGIS ModelBuilder workflow was developed and processed the requested values using ArcGIS Network Analyst, Structured Query Language (SQL) queries, attribute joins and several attribute calculations involving conditional and mathematical formulas.
- To increase a client's awareness of well drilling risks, a Python script was developed with ArcGIS function calls to search, query, download, format and process USGS National Water Information System (NWIS) water well depths and water levels. These wells were subsequently used in density maps of oil, gas and water wells by performing spatial joins of well locations with 10 km2 areas.
- A Python script was developed with ArcGIS function calls to create survey boxes of uniform width and height along designated survey lines. This script was interfaced with an ArcGIS Toolbox interface for future use.
- A client requested statistics for sampled aqueous chemistry values and values for locations without samples. A Python script with ArcGIS function calls was developed to produce statistics for known values and kriged interpolated surfaces areas lacking samples.
- Forestry data sets for a client hydrologist were processed to indicate roads prone to create sediment buildup with respect to hillside slope, grade, flow length, flow accumulation and proximity to stream. To accomplish this, a Python script was developed with ArcGIS function calls to calculate grade of roads using Light Detection and Ranging (LIDAR) Digital Elevation Models (DEM) values interfaced with an ArcGIS Toolbox interface. The grade calculation was subsequently used within an ArcGIS ModelBuilder workflow to extract the other required parameters and score each road segment.
- Presentations were developed to publish research for internal and external publications. Publications included a poster for the 2011 ESRI Federal User Conference and several presentations using the TouchTable GIS hardware and software. A TouchTable manual was created for the client to explore research possibilities.
- CTech EVS/MVS software utilized to create a three-dimensional display a client's sampled subsurface conductivity values and subsurface coordinates of a Marcellus Shale producing well.
- Anchorage, AK was visited to coordinate GIS-related efforts of a coal study. New coal field boundaries with respect to existing boundaries were digitized with a team of geologists for a publication.
- A Java-based spider tool with regular expressions was designed to automatically download and extract GIS data from online storage.
Web Application Programmer
- State of the art software, research techniques and new algorithms were evaluated in a laboratory setting.
- An Open Geospatial Consortium (OGC) Web Map Service (WMS) version 1.3.0 compliant map server using Java servlets and GeoTools Java libraries was implemented to test capabilities of current state of the art GIS web services versus existing desktop GIS software.
- Parallel processing techniques were researched using the C language, Message Passing Interface (MPI) libraries with the Condor 6.8 local job manager to produce a Single Instruction Multiple Dataset (SIMD) parallel processing environment for solving the Traveling Salesman Problem.
- Lectures and projects for undergraduate and graduate students were assembled and presented. An ArcGIS manual was co-written with sample data for students to learn GIS terminology and GIS software.
- A Java applet using Java Swing libraries and JLOOX visualization libraries was developed to visualize protein fluctuations. Several application prototypes were created and tested with users and stakeholders to iteratively increase the application's acceptance and usability.
- A client requested several data sets be trimmed to municipality borders in Southwestern Pennsylvania. The ArcGIS Arc Macro Language (AML) and ArcInfo were used to automate clipping of the available layers by municipal boundaries. The resulting data was web-enabled with ArcIMS Map Server.