Yeap Pierre, this is 8.3. I'll do that and i'll get back to you. Thanks for the quick answer.
George On Mon, Jul 19, 2010 at 1:27 PM, Pierre Racine <pierre.rac...@sbf.ulaval.ca>wrote: > 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:* postgis-users-boun...@postgis.refractions.net [mailto: > postgis-users-boun...@postgis.refractions.net] *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 <l...@pcorp.us> > wrote: > > Sebastian, > > > > Oops sorry about that. Will correct the readme.txt. > > > > Leo > > http://www.postgis.us > > > ------------------------------ > > *From:* postgis-users-boun...@postgis.refractions.net [mailto: > postgis-users-boun...@postgis.refractions.net] *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 < > sebastian.ov...@gmail.com> 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 <leho...@gmail.com> 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 < > sebastian.ov...@gmail.com> 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 <jorge.arev...@deimos-space.com> > > On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide > > <sebastian.ov...@gmail.com> 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 <jorge.arev...@deimos-space.com> > >> > >> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide > >> <sebastian.ov...@gmail.com> 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 > >> jorge.arev...@deimos-space.com > >> http://gis4free.wordpress.com > >> _______________________________________________ > >> postgis-users mailing list > >> postgis-users@postgis.refractions.net > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > > -- > > Sebastian E. Ovide > > > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > 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 > jorge.arev...@deimos-space.com > http://gis4free.wordpress.com > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Sebastian E. Ovide > > skype: sebastian.ovide > > +353 (0) 87 6340149 > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > -- > Sebastian E. Ovide > > > > > > > -- > Sebastian E. Ovide > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > -- > George R. C. Silva > > Desenvolvimento em GIS > http://blog.geoprocessamento.net > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- George R. C. Silva Desenvolvimento em GIS http://blog.geoprocessamento.net
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users