Geothermal Project Documentation

Project Overview

This project focuses on geothermal data analysis and visualization for Texas, including well data, temperature gradients, and zone mapping.

Project Structure

Data Directory

Contains all raw and processed data files organized into three main subdirectories:

1. map_data_calc/

Contains calculation and analysis files for mapping purposes:

zones_of_intereest/

• zones.ipynb: Main notebook for zone analysis and categorization
• zone_categories.csv: Defines different geothermal zones and their characteristics
• well_clusters_detailed_analysis.csv: Contains detailed analysis of well clusters
• wells_with_bht.xlsx: Well data including Bottom Hole Temperature measurements

interpolation/

• wells_with_interpolated_gradient.xlsx: Contains interpolated gradient data for wells
• texas_wells.csv: Comprehensive well data for Texas
• texas_gradient.csv: Gradient calculations for Texas
• texas_data.ipynb: Notebook for Texas-specific data processing

BHT/

• wells_with_interpolated_gradient.xlsx: Interpolated gradient data
• wells_with_bht.xlsx: Well data with Bottom Hole Temperature
• BHT.ipynb: Notebook for Bottom Hole Temperature analysis

2. wells_data/

Contains well-specific data and analysis:

• well_in_texas.ipynb: Main notebook for well data analysis and processing
• wells in texas.xlsx: Comprehensive well data in Excel format
• texas_wells.csv: Well data in CSV format for easier processing

(Data source: WellDatabase) ❗

3. gradient_data/

Contains temperature and gradient-related data:

IRENA_temperature/

• IRENA_hdr_T3km_global.tiff: Temperature data at 3km depth
• IRENA_hdr_T2km_global.tiff: Temperature data at 2km depth
• IRENA_hdr_T1km_global.tiff: Temperature data at 1km depth
• geothermal_data.ipynb: Notebook for processing IRENA temperature data

(Data source: IRENA Global Atlas) ❗

Main files:

• texas_data.csv: Texas-specific temperature and gradient data
• gradient.ipynb: Main notebook for gradient calculations
• geothermal_gradient.xlsx: Comprehensive gradient data
• Depth-specific geothermal data files (1km, 2km, 3km)

Maps Directory

Contains visualization and mapping files organized into three subdirectories:

1. geothermal map/

• map_gradient_from_xlsx.png: Visualization of geothermal gradients
• map.ipynb: Notebook for generating gradient maps
• wells_with_bht.xlsx: Well data used for gradient mapping

2. zones map/

• map_zones.png: Visualization of different geothermal zones
• map.ipynb: Notebook for zone mapping and visualization
• zone_categories.csv: Zone definitions and characteristics
• well_clusters_detailed_analysis.csv: Analysis used for zone mapping

3. well map/

• map_wells_density_green_red.png: Well density visualization with color coding
• map.ipynb: Notebook for well mapping and density calculations
• wells_with_bht.xlsx: Well data used for mapping

Data Processing Pipeline

1. Data Collection

   • Raw well data from Texas
   • Temperature data from IRENA
   • Bottom Hole Temperature measurements

2. Data Processing

   • Well data analysis and cleaning
   • Temperature gradient calculations
   • Zone categorization and analysis

3. Visualization

   • Gradient maps
   • Zone maps
   • Well density maps
   • Interpolation of missing data

File Formats and Usage

• Data Files

  • CSV: For data processing and analysis
  • XLSX: For comprehensive data storage and sharing
  • TIFF: For temperature raster data

• Analysis Files

  • Jupyter Notebooks (.ipynb): For data processing and analysis
  • Python scripts: For specific calculations

• Visualization Files

  • PNG: For map visualizations
  • Interactive maps: Generated from notebooks (will be released soon)

Map Visualizations

Geothermal Gradient Map

Map showing geothermal gradients across Texas

Well Density Map

Map showing well density distribution with color coding (green to red)

Zones Map final result ⭐

Map showing different geothermal zones in Texas

Example Well of Data ID-6 and Radius-0.573583

Cluster Lat	Cluster Lon	Well Name	Fluid Type	Well Lat	Well Lon	Depth (ft)	Gradient	Use
32.39343152727	-102.2998417446	STATE UNIVERSITY HUTEX CONS. 5	BLACK OIL	32.388240814208	-102.3065795898	12574	3.833	Electricity generation
32.39343152727	-102.2998417446	UNIVERSITY "12" 4	OIL WELL	32.391120910645	-102.2940139771	12600	3.84	Electricity generation
32.39343152727	-102.2998417446	UNIVERSITY -E- 4D	BLACK OIL	32.392730712891	-102.3033905029	12570	3.831	Electricity generation
32.39343152727	-102.2998417446	UNIV "E" 2	OIL WELL	32.393680572510	-102.2992630005	12571	3.832	Electricity generation
32.39343152727	-102.2998417446	UNIVERSITY "12" 3	OIL WELL	32.394618988037	-102.2951354980	12526	3.818	Electricity generation
32.39343152727	-102.2998417446	UNIVERSITY -E- 1A	BLACK OIL	32.396450042725	-102.3001403809	12650	3.856	Electricity generation
32.39343152727	-102.2998417446	UNIV "E" 1	OIL WELL	32.397178649902	-102.3003692627	12580	3.834	Electricity generation

Dependencies

• Python 3.x
• Required Python packages:
  • pandas
  • numpy
  • matplotlib
  • folium
  • geopandas
  • rasterio (for TIFF processing)