- 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)gid name Name unit categories detailView searchView exploreView scale_names scale_colors 8018541 alkalinity-glenda Alkalinity mg/L ["Nutrients" ] ["time"] TRUE TRUE 8018542 chlorophyll-a-glenda Chlorophyll a ug/L ["Nutrients" ] ["time"] TRUE TRUE 8018543 nitrogen-glenda Nitrite-Nitrate mg/L ["Nutrients" ] ["time"] TRUE TRUE 8018544 silica-glenda Silica mg/L ["Nutrients" ] ["time"] TRUE TRUE 8018545 total-phosphorus-glenda Total Phosphorus ug/L ["Nutrients" ] ["time"] TRUE TRUE 8018546 turbidity-glenda Turbity NTU ["Nutrients" ] ["time", "stacked_line"] TRUE TRUE 8018547 biomass Zooplankton Biomass ug/m^3 ["Biology"] ["stacked_bar"] TRUE TRUE ["Calanoids", "Cyclopoids", "Limnocalanus", "Daphnids Cladocerans", "Predatory Cladocerans", "Non-Daphnid Cladocerans"] ["#00FFFF", "#FFFF00", "#0000FF", "#FF3939", "#660000", "#660066"] 8018548 density Zooplankton Density #/m^3 ["Biology"] ["stacked_bar"] TRUE TRUE ["Calanoids", "Cyclopoids", "Limnocalanus", "Daphnids Cladocerans", "Predatory Cladocerans", "Non-Daphnid Cladocerans"] ["#00FFFF", "#FFFF00", "#0000FF", "#FF3939", "#660000", "#660066"] - Sources
Page History
Overview
Content Tools