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
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
How many points are we talking?
sqrt (x^2 + y^2) = the dist on a 2d plane
if origin is 0,0
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 ))
example i used UTM83-19 coord sys. look at the data table. I think this is what you are looking for.
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.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.