[postgis-users] import of Raster data

[Dylan Beaudette]

On Friday 17 August 2007 01:54, Andreas Laggner wrote:
> Good morning Dylan,
>
> i guess you are sleeping now but your reply seems to meet my aims very
> well! I will try to reproduce your approach and catch up on GDAL and
> starspan. If you have some more good hints for me feel free to write me
> again  :-)  - I will write you if i have more questions or big success.
>
> Toodle-oo        Andreas

Hi Andreas,

Good luck with starspan, it is a great little GIS tool. I haven't used it on 
windows, but on linux it works very well.

cheers,

dylan

> Dylan Beaudette schrieb:
> > 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