A production-grade data platform providing comprehensive analysis of Westchester County, New York through integrated open data sources, interactive mapping, and professional-grade dashboards for government officials, planners, and researchers.
The Westchester County Data Platform is a multi-component application featuring:
- Government data dashboards - Property tax, county budget, municipal services
- Interactive mapping - Multi-layer geographic visualization with click-to-inspect
- Transit accessibility analysis - Metro-North station coverage and walkability
- Demographic insights - Population, income, housing trends
- Data analysis tools - Jupyter notebooks for exploratory analysis
- Public web access - Professional UI suitable for government use
# Double-click START_LOCAL.bat or run:
./START_LOCAL.bat# Backend API
cd Technical/src/api
python main.py
# Frontend Application
cd Technical/src/frontend
npm run devOpen http://localhost:3000 in your browser.
- Property tax assessments and trends
- County budget data (multi-year analysis)
- Municipal services coverage
- Building permits and violations
- Zoning and land use
- Metro-North stations (Harlem, Hudson, New Haven lines)
- Transit accessibility analysis
- Station coverage and walkability scores
- GTFS schedule data
- Population trends by municipality
- Income and housing statistics
- Census tract data
- American Community Survey (ACS) data
- County and municipality boundaries
- Census tracts and block groups
- Parks and recreation areas
- Major roads and highways
Westchester/
├── README.md (this file)
├── HANDOFF_DOCUMENTATION.md # Current status and handoff info
├── PROJECT_INDEX.md # Complete file inventory
├── Output/ # User-facing deliverables
│ ├── Data/
│ │ ├── Results/ # Excel files (one sheet each)
│ │ ├── Source/ # Original data documentation
│ │ └── Robin/ # Robin database integration
│ ├── PDFs/ # LaTeX reports
│ ├── Charts/ # Visualizations
│ └── Documentation/ # Analysis documentation
└── Technical/ # Implementation
├── src/
│ ├── api/ # FastAPI backend
│ ├── frontend/ # React + TypeScript web app
│ ├── analysis/ # Python analysis scripts
│ ├── data_importers/ # API clients for data sources
│ └── processors/ # Data cleaning/transformation
├── data/
│ ├── raw/ # Original downloaded data
│ ├── processed/ # Cleaned data
│ └── cache/ # Temporary/cached data
├── notebooks/ # Jupyter notebooks
├── configs/ # Configuration files
├── scripts/ # Utility scripts
├── docs/ # Technical documentation
└── tests/ # Test files
- Overview Dashboard: High-level county metrics and trends
- Property Tax Dashboard: Assessment data, rates, geographic analysis
- Budget Dashboard: County spending by department and year
- Transit Dashboard: Metro-North accessibility with 1-mile radius analysis
- Demographics Dashboard: Population, income, housing statistics
- Municipal Services Dashboard: Police, fire, public works coverage
- Geographic Explorer: Multi-layer interactive map
- Municipality Comparison: Side-by-side town/city comparisons
- Multiple data layers (boundaries, stations, properties, census)
- Click-to-inspect feature details
- Buffer/radius analysis tools
- Heat maps for density visualization
- Choropleth maps for demographic data
- Jupyter notebooks for exploratory analysis
- Tax assessment trend analysis
- Budget efficiency comparisons
- Transit accessibility scoring
- Demographic change tracking
- Westchester County Open Data Portal - Government data, permits, services
- NY State Open Data - Westchester-specific records and statistics
- Metro-North Railroad - GTFS schedule and station data
- U.S. Census Bureau - ACS demographic data for Westchester
- Westchester County GIS - Geographic boundaries and mapping data
All data sources are documented in Output/Data/Source/README.md with:
- Source URLs and access methods
- Download timestamps
- Data quality assessments
- Processing notes
- 15+ Excel datasets - Druck-compliant (one sheet per file, machine-readable)
- 4+ LaTeX reports - Methodology, analysis findings, executive summaries
- Interactive visualizations - Charts, maps, and dashboards
- Complete documentation - Technical guides and user manuals
- Methodology Report - Data sources, processing, analysis methods
- Tax Assessment Analysis - Trends, patterns, recommendations
- Budget Analysis - Spending patterns, efficiency metrics
- Transit Accessibility Report - Metro-North coverage analysis
- Executive Summary - High-level findings for stakeholders
- User Guide - Platform usage instructions
- Backend: Python 3.11+, FastAPI, pandas, geopandas
- Frontend: React 18, TypeScript, Vite, Tailwind CSS
- Mapping: Mapbox GL JS / Leaflet
- Data Analysis: Jupyter Lab, matplotlib, seaborn
- Database: PostgreSQL + PostGIS (optional, starts with JSON/CSV)
- Deployment: Docker, local-first architecture
- HANDOFF_DOCUMENTATION.md: Current project status and completion metrics
- PROJECT_INDEX.md: Detailed file inventory and navigation
- Technical/README.md: Technical architecture and setup (to be created)
- Output/Documentation/: Analysis methodology and findings
This project follows:
- Druck Standards: Two-folder structure, data authenticity, documentation
- Excel Requirements: One sheet per file, machine-readable columns
- LaTeX Requirements: All final reports in LaTeX, PDFs in Output/PDFs/
- File Naming:
[YYYY.MM.DD]prefix for dated files - Production Quality: Professional UI/UX suitable for government officials
- Westchester County Government: Planners, officials, analysts
- Municipal Governments: Town and city administrators
- Researchers: Academic and policy researchers
- Public: Residents interested in county data and trends
- Media: Journalists covering Westchester County
Current Phase: Foundation Complete - Ready for Data Collection & Dashboard Expansion
Overall Progress: 40% Complete
Foundation Phase: ✅ 100% Complete
- ✅ Complete Druck-standard project structure
- ✅ Comprehensive documentation (12 files)
- ✅ FastAPI backend with 8 operational endpoints
- ✅ React + TypeScript frontend with professional UI
- ✅ Interactive mapping with Metro-North integration
- ✅ Data import system ready (3 importers built)
- ✅ Druck-compliant Excel generator operational
- ✅ One-click startup system (
START_LOCAL.bat) - 📋 Additional dashboards (6 more planned)
- 📋 Data collection execution (import scripts ready)
- 📋 LaTeX reports (system designed)
📋 For Complete Status: See [2025.10.12] COMPLETE_PROJECT_HANDOFF_DOCUMENTATION.md
This is part of the Arcanum Projects ecosystem and follows workspace-wide standards documented in Council/Druck/.
For questions or contributions:
- Review Druck documentation:
../../Council/Druck/README.md - Check project index:
PROJECT_INDEX.md - Read handoff documentation:
HANDOFF_DOCUMENTATION.md
Created: October 2025
Version: 1.0 (In Development)
Part of: Arcanum Projects - Council-supported research infrastructure
Follows: Druck organizational standards
Professional-grade data platform for Westchester County government, planning, and research applications.