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
{"id": 8018543, "name": "nitrogen-glenda", "title": "Nitrite-Nitrate", "unit": "mg/L", "categories": ["nutrients"], "detail_view": ["time"], "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"] } |