This Week in Land: Azircon, Efficiency Ratios & Tech Stack Pains

This week has been... busy šŸ˜…

It all started with a message from @azircon (yep, he’s at it again):
image.png

And the image he’s referring to – the Region Overview:
image.png

Honestly, this is one of my most used views. Maybe because I built it and I know how to read it, but for me it’s the best way to get a full picture of how and what your land is producing.

That said... it’s still just a lot of data šŸ˜…
I have explained every button, toggle, and table in older posts—but let’s be real, I can't expect everyone to go digging through old writeups. The site needs to be more self-explanatory and easier to use. So yeah, another thing on the to-do list: add feature descriptions. Not gonna lie, it’s not my highest priority... but it’s on the list!

Want to check it out immediately : https://splinter-lands.streamlit.app/

šŸ™Œ How You Can Support

If you like this tool, here are a few free ways to help:

  • āœ… Upvote this post — keeps the motivation high!
  • šŸ—³ļø Vote for my validator — helps fund future dev time
    šŸ‘‰ Vote for My SPS Validator Node

Simple Things That Make You Laugh

Sometimes you gotta hand it to Azircon - something simple he asks. Land is not simple, after his comment on my post, we had a nice talk on discord on which data he would like to see.

He made a post trying to keep land data simple, and it cracked me up because the more I dig into land, the more I realize how not simple it is and will become šŸ˜…

Right now, it’s fairly straightforward: limited resources and limited things to spend them on. But when 2.0 lands... it’s going to get a whole lot messier.
Small disclaimer: I’m not sure if I’ll be able to fit everything into this tool yet, but I’ll try. Future-me problem.

New Metrics: LPE & LCE

So after that message, Azircon and I got talking about DEC earnings and how to compare across accounts. I can already do this for one player... so for all players is possible. I’ve got the data—it "only" takes time šŸ˜… (for me to implement and the computer to compute).

Initial data setup wasn’t too bad, just a few hours of wrangling, and I could hand @azircon an initial dataset. What I didn’t expect was him immediately turning it into a full post:
šŸ‘‰ Land Efficiency Ratios by Azircon

He introduced two new metrics:

Land Plot Efficiency (LPE) = Total DEC Equivalent/hr / Active Plots
Land Card Efficiency (LCE) = Total PP Employed / Total DEC Equivalent/hr

That second one can be split into raw PP and boosted PP as well.
These are awesome for comparing performance across accounts, so I added both metrics to the tool and started working on graphs (inspire by @azircon posts). And while we are on the topic on ratios i expect that azircon will introduce a view more just love ratios 🤣.

It’s still early days—definitely feels like a "work in progress" release—but you can already check it out.

Where to Find the New Charts

image.png

Here’s the DEC overview. You can filter it by player, or just look at the top 500 by default.

image.png

āš ļø Warning: If you select "All", your browser might cry. You’ve been warned.

image.png

image.png

The last two charts are LCE and LPE. When you have a ton of data showing, use the search bar to zoom into your own account for a closer look.

image.png

There is my small dot 🤣

Bonus

With many of the charts I make, I also provide the raw data behind them. This is for anyone who wants to dive deeper or create their own visualizations.

Just a reminder: it’s all free data—so if you’re curious, go ahead and explore! I love seeing people get inspired and come up with their own views.

I know at least one person who’s already downloading it as a CSV and going wild with their own charts šŸ˜„
So why not give it a go yourself?

image.png

Tech Stack Thoughts: Streamlit Struggles

Let me be honest—this tool is slow. That’s mostly on Streamlit and Python, which are great for data crunching, not so much for frontend snappiness.

With more traction, comes more users... and more ā€œOh Noā€ screens (boo). I’ve mentioned before I’m planning to move to a new tech stack.

āœ… First step is done: data collection.

Next steps (don’t expect fireworks just yet, this is a slow build):

  • Build a small front-end that reads the stored data
  • Make it run locally easily (propably docker image)
  • Automate Deploy (make complete CI/CD automate deployments or image upload)
  • Start porting over the functionality from the Python version

