Middle Tennessee State University Department of Geosciences PGEO6050 - Programming for Geospatial Database Applications Laboratory 07 - Working with Geometry H.G. Momm [Spring 2022] PART 1: (5 points) SCRIPT 1 - Does not need to use CURSORS 1. Generate randomly a set of 1,000 (one thousand) points with X and Y coordinates between 0 and 1,000. 2. Save the file to a CSV ASCII file. PART II: (10 points) SCRIPT 2 - It needs to use CURSORS 3. Read the previously save file into memory and calculate the mean X and the mean Y values. 4. Identifies the points within plus and minus a user-defined delta distance from the means (referred to as "the selecting zone"). You will define the delta value (any number between 0 and 1000). 5 . Generates a point ESRI Feature Class with these points and respective information in the attribute table of whether or not the points are within the selecting zone. You can use a code or simply define YES or NO. PART III: (10 points) SCRIPT 3 - It needs to use CURSORS 6. Generate a polygon ESRI Feature Class with the rectangle of the selecting zone. PART IV: (5 points) SCRIPT 4 - It needs to use CURSORS 7. Generate code to generate 5 ESRI Shapefiles containing 1,000 randomly generated points between 0 and 1000. Notes: Please submit your answers as a PDF to D2L