Category: Data Extraction

I have a lot of data in Databases, MS SQL for some of the Revit Model Extract data, MySQL for my WordPress sites and some of my data and PostgreSQL for my OpenMaint data. So linking to the Databases via Python to be able to extract, interrogate and possibly update the databases is another way

I have a process where I export Revit Models with Shared Parameter Data to a 3DPDF which can be read by anyone with a PDF viewer so that they can 1/ view 3D Geometry of Building Model, 2/ Extract data from 3DPDF to a CSV or XML file for processing. I have developed an Excel

I was looking at doing a project to test web scraping with Python. I came across this article from AIA about how many architects does the economy in the US need in the future. I found that a lot of the data used was from general government sources. So I thought I would look at

Working with large data sets in Excel is slow. So I wanted to see if I could use Python instead to wrangle the data. I wanted to use python to replicate some work I did using Excel and Knime. This was to adjust some pre-collected data from an Asset Database that was exported to a

This is the LINK to the report. The idea is to use powerBI to display data about different elements on a Dashboard so you can drill into the data. In the above screenshot I have tables showing Standard, Upper & Lower Baselife Data with conditions by colour and a map referencing where the properties are

I use Knime for re-structuring data. What is Knime? From their website: At KNIME,  we build software for fast, easy and intuitive access to advanced data science, helping organizations drive innovation. Our KNIME Analytics Platform is the leading open solution for data-driven innovation, designed for discovering the potential hidden in data, mining for fresh insights,

Please download and play with the data extraction process from 3D PDF’s to Excel. This is a  a reduced functionality demonstration version of the Excel Macro developed for extracting information from 3D PDF’s. The Macro only works on Room data from the 3D PDF’s. There are also samples of 3D PDF files with Data &

Most Asset Management Property Portfolios will consist of existing buildings. Generally new buildings coming into the portfolio will be a small percentage of the total. Information about existing buildings will most probably be scanned (Raster) plans and documents from the original As-Built construction drawing set, with some small updates in CAD (Computer Aided Drawing). This

Modern Asset & Facilities Management use information about their assets to plan and maintain them in a Fit for Purpose state so that they can fulfill their space function to maximise their asset value. To do this you require information about the buildings so that you can use predictive tools to: Effectively budget to maintain

RTV Reporter Pro Setup has interface in Revit & Database behind. Database to be called RTV_ReporterPro_SPM to have connection. If it does not exist it is supposed to Create it (when you start RTV Reporter Pro in Revit for first time), but it errored out when I re-named the original one and tried that. Inside