Get Element Type in IdgnDB

Hello,

I am trying to extract from an idgndb sqlite extract (using DgnV8Converter 2.0) of an i.dgn file the list of element type (Mesh, Line String, Cell, Extended Element) for each 3D elements.

So far I get the list of 3D objects by querying the table bis_GeometricElement3d and I get the element Identifier by querying the table bis_ElementMultiAspect.

My first thought was the get this information from the GeometryStream column of table bis_GeometricElement3d but I could not find documentation on how to read this blob.

Thanks.

Louis-Marie Borione