sentinel_tilecoords_v090_sql.json

Thomas Gumbricht bio photo By Thomas Gumbricht

jsonsql/sentinel tilecoords (setup_db)

Add the coordinates for sentinel tiles

The json command file sentinel_tilecoords_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": "sentinel",
        "table": "tilecoords",
        "command": [
          "mgrs char(5)",
          "EPSG integer",
          "proj4 TEXT",
          "projection TEXT",
          "datum TEXT",
          "utmzone integer",
          "mgrsid varchar(3)",
          "refsize real",
          "reflins integer",
          "refcols integer",
          "ullat double precision",
          "ullon double precision",
          "urlat double precision",
          "urlon double precision",
          "lllat double precision",
          "lllon double precision",
          "lrlat double precision",
          "lrlon double precision",
          "centerlat double precision",
          "centerlon double precision",
          "west double precision",
          "east double precision",
          "north  double precision",
          "south double precision",
          "minx double precision",
          "miny double precision",
          "maxx  double precision",
          "maxy  double precision",
          "centerx double precision",
          "centery double precision",
          "PRIMARY KEY (mgrs)"
        ]
      }
    },
    {
      "processid": "createtable",
      "overwrite": false,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "sentinel",
        "table": "mgrscoords",
        "command": [
          "mgrs char(5)",
          "west double precision",
          "east double precision",
          "north  double precision",
          "south double precision",
          "minx double precision",
          "miny double precision",
          "maxx  double precision",
          "maxy  double precision",
          "sentinel char(1)",
          "PRIMARY KEY (mgrs)"
        ]
      }
    }
  ]
}