CSE 6331: Learn to Use a Spatial Database (SDBMS) and GIS Visualization Tools - IT Assignment Help

Assignment Task:

Task:

Introduction:
In this project students will be given a dataset which consist of a road map (Lines), counties map (Polygons), WAZE application events dataset (Points). The WAZE database is a collection of traffic events such as delays, accidents, traffic jams, etc. The datasets are of shapefile (.shp) format and will focus on the Texas counties in the Dallas/Fort Worth/Arlington area. The students can load the data into any spatial database management system (SDBMS) like SpatiaLite, PostGIS, etc.

Once the data has been uploaded to a SDBMS then they can use a GIS software (QGIS, ArcGIS, etc) to visualize the data. They will have to apply graphical interface on this project. Using the graphical interface, the students should be able to display (visualize) the results of various queries such as:
1. Show the different objects or locations,
2. Find region with most traffic jam,
3. Compute the area of an object, etc.

All the computation should be done within the SDBMS. The GIS program should just be used to visualize the output. The purposes of this project would be for the students to:
1. Learn how to load shapefile to SDBMS,
2. Use the spatial functions to answer queries,
3. Use GIS visualization tools to display the result.
 

First milestone:

In the first part, students will load the shapefile to SDBMS tables and create indexes on each table. Then, you should answer the provided queries (page 5). Each set of queries belongs to different categories:

1) non-spatial: can be answered without spatial function.

2) spatial and spatio-temporal queries: must be answered with spatial function.
 

Instruction for this milestone: Write a report that includes:
1- First page includes the students and the course information.
2- Provide proof of loading the data to SDBMS and describe how you loaded the data. Also show screenshot of the tables showing the first 10 rows in each table.

3- Analysis of the given dataset. Provide documentation to show that you studied each table and understand what kind of attributes andinformation exists in each table.
4- Make a list of the spatial functions available in the Spatial DBMS to answer queries in category (2) (Spatial and spatio-temporal queries)
5- Provide the result to each query in the requested format. Also provide the SQL statement for each query.

The due date for milestone 1: Friday April 2,2021 11:59 pm.
The report will be submitted through Canvas.
 

Second milestone:

In the second part, students will use GIS visualization tools (i.e. QGIS) to display the maps of different areas and show the results of the provided queries. You must write the steps to answer each question and display the result as in the following example.

The first due date: April 9, 2021 11:59 pm.

Only need to submit the answer of two queries.
The second due date: Thursday April 23, 2021 11:59 PM Include the answer to all queries in this milestone.
The project will be submitted through Canvas.
 

Example: Display each county in different colors and the name of each county.

Steps:
1- Add County layer as shapefile in QGIS.
2- Write click on the County layer then Properties.
3- Choose Symbologyà CategorizedàValue: CNTY_NM.
4- Click Classify. Then apply to see the result.
5- For adding the county name: Propertiesà Labelsàvalue: CNTY_NM

This CSE 6331:  Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.