title: Ð¯Ð·ÑÐºÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² BIM
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Query language in BIM
Creators: name: Ð¨Ð¸ÑÐ¾Ð², ÐÐµÐ¾ÑÐ³Ð¸Ð¹
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2020
Subjects: ÑÐ·ÑÐºÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ°
IFC
BIM
Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ðµ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ
Ð¾ÑÐºÑÑÑÑÐµ ÑÑÐ°Ð½Ð´Ð°ÑÑÑ
3D ÐºÐ°Ð´Ð°ÑÑÑ
query languages
information modeling
open standards
3D cadastre

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«Ð¯Ð·ÑÐºÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² BIMÂ». Ð Ð°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð¾Ð±ÑÐ¸Ð¼ Ð¿ÑÐ¸Ð½ÑÐ¸Ð¿Ð°Ð¼ ÑÐ·ÑÐºÐ¾Ð²ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² BIM, Ð½Ð° Ð¿ÑÐ¸Ð¼ÐµÑÐµ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð´Ð»Ñ 3 d ÐºÐ°Ð´Ð°ÑÑÑÐ° Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ° Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ AutoDesk Revit Ð¸ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ ÑÐ·ÑÐºÐ¾Ð²ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² Ð¾ÑÐºÑÑÑÐ¾Ð¹ ÑÑÐµÐ´Ðµ BIMvie.ws, Ñ Ð¾ÑÐºÑÑÑÑÐ¼ Ð¸ÑÑÐ¾Ð´Ð½ÑÐ¼ ÐºÐ¾Ð´Ð¾Ð¼ Ð´Ð»Ñ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ðµ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸Ð· BIM Ð¼Ð¾Ð´ÐµÐ»Ð¸. 
ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ:
1. ÐÐ½Ð°Ð»Ð¸Ð· Ð²Ð¾Ð·Ð½Ð¸ÐºÐ½Ð¾Ð²ÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿Ð¾ÑÐ¾Ð±Ñ ÑÐµÑÐµÐ½Ð¸Ñ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼ Ð¾ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ð¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² BIM ÑÑÐµÐ´Ðµ.
2. ÐÐ±Ð·Ð¾Ñ ÑÑÑÑÐºÑÑÑÑ Ð¾ÑÐºÑÑÑÐ¾Ð³Ð¾ BIM ÑÑÐ°Ð½Ð´Ð°ÑÑÐ° IFC, ÐºÐ°Ðº Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ñ Ð½ÑÐ¶Ð½Ð¾Ð¹ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸.
3. ÐÐ±Ð·Ð¾Ñ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ñ Ð¾Ð±ÑÐ¸Ñ/BIM Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð².
4. ÐÐ½Ð°Ð»Ð¸Ð· Ð»Ð¸ÑÐµÑÐ°ÑÑÑÑ Ð¾ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ð¸ BIM Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° Ð¿ÑÐ°ÐºÑÐ¸ÐºÐµ
5. Ð¡Ð¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð¸ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð´Ð»Ñ 3d ÐºÐ°Ð´Ð°ÑÑÑÐ°.
6. ÐÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ BIM Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² 
7. Ð Ð¿ÑÐ¾ÑÐµÑÑÐµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ»Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ñ Ð¼ÐµÑÐ¾Ð´Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð¸ Ð¾ÑÐµÐ½ÐºÐ¸ ÑÐ·ÑÐºÐ¾Ð²ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð², Ð° ÑÐ°ÐºÐ¶Ðµ Ð¿ÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ¾Ðµ Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð´Ð°Ð½Ð½ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð².
ÐÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ°Ñ Ð·Ð½Ð°ÑÐ¸Ð¼Ð¾ÑÑÑ ÑÐ°Ð±Ð¾ÑÑ Ð¸ÑÑÐ¾Ð´Ð¸Ñ Ð¸Ð· Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ·ÑÐºÐ¾Ð² Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð², ÐºÐ°Ðº ÑÐ°Ð±Ð»Ð¾Ð½ Ð´Ð»Ñ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ð¸ Ð½ÑÐ¶Ð½Ð¾Ð¹ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸Ð· Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð·Ð´Ð°Ð½Ð¸Ñ BIM. ÐÐ°Ð½Ð½ÑÐµ Ð·Ð°Ð¿ÑÐ¾ÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½Ð¸Ð¼Ñ Ð´Ð»Ñ Ð²ÑÐµÑ AEC ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ¾Ð² Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÑÑÐ¸Ðµ ÑÐ¾ÑÐ¼Ð°Ñ ÑÐ°Ð¹Ð» IFC. ÐÐ°ÐµÑ Ð¾Ð±ÑÐµÐµ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ðº Ð¿Ð¾Ð´ÑÐ¾Ð´Ñ ÑÐ¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° ÑÐ°Ð·Ð½ÑÑ ÑÐ·ÑÐºÐ°Ñ.
Ð ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ»Ð¸ Ð¿Ð¾Ð»ÑÑÐµÐ½Ñ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ:
â¢ Ð¡Ð¾Ð·Ð´Ð°Ð½Ð¸Ñ ÑÐµÑÐ²ÐµÑÐ° Ð¸ ÑÐµÐ½ÑÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð½Ðµ ÑÐµÑÐ°ÐµÑ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼Ñ Ð¾ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ð¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸. 
â¢ ÐÑÐ»Ð¸ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ ÑÑÐ½ÐºÑÐ¸Ð¸ Ð¸ ÑÑÑÑÐºÑÑÑÐ° ÑÐ°Ð¹Ð»Ð° Ð¾ÑÐºÑÑÑÐ¾Ð³Ð¾ ÑÑÐ°Ð½Ð´Ð°ÑÑÐ° IFC. ÐÐ¿Ð¸ÑÐ°Ð½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ ÑÑÑÐ½Ð¾ÑÑÐ¸, ÑÐ²Ð¾Ð¹ÑÑÐ²Ð°, Ð°ÑÑÐ¸Ð±ÑÑÑ Ð¸ Ð·Ð°Ð²Ð¸ÑÐ¸Ð¼Ð¾ÑÑÑ Ð¼ÐµÐ¶Ð´Ñ Ð½Ð¸Ð¼Ð¸, Ð° ÑÐ°Ðº Ð¶Ðµ ÑÐ·ÑÐº Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð½ÑÐ¹ Ð´Ð»Ñ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ ÑÐ°Ð¹Ð»Ð° IFC.
â¢ ÐÐ¿Ð¸ÑÐ°Ð½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ Ð¾Ð±ÑÐ¸Ðµ/BIM Ð·Ð°Ð¿ÑÐ¾ÑÑ Ð¸ Ð²ÑÑÐ²Ð»ÐµÐ½Ñ Ð¸Ñ Ð²Ð·Ð°Ð¸Ð¼Ð¾Ð´ÐµÐ¹ÑÑÐ²Ð¸Ðµ ÑÐ¾ ÑÑÑÑÐºÑÑÑÐ¾Ð¹ ÑÐ°Ð¹Ð»Ð° IFC, Ð²Ð»Ð¸ÑÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° BIM.
â¢ ÐÑÐ¾Ð¸Ð·Ð²ÐµÐ´ÐµÐ½ Ð°Ð½Ð°Ð»Ð¸Ð· Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ BIM Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² ÑÐ¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ 3d ÐºÐ°Ð´Ð°ÑÑÑÐ°. ÐÑÐ¸Ð½ÑÑÐ¾ ÑÐµÑÐµÐ½Ð¸Ðµ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð´Ð»Ñ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸Ð· BIM Ð¼Ð¾Ð´ÐµÐ»Ð¸.
â¢ Ð¡Ð¾Ð·Ð´Ð°Ð½Ñ 8 Ð¾Ð±ÑÐ¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¿Ð¾ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ñ ÑÐ°Ð·Ð½ÑÑ Ð·Ð¾Ð½ Ð¸ Ð¿ÑÐ¾ÑÑÑÐ°Ð½ÑÑÐ² Ð¸Ð· Ð¼Ð¾Ð´ÐµÐ»Ð¸ BIM.
â¢ ÐÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ¾Ð·Ð´Ð°Ð½Ð½ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð½Ð° Ð¿ÑÐ¸Ð¼ÐµÑÐµ ÐºÐ°Ð´Ð°ÑÑÑÐ° 
Ð¢Ð°ÐºÐ¸Ð¼ Ð¾Ð±ÑÐ°Ð·Ð¾Ð¼, Ð¼Ð¾Ð¶Ð½Ð¾ ÑÐ´ÐµÐ»Ð°ÑÑ Ð²ÑÐ²Ð¾Ð´, ÑÑÐ¾ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ BIM Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ ÑÐ¿ÑÐ¾ÑÑÐ¸ÑÑ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ðµ Ð½ÑÐ¶Ð½Ð¾Ð¹ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð² BIM ÑÑÐµÐ´Ðµ. Ð ÑÐ°Ðº Ð¶Ðµ Ð´Ð°Ð½Ð½Ð¾Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð¿Ð¾Ð½ÑÑÑ ÑÐ¿ÐµÑÐ¸ÑÐ¸ÐºÑ Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð¸Ðµ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð², Ð½Ðµ ÑÐ¾Ð»ÑÐºÐ¾ Ð´Ð»Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² JSON, Ð½Ð¾ ÑÐ°Ðº Ð¶Ðµ Ð¸ Ð´Ð»Ñ Ð´ÑÑÐ³Ð¸x (sql, bimql, ironphython, dynamo Ð¸ Ñ.Ð´).
description: The theme of the final qualification work: âQuery Languages in BIMâ. The work is devoted to the general principles of language queries in BIM, for example, creating an information model for a 3 d inventory using the AutoDesk Revit computer-aided design complex and creating language queries in an open source BIMvie.ws environment for extracting information from a BIM model.
Tasks that were solved during the study:
1. Analysis of the occurrence and methods of solving problems with information retrieval using queries in a BIM environment.
2. Overview of the structure of the open BIM standard IFC, as a database for extracting the necessary information.
3. An overview of existing common / BIM requests.
4. Literature analysis on the use of BIM queries in practice
5. Creating a model and modeling queries for 3d inventory.
6. Evaluation of the effectiveness of BIM requests
In the research process, methods of analysis and assessment of language queries were used, as well as theoretical modeling of the application of these queries
The practical significance of the work comes from the possibility of using query languages as a template for extracting the necessary information from the information model of the BIM building. These requests are applicable for all AEC complexes supporting the IFC file format. Gives a general idea of the approach to compiling queries in different languages.
During the study, the following results were obtained:
â¢ Server creation and data centralization does not solve the problem of information extraction.
â¢ The main functions and file structure of the open IFC standard were identified. The basic entities, properties, attributes and the relationship between them are described, as well as the language used to create the IFC file
â¢ The basic general / BIM requests are described and their interaction with the IFC file structure and the effect of requests on BIM are revealed.
â¢ An analysis of the use of BIM queries in the preparation of 3d inventory. A decision was made to create queries to extract information from the BIM model.
â¢ Created 8 general queries for extracting different zones and spaces from the BIM model
â¢ Evaluation of the effectiveness of created queries using the example of the inventory
We can conclude that the use of BIM queries makes it easier to extract the necessary information in a BIM environment. And also this study allows us to understand the specifics of writing requests, not only for JSON requests, but also for others (sql, bimql, ironphython, dynamo, etc.).