2026

Happy New Year 2026 to everyone

2025-12-31 by Krukarius

Happy New Year 2026 to everyone! This year will be challenging in many ways, especially in scientific development. I hope that some nice things will come through and that the ongoing challenges will be completed. I will stay positive over the forthcoming year, which is crucial. The new year marks the 10th anniversary of my … Read more

The elevation trick in Stellarium

2025-10-152025-10-15 by Krukarius

The Stellarium software offers a bunch of useful options for rendering the sky view in light of different cultures. The best ground-breaking option introduced a while ago is the ShowMySky mode for rendering the true atmosphere, about which I wrote in this article. It’s not everything! As I came to another function, an inherent rendering … Read more

Great American Eclipse visible from Europe

2025-09-292025-09-25 by Krukarius

Solar eclipse 2024 below the horizon in Spain, panoramic view

This is another lengthy text summarizing the solar eclipse from a scientific perspective. This time, it’s focused on the visibility of the Great American Eclipse in Europe. By understanding the Great American Eclipse, we mean the totality visible from North America on April 8, 2024. Notwithstanding the partial phase, which could be, at least theoretically, observed … Read more

The 4 years of solar eclipses (2019-2022) – summary

2025-08-012025-06-05 by Krukarius

Partial solar eclipse of October 25, 2022

As an eclipse chaser, I try to conduct as many professional observations as possible from every eclipse. Practically, I miss some of them because of a lack of funds or, at the very least, decent webcams in the areas where they occur. Last, my scientific conundrum isn’t covered by anyone who attends on-site. Therefore, the … Read more

Scientific report of March 29, 2025 partial solar eclipse

2025-05-232025-05-08 by Krukarius

Spectacle projection Jasło partial solar eclipse 2025 3

We are over a month ahead of the last partial solar eclipse on Saturday, March 29, 2025. It wasn’t a big eclipse in most European countries. Because of the largest magnitude of 0.9376, this eclipse was classified as a deep partial. Considering the Gamma factor 1.0405, the totality was visible about 210 km above the … Read more

Automated email notification in ArcGIS Field Maps Designer

2025-02-26 by Krukarius

Integromat make with Field Maps Designer

Field Maps Designer is a mobile solution integrated with ArcGIS Online, which allows users to capture the data on-site. On top of that, Field Maps Designer enables users to create notes, perform some inspections, and, most importantly, share all the information instantly with the office. In this article, I would like to pay attention to … Read more

ArcGIS Pro – Changing field names by the export

2025-02-18 by Krukarius

Changing the field name should be easy in ArcGIS Pro. The link and video below show how to do it quickly. I propose an alternative method for exporting your layer to answer the situation presented in the forum thread below. See all the steps below: 1. Right-click on your layer -> Data -> Export Features … Read more

Fetching ArcGIS Online layer into Power BI

2025-02-04 by Krukarius

This text is somewhat the expansion of this tutorial, which explains how we can load the ArcGIS Online layer attribute table into Excel via PowerQuery. As PowerBI is considered here, these steps are the same, although there are things to look at before. 1. In the first step, we must equip our attribute table data … Read more

ArcGIS Online attribute table to Excel – the most rapid export

2025-05-232025-01-16 by Krukarius

ArcGIS Online to Excel via PowerQuery header

Each layer uploaded or produced in ArcGIS Online has its attribute table. It’s the same as in other GIS tools like QGIS or ArcGIS Pro. If so, the user can export it to the spreadsheet and save it later as a .csv or .xslx file, for example. The classical exporting method is through the layer … Read more

The quickest decimal to DMS convertion in Excel

2025-01-242025-01-06 by Krukarius

Coordinates DMS to decimal and decimal to DMS one cell only Excel

Suppose you work on geographical or astronomical projects requiring transformation between the decimal and degree-minute-second pattern. You probably want to have everything converted as quickly as possible. On the web, some tutorials explain that the most common solution is using the Data -> Text to Columns with the main ribbon. Another way presented in the … Read more

