stelf

-- notes:
--	Use a CROSS JOIN when you need a simple Cartesian product without any dependency between the rows of the joined tables.
--	Use a CROSS JOIN LATERAL when the second table's rows depend on values from the first table's current row, allowing for 
--	   dynamic and row-specific computations during the join process. This is powerful for queries requiring a contextual 
--	   relationship between the data sets. Lateral means "to the side"
--

-- using CROSS JOIN and subquery

SELECT * FROM ( 

stelf

<xsl:stylesheet version="1.0"
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <!-- Template to process objectdefs and descend into module_name/objectdef/objectprop and match metaprops -->
    <xsl:template match="import | objectdefs | objectdefs/* | objectdefs/*/* | objectdefs/*/*/* ">
        <xsl:copy>
            <xsl:apply-templates select="*"/> 
        </xsl:copy>
    </xsl:template>

stelf

# geocoding a source CVS with google maps
# and then feed into a table in PostGIS
# 
# interestingly some parts of the code were created with ChatGPT4
# but the output, of course, had to be revised a little
# 
# license CC-Attribution
3

import csv

stelf

SELECT	distinct
	upper(CAST (keywords.str AS varchar2(32))) AS keyword,
	JP.pkey || '-' || JI.issuenum AS issuekey
FROM
	JIRAACTION jA
JOIN jiraissue JI ON
	JA.issueid = JI.id
JOIN project JP ON
	JI.project = JP.id
CROSS JOIN lateral

stelf

function Find-Files {
     [CmdletBinding()]
     param(
          [Parameter()] [string] $Glob,
          [Parameter()] [string] $Path = (Get-Location))

     if (-not ( $Path -match '^\w:' ) ) {
          $Path = (Get-Location).Path + '\' + $Path
     }

stelf

$comDoc = New-Object -Com 'HTMLFile'
# load the wiki content
$res = Invoke-WebRequest $webLocation
# create a webview
$comDoc.Write( [System.Text.Encoding]::Unicode.GetBytes($res.Content) )
# query DOM
$elems = $comDoc.querySelector('table.prettytable')
# unfortunately querySelectorAll fails for various reasons
# so we have to enumerate the items manually
$codes = $elems.childNodes().item(0).childNodes() `

stelf

-- listing only records that appear more than twice
-- in result which finds points within areas 
-- 
-- the partitioning allows us to figure the results
-- alongside corresponding dulplicate areas
-- 
-- the n.type may be skipped, is included as aexample

select * from (
  select 

stelf

jq -sc '.[] | .result."attendance-areas"[] | {
  type: "Feature",
  properties: {
    id: .id,
    grade: .grade | tostring,
    openEnrollment: .openEnrollment,
    name: .name, },
  geometry: .geometry, }' input/school-page-*.json > prepared/school.geojson

stelf

const saxpath = require('./lib/saxpath');
const fs      = require('fs');
const zlib    = require('zlib');
const sax     = require('sax');

const saxParser  = sax.createStream(true);
const deflate = zlib.createGunzip();
const fileStream = fs.createReadStream('../discogs_20211101_releases.xml.gz');
const streamer   = new saxpath.SaXPath(saxParser, '/releases/release');

stelf

#!/usr/local/bin/perl

use IO::Uncompress::Gunzip qw(gunzip $GunzipError);
use XML::XPath;

my $ifile = '/Users/user/Downloads/discogs_20211101_releases.xml.gz';
my $ioref = IO::Uncompress::Gunzip->new( $ifile )
    or die "gunzip failed: $GunzipError\n";

my $xp = XML::XPath->new(ioref => $ioref );