GIS site-selection case study for a dermatology and aesthetic medicine chain
Where should the next premium dermatology clinic open in Berlin?
An analysis of Berlin’s 542 planning areas points to three stations in Friedrichshain and Kreuzberg, where affluent demand is high and competition is thin.
Where is demand from affluent women aged 30–54 highest and least served, with a fast U-Bahn or S-Bahn connection?
A chain of dermatology and aesthetic medicine clinics is planning its first Berlin location and needs a shortlist it can take to property search. The client is fictional. The data, the method and the result are real.
Client
Dermatology and aesthetic medicine clinic chain expanding to Berlin
Target group
Women aged 30–54 with higher incomes
Unit of analysis
542 LOR Planungsräume, Berlin’s smallest official planning areas, about 7,000 residents each on average
Deliverable
Three recommended locations, tested against different weightings
Where the target group lives
≈ 720,700women aged 30–54 live in Berlin
They are not spread evenly. Density peaks in the inner city: the five densest Planungsräume, each with more than 8,000 women of this age per square kilometre, are all in Prenzlauer Berg and Friedrichshain.
Estimated as residents aged 30–54 multiplied by the share of women in each Planungsraum.
Where the income is
€4,030median gross monthly income in a typical Planungsraum, with a range of about €2,800 to €6,400
The highest earners live in the west, in Charlottenburg-Wilmersdorf and Steglitz-Zehlendorf, and in the centre, where new-build quarters such as Heidestraße and Gleisdreieck top the ranking.
Hatched areas: the statistics office suppresses income for small groups, so these values are estimated from the surrounding Bezirksregion.
Affluent demand
A dense but low-income area is a weak market. So is a wealthy villa district where few people live. The demand index multiplies normalised target density by normalised income, so a Planungsraum only scores well when both are high.
The result narrows the map to a handful of inner-city neighbourhoods. The strongest are Prenzlauer Berg (Senefelderstraße, Helmholtzplatz) and Friedrichshain (Samariterviertel, Boxhagener Platz).
Competition
114dermatology and aesthetic clinics and practices, 109 of them inside the city limits
Existing clinics cluster in the west and the centre. Charlottenburg-Wilmersdorf alone has 25. Friedrichshain-Kreuzberg has more women in the target group, but only 5 clinics.
Clinic locations from OpenStreetMap, checked by hand.
The market gap
The market gap index counts the affluent target group within 2 km of each Planungsraum and divides it by the number of clinics in the same radius, plus one.
The traditional west is saturated and all but disappears from the top of the ranking. The gap opens up east of the centre: Friedrichshain-Kreuzberg has more Planungsräume in the top fifth than any other district, followed by Neukölln and Lichtenberg.
Access
Car ownership in inner Berlin is low. Clients and staff will mostly arrive by public transport, so a clinic needs a U-Bahn or S-Bahn station within a short walk.
Access scores 1 when a station is within 500 m of the Planungsraum centre and falls to 0 at 1.5 km. 192 Planungsräume reach the full score.
Suitability
The final score weights the market gap at 70% and access at 30%.
The outlined areas are the robust result: Planungsräume that stay in the top 10% under every weighting tested. They form one continuous belt from Friedrichshain through Kreuzberg into northern Neukölln, plus a small pocket in Lichtenberg.
Robustness check
Weights are a judgement call, so the score was recalculated with two alternative weightings. Switch between them to see how little the top of the map moves.
Weights of the market gap and access in each variant
Variant
Market gap
Access
A, main
70%
30%
B, test
50%
50%
C, test
85%
15%
45Planungsräume stay in the top 10% whichever weights you choose
Premium filter
A high score is not yet a premium location. Candidate sites are U-Bahn and S-Bahn stations inside the stable areas or within 200 m of them.
Only stations in Planungsräume in Berlin’s top 40% by median income (€4,250 or more) go forward. That removes places where competition is low because purchasing power is low. Northern Neukölln holds the three highest scores in the whole analysis, yet every candidate station there, including those on the Ringbahn, drops out.
Spacing
Among the stations that pass, sites must be at least about 1 km apart so they do not compete for the same clients. The third slot goes to the strongest site south of the Spree, so the shortlist covers both Friedrichshain and Kreuzberg.
Shortlist: three recommended locations
Each site is a station with a premium catchment, few competitors and a stable score. The dashed circle on the map shows the 2 km radius used to count competing clinics.
1
Frankfurter Allee
Pettenkofer Straße, Friedrichshain
U5
S-Bahn Ring
Women 30–54
≈ 1,390
Density
≈ 4,320 / km²
Median income
€4,935
Clinics within 2 km
1
The highest score of any premium candidate, with a single competing clinic within 2 km. An interchange between the U5 and the Ringbahn, it widens the catchment well beyond its own neighbourhood.
A0.76
B0.83
C0.71
2
Frankfurter Tor
Forckenbeckplatz, Friedrichshain
U5
Women 30–54
≈ 1,690
Density
≈ 5,010 / km²
Median income
€4,639
Clinics within 2 km
2
The heart of affluent Friedrichshain, close to Boxhagener Platz, with the densest target group of the three sites. It sits 1.5 km west of site 1 on the same U5 line.
A0.61
B0.72
C0.52
3
Schönleinstraße
Graefekiez Nord, Kreuzberg
U8
Women 30–54
≈ 2,290
Density
≈ 3,870 / km²
Median income
€4,786
Clinics within 2 km
3
The strongest premium site south of the Spree, with the largest target group of the three. It gives the plan an independent second catchment in Kreuzberg, 3.3 km from the nearest Friedrichshain site.
A0.49
B0.64
C0.38
Methodology and sources
How the model works
Unit. 542 LOR Planungsräume (2021 boundaries, as of 2023) in ETRS89 / UTM 33N, analysed in ArcGIS Pro.
Target group. Residents aged 30–54 multiplied by the share of women in each Planungsraum. The source has no age-by-sex breakdown, so this is an estimate.
Income. Median gross monthly earnings of full-time employees subject to social insurance, by place of residence. 37 suppressed values were filled with the mean of the same Bezirksregion.
Demand. Normalised target density multiplied by normalised income.
Market gap. Affluent target group within 2 km divided by (clinics within 2 km + 1), measured from each Planungsraum centre.
Access. Distance from the Planungsraum centre to the nearest U-Bahn or S-Bahn station: 500 m or less scores 1, 1.5 km or more scores 0.
Score. Weighted sum of gap and access, tested with three sets of weights. Stable means top 10% in all three.
Shortlist. Stations in or within 200 m of the stable areas, a premium filter (median income of €4,250 or more) and a minimum spacing of about 1 km.
Limitations
The income figure leaves out the self-employed, civil servants and pensioners.
Clinic locations come from OpenStreetMap and were checked by hand, but some practices may be missing.
The analysis works at Planungsraum level. Individual premises, rents and footfall were not assessed.
Sources
Amt für Statistik Berlin-Brandenburg, Einwohnerregisterstatistik, 31 Dec 2024 (CC BY).
Amt für Statistik Berlin-Brandenburg, based on Statistik der Bundesagentur für Arbeit: median income by place of residence, 31 Dec 2023 (CC BY 3.0 DE).
Senatsverwaltung für Stadtentwicklung, Bauen und Wohnen: LOR Planungsräume boundaries.
OpenStreetMap contributors (ODbL): clinics and stations.