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

Code Block

language	js
title	/api/parameters
linenumbers	true

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

Page tree

Versions Compared

Old Version 3

New Version 4

Key