jsonsql/EASE2N template (setup_db)
Table for templates EASE GRID north
The json command file EASE2N_template_v090_sql.json is part of karttur’s GeoImagine project setup_db. Calling the json file will execute the following commands of the GeoImagine Framework.
{
"process": [
{
"processid": "createtable",
"overwrite": false,
"parameters": {
"db": "karttur",
"schema": "ease2n",
"table": "template",
"command": [
"hdffolder varchar(255)",
"hdfgrid varchar(255)",
"version varchar(8)",
"fileext varchar(8)",
"timestep varchar(16)",
"title varchar(128)",
"label varchar(255)",
"region varchar (32)",
"epsg bigint",
"retrieve character(1)",
"source varchar(32)",
"product varchar(32)",
"content varchar(32)",
"layerid varchar(64)",
"prefix varchar(32)",
"suffix varchar(64)",
"compid TEXT",
"masked character(1) DEFAULT 'N'",
"measure char(1)",
"dataunit varchar(32)",
"scalefac real",
"offsetadd real",
"cellnull bigint",
"celltype varchar(8)",
"PRIMARY KEY (source,product,layerid)"
]
}
},
{
"processid": "tableinsert",
"overwrite": false,
"parameters": {
"db": "karttur",
"schema": "ease2n",
"table": "template",
"command": {
"columns": [
"hdffolder",
"hdfgrid",
"version",
"fileext",
"timestep",
"title",
"label",
"region",
"epsg",
"retrieve",
"source",
"product",
"content",
"layerid",
"prefix",
"suffix",
"compid",
"masked",
"measure",
"dataunit",
"scalefac",
"offsetadd",
"cellnull",
"celltype"
],
"values": [
[
"'MOD_Grid_Seaice_4km_North'",
"'Sea_Ice_by_Reflectance_NP'",
"'006'",
"'tif'",
"'1D'",
"'Sea Ice by Reflectance NP'",
"'Sea Ice by Reflectance NP'",
"'global'",
"'6931'",
"'Y'",
"'modis'",
"'MOD29E1D'",
"'seaice'",
"'seaice'",
"'seaice'",
"'006'",
"'seaice_seaice'",
"'N'",
"'N'",
"'class'",
"'1'",
"'0'",
"'-1'",
"'BYTE'"
],
[
"'MOD_Grid_Seaice_4km_North'",
"'Ice_Surface_Temperature_NP'",
"'006'",
"'tif'",
"'1D'",
"'Ice Surface Temperature NP'",
"'Ice Surface Temperature NP'",
"'global'",
"'6931'",
"'Y'",
"'modis'",
"'MOD29E1D'",
"'seaice'",
"'icetemp'",
"'icetemp'",
"'006'",
"'seaice_icetemp'",
"'N'",
"'R'",
"'Kelvin'",
"'1'",
"'0'",
"'-1'",
"'UINT16'"
]
]
}
}
}
]
}