Subscribe to this thread
Home - General / All posts - Elevation Min Max
sour

125 post(s)
#16-Feb-21 13:18

How do I do this in manifold? is this possible?

I was getting the:

  • minimum value of elevation
  • Maximum value of elevation

  • Average elevation
    • Median Value of elevation - if possible

    Of a particular DMA for example:

    01-CAN05I

    • minimum value of elevation = 82
    • Maximum value of elevation = 110
    • Average elevation = 93.09
    • Median Value of elevation = 96

    I have a total of 1580 DMA. I have attached the sample. Thanks in advance

    Thanks!

    Attachments:
    Sample For Min Max.map

  • Dimitri


    6,436 post(s)
    #16-Feb-21 13:58

    Use aggregate functions.

    Example:

    SELECT Avg([Elevation]FROM [DMA CONTOUR LINE];

    Manifold User Community Use Agreement Copyright (C) 2007-2019 Manifold Software Limited. All rights reserved.