lts_by_city
Rank cities by LTS count with province, region, law breakdown, active/expired/unknown split (unknown = no expiry date on record, not lapsed), and top developer per city. Groups by city+province to avoid merging same-name cities across provinces. Use for housing pressure indices, city-level market analysis, and identifying emerging development hotspots. Cross-reference with PSGC MCP for city classification and population. Capped at 25k rows; check truncated flag and narrow filters if true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| law | No | Filter by housing law: BP220 (socialized/economic) or PD957 (open market) | |
| year | No | Filter by LTS issue year | |
| limit | No | Max cities to return, sorted by count desc | |
| region | No | Filter to a specific DHSUD region |