Jonathan Goergen

Jonathan Goergen Email and Phone Number

Research Data Specialist 2 (GIS) @ California Geological Survey
Sacramento, CA, US
Jonathan Goergen's Location
Sacramento, California, United States, United States
Jonathan Goergen's Contact Details

Jonathan Goergen work email

Jonathan Goergen personal email

n/a

Jonathan Goergen phone numbers

About Jonathan Goergen

I am a Geographic Information Scientist. Most of my career has centered on protecting agricultural commodities from invasive pests and diseases but I have also worked on social determinants of health research, disaster research, ontology research, construction and utility regulation policy, and currently flood protection and environmental compliance. The common thread I have started to see emerge in what I do well is the ability to determine and formalize the data model and process flows of existing business processes leveraging spatial queries (contains, intersects, touches, crosses, etc) in addition to the typical table joins of non-spatial relational database models to enable flexible querying and reporting to easily meet demands for information from leadership.

Jonathan Goergen's Current Company Details
California Geological Survey

California Geological Survey

View
Research Data Specialist 2 (GIS)
Sacramento, CA, US
Website:
water.ca.gov
Employees:
2615
Jonathan Goergen Work Experience Details
  • California Geological Survey
    Research Data Specialist 2 (Gis)
    California Geological Survey
    Sacramento, Ca, Us
  • California Geological Survey
    Research Data Specialist 2 (Gis)
    California Geological Survey Sep 2022 - Present
    Sacramento, California, Us
    • Provide project scoping, design, and management support for database and scientific programming projects related to geo-technical boring data and earthquake induced liquefaction • Consult with project geologists for subsurface geological framework modeling on modeling data management solutions; web-based data sharing and visualization approaches; and general project related file management practices• Develop and teach GIS training courses for internal staff on GIS software and tools like ArcGIS Pro, Google Earth, and QGIS• Facilitated monthly sessions demonstrating methods for applying Python for GIS solutions in ArcGIS Pro, QGIS, as well as methods for accessing web APIs via Python like the USGS Shakemap dataset or the US Census Bureau• Designed multi-step process to reclassify and migrate data stored across SQLite databases and an MS SQL Server to a PostgreSQL database• Utilized QGIS forms and Python macros to apply automation and data validity checks into existing data entry workflows• Designed, scoped, and manage project related to the modernization of an Engineering Geological Review database related to the Timber Harvest Plan Review Program• Provide process mapping and Python data processing automation support for post-fire Watershed Emergency Response Team (WERT) geospatial specialists• Provide informal teaching and mentoring of newer staff on topics such as Python automation, requirements gathering interviews, file management practices, and data management practices• Conduct ad hoc GIS and data analysis as requested
  • California Geological Survey
    Research Data Specialist 1 (Gis)
    California Geological Survey Feb 2022 - Aug 2022
    Sacramento, California, Us
  • California Department Of Water Resources, Flood Maintenance Office
    Research Data Specialist 1 (Gis)
    California Department Of Water Resources, Flood Maintenance Office Jun 2019 - Feb 2022
    • Develop and implement the use of QGIS and ESRI tools for the mobile collection of field data• Train staff on the use of mobile tablets, laptops, and cell phones for field data collection• Design GIS process workflows and perform spatial analysis• Use Python and R for data processing automation• Build relational database models to standardize output data from environmental field studies• Inventory, document, and analyze various streams of data from within and outside the organization• Design data models to leverage RDF/graph databases to improve connectivity between organizations • Provide subject matter expertise in the procurement of information technology products from contractors• Participate in department wide GIS Committee, chair GIS subcommittee on Open Source GIS
  • California Department Of Forestry And Fire Protection (Cal Fire), Dig Safe Board
    Research Data Specialist 1 (Gis)
    California Department Of Forestry And Fire Protection (Cal Fire), Dig Safe Board Jan 2019 - Jun 2019
    • Developed GIS workflows to manage and organize data related to 100,000s of excavation records produced each month by Call Before You Dig (811) Centers • Analyzed the compliance rate of agriculture industry related to "Call Before You Dig" laws using GIS and novel database queries• Prepared staff reports and presentations to the Dig Safe Board• Produced maps and metrics for the support of field staff conducting incident investigations • Assisted with the regulation development to implement Government Code 4216• Provided data modeling and database design to develop Board Case Management System• Participated in department wide GIS Users Group
  • Agricultural Sustainability Institute At Uc Davis
    Junior Research Specialist
    Agricultural Sustainability Institute At Uc Davis Sep 2018 - Jan 2019
    Davis, California, Us
    • Managed stakeholder identification and interview phase of research project• Applied formal ontology relating people, projects, organizations, and data sets to accommodate diverse set of public health and environmental protection organizations • Instantiated ontology using information from outreach and interview stage of research and earlier work to lay ground work for RDF/Graph database connecting silos of information between organizations• Produced infographics and slides for accomplishment reports• Managed organization and curation of major data documents in shared network space
  • None
    Cross Country Bicycle Rider
    None Apr 2018 - Jun 2018
    • Planned day to day itinerary for multiple month trip • Worked long days in inclement weather ranging from extreme heat, thunderstorms, wind storms, and rain • Modified distance goals by evaluating various data points related to my stamina and morale, physical injuries, vehicular traffic, elevation change, weather, distance to nearest available lodging, and equipment failure • Managed nutritional needs while navigating rural food deserts and burning 8,000 calories or more per day • Pondered Central Place Theory, the Von Thunen Model of Land Use, and the relationship between rural regional economies and the global economy during countless hours on a bicycle
  • Cdfa Phpps - Pest Detection And Emergency Projects
    Geographic Information Scientist (Under Various Titles)
    Cdfa Phpps - Pest Detection And Emergency Projects Sep 2015 - Mar 2018
    • Coordinated GIS workflows related to invasive pest emergency response work • Formalized data model for emergency response efforts • Designed and implemented internal relational database for tracking emergency responses • Designed SQL queries for report generation and answering complex questions from management • Built customized GIS processing tools to automate data analysis workflows • Desi­gned cartographic products and standards for communicating with other stakeholders • Provided analytical and cartographic products for Incident Command Structure meetings • Analyzed large spatio-temporal data sets to support decision making • Provided scenario based metrics to predict the impacts of various policy decisions • Documented and diagrammed complex interactions of various business workflows • Presented to researchers, industry, and other CDFA staff information on the system dynamics of branch operations and the associated data streams • Trained and lead a team of including myself, one GIS Analyst and two GIS Technicians • Managed data entry teams to digitized pen and paper records
  • Forage Genetics International
    Agricultural Research Technician; Environmental Health And Safety Coordinator
    Forage Genetics International Jul 2014 - Aug 2015
    Arden Hills, Minnesota, Us
    • Collected alfalfa yield trial data using harvester • Operated various tractors and PTO implements as needed on research farm • Drove truck-trailer combinations to move farm equipment between research plots • Managed facility environmental health and employee safety training programs • Visually inspected corn planting to self pollinate plants for seed breeding research • Performed other farm maintenance work such as irrigating crops, weed control, soil cultivation, and pest control • Filed Pesticide Use Reports with the County Agricultural Commissioner’s office
  • The University Of Iowa
    Research Assistant / Igert Trainee
    The University Of Iowa Aug 2011 - Jul 2014
    Iowa City, Iowa, Us
    • Conducted collaborative research within framework of GEEMaP IGERT program • Developed methods to improve heat health planning • Developed algorithm to map intra-urban variation of sky view factor using LIDAR data • Assisted with shading impact analysis of proposed high rise development • Developed python scripts to mine Google Maps API for neighborhood amenities to use in health research • Aided in spatial analysis, data collection and GIS support for research on the role of spatial context on health outcomes and neighborhood condition • Used various approaches to visualize data • Assisting in baseline tree canopy cover analysis for the Iowa City
  • Landscape-Based Environmental Systems And Modeling Lab
    Gis Programmer
    Landscape-Based Environmental Systems And Modeling Lab Jun 2013 - Jul 2013
    • Worked as member of GeoWEPP ArcGIS 10.1 development team • Assisted with developing progress benchmarks for completing project • Aided in porting GeoWEPP erosion modeling software from ArcGIS 9.3 to ArcGIS 10.1 • Beta tested product prior to release
  • Usda-Aphis
    Plant Protection Technician
    Usda-Aphis May 2009 - Jul 2011
    Riverdale, Maryland, Us
    • Surveyed residential properties for “at-risk” plant species for the Plum Pox Virus Survey • Maintained records for my assignment area • Collect data using iPaq brand PDA equipped with ArcPad • Produced employee auditing software using VB.net and ArcObjects
  • New York State Department Of Agriculture And Markets, Division Of Milk Control And Dairy Services
    Dairy Products Specialist, Trainee #1
    New York State Department Of Agriculture And Markets, Division Of Milk Control And Dairy Services Jun 2007 - Jun 2008
    • Inspected dairy farms and milk processing facilities in enforce the pasteurized milk ordinance • Tested milk products for fat content to guarantee proper standards of identity
  • New York State Department Of Agriculture And Markets, Division Of Plant Industry
    Assistant Farm Products Inspector #1
    New York State Department Of Agriculture And Markets, Division Of Plant Industry May 2002 - Jun 2007
    • Collected leaf samples from stone fruit orchards for Plum Pox Virus testing • Mapped stone fruit orchards in Niagara, Orleans, Monroe and Wayne county using GPS and ArcPad • Wrote 2007 Plum Pox Virus Field Crew Survey Manual • Trained incoming USDA-APHIS and State employees on sampling procedure • Maintained insect traps for the 2006 Sirex Woodwasp Delimiting Survey

