Ticket #232 (closed task: fixed)

Opened 3 years ago

Last modified 16 months ago

[raster] Implementation of ST_AsBinary for RASTER type

Reported by: mloskot Owned by: mloskot
Priority: low Milestone: PostGIS Raster Future
Component: raster Version: trunk
Keywords: st_asbinary,bytea Cc:

Description (last modified by mloskot) (diff)

This is just a record of the plan I've made to start implementing ST_AsBinary function for WKT Raster. The function is listed in the big plan.

The first version of [ST_AsBinary I'm going to implement will do nearly the same what ST_byte function does. It's prototype is:

bytea ST_AsBinary(raster r1);

At the moment, I don't aim to implement compression support, but later it can be extended to provide it:

bytea ST_AsBinary(raster r1, text compression);

I haven't planned to handle endianness as PostGIS'  ST_AsBinary does. So, it is expected that WKB is returned with  endianness native to the machine running the PostgreSQL database - it can vary (i.e. Intel returns NDR, PowerPC returns XDR). Feel free to share your suggestions of solutions fot this.

Change History

Changed 3 years ago by mloskot

  • owner changed from pracine to mloskot
  • status changed from new to assigned

Changed 3 years ago by mloskot

  • keywords st_asbinary,bytea added; st_asbinary removed

First version available from the spike (r4346)

Changed 3 years ago by mloskot

  • description modified (diff)

Changed 3 years ago by mloskot

  • description modified (diff)

Changed 2 years ago by mloskot

  • summary changed from Implementation of ST_AsBinary for RASTER type to [wktraster] Implementation of ST_AsBinary for RASTER type

Changed 2 years ago by pracine

  • priority changed from high to low
  • type changed from enhancement to task
  • milestone set to WKTRaster Future

This function should return the WKB format of the raster like does the PostGIS ST_AsBinary function.

 http://postgis.refractions.net/documentation/manual-1.4/ST_AsBinary.html

Changed 17 months ago by pracine

  • summary changed from [wktraster] Implementation of ST_AsBinary for RASTER type to [raster] Implementation of ST_AsBinary for RASTER type

Changed 16 months ago by jorgearevalo

  • status changed from assigned to closed
  • resolution set to fixed

Functions implemented: - st_asbinary (rtpostgis.sql) --> RASTER_to_binary (rt_pg.c) --> rt_raster_to_wkb (rt_api.c)

Note: See TracTickets for help on using tickets.