Michael B. Currie MichaelCurrie

Addendum: Legislative Pull Request

What follows are the specific text changes to Ontario statutes required to implement the proposals in https://michaelbcurrie.medium.com/a-modest-proposal-for-the-dead-88828530faa1.

An MPP would introduce these as a bill before the Legislative Assembly of Ontario. The responsible ministry is the Ministry of Public and Business Service Delivery.

Design principle: These amendments achieve their goals primarily by removing restrictive text and broadening existing powers, rather than adding new machinery. The net effect is a shorter statute with broader utility.

Net changes: −50 words net across both statutes. ~280 words added, ~330 words removed. The biggest single cut is repealing s.51.1 (the lost document reporting section nobody uses), which alone removes ~200 words.

Example of how to create dynamic map distance scales.

	#!/usr/bin/env python3
	"""
	Drop-in replacement for pandas.DataFrame methods for reading and writing to database:

	pandas.DataFrame.to_sql
	pandas.read_sql_table

	For some reason the current (Jan 2023) implementation in Pandas
	using sqlalchemy is really slow. These methods are ~300x faster.

	def the_song_lyrics():
	while True:
	yield "This is the song that doesn't end"
	yield "Yes it goes on and on my friends"
	yield "Some people started singing it, not knowing what it was"
	yield "And they'll continue singing it forever, just because"

	for lyric in the_song_lyrics():
	print(lyric)

	# A script showing how to back up a MediaWiki server hosted on a remote Debian machine
	# I run each line manually myself

	# SUMMARY: Basically there are five things you should extract from the mediawiki server:
	# 1. LocalSettings.php: Get this from /var/www/mediawiki/LocalSettings.php
	# 2. images.zip: A zip file of /var/www/mediawiki/images which contains all the image data
	# 3. dbdump20201011.sql: A single .sql file which is a dump of every table in the /var/www/ MySQL mediawiki database,
	# which you can create by running mysqldump
	# 4. pedia_full_dump.xml: The content, by running php /var/www/mediawiki/maintenance/dumpBackup.php --full > pedia_full_dump.xml
	# 5. mediawiki.zip: A zip file of /var/www/mediawiki entirely (just in case we have other media or config stuff we need)

	# Instructions for Windows developers working on the Fling Unity Visualization Tool

	# 1. Install the latest version of Unity
	# 2. (NOT NEEDED) Install "SmartMerge" for Unity by following https://docs.unity3d.com/Manual/SmartMerge.html
	# 3. Install GitHub Desktop
	# 4. Install git-lfs
	# 5. Get a GitHub developer account
	# 6. Get invitated and accept the invitation to the fling-asia GitHub organization
	# 7. Clone the fling-unity repository to your computer via the GitHub desktop app
	# 8. Open the program in Unity

	# Install git-lfs
	# (From https://github.com/git-lfs/git-lfs/wiki/Installation)
	sudo apt-get install software-properties-common
	sudo add-apt-repository ppa:git-core/ppa
	sudo apt-get update
	curl -s https://packagecloud.io/install/repositories/github/git-lfs/script.deb.sh \| sudo bash
	sudo apt-get install git-lfs
	git lfs install

	# Add git-lfs to an existing repo

	You can view WCON files at:

	movement.openworm.org/wconviewer

	But until the HTML5 fix is in, you have to upload and then download the file, which is awkward. Instead:

	1. Clone movement validation

	2. Start -> Run -> cmd -> navigate to C:\Users\Fling\Documents\GitHub\movement_cloud\webworm

	CREATE FUNCTION sandbox.MonthNormalizedYearDiff(@StartDate DATE, @EndDate DATE)
	RETURNS FLOAT
	AS
	BEGIN
	/*
	MONTH-NORMALIZED YEAR DIFF

	How many years are between 31 December 2015 and 31 January 2016, say? You could say
	31 days in January / 366 days in the year 2016. But notice how if I then try to
	"de-annualize" the resulting fraction, I can't multiply by 12, since 31/366 != 1/12.