How to Produce Prediction Map in GIS With ArcGIS and Excel?

Name: How to Produce Prediction Map in GIS With ArcGIS and Excel?
Rating: 4.2 (142 reviews)

Step By Step Guide To Produce and Validate Hazards Prediction Map With ArcGIS and Excel Using Frequency Ratio Model

Created byDr. Omar AlThuwaynee

Last updated 8/2019

English

What you'll learn

UPDATES March 2019: Course full data was uploaded with Section 2.
You’ll have my continuous support, taking your hand step-by-step to develop your first high quality map using real data
Writing a journal article, MOST WELCOME, I am available to help you to produce a scientific article qualified for peer review acceptance
I will be with you to interpret the results, we will discuss about the technical issues as well as how to make your results meaningful
Free access to all my previous publications techniques and methods: Search for "Omar Althuwaynee on Researchgate"

Course content

6 sections • 18 lectures • 1h 37m total length

Introduction to common statistical based model and Frequency ratio (FR) concept8:02
Explore the frequency ratio concept and basic statistical models for predicting GIS maps with ArcGIS and Excel. Learn to assess correlation and the contribution of predictor factors to target locations.

Introduction to the course data1:33
Dear Students, Data is provided with the link. please let me know if you face any issue accordingly.
Thanks,
Althuwaynee
Training and testing data preparation using ArcGIS4:00
Prepare training and testing data for GIS prediction maps using ArcGIS by selecting appropriate data, determining sample size, and ensuring clean data preparation.
Training and testing data preparation using Open source QGIS (Extra)3:03

Independent factors classification4:02
Pixels amount consistency of independent factors maps2:12
Analyze pixel-level consistency across independent factor maps to improve prediction maps in GIS using ArcGIS and Excel.
Tabulate the area of training data4:50
Tabulate the area of training data to support prediction maps in GIS, using a table to organize point data and area measurements for ArcGIS and Excel.

Data transfer from ArcGIS to Excel2:00
Transfer data from ArcGIS to Excel by preparing a table that organizes class numbers and points by ability, enabling a clear workflow for a prediction map.
Model parameters calculations in Excel4:31
Compute model parameters in Excel for GIS prediction maps, applying point-based ratios and class frequencies to derive meaningful zone and class calculations for ArcGIS workflows.
Calculate the Frequency ratio values10:31
Examine how to select and apply factors for GIS prediction maps, discuss rejection rates, and practice rigorous problem solving using ArcGIS and Excel.
Calculate the prediction rate values5:13
Calculate the prediction rate values for GIS-based prediction maps with ArcGIS and Excel by using minimums, divisions, a symbol table, and the susceptibility index as the final metric.
Calculate the prediction rates using pairwise comparison method6:58
Calculate prediction rates using the pairwise comparison method in GIS with ArcGIS and Excel by applying weights, reconciling rejection rates, and converting between methods to reveal factor relationships.

Reclassify the covariates using frequency ratio values6:22
Reclassify the covariates using frequency ratio values and apply natural breaks to define classes for a GIS prediction map. Evaluate class contributions and adjust classifications to improve map coverage.
Produce prediction map using the prediction rates3:41
Produce a prediction map by using prediction rates, adjusting weights and factors to reveal susceptible areas, and balance detail with data availability for precise GIS output.
Produce prediction map using the pairwise comparison2:20
Apply pairwise comparison to build a prediction map in GIS, using data factors to derive meaningful results from experimental data and avoid misleading conclusions.

Requirements

UPDATES March 2019: Course full data was uploaded with Section 2.
No prior statistical modelling background needed
Interest in developing a valid susceptibility map for geosciences applications using real life Data
Prior Familiarity With the Geographic information systems
Basic experience in ArcGIS software from Esri and Microsoft Excel
This Course Will be Demonstrated on a Windows OS

Description

Since the late 1980s, the widely popular and efficient geographic information system (GIS) has facilitated the development of new machine learning, data-driven, and empirical methods that reduce generalization errors.

In the this course, i have shared a famous and solid bivariate technique (Frequency ratio), to help you start your first prediction map using ArcMap and Excel only.

UPDATES March 2019: Course full data was uploaded with Section 2.

I will explain the spatial correlation between; prediction factors, and the dependent factor. Also, how to find the autocorrelations between; the prediction factors, by considering their prediction importance or contribution. Finally, I will Produce susceptibility map using; Microsoft Excel and ESRI ArcGIS only. Model prediction validation will be measured by most common statistical method of Area under the curve (AUC).

Who this course is for:

Students and researchers of environmental engineering sciences, Ecology, and Other Natural Sciences
Any discipline who wanted to start easily using GIS in producing susceptibility mapping purposes and hazard assessment
Beginner in geographical information system software's, looking for quick self development

How to Produce Prediction Map in GIS With ArcGIS and Excel?

What you'll learn

Explore related topics

Course content

Introduction to prediction mapping methods with GIS1 lecture • 8min

Training and testing data preparation3 lectures • 9min

Data preparation3 lectures • 11min

Frequency ratio model preparation in Excel5 lectures • 29min

Prediction map production3 lectures • 12min

Model evaluation using Area Under Curve (AUC) model3 lectures • 28min

Requirements

Description

Who this course is for: