PostGIS-Based Heterogeneous Sensor Database Framework for the Sensor Observation Service

Ikechukwu Maduako


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.


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://

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 :, 2011. FOSS4G. PostGIS 1.5.3 Manual. Web site. [Online] [Cited: August 20, 2011.]

Pierre, Racine. WKTRasterTutorial01. PostGIS. [Online] June 2010. [Cited: 11 12, 2011.]

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.


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.