Intelligence in action

What the data actually produced

Fifteen worked examples from a single extended analytical session across Westminster and London. Each sets out the question asked, the datasets used, the finding, and why it matters commercially: with the supporting detail behind expandable notes.

01Planning pipeline

Where a major estate's pipeline is actually stuck

The question

Which planning applications in Westminster over the last three months relate to a major institutional landowner, and how are they progressing?

Data used

Planning ApplicationsAuthority & area code lookup

The finding

A raw search returned 65 matches. Reading every proposal description individually removed unrelated hits: buildings with similar names, incidental wording: leaving 39 genuinely relevant records. Grouped into seven themes and cross-tabulated against decision status, the outcome was 22 approved, 17 pending and 0 refused. Every one of the four major redevelopment schemes was still undecided, while routine items cleared quickly and almost always favourably.

Why it matters

Approval rates alone would suggest a frictionless authority. The theme split shows the opposite: consent risk is concentrated entirely in the large, value-driving schemes, and programme assumptions should be built around that asymmetry rather than the headline rate.

39
Relevant records
22
Approved
17
Pending
0
Refused
Approved Pending
Advertising / display / decoration8
Facade repair / conservation8
Condition discharge6
Technical plant / equipment5
Internal refurbishment5
Landscaping / public realm3
Major redevelopment4

Caveat

The 65 to 39 reduction was manual and judgement-based; a name match in free text is a starting point, not a filter.
02Attribution discipline

Being on the estate's street is not being the applicant

The question

Do the applications found on a landowner's streets actually tell us the landowner is active?

Data used

Planning ApplicationsApplication documentsRegistered Titles

The finding

Across two separate estate searches: 39 records for one landowner and 30 for a comparator: only a small handful were directly attributable to the estate itself. The rest were filed by tenants, agents, individual leaseholders, building-specific companies and trusts. In the comparator search, just 1 of 30 raw hits could be confirmed as the estate itself, and that was a tree-pruning job. Confirmation came from three places only: an applicant field naming the estate outright, a cover letter inside the application documents that read 'on behalf of our client', and an applicant address matching the estate's known head office.

Why it matters

Any market-activity or competitor-tracking output built on address matching will systematically overstate a landowner's activity. Named evidence changes the conclusion, and title records settle it.

1 of 30
Confirmed as the estate itself
7
Geographic false positives excluded
20
Filed by leaseholders or building companies
03Ownership proof

Ownership proven from the register, not inferred

The question

Can we move from inference to conclusive proof of who owns a block?

Data used

Registered Titles (HM Land Registry)

The finding

A single title record returned the proprietor name outright, together with the registered proprietor address, tenure, area and registration date: a first-party, conclusive answer covering a Regent Street block and adjoining parcels, held leasehold over 4,225 square metres with the proprietor registered in May 2011.

Why it matters

This is the strongest evidence class available. Every other ownership signal in the wider data landscape: applicant names, agent names, addresses: is inferential by comparison. For approach strategy, joint venture structuring or assembly work, the register is the only defensible starting point.

208
Fields on the title record
4,225 m²
Registered area, example title

Caveat

Coverage is registered land only; unregistered holdings will not appear.
04Housing supply audit

26 records were only 23 real schemes

The question

How many genuine housing schemes and net new homes does the residential pipeline actually contain?

Data used

Planning Applications

The finding

Every retrieved record was classified by role: primary application, linked supporting consent, amendment, lawful development confirmation or other. Paired full and listed building consents on the same site, and lawful development confirmations of previously consented changes, were merged into single schemes. That reduced 26 active records to 23 unique schemes: 5 approved securing a net +1 home, 1 refused, and 16 pending carrying a potential but unsecured +60 homes, with 1 withdrawn scheme excluded.

Why it matters

Counting records rather than schemes would have inflated the pipeline. Distinguishing secured from unsecured supply is what makes the number usable in a delivery forecast or a land-supply argument.

26 → 23
Records to unique schemes
+1
Net homes secured
+60
Net homes pending, unsecured
05Label versus substance

A 'non-material amendment' that added 29 homes

The question

Do procedural application labels reliably describe the scale of what is being changed?

Data used

Planning Applications

The finding

An application filed under the administrative label 'non-material amendment' disclosed, in its text, a change from 560 to 589 consented homes: a net increase of 29 dwellings alongside a significant shift in unit mix, with fewer three-bed and more studio and one-bed units.

Why it matters

Screening a pipeline by application type would have discarded this record entirely. Material changes to consented quantum and mix routinely arrive under minor procedural labels, and any monitoring process that filters on type rather than reading content will miss them.

560 → 589
Consented homes
+29
Net dwellings, filed as minor
06Policy context

The same estate, three entirely different policy regimes

The question

What policy designations actually govern this landowner's holdings?

Data used

Local Plan Policy DesignationsAuthority & area code lookup

The finding

