QGIS - jak provést hromadný update hodnot pomocí SQL dotazu

1. varianta - nástroj SQL v Processing 

Menu Zpracování - Sada nástrojů - najít "SQL pro spuštění v SpatiaLite" a spustit, tam zadat SQL dotaz:

 update 'semicon_companies' set city=town where city isnull and town is not nullupdate 'semicon_companies' set city=town where city isnull and town is not null

2. varianta - SQL dotaz přes Prohlížeč

Postup je vidět v tomto videu, je nutné mít otevřen panel Browser (Prohlížeč), v něm najít (klidně gpkg) vrstvu, rozkliknout ji, což ukáže jméno SQL tabulky, na ni kliknout pravým, vybrat "Spustit SQL":

a zadat SQL dotaz, např.:

Kdy se z AI stal buzzword?

Wikipedia označuje AI jako buzzword poprvé v anonymním příspěvku do článku "Buzzword" z 16.3.2020 - viz srovnání verzí:

https://en.wikipedia.org/w/index.php?title=Buzzword&diff=prev&oldid=945784721

Přičemž: 

• Bing Code Search plugin pro Visual Studio 2013 coby Microsoft Research project byl uvolněn v únoru 2014. Tento plugin poskytuje kvalitní odpovědi na dotazy formulované v přirozeném jazyce a využívá data z několika zdrojů, vč. MSDN a StackOverflow.
• GitHub Copilot byl spuštěn jako plugin v JetBrains marketplace 29.10.2021
• DALL·E byl spuštěn v lednu 2021 a DALL·E 2  6. dubna 2022. Midjourney 12. července 2022.
• ChatGPT bylo spuštěno 30.11.2022,  

Samsung debloater

1.  stáhnout a nainstalovat adb - je v balíčku SDK Platform Tools 
2. V seznamu https://gist.github.com/gsurrel/40cc506ac7e31134a87be4ba01a71103 vybrat balíčky, které nechci, např. Word, Excel, Powerpoint atd. 
3. Nebo instalit a spustit GUI program Universal Android Debloater - https://github.com/0x192/universal-android-debloater 

Jak zpracovat hromadu fotek nebo skenů knížek do prohledávatelného PDF

 Pro hromadné ořezání stránek PDF je super nástroj Briss:

https://sourceforge.net/projects/briss/

V OpenJDK 1.8 nějak nechtěl fungovat, ale v JDK17 to jede pěkně. Umí nařezat i vícesloupcové sazby, díky čemuž lze fotit i 2 stránky najednou. 

Ořezání v PDF je ale pouze "Crop", kde PDF obsahuje pořád originální obrázek bez ořezu. Pro OCR je potřeba obrázky z PDF dostat včetně správného ořezu, pro což jsem použil "Print to PNG" přes "PDF Creator".

V PNG jsem pak odstranil pozadí pomocí ImageMagick-u a pomocí OCR Tesseract jsem je převedl zpět do prohledávatelného PDF. Potřebné balíčky pro Windows MSYS2:

pacman -S mingw-w64-x86_64-imagemagick

pacman -S mingw-w64-x86_64-tesseract-ocr

pacman -S mingw-w64-x86_64-tesseract-data

(je potřeba vybrat balíček "ces", v případě potřeby jiných jazyků spustit vícekrát)

