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):
And the image heās referring to ā the Region Overview:
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
Hereās the DEC overview. You can filter it by player, or just look at the top 500 by default.
ā ļø Warning: If you select "All", your browser might cry. Youāve been warned.
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.
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?
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:
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.
Thanks for sharing! - @azircon

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 :)
Thanks, thatās exactly my goal. Shifting gears next weekālittle cliffhanger there⦠stay tuned! š
@tipu curate
Upvoted š (Mana: 0/69) Liquid rewards.
So impressive, love the rankings I must say great work!
Thanks @revisesociology
Delegate Tokens and HP to Fallen Angels to earn weekly rewards!
Delegate | Join to the guild
Congratulations @beaker007! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)
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:
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.
Also, Az added another metric, LDE.
Any plans on adding this to your tool? :)
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!
Congratulations @beaker007! You received a personal badge!
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:
Wow
That says it allāwow! Every time I dive into the data, I get completely overwhelmed too. š
sir you are a legend and a genius
@basilmarples Thanks for the complimentāglad you're enjoying the updates! š
Itās a community-driven effort, so really, the genius is the community! š¤£
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.