The SCEDC is developing an improved Station Information System (SIS) for the California Integrated Seismic Network (CISN) Southern California Management Center (SCMC). The goal of this project is to develop a simplified database-driven system that can interact with a single database source to enter, update and retrieve station metadata easily and efficiently. The timeline for this project is to have the system functioning as the primary metadata source for the SCMC by September 1, 2005.

Documentation:
SIS Project Plan (Word document download)
SIS Entity-Relationship Diagram (jpeg file)
SIS Database Naming Conventions (Word document download)

Progress:
View Station Hardware Information
Searchable Database Schema Documentation
Stored Procedure Documentation
Import of Historical Station Information
Sample report of Digital Station Information
Ongoing Development Tracking

Problem Statement: The current methods of keeping track of all station information at the SCMC are not providing the functionality required to meet the needs of all of the users who need complete, accurate station information from a single source.

Scope: The scope of the system is to develop and implement a simplified metadata information system with the following capabilities:

• Provide accurate station/channel information for active stations to the SCSN real-time processing system.
• Provide accurate station/channel information for active and historic stations that have parametric data at the SCEDC e.g., for users retrieving data via STP from the SCEDC.
• Provide all necessary information to generate dataless SEED volumes for active and historic stations that have data at the SCEDC.
• Provide all necessary information to generate COSMOS V0 metadata information.
• Be updated through a graphical interface that is designed to minimize editing mistakes.
• Allow stations to be added to the system with a minimum, but incomplete set of information using predefined defaults that can be easily updated as more information becomes available. This aspect of the system becomes increasingly important with historic data when some aspects of the meta-data are simply not known.
• Facilitate statewide metadata exchange for both real-time processing and provide a common approach to CISN historic station metadata.

The system that will be developed has two fundamental design requirements:

• A well-designed database that is the single source of information, i.e., the authoritative information is what is contained in the database, not in flat-files or any other databases.
• Applications that interact with the data will interact directly with the database, i.e., they will not check information out of the database, manipulate it in another environment, and repopulate the database with the modified information.

Please send any questions, comments and suggestions about this project to Vikki Appel: