Author: Max Drake

After my first attempt to compile an executable programme with python, with no success. I thought I’d give it another try. The issue seems to be that the compilers do not play well with Python 3.6 yet. The nearest I came to getting anything working was with the CX_Freeze module with a setup.py file  as

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 downloaded a lot of stuff from Github but haven’t really bothered figuring what it was about. I found this video a simple way to get my head around it and get to use it initially: Github Tutorial For Beginners – Github Basics for Mac or Windows & Source Control Basics I had signed

Panoramic files (360/180) can be viewed directly with a programme such as Paint, but they do not make much sense. You need a specific Panoramic programme to read the files correctly. I use the FREE photo sphere viewer by Jeremy Heleine. Follow the link to see the demos. The method that the programme uses is

The new   photo sphere viewer by Jeremy Heleine allows you to put Markers on your Panorama . See demo here. I think that is pretty cool and I wondered if you could make them into Hyperlinks to link other panoramas to make a virtual tour. So I did some tests. My previous way to be

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

After trying and writing post about EpiCollect5 I decided to look at another data collection tool, Open Data Kit (ODK). A brief overview of it in video below: This has some strengths and weaknesses over EpiCollect5. Weaknesses: Only Android App, not Apple (but since there are lots of cheap Android mobiles this is not a

I had a couple of attempts at creating a mobile phone app for surveys. See this post and this one. I got distracted by the CRUD process and let it rest for a while. Whilst looking for some Python Mapping tools, I came across this article regarding capturing GPS data and was taken with the

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