- 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 8018546 turbidity-glenda Turbity NTU nutrients time, stacked_line TRUE TRUE 8018542 chlorophyll-a-glenda Chlorophyll a ug/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 8018541 alkalinity-glenda Alkalinity mg/L nutrients, contaminants time TRUE TRUE 8018543 nitrogen-glenda Nitrite-Nitrate mg/L nutrients time 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
/api/parameters/api/parameters{"id": 8018543,"name": "nitrogen-glenda","title": "Nitrite-Nitrate","unit": "mg/L","categories": ["nutrients"],"detail_view": ["time\r"],"search_view": true,"explore_view": true,"scale_names": [],"scale_colors": []},{"id": 8018548,"name": "density","title": "Zooplankton Density","unit": "#/m^3","categories": ["biology"],"detail_view": ["stacked_bar"],"search_view": true,"explore_view": true,"scale_names": ["Calanoids","Cyclopoids","Limnocalanus","Daphnids Cladocerans","Predatory Cladocerans","Non-Daphnid Cladocerans"],"scale_colors": ["#00FFFF","#FFFF00","#0000FF","#FF3939","#660000","#660066"]}, - Sources
Overview
Content Tools