the_real_monte

{
	"id": 4096013452,
	"name": "Portal logo",
	"description": "One of the logos from the video game series Portal",
	"links": {
		"website": [
			"https://www.thinkwithportals.com/"
		],
		"discord": [
			"6xrkUa9f6w"
		],
		"subreddit": [
			"Portal"
		]
	},
	"path": {
		"0": [
			[
				512,
				206
			],
			[
				512,
				211
			],
			[
				512,
				211
			],
			[
				509,
				211
			],
			[
				509,
				212
			],
			[
				508,
				212
			],
			[
				508,
				213
			],
			[
				507,
				213
			],
			[
				507,
				214
			],
			[
				505,
				214
			],
			[
				505,
				215
			],
			[
				504,
				215
			],
			[
				504,
				216
			],
			[
				505,
				216
			],
			[
				505,
				215
			],
			[
				507,
				215
			],
			[
				507,
				214
			],
			[
				508,
				214
			],
			[
				508,
				213
			],
			[
				509,
				213
			],
			[
				510,
				213
			],
			[
				510,
				214
			],
			[
				511,
				214
			],
			[
				511,
				219
			],
			[
				510,
				219
			],
			[
				510,
				220
			],
			[
				509,
				220
			],
			[
				509,
				221
			],
			[
				508,
				221
			],
			[
				508,
				222
			],
			[
				507,
				222
			],
			[
				507,
				223
			],
			[
				506,
				223
			],
			[
				506,
				224
			],
			[
				504,
				224
			],
			[
				504,
				222
			],
			[
				503,
				222
			],
			[
				503,
				221
			],
			[
				502,
				221
			],
			[
				502,
				220
			],
			[
				501,
				220
			],
			[
				501,
				221
			],
			[
				502,
				221
			],
			[
				502,
				223
			],
			[
				503,
				223
			],
			[
				503,
				225
			],
			[
				504,
				225
			],
			[
				504,
				226
			],
			[
				505,
				226
			],
			[
				505,
				227
			],
			[
				506,
				227
			],
			[
				506,
				226
			],
			[
				507,
				226
			],
			[
				507,
				225
			],
			[
				508,
				225
			],
			[
				508,
				224
			],
			[
				510,
				224
			],
			[
				510,
				225
			],
			[
				511,
				225
			],
			[
				512,
				225
			],
			[
				512,
				231
			],
			[
				511,
				231
			],
			[
				511,
				232
			],
			[
				511,
				233
			],
			[
				510,
				233
			],
			[
				510,
				234
			],
			[
				509,
				234
			],
			[
				509,
				235
			],
			[
				510,
				235
			],
			[
				510,
				234
			],
			[
				511,
				234
			],
			[
				512,
				234
			],
			[
				512,
				237
			],
			[
				512,
				206
			],
			[
				514,
				206
			],
			[
				514,
				213
			],
			[
				515,
				213
			],
			[
				515,
				214
			],
			[
				516,
				214
			],
			[
				516,
				215
			],
			[
				518,
				215
			],
			[
				518,
				213
			],
			[
				517,
				213
			],
			[
				517,
				211
			],
			[
				518,
				211
			],
			[
				518,
				210
			],
			[
				520,
				210
			],
			[
				520,
				209
			],
			[
				521,
				209
			],
			[
				521,
				210
			],
			[
				522,
				210
			],
			[
				522,
				211
			],
			[
				523,
				211
			],
			[
				523,
				213
			],
			[
				522,
				213
			],
			[
				522,
				214
			],
			[
				521,
				214
			],
			[
				521,
				215
			],
			[
				519,
				215
			],
			[
				519,
				217
			],
			[
				520,
				217
			],
			[
				520,
				219
			],
			[
				521,
				219
			],
			[
				521,
				222
			],
			[
				522,
				222
			],
			[
				522,
				223
			],
			[
				523,
				223
			],
			[
				523,
				224
			],
			[
				524,
				224
			],
			[
				525,
				225
			],
			[
				525,
				226
			],
			[
				524,
				226
			],
			[
				524,
				225
			],
			[
				523,
				225
			],
			[
				523,
				224
			],
			[
				522,
				224
			],
			[
				522,
				223
			],
			[
				521,
				223
			],
			[
				521,
				222
			],
			[
				520,
				222
			],
			[
				520,
				219
			],
			[
				518,
				219
			],
			[
				518,
				220
			],
			[
				517,
				220
			],
			[
				517,
				221
			],
			[
				516,
				221
			],
			[
				516,
				222
			],
			[
				515,
				222
			],
			[
				515,
				226
			],
			[
				516,
				226
			],
			[
				516,
				228
			],
			[
				517,
				228
			],
			[
				517,
				229
			],
			[
				518,
				229
			],
			[
				518,
				232
			],
			[
				517,
				232
			],
			[
				517,
				233
			],
			[
				516,
				234
			],
			[
				515,
				234
			],
			[
				515,
				235
			],
			[
				514,
				235
			],
			[
				514,
				237
			],
			[
				514,
				206
			]
		]
	},
	"center": {
		"0": [
			516,
			217
		]
	}
}

