jsonsql/MODISpolar template (setup_db)
MODISpolar templates (identical to SMAP templates)
The json command file MODISpolar_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,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "modispolar",
"table": "template",
"command": [
"daacid varchar(16)",
"version varchar(4)",
"source varchar(32)",
"product varchar(24)",
"content varchar(32)",
"layerid varchar(64)",
"prefix varchar(32)",
"suffix varchar(32)",
"fileext varchar(8)",
"region varchar (32)",
"celltype varchar(8)",
"dataunit varchar(32)",
"compid varchar(128)",
"hdffolder varchar(255)",
"hdfgrid varchar(255)",
"band smallint DEFAULT 1",
"scalefac real",
"offsetadd real",
"cellnull bigint",
"measure char(1)",
"masked char(1) DEFAULT 'N'",
"timestep varchar(16)",
"retrieve character(1)",
"title varchar(128)",
"label varchar(255)",
"system varchar(16)",
"epsg bigint",
"ullat double precision",
"ullon double precision",
"lrlat double precision",
"lrlon double precision",
"ulx double precision",
"uly double precision",
"lrx double precision",
"lry double precision",
"PRIMARY KEY (daacid,version,layerid)"
]
}
},
{
"processid": "tableinsert",
"overwrite": true,
"parameters": {
"db": "karttur",
"schema": "modispolar",
"table": "template",
"command": {
"columns": [
"daacid",
"version",
"hdffolder",
"hdfgrid",
"fileext",
"timestep",
"title",
"label",
"region",
"system",
"epsg",
"ullat",
"ullon",
"lrlat",
"lrlon",
"ulx",
"uly",
"lrx",
"lry",
"retrieve",
"source",
"product",
"content",
"layerid",
"prefix",
"suffix",
"compid",
"masked",
"measure",
"dataunit",
"scalefac",
"offsetadd",
"cellnull",
"celltype"
],
"values": [
[
"'MOD29E1D'",
"'006'",
"'MOD_Grid_Seaice_4km_North'",
"'Sea_Ice_by_Reflectance_NP'",
"'tif'",
"'1D'",
"'Sea Ice by Reflectance NP'",
"'Sea Ice Extent Global 4km EASE-Grid 2.0 North'",
"'northpolar'",
"'ease2n'",
"'6931'",
"'0'",
"'0'",
"'0'",
"'0'",
"'-9058902.1345'",
"'9058902.1845'",
"'9058902.1845'",
"'-9058902.1345'",
"'Y'",
"'MOD29E1D.006'",
"'MOD29E1D'",
"'seaice'",
"'seaice-northpolar'",
"'seaice'",
"'006'",
"'seaice_seaice'",
"'N'",
"'N'",
"'class'",
"'1'",
"'0'",
"'253'",
"'BYTE'"
],
[
"'MOD29E1D'",
"'006'",
"'MOD_Grid_Seaice_4km_North'",
"'Ice_Surface_Temperature_NP'",
"'tif'",
"'1D'",
"'Ice Surface Temperature NP'",
"'Sea Ice Temperature Global 4km EASE-Grid 2.0 North'",
"'northpolar'",
"'ease2n'",
"'6931'",
"'0'",
"'0'",
"'0'",
"'0'",
"'-9058902.1345'",
"'9058902.1845'",
"'9058902.1845'",
"'-9058902.1345'",
"'Y'",
"'MOD29E1D.006'",
"'MOD29E1D'",
"'seaice'",
"'icetemp-northpolar'",
"'icetemp'",
"'006'",
"'seaice_icetemp'",
"'N'",
"'R'",
"'kelvin'",
"'1'",
"'0'",
"'8'",
"'UINT16'"
],
[
"'MOD29E1D'",
"'006'",
"'MOD_Grid_Seaice_4km_South'",
"'Sea_Ice_by_Reflectance_SP'",
"'tif'",
"'1D'",
"'Sea Ice by Reflectance SP'",
"'Sea Ice Extent Global 4km EASE-Grid 2.0 South'",
"'southpolar'",
"'ease2s'",
"'6932'",
"'0'",
"'0'",
"'0'",
"'0'",
"'-9058902.1345'",
"'9058902.1845'",
"'9058902.1845'",
"'-9058902.1345'",
"'Y'",
"'MOD29E1D.006'",
"'MOD29E1D'",
"'seaice'",
"'seaice-southpolar'",
"'seaice'",
"'006'",
"'seaice_seaice'",
"'N'",
"'N'",
"'class'",
"'1'",
"'0'",
"'253'",
"'BYTE'"
],
[
"'MOD29E1D'",
"'006'",
"'MOD_Grid_Seaice_4km_South'",
"'Ice_Surface_Temperature_SP'",
"'tif'",
"'1D'",
"'Ice Surface Temperature SP'",
"'Sea Ice Temperature Global 4km EASE-Grid 2.0 South'",
"'southpolar'",
"'ease2s'",
"'6932'",
"'0'",
"'0'",
"'0'",
"'0'",
"'-9058902.1345'",
"'9058902.1845'",
"'9058902.1845'",
"'-9058902.1345'",
"'Y'",
"'MOD29E1D.006'",
"'MOD29E1D'",
"'seaice'",
"'icetemp-southpolar'",
"'icetemp'",
"'006'",
"'seaice_icetemp'",
"'N'",
"'R'",
"'kelvin'",
"'1'",
"'0'",
"'8'",
"'UINT16'"
]
]
}
}
}
]
}