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><br><div class="gmail_quote">On Mon, Jul 19, 2010 at 12:37 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</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>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Sebastian,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Oops sorry about that. Will correct the
readme.txt.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Leo</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
<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<br></font><br></div><div><div></div><div class="h5">
<div></div>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....<br><br>
<div class="gmail_quote">On Mon, Jul 19, 2010 at 12:13 PM, Sebastian E. Ovide
<span dir="ltr"><<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">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 !
<div>
<div></div>
<div><br><br>
<div class="gmail_quote">On Mon, Jul 19, 2010 at 12:03 PM, Fred Lehodey <span dir="ltr"><<a href="mailto:lehodey@gmail.com" target="_blank">lehodey@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">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><font color="#888888"><br>Fred.</font>
<div>
<div></div>
<div><br><br><br><br><br>
<div class="gmail_quote">On Mon, Jul 19, 2010 at 11:56 AM, Sebastian E. Ovide
<span dir="ltr"><<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">same: <br>
<div><br>ERROR: could not load library "C:/Program
Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be
found.<br><br></div>
<div>
<div></div>
<div>
<div class="gmail_quote">2010/7/19 Jorge Arévalo <span dir="ltr"><<a href="mailto:jorge.arevalo@deimos-space.com" target="_blank">jorge.arevalo@deimos-space.com</a>></span><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E.
Ovide<br>
<div><<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>> wrote:<br></div>
<div>> 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>><br><br></div>Try
adding C:/Program Files/PostgreSQL/8.4/lib/ to the PATH enviroment
variable.<br>
<div>
<div></div>
<div><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><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><font color="#888888">-- <br>Sebastian E.
Ovide<br><br>skype: sebastian.ovide<br><br>+353 (0) 87
6340149<br><br><br></font><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></blockquote></div><br></div></div></blockquote></div><br><br clear="all"><br></div></div>-- <br><font color="#888888">Sebastian E.
Ovide<br><br><br><br><br></font></blockquote></div><br><br clear="all"><br>--
<br>Sebastian E. Ovide<br><br><br><br></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>