Show filters Hide filters

Refine your search

Publication Year
1-2 out of 2 results
Change view
  • Sort by:
24:34 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2014
Found in:

Inteligeo - Geographic Intelligence System in the Brazilian Federal Police

This is a case study about using WebGIS for fighting crime from a forensics standpoint.When one thinks about GIS for law enforcement, vehicle tracking and messaging immediately comes to mind. Inteligeo provides support for law enforcement in a different manner: it provides information for the forensics examiner.The system became operational in November 2010 and it now has more than 850 themes and 950 data visualization layers, and is available only inside of the Brazilian Federal Police internal network. It started as tool for fighting environmental crime, now it covers a wide variety of subjects such as environmental data, chemical analysis of pesticides, mining operations, public works fraud and legal status of rural properties. We also have a raster data repository and integration with databases from several institutions.The system uses a fully open source database. After a difficult migration from a proprietary database, the data can now be handled not only by the proprietary GIS framework, but also by tools from the open source ecosystem and by our own maintenance tools.During almost four years of operations, some lessons have been learned and the initial strategic plans have changed. We will discuss issues such as what can be outsourced and what has to be made in house, decisions regarding the database, experimenting versus focusing, key features (our) users use most, demonstrating value to internal management.
  • Published: 2014
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
20:44 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2014
Found in:

Crazy data: Using PostGIS to fix errors and handle difficult datasets

Inteligeo is a system that stores a lot of information used by the Brazilian Federal Police Forensics to fight crime, initially in the environmental arena with a later expansion to other types of crime. During the construction of the database a lot of problems appeared for which PostGIS was the key to the solution.This presentation describes problems encountered by the team while loading 850+ shapefiles into the database, linking with external databases and building 950+ views of the data.Although the content of the recipes is very technical, the general concepts will be explained in an accessible language and correlated to real world cases.Topics:*Definition of crazy data in our context*Quick recipes- Spike removal- Invalid geometry detection and fixing- Filling holes- Raster image footprints- Hammering data into correct topologies- Speeding data visualization with ST Simplify and PGSQL 9.3's materialized views- Rough georeferencing using an auxiliary table- Creating constraints*How is crazy data generated and our experience in handling each case- Large datasets- Lack of validation- Reprojection- Geometric operations- Topological errors- Imprecise definitions- Legacy databases- Bad georeferencingWe will also discuss why is handling crazy data important for the Brazilian Federal Police, our efforts in cleaning up data at the source and the implications of geographical data in general for fighting crime.
  • Published: 2014
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
out of 1 pages


   64 ms - page object
   25 ms - search
   29 ms - highlighting
   25 ms - highlighting/31600
   29 ms - highlighting/31673


AV-Portal 3.7.0 (943df4b4639bec127ddc6b93adb0c7d8d995f77c)