"Find Existing Locations" results to include SITE & DISTANCE to site

883
6
12-19-2018 06:32 AM
Status: Already Offered
Labels (1)
JoLoCicero
New Contributor III

Scenario:  10 sites with a buffer of 3 rings each = 30 sets of data. 

100's of uploaded addresses. 

The exported results to Excel should identify the "site" and the "distance" from each address.  The site is necessary since there will be overlap.

Currently, I have to perform 30 processes using the "Find Existing Locations" to identify the proximity to the site.

Is there currently a better way to perform this task?  If not, please consider automating.

 

The attached map shows total data points in each radius pulled as a group with "Find Existing Locations", but the data exported does not clarify the site or the distance to the site.

6 Comments
RobertBorchert

Have you tried using the Near (Analysis Tool)?

It will give you In FID, Out FID, Distance, XY and even angle to the near item. 

JoLoCicero

Robert, I played around with this and it is fabulous. Exactly what I need. Except it is not connecting to all of my data points. I have deselected all of the limitations. Do you know why this is happening? I tried it twice and got the same thing.

Thanks so much!

Jo

<http://www.hhhunt.com/>

C. Jo LoCicero

Market Analyst . Properties Division

1401 Sunday Drive, Suite 109

Raleigh, NC 27606

Office – 919.461.0587 Ext. 119

HHHunt.com<http://www.hhhunt.com/>

<http://www.facebook.com/> <http://www.twitter.com/> <http://www.linkedin.com/>

JoLoCicero

This is what I am talking about.

Robert, I played around with this and it is fabulous. Exactly what I need. Except it is not connecting to all of my data points. I have deselected all of the limitations. Do you know why this is happening? I tried it twice and got the same thing.

Thanks so much!

Jo

<http://www.hhhunt.com/>

C. Jo LoCicero

Market Analyst . Properties Division

1401 Sunday Drive, Suite 109

Raleigh, NC 27606

Office – 919.461.0587 Ext. 119

HHHunt.com<http://www.hhhunt.com/>

<http://www.facebook.com/> <http://www.twitter.com/> <http://www.linkedin.com/>

PraveenSrivastava

Hi Jo,

Are you using the Nearby summaries in BA Web App? If so, here are some resources on this topic.

Thanks,

Praveen

JoLoCicero

Good morning, Praveen.

I ultimately got this worked out. Thanks for taking the time to check with me.

Have a great day!

Jo

<http://www.hhhunt.com/>

C. Jo LoCicero

Market Analyst . Properties Division

1401 Sunday Drive, Suite 109

Raleigh, NC 27606

Office – 919.461.0587 Ext. 119

HHHunt.com<http://www.hhhunt.com/>

<http://www.facebook.com/> <http://www.twitter.com/> <http://www.linkedin.com/>

HelenBrown
Status changed to: Already Offered