Find all buildings whose bldg:measuredHeight attribute has a values less than 50

XML Query

<query xmlns="http://www.3dcitydb.org/importer-exporter/config">
  <typeNames>
    <typeName xmlns:bldg="http://www.opengis.net/citygml/building/2.0">bldg:Building</typeName>
  </typeNames>
  <filter>
    <propertyIsLessThan>
      <valueReference>bldg:measuredHeight</valueReference>
      <literal>50</literal>
    </propertyIsLessThan>
  </filter>
</query>

SQL Query for 3DCityDB v4 (PostgreSQL)

SELECT
  b.id,
  b.objectclass_id,
  b.gmlid
FROM
  citydb.building a
  INNER JOIN citydb.cityobject b ON a.id = b.id
WHERE
  b.objectclass_id = 26
  AND a.measured_height < 50.0

SQL Query for 3DCityDB v5 (PostgreSQL)

SELECT
  ftr.id,
  ftr.objectclass_id,
  ftr.gmlid
FROM
  citydb.feature ftr
  INNER JOIN citydb.property pro ON ftr.id = pro.feature_id
    AND namespace = "con"
  AND name  = "height"
WHERE
  ftr.objectclass_id = 26
 AND pro.val_double < 50