Commercial property and land (module commercial_market)
Script: scripts/modules/commercial_market.py (run from the project root after sales_market; a few seconds).
Source: Dubai Land Department (DLD) open data via data.dubai (Dubai Open Data Licence): the rent contracts (Ejari,
dataset 468586, staged in data/staging_rents.duckdb) and the transactions file (dataset 470061, staged in
data/staging.duckdb). Nothing else is used. Data run to 2026-11-05; the latest complete month is October 2026.
1. Commercial rents
Contracts counted. Ejari contract lines with usage Commercial or Industrial, exactly one property in the contract
(no_of_prop = 1), an annual rent of at least AED 1,000 and a valid date, and a duration of at least 6 months (the
short-term rule of rents_market.md). Each contract counts once: a second Ejari line of a one-property contract repeats
line 1, so only the lowest line_number of each contract_id is kept, as in rents_market.md (28 such lines in the
last 12 months). Types, from the Ejari property type:
| Type | Ejari property type |
|---|---|
| Office | Office (any sub type) |
| Shop | Shop, except kiosks |
| Showroom | Showroom |
| Warehouse | Warehouse, Warehouse complex |
Hotels, hotel apartments, kiosks, restaurants registered as their own type, labour camps and whole plots are not included. The month is the contract start month; the series start in January 2013.
Rent per sq ft = annual rent / Ejari area, computed only for contracts whose area and rate are plausible for the
type: office 100–50,000 sq ft and AED 10–1,500 per sq ft a year; shop 50–30,000 sq ft and AED 20–3,000; showroom
200–100,000 sq ft and AED 10–1,500; warehouse 300–500,000 sq ft and AED 3–500. Most office contracts carry no Ejari
area (about a third have one in 2026), so office rent per sq ft rests on that subset; contracts_with_area shows how many.
Many office contracts are small serviced or flexible offices registered for a trade licence, which is why the median
annual office rent (about AED 17,000 in 2026) is far below the rent of a typical office floor.
2. Commercial sales
DLD sales (transaction group Sales) of offices, shops and hotel apartments that pass the staging checks, with the sale
procedures of the price index (price_index.md: individual sales and development unit sales; lease registrations and
"Adding Land By Sell" are excluded) and a price per sq ft between AED 100 and 50,000. AED per sq ft uses the DLD
recorded unit area. Market: Ready = title deed, Off-plan = Oqood.
3. Land (plots)
DLD sales of property type Land with the same procedures and checks, a price per sq ft of plot between AED 5 and 50,000,
from January 2008. Houses that DLD registers as land inside villa projects are left out: those are house sales and are
counted in the residential statistics (sales_market.md, land_in_villa_project). Bulk plot registrations are left
out too (rule in sales_market.md, section (b)): the 1,350 Land records in 10 same-project, same-day batches, 523 of
them on 2 October 2026, register many plots of one project at once and are not market land sales (with them, October
2026 would show 574 "Other" plot sales instead of 51). What remains are plots. Usage groups
from the DLD usage of the record: Residential, Commercial, Mixed use (Multi-Use, Residential / Commercial), Industrial
(Industrial, Storage) and Other (including Other, Agricultural and blanks). Price per sq ft is per sq ft of plot
area; plots with the same area can carry very different permitted floor areas, so plot prices per sq ft are not
comparable with prices per sq ft of built space.
4. Statistics
- City monthly tables: count, value, median price (or median annual rent) and the median per sq ft of the month.
*_3mcolumns: the median per sq ft of the rolling 3-month window ending in the month, andyoy_3m_pct, its change against the window 12 months earlier. A change needs at least 20 records with a usable area in both windows.- Community tables: the last 12 complete months (November 2025 – October 2026 in this build) against the 12 months before, per community and type: count, median price or rent, the median per sq ft of both periods and its change (at least 20 records in both periods), the New-contract share (rents) or the off-plan share (sales).
- Community names come from the price-index resolver applied to the DLD area, master project, project and (sales only) building. Ejari records often have no master project, so many rental communities are DLD areas.
- Medians are not quality-adjusted: they move with the mix of what was let or sold. This is strongest for land, where a month's plots can sit in very different locations.
5. Published tables (data/out/commercial_market/, each as .parquet and .csv)
| File | Grain |
|---|---|
rents_city_monthly |
month x type x contract type (All, New, Renew) |
rents_community_latest |
community x type, last 12 months |
sales_city_monthly |
month x type x market (All, Ready, Off-plan) |
sales_community_latest |
community x type, last 12 months |
land_city_monthly |
month x usage group (All plus groups) |
land_community_latest |
community x usage group, last 12 months |
site/data/commercial_market.json holds the series from January 2017 and the community tables.
6. Suppression
Cells from fewer than 5 records have their count and statistics empty (suppressed = true); a median per sq ft needs at
least 5 records with a usable area. Only primary suppression is applied (00-publication-compliance.md, section 6). No
company, tenant or landlord names are published; project and building names are not published in these tables.