2018 - Migrando Sistemas de Geoinformação para Software Livre na Polícia Federal

DANIEL ARAUJO MIRANDA (Polícia Federal)
https://doity.com.br/foss4gisgov

1. Migrating geographic information
systems to open source in the
Brazilian Federal Police

2. Inteligeo
●Is a system created by the Brazilian Federal Police
●Focus on providing experts with data to produce forensic
reports
●Is part of a larger initiative that involves training,
procurement and services for the entire Federal Police
●Is managed by AGEO/INC/DITEC/PF

3. Inteligeo
●Since 2009
●Centralized raster and vector database
●Support data for forensic reports
–Imagery
–Vector data
●Tools for searching, processing and displaying the
data
●Administrative information overlays

4. Sponsors
●JICA
–Initial investment, consulting, training. Long term success commitment.
–ALOS project (Jica President Award – best 4 projects in the world)
●FINEP
–Research on open source software usage
–ISPRS2012 (2 articles)
–EAFS2012
–Foss4g 2011
–Foss4g 2014 (2 presentations)
●UNODC
–PEQUI – Drug “DNA”
–SIGMA – Marijuana GIS
●DITEC – INC
–Personnel, equipment, infrastructure, operations, continued support.

8. Migration to FOSS
●We have been migrating since 2010
●Why change to FOSS?
–Strategic control of data
–Infrastructure integration
–Lifecycle cost
–Strategic control of software
–Technical superiority

9. Starting point
●Sponsored by JICA
●Built following a model from IBAMA's SISCOM
●Stack:
–CentOS
–ArcSDE on PostgreSQL
–ArcGIS Server
–Web application based on ESRI's FlexViewer
–Administration using ArcGIS Desktop

10. Step 1 (circa 2012)
●Migrate database to plain PostgreSQL+Postgis
●Rebuild all ArcGIS project files to point to that
–Esri support helped us make a direct connection without SDE
●Relinquish any compatibility guarantee
●Work around the caveats
–Long field names
–Unsupported field types
–ArcGIS' attempts to change the database upon connection
–Necessary to build views for some tables

11. Step 2 (2013-2014)
●Implement functionality that was previously being held back by the
database
–Integration with the forensic reports system
–Daily uploads of other institutions data
–Protocols for loading the image catalog footprints and metadata
–Protocols for producing geoprocessing products directly on the database
●Train people to use QGIS
●Write a script for automatic QGIS configuration
●wiki.osgeo.org/wiki/Brazilian_Coordinate_Reference_Systems

12. Step 3 (2015 - 2017)
●Develop a new web interface using only open source
code
●Choose a new open source middleware
–QGIS Server (great styling)
–Mapserver (great speed)
–Geoserver (great functionality)
–I3GEO/Mapserver (great user base in our government)
●We picked Geoserver mainly because of
authentication and ease of management.

13. What is new?
●Inteligeo 4.0 and 4.1 web interfaces
●Wiki web portal for documentation
●Geoserver implementation
●Initial tests for storing restricted data
●Huge image contract
●Providing image request services
●Creation of the Geomatics Area of the National Institute of Criminalistics
●Lots of work on migrating 850 layer styles to Geoserver (grind on the REST
api, geoserver bugs, hierarchy, metadata)
●Lots of Qgis training (10 courses in 2 years)
●Foss4g 2018 – Dar Es Salaam: redo half of the work on Geoserver

15. [usage reports]
[qgis configuration]
[forensic reports]

16. Next steps
●Finish Geoserver migration
●Decomission ArcGis Server
●Add features to Inteligeo 4.1
●Metadata overhaul
●Database overhaul
●New data warehousing protocols
●INDE publication
●Cleanup code for open sourcing
●New facilities for the team

29. Migrating geographic information systems to open source in the
Brazilian Federal Police
Presentation delivered on 2018-09-19 at the FOSS.4GIS.GOV conference at IBAMA
Daniel Araújo Miranda
Perito Criminal Federal
AGEO/INC/DITEC/PF
Instituto Nacional de Criminalística
Polícia Federal
Brasília - DF
miranda.dam at dpf.gov.br