GIS PORTFOLIO 2023 KEVIN KUAH KAI YING e: kuahkevin@gmail.com m: +65 9366 6539
01 02 03
MAPPING [.gdb]
GEODATABASE DEVELOPMENT AND SPATIAL EDITING: DIGITALISED CAMPUS MAP [BIM TO GIS]
EXPLORING THE INTEGRATION OF BUILDING INFORMATION MODELING AND GEOSPATIAL DATA [CAD TO GIS]
EXPLORING ARCGIS TO AUTOCAD PLUGIN - INTEGRATION OF CAD AND GEOSPATIAL DATA
04 05 06
SPATIAL ANALYSIS [SERVICE AREA + HOTSPOT]
SPATIAL ANALYSIS OF PARKS WITHIN PUBLIC HOUSING ESTATES [IDW INTERPOLATION]
A COMPARATIVE STUDY OF WIND AND SOLAR INTERGRATION FOR SUSTAINABLE POWER GENERATION [RASTER ANALYSIS]
AN EXPLORATION OF DEM AND SLOPE ANALYSIS: LOMBOK ISLAND, INDONESIA
01
[.gdb]
GEODATABASE DEVELOPMENT AND SPATIAL EDITING: DIGITALISED CAMPUS MAP OF NUS FASS The assignment introduces map digitisation of georectified satellite imagery at NUS Faculty of Art and Social Science. The process transforms the rastered base imagery into usable vector data forms. The assignment focuses on developing new geodatabases and creating feature classes of various geometry types: Points (points of interest), Polylines (roads) and Polygons (buildings). Additionally, each vector layer contains supplementary data managed by attribute fields and may be viewed on ArcGIS Pro software.
Software: ArcGIS Pro
PROJECT TITLE: GEODATABASE DEVELOPMENT AND SPATIAL EDITING: DIGITALISED CAMPUS MAP OF NUS FASS
DIGITALISED CAMPUS MAP OF NUS FASS CREATING GIS DATABASE USING GEODATABASE FORMAT
1. Creation of feature classes (i.e. point, line and polygon) 2. Adding fields for data entry 3. Configuration of pop-up data
PROJECT TITLE: GEODATABASE DEVELOPMENT AND SPATIAL EDITING: DIGITALISED CAMPUS MAP OF NUS FASS
Left: Screenshot of pop-up and geodatabases feature classes Above: Building - Attributes table
-
A
B
C
D
E
26.80 6.70
6.70
6.70
6.70
8.90
1
-
-
16.00
-
7.10
2
3
-
02
-
[BIM TO GIS]
EXPLORING THE INTEGRATION OF BUILDING INFORMATION MODELING AND GEOSPATIAL DATA This section explores the workflow and integration of BIM and GIS. The exchange of data between BIM models and geospatial data amplifies the importance of site contextual information, enabling further analysis for better project outcomes. The sample Revit model (Farnsworth House designed by architect, Mies van der Rohe) has its XYZ origin at 0. The model is uploaded on ArcGIS Pro and georeferenced according to the desired coordinate system and exact building location.
Software: Revit, ArcGIS Pro
PROJECT TITLE: EXPLORING THE INTERGRATION OF BUILDING INFORMATION MODELING AND GEOSPATIAL DATA
-
INTEGRATION OF BIM AND GIS DATA FARNSWORTH HOUSE - REVIT MODEL TO ARCGIS PRO
AXONOMETRIC VIEW OF REVIT MODEL FARNSWORTH HOUSE
INTEGRATION OF BIM AND GIS DATA FARNSWORTH HOUSE - REVIT MODEL TO ARCGIS PRO
03
[CAD TO GIS]
EXPLORING ARCGIS TO AUTOCAD PLUGIN - INTEGRATION OF CAD AND GEOSPATIAL DATA This section explores the workflow and integration of CAD and GIS. The workflow requires a free and downloadable plugin - ArcGIS for AutoCAD. The CAD drawing coordinate system is first assigned to SVY21 and georeferenced to SVY21 coordinates (33639.533N and 24334.953E) and heading values (336). The CAD file is groprocessed and converted by CAD to Geodatabase on ArcGIS Pro. The converted feature dataset are then dragged into the map and its symbology and attribute data are managed accordingly.
Software: AutoCAD, ArcGIS Pro
PROJECT TITLE: EXPLORING ARCGIS TO AUTOCAD PLUGIN - INTEGRATION OF CAD AND GEOSPATIAL DATA
INTEGRATION OF CAD AND GEOSPATIAL DATA 36 REBECCA ROAD
PROJECTION: SVY21
PROJECT TITLE: EXPLORING THE WORKFLOW OF CAD DATA AND GEOSPATIAL DATA
Top left: Manual sketch to PDF Top bottom: Digitalised drawing format from PDF Above: Georeference CAD drawings on AutoCAD
Left: Workflow Above: Integration of georeferenced CAD on ArcGIS Pro.
04
[SERVICE AREA + HOTSPOT]
SPATIAL ANALYSIS OF PARKS WITHIN PUBLIC HOUSING ESTATES The goal of this project seeks to investigate the accessibility of parks and their relationship with existing HDB housing. Spatial analysis are conducted by overlaying building footprints and HDB blocks along with the parks managed by Nparks. Three maps were produced; firstly, an overview of park locations across Singapore. Secondly, a hotspot analysis of park density. And lastly, the visualisation of reachable parks using the Service Area tool. The analysis identifies possible areas for future park construction, aiming to provide more green spaces for the residents.
PROJECT TITLE: SPATIAL ANALYSIS OF PARKS WITHIN PARK HOUSING ESTATES
Software: ArcGIS Pro
LOCATIONS OF PARKS AND PUBLIC HOUSING IN SINGAPORE PARKS UNDER THE PURVIEW OF NPARKS MANAGEMENT
Source: data.gov, geofabrik.de
PARK DENSITY MAP IN SINGAPORE UTILISING HOTSPOT ANALYSIS
Source: data.gov, geofabrik.de
DENSITY SCALE SPARSE
DENSE
The hotspot analysis indicates spatial clustering phenomena and varying density across Singapore. According to the results, hotspots are located in the central, southern, and eastern regions, while cold spots are found in the northern and western parts of the island. To further analyse this phenomenon, Woodlands in the north, has been selected. Using the Service Area tool on ArcGIS Pro, it is determined that residents living in the western area can reach the nearest park within 5-15 minutes of walking. Conversely, the eastern area experiences a shortage of parks.
PROJECT TITLE: SPATIAL ANALYSIS OF PARKS WITHIN PARK HOUSING ESTATES
ACCESSIBILITY OF PARKS WITHIN WOODLANDS PLANNING AREA VISUALISING REACHABLE PARKS WITH SERVICE AREA TOOL
Source: data.gov, geofabrik.de
05
[IDW INTERPOLATION]
A COMPARATIVE STUDY OF WIND AND SOLAR INTERGRATION FOR SUSTAINABLE POWER GENERATION] The project aims to adopt an exploratory & investigative approach by conducting studies on sustainable & renewable energies (e.g., solar & wind). It seeks to propose potential wind installation sites based on overlaying & mapping of spatial datasets. This would probe further insights where it derive results on areas where the strongest wind speeds are coupled with the strongest solar irradiance levels based on mean average. Potentially, further recommendations could be made on hybrid designs of Vertical Axis Wind Turbines (VAWT) & solar panels based on site selection and its technical specifications. The project also aim to highlight possible solutions and limitations which could further enhance the research by employing different analytical approaches and techniques, with the constructive use of statistical data.
Software: ArcGIS Pro
PROJECT TITLE: A COMPARATIVE STUDY OF WIND AND SOLAR INTERGRATION FOR SUSTAINABLE POWER GENERATION
OPTIMAL SITE SELECTION FOR ROOFTOP VAWT INSTALLATION SPATIAL OVERLAY OF RASTER-BASED WIND ENERGY POTENTIAL AND VECTOR-BASED BUILDING
EXISTING BUILDINGS WITH ENERGY POTENTIAL: WIND OVER SOLAR (%)
Source: geofabrik.de, data.gov
Vertical Axis Wind Turbine: Model Specs: Aeolos-V 1kW (Aeolos, n.d.)
PROJECT TITLE: A COMPARATIVE STUDY OF WIND AND SOLAR INTERGRATION FOR SUSTAINABLE POWER GENERATION
SOLAR RESOURCE OF SINGAPORE GLOBAL HORIZONTAL SOLAR IRRADIANCES
2019
2020
2022
2023
2021
Source: solcast.com
PROJECT TITLE: A COMPARATIVE STUDY OF WIND AND SOLAR INTERGRATION FOR SUSTAINABLE POWER GENERATION
SOLAR RESOURCE OF SINGAPORE (2019-2023) AVERAGE GLOBAL HORIZONTAL SOLAR IRRADIANCES
Source: solcast.com
PAGE
WIND RESOURCE OF SINGAPORE AVERAGE WIND ENERGY POTENTIAL BASED ON AVERAGE WIND SPEEDS AND SAMPLE VAWT REQUIREMENTS
2019
2020
2022
2023
2021
Source: Meteorological Service Singapore (MSS)
PROJECT TITLE: A COMPARATIVE STUDY OF WIND AND SOLAR INTERGRATION FOR SUSTAINABLE POWER GENERATION
WIND RESOURCE OF SINGAPORE (2019-2023) AVERAGE WIND ENERGY POTENTIAL BASED ON AVERAGE WIND SPEEDS AND SAMPLE VAWT REQUIREMENTS
Source: Meteorological Service Singapore (MSS)
COMPARATIVE MAP OF WIND & SOLAR ENERGY POTENTIAL (2019 - 2023) WIND ENERGY POTENTIAL AS A PERCENTAGE OF SOLAR ENERGY POTENTIAL
OPTIMAL SITE SELECTION FOR ROO
SPATIAL OVERLAY OF RASTER-BASED WIND ENERGY
OFTOP VAWT INSTALLATION
Y POTENTIAL AND VECTOR-BASED BUILDING FOOTPRINT
EXISTING BUILDINGS WITH ENERGY POTENTIAL: WIND OVER SOLAR (%)
Source: geofabrik.de, data.gov
06
[RASTER ANALYSIS]
AN EXPLORATION OF DEM AND SLOPE ANALYSIS: LOMBOK ISLAND, INDONESIA The project examines the capabilities of Digital Elevation Model (DEM) and conducts raster analysis such as the Shaded Relief Map and Slope Direction Map. Sourced from the United States Geological Survey (USGS), the DEM is generated by SRTM 1 Arc-Second Global with a resolution of 30m. The chosen site, Lombok Island is home to an active volcano, Mount Rinjani. The symbology of the Shaded Relief Map is a combination of hillshade, singleband psuedocolour and contour layers, resulting in a 3D representation of the topography. The Slope Direction Map utilises Aspect analysis, generating the slopes into classes according to the cardinal directions.
PROJECT TITLE: AN EXPLORATION OF DEM AND SLOPE ANALYSIS: LOMBOK ISLAND, INDONESIA
Software: QGIS
Top: Digital Elevation Model of Lombok PROJECT TITLE: AN EXPLORATION OF DEM AND SLOPE ANALYSIS: LOMBOK ISLAND, INDONESIA