#!/bin/bash
dir="ocr"
for file in "$dir"/*.jpg; do

  /mingw64/bin/convert.exe $file -fuzz 35% -opaque White -rotate 90 -quality 60 $file.jpg

  /mingw64/bin/tesseract.exe $file $file -l ces PDF
echo "Done: "$file
done

 

Ubuntu kernel update

Nefunkční touchpad v Kubuntu 20.04 na notebooku Lenovo ThinkBook 14-IIL: 

Nejdřív jsem zkusil skript ubuntu-mainline-kernel.sh , který umožňuje nainstalovat jakýkoli kernel až po současné verze, s čímž může mít dnes již staré Ubuntu 20.04 problém.  

Tak jsem zkusil prostý upgrade kernelu na nejnovější LTS verzi pro 20.04, ovšem s HWE (HW enablement) drivery, takto:

apt-get install --install-recommends linux-generic-hwe-20.04

A hurá, jede to.

Android / Samsung: How to move data from SD card to a new bigger one

My 64GB SD card is filled up with images & videos, so i bought 256 MB and looked for tips how to move the data.

I inserted the old card into USB SD card reader, the new card into the laptom SD card slot.

The old card is E:\, the new is F:\   

First, I tried this:

E:\xcopy "*.*" F:\ /s /e /v /h

(reference: https://forums.tomsguide.com/threads/how-do-i-move-my-data-from-my-sd-card-to-a-new-one-on-my-samsung-galaxy-s-5.68262/)

 Unfortunatelly, the copying process died with some device error after about 50GB was transfered. This might happen because of the whacky SD card slot in my laptop, which does not hold the SD card firmly enough, so small movements of the laptop sometimes cause SD card disconnect.  

Then I tried the robocopy, which also prints nice statistics after finishing:

robocopy e:\ f:\ /s /e /r:0 /z

But I was not sure if the interrupted files were transfered correctly, so I decided to make checksums of all files on the SD card.

I used the MSYS2 environment with Linux command line as I already had it installed.

pacman -S rhash

pacman -S pv

rhash --md5 -p '%h;%p\n' -r /e |pv -ls 7049 > c/tmp/md5.txt

This creates TXT file, containing hash (%h) separated by ; and full path of the hashed file (%p).

The pv (pipe /progress viewer) is there for progress monitoring: -l is line mode, -s 7049 is the number of files I got from robocopy stats.    

Dulik surname origins, meanings and etymology

I did not find anything about the history/etymology of Dulik surname anywhere on the Internet. I have traced my ancestors with "Dulik" surname upto 17xx and they all lived around here (Vlachovice, Ujezd, Slavicin) +- 30 km.

So here is my take about our surname origins, meanings and etymology.

In Czech Republic (EU), the surname "Dulik" is usual written as "Dulík" or "Ďulík". 

The history of this name is unknown. It was already very common in 16xx when the registers of vital records ('matriky') were generally established.

The words 'Dulik/Dulík/Ďulík' do not have any meaning in czech language. The closest similar Czech word with some meaning is 'Dolík'/'Ďolík', which is a slang equivalent of 'důlek' (English: 'a dent on a surface', or 'a dimple in somebody's face').

As the Dulik word has no meaning in Czech (or any other slavic) languages, its origin might be foreign.

E.g., Duleek (/duːˈliːk/; Irish: Damhliag, meaning "stone house or church^[2]") is a small town in County Meath, Ireland. 

French surnames with similar pronunciation are: 'De Lix' (a record example from 1587),   'Delix' (example from 1571), 'Dalex' (1572) etc.

During the Austro-Hungarian empire period, the official language in Czechia was German and in some cases, the vital records registry books from that period transcribed "Ďulík" as "Diulik" (there is no 'Ď' in German language and 'Diu..' is the closest pronunciation-equivalent in German transcription).

Coincidentaly (?), (according to Google translator)  in Malay, Filipino, Sundanese and Samoa languages (and possibly other languages in this language group), word "diulik" means "studied" or "educated". In Indonesian language it means "licked"

In old Greek language, the word "δούλα" ("doula") means "servant-woman", see https://en.wikipedia.org/wiki/Doula#History_and_etymology

This link explains also that the modern meaning of "doula" (in Czech language: "Dula") for "a trained companion who supports another individual (the doula's client) through a significant health-related experience, such as childbirth, ..." was first used in a 1969 anthropological study conducted by Dana Raphael. 

So "dula"/"doula" as child-birth assitant is a very modern meaning = does not explain the Dulik surname origin.

Another similar word in Czech and Greek language is "tolik/τολικά", which means "Total(lly)"

All the information in this text was collected by me on June 23th 2021.