All work

Spatial analysis

Where the Sun Shines and Income Aligns

Combining LiDAR, roof area, solar radiation, and household income to compare Calgary communities.

Role
GIS analyst
Project
SAIT BGIS / Calgary rooftop solar study

My contribution

Sanaz Poroushani — GIS analyst. I contributed to the community-level solar suitability analysis, spatial statistics, data and topology QA/QC, map production, and project reporting. The report’s QA/QC checklist records my review of spatial analysis, attribute data, topology, and deliverables, alongside collaborative review of the ModelBuilder workflow.

Team: Sanaz Poroushani, John Abboud.

01 / Introduction

A GIS-Based Neighborhood Analysis of Rooftop Solar Potential in Calgary

Where are Calgary’s strongest opportunities for rooftop solar when physical potential and socioeconomic capacity are considered together? This study combines LiDAR-derived solar radiation, residential rooftop area, and median household income to compare communities and identify priority areas for further investigation.

Geographic question

Where are the best neighborhoods in Calgary for rooftop solar panel installation based on solar potential, rooftop suitability, and socioeconomic factors such as household income?

Three dimensions of suitability

  1. Technical potential: incoming solar radiation derived from a two-metre LiDAR DEM.
  2. Physical capacity: available residential rooftop area aggregated by community.
  3. Socioeconomic readiness: median household income from Esri Enrich.

The analysis integrates these dimensions into a relative suitability index and uses bivariate mapping to explore where solar potential and household income align. Income is a community-level proxy for adoption capacity, rather than a measure of individual willingness to install solar.

Original map of Calgary residential communities, with study area, city boundary, legend, scale, and north arrow.
Residential community study area · Open image to enlarge ↗

Research context

The literature review identified the value of combining LiDAR and GIS for technical rooftop assessment with socioeconomic information about adoption. The project addresses this at the Calgary community scale, bringing technical resources and financial capacity into the same planning framework.

Original project workflow diagram from data acquisition and preparation through solar analysis, composite index, spatial statistics, and final outputs.
End-to-end analytical workflow · Open image to enlarge ↗

02 / Data preparation & analysis

From source data to community indicators

Inputs and analytical roles
InputRole in the studySource
Community boundariesCommon unit for aggregating and comparing resultsCity of Calgary Open Data
Residential building footprintsEstimate rooftop capacity and total available areaCity of Calgary Open Data
Two-metre LiDAR DEMGenerate the solar radiation surfaceCity of Calgary Open Data
Median household incomeRepresent socioeconomic capacity at community levelEsri Enrich

Data management and QA/QC

The layers were organized in a file geodatabase and projected to NAD 1983 3TM Zone 114. Data preparation checked missing values, duplicate records, geometry, unnecessary attributes, and community identifiers. Topology validation checked polygon overlaps and gaps before analysis. The same coordinate reference was maintained in PostgreSQL/PostGIS using SRID 3776.

Solar radiation and usable rooftop area

A solar radiation surface was generated in ArcGIS Pro from the DEM, with radiation expressed in Wh/m². Residential building footprints were filtered, clipped to the study area, and refined with a negative one-metre buffer to approximate usable rooftop space. The report’s SQL implementation of this buffer is included below.

Zonal Statistics as Table summarized solar radiation within each community. Spatial aggregation calculated total residential rooftop area. Solar statistics, rooftop area, and income were joined through the common comm_code field.

Original choropleth map of mean solar radiation by Calgary community using an orange-to-red scale.
Mean solar radiation by community · Open image to enlarge ↗
Original green choropleth map showing total residential rooftop area by Calgary community.
Total residential rooftop area by community · Open image to enlarge ↗

Composite suitability index

The main ArcGIS analysis used the Calculate Composite Index tool. Mean solar radiation (Solar_MEAN), total residential rooftop area (BL_Area_Sum), and median household income (Household_Mid_Income) were standardized using percentile ranking and combined using the geometric mean. This balances the inputs: a low value in one dimension cannot be fully offset by a high value in another.

