Page History

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
80185418018546	alkalinityturbidity-glenda	AlkalinityTurbity	mg/L	["Nutrients" ]	NTU	nutrients	time, stacked_line["time"]	TRUE	TRUE
8018542	chlorophyll-a-glenda	Chlorophyll a	ug/L	["Nutrients" ]	nutrients	time["time"]	TRUE	TRUE
80185438018544	nitrogensilica-glendaNitrite-Nitrate	Silica	mg/L	["Nutrients" ]	nutrients	time["time"]	TRUE	TRUE
80185448018545	silicatotal-phosphorus-glenda	SilicaTotal Phosphorus	mgug/L	["Nutrients" ]	nutrients	time["time"]	TRUE	TRUE
80185458018541	total-phosphorusalkalinity-glenda	Total PhosphorusAlkalinity	ugmg/L	["Nutrients" ]	nutrients, contaminants	time["time"]	TRUE	TRUE
80185468018543	turbiditynitrogen-glenda	Turbity	NTU	["Nutrients" ]	Nitrite-Nitrate	mg/L	nutrients	time["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"]	biology	["stacked_bar"]	TRUE	TRUE	["Calanoids", " Cyclopoids", " Limnocalanus", " Daphnids Cladocerans", " Predatory Cladocerans", " Non-Daphnid Cladocerans	#00FFFF, #FFFF00, #0000FF, #FF3939, #660000, #660066

/api/parameters

Code Block

language	js
title	/api/parameters
linenumbers	true

{"id": 8018543,"name": "nitrogen-glenda","title": "Nitrite-Nitrate","unit": "mg/L","categories"

]["#00FFFF", "#FFFF00", "#0000FF", "#FF3939", "#660000", "#660066"]8018548densityZooplankton Density#/m^3["Biology"]

: ["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"]

TRUETRUE

,"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

Page tree

Versions Compared

Old Version 2

New Version 3

Key