{ "id": 9231069619, "name": "Aperture Science", "description": "The Aperture Science logo, the fictional company from the video game Portal where the game takes place.", "links": { "website": [ "https://www.thinkwithportals.com/", "https://theportalwiki.com/wiki/Aperture_Science" ], "discord": [ "6xrkUa9f6w" ], "subreddit": [ "Portal" ] }, "path": { "0": [ [ 302, 19 ], [ 302, 20 ], [ 301, 20 ], [ 300, 20 ], [ 300, 22 ], [ 299, 22 ], [ 299, 32 ], [ 300, 32 ], [ 300, 33 ], [ 301, 33 ], [ 301, 34 ], [ 302, 34 ], [ 302, 35 ], [ 313, 35 ], [ 313, 33 ], [ 314, 33 ], [ 314, 32 ], [ 343, 32 ], [ 343, 31 ], [ 344, 31 ], [ 344, 30 ], [ 345, 30 ], [ 345, 25 ], [ 344, 25 ], [ 344, 24 ], [ 343, 24 ], [ 343, 23 ], [ 315, 23 ], [ 315, 22 ], [ 314, 22 ], [ 314, 21 ], [ 313, 21 ], [ 313, 20 ], [ 312, 20 ], [ 312, 19 ] ] }, "center": { "0": [ 307, 27 ] } }

