How to calculate the area in table and certain coordinate

      Area        Centroid    
      ____    ________________
        9     147.67    109.11
       27     146.81    108.52
       43     147.09     109.7
       54     147.81    109.35
       12     146.17    134.42
       56     147.73    109.46
       21     146.48    134.05
       53     147.83    109.26
       20      147.3    134.25
        2      126.5       146
       43     147.67    108.63
       24        147    134.04
        2      126.5       146
       45     147.93    108.87
       20     147.25    133.95
       10      125.5     146.8
       37     147.43    108.89
       16     147.31    133.56
        6     126.17       147
       36     147.39    108.81
       12     147.92    133.75
        6      126.5       147
       34     147.32    108.91
       12     147.92    133.75
        8      126.5       146
       29     147.69       109
       13     147.54    133.38
        8      126.5       146
       28     147.71    109.11
        7     148.14    134.43
        8      126.5       146
       28     147.71    109.11
        6        148     134.5
        7     126.43    145.71
       28     147.71    109.11
        7     147.29    133.71
        1        106       132
        8     126.25     145.5
       25      147.4    109.08
        7     147.29    133.71
        1        106       132
        5      126.4     145.2
       31     147.03    108.87
        9     147.33    133.78
        2      105.5       132
        6     126.17       145
       31     147.03    108.87
        9     147.33    133.78
        1        106       132
        3     125.67    144.33
       31     147.03    108.87
        9     147.33    133.78
       31     147.03    108.87
        9     147.33    133.78
       28     147.43    109.39
       10      146.7     133.6
       25     147.08     109.4
       11     147.55    133.18
       28     147.43    109.39
        5      146.8     133.2
       20      147.7    109.55
        3        149       132
       12     147.92    109.33

Hi all, I have data above.Anyone know how to calculate the total are ? Let say Inwant calculate the the total are that have coordinate (147 109) and (146 108), is it like this the command sum([146:147 108:109])?

Answer 1

[Chetan Bhavsar]

Hello @mohd akmal masud, You need to take out Area index then sum it where centroid is within you range.

You can do that like following

Area  = [9;27;43];
Centroid = [146.67    108.11; 146.81    109.52; 146.09     108.7];
T = table(Area ,Centroid);
%check in all value which are 147 in column 1 and 109 in column 2
trueIndex = ((147>=T.Centroid(:,1) & T.Centroid(:,1)>=146)&(109>=T.Centroid(:,2) & T.Centroid(:,2)>=108));
%add all area which have 147 and 109
sum(Area(trueIndex))

Or in one liner if you want

sum(Area(((147>=T.Centroid(:,1) & T.Centroid(:,1)>=146)&(109>=T.Centroid(:,2) & T.Centroid(:,2)>=108))))

Please mark answer as accepted if it satisfies your requirement.

[mohd akmal masud]

not like this.

What I means is I want to know the sum area of centroid (147 109) and (148 110)

what you wrote is you list all the area that have certain centroid then you sum it

[Chetan Bhavsar]

I didnt understood your question can you give expected answer for your given question?

[mohd akmal masud]

Ok, I explain to you.

Let say I have this below table. If you see, the first centroid is (147.59 109.28) have area 29. The third centroid is (147.55 110.18) have area 11.

Then I wrote Function as below

function total_Area = sum_area_objects(T,coord1,coord2)
total_Area = 0;
for i = 1:height(T);
    if T.Centroid(i,1) > coord1-1 & T.Centroid(i,1) < coord1+1 & T.Centroid(i,2) > coord2-1 & T.Centroid(i,2) < coord2+1
        total_Area = total_Area + T.Area(i);
    end
end
end

So , I dont know how to sum all the area that have centroid from (147 109) till (148 110). I wrote below but the answer is wrong. Because I want to all the centroid that have decimal point also .

Your_Answer = sum_area_objects( T, 147:148 , 109:110)

Area        Centroid    
____    ________________

