You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

  1. Parameters

    CREATE TABLE public.parameters
    (
        gid int DEFAULT nextval('geoindex_gid_seq'::regclass) PRIMARY KEY NOT NULL,
        name varchar(50) NOT NULL,
        title varchar(100),
        unit varchar(20),
        categories varchar(200),
        detail_view varchar(100),
        search_view boolean DEFAULT true ,
        explore_view boolean DEFAULT true ,
        scale_names varchar(250),
        scale_colors varchar(100)
    );
    CREATE UNIQUE INDEX parameters_gid_uindex ON public.parameters (gid);
    CREATE UNIQUE INDEX parameters_name_uindex ON public.parameters (name);  


    Sample For GLM (Not complete)


    gidnameNameunitcategoriesdetailViewsearchViewexploreViewscale_namesscale_colors
    8018541alkalinity-glendaAlkalinitymg/L["Nutrients" ]["time"]TRUETRUE

    8018542chlorophyll-a-glendaChlorophyll aug/L["Nutrients" ]["time"]TRUETRUE

    8018543nitrogen-glendaNitrite-Nitratemg/L["Nutrients" ]["time"]TRUETRUE

    8018544silica-glendaSilicamg/L["Nutrients" ]["time"]TRUETRUE

    8018545total-phosphorus-glendaTotal Phosphorusug/L["Nutrients" ]["time"]TRUETRUE

    8018546turbidity-glendaTurbityNTU["Nutrients" ]["time", "stacked_line"]TRUETRUE

    8018547biomassZooplankton Biomassug/m^3["Biology"]["stacked_bar"]TRUETRUE["Calanoids", "Cyclopoids", "Limnocalanus", "Daphnids Cladocerans", "Predatory Cladocerans", "Non-Daphnid Cladocerans"]["#00FFFF", "#FFFF00", "#0000FF", "#FF3939", "#660000", "#660066"]
    8018548densityZooplankton Density#/m^3["Biology"]["stacked_bar"]TRUETRUE["Calanoids", "Cyclopoids", "Limnocalanus", "Daphnids Cladocerans", "Predatory Cladocerans", "Non-Daphnid Cladocerans"]["#00FFFF", "#FFFF00", "#0000FF", "#FF3939", "#660000", "#660066"]
  2.  Sources
  • No labels