An original point of view
The previous 3 articles concentrated on the geocoding process in Excel for free. I considered the Google Sheets option and also the VBA Excel tools applicable to Bing, Nominatim, and others. Now it’s the best time to explain the process from another way around. Sometimes we have a situation when reverse geocoding is more needed … Read more
QGIS2web plugin is very handy because it is somewhat of a gateway between your QGIS project and its presence outside in the interactive version. The plugin is able to render as much as it can from our project in three types of interactive maps: Leaflet, OpenLayers, and Mapbox GL JS. The most important thing is, … Read more
I am very excited to announce to you a brand new tool, which has been developed just after the newest Stellarium edition was released. I mean the Stellarium version 0.2 onwards, which is the reach of new features. One of them is the possibility of loading the polygonal type of horizon, known by many of … Read more
The summary of my amateur test with a Sigma 150-600mm DG OS Contemporary lens and two teleconverters TC-1401 and TC-2001 includes the astrophotography section. I wanted to check this lens in terms of its ability to capture celestial objects. The fundamental difference between celestial objects and terrestrial objects is, that these first are in motion, … Read more
The inferior conjunction of Venus with the Sun happens almost every year. Almost, because in about the 8-year cycle of our neighbor planet she passes the Sun-Earth line 5 times (the synodic cycle counts 854 days exactly), making a peculiar pentagram, comprised of 5 petals. Every petal corresponds to the individual character of the inferior … Read more
The Sigma 150-600mm DG OS HSM f/5 – 6.3 + teleconverter kit TC-1401 bundle wasn’t enough for me. I just wanted to see, what the world looks like through the maximum telephoto lens, affordable for many of us at once. The difference in price between the 150-600mm C (or 150-600mm S) + TC-2001 combination and … Read more
Have you ever wondered what factors determine the leaves falling from trees in the autumn? Or maybe you noticed, that the period, when leaves fall on the ground varies every year. This article is an answer to these two basic questions because the foliage fall phenomenon isn’t so simple as thriving leaves from buds during … Read more
The TC1401 teleconverter is a good magnifier for some Sigma lenses, bringing your object by 1.4x closer than Sigma focal length can for you. If you are buying the Sigma 150-600mm f/5 – 6.3 DG OS HSM Contemporary lens, it comes quite often with it as a bundle (Pic. 1). It’s a quite good bargain … Read more
Recently I showed you how to collect the speed limit data about the specified section of the road. It’s obviously a huge step toward the speed limit map preparation. Reading the last article you got to know some examples of beautiful and very useful speed limit maps. In this reading, you will get knowledge about … Read more
My dream about a long telephoto lens finally came through. After a few weeks’s consideration, I bought the Sigma 150-600mm f/5-6.3 DG OS HSM Contemporary lens for my Nikon D5300 camera, which also included the TC1401 1.4x teleconverter, especially for this lens. Before I start the presentation on this teleconverter as well as the other … Read more
The road speed limit is somewhat guidance of what speed is considered safe and reasonable in the given section of the road or area. The primary goal of the speed limit is to keep everyone safe, not only the car driver but also the people affected nearby (pedestrians, cyclists, etc.). All speed limits are based … Read more
The 3rd part of this vast article about geocoding is slated for discussion about another free geocoding tool for MS Excel, namely the OpenStreetMap Nominatim geocoding and other remaining tools, which could be worth attention. NOMINATIM GEOCODING TOOL The usage of this small tool is very simple, even simpler than Bing Maps API geocoding, however, … Read more
It’s been a while since the previous part of this article when I showed you the way of geocoding the addresses via Google Sheets. Here you will get the knowledge of geocoding straight from the Excel sheet, without launching external platforms. A front of your eyes you have another two options. These ways were mentioned … Read more
Today I would like to demonstrate how to georeference the AutoCad .dwg file in QGIS. The .dwg extension keeps layers, colours, line thickness etc. in other words all information included in the drawing file. This is the biggest advantage of drawing files over another AutoCad extension – the .dxf. This format, on the other hand, … Read more
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 password and recover our hidden VBA project in at least a few ways. From these many ways, there are major 2 … Read more
The digitizing process is needed when we want to transform our map into vector data. This process is aimed at tracing the map features, which later appear as coordinates in either point, line, or polygon format. Digitizing is essential in the case where our data cannot be instantly integrated with the other GIS data. In … Read more
The work with addresses is quite often in our Excel spreadsheet. Today I would like to demonstrate to you how to parse the address string in the Excel cell in order to make it auto-populated on Google Maps or any other website. Nowadays many websites feature the permalink, which makes them more dynamic. The permalink … Read more
If you are an astronomer, astrophotographer, or even amateur tourist, you have some dreams about long-haul trips for sure. Quite often these trips are such long-range plans, because of our financial situation or spare time available in the foreseeable future. In astronomy or astrophotography, these plans are mostly determined by rare celestial events, which often … Read more
Finally, I decided to buy this lens after a very long contemplation. It was the longest deal with my DSLR purchase ever, which lasted more than 2 years frankly. The reason, why this optic was so desired by myself was driven by the common problem in DSLR photography – “the lack of field”. The majority … Read more
This is the second part of the article, explaining the great Venus orbit cycle, which repeats on average every 3159-3160 years. Reminding the basic mechanism it’s exactly 395 8-year cycles, where the planet back pretty much to the same place at the same time in the Sky, except the situation, where this moment in its … Read more