Development of a Geographic Information Systems Baseline Spatial Geodatabase Template for Evaluating Potential and Predicted Environmental Impacts for Sustainable Environmental Impact Assessment of Mining in Sierra Leone

Baseline Environmental Impact Assessment (EIA) of mining projects in Sierra Leone creates a challenging environment for data collection and impact prediction. Application of geographic information systems provides suitable spatial analysis data collection methods to reduce the challenges created by mining environments. This research develops a baseline spatial geodatabase template for evaluating potential and predicted environmental impacts assessment of mining projects in Sierra Leone. It is observed that spatial analysis of impacts of mining projects on the environmental attributes, especially air, noise, water, land, and socio-economy in mining areas is largely unex-plored in Sierra Leone. The literature review revealed that no complete GIS spatial data geodatabase collection template appears to have been developed to date to provide an integrated sustainable spatial analysis and modelling tool for EIA and environmental management of mining in Sierra Leone. Therefore developing a Geographic Information Systems baseline geodatabase template for the evaluation of potential and predicted environmental impact for sustainable environmental impact assessment of mining in Sierra Leone will: 1) provide support to the data acquisition process of environmental impact assessment, 2) offer a concept for developing analysis methods for environmental management of mining, 3) minimize the undesired environmental impacts of mining, and 4) give an optimal proposal for data collection and analysis of mining industry in attaining sustainable development in Sierra Leone. Due to the limited available data, a conceptual GIS database tem-How plate has been developed rather than a database case study of a mining site. No site investigation and data collection were undertaken. The geospatial database template was designed using ArcCatalog, ArcGIS 10.7.1. software, through the following steps: exploration of the general data requirement of environmental impact assessment studies of mining, the definition of the general baseline datasets requirement of environmental impact assessment in mining, structuring of the environmental impact assessment baseline spatial geodatabase, creating the geographic geodatabase dictionary, selecting, matching geographic data with geodatabase structure, designing the feature class and attributes, creating the baseline GIS geodatabase template. The GIS spatial geodatabase template has several advantages for environmental impact assessment of mining including avoiding data redundancy, integrating data into a single database, creating uniformity in data collection, easy to find and track data, integrated spatial and non-spatial data, and reducing the volume of data.


