Study guide
7.4 Geospatial Analysis: Intellisite, Drive-Time Trade Areas & Retail Gap Modeling
Certified Commercial Investment Member CCIM
Track your progress as you read
Finished sections get a check mark.
1 Getting Started: The CCIM Designation & Comprehensive Exam
About the CCIM Comprehensive Exam
2 Chapter 1: Time Value of Money & Cash Flow Modeling
1.1 Core Time Value of Money Principles & Compounding Dynamics 1.2 Annuity Mechanics, Sinking Funds & Loan Amortization Mathematics 1.3 The CCIM Cash Flow Model: From Gross Potential Income to BTCF
3 Chapter 2: Debt Financing, Cash-on-Cash Return & Direct Capitalization
2.1 Debt Financing Metrics: DCR, LTV & Maximum Loan Sizing 2.2 Cash-on-Cash Return & First-Year Equity Dividend Rates 2.3 Direct Capitalization & Capitalization Rate Derivation
4 Chapter 3: Advanced Capitalization & Mortgage-Equity Valuation
3.1 Band of Investment Technique (Debt & Equity Components) 3.2 Mortgage-Equity Analysis & The Ellwood Formulation 3.3 Discounted Cash Flow (DCF) Modeling & Net Present Value (NPV)
5 Chapter 4: Yield Metrics & After-Tax Investment Analysis
4.1 Internal Rate of Return (IRR) Mechanics, Limitations & MIRR 4.2 Commercial Real Estate Tax Fundamentals & MACRS Cost Recovery 4.3 After-Tax Cash Flow (ATCF) & After-Tax Equity Reversion (ATER) 4.4 Capital Accumulation & the Annual Growth Rate of Capital (AGRC)
6 Chapter 5: Market Fundamentals & Economic Base Analysis
5.1 The CCIM Strategic Analysis Model & Market Delineation 5.2 Economic Base Theory: Basic vs. Non-Basic Employment Dynamics 5.3 Location Quotient (LQ) & Economic Base Multipliers
7 Chapter 6: Supply, Demand & Trade Area Dynamics
6.1 Supply Analysis: Inventory, Pipeline & Competitor Benchmarking 6.2 Demand Modeling, Absorption Metrics & Market Slack 6.3 Trade Area Delineation: Primary, Secondary & Tertiary Zones
8 Chapter 7: Demographics, Site Evaluation, Regulatory Due Diligence & Geospatial Analysis
7.1 Psychographic & Demographic Profiling with Esri Tapestry Segmentation 7.2 Physical Site Evaluation, Ingress/Egress & Accessibility 7.3 Zoning, Land-Use Entitlements & Environmental Screening 7.4 Geospatial Analysis: Intellisite, Drive-Time Trade Areas & Retail Gap Modeling
9 Chapter 8: Commercial Sector Market Analysis: Office, Industrial, Retail & Multifamily
8.1 Office Sector Dynamics: Space Utilization, Classes & Submarket Drivers 8.2 Industrial & Logistics Facilities: E-Commerce, Clear Heights & Intermodal Hubs 8.3 Retail Trade Analysis: Reilly's Law, Huff Gravity Model & Sales Thresholds 8.4 Multifamily Analytics: Demographics, Household Formation & Concession Impact
10 Chapter 9: User Foundations, Space Measurement & Commercial Lease Types
9.1 The User Perspective vs. The Investor Perspective 9.2 Space Measurement Standards: BOMA Usable vs. Rentable Area & Load Factors 9.3 Commercial Lease Types: Gross, Modified Gross, Single, Double & Triple Net
11 Chapter 10: Expense Allocations, Percentage Rent & Comparative Lease Analysis
10.1 Expense Stops, Base Year Adjustments & Operating Expense Escalations 10.2 Retail Percentage Rent, Natural & Unnatural Breakpoints 10.3 Comparative Lease Analysis: Effective Rent & Net Present Cost Modeling
12 Chapter 11: Lease vs. Purchase Analysis & Sale-Leaseback Transactions
11.1 Cost of Capital & Appropriate Discount Rates for User Decisions 11.2 Structuring the Lease vs. Purchase Decision Framework 11.3 Sale-Leaseback Mechanics, Underwriting & Capital Optimization
13 Chapter 12: Lease Buyouts, Accounting Standards (ASC 842) & Interest-Based Negotiations
12.1 Early Lease Buyout Valuation & Surrender Premium Formulas 12.2 Corporate Lease Accounting (ASC 842 / IFRS 16) & Balance Sheet Impact 12.3 Interest-Based Negotiations in Commercial Leasing
14 Chapter 13: The Investment Lifecycle, Annual Review & Capital Decisions
13.1 The Real Estate Investment Lifecycle & Holding Period Optimization 13.2 Annual Property Performance Auditing & Variance Analysis 13.3 Refinancing Decisions & Capital Extraction Analysis
15 Chapter 14: Renovations, Disposition Timing & Leverage Dynamics
14.1 Value-Add Renovation Underwriting & Incremental Yield 14.2 Optimal Disposition Timing & Marginal Rate of Return (MRR) Analysis 14.3 Leverage Dynamics: Positive, Neutral & Negative Leverage
16 Chapter 15: Risk Quantification, Sensitivity Analysis & 1031 Exchange Fundamentals
15.1 Risk Analysis Frameworks: Sensitivity, Scenario & Monte Carlo Modeling 15.2 IRC Section 1031 Tax-Deferred Exchange Rules, Deadlines & Boot 15.3 Advanced 1031 Structures: Reverse, Construction & Delaware Statutory Trusts
17 Chapter 16: Syndication Waterfalls, Portfolio Strategy & Investment Committee Due Diligence
16.1 Real Estate Syndication, Promote Structures & Waterfall Distributions 16.2 Modern Portfolio Theory (MPT) & Diversification in Commercial Real Estate 16.3 Investment Committee Due Diligence, Underwriting Packages & Synthesis
7.4 Geospatial Analysis: Intellisite, Drive-Time Trade Areas & Retail Gap Modeling
Key Takeaways Explain This Topic AI
CI 102 requires candidates to perform geospatial analysis; The CCIM Institute delivers demographic, traffic, business-density, and consumer-spending mapping through Intellisite, the successor to the Site To Do Business (STDB) platform.
Drive-time and drive-distance polygons reflect the actual road network, barriers, and congestion a customer faces, whereas concentric radius rings assume travel is equally easy in all directions and systematically misstate trade areas.
Retail gap analysis compares trade-area consumer demand against sales supplied by businesses inside the area; demand above supply is leakage (unmet demand exported elsewhere) and supply above demand is surplus (the area imports customers).
The Leakage/Surplus Factor is computed as (Demand - Supply) / (Demand + Supply) x 100, producing a scale from -100 (total surplus) to +100 (total leakage) that is comparable across trade areas of different sizes.
Leakage is a hypothesis, not a conclusion: it must be reconciled against physical barriers, competitor pipeline, zoning capacity, and site accessibility before it is converted into supportable square footage.
Last updated: September 2026
7.4 Geospatial Analysis: Intellisite, Drive-Time Trade Areas & Retail Gap Modeling
Note
A published CI 102 objective. The CCIM Institute states that by the end of CI 102 you will be able to perform state-of-the-art geospatial analyses and to use Intellisite to map demographics, traffic, business density, and consumer spending — and turn that data into a market call . Sections 7.1 through 7.3 supplied the concepts: psychographic segmentation, physical site evaluation, and regulatory screening. This section supplies the tooling and the geometry that turn those concepts into a defensible, data-backed recommendation.
The Institute's Geospatial Platform
The CCIM Institute delivers geospatial capability to members through Intellisite , which succeeded the long-running Site To Do Business (STDB) platform. Intellisite bundles Esri mapping and demographic data with commercial real estate workflows, and the CI 102 case studies are built to be worked inside it across all four major property types.
The underlying data engine is Esri Business Analyst — the same platform that produces Business Analyst Online (BAO) reports and Tapestry Segmentation , the household classification system covered in Section 7.1. Candidates should understand what the platform does , not merely which buttons it exposes, because the exam tests interpretation.
Capability What It Produces Underwriting Use
Demographic reporting Current-year estimates and five-year forecasts for population, households, income, age, education, and tenure Sizing demand, validating Tapestry segments, projecting absorption
Consumer spending & Market Potential Household expenditure by category and Spending Potential Index (SPI) benchmarked to 100 = national average Tenant merchandising mix, sales projections
Business and employee density Establishment counts, employees, and sales volume by NAICS code Competitor inventory, daytime population, economic base checks
Traffic counts Annual Average Daily Traffic (AADT) at counted road segments Site accessibility and visibility scoring (Section 7.2)
Retail MarketPlace Trade-area demand versus supply by retail category Retail gap, leakage/surplus, supportable GLA
Thematic and heat mapping Choropleth maps of any variable across block groups or tracts Locating income, density, or growth clusters visually
Map layers and overlays Parcel boundaries, aerials, zoning, flood zones, transit Physical and regulatory due diligence
Trade Area Geometry: Rings Versus Drive Times
This is the single highest-value geospatial concept on the exam, and it connects directly to the trade area hierarchy from Section 6.3.
Concentric Radius Rings
A ring is a circle of fixed radius drawn around the site — the familiar 1-, 3-, and 5-mile report. It is fast, universally understood, and reproducible, which is why lenders and brokers still request it.
Its defect is a hidden assumption: that a customer can travel equally easily in every direction . A ring drawn on a site bounded by a river, a rail yard, a limited-access freeway, a military reservation, or a mountain ridge counts thousands of households that cannot practically reach the property.
Drive-Time and Drive-Distance Polygons
A drive-time polygon traces the actual road network outward from the site until a travel-time budget is exhausted, producing an irregular shape that stretches along arterials and collapses against barriers. Drive-distance polygons do the same on network mileage rather than minutes.
- Dimension Radius Ring Drive-Time Polygon
- Geometry Perfect circle Irregular, follows the road network
- Handles barriers No Yes
- Reflects congestion No Yes, when peak-period speeds are used
- Reproducible across analysts Perfectly Varies with network vintage and time-of-day setting
- Best use Quick screening, lender-format comparability Defensible demand sizing and capture modeling
Warning
The barrier trap. A three-mile ring around a site on the east bank of a river with one bridge two miles north may capture 42,000 households. The corresponding ten-minute drive-time polygon may capture 24,000 — and the missing 18,000 are on the far bank with a fifteen-minute detour. Underwriting demand from the ring overstates the trade area by 75 percent and will produce an unsupportable capture rate.
Exam-safe practice: deliver rings and drive times side by side. When they diverge materially, the divergence is itself the finding, and the drive-time figure governs the demand model.
Custom Polygons and Geocoding
Two supporting techniques appear throughout CI 102 casework:
Custom polygons are hand-drawn trade areas following real boundaries — a school attendance zone, a section of highway between two interchanges, a neighborhood bounded by arterials. Use them when local knowledge beats any automated geometry.
Geocoding converts a list of addresses into mapped points. Plotting a client's actual customer addresses or loyalty-card data and drawing the polygon that contains 60 to 70 percent of them produces an empirically observed primary trade area rather than a modeled one — the strongest evidence available.
Retail Gap Analysis: Leakage and Surplus
Retail gap analysis is where geospatial data converts into an investment recommendation.
Demand is the estimated retail expenditure by households living inside the trade area , by category.
Supply is the estimated sales generated by establishments located inside the trade area , by the same category. Retail Gap = Demand − Supply \text{Retail Gap} = \text{Demand} - \text{Supply} Retail Gap = Demand − Supply
Positive gap = Leakage. Residents are spending money that local businesses do not capture; those dollars are being exported to competing trade areas. Leakage signals potential unmet demand .
Negative gap = Surplus. Establishments are selling more than resident households can account for, meaning the area imports customers from outside. Surplus signals an established regional destination — and a crowded competitive field.
The Leakage/Surplus Factor
Raw dollar gaps cannot be compared across trade areas of different sizes, so analysts normalize: Leakage/Surplus Factor = Demand − Supply Demand + Supply × 100 \text{Leakage/Surplus Factor} = \frac{\text{Demand} - \text{Supply}}{\text{Demand} + \text{Supply}} \times 100 Leakage/Surplus Factor = Demand + Supply Demand − Supply × 100
The result runs from +100 (complete leakage — no local supply at all) to -100 (complete surplus). A factor near zero indicates a trade area roughly in balance.
Worked Example: Sizing a Home Improvement Opportunity
An analyst evaluates a 12-acre pad in a growing suburban submarket for a home improvement retailer. Intellisite is used to build a 12-minute drive-time polygon , and the Retail MarketPlace report for the Building Material and Garden Equipment category returns:
- Demand (household expenditure): $88,400,000
- Supply (sales by establishments in the polygon): $52,600,000
Step 1: Compute the Retail Gap Gap = $ 88,400,000 − $ 52,600,000 = $ 35,800,000 of leakage \text{Gap} = \$88{,}400{,}000 - \$52{,}600{,}000 = \$35{,}800{,}000 \text{ of leakage} Gap = $88 , 400 , 000 − $52 , 600 , 000 = $35 , 800 , 000 of leakage
Step 2: Compute the Leakage/Surplus Factor $ 35,800,000 $ 88,400,000 + $ 52,600,000 × 100 = 35.8 141.0 × 100 = 25.4 \frac{\$35{,}800{,}000}{\$88{,}400{,}000 + \$52{,}600{,}000} \times 100 = \frac{35.8}{141.0} \times 100 = 25.4 $88 , 400 , 000 + $52 , 600 , 000 $35 , 800 , 000 × 100 = 141.0 35.8 × 100 = 25.4
A factor of +25.4 indicates substantial leakage: roughly a quarter of the category's total trade-area activity is escaping to competitors outside the polygon.
Step 3: Apply a Realistic Capture Rate
No single store recaptures all leakage. Competitors will respond, some households will keep shopping near work, and category loyalty is sticky. The analyst underwrites a 65% capture of the identified leakage: $ 35,800,000 × 0.65 = $ 23,270,000 of supportable sales \$35{,}800{,}000 \times 0.65 = \$23{,}270{,}000 \text{ of supportable sales} $35 , 800 , 000 × 0.65 = $23 , 270 , 000 of supportable sales
Step 4: Convert Sales to Supportable Gross Leasable Area
Divide by the category's benchmark sales productivity — here $310 per square foot annually : $ 23,270,000 $ 310 / SF = 75,065 SF of supportable GLA \frac{\$23{,}270{,}000}{\$310/\text{SF}} = 75{,}065 \text{ SF of supportable GLA} $310/ SF $23 , 270 , 000 = 75 , 065 SF of supportable GLA
Step 5: Reconcile Against the Physical and Regulatory Site
The demand model is now cross-checked against Sections 7.2 and 7.3. A 75,000 SF box on 12 acres requires roughly 375 stalls at 5.0 per 1,000 SF, consuming about 131,000 SF of surface parking against a 522,720 SF parcel — feasible. Signalized full-movement access, permitted zoning use, and adequate truck-court depth must all be confirmed before the number is committed to an investment memorandum.
Important
Leakage is a hypothesis, not a conclusion. A large positive gap can mean unmet demand — or it can mean the category is structurally unservable in that location because a dominant competitor sits just outside the polygon boundary, because the arterial has no signalized left turn, or because zoning prohibits the use. Every geospatial finding must be reconciled with the Market, Location and Site, and Political and Legal analyses of the CCIM Strategic Analysis Model before it becomes a recommendation.
Beyond Retail: Geospatial Analysis by Property Type
Property Type Primary Geospatial Question Key Layers
Retail Where do the customers live, and what is leaking? Drive-time polygons, Retail MarketPlace, Tapestry, traffic counts
Office Where does the labor force live relative to the site? Commute-shed drive times, daytime population, educational attainment, transit
Industrial How fast can trucks reach population and intermodal nodes? Truck-route networks, interstate and rail access, one-day drive polygons, warehouse employment
Multifamily Where are renter households forming, and what can they pay? Household formation forecasts, renter-occupied tenure, income distribution, Tapestry
Exam Traps
Reporting rings where barriers exist. If a river, freeway, rail corridor, or elevation change bisects the trade area, radius-ring demographics are not defensible. Run the drive time.
Mixing data vintages. Decennial census counts, current-year estimates, and five-year forecasts are three different products. Comparing a decennial count to a competitor's current-year estimate manufactures growth that does not exist. State the vintage on every figure.
Treating the full gap as capturable. Leakage is the ceiling, never the projection. Apply an explicit, defended capture rate.
Confusing surplus with strength — or with saturation. A negative gap means the area imports shoppers, which can indicate a proven regional destination or an oversupplied field. Only competitor-level analysis distinguishes the two.
Double-counting daytime and residential demand. Office-worker lunch demand and resident household demand are different populations measured by different variables. Adding them without adjustment inflates the market.
Reading a Spending Potential Index as dollars. SPI is indexed to 100 = national average. An SPI of 142 means the trade area spends 42 percent above the national average on that category — it is not a dollar figure and cannot be summed.