Page History

...

1. In the Geoprocessing pane, if necessary, hit the Back arrow to return to the tool search interface.
2. Search "split" and click the Split By Attributes tool.
3. For 'Input Table', use the drop-down menu to select the converted CAD layer you wish to split.
4. For 'Target Workspace', click the Browse... button and navigate to and single click your project geodatabase with your site name and click OK.
5. For 'Split Fields', select the Layer field.
6. Click Run.

Assigning lot IDs to lot polygons

1. Return to the Catalog pane and add the lot polygon layer, as indicated in the Google sheet to your map. Your annotation point layer should already have been added to your map.
2. Return to In the Geoprocessing pane, search "join" and click the Spatial Join tool.
3. For 'Target Features', use the drop-down menu to select your lots polygon layer.
4. For 'Join Features', use the drop-down menu to select your Annotation (containing the lot IDs) point layer.
5. For 'Output Feature Class', rename the feature class something like "LotsWithIDs".
6. Leave the rest of the defaults and click Run.

Add new field

1. remove original lots, polygon, annotation

2. Figure out whether to do this in class or outside meetings or follow written instructions

3. TxtMemoClean

   TxtMemo.strip()

    

4. After join, show sort missing and reverse join to see which don't have it, or symbolize by join count (we don't have time for data cleaning)

5. Export with join

Joining

...

1. Add formatted Excel spreadsheet
2. Right-click Lots_withID > Joins and Relates > Add Join.
3. For Layer Name or Table View keep Lots with id
4. For Input Join Field, select TxtMemo
5. For Join Table, selcet outside Excel table
6. For Output Join Field, Select Lot, exact name is in Google spreadsheet.

Notes

1. What are they handing in?
   1. Appendix, inset, side x side frames
   2. directional dist, opt hot spot, cluster outlier, kernal density