You're using PostgreSQL 8.3 right? Replace
"SELECT ST_Intersection((gv).geom, $1) intgeom" with "SELECT ST_Intersection((gv).geom, $1) AS intgeom"... I'll fix the source. Pierre From: [email protected] [mailto:[email protected]] On Behalf Of George Silva Sent: 19 juillet 2010 12:11 To: PostGIS Users Discussion Subject: Re: [postgis-users] problem installing WKTRaster While we are at it, I've tried installing and there it complains about an error here: My download link was: http://www.postgis.org/download/windows/pg83/experimental/wktraster/wktraster_pg83.zip 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... Any ideas? Thanks guys. CREATE OR REPLACE FUNCTION st_intersection(geom geometry, rast raster, band integer) RETURNS SETOF geomval AS $$ -- Return the intersections of the geometry with the vectorized parts of -- the raster and the values associated with those parts, if really their -- intersection is not empty. SELECT intgeom, val FROM ( SELECT ST_Intersection((gv).geom, $1) intgeom, (gv).val FROM ST_DumpAsPolygons($2, $3) gv WHERE ST_Intersects((gv).geom, $1) AND ST_Intersects($1, $2, $3)) foo WHERE NOT st_isempty(intgeom) -- eliminate empty intersections UNION ALL -- If the geometry does not intersect with the raster, return an empty -- geometry and a null value SELECT emptygeom, NULL FROM ST_GeomCollFromText('GEOMETRYCOLLECTION EMPTY', st_srid($1)) emptygeom WHERE NOT ST_Intersects($1, $2, $3); $$ LANGUAGE SQL IMMUTABLE; NOTICE: type "raster" is not yet defined DETAIL: Creating a shell type definition.NOTICE: argument type raster is only a shell ERROR: syntax error at or near "intgeom" LINE 1219: SELECT ST_Intersection((gv).geom, $1) intgeom, (... ^ ********** Error ********** ERROR: syntax error at or near "intgeom" SQL state: 42601 Character: 44614 On Mon, Jul 19, 2010 at 12:37 PM, Paragon Corporation <[email protected]<mailto:[email protected]>> wrote: Sebastian, Oops sorry about that. Will correct the readme.txt. Leo http://www.postgis.us ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Sebastian E. Ovide Sent: Monday, July 19, 2010 9:08 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] problem installing WKTRaster Re reading the readme.txt 1) Install PostGIS into your database if you haven't already 2) Copy the rtpostgis.dll to the lib folder of your PostgreSQL install 3) a) then Run the share\contrib\postgis\rtpostgis.sql in your postgis enabled db b) You can install help now too by running share\contrib\postgis\wktraster_comments.sql 4) Copy the contents of bin to your PostgreSQL bin folder (gdal2wktraster.py, libgdal.dll) to bin folder of your PostgreSQL install. the point 4 should come before the point 3.... On Mon, Jul 19, 2010 at 12:13 PM, Sebastian E. Ovide <[email protected]<mailto:[email protected]>> wrote: Hi Fred, 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 ! thanks ! On Mon, Jul 19, 2010 at 12:03 PM, Fred Lehodey <[email protected]<mailto:[email protected]>> wrote: Hi Sebastian, you can try that free utility : http://www.dependencywalker.com/ Sometimes helpful to discover a missing file. Fred. On Mon, Jul 19, 2010 at 11:56 AM, Sebastian E. Ovide <[email protected]<mailto:[email protected]>> wrote: same: ERROR: could not load library "C:/Program Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be found. 2010/7/19 Jorge Arévalo <[email protected]<mailto:[email protected]>> On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide <[email protected]<mailto:[email protected]>> wrote: > done, same problem > > ERROR: could not load library "C:/Program > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be > found. > Try adding C:/Program Files/PostgreSQL/8.4/lib/ to the PATH enviroment variable. > 2010/7/19 Jorge Arévalo > <[email protected]<mailto:[email protected]>> >> >> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide >> <[email protected]<mailto:[email protected]>> wrote: >> > Hi All, >> > >> > on WinXP, with PostgreSLQ 8.4, PostGis 1.5 and WKTRaster 0.1.6d. >> > >> > Just followed the instructions from WKTRaster 0.1.6d readme.txt and when >> > I'm >> > running the rtpostgis.sql I'm getting this error: >> > >> > NOTICE: type "raster" is not yet defined >> > DETAIL: Creating a shell type definition. >> > ERROR: could not load library "C:/Program >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not >> > be >> > found. >> > >> > >> > ********** Error ********** >> > >> > ERROR: could not load library "C:/Program >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not >> > be >> > found. >> > SQL state: 58P01 >> > >> > >> > But I do have that file !!!! >> > >> > C:\Documents and Settings\sebastian ovide>dir "C:\Program >> > Files\PostgreSQL\8.4\lib\rtpostgis.dll" >> > Volume in drive C has no label. >> > Volume Serial Number is 2079-A57D >> > >> > Directory of C:\Program Files\PostgreSQL\8.4\lib >> > >> > 21/06/2010 13:52 210,432 rtpostgis.dll >> > 1 File(s) 210,432 bytes >> > 0 Dir(s) 450,924,576,768 bytes free >> > >> > >> > now, If I use the backslash... ( as for the error) >> > >> > >> > C:\Documents and Settings\sebastian ovide>dir "C:/Program >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll" >> > Volume in drive C has no label. >> > Volume Serial Number is 2079-A57D >> > >> > Directory of C:\Program Files\PostgreSQL\8.4\lib >> > >> > File Not Found >> > >> > >> > >> > ideas ? >> > >> > thanks >> > >> > -- >> > Sebastian E. Ovide >> > >> >> Hi, >> >> Try copying rtpostgis.dll in C:\Program Files\PostgreSQL\8.4\bin directory >> >> Best regards, >> >> -- >> Jorge Arévalo >> DEIMOS Space >> Internet & Mobilty Division >> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º >> 28760 Tres Cantos (Madrid) >> Tel: +34 91 806 34 50 - ext: 155 >> [email protected]<mailto:[email protected]> >> http://gis4free.wordpress.com >> _______________________________________________ >> postgis-users mailing list >> [email protected]<mailto:[email protected]> >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Sebastian E. Ovide > > > > > _______________________________________________ > postgis-users mailing list > [email protected]<mailto:[email protected]> > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- Jorge Arévalo DEIMOS Space Internet & Mobilty Division Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º 28760 Tres Cantos (Madrid) Tel: +34 91 806 34 50 - ext: 155 [email protected]<mailto:[email protected]> http://gis4free.wordpress.com _______________________________________________ postgis-users mailing list [email protected]<mailto:[email protected]> http://postgis.refractions.net/mailman/listinfo/postgis-users -- Sebastian E. Ovide skype: sebastian.ovide +353 (0) 87 6340149 _______________________________________________ postgis-users mailing list [email protected]<mailto:[email protected]> http://postgis.refractions.net/mailman/listinfo/postgis-users -- Sebastian E. Ovide -- Sebastian E. Ovide _______________________________________________ postgis-users mailing list [email protected]<mailto:[email protected]> http://postgis.refractions.net/mailman/listinfo/postgis-users -- George R. C. Silva Desenvolvimento em GIS http://blog.geoprocessamento.net
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