Jonathan Goergen Skills

Gis Geowepp Modeling Geographic Information Science C# Java Php Sql Databases Data Mining Remote Sensing Python Arcgis Spatial Analysis Data Collection Weka Envi Erdas Imagine Lidar Arcobjects Research Geography Geospatial Modeling Data Analysis Microsoft Office Public Speaking

Jonathan Goergen Education Details

  • University Of Iowa
    University Of Iowa
    Geography
  • University At Buffalo
    University At Buffalo
    Geography
  • Buffalo State University
    Buffalo State University
    Geography
  • State University Of New York College At Potsdam
    State University Of New York College At Potsdam
    Secondary Education And Teaching
  • State University Of New York College At Potsdam
    State University Of New York College At Potsdam
    Physics

Frequently Asked Questions about Jonathan Goergen

What company does Jonathan Goergen work for?

Jonathan Goergen works for California Geological Survey

What is Jonathan Goergen's role at the current company?

Jonathan Goergen's current role is Research Data Specialist 2 (GIS).

What is Jonathan Goergen's email address?

Jonathan Goergen's email address is jo****@****owa.edu

What is Jonathan Goergen's direct phone number?

Jonathan Goergen's direct phone number is +171638*****

What schools did Jonathan Goergen attend?

Jonathan Goergen attended University Of Iowa, University At Buffalo, Buffalo State University, State University Of New York College At Potsdam, State University Of New York College At Potsdam.

What are some of Jonathan Goergen's interests?

Jonathan Goergen has interest in Adaptation To Climate Change, Sustainability, Energy Policy, Parking Policy, Gardening, Rugby, Endurance Biking, Lidar Data Applications, Utility Bikes, Agricultural Policy.

What skills is Jonathan Goergen known for?

Jonathan Goergen has skills like Gis, Geowepp, Modeling, Geographic Information Science, C#, Java, Php, Sql, Databases, Data Mining, Remote Sensing, Python.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.