Estimated photovoltaic energy production

The report estimates PV output as rooftop area × mean solar radiation × 0.15, then divides by 1,000 to convert Wh to kWh. The 0.15 factor combines approximately 20% panel efficiency and a 75% system performance ratio. This is a screening estimate based on the report’s input period and assumptions; building-level installation decisions require site-specific assessment.

03 / Reproducible geoprocessing

ModelBuilder workflow

The ArcGIS ModelBuilder model organizes community selection, residential building extraction, clipping, footprint buffering, area calculation, income integration, zonal statistics, and composite index calculation into a repeatable workflow.

Preprocessed solar radiation and completed Esri Enrich income data were used in the model to reduce repeated computation and credit usage. Model outputs were exported to Model_Builder_DG.gdb, separately from previously processed data in Final_Geodatabase.gdb.

Original ArcGIS ModelBuilder diagram with input datasets, linked geoprocessing tools, and derived outputs.
ArcGIS ModelBuilder model · Open image to enlarge ↗

04 / Results & cartography

Where solar potential and income align

Solar radiation was relatively consistent across Calgary compared with the variation in rooftop area and income. The composite results identify western and southwestern communities as prominent opportunities, reflecting the combined effect of physical capacity and socioeconomic readiness.

Original rooftop solar suitability and adoption potential map of Calgary communities in pink and purple classes.
Composite rooftop solar suitability and adoption potential · Open image to enlarge ↗

Communities highlighted in the report

Edgemont, Hawkwood, Scenic Acres, Tuscany, Royal Oak, West Springs, Signal Hill, Strathcona Park, Aspen Woods, and Springbank Hill are identified among the most suitable communities. These names are presented as the report’s highlighted group, without imposing an additional ranking.

Bivariate analysis

The bivariate map combines estimated solar energy potential and median household income. It distinguishes communities with both high potential and high income from those where strong technical potential coincides with lower income and possible financial barriers. The report identifies agreement between the composite and bivariate results in communities including Edgemont, Tuscany, West Springs, Aspen Woods, and Springbank Hill.

Original bivariate map comparing Calgary solar energy potential and median household income using a two-dimensional colour scheme.
Solar energy potential and median household income · Open image to enlarge ↗

05 / Statistical interpretation

Income patterns and spatial clustering

Community median household incomes showed a positively skewed distribution. The mean was $114,529.89, compared with a median of $106,125.62; community values ranged from $46,403.85 to $300,001.00. The report’s standard deviation of $49,736.37 and skewness of 2.06 describe substantial variation between communities.

Original Calgary map of neighbourhood median household income by community in blue classes.
Median household income by community · Open image to enlarge ↗

Hot Spot Analysis — Getis-Ord Gi*

The income hotspot analysis identifies concentrations of high and low values. These patterns provide context for interpreting adoption capacity and the composite solar suitability map.

Original Getis-Ord Gi* map of median household income hotspots and cold spots across Calgary communities.
Income Hot Spot Analysis · Open image to enlarge ↗

Cluster and Outlier Analysis — Local Moran’s I

The local analysis identifies high–high and low–low income clusters alongside spatial outliers. It complements hotspot analysis by considering each community’s relationship with its neighbours.

Original Local Moran’s I cluster and outlier map for median household income in Calgary.
Income clusters and spatial outliers · Open image to enlarge ↗

Global Moran’s I

Global Moran’s I assessed the spatial distribution of household income, using contiguity edges-only neighbours and row standardization. The results indicate statistically significant positive spatial autocorrelation. These statistics describe income clustering, rather than the accuracy of the solar suitability model.

Global Moran’s I — household income
StatisticReported value
Moran’s Index0.276648
Expected Index−0.004673
Variance0.002349
z-score5.804277
p-value0.000000 (rounded as reported)
Original Global Moran’s I significance diagram showing the observed clustered income pattern.
Global Moran’s I spatial autocorrelation result · Open image to enlarge ↗