Introduction
Environmental Impact Assessment (EIA) was formally adopted in Sierra Leone in 2010 (EPA-SL Act, 2010) as a measure to protect the environment and to reduce environmental degradation associated with major developmental projects. Although Environmental Impact Assessments (EIAs) are dependent on geo-spatial information to make an assessment, there are no rules set on how to conduct an environmental assessment on mining activities in Sierra Leone. Since GIS is a vital tool and efficient in data collection, storage, analysis, and collation, it has become an appropriate mechanism for creating an environmental information system spatial geodatabase. This storage ability makes environmental spatial and non-spatial data easier to upgrade, update, process, and retrieve as needed. GIS is applicable in all stages of the EIA process: from the acquisition, storage, processing, manipulating and display of thematic information relative to the vulnerability of the affected natural resources. Geographic Information Systems (GIS) can improve the gathering, storage manipulation, transformation and processing of data and information. GIS contribution to environmental impact assessment studies is very important and very useful for managing environmental impact assessment and data consistently from field measurement (Kamara, 2019). Generally, an impact assessment study is an information collection and analysis process; thus, up-to-date, available, and relevant data are needed to attain useful results (Bulla et al., 2004). The section of the EIA report of mining that often describes the detailed environmental baseline conditions of a particular mining site demonstrates whether the EIA Consultant truly under-stands the environmental, social, health, and economic impact that the proposed mining project may create. For instance, if the EIA does not include details about the existing land cover/land use, vegetation, surface and groundwater quality, air quality, and the abundance and distribution of threatened and endangered species, then it simply is not possible for the EIA Consultant to formulate accurate information about how the project would impact land cover/land use, vegetation, surface and groundwater quality, air quality, and the abundance and distribution of threatened and endangered species. However, application of GIS in mining EIA in Sierra Leone is constrained by the availability of an appropriate digital electronic baseline geodatabase on environmental parameters and datasets, such as base maps on Land use/land cover, soil, geology, topography, population density, socio-economic levels, road accessibility, air quality, water quality, noise level, biological content, historical value, archaeological, climate change to name a few. Although very significant work has been done in environmental impact assessment and sophisticated Geological Information Systems has been developed to determine the location of mineral deposit and ore bodies, no complete GIS spatial geodatabase template for spatial data collection appears to have been developed to date to provide an integrated sustainable spatial analysis and modelling tool for EIA and environmental management of mining in Sierra Leone. This is due to 1) the absence of comprehensive understanding of interrelated environment impacts caused by the mining of different minerals, 2) the environmental uniqueness of each mine, which make it difficult to develop general tools of EIA analysis and models, 3) the availability of adequate spatial data, information and appropriate GIS technics, 4) because of the dynamic characteristics and multivariate nature of the environment, it has often been difficult to collate, analyze and interpret its datasets, 5) lack of appropriate temporal and spatial resolution of remotely sensed imageries and accurate geospatial data can be a major limitation on spatial modeling, 6) finally, the availability of GIS professionals and affordability of GIS software and related hardware is a major constraint on EIA budgeting, especially for developing countries like Sierra Leone. Most EIA studies of mining projects have focused only on one or a limited set of impacts of the project on the physical, ecological, or social environment. Thereby, such studies have not provided a holistic picture of the entire environmental impact scenario. The research aims to design a Geographic Information Systems baseline geodatabase template for the evaluation of potential and predicted environmental impact for sustainable environmental impact assessment of mining in Sierra Leone. The expected output is an application in the ArcGIS software environment where the no GIS expert and environmentalist can easily use the templates to collect and analyze the data and get a comprehensive analysis and results. This study will add a more meaningful contribution to studies already done by other researchers in the integration of GIS and GIS software to solve the problems in the EIAs of mining. Each step will be explained in detail in the subsequent sections. Therefore, it is expected that the environmental databases from mining companies have uniformity in all data collection procedures, field measurement procedures, results classification and data management, analysis method, and reporting data systems to the environmental impact assessment. The GIS spatial geodatabase template has several advantages for environmental impact assessment of mining including avoiding data redundancy, integrating, data into a single database, creating uniformity in data collection, easy to find and track data, integrated spatial and non-spatial data, and reducing the volume of data storage. This study will add a more meaningful contribution to studies already done by other researchers in the integration of GIS and GIS software to solve the environmental problems of mining. According to the trial done on the baseline GIS spatial geodatabase template, it has shown some encouraging results for evaluating potential and predicted environmental impacts assessment of mining projects in Sierra Leone. However, using the baseline spatial geodatabase template has many advantages; however, there are also several challenges to implement it as stated above.

Materials and Methods
The process of designing the geospatial database was accomplished by using a relational personal geodatabase concept. The geodatabase consists of ten feature datasets; the geospatial database template was designed using ArcCatalog, Arc-GIS 10.7.1. software, through the following steps: 1) exploration of the general data requirement of environmental impact assessment studies of mining, 2) defining the general baseline datasets requirement of environmental impact assessment in mining, 3) structuring of the environmental impact assessment baseline spatial geodatabase, 4) creating the geographic geodatabase dictionary, 5) selecting, matching geographic data with geodatabase structure, 6) designing the feature class and attributes, 7) creating the baseline GIS spatial geodatabase template.
Each step will be explained in detail in the subsequent sections.

Exploration of the General Data Requirement
The first step in this research was to study the specifications relative to data con- Leone. In the course of my investigation, I determined the general primary environmental data that the laws of Sierra Leone prescribe or recommends, or that were used by the authors of the examined environmental impact assessments for the various mining companies. On this basis, a data list was compiled containing only those data fields that occurred with at least 85% frequency in the examined impact assessment studies as a result of statistical evaluation.

Definition of the General Datasets Requirement
In examining the phases and work stages of environmental impact assessment, it was established that the data collection and surveying phase is primarily the basic state in which databases or information systems can serve as potential data sources. Consequently, in this research, the analysis of data needed for the examination of the basic state of the environment was emphasized; hence, they are taken into consideration for impact assessment and appraisal. The following gives a more detailed discussion of the specific kinds of environmental baseline datasets that an EIA for a proposed mining project needs to contain. Those environmental data were incorporated into my master data list, which occurred in at least (85%) of the studies that were investigated. Table 1 shows the primary data grouped as elements of the environment.

