BEGIN:VCALENDAR VERSION:2.0 PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2024//talk//Y8DPZC BEGIN:VTIMEZONE TZID:-03 BEGIN:STANDARD DTSTART:20000101T000000 RRULE:FREQ=YEARLY;BYMONTH=1 TZNAME:-03 TZOFFSETFROM:-0300 TZOFFSETTO:-0300 END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:pretalx-foss4g-2024-Y8DPZC@talks.staging.osgeo.org DTSTART;TZID=-03:20241206T140000 DTEND;TZID=-03:20241206T143000 DESCRIPTION:To showcase the application of free and open-source software (F OSS) in the census cartography works produced within the scope of the Braz ilian Institute of Geography and Statistics (IBGE). \n\nCurrently linked t o the Ministry of Planning and Budget\, IBGE is a federal public administr ation entity. Since its foundation in 1936\, it has become the main provid er of data and information in the country\, meeting the needs of various s egments of civil society as well as federal\, state\, and municipal govern ment entities. Its institutional mission is "to portray Brazil by providin g the information required to the understanding of its reality and the exe rcise of citizenship". To achieve this\, it identifies and analyzes the te rritory\, counts the population\, shows economic evolution through people ’s work and production\, while also revealing how they live. \n\nTo supp ort this purpose\, IBGE maintains the Territorial Base (TB)\, a spatial in formation system supporting the operations of collection\, processing\, an alysis\, tabulation\, charts\, cartograms\, and publications of its survey s and censuses. It is also used for evaluations of population estimates by identifying\, monitoring\, and representing the evolution of the territor y\, mainly through the development of its census sector network. \n\nThe T B consists of a graphical base of georeferenced information representing t erritorial structures\, census tracts (called sectors) and other elements. These structures can be legal\, such as the political-administrative divi sion\; analytical\, linked to territorial patterns or specific population groups\; or operational\, intended to guarantee access to and coverage of census units. \n\nAmong the territorial structures that comprise the TB\, the census sector underpins the operational organization of censuses and s ome sample surveys. It is a territorial interview collection unit whose si ze and number of households and establishments allow the census taker to c omplete their activities within a specified timeframe. Moreover\, it is th e basic unit for disseminating census information\, allowing public access to statistical results at the smallest spatial range. \n \nIn mid-2014\, IBGE was moving from a data update model based on a complete review conduc ted just before a census operation to a continuous update model\, which wa s more complex and required more agile tools and systems for operators. At that time\, however\, the software used by the TB was commercial\, with t he update and customization processes for the entity's specific objectives being slow and difficult\, as they were tied to contracts with the suppli er. This represented a considerable\, often prohibitive\, expense for publ ic coffers. \n\nConcurrently\, a staff of analysts had formed within IBGE \, coming from civil service exams held in previous years for specialized technical jobs. These servers had two synergistic qualities: methodologica l knowledge of the activities performed by the institution\, and some had technical capabilities in systems development. \n\nGiven the scenario\, it became feasible to explore an internal alternative for TB update activiti es. Such a system should meet these technological premises: \n\nBe based o n a free platform without licensing costs\, preferably with an open-source codebase to avoid future dependencies\; \n\nOperate with low computationa l and network requirements to meet the diverse realities of users\; \n\nBe fully customizable to adapt to the needs of the TB and IBGE. \n\nGiven su ch requirements and considering the technical knowledge and stage of evolu tion of geoprocessing tools at the time\, the system was defined as an ext ernal plugin for QGIS (using pyQGIS API) with a graphical interface modele d in Qt framework (using pyQt API). \n\nThe Geographic Information System for the Territorial Base (SIGBT)\, therefore\, is the technological soluti on that emerged in 2014. Its conception\, implementation\, and homologatio n stages were always characterized by constant collaborative development\, where TB technicians and related areas of IBGE could participate and cont ribute in several ways\, from signaling problems to suggesting improvement s and even writing the code itself. The development of SIGBT was designed modularly\, to meet the methodological and conceptual priorities defined b y IBGE. \n\nIts code was primarily written in Python\, and the handled dat a is managed by an SQLite database (with SpatiaLite extension)\, made avai lable to internal users for download and offline editing from a versioned Git repository. \n\nAmong the main procedures performed by SIGBT are the g raphical operations on census sectors (divisions\, aggregations\, adjustme nts\, and ensuring comparability between previous sector grids) and intra- sector layers (localities\, roads\, blocks\, and block faces). It also ens ures the topological and methodological consistency of the edits made. Add itionally\, the production of maps used in census operations is carried ou t on SIGBT. \n\nSince the advent of SIGBT\, three major data update cycles aimed at census operations have been conducted using the system: the 2015 Population Count (which was eventually canceled)\, the 2016 Census of Agr iculture\, and the 2022 Demographic Census (which prompted two update cycl es due to two postponements). \n\nCurrently\, SIGBT is in use at the IBGE Coordination of Territorial Structures\, in all 27 State Superintendencies \, and in most of its over 560 agencies. It comprises about 50 specific fu nctions that automate processes\, facilitate edits\, and enable the contin uous updating of the TB. The system also integrates information from other databases from different areas that interact with the TB\, enabling integ rated editing and visualization of all data\, thus facilitating the constr uction of territorial occupation indicators at the national level. \n\nLoo king towards the future of SIGBT\, the development of new modules for publ ic access is being considered. It is projected that these modules will lev erage QGIS navigation resources to offer citizens easier and quicker acces s to geographic data published by IBGE. \n\n \n\nFinal Considerations \n\ nThe explanation above showcases\, through IBGE's experience with SIGBT\, the feasibility of using a free software architecture for complex geograph ical projects with a wide range of geographic applications. \n\nFrom a bu dgetary perspective\, the superiority of free software was also verified\, as SIGBT has contributed estimated savings that would exceed six figures since its creation\, solely from software licensing that is no longer used . \n\nThe SIGBT initiative\, therefore\, presents itself as a successful e xample of a system based on free and open-source software\, developed by p ublic administration\, showing that the use of this type of structure is n ot only viable but desirable. DTSTAMP:20260428T053618Z LOCATION:Room III SUMMARY:Use of Open-Source Software in Census Cartography Production - IBGE 's Case - Fabiano Saraiva\, Ivan Lonel\, Lucas Halberstadt da Rosa\, Carlo s Eduardo Cagna URL:https://talks.staging.osgeo.org/foss4g-2024/talk/Y8DPZC/ END:VEVENT END:VCALENDAR