= '''PostGIS WKT Raster Beta 0.2.4 Working Specifications''' = {{{ #!div style='background-color: #F4F4F4; padding: 5px; border: 1px solid gray; float: right; margin-left: 5px; width: 260px; font-size: small;' > '''Quick Links''' * [wiki:WKTRaster WKT Raster Home Page] * [wiki:WKTRaster/PlanningAndFunding Planning & Funding] * [wiki:WKTRaster/SpecificationWorking01 Beta 0.1.6 Working Specifications] * [wiki:WKTRaster/Documentation01 Beta 0.1.6 Documentation] * [wiki:WKTRaster/SpecificationWorking03 Working Specifications for Future Versions] }}} ---- == '''Objective B02x - Being able to intersect vector and raster to produce raster.''' == '''ST_Intersects(raster, raster)'''[[BR]] '''ST_AsRaster(geometry, pixelsize) -> raster'''[[BR]] '''ST_Intersection(geometry, raster, band) -> raster''' Variant 1: ST_Intersection(geometry, val, raster, band) -> raster with the same metadatada as the provided raster. Non intersecting pixels are filled with nodata values. Variant 2: ST_Intersection(geometry, val, raster, band, 'TRIM') -> raster with the same metadatada as the provided raster but the extent is reduced to the geometry extent. Non intersecting pixels are filled with nodata values. Rasterize the geometry as a new raster (ST_AsRaster(geometry, pixeltype, val, nodataval, raster)) and then copy only pixels for which both raster bands have a value. Optionally trim the raster to withvalue extent. ---- == '''Objective B02x - Being able to use "group by" to accumulate tiles to form a new raster.''' == '''ST_Union(raster|geometry, raster|geometry, ‘raster’|’geometry’) -> raster/geometry'''[[BR]] '''ST_Accum(raster set|geometry set, ‘raster’|’geometry’) -> raster/geometry''' ---- == '''Objective B02x - Being able to set and get the skew of a raster in terms of rotation.''' == '''ST_SetRotation(raster, angle)''' Set the rotation of the raster. This method actually derive values for pixelsizex, pixelsizey, skewx and skewy based on the provided rotation angle. '''Open Question:''' PR: The angle should be provided in radian or in degree? '''ST_Rotation(raster) -> float64''' Return the georeference's rotation angle in (degree or radiant?) derived from the pixel size and the skew. PR: I think getting the rotation get no sence since the result of pixelsizes and skew is not necessarily a rotation. It make sence to set it though.