Structuring the Geospatial Database
The structure of the spatial geodatabase includes two types of data, i.e. Spatial and non-spatial (attributes data). The structure of the spatial geodatabase contains ten features datasets namely: the basemap dataset, the air quality dataset, water quality dataset, the population dataset, the flora and fauna datasets (biological dataset), land cover/land use datasets, socio-economic datasets, waste management dataset, climate change dataset and soil quality dataset as shown in Figure 1.

Creating the Geographic Geodatabase Dictionary
The data dictionary is the result of the analysis phase of existing needs in terms of geospatial data. This data is available either in analog form (maps) or digital (computer support). A data dictionary is a collection of metadata and necessary reference data for designing a geographic database and is a catalog or table containing information about the datasets stored in a database It describes data definition, data type, coordinate system, feature class field properties, relationship diagram, and reference table. It's contained the full names of attributes, meanings of codes, the scale of the source data, accuracy of locations, and map projections used. Creating a data dictionary allows other users to view formation about the data. The data dictionary is useful for environmental practitioners, engineers, surveyors, GIS experts, and analysts for data processing and analysis, GIS users and decision-makers, environmental technicians involving in EIA studies of mining. This is the main referential of the database template. It is often represented by a table containing the name, code, data type, and comments, etc. as shown in Figure 2.

Selecting, Matching Geographic Data with Geodatabase Structure
GIS database design is about identifying the thematic layers to be used and specifying the contents and representations of each thematic layer. This involves defining how the geographic features are to be represented (for example, as points, lines, polygons, raster's, or tabular attributes); how the data is organized into feature classes, attributes, and relationships; and the spatial and database integrity rules for implementing rich GIS behavior using topologies, networks, raster catalogs, and so forth. Designing of feature classes and attributes is the most important step in the building of the template databases because this step determines what the database looks like. This step includes determination of the following feature class name, coordinate system, data type, field name and field properties, code for each environment parameters, and creating reference tables. The baseline spatial geodatabase contains a series of GIS data layers. The list above, sorted by layer category, shows the vector data layers in the database that model real-world features as points, lines, or polygons in a UTM (WGS 1984) projected geographic coordinate system. All feature classes in the geodatabase have the following common attributes as shown in Table 2.
The NAME attribute is used in ArcMap for labelling purposes, and most of the feature classes have a typical characteristic that is used for symbolizing features. The remaining attributes are primarily used for quality control and metadata purposes. The environmental impact assessment baseline spatial geodatabase model template consists of a set of core templates (sub-models) and extensions. These core templates and extensions can be linked using a common theme in the model, i.e. the concession area.
A concession area can be represented as a polygon, using a unique identifier for each concession area. Templates may interact with each other with a combination of spatial and non-spatial data with reference information to form the environmental impact assessment baseline spatial geodatabase layers, the geodatabase data model is dynamic; it will provide flexibility for end-users to manipulate the selection criteria and organizing them on a priority basis depending on the development strategies considered.

Creating the Baseline GIS Geodatabase Template
The GIS baseline geodatabase was created in the ArcCatalog of the ArcGIS Desktop 10.7.1. Software. This is a collection of feature datasets and a feature dataset is a group of feature classes. This step includes 1) creating personal geodatabase, 2) creating feature datasets, 3) creating feature class, and 4) determine the feature class properties. Figure 3 shows the personal Environmental GIS baseline Spatial Geodatabase in the ArcCatalog, ArcGIS Software. This geodatabase contains ten (10) feature datasets. A feature is a collection of features representing the same geographic elements such as boreholes, drill holes, parcels, or soil types, etc. All the features in a future class have the same spatial representation (for example point, line, or polygon) and share a common set of descriptive attributes. Feature datasets are organized collections of related feature classes (Maryati et al., 2012). The feature class properties (Figure 4) provide information regarding field properties, domain indexes, subtypes, relationship, representation, coordinate system, tolerance, and resolution. All information about the spatial data is stored in the field's attribute. The field properties include the field name, data type, alias, allow null values, default value, and length as shown in Figure 4. The baseline environmental GIS spatial database template for a proposed mining project contained ten (10) datasets. The creation of each of these datasets is explained in the following sections.

