Geocode non addressable Excel Spreadsheet

Question

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

JoeBorgione · Answer

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.

CMcDonald · Answer

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.

JoeBorgione · Answer

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