jsonsql/general GDALtypes (setup_db)
Install and fill the tables that define the different cell types and file types that the system can handle
The json command file general_GDALtypes_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": "process",
"table": "celltypes",
"command": [
"gdal varchar(8)",
"arr char(1)",
"np varchar(8)",
"usgs varchar(8)",
"PRIMARY KEY (gdal)"
]
}
},
{
"processid": "tableinsert",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "celltypes",
"command": {
"columns": [
"gdal",
"arr",
"np",
"usgs"
],
"values": [
[
"'Byte'",
"'B'",
"'uint8'",
"'UINT8'"
],
[
"'Int16'",
"'h'",
"'int16'",
"'INT16'"
],
[
"'UInt16'",
"'H'",
"'uint16'",
"'UINT16'"
],
[
"'Int32'",
"'l'",
"'int32'",
"'INT32'"
],
[
"'UInt32'",
"'L'",
"'uint32'",
"'UINT32'"
],
[
"'Float32'",
"'f'",
"'float32'",
"'FLOAT32'"
],
[
"'Float64'",
"'d'",
"'float64'",
"'FLOAT64'"
]
]
}
}
},
{
"processid": "createtable",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "gdalformat",
"command": [
"hdr varchar(8)",
"dat varchar(8)",
"gdaldriver varchar(8)",
"PRIMARY KEY (hdr,dat,gdaldriver)"
]
}
},
{
"processid": "tableinsert",
"overwrite": false,
"delete": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "gdalformat",
"command": {
"columns": [
"hdr", "dat", "gdaldriver"
],
"values": [
[
"'.tif'",
"'*'",
"'GTiff'"
],
[
"'.ers'",
"'*'",
"'ERS'"
],
[
"'tif'",
"'*'",
"'GTiff'"
],
[
"'ers'",
"'*'",
"'ERS'"
],
[
"'csv'",
"'*'",
"'none'"
],
[
"'xml'",
"'*'",
"'none'"
],
[
"'txt'",
"'*'",
"'none'"
],
[
"'.csv'",
"'*'",
"'none'"
],
[
"'.xml'",
"'*'",
"'none'"
],
[
"'.txt'",
"'*'",
"'none'"
],
[
"'.hdf'",
"'*'",
"'HDF4'"
],
[
"'hdf'",
"'*'",
"'HDF4'"
],
[
"'HDF'",
"'*'",
"'HDF4'"
],
[
"'.HDF'",
"'*'",
"'HDF4'"
],
[
"'lis'",
"'*'",
"'GENBIN'"
],
[
"'.lis'",
"'*'",
"'GENBIN'"
],
[
"'1x1'",
"'*'",
"'GENBIN'"
],
[
"'.1x1'",
"'*'",
"'GENBIN'"
],
[
"'hdr'",
"'bil'",
"'bil'"
],
[
"'.hdr'",
"'.bil'",
"'bil'"
],
[
"'shp'",
"'*'",
"'shp'"
],
[
"'.shp'",
"'.*'",
"'shp'"
],
[
"'adf'",
"'*'",
"'AIG'"
],
[
"'.adf'",
"'.*'",
"'AIG'"
],
[
"'zip'",
"'*'",
"'none'"
],
[
"'.zip'",
"'.*'",
"'none'"
],
[
"'adf'",
"'*'",
"'AIG'"
],
[
"'.adf'",
"'.*'",
"'AIG'"
],
[
"'e00'",
"'*'",
"'E00GRID'"
],
[
"'.e00'",
"'.*'",
"'E00GRID'"
],
[
"'tar.gz'",
"'*'",
"'none'"
],
[
"'.tar.gz'",
"'.*'",
"'none'"
],
[
"'sql'",
"'*'",
"'none'"
],
[
"'.sql'",
"'.*'",
"'none'"
],
[
"'pos'",
"'csv'",
"'none'"
],
[
"'.pos'",
"'.csv'",
"'none'"
],
[
"'asc'",
"'aai'",
"'AAIGrid'"
],
[
"'.asc'",
"'.aai'",
"'AAIGrid'"
],
[
"'.zip'",
"'.zip'",
"'none'"
],
[
"'.tar.bz2'",
"'.tar.bz2'",
"'none'"
]
]
}
}
}
]
}