ivanlonel

#Requires -Version 6.0
<#
.SYNOPSIS
    Downloads (or uses a local) QGIS MSI installer and creates a portable QGIS archive.

.DESCRIPTION
    Two modes of operation:

    -QgisVersion  (default)
        Queries https://download.osgeo.org/qgis/windows/ for the highest matching

ivanlonel

// ==UserScript==
// @name         Pokemon Zone Card Collection CSV Downloader
// @namespace    http://tampermonkey.net/
// @version      1.1
// @description  Download Pokemon card collection data as CSV from Pokemon Zone
// @author       Ivan Donisete Lonel
// @match        https://www.pokemon-zone.com/players/*/cards/
// @grant        none
// ==/UserScript==

ivanlonel

import sys
from pathlib import Path

from qgis.core import QgsApplication
from qgis.core.contextmanagers import qgisapp

with qgisapp(guienabled=False, sysexit=False):
    # Required before importing processing:
    sys.path.append(str(Path(QgsApplication.prefixPath()) / "python/plugins"))

ivanlonel

-- https://dbfiddle.uk/m-oWZnKN

-- This uses function pluscode_decode, implemented here:
-- https://github.com/google/open-location-code/blob/main/plpgsql/pluscode_functions.sql

CREATE OR REPLACE FUNCTION pluscode_grid(
	original_geometry geometry,
	pluscode_length integer
)
-- Given a geometry and a plus code length (2, 4, 6, 8, 10, 11, 12, 13, 14, or 15),

ivanlonel

-- Converts geohash (up to 12 characters) between text and bigint formats in Postgres

-- https://dbfiddle.uk/UzF6gQzu

-- The geohash length is stored in the 4 least significant bits,
-- so that the relative order of the resulting int8 is the same
-- as that of the the original text string:
--   gzzzzzzzzzzz < h < h0 < h00 < h01             < h1
--   -4           < 1 < 2  < 3   < 562949953421315 < 18014398509481986

ivanlonel

-- https://dbfiddle.uk/n5dn_Rbj

CREATE OR REPLACE FUNCTION geohash_grid(
	original_geometry geometry,
	geohash_precision integer
)
-- Given a geometry and a geohash length, returns a grid of all rectangles
-- represented by geohashes of that length that intersect the geometry.
	RETURNS TABLE (geohash text, geom geometry(polygon))
	LANGUAGE SQL

ivanlonel

# https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection

# requires pycryptodome lib (pip install pycryptodome)

import argparse
import contextlib
import os
import json
from Crypto.Cipher import AES

ivanlonel

// ==UserScript==
// @name         Preencher Acompanhamento das Atividades - PGD
// @namespace    http://tampermonkey.net/
// @version      0.2
// @description  Preenche automaticamente os campos "Status", "Início", "Fim" e "Tempo gasto para realizar a atividade" da página de acompanhamento das atividades do PGD
// @author       ChatGPT
// @match        http://w3.programagestao.sda.ibge.gov.br/SDA-ProgramaGestao/planoTrabalho.jsf
// @icon         https://www.google.com/s2/favicons?sz=64&domain=gov.br
// @grant        none
// ==/UserScript==

ivanlonel

Utilizando LabelImg para criar anotações de imagens no formato Darknet/YOLO

LabelImg é uma ferramenta de anotação de imagens desenvolvida em Python com interface gráfica baseada em Qt.

As anotações podem ser salvas em três diferentes formatos:

• PASCAL VOC
• Darknet/YOLO (a partir da versão 1.7.0)
• CreateML (a partir da versão 1.8.5)

ivanlonel

from __future__ import annotations
from typing import Any
from collections.abc import Iterable, Iterator
import difflib
import itertools

def longest_common_subsequence(seq1: Iterable[Any], seq2: Iterable[Any]) -> Iterator[Any]:
    a = list(seq1)
    b = list(seq2)
    lcs = (a[block.a:(block.a + block.size)] for block in difflib.SequenceMatcher(None, a, b).get_matching_blocks())