jsonsql/default system regions (setup_db)
Install region tables for the default systems
The json command file default_system_regions_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": "regions",
"command": [
"regionid varchar(64)",
"regiontype varchar(8)",
"mgrs char(5)",
"utm smallint",
"mgrsid char(3)",
"PRIMARY KEY (regionid,mgrsid)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "modis",
"table": "regions",
"command": [
"regionid varchar(64)",
"regiontype varchar(8)",
"xtile smallint",
"ytile smallint",
"PRIMARY KEY (regionid,xtile,ytile)"
]
}
},
{
"processid": "createtable",
"overwrite": true,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "landsat",
"table": "regions",
"command": [
"regionid varchar(64)",
"regiontype varchar(8)",
"wrspath smallint",
"wrsrow smallint",
"wrs smallint",
"dir char(1)",
"wrsprstr char(8)",
"PRIMARY KEY (regionid,wrs,dir,wrspath,wrsrow)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "ease2n",
"table": "regions",
"command": [
"regionid varchar(64)",
"regiontype varchar(8)",
"xtile smallint",
"ytile smallint",
"PRIMARY KEY (regionid,xtile,ytile)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "ease2s",
"table": "regions",
"command": [
"regionid varchar(64)",
"regiontype varchar(8)",
"xtile smallint",
"ytile smallint",
"PRIMARY KEY (regionid,xtile,ytile)"
]
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "ease2t",
"table": "regions",
"command": [
"regionid varchar(64)",
"regiontype varchar(8)",
"xtile smallint",
"ytile smallint",
"PRIMARY KEY (regionid,xtile,ytile)"
]
}
}
]
}