获得raster对象的元数据,返回JSON格式。
语法
text ST_MetaData(raster raster_obj);
text ST_MetaData(raster raster_obj,
text key);
text ST_MetaData(raster raster_obj,
integer band,
text key);
参数
参数名称 | 描述 |
---|---|
raster_obj | raster对象。 |
band | 波段序号,从0开始。 |
key | 需要查询的元数据项名称,如果传入的是all ,则返回一个包含所有元数据项的JSON。
|
示例
select ST_MetaData(raster_obj) from raster_table;
-- meta data with a name
SELECT ST_MetaData(raster_obj, 'swh#scale_factor')
FROM raster_table;
st_metadata
-----------------------
0.0001488117874873806
-- all meta data
SELECT ST_MetaData(raster_obj, 'all')
FROM raster_table;
st_metadata
-----------------------
{"AREA_OR_POINT":"Area"}
-- meta data with a name of a band
SELECT ST_MetaData(raster_obj, 0, 'NETCDF_DIM_time')
FROM raster_table;
st_metadata
-------------
1043112
-- all meta data of a band
SELECT ST_MetaData(raster_obj, 'all')
FROM raster_table;
st_metadata
----------------------------------------------------------------------------------------------------------------------------------------
{"add_offset":"4.907141431495487","long_name":"Significant height of combined wind waves and swell","missing_value":"-32767","NETCDF_DI.
M_time":"1043112","NETCDF_VARNAME":"swh","scale_factor":"0.0001488117874873806","units":"m","_FillValue":"-32767"}