# A Unified Database Solution to Process BIM and GIS Data
## 3 Results
### Implementation of the Common Database Environment for IFC and CityGML Data
\begin{table}
\begin{tabular}{c c} \hline \hline
**CityGML** _AbstractBuildingType_ **Class** & **Multiple IFC Attributes and Classes** \\ \hline _class_ & The class of an object can be determined from the data contained in the attribute sets assigned to the object. \\ _function_ & The function of an object can be determined from the data contained in the attribute sets assigned to the object. \\ _usage_ & _Occupancy/Type_ attribute from the _Pset_BuildingCommon_ property set attached to the building. \\ _yearOfConstruction_ & _YearOfConstruction_ attribute from the _Pset_BuildingCommon_ property set attached to the building. \\ _yearOfConstruction_ & The date of decommissioning the building is determined by analyzing the data contained in the property sets assigned to the object if such information is present in the building model. \\ _yearOfDemolition_ & _ObjectType_ attribute of the _lfcRoof_ object class assigned to the _lfcBuilding_ object. \\ _rooftType_ & Determining the height of the building takes place through the analysis of geometric objects indicated by the attributes _Representation_ and _ObjectPlacement_ of the _lfcBuilding_ object. \\ _measuredHeight_ & _NumberOfStorys_ attribute from the _Pset_BuildingCommon_ property set attached to the building or the number of _lfcBuildingStorey_ objects attached to the building. The determination of the number of stories above and below the ground level is made by analyzing the attributes _ObjectPlacement_ of each _lfcBuildingStorey_ object attached to the building. \\ _storeyHeglitsAboveGround_, _storeyHeglitsBelowGround_ & The determination of the height of the stories above and below the ground level is made by analyzing the _Representation_ attributes of the _lfcBuildingStorey_ objects. \\ _lodFootPrint_ & The outline of the building on the ground is determined by analyzing the geometric objects indicated by the _Representation_ attribute of the _lcdRoofEdge_ \\ _lodIoRoofEdge_ & The roof edge is determined by analyzing the geometric objects indicated by the _Representation_ attribute of the _lcdRoof_ object assigned to _lfcBuilding_. \\ _lodIoISolid_, _lodIMultiSurface_, _lodIMultiCurce_, _lod2 Scild_, _lod2 Scild_, _lod2 Scrinathtresection_ & The geometry of the building body and its contact with the ground are determined by analyzing the geometric features of the objects indicated by the _Representation_ and _ObjectPlacement_ attributes of the building. \\ _lod2 Scild_, _lod2 Scild_, _lod2 Scrinathtresection_ & The list of objects related to the building outside of the building body can be obtained on the basis of the relationships that aggregate these objects with the building or _lfcSuic_ object. \\ _outerBuildingInstallation_ & The list of building-related objects inside the building body can be obtained on the basis of the _lfcReIContained_ aggregating relationships. \\ _interiorBuildingInstallation_ & The building outline can be obtained from the _lfcPolyLoop_ object defining the building outline. \\ _loadBy_ & The geometry of the building body and its contact with the ground are determined by analyzing the geometric features of the objects indicated by the _Representation_ and _ObjectPlacement_ attributes of the building. \\ _lod4 Scild_, _lod4 Scild_, _lod4 Scrinathtresection_ & The geometry of the building body and its contact with the ground are determined by analyzing the geometric features of the objects indicated by the _Representation_ and _ObjectPlacement_ attributes of the building. \\ _interiorRoom_ & The list of rooms can be obtained by _lfcReIAggregates_ aggregation. \\ _consistsOfBuildingPart_ & The list of objects inside the building can be obtained by the _lfcReIAggregates_ and _lfcReIContained_ aggregations. \\ _address_ & The _lfcPostalAddress_ object related to the _lfcBuilding_ object. \\ \hline \hline \end{tabular}
\end{table} 
Table 1: An example of the process of obtaining data for the CityGML model from the Industry Foundation Classes (IFC) model.