Data Preparation

Data Preparation

Data Prepartaion

1.0 Extracting and preparing layer

1.1 Study Area

Bring in BATAS_DESA_DESEMBER_2019_DUKCAPIL_KALIMANTAN_TIMUR.shp into QGIS.

“KAB_KOTA” in ( ‘KOTA BALIKPAPAN’ , ‘KOTA SAMARINDA’ ) or “KECAMATAN” in ( ‘ANGGANA’ , ‘BABULU’ , ‘LOA JANAN’ , ‘LOA KULU’ , ‘MARANG KAYU’ , ‘MUARA JAWA’ , ‘PENAJAM’ , ‘SAMBOJA’ , ‘SANGA SANGA’ , ‘SEBULU’ , ‘SEPAKU’ , ‘TENGGARONG’ , ‘TENGGARONG SEBERANG’ , ‘WARU’ , ‘MUARA BADAK’ )

1.2 Road layer

Bring in gis_osm_roads_free_1.shp into QGIS

Save the selected features into a geopackage and name it roads.

1.3 Building layer

Using the steps in 1.1.1, select gis_osm_buildings_a_free_1.shp to study_area and save it into a geopackage as building

1.4 Transport layer

Bring gis_osm_traffic_a_free_1.shp and gis_osm_transport_a_free_1.shp into QGIS

Using the steps in 1.1.1, select transport layer into study_area layer and save it into a geopackage as transport, overwriting the transport layer

From the menu bar, select Select features by freehand and manually select transport_centroid features that are within the study area.

1.5 Hotspot layer

Open Titik Api Hotspot se-Indonesia Tahun [Year] into QGIS, where [Year] is 2014 - 2020.

Select the hospots that fall within the study area. - From the plugins toolbar, click Select by location - For Input, select Titik Api Hotspot se-indonesia Tahun [Year] - Intersect should be selected - For By comparing to the features from, select study_area. Under advanced options , select Do not Filter (Better Performance) - Click Run

Relevant hotspots will be selected. - Select Export -> Save selected features as - Set the Format to GeoPackage from the drop down - Set the layer name to kalimantan - Set the CRS to EPSG:23845 - For 2014, 2015 & 2017, select Points for Geometry type and untick Include z-dimension - Click Ok - Save the selected points into a geopackage and name it kalimantan_[Year]

Repeat this process for all the year.

A temporary Merged layer should be added to your map. - Select Export -> Save features as - Set the Format to GeoPackage from the drop down - Set the layer name to kalimantan - Set the CRS to EPSG:23845 - Under Select fields, deselect fid - Click Run

1.6 Healthcare layer

1.7 Forest layer

Select the area that falls within the study area. - From the plugins toolbar, click Select by location - For Input, select Tuplah_Kalimantan_Timur_2019 - Intersect should be selected - For By comparing to the features from, select study_area. Under advanced options , select Do not Filter (Better Performance) - Click Run

Select the relevant polygons that are related to forest. - From the plugins toolbar, click Select by expression - Type the following expression in the expression box: - “Legenda” in ( ‘Hutan Lahan Kering Primer’ , ‘Hutan Lahan Kering Sekunder’ , ‘Hutan Mangrove Primer’ , ‘Hutan Mangrove Sekunder’ , ‘Hutan Rawa Primer’ , ‘Hutan Rawa Sekunder’ , ‘Hutan Tanaman’) - Click Run - Select Export -> Save selected features as Save the layer in the geopackage as forest

1.8 Agriculture layer

Select the area that falls within the study area. - From the plugins toolbar, click Select by location - For Input, select Tuplah_Kalimantan_Timur_2019 - Intersect should be selected - For By comparing to the features from, select study_area. Under advanced options , select Do not Filter (Better Performance) - Click Run

Select the relevant polygons that are related to agriculture. - From the plugins toolbar, click Select by expression - Type the following expression in the expression box: - “Legenda” in ( ‘Pertanian Lahan Kering’ , ‘Pertanian Lahan Kering Campur’ , ‘Sawah’ , ‘Perkebunan’ ) - Click Run - Select Export -> Save selected features as - Save the layer in the geopackage as agriculture

1.9 Waterway and Water Body layers

