Pixel image after upload to sde. How I can improve image quality?

3130
8
10-29-2015 08:46 AM
DiegoLlamas
Occasional Contributor III

Hi,

I have a raster dataset on a file geodatabase with Puerto Rico Imagery from 2007. this image look really smooth

Puerto Rico fgb.jpg

PRfgb.png

PRfgb1.png

PRfgb2.png

After I create the raster dataset on SDE and upload the image using the exact same characteristics and properties from the one on the file geodatabase it seem with pixels and not smooth as the one on the FGD.

Puerto Rico sde.jpg

as you can see, the properties are the same

PRsde.png

prsde1.png

prsde2.png

I create the pyramids and calculate statistics for the raster and it does not look like the FGB one.

What am I doing wrong?

Thanks,

Diego Llamas

0 Kudos
8 Replies
DanPatterson_Retired
MVP Esteemed Contributor

Wow deja vu...

https://community.esri.com/thread/167660

Are you working with the same data?

RobertScheitlin__GISP
MVP Esteemed Contributor

Diego,

    Are you adding the raw uncompressed imagery when loading to SDE or are you using the already compressed FGDB data? If you compress data that is already compressed you can see issues like this.

JakeSkinner
Esri Esteemed Contributor

Hi Diego,

It looks like the pyramids are different.  For the File Geodatabase Raster Dataset, you are using Bilinear.  For the SDE Raster Dataset, you are using Nearest Neighbor.  I would recommend deleting the pyramids using the Build Pyramids tool, and then recreating using Bilinear.

DanPatterson_Retired
MVP Esteemed Contributor

would that be the issue on the parent thread too? (same data)

JakeSkinner
Esri Esteemed Contributor

Yes, I believe so.

GabrielUpchurch1
Occasional Contributor III

I would give serious consideration to the suggestion made by Jake Skinner​.  I suspect he has identified the issue and the fix.  The graininess in the SDR is likely from using the nearest neighbor resampling for the pyramids, which is really intended for working with categorical data.  I think it is/has also been used with coarse resolution imagery.  In the case of high resolution imagery, you should be using either bilinear or cubic for the resampling method.

GordonSumerling
Esri Contributor

To expand on Gabriels comments you need to set the resampling on the pyramids  in the environment variables when performing the load to SDE. By default it is set to nearest neighbor. also nearest neighbor is the fastest resampling method but not necessarily the optimal for continuous data like this. Bilinear or cubic convolution are slower to process but provide a far more visually pleasing result.

i guess the real question though is why are you loading up your Enterprise Geodatabase with imagery? The preferred method today is to place the imagery in a Mosaic Dataset. Not only is it faster to create but it saves having multiple version of the same imagery and provides similar if not faster display speeds.

Regards

Gordon

DiegoLlamas
Occasional Contributor III

Thank you Guys, (Dan,Gabriel, Gordon, Jake, Robert) I will try your suggestions and I will let you know.