29     147.59    109.28
7        147    129.57
11     147.55    110.18
1        147       129
2        122     142.5
2        122     142.5
1        142       139
14      145.5    111.14
1        142       138
57     146.74    108.68
81     147.05    109.85
1        142       137
4     147.75    129.75
93     147.75    109.56
40     146.28    134.05
1        125       145
95     147.68    109.52
50     146.48     133.8
6     125.67    146.33
92     147.77    109.37
52     147.15    134.06
12      126.5       146
80     147.62    108.91
55     146.89    133.84
3     105.33    135.33
13     126.31    145.92
79     147.84    108.89
46     147.07    133.89
6      105.5     135.5
28      125.5    146.86
71     147.45     108.9
42     147.17    133.64
7     105.57    135.14
23     126.09    146.91
70     147.41    108.84
34     147.82    133.85
9     105.67    134.78
23     126.35    146.57
68     147.38    108.93
34     147.82    133.85
10      106.2     134.2
27     126.41    146.04
63      147.6    108.92
35      147.6    133.63
15      105.8    133.47
26      126.5       146
61     147.64    109.05
29     147.76    134.14
13     106.08    133.15
26      126.5       146
61     147.64    109.05
28     147.68    134.18
14     105.93    132.86
27     126.26    145.78
61     147.64    109.05
29     147.41     133.9
16     105.75    132.38
29     126.07    145.62
58      147.4    108.91
29     147.41     133.9
15     105.73    132.53
21     126.52    145.38
64     147.12    108.86
31     147.42     133.9
16      105.5    132.25
23     125.96    144.91
64     147.12    108.86
33     147.21    133.82
14        106       132
18     125.56    144.67
64     147.12    108.86
34     147.32    133.85
4      105.5     133.5
10      125.7       145
64     147.12    108.86
34     147.32    133.85
1        106       133
9     125.56    144.78
61     147.52    109.31
34     146.94    133.79
5      125.4     143.8
57     147.25    109.26
38     147.63    133.26
61     147.52    109.31
28     147.25    133.21
50     147.78    109.32
20      148.4    132.15
35     147.71    109.57

[mohd akmal masud]

T=table;
T.Area = data(:,1);
T.Centroid = data(:,2:3);
Input1 =[147 109];
Input2 =[148 110];
Unrecognized function or variable 'data'.

[Chetan Bhavsar]

So as per you you want

sum all the area that have centroid from (147 109) till (148 110).

146.94 - not needed

147.63 - needed

148.4 - not needed

is my understanding correct?

[Chetan Bhavsar]

data = [      9     147.67    109.11
     27     146.81    108.52
     43     147.09     109.7
     54     147.81    109.35
     12     146.17    134.42
     56     147.73    109.46
     21     146.48    134.05
     53     147.83    109.26
     20      147.3    134.25
      2      126.5       146
     43     147.67    108.63
     24        147    134.04
      2      126.5       146
     45     147.93    108.87
     20     147.25    133.95
     10      125.5     146.8
     37     147.43    108.89
     16     147.31    133.56
      6     126.17       147
     36     147.39    108.81
     12     147.92    133.75
      6      126.5       147
     34     147.32    108.91
     12     147.92    133.75
      8      126.5       146
     29     147.69       109
     13     147.54    133.38
      8      126.5       146
     28     147.71    109.11
      7     148.14    134.43
      8      126.5       146
     28     147.71    109.11
      6        148     134.5
      7     126.43    145.71
     28     147.71    109.11
      7     147.29    133.71
      1        106       132
      8     126.25     145.5
     25      147.4    109.08
      7     147.29    133.71
      1        106       132
      5      126.4     145.2
     31     147.03    108.87
      9     147.33    133.78
      2      105.5       132
      6     126.17       145
     31     147.03    108.87
      9     147.33    133.78
      1        106       132
      3     125.67    144.33
     31     147.03    108.87
      9     147.33    133.78
     31     147.03    108.87
      9     147.33    133.78
     28     147.43    109.39
     10      146.7     133.6
     25     147.08     109.4
     11     147.55    133.18
     28     147.43    109.39
      5      146.8     133.2
     20      147.7    109.55
      3        149       132
     12     147.92    109.33];
