SMAP_v090_sql.json

Thomas Gumbricht bio photo By Thomas Gumbricht

jsonsql/SMAP (setup_db)

Installs and fills tables for DAAC SMAP data holdings

The json command file SMAP_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": "smap",
        "table": "daacholdings",
        "command": [
          "daacid character(26)",
          "version smallint",
          "metaurl varchar(64)",
          "serverurl varchar(64)",
          "serverpath varchar(64)",
          "startdate date",
          "enddate date",
          "resolkm smallint",
          "temporal varchar(16)",
          "label TEXT",
          "tgcomment varchar(255)",
          "PRIMARY KEY (daacid,version)"
        ]
      }
    },
    {
      "processid": "tableinsert",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "smap",
        "table": "daacholdings",
        "command": {
          "columns": [
            "daacid",
            "version",
            "metaurl",
            "serverurl",
            "serverpath",
            "startdate",
            "enddate",
            "resolkm",
            "temporal",
            "label",
            "tgcomment"
          ],
          "values": [
            [
              "'SPL2SMA'",
              "3",
              "'https://nsidc.org/data/SPL2SMA/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL2SMA.003'",
              "'2015-04-13'",
              "'2015-07-07'",
              "3",
              "'49minutes'",
              "'SMAP L2 Radar Half-Orbit 3 km EASE-Grid Soil Moisture'",
              "'short time orignal 3km scene data'"
            ],
            [
              "'SPL2SMAP'",
              "3",
              "'https://nsidc.org/data/SPL2SMA/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL2SMAP.003'",
              "'2015-04-13'",
              "'2015-07-07'",
              "9",
              "'49minutes'",
              "'SMAP L2 Radar/Radiometer Half-Orbit 9 km EASE-Grid Soil Moisture'",
              "'short time orignal 9km scene data'"
            ],
            [
              "'SPL2SMAP_S'",
              "3",
              "'https://nsidc.org/data/SPL2SMAP_S/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL2SMAP_S.003'",
              "'2015-03-21'",
              "'2100-01-01'",
              "3",
              "'30sec'",
              "'SMAP/Sentinel-1 L2 Radiometer/Radar 30-Second Scene 3 km EASE-Grid Soil Moisture'",
              "'sentinel-e combined 3km data at 30sec'"
            ],
            [
              "'SPL2SMP'",
              "7",
              "'https://nsidc.org/data/SPL2SMP/versions/7'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL2SMP.003'",
              "'2015-03-31'",
              "'2100-01-01'",
              "36",
              "'49minutes'",
              "'SMAP L2 Radiometer Half-Orbit 36 km EASE-Grid Soil Moisture'",
              "'original 36km scene data - skip'"
            ],
            [
              "'SPL2SMP_E'",
              "4",
              "'https://nsidc.org/data/SPL2SMP_E/versions/4'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL2SMP_E.004'",
              "'2015-03-31'",
              "'2100-01-01'",
              "36",
              "'49minutes'",
              "'SMAP Enhanced L2 Radiometer Half-Orbit 9 km EASE-Grid Soil Moisture'",
              "'SMAP enhanced 9km scene data'"
            ],
            [
              "'SPL3FTA'",
              "3",
              "'https://nsidc.org/data/SPL3FTA/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3FTA.003'",
              "'2015-04-13'",
              "'2015-08-07'",
              "3",
              "'1D'",
              "'SMAP L3 Radar Northern Hemisphere Daily 3 km EASE-Grid Freeze/Thaw State'",
              "'short time orignal 3km scene data'"
            ],
            [
              "'SPL3FTP'",
              "3",
              "'https://nsidc.org/data/SPL3FTP/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3FTP.003'",
              "'2015-03-31'",
              "'2100-01-01'",
              "36",
              "'1D'",
              "'SMAP L3 Radiometer Global and Northern Hemisphere Daily 36 km EASE-Grid Freeze/Thaw State'",
              "'SMAP original 36km scene data'"
            ],
            [
              "'SPL3FTP_E'",
              "3",
              "'https://nsidc.org/data/SPL3FTP_E/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3FTP_E.003'",
              "'2015-03-31'",
              "'2100-01-01'",
              "9",
              "'D'",
              "'SMAP Enhanced L3 Radiometer Global and Northern Hemisphere Daily 9 km EASE-Grid Freeze/Thaw State'",
              "'SMAP enhanced 9 km'"
            ],
            [
              "'SPL3SMA'",
              "3",
              "'https://nsidc.org/data/SPL3SMA/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3SMA.003'",
              "'2015-04-13'",
              "'2015-08-07'",
              "3",
              "'1D'",
              "'SMAP L3 Radar Global Daily 3 km EASE-Grid Soil Moisture'",
              "'original daily 3 km product'"
            ],
            [
              "'SPL3SMAP'",
              "3",
              "'https://nsidc.org/data/SPL3SMAP/versions/3'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3SMAP.003'",
              "'2015-04-13'",
              "'2015-07-07'",
              "9",
              "'1D'",
              "'SMAP L3 Radar/Radiometer Global Daily 9 km EASE-Grid Soil Moisture'",
              "'original daily 9 km product'"
            ],
            [
              "'SPL3SMP'",
              "7",
              "'https://nsidc.org/data/SPL3SMP/versions/7'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3SMP.007'",
              "'2015-03-31'",
              "'2100-01-01'",
              "36",
              "'1D'",
              "'SMAP L3 Radiometer Global Daily 36 km EASE-Grid Soil Moisture'",
              "'SMAP 36 km standard product'"
            ],
            [
              "'SPL3SMP_E'",
              "4",
              "'https://nsidc.org/data/SPL3SMP_E/versions/4'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL3SMP_E.004'",
              "'2015-03-31'",
              "'2100-01-01'",
              "9",
              "'1D'",
              "'SMAP Enhanced L3 Radiometer Global Daily 9 km EASE-Grid Soil Moisture'",
              "'SMAP enhanced 9 km product'"
            ],
            [
              "'SPL4CMDL'",
              "4",
              "'https://nsidc.org/data/SPL4CMDL/versions/4'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL4CMDL.005'",
              "'2015-03-31'",
              "'2100-01-01'",
              "9",
              "'1D'",
              "'SMAP L4 Global Daily 9 km EASE-Grid Carbon Net Ecosystem Exchange'",
              "'SMAP carbon flux'"
            ],
            [
              "'SPL4SMAU'",
              "5",
              "'https://nsidc.org/data/SPL4SMAU/versions/5'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL4SMAU.005'",
              "'2015-03-31'",
              "'2100-01-01'",
              "9",
              "'3H'",
              "'SMAP L4 Global 3-hourly 9 km EASE-Grid Surface and Root Zone Soil Moisture Analysis Update'",
              "'SMAP root zone moisture'"
            ],
            [
              "'SPL4SMGP'",
              "5",
              "'https://nsidc.org/data/SPL4SMGP/versions/5'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL4SMGP.005'",
              "'2015-03-31'",
              "'2100-01-01'",
              "9",
              "'3H'",
              "'SMAP L4 Global 3-hourly 9 km EASE-Grid Surface and Root Zone Soil Moisture Geophysical Data'",
              "'skip for now'"
            ],
            [
              "'SPL4SMLM'",
              "5",
              "'https://nsidc.org/data/SPL4SMLM/versions/5'",
              "'https://n5eil01u.ecs.nsidc.org'",
              "'SMAP/SPL4SMLM.005'",
              "'2015-03-31'",
              "'2100-01-01'",
              "9",
              "'static'",
              "'SMAP L4 Global 9 km EASE-Grid Surface and Root Zone Soil Moisture Land Model Constants'",
              "'skip for now'"
            ]
          ]
        }
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "smap",
        "table": "daacdata",
        "command": [
          "daacid varchar(64)",
          "version character(3)",
          "filename character varying(128)",
          "acqdate date",
          "doy smallint",
          "downloaded character(1) DEFAULT 'N'",
          "organized character(1) DEFAULT 'N'",
          "exploded character(1) DEFAULT 'N'",
          "redundant character(1) DEFAULT 'N'",
          "deleted character(1) DEFAULT 'N'",
          "maskstatus character(1) DEFAULT 'Y'",
          "PRIMARY KEY (filename)"
        ]
      }
    }
  ]
}