For the Regent Street and Piccadilly area, the confirmed designations were a West End retail and leisure special policy area, Central Activities Zone, Opportunity Area, key development site, town centre across five polygon fragments, special policy area across three fragments, strategic cultural area and archaeological priority area. St James's carried all of those plus a protected heritage vista. The estate's Regent's Park holdings were governed by an entirely different regime: Metropolitan Open Land, sites of importance for nature conservation and proposed district energy networks.

Why it matters

A single-portfolio policy assumption fails immediately. Retail intensification arguments that work on Regent Street have no purchase in Regent's Park, where the binding constraints are environmental and heritage-led.

Caveat

Every designation returned carried a single 22 February 2024 stamp: a frozen snapshot that does not reflect the authority's January 2026 plan review adoption.
07Data currency

Two dates that look identical and mean opposite things

The question

How current is this data really, and how far back does it go?

Data used

Planning ApplicationsPlanning Appeals

The finding

Sorting applications nationally by update stamp showed a nightly bulk refresh; sorting by receipt date showed the newest UK application received 4 September and ingested the next day: a genuine one-day lag. Appeals behaved differently: the top rows by update stamp were timestamped the night before the query, but their actual content dated back to 2000 and 2005, because the entire historic archive is re-crawled nightly. Re-run against the receipt date, appeals lodged the previous day appeared immediately.

Why it matters

An update stamp measures crawl time, not event time. Reporting 'most recently updated' as 'most recent' is the single easiest way to present twenty-year-old evidence as current: and it changed the answer more than once in this work.

~1 day
Application ingestion lag
1983
Earliest verified record
08Appeal precedent

A refusal overturned, and why it matters next time

The question

Is there a genuinely current appeal precedent in this location, found using the correct date field?

Data used

Planning Appeals (Planning Inspectorate)

The finding

Filtering appeals by address and receipt date from 2024 onwards returned 14 results, most of them same-named streets in other towns. One matched precisely: two externally illuminated advertisement boards of 5.5 by 9.3 metres on a scaffold building wrap. The authority had refused the advertisement consent; the appeal was allowed and the refusal overturned. Received 21 December 2025, decided 29 June 2026: 124 days.

Why it matters

This is directly usable precedent on a building already present in the same landowner's application list: a comparable refusal on large temporary advertising was overturned, and the decision timeline gives a realistic planning assumption for a similar route.

Allowed
Refusal overturned
124 days
Received to decided
14 → 1
Results to genuine match
09Consultation intelligence

43,582 objections on record: but not on the newest schemes

The question

Can we read what local amenity bodies and statutory consultees actually said?

Data used

Planning Comments & Consultation ResponsesPlanning Applications

The finding

On three major Regent Street applications, the named consultees were on record: a local amenity society, a neighbourhood forum, the national heritage body, amenity society groupings and a residents' society: but the comment text was blank on every recent entry. Tested at scale, the same four bodies returned 43,582 populated comments platform-wide, and one Westminster-specific society alone accounted for 2,452, including detailed objections citing named plan policies on scale and grain, local environmental impact, energy and net zero, alongside conditional non-objections.

Why it matters

The written record is rich enough to anticipate the exact policy grounds a scheme will face, and to identify which bodies object conditionally rather than outright. It is simply thinner on the newest applications, so consultation risk should be read from a body's history rather than from the live case.

43,582
Populated comments, four bodies
2,452
One local society alone
10Demographic profiling

One Output Area, and what it says about the occupier base

The question

What does the resident profile look like at the finest available geography?

Data used

Output Area Boundary LookupCensus Demographics & Socio-Economics

The finding

A location search identified a genuine West End Output Area, then eight metrics were pulled for it: 202 residents at 1,169.6 people per square kilometre, sharply skewed to ages 20 to 34 at around 40 per cent with very few over 65, 53.9 per cent single-person households, 68.5 per cent private rented overall with only 16.5 per cent owning outright, around 67 per cent in some form of employment, and mean net annual household income of approximately £51,100 within a modelled range of £42,900 to £60,900.

Why it matters

This is a young, single-person, private-rented, working population: an occupier base whose needs are compact units, service amenity and transport, not family housing. At Output Area scale that judgement can be made street by street rather than borough-wide.

53.9%
Single-person households
68.5%
Private rented
~40%
Aged 20–34
£51,100
Mean net household income

Caveat

This is one small Output Area inside a much larger and more varied ward, and it is a 2021 snapshot: no change over time can be shown.
11Movement comparison

Twice the footfall, half the dwell time

The question

How does the prime retail pitch compare with a boutique street?

Data used

Pedestrian Activity Estimates

The finding

The densest cells at three sampled points showed a peak of 14,146 pedestrians a day at the Oxford Circus end of Regent Street with a top-ten average of 7,432, against 5,649 peak at the Piccadilly Circus end, and 4,330 peak with a 3,535 average on a Belgravia boutique street. Dwell times inverted the ranking: the boutique street held pedestrians for up to roughly 1.8 hours in some cells, against far shorter stays on the busier pitch.