Happy New Year 2025 to everyone

2025-05-232024-12-31 by Krukarius

You might have noticed the long inactivity if you read articles on my website regularly. The last serious article was about the lunar standstill and the entire website went quiet. What is the reason behind it? For over 8 years of running this blog/website I did my best to provide the original approach for various … Read more

AutoCAD LT – ArcGIS Pro – ArcGIS Online quickest data transfer

2025-05-282024-07-18 by Krukarius

Suppose you visit my website quite often as a GIS Specialist or similar. In that case, you probably know my texts about transferring the AutoCAD LT data to ArcGIS Online using the QGIS application. This way is free, although it features some unpleasant limitations i.e. lack of attributes, which can be painful for further data … Read more

Major lunar standstill and moonrise/moonset azimuth fluctuations

2025-08-012024-06-10 by Krukarius

The text explains the rare phenomenon, in which the azimuths of moonrise and moonset are more extreme. This situation allows us to see distant landscape features with the lunar disk beyond. Learn more about the lunar standstill and its frequency across the centuries. The changes in moonrise/moonset azimuths can give you a clue of how some Megalithic constructions have been set and how the Moon’s path across the sky would have looked like thousands of years before. Moreover, the declination of the Moon isn’t the same. It changes significantly because of the parallax.

UK Address sanitizer in Excel 365

2025-12-022024-05-06 by Krukarius

This article will shortly describe the tool I needed to develop recently. It is aimed at addressing cleansing. The general lists of addresses are often messy. It means, that the components of the address aren’t ordered well amidst various spaces and commas in the wrong places. It eventually excludes these addresses from proper geocoding and … Read more

Stellarium and ShowMySky visual model

2025-05-282024-01-31 by Krukarius

Stellarium is the astrosoftware developed for many years. There were quite a lot of versions of 0. x meaning, that the work is still in progress. Since 2021, when Stellarium reached the version of 1.0 we can enjoy pretty much the full functionality of this amazing astronomical application. One of the core features is the … Read more

Earth history in 1 year – happy new year 2024 to everyone!

2025-05-282023-12-31 by Krukarius

The tail end of the year is the time for some kind of a resume when we are going back in our memories and analyzing what was good and what was bad over the entire year. As a geography student I had to learn about the history of Earth, which at some point can be … Read more

PDF drawing – the fastest georeference with AutoCAD LT

2025-05-282023-12-22 by Krukarius

PDF documents are very popular. They can include various content from text through simple drawings to detailed maps of some areas. Storing drawings, plans, or maps in PDF files is very convenient because this format is platform-independent. It means, that any kind of map, plan, or sketch can be viewed, shared, and printed in various … Read more

Solar eclipse below the horizon – the observation guideline

2025-05-282023-11-23 by Krukarius

Solar eclipse below the horizon observation pattern

The 2024 total solar eclipse is coming. Anyone interested will be in North America. We cannot forget about the people, who live or will temporarily stay in Western Europe on the day when the event occurs. Therefore I decided to prepare the text, which presents the guideline for this specific kind of observation. The guideline … Read more

Transfer AutoCAD drawing to ArcGIS Online part III

2025-05-282023-10-12 by Krukarius

Transfer layer from AutoCAD to AGOL via QGIS

The last bit of this whole text covers the full guidance for the creation of the individual feature hosted layer, which can be used next for all available ArcGIS Online tools. In the last article, you’ve learned how to prepare your AutoCAD layer upon its further loading as the file to ArcGIS Online. In fact, … Read more

Transfer AutoCAD drawing to ArcGIS Online part II

2025-05-282023-10-02 by Krukarius

Transfer layer from AutoCAD to AGOL via QGIS 2

The previous post explained to you the simplest way of migrating the AutoCAD drawing to ArcGIS Online. It included the important bits like the AutoCAD layer extraction as well as its further import to QGIS. In fact, this is the section, that doesn’t change, so if you are not familiar with it jump to the … Read more