skills.rest
chuangkevin
chuangkevinCOMMUNITY
Explore all skills by this author →
GitHub

houseprice-community

Map HousePrice community and transaction records using join keys and tagging fields.

Updated Mar 16, 2026
Search Tags:#community#sql#joins#data-model#real-estate#houseprice#dealallcaselist
One-click install
npx skills add https://github.com/chuangkevin/project-bridge --skill houseprice-community
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: houseprice-community
Source: https://github.com/chuangkevin/project-bridge/tree/main/skill/houseprice/community/houseprice-community
Command: npx skills add https://github.com/chuangkevin/project-bridge --skill houseprice-community

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill clarifies and documents how HousePrice community records relate to transaction and build tables so engineers and analysts can reliably join, tag, and backfill community identifiers across成屋 (existing buildings) and 新建案 (new builds).

Core Features & Use Cases

  • Canonical mapping between Community, NewBuildGroup, CmpWebCaseNewBuild, NewBuildDealCaseList, DealAllCaseList, and HouseFun.BuBuilding with clear join keys and precedence rules.
  • Query patterns & examples for retrieving GroupId, CommunityId, and performing end-to-end joins from DealAllCaseList to WebCase via bridge tables.
  • Tagging & backfill procedures showing how to populate TagBuildingHeadID, TagBuildingHeadGroupId, TagBuildingHeadName and the GetPriceWithBuildOrNewBuild unified logic.
  • Use Case: Data engineering jobs reconciling real-estate transaction records to community master records for reporting, analytics, and UI linking.

Quick Start

Ask the skill to "Show SQL to resolve a DealAllCaseList row to its Community GroupId and Tag fields using BuildingID or CaseNo+DealKind".

Frequently Asked Questions about houseprice-community

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I join DealAllCaseList to community master records in SQL for real estate transactions?▼

To join DealAllCaseList to community records, use bridge tables and apply join keys like GroupId, BudFrom+BuildID, or CaseNo+DealKind to resolve cross-table relationships between transaction and build tables.

What is the correct join key to map HousePrice community records to NewBuildDealCaseList?▼

The correct join key to map HousePrice community records to NewBuildDealCaseList relies on GroupId, or CaseNo combined with DealKind, ensuring accurate cross-referencing between community and new build transaction tables.

How to backfill TagBuildingHeadID and TagBuildingHeadGroupId for existing buildings and new builds?▼

Backfill TagBuildingHeadID, TagBuildingHeadGroupId, and TagBuildingHeadName by applying the GetPriceWithBuildOrNewBuild unified logic to populate community identifiers across existing buildings and new builds.

Does querying real estate community mapping tables require NOLOCK conventions?▼

Yes, querying real estate community mapping tables requires read-only WITH(NOLOCK) conventions to prevent locking issues during ETL jobs, report generation, and database queries across Community and DealAllCaseList tables.

What's the best way to resolve a DealAllCaseList row to its Community GroupId using SQL?▼

The best way to resolve a DealAllCaseList row to its Community GroupId is by joining through bridge tables to CmpWebCaseNewBuild using BuildingID or CaseNo+DealKind as the primary lookup keys.

Can I link HouseFun.BuBuilding data to CmpWebCaseNewBuild for analytics reporting?▼

You can link HouseFun.BuBuilding data to CmpWebCaseNewBuild by using canonical mapping with BudFrom+BuildID join keys to reconcile real estate transaction records for reporting and UI linking.

Related Skills

Explore More Data & Analytics Skills→
anukkrit149anukkrit149

schema-exploration

List database tables and describe columns, keys, and relationships.

Community
Intermediate
flag3flag3
1

clickhouse-io

Design and optimize ClickHouse analytics workloads with table engines, partitioning, and materialized views.

Community
Intermediate
tilmon-engineeringtilmon-engineering
3

detect-foreign-keys

Detect and validate foreign key relationships across relational database tables.

Official
Intermediate
sunnypatneedisunnypatneedi
11

multi-source-data-conflation

Merge and reconcile records from multiple sources into unified master data.

Community
Advanced