{
	"id": 2782394322,
	"name": "Factorio",
	"description": "The logo for the game Factorio",
	"links": {
		"lemmy": [
			"[[email protected]](/c/[email protected])"
		],
		"website": [
			"https://www.factorio.com/"
		],
		"discord": [
			"factorio"
		],
		"subreddit": [
			"factorio"
		]
	},
	"path": {
		"0": [
			[
				539,
				365
			],
			[
				540,
				365
			],
			[
				540,
				365
			],
			[
				540,
				366
			],
			[
				542,
				366
			],
			[
				542,
				367
			],
			[
				543,
				367
			],
			[
				543,
				366
			],
			[
				545,
				366
			],
			[
				545,
				365
			],
			[
				548,
				365
			],
			[
				548,
				366
			],
			[
				549,
				366
			],
			[
				550,
				366
			],
			[
				550,
				367
			],
			[
				553,
				367
			],
			[
				553,
				370
			],
			[
				558,
				370
			],
			[
				558,
				367
			],
			[
				562,
				367
			],
			[
				562,
				366
			],
			[
				566,
				366
			],
			[
				566,
				367
			],
			[
				567,
				367
			],
			[
				568,
				367
			],
			[
				568,
				368
			],
			[
				570,
				368
			],
			[
				570,
				367
			],
			[
				571,
				367
			],
			[
				571,
				366
			],
			[
				572,
				366
			],
			[
				572,
				363
			],
			[
				571,
				363
			],
			[
				571,
				361
			],
			[
				572,
				361
			],
			[
				572,
				359
			],
			[
				573,
				359
			],
			[
				573,
				358
			],
			[
				578,
				358
			],
			[
				578,
				356
			],
			[
				577,
				356
			],
			[
				577,
				354
			],
			[
				576,
				354
			],
			[
				576,
				352
			],
			[
				575,
				352
			],
			[
				575,
				351
			],
			[
				571,
				351
			],
			[
				571,
				349
			],
			[
				572,
				349
			],
			[
				572,
				348
			],
			[
				574,
				348
			],
			[
				574,
				347
			],
			[
				573,
				347
			],
			[
				573,
				346
			],
			[
				572,
				346
			],
			[
				572,
				344
			],
			[
				571,
				344
			],
			[
				571,
				343
			],
			[
				570,
				343
			],
			[
				570,
				342
			],
			[
				569,
				342
			],
			[
				569,
				343
			],
			[
				568,
				343
			],
			[
				568,
				344
			],
			[
				564,
				344
			],
			[
				564,
				343
			],
			[
				562,
				343
			],
			[
				562,
				342
			],
			[
				560,
				342
			],
			[
				560,
				339
			],
			[
				556,
				339
			],
			[
				556,
				341
			],
			[
				555,
				341
			],
			[
				555,
				342
			],
			[
				552,
				342
			],
			[
				552,
				343
			],
			[
				548,
				343
			],
			[
				548,
				342
			],
			[
				546,
				342
			],
			[
				546,
				341
			],
			[
				545,
				341
			],
			[
				545,
				342
			],
			[
				544,
				342
			],
			[
				544,
				343
			],
			[
				543,
				343
			],
			[
				543,
				344
			],
			[
				542,
				344
			],
			[
				542,
				346
			],
			[
				543,
				348
			],
			[
				543,
				349
			],
			[
				541,
				349
			],
			[
				541,
				350
			],
			[
				538,
				350
			],
			[
				538,
				351
			],
			[
				537,
				351
			],
			[
				537,
				353
			],
			[
				536,
				353
			],
			[
				536,
				356
			],
			[
				539,
				356
			],
			[
				541,
				358
			],
			[
				541,
				362
			],
			[
				540,
				362
			]
		]
	},
	"center": {
		"0": [
			557,
			355
		]
	}
}

{
	"id": 2337463645,
	"name": "Loss Meme",
	"description": "From Know Your Meme: \nLoss, also known as CADbortion, Loss.jpg and | || || |_, refers to an iconic cartoon strip from the video game-themed webcomic series Ctrl+Alt+Del in which the female lead suffers a miscarriage. The dramatic tonal shift for the series was unexpected, and for many readers, unsuccessful, leading to the strip being widely mocked online. In the decade since its release, it became the subject of widespread mockery among its readers, and has since been widely parodied in minimalist interpretations of the strip's four panels, represented as \"| || || |_\".",
	"links": {
		"website": [
			"https://knowyourmeme.com/memes/loss",
			"https://cad-comic.com/"
		]
	},
	"path": {
		"0": [
			[
				524,
				93
			],
			[
				559,
				93
			],
			[
				560,
				74
			],
			[
				543,
				74
			],
			[
				542,
				79
			],
			[
				541,
				78
			],
			[
				538,
				74
			],
			[
				537,
				72
			],
			[
				538,
				71
			],
			[
				541,
				69
			],
			[
				542,
				66
			],
			[
				544,
				65
			],
			[
				544,
				57
			],
			[
				545,
				55
			],
			[
				542,
				51
			],
			[
				538,
				51
			],
			[
				536,
				53
			],
			[
				535,
				52
			],
			[
				533,
				49
			],
			[
				526,
				56
			],
			[
				526,
				60
			],
			[
				527,
				60
			],
			[
				526,
				61
			],
			[
				526,
				64
			],
			[
				528,
				66
			],
			[
				528,
				68
			],
			[
				527,
				68
			],
			[
				526,
				66
			],
			[
				523,
				66
			],
			[
				521,
				64
			],
			[
				518,
				61
			],
			[
				516,
				63
			],
			[
				518,
				65
			],
			[
				514,
				63
			],
			[
				512,
				64
			],
			[
				514,
				67
			],
			[
				511,
				67
			],
			[
				511,
				70
			],
			[
				515,
				71
			],
			[
				517,
				75
			],
			[
				521,
				75
			],
			[
				523,
				73
			],
			[
				521,
				77
			],
			[
				522,
				82
			],
			[
				525,
				83
			]
		]
	},
	"center": {
		"0": [
			550,
			84
		]
	}
}

