[postgis-users] using WKT Raster

Wed Jan 13 06:18:24 PST 2010

Hi,
I have this error when running this command
python.exe gdal2wktraster.py -r 
D:\ms4w\paccSnte\data\IlotsChaleur\rssMtl_icu_byteScaled_google_30m.tif -t 
tmp.rssmtl_tif -s900913 -o wkt.sql

BEGIN
psql:wkt.sql:2: NOTICE:  CREATE TABLE will create implicit sequence 
"rssmtl_tif_
rid_seq" for serial column "rssmtl_tif.rid"
psql:wkt.sql:2: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit 
index "
rssmtl_tif_pkey" for table "rssmtl_tif"
CREATE TABLE
psql:wkt.sql:3: ERROR:  function addrastercolumn(unknown, unknown, 
unknown, inte
ger, text[], boolean, boolean, unknown, numeric, numeric, unknown, 
unknown, unkn
own) does not exist
LINE 1: SELECT AddRasterColumn('public','rssmtl_tif','rast',900913, ...
               ^
HINT:  No function matches the given name and argument types. You might 
need to
add explicit type casts.
psql:wkt.sql:4: ERROR:  current transaction is aborted, commands ignored 
until e
nd of transaction block
ROLLBACK

I read this on the page's project
The wktraster_database must be a PostgreSQL database with PostGIS and WKT 
Raster extensions enabled

How do I get the functions for postgis and how do I enable WKT Raster 
extension?
thanks
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction de la santé environnementale et de la toxicologie
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3 
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144
steve.toutant at inspq.qc.ca
http://www.inspq.qc.ca

Steve.Toutant at inspq.qc.ca@postgis.refractions.net 
Envoyé par : postgis-users-bounces at postgis.refractions.net
12/01/2010 03:33 PM
Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>

A
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
cc
postgis-users-bounces at postgis.refractions.net
Objet
[postgis-users] WKT Raster

HI, 
I just installed wktraster_pg83 using this link 
http://www.postgis.org/download/windows/pg83/experimental/wktraster/ 

I guess the next step is to use gdal2wktraster.py to load an image in 
postgis. 

I don't know the syntax to use so I tried this command 
C:\Python\python.exe gdal2wktraster.py --help 

I got this error 
Traceback (most recent call last): 
  File "gdal2wktraster.py", line 32, in <module> 
    from osgeo import gdal 
  File "C:\Python\lib\site-packages\osgeo\gdal.py", line 7, in <module> 
    import _gdal 
ImportError: DLL load failed: Le module spÚcifiÚ est introuvable. 

What is it missing? 
Also, any doc on how to use gdal2wktraster.py? 

thanks 
steve 

"Paragon Corporation" <lr at pcorp.us>@postgis.refractions.net 
Envoyé par : postgis-users-bounces at postgis.refractions.net 
07/12/2009 10:37 PM 

Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>

A
"'PostGIS Users Discussion'" <postgis-users at postgis.refractions.net> 
cc

Objet
Re: [postgis-users] Suggestion Needed

FWIW for Windows users, we do have fairly recent compiled WKT Raster as of 
December 4th, 2009.  Give it a try.  I haven't had chance to try WKT 
Raster yet, but hopefully this will encourage people to give it a try. 

http://www.postgis.org/download/windows/experimental.php 

Hope that helps, 
Regina 

From: postgis-users-bounces at postgis.refractions.net 
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Pierre 
Racine
Sent: Monday, December 07, 2009 3:27 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Suggestion Needed

Mukesh, 

Sorry for the late answer. You can give a try to WKT Raster. You will have 
to compile it though. Loading Geotiff should then be straightforward using 
gdal2wktraster.py. 

Pierre 

From: postgis-users-bounces at postgis.refractions.net 
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of mukesh 
karanwal
Sent: 25 novembre 2009 06:30
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Suggestion Needed 

Hi.. 
thanks for the reply. 
i did it but still it is showing the same error! 

I actually want to store a Geotiff file in the databse, could you please 
tell, is there any other way to do this? or where am i doing mistake, if 
any? 

Thanks 

--- On Tue, 11/24/09, Luigi Castro Cardeles <luigi.cardeles at gmail.com> 
wrote: 

From: Luigi Castro Cardeles <luigi.cardeles at gmail.com>
Subject: Re: [postgis-users] Suggestion Needed
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Date: Tuesday, November 24, 2009, 10:17 PM 
Hi,

to "bypass" the password, you can make the .pgpass file and fill that with 
your connection params (hostname:port:database_name:user:password).
If you are using windows, the path is: C:\Users\<your user 
name>\AppData\Roaming\postgresql\.pgpass

best regards 
Luigi Castro Cardeles

2009/11/24 mukesh karanwal <mukesh_karanwal at yahoo.com> 

Hey Everyone, 

I am trying to store raster data in Postgis/PostgrSQL using "
geotiff2pgrstaer.exe". but evertime i get an error that "when making 
connection to PostgreSQL: fe_sendauth: no password supplied", though i am 
supplying all the information. 

The command i am giving is like: 
C:\..> geotiff2pgraster -h localhost -p 5432 -d postgis -U postgres -P 
<mypassword> data.tif(strored at this location only) tablename 

Kindly tell the remedy for the above problem and also is there any other 
way out to store raster data until now? 

Thanks in anticipation 

-- 
With Regards,
Mukesh 

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users 

-----Inline Attachment Follows----- 
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

 _______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
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/20100113/cc62321b/attachment.html>