AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Contributor
COLINBIBLE4464
Posts: 16
Registered: ‎04-15-2010
Message 1 of 5 (269 Views)

using expression builder to list the distance between points

269 Views, 4 Replies
05-03-2012 04:57 PM

Hello. I have a data table showing points surrounding a central source.

I would like to create a calculation that adds a column in my data table of the points; that shows the distance between each respective point, and the central point.

My knowledge in expression building is limited, and Im hoping someone here could help me.

I assume I would be using some form of calculation using the geom, and the X and Y locations, however Im coming up with nada.

Can anyone help?

 

Thanking you in advance

 

Colin

Mentor
tjmapper
Posts: 229
Registered: ‎03-25-2008
Message 2 of 5 (257 Views)

Re: using expression builder to list the distance between points

05-04-2012 11:46 AM in reply to: COLINBIBLE4464

I don't believe you can connect 2 features in a calculation. Therefore you want be able to calculate the distance between. That's what lines are for :smileywink:

 

How many points are we talking?

Valued Mentor
parkr4st
Posts: 438
Registered: ‎03-24-2004
Message 3 of 5 (239 Views)

Re: using expression builder to list the distance between points

05-04-2012 02:02 PM in reply to: tjmapper

sqrt (x^2 + y^2) = the dist on a 2d plane

 

if origin is 0,0

 

then

 Sqrt ( Power (  X1 , 2 )  +  Power (  (Y1, 2 ))

 

so subract x & y of your central point from x1 and y1 of each point

 

ie origin at 1,1

 

 Sqrt ( Power ( ( X1-1) , 2 )  +  Power (  (Y1-1) , 2 ))

 

dave

 

Valued Mentor
parkr4st
Posts: 438
Registered: ‎03-24-2004
Message 4 of 5 (238 Views)

Re: using expression builder to list the distance between points

05-04-2012 02:06 PM in reply to: parkr4st

example i used  UTM83-19 coord sys.  look at the data table. I think this is what you are looking for.

 

Dave

 

 

Contributor
COLINBIBLE4464
Posts: 16
Registered: ‎04-15-2010
Message 5 of 5 (223 Views)

Re: using expression builder to list the distance between points

05-06-2012 05:34 PM in reply to: parkr4st

Thank you guys.

That was the type of solution that I was looking to implement.

I have 20 points (residences) surrounding a potential site.

I was just measuring the distance from the centre of the proposed site ( a coordinate), to each residence (nodes surrounding the proposed site)

I was writing the distances down and adding them to a spreadsheet. I wanted to shortcut that by having the distances automatically update in the data table if I moved a node (residence). Then I would export the data table into the spreadsheet.

 

Colin

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.