I’m using STArea() function to get an area from the geography column.
I’m facing some problems there:
1-Geography values are not saved in correct order in Origam. STArea() is giving huge numbers - the whole worlds area minus the object area is counted instead of the single object area.
Actually I’m workarounding this problem by @Expression.ReorientObject().STArea().
By this way I’m giving correct values.
2-The saving of geography object (painted from GUI) is inconsistent in Origam.
In some minor cases users are able to paint the object reverted.
By this way almost all values are saved reverted but some are saved “correctly”.
Actually I’m using version 2021.1.1875.0.