This service simply read a file of SHEF data and stores it is a sqlite database. the database is created by the service itself, no user intervention is need. Currently it will only handle 1 format of SHEF .A in the form of
.A STATION 20080410 Z DH2245/DUE/HG 4.2
the spacing must be that way and the /DUE must be there or the service will fail to parse the line of data. The way around that is to integrate/call the shefit program that can process all shef formats and read "shefit" into the database.

The database is created with the statements:
create table data( shef char(7), station varchar(255), date float, val varchar(255) );
create unique index unique_data on data (shef,station,date,val );

Back to Main page  Back to Documenation Logo