BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH
Autor(a) principal: | |
---|---|
Data de Publicação: | 2015 |
Outros Autores: | , , , , , , , |
Tipo de documento: | Artigo de conferência |
Idioma: | eng |
Título da fonte: | Repositório Institucional da UNESP |
Texto Completo: | http://dx.doi.org/10.5194/isprsarchives-XL-7-W3-635-2015 http://hdl.handle.net/11449/161769 |
Resumo: | Bio-optical characterization of water bodies requires spatio-temporal data about Inherent Optical Properties and Apparent Optical Properties which allow the comprehension of underwater light field aiming at the development of models for monitoring water quality. Measurements are taken to represent optical properties along a column of water, and then the spectral data must be related to depth. However, the spatial positions of measurement may differ since collecting instruments vary. In addition, the records should not refer to the same wavelengths. Additional difficulty is that distinct instruments store data in different formats. A data integration approach is needed to make these large and multi source data sets suitable for analysis. Thus, it becomes possible, even automatically, semi-empirical models evaluation, preceded by preliminary tasks of quality control. In this work it is presented a solution, in the stated scenario, based on spatial - geographic - database approach with the adoption of an object relational Database Management System - DBMS - due to the possibilities to represent all data collected in the field, in conjunction with data obtained by laboratory analysis and Remote Sensing images that have been taken at the time of field data collection. This data integration approach leads to a 4D representation since that its coordinate system includes 3D spatial coordinates - planimetric and depth - and the time when each data was taken. It was adopted PostgreSQL DBMS extended by PostGIS module to provide abilities to manage spatial/geospatial data. It was developed a prototype which has the mainly tools an analyst needs to prepare the data sets for analysis. |
id |
UNSP_ed98bd571c5ae30c832a9c8bcd5f32a1 |
---|---|
oai_identifier_str |
oai:repositorio.unesp.br:11449/161769 |
network_acronym_str |
UNSP |
network_name_str |
Repositório Institucional da UNESP |
repository_id_str |
2946 |
spelling |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACHBio-optical PropertiesMulti Source Data4D RepresentationQuality ControlSensors Data IntegrationBio-optical characterization of water bodies requires spatio-temporal data about Inherent Optical Properties and Apparent Optical Properties which allow the comprehension of underwater light field aiming at the development of models for monitoring water quality. Measurements are taken to represent optical properties along a column of water, and then the spectral data must be related to depth. However, the spatial positions of measurement may differ since collecting instruments vary. In addition, the records should not refer to the same wavelengths. Additional difficulty is that distinct instruments store data in different formats. A data integration approach is needed to make these large and multi source data sets suitable for analysis. Thus, it becomes possible, even automatically, semi-empirical models evaluation, preceded by preliminary tasks of quality control. In this work it is presented a solution, in the stated scenario, based on spatial - geographic - database approach with the adoption of an object relational Database Management System - DBMS - due to the possibilities to represent all data collected in the field, in conjunction with data obtained by laboratory analysis and Remote Sensing images that have been taken at the time of field data collection. This data integration approach leads to a 4D representation since that its coordinate system includes 3D spatial coordinates - planimetric and depth - and the time when each data was taken. It was adopted PostgreSQL DBMS extended by PostGIS module to provide abilities to manage spatial/geospatial data. It was developed a prototype which has the mainly tools an analyst needs to prepare the data sets for analysis.Sao Paulo State Univ, Postgrad Program Cartog Sci, Presidente Prudente, SP, BrazilSao Paulo State Univ, Postgrad Program Cartog Sci, Presidente Prudente, SP, BrazilCopernicus Gesellschaft MbhUniversidade Estadual Paulista (Unesp)Imai, N. N. [UNESP]Shimabukuro, M. H. [UNESP]Carmo, A. F. C. [UNESP]Alcantara, E. H. [UNESP]Rodrigues, T. W. P. [UNESP]Watanabe, F. S. Y. [UNESP]Schreier, G.Skrovseth, P. E.Staudenrausch, H.2018-11-26T16:48:32Z2018-11-26T16:48:32Z2015-01-01info:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/conferenceObject635-641application/pdfhttp://dx.doi.org/10.5194/isprsarchives-XL-7-W3-635-201536th International Symposium On Remote Sensing Of Environment. Gottingen: Copernicus Gesellschaft Mbh, v. 47, n. W3, p. 635-641, 2015.2194-9034http://hdl.handle.net/11449/16176910.5194/isprsarchives-XL-7-W3-635-2015WOS:000380531900094WOS000380531900094.pdfWeb of Sciencereponame:Repositório Institucional da UNESPinstname:Universidade Estadual Paulista (UNESP)instacron:UNESPeng36th International Symposium On Remote Sensing Of Environmentinfo:eu-repo/semantics/openAccess2024-06-18T15:02:39Zoai:repositorio.unesp.br:11449/161769Repositório InstitucionalPUBhttp://repositorio.unesp.br/oai/requestopendoar:29462024-08-05T19:28:39.342724Repositório Institucional da UNESP - Universidade Estadual Paulista (UNESP)false |
dc.title.none.fl_str_mv |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
title |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
spellingShingle |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH Imai, N. N. [UNESP] Bio-optical Properties Multi Source Data 4D Representation Quality Control Sensors Data Integration |
title_short |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
title_full |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
title_fullStr |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
title_full_unstemmed |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
title_sort |
BIO-OPTICAL DATA INTEGRATION BASED ON A 4D DATABASE SYSTEM APPROACH |
author |
Imai, N. N. [UNESP] |
author_facet |
Imai, N. N. [UNESP] Shimabukuro, M. H. [UNESP] Carmo, A. F. C. [UNESP] Alcantara, E. H. [UNESP] Rodrigues, T. W. P. [UNESP] Watanabe, F. S. Y. [UNESP] Schreier, G. Skrovseth, P. E. Staudenrausch, H. |
author_role |
author |
author2 |
Shimabukuro, M. H. [UNESP] Carmo, A. F. C. [UNESP] Alcantara, E. H. [UNESP] Rodrigues, T. W. P. [UNESP] Watanabe, F. S. Y. [UNESP] Schreier, G. Skrovseth, P. E. Staudenrausch, H. |
author2_role |
author author author author author author author author |
dc.contributor.none.fl_str_mv |
Universidade Estadual Paulista (Unesp) |
dc.contributor.author.fl_str_mv |
Imai, N. N. [UNESP] Shimabukuro, M. H. [UNESP] Carmo, A. F. C. [UNESP] Alcantara, E. H. [UNESP] Rodrigues, T. W. P. [UNESP] Watanabe, F. S. Y. [UNESP] Schreier, G. Skrovseth, P. E. Staudenrausch, H. |
dc.subject.por.fl_str_mv |
Bio-optical Properties Multi Source Data 4D Representation Quality Control Sensors Data Integration |
topic |
Bio-optical Properties Multi Source Data 4D Representation Quality Control Sensors Data Integration |
description |
Bio-optical characterization of water bodies requires spatio-temporal data about Inherent Optical Properties and Apparent Optical Properties which allow the comprehension of underwater light field aiming at the development of models for monitoring water quality. Measurements are taken to represent optical properties along a column of water, and then the spectral data must be related to depth. However, the spatial positions of measurement may differ since collecting instruments vary. In addition, the records should not refer to the same wavelengths. Additional difficulty is that distinct instruments store data in different formats. A data integration approach is needed to make these large and multi source data sets suitable for analysis. Thus, it becomes possible, even automatically, semi-empirical models evaluation, preceded by preliminary tasks of quality control. In this work it is presented a solution, in the stated scenario, based on spatial - geographic - database approach with the adoption of an object relational Database Management System - DBMS - due to the possibilities to represent all data collected in the field, in conjunction with data obtained by laboratory analysis and Remote Sensing images that have been taken at the time of field data collection. This data integration approach leads to a 4D representation since that its coordinate system includes 3D spatial coordinates - planimetric and depth - and the time when each data was taken. It was adopted PostgreSQL DBMS extended by PostGIS module to provide abilities to manage spatial/geospatial data. It was developed a prototype which has the mainly tools an analyst needs to prepare the data sets for analysis. |
publishDate |
2015 |
dc.date.none.fl_str_mv |
2015-01-01 2018-11-26T16:48:32Z 2018-11-26T16:48:32Z |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/conferenceObject |
format |
conferenceObject |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://dx.doi.org/10.5194/isprsarchives-XL-7-W3-635-2015 36th International Symposium On Remote Sensing Of Environment. Gottingen: Copernicus Gesellschaft Mbh, v. 47, n. W3, p. 635-641, 2015. 2194-9034 http://hdl.handle.net/11449/161769 10.5194/isprsarchives-XL-7-W3-635-2015 WOS:000380531900094 WOS000380531900094.pdf |
url |
http://dx.doi.org/10.5194/isprsarchives-XL-7-W3-635-2015 http://hdl.handle.net/11449/161769 |
identifier_str_mv |
36th International Symposium On Remote Sensing Of Environment. Gottingen: Copernicus Gesellschaft Mbh, v. 47, n. W3, p. 635-641, 2015. 2194-9034 10.5194/isprsarchives-XL-7-W3-635-2015 WOS:000380531900094 WOS000380531900094.pdf |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
36th International Symposium On Remote Sensing Of Environment |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
635-641 application/pdf |
dc.publisher.none.fl_str_mv |
Copernicus Gesellschaft Mbh |
publisher.none.fl_str_mv |
Copernicus Gesellschaft Mbh |
dc.source.none.fl_str_mv |
Web of Science reponame:Repositório Institucional da UNESP instname:Universidade Estadual Paulista (UNESP) instacron:UNESP |
instname_str |
Universidade Estadual Paulista (UNESP) |
instacron_str |
UNESP |
institution |
UNESP |
reponame_str |
Repositório Institucional da UNESP |
collection |
Repositório Institucional da UNESP |
repository.name.fl_str_mv |
Repositório Institucional da UNESP - Universidade Estadual Paulista (UNESP) |
repository.mail.fl_str_mv |
|
_version_ |
1808129073692540928 |