{
	"id": 6775414639,
	"name": "Satisfactory",
	"description": "The check mark from the game Satisfactory",
	"links": {
		"lemmy": [
			"[[email protected]](/c/[email protected])"
		],
		"website": [
			"https://www.satisfactorygame.com/"
		],
		"discord": [
			"satisfactory"
		],
		"subreddit": [
			"SatisfactoryGame"
		]
	},
	"path": {
		"0": [
			[
				705,
				376
			],
			[
				705,
				377
			],
			[
				706,
				378
			],
			[
				707,
				379
			],
			[
				708,
				380
			],
			[
				709,
				381
			],
			[
				709,
				382
			],
			[
				710,
				383
			],
			[
				711,
				384
			],
			[
				712,
				385
			],
			[
				713,
				386
			],
			[
				714,
				387
			],
			[
				714,
				388
			],
			[
				715,
				389
			],
			[
				716,
				390
			],
			[
				717,
				391
			],
			[
				718,
				392
			],
			[
				719,
				393
			],
			[
				719,
				394
			],
			[
				720,
				395
			],
			[
				721,
				396
			],
			[
				722,
				397
			],
			[
				723,
				398
			],
			[
				724,
				397
			],
			[
				725,
				396
			],
			[
				726,
				395
			],
			[
				727,
				394
			],
			[
				728,
				393
			],
			[
				729,
				392
			],
			[
				730,
				391
			],
			[
				730,
				390
			],
			[
				731,
				389
			],
			[
				732,
				388
			],
			[
				733,
				387
			],
			[
				736,
				384
			],
			[
				737,
				383
			],
			[
				737,
				382
			],
			[
				738,
				381
			],
			[
				744,
				375
			],
			[
				744,
				374
			],
			[
				751,
				367
			],
			[
				751,
				366
			],
			[
				746,
				361
			],
			[
				745,
				361
			],
			[
				737,
				367
			],
			[
				735,
				367
			],
			[
				735,
				370
			],
			[
				734,
				369
			],
			[
				733,
				369
			],
			[
				732,
				368
			],
			[
				731,
				367
			],
			[
				731,
				365
			],
			[
				730,
				364
			],
			[
				730,
				363
			],
			[
				729,
				362
			],
			[
				728,
				361
			],
			[
				727,
				361
			],
			[
				726,
				360
			],
			[
				725,
				360
			],
			[
				724,
				359
			],
			[
				718,
				359
			],
			[
				717,
				360
			],
			[
				716,
				360
			],
			[
				715,
				361
			],
			[
				714,
				362
			],
			[
				713,
				363
			],
			[
				711,
				365
			],
			[
				711,
				371
			],
			[
				710,
				372
			],
			[
				710,
				376
			],
			[
				705,
				376
			]
		]
	},
	"center": {
		"0": [
			723,
			378
		]
	}
}

{
	"id": 5521865151,
	"name": "Canvas Logo",
	"description": "The Canvas logo",
	"links": {
		"lemmy": [
			"https://toast.ooo/c/canvas"
		],
		"matrix": [
			"#canvas:matrix.org"
		],
		"website": [
			"https://canvas.fediverse.events/"
		],
		"discord": [
			"mEUqXZw8kR"
		]
	},
	"path": {
		"0": [
			[
				750,
				412
			],
			[
				760,
				412
			],
			[
				760,
				422
			],
			[
				773,
				422
			],
			[
				773,
				435
			],
			[
				760,
				435
			],
			[
				760,
				423
			],
			[
				760,
				422
			],
			[
				750,
				422
			]
		]
	},
	"center": {
		"0": [
			766,
			428
		]
	}
}

