BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2024//talk//ZNHXX8
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-ZNHXX8@talks.staging.osgeo.org
DTSTART;TZID=-03:20241206T163000
DTEND;TZID=-03:20241206T170000
DESCRIPTION:In 2015\, the City of São Paulo launched GeoSampa\, a platform
  providing access to a variety of cadastral data\, maps\, satellite images
 \, and information on zoning\, land use\, urban infrastructure\, land subd
 ivision\, and public areas for both municipal technicians and the general 
 public. GeoSampa serves as a data repository\, allowing different departme
 nts to share their information and keep it updated on the platform. A nota
 ble example is the Licensing Department\, which in 2015 presented a geogra
 phic database solution using open-source software\, with Linux\, Postgres\
 , PostGIS\, Python\, and QGIS\, for land subdivision processes. These init
 iatives solved major problems and streamlined work processes\, highlightin
 g the importance of a data-sharing culture among public agencies for urban
  development.\nThe work developed by the Licensing Department was summariz
 ed in the experience cataloged by CEBRAP in a program called COPI-COLA\, w
 hose content can be seen in full on the CEBRAP website  https://cebrap.org
 .br/wp-content/uploads/2023/09/Guia_5.pdf. This program adopted an innovat
 ive approach by using open-source software to develop and maintain the sys
 tem\, significantly reducing implementation costs and making team work mor
 e efficient and integrated. Other areas also benefited from the organized 
 and available information on GeoSampa\, serving as an example for public a
 gencies across the country.\nThis work specifically aims to show two techn
 ical examples of codes used in the Geographic Database mentioned above\, w
 hich I developed\, highlighting the practical benefits of collaboration an
 d technological innovation in the public sector using open-source software
 .\nExample 1\nAccording to Ordinance No. 957/GC3 of 2015\, issued by the B
 razilian Aeronautics Command (COMAER)\, guidelines are established for the
  creation and management of Airport Protection Zones (ZPA). The objective 
 is to ensure the safety and efficiency of air operations by preventing obs
 tacles and activities that could interfere with air navigation. The ordina
 nce details the competencies of municipalities and other bodies in monitor
 ing and controlling these areas\, as well as defining specific restriction
 s for land use near airports.\nDue to the large volume of licensing reques
 ts\, if all enterprises were subject to DECEA's evaluation\, there would b
 e a need to increase DECEA's team\, resulting in approval delays. To mitig
 ate this problem\, the implementation of a geographic system\, to be used 
 by the City of São Paulo\, could select only cases in regions where DECEA
 's action was necessary.\nA system using Linux\, Postgres\, PostGIS\, and 
 QGIS was developed by the department's technicians with validation from DE
 CEA's technicians. This optimized processes\, reducing DECEA's workload an
 d shortening approval times. Our objective is to briefly present how this 
 system was developed and its impact on time savings and information securi
 ty.\nExample 2\nThe work consisted of creating an algorithm to comply with
  Article 131 of Law No. 16.402/2016. "The use of properties\, for the purp
 oses of land subdivision\, use\, and occupation discipline\, is classified
  as permitted or not permitted and as compliant or non-compliant. § 2º U
 se not permitted in the location is that which cannot be implemented or in
 stalled on the property due to the zone and the street width." Street widt
 h is defined as the distance between property alignments\, including the c
 arriageway and public walkway.\nWe used the cartographic bases of the City
  of São Paulo\, surveyed in 2004\, for geoprocessing. The tool used was t
 he QGIS software (Geographic Information System - GIS)\, the official proj
 ect of the Open Source Geospatial Foundation (OSGeo). The Licensing and Ur
 ban Development Department's (SMUL) database on street widths at the time 
 (2018) covered between 35% and 40% of the city's streets. The database had
  low reliability\, as measurements were taken randomly at three different 
 points on the street segment\, making it visually impossible to pinpoint w
 here the width is smallest\, thus preventing proper application of the abo
 ve law. Measurements not included in this database would be taken in loco 
 by subprefecture technicians and sent to the Licensing Department's Cadast
 re Division for completion. This database gathered measurements taken over
  time and was not available to the public.\nThe work presented here was de
 veloped using scripts in PyQGIS\, which combines the Python programming la
 nguage with QGIS APIs\, allowing for automated geometry tracing. The creat
 ed code used all street segments and traced all elevations from the nodes 
 created in the block layers\, choosing the minimum elevation. This work do
 es not eliminate the need for in loco measurements\, but like in Example 1
 \, selects the necessary cases\, significantly reducing the number of visi
 ts and increasing reliability for proper law enforcement.\nConclusion\nThe
  success of GeoSampa and associated projects reveals that using open-sourc
 e tools promotes transparency and accessibility of geographic information\
 , strengthening citizen participation and facilitating urban planning\, ma
 king cities smarter and more sustainable.\nAs a developer of this project\
 , I feel immense pride in having contributed to this digital and technolog
 ical transformation in public administration. Seeing the positive impact o
 f our work is extremely gratifying.\nUltimately\, São Paulo's example can
  inspire other cities to adopt similar practices\, contributing to a futur
 e where technology and innovation serve efficient and inclusive urban deve
 lopment. Thus\, the cartographic transition from map library to geoprocess
 ing marks a new era in public administration\, where geographic informatio
 n is a valuable resource for decision-making and improving quality of life
  in cities.
DTSTAMP:20260509T220447Z
LOCATION:Room III
SUMMARY:Cartographic Transition: From Map Library to Geoprocessing - Explor
 ing the Codes Behind the Project. A Model for Public Agencies - Sylvia Reg
 ina Rodrigues Damiao
URL:https://talks.staging.osgeo.org/foss4g-2024/talk/ZNHXX8/
END:VEVENT
END:VCALENDAR