<div>Hi, </div>
<div> </div>
<div>Sorry for late reply and thanks to all who replied my message. There are very helpful replies and especially the GUI interface to load shapefile in PostGIS. Thanks Steve for helpful link.</div>
<div> </div>
<div>I want to explain more about my porblem which I described in first mail.</div>
<div> </div>
<div>Basically the application I am going to develop is web interface to do Conservation Analysis/Land Assessment Analysis which will use wegihted overlay technique (See details for weighted overlay anlysis at <a href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=weighted_overlay">
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=weighted_overlay</a>) .It will let user to choose layers they want to include in model. Then user will give weightage to each layer according to its pripority (which land has more priority to be conserveed) and then can rank features in those layers according to its importance(
e.g. If Layer is of Land Use, then will determine which features in landuse are much important e.g. Agriculture, Forage etc). Then model will take all parameters and will process the information and will show the results back into the browser (in the form of map/image). All this data will be stored in PostGIS database and should be in raster format as Model will use weighted overlay analysis technique which uses raster data.
</div>
<div> </div>
<div>Now the porblem is, how to store raster data in PostGIS/Postgres SQL. There are multiple ideas I am working on right now</div>
<div> </div>
<div>1. Can we store actually raster data direcly in PostgreSQL or PostGIS or we should strore it in outside of PostGIS and have some sort of reference to PostGIS with other data.</div>
<div>2. Can we actually use PGCHIP GDAL driver (new implementation of raster in PostGIS). For reference please visit, <a href="http://simon.benjamin.free.fr/pgchip/">http://simon.benjamin.free.fr/pgchip/</a> ?</div>
<div>3. Can we use PGRaster SQL Interface to store raster data (<a href="http://postgis.com/support/wiki/index.php?PgRasterSqlInterface">http://postgis.com/support/wiki/index.php?PgRasterSqlInterface</a>). I tried to do it but it did not work. So just wondering if somebody has actually used it to store raster data. If so, then how?
</div>
<div> </div>
<div>If somebody has used some solution to store raster data in PostGIS, please let me know. If this is not possible at all, then may suggest some alternative.</div>
<div>Here I want to mention that I have data in the form of ESRI shapefiles (mostly vector format). I tried to use gdal_rasterize but it gave me error that "The procedure entry point OGRCleanupALL could not be located in the dynamic link library
gdal13.dll". I tried to fix it and tried to re-install GDAL as well but I got same message.</div>
<div> </div>
<div>Regards,</div>
<div> </div>
<div>Khalid</div>
<div> </div>
<div><span class="gmail_quote">On 2/15/07, <b class="gmail_sendername">Steven De Vriendt</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:gisaalter@gmail.com" target="_blank">gisaalter@gmail.com
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Khalid,<br><br>A little while back someone posted this on the PostGIS mailing list:<br><br><br><br>Hello All,
<br><br>two new graphical interfaces for the shp2pgsql and pgsql2shp tools<br>are available under the terms of the GPL: <br><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://sdteffen.de/gis/gpgsql2shp.html" target="_blank">
http://sdteffen.de/gis/gpgsql2shp.html</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://sdteffen.de/gis/gshp2pgsql.html" target="_blank">http://sdteffen.de/gis/gshp2pgsql.html</a><br><br>The interfaces are built using the GTK+ and thus cross-platform.
<br><br>Windows installers are available. When installing on Windows, make<br>sure that you install the GTK+ runtime environment first: <br><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://downloads.sourceforge.net/gimp-win/gtk%2B-2.10.6-1-setup.zip" target="_blank">
http://downloads.sourceforge.net/gimp-win/gtk%2B-2.10.6-1-setup.zip </a><br><br>Gshp2pgsql allows to specify pre- and post-load SQL script. A pre-load<br>script can be used e.g. to drop views that are dependent on the loaded table
<br>if the table needs to be recreated and the post-load script can recreate <br>these views.<br><br>Regards,<br><br>Steffen<br><br><br>I'haven't used it but it seems like something you can use <br><span><br>Steven
<br><br></span><br>_______________________________________________<br>postgis-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postgis-users@postgis.refractions.net" target="_blank">
postgis-users@postgis.refractions.net </a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br><br></blockquote></div><br>