Select the area that falls within the study area. - From the plugins toolbar, click Select by location - For Input, select gis_osm_water_a_free_1.shp - Intersect should be selected - For By comparing to the features from, select study_area. Under advanced options , select Do not Filter (Better Performance) - Click Run - Select Export -> Save selected features as - Save the layer in the geopackage as waterway

Select the area that falls within the study area. - From the plugins toolbar, click Select by location - For Input, select gis_osm_waterways_free_1.shp - Intersect should be selected - For By comparing to the features from, select study_area. Under advanced options , select Do not Filter (Better Performance) - Click Run - Select Export -> Save selected features as - Save the layer in the geopackage as waterbody

2.0 Accessibility

2.1 Accessibility to Roads

Accessibility factor: <=100m = 5, 100-200m = 4, 200-300m = 3, 300-500m = 2, >500m = 1 from roads.

2.1.1 Creating attribute field for rasterizing

Before we can rasterize the roads layer, we need to add a control attribute field in the roads layer. - At the Layers panel, click on the Roads layer to make it active. - From the icon bar, click on the Open Attribute Table icon .

The attribute table of the roads layer appears.

The Field Calculator dialog window appears.

Your screen should look similar to the figure below.

Notice that a new field called POI_CODE has been added into the attribute table of roads GIS layer. Also note that all the records are indicated with POI_CODE values equals to 1.

You are now ready to rasterize the roads layer. Save the editing before moving on.

2.1.2 Rasterizing roads layer

The Raster (Vector to Raster) dialog window appears.

When you are ready, - Click on the Run button.

When the operation ends, the dialog window will display the operation log. - Read the output display to ensure that the process has completed without any error.

After confirming that there is no error. You can close the dialog window. - Click on the Close button.

Notice that a temporary layer called Rasterized has been added in the QGIS project.

Save the temporary layer into GeoPackage format. Call the newly exported layer raster_roads. Next, remove the temporary layer from QGIS.

2.1.3 Working with Proximity function of QGIS

Now, the Proximity operation of QGIS will be used to compute the proximity to roads layer.

The Proximity (Raster Distance) dialog window appears.

A temporary layer called Proximity map is created and added in the QGIS project. The legend of Proximity map layer indicates that the furthest distance from the roads is 86038 metres.

save the newly computed proximity map into GeoPackage format with a resolution of 5m x 5m. Call the layer prox_roads. Next, remove the Proximity map layer from QGIS.

2.1.4 Deriving road accessibility factor preference layer

The dialog window of Reclassify by Table appears. - For Raster Layer, select slope from the drop-down list. - For the Reclassification table, click on the icon.

The dialog window of the Fixed table appears. - Enter the value similar to the screenshot below.

Reminder: Click on Add Row button when you want to add a new row. - Click on the OK button when you have completed the entry.

You will go back to the dialog window of Reclassify by Table. - For Range boundaries, select the option similar to the screenshot below.

Note: Pay attention to the Using classes section of the report log. This is the actual reclassification scheme defined using Fixed table and Range boundaries functions of Reclassify by Table of QGIS.

When you are done with reviewing the report log, click on the Close button to close the dialog window of Reclassify by Table.

Notice that a new temporary raster layer will be added on the view window of QGIS as shown in the screenshot below.

Using the steps you had learned in the earlier section, save the temporary raster layer into Geopackage format. Name the data layer as rank_roads. Then, remove the temporary raster layer from QGIS.

2.2 Health

2.2.1 Deriving health risk factor preference layer

Using the steps in 2.1, Create a layer for health risk factor. - Health risk factor: - <=100m = 1, - 100-200m = 2, - 200-300m = 3, - 300-500m = 4, - >500m = 5 away from population i.e. housing areas and offices.

2.3 Hotspot

The heat map should look like this

2.4 Education

The choropleth map should look like this:

2.5 Slope

2.5.1 Deriving slope layer

We will compute a slope layer from the DEM layer by using the Slope operation of QGIS.

Bring in DEM SRTM 30M KALIMANTAN TIMUR layer into qgis.

Save the temporary Clipped (extent) into geopackage as elevation_30m - From the menu bar, select Raster -> Analysis -> Slope.

Slope dialog window appears. - For Input layer, select elevation_30m from the drop-down list.

Keep the rest of the setting as default. - Click on the Run button.

When the computation is completed, a temporary layer called Slope will be added in the QGIS project.

