I'm using ArcGIS Desktop 10.

I have shapefiles consisting of points (street addresses).

I also have shapefiles consisting of polygons (ie, congressional districts, city council districts, etc... a separate shapefile for each kind of district)

How do I run a query that exports a csv of the address and what district that address falls in?

  • 3
    You can use the Spatial Join tool within arctoolbox. Then export out the resulting shapefile .dbf file to a seperate database (xls, csv...etc). – artwork21 Dec 21 '11 at 21:12

artwork21 is absolutely right. Another way to do that is to:

  1. Right click on the point feature class (your street addresses) and go to Join and Relates > Join.
  2. In the prompt box, at the top, select the drop down and choose "Join data from another layer based on spatial location".
  3. Select your polygon feature class (districts) and choose "it falls inside". This will export a shapefile that contain every point and the district it falls in and then, as artwork21 mentioned,
  4. export the resulting table as a .dbf,
  5. open it with Excel and save it as a .csv.

You can also reverse this for further analysis:

  1. Right click the polygon shapefile > Joins and Relates > Join.
  2. Select "Join data from another layer based on spatial location"
  3. Choose the point feature class as the joining layer.

    This gives you a few more options. For example, you can give each polygon attributes of Average, Minimum, Standard Deviation, Sum, Maximum, or Variance (or all of them) from the point feature class.

    So, if you were wondering how many addresses are assigned to the "xyz" district, this would be an ideal solution.

You can also do point to point. For example, if you have a point feature class with distribution centers, and another point feature class with store location and you want to see which which distribution center every store is closest to, you can:

  1. Use the Store Location feature class and join the distribution center feature class
  2. Choose "each point will be given attribute of joining layer closest to it.."

    The output will show every store and the attributes of the distribution center to which it is closest to.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.