BEGIN:VCALENDAR VERSION:2.0 PRODID:-//pretalx//talks.osgeo.org//foss4g-2026//talk//BEL77U BEGIN:VTIMEZONE TZID:JST BEGIN:STANDARD DTSTART:20000101T000000 RRULE:FREQ=YEARLY;BYMONTH=1 TZNAME:JST TZOFFSETFROM:+0900 TZOFFSETTO:+0900 END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:pretalx-foss4g-2026-BEL77U@talks.osgeo.org DTSTART;TZID=JST:20260902T170000 DTEND;TZID=JST:20260902T173000 DESCRIPTION:The Mineral Research and Production Support Platform (P3M) was conceived and is being implemented by a team of specialists from the Geolo gical Survey of Brazil (SGB). with the support and participation of public and private entities directly or indirectly related to the Brazilian mine ral industry\, such as: Secretariat of Geology\, Mining and Mineral Transf ormation (SGM) of the Ministry of Mines and Energy (MME)\; National Mining Agency (ANM)\; Agency for the Development and Innovation of the Brazilian Mineral Sector (ADIMB)\; Brazilian Association of Mineral Research and Mi ning Companies (ABPM)\; National Association of Aggregate Producers for Co nstruction (ANEPAC)\; Brazilian Institute of Geography and Statistics (IBG E)\, and Brazilian Mining Institute (IBRAM).\n\nThe core development of P3 M is being carried out by the UFLA (Federal University of Lavras) Agency f or Innovation in Geotechnologies and Intelligent Systems (Zetta). Launched in late 2022\, the Platform's main objective is to increase the attractiv eness of investments and promote the sustainable development of the minera l industry\, through the integration of data on mineral potential\, infras tructure\, costs\, legislation\, protected areas\, and socioeconomic indic ators of Brazil.\n\nIt has a crucial role in planning mineral research and production\, generating qualified knowledge that is essential to support strategic decisions in both the public and private sectors. For industries and investors in the mining sector\, the data available on the Platform c ontribute to supporting development plans and the exploitation of mineral deposits. Government entities also benefit primarily from information for monitoring the competitiveness of mineral research and production\, thereb y promoting greater attractiveness of investments for national development .\n\nIn short\, P3M provides information free of charge through two main e nvironments: (i) a map and data viewer that integrates geoscientific\, eco nomic\, environmental and legal information\, mining rights\, among others \, from various national and governmental entities\; and (ii) a dashboard system with statistical data presentation\, with filters by territorial un it (e.g.\, region\, state\, or municipality) and commodity.\n\nOne of the main differentiators of the P3M platform\, among the various software prod ucts of SGB\, is its complete conception and development using FOSS4G. The main objective of this work is to present the solution architecture used in the development\, focusing primarily on the use of FOSS4G projects. In early February of this year\, version 2.4.4 was released\, with several im provements in terms of user experience and performance.\n\nThe platform de ployment is entirely container-based\, provisioned in a Kubernetes environ ment using Helm Chart\, and data storage relies on PostgreSQL 14 databases with PostGIS 3.4. In general terms\, the P3M Platform can be subdivided i nto three main components: (i) map and dashboard visualization system\, (i i) data pipeline orchestration\, and (iii) spatial data infrastructure.\n\ nThe map and dashboard applications are deployed in two container images: the first\, a backend project with Django + Rest framework\, brings a syst em of REST APIs to define the content controls for the maps and dashboards . The application also has an administrative interface so that content man agers can modify the application's behavior and the list of available laye rs and groups. The front-end component is a TypeScript application that re lies on libraries such as OpenLayers to render the layer tree\, delivered by the backend\, and the dashboard data.\n\nThe data pipeline orchestratio n environment was deployed from a custom Apache Airflow container image\, supplemented with libraries such as GDAL\, GeoPandas\, and Apache Arrow/Pa rquet.\n\nFor P3M\, some data pipelines were developed to collect data of mining processes and financial compensation – available from the Nationa l Mining Agency (ANM). This data\, originally delivered in spreadsheets an d File Geodatabases\, is sanitized\, enriched\, and transformed using GDAL \, and finally saved in proprietary PostgreSQL/PostGIS tables of active mi nes\, commodity associations\, and mining process statuses. Currently\, th ese pipelines run on Mondays\, Wednesdays\, and Fridays and are crucial fo r maintaining the dashboards and authorial layers.\n\nThe provision of map s and metadata on P3M strictly follows the use of OGC Open Web Services st andards\, such as WMS\, WMTS\, and WFS\, and the platform consumes maps an d metadata from a GeoNode installation owned by the SGB\, in order to fulf ill the role of Spatial Data Infrastructure.\n\nThe SGB’s GeoNode was de ployed to a production environment in late 2025\, initially to support thi s platform. Prior to this GeoNode\, P3M had a dedicated GeoServer instance in its own workspace to serve the maps. After going into production\, all layers and configurations were moved to this GeoNode. Currently\, about 3 20 vector and raster layers from various Brazilian government data sources are cataloged and registered. Initially\, this data was organized and cle aned to create a database that was placed as a datastore in GeoNode's GeoS erver.\n\nThe option of hosting duplicate data instead of consuming OGC se rvices from other institutions was chosen due to the need to have this dat a available on the platform\, even if the source provider is unavailable\, in addition to the geological service having a robust IT infrastructure. The P3M authorial layers are also hosted on GeoNode\, but directly from th e exposure of the spatial tables to the GeoNode Geoserver. Some of these t ables\, such as mineral resource data and systematic mapping\, are also fe d from pipelines in Airflow.\n\nFinally\, the P3M Platform\, since its con ception\, has always been guided by the use of free and open-source librar ies and frameworks to ensure transparency and interoperability. Alongside major FOSS4G projects\, P3M stands out among the select group of data and service providers applied to Geology and Mining sectors by adopting framew orks that are free from restrictive licensing and bundled sales practices. The application is publicly available at https://p3mgeo.sgb.gov.br/. DTSTAMP:20260717T225801Z LOCATION:Cosmos1 SUMMARY:A case use of FOSS4G to promote the Mining Industry: The P3M Platfo rm of the Geological Survey of Brazil. - Carlos Eduardo Mota URL:https://talks.osgeo.org/foss4g-2026/talk/BEL77U/ END:VEVENT END:VCALENDAR