+ Reply to Thread
Results 1 to 4 of 4

Thread: ArcGIS10: Use xlsx file as Reference Data to create Address Locator. Errors!!??

  1. #1
    Scott Chang
    Join Date
    May 2010
    Posts
    191
    Points
    2
    Answers Provided
    0


    0

    Default ArcGIS10: Use xlsx file as Reference Data to create Address Locator. Errors!!??

    Hi all,
    I used an Excel 2007 worksheet to make an xlsx file:
    OID Org_Name Address City State ZIP_Code
    0 Kentucky Theatre 214 East Main Street Lexington KY 40507
    1 Repulic Bank & Trust Company 2401 Harrodsburg Road Lexington KY 40504
    2 Square D 1601 Mercer Road Lexington KY 40501
    3 Community Trust Bank 901 Beaumont Centre Parkway Lexington KY 40513
    4 Link-Belt Cranes 2651 Palumbo Drive Lexington KY 40909
    5 Central Bank & Trust Company 3270 Tates Creek Road Lexington KY 40509
    6 Glass America 3801 Nicholasville Centre Drive Lexington KY 40503
    7 Odessa Roofing Inc & Repair 232 Gold Rush Road Lexington KY 40503
    8 Blue Grass Plating Co. 451 North Estill Avenue Richmond KY 40475
    9 Farmers Bank 213 East Main Street Wilmore KY 40390
    10 Central Bank & Trust Co. 301 North Main Street Nicholasville KY 40356
    Then I used it as Reference Data to create an Address Locator and I got errors - see the attached files.
    Please kindly help and advise me what is wrong in my xlsx file, what format I should use to create the table for Reference Data, and how to solve the errors.

    Thanks,
    Scott Chang
    Attached Thumbnails Attached Thumbnails Click image for larger version

Name:	scLexingtonKyAddressGeocoding--2.JPG‎
Views:	49
Size:	153.6 KB
ID:	13645   Click image for larger version

Name:	scLexingtonKyAddressLocator-3.JPG‎
Views:	45
Size:	164.8 KB
ID:	13646  
    Last edited by ScottChang25; 04-18-2012 at 12:14 PM.

  2. #2
    Scott Chang
    Join Date
    May 2010
    Posts
    191
    Points
    2
    Answers Provided
    0


    0

    Default Re: ArcGIS10: Use xlsx file as Reference Data to create Address Locator. Errors!!??

    Add one more jpg file to show the "$" is in the end of the xlsx name. Can the "$" cause the errors? When I try to create the Address Locator, how can I avoid using the "$" that came with the .xlsx file?
    Attached Thumbnails Attached Thumbnails Click image for larger version

Name:	scLexingtonKyAddressLocator-4.JPG‎
Views:	24
Size:	165.1 KB
ID:	13649  
    Last edited by ScottChang25; 04-18-2012 at 12:19 PM.

  3. #3
    Matthew Oelschlegal
    Join Date
    Jun 2011
    Posts
    22
    Points
    4
    Answers Provided
    1


    0

    Default Re: ArcGIS10: Use xlsx file as Reference Data to create Address Locator. Errors!!??

    Quote Originally Posted by ScottChang25 View Post
    Add one more jpg file to show the "$" is in the end of the xlsx name. Can the "$" cause the errors? When I try to create the Address Locator, how can I avoid using the "$" that came with the .xlsx file?
    Scott,

    Your reference data should be street centerlines, parcels, or some other type of data that has geometry and can be displayed on the map. Check the page below for some assistance in getting started. Also if you are only using one file as reference data it should be the primary table rather than alias table.

    http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002500000013000000.htm


    M.O.

  4. #4
    Joe Borgione

    Join Date
    Apr 2010
    Posts
    1,140
    Points
    308
    Answers Provided
    31


    0

    Default Re: ArcGIS10: Use xlsx file as Reference Data to create Address Locator. Errors!!??

    +1 to what Matt says.

    The very basic concept of geocoding is you are matching a name or an address to a geographic location. For example: If I have a POINT feature class and three of the points are named Matts House, Joes House and Scotts House respectively, and I have a TABLE of events (like Loud Party Complaints) and those records contain various location references and a few show Joes House and a few more Show Matts house, I can then match those complaints to a geographic location, and display them in the form of a map.

    Addtionally, if I have a LINE feature class of streets that have address ranges on them, I can use them as the basis to geo-locate my table of events. Lets say that Loud Party Compliant table has as locations not only references to Joes House and Matts House, but actual addresses as well; for example 1234 Main St.

    I can create one locator based on points and one locator based on streets and composite them together. That way, regardless of how the location field in the complaints table is populated, 1234 Main St or Joes House, I will be able to get a match.

    Bottom line: The G of GIS stands for Geography. You need to have a GIS feature class to match against. Your list of addresses you wish to map can be in just about any format you want. Spreadsheets included.

    Hope this helps-
    Joe Borgione
    AlpineGeographic

    If the suggestion I provide helps solve your problem, please feel free to give it a favorable review by clicking the up arrow. That's only only reward I get for sharing 20 + years of professional GIS experience.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts