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