[postgis-users] import of Raster data

[Andreas Laggner]

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

   

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
>>>       
>
>   


-- 
Dipl. Geoökologe Andreas Laggner
Institut für Ländliche Räume (LR)
Bundesforschungsanstalt für Landwirtschaft (FAL)

Institute of Rural Studies
Federal Agricultural Research Centre (FAL)

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 5515
Fax: (+49) (0)531 596 5599
E-mail: andreas.laggner at fal.de
Homepage: http://www.lr.fal.de/