The observed clustering is inconsistent with a random spatial pattern at the significance levels discussed in the report. The reported rounded p-value should not be interpreted as a probability of exactly zero.

06 / PostgreSQL & PostGIS

Database design and spatial SQL

The project replicated its spatial data in PostgreSQL/PostGIS to support relational and spatial analysis alongside ArcGIS Pro. Four core entities — calgary_boundary, household_income, buildings_footprints, and zonal_solar_community — provide city context, community income, rooftop geometries, and solar summaries.

The common comm_code field links community income, buildings, and solar summaries. Geometry columns use the project’s projected reference system, SRID 3776, for area and distance calculations.

Original entity relationship diagram showing the four spatial database tables, fields, and relationships.
PostgreSQL/PostGIS entity relationship diagram · Open image to enlarge ↗

SQL code from the report

The following excerpts preserve the SQL as printed in the report. They demonstrate geometry preparation, attribute joins, aggregation, intersection, and energy estimation; they are displayed for review and are not executed by this website.

SQL 01 / PostGIS

Prepare usable residential rooftop geometries

View original SQL excerpt
CREATE TABLE buildings_buffered AS

SELECT

     gid,

     comm_code,

     ST_Buffer(geom, -1) AS geom

FROM buildings_footprints

WHERE building_type = 'Residential'

AND ST_Area(geom) > 2;

SQL 02 / PostGIS

Join community income and solar potential

View original SQL excerpt
SELECT h.comm_name, z.solar_mean

FROM household_income h

JOIN zonal_solar_community z ON h.comm_code = z.comm_code;

SQL 03 / PostGIS

Summarize community income and buildings

View original SQL excerpt
SELECT      h.comm_code, h.comm_name, h.household_mid_income,

     COUNT(b.gid) AS building_count,

     SUM(b.bl_area) AS total_building_area,

     AVG(b.bl_area) AS avg_building_area

FROM household_income h

INNER JOIN buildings_footprints b

     ON h.comm_code = b.comm_code

GROUP BY

     h.comm_code,

     h.comm_name,

     h.household_mid_income

ORDER BY total_building_area DESC;

SQL 04 / PostGIS

Calculate building–community intersection areas

View original SQL excerpt
SELECT b.gid,

          s.comm_code,

          ST_Area(ST_Intersection(b.geom, s.geom)) AS intersect_area

FROM buildings_footprints b

JOIN zonal_solar_community s

ON ST_Intersects(b.geom, s.geom);

SQL 05 / PostGIS

Estimate solar energy production per building

View original SQL excerpt
SELECT b.gid,

b.bl_area,

z.solar_mean,

b.bl_area * z.solar_mean * 0.15 AS estimated_wh_year,

(b.bl_area * z.solar_mean * 0.15) / 1000 AS estimated_kwh_year

FROM buildings_footprints b

JOIN zonal_solar_community z

ON b.comm_code = z.comm_code;

SQL 06 / PostGIS

Create a negative one-metre building buffer

View original SQL excerpt
SELECT comm_code,

          bl_area,

          ST_AREA(ST_Buffer(geom, -1)) AS area_value,

          ST_Buffer(geom, -1) AS buffered_geom

FROM buildings_footprints;

The appendix also includes a separate weighted, min–max SQL ranking example. That example differs from the percentile/geometric-mean method described for the main ArcGIS composite map; the methods are not presented here as interchangeable.

07 / Discussion & conclusion

Supporting informed solar planning

The report concludes that rooftop solar suitability depends on the interaction between environmental resources, available roof area, and socioeconomic capacity. The composite and bivariate maps identify communities where these conditions align, while also showing where financial barriers may constrain adoption despite useful technical potential.

This is a community-scale planning framework. It supports identifying areas for further assessment and considering targeted incentives; it does not establish engineering feasibility for individual roofs or predict actual household adoption.

08 / Interactive StoryMap

Explore the solar study

Follow the project’s maps and narrative in ArcGIS StoryMaps.

Open Calgary Solar StoryMap
More selected workTAKEPOINT: Spatial Intelligence From First Take to Last