Infraworks is software that terminates 3D data in a GIS-like manner to create an integrated BIM model. It is also a software for schematic design of civil engineering structures from a bird's eye view.
The Infraworks data itself is stored in .sqlite format, which is a great feature of the database format itself. (This is a great thing, yet it is not taken up much in the Japanese civil engineering industry. That's because we don't design with data.)
So, using my beloved Power BI, I would like to visualize the database, Infraworks, with a BI tool.
①First, I will connect Infraworks directly to Power BI via ODBC.
②After selecting ODBC, the data source name is "SQLite3 Datasource" and in the advanced configuration options, enter "database = path to InfraWorks data" in the connection string.
③The _journal_~ file had no particular content, so we ignored it. Read from "ABUTMENTS" to the very bottom.
Since it is difficult to check the contents of queries in Power BI, it is recommended to install DB Browser for SQLite to check the contents of the queries. Let's do the data processing on Power BI.
Here is a dashboard I created on the fly.
The actual product can be seen here.
Infraworks, which doesn't see the light of day very often, may actually be the most advanced in database design.
3 Comments
