When can we see full Moon in daylight?
At the beginning of this article, I would like to recall one of the questions, which appears from time to time on the Geography Olympiad. The query sounds like this: “If at 9 pm...
Practical & popular science Service
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...
Is the selenelion lunar eclipse really rare event?
In this text, I would like somewhat to continue the thread from the previous one, which has described briefly my observation of the “just” partial lunar eclipse on Monday morning of May 16th. As...
Why Indoor Mapping Is A Game Changer For Transportation Hubs
Imagine if you could know exactly where you were inside a building, without ever having to ask for help. Indoor mapping is making this a reality, and it’s changing the way we navigate transportation...
Just partial lunar eclipse of May 16th 2022
I had a good occasion to watch just a partial lunar eclipse from southeastern Poland – my homeland, this time. The event, although very short, will be remembered probably forever. Before I will get...
Lunar occultations of the brightest stars in the 2021-2040 period
The last piece of the topic about the most interesting celestial events in the period of 2021 – 2040 covers lunar occultations of stars. I haven’t described it before, because in my point of...
Making fibre FTTx schematics in QGIS
This article is dedicated to anyone, who works in the telecom industry and struggles with creating the FTTx schematics. We have several nice ways to combat our day-to-day work, although not all of them...
Quick transfer the QGIS legend from print layout to Excel
Maybe you were wondering about the possibility of transferring the legend from the QGIS print layout to Excel? This short text shows you how to do it, especially for the simple legend, which won’t...
The 49 brightest stars in the night sky – when and where can we see them?
Since this amazing image (at the top) has been published, the articles about the 25 brightest stars in the night sky grew like weeds. Despite a multitude of similar texts presenting a brief description...
KMZ to KML – quick conversion with Python
In this short text, I would like to mention a couple of steps to the successful conversion of the Google Earth files between the .kmz and .kml. As we know, the .kmz file is...
How can I make a geographic heat map in Google Maps?
A heat map represents the density of specific data within an area of a map. It presents as color-coded circles on the map, depending on set parameters. The aggregation of this data formulates with...
The quickest way of making the speed limit map
Previously I explained to you how to make the speed limit in QGIS and display it in Google Maps. This process required drawing the new layer including the speed limit of the given road...
Displaying OpenInfraMap data in QGIS
OpenInfraMap is one of many OpenStreetMap projects, which is concentrated on highlighting the infrastructure worldwide. Predominantly this infrastructure is invisible in the major OpenStreetMap rendering but is directly sourced from OpenStreetMap. The OpennInfraMap is...
Preparing simple custom grid in QGIS print composer
Print composer in QGIS gives us the possibility of creating printable maps and atlases, which can be saved as the .pdf or .svg. The print composer provides a wide spectrum of options by adding...
Opening Google Street View in VBA Excel
Opening websites programmatically at their certain addresses is quite a straightforward thing regardless of the programming language. Previously I dealt with launching Google Maps from the Excel document with the Google Chrome browser. Now...
Happy New Year 2022 to everyone!
We are coming to the end of the next year, another busy year for anyone of us. At the finish of the 6th year of the MkrGeo blog, I would like to wish all...
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...
A guide for displaying the Sweet Home 3D model in Google Earth
Sweet Home 3D is an open-source architectural design software, mostly dedicated to interiors, which helps users create a 2D plan of a house with a 3D preview. In this design software, a user can...
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,...
What determines the brightness of the star and how to measure it?
The starry night is a nice view for everyone I guess quite often we like to lie on the ground and gaze at the sky full of stars. In the whole Milky Way, we...