Changes between Initial Version and Version 2 of Ticket #2353


Ignore:
Timestamp:
Jun 7, 2013, 6:58:37 AM (11 years ago)
Author:
Bborie Park
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #2353

    • Property Owner changed from pramsey to Bborie Park
    • Property Component postgis → raster
    • Property Type patch → defect

  • Ticket #2353 – Description

    initial v2  
    77value's number 4 in this raster come out with ST_Value:
    88
     9{{{
    910SELECT ST_Value(rast, 1, 8, 2), ST_BandnoDataValue(rast), ST_BandPixelType(rast)
    1011FROM (SELECT '0100000100000000000088C340000000000088C3C03FF0F16F910F29C1F38C064BB32D244100000000000000000000000000000000C67D00000A000A0045FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0100FFFFFFFFFFFFFFFFFFFF0300FFFF040005000600FFFFFFFFFFFF0C000D000E000F00100011001200FFFFFFFFFFFF180019001A001B001C001D001E00FFFFFFFFFFFF2400250026002700280029002A00FFFFFFFFFFFF3400350036003700380039003A00FFFFFFFF4B004C004D004E004F00500051005200FFFFFFFF6A006B006C006D006E006F0070007100FFFFFFFF8F009000910092009300940095009600FFFFFFFFB500B600B700B800B900BA00BB00BC00'::raster rast) foo
     12}}}
    1113
    1214but not with ST_DumpAsPolygons:
    1315
     16{{{
    1417SELECT (ST_DumpAsPolygons(rast)).val
    1518FROM (SELECT '0100000100000000000088C340000000000088C3C03FF0F16F910F29C1F38C064BB32D244100000000000000000000000000000000C67D00000A000A0045FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0100FFFFFFFFFFFFFFFFFFFF0300FFFF040005000600FFFFFFFFFFFF0C000D000E000F00100011001200FFFFFFFFFFFF180019001A001B001C001D001E00FFFFFFFFFFFF2400250026002700280029002A00FFFFFFFFFFFF3400350036003700380039003A00FFFFFFFF4B004C004D004E004F00500051005200FFFFFFFF6A006B006C006D006E006F0070007100FFFFFFFF8F009000910092009300940095009600FFFFFFFFB500B600B700B800B900BA00BB00BC00'::raster rast) foo
     19}}}
    1620
    1721I used ST_Value to show that the value 4 associated with the pixel with coordinates (8,2) actually exists! Please note that adjacent values are different. Also note that ST_PixelAsPolygons() works fine.