2025

Scientific report of March 29, 2025 partial solar eclipse

2025-05-082025-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-02-182025-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

2024-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

2024-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-01-212024-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

2024-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

2024-12-082024-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!

2024-12-202023-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

2024-12-082023-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

2024-12-082023-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

2024-12-182023-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

2024-12-182023-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

Brief guidebook for loading PDF drawings in MS Visio

2024-12-182023-09-28 by Krukarius

This short article is dedicated to people, who use Microsoft Visio on a daily basis. The PDF format isn’t supported directly by MS Visio software, although we can get this drawing in place easily by using third-party tools. In fact, you will find quite a lot of handbooks online, which suggest using PDF-dedicated software like … Read more

Nikon D5300 the first impression

2025-01-242016-05-20 by Krukarius

I have been taking photos for 10 years. Exactly 10 years and 5 days ago my mother bought me my first camera Canon Powershot A540. I was very, very happy. I use to use that model for over 5 years till November 2011, when finally the camera was down after 84,5k shoots. Sounds impressive, however, … Read more

The transit of the Mercury on May 9, 2016

2025-01-242016-05-12 by Krukarius

Exactly 3 days ago (on 9th May 2016) Mercury crossed the entire face of the Sun. Everybody in Britain (and Poland as well) could observe the transit of the smallest planet in the Solar System. The 2016 transit was the first to be visible from Europe since 7th May 2003. I also remember the 1999 … Read more

Witam wszystkich! (Welcome everybody!)

2016-04-20 by Krukarius

Zdecydowałem dzielić się moimi oryginalnymi przemyśleniami z Wami. Jeśli jesteś zainteresowany przeglądnij poszczególne artykuły by dowiedzieć się więcej. I decided to share my original ideas with you! If you are interested check out the following articles to find more.