Exporting spatial data linkage from two inputs in ArcGIS?

Question 1

I have a csv file containing of points (house locations) and shapefiles consisting of polygons (congressional districts)

How do I export a csv of the points and what district that point falls in?

Because I don't have any objective id for the points so I was unable to use join data feature in Exporting query to identify what polygon certain points fall in using ArcGIS Desktop?.

I am using ArcGIS Desktop 10.3.

Question 2

You need to do the following, assuming the CSV file has X,Y locations

Add the CSV file as point data
Go to File -> Add data -> Add X,Y Data
Save point data as feature class (shapefile) by right-click on the point data -> Data -> Export data
Add the district polygons and the newly created point shapefile (houses), then right-click the point shapefile -> Join and Relate -> Join -> Use "Join data from another layer based on spatial location" -> Use "It falls inside" -> Save the results to a new shapefile
Load the newly created shapefile with the joined information -> open the attribute table -> Go to table option (White sheet icon at the top left corner) -> go to Export -> Choose "Text" under the Save as Type. It will Create a CSV file with point data and the districts information.

If you need more options, then you can use ArcToolbox -> Analysis Tools -> Overlay -> Open Spatial Join

Use point shapefile (houses) for Target Feature
Use district polygons for Join Feature
Join_One_to_One
You can use Field Mapping, if necessary, or keep the default option
Use Intersect as match option, or choose the option that is suitable to your case
Save to a new shapefile
Load the newly created shapefile with the joined information -> open the attribute table -> Go to table option (White sheet icon at the top left corner) -> go to Export -> Choose Text under the Save as Type. It will Create a CSV file with point data and the districts information.

Question 3

Thanks, the first option works. I didn't manage to find export text option so I saved as dbf then changed the extension to csv.

ahmadhanb ahmadhanb 41.8k5 gold badges55 silver badges110 bronze badges · Accepted Answer · 2016-07-26 06:29:18Z

You need to do the following, assuming the CSV file has X,Y locations

Add the CSV file as point data
Go to File -> Add data -> Add X,Y Data
Save point data as feature class (shapefile) by right-click on the point data -> Data -> Export data
Add the district polygons and the newly created point shapefile (houses), then right-click the point shapefile -> Join and Relate -> Join -> Use "Join data from another layer based on spatial location" -> Use "It falls inside" -> Save the results to a new shapefile
Load the newly created shapefile with the joined information -> open the attribute table -> Go to table option (White sheet icon at the top left corner) -> go to Export -> Choose "Text" under the Save as Type. It will Create a CSV file with point data and the districts information.

If you need more options, then you can use ArcToolbox -> Analysis Tools -> Overlay -> Open Spatial Join

Use point shapefile (houses) for Target Feature
Use district polygons for Join Feature
Join_One_to_One
You can use Field Mapping, if necessary, or keep the default option
Use Intersect as match option, or choose the option that is suitable to your case
Save to a new shapefile
Load the newly created shapefile with the joined information -> open the attribute table -> Go to table option (White sheet icon at the top left corner) -> go to Export -> Choose Text under the Save as Type. It will Create a CSV file with point data and the districts information.

Thanks, the first option works. I didn't manage to find export text option so I saved as dbf then changed the extension to csv.

1 Answer 1