T=table;
T.Area = data(:,1);
T.Centroid = data(:,2:3);

Input1 =[147 109];
Input2 =[148 110];

output = sum(T.Area(((Input2(1)>=T.Centroid(:,1) & T.Centroid(:,1)>=Input1(1))&(Input2(2)>=T.Centroid(:,2) & T.Centroid(:,2)>=Input1(2)))))

[mohd akmal masud]

I used your code but have error

Unrecognized function or variable 'data'.

[mohd akmal masud]

>> T.Centroid = Data(:,2:3);
Variable index exceeds table dimensions.

[Image Analyst]

This answer is marked as Accepted so we assume you have it figured out by now.

[Chetan Bhavsar]

@mohd akmal masud

data = [      9     147.67    109.11
     27     146.81    108.52
     43     147.09     109.7
     54     147.81    109.35
     12     146.17    134.42
     56     147.73    109.46
     21     146.48    134.05
     53     147.83    109.26
     20      147.3    134.25
      2      126.5       146
     43     147.67    108.63
     24        147    134.04
      2      126.5       146
     45     147.93    108.87
     20     147.25    133.95
     10      125.5     146.8
     37     147.43    108.89
     16     147.31    133.56
      6     126.17       147
     36     147.39    108.81
     12     147.92    133.75
      6      126.5       147
     34     147.32    108.91
     12     147.92    133.75
      8      126.5       146
     29     147.69       109
     13     147.54    133.38
      8      126.5       146
     28     147.71    109.11
      7     148.14    134.43
      8      126.5       146
     28     147.71    109.11
      6        148     134.5
      7     126.43    145.71
     28     147.71    109.11
      7     147.29    133.71
      1        106       132
      8     126.25     145.5
     25      147.4    109.08
      7     147.29    133.71
      1        106       132
      5      126.4     145.2
     31     147.03    108.87
      9     147.33    133.78
      2      105.5       132
      6     126.17       145
     31     147.03    108.87
      9     147.33    133.78
      1        106       132
      3     125.67    144.33
     31     147.03    108.87
      9     147.33    133.78
     31     147.03    108.87
      9     147.33    133.78
     28     147.43    109.39
     10      146.7     133.6
     25     147.08     109.4
     11     147.55    133.18
     28     147.43    109.39
      5      146.8     133.2
     20      147.7    109.55
      3        149       132
     12     147.92    109.33];
T=table;
T.Area = data(:,1);
T.Centroid = data(:,2:3);
Input1 =[147 109];
Input2 =[148 110];
output = sum(T.Area(((Input2(1)>=T.Centroid(:,1) & T.Centroid(:,1)>=Input1(1))&(Input2(2)>=T.Centroid(:,2) & T.Centroid(:,2)>=Input1(2)))))

output = 466

[Chetan Bhavsar]

has your data changed recently?

[mohd akmal masud]

yah..

T =

1593×2 table

Area                Centroid         
__________    __________________________

7.9862e+05    128.24    134.13    72.539
1        16       139         1
13    36.462    99.308    1.1538
75    69.987    156.37    3.2267
1        73       229         1
1        79       192         1
31    85.903    175.84    1.3226
80     95.75    128.22     1.575
21    95.333    169.38    1.1429
2095    90.026    119.06    7.0692
7    105.71        36         1
1       108       145         1
2     110.5       146         1
1       113       230         1
1       115       147         1
1       118       148         1
1979    128.44    174.24    6.4785
1       142        86         1
9    148.89    229.22         1
1275    152.11    172.63    8.7867

[Chetan Bhavsar]

in this case there are 2 area what do you want with them 1st one or second or sum?