MBER1264 - Geospatial Modeling and Visualization Assignment

Assignment Task

Task

1. Please use the provided GPS sekolah Selangor.xls and selangor.shp files.

2. Write a detailed report on how to:

(a) Import the Shapefile data (selangor.shp) into the PostgreSQL database.

(b) Connect to and view the populated database using QGIS.

(c) Perform a spatial query (select by location) using SQL, and then compare the results with a similar function within QGIS.

(d) Explore other PostGIS functions similar to the “select by location” spatial query, such as STWITHIN, STINTERSECTS and STCONTAINS.

(e) Identify schools that are not mapped correctly (i.e., outside the state boundary) from the database.

(f) Output the results for item 2(e) to a new spatial table and GeoJSON file. Verify these outputs using QGIS software.

This MBER1264 – IT and Computer Science has been solved by our PhD Experts at My Uni Paper.