<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You’re using PostgreSQL 8.3 right?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Replace <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>“</span>SELECT ST_Intersection((gv).geom, $1) intgeom<span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>” <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>with<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>“</span>SELECT ST_Intersection((gv).geom, $1) AS intgeom<span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>”…<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I’ll fix the source.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Pierre<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of </b>George
Silva<br>
<b>Sent:</b> 19 juillet 2010 12:11<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] problem installing WKTRaster<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>While we are at it, I've tried
installing and there it complains about an error here:<br>
<br>
My download link was: <a
href="http://www.postgis.org/download/windows/pg83/experimental/wktraster/wktraster_pg83.zip">http://www.postgis.org/download/windows/pg83/experimental/wktraster/wktraster_pg83.zip</a><br>
<br>
I've already placed all my files at the correct place. What is the name of the
environment variable for postgresql? Just "PATH"? I already have two
or three variables with that name...<br>
<br>
Any ideas? Thanks guys.<br>
<br>
<br>
CREATE OR REPLACE FUNCTION st_intersection(geom geometry, rast raster, band
integer) <br>
RETURNS SETOF geomval AS <br>
$$<br>
-- Return the intersections of the
geometry with the vectorized parts of <br>
-- the raster and the values
associated with those parts, if really their <br>
-- intersection is not empty.<br>
SELECT intgeom, val<br>
FROM (<br>
SELECT
ST_Intersection((gv).geom, $1) intgeom, (gv).val <br>
FROM
ST_DumpAsPolygons($2, $3) gv<br>
WHERE
ST_Intersects((gv).geom, $1) AND ST_Intersects($1, $2, $3)) foo<br>
WHERE NOT st_isempty(intgeom)
-- eliminate empty intersections<br>
UNION ALL<br>
-- If the geometry does not
intersect with the raster, return an empty <br>
-- geometry and a null value<br>
SELECT emptygeom, NULL FROM<br>
ST_GeomCollFromText('GEOMETRYCOLLECTION EMPTY', st_srid($1)) emptygeom<br>
WHERE NOT ST_Intersects($1, $2, $3);<br>
$$ <br>
LANGUAGE SQL IMMUTABLE;<br>
<br>
NOTICE: type "raster" is not yet defined<br>
DETAIL: Creating a shell type definition.NOTICE: argument type
raster is only a shell<br>
<br>
ERROR: syntax error at or near "intgeom"<br>
LINE
1219:
SELECT ST_Intersection((gv).geom, $1) intgeom, (...<br>
^<br>
<br>
********** Error **********<br>
<br>
ERROR: syntax error at or near "intgeom"<br>
SQL state: 42601<br>
Character: 44614<br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal>On Mon, Jul 19, 2010 at 12:37 PM, Paragon Corporation <<a
href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Sebastian,</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Oops sorry about that. Will correct the readme.txt.</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Leo</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> <a
href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net"
target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf
Of </b>Sebastian E. Ovide<br>
<b>Sent:</b> Monday, July 19, 2010 9:08 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] problem installing WKTRaster</span><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Re reading the readme.txt<br>
<br>
1) Install PostGIS into your database if you haven't already<br>
2) Copy the rtpostgis.dll to the lib folder of your PostgreSQL install<br>
3)<br>
a) then Run the share\contrib\postgis\rtpostgis.sql in your postgis enabled db<br>
b) You can install help now too by running
share\contrib\postgis\wktraster_comments.sql<br>
4) Copy the contents of bin to your PostgreSQL bin folder (gdal2wktraster.py,
libgdal.dll) to bin folder of your PostgreSQL install.<br>
<br>
the point 4 should come before the point 3....<o:p></o:p></p>
<div>
<p class=MsoNormal>On Mon, Jul 19, 2010 at 12:13 PM, Sebastian E. Ovide <<a
href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal>Hi Fred,<br>
<br>
Thanks to that Tool I've discovered that the dll could not find libgdal.dll...
so I've copied it into the bin dir and now it works !<br>
<br>
thanks ! <o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p>
<div>
<p class=MsoNormal>On Mon, Jul 19, 2010 at 12:03 PM, Fred Lehodey <<a
href="mailto:lehodey@gmail.com" target="_blank">lehodey@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal>Hi Sebastian,<br>
you can try that free utility : <a href="http://www.dependencywalker.com/"
target="_blank">http://www.dependencywalker.com/</a><br>
<br>
Sometimes helpful to discover a missing file.<br>
<span style='color:#888888'><br>
Fred.</span> <o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br>
<br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal>On Mon, Jul 19, 2010 at 11:56 AM, Sebastian E. Ovide <<a
href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal>same: <o:p></o:p></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be
found.<o:p></o:p></p>
</div>
<div>
<div>
<div>
<p class=MsoNormal>2010/7/19 Jorge Arévalo <<a
href="mailto:jorge.arevalo@deimos-space.com" target="_blank">jorge.arevalo@deimos-space.com</a>><o:p></o:p></p>
<p class=MsoNormal>On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide<o:p></o:p></p>
<div>
<p class=MsoNormal><<a href="mailto:sebastian.ovide@gmail.com"
target="_blank">sebastian.ovide@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>> done, same problem<br>
><br>
> ERROR: could not load library "C:/Program<br>
> Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could
not be<br>
> found.<br>
><o:p></o:p></p>
</div>
<p class=MsoNormal>Try adding C:/Program Files/PostgreSQL/8.4/lib/ to the PATH
enviroment variable.<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal><br>
<br>
> 2010/7/19 Jorge Arévalo <<a href="mailto:jorge.arevalo@deimos-space.com"
target="_blank">jorge.arevalo@deimos-space.com</a>><br>
>><br>
>> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide<br>
>> <<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>>
wrote:<br>
>> > Hi All,<br>
>> ><br>
>> > on WinXP, with PostgreSLQ 8.4, PostGis 1.5 and WKTRaster 0.1.6d.<br>
>> ><br>
>> > Just followed the instructions from WKTRaster 0.1.6d readme.txt
and when<br>
>> > I'm<br>
>> > running the rtpostgis.sql I'm getting this error:<br>
>> ><br>
>> > NOTICE: type "raster" is not yet defined<br>
>> > DETAIL: Creating a shell type definition.<br>
>> > ERROR: could not load library "C:/Program<br>
>> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified
module could not<br>
>> > be<br>
>> > found.<br>
>> ><br>
>> ><br>
>> > ********** Error **********<br>
>> ><br>
>> > ERROR: could not load library "C:/Program<br>
>> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified
module could not<br>
>> > be<br>
>> > found.<br>
>> > SQL state: 58P01<br>
>> ><br>
>> ><br>
>> > But I do have that file !!!!<br>
>> ><br>
>> > C:\Documents and Settings\sebastian ovide>dir "C:\Program<br>
>> > Files\PostgreSQL\8.4\lib\rtpostgis.dll"<br>
>> > Volume in drive C has no label.<br>
>> > Volume Serial Number is 2079-A57D<br>
>> ><br>
>> > Directory of C:\Program Files\PostgreSQL\8.4\lib<br>
>> ><br>
>> > 21/06/2010
13:52 210,432
rtpostgis.dll<br>
>> >
1 File(s) 210,432 bytes<br>
>> >
0 Dir(s) 450,924,576,768 bytes free<br>
>> ><br>
>> ><br>
>> > now, If I use the backslash... ( as for the error)<br>
>> ><br>
>> ><br>
>> > C:\Documents and Settings\sebastian ovide>dir "C:/Program<br>
>> > Files/PostgreSQL/8.4/lib/rtpostgis.dll"<br>
>> > Volume in drive C has no label.<br>
>> > Volume Serial Number is 2079-A57D<br>
>> ><br>
>> > Directory of C:\Program Files\PostgreSQL\8.4\lib<br>
>> ><br>
>> > File Not Found<br>
>> ><br>
>> ><br>
>> ><br>
>> > ideas ?<br>
>> ><br>
>> > thanks<br>
>> ><br>
>> > --<br>
>> > Sebastian E. Ovide<br>
>> ><br>
>><br>
>> Hi,<br>
>><br>
>> Try copying rtpostgis.dll in C:\Program Files\PostgreSQL\8.4\bin
directory<br>
>><br>
>> Best regards,<br>
>><br>
>> --<br>
>> Jorge Arévalo<br>
>> DEIMOS Space<br>
>> Internet & Mobilty Division<br>
>> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º<br>
>> 28760 Tres Cantos (Madrid)<br>
>> Tel: +34 91 806 34 50 - ext: 155<br>
>> <a href="mailto:jorge.arevalo@deimos-space.com" target="_blank">jorge.arevalo@deimos-space.com</a><br>
>> <a href="http://gis4free.wordpress.com" target="_blank">http://gis4free.wordpress.com</a><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
><br>
> --<br>
> Sebastian E. Ovide<br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
<br>
<br>
<br>
--<br>
Jorge Arévalo<br>
DEIMOS Space<br>
Internet & Mobilty Division<br>
Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º<br>
28760 Tres Cantos (Madrid)<br>
Tel: +34 91 806 34 50 - ext: 155<br>
<a href="mailto:jorge.arevalo@deimos-space.com" target="_blank">jorge.arevalo@deimos-space.com</a><br>
<a href="http://gis4free.wordpress.com" target="_blank">http://gis4free.wordpress.com</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><br>
<br clear=all>
<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='color:#888888'>-- <br>
Sebastian E. Ovide<br>
<br>
skype: sebastian.ovide<br>
<br>
+353 (0) 87 6340149<br>
<br>
<br>
</span><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><br>
<br clear=all>
<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'>-- <br>
<span style='color:#888888'>Sebastian E. Ovide<br>
<br>
<br>
<br>
</span><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br clear=all>
<br>
-- <br>
Sebastian E. Ovide<br>
<br>
<br>
<o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br clear=all>
<br>
-- <br>
George R. C. Silva<br>
<br>
Desenvolvimento em GIS<br>
<a href="http://blog.geoprocessamento.net">http://blog.geoprocessamento.net</a><o:p></o:p></p>
</div>
</div>
</body>
</html>