Refining Geocodes

Step 1

In the process of refining the unknown addresses of the LASD_2010_2015 csv file, I encountered an Arcmap issue where acrmap couldn't fully load the table. I chose to create a new address locator by using California streets from the T_drive>Projects>Mapshare>Claifornia>Streets. The address locator was set to US dual ranges and it matched 11 unknown points out of 72612 and the table was now fully loaded and ready to be modified. I imported the shape file to a geodatabase and applied python coding to remove the NUll and HOME_ADDRESS values in the table.

The scripts are as follows:

arcpy.MakeFeatureLayer_management("LASD_Unknown_Geocode","UKGC")

arcpy.SelectLayerByAttribute_management("UKGC","NEW_SELECTION", '"ARC_Street" = \'HOME_ADDRESS\'')

arcpy.DeleteRows_management("UKGC")

This removed 60 values. Next I selected by attribute the null values and used the python code

arcpy.DeleteRows_management("UKGC")

This removed 12 values.