In the short term, I’ll try to reduce the "Oh No" moments in the current app by switching to static tables from the new backend. That way, Streamlit just fetches already-processed data instead of crunching everything live. Let's see if that helps.

šŸ“ GitHub Repos

As always, these projects are open source, one build with python and streamlit. The new one build with Next.js + Prisma.

Check out the code here:
šŸ”— https://github.com/gamerbeaker007/splinter-lands
šŸ”— https://github.com/gamerbeaker007/splinter-lands-next

Suggestions and PRs welcome! Just be gentle—I’m not a TypeScript expert, so some of the code might hurt your eyes šŸ˜…

šŸ™Œ How You Can Support

If you like this tool, here are a few free ways to help:

  • āœ… Upvote this post — keeps the motivation high!
  • šŸ—³ļø Vote for my validator — helps fund future dev time
    šŸ‘‰ Vote for My SPS Validator Node

āš ļø Final Note

This is a hobby project I hack on in my spare time. If it crashes, glitches, or acts weird — don’t be surprised šŸ˜… Just reach out and I’ll look into it.

Here’s a little sneak peek of the data collector in action:
image.png

That’s all for now.
I’ll see you on the battlefield! šŸ§™ā€ā™‚ļøāš”ļø

Do you also want to be part of this amazing play to earn game consider using my referral link.



0
0
0.000
18 comments
avatar

The fact that you have been able to keep this tool free so far is a magic that I can’t explain with any plots :)

0
0
0.000
avatar

Thanks, that’s exactly my goal. Shifting gears next week—little cliffhanger there… stay tuned! šŸ˜‰

0
0
0.000
avatar

Congratulations @beaker007! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)

You received more than 11000 HP as payout for your posts, comments and curation.
Your next payout target is 12000 HP.
The unit is Hive Power equivalent because post and comment rewards can be split into HP and HBD

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out our last posts:

Be ready for the June edition of the Hive Power Up Month!
Hive Power Up Day - June 1st 2025
0
0
0.000
avatar

Any chance we can show the formulas for both LDE and LCE when looking at the charts? :) I keep switching from tab to tab to double check if I got the formulas correctly lol.

Land Plot Efficiency (LPE) = Total DEC Equivalent/hr / Active Plots
Land Card Efficiency (LCE) = Total PP Employed / Total DEC Equivalent/hr

Also, Az added another metric, LDE.

Land DEC Efficiency (LDE) = (total_dec_stake_in_use)/(DEC/hr*24)

Any plans on adding this to your tool? :)

0
0
0.000
avatar

Totally agree—I'll add the text directly along with the first LDE chart. šŸ™‚

There are still plenty of spots where I need to add more explanations šŸ˜….

Unfortunately, I can't push this to the main site just yet—I'm in the middle of a breaking change. More on that next week...

In the meantime, feel free to take a sneak peek here:
https://land.spl-stats.com/

Let me know if the descriptions are clear and if you spot anything that looks off!

0
0
0.000
avatar

Congratulations @beaker007! You received a personal badge!

You powered-up at least 10 HIVE on Hive Power Up Day!
Wait until the end of Power Up Day to find out the size of your Power-Bee.
May the Hive Power be with you!

You can view your badges on your board and compare yourself to others in the Ranking

Check out our last posts:

Hive Power Up Month Challenge - May 2025 Winners List
Be ready for the June edition of the Hive Power Up Month!
Hive Power Up Day - June 1st 2025
0
0
0.000
avatar

Wow

0
0
0.000
avatar

That says it all—wow! Every time I dive into the data, I get completely overwhelmed too. šŸ˜…

0
0
0.000
avatar

sir you are a legend and a genius

0
0
0.000
avatar
(Edited)

@basilmarples Thanks for the compliment—glad you're enjoying the updates! 😁
It’s a community-driven effort, so really, the genius is the community! 🤣

0
0
0.000
avatar

its just great to see someone putting such a lot of time in to some really cool tools.
come for the rewards. stay for the stats.

0
0
0.000