[postgis-users] Need help to load data in PostGIS

[Khalid]

Hi,

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.

I want to explain more about my porblem which I described in first mail.

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
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=weighted_overlay)
.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.

Now the porblem is, how to store raster data in PostGIS/Postgres SQL. There
are multiple ideas I am working on right now

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.
2. Can we actually use PGCHIP GDAL driver (new implementation of raster in
PostGIS). For reference please visit,  http://simon.benjamin.free.fr/pgchip/
 ?
3. Can we use PGRaster SQL Interface to store raster data (
http://postgis.com/support/wiki/index.php?PgRasterSqlInterface). 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?

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

Regards,

Khalid

On 2/15/07, Steven De Vriendt <gisaalter at gmail.com> wrote:
>
> Khalid,
>
> A little while back someone posted this on the PostGIS mailing list:
>
>
>
> Hello All,
>
> two new graphical interfaces for the shp2pgsql and pgsql2shp tools
> are available under the terms of the GPL:
>
> http://sdteffen.de/gis/gpgsql2shp.html
> http://sdteffen.de/gis/gshp2pgsql.html
>
> The interfaces are built using the GTK+ and thus cross-platform.
>
> Windows installers are available. When installing on Windows, make
> sure that you install the GTK+ runtime environment first:
>
> http://downloads.sourceforge.net/gimp-win/gtk%2B-2.10.6-1-setup.zip
>
> Gshp2pgsql allows to specify pre- and post-load SQL script. A pre-load
> script can be used e.g. to drop views that are dependent on the loaded
> table
> if the table needs to be recreated and the post-load script can recreate
> these views.
>
> Regards,
>
> Steffen
>
>
> I'haven't used it but it seems like something you can use
>
> Steven
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070216/a2b55175/attachment.html>