The legend of the Slope layer shows that the minimum and maximum values of the slope values are 0 and 70.3093 degrees respectively. The grids with darker grey indicate locations with relatively gentle slopes. On the other hand, the light grey grids indicate locations with steeper slope.

2.5.2 Slope ranking

2.5.3 Hillshade

Save the temporary Hillshade layer into geopackage as Hillshade.

2.5.4 qgis2threejs

Ensure that Slope layer is above hillshade in the layers window

From the menu bar, select plugins -> manage and install plugins. Search for Qgis2threejs and double click the Install Plugin. Select Qgis2threejs Exporter from the menu bar.

2.6 Healthcare

It should look similar to this:

2.7 Forest Fire Hotspots

It should look similar to this:

2.8 Forest

It should look similar to this:

2.8 Water Body

3.0 Choropleth Maps

3.1 Working Population

Before drawing the map, we have to create a new column for the working population.

A new column, working age, is added to the attribute table. Now that we have the necessary columns, we can draw the choropleth map.

3.2 Religion

3.2.1 Muslim

Using the steps from 3.1, draw a choropleth map. There is no need to open the field calculator as the necessary columns are already present. - For Value, select the expression buttopm, , next to the drop down box - Type “SILAM”/“JUMLAH_PEN” into the expression panel - Click Ok

3.2.2 Christian

Using the steps from 3.2.1, draw a choropleth map using “KRISTEN” /“JUMLAH_PEN” as the Value

3.3 Gender

Using the steps from 3.2.1, draw a choropleth map using “PRIA” /“JUMLAH_PEN” as the Value

3.4 Settlements Heatmap

Save the temporary Heatmap layer into geopackage as settlements_heatmap.

3.5 Forest Fire Hotspot Heatmap

3.6 Education Choropleth Map

4.0 Site Suitability

Download the AHP Template. Open the Excel template and perform AHP analysis. This is our AHP score that we come up with.

This is our AHP score.

From the above results, health risk factor poses the most critical factor and economic factor being the least weighted factor in determining the suitable site. The consistency check of 4% is below 10% and the inconsistency is acceptable.

4. 1 Prepare a composite accessibility layer

(1-(“Slope@1”/70.30928))*0.033+(1-(“prox_transport@1”-562.249939)/(100132.03125-562.249939))*0.053+(“prox_hotspot@1”/88631.007812)*0.166+(“forest_prox@1”/86003.609375)*0.23+(1-(“raster_road_prox@1”/86038.75))*0.086+(“waterbody_prox@1”/87802.921875)*0.432

Noticed that we used 1 - z-score of slope, transport and road as we want higher z-score to represent better site suitability.

4.2 Identify suitable sites

We now need to identify a suitable area based on the composite accessibility layer that we have obtained. The scale of the composite accessibility layer ranges from 0.155585 to 0.690181. After investigating the various values to determine the best value to identify the composite factor score, we have decided on 0.3 to better pinpoint the ideal location.

In order to derive the site suitability layer, the reclassifying operation of raster GIS will be used. In QGIS, raster reclassifying can be performed by using the Reclassify by Table function.

The dialog window of Reclassify by Table appears. - For Raster Layer, select composite_layer from the drop-down list. - For the Reclassification table, click on the icon.

The dialog window of the Fixed table appears. - Enter the value similar to the screenshot below.

The temporary layer should look like this.

Clip the temporary layer into the study area. - The study area should be a dissolved polygon. Open the Dissolve window by clicking Vector -> Geoprocessing -> Dissolve. - In the Dissolve window, select study_area.

The temporary layer should look like the following

Save the temporary layer into geopackage as suitability

4.3 Vectorise suitable sites

Next, we will convert the suitable site identified above from raster into vector through vectorisation. - From the menu bar, select Raster -> Conversion -> Polygonize(Raster to Vector)

The Polygonize (Raster to Vector) dialog window appears. - For Input Layer, select suitability from the drop-down list. - For Name of the field to create, type Sites. - Keep the checkbox in front of Use 8-connectedness uncheck.

We would only like to save the areas which are suitable (which we previously labelled as ‘1’). - Use the Select by expression tool - Enter the following expression in the expression box - “Sites” = 1 - Save the selected area into geopackage as suitability_vector. Your screen should look similar to the screenshot below.