Utilização de Banco de dados espacial para aplicações em Saneamento
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
Narcélio de Sá
Analista de Geoprocessamento - CAGECE
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324722/Logo_Labocart_HD.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324725/bras_o_novo_UFC.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324680/Pg_logo.png)
Desenvolver e implantar uma solução baseada em inteligência geográfica para a gestão de cadastro compreendendo a obtenção e atualização de informações comerciais e técnicas de redes de água e esgoto numa base de dados georreferenciada integrada para utilização pelas diversas áreas da Companhia.
Objetivo do Projeto:
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324679/2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Melhorar a confiabilidade do cadastro da Cagece:
Benefícios do Projeto:
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324677/water-icon.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324683/icon_company.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324676/esgoto-icon.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324678/normal_ian-symbol-water-drinking-water-treatment-plant-1.png)
Cadastro de Redes de Água
Cadastro de Clientes
Cadastro de Redes de Esgoto
Cadastro de Equipamentos
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Possibilitar a integração com outros sistemas da Cagece, tais como: Prax,Siscope, ERP, COA, COE, etc.
Possibilitar simulação de situações de rede.
Benefícios do Projeto:
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329157/wtr-CIPCostEstimate.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Etapas de trabalho para
estruturação do Cadastro em GIS:
1ª Etapa
2ª Etapa
3ª Etapa
Conversão, Adequação
e atualização
da Base Cadastral
Controle de
Qualidade
Edição, Processamento e Análise
específica para Saneamento
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324675/gear.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324674/check-1-icon.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324673/paste.png)
Infraestrutura Atual:
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324696/mini_qgis_brasil_original.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324682/GeoServer_MARK.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324680/Pg_logo.png)
Interface do usuário
Banco de Dados
Web Service
QGIS
PostgreSQL + PostGIS
Geoserver
Infraestrutura Open Source
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324681/Opensource.svg.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Infraestrutura Atual:
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324696/mini_qgis_brasil_original.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324682/GeoServer_MARK.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324680/Pg_logo.png)
Infraestrutura Open Source
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324681/Opensource.svg.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](http://is5.mzstatic.com/image/thumb/Purple/v4/14/69/a8/1469a875-19ec-c4fa-6d01-c04650be7c63/source/1200x630bb.jpg)
![](http://www.gaia-gis.it/gaia-sins/spatialite-logo.png)
![](http://www.geopackage.org/img/geopkg.png)
![](https://upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/1200px-SQLite370.svg.png)
![](https://upload.wikimedia.org/wikipedia/en/6/60/PostGIS_logo.png)
![](http://leafletjs.com/docs/images/logo.png)
![](https://www.epa.gov/sites/production/files/2016-10/swmm.png)
![](http://corneltudose.ro/wp-content/uploads/2016/09/openlayers.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Banco de Dados Espacial
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329445/travel-2650303_1920.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
O que é um banco de dados?
Uma das definições de banco de dados afirma que se trata de uma coleção de informações que se relacionam de modo que criem algum sentido, isto é, é uma estrutura bem organizada de dados que permite a extração de informações. Assim, são muito importantes para empresas e tornaram-se a principal peça dos sistemas de informação.
![](http://www.issart.com/blog/wp-content/uploads/2017/03/boxbarimage5.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
PostgreSQL
O PostgreSQL é um projeto open source coordenado pelo PostgreSQL Global Development Group.
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324680/Pg_logo.png)
1982 - Projeto Ingres, desenvolvido na Universidade de Berkeley, Califórnia.
1986 - Nasce o projeto pós-Ingres com o objetivo de resolver problemas com o modelo de banco de dados relacional.
1993 - O projeto é abandonado pela Universidade de Berkeley.
1994 - O projeto foi renomeado para Postgres95 como software open source.
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
PostgreSQL
1996 - o projeto foi renomeado para PostgreSQL , na sua versão 6.0
2017 - Lançada a versão 10.1 do PostgreSQL.
É considerado um dos SGBDs de código aberto mais avançados do mundo.
![](https://upload.wikimedia.org/wikipedia/commons/thumb/7/7b/Seal_of_the_United_States_Department_of_State.svg/220px-Seal_of_the_United_States_Department_of_State.svg.png)
![](https://www.nasa.gov/sites/default/files/images/nasaLogo-570x450.png)
![](https://image.freepik.com/free-icon/apple-logo_318-40184.jpg)
![](https://upload.wikimedia.org/wikipedia/commons/thumb/7/79/NOAA_logo.svg/1200px-NOAA_logo.svg.png)
![](https://blog.openstreetmap.org/wp-content/uploads/2011/05/newosmlogo.png)
![](https://upload.wikimedia.org/wikipedia/commons/thumb/c/c0/Embrapa.svg/1200px-Embrapa.svg.png)
![](https://media.lovemondays.com.br/logos/63e949/exercito-brasileiro-original.jpg)
![](http://caieiras.sp.gov.br/hotsite/juntaMilitar/img/logo_forcaaereabrasileira.jpg)
![](https://upload.wikimedia.org/wikipedia/commons/thumb/8/81/Logo_IBAMA.svg/1200px-Logo_IBAMA.svg.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Porque o PostgreSQL?
![](https://upload.wikimedia.org/wikipedia/en/thumb/6/62/MySQL.svg/1200px-MySQL.svg.png)
![](https://esolution.ca/wp-content/uploads/Oracle_Database.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324680/Pg_logo.png)
Funcionalidades
Desempenho
Custo
Escalabilidade
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
“Enterprise” | 1 Dual-Core | 2 Quad-Core |
---|---|---|
Oracle | $40,000 | $160,000 |
IBM DB2 | $36,400 | $145,600 |
MS SQL Server | $25,000 | $50,000 |
IBM Informix | $50,000 | $200,000 |
PostgreSQL | $0 | $0 |
2007
Custo do hardware $5,000
Custo do banco de dados $50,000
1997
Custo do hardware $50,000
Custo do banco de dados $50,000
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Porque o PostgreSQL?
- Consultas complexas
- Chaves estrangeiras
- Integridade transacional
- Controle de concorrência multi-versão
- Suporte ao modelo híbrido objeto-relacional
- Ele tem facilidade de Acesso
- Gatilhos
- Visões
- Linguagem Procedural em várias linguagens (PL/pgSQL, PL/Python, PL/Java, PL/Perl) para Procedimentos armazenados
- Indexação por texto
- Estrutura para guardar dados Georeferenciados PostGIS
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Postgis
O PostGIS é uma extensão espacial gratuita e de código fonte livre que implementa a especificação padrão da Open Geospatial Consortium (OGC).
Permite o uso de objetos GIS (Sistemas de Informação Geográfica) ser armazenado em banco de dados.
PostGIS inclui suporte para índices espaciais GiST e R-Tree, além de funções para análise básica e processamento de objetos GIS.
![](http://duspviz.mit.edu/_assets/img/postgis-logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Geometrias Suportadas
O PostGIS suporta os seguintes tipos de Geometrias especificados pela OGC:
Point;
Linestring;
Polygon;
Multipoint;
Multilinestring;
Multipolygon;
GeometryCollection.
![](http://duspviz.mit.edu/_assets/img/postgis-logo.png)
Cases de Estudo
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Projeto de Cadastro Georreferenciado
CAGECE - IGEO
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329454/depth-of-field-1868723_1920.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
O que é o Geocoding
A geocodificação é o processo de converter endereços (como nome da rua e número) em coordenadas geográficas (latitude e longitude) que permitem a inserção de marcadores de local em um mapa ou o posicionamento do mapa.
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324986/reverse.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
A geocodificação é uma tarefa que envolve múltiplos conjuntos de dados e processos, todos os quais trabalham em conjunto. Um geocodificador é composto por dois componentes importantes: um conjunto de dados de referência e o algoritmo de geocodificação.
Serviços de Geocodificação:
Google
Mapbox
Here
BingMaps
CloudMade
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324988/geocoding.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Como Funciona o Geocoding
Entrada dos dados: Lista de endereços
Consulta: Verificação da relação entre os endereços enviados e os presentes na base de referência
Resultado: Lat , Long
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324985/geocoding_cogs.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Precisão do resultado
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324987/rooftop.png)
"ROOFTOP"
"RANGE_INTERPOLATED"
"GEOMETRIC_CENTER"
"APPROXIMATE"
*Google API location_type
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Precisão do resultado
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324983/interpolate_2.png)
"ROOFTOP"
"RANGE_INTERPOLATED"
"GEOMETRIC_CENTER"
"APPROXIMATE"
*Google API location_type
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Precisão do resultado
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324979/geom_center.png)
"ROOFTOP"
"RANGE_INTERPOLATED"
"GEOMETRIC_CENTER"
"APPROXIMATE"
*Google API location_type
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Precisão do resultado
"ROOFTOP"
"RANGE_INTERPOLATED"
"GEOMETRIC_CENTER"
"APPROXIMATE"
*Google API location_type
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324977/aproximate.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Desafios do Geocoding
Formatação do Endereço
Consultas ambíguas
Dependência de Base de dados Externa
Custo benefício do serviço
Av. Dr. Lauro Vieira Chaves, 1030 Vila União, Fortaleza – CE, 60420-280
6289
9%
6289
Logradouros não amigáveis ao geocoding.(S.D.O, SDO , ST-,RUA DISPONÍVEL )
dos Logradouros cadastrados no PRAX
Imóveis não localizáveis
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Georreferenciamento por interpolação IGEO-PRAX
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4325098/igeo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329454/depth-of-field-1868723_1920.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Metodologia
Campo:
Medição dos Lotes
Geração do Overlay
Cadastro no PRAX
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4325300/pc.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4325299/cit.png)
Escritório:
Carga dos dados do PRAX
Geração de perímetro de Referência
Interpolação dos dados
Controle de Qualidade
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Medição dos Lotes
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324973/quadra.png)
Rua Coronel Jucá
R. Henriqueta Galeno
R. Beni Carvalho
R. Monsenhor Catão
UNIDADE: UNMTL
SETOR: 6
QUADRA: 7
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Geração dos Overlays
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324971/overlay.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324969/overlay_det.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Geração de perímetro de Referência
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324973/quadra.png)
Rua Coronel Jucá
R. Henriqueta Galeno
R. Beni Carvalho
R. Monsenhor Catão
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Interpolação dos dados dos lotes
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324973/quadra.png)
Rua Coronel Jucá
R. Henriqueta Galeno
R. Beni Carvalho
R. Monsenhor Catão
759
749
739
731
719
709
sn
738
750
762
768
780
796
1396
1704
1720
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Controle de Qualidade
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324973/quadra.png)
Rua Coronel Jucá
R. Henriqueta Galeno
R. Beni Carvalho
R. Monsenhor Catão
759
719
709
sn
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329346/01.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329345/02.png)
Imóvel 759
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Georreferenciamento por interpolação IGEO-PRAX
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329405/lote_cadastro.gif)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329544/Image_1510594476.png)
Trigger para georreferenciamento de clientes
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Resultados:
Agilidade / Precisão no Cadastro
Integração com o PRAX
Atualização semiautomática
Dados podem ser disponibilizados em json via Geoserver:
http://172.25.131.53:8080/geoserver/IGEO/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=IGEO:ponto_imovel&CQL_FILTER=IMO_COD_INSCRICAO=265381&outputFormat=application%2Fjson
Fatores de complicação:
Problemas no cadastro dos lotes no PRAX
Comunicação entre o PRAX e o IGEO
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329494/google.png)
Dados do geocoding Google
Setores (7,8,9,10)
PRAX: 10.457
Google: 3.845
Resultado: 36,76 %
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329493/cagece.png)
Dados do geocoding IGEO
Setores (7,8,9,10)
PRAX: 10.457
IGEO: 9.846
Resultado: 94,15 %
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329491/google_2.jpg)
Dados do geocoding Google
Setores (7,8,9,10)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329492/cagece_2.png)
Dados do geocoding IGEO
Setores (7,8,9,10)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
1196495
230000
21
22
9
IMÓVEIS CAPITAL
IMÓVEIS IGEO
% MAPEADO
DIAS DE TRABALHO
ESTAGIÁRIOS
Números Maio/2017
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
1196495
1115608
96
154
14
IMÓVEIS CAPITAL
IMÓVEIS IGEO
% MAPEADO
DIAS DE TRABALHO
ESTAGIÁRIOS
Números Novembro /2017
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329554/Image_1510590561.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Integração com os sistemas Cagece
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329560/Image_1510589297.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Mapa dos serviços executados
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329561/Image_1510588657.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Mapa dos serviços executados
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329564/Image_1510588742.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Monitorar OS
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329566/Image_1510589196.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Cadastro de Redes
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329541/pipeline-2472068_1920.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329546/Image_1510589696.png)
Mapa das redes de Água da RMF
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329550/Image_1510590817.png)
Cadastro de atributos da rede de água
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329558/Image_1510589665.png)
Mapa das redes de Esgoto da RMF
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329559/Image_1510590840.png)
Cadastro de atributos da rede de esgoto
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329619/IMG_20150311_092908.jpg)
Arqueologia Cartográfica
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329573/Image_1510592009.png)
Verificação de Fluxo de rede
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329571/Image_1510592044.png)
Verificação de Fluxo de rede
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329575/Image_1510592072.png)
Verificação de Fluxo de rede
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Integração com o EPANET
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329595/drops-of-water-578897_1920.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329546/Image_1510589696.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329600/Image_1510596934.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329609/dmc_messejana_situacao_01.gif)
Simulação de Perda de carga
Situação Atual
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329608/dmc_messejana_situacao_02.gif)
Simulação de Perda de carga
Com empreendimentos
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329607/dmc_messejana_situacao_03.gif)
Simulação de Perda de carga
Com empreendimentos + Melhorias na Rede
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Perspectivas Futuras...
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329614/map-of-the-world-2164673_1920.jpg)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324666/GISDay_logo.png)
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4324715/cagece_2.png)
Obrigado
![](https://s3.amazonaws.com/media-p.slid.es/uploads/737896/images/4329614/map-of-the-world-2164673_1920.jpg)
GISday UFC 2017
By Narcélio de Sá Pereira Filho
GISday UFC 2017
- 432