图论中间件技术学习：rasterNULL 博文链接：https://flyqantas.iteye.

文件名称: 图论中间件技术学习：raster

所属分类: 其它

开发工具:

文件大小: 2mb

下载次数: 0

上传时间: 2019-08-10

提供者: weixin_********

下载 (2mb)

不能下载？报告错误

详细说明：NULL 博文链接：https://flyqantas.iteye.com/blog/2216451Georeferenced, Multiband, Multiresolution and Tiled Coverages Each raster/tile is georeferenced upperLeftx upperLeftY Skew X scaleX Supports rotation( or skew) skew Supports multiple bands with different pixeltypes in the same raster scalbY 1BB, 8BSI, 8BUL, 16BSI, 16BUI, 32BSI, 32BUI, 32BF, 64BF One nodata value per band width Tiled indexed e.g. SRTM Coverage for Canada No real limit on size 1 GB per tile, 32 TB per coverage(table) Rasters are compressed (by PostgreSQL) Supports irregularly tiled overlapping coverages Other resolutions(or overviews)are stored in sister tables List of raster columns available in a raster columns table similar to the geometry_ columns table Supports Many Raster Arrangements missing mIssing tile overlaps smaller same tiles size tiles a)warehouse of untiled irregularly tiled raster regularly tiled raster and unrelated images coverage(36 tiles coverage(36 tiles) (4 images) Table 1 日日 ■■ empty space Table 2 d)rectangular regularly f rasterized geometries tiled raster coverage e)tiled images (2 tables coverage 9 lines in the (54 tiles of 54 tiles) table) What You can Do now? Store and manage rasters in the database Batch import rasters raster2pgsql py -r"c:/temp/mytiffolder/*. tif -t mytable -S 4326 -k 50x50- psql -d testdb Get and set the raster properties Upper left corner coordinates transformation parameters srid number of bands Get and set band properties Pixel type nodata value Reproject raster(ST_Transform) ST Resample(raster), ST_ Rescale(, ST Snap ToGrido Convert a geometry to a raster (sT AsRaster) Convert a raster to a set of geometries-values (ST DumpAsPolygons) What You can do now? Dump rasters from the database With the 'PostGisRaster'GDAL driver Developed and maintained by Jorge Arevalo Read only, optimization in progress GDAL The write part is still to do(by you?) Two modes 1. ONE RASTER PER ROW 2 ONE RASTER PER TABLE What You can do now? Get raster statistics ST_ SummaryStats(raster) Return a set of(min, max, sum, mean, stddev, count (of withdata pixels)records 10 seconds for one SRTM tile of 3600 x 3600 pixels, 70MB ST_ Histogram(raster, bin, widthl D) Return a set of (min, max, count, percent) records for an array of bins ST Quantile(raster, quantiles[ l) Return a set of values for an array of quantile ST Value Count(raster, values D Return the frequency for an array of value What You can do now? Display rasters QGis plugin by Mauricio de paulo mauriciodevgmail.com) gvsIG plugin by Nacho Brodin (brodinprodevelop. es) MapServer through GDAL Normally any software using GDaL to read raster and allowing passing database connection parameters to GDAL Display a vectorization of the raster OpenJump SELECT ST_ AsBinary ((sT_ BumpAs Polygons(rast).geom (ST DumpAs Polygonsrast)). val FROM srtm tiled Where rid=1869 ArcGIS 10 Add Query Layer (same as OpenJump but without ST_ AsBinaryo) Any software displaying vector PostGis queries What You can do now? Edit and compute new rasters ST Setvalue( of a pixel ST Reclass( a raster ST_ MapAlgebra(raster, band 420 6 null null expression, 1-42 9 null nodatavalueexpr, 201 8 null null pixeltype Expressions are evaluated by the PostgresQL parser You can use any complex SQL expression e.g. 'CASE WHEN rast <0 THEN rast+10 ELSE NULL END You can provide a nodatavalueexpr to handle source nodata values What You can Do Now? Convert rasters to any GDAL format in SQL. ■■口 Get the list of GdaL drivers available sT GDALDrivers) Convert to any of the available format ( ST_ ASGDALRaster) SELECT ST ASGDALRaster(rast, USGSDEM) FROM Srtm 22 03 ST ASTIFFO, ST ASJPEGO, ST ASPNGO

(系统自动生成,下载前可以参看下载内容)