Water & Sewer Permit Analysis in NYC

Overview

The spatial distribution of water and sewer permits in New York City plays a crucial role in understanding patterns of urban development, infrastructure needs, and resource allocation. In this Spatial Statistics assignment, I applied Kernel Density and Hot Spot Analysis (Getis-Ord Gi*) to assess the concentration and statistical significance of water and sewer permit activity across NYC.

The goal was to identify areas with higher-than-expected permit activity, which could indicate regions of increased demand for infrastructure upgrades, new construction, repairs, and population sizes.

Data & Approach

I utilized two primary datasets for the analysis:

1A shapefile representing the boundaries of NYC boroughs

2A dataset of historic water and sewer permits including date of issuance and permit type, geocoded to populate locations on the map

Methodology

Kernel Density Analysis

Kernel Density was used to generate a continuous surface depicting the density of water and sewer permits across NYC. This method calculates the number of permits per unit area, providing insight into the spatial intensity of permit activity. The input for the Kernel Density was the aggregated permit data. The resulting symbols displayed warmer colors in areas of high permit density (indicating more frequent infrastructure activities) and cooler colors in low-density areas.

Hot Spot Analysis (Getis-Ord Gi*)

To complement Kernel Density, Hot Spot Analysis was conducted to identify statistically significant clusters of permit activity. This analysis calculates Z-scores and p-values to determine whether observed concentrations of permits were due to random chance or indicative of meaningful spatial patterns. Areas with high Z-scores were considered hot spots, indicating significant concentrations of permits, while low Z-scores represented cold spots, showing areas with lower-than-expected permit activity.

Results

Water and Sewer Permit Locations in New York City (2018–2021) — Kernel Density and Hot Spot Analysis — Water and Sewer Permit Locations in New York City (2018–2021). Left layer shows kernel density of permits; right layer shows hot spot analysis results with statistically significant clusters highlighted.

Key Findings

Manhattan & Brooklyn: Infrastructure Hotspots

The Kernel Density map revealed that Manhattan and Brooklyn exhibited the highest densities of water and sewer permits, reflecting the high level of urban development and infrastructure demand in these boroughs. These areas are characterized by dense populations and ongoing construction, which likely drive increased permit activity.

Statistical Confirmation via Hot Spot Analysis

The Hot Spot Analysis confirmed that Manhattan and parts of Brooklyn are statistically significant hot spots, suggesting that the observed concentration of permits in these boroughs is not due to chance. These findings indicate that infrastructure work in these regions is likely linked to ongoing urban development, new construction projects, and the need for extensive water and sewer system upgrades.

Staten Island & The Bronx: Cold Spots

Staten Island and parts of the Bronx were identified as cold spots, where permit activity was significantly lower than expected. This could point to areas with aging infrastructure that may be underserved or where development activity is limited, raising questions about equitable infrastructure investment.