PostGIS-Based Heterogeneous Sensor Database Framework for the Sensor Observation Service
DOI:
https://doi.org/10.14311/gi.8.4Abstract
Environmental monitoring and management systems in most cases deal with models and spatial analytics that involve the integration of in-situ and remote sensor observations. In-situ sensor observations and those gathered by remote sensors are usually provided by different databases and services in real-time dynamic services such as the Geo-Web Services. Thus, data have to be pulled from different databases and transferred over the network before they are fused and processed on the service middleware. This process is very massive and unnecessary communication and work load on the service. Massive work load in large raster downloads from flat-file raster data sources each time a request is made and huge integration and geo-processing work load on the service middleware which could actually be better leveraged at the database level. In this paper, we propose and present a heterogeneous sensor database framework or model for integration, geo-processing and spatial analysis of remote and in-situ sensor observations at the database level. And how this can be integrated in the Sensor Observation Service, SOS to reduce communication and massive workload on the Geospatial Web Services and as well make query request from the user end a lot more flexible.References
Groundwater and Vegetation Effects on Actual Evapotranspiration Along the Riparian Zone and of a Wetland in the Republican River Basin. Gregory Cutrell, M. Evren Soylu. Nebraska-Lincoln : s.n., 2009.
Development of a Dynamic Web Mapping Service for Vegetation Productivity Using Earth Observation and in situ Sensors in a Sensor Web Based Approach. Kooistra, L., et al. 4, 2009, Sensors , Vol. 9, pp. 2371-2388.
Hamre, Torill. Integrating Remote Sensing, In Situ and Model Data in a Marine Information System (MIS). Marine Information System (MIS), in Proc. Neste Generasjons GIS. 1993, pp. 181-192.
Geographic information -- Schema for coverage geometry and functions. ISO. 2009, TC 211 - Geographic information/Geomatics.
PostGISWiki. PostGIS UsersWiki. [Online] [Cited: September 10, 2011.] http:// trac.osgeo.org/postgis/wiki/UsersWikiCoveragesAndPostgis.
Management of multidimensional discrete data. Baumann, Peter. Issue 4, October 1994, The VLDB Journal, Vol. Volume 3, pp. 401-44.
Store, manipulate and analyze raster data within the PostgreSQL/PostGIS spatial database. Racine, Pierre. Denver : http://2011.foss4g.org, 2011. FOSS4G.
postgis.refractions.net. PostGIS 1.5.3 Manual. postgis.refractions.net Web site. [Online] [Cited: August 20, 2011.] http://www.postgis.org/docs/
Pierre, Racine. WKTRasterTutorial01. PostGIS. [Online] June 2010. [Cited: 11 12, 2011.] http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01
Designing a Geo-scientific Request Language - A Database Approach. Baumann, Peter. s.l. : Springer-Verlag Berlin, Heidelberg, 2009. SSDBM 2009 Proceedings of the 21st International Conference on Scientific and Statistical Database Management. ISBN: 9783-642-02278-4.
Rueda, Carlos and Gertz, Michael. Real-Time Integration of Geospatial Raster and Point Data Streams. Statistical and Scientific Database Management. 2008, pp. 605--611.
WARMER in-situ and remote data integration. AlastairAllen, et al. Southampton (UK) : s.n., 30th March 2009. National Oceanography Center.
An integrated Earth sensing sensorweb for improved crop and rangeland yield predictions. Teillet, P M, et al. 2007, Canadian Journal of Remote Sensing, Vol. 33, pp. 88-98.
Downloads
Published
Issue
Section
License
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).