Yeap Pierre, this is 8.3.<br><br>I'll do that and i'll get back to you. Thanks for the quick answer.<br><br>George<br><br><div class="gmail_quote">On Mon, Jul 19, 2010 at 1:27 PM, Pierre Racine <span dir="ltr"><<a href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">You’re using PostgreSQL 8.3 right?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Replace </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">“</span>SELECT ST_Intersection((gv).geom, $1) intgeom<span style="font-size: 11pt; color: rgb(31, 73, 125);">” </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">with</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">“</span>SELECT ST_Intersection((gv).geom, $1) AS intgeom<span style="font-size: 11pt; color: rgb(31, 73, 125);">”…</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I’ll fix the source.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Pierre</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; padding: 0cm 0cm 0cm 4pt;">
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<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>George
Silva<br>
<b>Sent:</b> 19 juillet 2010 12:11<div><div></div><div class="h5"><br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] problem installing WKTRaster</div></div></span></p>
</div>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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" target="_blank">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>
</p>
<div>
<p class="MsoNormal">On Mon, Jul 19, 2010 at 12:37 PM, Paragon Corporation <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:</p>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; color: blue;">Sebastian,</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size: 10pt; color: blue;">Oops sorry about that. Will correct the readme.txt.</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size: 10pt; color: blue;">Leo</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: blue;"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></span></p>
<p class="MsoNormal"> </p>
<div class="MsoNormal" style="text-align: center;" align="center">
<hr width="100%" align="center" size="2">
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <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></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">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....</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:</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 ! </p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"> </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:</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: rgb(136, 136, 136);"><br>
Fred.</span> </p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br>
<br>
<br>
</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:</p>
<p class="MsoNormal">same: </p>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be
found.</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>></p>
<p class="MsoNormal">On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide</p>
<div>
<p class="MsoNormal"><<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>> wrote:</p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">> 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>
></p>
</div>
<p class="MsoNormal">Try adding C:/Program Files/PostgreSQL/8.4/lib/ to the PATH
enviroment variable.</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></p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br clear="all">
</p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><span style="color: rgb(136, 136, 136);">-- <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></p>
</div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br clear="all">
</p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;">-- <br>
<span style="color: rgb(136, 136, 136);">Sebastian E. Ovide<br>
<br>
<br>
<br>
</span></p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br clear="all">
<br>
-- <br>
Sebastian E. Ovide<br>
<br>
<br>
</p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><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></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" target="_blank">http://blog.geoprocessamento.net</a></p>
</div></div></div>
</div>
</div>
<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><br>
<br></blockquote></div><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><br>