Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database
Autor(a) principal: | |
---|---|
Data de Publicação: | 2023 |
Outros Autores: | , , |
Tipo de documento: | Artigo |
Idioma: | eng |
Título da fonte: | Anuário do Instituto de Geociências (Online) |
Texto Completo: | https://revistas.ufrj.br/index.php/aigeo/article/view/55179 |
Resumo: | Investment in sanitation and infrastructure is essential to ensure quality of human life, so its absence or fragility can lead to a scenario of calamities. Among the elements that constitute the infrastructure of a sanitation system is the technical register responsible for gathering all the information inherent to the system from the implementation of the network to the final destination of the effluent, provided for in the stages of design, execution and continuity of operations. As a result, GIS have become fundamental tools for the registration of sanitation networks, as they provide the integration of descriptive and graphic data in the same base. In this context, the objective of this study was the implementation of a database in free software through the SpatiaLite extension, aggregated georeferenced spatial information of components of a sanitary sewage network, producing a proposal for a Technical Registry. Processing was developed in the software QGIS 3.16, in which the elements of “Inspection Box” were used in the model, being represented vectorially by geometry of “Point” and “Extension” represented by “Line” to form a spatial system on the structure and location by means of vectorization on screen. As a result, the implementation of the register through the SpatiaLite platform, ensured fast processing, positional accuracy, conformity of cartographic representation, topology between classes, format consistency and completeness. However, the database enabled to analyze together all the components interrelated with the sewage system, through technical information for the management and efficiency of basic sanitation services. |
id |
UFRJ-21_b01e65a4e0c774b2062ac8130195d542 |
---|---|
oai_identifier_str |
oai:ojs.pkp.sfu.ca:article/55179 |
network_acronym_str |
UFRJ-21 |
network_name_str |
Anuário do Instituto de Geociências (Online) |
repository_id_str |
|
spelling |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite databaseInvestment in sanitation and infrastructure is essential to ensure quality of human life, so its absence or fragility can lead to a scenario of calamities. Among the elements that constitute the infrastructure of a sanitation system is the technical register responsible for gathering all the information inherent to the system from the implementation of the network to the final destination of the effluent, provided for in the stages of design, execution and continuity of operations. As a result, GIS have become fundamental tools for the registration of sanitation networks, as they provide the integration of descriptive and graphic data in the same base. In this context, the objective of this study was the implementation of a database in free software through the SpatiaLite extension, aggregated georeferenced spatial information of components of a sanitary sewage network, producing a proposal for a Technical Registry. Processing was developed in the software QGIS 3.16, in which the elements of “Inspection Box” were used in the model, being represented vectorially by geometry of “Point” and “Extension” represented by “Line” to form a spatial system on the structure and location by means of vectorization on screen. As a result, the implementation of the register through the SpatiaLite platform, ensured fast processing, positional accuracy, conformity of cartographic representation, topology between classes, format consistency and completeness. However, the database enabled to analyze together all the components interrelated with the sewage system, through technical information for the management and efficiency of basic sanitation services.Universidade Federal do Rio de Janeiro2023-08-31info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdfhttps://revistas.ufrj.br/index.php/aigeo/article/view/5517910.11137/1982-3908_2023_46_55179Anuário do Instituto de Geociências; v. 46 (2023)Anuário do Instituto de Geociências; Vol. 46 (2023)1982-39080101-9759reponame:Anuário do Instituto de Geociências (Online)instname:Universidade Federal do Rio de Janeiro (UFRJ)instacron:UFRJenghttps://revistas.ufrj.br/index.php/aigeo/article/view/55179/pdfCopyright (c) 2023 Anuário do Instituto de Geociênciasinfo:eu-repo/semantics/openAccessSilva Júnior, Juarez Antônio daSilva Júnior, Ubiratan Joaquim daFrança, Thaisa Manoela SilvaVenancio, Wallamys Alexandre Ramos2023-08-31T10:58:43Zoai:ojs.pkp.sfu.ca:article/55179Revistahttps://revistas.ufrj.br/index.php/aigeo/indexPUBhttps://revistas.ufrj.br/index.php/aigeo/oaianuario@igeo.ufrj.br||1982-39080101-9759opendoar:2023-08-31T10:58:43Anuário do Instituto de Geociências (Online) - Universidade Federal do Rio de Janeiro (UFRJ)false |
dc.title.none.fl_str_mv |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
title |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
spellingShingle |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database Silva Júnior, Juarez Antônio da |
title_short |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
title_full |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
title_fullStr |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
title_full_unstemmed |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
title_sort |
Proposal for Technical Registry of Sanitation Networks through an open structure using SpatiaLite database |
author |
Silva Júnior, Juarez Antônio da |
author_facet |
Silva Júnior, Juarez Antônio da Silva Júnior, Ubiratan Joaquim da França, Thaisa Manoela Silva Venancio, Wallamys Alexandre Ramos |
author_role |
author |
author2 |
Silva Júnior, Ubiratan Joaquim da França, Thaisa Manoela Silva Venancio, Wallamys Alexandre Ramos |
author2_role |
author author author |
dc.contributor.author.fl_str_mv |
Silva Júnior, Juarez Antônio da Silva Júnior, Ubiratan Joaquim da França, Thaisa Manoela Silva Venancio, Wallamys Alexandre Ramos |
description |
Investment in sanitation and infrastructure is essential to ensure quality of human life, so its absence or fragility can lead to a scenario of calamities. Among the elements that constitute the infrastructure of a sanitation system is the technical register responsible for gathering all the information inherent to the system from the implementation of the network to the final destination of the effluent, provided for in the stages of design, execution and continuity of operations. As a result, GIS have become fundamental tools for the registration of sanitation networks, as they provide the integration of descriptive and graphic data in the same base. In this context, the objective of this study was the implementation of a database in free software through the SpatiaLite extension, aggregated georeferenced spatial information of components of a sanitary sewage network, producing a proposal for a Technical Registry. Processing was developed in the software QGIS 3.16, in which the elements of “Inspection Box” were used in the model, being represented vectorially by geometry of “Point” and “Extension” represented by “Line” to form a spatial system on the structure and location by means of vectorization on screen. As a result, the implementation of the register through the SpatiaLite platform, ensured fast processing, positional accuracy, conformity of cartographic representation, topology between classes, format consistency and completeness. However, the database enabled to analyze together all the components interrelated with the sewage system, through technical information for the management and efficiency of basic sanitation services. |
publishDate |
2023 |
dc.date.none.fl_str_mv |
2023-08-31 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
https://revistas.ufrj.br/index.php/aigeo/article/view/55179 10.11137/1982-3908_2023_46_55179 |
url |
https://revistas.ufrj.br/index.php/aigeo/article/view/55179 |
identifier_str_mv |
10.11137/1982-3908_2023_46_55179 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
https://revistas.ufrj.br/index.php/aigeo/article/view/55179/pdf |
dc.rights.driver.fl_str_mv |
Copyright (c) 2023 Anuário do Instituto de Geociências info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Copyright (c) 2023 Anuário do Instituto de Geociências |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
Universidade Federal do Rio de Janeiro |
publisher.none.fl_str_mv |
Universidade Federal do Rio de Janeiro |
dc.source.none.fl_str_mv |
Anuário do Instituto de Geociências; v. 46 (2023) Anuário do Instituto de Geociências; Vol. 46 (2023) 1982-3908 0101-9759 reponame:Anuário do Instituto de Geociências (Online) instname:Universidade Federal do Rio de Janeiro (UFRJ) instacron:UFRJ |
instname_str |
Universidade Federal do Rio de Janeiro (UFRJ) |
instacron_str |
UFRJ |
institution |
UFRJ |
reponame_str |
Anuário do Instituto de Geociências (Online) |
collection |
Anuário do Instituto de Geociências (Online) |
repository.name.fl_str_mv |
Anuário do Instituto de Geociências (Online) - Universidade Federal do Rio de Janeiro (UFRJ) |
repository.mail.fl_str_mv |
anuario@igeo.ufrj.br|| |
_version_ |
1797053535744950272 |