topic Re: Import TIFF file to SDE in Data Management Questions

Import TIFF file to SDE

RudyCharlot — Tue, 27 May 2014 11:36:01 GMT

Good morning everyone,
what is the best way to import an image file (tiff) to an SDE geodatabase?
Please I would appreciate any help on this issue. Thank you much.

Sincerely,
Rudy Charlot

Re: Import TIFF file to SDE

VinceAngelo — Tue, 27 May 2014 12:22:44 GMT

What is the best vegetable? There are at least a half-dozen ways to load a raster
into ArcSDE, all of them "best" under certain conditions, but best practice is not to
do so at all.

If you provide complete information about your RDBMS and ArcGIS software available,
and what you intend to do with the image, we could provide more guidance on making
best use of what you have.

- V

Re: Import TIFF file to SDE

RudyCharlot — Tue, 27 May 2014 13:33:26 GMT

the ArcSDE is a "postgresql" and i am currently using 10.0.
I am creating a cache map for my stormwater field crew that I would like everything on my group layer for my cache map
to be located into the ArcSDE geodatabase, but I have never imported a tiff file into ArcSDE database before.
Once again, thank you for the prompt response.

Regards,
Rudy

Re: Import TIFF file to SDE

VinceAngelo — Tue, 27 May 2014 16:52:17 GMT

While its possible to load rasters into a database instance, doing so is sufficiently wasteful
that it is strongly not recommended. Mosaic datasets are the current "best" way to handle
rasters, but your ArcGIS release is too old to take advantage of them.

- V

Re: Import TIFF file to SDE

JakeSkinner — Wed, 28 May 2014 11:58:06 GMT

Hi Rudy,

As Vince mentioned, a mosaic dataset would be your best option, and this data model is available at 10.0:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/What_s_new_for_rasters/00qp0000000w000000/

Re: Import TIFF file to SDE

RudyCharlot — Mon, 09 Jun 2014 16:23:38 GMT

Thank you very much guys. I will take Vince's advice not to have it imported into the SDE geodatabase.

Best regards,
Rudy