Select to view content in your preferred language

How to Geocode Postal Codes,retrieve corresponding Street Names, and merge in a table

1091
2
09-12-2011 11:46 AM
MaximSilin
Regular Contributor
Hi,

Have a list of Canadian postal codes (i.e. A1B2C3) in Excel. Also, have a road network layer, that has no postal code information in it. The postal codes are located on both sides of each road. Need to merge the postal codes and the streets data together to see which postal code corresponds to which road. This sounds like a fairly simple task, but I can't seem to figure out how to accomplish it...

Any ideas are welcome.
Max
Tags (2)
0 Kudos
2 Replies
MaximSilin
Regular Contributor
Well, upon thinking further on this matter, the question goes done to getting an Address Locator for Canada (or at least an Address Locator style for Canadian addresses that could be downloaded and stored locally on the drive to be used for custom Address locator creation). I think having such would allow me to do a Reverse Geocoding on the postal code locations, and retrieve the Street Names associated with them, stored in an attribut table. Any ideas on where to download Address Locator/Locator Style for Canada from?
0 Kudos
MaximSilin
Regular Contributor
The workaround that I had come up with is described in the following technical article (also see the link in the "Related Information" section):

"How To: Geocode a list of postal codes and extract additional information (e.g. Street Name) corresponding to the geocoded postal code locations"
http://www.esri.ca/en_support/1462_5151.asp?QCount=2
0 Kudos