{
	"id": 8847869539,
	"name": "Mastodon Logo",
	"description": "The logo for Mastodon",
	"links": {
		"website": [
			"https://joinmastodon.org/"
		]
	},
	"path": {
		"0": [
			[
				602,
				148
			],
			[
				603,
				148
			],
			[
				603,
				151
			],
			[
				604,
				151
			],
			[
				604,
				153
			],
			[
				605,
				153
			],
			[
				605,
				154
			],
			[
				606,
				154
			],
			[
				606,
				156
			],
			[
				607,
				156
			],
			[
				607,
				157
			],
			[
				608,
				157
			],
			[
				608,
				158
			],
			[
				609,
				158
			],
			[
				609,
				159
			],
			[
				610,
				159
			],
			[
				610,
				160
			],
			[
				611,
				160
			],
			[
				611,
				161
			],
			[
				612,
				161
			],
			[
				613,
				161
			],
			[
				613,
				162
			],
			[
				614,
				162
			],
			[
				615,
				162
			],
			[
				615,
				163
			],
			[
				616,
				163
			],
			[
				617,
				163
			],
			[
				617,
				164
			],
			[
				619,
				164
			],
			[
				620,
				164
			],
			[
				620,
				165
			],
			[
				637,
				165
			],
			[
				637,
				164
			],
			[
				642,
				164
			],
			[
				642,
				163
			],
			[
				643,
				163
			],
			[
				643,
				162
			],
			[
				644,
				162
			],
			[
				644,
				161
			],
			[
				645,
				161
			],
			[
				645,
				156
			],
			[
				644,
				156
			],
			[
				644,
				155
			],
			[
				639,
				155
			],
			[
				639,
				156
			],
			[
				625,
				156
			],
			[
				625,
				155
			],
			[
				623,
				155
			],
			[
				623,
				154
			],
			[
				622,
				154
			],
			[
				622,
				152
			],
			[
				621,
				153
			],
			[
				621,
				150
			],
			[
				631,
				150
			],
			[
				632,
				150
			],
			[
				642,
				151
			],
			[
				642,
				150
			],
			[
				651,
				150
			],
			[
				651,
				149
			],
			[
				653,
				149
			],
			[
				653,
				148
			],
			[
				655,
				148
			],
			[
				655,
				147
			],
			[
				656,
				147
			],
			[
				656,
				146
			],
			[
				657,
				146
			],
			[
				657,
				145
			],
			[
				658,
				145
			],
			[
				658,
				144
			],
			[
				659,
				144
			],
			[
				659,
				143
			],
			[
				660,
				143
			],
			[
				660,
				142
			],
			[
				661,
				142
			],
			[
				661,
				140
			],
			[
				662,
				140
			],
			[
				662,
				138
			],
			[
				663,
				138
			],
			[
				663,
				114
			],
			[
				662,
				114
			],
			[
				662,
				111
			],
			[
				661,
				111
			],
			[
				661,
				107
			],
			[
				660,
				107
			],
			[
				660,
				106
			],
			[
				659,
				106
			],
			[
				659,
				105
			],
			[
				658,
				105
			],
			[
				658,
				104
			],
			[
				657,
				104
			],
			[
				657,
				103
			],
			[
				656,
				103
			],
			[
				656,
				102
			],
			[
				655,
				102
			],
			[
				655,
				101
			],
			[
				654,
				101
			],
			[
				653,
				101
			],
			[
				653,
				100
			],
			[
				652,
				100
			],
			[
				651,
				100
			],
			[
				651,
				99
			],
			[
				613,
				99
			],
			[
				613,
				100
			],
			[
				611,
				100
			],
			[
				611,
				101
			],
			[
				609,
				101
			],
			[
				609,
				102
			],
			[
				608,
				102
			],
			[
				601,
				106
			]
		]
	},
	"center": {
		"0": [
			637,
			125
		]
	}
}

