{"id":{"repo_id":"sdstate","oai_identifier":"oai:openprairie.sdstate.edu:etd-3060"},"canonical_url":"https://search.ndltd.org/etd/sdstate/oai:openprairie.sdstate.edu:etd-3060","repository":{"repo_id":"sdstate","name":"South Dakota State University","base_url":"https://openprairie.sdstate.edu/do/oai/"},"display":{"title":"Design and Implementation of an Operational and Fully Automated Database Storing Geolocated Data","abstract":"Started in 2011, in the Image Processing Laboratory (IP Lab), a project is under way to perform atmospheric correction of space borne imaging sensors with no restrictions on the date, location, sensor or satellite used to create the image. In order to perform this correction, a wide range of meteorological data is needed to characterize the atmosphere. This meteorological data is obtained manually from multiple sources. Each of these sources comes in different data structures, with different compression/packing formats, with different spatial and temporal resolutions. Moreover, new data is periodically added to those sources.The absence of restrictions on the source of the images, which involves gathering large, complete and continuous data sets, has never been attempted before in this field. Thus, the project completed as described in this thesis has one main objective, which is to assess the feasibility of building a database that can support the multiple differences in the input data and that is fully automated, meaning newly available data should be automatically inserted in the database without any human intervention.To address the objective, a database and a script were created with the required exibility. To evaluate it, stored procedures were created to validate the correctness of the data by comparing their results to the data obtained from the multiple sources. The comparison revealed that the data was being processed and retrieved correctly.Using the methodology described in this thesis, the IP Lab was able to increase its efficiency and reliability, while at the same time providing a mechanism for easier linkage to the outside world.","abstract_html":"Started in 2011, in the Image Processing Laboratory (IP Lab), a project is under way to perform atmospheric correction of space borne imaging sensors with no restrictions on the date, location, sensor or satellite used to create the image. In order to perform this correction, a wide range of meteorological data is needed to characterize the atmosphere. This meteorological data is obtained manually from multiple sources. Each of these sources comes in different data structures, with different compression/packing formats, with different spatial and temporal resolutions. Moreover, new data is periodically added to those sources.The absence of restrictions on the source of the images, which involves gathering large, complete and continuous data sets, has never been attempted before in this field. Thus, the project completed as described in this thesis has one main objective, which is to assess the feasibility of building a database that can support the multiple differences in the input data and that is fully automated, meaning newly available data should be automatically inserted in the database without any human intervention.To address the objective, a database and a script were created with the required exibility. To evaluate it, stored procedures were created to validate the correctness of the data by comparing their results to the data obtained from the multiple sources. The comparison revealed that the data was being processed and retrieved correctly.Using the methodology described in this thesis, the IP Lab was able to increase its efficiency and reliability, while at the same time providing a mechanism for easier linkage to the outside world.","abstract_has_math":false,"creators":["Richard, Romain"],"institution":null,"degree_name":"Master of Science (MS)","degree_level":"Thesis - University Access Only","degree_discipline":"Electrical Engineering and Computer Science","degree_department":null,"school":null,"contributors":["Dennis Helder","Sung Shin"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":null,"date_issued":"","date_published":null,"updated_at":"2026-11-19T08:58:21Z","subjects":[],"languages":["en"],"rights":["<p>In Copyright - Non-Commercial Use Permitted<br /><a href=\"http://rightsstatements.org/vocab/InC-NC/1.0/\">http://rightsstatements.org/vocab/InC-NC/1.0/</a></p>"],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://openprairie.sdstate.edu/etd/2033","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://openprairie.sdstate.edu/etd/2033","record_label":"Repository record","record_kind":"record","record_source":"dc:identifier","download_url":null,"download_label":null,"download_source":null,"access_status":null,"embargo_until":null,"access_note":null},"source_record":{"url":"https://openprairie.sdstate.edu/do/oai/?verb=GetRecord&metadataPrefix=oai_etdms&identifier=oai%3Aopenprairie.sdstate.edu%3Aetd-3060","prefix":"oai_etdms"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Dennis Helder","Sung Shin"]},{"key":"dc:creator","label":"Author","values":["Richard, Romain"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.available","label":"Dc Date Available","values":["2017-11-27T08:00:00Z"]},{"key":"dc:date.created","label":"Dc Date Created","values":["2014-01-01T08:00:00Z"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["Electrical Engineering and Computer Science"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Thesis - University Access Only"]},{"key":"thesis:degree_name","label":"Degree Name","values":["Master of Science (MS)"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["en"]},{"key":"dc:rights","label":"Dc Rights","values":["<p>In Copyright - Non-Commercial Use Permitted<br /><a href=\"http://rightsstatements.org/vocab/InC-NC/1.0/\">http://rightsstatements.org/vocab/InC-NC/1.0/</a></p>"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://openprairie.sdstate.edu/etd/2033"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["Started in 2011, in the Image Processing Laboratory (IP Lab), a project is under way to perform atmospheric correction of space borne imaging sensors with no restrictions on the date, location, sensor or satellite used to create the image. In order to perform this correction, a wide range of meteorological data is needed to characterize the atmosphere. This meteorological data is obtained manually from multiple sources. Each of these sources comes in different data structures, with different compression/packing formats, with different spatial and temporal resolutions. Moreover, new data is periodically added to those sources.The absence of restrictions on the source of the images, which involves gathering large, complete and continuous data sets, has never been attempted before in this field. Thus, the project completed as described in this thesis has one main objective, which is to assess the feasibility of building a database that can support the multiple differences in the input data and that is fully automated, meaning newly available data should be automatically inserted in the database without any human intervention.To address the objective, a database and a script were created with the required exibility. To evaluate it, stored procedures were created to validate the correctness of the data by comparing their results to the data obtained from the multiple sources. The comparison revealed that the data was being processed and retrieved correctly.Using the methodology described in this thesis, the IP Lab was able to increase its efficiency and reliability, while at the same time providing a mechanism for easier linkage to the outside world."]},{"key":"dc:title","label":"Title","values":["Design and Implementation of an Operational and Fully Automated Database Storing Geolocated Data"]}]}],"canonical_facts":{"dc:contributor":["Dennis Helder","Sung Shin"],"dc:creator":["Richard, Romain"],"dc:date.available":["2017-11-27T08:00:00Z"],"dc:date.created":["2014-01-01T08:00:00Z"],"dc:description.abstract":["Started in 2011, in the Image Processing Laboratory (IP Lab), a project is under way to perform atmospheric correction of space borne imaging sensors with no restrictions on the date, location, sensor or satellite used to create the image. In order to perform this correction, a wide range of meteorological data is needed to characterize the atmosphere. This meteorological data is obtained manually from multiple sources. Each of these sources comes in different data structures, with different compression/packing formats, with different spatial and temporal resolutions. Moreover, new data is periodically added to those sources.The absence of restrictions on the source of the images, which involves gathering large, complete and continuous data sets, has never been attempted before in this field. Thus, the project completed as described in this thesis has one main objective, which is to assess the feasibility of building a database that can support the multiple differences in the input data and that is fully automated, meaning newly available data should be automatically inserted in the database without any human intervention.To address the objective, a database and a script were created with the required exibility. To evaluate it, stored procedures were created to validate the correctness of the data by comparing their results to the data obtained from the multiple sources. The comparison revealed that the data was being processed and retrieved correctly.Using the methodology described in this thesis, the IP Lab was able to increase its efficiency and reliability, while at the same time providing a mechanism for easier linkage to the outside world."],"dc:identifier":["https://openprairie.sdstate.edu/etd/2033"],"dc:language":["en"],"dc:rights":["<p>In Copyright - Non-Commercial Use Permitted<br /><a href=\"http://rightsstatements.org/vocab/InC-NC/1.0/\">http://rightsstatements.org/vocab/InC-NC/1.0/</a></p>"],"dc:title":["Design and Implementation of an Operational and Fully Automated Database Storing Geolocated Data"],"thesis:degree_discipline":["Electrical Engineering and Computer Science"],"thesis:degree_level":["Thesis - University Access Only"],"thesis:degree_name":["Master of Science (MS)"]},"updated_at":"2026-11-19T08:58:21Z"}