Additional Notes (02/07)

Geocoding!

Using Free TIGER street files and then TAD parcel data

• Geocode using the TIGER 2000 streetline dataset
• Create an Address Locator
  
• Add streetlayer to ArcMap
• ArcToolbox/Geocoding Tools/Create Address Locator
• Address Locator Style: 'US Streets with Zone'
• Reference Data: 'streetsTIGER' // Role: 'Primary Table'
  
• TIGER data is standard so all relevant fields will be auto-detected
• Specify a location and name for the lcoator
• OK
• Geocode using this Address Locator
• Right-click table in ArcMap and select 'Geocode Addresses'
• Select the appropriate Address Locator and select OK
• Street or Intersection: 'Address'
• Zone: 'Zipcode'
• Specify location and name for output shapefile
• OK
• Ouch! Results are lousy, eh?
• Click 'Geocoding Options' to edit parameters
• If you clicked OK past this dialog box already, right-click on the geocoded result and select Data/'Review-Rematch Addresses'. Then click 'Geocoding Options'
  
• We can adjust (lower) the 'Spelling Sensitivity' and/or 'Minimum Match Score'
• Not much better??
• Yep, TIGER data (free) is the pits for geocoding! This is why I love the freely available Yahoo! geocoding services.
• Geocode using the Tarrant Appraisal District's (TAD) parcel boundary file.
• What has been prepared for you (download here):
• The TAD parcel shapefile has been downloaded from the TAD Download page and joined (merged) to:
• AAAA primary real estate account dataset
• This gives us the property info that we need (such as square foot)
  
• LOCA property address location info
• This provides address info in a structured way for geocoding
  
• City boundaries
• This is what we will use for our geocoding zone. Seems silly, but neither AAAA or LOCA provide the city name of the property. They provide the city code, which is what I used to join to the city boundary shapefile.
• Create an Address Locator
  
• Add parcel shapefile to ArcMap
• ArcToolbox/Geocoding Tools/Create Address Locator
• Address Locator Style: 'US One Address with Zone'
• Reference Data: 'tadParcelsCity' // Role: 'Primary Table'
  
• Field Mapping:
• House Number: 'Street_No'
• Prefix Direction: 'PREDIR'
• Prefix Type: NONE
• Street Name: 'STREET_NAM'
• Street Type: STREET_TYP'
• Suffix Direction: 'PostDir'
• Zone: 'CITY_NAME'
  
• Specify a location and name for the lcoator
• OK
• Geocode using this Address Locator
• Right-click table in ArcMap and select 'Geocode Addresses'
• Select the appropriate Address Locator and select OK
• Street: 'Address'
• Zone: 'City'
• Specify location and name for output shapefile
• OK
• Woot! Beauty in - Beauty out!
• Geocoding Complete!