[postgis-users] import of Raster data

[Dylan Beaudette]

On Thursday 16 August 2007 04:09, Andreas Laggner wrote:
> Moin Stefan  ;-)
>
> i want to use the spatial data from the raster together with vector data
> in postgis. For example: soils from buk1000 and preception from DWD 1km
> raster or altitude/slope from DEM25m raster to analyse potentials of
> farmland.
> I need the values from the cells in a spatial correct topology.
> In the year 2007 the archive did not have any solutions for raster data
> import.......
>
> hasta luego      Andreas
>
> Stephan Holl schrieb:
> > Hello Andreas,

Andreas, 

there are more suitable means to this end. Store your raster data in some 
GDAL-compatible format (compressed, tiled, geotiff works well), and you 
vector data in postgis. What you are trying to do is a simple operation for 
any program which can read GDAL/OGR datasources. One example is Starspan -- 
this can compute raster summaries for vector point/line/polygon features. 

I commonly use this approach to combine vector data stored in PostGIS and 
raster data stored in GRASS.

Cheers,

Dylan

> >
> > Andreas Laggner <andreas.laggner at fal.de>, [20070816 - 10:43:36]
> >
> >> Moin PostGis users,
> >>
> >> i want to import huge raster datasets from ArcGis Grid or Erdas
> >> Imagine .img to PostGis (for example DEM25 meters germany around 16
> >> million cells). What is the best way to do that? Found nothing in the
> >> documentation that seems to be practical......(perhaps transform the
> >> grid to points and import the points with the information of the
> >> original cell size and the projection - but that seems to be
> >> circuitous??).
> >
> > What are you going to achieve with that? Perhaps you could have a look
> > at the archive of this list and search for raster data and so forth.
> > There can be found an interesting dicussion about rasters and PostGIS.
> >
> > Best
> > 	Stephan

-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341