ifcSQL_Tools_for_QGIS

KO | EN

gitlite — search

#python #llm #go #machine-learning #linux #docker #java #windows #awesome #vue #security #pytorch #ios #mcp

ifcSQL_Tools_for_QGIS

(★ 19)

This repository contains the code for the ifcSQL_Tools QGIS plugin that allows you to interact with (load, view, filter, query and delete) IFC data stored in the ifcSQL database.

ifcSQL_Tools_for_QGIS 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# <img src="https://github.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/raw/main/Icons/icon.png" width="40" alt="icon"> ifcSQL_Tools_for_QGIS 
This repository contains the code for the ifcSQL_Tools QGIS plugin that allows you to interact with (load, view, filter, query and delete) IFC data stored in the ifcSQL database.

What can you do with this plugin?
- Load all your georeferenced IFC models into database;
- View all your IFC models simultaneously on a map (in 2D or 3D);
- Filter and display only the IFC elements that interest you;
- Query IFC elements to view their attributes and properties;
- Delete the IFC models you no longer need from the database;

Below is an example of a wastewater treatment plant consisting of 21 IFC files.

![Screenshot ZIP download](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/01_WWTP_QGIS.png)

> [!NOTE]
> 
> Currently, the plugin is designed to work only on Windows and with QGIS 3.40-3.44
>

# 🛠️ How to install and set up the plugin?

### (1) Download the **`Source code (zip)`** from the "Releases".
 ![Screenshot ZIP download](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/02_ZIP_download.png)

### (2) Install the plugin from the ZIP file in QGIS. 
 ![Screenshot install plugin from ZIP](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/03_Install_from_ZIP.png)

### (3) Open the plugin folder, then open the “first_installation” folder and follow the instructions starting with the first PDF file: [0.Start with ifcSQL_Tools.pdf](./first_installation/)
 ![GIF plugin folder](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/04_open_plugin_folder.gif)

> [!NOTE]
> Here you can find the video tutorial on how to install and set up the plugin: https://www.youtube.com/watch?v=iwmdUl1p-14
>

# 🚀 How to use the plugin?

### (0) Before you start using the plugin, you need to connect to the two databases (MSSQL and PostgreSQL) that you created in the previous steps.
 ![Screenshot Connect_MSSQL](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/05.1_Connect_mssql.png) 
 ![Screenshot Connect_postgres](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/05.1_Connect_postgres.png)

### (1) You can import an IFC file using the “Import IFC file” button. 
Remember that you must import the file first into MSSQL and then into PostgreSQL for the process to be complete. If you need help georeferencing an IFC model, see: https://ifcgref.bk.tudelft.nl/. The steps to follow (for both databases) are:
- Select an existing connection or create a new one.
- Connect to the selected database.
- Select the IFC file you want to import (For importing into PostgreSQL: the plugin will suggest the last file imported into MSSQL).
- Import the IFC file.

It is recommended to split larger models into multiple IFC files to speed up the loading process, which might otherwise be slow.

> [!NOTE]
> Currently, you must import georeferenced IFC models that use the same coordinate reference system (CRS). If you import IFC models with different CRSs, they will all appear on a single
layer in QGIS, causing some models to be displayed at an incorrect geographic location relative to the QGIS map’s CRS.
>

![Screenshot ImportIFCfileMSSQL](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/06_ImportIFCfileMSSQL.png) 
 ![Screenshot ImportIFCfilePostgreSQL](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/07_ImportIFCfilePostgreSQL.png)

### (2) You can delete an IFC file using the “Delete IFC file” button. 
The file will be deleted from both databases or only from MSSQL if it has not alredy been imported into PostgreSQL. The steps to follow are:
- Select the existing connections (both databases).
- Connect to the selected databases.
- Select the IFC file you want to delete (the plugin will show you whether the file is present only in MSSQL or in both databases).
- Delete the IFC file.
 ![Screenshot DeleteIFCfile](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/08_DeleteIFCfile.png)

### (3) You can filter IFC geometries using the “IFC Filter” button. 
You can filter the IFC geometries in your database by following these steps:
- Select the existing connections.
- Connect to the databases.
- Decide whether to use both the context filter and the IFC filter (you can disable one of them).
- In the context filter, you can select three types of filters: “default filter” if you have geographical areas loaded in your database; “manual filter” if you want to draw the area extents; “project filter” if you want to filter by a specific IFC file.
- In the IFC filter, you can select three types of filters: "IFC Class Filter" if you want to filter by Class; "IFC Building Storey Filter" if you want to filter by Building Storey; "IFC Class and Building Storey Filter" if you want to filter by Building Storey and then by Class.
- Apply filter.
 ![Screenshot IFCquery](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/09_IFCFilter.gif)

### (4) You can query IFC elements using the “IFC Query” button. 
You can query the IFC elements in your database by following these steps:
- Select the existing connections.
- Connect to the databases.
- Select an element.
- Read its attributes and properties.
 ![Screenshot IFCquery](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/10_IFCQuery.gif)

# 🔍 How to view imported geometries?

Once the data has been imported (MSSQL + PostgreSQL), you can easily view your IFC geometries directly within QGIS. Just follow the steps below:
- Import the `entitygeometry` table from PostgreSQL using a simple drag-and-drop.
- Import `OpenStreetMap` layer to provide a geographical background. 
- Access the layer properties and enable the 3D view representation.
- Click the "3D map view" button.

![GIF 3Dmapview](https://raw.githubusercontent.com/MicheleBerlato/ifcSQL_Tools_for_QGIS/main/github_images/11_3Dmapview.gif)

# 🎓 Paper & Citation

Even if the workflow has been enhanced, particularly simplifying geometry conversion, you can read the original paper to see how it all started:

- **IFC and QGIS integration for the Integrated Water Service Management**  
  Michele Berlato, Giorgio Agugiaro, Ken Arroyo Ohori, Carlo Zanchetta  
  *ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences*, Vol. XI-4-2026, pp. 13–20, 2026.  
  🔗 **DOI:** [10.5194/isprs-annals-XI-4-2026-13-2026](https://doi.org/10.5194/isprs-annals-XI-4-2026-13-2026)

# 📁 Folders Contents

- first_installation = folder containing the files needed to install and set up the plugin;
- github_images = folder containing the images shown in the GitHub readme;
- i18n = folder containing the translation of the plugin into English;
- Icons = folder containing the icons used in the plugin;
- IfcSQL_scripts = folder containing the scripts for setting up the tables in the two databases;
- tds_FDW_16 = folder containing the scripts for install the "Foreign Data Wrapper";
- UIs = folder containing the user interfaces included in the plugin.

ifcSQL_Tools_for_QGIS

ifcSQL_Tools_for_QGIS 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

ifcSQL_Tools_for_QGIS

ifcSQL_Tools_for_QGIS 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README