landsat_scenecoords_v090_sql.json

Thomas Gumbricht bio photo By Thomas Gumbricht

jsonsql/landsat scenecoords (setup_db)

Add coordinates for landsat tiles

The json command file landsat_scenecoords_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": true,
      "delete": false,
      "parameters": {
        "db": "karttur",
        "schema": "landsat",
        "table": "scenecoords",
        "command": [
          "wrs smallint",
          "dir char(1)",
          "wrspath smallint",
          "wrsrow smallint",
          "wrspr char(8)",
          "EPSG integer",
          "proj4 TEXT",
          "projection TEXT",
          "datum TEXT",
          "refsize real",
          "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 (wrs,dir,wrspath,wrsrow)"
        ]
      }
    }
  ]
}