Wren Halvorsen

Prepared 4 zoning map amendment analyses and staff reports for Planning Commission hearings, summarizing code compliance, comprehensive plan consistency, and public testimony. Built a 1,200-parcel land-use inventory in ArcGIS Pro for the corridor plan, reconciling assessor, permit, and field data to flag 140+ underutilized sites. Co-facilitated 6 public open houses with 400+ total attendees; designed bilingual display boards and synthesized 650 comment cards into a themed findings memo. Developed an ADU permit trend dashboard (2016–2025) that tracks 3,800+ permits by neighborhood, adopted by staff for quarterly housing production reporting. Reviewed 30+ land-use applications against Title 33 zoning code standards, reducing senior planner review time by ~15%.

Led a bus stop accessibility audit of 850 stops, scoring ADA landing pads, curb ramps, shelters, and lighting to prioritize $1.2M in capital improvements. Analyzed automatic passenger counter data for 22 bus lines to identify ridership recovery trends and overcrowding hot spots by time of day. Produced Title VI equity maps overlaying minority and low-income census tracts with service changes for the Board-required equity analysis. Authored a frequent-service corridor memo recommending 3 candidate corridors, projected to serve 18,000+ additional weekday riders within ¼ mile. Cleaned and geocoded 5,000+ customer service records in QGIS to map recurring stop-amenity complaints.

Supported a regional housing affordability survey of 2,000 households, managing sampling frames and weekly response-rate tracking (38% final response). Cleaned and weighted survey data in R and Python (pandas), building reproducible scripts that cut data-prep time by 40%. Co-authored a policy brief on rent burden and displacement risk distributed to 12 Metro-area jurisdictions. Created 15+ charts and choropleth maps from Census/ACS 5-year estimates for presentations to city council staff. Coordinated literature reviews on inclusionary zoning and middle housing across 25 peer cities.

GPA 3.8/4.0. Coursework: Land Use Law, Transportation Planning, Advanced GIS, Housing Policy, Community Engagement Studio. Capstone: equitable TOD strategy for a SW Corridor station area.

Minor in Spatial Data Science. Senior thesis on wildfire-risk zoning in the wildland-urban interface; Dean's List 6 terms.

Logged 1,500+ cyclist and pedestrian movements across 8 intersections during seasonal counts; data informed the 2024 regional active-transportation report.