Sensor technologies are improving fast: sensors are being developed to record more types of phenomena in improving precision, and they are becoming less expensive. The vision is that sensor networks deployed across large spaces, attached to important infrastructure, and embedded in our everyday environments will become a ubiquitous element of the world''s information infrastructure. The apparent bottleneck in reaching this vision efficiently and cost effectively is software development. Here we discuss an integrated service-oriented architecture for collecting, archiving, analyzing and visualizing sensor network data. The framework has been deployed and evaluated in two applications: SensorGIS and SmartCondo, designed for sensor networks deployed in outdoor and indoor spaces.