Creating the Baseline Base Map Dataset
The base map datasets are the datasets that contain the feature classes that are to be used as a base map for the creation of the thematic maps for the baseline environmental impact assessment of mining projects. This dataset includes Administrative boundary, Provincial boundary, Concession area boundary, District boundary, Chiefdom boundary, Section boundary, Village boundary Infrastructure, Public road, mined road, Railway, and River as shown in ( Figure 5). From Figure 5, the GIS Base map personal geodatabase was created in the ArcCatalog of the ArcGIS Desktop 10.7.1. Software. Table 3 shows the description of the baseline base map layers' attributes.

Creating the Baseline Land Cover/Land Use Dataset
The land cover/land use datasets are the datasets that contain the feature classes to be used as a base map for the creation of the land cover/land use thematic maps for the baseline environmental impact assessment of mining projects. It contains mainly the feature classes related to the mining operations in the project concession area which includes; land cover feature class, land use feature class, mined-out land feature class, land topography feature class, soil type feature class, geology type feature class as shown in Figure 6. Table 4 shows the description of the baseline land cover/land use layers' attributes.

Creating the Baseline Air Quality Dataset
Baseline Air quality datasets for a mining project concession area are critical to evaluating the potential distribution of air pollutants and their effects in the area of influence. Air pollutants can travel long distances, so baseline air quality information should be considered about meteorological conditions, wind patterns, geological formations, and anything else that might influence the distribution of air pollutants. Baseline air quality datasets should include the following: location of air monitoring and/or sampling stations and measurements of these common parameters; Particulate matter (PM10 and PM2.5), Carbon monoxide (CO), Nitrogen oxides (NOx), Lead (Pb), cadmium (Cd), arsenic (As), mercury (Hg), Total Suspended Solids (TSS), and Sulfur dioxide (SO 2 ). This dataset includes noise, air temperature, air humidity, wind speed rainfall, air quality point, ambient air quality, and air vibration, Figure 7 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. As can be seen in Figure 7, the Air quality datasets contain eight feature classes. Attributes of these future classes are further illustrated in Table 5.

Creating the Baseline Wildlife, Flora and Fauna Datasets
The wildlife datasets comprise all living things that are undomesticated. This includes plants, animals (vertebrates, birds, fish), and other organisms (invertebrates). The baseline wildlife, flora, and fauna datasets must include a list of wildlife species within the project area and interactions between species. This should include all endemic flora and fauna in the project concession area that have a special conservation status-for example, listed by the International Union for Conservation of Nature (IUCN) or by national legislation as a threatened Journal of Geoscience and Environment Protection or endangered species, a description of the region and species distribution. The dataset contains mainly feature classes related to wildlife, flora, fauna, and biodiversity. This dataset contains six feature classes includes terrestrial species, aquatic species, habitats critical to ecological processes, biology point. Figure 8 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. Each feature class contains information regarding mapping point names and UTM XY position coordinates. Attributes of these future classes are further illustrated in Table 6.

Creating the Baseline Surface and Groundwater Quality Dataset
The baseline surface and groundwater quality datasets must include a list of Common water quality attributes such as Physical, chemical: pH, turbidity, sus- water quality (surface water or groundwater) samples are collected, they should be analyzed for the full suite of parameters and contaminants of concern. This baseline surface and groundwater quality datasets contain seven feature classes including Water pH, Turbidity, TSS (Total Suspended Sediment), salinity, water quality point, Fe Total, and Mn Total. Figure 9 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. Attributes of these future classes are further illustrated in Table 7.

