# Help! i need to create spreadsheet of points...

939
2
02-10-2021 12:35 PM
New Contributor II

So i am new to Arcmap.
I am trying to generate a spreadsheet with coordinates and id of points within a certain radius of other points, but i can’t find how to do this anywhere. I’ve tried spatial join, i’ve tried select by location. It only gives me the number of points or the sum of all point inside all areas, which is not what i want.

plz help me

1 Solution

Accepted Solutions
MVP Frequent Contributor

You'll first need to ensure that the points you want to join to have x,y fields which are populated.  I'm guessing you already do, but Calculate Geometry Attributes—Help | ArcGIS Desktop will do this if not (POINT_X, POINT_Y).

Also ensure you have everything in the correct projection/coordinate system.

Spatial join normally only returns the count of matching features, and the attributes of the first feature it encounters.

However, the Field Mapping allows you to specify some very handy rules on how you handle multiple coincident/within a distance features.

In this case, you would probably want a field containing a delimited (comma separated for example) list of all the IDs of points within a distance from your other input features, and another field containing the XYs of those points.

A helpful blog (helped me several years ago) here Spatial Join’s hidden trick or how to transfer attribute values in a One to Many relationship | Esri... should give you an idea of the process (beware of max field length in your new fields!).

2 Replies
MVP Frequent Contributor

You'll first need to ensure that the points you want to join to have x,y fields which are populated.  I'm guessing you already do, but Calculate Geometry Attributes—Help | ArcGIS Desktop will do this if not (POINT_X, POINT_Y).

Also ensure you have everything in the correct projection/coordinate system.

Spatial join normally only returns the count of matching features, and the attributes of the first feature it encounters.

However, the Field Mapping allows you to specify some very handy rules on how you handle multiple coincident/within a distance features.

In this case, you would probably want a field containing a delimited (comma separated for example) list of all the IDs of points within a distance from your other input features, and another field containing the XYs of those points.

A helpful blog (helped me several years ago) here Spatial Join’s hidden trick or how to transfer attribute values in a One to Many relationship | Esri... should give you an idea of the process (beware of max field length in your new fields!).

New Contributor II

THANK YOU SO MUCH!!
u saved my work, for real
(sorry for the late response)