Changeset 49

Show
Ignore:
Timestamp:
07/14/06 10:09:23
Author:
monisha
Message:

qcflags added to salinity_prod, wave_in_situ_prod, current_in_situ_map and removed from wind_map

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • db/trunk/schema/sea_coos_obs.sql

    r48 r49  
    31293129    qcflag_data_availability character(1), 
    31303130    qcflag_sensor_range character(1), 
    3131     qcflag_gross range character(1), 
     3131    qcflag_gross_range character(1), 
    31323132    qcflag_climatological_range character(1), 
    31333133    qcflag_rate_of_change character(1), 
    3134     qcflag_aggregate character varying,        
     3134    qcflag_aggregate character(1),     
    31353135    CONSTRAINT "$1" CHECK ((srid(the_geom) = -1)), 
    31363136    CONSTRAINT "$2" CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL))), 
    …… 
    32793279    qcflag_data_availability character(1), 
    32803280    qcflag_sensor_range character(1), 
    3281     qcflag_gross range character(1), 
     3281    qcflag_gross_range character(1), 
    32823282    qcflag_climatological_range character(1), 
    32833283    qcflag_rate_of_change character(1), 
    3284     qcflag_aggregate character varying,        
     3284    qcflag_aggregate character(1),     
    32853285    seq integer DEFAULT nextval('sst_prod_seq'::text), 
    32863286    CONSTRAINT "$1" CHECK ((srid(the_geom) = -1)), 
    …… 
    43054305    normalized_wind_gust_value_knots character varying, 
    43064306    normalized_wind_gust_value_mph character varying, 
    4307     normalized_wind_gust_mph double precision, 
    4308     qcflag_data_availability character(1), 
    4309     qcflag_sensor_range character(1), 
    4310     qcflag_gross range_ character(1), 
    4311     qcflag_climatological_range character(1), 
    4312     qcflag_rate_of_change character(1), 
    4313     qcflag_aggregate character varying,  
     4307    normalized_wind_gust_mph double precision,           
    43144308    CONSTRAINT "$1" CHECK ((srid(the_geom) = -1)), 
    43154309    CONSTRAINT "$2" CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL))) 
    …… 
    57645758    surface_or_bottom character varying, 
    57655759    current_to_direction_compass character varying, 
     5760    qcflag_data_availability character(1), 
     5761    qcflag_sensor_range character(1), 
     5762    qcflag_gross_range character(1), 
     5763    qcflag_climatological_range character(1), 
     5764    qcflag_rate_of_change character(1), 
     5765    qcflag_aggregate character(1),           
    57665766    CONSTRAINT "$2" CHECK ((srid(the_geom) = -1)), 
    57675767    CONSTRAINT "$3" CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL))) 
    …… 
    68886888    seq serial NOT NULL, 
    68896889    the_geom geometry, 
     6890    qcflag_data_availability character(1), 
     6891    qcflag_sensor_range character(1), 
     6892    qcflag_gross_range character(1), 
     6893    qcflag_climatological_range character(1), 
     6894    qcflag_rate_of_change character(1), 
     6895    qcflag_aggregate character(1),       
    68906896    CONSTRAINT "$2" CHECK ((srid(the_geom) = -1)), 
    68916897    CONSTRAINT "$3" CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL))) 
    …… 
    73847390    secs_from_time_stamp integer, 
    73857391    the_geom geometry, 
     7392    qcflag_data_availability character(1), 
     7393    qcflag_sensor_range character(1), 
     7394    qcflag_gross_range character(1), 
     7395    qcflag_climatological_range character(1), 
     7396    qcflag_rate_of_change character(1), 
     7397    qcflag_aggregate character(1),       
    73867398    CONSTRAINT "$2" CHECK ((srid(the_geom) = -1)), 
    73877399    CONSTRAINT "$3" CHECK (((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL)))