this post was submitted on 18 Jul 2024

140 points (98.6% liked)

Canvas

2097 readers

1 users here now

Canvas — The Fediverse’s r/place

2024 Concluded!

Get a print!

Check out the other items
mastodon.world, lemmy.world, blahaj.zone, toot.community, toast.ooo, canvas 2024 stickers also available!
Donate directly

Timelapses

founded 1 year ago

MODERATORS

[email protected]

140

Full Timelapse, Canvas Poster, Database Dump | Canvas 2024 (sc07.tv)

submitted 5 months ago* (last edited 5 months ago) by [email protected] to c/[email protected]

8 comments fedilink hide all child comments

Full Timelapse: PeerTube, YouTube, Raw File

Full Image: https://cdn.sc07.company/canvas/2024/finished.png

Canvas poster

🚨🚨🚨 You can now pre-order the posters!!

https://sc07.shop

These are pre-orders, the first orders will be shipped out August 1st following the shipping information listed on the site

Most countries are supported if yours is not listed, send me an email [email protected] or comment below 💜

Instance Stickers

Proceeds from instance stickers go to their respective instances 💞

Direct Donations

If you would like to directly donate to Canvas w/o making any purchases, I accept donations via Stripe 💜

(i wasn't clear on the stripe page that the fediverse handles would be public, so this is a placeholder until i get confirmation they all want it public or not)

Support

If you are having issues with the website, send an email to [email protected]

Database Dump

the old system for pixel placement logs was flawed, and someone suggested the brilliant idea of just publishing the database dump, it already has all the information anyway

no ip addresses, or ban logs only pixel placements (with username), pixel moderation logs and palette settings

https://cdn.sc07.company/canvas/2024/canvas-stripped.sql.txt

Canvas Repo - Canvas Timelapse Repo

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 6 points 5 months ago (2 children)

Is there a way to look up where are pixels that individual users put?

I consider buying it and putting pins or something in the few places where I left my mark.

[–] [email protected] 12 points 5 months ago (1 children)

There is no tools right now that allow that to happen

but the database dump is tagged in this post which would allow for people to make those tools 🙏

[–] [email protected] 4 points 5 months ago* (last edited 5 months ago) (1 children)

I thought that it is stripped of user data only pixel placements.

Edit: looked at it now and with my ~50 pixels placed it is possible to find it without tools.

[–] [email protected] 6 points 5 months ago

Sorry, I phrased it badly 😅

There's no user table (from the server) but each pixel is tagged with whoever placed the pixel

I've edited my original post so it doesn't confuse more people

[–] the_real_monte 6 points 5 months ago (1 children)

I can help you out if there is something you are looking for. I have a script that I can run on my computer to generate an image of just one user's pixels, or a group of users. I have not gone through the new data yet, but should have something by the end of today.

[–] [email protected] 4 points 5 months ago

Thanks, DM of the few pixels I placed (mostly randomly- there is cool art I can help with fill, I am bored so I will extend the trans flag...) would be highly appreciated.

I would be surprised if there are more than 20 of my pixels on the final canvas.