HW Traverse Closure Balancing Area Computations and Mapping

Make an Excel spreadsheet to perform "Traverse Computations" similar to the lecture example.

1. We've already checked the interior angles, balanced them, and computed the azimuths of our parcel sides in our angle HW.

2. Construct an Excel spreadsheet to do the closure computation similar to the layout in lecture and the text. Compute the closure errors in latitudes and departures, the linear error of closure, the ratio of closure. Make a decision whether you have any blunders of measurement. Try to identify any blunder, remeasure them, and re-compute the traverse closure till you achieve at least a 1/2000 closure.

3. Now expand your spreadsheet to balance the traverse by the Bowditch "compass" rule. Compute corrections to the preliminary latitudes and departures. Apply the corrections, making certain that your sum of balanced latitudes and departures are both zero.

4. Use the balanced latitudes and departures to compute the geodetic coordinates of all your parcel corners. First, you must compute the reference corner's coordinates by applying the tie azimuth and distance from the "tie" geodetic station. Then apply the balanced latitudes and departures to the reference corner's STATE PLANE COORDINATES to get the State Plane Coordinates of the other corners.

5. Compute the area of your parcel in square feet by the coordinate cross-multiplication method.

6. Map the Parcel: Update your AutoCAD sketch with the measured location of the parcel

1. Enter your lot corner points. In AutoCAD, open the previous sketch you made of your project site and create a new point layer for the Lot Corner points "p-lot" (or similar) with a chosen color other than black. Make the layer current. Enter each Lot Corner point: Command: PO, "enter x, y" (your computed state plane coordinate E,N).

2. Also create a new point layer for your Control Points "p-cont" or similar. Move your control points from the basic layer to this new one.

3. Make the lot lines and hatch. Make a new layer for Lot Lines named "l-lot" or similar with the same color as the lot corner points. Make it current. Draw lot lines: Command: L, pick first point (with o-snap on), second point, and continue for all four lines. Hatch the lot. Command: HATCH, Choose the hatch style (default OK), set spacing to about 30-50. Choose internal point inside lot, OK.

4. Also create a new layer for sketched objects "l-sketch" or similar. Move all your sketched surrounding features to this new layer. Update the locations of your sketched surrounding features to more correct locations to make the drawing as realistic as possible.

5. Dimension your lot with distances, azimuths, and angles. Make a NEW dimension style: Command: DIMSTYLE. Make the same settings as in the video, make the NEW style current. Add length and angle dimensions using the ACAD "aligned" or "angular" dimensioning. Beside these dimensions, enter your final azimuths as Mtext or Dtext aligning your azimuths on the other side of the line from the dimensioned lengths.

6. Add the results of your leveling lab: Add a point for the BM location (approx. location if necessary) to the "p-cont" layer, labels for the BM name and elevation, labels for each lot corner elevation.

7. Clean up your drawing deleting your sketched lot corners and other features not needed.

8. Save your drawing. When doing the "save as", in the save as dialog box, pull down the list of "file types". Select ACAD 2007.

Submit:

1. Your expanded Excel spreadsheet showing all the new traverse calculations – closure, balancing, area. In your Excel spreadsheet insert a text box or text discussion of your process, observations, and results.

2. Attach your ACAD 2007 *.dwg file to your WebCT upload.

.