Why it matters

Volume and dwell describe different retail propositions. High-volume through-traffic supports convenience and flagship visibility; long dwell supports browsing and higher-consideration purchases. Rent and tenant-mix arguments should cite whichever measure matches the proposition.

14,146
Peak daily, prime pitch
4,330
Peak daily, boutique street
~1.8 hrs
Longest dwell, boutique cells
Prime pitch: north end14,146 /day
Top-ten cell average 7,432 · shortest dwell
Prime pitch: south end5,649 /day
Top-ten cell average 4,438
Boutique street, Belgravia4,330 /day
Top-ten cell average 3,535 · dwell up to ~1.8 hrs

Caveat

The dataset is entirely static with no date dimension, and is a directional indicator rather than an exact count. The lower Piccadilly Circus figure may reflect a sampling point slightly off the main frontage line.
12Value benchmarking

£79 to £132 per square foot on the same street

The question

What is a commercial unit on this street let for?

Data used

Business Rates & Rateable Values (VOA)

The finding

No dataset holds an actual signed lease figure, so rateable value was used as the closest available proxy: the official estimate of notional open-market annual rent. Three shop units on the same street returned £5,760,000 over 6,809.52 square metres (around £79 per square foot), £1,780,000 over 1,248 square metres (around £132), and £1,640,000 over 1,649.6 square metres (around £92).

Why it matters

A 67 per cent spread in implied value per square foot along one street is a usable benchmarking signal for reviews and acquisitions: provided it is presented as an official valuation, not evidence of an agreed rent.

~£79
Implied £/sq ft, largest unit
~£132
Implied £/sq ft, highest
3
Comparable units benchmarked
Largest unit: 6,809.52 m²79 /sq ft
Rateable value £5,760,000
Mid unit: 1,649.6 m²92 /sq ft
Rateable value £1,640,000
Smallest unit: 1,248 m²132 /sq ft
Rateable value £1,780,000

Caveat

Rateable value is a government valuation for tax purposes at a fixed antecedent date, not an agreed rent. Genuine signed-lease comparables sit in paid commercial services, not in public data.
13Infrastructure constraint

Zero headroom on the local substation

The question

Can an electrification or retrofit programme physically be connected here?

Data used

Substation Capacity & HeadroomEnergy Performance Certificates

The finding

The 11kV substation around 150 metres from the estate's main frontage shows demand headroom of 0 MVA: effectively no room for additional electrical demand: against generation headroom of 47.5 MW rated green. Alongside it, energy certificate records give asset-level retrofit exposure: one adjoining office of 3,257 square metres rated B with an efficiency score of 49, lodged April 2026.

Why it matters

A retrofit-first policy position and a zero-headroom substation are in direct tension. Capacity, not consent, may be the binding constraint on an electrification programme, and reinforcement lead times need to enter the programme now rather than at design stage.

0 MVA
Demand headroom
47.5 MW
Generation headroom
124
Fields per energy certificate
14Delivery risk

129 per cent: and a year that came within 0.6 points of the cliff edge

The question

How exposed is this authority on housing delivery?

Data used

Housing Delivery Test Results

The finding

The three-year record shows 648.6 homes delivered against 655.8 required in year one (98.9 per cent), 744.4 against 985.0 in year two (75.6 per cent), and 2,002.7 against 985.0 in year three (203.3 per cent): a three-year total of 3,395.8 against 2,625.8, or 129 per cent, with no policy consequence. The requirement itself rose from 656 to 985 partway through the window.

Why it matters

The headline pass conceals a year that sat 0.6 percentage points above the threshold that triggers the presumption in favour of sustainable development. Delivery here depends on a small number of large completions landing in a single monitoring year, so the authority's refusal position is more fragile than 129 per cent suggests.

129%
Three-year result
75.6%
Weakest single year
None
Policy consequence
Year 1: 98.9%648.6 homes
Required 655.8
Year 2: 75.6%744.4 homes
Required 985.0 · 0.6 points above the presumption threshold
Year 3: 203.3%2,002.7 homes
Required 985.0
15Transaction evidence

What a completed sale record actually gives you

The question

What does the residential transaction evidence contain, and what is missing?

Data used

Price Paid & Listing History

The finding

A recent record near Soho returned a leasehold two-bed, one-bath flat of 45 square metres built around 1900, sold for £483,000 on 31 March 2026, with an index-based current valuation of £484,421 alongside listing history, an energy certificate cross-link and linked planning history.

Why it matters

For residential benchmarking this is a complete evidence chain from asking price to completion to current valuation. The gap matters just as much: stock currently available, under offer or sold subject to contract never appears, so live market depth cannot be read here.

£483,000
Completed sale price
45 m²
Floor area
£484,421
Index-based current value

Caveat

Completed sales only. There is no rental or lettings data anywhere in the landscape.