ST_GDALDrivers — Gibt eine Liste der Rasterformate aus, die von PostGIS über die Bibliothek GDAL unterstützt werden. Nur die Formate mit can_write=True können von ST_AsGDALRaster verwendet werden.
setof record ST_GDALDrivers(integer OUT idx, text OUT short_name, text OUT long_name, text OUT can_read, text OUT can_write, text OUT create_options);
Gibt eine Liste der Rasterformate aus - short_name, long_name und die Optionen des Urhebers - die von GDAL unterstützt werden. Verwenden Sie den "short_name" als Übergabewert für den Parameter format vonST_AsGDALRaster. Die Optionen variieren, je nach dem mit welchen Treibern Ihre "libgdal" kompiliert wurde. create_optionsgibt einen XML-formatierten Satz an CreationOptionList/Option zurück, der aus dem Namen und optional aus type, descriptionund VALUE für jede Option eines bestimmten Treibers besteht.
Änderung: 2.5.0 - die Spalten can_read und can_write hinzugefügt.
Änderung: 2.0.6, 2.1.3 - standardmäßig ist kein Treiber aktiviert, solange die GUC oder die Umgebungsvariable "gdal_enabled_drivers" nicht gesetzt sind.
Verfügbarkeit: 2.0.0 - GDAL >= 1.6.0.
List of Drivers.
SET postgis.gdal_enabled_drivers = 'ENABLE_ALL'; SELECT short_name, long_name, can_write FROM ST_GDALDrivers() ORDER BY short_name;
short_name | long_name | can_write -----------------+-------------------------------------------------------------+----------- AAIGrid | Arc/Info ASCII Grid | t ACE2 | ACE2 | f ADRG | ARC Digitized Raster Graphics | f AIG | Arc/Info Binary Grid | f AirSAR | AirSAR Polarimetric Image | f ARG | Azavea Raster Grid format | t BAG | Bathymetry Attributed Grid | f BIGGIF | Graphics Interchange Format (.gif) | f BLX | Magellan topo (.blx) | t BMP | MS Windows Device Independent Bitmap | f BSB | Maptech BSB Nautical Charts | f PAux | PCI .aux Labelled | f PCIDSK | PCIDSK Database File | f PCRaster | PCRaster Raster File | f PDF | Geospatial PDF | f PDS | NASA Planetary Data System | f PDS4 | NASA Planetary Data System 4 | t PLMOSAIC | Planet Labs Mosaics API | f PLSCENES | Planet Labs Scenes API | f PNG | Portable Network Graphics | t PNM | Portable Pixmap Format (netpbm) | f PRF | Racurs PHOTOMOD PRF | f R | R Object Data Store | t Rasterlite | Rasterlite | t RDA | DigitalGlobe Raster Data Access driver | f RIK | Swedish Grid RIK (.rik) | f RMF | Raster Matrix Format | f ROI_PAC | ROI_PAC raster | f RPFTOC | Raster Product Format TOC format | f RRASTER | R Raster | f RS2 | RadarSat 2 XML Product | f RST | Idrisi Raster A.1 | t SAFE | Sentinel-1 SAR SAFE Product | f SAGA | SAGA GIS Binary Grid (.sdat, .sg-grd-z) | t SAR_CEOS | CEOS SAR Image | f SDTS | SDTS Raster | f SENTINEL2 | Sentinel 2 | f SGI | SGI Image File Format 1.0 | f SNODAS | Snow Data Assimilation System | f SRP | Standard Raster Product (ASRP/USRP) | f SRTMHGT | SRTMHGT File Format | t Terragen | Terragen heightfield | f TIL | EarthWatch .TIL | f TSX | TerraSAR-X Product | f USGSDEM | USGS Optional ASCII DEM (and CDED) | t VICAR | MIPL VICAR file | f VRT | Virtual Raster | t WCS | OGC Web Coverage Service | f WMS | OGC Web Map Service | t WMTS | OGC Web Map Tile Service | t XPM | X11 PixMap Format | t XYZ | ASCII Gridded XYZ | t ZMap | ZMap Plus Grid | t
List of options for each driver.
Output the create options XML column of JPEG as a table. These creator options can be used in the ST_AsGDALRaster options argument.
SELECT (xpath('@name', g.opt))[1]::text As oname,
(xpath('@type', g.opt))[1]::text As otype,
(xpath('@description', g.opt))[1]::text As descrip
FROM (SELECT unnest(xpath('/CreationOptionList/Option', create_options::xml)) As opt
FROM ST_GDALDrivers()
WHERE short_name = 'JPEG') As g;
oname | otype | descrip
--------------------+---------+-------------------------------------------------
PROGRESSIVE | boolean | whether to generate a progressive JPEG
QUALITY | int | good=100, bad=0, default=75
WORLDFILE | boolean | whether to generate a worldfile
INTERNAL_MASK | boolean | whether to generate a validity mask
COMMENT | string | Comment
SOURCE_ICC_PROFILE | string | ICC profile encoded in Base64
EXIF_THUMBNAIL | boolean | whether to generate an EXIF thumbnail(overview).
By default its max dimension will be 128
THUMBNAIL_WIDTH | int | Forced thumbnail width
THUMBNAIL_HEIGHT | int | Forced thumbnail height
(9 rows)
This example turns a few common GeoTIFF creator options into a compact table.
WITH gtiff_options AS (
SELECT
option_name,
option_type,
default_value
FROM ST_GDALDrivers() AS driver
CROSS JOIN LATERAL XMLTABLE(
'/CreationOptionList/Option'
PASSING (driver.create_options::xml)
COLUMNS
option_name text PATH '@name',
option_type text PATH '@type',
default_value text PATH '@default'
) AS options
WHERE driver.short_name = 'GTiff'
)
SELECT option_name AS name, option_type AS type, coalesce(default_value, '') AS default_value
FROM gtiff_options
WHERE option_name = ANY (ARRAY[
'COMPRESS',
'INTERLEAVE',
'TILED',
'BLOCKXSIZE',
'BLOCKYSIZE',
'JPEG_QUALITY'
])
ORDER BY 1;
name | type | default_value ---------------+---------------+--------------- BLOCKXSIZE | int | BLOCKYSIZE | int | COMPRESS | string-select | INTERLEAVE | string-select | PIXEL JPEG_QUALITY | int | 75 TILED | boolean | (6 rows)
Use XMLTABLE to expose selected GTiff creation options as rows. The same pattern can be used without the name filter to inspect the full XML document.
SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
SELECT option_name, option_type
FROM ST_GDALDrivers() AS driver
CROSS JOIN LATERAL XMLTABLE(
'/CreationOptionList/Option'
PASSING (driver.create_options::xml)
COLUMNS
option_name text PATH '@name',
option_type text PATH '@type'
) AS options
WHERE driver.short_name = 'GTiff'
AND option_name IN ('COMPRESS', 'TILED', 'BIGTIFF')
ORDER BY option_name;
option_name | option_type -------------+--------------- BIGTIFF | string-select COMPRESS | string-select TILED | boolean (3 rows)