Nth_element - ObjectVision/GeoDMS GitHub Wiki

Aggregation functions nth_element

This operator returns the value of the nth element of ranked attribute a, which can be done in partition.

• nth_element(a, n)
• nth_element(a, n, relation)

• nth_element(a, n) results in a parameter with the nth element of the ascending sorted attribute a.
• nth_element(a, n, relation) results in an attribute with the nth elements of the ascending sorted attribute a, grouped by relation. The domain unit of the resulting attribute is the values unit of the relation.

• attribute a with numeric (uint2, uint4, uint8, uint32, float32, or bool value type)
• attribute n with uint32 value type
• relation with value type of the group CanBeDomainUnit

1. The values unit of the resulting data item should match with regard to value type and metric with the values unit of attribute a
2. The domain of argument a and relation must match,
3. The domain of argument n must be the same as the resulting domain or n must be a parameter.

5.61

1. parameter<uint32>  nth_elementNrInh                := nth_element(City/NrInhabitants, 2); result = 300
2. attribute<float32> nth_elementNrInhRegion (Region) := 
     nth_element(
          City/NrInhabitants
        , 0
        , City/Region_rel
     );

domain City, nr of rows = 7

domain Region, nr of rows = 5

• nth_element_weighted
• rth_element