Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Georaster. Cell value not being scaled

udadiNov 30 2004 — edited Dec 2 2004
Hi,
I am having problems with scaling the cell value according to the scaling function specified in the metadata. The values in the cells are retrieved as they are stored when I am using sdo_geor.getcellvalue and they are not scaled according to the scaling function specified. How to get the scaled values? The following is my metadata:

/**********************************************************/
"<georasterMetadata xmlns=\"http://xmlns.oracle.com/spatial/georaster\">\n"+
"<objectInfo>\n"+
"<rasterType>21001</rasterType>\n"+
"<ID>"+rasterId+"</ID>\n"+
"<isBlank>false</isBlank>\n"+
"</objectInfo>\n"+
"<rasterInfo>\n"+
"<cellRepresentation>UNDEFINED</cellRepresentation>\n"+
"<cellDepth>8BIT_U</cellDepth>\n"+
"<totalDimensions>3</totalDimensions>\n"+
"<dimensionSize type=\"COLUMN\">\n"+
"<size>1536</size>\n"+
"</dimensionSize>\n"+
"<dimensionSize type=\"ROW\">\n"+
"<size>768</size>\n"+
"</dimensionSize>\n"+
"<dimensionSize type=\"BAND\">\n"+
"<size>5</size>\n"+
"</dimensionSize>\n"+
"<ULTCoordinate>\n"+
"<row>0</row>\n"+
"<column>0</column>\n"+
"<band>0</band>\n"+
"</ULTCoordinate>\n"+
"<blocking>\n"+
"<type>REGULAR</type>\n"+
"<totalRowBlocks>3</totalRowBlocks>\n"+
"<totalColumnBlocks>6</totalColumnBlocks>\n"+
"<totalBandBlocks>1</totalBandBlocks>\n"+
"<rowBlockSize>256</rowBlockSize>\n"+
"<columnBlockSize>256</columnBlockSize>\n"+
"<bandBlockSize>5</bandBlockSize>\n"+
"</blocking>\n"+
"<interleaving>BIP</interleaving>\n"+
"<pyramid>\n"+
"<type>NONE</type>\n"+
"<maxLevel>0</maxLevel>\n"+
"</pyramid>\n"+
"<compression>\n"+
"<type>NONE</type>\n"+
"</compression>\n"+
"</rasterInfo>\n"+
"<spatialReferenceInfo>\n"+
"<isReferenced>true</isReferenced>\n"+
"<isRectified>false</isRectified>\n"+
"<description>georeferenced SSMI data</description>\n"+
"<SRID>8307</SRID>\n"+
"<spatialResolution dimensionType=\"X\">\n"+
"<resolution>0.25</resolution>\n"+
"</spatialResolution>\n"+
"<spatialResolution dimensionType=\"Y\">\n"+
"<resolution>0.25</resolution>\n"+
"</spatialResolution>\n"+
"<modelCoordinateLocation>CENTER</modelCoordinateLocation>\n"+
"<modelType>FunctionalFitting</modelType>\n"+
"<polynomialModel rowOff=\"0\" columnOff=\"0\" xOff=\"0\" yOff=\"0\" zOff=\"0\" rowScale=\"1\" columnScale=\"1\" xScale=\"1\" yScale=\"1\" zScale=\"1\">\n"+
"<pPolynomial nVars=\"2\" order=\"1\" nCoefficients=\"3\">\n"+
"<polynomialCoefficients>355.5000000000000 0 4.0000000000000</polynomialCoefficients>\n"+
"</pPolynomial>\n"+
"<qPolynomial nVars=\"0\" order=\"0\" nCoefficients=\"1\">\n"+
"<polynomialCoefficients>1</polynomialCoefficients>\n"+
"</qPolynomial>\n"+
"<rPolynomial nVars=\"2\" order=\"1\" nCoefficients=\"3\">\n"+
"<polynomialCoefficients>-0.5000000000000 4.0000000000000 0</polynomialCoefficients>\n"+
"</rPolynomial>\n"+
"<sPolynomial nVars=\"0\" order=\"0\" nCoefficients=\"1\">\n"+
"<polynomialCoefficients>1</polynomialCoefficients>\n"+
"</sPolynomial>\n"+
"</polynomialModel>\n"+
"</spatialReferenceInfo>\n"+
"<temporalReferenceInfo>\n"+
"<isReferenced>false</isReferenced>\n"+
"</temporalReferenceInfo>\n"+
"<layerInfo>\n"+
"<layerDimension>BAND</layerDimension>\n"+
"<subLayer>\n"+
"<layerNumber>1</layerNumber>\n"+
"<layerDimensionOrdinate>0</layerDimensionOrdinate>\n"+
"<layerID>SSMI1</layerID>\n"+
"<scalingFunction>\n"+
"<a0>0</a0>\n"+
"<a1>0.2</a1>\n"+
"<b0>1</b0>\n"+
"<b1>0</b1>\n"+
"</scalingFunction>\n"+
"</subLayer>\n"+
"<subLayer>\n"+
"<layerNumber>2</layerNumber>\n"+
"<layerDimensionOrdinate>1</layerDimensionOrdinate>\n"+
"<layerID>SSMI2</layerID>\n"+
"<scalingFunction>\n"+
"<a0>0.0</a0>\n"+
"<a1>0.3</a1>\n"+
"<b0>1.0</b0>\n"+
"<b1>0.0</b1>\n"+
"</scalingFunction>\n"+
"</subLayer>\n"+
"<subLayer>\n"+
"<layerNumber>3</layerNumber>\n"+
"<layerDimensionOrdinate>2</layerDimensionOrdinate>\n"+
"<layerID>SSMI3</layerID>\n"+
"<scalingFunction>\n"+
"<a0>0.0</a0>\n"+
"<a1>0.01</a1>\n"+
"<b0>1.0</b0>\n"+
"<b1>0.0</b1>\n"+
"</scalingFunction>\n"+
"</subLayer>\n"+
"<subLayer>\n"+
"<layerNumber>4</layerNumber>\n"+
"<layerDimensionOrdinate>3</layerDimensionOrdinate>\n"+
"<layerID>SSMI4</layerID>\n"+
"<scalingFunction>\n"+
"<a0>0.0</a0>\n"+
"<a1>0.1</a1>\n"+
"<b0>1.0</b0>\n"+
"<b1>0.0</b1>\n"+
"</scalingFunction>\n"+
"</subLayer>\n"+
"</layerInfo>\n"+
"<sourceInfo>SSMI image</sourceInfo>\n"+
"</georasterMetadata>\n";
/**********************************************************/

Thanks,
Upendra
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 30 2004
Added on Nov 30 2004
4 comments
247 views