| Version 1 (modified by , 15 years ago) ( diff ) |
|---|
PostGIS WKT Raster Beta 03 (and up) Working Specifications
Quick Links
Objective B03a - Being able to set all the properties of a raster.
RT_SetSRID(raster|geometry, integer)
RT_SetPixelType(raster, band, string)
RT_SetPixelSize(raster)
RT_SetNoDataValue(raster, band, value)
RT_SetGeoReference(raster, string)
Objective B03b - Being able to reproject a raster.
RT_Transform(raster|geometry, SRID) → same type as input
Objective B03c - Being able to do some base raster operations.
RT_Area(raster|geometry) → double
RT_Count(raster, value) → integer
RT_Resample(raster, pixelsize, method) → raster
RT_SelectByValue(raster|geometry, ‘expression’) → same type as first argument
RT_Reclass(raster|geometry,string) → same type as first argument
RT_MapAlgebra(raster|geometry, [raster|geometry,…], ‘mathematical expression’, ‘raster’ |’geometry’) → raster/geometry
RT_Clip(raster|geometry,geometry) → same type as first argument
RT_Flip(raster|geometry, ’vertical’|’horizontal’) → same type as first argument
PostGIS WKT Raster Beta 0.4
Objective B04a - Being able to convert a raster to standards formats.
RT_AsKML(raster|geometry) → string
RT_AsSVG(raster|geometry) → string
Objective B04b - Being able to control the validity of a raster.
RT_IsEmpty(raster|geometry) → boolean
RT_mem_size(raster|geometry) → integer
RT_isvalid(raster|geometry) → boolean
Objective B04c - Being able to use other major topological operators
RT_Within(raster|geometry A, raster|geometry B)
RT_Contains(raster|geometry A, raster|geometry B)
RT_Overlaps(raster|geometry, raster|geometry)
PostGIS WKT Raster Beta 0.5
Objective B05a - Being able to derive a raster layer from vector layer.
RT_Interpolate(points, pixelsize, method) → raster
Objective B05b - Being able to do on rasters most operations available on geometries
RT_Centroid(raster|geometry) → point geometry
RT_PointOnSurface(raster|geometry) → point geometry
RT_Buffer(raster|geometry, double) → same type as first arg.
RT_ConvexHull(raster|geometry) → same type as input
RT_Difference(raster|geometry A, raster|geometry B) → same type as first argument
RT_SymDifference(raster|geometry,raster|geometry,‘raster’|’geometry’) → raster/geometry
PostGIS WKT Raster Beta 0.6
Objective B06a - Being able to use all the other topological operators
RT_Equals(raster|geometry, raster|geometry)
RT_Disjoint(raster|geometry, raster|geometry)
RT_Touches(raster|geometry, raster|geometry)
RT_Crosses(raster|geometry, raster|geometry)
RT_Covers(raster|geometry A, raster|geometry B)
RT_IsCoveredBy(raster|geometry A, raster|geometry B)
RT_Relate(raster|geometry, raster|geometry, intersectionPatternMatrix )
Objective B07b - Being able to edit a raster
RT_Value(raster, band, x, y) → value
Return value of a single pixel. Pixel location is specified by 1-based index of Nth band of raster and X,Y coordinates.
The X coordinate is expected to be in range of [1, RT_Width(raster)] and Y coordinate in range of [1, RT_Height(raster))].
Return value is of type of 64-bit float-point number.
TODO: mloskot: Should we return NUMERIC instead of FLOAT8?
RT_SetValue(raster, band, x, y, value)
RT_Affine(raster|geometry,…) → same type as input
RT_Translate(raster|geometry,…) → same type as input
RT_Scale(raster|geometry,…) → same type as input
RT_TransScale(raster|geometry,…) → same type as input
RT_RotateZ,Y,Z(raster|geometry, float8) → same type as input
Other functions
RT_AsBinary(raster, compression)
RT_RasterFromWKB(raster, [<srid>])
RT_RasterFromText(string, [<srid>])
RT_AsText(raster)
