Fran Lopez Tapia Email & Phone Number

Los Altos, California, United States

Los Altos, California, United States

-Streamlining Data Management and Analysis with Python Scripts I have authored a variety of Python scripts and ArcGIS Pro Notebooks that perform nightly GIS data calculation tasks, ensuring timely data updates and analysis.-Ensuring Data Integrity through ETL Maintenance and ImprovementI maintained and improved the team's quarterly Extract Transform Load (ETL) models for Calflora, California Natural Diversity Database, and California Protected Areas Database data. -Trail Information Systems Project: A Multifaceted InitiativeI spearheaded the District's trail information systems project, encompassing data collection, data analysis, nightly Python script implementation, and public-facing web application development. -Supporting Conservation Efforts with GIS analysisIn support of the Santa Cruz Kangaroo Rat habitat restoration project, I conducted a binary suitability analysis, utilizing GIS tools and spatial data to identify suitable habitat areas for the species. This analysis resulted in detailed maps that informed conservation planning and decision-making.-Fulfilling GIS Requests with Expertise and EfficiencyI have consistently fulfilled map, data, and data analysis requests, providing timely and accurate information to support a wide range of projects and departments.

Los Altos, California, United States

-Advancing District Functions and Empowering Staff with GIS ExpertiseI have consistently fulfilled map and data analysis requests, providing valuable insights that have informed request for proposals (RFPs), board reports, grant applications, and public outreach initiatives.-Enhancing Public Engagement with Interactive Web Applications and Story MapsI have played a pivotal role in developing and publishing numerous web applications and story maps, both for internal use by District staff and for public engagement. These interactive tools have provided a user-friendly platform for staff to access and utilize GIS data, while also enabling the public to explore and understand complex spatial information in a more intuitive and engaging manner.-Revamping the Patrol Map for Enhanced Field OperationsI spearheaded the implementation of major data and cartographic updates to the organization's Patrol Map, ensuring its accuracy and relevance for field operations. This updated map has been downloaded from the Avenza Map Store and is actively used in the field by over 300 Midpen staff and external partners.-Empowering Staff with GIS Training and ExpertiseI conducted monthly GIS trainings, providing hands-on guidance and instruction on the use of internal GIS web applications. These training sessions have empowered staff to effectively utilize GIS tools in their daily work.-Leadership in Data Collection and CASME GroupFor three consecutive years, I led the District's Collector Asset Subject Matter Expert (CASME) group, overseeing a team responsible for presenting, training, and data collection initiatives. This group has been instrumental in producing hundreds of new data points for the agency, significantly enhancing the organization's spatial data repository.

Los Altos, California, United States

-Supporting the GIS Team with map requestsFulfilled map, data, and analysis requests from all departments within the organization. My expertise in GIS and cartographic design enabled me to provide accurate, timely, and visually appealing maps that informed decision-making across the organization.-Creating and Updating MapsI demonstrated my cartographic expertise by creating and updating maps of District preserves, adhering to established cartographic practices and incorporating detailed mapping elements. These maps served as valuable tools for staff and the public to understand projects and preserves.-Collaborating on an Interactive Public Story MapI actively collaborated with the planning department to publish the Bear Creek Redwoods interactive public Story Map, which showcases the District's efforts to preserve this iconic redwood forest. This Story Map, featured in ESRI's Story Map Gallery, provides an engaging and informative platform for the public to explore the area's natural beauty and learn about conservation efforts.

Burlingame, California, United States

-Supporting Public Works with GIS requestsI supported the Public Works Department in maintaining and updating critical infrastructure data. I have consistently fulfilled data update requests for parcels, utilities, and water infrastructure, ensuring that the department has access to accurate and up-to-date information for planning and maintenance purposes.-Created a Zoning Map BookI updated the city's zoning GIS layer and utilizing data-driven pages to create a comprehensive 58-page city zoning map book for the planning department. This detailed map book provides an invaluable resource for planners and developers.Streamlining Field Data Collection with ArcGIS Field MapsTo streamline field data collection for trees and street furniture, I developed ArcGIS Online web maps, providing field crews with easy access to maps and data collection tools. -Creating a Public-Facing Story Map for Project TransparencyI created of one of the city's first public-facing Story Maps, titled "Projects around town." This interactive Story Map allows residents to easily track the status of various city projects, fostering a sense of community involvement and accountability.

Redwood City, California, United States

Master'S Degree, Urban And Regional Planning

Bachelor'S Degree, Sociology