climateindexes_v090_sql.json

Thomas Gumbricht bio photo By Thomas Gumbricht

jsonsql/climateindexes (setup_db)

Adds the schema and table for climate indexes

The json command file climateindexes_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": "climateindex",
        "table": "climindex",
        "command": [
          "index TEXT NOT NULL",
          "acqdate date",
          "acqdatestr char(6)",
          "value real",
          "PRIMARY KEY(index,acqdate)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "climateindex",
        "table": "indexmeta",
        "command": [
          "index TEXT NOT NULL",
          "type TEXT NOT NULL",
          "source TEXT NOT NULL",
          "url TEXT NOT NULL",
          "update date",
          "PRIMARY KEY (index)"
        ]
      }
    }
  ]
}