Choropleth map in QGIS based on the MS Excel data
This time I would like to present an excellent way of making the simple choropleth map in QGIS, based on MS Excel data. Occasionally you will be acquainted with some tricks, which help you...
Category: Data
Extraction of item properties from AutoCAD LT to Excel
AutoCAD LT version is quite poor when compared to the full AutoCAD 3D software. It means in practice, that some options aren’t available or require a bigger workaround in order to get to the...
Updating the attribute table in QGIS from other layers
The data attribute table in QGIS can be updated in different ways. We can use the “Default value” option, provide the formula to our column, and replace some content, and so forth. In this...
Batch import PDF document to Google Sheets – random data
Importing PDF documents directly to Google Sheets still remains a tricky issue. The first stop at this conversion route is using Google Docs, where you can extract the PDF content nicely. One more thing...
Populating multiple Excel sheet stuff in QGIS
Today I would like to discuss the process of how can we plot bulk data located in multiple Excel worksheets to QGIS and display them as the point layer. I definitely mean the situation,...
Good way to sanitizing a bulk address list, part 1 – Excel & VBA
When you work with any Excel data, probably you experienced sometimes, that the spreadsheet input looks messy. I personally deal with the address data predominantly, which you could notice by reading my previous articles...
Smart way of unlocking the Excel VBA project and workbook
Probably experienced a sad situation when the password for your Excel workbook is lost or forgotten. Head up, because it’s not the end of the world. Nowadays we can easily break down the forgotten...
Excel Spreadsheet batch data geocoding for GeoJSON and JSON files
Recently I was dealing with geotagging single addresses in Google Maps and other easily accessible tools. However, the stuff, that I focused on is playing around with single placemarks only. I believe, that this...
The fastest way to execute UK address list using MySQL and PostgreSQL
The United Kingdom addresses are specific because usually, a single postcode applies to a single building or at most a compact group of properties. It means, that these objects can be found very quickly,...