Postgres Raster image display

[Milo van der Linden]

For performance reason it is advised NOT to store your raster images 
inside the database. This discussion gets opened about once every month. 
There is no functionality available to read raster images from a database.



Ryan Ollerenshaw schreef:
> How can i use a Postgres database to display raster images with
> Mapserver?  There are lots of examples on display features this way
> and using a gdaltindex to create a shapefile but i cant find any that
> talk about using a database to store raster images.  Here is what i am
> currently trying:
>
> LAYER
>   NAME "stereo_simp"
>   TYPE RASTER
>   PROCESSING "SCALE=AUTO" #rescale 16-bit image to 8-bit
>   STATUS on
>   CONNECTION "host=localhost dbname=test user=postgres"
>   CONNECTIONTYPE POSTGIS
>   DATA "location FROM stereo"
>   TILEINDEX "stereo" #the table name
>   TILEITEM "location" #column that contains the path to the image
> END
>
> if i just try and display the image directly it works just fine:
>
> LAYER
>   NAME "stereo_simp"
>   TYPE RASTER
>   PROCESSING "SCALE=AUTO" #rescale 16-bit to 8-bit
>   STATUS on
>   DATA "/hiview/products/data/20070929_000600_14euA_171_16_gdal.tif"
> END
>
> Thank you for your time,
> -Ryan
>
>   


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071022/9e69583e/attachment.htm>