BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-2024//talk//3MTN3L
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-3MTN3L@talks.staging.osgeo.org
DTSTART;TZID=-03:20241206T160000
DTEND;TZID=-03:20241206T163000
DESCRIPTION:The Geological Survey of Brazil (SGB) is under a digital transf
 ormation process. One of the pillars of this process involves speed\, scal
 ability\, security and availability of data produced. Furthermore\, CPRM i
 s creating a favorable environment for the adoption of cloud-based archite
 cture.\n\nThis paper aims to present an overview of a new developed Geolog
 ical Spatial Data Infrastructure for the SGB. The GeoSGB is the main sourc
 e for internal mapping\, infographic and dashboard applications. It will a
 ssimilate legacy services\, that runs on isolated map servers\, such as se
 lf hosted node of OneGeology OGC Services.\n\nThe solution adopted is GeoN
 ode 4.2\, which brings together map\, data services\, metadata catalog and
  spatial database. It is free and open source software with a very active 
 community. In addition\, GeoNode has a good content management system\, a 
 rich API\, and it’s fully customizable. To meet data access demands\, it
  was customized to run in Kubernetes-based environments and each mapped ar
 ea produces its own geoservice\, exportable to different formats\, such as
  shapefile and geotiff.\n\nHowever\, it became necessary a complete separa
 tion between the production and publishing environments. SGB’s productio
 n pipeline is composed by internally developed data management software. S
 ome of these systems are being modernized\, with updates on business rules
 \, frameworks and security. GIS work is carried out in ArcGIS Enterprise®
 \, with some exceptions in QGIS and GeoServer. With this background\, it s
 hould be considered as a hybrid GIS model.\n\nAbout database structures\, 
 a process of harmonization was necessary\, mainly those produced from prop
 rietary GIS. For legacy reasons\, the proprietary structures were maintain
 ed\, as long as possible to export to OGC WKT or WKB. Exported geometries 
 are analyzed for compliance with Simple Features Standard (OGC/ISO19125). 
 The information eligible for publication were consolidated in database vie
 ws and is literally replicated to GeoSGB\, by script.\n\n\nThe metadata pr
 oduction for continuous databases is carried out semi-automatically – te
 mplated - in accordance with the mapping program. This is possible by inte
 grating GeoNode's APIs with internal databases\, delivering associated met
 adata and resources directly to the authors. The contact with (meta)data a
 uthors were managed by GeoNode.\n\nThe symbolization of thematic layers in
 volved the development of interoperable libraries\, based on SVG glyphs in
 serted in OpenType fonts (ISO/IEC 14496-22:2007)\, with near equal renderi
 ng among different multi-platform GIS software.\n\nData and metadata pipel
 ines were implemented using Python scripts\, with specific libraries assoc
 iated with GeoNode APIs. Apache Airflow manages the entire process of extr
 acting internal bases\, quality tests\, structure analysis and loading on 
 the GeoSGB database server\, including being responsible for notification 
 activities.\n\nSo\, GeoSGB now is a continuous development platform\, with
  focus in increase quality in delivered data to customers.\n\nThe future p
 erspectives involve the transformation itself into research line in geotec
 hnologies and high-performance IT services. It shoud envolve plug-in devel
 opment for data management\, processing and visualization including use of
  artificial intelligence. In operational terms\, adoption of OGC APIs\, da
 ta internationalization and harmonization\, associated with adoption of OG
 C specific standards\, such as GeoSciML and WaterML contributes to become 
 SGB a global supplier of geoscientific data.
DTSTAMP:20260504T204155Z
LOCATION:Room I
SUMMARY:OpenGeoSGB: State of the art of Transition to an Open Source\, semi
 -automated\, FAIR-ready Geological Spatial Data Infrastructure of the Geol
 ogical Survey of Brazil - Carlos Eduardo Mota
URL:https://talks.staging.osgeo.org/foss4g-2024/talk/3MTN3L/
END:VEVENT
END:VCALENDAR