{
	"id": 6173006958,
	"name": "Android Bugdroid",
	"description": "The Android mascot",
	"links": {
		"lemmy": [
			"[[email protected]](/c/[email protected])"
		],
		"website": [
			"https://www.android.com/"
		],
		"subreddit": [
			"Android"
		]
	},
	"path": {
		"0": [
			[
				9,
				124
			],
			[
				12,
				127
			],
			[
				12,
				127
			],
			[
				14,
				125
			],
			[
				20,
				125
			],
			[
				22,
				127
			],
			[
				25,
				124
			],
			[
				22,
				128
			],
			[
				25,
				128
			],
			[
				25,
				129
			],
			[
				26,
				131
			],
			[
				26,
				133
			],
			[
				26,
				135
			],
			[
				26,
				138
			],
			[
				26,
				139
			],
			[
				27,
				139
			],
			[
				28,
				139
			],
			[
				29,
				136
			],
			[
				30,
				135
			],
			[
				31,
				135
			],
			[
				32,
				136
			],
			[
				32,
				148
			],
			[
				31,
				149
			],
			[
				30,
				149
			],
			[
				29,
				148
			],
			[
				29,
				142
			],
			[
				26,
				142
			],
			[
				26,
				150
			],
			[
				25,
				152
			],
			[
				23,
				152
			],
			[
				22,
				155
			],
			[
				19,
				155
			],
			[
				19,
				152
			],
			[
				15,
				152
			],
			[
				15,
				155
			],
			[
				12,
				155
			],
			[
				12,
				152
			],
			[
				9,
				152
			],
			[
				9,
				151
			],
			[
				8,
				150
			],
			[
				8,
				142
			],
			[
				5,
				142
			],
			[
				5,
				148
			],
			[
				4,
				149
			],
			[
				3,
				149
			],
			[
				2,
				148
			],
			[
				2,
				136
			],
			[
				3,
				135
			],
			[
				4,
				135
			],
			[
				5,
				136
			],
			[
				5,
				141
			],
			[
				8,
				141
			],
			[
				8,
				131
			],
			[
				9,
				128
			],
			[
				12,
				128
			]
		]
	},
	"center": {
		"0": [
			17,
			140
		]
	}
}

{
	"id": 505497885,
	"name": "502 Bad Gateway",
	"description": "Whenever the server crashed during the event, the site would simply display the \"502 Bad Gateway\" error message",
	"links": {},
	"path": {
		"0": [
			[
				505,
				0
			],
			[
				505,
				22
			],
			[
				621,
				22
			],
			[
				621,
				0
			]
		]
	},
	"center": {
		"0": [
			563,
			11
		]
	}
}

{ "id": 4949019230, "name": "Block O", "description": "The logo for The Ohio State University", "links": { "subreddit": [ "OSU" ] }, "path": { "0": [ [ 907, 451 ], [ 903, 455 ], [ 903, 459 ], [ 908, 464 ], [ 912, 460 ], [ 912, 455 ], [ 908, 451 ] ] }, "center": { "0": [ 908, 457 ] } }

There was an error with the fediverse-auth on the Canvas site where after a certain point new logins started being logged as all lower case which created duplicates of 59 users and were treated as separate users. I have merged all of the duplicate accounts and rebuild the database.

This also means that all of the stats on Canvas Stats are incorrect. The canvas Stats app has been updated with the new data.

You can find the fixed database dump sql file on my github: https://raw.githubusercontent.com/TheRealMonte/data-files/main/2024/canvas-2024-fixed-sql.sql The file is 33,568 kB.

The SQL file has 4 tables:

• users (user_id, username, ranking, total_pixels_placed)
• colors (color_id, color_name, color_hex)
• pixels (log_id, user_id, x_cord, y_cord, color_id, time_placed, is_mod_action, is_top, time_deleted)
• top_cord (top_cord_id, user_id, x_cord, y_cord, count_placed)

The users table includes the rank and total pixels placed for each user. Deleted pixels are not counted. There are 13 users who deleted every pixel the placed. They are still ranked, but their total pixel count is 0.

The colors table includes the color ID, name, and hex which when joined with the pixels table can be used to easly select the color name or hex.

The pixels table includes the username, x and y coordinates, color ID, the time the pixel was placed, if the pixel was a moderator placement, if the pixel can be seen in the final image, and the time the pixel was deleted or NULL.

The top_cord table includes the x and y coordiantes for the coordinate each user placed the most pixels on along with the count.

The only data not included here is the pixel color counts for each user. You an find the pixel color counts for a user by selecting:

SELECT color_name, count(color_name) FROM public.pixels JOIN users on users.user_id = pixels.user_id JOIN colors on colors.color_id = pixels.color_id WHERE username = <username> GROUP BY color_name

Another update to Canvas Stats app. You can now view your pixels you placed during the event in your browser and download the pixels as a png image!