{"id":{"repo_id":"calpoly","oai_identifier":"oai:digitalcommons.calpoly.edu:theses-5078"},"canonical_url":"https://search.ndltd.org/etd/calpoly/oai:digitalcommons.calpoly.edu:theses-5078","repository":{"repo_id":"calpoly","name":"Cal Poly","base_url":"https://digitalcommons.calpoly.edu/do/oai/"},"display":{"title":"Developing a Rapid Urban Forest Assessment System for Sustainable City Greenification","abstract":"This thesis presents the Rapid Urban Forest Assessment (RUFA) system, a web-based platform that integrates urban tree inventories and aerial tree detection to assess forest health across California’s census-designated places. RUFA combines inventoried tree records with coordinates detected from high-resolution multispectral imagery using convolutional neural networks, then computes a composite RUFA Score from four metrics: canopy cover percentage, trees per capita, tree diversity (TD-50), and tree evenness. The thesis addresses two engineering challenges in building the dashboard: querying and aggregating over seven million tree records in real time, and rendering spatial summaries at multiple zoom levels without recomputing cluster assignments on every map interaction. An evaluation of spatial indexing strategies motivates a MySQL schema combining R-tree candidate pruning with cascading materialized views, enabling sub-second city-level queries, while a SuperCluster index paired with Voronoi tessellation supports interactive map visualization. Deployed on AWS, RUFA provides urban foresters, planners, and researchers with RUFA Scores comparable across communities and multi-scale map outputs to support evidence-based urban forestry management.","abstract_html":"This thesis presents the Rapid Urban Forest Assessment (RUFA) system, a web-based platform that integrates urban tree inventories and aerial tree detection to assess forest health across California’s census-designated places. RUFA combines inventoried tree records with coordinates detected from high-resolution multispectral imagery using convolutional neural networks, then computes a composite RUFA Score from four metrics: canopy cover percentage, trees per capita, tree diversity (TD-50), and tree evenness. The thesis addresses two engineering challenges in building the dashboard: querying and aggregating over seven million tree records in real time, and rendering spatial summaries at multiple zoom levels without recomputing cluster assignments on every map interaction. An evaluation of spatial indexing strategies motivates a MySQL schema combining R-tree candidate pruning with cascading materialized views, enabling sub-second city-level queries, while a SuperCluster index paired with Voronoi tessellation supports interactive map visualization. Deployed on AWS, RUFA provides urban foresters, planners, and researchers with RUFA Scores comparable across communities and multi-scale map outputs to support evidence-based urban forestry management.","abstract_has_math":false,"creators":["Gonzalez, Daniel"],"institution":null,"degree_name":"MS in Computer Science","degree_level":null,"degree_discipline":null,"degree_department":null,"school":null,"contributors":["Alex Dekhtyar","Computer Science","College of Engineering"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":null,"date_issued":"","date_published":null,"updated_at":"2026-11-19T07:12:58Z","subjects":["Urban forestry","tree density","biodiversity","TD-50","Computer and Systems Architecture","Data Storage Systems"],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://digitalcommons.calpoly.edu/theses/3410","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://digitalcommons.calpoly.edu/theses/3410","record_label":"Repository record","record_kind":"record","record_source":"dc:identifier","download_url":null,"download_label":null,"download_source":null,"access_status":null,"embargo_until":null,"access_note":null},"source_record":{"url":"https://digitalcommons.calpoly.edu/do/oai/?verb=GetRecord&metadataPrefix=oai_etdms&identifier=oai%3Adigitalcommons.calpoly.edu%3Atheses-5078","prefix":"oai_etdms"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Alex Dekhtyar","Computer Science","College of Engineering"]},{"key":"dc:creator","label":"Author","values":["Gonzalez, Daniel"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.available","label":"Dc Date Available","values":["2026-08-03T07:00:00Z"]},{"key":"dc:date.created","label":"Dc Date Created","values":["2026-08-01T07:00:00Z"]},{"key":"thesis:degree_name","label":"Degree Name","values":["MS in Computer Science"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Urban forestry","tree density","biodiversity","TD-50","Computer and Systems Architecture","Data Storage Systems"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://digitalcommons.calpoly.edu/theses/3410"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["This thesis presents the Rapid Urban Forest Assessment (RUFA) system, a web-based platform that integrates urban tree inventories and aerial tree detection to assess forest health across California’s census-designated places. RUFA combines inventoried tree records with coordinates detected from high-resolution multispectral imagery using convolutional neural networks, then computes a composite RUFA Score from four metrics: canopy cover percentage, trees per capita, tree diversity (TD-50), and tree evenness. The thesis addresses two engineering challenges in building the dashboard: querying and aggregating over seven million tree records in real time, and rendering spatial summaries at multiple zoom levels without recomputing cluster assignments on every map interaction. An evaluation of spatial indexing strategies motivates a MySQL schema combining R-tree candidate pruning with cascading materialized views, enabling sub-second city-level queries, while a SuperCluster index paired with Voronoi tessellation supports interactive map visualization. Deployed on AWS, RUFA provides urban foresters, planners, and researchers with RUFA Scores comparable across communities and multi-scale map outputs to support evidence-based urban forestry management."]},{"key":"dc:title","label":"Title","values":["Developing a Rapid Urban Forest Assessment System for Sustainable City Greenification"]}]}],"canonical_facts":{"dc:contributor":["Alex Dekhtyar","Computer Science","College of Engineering"],"dc:creator":["Gonzalez, Daniel"],"dc:date.available":["2026-08-03T07:00:00Z"],"dc:date.created":["2026-08-01T07:00:00Z"],"dc:description.abstract":["This thesis presents the Rapid Urban Forest Assessment (RUFA) system, a web-based platform that integrates urban tree inventories and aerial tree detection to assess forest health across California’s census-designated places. RUFA combines inventoried tree records with coordinates detected from high-resolution multispectral imagery using convolutional neural networks, then computes a composite RUFA Score from four metrics: canopy cover percentage, trees per capita, tree diversity (TD-50), and tree evenness. The thesis addresses two engineering challenges in building the dashboard: querying and aggregating over seven million tree records in real time, and rendering spatial summaries at multiple zoom levels without recomputing cluster assignments on every map interaction. An evaluation of spatial indexing strategies motivates a MySQL schema combining R-tree candidate pruning with cascading materialized views, enabling sub-second city-level queries, while a SuperCluster index paired with Voronoi tessellation supports interactive map visualization. Deployed on AWS, RUFA provides urban foresters, planners, and researchers with RUFA Scores comparable across communities and multi-scale map outputs to support evidence-based urban forestry management."],"dc:identifier":["https://digitalcommons.calpoly.edu/theses/3410"],"dc:subject":["Urban forestry","tree density","biodiversity","TD-50","Computer and Systems Architecture","Data Storage Systems"],"dc:title":["Developing a Rapid Urban Forest Assessment System for Sustainable City Greenification"],"thesis:degree_name":["MS in Computer Science"]},"updated_at":"2026-11-19T07:12:58Z"}