I have two layers. A layer represented by a fishnet and a layer represented by certain boat routes. After I intersect them I want to be able to calculate the sum and max value for certain characteristics like dead weight, gross tonnage and beam per each square from the fishnet per each track.
Here is an example of how my table looks like after I intersect the fishnet with the boat tracks:
FID_Sample FID_FishGr mmsi Beam Gross_Tonn Deadweight 0 7017 440296000 8 764 394 1 7017 440296000 8 764 394 2 7017 440761000 12 812 588 3 7017 440761000 12 812 588 4 7017 440980000 10 788 391 5 7017 440980000 10 788 391 6 7017 441053000 10 811 455 7 7017 441053000 10 811 455 As you can see in each square(FID_FishGr), there are a certain number of tracks(mmsi) and each track has it's own characteristics of Beam, Gross_Tonn and Deadweight.
Now I have created a model, hoping that I have solved my problem nice and easy, but when I checked the math in excel it weren't the results I expected.
When I use the model posted above, and I want to calculate the SUM for Gross Tonnage in each FID_FishGr it gets me the sum of all boat tracks even if they are duplicate(more lines of the same track in a square).
OBJECTID FID_FishGr FREQUENCY SUM_Gross_ 1 7017 8 6350 2 7018 2 1576 3 7019 1 788 4 7183 8 6350 5 7184 8 6350 6 7185 5 3987 7 7186 3 2411 8 7349 8 6350 9 7350 8 6350 Lets take a clear example: - in the first table you can see the tracks in one entire square and if you add the gross tonnage for each track you will get 3175 but if I sum it up with summary statistic I get 6350, as you can see in the second table.
What I want to achieve, is to calculate a SUM for each unique square of the fishnet using only unique track boat and not to sum up all of them.
What tool should I use to do this and how?
أكثر...
Here is an example of how my table looks like after I intersect the fishnet with the boat tracks:
FID_Sample FID_FishGr mmsi Beam Gross_Tonn Deadweight 0 7017 440296000 8 764 394 1 7017 440296000 8 764 394 2 7017 440761000 12 812 588 3 7017 440761000 12 812 588 4 7017 440980000 10 788 391 5 7017 440980000 10 788 391 6 7017 441053000 10 811 455 7 7017 441053000 10 811 455 As you can see in each square(FID_FishGr), there are a certain number of tracks(mmsi) and each track has it's own characteristics of Beam, Gross_Tonn and Deadweight.
Now I have created a model, hoping that I have solved my problem nice and easy, but when I checked the math in excel it weren't the results I expected.
When I use the model posted above, and I want to calculate the SUM for Gross Tonnage in each FID_FishGr it gets me the sum of all boat tracks even if they are duplicate(more lines of the same track in a square).
OBJECTID FID_FishGr FREQUENCY SUM_Gross_ 1 7017 8 6350 2 7018 2 1576 3 7019 1 788 4 7183 8 6350 5 7184 8 6350 6 7185 5 3987 7 7186 3 2411 8 7349 8 6350 9 7350 8 6350 Lets take a clear example: - in the first table you can see the tracks in one entire square and if you add the gross tonnage for each track you will get 3175 but if I sum it up with summary statistic I get 6350, as you can see in the second table.
What I want to achieve, is to calculate a SUM for each unique square of the fishnet using only unique track boat and not to sum up all of them.
What tool should I use to do this and how?
أكثر...