BEGIN:VCALENDAR VERSION:2.0 PRODID:-//pretalx//talks.osgeo.org//foss4g-europe-2026//talk//VJT8JW BEGIN:VTIMEZONE TZID:EET BEGIN:STANDARD DTSTART:20001029T050000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10 TZNAME:EET TZOFFSETFROM:+0300 TZOFFSETTO:+0200 END:STANDARD BEGIN:DAYLIGHT DTSTART:20000326T040000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3 TZNAME:EEST TZOFFSETFROM:+0200 TZOFFSETTO:+0300 END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT UID:pretalx-foss4g-europe-2026-VJT8JW@talks.osgeo.org DTSTART;TZID=EET:20260630T124500 DTEND;TZID=EET:20260630T125000 DESCRIPTION:Spatially explicit biogas potential assessment requires integra ting land cover dynamics\, agricultural census records\, livestock invento ries\, and municipal waste generation data into a unified analytical frame work. In most national contexts\, each of these dimensions is maintained b y a distinct government agency operating at incompatible spatial resolutio ns\, under divergent update schedules\, and without a shared classificatio n ontology. The result is not data absence but institutional fragmentation \, and fragmentation is a structurally different problem from scarcity: th e data exists\, is publicly available\, and is updated regularly\, but no coordinating infrastructure connects it into an analysis-ready form. This distinction has direct consequences for platform design. A system built to address data scarcity aggregates and estimates\; a system built to addres s institutional fragmentation must integrate\, reconcile\, and make the re conciliation process itself transparent and reproducible.\nPILAR-2b (Plata forma Inteligente de Localização e Aproveitamento de Resíduos para Biog ás e Bioprodutos) is an open-source spatial decision-support platform dev eloped at CP2b/NIPE-Unicamp\, Brazil\, to produce municipally disaggregate d biogas potential estimates for São Paulo State's 645 municipalities thr ough a reproducible pipeline that treats data integration as a primary com putational challenge rather than a preprocessing step. The platform integr ates five heterogeneous government datasets: IBGE agricultural census reco rds\, SNIS municipal waste inventories\, MapBiomas 30-metre land cover ras ters\, ANEEL energy infrastructure layers\, and CETESB environmental licen sing records. These sources present four structurally distinct incompatibi lities: administrative unit definitions differ across agencies\; coordinat e reference systems require transformation to SIRGAS 2000 UTM Zone 22S\; u pdate cycles range from annual to decennial\; and feedstock classification schemes lack a common ontology across sources. The data integration pipel ine resolves each incompatibility through a fully scripted\, version-contr olled transformation chain implemented in Python with GeoPandas\, Shapely\ , and Fiona\, with no manual reconciliation steps at any stage. Every tran sformation from raw institutional input to analysis-ready geospatial layer is traceable\, independently executable\, and documented in a public repo sitory under GPL 3.0.\nThe platform architecture follows a three-tier micr oservices model\, separating presentation\, application logic\, and data p ersistence into independently deployable cloud components. The presentatio n layer is implemented in Next.js 15 with Mapbox GL JS vector tile renderi ng\, enabling simultaneous display of all 645 municipal polygons with sub- second pan-and-zoom response without requiring a client-side GIS installat ion. The application layer is built on FastAPI 0.104.1 with an asynchronou s Python runtime\; NumPy vectorization across all municipalities reduced p er-request computation time from approximately 8.2 seconds with sequential iteration to 0.9 seconds with vectorised batch processing. The persistenc e layer operates on PostgreSQL 15 with PostGIS 3.4\, hosted on Supabase\, with full operational costs ranging from zero to fifty US dollars per mont h\, depending on demand\, a range considered accessible for public sector and academic deployment without proprietary licensing.\nIntegrated feedsto ck inventories enter a correction factor methodology that decomposes theor etical biomass availability into practical mobilisable potential through f our sequential\, feedstock-dependent factors: collection efficiency (FC)\, competing uses (FCo)\, seasonal availability (FS)\, and logistical constr aints (FL). Each factor is independently parameterised per feedstock categ ory across 30 feedstock types in four sectors: agriculture\, industry\, li vestock\, and urban waste. The FC times FCo times FS times FL multiplicati on produces a transparent audit trail from gross theoretical potential to practically actionable municipal estimates\, enabling factor-specific sens itivity analysis that is structurally unavailable in single-factor yield a pproaches\, where corrections are embedded rather than decomposed.\nApplie d to São Paulo State's 645 municipalities\, PILAR-2b quantifies a theoret ical biogas potential of 133.82 million m³ CH4/day from consolidated feed stock inventories\, reduced to 19.69 million m³/day practical mobilisable potential through sequential correction factor application\, representing a 14.7% weighted average retention that encodes binding regulatory and lo gistical constraints directly in the correction structure. Spatial analysi s reveals that 25.1% of municipalities account for 67.0% of the state's pr actical potential\, a four-order-of-magnitude spread across the municipal distribution that confirms that state-level aggregation is analytically in sufficient for infrastructure investment decisions and that municipal-reso lution outputs constitute a structurally distinct planning information pro duct. Cross-validation against the 2025 São Paulo biomethane roadmap (Ins tituto 17\, PSR\, and Amplum Biogás\, published by FIESP) yields a mean a bsolute error of 13.2%\, approaching the 15-20% performance range document ed for the DBFZ Biomass Monitor operating under substantially denser Europ ean data conditions. All primary analytical workflows are complete within sub-3-second response times under 50 concurrent users in production condit ions.\nThe data incompatibility challenges resolved by this pipeline\, inc luding misaligned administrative units\, divergent update cycles\, and abs ent cross-agency classification standards\, recur structurally wherever po licy-relevant energy assessments depend on combining institutionally separ ated government sources. The São Paulo deployment demonstrates that these challenges are tractable within a fully open\, browser-accessible stack a t operational costs within reach of public institutions. PILAR-2b is desig ned for direct replication in any national or subnational context where Ma pBiomas-equivalent land cover data\, agricultural census records\, and mun icipal waste inventories achieve sufficient completeness\, a condition alr eady met across multiple Brazilian states and increasingly across Latin Am erican\, African\, and Southeast Asian contexts where open satellite and c ensus data are advancing faster than institutional coordination. The resul t is not a regional tool but a methodological blueprint: an open geospatia l integration architecture replicable wherever fragmented data governance\ , not technical capacity\, is the binding constraint on evidence-based ene rgy planning. DTSTAMP:20260605T011258Z LOCATION:A01 SUMMARY:PILAR-2b: An Open Geospatial Pipeline for Biogas Potential Assessme nt in Institutionally Fragmented Data Environments - Lucas Nakamura Cerejo URL:https://talks.osgeo.org/foss4g-europe-2026/talk/VJT8JW/ END:VEVENT END:VCALENDAR