I am a volunteer for a non-profit org that collaborates with local government to support historic preservation in a city. We have eight historic districts, each that I have defined and have available in KML (8 KML files). My need is to get a spreadsheet (csv ... data) with ALL the USPS postal addresses within the boundaries of the polygon. Best case would be a file that contains all the address parts as separate attributes (house number, street name, street suffix, city, state, zip ... but I could likely handle it if one field contained the entire address/city/state/zip. I don't own any product of ESRI, but have used it for years to view historic maps of our city that ESRI ingested.
In any case, I'm NEW to Arcgis and don't even know where to start. I had hoped to prove to the nonprofit management that using gis would be extremely helpful since the boundaries of these districts RARELY change and every year we get a fresh dump (Access DB) of all the property owners for every property in our city, but only some of these properties fall within one of the eight polygons. I am skilled enough that I could join a list of addresses (from esri) with this tax record database so that we could YEARLY satisfy the goal of being able to know the names and addresses of every property owner in our eight historic districts. I'm hopeful that someone might be able to help me understand what products I need (from ESRI or elsewhere) to do this and how to go about accomplishing the stated goal (in bold above). Thank you in advance! Mitch
Solved! Go to Solution.
Hi Mitch,
Well this is a fine kettle of fish you've gotten yourself in.
The easiest way I can think of for you to help your organization is for you to call the city manager or assessors office and ask them for the information you want and why you want it. They may be very helpful to you in this regard, and for a small price even supply you with mailing labels.
They may also have GIS data with street addresses on it. These are necessary for certain kinds of license applications (liquor, marijuana, adult entertainment).
Another way is to call a direct mail marketing company. They have the info you want, too, for a small price.
You may be able to add your kml files directly to your ArcGIS Pro map, or you can use the KML to Feature Class tool to accomplish this. I found a Department of Transportation website which has most of the addresses in the US on it. You can download this file and use the clip tool to get only the addresses inside your polygons. Then use the feature to excel tool to extract the addresses which are inside your polygons and put them on an excel spreadsheet which you can use for mass mailing. Here's what I did in 10 minutes for one of my favorite windsurfing beaches, Nahant Massachusetts.
Since you are the novice you say you are, I would go with solution number one and call the city manager's office first and see what you can get from them.
Hi Mitch,
Well this is a fine kettle of fish you've gotten yourself in.
The easiest way I can think of for you to help your organization is for you to call the city manager or assessors office and ask them for the information you want and why you want it. They may be very helpful to you in this regard, and for a small price even supply you with mailing labels.
They may also have GIS data with street addresses on it. These are necessary for certain kinds of license applications (liquor, marijuana, adult entertainment).
Another way is to call a direct mail marketing company. They have the info you want, too, for a small price.
You may be able to add your kml files directly to your ArcGIS Pro map, or you can use the KML to Feature Class tool to accomplish this. I found a Department of Transportation website which has most of the addresses in the US on it. You can download this file and use the clip tool to get only the addresses inside your polygons. Then use the feature to excel tool to extract the addresses which are inside your polygons and put them on an excel spreadsheet which you can use for mass mailing. Here's what I did in 10 minutes for one of my favorite windsurfing beaches, Nahant Massachusetts.
Since you are the novice you say you are, I would go with solution number one and call the city manager's office first and see what you can get from them.
Thank you for the detailed reply and mostly for providing options/considerations that might help me devise a solution. On my way! Much appreciated!
Hi Mitch,
You're very welcome. Please let us know if one of my options solved your problem.
We are keeping score, and this is a little game we play.