Bartosz Brzeziński
Bartosz Brzeziński is a Senior Geospatial Data Steward at Bayer, where he is responsible for managing spatial data and developing solutions utilizing GIS technology. With a strong background in geospatial analysis, Bartosz plays a important role in enhancing data-driven decision-making processes within the organization.
Prior to his current position at Bayer, Bartosz worked as a GIS Analyst at UBS, where he provided analytical support to financial analysts. His expertise in geospatial data analysis allowed him to contribute valuable insights that informed investment strategies and financial assessments.
In his earlier career, Bartosz focused on supporting investment processes in the renewable energy sector, specifically working with GIS applications related to wind turbines and small hydropower plants. His experience in this field has equipped him with a deep understanding of the intersection between geospatial technology and sustainable energy solutions.
In his free time, Bartosz shares his passion for GIS by conducting training sessions focused on the use of Open Source technologies. His commitment to education and knowledge sharing reflects his dedication to advancing the field of geospatial analysis and empowering others to leverage GIS in their work.
Sessions
In the era of precision agriculture, the ability to effectively manage and analyze spatial data is crucial for ensuring sustainable farming practices and optimizing crop yields.
This presentation will delve into the innovative use of Open Source technologies, specifically PostgreSQL with PostGIS and GeoServer, within the Spatial Yield Program in Bayer Crop Science's global field trials.
The primary objective of this project was to establish a robust data pipeline that facilitates the rapid delivery of critical information to end-users. This data is essential for assessing the quality and performance of various corn and soybean varieties, enabling agronomists and farmers to make informed decisions based on real-time insights.
By leveraging PostgreSQL and PostGIS, we harnessed the power of spatial databases
to efficiently store, manage, and query large datasets exceeding 1TB of high-precision data collected by planters and combines. Meanwhile, GeoServer enabled seamless integration and visualization of this data through web services, serving up to 75 million requests per day internally.
One of the significant technical challenges we faced was the need to ensure that the data delivery process was not only swift but also reliable, allowing users to access and analyze data without delay.Our solution involved the development of a streamlined pipeline that automates data processing and integrates multiple data sources, ensuring that users receive timely updates on crop performance metrics.
This presentation will highlight the methodologies including AWS services, Apache Kafka and K8S crons employed in the project, the challenges encountered, and the solutions implemented.
We will also discuss the impact of our work on the decision-making processes within the agricultural sector and how Open Source technologies can empower organizations to harness the full potential of spatial data.
The primary objective of the program is to assist growers in identifying the best products for their farms by rigorously testing products across diverse environments to determine the most effective solutions tailored to each specific context, as well as the management practices that yield optimal results.