Creating the Baseline Soil Quality Dataset
The baseline soil quality datasets mainly contain feature classes related to soil based on conditions typically found in the mining concession area. Soil baseline studies are based on three major sources of information: desk study, fieldwork, and laboratory analysis. Baseline soil quality datasets should include measure-S. M. Kamara Journal of Geoscience and Environment Protection ments of these common parameters: soil composition, soil strength (resistance to crushing), mineral content, and pH. Some measure of water content, organic content, soil texture, particle size, and bulk density. This dataset contains six feature classes includes soil sample points, dumping soil area, soil pH, Cation exchange capacity, Soil nutrient (potassium, calcium, magnesium, nitrogen, phosphorus), and Heavy metals (lead, copper, zinc, cadmium, mercury, and chromium). Figure 10 illustrates the design of the geodatabase in the Arc-GIS/ArcCatalog software. Attributes of these future classes are further illustrated in Table 8.

Creating the Baseline Socio-Economic Dataset
The socio-economic environment is defined as all activities, and social and economic processes, that could be influenced directly or indirectly by the mining project which includes the size and distance of built environment, built-up, cultural values, historical monuments, the function of the examined area. This dataset contains nine feature class includes, socio-economic quality point, Quality of life, Housing quality and quantity (this is particularly important if people are to be relocated), Public safety (police, fire), Education (average level, access, public and/or private), Health services, Recreation (public, private), public services sanitation, livelihood. In this dataset, the field attributes related to field measurement results are not filled in using specific code but filled with real results of field measurements. Figure 11 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. Attributes of these future classes are further illustrated in Table 9.

Creating the Baseline Population Dataset
The baseline population datasets mainly contain location of the local population about the proposed project area, this dataset contains four feature classes which  Figure 12 illustrates the Composite baseline population dataset; Figure 12 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. Attributes of these future classes are further illustrated in Table 10.

Creating Baseline Waste Management Dataset
The baseline waste management dataset contains six feature classes related to waste generated during the mining operation. This dataset includes waste point, solid waste, chemical waste, waste treatment plant (WTP), tailings impoundment facility, and tailings disposal. Figure 13 illustrates the Composite baseline waste management dataset; Figure 13 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. Attributes of these future classes are further illustrated in Table 11. Each feature class contains information include point name, spatial position, and field check result.

Creating the Baseline Climate Change Dataset
The baseline climate change dataset contains six feature classes related to climate conditions around the surroundings of the mine site operation and concession area. This dataset includes a Concession area, Rainfall, temperature, air, protected, and sensitive areas. Figure 14 illustrates the design of the geodatabase in the ArcGIS/ArcCatalog software. Attributes of these future classes are further illustrated in Table 12. Each feature class contains information include point name, spatial position, and field check result.

Composition of the Baseline GIS Spatial Geodatabase Template
The baseline environmental GIS spatial database template for a proposed mining project contained ten (10) datasets with seventy-one (71) feature classes as shown in Figure 15. Geographic information systems (GIS) are founded upon the capability to organize information into a series of layers that can be integrated using geographic location. As a fundamental level, each GIS dataset is organized as a series of thematic layers to represent and answer questions about a particular problem set such as environmental impact assessment of mining. The basis of this step enables us to arrange the datasets required to support the baseline database of the EIA of mining and organized these data into logical feature sets. As it was discussed these blocks represent data groups or feature datasets.
This provides us with a framework for understanding the design process that was presented throughout the geodatabase design. The geographic representations are organized in a series of thematic layers. A thematic layer is a collection of common geographic elements, such as road network, a collection of parcel These data collections should be organized as feature classes and raster-based data layers. Figure 15 shows the overall view of the structure of the baseline spatial geodatabase datasets of Environmental Impact Assessments of mining.
There are 10 environmental datasets and 71 feature classes. Those featured classes were grouped into feature datasets. Parameters which have the same characteristic and belong to a specific theme were grouped and organized into one  feature dataset. The grouping is not based on feature data type and attributes fields and it combines features that logically belong together. The datasets and data layers are grouped and subcategorized into blocks. As shown in Figure 15.
The above blocks develop the conceptual data model, model features based on the data needed for the environmental impact assessment spatial analysis functions, and determine the spatial representation (i.e. point, polygon, line, image, surface) and non-spatial representation (i.e. attributes) of each feature. These blocks also create the logical data model, which will link the conceptual model with a GIS geodatabase. The list above is sorted by layer category, shows the vector data layers in the geodatabase that model real-world features as points, S. M. Kamara