Question

Floor Elevation calculation

  • 4 February 2019
  • 1 reply
  • 15 views

Hi, I have building floor plan with floor number (which is like G, M1, M2, M3, F1, ...F19 etc.) and I have height of each floor (like 3.4, 4, 4.5 etc.). We want to show the elevated floors in GIS with as per the exact height from ground (which is height of G+M1+M2+M3+F1+F2 and so on). I have attached a sample file. We have more 10000 buildings and each building has multiple floor so manual calculation of floor elevation is tedious work.


1 reply

Userlevel 2
Badge +17

If the excel records were sorted in the order from low floor to high floor already, you can use the StatisticsCalculator to calculate cumulative sum of their height for each floor.

  • Attributes to Analyze: FLOORHEIGHT
  • Sum Attribute: _sum

Then, take a look at the features outpu via the Cumulative port.

Reply