topic Re: Geocode non addressable Excel Spreadsheet in ArcGIS Pro Questions

Geocode non addressable Excel Spreadsheet

CMcDonald — Wed, 10 Feb 2021 12:12:14 GMT

Hi,

I have had an Excel spreadsheet shared with me that has a list of non addressable assets (trees). Is it possible to do some sort of Reverse Geocode and import them as a Table and add the location manually for each into a single Feature Class/Shapefile.

The 'geocode' options in the ArcGIS Toolbox seem mainly to refer to geocoding addresses.

Thanks

Re: Geocode non addressable Excel Spreadsheet

Robert_LeClair — Wed, 10 Feb 2021 14:54:04 GMT

In ArcGIS Pro, you can zoom to the non-addressable assets (trees) for example and with the World Imagery basemap on, right click on the image. From the Context Menu, select "What's Here?" ArcGIS Pro will provide you an address and a Lat/Lon for that position that you can copy/paste into a table.

Re: Geocode non addressable Excel Spreadsheet

JoeBorgione — Wed, 10 Feb 2021 15:04:37 GMT

Does the spreadsheet have any sort of spatial reference as to where the trees are located like a a lat,long pair?

Re: Geocode non addressable Excel Spreadsheet

CMcDonald — Wed, 10 Feb 2021 15:22:55 GMT

There are no coordinates in the spreadsheet but there is a Postcode (zipcode). Each site surveyed has been put in a separate tab in the spreadsheet so you could match all the trees from each site to a single location I guess and then manually move them.

Re: Geocode non addressable Excel Spreadsheet

JoeBorgione — Wed, 10 Feb 2021 15:28:15 GMT

You could create a locator based on zipcode if you have access to zipcode data. All the trees in a given zipcode will be matched in the same location so you won't get any sort of precision out of it. If your data had some sort of coordinate pairs you could reverse geocode them to a locator.