Skip to main content
Question

Floor Elevation calculation

  • February 4, 2019
  • 1 reply
  • 40 views

vini.devgan

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • February 4, 2019

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.