modis_template_v090_sql.json

Thomas Gumbricht bio photo By Thomas Gumbricht

jsonsql/modis template (setup_db)

Install MODIS template table, and add records for the MODIS products in use

The json command file modis_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": "modis",
        "table": "template",
        "command": [
          "source character varying(32)",
          "product varchar(24)",
          "folder varchar(32)",
          "band character varying(32)",
          "prefix varchar(32)",
          "suffix varchar(32)",
          "fileext varchar(8)",
          "celltype character varying(8)",
          "dataunit character varying(32)",
          "compid varchar(128)",
          "hdffolder varchar(64)",
          "hdfgrid varchar(64)",
          "scalefac real",
          "offsetadd real",
          "cellnull bigint",
          "measure char(1)",
          "timestep varchar(16)",
          "retrieve character(1)",
          "ecode character varying(32)",
          "PRIMARY KEY (source,band)"
        ]
      }
    },
    {
      "processid": "tableinsert",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "modis",
        "table": "template",
        "command": {
          "columns": [
            "source",
            "product",
            "folder",
            "band",
            "prefix",
            "suffix",
            "fileext",
            "celltype",
            "dataunit",
            "compid",
            "hdfgrid",
            "hdffolder",
            "scalefac",
            "offsetadd",
            "cellnull",
            "retrieve",
            "ecode",
            "measure"
          ],
          "values": [
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'IGBP'",
              "'IGBP'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'landcover_IGBP'",
              "'Land_Cover_Type_1'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'Y'",
              "'1'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'UMD'",
              "'UMD'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'landcover_UMD'",
              "'Land_Cover_Type_2'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'01'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'LAI-fPAR'",
              "'LAI-fPAR'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'landcover_LAI-fPAR'",
              "'Land_Cover_Type_3'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'NPP-BGC'",
              "'NPP-BGC'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'landcover_NPP-BGC'",
              "'Land_Cover_Type_4'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'0001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'PFT'",
              "'PFT'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'landcover_PFT'",
              "'Land_Cover_Type_5'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'00001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'IGBP-assess'",
              "'IGBP-assess'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'lc-ancillary_IGBP-assess'",
              "'Land_Cover_Type_1_Assessment'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'UMD-assess'",
              "'UMD-assesss'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'lc-ancillary_UMD-assess'",
              "'Land_Cover_Type_2_Assessment'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'0000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'LAI-fPAR-assess'",
              "'LAI-fPAR-assess'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'lc-ancillary_LAI-fPAR-assess'",
              "'Land_Cover_Type_3_Assessment'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'0000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'NPP-BGC-assess'",
              "'NPP-BGC-assess'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'lc-ancillary_NPP-BGC-assess'",
              "'Land_Cover_Type_4_Assessment'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'PFT-assess'",
              "'PFT-assess'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'lc-ancillary_PFT-assess'",
              "'Land_Cover_Type_5_Assessment'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'0000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'Quality'",
              "'Quality'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'lc-ancillary_Quality'",
              "'Land_Cover_QC'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'00000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'IGBP-2nd'",
              "'IGBP-2nd'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Class'",
              "'landcover_IGBP-2nd'",
              "'Land_Cover_Type_1_Secondary'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'000000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'landcover'",
              "'IGBP-2nd-percent'",
              "'IGBP-2nd'",
              "''",
              "'.tif'",
              "'Byte'",
              "'Percent'",
              "'landcover_IGBP-2nd-percent'",
              "'Land_Cover_Type_1_Secondary_Percent'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'0000000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'LC-property-1'",
              "'LC-property-1'",
              "''",
              "'.tif'",
              "'Byte'",
              "'na'",
              "'lc-ancillary_LC-property-1'",
              "'LC_Property_1'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'00000000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'LC-property-2'",
              "'LC-property-2'",
              "''",
              "'.tif'",
              "'Byte'",
              "'na'",
              "'lc-ancillary_LC-property-2'",
              "'LC_Property_2'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'000000000000001'",
              "'N'"
            ],
            [
              "'MOD12Q1v006'",
              "'MOD12Q1'",
              "'lc-ancillary'",
              "'LC-property-3'",
              "'LC-property-3'",
              "''",
              "'.tif'",
              "'Byte'",
              "'na'",
              "'lc-ancillary_LC-property-3'",
              "'LC_Property_3'",
              "'hdfgrid'",
              "1",
              "0",
              "255",
              "'N'",
              "'0000000000000001'",
              "'N'"
            ]
          ]
        }
      }
    },
    {
      "processid": "tableinsert",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "modis",
        "table": "template",
        "command": {
          "columns": [
            "source",
            "product",
            "folder",
            "band",
            "prefix",
            "suffix",
            "fileext",
            "celltype",
            "dataunit",
            "compid",
            "hdfgrid",
            "hdffolder",
            "scalefac",
            "offsetadd",
            "cellnull",
            "retrieve",
            "ecode",
            "measure"
          ],
          "values": [
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'rl'",
              "'rl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_rl'",
              "'sur_refl_b01'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'1'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'na'",
              "'na-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_na'",
              "'sur_refl_b02'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'01'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'bl'",
              "'bl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_bl'",
              "'sur_refl_b03'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'gl'",
              "'gl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_gl'",
              "'sur_refl_b04'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'0001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'ma'",
              "'ma-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_ma'",
              "'sur_refl_b05'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'00001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'mb'",
              "'mb-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_mb'",
              "'sur_refl_b06'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'000001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi'",
              "'mc'",
              "'mc-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_mc'",
              "'sur_refl_b07'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'0000001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi-ancillary'",
              "'Quality'",
              "'Quality'",
              "'v006'",
              "'.tif'",
              "'INT32'",
              "'Bits'",
              "'srfi-ancillary_Quality'",
              "'sur_refl_qc_500m'",
              "'hdfgrid'",
              "1",
              "0",
              "4294967295",
              "'Y'",
              "'00000001'",
              "'N'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi-ancillary'",
              "'sur-refl-szen'",
              "'sur-refl-szen'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Degree'",
              "'srfi-ancillary_sur-refl-szen'",
              "'sur_refl_szen'",
              "'hdfgrid'",
              "0.01",
              "0",
              "0",
              "'N'",
              "'000000001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi-ancillary'",
              "'sur-refl-vzen'",
              "'sur-refl-vzen'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Degree'",
              "'srfi-ancillary_sur-refl-vzen'",
              "'sur_refl_vzen'",
              "'hdfgrid'",
              "0.01",
              "0",
              "0",
              "'N'",
              "'0000000001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi-ancillary'",
              "'sur-refl-raz'",
              "'sur-refl-raz'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Degree'",
              "'srfi-ancillary_sur-refl-raz'",
              "'sur_refl_raz'",
              "'hdfgrid'",
              "0.01",
              "0",
              "0",
              "'N'",
              "'00000000001'",
              "'R'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi-ancillary'",
              "'State'",
              "'State'",
              "'v006'",
              "'.tif'",
              "'UINT16'",
              "'Bits'",
              "'srfi-ancillary_State'",
              "'sur_refl_state_500m'",
              "'hdfgrid',1,0,65535,'Y'",
              "'000000000001'",
              "'N'"
            ],
            [
              "'MOD09A1v006'",
              "'MOD09A1'",
              "'srfi-ancillary'",
              "'DOY'",
              "'DOY'",
              "'v006'",
              "'.tif'",
              "'UINT16'",
              "'doy'",
              "'srfi-ancillary_DOY'",
              "'sur_refl_day_of_year'",
              "'hdfgrid',1,0,65535,'Y'",
              "'0000000000001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'rl'",
              "'rl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_rl'",
              "'sur_refl_b01'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'1'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'na'",
              "'na-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_na'",
              "'sur_refl_b02'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'01'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'bl'",
              "'bl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_bl'",
              "'sur_refl_b03'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'gl'",
              "'gl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_gl'",
              "'sur_refl_b04'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'0001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'ma'",
              "'ma-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_ma'",
              "'sur_refl_b05'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'00001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'mb'",
              "'mb-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_mb'",
              "'sur_refl_b06'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'000001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi'",
              "'mc'",
              "'mc-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_mc'",
              "'sur_refl_b07'",
              "'hdfgrid'",
              "0.0001",
              "0",
              "-38672",
              "'Y'",
              "'0000001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi-ancillary'",
              "'Quality'",
              "'Quality'",
              "'v006'",
              "'.tif'",
              "'INT32'",
              "'Bits'",
              "'srfi-ancillary_Quality'",
              "'sur_refl_qc_500m'",
              "'hdfgrid'",
              "1",
              "0",
              "4294967295",
              "'Y'",
              "'00000001'",
              "'N'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi-ancillary'",
              "'sur-refl-szen'",
              "'sur-refl-szen'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Degree'",
              "'srfi-ancillary_sur-refl-szen'",
              "'sur_refl_szen'",
              "'hdfgrid'",
              "0.01",
              "0",
              "0",
              "'N'",
              "'000000001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi-ancillary'",
              "'sur-refl-vzen'",
              "'sur-refl-vzen'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Degree'",
              "'srfi-ancillary_sur-refl-vzen'",
              "'sur_refl_vzen'",
              "'hdfgrid'",
              "0.01",
              "0",
              "0",
              "'N'",
              "'0000000001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi-ancillary'",
              "'sur-refl-raz'",
              "'sur-refl-raz'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Degree'",
              "'srfi-ancillary_sur-refl-raz'",
              "'sur_refl_raz'",
              "'hdfgrid'",
              "0.01",
              "0",
              "0",
              "'N'",
              "'00000000001'",
              "'R'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi-ancillary'",
              "'State'",
              "'State'",
              "'v006'",
              "'.tif'",
              "'UINT16'",
              "'Bits'",
              "'srfi-ancillary_State'",
              "'sur_refl_state_500m'",
              "'hdfgrid',1,0,65535,'Y'",
              "'000000000001'",
              "'N'"
            ],
            [
              "'MYD09A1v006'",
              "'MYD09A1'",
              "'srfi-ancillary'",
              "'DOY'",
              "'DOY'",
              "'v006'",
              "'.tif'",
              "'UINT16'",
              "'doy'",
              "'srfi-ancillary_DOY'",
              "'sur_refl_day_of_year'",
              "'hdfgrid',1,0,65535,'Y'",
              "'0000000000001'",
              "'R'"
            ]
          ]
        }
      }
    },
    {
      "processid": "tableinsert",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "modis",
        "table": "template",
        "command": {
          "columns": [
            "source",
            "product",
            "folder",
            "band",
            "prefix",
            "suffix",
            "fileext",
            "celltype",
            "dataunit",
            "compid",
            "hdfgrid",
            "hdffolder",
            "scalefac",
            "offsetadd",
            "cellnull",
            "retrieve",
            "ecode",
            "measure"
          ],
          "values": [
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'rl'",
              "'rl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_rl'",
              "'Nadir_Reflectance_Band1'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'1'",
              "'R'"
            ],
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'na'",
              "'na-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_na'",
              "'Nadir_Reflectance_Band2'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'01'",
              "'R'"
            ],
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'bl'",
              "'bl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_bl'",
              "'Nadir_Reflectance_Band3'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'001'",
              "'R'"
            ],
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'gl'",
              "'gl-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_gl'",
              "'Nadir_Reflectance_Band4'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'0001'",
              "'R'"
            ],
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'ma'",
              "'ma-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_ma'",
              "'Nadir_Reflectance_Band5'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'00001'",
              "'R'"
            ],
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'mb'",
              "'mb-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_mb'",
              "'Nadir_Reflectance_Band6'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'000001'",
              "'R'"
            ],
            [
              "'MCD43A4v006'",
              "'MCD43A4'",
              "'srfi'",
              "'mc'",
              "'mc-srfi'",
              "'v006'",
              "'.tif'",
              "'INT16'",
              "'Reflectance'",
              "'srfi_mc'",
              "'Nadir_Reflectance_Band7'",
              "'MOD_Grid_BRDF'",
              "0.0001",
              "0",
              "32767",
              "'Y'",
              "'0000001'",
              "'R'"
            ]
          ]
        }
      }
    },
    {
      "processid": "tableinsert",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "modis",
        "table": "template",
        "command": {
          "columns": [
            "source",
            "product",
            "folder",
            "band",
            "prefix",
            "suffix",
            "fileext",
            "celltype",
            "dataunit",
            "compid",
            "hdfgrid",
            "hdffolder",
            "scalefac",
            "offsetadd",
            "cellnull",
            "retrieve",
            "ecode",
            "measure"
          ],
          "values": [
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecover'",
              "'treecover'",
              "'treecover'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Percent'",
              "'treecover_treecover'",
              "'Percent_Tree_Cover'",
              "'MOD44B_250m_GRID',1,0,253,'Y'",
              "'1'",
              "'R'"
            ],
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecov-ancillary'",
              "'Quality'",
              "'Quality'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'treecov-ancillary_quality'",
              "'MOD44B_250m_GRID'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "-99",
              "'N'",
              "'01'",
              "'N'"
            ],
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecov-ancillary'",
              "'treecover-std'",
              "'treecove-std'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'treecov-ancillary_treecove-std'",
              "'Percent_Tree_Cover_SD'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "-99",
              "'N'",
              "'001'",
              "'R'"
            ],
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecov-ancillary'",
              "'cloud'",
              "'cloud'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'treecov-ancillary_cloud'",
              "'MOD44B_250m_GRID'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "-99",
              "'N'",
              "'0001'",
              "'N'"
            ]
          ]
        }
      }
    },
    {
      "processid": "tableinsert",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "modis",
        "table": "template",
        "command": {
          "columns": [
            "source",
            "product",
            "folder",
            "band",
            "prefix",
            "suffix",
            "fileext",
            "celltype",
            "dataunit",
            "compid",
            "hdfgrid",
            "hdffolder",
            "scalefac",
            "offsetadd",
            "cellnull",
            "retrieve",
            "ecode",
            "measure"
          ],
          "values": [
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecover'",
              "'treecover'",
              "'treecover'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Percent'",
              "'treecover_treecover'",
              "'Percent_Tree_Cover'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "253",
              "'Y'",
              "'1'",
              "'R'"
            ],
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecov-ancillary'",
              "'Quality'",
              "'Quality'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'treecov-ancillary_quality'",
              "'MOD44B_250m_GRID'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "-99",
              "'N'",
              "'01'",
              "'N'"
            ],
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecov-ancillary'",
              "'treecover-std'",
              "'treecove-std'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'treecov-ancillary_treecove-std'",
              "'Percent_Tree_Cover_SD'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "-99",
              "'N'",
              "'001'",
              "'R'"
            ],
            [
              "'MOD44B005'",
              "'MOD44B'",
              "'treecov-ancillary'",
              "'cloud'",
              "'cloud'",
              "'v006'",
              "'.tif'",
              "'Byte'",
              "'Bits'",
              "'treecov-ancillary_cloud'",
              "'MOD44B_250m_GRID'",
              "'MOD44B_250m_GRID'",
              "1",
              "0",
              "-99",
              "'N'",
              "'0001'",
              "'N'"
            ]
          ]
        }
      }
    }
  ]
}