Skip to topic | Skip to bottom
Home
Main
Main.sst_and_wind_table_detailsr1.1 - 23 Mar 2005 - 16:50 - CharltonPurvistopic end

Start of topic | Skip to actions
sea_coos_obs=# \d wind_prod
                                      Table "public.wind_prod"
           Column            |            Type             |               Modifiers                
-----------------------------+-----------------------------+----------------------------------------
 station_id                  | character varying           | not null
 time_stamp                  | timestamp without time zone | not null
 z                           | double precision            | not null
 wind_speed                  | double precision            | 
 wind_from_direction         | double precision            | 
 label_theta                 | double precision            | 
 label_char                  | character(1)                | 
 lon                         | double precision            | 
 lat                         | double precision            | 
 title                       | character varying           | 
 institution                 | character varying           | 
 institution_url             | character varying           | 
 institution_dods_url        | character varying           | 
 source                      | character varying           | 
 refs                        | character varying           | 
 contact                     | character varying           | 
 report_time_stamp           | timestamp without time zone | 
 show                        | integer                     | 
 secs_from_report_time_stamp | integer                     | 
 secs_from_time_stamp        | integer                     | 
 the_geom                    | geometry                    | not null
 wind_speed_knots            | double precision            | 
 can_be_normalized           | character varying           | 
 normalized_wind_speed       | double precision            | 
 normalized_wind_speed_knots | double precision            | 
 normalized_label_char       | character(1)                | 
 positive                    | character varying           | 
 label_z                     | double precision            | 
 wind_from_direction_compass | character varying           | 
 wind_speed_mph              | double precision            | 
 normalized_wind_speed_mph   | double precision            | 
 label_char_knots            | character(1)                | 
 label_char_mph              | character(1)                | 
 normalized_label_char_knots | character(1)                | 
 normalized_label_char_mph   | character(1)                | 
 value                       | character varying           | 
 value_knots                 | character varying           | 
 value_mph                   | character varying           | 
 normalized_value            | character varying           | 
 normalized_value_knots      | character varying           | 
 normalized_value_mph        | character varying           | 
 seq                         | integer                     | default nextval('wind_prod_seq'::text)
Indexes:
    "pk_id_time_stamp_z" primary key, btree (station_id, time_stamp, z)
    "wind_prod__gist" gist (the_geom)
    "wind_prod__id_z_rep_time" btree (station_id, z, report_time_stamp)
    "wind_prod__oid" btree (oid)
    "wind_prod__report_time_stamp" btree (report_time_stamp)
    "wind_prod__seq" btree (seq)
    "wind_prod__show" btree ("show")
    "wind_prod__station_id" btree (station_id)
    "wind_prod__time_stamp" btree (time_stamp)
Check constraints:
    "$1" CHECK (srid(the_geom) = -1)
    "$2" CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL)
    "can_be_normalized_yes_no" CHECK (can_be_normalized::text = 'yes'::character varying::text OR can_be_normalized::text = 'no'::character va
rying::text OR can_be_normalized::text = ''::character varying::text)
    "positive_up_down" CHECK (positive::text = 'up'::character varying::text OR positive::text = 'down'::character varying::text OR positive::
text = ''::character varying::text)
Triggers:
    wind_labels_and_times_trig BEFORE INSERT OR UPDATE ON wind_prod FOR EACH ROW EXECUTE PROCEDURE wind_labels_and_times()

sea_coos_obs=# \d sst_prod
                                      Table "public.sst_prod"
            Column            |            Type             |               Modifiers               
------------------------------+-----------------------------+---------------------------------------
 station_id                   | character varying           | not null
 time_stamp                   | timestamp without time zone | not null
 z                            | double precision            | 
 temperature_celcius          | double precision            | 
 lon                          | double precision            | 
 lat                          | double precision            | 
 title                        | character varying           | 
 institution                  | character varying           | 
 institution_url              | character varying           | 
 institution_dods_url         | character varying           | 
 source                       | character varying           | 
 refs                         | character varying           | 
 contact                      | character varying           | 
 report_time_stamp            | timestamp without time zone | 
 show                         | integer                     | 
 secs_from_report_time_stamp  | integer                     | 
 secs_from_time_stamp         | integer                     | 
 the_geom                     | geometry                    | not null
 positive                     | character varying           | 
 label_z                      | double precision            | 
 temperature_fahrenheit       | double precision            | 
 value_temperature_celcius    | character varying           | 
 value_temperature_fahrenheit | character varying           | 
 seq                          | integer                     | default nextval('sst_prod_seq'::text)
Indexes:
    "pk_id_time_stamp" primary key, btree (station_id, time_stamp)
    "sst_prod__gist" gist (the_geom)
    "sst_prod__id_z_rep_time" btree (station_id, z, report_time_stamp)
    "sst_prod__oid" btree (oid)
    "sst_prod__report_time_stamp" btree (report_time_stamp)
    "sst_prod__seq" btree (seq)
    "sst_prod__show" btree ("show")
    "sst_prod__station_id" btree (station_id)
    "sst_prod__time_stamp" btree (time_stamp)
Check constraints:
    "$1" CHECK (srid(the_geom) = -1)
    "$2" CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL)
    "positive_up_down" CHECK (positive::text = 'up'::character varying::text OR positive::text = 'down'::character varying::text OR positive::
text = ''::character varying::text)
Triggers:
    sst_labels_and_times_trig BEFORE INSERT OR UPDATE ON sst_prod FOR EACH ROW EXECUTE PROCEDURE sst_labels_and_times()

-- CharltonPurvis - 23 Mar 2005
to top


You are here: Main > sst_and_wind_table_details

to top

Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding DMCC? Send feedback