- Home
- Skills
- Trading & Investing
- tochi satei kun
Works with the AI Agents you already use
tochi satei kun
Open-source white-box land valuation engine for Japan using hedonic regression and MLIT transaction data.
Free
tochi satei kun
Example session with this skill installed
Run a land valuation for a 150sqm lot in Setagaya, 8 mins from the station. I have the MLIT CSV and Setagaya GeoJSON ready in the project folder.
- Read your context and instructions
- Compiled the tochi satei kun
I have processed the land valuation for the specified property in Setagaya. The engine performed a hedonic regression on the provided MLIT transaction data and synchronized the results with the latest Official Land Price benchmarks.
Valuation Report Summary
| Item | Value |
|---|---|
| Subject Property | Setagaya-ku, 150.00 sqm, 8 min to Station |
| Valuation Price | ¥132,000,000 (¥880,000/sqm) |
| Price Range | ¥118,000,000 - ¥145,000,000 |
| Regression R² | 0.84 (High Reliability) |
| Data Points | 42 transactions analyzed |
The generated Excel workbook contains the full disclosure of beta coefficients for the 12 features analyzed, including station proximity (β=-0.042) and lot shape (β=0.15). The client-facing sheet has been formatted without technical jargon, suitable for direct presentation.
# Generated File Location:
# output/土地査定_世田谷区_20240520.xlsx
Next steps
- Review the Pro Sheet to verify the hedonic coefficients and p-values for local market fit.
- Check the
Comparison Table in the workbook to see the top 3 similar transactions used for individual factor adjustments.
3. Present the Client Sheet to the seller to justify the suggested listing price range.
Connects securely to your tools. The creator never sees your data.
About this skill
Pricing land in Japan is often a "black box" of hidden adjustments. This skill provides an open-source, white-box Automated Valuation Model (AVM) designed for real estate professionals. It transforms raw MLIT transaction data and Official Land Price GeoJSON files into professional, explainable appraisal reports.
What it does
- Statistical valuation calculates land prices using hedonic regression across 12 specific features including area, shape, and station proximity.
- Explainable logic discloses all beta coefficients, p-values, and standard errors, ensuring the valuation isn't just a number but a defensible calculation.
- Dual-sheet output generates a detailed "Pro" sheet for internal review and a simplified "Client" sheet compliant with industry standards.
- Comparable selection identifies top-weighted similar transactions and aligns them using weighted distance scores.
- Automated adjustment applies time corrections based on official land price trends and individual factor corrections for specific lot characteristics.
How it works
- The user provides a property profile and two required data files (MLIT CSV and Official Land Price GeoJSON).
- The skill executes
scripts/main.pyto run the full valuation pipeline, from data scoping to regression analysis. - The system generates a three-sheet Excel workbook (
.xlsx) containing the Pro, Client, and Supplemental Data sheets.
Frameworks & tools
Built with Python, utilizing statsmodels for OLS regression, openpyxl for Excel generation, and specialized scripts for geospatial data handling and MLIT parsing.
Why this beats prompting it yourself
Generic prompts cannot handle regression analysis of thousands of transaction records or calculate precise time-adjustments from GeoJSON files. This skill uses a hard-coded mathematical pipeline that ensures every yen of valuation is backed by a specific coefficient rather than an LLM guess.
Use cases
- Generating initial valuation reports for prospective sellers during the listing phase.
- Providing objective evidence for price negotiations based on historical transaction data.
- Comparing subject property values against official land price (Koji Chika) benchmarks.
- Creating white-labeled valuation documents for real estate agency clients.
Known limitations
Supports only vacant land and ownership rights in Japan. Buildings, apartments, and leasehold rights are excluded. Requires external CSV/GeoJSON data files as inputs.
How to use
Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scanned
Verified clean 13 days ago
- Free to download with an account