Meihao Fan
Expertise in Hydro-climatology 
Posts by Collection
people
projects
Climate Change: Impact on agriculture across Southeast Asia
Published:
Singapore-MIT Alliance project and World Bank project 
Climate Change: Impact on urban flooding in Singapore
Published:
Public Utilities Board (PUB) project 
ABC Waters: Low impact development (LID) for Singapore environment
Published:
PUB-TMSI-Monash University project 
Drought Prediction across Australia
Published:
ARC linkage grant and Department of Industry, NSW, Australia 
publications
Few‐Shot Multihop Question Answering over Knowledge Base
Published in Wireless Communications and Mobile Computing, 2021
This paper is about Question Answering over Knowledge Base.
Recommended citation: Fan, Meihao, Lei Zhang, Siyao Xiao, and Yuru Liang. "Few-shot multi-hop question answering over knowledge base." arXiv preprint arXiv:2112.11909 (2021). https://onlinelibrary.wiley.com/doi/abs/10.1155/2022/8045535
Cost-Effective In-Context Learning for Entity Resolution: A Design Space Exploration
Published in IEEE 40th International Conference on Data Engineering (ICDE), 2024
This paper is about LLM for Entity Resolution.
Recommended citation: Fan, Meihao, Xiaoyue Han, Ju Fan, Chengliang Chai, Nan Tang, Guoliang Li, and Xiaoyong Du. "Cost-effective in-context learning for entity resolution: A design space exploration." In 2024 IEEE 40th International Conference on Data Engineering (ICDE), pp. 3696-3709. IEEE, 2024. https://ieeexplore.ieee.org/abstract/document/10597751
AutoPrep: Natural Language Question-Aware Data Preparation with a Multi-Agent Framework
Published in , 2024
This paper is about Multi-agent framework for TableQA.
Recommended citation: Fan, Meihao, Ju Fan, Nan Tang, Lei Cao, Guoliang Li, and Xiaoyong Du. "AutoPrep: Natural Language Question-Aware Data Preparation with a Multi-Agent Framework." arXiv preprint arXiv:2412.10422 (2024). https://arxiv.org/abs/2412.10422
Reward-SQL: Boosting Text-to-SQL via Stepwise Reasoning and Process-Supervised Rewards
Published in , 2025
This paper proposes Reward-SQL, a framework for improving Text-to-SQL reasoning using process-supervised reward models.
Recommended citation: Zhang, Yuxin, Meihao Fan, Ju Fan, Mingyang Yi, Yuyu Luo, Jian Tan, and Guoliang Li. "Reward-sql: Boosting text-to-sql via stepwise reasoning and process-supervised rewards." arXiv preprint arXiv:2505.04671 (2025). https://arxiv.org/pdf/2505.04671
software
Predictor identifier: Nonparametric PREDiction (NPRED)
The open-source R package NPRED is used to identify the meaningful predictors to the response from a large set of potential predictors.
WASP: Wavelet System Prediction
The open-source software WASP is used for system modeling and prediction.
WQM: Wavelet-based Quantile Mapping
The open-source software WQM is used for post-processing numerical weather prediction.
synthesis: Generate Synthetic Data from Statistical Models
Generate synthetic time series from commonly used statistical models, including linear, nonlinear and chaotic systems.
talks
Urban Surface Characteristics Study Using Time-area Function Model: A Case Study in Saudi Arabia
Published:
Recommended citation: Jiang, Z., Molkenthin, F., & Sieker, H. (2016). Urban Surface Characteristics Study Using Time-area Function Model: A Case Study in Saudi Arabia. 12th International Conference on Hydroinformatics HIC 2016, Poster, Songdo Convensia Convention Center, 21-26 August 2016, FP-10.
Impacts of Climate Change on Rice Crop Yields in Vietnam
Published:
Recommended citation: Jiang, Z., Raghavan, S. V., Hur, J., Sun, Y., and Liong, S.-Y.: Impacts of Climate Change on Rice Crop Yields in Vietnam, Asia Oceania Geosciences Society (AOGS) 2017, Suntec Singapore Convention & Exhibition Centre, 6-11 August 2017, IG04-A026. Download talk here
Drought prediction for improved water resource management: A wavelet-based system prediction approach
Published:
Recommended citation: Jiang, Z., Sharma, A., and Johnson, F.: Drought prediction for improved water resource management: A wavelet-based system prediction approach, STAHY 2019, Wentian Building, Hohai University, Nanjing, 19-20 October 2019. Download talk here
A wavelet-based method to analyse sustained hydrological anomalies under climate change
Published:
Recommended citation: Jiang, Z., Sharma, A., and Johnson, F.: A wavelet-based method to analyse sustained hydrological anomalies under climate change, MODSIM 2019, National Convention Centre Canberra, 1-6 December 2019, K22. Download talk here
Forecasting drought revisited - the importance of spectral transformations to dominant atmospheric predictor variables
Published:
Recommended citation: Sharma, A., Jiang, Z., and Johnson, F.: Forecasting drought revisited - the importance of spectral transformations to dominant atmospheric predictor variables, EGU General Assembly 2020, Online, 4-8 May 2020, EGU2020-12334, https://doi.org/10.5194/egusphere-egu2020-12334, 2020. Download talk here
Hydro-climatological forecasting: A view from the spectral domain
Published:
Recommended citation: Jiang, Z., Sharma, A. and Johnson, F., Hydro-climatological forecasting: A view from the spectral domain. In AGU Fall Meeting 2020. San Francisco, CA, USA, H184-07. Link Download PPT Video
Advanced wavelet-based variance transformation algorithms for ENSO forecasting over long lead times
Published:
Recommended citation: Jiang, Z., Sharma, A., and Johnson, F.: Advanced wavelet-based variance transformation algorithms for ENSO forecasting over long lead times, MODSIM 2021, The University of Sydney and International Convention Centre, 5-10 December 2021, K5. Video
Applications of the wavelet-based method for postprocessing rainfall forecasts – Implications for urban flood forecasting
Published:
Recommended citation: Jiang, Z., & Johnson F.: Applications of the wavelet-based method for postprocessing rainfall forecasts – Implications for urban flood forecasting, Asia Oceania Geosciences Society (AOGS) 2022, Singapore, 1-5 August 2022, HS37-A006. Download talk here
Hydrologic forecasting over long lead times: A wavelet-based variance transformation approach
Published:
Recommended citation: Jiang, Z., Sharma, A., & Johnson F.: Hydrologic forecasting over long lead times: A wavelet-based variance transformation approach, Asia Oceania Geosciences Society (AOGS) 2022, Singapore, 1-5 August 2022, HS34-A011. Download talk here
Could the 2019-20 Australia bushfires or 2020-22 floods be predicted using CMIP decadal prediction?
Published:
Recommended citation: Jiang, Z., Choudhury, D., and Sharma, A.: Could the 2019-20 Australia bushfires or 2020-22 floods be predicted using CMIP decadal prediction?, EGU General Assembly 2023, Vienna, Austria, 24–28 Apr 2023, EGU23-10096, https://doi.org/10.5194/egusphere-egu23-10096, 2023. Download talk here
Wavelet-based post-processing of NWP precipitation forecasts
Published:
Recommended citation: Johnson, F. and Jiang, Z.: Wavelet-based post-processing of NWP precipitation forecasts, EGU General Assembly 2023, Vienna, Austria, 24–28 Apr 2023, EGU23-14123, https://doi.org/10.5194/egusphere-egu23-14123, 2023. Download talk here
Enhancing water supply management through improved rainfall anomaly forecasting over medium to long term
Published:
Recommended citation: Jiang, Z., Kibria, G., and Sharma, A.: Enhancing water supply management through improved rainfall anomaly forecasting over medium to long term, International Union of Geodesy and Geophysics (IUGG) 2023, Berlin, Germany, 11–20 July 2023, IUGG23-4782, https://doi.org/10.57757/IUGG23-4782. Download talk here
Unlocking the Future of Rainfall: Enhancing Interannual Forecasts with Spectral Transformations of CMIP Decadal Predictions
Published:
Recommended citation: Jiang, Z., Choudhury, D., and Sharma, A.: Unlocking the Future of Rainfall: Enhancing Interannual Forecasts with Spectral Transformations of CMIP Decadal Predictions, Asia Oceania Geosciences Society (AOGS) 2023, Singapore, 31 July-04 August 2023, HS10-A010. Download talk here
Navigating Water Resource Management: A Forecasting Framework for Interannual Drought Projections
Published:
Recommended citation: Jiang, Z., Kibria, G., and Sharma, A.: Navigating Water Resource Management: A Forecasting Framework for Interannual Drought Projections, EGU General Assembly 2024, Vienna, Austria, 14–19 Apr 2024, EGU24-13279, https://doi.org/10.5194/egusphere-egu24-13279, 2024. Download talk here
Enhanced daily streamflow simulation for future climates using a non-parametric method with variable selection and transformation
Published:
Recommended citation: Jiang, Z., Haberlandt, U., and Sharma, A.: Enhanced daily streamflow simulation for future climates using a non-parametric method with variable selection and transformation, Asia Oceania Geosciences Society (AOGS) 2024, South Korea, 23 June-28 June 2024, HS13-A009. Download talk here
teaching
CVEN3501 Water Resources Engineering
Undergraduate course, School of Civil and Environmental Engineering, UNSW Sydney, 2019
- Teaching period: T1, 2019
- Position: Teaching Assistant
- Role: Demonstrator and Tutor
- Number of students: 610
- Course Profile: Handbook
CVEN9625 Fundamentals of Water Engineering
Masters course, School of Civil and Environmental Engineering, UNSW Sydney, 2019
- Teaching period: S2, 2018; T1&3, 2019.
- Position: Teaching Assistant
- Role: Demonstrator and Tutor
- Number of students: ~200
- Course Profile: Handbook
CVEN9612 Catchment and Water Resources Modelling
Masters course, School of Civil and Environmental Engineering, UNSW Sydney, 2023
- Teaching period: T3, 2022-2024.
- Position: Coordinator
- Role: Demonstrator and Instructor
- Number of students: ~20
- Course Profile: Handbook
CVEN4507 Advanced Water Engineering
Undergraduate course, School of Civil and Environmental Engineering, UNSW Sydney, 2024
- Teaching period: T2, 2024.
- Position: Instructor
- Role: Demonstrator & Workshops
- Number of students: ~20
- Course Profile: Handbook